musiccaps_details (view)
2 rows where musiccaps_aspects contains "flute like instrument" and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- flute like instrument · 2 ✖
- acoustic guitar 1
- amateur recording 1
- beautiful 1
- calm 1
- celtic 1
- dulcet 1
- euphonious 1
- flute melody 1
- folk 1
- folk music 1
- higher key 1
- idyllic 1
- instrumental 1
- male voice singing 1
- medium uptempo 1
- melancholic 1
- mellow 1
- minimalist 1
- pure 1
- recorder 1
- serene 1
- simplicity 1
- slow tempo 1
- soft 1
- soulful 1
- wind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Jordania y su Música | This song contains a male voice loudly singing in a higher key. A flutelike instrument is playing a melody out of tune accompanied by an accordion sound. This is an amateur recording. | 2009-11-10T08:33:59Z | rauloleono | El Reino Hachemita de Jordania es uno de los países que alberga en sus regiones deserticas a una gran cantidad de árabes beduinos. Este grupo social nómada tiene fuerte influencia sobre Jordania, principalmente en la música tradicional jordana. Los beduinos poseen sus propios maneras de desarrollar sus constumbres y tradiciones; las danzas es una manera de demostrar su cultura y la música a pesar de poseer escalas un tanto primitivas, mantienen un lugar popular en el folklór árabe. Espero disfruten de éstas 2 piezas tradicionales beduinas. Me hubiera gustado publicar más pero desafortunadamente la música de Jordania es escaza para conseguir, pero de todas maneras, lo que he publicado para ustedes narra claramente a "Jordania y su Música". Saludos a todos(as) y que lo disfruten. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["amateur recording", "male voice singing", "higher key", "flute like instrument", "medium uptempo"] | 6 | gI-ovjTWBzo | 4022 |
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;