musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "hand claps" and musiccaps_author = 8 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- hand claps · 2 ✖
- acoustic guitar solo 1
- additive rhythm 1
- classical guitar 1
- complex chords 1
- complex rhythm 1
- duet 1
- electric guitar 1
- fast beat 1
- fast scales 1
- fast strumming acoustic guitar 1
- fiery 1
- flamenco 1
- flamenco influence 1
- flamenco strumming 1
- guiro 1
- hand percussion 1
- latin 1
- lively 1
- low tuned bass drum 1
- modern electric bass 1
- nylon string guitar 1
- passionate 1
- passionate female singer 1
- quick tempo 1
- spanish guitar 1
- tambourine 1
- virtuosic 1
- wah 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Flamenco guitar and dance | A fiery, passionate flamenco duet between a nylon string guitar player and a clapping dancer. The guitar playing is virtuosic, employing flamenco strumming and fast scales. The rhythms are complex and additive. | 2006-05-24T23:46:57Z | AIRE Artists Agency | Fantastic flamenco piece - Tangos Rompeserones by Moraito - covered by Przemyslaw Haluszczak. Video presents the polish flamenco guitarists from Poznan accompanied with a drummer (palmas) + a female flamenco dancer. | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["flamenco", "duet", "spanish guitar", "classical guitar", "nylon string guitar", "hand claps", "virtuosic", "fast scales", "flamenco strumming", "additive rhythm", "complex rhythm", "fiery", "passionate"] | 8 | IwqD859w2_E | 1955 | |
( Rumba ) Parrita & Canelita " Remix " Dj Barajero | Latin music featuring a quick tempo, hand percussion, tambourine, lively hand claps, guiro, a low tuned bass drum, an acoustic guitar solo with a wah effect, flamenco inspired fast acoustic guitar strumming, complex chords and a modern electric bass sound supporting a passionate female singer. | 2011-05-27T11:41:49Z | DJ Barajero | Parrita Canelita Remix Dj Barajero Flamenco Rumba Salsa Reggueton Verano Nuevo 2011 2012 2013 | ["Flamenco", "Music", "Music of Latin America"] | ["latin", "low tuned bass drum", "lively", "electric guitar", "wah", "acoustic guitar solo", "hand percussion", "fast strumming acoustic guitar", "flamenco influence", "tambourine", "guiro", "passionate female singer", "complex chords", "fast beat", "modern electric bass", "hand claps", "quick tempo"] | 8 | YzpzKyzyL0Y | 3331 |
Advanced export
JSON shape: default, array, newline-delimited
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;