musiccaps_details (view)
4 rows where musiccaps_aspects contains "country rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- country rock · 4 ✖
- acoustic 1
- amateur recording 1
- ambient sounds 1
- banjos 1
- bass guitar 1
- charged up 1
- clapping 1
- concert 1
- country blues 1
- country song 1
- dixie chicks concert 1
- electric guitar 1
- electric guitar lick 1
- energetic 1
- entertaining 1
- enthusiastic 1
- fans cheering 1
- female vocalists 1
- folk 1
- girl band 1
- grungy electric guitar 1
- high octane 1
- hysteria 1
- incoherent sound 1
- live audience 1
- live performance 1
- male voice 1
- medium tempo 1
- moderate tempo 1
- rock 1
- romantic mood 1
- simple percussion 1
- simple rock drumming 1
- southern 1
- twangy electric guitar arpeggios 1
- world music 1
- youthful 1
musiccaps_names (array) 12 ✖
- Music 3
- Bang 1
- Blues 1
- Country 1
- Electronic music 1
- Independent music 1
- Jazz 1
- Progressive rock 1
- Rock and roll 1
- Rock music 1
- Singing 1
- Song 1
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
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;