musiccaps_details (view)
2 rows where musiccaps_aspects contains "haunting", musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "unsettling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- haunting · 2 ✖
- poor audio quality · 2 ✖
- unsettling · 2 ✖
- ad jingle 1
- amateur music production 1
- cellos playing tense lower harmony 1
- chainsaw buzzing 1
- chase sequence sounds 1
- chasing sou dsl 1
- dangerous 1
- discomforting effect 1
- drums playing furiously 1
- eerie 1
- emotional 1
- faint vocals 1
- female screaming sounds 1
- female singer 1
- harp accompaniment 1
- haunting harmony 1
- horror film soundtrack 1
- horror movie soundtrack 1
- huffing and puffing 1
- keyboard harmony 1
- medium tempo 1
- murderous theme 1
- no percussions 1
- offbeat 1
- oman screaming 1
- poignant 1
- quirky 1
- running sounds 1
- string section playing 1
- tense music 1
musiccaps_names (array) 3 ✖
- Music 2
- Run 1
- Scary music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nike Running Commercial - Scary | The song is an instrumental with sounds of a woman screaming and running with huffing and puffing sounds. A chainsaw buzzes ominously , with a string section playing a scary and tense accompaniment along with a cello building the tension with a poignant harmony. The music is a horror movie soundtrack or an ad jingle. The song audio quality is very poor. | 2006-05-21T17:10:24Z | Shadow tiger void killer | Commercial for Nike running, why sport? you'll live longer! | ["Music", "Run"] | ["oman screaming", "running sounds", "chainsaw buzzing", "chase sequence sounds", "string section playing", "dangerous", "tense music", "cellos playing tense lower harmony", "female screaming sounds", "horror movie soundtrack", "ad jingle", "unsettling", "haunting", "murderous theme", "poor audio quality", "huffing and puffing", "drums playing furiously", "chasing sou dsl"] | 1 | GX-QhoihLeI | 1732 | |
the GHOST BRIDE | A female singer sings this eerie melody. The song is medium tempo with a rolling bells keyboard harmony, and other ambient echo tones and harp tones. The song is haunting and unsettling. The audio quality is very poor and not enjoyable. | 2013-10-04T23:18:46Z | grav3yardgirl | -DON'T WORRY- makeup & hair tutorial COMING TOMORROW! SWAMP FAMILY TEA CUPS ARE BACK! https://www.etsy.com/listing/125139605/16-oz-swamp-family-tea-cup http://www.youtube.com/subscription_center?add_user=grav3yardgirl INSTAGRAM: @grav3yardgirl www.numestyle.com Coupon code: funnybunny - $115 off Curling Wands and Flat Irons Coupon code: bunny8 - $120 off all our styling sets Coupon code: bunny1 - $97 FOR the Lustrum, Couture and Argan Oil, total discount of $366 OFF! http://goo.gl/BGoya3 WANNA SEND ME MAIL? SEND IT HERE!: GRAV3YARDGIRL PO BOX #2263 PEARLAND, TEXAS 77588 follow me on twitter: http://twitter.com/grav3yardgirl LIKE ME ON FACEBOOK: http://www.facebook.com/grav3yardgirl please check out MY ETSY PAGE!!: http://www.etsy.com/shop/enmortem?ref... please take a moment to subscribe!! FTC- I am not being paid by any of the mentioned companies or designers to make this video. The views in this video are strictly my own and I am not affiliated with any of these companies. | ["Music", "Scary music"] | ["female singer", "faint vocals", "eerie", "haunting", "emotional", "poor audio quality", "discomforting effect", "poignant", "unsettling", "offbeat", "quirky", "amateur music production", "haunting harmony", "horror film soundtrack", "no percussions", "harp accompaniment", "keyboard harmony", "medium tempo"] | 1 | KoAGZ_dB8MM | 2119 |
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;