musiccaps_details (view)
4 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "groovy", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "shimmering hi hats"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Breakin Part 1, Final Dance Battle | The low quality recording features a hip hop song that consists of a flat male vocal rapping over punchy kick and snare hits, shimmering hi hats, DJ scratching sound effects and groovy bass. It sounds energetic, upbeat and groovy. | 2009-12-10T11:29:51Z | babeygurl05 | Final dance battle at the club, Ozone, Turbo and Kelly win! | ["Scratching (performance technique)"] | ["low quality", "hip hop", "punchy snare", "dj scratching sounds", "punchy kick", "groovy bass", "flat male vocal", "shimmering hi hats", "upbeat", "groovy", "energetic"] | 4 | A5fPSkTvjmY | 1067 | |
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 | |
Destruct - Time's Up [Official Music Video] | The low quality recording features a hip hop song that consists of flat male vocals talking over reverberant female vocal melody, punchy snare and kick hits, shimmering hi hats, groovy bass and mellow piano chord progression. It has a lot of reverb on it and it sounds easygoing, chill and groovy - like something you would listen to on a car ride. | 2012-06-29T08:09:36Z | destructmc | Download the album "Leaving yet?" for free @ http://www.destructmusic.com/album/leaving-yet Add Me @ http://www.facebook.com/mcdestruct Follow Me @ https://twitter.com/mcdestruct Guest starring Marz Prod. by Michael Omar Perez Directed by Jacqueline Arevalo DP by Ace Fillmore Edited by Komprza Subscribe now to http://www.youtube.com/destructmc Cop That fresh gear @ http://www.facebook.com/Faktnclothing | ["Music", "Hip hop music", "Tender music"] | ["low quality", "hip hop", "flat male vocal", "reverberant female vocal melody", "punchy snare", "punchy kick", "shimmering hi hats", "groovy bass", "mellow piano chord progression", "easygoing", "chill", "groovy", "reverberant"] | 4 | nrcfdP6LrLo | 4583 | |
Fabolous, Jay Z, & Young Jeezy F A B O L O U S Vol 2 Block On Smash | The low quality recording features a hip hop song that consists of a flat male vocal, alongside some background male vocals, rapping over punchy kick and snare hits, shimmering hi hats, funky electric guitar, brass melody, groovy synth keys melody and groovy bass. It sounds energetic, groovy and exciting. | 2009-08-07T17:12:38Z | briellehursl21 | ["Music", "Rapping", "Hip hop music"] | ["hip hop", "punchy snare", "punchy kick", "funky electric guitar", "brass melody", "groovy synth keys melody", "groovy bass", "shimmering hi hats", "flat male vocal", "background male vocals", "energetic", "groovy", "exciting", "low quality"] | 4 | x6U1gX5a_4M | 5304 |
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;