musiccaps_details (view)
2 rows where musiccaps_aspects contains "ambient", musiccaps_aspects contains "intense" and musiccaps_aspects contains "psychedelic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- ambient · 2 ✖
- electronic music 2
- fast tempo 2
- intense · 2 ✖
- psychedelic · 2 ✖
- burgeoning 1
- captivating 1
- club music 1
- critical 1
- dance groove 1
- dance music 1
- dark 1
- dense 1
- digital sounds 1
- edm 1
- electro rock 1
- electronic articulation 1
- fluctuating 1
- fourth world music 1
- goth rock 1
- high-powered 1
- incessant rhythm 1
- instrumental 1
- intense electric guitar feedback 1
- male vocalist 1
- multi layered sounds 1
- nigthclubs 1
- percussive envelopes 1
- punchy 1
- suspenseful 1
- synth rock 1
- synthesiser arrangement 1
- synthesiser articulation 1
- trance 1
- trap music 1
- trippy 1
- vigorous 1
musiccaps_names (array) 4 ✖
- Music 2
- Angry music 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dark Nebula Remix [by DeltaHedron] - Kirby Squeak Squad Music Extended | This music is an Electronic instrumental. The tempo is fast with synthesiser arrangements. It has an incessant, burgeoning rhythm. The music is youthful , captivating, psychedelic, trippy, groovy, trance EDM/Synth Pop. | 2014-10-19T11:26:23Z | SuperRayman001 | Original by DeltaHedron / Alez S: https://www.youtube.com/watch?v=9Hmemrr0Lhg&list=UUK1Xc2_xHaNs8wTIJOwLkew Playlist: https://www.youtube.com/playlist?list=PLC-qn8gNLc3FxgeSDS-h8qUDH0YtEp2nv Picture: http://www.deviantart.com/art/Dark-Nebula-197928143 | ["Music", "Techno", "Trance music"] | ["instrumental", "fast tempo", "electronic music", "dance groove", "burgeoning", "edm", "synthesiser articulation", "psychedelic", "trippy", "trance", "trap music", "incessant rhythm", "captivating", "vigorous", "intense", "dense", "suspenseful", "critical", "dance music", "club music", "ambient"] | 7 | JL9Xxzf9e2A | 1993 | |
Blue Stahli - Shoot Em Up | A male vocalist sings this youthful Electro rock . The tempo is fast with an intense electric guitar feedback, hard hitting drumming, synthesiser arrangements and electronic sound articulation. The song is high-powered, punchy, intense, youthful,ambient, buoyant, passionate and psychedelic with a dance groove. | 2015-10-04T04:33:29Z | Blue Stahli | Meaning: https://www.youtube.com/watch?v=PezlFNTGWv4 And https://www.youtube.com/watch?v=x5U_XD4kDJ4 I feel like the lyrics are pretty clear in what they're attacking, but just in case anyone wonders. The above clips are why the lyrics are what they are. Purchase/Stream 'The Devil': https://bluestahli.ffm.to/thedevil.owe BLUE STAHLI SPOTIFY: http://spoti.fi/1ijKPfA SPOTIFY (Sunset Neon): https://spoti.fi/2RLcprX BANDCAMP: https://bluestahlimusic.bandcamp.com/ INSTAGRAM: http://instagram.com/blue_stahli WEB and MERCH: https://www.bluestahlimusic.com/ TWITTER: http://twitter.com/bluestahli FACEBOOK: http://facebook.com/bluestahlimusic VKONTAKTE: http://vk.com/bluestahliofficial Neat motion graphics courtesy of Beeple! http://beeple-crap.com/ | ["Music", "Angry music"] | ["male vocalist", "fast tempo", "electronic music", "electro rock", "synth rock", "goth rock", "intense electric guitar feedback", "synthesiser arrangement", "electronic articulation", "intense", "digital sounds", "punchy", "dark", "psychedelic", "fourth world music", "ambient", "multi layered sounds", "percussive envelopes", "high-powered", "fluctuating", "nigthclubs"] | 7 | bztxC9EFfCk | 3671 |
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;