musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "folk music", musiccaps_aspects contains "instrumental" and musiccaps_author = 7
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 91 ✖
- folk music · 5 ✖
- instrumental · 5 ✖
- cheerful 3
- lively 3
- acoustic guitar accompaniment 2
- animated 2
- dulcet 2
- happy 2
- minimalist 2
- 8 stringed instrument 1
- accordion harmony 1
- acordion harmony 1
- acoustic guitar 1
- auto harp 1
- beautiful 1
- bluegrass 1
- bongos 1
- bright 1
- calm 1
- celtic 1
- chirpy 1
- colourful 1
- complex harmonies 1
- conga 1
- contemporary traditional music 1
- country instrument 1
- country song 1
- country song instrumental 1
- dance groove 1
- dance music 1
- electric guitar 1
- electronic reggae 1
- energetic 1
- enthusiastic 1
- euphonious 1
- fast tempo 1
- flute like instrument 1
- flute melody 1
- folk 1
- groovy bass 1
- happy merry 1
- high notes 1
- high-spirited 1
- idyllic 1
- keyboard accompaniment 1
- latin folk 1
- lute family 1
- mandolin 1
- mandolin harmony 1
- medium fast tempo 1
- medium tempo 1
- melancholic 1
- mellifluous 1
- mellow 1
- nostalgic 1
- party song 1
- pedal steel guitar 1
- pleasant 1
- plucking 1
- polyrhythms 1
- psychedelic 1
- pure 1
- recorder 1
- regional music 1
- saxophone 1
- sentimental 1
- serene 1
- simplicity 1
- slow tempo 1
- soft 1
- soothing 1
- soprano string instrument 1
- soulful 1
- spirited 1
- steady drumming 1
- steel guitar 1
- steel pan 1
- string harmony 1
- stringed instruments 1
- sunny 1
- syncopated 1
- synthesiser arrangement 1
- trombone 1
- trumpets 1
- upbeat 1
- vibrant 1
- vivacious 1
- vivid 1
- warm 1
- wind instrument 1
- world music 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Prieta Linda "Adrian Duran y Fred Mancilla" | This song is a lively instrumental. The tempo is medium fast with an enthusiastic accordion harmony and acoustic guitar accompaniment. The music is spirited, melodious, warm, cheerful, happy, vivacious and colourful. This music is a Folk song instrumental. | 2011-07-20T01:59:52Z | chikiturris1 | para contractiones # (714) 579-9074 Chubbz # (909) 277- 8651 Nanas | ["Accordion"] | ["instrumental", "medium fast tempo", "acordion harmony", "acoustic guitar accompaniment", "lively", "cheerful", "happy", "warm", "enthusiastic", "energetic", "vibrant", "folk music"] | 7 | 6dFCMXNlmzQ | 773 | |
Old Joe Clark - Mandolins | This music is instrumental . The tempo is fast with mandolins playing a lively, spirited rhythmic harmony with acoustic guitar accompaniment. The instrumentation is minimal with emphasis on the mandolin melody. The music is chirpy, perky, cheerful, happy, animated and spirited. | 2011-09-09T13:52:59Z | pstewart0831 | Bluegrass Mandolin Class impromptu jam Lyrics: 1. Old Joe Clark, the preacher's son Preached all over the plain The only text he ever knew Was high low jack and the game [Chorus] Fare thee well Old Joe Clark Fare thee well I'm bound Fare thee well Old Joe Clark Goodbye Betsy Brown 2. Old Joe Clark had a mule His name was Morgan Brown And every tooth in that mule's head Was sixteen inches round Chorus 3. Old Joe Clark had a yellow cat She would neither sing nor pray Stuck her head in a buttermilk jar And washed her sins away Chorus 4. Old joe clark had a house Fifteen stories high And every story in that house Was filled with chicken pie Chorus 5. I went down to Old Joe's house He invited me to supper I stumped my toe on the table leg And stuck my nose in the butter Chorus | ["Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["instrumental", "mandolin", "mandolin harmony", "stringed instruments", "8 stringed instrument", "string harmony", "lute family", "soprano string instrument", "high notes", "plucking", "lively", "cheerful", "happy", "sunny", "chirpy", "bright", "animated", "spirited", "dance music", "folk music", "acoustic guitar accompaniment"] | 7 | D-p9s8y2z_U | 1427 | |
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 | |
Ondatrópica - Punkero Sonidero | This music is an upbeat instrumental. The tempo is fast with a plethora of instruments like trumpets, congas, bongos, steel drum, accordion,saxophone, keyboard,and electric guitar. The music is perky, buoyant, high spirited, enthusiastic, energetic with complex harmonies. This music is a contemporary take in Traditional Latin folk music. | 2012-06-29T08:59:31Z | Soundway Records | Artist: Ondatrópica Title: Punkero Sonidero Album: Punkero Sonidero Conceived by Colombian musician Mario Galeano, the force behind the band Frente Cumbiero, and English producer Will 'Quantic' Holland, Ondatrópica brings together an all-star cast representing both the classic and modern styles of la musica Colombiana. Label Website: http://www.soundwayrecords.com https://www.facebook.com/SoundwayRecords http://soundcloud.com/soundway-records https://twitter.com/#!/soundway Click here to subscribe to Soundway Records - http://www.bit.ly/sub2soundway MUSIC FROM PLANET EARTH: PAST, PRESENT & FUTURE Soundway Records was conceived in 2002 by label owner Miles Cleret whilst returning from Ghana with a hoard of dusty old 45s and LPs that had mostly not been heard outside the former Gold Coast since their original release. Planned on a whim the trip was not one of the carefully planned research expeditions that Miles would later embark on to any number of far-flung tropical destinations. On the contrary he left England with no idea of what he might find or that it might be the start of a career in the record business. Although the label has it's roots in West Africa the scope has grown to include many other parts of the tropical belt with the aim of making available recordings that have in most cases never been available outside of their original countries and often not even there for over 30 years. Over the years Soundway's modus operandi has been to approach the music from a different angle from many of the more established "World Music" labels. By focusing on more obscure artists as well as big names and often concentrating on progressive recordings more in sync with Cleret's generation and background in DJ culture and dance-music. Styles have included afro-beat, funk, highlife, ethio-jazz, molam, calypso, cumbia, champeta, biguine, latin-jazz and disco as well as many unclassifiable recordings. Since 2012 Soundway has begun releasing new material from a carefully selected handful of contemporary recording … | ["Music", "Ska"] | ["instrumental", "fast tempo", "trumpets", "complex harmonies", "syncopated", "electronic reggae", "synthesiser arrangement", "folk music", "latin folk", "world music", "accordion harmony", "psychedelic", "party song", "dance groove", "contemporary traditional music", "trombone", "conga", "bongos", "steel pan", "saxophone", "electric guitar", "groovy bass", "upbeat", "cheerful", "happy merry", "polyrhythms", "animated", "high-spirited", "lively", "colourful", "vivid", "vivacious"] | 7 | mcAsO331Z9s | 4482 | |
Richard Burton... pedal steel guitar... last date | This music is a Country song instrumental. The tempo is medium with a pedal steel guitar lead harmony with steady drumming and keyboard accompaniment. The music is a simple,minimalist, sweet, dulcet, sentimental, nostalgic, soothing, pleasant and mellifluous , classic Country music instrumental. | 2011-02-03T00:25:39Z | Bob Adams | Richard's rendition of Floyd Cramer's 'Last Date' A sweet sound from that ZB Richard! | ["Blues", "Music", "Steel guitar, slide guitar"] | ["instrumental", "medium tempo", "keyboard accompaniment", "minimalist", "dulcet", "auto harp", "steel guitar", "pedal steel guitar", "steady drumming", "country song", "country song instrumental", "country instrument", "bluegrass", "regional music", "folk music", "pleasant", "nostalgic", "sentimental", "soothing", "mellifluous"] | 7 | qVT6GX1KHUY | 4788 |
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;