musiccaps_details (view)
42 rows where musiccaps_aspects contains "upbeat" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 187 ✖
- upbeat · 42 ✖
- bass guitar 21
- electronic drums 15
- acoustic drums 13
- electric guitar 13
- energetic 13
- lively 10
- live performance 9
- instrumental 8
- male vocal 8
- danceable 7
- loud 7
- melodic singing 7
- piano 7
- keyboard 6
- synth 6
- cheerful 5
- dance 5
- groovy 5
- joyful 5
- no singer 5
- playful 5
- simple tune 5
- female vocal 4
- percussion 4
- saxophone 4
- strong bass 4
- upright bass 4
- vibrant 4
- accordion 3
- acoustic guitar 3
- acoustic sounding drums 3
- aggressive 3
- easygoing 3
- electronic dance music 3
- male vocals 3
- repeated theme 3
- turntable 3
- amateur recording 2
- big band 2
- brass 2
- brass section 2
- catchy 2
- country music 2
- dance pop 2
- drum & bass 2
- eerie 2
- electronic 2
- female vocals 2
- fiddle 2
- folk dance 2
- funk 2
- harmony singing 2
- house 2
- jazz 2
- pop music 2
- pop rock 2
- remix 2
- rock-n-roll 2
- scratching 2
- urban 2
- vocal sample 2
- acapella 1
- acoustic drum 1
- afrobeat 1
- american 1
- arabesque 1
- audience clapping 1
- backing track 1
- baglama 1
- balkan music 1
- bansuri 1
- boogie woogie 1
- bouzouki 1
- bravado 1
- brush 1
- charleston dance 1
- clarinet 1
- clave 1
- club music 1
- colorful 1
- complex 1
- cozy 1
- crowd clapping 1
- dance music 1
- disco 1
- disco music 1
- distorted electric guitar 1
- dj 1
- dj performance 1
- dub 1
- eccentric 1
- electro swing 1
- electroclash 1
- electronic dance 1
- euphoric 1
- experimental pop 1
- fast-tempo electronic drums 1
- female synth vocal 1
- fiddle solo 1
- finger click 1
- flute 1
- generic 1
- gloomy 1
- greek folk music 1
- gritty singing 1
- halay 1
- harmonium 1
- hindustani classical music 1
- hip-hop breakbeat 1
- hollering 1
- hollering sample 1
- indietronica 1
- irish folk music 1
- jam 1
- jazz music 1
- jolly 1
- joyful singing 1
- k-pop 1
- kids performance 1
- korean 1
- kurdish folk music 1
- latin acoustic drums 1
- latin dance 1
- latin percussion 1
- live recording 1
- loud electronic drums 1
- low-to-medium pitch singing 1
- male and female vocal 1
- melancholic 1
- melodic 1
- modern sound 1
- modern sounding 1
- movie theme 1
- mysterious 1
- old recording 1
- pastoral 1
- poor quality 1
- poor quality recording 1
- power metal 1
- r&b 1
- rapid singing 1
- raspy voice 1
- raw 1
- reggae 1
- repeated sample 1
- repeating theme 1
- rimshots 1
- rising pattern 1
- rock 1
- rock and roll 1
- romanian folk music 1
- salsa 1
- shoes 1
- shuffle 1
- ska punk 1
- slap technique 1
- snare drum 1
- solo 1
- spanish language 1
- speed metal 1
- story-telling mood 1
- strings 1
- studio performance 1
- swing jazz 1
- syncopated 1
- synth bass 1
- tabla 1
- tambourine 1
- tap dancing 1
- tapping 1
- techno 1
- trap 1
- trombone 1
- tropical 1
- trumpet 1
- trumpets 1
- tuba 1
- vibraphone 1
- vigorous 1
- virtual sounds 1
- vocaloid 1
- wind band 1
- winds section 1
- yodeling 1
- zumba 1
- zurna 1
musiccaps_names (array) 65 ✖
- Music 35
- Ska 6
- Disco 3
- Happy music 3
- Rock and roll 3
- Roll 3
- Swing music 3
- Accordion 2
- Afrobeat 2
- Brass instrument 2
- Country 2
- Dance music 2
- Drum 2
- Drum and bass 2
- Drum kit 2
- Dubstep 2
- Electronic dance music 2
- Exciting music 2
- Musical instrument 2
- Percussion 2
- Scratching (performance technique) 2
- Singing 2
- A capella 1
- Angry music 1
- Bang 1
- Bass drum 1
- Bass guitar 1
- Bluegrass 1
- Crowd 1
- Drum roll 1
- Electronic music 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- House music 1
- Inside, public space 1
- Jazz 1
- Mandolin 1
- Music of Africa 1
- Music of Asia 1
- Music of Latin America 1
- Outside, rural or natural 1
- Plucked string instrument 1
- Rimshot 1
- Rock music 1
- Salsa music 1
- Scratch 1
- Shuffle 1
- Snare drum 1
- Song 1
- Soul music 1
- Soundtrack music 1
- Speech 1
- Tabla 1
- Tambourine 1
- Tap 1
- Theremin 1
- Traditional music 1
- Trombone 1
- Trumpet 1
- Vibraphone 1
- Violin, fiddle 1
- Vocal music 1
- Yodeling 1
- Zing 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;