musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance music", musiccaps_aspects contains "dance rhythm", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "poor audio quality"
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 |
---|---|---|---|---|---|---|---|---|---|---|
1st Place DJ NIFFTY - 2010 World DMC DJ Championships - South African Final | A male singer sings this rapping vocals with a backup singer. The song is medium tempo with a groovy drum rhythm, disc scratching sounds, strong bass line and string accompaniment. The song is groovy and has a dance rhythm. The song audio quality is poor. | 2010-09-30T14:21:46Z | edptv | Produced by: www.blackbirdproductions.co.za 2010 South African DMC DJ Championships Final. MULTI-CAM of Live Set - DJ NIFFTY - Club Atmospheer - Cape Town - South Africa. RESULTS: 1st - DJ NIFFTY (2010 South African DMC DJ Champion) http://www.youtube.com/watch?v=6YXjJ6ABnZU 2nd - DJ CODAX http://www.youtube.com/watch?v=dibExyXfC3c 3rd - DJ ON Q http://www.youtube.com/watch?v=rCIoFNNOdOE FINALISTS: DJ CALCULUS http://www.youtube.com/watch?v=kvmBoL-tmtA DJ SHAMELESS http://www.youtube.com/watch?v=Uo5YJZ6RFbI DJ MARV D http://www.youtube.com/watch?v=1NqCsKCitfA DJ JUICE http://www.youtube.com/watch?v=J4xzSdnnFLM | ["Scratching (performance technique)", "Electronic music", "Music", "Speech"] | ["techno pop music", "male vocals", "rapping vocals", "dance party", "all night party", "discotheque", "dance floor", "dance rhythm", "energetic", "exciting", "medium tempo", "dj turntable", "ambient noises", "poor audio quality", "dance music", "electronic dance music", "groovy music", "dj face off", "disc scratching noises"] | 1 | 6YXjJ6ABnZU | 766 | |
鈴木能律子フラメンコスタジオ*BELEN ご案内 | A female singer sings this traditional melody. The song is medium tempo with a clicking percussion rhythm, guitar strumming accompaniment and tap dancing tones. The song is energetic and passionate. The song has very poor audio quality. | 2012-05-27T11:47:36Z | STUDIO NORI | ["Music", "Tambourine", "Vocal music"] | ["dance music", "maracas playing percussively", "acoustic song", "live performance", "tap dance rhythm", "women dancing", "traditional dancing", "clicking percussions", "clickers", "poor audio quality", "guitar playing rhythm", "energetic", "passionate", "ambient room noise", "dance rhythm", "fats tempo", "female latin singer", "footstep sounds"] | 1 | jtRse-cDB18 | 4286 |
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;