musiccaps_details (view)
51 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_author = 7
This data as json
musiccaps_aspects (array) 522 ✖
- acoustic guitar · 51 ✖
- instrumental 17
- keyboard harmony 15
- emotional 14
- fast tempo 14
- male singer 13
- medium tempo 13
- soft 13
- mellow 12
- slow tempo 12
- steady drumming 11
- sentimental 10
- melodic 9
- cello 8
- male vocalist 8
- romantic 8
- banjo 7
- dulcet 7
- electric guitar 7
- keyboard accompaniment 7
- mandolin 7
- amateur recording 6
- country music 6
- country pop 6
- duet 6
- energetic 6
- happy 6
- medium fast tempo 6
- soothing 6
- youthful 6
- auto harp 5
- clapping 5
- fiddle 5
- passionate 5
- vocalisation 5
- world music 5
- animated 4
- calm 4
- cheerful 4
- country song 4
- enthusiastic 4
- folk music 4
- foreign language 4
- groovy 4
- home video 4
- live performance 4
- love song 4
- peppy 4
- pleasant 4
- poignant 4
- pop 4
- resonator 4
- simple melody 4
- vivacious 4
- vocal backup 4
- ambient 3
- bongos 3
- buoyant 3
- cheering 3
- children’s song 3
- choral harmony 3
- concert 3
- country hits 3
- dreamy 3
- funky bass line 3
- guitar tuning 3
- home recording 3
- lively 3
- loud 3
- melancholic 3
- mellifluous 3
- melodious 3
- merry 3
- minimalist 3
- nostalgia 3
- people talking 3
- playful 3
- regional music 3
- regional pop 3
- serene 3
- spirited 3
- story telling 3
- violin symphony 3
- animated vocals 2
- atmospheric 2
- atmospheric synthesiser 2
- bluegrass 2
- blues 2
- boomy 2
- calming 2
- catchy 2
- chanting 2
- chimes 2
- country folk music 2
- crowd cheering 2
- cymbals 2
- digital drum 2
- educational 2
- emphatic vocals 2
- euphonious 2
- female singer 2
- fervent 2
- fingers snapping 2
- folk pop 2
- folk song 2
- fresh 2
- gig 2
- groovy bass 2
- groovy bass line 2
- indian classical 2
- inferior audio quality 2
- informative 2
- intense drumming 2
- latin dance music 2
- latin pop 2
- latin song 2
- learning 2
- live audience 2
- lively vocals 2
- lonely 2
- monotone 2
- muffled audio 2
- no melody 2
- peaceful 2
- perky 2
- proposal song 2
- puja 2
- raga 2
- reggae 2
- rhythmic drumming 2
- rock 2
- sad 2
- shakers 2
- sharp 2
- slick drumming 2
- soul 2
- soulful 2
- straight bass lines 2
- string harmony 2
- string instrument 2
- synthesiser arrangements 2
- vibrant 2
- violin 2
- violin harmony 2
- violins 2
- vocal harmony 2
- wind instrument 2
- abrupt end 1
- accordion melody 1
- acoustic bass 1
- aesthetic 1
- affecting 1
- african 1
- african percussion 1
- alap 1
- alternative pop 1
- alternative rock 1
- alto 1
- amateur 1
- amateur audio recording 1
- amateur musicians 1
- amateur singer 1
- ambient noises 1
- amplified 1
- amplified guitar 1
- animated guitar 1
- animated music 1
- animated percussions 1
- animated sounds 1
- artist 1
- audio 1
- backup harmony 1
- banjo riff 1
- baritone 1
- bass drum 1
- bass guitar 1
- beautiful 1
- beep 1
- bells 1
- beseeching 1
- bollywood 1
- bollywood retro 1
- booming sounds 1
- boomy bass lines 1
- boomy drumming 1
- boys having fun 1
- brass band 1
- brass instrument 1
- breakup song 1
- bright drumming 1
- bright violin 1
- busking 1
- cajun 1
- cajun beat 1
- camera sounds 1
- captivating 1
- celebration 1
- celebratory 1
- cello bass 1
- celtic 1
- censored lyrics 1
- chaotic 1
- charming 1
- cheering clapping 1
- children vocals 1
- children’s ryymes 1
- choral backup 1
- chord progression 1
- chords 1
- christian gospel song 1
- christian music 1
- christian song 1
- christmas carol 1
- christmas carols 1
- christmas cheer 1
- christmas greeting 1
- christmas songs 1
- christmas time 1
- chrost 1
- classic 1
- classic pop 1
- classical 1
- clicking sound 1
- closing riff 1
- club musc 1
- club music 1
- colourful 1
- complex chords 1
- complex harmony 1
- congas 1
- contemporary 1
- country folk 1
- country folk song 1
- country folk songs 1
- country love song 1
- country song hits 1
- country songs 1
- cymbal ride 1
- cymbal rides 1
- dance groove 1
- dance grove 1
- dance music 1
- dance pop 1
- devotional 1
- dissonant booming sounds 1
- dobro 1
- dream pop 1
- droning keyboard harmony 1
- drunk singing 1
- earnest 1
- edm 1
- elctronic music 1
- electrifying 1
- electronic music 1
- electronically arranged sounds 1
- empahtic vocals 1
- enchanting 1
- engaging 1
- enigmatic 1
- enthusiastic spanish guitar 1
- ethereal 1
- excishakers 1
- falling in love 1
- female singing 1
- female vocal backup 1
- female vocalisation 1
- female vocalist 1
- female vocalists 1
- festive 1
- finger style guitar 1
- first love 1
- flageolet 1
- flute like instrument 1
- flute melody 1
- fog horn 1
- folk 1
- folk lyrics 1
- free style guitar 1
- french carols 1
- french song 1
- fun 1
- funk/soul 1
- funky 1
- funky bass lines 1
- funny 1
- funny song 1
- giggling 1
- godfather 1
- godfather theme 1
- groovy bass lines 1
- group singing 1
- guitar 1
- guitar lead 1
- guitar solo 1
- guitar string plonk 1
- guitar tuning tutorial 1
- guitar tutorial 1
- happy song 1
- harmonium accompaniment 1
- harmonizing 1
- high energy 1
- high-spirited 1
- hillbilly music 1
- hindi song 1
- hindu mythology 1
- hindustani classical 1
- hissing sound 1
- hooting sound 1
- how to tune a guitar 1
- husky voice 1
- hymns 1
- idyllic 1
- improvisation 1
- inaudible 1
- incoherent vocals 1
- indian devotional song 1
- indian music 1
- indian mythology 1
- indie pop 1
- infectious drum grooves 1
- inferior sound quality 1
- insightful 1
- insistent rhythm 1
- instructor 1
- introduction music 1
- jazz 1
- joyful 1
- karaoke 1
- keyboard arrangement 1
- khartal 1
- kids screaming in joy 1
- kindergarten song 1
- latin dance 1
- latin dance hits 1
- latin music 1
- latin regional 1
- latin urbano 1
- laughing 1
- lead harmony 1
- learning to tune a guitar 1
- lecture 1
- light 1
- lively backup 1
- lively cello 1
- lively mandolin 1
- lively sitar 1
- lively spirited 1
- lively trumpets 1
- lively violin 1
- lively vocal backup 1
- lonely sad 1
- longing 1
- loud feedback 1
- low to high note 1
- low to high notes 1
- lucid 1
- lullaby 1
- male harmony 1
- male vocalists 1
- male voice 1
- male voice speaking 1
- male voice talking 1
- mandira taal 1
- mandira taal percussion 1
- mantras 1
- meditation 1
- meditative 1
- medium harmony 1
- melancholy 1
- mellifluent 1
- mellow tune 1
- melodious harmony 1
- melodious viloin 1
- mezzo-soprano 1
- mind stimulating 1
- minimal instrumentation 1
- minimal instruments 1
- minimalist music 1
- monotone singing 1
- mood 1
- movie soundtrack 1
- muddled 1
- muddled audio 1
- muffled guitar quality 1
- muffled sounds 1
- multi vocalists 1
- naughty 1
- no instrumentation 1
- no percussions 1
- nostalgic 1
- nursery rhyme 1
- of static 1
- old-time country rock 1
- orchestral music 1
- organ 1
- parade 1
- party song 1
- pensive 1
- people talking in background 1
- pepeasant 1
- percussion grooves 1
- performance 1
- performer 1
- piano accompaniment 1
- pipe organ 1
- pleading 1
- pop hits 1
- pop music 1
- pop rock 1
- popular music 1
- praise and worship 1
- prayer 1
- pulsating 1
- punch digital drum beat 1
- punchy 1
- punchy beat 1
- punchy drumming 1
- pure 1
- r&b 1
- raaga 1
- recorder 1
- reflective 1
- regretful 1
- repetitive 1
- request 1
- resonator guitar 1
- resounding 1
- resounding sound 1
- retro music 1
- reverb 1
- rhythmic 1
- rhythmic counter play 1
- rhythmic guitar 1
- romantic piano accompaniment 1
- room acoustics 1
- sentimental nostalgic 1
- sharp sound 1
- simple 1
- simple bass lines violin hamony 1
- simple groove 1
- simple harmony 1
- simple lyrics 1
- simplicity 1
- slows down to a rhythmic melody 1
- soft bass 1
- soft melodious 1
- soft piano 1
- soft piano accompaniment 1
- soft rock 1
- soft vocals 1
- sombre 1
- song climax 1
- song end 1
- songs for children 1
- songs for kids 1
- sonic power 1
- soprano 1
- soulfu 1
- soulfulromantic 1
- sound of bubbling 1
- sound of horn 1
- sound of static 1
- southern rock 1
- speech like singing 1
- spirited string arrangement 1
- sprechstimme 1
- stage performance 1
- static 1
- steady bass 1
- steady bass lines 1
- stifled laughter 1
- string instrument tuning 1
- string instruments 1
- string orchestra 1
- strong drum beats 1
- suggestive 1
- sunny 1
- super imposed male voice 1
- sweet 1
- swing 1
- swing beat 1
- swishing sound 1
- syncopated bass lines 1
- synth arrangements 1
- synthesiser 1
- synthesiser articulation 1
- tala 1
- tambourine 1
- tambourine beats 1
- teaching to tune a guitar 1
- temple bells 1
- thumping music 1
- timeless 1
- toddlers 1
- trance 1
- trombone 1
- trumpet 1
- trumpets 1
- tutorial 1
- ukele 1
- ukele melody 1
- ukelele 1
- upbeat 1
- vibrations 1
- vigorous at the onset 1
- vigorous banjo 1
- vigorous drumming 1
- vigorous tabla introduction 1
- viola 1
- vocal emphasis 1
- warm 1
- water boiling 1
- water bubbling 1
- wedding song 1
- whistle 1
- whistle harmony 1
- whistling 1
- white christmas 1
- white noise 1
- wistful 1
- xylophone 1
- young love 1
musiccaps_names (array) 61 ✖
- Music 48
- Musical instrument 8
- Guitar 7
- Plucked string instrument 7
- Singing 7
- Acoustic guitar 5
- Country 5
- Banjo 4
- Bluegrass 4
- Reggae 4
- Strum 4
- Electronic tuner 3
- Song 3
- Ukulele 3
- Christian music 2
- Effects unit 2
- Exciting music 2
- Folk music 2
- Funk 2
- Happy music 2
- Mantra 2
- Soul music 2
- Steel guitar, slide guitar 2
- Swing music 2
- Tap 2
- Tender music 2
- Wedding music 2
- Background music 1
- Bass guitar 1
- Beep, bleep 1
- Blues 1
- Carnatic music 1
- Choir 1
- Chorus effect 1
- Christmas music 1
- Crowd 1
- Distortion 1
- Dubstep 1
- Electric guitar 1
- Electronic dance music 1
- Flamenco 1
- Flute 1
- Gospel music 1
- Jazz 1
- Jingle (music) 1
- Mandolin 1
- Music of Africa 1
- Music of Bollywood 1
- Rattle (instrument) 1
- Rhythm and blues 1
- Rock and roll 1
- Rock music 1
- Roll 1
- Sad music 1
- Salsa music 1
- Sitar 1
- Spray 1
- Tapping (guitar technique) 1
- Theremin 1
- Vocal music 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;