musiccaps_details (view)
7 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_names contains "Folk music"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| ROZBĚH BLUEGRASS MUSIC | This is a bluegrass music piece. There is a mandolin playing the main tune as the lead while a banjo and an acoustic guitar are supporting it in the melodic background. There is a joyful feeling to this piece. It could be used in the soundtrack of a movie or a TV show with a rural setting. It could also be used in the background of pastoral social media content. | 2011-08-25T14:41:30Z | honzabaseman | 00. Úvod 01. MATTERHORN 02. PLEASE SEARCH A HEART 03. FOX ON THE RUN 04. HROU ZÍSKÁŠ HROW 05. SALT CREEK 06. ZÁTOKA 07. NOČNÍ VLAK 08. ZLATÁ RYBKA 09. BLACK DIAMOND 10. PÁDÍ MISSISSIPPI 11. FOGGY MOUNTAIN BREAKDAUN 12. KAROLÍNA 13. SVÍCEN ZMIZEL V TMÁCH 14. ARKANSAS TRAVELLER 15. PÝCHA PŘEDCHÁZÍ PÁD 16. PŘÍSAHEJ 17. SAIL TO AUSTRALIA | ["Gospel music", "Folk music", "Flamenco", "Music", "Music of Bollywood", "Music of Latin America", "Bluegrass"] | ["bluegrass", "no singer", "instrumental", "banjo", "mandolin", "acoustic guitar", "playful", "joyful", "uplifting", "easygoing", "rural", "pastoral"] | 9 | 0-7PyzhzuYQ | 108 | |
| Faraon - Flamenco Rumba_20/11/2011@Barceloan | This is a recording of two flamenco guitarists playing a captivating latin american rhythm. It's upbeat and suitable for dancing. The one guitarist strums chords in the percussive flamenco style, while the other guitarist plays flamenco lead with arpeggios and licks. The performance is live and outside. There is reverb applied to the lead guitar. Both are playing on nylon strings. | 2011-11-24T17:50:51Z | Julian Kan | Spanish Guitar - Adrian Roman & Martin Sazandeh's performance at Cathedral, Gothic Quarter, Barcelona | ["Folk music", "Flamenco", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["live performance", "flamenco guitarists", "acoustic guitar", "nylon string guitar", "latin american music", "upbeat", "energetic", "dance", "reverb"] | 3 | KChjW89XOF0 | 2064 | |
| Дунаю, Дунаю | A female choir is singing a melody. The instruments are playing the same melody. The percussion- section contains a bassline being played along with a tambourine. This song may be playing at a public folkfest. | 2009-10-10T22:36:29Z | ArattaMedia | Українська народна пісня у виконанні народного ансамблю "Вишня". Художній керівник - Адам Дзюба. Інформація про колектив - http://www.aratta-ukraine.com/text_ua.php?id=1401 DVD - http://opensharing.org/torrent/94519/ | ["Folk music", "Music", "Musical instrument"] | ["folkmusic", "violin", "accordion", "female choir", "bass", "tambourine", "flute", "acoustic guitar", "uptempo"] | 6 | O6QyYC7Tt2A | 2399 | |
| Sam Stone - John Prine | A male vocalist sings this melancholic country song. The tempo is slow with acoustic guitar lead and harmony with another string instrument accompanying. The song is soft, mellow, sad, pensive, melancholic and poignant with a sweet , pleasant melody. This song is a Classic Country song. | 2009-12-03T02:53:38Z | HouseOBVIOUSLY | Classic John Prine right here. | ["Folk music", "Music"] | ["male vocalist", "slow tempo", "acoustic guitar", "simple melody", "hillbilly music", "banjo", "old-time country rock", "folk lyrics", "country music", "bluegrass", "country hits", "regional music", "country folk songs", "acoustic bass", "mellow", "soft", "sentimental", "nostalgic", "pensive", "melancholy", "story telling"] | 7 | Sl9ZkYViEIs | 2787 | |
| 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 | |
| tsehay yohannes - Old music | A male vocalist sings this lilting melody. The tempo is medium with keyboard harmony, groovy bass line, steady drumming and mandolin harmony. The song is emotional, romantic, soulful, sentimental and soothing. This song is Regional Pop, | 2012-06-02T11:28:06Z | Banchi Avera | This song taking me back to my past ......... | ["Folk music", "Music", "Tender music"] | ["male singer", "medium tempo", "foreign language", "romantic", "soulful", "mandolin", "steady drumming", "soulfulromantic", "soulfu", "soothing", "calm", "soulful", "emotional", "love song", "folk song", "world music", "funky bass line", "keyboard harmony", "acoustic guitar"] | 7 | c9h4p6325Xo | 3684 | |
| Carrom - 10 Slams and 100 Ideas for Dynamic Carrom - Part1 of 12 | This song contains a tabla rhythm spread across both sides of the speakers. An acoustic guitar melody panned to the right side of the speakers. Far in the background you can hear clapping as part of the song. A male voice is singing in a higher register than a violin takes over playing a melody in a higher register with reverb and a little delay. This song may be playing in a lovely movie-scene. | 2009-09-16T03:35:04Z | carrompassion | 10 Slams and 100 Ideas for Dynamic Carrom - Part1 of 12 | ["Folk music", "Music"] | ["hindi/pop", "tablas", "violin", "acoustic guitar", "clapping", "male voice singing", "higher pitch", "medium to uptempo", "peaceful sounding"] | 6 | nFoktpUVeVw | 4528 |
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;