musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy music", musiccaps_aspects contains "techno dance music" and musiccaps_names contains "Scratching (performance technique)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- dj 2
- groovy music · 2 ✖
- techno dance music · 2 ✖
- average audio quality 1
- bad audio quality 1
- dance floor 1
- dance music 1
- disc scratching tones 1
- dj face off 1
- dj maestro 1
- dj turntable 1
- eerie tones 1
- electronic dance music 1
- energetic 1
- enthusiastic 1
- exciting 1
- exorcism sounds 1
- female singer 1
- groovy rhythm 1
- instrumental music 1
- live audience 1
- live performance 1
- medium tempo 1
- no harmonies 1
- no percussions 1
- passionate 1
- people dancing 1
- repeated vocal phrases 1
- retro dj music 1
- retro electronica 1
- scratching disc 1
- spinning discs 1
- steady rhythm 1
- strong bass line 1
- syncopated music 1
musiccaps_names (array) 4 ✖
- Music 2
- Scratching (performance technique) · 2 ✖
- Hip hop music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ Shortee - "Watch Out Now" Beatjuggle Routine 2003 | A DJ plays a cool groove with some female vocals. The song is medium tempo with a steady drumming rhythm, scratch disc percussions, and percussive bass line. The song is exciting and groovy. The audio quality is average. | 2006-08-07T01:33:25Z | DJ Shortee | Turntablist beat juggle routine performed by Shortee in 2003 with the Beatnuts' song "Watch Out Now". Featured on "Shortee's DJ 202" Instructional DVD available on www.how2dj.com. Learn more about shortee at www.djshortee.com! | ["Scratching (performance technique)", "Music", "Speech", "Hip hop music"] | ["dj", "female singer", "repeated vocal phrases", "techno dance music", "average audio quality", "groovy music", "dj turntable", "spinning discs", "scratching disc", "energetic", "groovy rhythm", "strong bass line", "steady rhythm", "medium tempo", "people dancing", "retro electronica", "electronic dance music", "dance floor"] | 1 | J0t4VMnXDNM | 1960 | |
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;