musiccaps_details (view)
5 rows where musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "story telling" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 78 ✖
- bad audio quality · 5 ✖
- story telling · 5 ✖
- emotional 3
- medium tempo 3
- female singer 2
- inspiring 2
- keyboard accompaniment 2
- nostalgia 2
- piano accompaniment 2
- pop song 2
- retro hits 2
- song cover 2
- steady drumming rhythm 2
- string section harmony 2
- strong bass line 2
- aggressive 1
- autoharp accompaniment 1
- backup singers 1
- boomy bass line 1
- classic county hits 1
- country classics 1
- country music 1
- drug wars 1
- eerie 1
- energetic 1
- enthusiastic 1
- euro pop 1
- everlasting hits 1
- exciting 1
- explicit lyrics 1
- gang fights 1
- ghetto boys 1
- goth rap 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar strumming 1
- gunshots 1
- haunting 1
- hissing and buzzing distortions 1
- hissing tones 1
- keyboard harmony 1
- latin male singers 1
- latin rap singers 1
- life is tough 1
- life’s lessons 1
- machine gun sounds 1
- male backup singer 1
- male rapper 1
- male singer 1
- modern pop covers 1
- motivational 1
- movie soundtrack 1
- odern pop hits 1
- old classics 1
- old memories 1
- passionate 1
- pleasant 1
- pop super hits 1
- rap song 1
- reciting pain 1
- romantic 1
- serious 1
- slamming door percussion 1
- slow tempo 1
- spirited 1
- steady drumming 1
- struggles 1
- suspense 1
- synth string section 1
- the hood 1
- vibrato 1
- violence 1
- vocal echoes 1
- vocal harmony 1
- walking bas s line 1
- walking bass line 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music · 5 ✖
- Rapping 2
- Christian music 1
- Hip hop music 1
- Music of Latin America 1
- Musical instrument 1
- Reggae 1
- Scary music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Aleksander Mežek - Siva pot | A male singer sings this popular country hit with backup singers in vocal harmony. The song is in medium tempo with a walking bass , acoustic guitar strumming rhythmically, autoharp accompaniment and steady drumming rhythm. The song is an emotional and nostalgic country hit. The audio quality is poor. | 2006-12-19T14:33:29Z | jaki386 | Aleksander Mežek - Siva pot | ["Christian music", "Music", "Musical instrument"] | ["male singer", "backup singers", "guitar strumming", "everlasting hits", "euro pop", "medium tempo", "walking bass line", "autoharp accompaniment", "walking bas s line", "steady drumming", "story telling", "nostalgia", "pleasant", "exciting", "enthusiastic", "old memories", "classic county hits", "pop super hits", "retro hits", "groovy rhythm", "country classics", "bad audio quality", "song cover", "country music"] | 1 | 3KQy3Cajo4E | 456 | |
A time for us ~ lyrics ***there is a mistake with the name of singer. This is not Loreena*** | A female singer sings this lilting melody. The song is medium tempo with an acoustic guitar accompaniment, strong bass line, steady rhythm and piano accompaniment. The song has a bad audio quality. The song is emotional and nostalgic in nature. | 2010-08-25T18:09:52Z | CathCthrn | (Love Theme from Romeo and Juliet) (Words by Larry Kusik, Eddie Snyder / Music by Nino Rota) Lyrics A time for us, some day there'll be When chains are torn by courage born of a love that's free A time when dreams so long denied can flourish As we unveil the love we now must hide A time for us, at last to see A life worthwhile for you and me And with our love, through tears and thorns We will endure as we pass surely through every storm A time for us, some day there'll be a new world A world of shining hope for you and me A time for us, at last to see A life worthwhile for you and me And with our love, through tears and thorns We will endure as we pass surely through every storm A time for us, some day there'll be a new world A world of shining hope for you and me | ["Music", "Tender music"] | ["female singer", "bad audio quality", "medium tempo", "strong bass line", "guitar accompaniment", "pop song", "vibrato", "piano accompaniment", "string section harmony", "old classics", "retro hits", "story telling", "inspiring", "motivational", "emotional", "romantic", "nostalgia"] | 1 | 5Tq56BN8PCQ | 661 | |
Jak Progresso - Yip Wreck | A male rapper sings this rap medley with a backup singer in vocal harmony. The song is medium tempo with a boomy bass line, synth string section and piano accompaniment. The song is storytelling and haunting in its style. The song is a retro rap song with poor audio quality. | 2010-02-18T12:01:56Z | Ih8thePolice | Track 9 of Pestilence | ["Music", "Rapping"] | ["bad audio quality", "male rapper", "story telling", "emotional", "male backup singer", "piano accompaniment", "medium tempo", "eerie", "haunting", "serious", "steady drumming rhythm", "boomy bass line", "keyboard harmony", "aggressive", "rap song", "goth rap", "synth string section"] | 1 | TrvI6t4pAP0 | 2870 | |
Franco El Gorila Ft Ñengo Flow - La Muerte ★New Reggaeton★ORIGINAL 2010 Full Records★ | Make the singer sing this Latin rap song in vocal harmony. The song is medium tempo with a steady drum drumming rhythm, keyboard accompaniment, string section harmony, percussive bass line and machine gunshot sounds. The song is story telling and violent in nature. The song has bad audio quality. | 2010-10-20T08:13:45Z | Ricky40Flow | UNETE: ► http://facebook.com/DembowUrbano Official Song HQ★Escucha y Descarga aqui Lo nuevo de Franco el Gorila Junto a Ñengo Flow "La Muerte" Downloads http://flowhot.info/nusyqy1cgnpc ( Full Metal Enterprises, Millones Record, WY Records, By Sinfonico) New Reggaeton Octubre 20. Ricky40. (Ak-47) www.flowhot.net (La Pagina Mas Rankea). Franco El Gorila Ft Ñengo Flow - La Muerte Franco El Gorila Ft Ñengo Flow - La Muerte Franco El Gorila Ft Ñengo Flow - La Muerte Franco El Gorila Ft Ñengo Flow - La Muerte Franco El Gorila Ft Ñengo Flow - La Muerte Franco El Gorila Ft Ñengo Flow - La Muerte | ["Music", "Rapping", "Reggae", "Music of Latin America", "Hip hop music"] | ["latin male singers", "latin rap singers", "gunshots", "bad audio quality", "machine gun sounds", "vocal harmony", "explicit lyrics", "string section harmony", "keyboard accompaniment", "groovy bass line", "steady drumming rhythm", "violence", "struggles", "story telling", "gang fights", "drug wars", "life is tough", "energetic", "youthful", "the hood", "ghetto boys", "reciting pain"] | 1 | bSX5-VPL8rE | 3625 | |
LORDE | Everybody Wants to Rule the World (Lyrics) | A female singer sings this iconic pop cover. The song is slow tempo with a piano accompaniment, strong drum hit and low pitched keyboard harmony. The song is tense and mysterious. The song is a modern pop cover and has poor audio quality with hissing and buzzing tones. | 2013-11-14T05:03:56Z | hrbrocks10 | Song: Everybody Wants to Rule the World : Lorde - Tears For Fears Cover No copyright infringement intended! | ["Music", "Scary music"] | ["bad audio quality", "hissing tones", "female singer", "hissing and buzzing distortions", "emotional", "spirited", "passionate", "inspiring", "life’s lessons", "vocal echoes", "slamming door percussion", "pop song", "song cover", "suspense", "slow tempo", "odern pop hits", "movie soundtrack", "strong bass line", "story telling", "modern pop covers", "keyboard accompaniment"] | 1 | cY3g6N5Sokk | 3716 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;