musiccaps_details (view)
4 rows where musiccaps_aspects contains "folk", musiccaps_aspects contains "instrumental" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 61 ✖
- folk · 4 ✖
- instrumental · 4 ✖
- banjo 2
- bluegrass 2
- country 2
- medium tempo 2
- melodious 2
- string instrument 2
- 8 stringed instrument 1
- 9 stringed instrument 1
- acoustic guitar 1
- african instrument 1
- american instrument 1
- banjo lead 1
- beautiful 1
- blue grass 1
- calm 1
- celtic 1
- classical 1
- country music 1
- country song 1
- country songs 1
- dulcet 1
- ethnic music 1
- euphonious 1
- fast tempo 1
- flute like instrument 1
- flute melody 1
- folk music 1
- folk song 1
- high notes 1
- high pitched sounds 1
- home recording 1
- idyllic 1
- jazz 1
- lively 1
- lute instrument 1
- mandolin 1
- mandolin instrumental 1
- melancholic 1
- mellow 1
- minimalist 1
- no accompaniment 1
- plucked string instrument 1
- poor audio quality 1
- pure 1
- recorder 1
- regional music 1
- serene 1
- simplicity 1
- slow tempo 1
- soft 1
- soprano tone 1
- soulful 1
- spirited 1
- stringed instrument 1
- sweet 1
- sweet melody 1
- tutorial 1
- wind instrument 1
- world music 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
10 songs to play on mandolin that aren't bluegrass | This song is a mandolin instrumental. The tempo is medium with a lively melody on the mandolin. The music is minimalist without any other instruments. The music is high pitched, melodious and charming. This audio ends abruptly indicating that this could be a mandolin tutorial. | 2014-08-08T12:17:31Z | mandohat | I love bluegrass, but the mandolin is a great instrument for lots of styles! http://www.andyslessons.com ---Andy Hatfield, mandolin and guitarist | ["Music", "Mandolin"] | ["instrumental", "medium tempo", "mandolin", "folk", "classical", "jazz", "ethnic music", "country songs", "tutorial", "string instrument", "mandolin instrumental", "8 stringed instrument", "country song", "bluegrass", "high notes", "melodious", "sweet", "lute instrument", "soprano tone"] | 7 | 2ZogsGp-T4o | 381 | |
Folk music from Scotland - Black is the colour | This music is a beautiful ,soothing instrumental. The tempo is slow with a wind instrument like a recorder/flute solo and an acoustic guitar accompaniment. The music is dulcet, serene,calming, soothing, mellifluous,soulful, therapeutic and idyllic. This is a folk song instrumental. | 2011-03-15T12:30:38Z | Arany Zoltán | #folkmusic #scottish #celtic #aranyzoltan https://www.facebook.com/Arany-Zolt%C3%A1n-Music-274856225999515/ http://aranyzoltan.hu/ Lyrics: Black is the colour of my true love's hair, Her lips are like some roses fair, She's the sweetest smile, And the gentlest hands, I love the ground, Whereon she stands. I love my love and well she knows, I love the ground, whereon she goes, I wish the day, it soon would come, When she & I could be as one. Black is the colour of my true love's hair, Her lips are like some roses fair, She's the sweetest smile, And the gentlest hands, I love the ground, Whereon she stands. I go to the Clyde and I mourn and weep, For satisfied, I ne'er can be, I write her a letter, just a few short lines, And suffer death, a thousand times. Black is the colour of my true love's hair, Her lips are like some roses fair, She's the sweetest smile, And the gentlest hands, I love the ground, Whereon she stands. | ["Wind instrument, woodwind instrument", "Flute"] | ["instrumental", "slow tempo", "recorder", "soulful", "pure", "simplicity", "minimalist", "folk", "folk music", "acoustic guitar", "celtic", "flute melody", "dulcet", "flute like instrument", "soft", "mellow", "serene", "idyllic", "melancholic", "calm", "euphonious", "wind instrument", "beautiful"] | 7 | PKsdjH0RmsU | 2528 | |
cluck old hen | This music clip is a Lively Banjo instrumental. The tempo is fast with a spirited Banjo lead harmony. The music is simple, cheerful, happy, festive, upbeat and vivacious. The audio is not very clear as it is a home recording. The music has a country or folk song vibe. | 2009-06-29T15:04:18Z | janepc123 | Played on my newly acquired John Grey open back courtesy of the generosity of Joemac | ["Banjo", "Music", "Bluegrass"] | ["instrumental", "fast tempo", "lively", "spirited", "country music", "folk song", "regional music", "banjo", "banjo lead", "no accompaniment", "world music", "melodious", "poor audio quality", "home recording", "stringed instrument", "country", "bluegrass", "folk", "high pitched sounds"] | 7 | R1RGIgC-xKw | 2661 | |
Luap plays Old Gray Goose (take 2) | This music clip is of a musician playing a lilting melody on the Banjo. The tempo is medium with a rhythmic lead harmony. There is no other instrument used. The music is soft, mellow, nostalgic, and calming. Soothing and simple. | 2009-01-12T01:39:50Z | llmckee | More practice and improvement | ["Banjo", "Music", "Steel guitar, slide guitar", "Plucked string instrument"] | ["instrumental", "medium tempo", "string instrument", "plucked string instrument", "banjo", "african instrument", "american instrument", "9 stringed instrument", "sweet melody", "folk", "country", "blue grass"] | 7 | YbLR6dgY-K4 | 3297 |
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;