musiccaps_details (view)
1 row where musiccaps_aspects contains "filtered background male vocal", musiccaps_aspects contains "uptempo hi hats" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;