musiccaps_details (view)
54 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar" and musiccaps_aspects contains "instrumental"
This data as json
musiccaps_aspects (array) 354 ✖
- acoustic guitar · 54 ✖
- instrumental · 54 ✖
- no singer 15
- easygoing 8
- no voices 8
- slow tempo 8
- lively 7
- calming 6
- fast tempo 6
- joyful 5
- mandolin 5
- no percussion 5
- banjo 4
- bass guitar 4
- keyboard harmony 4
- mellow 4
- melodic 4
- moderate tempo 4
- no other instruments 4
- relaxing 4
- soft 4
- accordion 3
- acoustic drums 3
- amateur recording 3
- ambient 3
- bluegrass 3
- cello 3
- electric guitar 3
- flamenco 3
- gentle 3
- guitar solo 3
- guitar tuning 3
- loud 3
- medium fast tempo 3
- medium tempo 3
- mellow tune 3
- no voice 3
- percussion 3
- piano 3
- romantic 3
- soothing 3
- vibrant 3
- violin 3
- bass 2
- calm 2
- clapping 2
- classical 2
- country song 2
- cozy 2
- double bass 2
- dulcet 2
- eccentric 2
- emotional 2
- energetic 2
- euphonious 2
- exotic 2
- fiddle 2
- flute 2
- folk 2
- folk music 2
- folk song 2
- gentle playing 2
- groovy 2
- happy mood 2
- harmonica 2
- home video 2
- meditation music 2
- minimalist 2
- monotone 2
- no melody 2
- optimistic 2
- orchestra 2
- peppy 2
- pop music 2
- rhythmic 2
- sensual 2
- serene 2
- sharp 2
- single instrument 2
- steady drumming 2
- steady tempo 2
- string instrument 2
- ukulele 2
- upbeat 2
- vivacious 2
- vocalisation 2
- abrupt end 1
- accordion song 1
- acoustic 1
- adventurous 1
- aesthetic 1
- aggressive guitar playing 1
- alpine folk music 1
- amateur 1
- amateur musicians 1
- american 1
- amplified 1
- amplified guitar 1
- animated sounds 1
- arpeggio 1
- atmospheric 1
- banjo riff 1
- beautiful 1
- bells 1
- blues 1
- blues rock 1
- blues song 1
- booming sounds 1
- boomy 1
- busking 1
- camera sounds 1
- captivating 1
- carnatic 1
- catchy 1
- celtic 1
- chanting 1
- charming 1
- cheerful 1
- chinese 1
- chord progression 1
- chords 1
- clarinet 1
- classic pop 1
- classical music 1
- clicking sound 1
- colourful 1
- compilation 1
- complex chords 1
- complex harmony 1
- country 1
- country music 1
- cover 1
- crowd cheering 1
- cymbal ride 1
- cymbal rides 1
- cymbals 1
- dance groove 1
- dance style music 1
- delicate 1
- didgeridoo song 1
- digital drum 1
- dissonant booming sounds 1
- dreamy 1
- eastern 1
- easy listening 1
- edm 1
- elctronic music 1
- electronic music 1
- electronically arranged sounds 1
- enigmatic 1
- ethereal 1
- exercise 1
- female vocalisation 1
- finger style guitar 1
- fingerpicking 1
- fingers snapping 1
- fingerstyle guitar 1
- flute like instrument 1
- flute melody 1
- folk dance 1
- free stroke 1
- free style guitar 1
- fresh 1
- fun 1
- funk/soul 1
- funky bass line 1
- funky bass lines 1
- funny 1
- generic 1
- glockenspiel 1
- godfather 1
- godfather theme 1
- groovy bass lines 1
- guitar 1
- guitar cover 1
- guitar effects 1
- guitar lead 1
- guitar song 1
- guitar string plonk 1
- guitar tuning tutorial 1
- guitar tutorial 1
- happy 1
- harmonica song 1
- harmonium accompaniment 1
- harp 1
- heart-touching 1
- hindi film music 1
- hindu mythology 1
- hindustani classical 1
- hissing sound 1
- hooting sound 1
- how to tune a guitar 1
- idyllic 1
- improvisation 1
- indian classical 1
- indian music 1
- indian mythology 1
- infectious drum grooves 1
- informative 1
- instructor 1
- introduction music 1
- irish 1
- irish folk music 1
- italian folk music 1
- jam 1
- jazz song 1
- keyboard accompaniment 1
- khartal 1
- kids screaming in joy 1
- latin 1
- latin dance 1
- lead harmony 1
- learning to tune a guitar 1
- lecture 1
- live performance 1
- live recording 1
- lively sitar 1
- lively spirited 1
- lively violin 1
- loud feedback 1
- low quality recording 1
- low to high note 1
- low to high notes 1
- lucid 1
- major key 1
- male voice 1
- male voice talking 1
- mandira taal 1
- mandira taal percussion 1
- mantras 1
- maracas 1
- meditative 1
- melancholic 1
- mellifluent 1
- melodious 1
- melodious viloin 1
- minimal instrumentation 1
- minimal instruments 1
- mood 1
- movie music 1
- mysterious 1
- napoletana 1
- new-age 1
- no instrumentation 1
- of static 1
- orchestral music 1
- palm muting 1
- pastoral 1
- pedal steel guitar 1
- people talking 1
- people talking in background 1
- percussive elements 1
- percussive slap 1
- percussive strumming 1
- perky 1
- piano accompaniment 1
- piano song 1
- picado 1
- playful 1
- pleasant 1
- poignant 1
- poor quality 1
- pop song 1
- pop-rock 1
- popular music 1
- positive 1
- psychedelic 1
- puja 1
- punch digital drum beat 1
- punchy beat 1
- punchy drumming 1
- pure 1
- raaga 1
- raga 1
- recorder 1
- relaxing music 1
- repeating theme 1
- repetitive 1
- resonator guitar 1
- resounding 1
- resounding sound 1
- retro music 1
- rhythmic counter play 1
- rhythmic drumming 1
- rhythmic guitar 1
- rising 1
- rock 1
- romanian folk music 1
- romantic melody 1
- romantic piano accompaniment 1
- rural 1
- sentimental 1
- shaker 1
- sharp sound 1
- simple 1
- simple harmony 1
- simple melody 1
- simple percussion 1
- simplicity 1
- slick drumming 1
- slows down to a rhythmic melody 1
- soap opera soundtrack 1
- soft bass 1
- sonic power 1
- soul 1
- soulful 1
- sound of bubbling 1
- spanish 1
- spirited 1
- static 1
- steel guitar 1
- string instrument tuning 1
- strings 1
- sunny 1
- sweet 1
- swishing sound 1
- syncopated bass lines 1
- synth strings 1
- synthesiser arrangements 1
- tala 1
- tambourine 1
- tambourine beats 1
- tango 1
- tarantella 1
- teaching to tune a guitar 1
- temple bells 1
- tender 1
- trance 1
- trippy 1
- trumpets 1
- tutorial 1
- tv series theme 1
- uilleann pipes 1
- uplifting 1
- upright bass 1
- vibrations 1
- vibrato 1
- video game music 1
- vigorous 1
- vigorous at the onset 1
- vigorous tabla introduction 1
- violin harmony 1
- violin symphony 1
- waltz 1
- warm 1
- water boiling 1
- water bubbling 1
- western music 1
- whistle harmony 1
- whistling 1
- white noise 1
- wind instrument 1
- xiao 1
- youthful 1
musiccaps_names (array) 59 ✖
- Music 44
- Musical instrument 19
- Guitar 18
- Plucked string instrument 17
- Acoustic guitar 12
- Flamenco 8
- Bluegrass 7
- Strum 7
- Wind instrument, woodwind instrument 7
- Banjo 4
- Electronic tuner 4
- Flute 4
- Ukulele 4
- Accordion 3
- Harmonica 3
- Bowed string instrument 2
- Country 2
- Effects unit 2
- Gospel music 2
- Mandolin 2
- Music of Bollywood 2
- Music of Latin America 2
- Reverberation 2
- Sad music 2
- Soul music 2
- Steel guitar, slide guitar 2
- Tapping (guitar technique) 2
- Wedding music 2
- Background music 1
- Blues 1
- Carnatic music 1
- Cello 1
- Chorus effect 1
- Didgeridoo 1
- Distortion 1
- Dubstep 1
- Echo 1
- Electric guitar 1
- Electric piano 1
- Electronic dance music 1
- Exciting music 1
- Folk music 1
- Harmonic 1
- Inside, small room 1
- Jingle, tinkle 1
- Keyboard (musical) 1
- New-age music 1
- Piano 1
- Rhythm and blues 1
- Rock and roll 1
- Rock music 1
- Salsa music 1
- Sitar 1
- Spray 1
- Steelpan 1
- Swing music 1
- Tender music 1
- Traditional music 1
- Violin, fiddle 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;