musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "upright bass" and musiccaps_aspects contains "violin"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 21 ✖
- upright bass · 3 ✖
- violin · 3 ✖
- acoustic guitar 2
- acoustic drums 1
- amateur recording 1
- banjo 1
- country music 1
- country/blues 1
- country/folk 1
- drums 1
- e-guitar 1
- electric guitar 1
- electric keys 1
- hard-hitting 1
- lively 1
- male and female voices singing 1
- male vocal 1
- mandolin 1
- medium to uptempo 1
- preach-like singing 1
- uptempo 1
musiccaps_names (array) 10 ✖
- Music 3
- Banjo 1
- Blues 1
- Bowed string instrument 1
- Electric guitar 1
- Musical instrument 1
- Rock and roll 1
- Ska 1
- Song 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
David Peterson "Rattlesnakin' Daddy" | The drums and the upright bass are playing in a bluesy, country vibe with a half open hi hat. An acoustic guitar is strumming chords that are almost not noticeable. The e-guitar is playing a loud lead melody in the foreground while a violin is playing short bowed notes along. This is an amateur recording. This song may be playing in a bar. | 2009-04-23T02:23:03Z | NeuronVacuum | David Peterson performs "Rattlesnakin' Daddy" at the Family Wash in Nashville TN April 2009. Paul Franklin on pedal steel, Luke Bulla on fiddle, Richard Bennett on electric guitar, Dennis Crouch on bass, and Tommy Giampietro on snare. | ["Blues", "Electric guitar", "Music"] | ["country/blues", "e-guitar", "acoustic guitar", "drums", "violin", "upright bass", "electric keys", "uptempo"] | 6 | D0L-M4trkpw | 1428 | |
Strawfoot - churchyard cough live | This is a country music piece. There is a male vocalist singing in a preaching manner. The melody is being played by a violin, a banjo and an electric guitar while an upright bass is playing in the background. The rhythmic background consists of an accentuated acoustic drum beat. The atmosphere is lively and hard-hitting. This piece could be used in the soundtrack of a historical crime movie taking place in the US. | 2009-06-01T06:07:26Z | Word Smith | Dirge-Country pioneers, Strawfoot, bring a dark sound of candy-coated salvation and eternal hellfire and damnation to the public with haunting cautionary tales of outlaw scarecrows, wayward preachers, falling pianos, and the devil. Strawfoot creates an original sound steeped in the rich, dark history of America and beyond. Fronted by a crazed and angry preacher, Strawfoot is a seven-piece band consisting of violin, banjo, harmonica, upright bass, guitar, percussion and the occasional mandolin and accordian. Strawfoot has quickly become a fan favorite wherever they take the stage, gaining fans across America and abroad. | ["Music", "Ska", "Song", "Rock and roll"] | ["country music", "male vocal", "preach-like singing", "violin", "banjo", "electric guitar", "upright bass", "acoustic drums", "lively", "hard-hitting"] | 9 | adYFXYPqo2M | 3562 | |
Rooster Song | This song contains an upright bass playing a simple bassline along with an acoustic guitar strumming chords and a mandolin playing a fast paced melody. A violin is ending the phrase in the mid range. Then male and female voices are singing with the female voice being the lead voice. In the background you can hear the crowd laughing. This song may be playing as a local concert. | 2007-01-11T22:59:38Z | Phil Greer | Timberline's most requested song... | ["Banjo", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | ["country/folk", "upright bass", "acoustic guitar", "violin", "mandolin", "male and female voices singing", "medium to uptempo", "amateur recording"] | 6 | j0UMI2DrnMA | 4229 |
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;