musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance music", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "keyboard accompaniment"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- dance music · 2 ✖
- instrumental · 2 ✖
- keyboard accompaniment · 2 ✖
- amateur production 1
- ambient room noises 1
- cajun 1
- chatter of people 1
- congas 1
- disc scratching 1
- distorted audio 1
- dj 1
- dj face off 1
- dj practice session 1
- drums 1
- electric guitar harmony 1
- hissing tones 1
- home dj 1
- knob turns 1
- lively 1
- muddled audio 1
- spirited 1
- string section harmony 1
- techno drumming 1
- vinyl 1
- whistle tones 1
- whistling tones 1
- wind instrument harmony 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dj Max / Scratch / Cuenca - Ecuador. | The song is an instrumental. The song is medium tempo, with disc scratching tones, whistling tones, keyboard accompaniment and techno drumming. The sound is poor audio quality, with ambient room noises. | 2014-01-26T12:39:10Z | Dj Max | El arte de pinchar discos, es una actividad totalmente creativa en el caso del turntablism, y con un alto componente creativo en el caso del breakbeat y el remix. Informacion: http://mundo-hiphop.foroactivos.net/t6-origen-del-dj | ["Scratching (performance technique)", "Music"] | ["disc scratching", "keyboard accompaniment", "ambient room noises", "knob turns", "amateur production", "whistle tones", "dj face off", "string section harmony", "dj practice session", "hissing tones", "whistling tones", "instrumental", "techno drumming", "vinyl", "home dj", "dj", "dance music"] | 1 | IbJh1xeBFcI | 1922 | |
demo kisanola | This song is an instrumental. The tempo is medium fast with enthusiastic drumming, congas and canon rhythm,electronic guitar harmony, keyboard accompaniment and a wind instrument playing a melodious harmony. There is the sound of chattering in the background. The audio is of inferior quality and muddled. The song is energetic, spirited and melodic with a catchy dance groove. | 2007-11-17T14:44:37Z | llawal41 | african men dancing like men, not women | ["Music", "Steelpan"] | ["instrumental", "distorted audio", "drums", "dance music", "wind instrument harmony", "congas", "electric guitar harmony", "keyboard accompaniment", "cajun", "lively", "spirited", "dance music", "muddled audio", "chatter of people"] | 7 | rTBQmP6Vt0g | 4878 |
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;