musiccaps_details (view)
8 rows where musiccaps_aspects contains "uptempo", musiccaps_author = 6 and musiccaps_names contains "Bluegrass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- uptempo · 8 ✖
- amateur recording 6
- acoustic guitars 4
- banjo 4
- upright bass 3
- acoustic guitar 2
- cheerful 2
- e-bass 2
- mandolin 2
- acoustic drums 1
- bluegrass 1
- cajon 1
- country 1
- country/folkrock 1
- country/rock 1
- female duo singing 1
- folk/country 1
- foto shot sound 1
- good mood 1
- male voice 1
- male voice cheering 1
- male voice singing 1
- mid range singing 1
- mid-range 1
- poor recording quality 1
- singer-songwriter 1
- slide guitar 1
- soft percussion 1
- uprightbass 1
musiccaps_names (array) 14 ✖
- Bluegrass · 8 ✖
- Music 8
- Banjo 4
- Country 3
- Guitar 3
- Musical instrument 3
- Plucked string instrument 3
- Acoustic guitar 2
- Blues 2
- Strum 2
- Mandolin 1
- Rock and roll 1
- Squish 1
- Steel guitar, slide guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Smokin' Guitar at the Super Srecret Bluegrass Jam | This song contains acoustic guitars being strummed fast, a mandolin playing the lead melody in a higher pitch and an upright bass providing an almost walking bassline. This song may be playing in the countryside while having a BBQ. | 2006-09-25T12:58:24Z | arenacom1 | We were playing so fast that my guitar started smoking at the end of the video. | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "Bluegrass"] | ["amateur recording", "acoustic guitars", "mandolin", "upright bass", "uptempo", "cheerful"] | 6 | 0S5zWt91Bwo | 169 | |
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 | |
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 | |
Roundstone summer Festival 09 - Micky Martin and friends... traditional irish music | This song is recorded in poor quality. Two acoustic guitars are playing. One of them is strumming chords while the other is playing a country solo up and down the fretboard. A cajon player is supported with mostly kick sounds. This song may be played at an Irish bar. | 2009-08-24T01:49:16Z | Alberto Graziotto | A great perform!!!! | ["Blues", "Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["country/folkrock", "acoustic guitars", "cajon", "male voice cheering", "uptempo", "cheerful", "poor recording quality"] | 6 | WhX3jQxHZWc | 3127 | |
Chords'n'Coffee - Never Ringing Doorbell | Acoustic guitars are strumming chords while a male voice is singing with his full voice but not loud. A bass is supported along with some very soft percussion that are barely noticeable. This song may be playing with friends at a bonfire. | 2013-12-08T21:30:41Z | ChordsnCoffee Wien | Band: Chords'n'Coffee . Acoustic Band from Vienna/Austria Song: Never Ringing Doorbell - live on a rooftop terrace Camera: Peter Paulhart, Felix Huber - Black Coffee Sound: Torge Karstens | ["Country", "Music", "Steel guitar, slide guitar", "Bluegrass"] | ["singer-songwriter", "acoustic guitars", "e-bass", "male voice", "mid range singing", "soft percussion", "amateur recording", "uptempo"] | 6 | eBF0zRHCbZE | 3850 | |
Will the Circle Be Unbroken - Guitar Lesson- Hot Bluegrass Lead | This audio contains someone playing an acoustic guitar fingerstyle. An upright bass is playing a line in the background. This song may be playing guitar to someone. | 2014-07-22T00:35:03Z | Music With Ryan | This lesson comes with over 30 minutes of video, PDF tabs and four audio backing tracks! Become a Premiere member to access this full-length video and ALL of the instruction at my site. Learn more here - https://musicwithryan.com/courses/will-circle-unbroken-advanced/ Premiere members get access to over 350 full-length video lessons, all three courses, and my Video Exchange Program for a monthly, quarterly, or yearly fee. Learn more here - https://www.musicwithryan.com/memberships | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "Bluegrass"] | ["amateur recording", "country", "acoustic guitar", "uprightbass", "uptempo"] | 6 | kmZFn-CQ19A | 4356 |
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;