musiccaps_details (view)
2 rows where musiccaps_aspects contains "string section playing" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- string section playing · 2 ✖
- ad jingle 1
- bad audio quality 1
- cellos playing tense lower harmony 1
- chainsaw buzzing 1
- chase sequence sounds 1
- chasing sou dsl 1
- dangerous 1
- drums playing furiously 1
- entertaining 1
- female screaming sounds 1
- haunting 1
- hissing noise 1
- home music video 1
- horror movie soundtrack 1
- huffing and puffing 1
- instrumental music 1
- medium fast tempo 1
- murderous theme 1
- oman screaming 1
- passionate 1
- percussionist 1
- poor audio quality 1
- positive 1
- practice room 1
- rehearsal session 1
- running sounds 1
- soloist 1
- spirited 1
- tambourine playing percussively 1
- tense music 1
- unsettling 1
- varying volume levels 1
- western classical music 1
musiccaps_names (array) 3 ✖
- Music 2
- Run 1
- Tambourine 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 | |
Carnival Overture - Tambourine performed by Steve Myers | The song is an instrumental. The song is medium fast tempo with a western classic al piece featuring a string string section plays and a tambourine player practices along with background music. The song is spirited and passionate. The audio quality is very poor. | 2011-06-22T18:06:47Z | ybooby | Dvoraks Carnival Overture | ["Music", "Tambourine"] | ["tambourine playing percussively", "home music video", "entertaining", "soloist", "percussionist", "rehearsal session", "bad audio quality", "practice room", "instrumental music", "hissing noise", "varying volume levels", "string section playing", "positive", "spirited", "passionate", "western classical music", "medium fast tempo"] | 1 | xzgnLpKkvdg | 5375 |
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;