musiccaps_details (view)
5 rows where musiccaps_aspects contains "virtuosic" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- virtuosic · 5 ✖
- fast beat 2
- simple chord progression 2
- yodeling 2
- additive rhythm 1
- beat boxing 1
- bluegrass 1
- classical guitar 1
- complex rhythm 1
- complex rhythms 1
- country 1
- digeridoo 1
- duet 1
- electric bass 1
- electric piano 1
- fast 1
- fast scales 1
- female and male yodeling 1
- fiddle 1
- fiery 1
- flamenco 1
- flamenco strumming 1
- guitar 1
- hand claps 1
- high melody 1
- male singer 1
- male vocalist 1
- manic 1
- nylon string guitar 1
- oompah 1
- operatic 1
- organ 1
- passionate 1
- piano 1
- professionally trained 1
- simple rhythms 1
- spanish guitar 1
- steady bass and drums 1
musiccaps_names (array) 19 ✖
- Music 5
- Yodeling 2
- Acoustic guitar 1
- Christian music 1
- Christmas music 1
- Didgeridoo 1
- Flamenco 1
- Gospel music 1
- Guitar 1
- Jingle (music) 1
- Lullaby 1
- Music of Africa 1
- Music of Latin America 1
- Musical instrument 1
- Opera 1
- Plucked string instrument 1
- Singing 1
- Song 1
- Vocal music 1
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 | |
Ondrej Smeykal Playing a Chad Butler Didgeridoo | solo performance of a virtuosic didgeridoo player playing a fast beat with complex rhythms. Sounds like beat boxing. | 2008-09-17T01:43:06Z | · Michael Medina | Ondrej Smeykal Playing a Chad Butler Didgeridoo. This was didgeridoo number 360 and was available at https://bhumsiva.com/galery?gallery=360 | ["Didgeridoo", "Music"] | ["digeridoo", "virtuosic", "complex rhythms", "fast beat", "beat boxing"] | 8 | RGTWqZoswAo | 2686 | |
Toque Celular- Crazy Yodeling | A virtuosic Male yodeler accompanied by an oompah band playing a fast beat and simple chord progression with electric bass, piano, fiddle, and drums. The feeling is manic. | 2009-10-18T18:13:22Z | Pedro Júnior | Tune Cellphone Song Music- Yodeling ioleleihu ioleleiu io-lele-i-hu | ["Music of Africa", "Yodeling", "Jingle (music)", "Music", "Music of Latin America"] | ["yodeling", "oompah", "simple chord progression", "fast beat", "electric bass", "male vocalist", "virtuosic", "piano", "fiddle", "manic"] | 8 | TqWmuwAYmnI | 2869 | |
Buzz Goertzen - The Idaho Yodeler - TheIdahoYodeler.com | A female and male duo yodeling over a fast bluegrass band. The bass and drums are steady and simple as is the chord progression. The guitarist and other instrumentalists are virtuosic. | 2011-03-30T18:33:50Z | theidahoyodeler | Nothing stirs up an audience like yodeling, and no one yodels like Buzz Goertzen. His charismatic personality, wit and unique style have endeared him to audiences everywhere. Being also a gifted songwriter as well as a humorist, it is no wonder that standing ovations are the norm wherever he performs. He has written most of his own compositions, but also sings many of the "old favorite" yodeling songs of the past. Visit his website today at www.TheIdahoYodeler.com | ["Christmas music", "Singing", "Gospel music", "Yodeling", "Christian music", "Music", "Song"] | ["yodeling", "female and male yodeling", "country", "fast", "bluegrass", "steady bass and drums", "guitar", "virtuosic", "simple rhythms", "simple chord progression"] | 8 | Y7mTjfgcybQ | 3256 | |
Ivan Ozhogin - The Jewish lullaby | A professionally trained operatic male singer singing a difficult, high melody accompanied by organ and electric piano. | 2011-06-29T21:31:44Z | MrTweens | Иван Ожогин - Еврейская колыбельная (с) Елена Сорокина Архиповский музыкальный салон, 25.05.2011 | ["Music", "Opera", "Lullaby", "Vocal music"] | ["male singer", "operatic", "electric piano", "organ", "professionally trained", "high melody", "virtuosic"] | 8 | xvryKn-V-JM | 5364 |
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;