musiccaps_details (view)
17 rows where search matches "guitar", musiccaps_aspects contains "fast tempo" and musiccaps_names contains "Musical instrument"
This data as json
musiccaps_aspects (array) 166 ✖
- fast tempo · 17 ✖
- instrumental 8
- enthusiastic 5
- cheerful 4
- energetic 4
- lively 4
- rhythmic acoustic guitar 4
- rock 4
- acoustic guitar 3
- electric guitar 3
- happy 3
- live performance 3
- male vocalist 3
- metal 3
- sonic power 3
- spirited 3
- upbeat 3
- bright 2
- concert 2
- country music 2
- electric guitar lead 2
- foreign language 2
- hard rock 2
- heavy metal 2
- home recording 2
- inferior audio quality 2
- intense 2
- loud 2
- melodic 2
- passionate 2
- people talking 2
- rock and roll 2
- simple 2
- spanish guitar 2
- stringed instrument 2
- acordian harmony 1
- acoustic 12 string guitars 1
- acoustic guitar accompaniment 1
- aggressive 1
- aggressive guitar playing 1
- amateur home recording 1
- amateur recording 1
- ambient outdoor sounds 1
- ambient sounds 1
- amplified 1
- amplified guitar 1
- amplified music 1
- animated 1
- animated acoustic guitar rhythm 1
- auto harp 1
- banjo 1
- blues 1
- blues rock 1
- cello 1
- clapping 1
- clarinet 1
- classical 1
- clean notes 1
- country folk music 1
- country pop 1
- dance music 1
- death metal 1
- demonstration 1
- dense 1
- drum machine 1
- earnest singing 1
- electric guitar demo 1
- electric guitar harmony 1
- electric guitar lesson 1
- electric guitar riff 1
- electric guitar solo 1
- emotional 1
- emphatic vocals 1
- engaging 1
- entertaining 1
- fiddle 1
- fingerstile acoustic guitar 1
- folk 1
- folk music 1
- folk song 1
- fun 1
- funk 1
- fusion 1
- groovy bass line 1
- guitar arpeggio 1
- guitar lead 1
- guitar solo 1
- hand percussions 1
- hard rock instrumental 1
- heavy metalloud feed back 1
- high energy 1
- high spirited 1
- hoe recording 1
- indie rock 1
- instructional 1
- intense electric guitar 1
- jarring 1
- jazz 1
- joyful 1
- keyboard harmony 1
- latin instrumental music 1
- latin pop 1
- lead guitar 1
- light 1
- live audience 1
- lively backup 1
- lively tambourine beats 1
- lively vocals 1
- loud feed back 1
- loud feedback 1
- loud guitar feedback 1
- low quality audio 1
- male harmony 1
- male singers 1
- male vocalists 1
- male voice speaking 1
- merry 1
- minimal instruments 1
- minimalist 1
- no percussion 1
- no vocals 1
- no voice 1
- no voices 1
- outdoor singing 1
- palm muting 1
- party song 1
- passionate singing 1
- people cheering 1
- percussion 1
- perky 1
- playful 1
- pop 1
- pop rock 1
- popular song 1
- punchy drumming 1
- regional music 1
- regional song 1
- resounding 1
- reverb delay electric guitar 1
- review 1
- rhythmic guitar 1
- room acoustics 1
- shakers 1
- singing along 1
- skillful 1
- smal hand drum 1
- smooth 1
- spanish song 1
- static 1
- stringed instrument 1
- strummed electric guitar 1
- synth electric guitar solo 1
- tambourine 1
- tambourine used as hand drum 1
- tapping sound 1
- three part harmony 1
- tutorial 1
- ukele 1
- upbeat electronic drums 1
- vigorous 1
- vigorous vivacious 1
- vivacious 1
- vocal backup 1
- vocalisation 1
- wind instrument 1
- youthful 1
musiccaps_names (array) 39 ✖
- Music 17
- Musical instrument · 17 ✖
- Guitar 11
- Plucked string instrument 10
- Acoustic guitar 5
- Bluegrass 3
- Bass guitar 2
- Chorus effect 2
- Country 2
- Distortion 2
- Effects unit 2
- Electric guitar 2
- Rock music 2
- Singing 2
- Strum 2
- Tapping (guitar technique) 2
- Accordion 1
- Banjo 1
- Blues 1
- Bowed string instrument 1
- Cacophony 1
- Clapping 1
- Flamenco 1
- Funk 1
- Inside, large room or hall 1
- Mandolin 1
- Mantra 1
- Music of Latin America 1
- Outside, urban or manmade 1
- Percussion 1
- Pop music 1
- Pulse 1
- Rattle (instrument) 1
- Rock and roll 1
- Roll 1
- Song 1
- Speech 1
- Synthesizer 1
- Traditional music 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;