musiccaps_details (view)
2 rows where musiccaps_aspects contains "sneeze"
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 |
---|---|---|---|---|---|---|---|---|---|---|
STAA Episode 1 - The Shifting | This is an excerpt from a dubbed anime. There is a male voice speaking in a funny manner. Then, a dramatic orchestra piece starts playing to imply something is about to happen. The brass section and the timpani are playing a rising pattern until a sneeze and hissing sounds can be heard. There is a peculiar feel to this track. Parts of it could be sampled for use in beat-making. | 2011-07-27T19:08:36Z | TheWINChestersInc | Oh yeah. This is happening too. Cass List: Omnibeneficial: Dean, Shapeshifter (sometimes) , Crotch Guy and Old Man ThroneofCipher: Sam xbubblemunkyx: Wife and Catherine TheDeathWombat: Shapeshifter | ["Music", "Speech", "Scary music"] | ["anime", "male voice", "funny speaking", "sneeze", "hissing sounds", "orchestra piece", "brass section", "timpani", "rising pattern", "dramatic", "peculiar"] | 9 | DgVpK6r7JT4 | 1503 | |
Arturo & Doc Solos.mp4 | a latin jazz ensemble performing in a recital hall. A trumpet solo is accompanied by acoustic bass, syncopated drums and piano. The rhythm is upbeat and danceable. You can hear the reverb of the recital hall as well as audience sounds, someone sneezing. | 2010-11-29T02:19:26Z | jazzman1222 | This is my second Video of Doc and Arturo at the Rafael Mendez Trumpet Festival in Mexico City. Hard to believe that Doc is 83, he still has a wonderful sound!!! Arturo is still burnin´as usual!! | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Trumpet", "Inside, large room or hall"] | ["latin jazz", "trumpet solo", "acoustic bass", "recital hall", "reverb", "audience sounds", "sneeze", "piano", "syncopated drums", "upbeat rhythm", "danceable"] | 8 | eiyyoUt64Zc | 3894 |
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;