musiccaps_details (view)

4 rows where musiccaps_aspects contains "country rock"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Rosie and The Originals - Angel Baby - Rare FULL Version We hear a twangy electric guitar on which some arpeggiated chords are played. The music style is a bluesy country rock style. 2013-06-07T03:47:56Z PJDooWop Here's the full version. For some reason there are a lot of edited versions floating around that cut off the instrumental break and the ending. I don't think I ever heard the full ending of this on NY radio, but here is the entire recording for your enjoyment ["Blues", "Jazz"] ["twangy electric guitar arpeggios", "country rock", "country blues", "southern"] 3 KikHXfUanJk 2110
Indie Music Streaming - 6 Years This country rock song features a male voice singing at a high pitch. This is accompanied by percussion playing a simple beat. A guitar strums chords. The bass guitar plays the root notes of the chords. The mood of this song is romantic. This song can be played in a romantic movie. 2015-07-09T03:30:11Z Music Lesson Central Indie Music Streaming Music Lesson Central - Learn How To Play Music Learn Guitar, Piano, Bass, Drums, Harmonica, and Mandolin ["Music", "Independent music", "Rock music", "Song", "Progressive rock"] ["country rock", "male voice", "moderate tempo", "bass guitar", "electric guitar", "simple percussion", "romantic mood"] 0 WeDA1mDFSCo 3120
Dixie Chicks Taking the Long Way Live A girl band sings this lively song. The tempo is medium with vibrant music. The audio quality is inferior so the music and vocals are incoherent. This is a live performance with ambient sounds of fans cheering, clapping and singing along. This song is a hit Country Rock. 2006-08-02T22:04:41Z Susanne Goldstone Rosenhouse Live from Madison Square Garden. Natalie's introduction to New York fans then Taking the Long Way Live. Oh, and a little bit of me singing along and cheering. Didn't know my camera would pick that up. :) Hope y'all enjoy! ["Singing", "Electronic music", "Music", "Bang"] ["female vocalists", "medium tempo", "live performance", "country rock", "folk", "world music", "acoustic", "country song", "youthful", "enthusiastic", "energetic", "entertaining", "folk", "concert", "incoherent sound", "amateur recording", "live audience", "girl band", "dixie chicks concert", "ambient sounds", "fans cheering", "clapping", "hysteria"] 7 aGMdcxeF6Ak 3524
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;