musiccaps_details (view)
14 rows where musiccaps_names contains "Outside, urban or manmade" sorted by youtube_link
This data as json
musiccaps_aspects (array) 117 ✖
- low quality 4
- amateur recording 3
- instrumental 3
- noisy 3
- dramatic 2
- footsteps 2
- poor audio quality 2
- acoustic guitar 1
- aggressive 1
- ambient street noises 1
- amplified 1
- arcade game 1
- background voices 1
- beating 1
- bell sounds 1
- birds chirping 1
- birds singing 1
- bleak 1
- building anticipation 1
- building tension 1
- bull fight 1
- bull goring a man 1
- car honking sound effects 1
- cello playing 1
- chiptune melody 1
- church bells 1
- cinematic synth 1
- compilation 1
- conductor 1
- crouching bass line 1
- crowd chattering 1
- dangerous 1
- death metal 1
- distant brass melody 1
- distant traffic 1
- dread 1
- e-guitar 1
- eerie 1
- electric guitar 1
- emotional 1
- exciting 1
- fast tempo 1
- fighting 1
- flutes playing 1
- folk 1
- galloping sound 1
- gameplay 1
- gong 1
- hard 808 bass 1
- hard rock 1
- haunting 1
- heartbeat 1
- heartfelt 1
- heavy metal 1
- heavy metalloud feed back 1
- higher pitch 1
- horn section 1
- horn sounds 1
- horror 1
- instrumental music 1
- instrumental sjic 1
- intense 1
- live performance 1
- live recording 1
- loud feedback 1
- loud impact 1
- low fidelity 1
- low wide suspenseful pad 1
- lullaby 1
- male voice singing 1
- male voice speaking 1
- male voices 1
- man screaming in pain 1
- martial arts movie 1
- metal 1
- mono 1
- movie music 1
- movie soundtrack 1
- movie trailer 1
- mysterious string synth tones 1
- no percussion instruments 1
- paigu 1
- painful screaming/crying sounds 1
- passionate 1
- passionate male singer 1
- philharmonic orchestra 1
- piano 1
- punchy snare 1
- retro movie soundtrack 1
- rock 1
- scary 1
- shimmering hi hats 1
- shouting 1
- singer-songwriter 1
- sonic power 1
- sound effects 1
- spooky glass melody 1
- spooky movie 1
- steady drumming rhythm 1
- string section harmony 1
- stringed instrument 1
- strings 1
- strumming 1
- suspense 1
- synth keys melody 1
- tense harmony 1
- tension 1
- terrified female voice 1
- thin 1
- transition effects 1
- trap 1
- video game soundtrack 1
- violence 1
- water running 1
- whistling sound effects 1
- wide filtered stuttering down sweep sound effect 1
- wind 1
musiccaps_names (array) 21 ✖
- Music 14
- Outside, urban or manmade · 14 ✖
- Bell 2
- Guitar 2
- Heart murmur 2
- Musical instrument 2
- Plucked string instrument 2
- /t/dd00003 1
- Bass guitar 1
- Cacophony 1
- Echo 1
- Foghorn 1
- Glass 1
- Ice cream truck, ice cream van 1
- Inside, large room or hall 1
- Inside, small room 1
- Rumble 1
- Scary music 1
- Speech 1
- Thunk 1
- Wail, moan 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;