musiccaps_details (view)
2 rows where musiccaps_aspects contains "eerie", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "serious"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- eerie · 2 ✖
- keyboard harmony · 2 ✖
- serious · 2 ✖
- aggressive 1
- anticipatory 1
- bad audio quality 1
- boomy bass line 1
- cello 1
- chilling 1
- edgy 1
- electronic music 1
- electronica 1
- emotional 1
- goth rap 1
- grim 1
- haunting 1
- humming 1
- instrumental 1
- intense 1
- male backup singer 1
- male rapper 1
- medium tempo 1
- piano accompaniment 1
- rap song 1
- slow tempo 1
- spooky 1
- steady drumming rhythm 1
- story telling 1
- suspenseful 1
- synth pop 1
- synth string section 1
- synthesised sounds 1
- synthesiser articulation 1
- terrifying 1
- thudding sound 1
- vocalisation 1
musiccaps_names (array) 3 ✖
- Music 2
- Rapping 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 |
---|---|---|---|---|---|---|---|---|---|---|
Jens Pulver Highlight | This music is instrumental. The tempo is slow with a steady, droning keyboard harmony and synthesiser arrangements to create sounds like howling wind, door thudding and a rhythmic male vocal riff. The music is serious, suspenseful, grim, spooky, sinister, chilling ,anticipatory and terrifying. This music is Synth Pop. | 2007-02-26T01:48:07Z | spurious | awesome Jens Pulver HL, killer left hook in all its glory. song is "Whatever" by Our Lady Peace" | ["Music", "Scary music"] | ["instrumental", "slow tempo", "keyboard harmony", "anticipatory", "synth pop", "terrifying", "chilling", "serious", "electronic music", "electronica", "synthesised sounds", "grim", "edgy", "spooky", "eerie", "serious", "synthesiser articulation", "vocalisation", "humming", "thudding sound", "suspenseful", "intense", "cello"] | 7 | E2gstPe3Im4 | 1526 | |
Jak Progresso - Yip Wreck | A male rapper sings this rap medley with a backup singer in vocal harmony. The song is medium tempo with a boomy bass line, synth string section and piano accompaniment. The song is storytelling and haunting in its style. The song is a retro rap song with poor audio quality. | 2010-02-18T12:01:56Z | Ih8thePolice | Track 9 of Pestilence | ["Music", "Rapping"] | ["bad audio quality", "male rapper", "story telling", "emotional", "male backup singer", "piano accompaniment", "medium tempo", "eerie", "haunting", "serious", "steady drumming rhythm", "boomy bass line", "keyboard harmony", "aggressive", "rap song", "goth rap", "synth string section"] | 1 | TrvI6t4pAP0 | 2870 |
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;