musiccaps_details (view)
4 rows where musiccaps_aspects contains "grim", musiccaps_aspects contains "violin harmony" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- grim · 4 ✖
- instrumental 4
- violin harmony · 4 ✖
- intense 3
- cello 2
- dark 2
- movie soundtrack 2
- sinister 2
- slow tempo 2
- spooky 2
- viola 2
- bleak 1
- bow string instrument 1
- dangerous 1
- defeated 1
- depressed 1
- didgeridoo 1
- dismal 1
- dreary 1
- eerie 1
- electronic sounds 1
- fast tempo 1
- fearful 1
- frightening 1
- gloomy 1
- harpsichord 1
- heavy 1
- horror movie soundtrack 1
- keyboard accompaniment 1
- keyboard harmony 1
- lost 1
- medium tempo 1
- melancholic piano 1
- pensive 1
- piano accompaniment 1
- poignant 1
- reflective 1
- ritardando 1
- sad 1
- scary 1
- sombre 1
- spike chilling 1
- static 1
- suspenseful 1
- synthesiser arrangements 1
- sythesiser arrangements 1
- violin 1
- violin symphony 1
- wistful 1
musiccaps_names (array) 5 ✖
- Music 3
- Scary music 2
- Background music 1
- New-age music 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shawshank Redemption - Brook was here | This music is instrumental. The tempo is slow with a melancholic piano melody with violin harmony and keyboard accompaniment. The music is sad, mellow, grim, sombre, wistful, poignant, pensive, melancholic and reflective. This music is a soundtrack for a movie. | 2011-04-29T20:28:12Z | Opeth Opet | Enjoy | ["New-age music"] | ["instrumental", "melancholic piano", "slow tempo", "grim", "sombre", "movie soundtrack", "wistful", "sad", "pensive", "reflective", "depressed", "lost", "defeated", "violin harmony", "keyboard accompaniment", "poignant"] | 7 | OkcBJawiIHA | 2466 | |
Two Steps From Hell - Mountains From Water (Archangel) | This music is an intense instrumental.The tempo is fast with vigorous violin harmony that slows down to the accompaniment of a grim Piano harmony. The music is a Ritardando and has a grim, dark, intense,serious,bleak, dreary, and dangerous vibe to it. | 2011-10-08T10:51:01Z | Two Steps From Hell | Buy this album on iTunes: http://tiny.cc/TSFH-Archangel Amazon: http://tiny.cc/TSFH-Archangel1 Spotify: https://open.spotify.com/album/1TVpHhBK3pSTqizgLLh16s Follow Two Steps From Hell on Facebook: http://fbl.me/TSFH Follow Nick Phoenix on Facebook: http://fbl.me/NickPhoenix Composed by Nick Phoenix. You can buy more of our music here: iTunes: http://tiny.cc/TSFH Amazon: http://tiny.cc/TSFH1 CDBaby: http://tinyurl.com/n2b6jrz TSFH Official Websites: www.twostepsfromhell.com www.thomasbergersen.com | ["Music", "Scary music"] | ["instrumental", "fast tempo", "intense", "grim", "dark", "viola", "cello", "violin", "bow string instrument", "dark", "dismal", "bleak", "gloomy", "intense", "dreary", "dangerous", "ritardando", "violin harmony", "piano accompaniment", "sythesiser arrangements"] | 7 | Z_0Ta-m_-hU | 3392 | |
Uru Soundtrack - 02 Beyond Gira | This music is instrumental. The tempo is medium with an intense didgeridoo harmony, violin melody and keyboard accompaniment. The music is eerie,suspenseful; grim, sinister, scary and spooky. It is the sound track of a movie. | 2010-12-13T11:05:44Z | DilandauMusic | Uru: Ages Beyond Myst Soundtrack - 02 Beyond Gira Written by Tim Larkin Let's Uru: http://www.youtube.com/view_play_list?p=9BA1AE80F6BC85F4 Let's Play Uru Live: http://www.youtube.com/view_play_list?p=82059B645037C768 | ["Music", "Theremin"] | ["instrumental", "medium tempo", "didgeridoo", "violin harmony", "suspenseful", "spooky", "synthesiser arrangements", "electronic sounds", "static", "sinister", "grim", "dark", "intense", "scary", "fearful", "movie soundtrack"] | 7 | h6Y0KDtUNHw | 4077 | |
タワー・オブ・テラーBGM | This music is instrumental. The tempo is slow with an intense violin harmony with heavy bass cello. The music is intense, serious, grim, spooky, eerie, terrifying and spine chilling and sounds like the soundtrack of a horror movie. | 2011-03-05T07:27:08Z | TheDisney0304 | ["Background music", "Music", "Scary music"] | ["instrumental", "slow tempo", "violin harmony", "cello", "viola", "keyboard harmony", "violin symphony", "harpsichord", "intense", "heavy", "sinister", "grim", "spooky", "eerie", "frightening", "spike chilling", "horror movie soundtrack"] | 7 | sGM6xX5laFU | 4935 |
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;