musiccaps_details (view)
2 rows where musiccaps_aspects contains "drums playing furiously" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- drums playing furiously · 2 ✖
- ad jingle 1
- brass section 1
- building anticipation 1
- cellos playing tense lower harmony 1
- chainsaw buzzing 1
- chase sequence sounds 1
- chasing sou dsl 1
- composer 1
- conductor 1
- creating fear 1
- dangerous 1
- eerie 1
- emotional 1
- female screaming sounds 1
- haunting 1
- horn section 1
- horror movie soundtrack 1
- huffing and puffing 1
- life changing moments 1
- murderous theme 1
- oman screaming 1
- ominous 1
- opera hall 1
- passionate 1
- philharmonic orchestra 1
- poor audio quality 1
- running sounds 1
- scary 1
- spirited 1
- string section 1
- string section playing 1
- tense 1
- tense music 1
- timpani percussions 1
- unsettling 1
- utmost importance 1
- western classical music 1
musiccaps_names (array) 3 ✖
- Music 2
- Run 1
- Theme 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 | |
Goat Farming in Hyderabad Livestock and Farms (HLSF), Andhra Pradesh, India | The song is an instrumental piece. The song is medium tempo with a furiously playing timpani percussion, string section playing, horns playing and low pitched harmony that evokes danger and suspense. The song is a modern western classical instrumental. | 2013-01-03T13:24:59Z | HydLiveStock | Goat Farming in Hyderabad Livestock and Farms, Andhra Pradesh, India www.HyderabadLivestock.com Phone:+91 939 488 7040 | ["Theme music", "Music"] | ["western classical music", "tense", "ominous", "utmost importance", "life changing moments", "eerie", "spirited", "passionate", "opera hall", "creating fear", "timpani percussions", "drums playing furiously", "string section", "conductor", "composer", "horn section", "brass section", "emotional", "scary", "building anticipation", "philharmonic orchestra"] | 1 | whZygh228yw | 5284 |
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;