musiccaps_details (view)
2 rows where musiccaps_aspects contains "cinematic strings", musiccaps_aspects contains "percussion" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- cinematic strings · 2 ✖
- percussion · 2 ✖
- tension 2
- brass 1
- choir sound 1
- danger 1
- dramatic 1
- epic 1
- male choir 1
- movie music 1
- ominous 1
- orchestra 1
- suspense 1
- video game theme 1
- wind sound effect 1
musiccaps_names (array) 2 ✖
- Music 2
- Scary music 2
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
All World of Warcraft Cinematics | This is a video game theme. There is a cinematic string sound playing the melody while the wind sound effect implies there is a snowstorm. A male choir starts singing alongside orchestral percussive elements. There is an epic atmosphere. This piece could fit well in the soundtrack of a thriller video game where there is a face-off about to happen. | 2014-08-16T04:48:55Z | Stormrage Studios | All World of Warcraft Cinematics + Warlords of Draenor Cinematic. If you like this video please give it a thumbs up, subscribe and be sure to check out my other videos! Thanks to Blizzard Entertainment! | ["Music", "Scary music"] | ["video game theme", "cinematic strings", "wind sound effect", "male choir", "percussion", "epic", "dramatic", "tension"] | 9 | -o0ZtQIkM60 | 86 | |
Narnia Soundtrack: The Blitz, 1940 | This is an orchestral movie music piece. There is a brass section and a cinematic sounding strings section playing a dramatic tune. A percussive syncopation provides the rhythmic background. There is a faint high-pitched choir sound that is most likely coming from a synth. The atmosphere is full of suspense. This piece could be used in the soundtrack of a video game or a movie at a scene that implies an imminent threat or danger. | 2007-11-20T02:32:45Z | Neon | The Chronicles of Narnia Soundtrack: The Blitz, 1940 Composed by Harry Gregson-Williams | ["Music", "Scary music"] | ["movie music", "orchestra", "brass", "cinematic strings", "percussion", "choir sound", "suspense", "tension", "ominous", "danger"] | 9 | N0i99VyZCg8 | 2316 |
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;