musiccaps_details (view)
1 row where musiccaps_aspects contains "dangerous", musiccaps_author = 1 and musiccaps_names contains "Run"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;