musiccaps_details (view)
4 rows where musiccaps_aspects contains "cozy", musiccaps_author = 9 and musiccaps_names contains "Banjo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- banjo 4
- cozy · 4 ✖
- folk 3
- american 2
- bluegrass 2
- instrumental 2
- solo 2
- acoustic guitar 1
- american folk music 1
- cheerful 1
- easygoing 1
- folk singing 1
- friendly 1
- lively 1
- male vocal 1
- pastoral 1
- steady tempo 1
- uplifting 1
- violin 1
musiccaps_names (array) 10 ✖
- Banjo · 4 ✖
- Music 4
- Musical instrument 3
- Bluegrass 2
- Guitar 2
- Plucked string instrument 2
- Bowed string instrument 1
- Mandolin 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 |
---|---|---|---|---|---|---|---|---|---|---|
Kickin Chickens played by Jaimee Perea (Eddie Shelton Banjo cover) | This is a bluegrass music piece performance. Iconic to the American folk songs, it involves a rapidly played banjo solo. The atmosphere of the piece is cozy and positive. This piece could be used in rural social media content or in a comedy show taking place in rural USA. | 2010-06-10T03:30:29Z | PecosMtJeff | Our friend Jaimee Perea stopped by the house with her banjos, so we set up a camera and talked her into playing a few songs (she really isn't used to having an audience, but I think she did just great considering that we just stuck her in a corner and asked her to play). You might hear the dog barking in the background or the kids out playing in the pool... but hey... its just down home pickin! | ["Banjo", "Music"] | ["bluegrass", "folk", "american", "banjo", "instrumental", "solo", "cozy", "uplifting", "pastoral"] | 9 | ExghbCGRBx0 | 1604 | |
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 | |
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 | |
Greatest Banjo player of all time: Obi Barthmann | This is an amateur recording of a solo banjo player. The piece is played in the major scale, creating a friendly, calming atmosphere giving it a definitive characteristic of a folk song. It could be used as background music in pastoral content, touristic videos of rural locations. | 2007-08-26T02:09:33Z | Florian Baessler | This song is available for download here (full album): http://www.wilderpilger.de/produkt/banjo-landscapes-ii-obi-barthmann/ This is Obi Barthmann, banjo player and composer from germany. The song is called "time" and is one of my favourite compositions by him. If you don't get it: The title is just a litte exaggerating. But if you can't deal with some bullshit, please f**k off and leave the internet. Wanna see some real playing by this guy? look here: https://youtu.be/DFx5dYB3NoA | ["Banjo", "Music", "Musical instrument", "Plucked string instrument"] | ["banjo", "solo", "friendly", "cozy", "folk"] | 9 | kko1uYyqJ_o | 4355 |
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;