musiccaps_details (view)
2 rows where musiccaps_aspects contains "dj" and musiccaps_names contains "Reggae"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- dance music 2
- dj · 2 ✖
- groovy bass line 2
- bop tune 1
- brush drumming rhythm 1
- dance rhythm 1
- dance tune 1
- double bass harmony 1
- drum machines 1
- electronic dance music 1
- female backup singer 1
- groovy music 1
- hissing tones 1
- home studio 1
- instrumental music 1
- jazz dance music 1
- jazz music 1
- love performance 1
- male singer 1
- medium tempo 1
- people dancing 1
- piano accompaniment 1
- poor audio quality 1
- poor audio quality hissing tones 1
- rhythm mismatch 1
- steady drum rhythm 1
- synth horn melody 1
- synth modules 1
- synthesisers 1
- techno drumming rhythm 1
- trumpet playing percussively 1
- turntables 1
- vocal harmony 1
musiccaps_names (array) 8 ✖
- Music 2
- Reggae · 2 ✖
- Drum and bass 1
- Dubstep 1
- Funk 1
- Rock and roll 1
- Ska 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Moskvin - ragga dub & enei - deep dnb "use your fingers" live looping mix (Drum pads 24 & korg kp3) | The song is an instrumental. The song is medium with a strong bass line, steady techno drumming rhythm, various percussion hits and a synth horn melody. The song has mismatched tempos and is amateurish in production. The audio quality is poor. | 2015-04-01T21:14:12Z | Moskvin | Moskvin - ragga dub & enei - deep dnb "use your fingers" live looping mix (Drum pads 24 & korg kp3) Download Drum Pads 24: Windows Phone Store: http://bit.ly/DrumPads24WP Google Play: https://play.google.com/store/apps/details?id=com.paullipnyagov.drumpads24 App Store: https://itunes.apple.com/app/id667945907 ------------------------------------------------------------------------------ Drum Pads 24: https://www.facebook.com/Drumpads | ["Drum and bass", "Music", "Reggae", "Dubstep"] | ["home studio", "dj", "turntables", "synthesisers", "poor audio quality hissing tones", "medium tempo", "synth modules", "drum machines", "rhythm mismatch", "dance music", "electronic dance music", "synth horn melody", "groovy bass line", "techno drumming rhythm", "dance tune", "hissing tones", "instrumental music"] | 1 | 8XBsesSEbbU | 925 | |
Groovy Live Musik : "We no speak americano" by 4 to the bar : jazzy swing and lounge music | A male singer sings this groovy bop tune. The song is medium tempo with a groovy double bass playing, piano accompaniment, trumpet playing percussively and brush drumming rhythm. The song is entertaining and exciting. The song is a jazz dance tune with an electronica twist. | 2011-02-01T14:48:22Z | loungemusicband | http://4tothebar.de : More groovy lounge music, swing sounds and jazzy live music for club, event and party. Lounge Music: Die Live Band 4 to the bar spielt Swing, Samba und Jazz mit Drums, Kontrabass, Piano und Sängerin und Deejay | ["Swing music", "Funk", "Music", "Reggae", "Ska", "Rock and roll"] | ["groovy music", "love performance", "dj", "dance music", "brush drumming rhythm", "groovy bass line", "steady drum rhythm", "piano accompaniment", "trumpet playing percussively", "male singer", "female backup singer", "vocal harmony", "bop tune", "double bass harmony", "jazz music", "jazz dance music", "poor audio quality", "people dancing", "dance rhythm"] | 1 | RtgHU1UMo5o | 2729 |
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;