musiccaps_details (view)
3 rows where musiccaps_aspects contains "trance music" and musiccaps_aspects contains "upbeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- trance music · 3 ✖
- upbeat · 3 ✖
- atmospheric synthesiser 2
- dance music 2
- edm 2
- enthusiastic 2
- fast tempo 2
- instrumental 2
- psychedelic 2
- trance 2
- youthful 2
- boomy bass lines 1
- buoyant 1
- club music 1
- contemporary pop 1
- dance groove 1
- digital drum arrangement 1
- digital drumming 1
- disco pop 1
- dj 1
- dj mixer 1
- dj song 1
- drum machine 1
- elctronic beats 1
- elecronic music 1
- electro pop 1
- electronic music 1
- enigmatic 1
- falsetto voice 1
- female vocalisation 1
- hypnotic 1
- intense 1
- programmed percussion 1
- punchy 1
- repetitive melody 1
- synth music 1
- synth pop 1
- techno song 1
- trap 1
- trippy 1
musiccaps_names (array) 7 ✖
- Music 3
- Disco 2
- Drum machine 1
- House music 1
- Ping 1
- Sampler 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mad Mike - Heartbeat Of A Groove | This techno song features a falsetto voice in the beginning. This is accompanied by 2 counts of programmed percussion. A synth plays one chord using synth strings. The voice, percussion and synth pause and only a repetitive synth loop is played. After four bars, the kick drum starts playing on every count. The mood of this song is upbeat. This song can be played in a trance party or a DJ party. | 2009-06-12T11:28:26Z | yellowidhouse | 1992 Happy Records | ["Sampler", "Disco", "Music", "Drum machine"] | ["techno song", "dj song", "falsetto voice", "synth music", "trance music", "dance music", "programmed percussion", "repetitive melody", "upbeat"] | 0 | 9Cfs00bZRCg | 983 | |
Ping and Plong - Deutsch Nummern [Minimal Techno 2014] | This song is an instrumental. The tempo is fast with synthesiser arrangements , boomy bass and digital drumming. The song is youthful, enthusiastic, engaging, upbeat; vivacious, punchy and buoyant. This song is an EDM/Synth pop. | 2014-02-03T14:45:34Z | ping plong | Follow Us on Facebook:https://www.facebook.com/pages/Ping-and-Plong/703436366348507?fref=ts Follow Us on Soundcloud:http://soundcloud.com/ping-and-plong Download Link:http://www.beatport.com/track/deutsch-nummern-original-mix/5107074 | ["House music", "Music", "Ping"] | ["instrumental", "fast tempo", "elecronic music", "trap", "trance", "trance music", "boomy bass lines", "edm", "psychedelic", "atmospheric synthesiser", "drum machine", "digital drum arrangement", "buoyant", "punchy", "upbeat", "youthful", "intense", "enthusiastic"] | 7 | CdFutCUKTXI | 1385 | |
Elisa - Love Vibration | This music is an electronic instrumental. The tempo is fast with atmospheric synthesiser, digital drum arrangements and an insistent, recurring female vocalisation. The music is upbeat, youthful, trance, trippy, hypnotic, psychedelic, incessant, and enthusiastic EDM/Synth Pop. | 2009-01-22T22:47:43Z | outy1978 | HQ version: http://uk.youtube.com/watch?v=u9n4R78UBtA&fmt=18 Label: FFRR Catalog#: FXDJ 200 Country: UK Released: 1992 | ["Disco", "Music", "Soul music"] | ["instrumental", "fast tempo", "female vocalisation", "electronic music", "digital drumming", "atmospheric synthesiser", "edm", "club music", "dance music", "dj", "dj mixer", "elctronic beats", "youthful", "enthusiastic", "trippy", "trance", "hypnotic", "enigmatic", "trance music", "psychedelic", "disco pop", "contemporary pop", "electro pop", "synth pop", "upbeat", "dance groove"] | 7 | u9n4R78UBtA | 5092 |
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;