musiccaps_details (view)
2 rows where musiccaps_aspects contains "electro", musiccaps_names contains "Electronic dance music" and musiccaps_names contains "Electronic music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- electro · 2 ✖
- exciting 2
- 4 on the floor kick pattern 1
- addictive 1
- energetic 1
- epic 1
- haunting synth lead melody 1
- loud choir vocals 1
- loud low percussions 1
- low quality 1
- mellow synth keys 1
- passionate female vocal 1
- powerful 1
- shimmering hi hats 1
- synth lead riser 1
- tom roll 1
- wide synth pad chords 1
musiccaps_names (array) 4 ✖
- Electronic dance music · 2 ✖
- Electronic music · 2 ✖
- Music 2
- Inside, large room or hall 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Qlimax 2011 | Official Q-dance Aftermovie | The low quality recording features an electro song that features loud choir vocals singing over loud low percussions and some tom rolls. Towards the end of the loop, the choir vocal is sustained and it blends with synth lead riser. It sounds powerful, epic, energetic and exciting. | 2011-12-06T01:37:33Z | Q-dance | Get your tickets for Qlimax The Source now at http://q-dance.link/QL20-Tickets-YT. http://www.q-dance.com Qlimax Digipack (BLU-RAY/DVD/CD) available here: http://store.q-dance.nl/en/dvd-blu-ray-38/qlimax-2011-blu-raydvd-62316/ On the 26th of November 2011 Qlimax took place in GelreDome Arnhem. Here the one and only official movie. Make sure to watch it full screen in 720p or higher. This unique event was captured live by 10 RED Epic cameras and edited in 5K cinema resolution and will be available on Blu-ray disc. More info about Q-dance and Qlimax can be found at http://Q-dance.com | ["Electronic music", "Music", "Electronic dance music", "Inside, large room or hall"] | ["low quality", "electro", "loud choir vocals", "loud low percussions", "tom roll", "synth lead riser", "exciting", "energetic", "powerful", "epic"] | 4 | 8qeTEfOqB0A | 954 | |
DANCE FLOOR 2011 - VOEUX 2011 - FRED FRUHAUF | The Electro song features a passionate female vocalist singing over wide synth pad chords, mellow synth keys, shimmering hi hats, "4 on the floor" kick pattern and haunting synth lead melody. It sounds addictive and exciting. | 2010-12-31T18:06:42Z | Fred Fruhauf | Un petit Remix de l'année 2010 pour passer votre réveillon. Toute l'équipe FFZOOM, ainsi que le Studio le Clos Sevestre vous présente SES MEILLEURS VOEUX POUR L'ANNEE 2011. | ["Electronic music", "Music", "Electronic dance music"] | ["electro", "passionate female vocal", "wide synth pad chords", "mellow synth keys", "shimmering hi hats", "4 on the floor kick pattern", "haunting synth lead melody", "addictive", "exciting"] | 4 | sU08gu2zJ4c | 4953 |
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;