musiccaps_details (view)
2 rows where musiccaps_names contains "Country", musiccaps_names contains "Guitar" and musiccaps_names contains "Mandolin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
musiccaps_names (array) 10 ✖
- Country · 2 ✖
- Guitar · 2 ✖
- Mandolin · 2 ✖
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Banjo 1
- Bluegrass 1
- Gospel music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Salty Dog Blues: Piedmont Blues Fingerstyle | The low quality recording features an acoustic guitar blues melody. The recording is very noisy, roomy and you can hear cars passing by in the background. | 2008-12-17T22:33:33Z | bostonteabagger71739 | My version of the old blues song. A little sloppy I know haha | ["Country", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["low quality", "blues", "acoustic guitar melody", "noisy", "roomy", "cars passing"] | 4 | g_bgmnJ1b_g | 4039 |
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;