musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "calm", musiccaps_aspects contains "serene" and musiccaps_author = 7
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 51 ✖
- calm · 3 ✖
- serene · 3 ✖
- acoustic guitar 2
- dulcet 2
- euphonious 2
- flute melody 2
- instrumental 2
- mellow 2
- peaceful 2
- soft 2
- acoustic guitar accompaniment 1
- aerophone 1
- african 1
- beautiful 1
- celtic 1
- classical music 1
- contemplative 1
- deliberate 1
- emotional 1
- flute like instrument 1
- folk 1
- folk music 1
- foreign language 1
- hills 1
- idyllic 1
- indian classical 1
- keyboard accompaniment 1
- male singer 1
- meditative 1
- medium tempo 1
- melancholic 1
- mellifluous 1
- melodic 1
- minimalist 1
- mountains 1
- pensive 1
- pure 1
- recorder 1
- romantic 1
- simple groove 1
- simplicity 1
- slow tempo 1
- soothing 1
- soulful 1
- sow tempo 1
- steady drumming 1
- straight bass lines 1
- synth arrangements 1
- wind instrument 1
- woodwind 1
- world music 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Michael ofori ogyegyentwie ghana gospel music | A male vocalist sings this sweet melody in a foreign language. The tempo is medium with keyboard accompaniment, steady drumming, synthesiser arrangement and acoustic guitar. The song has a simple, easy melody. It is earnest, emotional, calm and soothing. This song is a Regional Pop song. | 2009-04-20T09:40:57Z | gimwhp | Michael Ofori, Ghanaian born live in the United States. Singer of Gospel music. | ["Music of Africa", "Funk", "Music", "Reggae", "Rhythm and blues", "Soul music", "Exciting music"] | ["male singer", "medium tempo", "foreign language", "world music", "keyboard accompaniment", "steady drumming", "straight bass lines", "synth arrangements", "african", "melodic", "calm", "simple groove", "acoustic guitar", "romantic", "emotional", "peaceful", "serene"] | 7 | D3FyfFIKLVc | 1430 | |
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 | |
Spiritual music - Sounds of Isha - 'The Seed' | This music is instrumental. The tempo is slow with a flute playing a melodic lead harmony and later joined by a rhythmic acoustic guitar. The song is dulcet, warm, peaceful; calming, meditative,pensive, contemplative, deliberate, mellifluous and euphonious. This music is an Indian Classical. | 2008-07-26T15:02:52Z | PRyde16 | 'The Seed' Album: Sounds of Isha www.ishafoundation.org Support Sounds of Isha by purchasing their music from soundsofisha.org I do not own this music. | ["Music", "Tender music"] | ["instrumental", "sow tempo", "soft", "meditative", "mellow", "mellifluous", "dulcet", "peaceful", "contemplative", "pensive", "mellifluous", "deliberate", "hills", "mountains", "indian classical", "euphonious", "flute melody", "acoustic guitar accompaniment", "soothing", "woodwind", "aerophone", "classical music", "calm", "serene"] | 7 | nPlDt1R8Qfc | 4536 |
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;