musiccaps_details (view)
1 row where musiccaps_aspects contains "kids performance", musiccaps_aspects contains "modern sound" and musiccaps_aspects contains "scratching"
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 |
---|---|---|---|---|---|---|---|---|---|---|
DJ Kids Scratching! | This is a DJ performance recording of two kids scratching a turntable. The turntable is being scratched over a hip-hop breakbeat that consists of a loud electronic drum beat. The atmosphere is danceable and there is an urban sound. This piece could be played at sports venues. It could also be sampled for use in beat-making. | 2007-09-14T19:58:53Z | valentinesday01 | this little dudes get down on the turntables!! Yeah they're bad asses. For those who continue to say it's fake check out their page: Sarahscratch. Their names are DJ Sara and DJ Ryusei. | ["Scratching (performance technique)", "Music"] | ["dj performance", "live recording", "kids performance", "turntable", "scratching", "hip-hop breakbeat", "electronic drums", "dance", "urban", "upbeat", "modern sound"] | 9 | WiAFUo2nxIk | 3129 |
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;