musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy music" and musiccaps_aspects contains "groovy rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- groovy music · 2 ✖
- groovy rhythm · 2 ✖
- medium tempo 2
- average audio quality 1
- chord changes 1
- dance floor 1
- dj 1
- dj turntable 1
- electronic dance music 1
- energetic 1
- exciting 1
- female singer 1
- funk jazz 1
- home music video 1
- instrumental music 1
- jazz music 1
- keyboard accompaniment 1
- keyboard comparison video 1
- live performance 1
- music demonstration 1
- music store 1
- people dancing 1
- poor audio quality 1
- repeated vocal phrases 1
- retro electronica 1
- scratching disc 1
- spinning discs 1
- steady rhythm 1
- strong bass line 1
- techno dance music 1
- tonal differences 1
musiccaps_names (array) 7 ✖
youtube_published (date) 2 ✖
- 2006-08-07 1
- 2014-01-09 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 | |
Kurzweil Artis vs Nord Stage vs Yamaha Motif XF8 vs Korg Kronos | The song is an instrumental. The song is medium tempo with chord changes played on different keyboards to check subtle differences in tonality. The song track is a comparison video playing funk jazz accompaniment. | 2014-01-09T20:53:42Z | Hit Space Hangszer- és Stúdiótechnikai Szaküzlet | Egy kis ízelítő pár népszerű billentyűs hangszerből. Mivel a hangszerek mindegyike rendelkezik valamiféle extrával a másikhoz képest, érdemes őket személyesen kipróbálni. A Hit Space-ben található Magyarország legszélesebb szintetizátor választéka, ahol minden érdeklődőt szeretettel látunk! | ["Electric piano", "Keyboard (musical)", "Piano"] | ["keyboard comparison video", "medium tempo", "jazz music", "groovy rhythm", "music store", "music demonstration", "home music video", "instrumental music", "funk jazz", "chord changes", "poor audio quality", "live performance", "groovy music", "exciting", "tonal differences", "keyboard accompaniment"] | 1 | M1ds6tRFxhs | 2236 |
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;