musiccaps_details (view)
2 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "intense" and musiccaps_aspects contains "vocalisation"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- fast tempo · 2 ✖
- instrumental 2
- intense · 2 ✖
- vocalisation · 2 ✖
- airplane sound 1
- animated voices 1
- auto harp 1
- birds 1
- birds chirping 1
- blasts 1
- breezy 1
- cello 1
- cheerful 1
- child playing 1
- child’s voice 1
- crashing 1
- crickets 1
- danger 1
- dangerous 1
- dark 1
- destructive 1
- eerie 1
- electric guitar 1
- evil 1
- exploding 1
- falling 1
- fearful 1
- fun 1
- incessant eerie background music 1
- male voice screaming 1
- playful 1
- poor audio quality 1
- pop 1
- scraping 1
- sinister music 1
- spook music 1
- spooky 1
- static 1
- synthesiser arrangement 1
- tumbling 1
- viola 1
- violins 1
musiccaps_names (array) 6 ✖
- Boom 1
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Music 1
- Pizzicato 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Snoopy & Woodstock 3 | This music is an animated instrumental. The tempo is fast with a lively cello bass line , viola and violin harmony with a lead strung instrument which is either an Auto Harp or electric guitar. There is a child’s voice superimposed on the music with incoherent words and a lot of static. The music is lively, intense,playful, fun, cheerful, animated and breezy. This music is an animated Pop. | 2007-02-19T00:19:07Z | HITMANIV | Snoopy and Woodstock get their roll on | ["Cello", "Double bass", "Pizzicato", "Bowed string instrument"] | ["instrumental", "fast tempo", "animated voices", "cello", "pop", "fun", "breezy", "child playing", "auto harp", "static", "poor audio quality", "electric guitar", "violins", "auto harp", "viola", "intense", "playful", "child’s voice", "vocalisation", "cheerful"] | 7 | sUh43prJYMM | 4954 | |
Soul Eater (English Dub) Kishin Asura vs Shinigami-sama -2nd fight- | This clip is an instrumental. The tempo is fast with no harmony. There is a sinister synthesised music playing in the background to the sounds of a male voice screaming in pain, an airplane flying, crashing, exploding, blasts, tumbling and scraping and the sound of a bird or cricket . The sinister music incessantly plays in the background. The vibe of this audio is sinister, spooky, eerie, haunting, dangerous and destructive. | 2011-05-27T03:56:42Z | Raidtastic | Disclaimer: I don't own Soul Eater. Clip from episode 48 of the Soul Eater anime English dub. I didn't include the part where Asura eats Arachne's soul because I already made that part into a separate video. | ["Music", "Boom"] | ["instrumental", "fast tempo", "vocalisation", "fearful", "destructive", "exploding", "tumbling", "scraping", "incessant eerie background music", "spooky", "dangerous", "evil", "dark", "intense", "crickets", "birds", "crashing", "male voice screaming", "synthesiser arrangement", "sinister music", "danger", "airplane sound", "crashing", "falling", "birds chirping", "blasts", "spook music", "eerie"] | 7 | vQHKa69Mkzo | 5182 |
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;