musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "passionate female vocal" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- groovy bass · 3 ✖
- passionate 3
- passionate female vocal · 3 ✖
- live performance 2
- low quality 2
- pop 2
- punchy snare 2
- shimmering hi hats 2
- addictive 1
- crowd cheering 1
- crowd singing 1
- emotional 1
- energetic 1
- fade out 1
- flat male vocal 1
- groovy 1
- groovy piano melody 1
- intimate 1
- jazz 1
- mono 1
- noisy 1
- punchy kick 1
- saxophone melody 1
- shimmering shakers 1
- soft kick hits 1
- soulful 1
- wide electric guitar melodies 1
- wide harmonizing vocals 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 | |
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 | |
Shirley King - Let The Good Times Roll | The low quality recording features a live performance of a jazz song and it consists of a passionate female vocalist singing over groovy piano melody, saxophone melody, groovy bass, shimmering hi hats, punchy snare and soft kick hits. It sounds passionate, soulful and the recording is noisy and in mono. | 2008-11-26T05:14:33Z | Bob .Hampton | Daughter of the Blues Shirley King on B.B King's "Let The Good Times Roll". Performed at the VFW in Berwyn, IL at a benefit for Big Time Sarah's church | ["Blues", "Singing", "Jazz", "Music", "Harmonic"] | ["low quality", "live performance", "passionate female vocal", "groovy piano melody", "saxophone melody", "groovy bass", "shimmering hi hats", "punchy snare", "soft kick hits", "jazz", "passionate", "soulful", "noisy", "mono"] | 4 | mFcHGbnNtSQ | 4456 |
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;