musiccaps_details (view)
2 rows where musiccaps_aspects contains "haunting synth lead melody" and musiccaps_author = 4 sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- haunting synth lead melody · 2 ✖
- 4 on the floor kick pattern 1
- addictive 1
- electro 1
- exciting 1
- humming sound effects 1
- low quality 1
- mellow synth keys 1
- munching sound effects 1
- passionate female vocal 1
- shimmering chain sound effects 1
- shimmering hi hats 1
- smooth bass 1
- unbalanced stereo image 1
- wide synth pad chords 1
musiccaps_names (array) 4 ✖
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cinnamon Toast Crunch: Pieces-Gone Television Commercial | The low quality recording features a munching and humming sound effect - like someone is enjoyably eating. At the very beginning, there is also a haunting synth lead melody and a smooth bass located in the left channel of the stereo image - making it unbalanced. | 2009-08-26T15:33:51Z | eatmedaily | ["Music", "Crunch"] | ["munching sound effects", "humming sound effects", "shimmering chain sound effects", "haunting synth lead melody", "smooth bass", "low quality", "unbalanced stereo image"] | 4 | Z9hnLYpypCU | 3344 | ||
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;