musiccaps_details (view)
4 rows where musiccaps_aspects contains "edm", musiccaps_aspects contains "vocalisation" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 69 ✖
- edm · 4 ✖
- instrumental 4
- vocalisation · 4 ✖
- dance music 3
- energetic 3
- fast tempo 3
- club music 2
- electronic music 2
- futuristic 2
- progressive 2
- psychedelic 2
- synthesiser articulation 2
- atmospheric 1
- auto tuned voices 1
- background chatter 1
- boisterous 1
- boomy 1
- buoyant 1
- catchy 1
- catchy vocal riff 1
- compelling 1
- dj mixer 1
- drum machine 1
- electric powered 1
- electrifying 1
- electro pop 1
- electro/pop 1
- electronic sounds 1
- electronically arranged music 1
- enthusiastic 1
- exhilarating 1
- explosive 1
- female backup 1
- funky bass lines 1
- groovy 1
- heavy 1
- heavy synthesisation 1
- home recording 1
- home video 1
- infectious drumming 1
- insistent 1
- intense 1
- keyboard accompaniment 1
- keyboard harmony 1
- muffled audio 1
- obscure audio 1
- passionate 1
- perky 1
- phonograph record 1
- pop hits 1
- powerful 1
- punchy 1
- punchy beats 1
- rapid 1
- retro pop 1
- robotic voice 1
- sound manipulation 1
- spirited 1
- synth/pop 1
- synthesiser arrangement 1
- tambourine beats 1
- thumping sounds 1
- upbeat 1
- vibrant electric guitar harmony 1
- vigorous drumming 1
- vinyl disc 1
- volatile 1
- workout music 1
- youthful 1
musiccaps_names (array) 11 ✖
- Music 4
- Drum and bass 2
- House music 2
- Burst, pop 1
- Dance music 1
- Drum machine 1
- Dubstep 1
- Electronic dance music 1
- Grunge 1
- Sampler 1
- Shuffle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ Fresh - Pink Panther | This music is an electronic instrumental. The tempo is medium fast with synthesiser arrangements, DJ mixer, turn table and digital drums. The music is futuristic , emphatic, intense, loud , enthusiastic; heavily synthesised and groovy. It has a psychedelic, trace-like vibe. | 2008-06-27T17:14:58Z | Henry Weallans | DJ Fresh Drum & Bass | ["Sampler", "Drum and bass", "House music", "Music", "Dubstep", "Electronic dance music", "Drum machine", "Grunge", "Dance music"] | ["instrumental", "electronic music", "drum machine", "boomy", "punchy", "buoyant", "sound manipulation", "phonograph record", "vinyl disc", "heavy synthesisation", "female backup", "vocalisation", "futuristic", "progressive", "insistent", "compelling", "dj mixer", "synthesiser articulation", "dance music", "edm", "club music", "energetic", "intense", "heavy", "punchy", "groovy", "atmospheric", "youthful", "spirited", "psychedelic"] | 7 | A8b-0yWXBCE | 1073 | |
Madeon - Pop Culture | This song is a Retro electronic instrumental. The tempo is fast with electronically arranged music, slick drumming, bright amplified keyboard harmony, tambourine beats,synthesiser arrangements and male and female vocalisation. The song is youthful, groovy,vibrant, upbeat, passionate, catchy and punchy. This song is a Retro EDM. | 2013-12-02T21:31:12Z | Chris Taylor | Music Video | ["Music", "Burst, pop"] | ["instrumental", "electro pop", "fast tempo", "pop hits", "retro pop", "edm", "dance music", "club music", "workout music", "vocalisation", "perky", "energetic", "catchy", "upbeat", "synthesiser arrangement", "tambourine beats", "infectious drumming", "auto tuned voices", "keyboard harmony"] | 7 | B496Qv0CuOQ | 1203 | |
jamie and millie couple shuffle | This is Electronic Dance music. The tempo is fast with synthesiser arrangements, punchy Digital drum rhythm, electronic sounds and a recurring, catchy vocal riff with the sound of talking in the background.The music is obscure as it is an amateur recording . It is buoyant, youthful, energetic, enthusiastic, and pulsating with a dance groove. | 2009-05-03T12:50:31Z | Carnesy | ["Music", "Shuffle"] | ["instrumental", "fast tempo", "electronic music", "obscure audio", "thumping sounds", "vocalisation", "punchy beats", "robotic voice", "background chatter", "electronically arranged music", "home video", "home recording", "muffled audio", "psychedelic", "dance music", "edm", "catchy vocal riff"] | 7 | K2h6UiZSoZ4 | 2054 | ||
2012 Chrysler 300C CRD engine sound and 0-100km/h | This music is an Electronic instrumental. The tempo is fast with an electrifying drum rhythm, funky bass lines, synthesiser articulation, cymbals rides, digital drums and electronically arranged sounds. The music is an energetic, high-powered, energetic, enthusiastic, intense, and explosive EDM/Synth Pop. | 2012-11-22T10:36:55Z | PDriveTV | 2012 Chrysler 300C CRD engine sound and 0-100km/h. Head over to http://performancedrive.com.au/2012-chrysler-300c-crd-review-video/ for the full review. 2012 Chrysler 300C CRD 3.0-litre turbo-diesel V6 with DOHC and common-rail injection Five-speed automatic, rear-wheel drive 176kW/550Nm 0-100km/h in 7.0 seconds (as tested) | ["Drum and bass", "House music", "Music"] | ["instrumental", "fast tempo", "vocalisation", "synth/pop", "electro/pop", "futuristic", "progressive", "edm", "synthesiser articulation", "vigorous drumming", "funky bass lines", "vibrant electric guitar harmony", "keyboard accompaniment", "electronic sounds", "rapid", "boisterous", "energetic", "enthusiastic", "electrifying", "exhilarating", "passionate", "electric powered", "powerful", "volatile", "explosive"] | 7 | b8cgQBzBXi8 | 3603 |
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;