musiccaps_details (view)
4 rows where musiccaps_author = 8 and musiccaps_names contains "Music of Latin America"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| ( 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 | |
| Brooklyn Elbert & Kassidy King sing "How Does She Yodel" 2011 Christmas | A quiet recording of two female singers participating in a yodeling call and response section, accompanied by accordion, drum kit, bass and guitar playing a steady oompah beat. The chord progression is simple and the mood is fun and silly. | 2012-01-28T00:04:23Z | LilCutieBittys | 10 year olds- Brooklyn Elbert and Kassidy King of Avery and The Calico Hearts perform a duet to "How Does She Yodel" in which they both show off their country twang, natural break abilities, and harmonizing yodeling skills. Brought the house down (second year in a row). Trivia fact: This is Kassidy's 4th year to sing this song at a Cactus Christmas show. Great way to see both of these girls, who usually sing back up to Avery (Winter), featured prominently. The girls are students of Terri Caldwell Music under the direction of Cami Caldwell. Intro by Terri Caldwell. Video by Johnny Busby. Taken at the Cactus Kids Christmas show December 2011 at the Cactus Theater in Lubbock, Texas. | ["Singing", "Yodeling", "Music", "Music of Latin America"] | ["quiet recording", "yodeling duet", "call and response", "two female vocalists", "oompah", "accordion", "simple chord progression", "drum kit", "guitar", "fun", "silly"] | 8 | qaQjG9SwORU | 4799 | |
| Frankie Ruiz - Bailando | Cheery, upbeat Latin music featuring a lively male singer, busy percussion including hand percussion like bongos and congas as well as cowbell and more. String bass plays a syncopated tumbao rhythm while a brass section accompanies a trombone. | 2008-02-09T16:00:37Z | jjaime99 | Frankie Ruiz | ["Singing", "Music of Latin America"] | ["latin", "busy percussion", "brass section", "trombone", "lively male singer", "tumbao", "syncopated bass", "hand percussion", "bongos", "congas", "string bass", "cowbell", "upbeat", "cheery"] | 8 | w62KGC7um_Y | 5240 |
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;