musiccaps_details (view)
16 rows where musiccaps_names contains "Foghorn"
This data as json
musiccaps_aspects (array) 140 ✖
- instrumental 5
- low quality 5
- calming 3
- emotional 3
- noisy 3
- poor audio quality 3
- relaxing 3
- tuba 3
- ambient 2
- brass 2
- loud 2
- melancholic 2
- mono 2
- movie soundtrack 2
- slow tempo 2
- trumpet 2
- acordion 1
- aerophone 1
- amateur music recording 1
- amateur recording 1
- anthem 1
- army marching 1
- audio crackles 1
- background music 1
- bass drum 1
- birds chirping 1
- brass band 1
- brass instrument 1
- building anticipation 1
- buzzing 1
- buzzy 1
- changing tones 1
- cheerful 1
- choir singers 1
- choral harmony 1
- cinematic 1
- clarinet 1
- classical 1
- classical music 1
- conductor 1
- counting 1
- counting in french 1
- crouching bass line 1
- deteriorated audio quality 1
- distorted 1
- dramatic 1
- eerie 1
- epic 1
- fast tempo 1
- flutes playing 1
- forceful 1
- french horn 1
- french horn tutorial 1
- funeral march 1
- goat sound 1
- happy 1
- harsh 1
- haunting 1
- holding notes 1
- horn 1
- horn section 1
- horn solo 1
- hot signal 1
- humming 1
- intricately coiled instrument 1
- intro 1
- jazz 1
- jazzy 1
- keeping beat 1
- live performance 1
- loud didgeridoo modulating low tones 1
- loud impact 1
- low horn 1
- majestic 1
- male laughing 1
- male voice 1
- male voice speaking 1
- march 1
- meditative 1
- medium tempo 1
- mellow echoing synth pad keys 1
- mellow keys chords 1
- mellow sustained strings 1
- melodious harmony 1
- merry 1
- monotone 1
- movie music 1
- muffled trumpet melody 1
- no percussion instruments 1
- ominous music 1
- orchestra 1
- organ playing chords 1
- passionate 1
- passionately 1
- pensive 1
- philharmonic orchestra 1
- pleasant harmonious 1
- quick tempo 1
- retro movie soundtrack 1
- retro movie themes 1
- reverberant 1
- rich 1
- royal march 1
- sad 1
- saxophone 1
- smooth bass guitar 1
- snare drum 1
- soft electric guitar arpeggiated melody 1
- soft kick hits 1
- soft rimshot hits 1
- soft shimmering bells 1
- solemn 1
- song intro 1
- spirited 1
- spooky movie 1
- steady drumming rhythm 1
- string section harmony 1
- strings 1
- subtle wooden percussive element 1
- suspense 1
- sustained low woodwind 1
- the horn 1
- tribute 1
- triumphant 1
- trombone 1
- trombones 1
- trumpet playing 1
- tuba solo melody 1
- tutorial 1
- unpleasant 1
- uptempo 1
- warm 1
- weird 1
- wide brass section 1
- wide resonating woodwind melody 1
- wind 1
- wind ensemble 1
- wind instrument 1
- wind instruments 1
- wood wind 1
musiccaps_names (array) 17 ✖
- Foghorn · 16 ✖
- Music 15
- Musical instrument 7
- Brass instrument 6
- Inside, large room or hall 2
- Orchestra 2
- Accordion 1
- Bass guitar 1
- Classical music 1
- Didgeridoo 1
- Guitar 1
- Outside, rural or natural 1
- Outside, urban or manmade 1
- Plucked string instrument 1
- Speech 1
- Trombone 1
- Trumpet 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;