musiccaps_details (view)
2 rows where musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "dj" and musiccaps_author = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
Wowee one - heavy bass clear sound - playing dubstep | A male singer sings this aggressive vocal. The song is medium tempo with a slick drumming rhythm, groovy bass line, sonic tones, keyboard harmony and various percussive hits. The song is a modern electronic dance music with trance influences. The song has bad quality audio issues. | 2011-08-21T14:51:25Z | FRAGGA1992 | wowee one heavy bass clear sound test dubstep | ["Electronic music", "Music", "Field recording", "Dubstep"] | ["bad audio quality", "electronic dance music", "dj", "strong drumming rhythm", "trance music", "medium tempo", "string drumming rhythm", "groovy bass line", "keyboard harmony", "energetic", "youthful", "robotic harmony tones", "male singer", "dance music", "disco club", "edm", "people dancing", "aggressive vocals", "explicit trance keyboard tones"] | 1 | 2ZgEbNi--8Q | 380 | |
1997 World ITF DJ Finals - Scratching Final - DJ Babu vs Tony Vegas | The song is an instrumental. The song is medium with a DJ creating scratchy tones by scratching vinyl on a turntable. The DJ creates an eerie and syncopated rhythm. The audio is bad quality. | 2012-12-14T20:20:54Z | DJ_Fobtronics | Babu as always, great on the cut. Tony Vegas, some nice stuff, but errors cost him. Mis calc'd the encode slightly, chopped the last 4 seconds. Classic Beat Juggling Final here: https://www.youtube.com/watch?v=ZYWhurwQajU | ["Scratching (performance technique)", "Music"] | ["disc scratching tones", "dj", "dance music", "retro dj music", "no harmonies", "exorcism sounds", "no percussions", "eerie tones", "dj maestro", "techno dance music", "instrumental music", "bad audio quality", "groovy music", "live performance", "exciting", "enthusiastic", "passionate", "dj face off", "live audience", "syncopated music"] | 1 | y4vtzCAPv84 | 5378 |
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;