musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance music", musiccaps_aspects contains "synthesiser arrangements" and musiccaps_names contains "Trance music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 57 ✖
- club music 3
- dance music · 3 ✖
- synthesiser arrangements · 3 ✖
- dj 2
- electro pop 2
- fast tempo 2
- instrumental 2
- vibrant 2
- ambulance siren 1
- animated 1
- boomy bass drops 1
- buoyant 1
- busy music 1
- catchy vocal riff 1
- creepy 1
- dance groove 1
- dance hits 1
- dangerous 1
- distorted music 1
- distorted sound 1
- edm 1
- eerie 1
- electro rock 1
- electronic instrumentation 1
- emphatic vocals 1
- female singer 1
- female vocals 1
- foreign language 1
- frightening 1
- goth rock 1
- groovy bass line 1
- grunting 1
- high strung 1
- incoherent vocals 1
- inferior sound quality 1
- intense 1
- keyboard harmony 1
- menacing voices 1
- party music 1
- police van siren 1
- punchy youthful 1
- roaring 1
- rock 1
- sinister 1
- spirited 1
- spirited drumming 1
- syncopated harmony 1
- thumping beat 1
- trance 1
- trap 1
- trippy music 1
- upbeat electronic riff 1
- vigorous beat 1
- vigorous drumming 1
- vivacious 1
- vocal riff 1
- youthful 1
musiccaps_names (array) 8 ✖
- Music 3
- Trance music · 3 ✖
- Drum and bass 2
- Dubstep 2
- Electronic dance music 2
- House music 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 |
---|---|---|---|---|---|---|---|---|---|---|
I Say Yes (Zero no Tsukaima - Futatsuki no Kishi) | A female vocalist sings this energetic song. The tempo is fast with enthusiastic drumming, funky bass line, keyboard harmony and synthesiser arrangements. The song is youthful, vibrant, vivacious, hyper, spirited, passionate, bright and has a dance groove. This song is an Electro Pop song. | 2008-07-11T15:03:54Z | Aiath86 | Album: Exit Trance Presents Speed Anime Trance Best 4 | ["Music", "Trance music"] | ["female singer", "fast tempo", "foreign language", "dance music", "dance hits", "club music", "dance music", "electronic instrumentation", "synthesiser arrangements", "spirited drumming", "keyboard harmony", "groovy bass line", "busy music", "electro pop", "animated", "spirited", "emphatic vocals", "youthful", "upbeat electronic riff", "vibrant", "vivacious"] | 7 | BkoCi-IZccI | 1287 | |
DJ VENGEANCE - ZOMP STOMP [Jump Up Drum & Bass] | This song is an instrumental. The tempo is fast with vigorous drumming, thumping bass lines and keyboard arrangement with sounds of an ambulance or police van, menacing voices, grunting, incoherent vocal riff and whooshing sound of wind. This song is aggressive, vigorous, energetic trippy, trance like with the syncopated music giving it a eerie, sinister, creepy vibe. This song is a Hard Rock/Goth Rock. | 2008-12-21T08:14:58Z | Vengeance Music UK | DJ Vengeance - Nu Urban Artists 001 Track: Zomp Stomp sample:its a zombie Nu Artists is for, well, exactly that, new artists with plenty of potential on display. And that's precisely why Vengeance is hitting hard with his first release on this brand new imprint. First comes the Electro inspired 'Dancehall Slayer', all synthetic bubbles before the bass drops, and by then it's all over! 'Zomp Stomp' on the flip is full of beans too. This boy will go far! - Nu Urban Music Sales: http://www.nu-urbanmusic.co.uk/drum_and_bass/shop/product_info.php?products_id=11102 | ["Drum and bass", "Music", "Trance music", "Dubstep", "Electronic dance music"] | ["instrumental", "fast tempo", "trance", "trap", "police van siren", "intense", "dj", "dance music", "club music", "incoherent vocals", "trippy music", "vigorous beat", "syncopated harmony", "thumping beat", "vigorous drumming", "synthesiser arrangements", "ambulance siren", "menacing voices", "roaring", "grunting", "vocal riff", "rock", "goth rock", "sinister", "eerie", "creepy", "dangerous", "frightening"] | 7 | ItLWKIhe58c | 1950 | |
endless squad SHUFFLE | A female vocalist sings this high energy pop song. The tempo is fast with vigorous drumming, synthesiser arrangements and boomy bass drops. The song is vibrant, lively, spirited, buoyant, punchy and youthful with a catchy vocal riff. The sound quality of this song is inferior and distorted. This song is an EDM/Synth Pop song. | 2011-08-12T07:05:36Z | omingendless | ["Drum and bass", "House music", "Music", "Techno", "Trance music", "Shuffle", "Dubstep", "Electronic dance music"] | ["instrumental", "vibrant", "high strung", "female vocals", "punchy youthful", "dance groove", "inferior sound quality", "distorted sound", "catchy vocal riff", "electro rock", "electro pop", "edm", "distorted music", "synthesiser arrangements", "dj", "dance music", "party music", "club music", "vibrant", "buoyant", "boomy bass drops"] | 7 | YWf3I4jKusI | 3291 |
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;