musiccaps_details (view)
2 rows where musiccaps_aspects contains "shimmering hi hats" and musiccaps_aspects contains "wide harmonizing vocals"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- low quality 2
- shimmering hi hats · 2 ✖
- wide harmonizing vocals · 2 ✖
- christian music 1
- crowd cheering 1
- crowd singing 1
- emotional 1
- energetic 1
- flat male vocal 1
- groovy 1
- groovy bass 1
- live performance 1
- loud 1
- messy 1
- organ keys chords 1
- passionate 1
- passionate female vocal 1
- pop 1
- punchy kick 1
- punchy snare 1
- simple punchy kick 1
musiccaps_names (array) 7 ✖
- Music 2
- Chant 1
- Christian music 1
- Gospel music 1
- Music of Asia 1
- Singing 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Yezu Bwesigye Bwangye Catholic Christian Music | The low quality recording features a Christian Music that contains wide harmonizing vocals singing over shimmering hi hats, simple punchy kick and organ keys playing in the background. It sounds messy, as the vocals are way too loud, relative to the other instruments. | 2015-09-01T18:41:49Z | SHIELD OF FAITH | Yezu Bwesigye bwangye, Yezu magara gangye, Omujuni wangye. Eiguru ntwarayo mbe naiwe. Jesus my trust, my life, my Savior, I dwell with you in Heaven a Runyankole Rukiga song from Kigezi Ankole Uganda | ["Gospel music", "Chant", "Christian music", "Music", "Song"] | ["low quality", "christian music", "wide harmonizing vocals", "shimmering hi hats", "simple punchy kick", "organ keys chords", "messy", "loud"] | 4 | jPROsr_K710 | 4252 |
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;