musiccaps_details (view)
3 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "punchy snare", musiccaps_names contains "Hip hop music" and musiccaps_names contains "Rapping"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Skibadee + Bashy MC FACEOFF 1XTRA | The low quality recording features a hip hop song where a fruity male vocal is rapping over punchy kick and snare hits, shimmering hi hats, groovy bass and brass melody. It sounds bouncy, groovy and upbeat. | 2007-04-17T08:17:05Z | danshish | Skibadee + Bashy MC FACEOFF on 1XTRA then some other mc's | ["Drum and bass", "Electronic music", "Music", "Rapping", "Hip hop music"] | ["low quality", "hip hop", "fruity male vocal", "brass melody", "punchy kick", "punchy snare", "shimmering hi hats", "groovy bass", "groovy", "bouncy", "upbeat"] | 4 | YZvv4hOlNqw | 3294 | |
Wale - Focused clean version | The low quality recording features a R&B song that consists of flat male vocals, alongside filtered background male vocals, singing over punchy kick and snare hits, shimmering cymbals, uptempo hi hats, distorted bass and repetitive synth lead melody. It sounds messy, as the frequencies are clashing with each other, but also energetic, emotional and addictive - like something you would quickly learn to sing along. | 2011-11-26T16:53:06Z | DjDrewskie | I was Really Feeiling His Albm But There Was No Clean Version Anywhere So You KNow I Had To Do It! if want anymore songs done comment nd ill get to it I DO NOT OWN ANY RIGHTS TO THIS SONG RML | ["Music", "Rapping", "Zing", "Hip hop music"] | ["low quality", "r&b", "uptempo hi hats", "distorted bass", "repetitive synth lead melody", "filtered background male vocal", "punchy snare", "shimmering cymbals", "punchy kick", "flat male vocal", "energetic", "emotional", "addictive", "messy"] | 4 | nSLxQLYYoNE | 4538 | |
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;