musiccaps_details (view)
15 rows where search matches "guitar", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "upbeat"
This data as json
musiccaps_aspects (array) 167 ✖
- instrumental · 15 ✖
- upbeat · 15 ✖
- fast tempo 6
- cheerful 5
- bass guitar 4
- catchy 4
- keyboard harmony 4
- live performance 4
- vibrant 4
- enthusiastic 3
- groovy 3
- lively 3
- no singer 3
- playful 3
- youthful 3
- accordion 2
- acoustic guitar 2
- acoustic sounding drums 2
- animated 2
- bongos 2
- dance groove 2
- fiddle 2
- funky bass line 2
- groovy bass line 2
- happy 2
- joyful 2
- moderate tempo 2
- no voices 2
- people talking 2
- punk rock 2
- retro rock 2
- rhythmic acoustic guitar 2
- rock 2
- steel pan 2
- trumpets 2
- vivacious 2
- accordion harmony 1
- ambient background sounds 1
- amplified guitar 1
- amplified guitar riff 1
- backing track 1
- balkan music 1
- bass notes 1
- brass band 1
- bright drumming 1
- bright trumpeting 1
- buoyant 1
- burgeoning harmony 1
- captivating 1
- cheering 1
- clapping 1
- clarinet 1
- classic rock 1
- colourful 1
- complex 1
- complex harmonies 1
- complex harmony 1
- concert 1
- conga 1
- contemporary traditional music 1
- country song 1
- digital drum 1
- discarded oil drums 1
- distortion guitar 1
- documentary 1
- electric guitar 1
- electric guitar feedback 1
- electric guitar melody 1
- electronic drums 1
- electronic reggae 1
- energetic 1
- energetic drumming 1
- engaging 1
- enthusiastic electric guitar harmony 1
- enthusiastic electric guitar lead 1
- enthusiastic electronic guitar melody 1
- external amplification 1
- fiddle solo 1
- folk dance 1
- folk music 1
- folk song 1
- funk 1
- funk pop 1
- funky 1
- groovy bass 1
- groovy bass lines 1
- guider sound of breeze 1
- guiero rhythm 1
- guiro rhythm 1
- guitar harmony 1
- happy feel 1
- happy merry 1
- hard hitting drumming 1
- harmonica 1
- high spirited 1
- high-spirited 1
- indie rock 1
- infectious drumming 1
- intense 1
- intense drumming 1
- interview 1
- irish folk music 1
- jam 1
- jive 1
- keyboard accompaniment 1
- keyboard melody 1
- latin folk 1
- latin instrumental music 1
- latin pop 1
- light 1
- lively tambourine beats 1
- loud 1
- loud electric guitar feedback 1
- male voices interaction 1
- medium fast tempo 1
- men talking 1
- muffled music 1
- no other instruments 1
- no percussion 1
- party song 1
- percussion 1
- perky 1
- polyrhythms 1
- poor audio quality 1
- positive 1
- promotion 1
- psychedelic 1
- pulsating 1
- recycled instrument 1
- review 1
- rhythmic congas 1
- rock and roll 1
- romanian folk music 1
- saxophone 1
- simple music 1
- simple percussion 1
- slap technique 1
- solo 1
- sonic power 1
- sonic treat 1
- sound of bike starting 1
- sound of breeze 1
- spanish guitar 1
- spirited 1
- steady bass line 1
- steady drumming 1
- superimposed vocals 1
- syncopated 1
- synth rock 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- synthesiser articulation 1
- tapping 1
- trombone 1
- ukele 1
- upbeat catchy 1
- upbeat music 1
- upbeat vivacious 1
- upright bass 1
- vibrations 1
- virtual sounds 1
- vivid 1
- wind band 1
- wind instrument 1
- wind instruments 1
- windy 1
- world music 1
musiccaps_names (array) 31 ✖
- Music 11
- Musical instrument 4
- Guitar 3
- Plucked string instrument 3
- Accordion 2
- Acoustic guitar 2
- Bass guitar 2
- Blues 2
- Rock and roll 2
- Rock music 2
- Ambient music 1
- Background music 1
- Bass drum 1
- Bluegrass 1
- Brass instrument 1
- Country 1
- Drum 1
- Drum kit 1
- Harmonica 1
- Jazz 1
- Music of Latin America 1
- Percussion 1
- Progressive rock 1
- Psychedelic rock 1
- Roll 1
- Ska 1
- Speech 1
- Steelpan 1
- Trumpet 1
- Violin, fiddle 1
- Wind instrument, woodwind instrument 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;