musiccaps_details (view)
18 rows where musiccaps_aspects contains "live audience" and musiccaps_author = 7
This data as json
musiccaps_aspects (array) 245 ✖
- live audience · 18 ✖
- live performance 18
- ambient sounds 10
- instrumental 10
- concert 9
- fast tempo 9
- energetic 6
- amateur recording 5
- clapping 5
- classical 5
- enthusiastic 5
- cello 4
- lively 4
- male vocalist 4
- medium fast tempo 4
- medium tempo 4
- spirited 4
- bagpiper 3
- engaging 3
- gig 3
- hysteria 3
- loud 3
- people talking 3
- pulsating 3
- wind instrument 3
- youthful 3
- acoustic guitar 2
- banjo 2
- bellows 2
- boy band 2
- brass band 2
- cheering 2
- country music 2
- country song 2
- crowd cheering 2
- dj 2
- dj mixer 2
- double reed instrument 2
- drone pipes 2
- droning 2
- electrifying 2
- emotional 2
- exquisite 2
- fans cheering 2
- fiddle 2
- inferior audio quality 2
- keyboard harmony 2
- lively trumpets 2
- male singer 2
- merry 2
- muffled audio 2
- orchestra 2
- outdoor performance 2
- passionate 2
- piper 2
- poor audio quality 2
- regional music 2
- rich 2
- sharp sounds 2
- stage performance 2
- steady drumming 2
- techno music 2
- vocalisation 2
- 90’s hit song 1
- acoustic 1
- acoustic guitar accompaniment 1
- aerophone 1
- allegro 1
- allergissimo 1
- ambient concert sounds 1
- animated 1
- applause 1
- artist 1
- audience clapping 1
- audience singing along 1
- auto harp 1
- back street boys 1
- baroque 1
- bass drum 1
- bellows-blown bagpipe 1
- blues 1
- booming 1
- boomy 1
- buoyant 1
- captivating 1
- catchy vocal riff 1
- chamber instrument 1
- chamber music 1
- chanter 1
- cheerful 1
- cheering clapping 1
- christmas carols 1
- christmas concert 1
- christmas song 1
- christmas songs 1
- christmas time 1
- closing riff 1
- club music 1
- comforting 1
- compelling 1
- complex harmony 1
- conductor 1
- contemporary 1
- country folk music 1
- country rock 1
- crowd screaming 1
- deliberate 1
- delicate 1
- dixie chicks concert 1
- electric guitar 1
- electric guitar harmony 1
- electro music 1
- electro pop 1
- elegant 1
- emphatic vocals 1
- emphatic vocals 1
- enchanting 1
- english dance 1
- entertaining 1
- enthralling 1
- extravagant 1
- fans 1
- fans going berserk 1
- fans going crazy 1
- fans screaming 1
- female vocalist 1
- female vocalists 1
- flute 1
- folk 1
- folk song 1
- foreign language 1
- fourth world music 1
- french horn 1
- french horn harmony 1
- full bodied 1
- fun 1
- funky bass 1
- futuristic 1
- ghungaroos sound 1
- girl band 1
- groovy bass line 1
- happy 1
- hard hitting drums 1
- harmonium melody 1
- haunting 1
- haunting melody 1
- heavily synthesised music 1
- heavy reverb 1
- high energy 1
- high notes 1
- high-spirited 1
- hip-hop 1
- hit song 1
- hooting 1
- humming melody 1
- hypnotic 1
- incoherent music 1
- incoherent sound 1
- indian classical 1
- indian percussion instrument 1
- infectious drumming 1
- infectious engaging 1
- intense 1
- irish 1
- italian classical 1
- k-pop 1
- keyboard rhythm 1
- lilting 1
- lively backup 1
- lively piano 1
- lively spanish guitar 1
- lively tabla rhythm 1
- lively vocals 1
- mandolin 1
- melodious 1
- melody pie 1
- mesmerising 1
- minimalist 1
- muffled instrumentation 1
- muffled sounds 1
- new age music 1
- paino accompaniment 1
- people singing 1
- percussive sounds 1
- performer 1
- pop 1
- pop hit 1
- popular folk music 1
- popularity 1
- powerful vocals 1
- psychedelic 1
- raga 1
- rap 1
- regional folk 1
- resonating 1
- resonator 1
- reverb 1
- rhythmic 1
- rhythmic foot tapping 1
- robotic sounds 1
- rock 1
- scottish instrument 1
- scratching 1
- sharp 1
- sing introduction 1
- slow tempo 1
- small pipe harmony 1
- smooth 1
- soft rock 1
- song end 1
- song interlude 1
- southern rock 1
- spanish song 1
- spectacular 1
- sruti 1
- static 1
- symphony 1
- synth pop 1
- teen pop 1
- teen singer 1
- thumping beats 1
- thumping drum beat 1
- trance 1
- trombone 1
- trumpet symphony 1
- turn table 1
- turntablist 1
- upbeat 1
- vibrant 1
- vibrant vivacious 1
- vibrations 1
- vigorous 1
- vigorous clarinet solo 1
- vinyl record scratching 1
- viola 1
- violin solo 1
- violin symphony 1
- violins 1
- vivacious 1
- vocal backup 1
- vocals 1
- western classical 1
- western classical music 1
- woodwind 1
- world music 1
musiccaps_names (array) 40 ✖
- Music 11
- Musical instrument 4
- Singing 4
- Bagpipes 3
- Wind instrument, woodwind instrument 3
- Bang 2
- Brass instrument 2
- Orchestra 2
- Rock music 2
- Trombone 2
- Applause 1
- Banjo 1
- Bass guitar 1
- Bluegrass 1
- Choir 1
- Christmas music 1
- Clarinet 1
- Country 1
- Crowd 1
- Disco 1
- Drum 1
- Electronic music 1
- Flamenco 1
- Funk 1
- Guitar 1
- Hip hop music 1
- Independent music 1
- Music of Asia 1
- Music of Latin America 1
- Percussion 1
- Plucked string instrument 1
- Pop music 1
- Rapping 1
- Scratching (performance technique) 1
- Shout 1
- Song 1
- Tabla 1
- Tambourine 1
- Trumpet 1
- Yodeling 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;