musiccaps_details (view)
2 rows where musiccaps_aspects contains "male voice", musiccaps_author = 9 and musiccaps_names contains "Scary music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- dramatic 2
- male voice · 2 ✖
- anime 1
- brass 1
- brass section 1
- explosions 1
- funny speaking 1
- gasp 1
- high-pitched choir 1
- hissing sounds 1
- horrifying 1
- movie music 1
- ominous 1
- orchestra piece 1
- peculiar 1
- rising pattern 1
- sirens 1
- sneeze 1
- sound effects 1
- strings 1
- timpani 1
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 | |
Londo confronts Mr. Morden | This is a movie music piece. Initially, sound effects related to the movie such as explosions and sirens can be heard. A male voice can be heard gasping. There is an orchestra made up of a brass section, a string section and a choir singing at a high pitch. The atmosphere is ominous. This piece could be used in the soundtrack of a horror movie. | 2012-04-14T10:00:08Z | zillabeast | From B5's finest hour, Season 4, Episode 6 - "Into the Fire." | ["Music", "Scary music"] | ["sound effects", "explosions", "sirens", "male voice", "gasp", "strings", "brass", "high-pitched choir", "dramatic", "horrifying", "ominous", "movie music"] | 9 | wR7n4Gg-_ac | 5266 |
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;