musiccaps_details (view)
2 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "electro" and musiccaps_aspects contains "exciting"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
D.B. - Limit (Keinerechte / KR003) | The Electro song features a harmonizing passionate male vocals, with widely spread and dynamic echo effect on it, singing over groovy bass, groovy piano chords, synth keys and filtered "4 on the floor" kick pattern. It sounds exciting, easygoing and addictive - like something you would hear in a DJ set as a warm up. | 2011-08-09T10:08:55Z | Keinerechte | Vinyl Only! Audio is only 128 kBit/s | ["Music", "Reggae"] | ["electro", "groovy piano chords", "synth keys", "wide echoing effect", "harmonizing passionate male vocals", "groovy bass", "filtered \"4 on the floor\" kick pattern", "easygoing", "exciting", "addictive"] | 4 | sIItIq_W3eE | 4940 | |
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;