musiccaps_details (view)
3 rows where musiccaps_aspects contains "psychedelic", musiccaps_aspects contains "techno music" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 64 ✖
- club music 3
- psychedelic · 3 ✖
- techno music · 3 ✖
- youthful · 3 ✖
- buoyant 2
- dance music 2
- digital drums 2
- dj 2
- dj mixer 2
- edm 2
- electrifying 2
- electronic music 2
- electronica 2
- fast tempo 2
- hypnotic 2
- instrumental 2
- advanced chord structure 1
- ambient mixes 1
- ambient techno 1
- atmospheric 1
- boomy bass 1
- dance pop 1
- dancing 1
- deep house 1
- dj routine 1
- drum machine 1
- edmdance music 1
- electronic effects 1
- energetic 1
- groovy bass lines 1
- high-spirited 1
- house 1
- incessant beats 1
- male singer 1
- medium fast tempo 1
- melodious 1
- pro 1
- propulsive beats 1
- pulsating 1
- pulsating beats 1
- punchy 1
- punchy beats 1
- punchy drum beats 1
- repetitive 1
- reverb 1
- scratching sound 1
- skillful 1
- soulful vocals 1
- steady rhythm 1
- stimulating 1
- synth pop 1
- synthesised sounds 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- tech house 1
- techno trance 1
- throbbing 1
- trance music 1
- trap 1
- turn table 1
- unobstructive 1
- upbeat 1
- vigorous 1
- vinyl record 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
|Deep house| Cutting Shapes | A male vocalist sings this catchy song. The tempo is fast with synthesiser arrangement, punchy digital drum beats, groovy bass line and melodic vocal backup. The music has a repetitive, catchy vocal riff. It is youthful, punchy, bouncy, thumping, pulsating, and throbbing with soulful vocals and a dance groove. This music is Deep House/Techno pop. | 2014-02-20T00:28:06Z | Simon Boles | ["Disco", "Music"] | ["male singer", "fast tempo", "punchy drum beats", "digital drums", "synthesiser arrangements", "electronic effects", "reverb", "techno music", "edm", "electronica", "dance pop", "club music", "deep house", "pulsating beats", "electrifying", "youthful", "punchy", "throbbing", "buoyant", "psychedelic", "repetitive", "incessant beats", "melodious", "groovy bass lines", "ambient mixes", "atmospheric", "advanced chord structure", "soulful vocals", "unobstructive", "stimulating", "dancing"] | 7 | poxsF3-HeP0 | 4736 | ||
DJ Craze - DJ Routine [inthemix] | This music is an Electronic instrumental. The tempo is fast with vigorous electronic and heavily synthesised music using DL mixer, turn table and drum machines.The Ustica is youthful, futuristic, contemporary, vigorous, groovy, psychedelic, trance, hypnotic ,boomy and pulsating. This music is an Electronica/Tech House. | 2015-08-03T21:31:47Z | zebgagang | https://vk.com/trap_edm | ["Scratching (performance technique)", "Electronic music", "Music"] | ["instrumental", "fast tempo", "drum machine", "turn table", "edm", "synthesised sounds", "dance music", "ambient techno", "hypnotic", "psychedelic", "tech house", "dj mixer", "dj", "edmdance music", "electronic music", "trance music", "trap", "techno music", "scratching sound", "vinyl record", "boomy bass", "skillful", "vigorous", "pro", "dj routine", "club music", "youthful", "high-spirited", "techno trance"] | 7 | ue1sgGEvkwE | 5130 |
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;