musiccaps_details (view)
2 rows where musiccaps_aspects contains "ominous" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- bowed string bass 2
- ominous · 2 ✖
- ambient 1
- atmospheric 1
- concert bass drum 1
- eerie 1
- electronic cymbal roll 1
- foreboding 1
- held strings 1
- high pitched 1
- horror soundtrack 1
- metallic 1
- orchestral 1
- panned hard right 1
- screech 1
- slow descending glissando 1
- texture 1
- unsettling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pretty little liars - Alison visits the girls | Ominous orchestral music with long held string notes, bowed string bass, electronic cymbal roll and concert bass drum. The mood is eerie. | 2013-01-24T18:04:03Z | PLLlover | Alison visits Hanna, Emily, Spencer and Aria. Are they just dreaming or it is real? That is the question I want to have answered... Episodes when Ali visited the liars: Hanna: 01x11 Emily: 02x12 Spencer: 02x24 Aria: 03x16 | ["Music", "Speech", "Scary music", "Inside, small room"] | ["ominous", "orchestral", "panned hard right", "eerie", "held strings", "bowed string bass", "electronic cymbal roll", "concert bass drum"] | 8 | GAoGADilmV8 | 1696 | |
Twilight Score: The Skin of a Killer | Ambient music full of textures. Present are a slow descending glissando from a high-pitched metallic screech, a bowed string bass, atmospheric reverb. The mood is foreboding and ominous. Good for an unsettling horror soundtrack. | 2009-02-13T22:05:18Z | TwilightScore17 | The Skin Of A Killer by Carter Burwell from the Twilight Score. This is played as Bella tells Edward that she knows his secret, and that she's not afraid. Then Edward runs with Bella on his back "up the mountain, out of the cloud bank" So she can see him in the sunlight. No copyright infringement intended. | ["Music", "Scary music"] | ["atmospheric", "ambient", "texture", "slow descending glissando", "unsettling", "horror soundtrack", "high pitched", "bowed string bass", "foreboding", "ominous", "metallic", "screech"] | 8 | _VmCPixy9GQ | 3473 |
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;