musiccaps_details (view)
38 rows where musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "vibrant"
This data as json
musiccaps_aspects (array) 327 ✖
- instrumental · 38 ✖
- vibrant · 38 ✖
- fast tempo 13
- no singer 10
- enthusiastic 9
- energetic 8
- lively 8
- live performance 7
- youthful 6
- engaging 5
- upbeat 5
- bass guitar 4
- catchy 4
- cheerful 4
- electronic music 4
- groovy 4
- keyboard harmony 4
- orchestra 4
- spirited 4
- vivacious 4
- acoustic guitar 3
- captivating 3
- cello 3
- club music 3
- dance music 3
- dj 3
- edm 3
- fiddle 3
- joyful 3
- loud 3
- medium tempo 3
- percussion 3
- playful 3
- punchy 3
- sonic power 3
- synthesiser arrangements 3
- vigorous 3
- violin 3
- violin symphony 3
- western classical 3
- accordion 2
- acoustic drums 2
- animated 2
- brass section 2
- buoyant 2
- classical 2
- classical music 2
- dance groove 2
- danceable 2
- dexterous 2
- digital drum 2
- drum machine 2
- eastern sounding 2
- electric guitar feedback 2
- enthusiastic drumming 2
- flute 2
- folk dance 2
- folk music 2
- funky bass line 2
- guitar 2
- happy 2
- heart-touching 2
- infectious drumming 2
- irish folk music 2
- medium fast tempo 2
- oud 2
- profound 2
- punk rock 2
- rich 2
- rock 2
- single instrument 2
- synthesiser articulation 2
- tambourine 2
- upright bass 2
- vibrations 2
- viola 2
- violins 2
- acordion harmony 1
- acoustic guitar accompaniment 1
- acoustic jazz drums 1
- acoustic steel drum 1
- aerophone 1
- african percussion 1
- amplified guitar 1
- arabic 1
- auto harp accomapniment 1
- azerbaijani folk music 1
- ball rom dancing 1
- ball room 1
- bansuri 1
- batman 1
- beat 1
- beat boxing 1
- bells 1
- big band 1
- blues harp 1
- booming drums 1
- booming sounds 1
- boomy bass drops 1
- bow stringed instruments 1
- brass band 1
- bright drumming 1
- bugle like sounding instrument 1
- burgeoning 1
- car honking 1
- catchy beat 1
- catchy vocal riff 1
- celebratory 1
- chamber music 1
- chanting 1
- chill 1
- choral harmonybright trumpet harmony 1
- cimbalom 1
- colourful 1
- complex harmony 1
- contrabass 1
- country folk song 1
- country movie 1
- country music 1
- cowboy 1
- crisp 1
- cymbal 1
- cymbal ride 1
- cymbals clashing 1
- daf 1
- dance clubs 1
- deep sound 1
- def 1
- dense 1
- digital music 1
- dimuendo 1
- dissonant booming sounds 1
- distorted music 1
- distorted sound 1
- dj mixer 1
- documentary 1
- dreamy 1
- drum beats 1
- drum kit imitation 1
- drumming patterns 1
- eccentric 1
- electric cello 1
- electric guitar melody 1
- electric guitar solo 1
- electro pop 1
- electro rock 1
- electronic drums 1
- electronic instrumentation 1
- electronically arranged sounds 1
- elegant 1
- emphatic 1
- energetic dholak 1
- energetic drumming 1
- enthralling 1
- enthusiastic electric guitar harmony 1
- enthusiastic electric guitar lead 1
- euphonious 1
- exotic 1
- exquisite 1
- external amplification 1
- female vocals 1
- festive 1
- fiddle solo 1
- free reed instrument 1
- french harp 1
- french horn 1
- funk pop 1
- funky 1
- funky electric guitar riff 1
- garmon 1
- glockenspiel 1
- groovy bass line 1
- groovy bass lines 1
- guitar harmony 1
- hands clapping 1
- harmonica 1
- harmonica melody 1
- harp 1
- heavy metal 1
- hi-hat 1
- high strung 1
- high torque 1
- hindi film music 1
- hindustani classical 1
- hindustani music 1
- hip-hop 1
- hissing sound 1
- home video 1
- horn instrument 1
- incessant 1
- indian classical 1
- indian percussions 1
- indian string instrument 1
- inferior sound quality 1
- insistent 1
- intense 1
- intense drumming 1
- interview 1
- iranian classical music 1
- jazz 1
- kick drum 1
- lively keyboard accompaniment 1
- lively sitar 1
- lively vigorous 1
- loud electric guitar feedback 1
- low pitch 1
- lucid 1
- male voice speaking 1
- male voices interaction 1
- mandolin 1
- medium-pitched synth 1
- melancholic 1
- melancholy 1
- melodic 1
- melodious 1
- men talking 1
- merry 1
- modern sounding 1
- mouth organ 1
- nepali folk music 1
- ney 1
- ney flute 1
- nostalgic 1
- orchestral music 1
- oriental dance 1
- ost 1
- pannist 1
- paraguayan folk music 1
- paraguayan harp 1
- party music 1
- pensive 1
- percussion instruments 1
- percussion sounds 1
- perky 1
- phono output 1
- phonograph record 1
- piano 1
- piano accompaniment 1
- pleasant sounds 1
- pop 1
- positive 1
- promotion 1
- psychedelic music 1
- pulsating 1
- punch digital drum beat 1
- punchy bass lines 1
- punchy beat 1
- punchy drumming 1
- punchy youthful 1
- punjabi film music 1
- qanun 1
- raga 1
- rajasthani folk music 1
- rap 1
- recycled instrument 1
- regional music 1
- repetitive 1
- resounding melody 1
- review 1
- rhythmi chanting 1
- rhythmic 1
- rhythmic beat 1
- rhythmic chanting 1
- romanian folk music 1
- sax concerto 1
- saxophone 1
- saxophone quartet 1
- sensual 1
- simple harmony 1
- single reed instrument 1
- skilled 1
- slow tempo 1
- smooth 1
- snare 1
- soft 1
- sonic treat 1
- sound of bubbling 1
- sound of galloping horse 1
- spirited tabla 1
- stainless steel instrument 1
- steady drumming 1
- steady tempo 1
- steel drums 1
- steel pan 1
- string instrument 1
- string instruments 1
- string section 1
- subtle keyboard harmony 1
- superimposed vocals 1
- swing jazz 1
- symphony 1
- syncopated harmony 1
- synth rock 1
- synthesized electronic tones 1
- taal 1
- tabla 1
- table turner 1
- tambourine beats 1
- tango 1
- tapping 1
- tar 1
- trance 1
- trippy 1
- triumphant music 1
- trombone 1
- trumpet 1
- trumpet flourish 1
- trumpets 1
- tubular bells 1
- tuneful 1
- turn table 1
- uilleann pipes 1
- unique 1
- untiring 1
- upbeat catchy 1
- upbeat music 1
- upbeat vivacious 1
- vigorous mandolin harmony 1
- vinyl records 1
- vivid 1
- vocalisation 1
- walking bass line 1
- warm 1
- water boiling 1
- whistling 1
- wind instrument 1
- woodwind 1
musiccaps_names (array) 62 ✖
- Music 24
- Brass instrument 5
- Musical instrument 5
- Accordion 4
- Wind instrument, woodwind instrument 4
- Folk music 3
- Saxophone 3
- Traditional music 3
- Banjo 2
- Bluegrass 2
- Bowed string instrument 2
- Classical music 2
- Country 2
- Dubstep 2
- Electronic dance music 2
- Flute 2
- Harmonica 2
- Harp 2
- Jazz 2
- Plucked string instrument 2
- Rattle (instrument) 2
- Tabla 2
- Trumpet 2
- Violin, fiddle 2
- Ambient music 1
- Bass guitar 1
- Beatboxing 1
- Blues 1
- Cello 1
- Clarinet 1
- Clatter 1
- Double bass 1
- Drum 1
- Drum and bass 1
- Drum machine 1
- Effects unit 1
- Electric guitar 1
- Electric piano 1
- French horn 1
- House music 1
- Jingle, tinkle 1
- Keyboard (musical) 1
- Percussion 1
- Piano 1
- Pizzicato 1
- Pop music 1
- Reverberation 1
- Rock and roll 1
- Rock music 1
- Sampler 1
- Scratch 1
- Scratching (performance technique) 1
- Shuffle 1
- Sitar 1
- Speech 1
- Spray 1
- Steelpan 1
- Swing music 1
- Synthesizer 1
- Techno 1
- Trance music 1
- Vehicle horn, car horn, honking 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;