musiccaps_details (view)
1 row where musiccaps_aspects contains "strings" and musiccaps_aspects contains "terrifying" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- cinematic synth 1
- dread 1
- electronic drums 1
- hopelessness 1
- movie music 1
- ominous 1
- sound effects 1
- strings · 1 ✖
- synth bass 1
- terrifying · 1 ✖
musiccaps_names (array) 2 ✖
- Music 1
- Scary music 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Saw 7 Teaser Trailer | This is a movie music piece. Elements with sharp characters in varying ranges such as strings, cinematic synth and synth bass have been used to create a feeling of dread and hopelessness. The electronic drums have been used for crash hits to put emphasis points. There are also other unnerving sound effects. The atmosphere of the piece is ominous. It could be used in the soundtrack of a horror movie or a horror video game. | 2008-08-21T08:57:08Z | DecimalBrothers | PLEASE SUBSCRIBE (if you like cupcakes). Facebook: http://facebook.com/DecimalBrothers Second Channel: http://youtube.com/greenhatangel DB Twitter: http://twitter.com/DecimalBrothers Mollie's Twitter: http://twitter.com/mollieDB Homam's Twitter: http://twitter.com/homamDB Thanks for all the supportive comments, this was made a while back and we have grown greatly since this film. This was made during saw 6 VI So far these have been released: Saw: 1 - I 2 - II 3 - III 4 - IV 5 - V 6 - VI 7 - VII Props goes to Mollie with his phenomenal editing skills :) | ["Music", "Scary music"] | ["movie music", "strings", "cinematic synth", "synth bass", "electronic drums", "sound effects", "dread", "hopelessness", "ominous", "terrifying"] | 9 | DpAfyjjQJyk | 1511 |
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;