musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_names contains "Banjo" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- acoustic guitar · 5 ✖
- banjo 3
- amateur recording 2
- bluegrass 2
- instrumental 2
- medium to uptempo 2
- upright bass 2
- violin 2
- vocalisation 2
- american 1
- animated 1
- animated sounds 1
- auto harp 1
- background voices 1
- banjo riff 1
- camera sounds 1
- cello 1
- cheerful 1
- clapping 1
- clicking sound 1
- concert 1
- country folk music 1
- country music 1
- country/folk 1
- cozy 1
- crowd cheering 1
- enthusiastic 1
- fast tempo 1
- fiddle 1
- folk 1
- …
musiccaps_names (array) 12 ✖
- Banjo · 5 ✖
- Music 5
- Musical instrument · 5 ✖
- Bluegrass 3
- Guitar 3
- Plucked string instrument 3
- Bowed string instrument 2
- Country 2
- Violin, fiddle 2
- Acoustic guitar 1
- Song 1
- Speech 1
youtube_published (date) 5 ✖
- 2006-11-06 1
- 2007-01-11 1
- 2007-03-08 1
- 2008-01-14 1
- 2014-06-16 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bluegrass jam ( Rebecca) | An acoustic guitar is strumming chords while a banjo is playing a fast melody over it. In the background you can hear an upright bass playing a fast walking bassline. Also in the background noises of people speaking can be heard. This song may be playing live on the streets performed by buskers. | 2006-11-06T22:08:09Z | monrobro | Jamming at Memramcook Festival with True Blue Banjo- Dominic Cormier Bass- Jean-Marc Boucher Mandolin- Ron Girouard Guitar- 1st Break Michael Alain Guitar- 2nd Break Richard Bourque | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bluegrass"] | ["bluegrass", "amateur recording", "banjo", "acoustic guitar", "upright bass", "background voices", "medium to uptempo"] | 6 | 669Fk7afszw | 724 | |
Man of Constant Sorrow Bluesy Guitar Lesson! | This music is an instrumental with a lot of vocalisation and animated sounds. There are sounds of swishing, water bubbling, guitar string plonking, acoustic guitar riff, camera clicking pictures, kids screaming in glee, cheering and clapping. This music seems to be an introduction to a Show. | 2014-06-16T12:31:33Z | Banjo Ben Clark | Lesson link: https://banjobenclark.com/lessons/man-of-constant-sorrow-guitar - I absolutely LOVE this version on guitar! It would be easy to throw together a bunch of bluesy licks that work over the chords, but it's another thing to play bluesy licks that sing the melody, which is what we do here! Make sure you watch the ~30 minute video that matches these tabs and mp3's! | ["Banjo", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "medium fast tempo", "acoustic guitar", "introduction music", "vocalisation", "animated sounds", "banjo riff", "water bubbling", "crowd cheering", "clapping", "kids screaming in joy", "funny", "hooting sound", "clicking sound", "guitar string plonk", "swishing sound", "camera sounds"] | 7 | 7ITwarmdyfI | 824 | |
Wild Oats: Bluegrass Music | This is a bluegrass music piece. The acoustic guitar follows an offbeat strumming pattern, providing a rhythmic background. The violin and the banjo take turns to play rapid, upbeat solos. The atmosphere is very lively. This piece could be used at a definitively American setting such as a rodeo venue. | 2007-03-08T23:27:07Z | Infinitecre8tions | We met these guys in Pigeon Forge, TN as the opening act in Dolly Parton's Dixie Stampede. They agreed to do a private show just for our cameras! | ["Banjo", "Guitar", "Music", "Musical instrument", "Violin, fiddle", "Plucked string instrument", "Bluegrass", "Bowed string instrument"] | ["bluegrass", "instrumental", "violin", "banjo", "acoustic guitar", "american", "folk", "cozy", "lively"] | 9 | hH6thMA3640 | 4090 | |
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 | |
The Seldom Scene - After Midnight | A male vocalist sings this high energy Country Song. The tempo is fast with animated Banjo, fiddle, auto harp, acoustic guitar and cello. The song is cheerful, happy, enthusiastic, fervent, pulsating, buoyant and animated with vocalising and backup. This song is a spirited Country Folk Song. | 2008-01-14T14:52:51Z | BluegrassLibrary | John Duffey, Ben Eldridge, Mike Auldridge, Phil Rosenthal, & Tom Gray | ["Banjo", "Country", "Music", "Musical instrument", "Song", "Bluegrass"] | ["male vocalist", "fast tempo", "country music", "lively vocals", "lively backup", "banjo", "cello", "auto harp", "fiddle", "acoustic guitar", "country music", "country folk music", "vocalisation", "high energy", "fun", "merry", "cheerful", "live performance", "concert", "live audience", "enthusiastic", "animated", "regional music"] | 7 | q-sJu8CoZts | 4750 |
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;