musiccaps_details (view)
4 rows where musiccaps_aspects contains "passionate female vocal", musiccaps_aspects contains "pop" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- passionate female vocal · 4 ✖
- pop · 4 ✖
- live performance 3
- low quality 3
- passionate 3
- emotional 2
- energetic 2
- groovy bass 2
- punchy kick 2
- punchy snare 2
- addictive 1
- addictive synth lead melody 1
- background harmonizing vocals 1
- clapping 1
- crowd cheering 1
- crowd singing 1
- energetic drums 1
- fade out 1
- flat male vocal 1
- fun 1
- groovy 1
- groovy thin bass 1
- happy 1
- harmonizing female background vocals 1
- intimate 1
- mellow bells melody 1
- mellow synth pad 1
- mono 1
- noisy 1
- shimmering cymbals 1
- …
musiccaps_names (array) 5 ✖
- Singing · 4 ✖
- Music of Asia 2
- Funk 1
- Independent music 1
- Music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nasty Girl by Destiny's Child | The Pop song features a passionate female vocal singing over groovy bass, wide electric guitar melodies and shimmering shakers, as the overall audio is slowly fading out. It sounds addictive, passionate and intimate. | 2007-04-15T07:50:17Z | Bubblez1636 | Destiny's Child's song, Nasty Girl, with a compilation of video footage they made AFTERWARDS. Funny | ["Singing", "Funk"] | ["pop", "passionate female vocal", "groovy bass", "wide electric guitar melodies", "shimmering shakers", "fade out", "addictive", "passionate", "intimate"] | 4 | C-7ubPOCeJk | 1314 | |
Fifth Harmony "Hero" - Live Week 3 - The X Factor USA 2012 | The low quality recording features a live performance of a pop song that consists of a passionate female vocal, alongside harmonizing background female vocals singing over synth pad chords, punchy kick and snare hits, shimmering cymbals, claps, mellow bells melody and smooth bass. It sounds emotional and passionate. | 2012-11-15T07:55:28Z | Eduardo Villavicencio | 14/11/12 - Top 12 Fifth Harmony sings "Hero" PRE-ORDER FIFTH HARMONY'S NEW SINGLE "BO$$" ON ITUNES NOW http://smarturl.it/5HBOSS | ["Singing", "Music of Asia"] | ["low quality", "passionate female vocal", "harmonizing female background vocals", "shimmering cymbals", "mellow bells melody", "smooth bass", "punchy snare", "punchy kick", "synth pad chords", "emotional", "passionate", "live performance", "pop", "clapping"] | 4 | TiDdR-6bIcY | 2860 | |
Melissa Manchester - You Should Hear How She Talks About You | The low quality recording features a live performance of a pop song that consists of passionate female vocals, alongside background harmonizing vocals, singing over energetic drums, groovy, thin bass, mellow synth pad and addictive synth lead melody. Even though the recording is noisy and in mono, it sounds energetic, happy and fun. | 2007-05-21T17:06:41Z | Guido Antonio Di Carlo | Melissa Manchester - You Should Hear How She Talks About You live at Solid Gold 1982 | ["Singing", "Independent music"] | ["low quality", "mono", "noisy", "pop", "live performance", "energetic drums", "groovy thin bass", "mellow synth pad", "addictive synth lead melody", "passionate female vocal", "background harmonizing vocals", "energetic", "happy", "fun"] | 4 | W_MZo88gzrA | 3107 | |
PUFF DADDY & FAITH feat. 112 - ILL BE MISSING YOU | The low quality recording features a live performance of a pop song that consists of flat male vocal talking, passionate female vocal, alongside harmonizing wide female vocals, singing over punchy kick and snare hits, shimmering hi hats and groovy bass. There are crowd singing and cheering sounds in the background. It sounds groovy, emotional, energetic and passionate. | 2009-06-24T16:34:33Z | PaulP | I'll Be Missing You by Puff Daddy (Dedicated to Notorious B.I.G.) (Puff) Seems like yesterday we used to rock the show I lace the track you lock the flow So far from hanging on the block of dough Notorious they got to know that Life ain't always as it seem to be Words can't express what you mean to me And though you're gone We still a team Through your family I'll fulfill your dreams In the future can't wait to see If you'll open up the gates for me Remenice sometime The night they took my friend Try to black it out but it plays again When it's weird feelin' it's really hard to conceil Can't imagine all the pain I feel Give everything to hear half your breath I know you still livin' your life after death CHORUS: (Faith) Every step I take Every move I make Every single day Every time I pray I'll be missing you Thinking of the day When you went away What a life to take What a bond to break I'll be missing you (Puff) It's kind of hard wit you not around Know you in heaven smilin' down Watchin' us while we pray for you Everyday we pray for you Till the day we meet again In my heart is where I'll keep you friend Memories give me the strength I need to proceed Strength I need to believe My thoughts big I just can't define Wish I could turn back the hands of time Bust in the 6 Shop for new clothes and kicks You and me taking flicks Making hits stages they receive you on Still can't believe you're gone Give anything to hear half your breath I know you still livin' your life after death CHORUS: (Faith) Every step I take Every move I make Every single day Every time I pray I'll be missing you Thinking of the day When you went away What a life to take What a bond to break I'll be missing you some glad morning When this life is over I know I'll see your face CHORUS (112) x4 Every night I pray E… | ["Singing", "Music of Asia", "Music"] | ["pop", "low quality", "live performance", "flat male vocal", "passionate female vocal", "wide harmonizing vocals", "punchy kick", "punchy snare", "shimmering hi hats", "groovy bass", "crowd cheering", "crowd singing", "energetic", "groovy", "emotional", "passionate"] | 4 | XILyHZyyCik | 3174 |
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;