musiccaps_details (view)
6 rows where musiccaps_aspects contains "banjo", musiccaps_author = 6 and musiccaps_names contains "Bluegrass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- banjo · 6 ✖
- amateur recording 5
- upright bass 4
- uptempo 4
- bluegrass 3
- acoustic guitar 2
- acoustic drums 1
- acoustic guitars 1
- background noises 1
- background voices 1
- country/rock 1
- e-bass 1
- female duo singing 1
- folk/country 1
- foto shot sound 1
- good mood 1
- male voice singing 1
- mandolin 1
- medium to uptempo 1
- mid-range 1
- semi acoustic mandolin 1
- slide guitar 1
musiccaps_names (array) 13 ✖
- Bluegrass · 6 ✖
- Music 6
- Banjo 5
- Country 4
- Guitar 2
- Mandolin 2
- Musical instrument 2
- Plucked string instrument 2
- Blues 1
- Gospel music 1
- Rock and roll 1
- Speech 1
- Squish 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bluegrass When the Roll Is Called Up Yonder (Bruce Weeks) | Someone is playing an acoustic guitar strumming chords on the backbeat along with a banjo doing the same. A slide guitar is playing a melody along. An upright bass is playing a simple bassline. Two female voices are singing as a duo. The second one creates harmony in the higher register. This song is an amateur recording. This song may be playing at a local event. | 2008-10-31T14:30:29Z | Bruce Weeks | www.bruceweeksfamilyband.com More music from our Jasper Meeting on Thursday nights now meeting at 3530 Salem Church Rd 3 miles from Jasper Jeep on the right. | ["Banjo", "Country", "Music", "Bluegrass"] | ["bluegrass", "acoustic guitar", "slide guitar", "upright bass", "banjo", "female duo singing", "amateur recording", "uptempo"] | 6 | 40sAH2ZB0Pg | 532 | |
Awesome Mandolin Playing by 15 year old Jake | A banjo is playing chords while an upright bass is playing a bassline. These two form the rhythmic section. On top of that a mandolin is playing a fast and complex solo. In the background you can hear the crowd cheering and clapping hands. This is an amateur recording. This song may be playing in a big pub. | 2007-10-28T00:10:19Z | Billy Pollard | Mandolin playing by Jake Jolliff with Bill Jolliff on Banjo, Louanne Fugal on Upright Bass, Steve Blanchard on Rythym Guitar, Awesome Mandolin Pickin' n' Grinnin', Bluegrass Style Music, Strolling Down Memory Lane, Billy and Willie Pollard's Country Gospel T.V. Program, WillieAndBilly@Yahoo.com , http://billyandwillie.tripod.com | ["Gospel music", "Banjo", "Country", "Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["bluegrass", "semi acoustic mandolin", "banjo", "upright bass", "background noises", "amateur recording"] | 6 | 4KqSdK5KM-I | 556 | |
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 | |
Kendall Motor Oil - with liquid titanium - Mood film | A full sounding male voice is singing mid range with kind of a radio effect on his voice. Two banjos are strumming chords with one playing the lead melody on top. One is panned to the right side of the speakers. An acoustic drum is playing a four on the floor groove with a kick on every beat and an e-bass is playing his own melody along. In the background you can hear the sound of a photo taken. This song may be playing in an advertisement for a product. | 2013-11-13T09:01:16Z | Kendall Motor Oil | Kendall Lubricants sfeerfilm. Een mooie afwisseling tussen dragrace beelden en Kendall Motor Oil producten. Voor meer informatie bezoek onze nieuwe website: http://www.kendall.nl Kendall motor oil - with liquid titanium The best possible Oil for your vehicle: -Kendall Super D 15W40 -Kendall versatrans synthetic blend automatic transmission fluid -Kendall GT-1 2-cycle motor oil -GT-1 Full Synthetic 5W-40 -Kendall Euro GT-1 Full synthetic 5W-30 -Kendall Euro GT-1 Full synthetic 5W-40 -Kendall GT-1 Full synthetic 0W-20 with Liquid Titanium -Kendall GT-1 Full synthetic 10W-30 with Liquid Titanium -Kendall GT-1 Full synthetic 5W-20 with Liquid Titanium -Kendall GT-1 Full synthetic 5W-30 with Liquid Titanium -Kendall GT-1 Full synthetic 0W-20 with Liquid Titanium -Kendall GT-1 High mileage synthetic blend 10W-30 with Liquid Titanium -Kendall GT-1 High mileage synthetic blend 10W-40 with Liquid Titanium -Kendall GT-1 High mileage synthetic blend 5W-20 Liquid Titanium with SealMax -Kendall GT-1 High mileage synthetic blend 5W-30 Liquid Titanium with SealMax -Kendall GT-1 GT-1 High performance 10W-40 -Kendall GT-1 GT-1 High performance Synthetic blend 5W-30 -Kendall GT-1 GT-1 High performance 10W-40 with Liquid Titanium -Kendall GT-1 GT-1 High performance 10W-40 with Liquid Titanium (exceptional engine wear protection) -Kendall GT-1 GT-1 High performance 20W-50 High performance racing formula with added zinc -Kendall Nitro 70 GT-1 High performance motor oil (ideal for engines fueled with nitromethane) -Kendall GT-1 Motorcycle 4-cycle motor oil SEA 20W50 -Kendall non-detergent sae 10W Motor oil (recommended for use in industrial applications) -Kendall non-detergent sae 20W-20 Motor oil (recommended for use in industrial applications) -Kendall L-427 SUPER BLU NLGI GC-LB NLGI #2 -Kendall Limited-Slip Axle Additive Concentrate -Kendall non-detergent sae30 Motor oil (recommended for use in industrial applications) -Kendall SHP corrosion-preventive NLGI #2 -Kendall SHP Diesel premium full synthetic Diesel engine oil SAE5W-40… | ["Blues", "Banjo", "Music", "Squish", "Rock and roll", "Bluegrass"] | ["country/rock", "banjo", "male voice singing", "mid-range", "foto shot sound", "acoustic drums", "e-bass", "uptempo"] | 6 | 9-R70gSqvrc | 968 | |
Cherokee Shuffle & Sled Ride - Townsend Bluegrass Jam, 5 5 12 | This song contains people strumming chords on acoustic guitars while a banjo and a mandolin are taking turns playing a lead melody. In the background you can hear an upright bass playing a fitting bassline. This song may be playing live while having a BBQ with friends. | 2012-06-25T22:02:35Z | gingermc2 | I know the name of only two people in this jam session; McCoy Borg, the banjo player & Josh-mandolin.. I think the woman playing bass is from Ohio. Spring Festival @ Townsend, TN 5-5-12. | ["Country", "Music", "Bluegrass"] | ["amateur recording", "folk/country", "acoustic guitars", "mandolin", "banjo", "upright bass", "uptempo", "good mood"] | 6 | Ok-ia7ziJy0 | 2465 | |
Banjo Music "Potato Head Blues" Eddy Davis Tenor Banjo | Someone is strumming a banjo along with playing a lead melody. This may be playing sitting in the countryside in front of your house in the garden. | 2009-10-22T23:22:11Z | Wyatt Urban | Eddy Davis plays POTATO HEAD BLUES, Sept. 25, 2009 in NYC, on a Gibson Mastertone TB5, which originally belonged to Jim Robinson, who purchased it new in 1931. Jim played it until 2005, when he died at the age of 92. | ["Banjo", "Music", "Mandolin", "Bluegrass"] | ["amateur recording", "banjo", "uptempo"] | 6 | VAqgpoyD2jc | 2979 |
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;