musiccaps_details (view)
2 rows where musiccaps_aspects contains "hypnotic", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "medium fast tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- hypnotic · 2 ✖
- instrumental · 2 ✖
- medium fast tempo · 2 ✖
- psychedelic 2
- buoyant 1
- chanting 1
- club music 1
- dance music 1
- didgeridoo harmony 1
- digital drums 1
- dj 1
- dj mixer 1
- eerie 1
- electrifying 1
- electronic music 1
- electronica 1
- energetic 1
- grim 1
- haunting 1
- house 1
- intense 1
- male vocalisation 1
- pendulum choir 1
- propulsive beats 1
- pulsating 1
- punchy beats 1
- resonating 1
- resounding 1
- resounding voices 1
- sinister 1
- steady rhythm 1
- synth pop 1
- synthesiser arrangement 1
- techno music 1
- timer clicking 1
- timer ticking 1
- trance 1
- trippy 1
- upbeat 1
- vocalisation 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 2
- Choir 1
- Electronic music 1
- Electronica 1
- House music 1
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 | |
Pendulum Choir | This music is instrumental. The tempo is medium fast with an incessant droning of the didgeridoo, sound of a timer ticking and male vocals like a chant. The music is eerie, creepy, spooky, sinister, scary, hypnotic, trance like and fear inducing with resounding effect. | 2011-10-02T15:46:31Z | codactdecosterd | Concert/performance - Cod.Act 2011 - www.codact.ch | ["Music", "Choir"] | ["instrumental", "vocalisation", "medium fast tempo", "pendulum choir", "resonating", "resounding", "timer ticking", "didgeridoo harmony", "male vocalisation", "resounding voices", "timer clicking", "intense", "grim", "sinister", "chanting", "psychedelic", "hypnotic", "eerie", "haunting", "trance", "trippy"] | 7 | vsXs3GUrw64 | 5215 |
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;