musiccaps_details (view)
58 rows where musiccaps_aspects contains "lively" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 232 ✖
- lively · 58 ✖
- instrumental 26
- vibrant 24
- acoustic drums 17
- bass guitar 15
- live performance 14
- no singer 13
- acoustic guitar 10
- upbeat 10
- male vocal 9
- percussion 9
- cheerful 8
- upright bass 8
- energetic 7
- joyful 7
- playful 6
- electric guitar 5
- folk dance 5
- male vocals 5
- melodic singing 5
- piano 5
- accordion 4
- easygoing 4
- female vocal 4
- jazz 4
- keyboard 4
- clarinet 3
- dance 3
- danceable 3
- flute 3
- latin dance music 3
- latin percussion 3
- marimba 3
- orchestra 3
- scottish folk music 3
- single instrument 3
- tabla 3
- violin 3
- amateur recording 2
- american 2
- bagpipes 2
- banjo 2
- bansuri 2
- big band 2
- brass 2
- brass section 2
- ceremonial 2
- classical 2
- conga 2
- cozy 2
- electronic drums 2
- fiddle 2
- folk 2
- garmon 2
- greek folk music 2
- harmonium 2
- jolly 2
- joyful singing 2
- latin dance 2
- loud singing 2
- male voice 2
- mandolin 2
- maracas 2
- mexican folk music 2
- salsa 2
- scottish bagpipes 2
- spanish 2
- steady tempo 2
- steel percussion 2
- strings section 2
- tango 2
- tarantella 2
- ukulele 2
- unique 2
- accordeon 1
- acoustic 1
- acoustic drum 1
- acoustic latin drums 1
- afro cuban 1
- afro cuban dance 1
- afro-cuban 1
- albanian pop music 1
- algerian folk music 1
- arabesque 1
- arpa jarocha 1
- audience clapping 1
- azerbaijani folk music 1
- background music 1
- baglama 1
- bass drum 1
- bluegrass 1
- bodhran 1
- bongo 1
- bouzouki 1
- catchy 1
- cello 1
- chamber orchestra 1
- chant-like singing 1
- charleston dance 1
- childlike 1
- childlike singing 1
- chill 1
- choir 1
- claps 1
- classical music 1
- clave 1
- congas 1
- country music 1
- cowbell 1
- croatian pop 1
- crowd clapping 1
- cymbal 1
- cymbals 1
- dancehall 1
- doira 1
- dreamy 1
- drums 1
- dub 1
- eccentric 1
- educational 1
- electric guitat 1
- elegant 1
- euphoric 1
- female voice 1
- festive 1
- floghera 1
- folk music 1
- french bagpipes 1
- fun 1
- funk 1
- glockenspiel 1
- gujarati folk music 1
- halay 1
- hard-hitting 1
- harmonica 1
- harp 1
- heart-touching 1
- heavy metal 1
- hindi film music 1
- historical movie music 1
- horn 1
- indian dance music 1
- indian film music 1
- introduction 1
- irish 1
- irish folk music 1
- italian folk music 1
- jamaican 1
- jazz music 1
- jazzy 1
- kids show theme 1
- kids song 1
- korean 1
- kurdish folk music 1
- latin acoustic drums 1
- latin folk 1
- latin music 1
- lighthearted 1
- live recording 1
- loud 1
- lute 1
- male and female vocal 1
- manjira 1
- marching band 1
- medieval music 1
- medium-to-high pitch singing 1
- merrily singing 1
- movie music 1
- movie theme 1
- napoletana 1
- nepali folk music 1
- off-key singing 1
- old recording 1
- omani traditional music 1
- oud 1
- outer space 1
- package opening 1
- peruvian folk music 1
- peruvian harp 1
- polka 1
- pop music 1
- pop rock 1
- positive 1
- preach-like singing 1
- punjabi film music 1
- rai 1
- raspy voice 1
- reggae 1
- relaxed 1
- repeated tune 1
- rhythmic 1
- rising tempo 1
- robotic sound effects 1
- romanian folk music 1
- rumba 1
- saxophone 1
- saxophone quartet 1
- shekere 1
- shoes 1
- shouting 1
- sitar 1
- ska punk 1
- snare drum 1
- sound effects 1
- space disco 1
- spanish language 1
- star wars 1
- street atmosphere 1
- street performance 1
- strings 1
- studio performance 1
- synth 1
- tambourine 1
- tap dancing 1
- theme music 1
- timbale 1
- toy review 1
- trombone 1
- trumpet 1
- tuba 1
- uilleann pipes 1
- uzbek folk music 1
- venezuelan 1
- vibraphone 1
- vielle 1
- wedding march 1
- winds 1
- winds section 1
- woodwinds 1
- xylophone 1
- yodeling 1
- zurna 1
musiccaps_names (array) 69 ✖
- Music 34
- Wind instrument, woodwind instrument 9
- Musical instrument 8
- Traditional music 7
- Accordion 6
- Bagpipes 5
- Brass instrument 5
- Ska 5
- Bowed string instrument 4
- Banjo 3
- Bluegrass 3
- Clarinet 3
- Harp 3
- Mandolin 3
- Rattle (instrument) 3
- Swing music 3
- Acoustic guitar 2
- Drum kit 2
- Flamenco 2
- Flute 2
- Guitar 2
- Jazz 2
- Music of Africa 2
- Music of Latin America 2
- Percussion 2
- Pizzicato 2
- Plucked string instrument 2
- Rock and roll 2
- Roll 2
- Salsa music 2
- Singing 2
- Song 2
- Soul music 2
- Speech 2
- Steelpan 2
- Tabla 2
- Trombone 2
- Trumpet 2
- Violin, fiddle 2
- Afrobeat 1
- Blues 1
- Cello 1
- Classical music 1
- Dance music 1
- Disco 1
- Double bass 1
- Drum 1
- Electronic music 1
- Folk music 1
- French horn 1
- Funk 1
- Glockenspiel 1
- Happy music 1
- Harmonica 1
- Jingle, tinkle 1
- Mallet percussion 1
- Marimba, xylophone 1
- Middle Eastern music 1
- Music for children 1
- Orchestra 1
- Pop music 1
- Reggae 1
- Saxophone 1
- Shofar 1
- Soundtrack music 1
- String section 1
- Tap 1
- Timpani 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;