musiccaps_details (view)
10 rows where musiccaps_author = 3 and musiccaps_names contains "Country"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Susie & Mick Darling - Rattle Tattle Gypsy | This is the performance of an Irish folk song using a banjo and a mandolin. The singer is elderly and the guitars are layered. The banjo is used to play a simple motif that revolves around two chords. | 2012-08-26T21:47:41Z | Teesside Steve | Friday 24th August 2012 - http://www.fb.com/saltburnopen | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass", "Bowed string instrument"] | ["live performance", "low quality audio", "folk music", "banjo", "mandolin", "irish bouzouki guitark", "irish folk singing", "eldery male vocals"] | 3 | 0hfU27A6tus | 199 | |
| Mumford & Sons - Sigh No More (Free Album Download Link) | This is a quintessentially folk-rock song, with at least a three-part country-folk harmony. There is an acoustic guitar arpeggio throughout the clip, and a powerful stab on the bass strings every second bar. The song feels sombre, in a way. | 2011-05-23T13:02:11Z | montana8804 | Free Album Download Link: http://bit.ly/igQOpr Mumford & Sons - Sigh No More Sigh No More | ["Country", "Music"] | ["folk rock", "acoustic guitar", "folk harmonies", "country-folk", "powerful guitar stabs", "repeated vocal motif"] | 3 | DA3fNvbZoBM | 1446 | |
| She Thinks I Still Care | The song is a slow country song - a country ballad played on a steel guitar. This is the type of song that would be suitable for an old country western movie where a hero character walks into a diner. This is a live recording and the song has a slow tempo. | 2010-08-27T01:59:11Z | Terry Wisdom | My dog is my most loyal audience, She never cares when I make a mistake. She just loves steel guitar. | ["Country", "Music", "Steel guitar, slide guitar", "Plucked string instrument"] | ["steel guitar", "country music", "live recording", "slow country music", "country ballad", "arpeggio", "intricate steel guitar playing", "country western", "vintage country"] | 3 | DHo1z0_ZUNA | 1461 | |
| Orthodox Celts - Green Roses | This is a folk rock song with a strong Irish influence. We hear a typical Irish fiddle tune played on the violin - as the leading melodic motif for the instruments. The singer has a burly rock and roll voice and the song just has a general feel-good aura to it. | 2009-10-27T12:26:56Z | BicycleFanatic89 | Orthodox Celts - Green roses Album : Green Roses 1999, Metropolis | ["Country", "Music", "Bluegrass"] | ["irish influence", "irish fiddle sound", "folk rock", "irish folk rock", "violin motif", "burly male rock vocal", "simple folk drum beat"] | 3 | E4To9BC2jx8 | 1530 | |
| Cow Girl (Comedy Country Music Video) | This is a country folk song with a generally positive, cheerful and joyful vibe to it. The singer is a man with an elderly voice that has a quality that sounds like a gurgle. His style of singing and the content of lyrics and melody are similar to hearing a story being told. There aren't really any rhyming lyrics - it's more like he is telling a story in song form. There are licks being played on an electric guitar, as well as certain motifs on the violin in between particular phrases by the singer. | 2013-07-31T05:05:40Z | Papa Darwell | Darwell and The Risktaker Band filmed at Darwell's Cafe Long Beach Ms | ["Country", "Music", "Pop music", "Middle Eastern music", "Bluegrass", "Exciting music"] | ["country folk music", "electric guitar licks", "violin lick", "elderly raspy male country vocal", "intricate bassline", "country", "southern", "vibrant piano playing", "cheerful", "storytelling style singing", "joyful"] | 3 | GFGwPa9d9XQ | 1702 | |
| Star Wars Theme - Double Bass Solo | This is an instrumental track featuring the double bass and acoustic guitar. Initially, chords are strummed on the acoustic guitar, and then arpeggio notes are played. The double bass is played with a bow and plays the leading melodic motif in the song. The song feels like it would be suitable in an adventure movie. | 2015-12-22T22:50:11Z | TESEO | Star Wars Theme - Double Bass Solo - Plays Francesco Tesei - New Fan Page https://www.facebook.com/Teseoguitar - SUBSCRIBE! http://www.youtube.com/user/teseoguitar?sub_confirmation=1 | ["Country", "Music", "Wedding music"] | ["double bass", "acoustic guitar", "guitar arpeggios", "fantasy", "exciting"] | 3 | X6Q53uXgaHc | 3161 | |
| Country Swing Dancing - Moves Tricks Lifts Aerials Dips Flips | The song is a country rock song with a charged up, potent sound. The guitar is grungry, and gives punchy and gritty energy. The singer has a smooth voice and sings with charisma and suave charm. | 2011-06-06T20:49:56Z | ForeverCountryDancing | Check out more dance clips and country swing dance instruction on our YouTube channel and https://forevercountry.intelivideo.com/. Purchase your Forever Country t-shirt at https://www.redbubble.com/people/forevercountry3/explore?asc=u&page=1&sortOrder=recent | ["Country", "Music", "Rock and roll"] | ["country rock", "banjos", "grungy electric guitar", "simple rock drumming", "electric guitar lick", "charged up", "high octane", "rock"] | 3 | ewI4q7_4TBQ | 3910 | |
| Country Music Top Hits 1956- 2011 | This features two clips from country songs. The first song is upbeat, and suitable for rhythmic and groovy dancing. The second song is slower and features a group of male vocalists harmonising. The overall feeling is a country midwestern feel. | 2011-04-28T19:59:30Z | billboardcountry1 | ["Country", "Traditional music", "Music", "Rhythm and blues", "Soul music"] | ["country music", "old schol", "vintage country music", "country folk music", "two songs", "group male harmony vocals", "upbeat", "upright bass guitar"] | 3 | jd1IS7N3u0I | 4267 | ||
| Sam Bush and the Infamous Stringdusters | This is a fun, upbeat country folk song. We hear a banjo player strum rapidly and then go on to do a solo. We hear cheering and clapping fans, intricate basslines and acoustic guitars being rapidly strummed. It's a fun, uptempo song that would be heard in a barnyard. | 2007-08-19T18:07:06Z | Nina | Otis Mountain Festival, Elizabethtown, NY. 8/18/07 | ["Country", "Guitar", "Music", "Musical instrument", "Tambourine", "Plucked string instrument", "Bowed string instrument"] | ["live country folk band", "folk music", "fast paced", "uptempo", "energetic", "banjo playing", "acoustic guitar strumming", "live recording", "poor audio quality", "crowd cheering", "crowd clapping", "fun", "barnyard"] | 3 | puAclKsCbes | 4741 | |
| Cool Accordion Girls - accordeon music mix acordeon crazy power players Akkordeon fisarmonica | Here we have a compilation of songs led by accordions. The first clip is more of a folk ballad with a cheery and uplifting tone to it, the second clip is an emotional ballad. | 2014-03-27T14:23:04Z | Accordeon Accordion Jo Brunenberg | WARNING! Do not take this compilation too seriously :-) It is a compilation with a wink and a smile..... For really serious accordion compilations (10 minutes each) see: CLASSICAL ACCORDION https://youtu.be/2qDCQ3S2Ajo and: MODERN ACCORDION https://youtu.be/_s9dgvFt7Rc JAZZ ACCORDION https://youtu.be/SmiwE7mjtfM Accordion players from amateur to punk. From amateur, to just funny or very professional players. Extremely different accordion styles - Accordion fun. Cool Girls and Ladies playing Accordion. Real Power Players - Chica acordeón. Amazing funny accordion power players, just for fun. Akordeon Muzyka. This video has been included in "Best Accordion Videos": http://accordionvideos.info Featuring amongst many others: "Gipsy girl" Maria Selezneva, Pamela Souriau, Isabelle Lépinay, Accordion Babes, Laurie Black, Kanako Kato, Queen Joan, Christine Schmid, Die Twinnies - Bayernmädels, Ksenija Sidorova, Zoe Tiganouria, あんざいのりえ , accordion girl Melissa Elledge, Miss Natasha Enquist, Ingrid Gatin, Kimberley Pritchard, Sophie's Smokin' Squeezebox, Mllelauriem, Phoebe Legere, Treol, Группа Невесты, Valentina Bajkova, Svetlana Podshivalova, Renee De La Prade, Monsters of Accordion, Ansambel Cebelce - Cebelca , Elena Volodya.... LINKS TO THE ORIGINAL VIDEOS: 0.00 0.08 https://youtu.be/vWOEfwffKxM 0.16 https://youtu.be/BvWLQp7pOp8 0.23 https://youtu.be/aspe3-Wr3dw 0.29 https://youtu.be/YtoXQ8nOuKk 0.36 https://youtu.be/zFlVn0upPo0 0.43 https://youtu.be/6MBfsh1iy_E 0.51 https://youtu.be/g74LyeBT--E 1.00 https://youtu.be/AeyBpqI5LRE 1.05 https://youtu.be/7-Q5uDwhBL0 1.10 https://youtu.be/igoeqWxRg98 1.19 https://youtu.be/G1gNNbqENug 1.23 1.29 https://youtu.be/1QN4NyD6l8A 1.38 https://youtu.be/7LT2TCu31MM 1.47 https://youtu.be/-_es5g6KCVI 1.57 https://youtu.be/XKqcBx5Rp8Q 2.08 https://youtu.be/3nsAdkchlOk0.00 2.16 https://youtu.be/YZNZZTvmm4c 2.24 https://youtu.be/tBUishjdqrg 2.33 https://youtu.be/mdKH5OoKaOg 2.36 https://youtu.be/xDaX5Bs_oqo 2.43 https://yo… | ["Country", "Music"] | ["accordions", "folk music", "emotional accordion ballad", "piano", "live performances"] | 3 | vo-o3dG8Oq0 | 5205 |
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;