musiccaps_details (view)

5 rows where musiccaps_aspects contains "male vocal" and musiccaps_names contains "Bluegrass"

✎ 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
Johnny Cash Your Own Personal Jesus Music Video This is a country/Americana music piece. There is a male vocalist with a gravelly voice singing in the lead. An acoustic guitar is playing a simple tune. There is a faint percussive element that can be heard in the background that resembles pinched harmonics coming from a guitar. The atmosphere is melancholic. This piece could be used in the soundtrack of a drama movie or a TV show during a scene of introspection where a character is experiencing dark thoughts. 2008-01-30T02:15:17Z bayekane Johnny Cash Your Own Personal Jesus Music Video ["Country", "Music", "Bluegrass"] ["country", "americana", "rock", "male vocal", "gravelly voice", "acoustic guitar", "percussion", "melancholic", "sentimental", "steady tempo"] 9 6OcoDIrbMtY 750
Blue Grass Gospel This is a bluegrass gospel piece. The multitrack male vocalist is singing religious lyrics loudly. For the melodic background, a banjo and a violin is playing the tune while a bass guitar is providing the rhythmic background. The atmosphere is hopeful. This song could be used in Christian religious social media content. 2013-02-05T18:42:42Z slickerflicker Music by IIIrd Tyme Out 1ST Song Title: I Want To Stroll Over Heaven 2ND Song Title: Across The Miles Photography & Video by slickerflicker Sunset captured 1 31 13 Dedicated to My Wife Deborah on Her Birthday ["Gospel music", "Country", "Music", "Song", "Bluegrass"] ["bluegrass", "gospel", "male vocal", "violin", "banjo", "bass guitar", "christian", "religious", "hopeful", "optimistic"] 9 CAL5CgkKkR4 1338
Old Ground Hog This is an American folk music piece. There is a male vocalist singing in the folk style. The banjo is playing a cheerful melody at a steady tempo. The atmosphere of the piece is cozy and easygoing. This piece could be playing in the background at a roadside diner. It could also be included in the soundtrack of a movie or a TV show taking place in rural USA. 2009-10-23T23:49:03Z guy wolff Here is one in double C capoed at the fourth fret and the fifth string tuned drone to the second string . It is one we all learned from the Folkways record from the early 60's "Music from Clarence Tom Ashley's " this song played by Doc Watson . It is one of the first songs I ever learned on Banjo . Today I like playing this in Double C tuning ["Banjo", "Guitar", "Music", "Mandolin", "Musical instrument", "Song", "Bluegrass"] ["american folk music", "male vocal", "folk singing", "banjo", "cheerful", "cozy", "easygoing", "steady tempo"] 9 QK-mjNg8cPo 2613
fuel - in bluegrass style - iron horse This is a bluegrass cover of an originally heavy metal music piece. There is a male vocalist singing melodically in the lead. The tune is being played by the banjo, the mandolin and the acoustic guitar while the bass guitar is playing in the background. The atmosphere is playful and there is a rural feel to the piece. This piece could be used in the soundtrack of a comedy movie that takes place in the rural parts of the USA. 2007-09-19T18:28:14Z oddis123 Fade to Bluegrass Tribute to Metallica is available at http://www.cmhrecords.com on iTunes and retailers nationwide. Kirk Hammett also likes this tribute! Check out the interview here: http://youtube.com/watch?v=jdh_0H77Dkc ["Country", "Music", "Bluegrass"] ["bluegrass", "cover", "male vocal", "melodic singing", "banjo", "mandolin", "acoustic guitar", "bass guitar", "playful", "easygoing", "rural"] 9 _AVegKwklcg 3451
RALPH STANLEY WITH CJ THE DJ "WHITE DOVE" This is an American folk music piece. There is a male vocal singing melodically as the lead and there is a male back vocal accompanying the lead in different harmonies. The melody is composed of a rich amalgam of chordophones such as the fiddle, the acoustic guitar, the bass guitar and the banjo. The atmosphere is easygoing but melancholic. This piece could be playing in the background at an American diner or a pub. It could also work well in the soundtrack of a movie taking place in rural USA. 2011-02-01T02:16:16Z elizabethmoore1980 RALPH STANLEY WITH CJ THE DJ FROM NEW CD "MUSIC AMONG FRIENDS" WHITE DOVE ["Music", "Bluegrass"] ["american folk music", "country", "male vocal", "male back vocal", "folk singing", "fiddle", "acoustic guitar", "banjo", "bass guitar", "cozy", "easygoing", "melancholic", "slow tempo"] 9 wT2Y0DCq5LI 5270

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;