musiccaps_details (view)
11 rows where musiccaps_aspects contains "serious"
This data as json
musiccaps_aspects (array) 137 ✖
- serious · 11 ✖
- grim 5
- instrumental 5
- intense 5
- slow tempo 4
- eerie 3
- emotional 3
- keyboard harmony 3
- medium tempo 3
- sinister 3
- atmospheric synthesiser 2
- cello 2
- dangerous 2
- deep bass 2
- instrumental music 2
- passionate 2
- suspenseful 2
- synthesiser articulation 2
- 90's hip hop 1
- acoustic 1
- aggressive 1
- animated movie soundtrack 1
- anticipatory 1
- bad audio quality 1
- battle march 1
- bell ringing 1
- bell tones 1
- blasts 1
- booming bass drum 1
- booming sounds 1
- boomy bass 1
- boomy bass line 1
- bow stringed instrument 1
- cartoon soundtrack 1
- chilling 1
- chopper 1
- clap 1
- classical music 1
- complex rhythms 1
- danger 1
- doubled vocals 1
- droning 1
- edgy 1
- electric guitar harmony 1
- electric piano 1
- electroni music 1
- electronic music 1
- electronica 1
- enigmatic 1
- ethereal sounds 1
- ethereal tones 1
- exquisite technique 1
- fast tempo 1
- fireworks 1
- gangster rap 1
- glass harp harmony 1
- glass harpist 1
- goth rap 1
- grim cello 1
- grunting 1
- gunshots 1
- hand percussion 1
- haunting 1
- helicopter sound 1
- hip-hop 1
- hollow sound 1
- hostile 1
- humming 1
- intense violin 1
- journey in to the unknown 1
- lead 1
- live performance 1
- male and female players 1
- male backup singer 1
- male rapper 1
- male singer 1
- mallets 1
- marching drum rhythm 1
- master class 1
- mesmerising 1
- metal clanging 1
- militant 1
- minimal 1
- minimalist music 1
- mystical 1
- no melody 1
- no vocals 1
- orchestra 1
- oud 1
- percussions 1
- piano accompaniment 1
- poor audio quality 1
- profound 1
- psychedelic synthesiser 1
- rap 1
- rap song 1
- rapper 1
- retro arcade game music 1
- retro pop music 1
- rhythmic patter 1
- rhythmic speechlow notes 1
- roaring 1
- roll 1
- siren at the end 1
- solo 1
- sound effects 1
- spooky 1
- steady bass line 1
- steady drumming rhythm 1
- story telling 1
- string section 1
- string synth harmony 1
- strong male rapper 1
- suspense 1
- synth flute 1
- synth pop 1
- synth rap 1
- synth string section 1
- synthesised sounds 1
- tambourine 1
- terrifying 1
- thudding sound 1
- timpani 1
- two drums 1
- vibrations 1
- vibrato 1
- victory march 1
- vigorous drumming 1
- viola 1
- violin symphony 1
- violins 1
- vital 1
- vocalisation 1
- western classical 1
- wind instrument 1
- wine cellar 1
- wonder 1
musiccaps_names (array) 17 ✖
- Music 9
- Musical instrument 2
- Scary music 2
- Background music 1
- Bowed string instrument 1
- Double bass 1
- Drum 1
- Eruption 1
- Glass 1
- Heart murmur 1
- Music of Asia 1
- Rapping 1
- Reggae 1
- Singing 1
- Soul music 1
- Timpani 1
- Traditional music 1
0 records
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;