musiccaps_details (view)
99 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_author = 9
This data as json
musiccaps_aspects (array) 298 ✖
- acoustic guitar · 99 ✖
- bass guitar 38
- male vocal 30
- easygoing 28
- melodic singing 28
- acoustic drums 27
- instrumental 27
- female vocal 17
- no singer 15
- live performance 14
- electric guitar 13
- emotional 13
- mellow 12
- lively 10
- male vocals 10
- sentimental 10
- acoustic 9
- calming 9
- electronic drums 9
- simple tune 9
- joyful 8
- mandolin 8
- relaxing 8
- cozy 7
- flamenco 7
- gentle 7
- melancholic 7
- piano 7
- religious 7
- slow tempo 7
- banjo 6
- bluegrass 6
- fiddle 6
- generic 6
- gospel 6
- percussion 6
- pop music 6
- spanish 6
- vibrant 6
- cover 5
- gentle playing 5
- playful 5
- romantic 5
- strings 5
- uplifting 5
- accordion 4
- chill 4
- christian 4
- groovy 4
- jam 4
- jingle 4
- male voice 4
- steady tempo 4
- upright bass 4
- ambient synth 3
- ballad 3
- clarinet 3
- country music 3
- devotional 3
- exotic 3
- female voice 3
- flute 3
- folk 3
- mellow singing 3
- mellow tune 3
- melodic 3
- repeated theme 3
- sensual 3
- teen female vocal 3
- trippy 3
- upbeat 3
- violin 3
- aggressive 2
- alternative 2
- alternative rock 2
- amateur recording 2
- american 2
- calm 2
- country 2
- crowd singing 2
- dance 2
- downtempo 2
- eccentric 2
- educational 2
- energetic 2
- festive 2
- friendly 2
- fun 2
- gentle singing 2
- harmonica 2
- heart-touching 2
- indie rock 2
- irish 2
- keyboard 2
- latin dance 2
- latin percussion 2
- longing 2
- lullaby 2
- major key 2
- maracas 2
- meditation 2
- meditation music 2
- movie music 2
- optimistic 2
- orchestra 2
- passionate singing 2
- poor quality 2
- pop 2
- pop rock 2
- positive 2
- psychedelic 2
- repeating theme 2
- rock 2
- rural 2
- simple 2
- single instrument 2
- sleep-inducing 2
- solo 2
- soothing 2
- synth strings 2
- teen male vocal 2
- tender 2
- thai 2
- ukulele 2
- urban 2
- acoustic folk 1
- acoustic performance 1
- acoustic rock 1
- acoustic sounding drums 1
- adventurous 1
- advertising 1
- afro-cuban 1
- agitated 1
- albanian pop music 1
- alpine folk music 1
- american folk 1
- american folk music 1
- americana 1
- arpeggio 1
- background music 1
- banjo solo 1
- bass 1
- bells 1
- bland 1
- boy band 1
- brazilian 1
- british hip-hop music 1
- cajon 1
- carnatic 1
- cello 1
- chant 1
- cheerful 1
- child male voice 1
- children's song 1
- chimes 1
- chinese 1
- chipmunk effect 1
- christian contemporary music 1
- christian pop 1
- christian rock 1
- christmas 1
- claps 1
- classical 1
- classical music 1
- coffee shop music 1
- comedic 1
- compilation 1
- croatian pop 1
- crowd cheering 1
- deep 1
- delicate 1
- description 1
- drums 1
- dub 1
- eastern 1
- electric guitat 1
- electronic 1
- electronic drum beat 1
- exercise 1
- experimental pop 1
- folk dance 1
- folk music 1
- folk rock 1
- folk singing 1
- footsteps 1
- free stroke 1
- gear 1
- glockenspiel 1
- gospel music 1
- gothic rock 1
- gravelly voice 1
- grunt-like singing 1
- guitar cover 1
- guitar solo 1
- hard-hitting 1
- harmonic singing 1
- harmony singing 1
- harp 1
- heavy effects 1
- hindi film music 1
- hip 1
- hmong pop 1
- hollering 1
- hopeful 1
- house 1
- humming 1
- indian 1
- indie 1
- instructive speaking 1
- intuitive folk 1
- irish folk music 1
- italian folk music 1
- jazz ballad 1
- jewish 1
- jovial 1
- k-pop 1
- kids song 1
- korean 1
- korean indie rock 1
- laid back 1
- latin 1
- latin music 1
- latin pop 1
- loud 1
- malaysian 1
- male back vocal 1
- medium tempo 1
- melodic pad 1
- mexican folk music 1
- minor key 1
- modern 1
- modern r&b 1
- monotonous 1
- mysterious 1
- napoletana 1
- neo-folk 1
- new-age 1
- normal tempo 1
- nostalgic 1
- off-key piano 1
- out-of-tune singing 1
- passionate 1
- pastoral 1
- people shouting 1
- percussive elements 1
- percussive slap 1
- picado 1
- pingpong 1
- plucking 1
- pop soul 1
- pop-rock 1
- product review 1
- pulse effect 1
- punk rock 1
- r&b 1
- rapping 1
- reggae 1
- remix 1
- review 1
- rhythm machine 1
- rhythmic 1
- rising 1
- rock music 1
- romanian folk music 1
- samba 1
- shouting 1
- simple drum track 1
- soap opera soundtrack 1
- soap opera theme 1
- soprano 1
- soul music 1
- sound effects 1
- spiritual 1
- steel guitar 1
- story-telling mood 1
- strong bass 1
- synth 1
- tango 1
- tarantella 1
- teen pop 1
- telephone sound effect 1
- tension 1
- trap 1
- tuning 1
- tutorial 1
- tv series theme 1
- uilleann pipes 1
- unique 1
- valentines 1
- vibrato 1
- video game music 1
- vietnamese ballad 1
- vigorous 1
- vocal sample 1
- wedding music 1
- western music 1
- xiao 1
- yoga music 1
musiccaps_names (array) 88 ✖
- Music 83
- Singing 16
- Flamenco 14
- Guitar 14
- Musical instrument 14
- Plucked string instrument 14
- Acoustic guitar 11
- Bluegrass 11
- Song 9
- Country 8
- Independent music 6
- Strum 6
- Happy music 5
- Mandolin 5
- Music of Latin America 5
- Wind instrument, woodwind instrument 5
- Accordion 4
- Christian music 4
- Speech 4
- Ukulele 4
- /t/dd00004 3
- Banjo 3
- Bowed string instrument 3
- Flute 3
- Pop music 3
- A capella 2
- Bass guitar 2
- Child singing 2
- Harmonica 2
- Inside, small room 2
- Lullaby 2
- Middle Eastern music 2
- Music for children 2
- Music of Asia 2
- Music of Bollywood 2
- Sad music 2
- Salsa music 2
- Ska 2
- Swing music 2
- Tender music 2
- Traditional music 2
- Wedding music 2
- /t/dd00003 1
- Bang 1
- Bass drum 1
- Busy signal 1
- Carnatic music 1
- Cello 1
- Chant 1
- Christmas music 1
- Dance music 1
- Drum 1
- Drum kit 1
- Drum machine 1
- Drum roll 1
- Echo 1
- Electric piano 1
- Electronic tuner 1
- Exciting music 1
- Folk music 1
- Funk 1
- Gospel music 1
- Harmonic 1
- Humming 1
- Jazz 1
- Jingle (music) 1
- Jingle, tinkle 1
- Keyboard (musical) 1
- Maraca 1
- Music of Africa 1
- New-age music 1
- Outside, rural or natural 1
- Percussion 1
- Piano 1
- Ping 1
- Reggae 1
- Rimshot 1
- Roll 1
- Skateboard 1
- Snare drum 1
- Soul music 1
- Steel guitar, slide guitar 1
- Steelpan 1
- Synthetic singing 1
- Tapping (guitar technique) 1
- Television 1
- Violin, fiddle 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;