musiccaps_details (view)
5 rows where musiccaps_aspects contains "mandolin" and musiccaps_names contains "Guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- mandolin · 5 ✖
- acoustic guitar 2
- amateur recording 2
- folk music 2
- instrumental 2
- acoustic guitars 1
- banjo 1
- cheerful 1
- cozy 1
- e-bass 1
- easygoing 1
- eldery male vocals 1
- flutes 1
- folk song 1
- irish 1
- irish bouzouki guitark 1
- irish folk singing 1
- joyful 1
- live performance 1
- lively 1
- low quality audio 1
- medium tempo 1
- no singer 1
- no voice 1
- percussion 1
- steady tempo 1
- upright bass 1
- uptempo 1
- whistling 1
musiccaps_names (array) 12 ✖
- Guitar · 5 ✖
- Music 5
- Musical instrument 5
- Plucked string instrument 5
- Bluegrass 4
- Acoustic guitar 2
- Mandolin 2
- Banjo 1
- Bowed string instrument 1
- Country 1
- Folk music 1
- Strum 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 | |
Susie & Mick Darling - Rattle Tattle Gypsy | This is the performance of an Irish folk song using a banjo and a mandolin. The singer is elderly and the guitars are layered. The banjo is used to play a simple motif that revolves around two chords. | 2012-08-26T21:47:41Z | Teesside Steve | Friday 24th August 2012 - http://www.fb.com/saltburnopen | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass", "Bowed string instrument"] | ["live performance", "low quality audio", "folk music", "banjo", "mandolin", "irish bouzouki guitark", "irish folk singing", "eldery male vocals"] | 3 | 0hfU27A6tus | 199 | |
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 | |
Kjarkas - Yo no he nacido para sufrir HD | This song contains someone strumming a melody on a mandolin while more people are whistling along. Then a mandolin, an e-bass and an acoustic guitar are playing a short melody in a lower key before breaking into the next part along with flutes and percussions. This song may be played outside by musicians performing. | 2016-07-07T01:47:40Z | calacas555 | Tema que será parte de la nueva producción cdgráfica del grupo Kjarkas denominado la Leyenda Viva | ["Folk music", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "acoustic guitar", "e-bass", "mandolin", "flutes", "whistling", "percussion", "medium tempo"] | 6 | ZTVMsW1h3bI | 3379 | |
mandolinvideo.avi | The excerpt features a mandolin playing a folk song. This is the only musical instrument playing, there aren't others or any voices singing. The character of the song is joyful. | 2012-04-19T17:06:56Z | Stuart Wailing Resonators | This video is of a Stuart Wailing Resonator Mandolin being played by Phil Tyler. See other instrument made by Stuart Wailing at https://stuartwailingresonator.000webhostapp.com/index.html | ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["mandolin", "instrumental", "no voice", "joyful", "folk song"] | 2 | w2vMywh5Nto | 5232 |
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;