musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "easygoing", musiccaps_names contains "Bluegrass" and musiccaps_names contains "Mandolin"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 19 ✖
- acoustic guitar 2
- easygoing · 2 ✖
- banjo 1
- banjo solo 1
- bluegrass 1
- cozy 1
- folk music 1
- instrumental 1
- irish 1
- joyful 1
- live performance 1
- lively 1
- male vocals 1
- mandolin 1
- no singer 1
- playful 1
- steady tempo 1
- uplifting 1
- upright bass 1
musiccaps_names (array) 8 ✖
- Bluegrass · 2 ✖
- Mandolin · 2 ✖
- Music 2
- Acoustic guitar 1
- Flamenco 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Saint Anne's Reel on Guitar and Mandolin | This is an Irish folk music piece. The melody is being played by an acoustic guitar and a mandolin. The atmosphere of the piece is cozy and easygoing. It has a steady tempo. This piece could be used in the soundtrack of a documentary. It could also be playing in the background at an Irish pub or an Irish cuisine restaurant. | 2010-03-04T00:29:30Z | Ryan Kimm | Ryan Kimm and Mike Hedding doing that old fiddle tune Saint Anne's Reel. Tabs and Practice tracks available for this tune and other fiddle tunes at http://www.musicwithryan.com Check out more fiddle tunes and free lesson videos at http://www.youtube.com/channel/UCjEo6w49rYrwFNy6cXWRe6A | ["Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["irish", "folk music", "no singer", "instrumental", "acoustic guitar", "mandolin", "cozy", "lively", "easygoing", "steady tempo"] | 9 | Ts04bBeY1d4 | 2871 | |
Greensky Bluegrass | 3/01/2014 | "Letter To Seymour" - "New Rize Hill" | This is the live performance of a bluegrass music piece. There are male vocals singing together in a lively manner. There are two banjos playing the melody, one acting as the lead and the other as the rhythm. There is also an acoustic guitar following the banjos. An upright bass is playing the bass line which acts as a rhythmic background. The general atmosphere of the piece is very uplifting. The piece can be used in the soundtrack of rural comedies. It could also be used in the background for funny social media content. | 2014-04-20T16:36:51Z | GreenskyBluegrass | Greensky Bluegrass live at the Neptune Theater in Seattle, Washington on March 1, 2014 performing a medley of Letter To Seymour into New Rize Hill. Anders Beck: dobro Michael Arlen Bont: banjo and vocals Dave Bruzza: guitar and vocals Mike Devol: bass and vocals Paul Hoffman: mandolin and vocals Filmed & Edited by Mark Burgin (tapermark) © 2014 Greensky Bluegrass All Rights Reserved www.greenskybluegrass.com | ["Flamenco", "Music", "Mandolin", "Bluegrass"] | ["bluegrass", "live performance", "male vocals", "banjo", "banjo solo", "upright bass", "acoustic guitar", "playful", "joyful", "uplifting", "easygoing"] | 9 | Tvwi_YuLehk | 2876 |
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;