musiccaps_details (view)
3 rows where musiccaps_aspects contains "dj mixer", musiccaps_aspects contains "electrifying" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- buoyant 3
- dj 3
- dj mixer · 3 ✖
- electrifying · 3 ✖
- instrumental 3
- pulsating 3
- youthful · 3 ✖
- club music 2
- dance music 2
- edm 2
- electronic music 2
- electronica 2
- energetic 2
- fast tempo 2
- psychedelic 2
- synthesiser articulation 2
- amateur recording 1
- dance floor 1
- digital beats 1
- digital drumming 1
- digital drums 1
- digital music 1
- distorted sounds 1
- drum machine 1
- electro pop 1
- electronic arrangements 1
- fourth world music 1
- freestyle dance 1
- futuristic 1
- groovy 1
- house 1
- hynoptic 1
- hypnotic 1
- inferior audio quality 1
- medium fast tempo 1
- propulsive beats 1
- punchy 1
- punchy beats 1
- punchy drumming 1
- static 1
- steady rhythm 1
- synth pop 1
- synthesised sounds 1
- synthesiser arrangement 1
- techno music 1
- techno pop 1
- trance 1
- trap 1
- trippy 1
- upbeat 1
- vibrations 1
musiccaps_names (array) 9 ✖
- Music 3
- Electronic music 2
- House music 2
- Dance music 1
- Dubstep 1
- Electronic dance music 1
- Electronica 1
- Shuffle 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
TAIWAN Melbourne Shuffle · 曳步舞 · 鬼步舞 【T.N.S 貓少] | This music is an Electronic instrumental. The tempo is fast with punchy, synthesised music and thumping drum beats on the drum machine. The music is youthful, energetic, enthusiastic,loud, buoyant, punchy, pulsating and electrifying. The sound quality is of inferior quality and there is a bit of static. | 2013-03-15T14:55:39Z | 魑魅鳳 | ["House music", "Music", "Shuffle", "Dubstep", "Electronic dance music", "Dance music"] | ["instrumental", "fast tempo", "electronic music", "buoyant", "youthful", "pulsating", "electrifying", "static", "inferior audio quality", "amateur recording", "edm", "punchy drumming", "synthesiser articulation", "dj", "dj mixer", "dance floor", "freestyle dance", "drum machine", "digital drumming", "digital music", "distorted sounds"] | 7 | JqmOqYtQqB8 | 2038 | ||
Techno Bass Remix | This song is an electronic instrumental. The tempo is fast with heavily synthesised sounds, digital drum arrangements and electronic beats. The music is youthful, groovy, pulsating, electrifying, buoyant, thumping, psychedelic, trance like and trippy. This music is Techno Pop/EDM. | 2008-07-19T13:27:37Z | MrBombastik93 | Mein 1. Remix 1.000.000 Views !!! OMG !! THX GUYS !! | ["Electronic music", "Music", "Techno"] | ["instrumental", "fast tempo", "synthesised sounds", "electronic arrangements", "digital beats", "punchy", "buoyant", "youthful", "energetic", "pulsating", "vibrations", "electrifying", "trance", "trap", "trippy", "hynoptic", "psychedelic", "techno pop", "electronica", "electro pop", "edm", "dance music", "club music", "synthesiser articulation", "dj", "fourth world music", "futuristic", "dj mixer", "groovy"] | 7 | PxxyplPsqBY | 2582 | |
Big Fat (Original Mix) - Tonic Feat. Tarantula Man | This music is instrumental. The tempo is medium fast with synthesiser arrangements , digital drums and electronic music . The music is upbeat, pulsating, youthful, buoyant, exciting, punchy , psychedelic and has propulsive beats with a dance groove. This music is EDM/Techno. | 2012-04-02T00:42:17Z | xMusicOfTheWorldx | Dont Forget To Susbscribe!!!!! | ["Electronic music", "House music", "Music", "Electronica"] | ["instrumental", "medium fast tempo", "propulsive beats", "psychedelic", "hypnotic", "steady rhythm", "electronic music", "house", "upbeat", "energetic", "pulsating", "electrifying", "youthful", "buoyant", "techno music", "punchy beats", "synthesiser arrangement", "digital drums", "dj", "dj mixer", "dance music", "club music", "synth pop", "electronica"] | 7 | cFIZraIPAXE | 3690 |
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;