musiccaps_details (view)
2 rows where musiccaps_aspects contains "dj mixer" and musiccaps_aspects contains "synthesiser arrangements"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- buoyant 2
- dj 2
- dj mixer · 2 ✖
- fast tempo 2
- synthesiser arrangements · 2 ✖
- clanging whirring 1
- club music 1
- dance groove 1
- dance music 1
- dance pop 1
- digital drum 1
- digital drumming 1
- electronic music 1
- energetic drums 1
- energetic vocal backup 1
- enthusiastic 1
- groovy 1
- instrumental 1
- keyboard harmony 1
- male vocalist 1
- phonograph record 1
- punchy 1
- synth pop 1
- tambourine beats 1
- tapping sound 1
- turn table 1
- tutn table motor 1
- vinyl record 1
- vivacious 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ HumNoy Maraca YouTube | A male vocalist sings this energetic song. The tempo is fast with synthesiser arrangements, punchy digital drumming, tambourine beats and keyboard harmony. The music is upbeat, punchy, groovy, youthful, buoyant and exciting. This song is Synth Pop. | 2013-12-03T12:25:16Z | ณ๊องจุ้น คนเดิม | ["Music", "Song", "Dance music", "Maraca"] | ["male vocalist", "fast tempo", "energetic drums", "synth pop", "buoyant", "tambourine beats", "digital drum", "synthesiser arrangements", "keyboard harmony", "energetic vocal backup", "dj", "dj mixer", "dance pop", "dance music", "club music", "youthful", "enthusiastic", "vivacious"] | 7 | S7rP6coeLTY | 2742 | ||
Le Skateboard | This is electronic dance music. The tempo is fast with a turntable output, synthesiser arrangement ,digital drum beats and loud sounds of clanging, crashing and tapping superimposed on the music. The music is youthful, punchy, buoyant and enthusiastic with a dance groove. This music is EDM. | 2007-05-11T21:45:10Z | Mad Operator | A 3D animation with a skateboard, a skatepark and all that kind of stuff! | ["Scratching (performance technique)", "Music", "Skateboard"] | ["instrumental", "fast tempo", "turn table", "dj", "dj mixer", "tutn table motor", "vinyl record", "synthesiser arrangements", "digital drumming", "phonograph record", "clanging whirring", "tapping sound", "electronic music", "punchy", "groovy", "buoyant", "dance groove"] | 7 | VZfrDZhI7BU | 3009 |
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;