musiccaps_details (view)
4 rows where musiccaps_aspects contains "world music" and musiccaps_names contains "Folk music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- world music · 4 ✖
- female singer 2
- foreign language 2
- keyboard harmony 2
- medium tempo 2
- steady drumming 2
- acoustic guitar 1
- arabic music 1
- calm 1
- calming 1
- captivating 1
- double reed solo 1
- drone 1
- easygoing 1
- emotional 1
- folk song 1
- funky bass line 1
- gentle 1
- hawaiian folk 1
- love song 1
- low fidelity 1
- male singer 1
- male vocal 1
- mandolin 1
- melodic singing 1
- middle eastern music 1
- peaceful 1
- percussion instrument 1
- regional pop 1
- relaxing 1
- romantic 1
- simple bass lines 1
- soothing 1
- soulfu 1
- soulful 1
- soulfulromantic 1
- tambourine 1
- technically challenging melody 1
- ukulele 1
- unique instrument 1
musiccaps_names (array) 6 ✖
- Folk music · 4 ✖
- Music 4
- Middle Eastern music 1
- Singing 1
- Tender music 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
jászsági népdalok (hungarian folk music) | A low fidelity recording of a drone instrument playing a chord while a female singer and double reed instrument double a technically challenging melody. | 2010-08-23T12:12:56Z | Jász Gyerek | 4 népdal | ["Traditional music", "Folk music", "Music"] | ["low fidelity", "female singer", "double reed solo", "drone", "technically challenging melody", "world music"] | 8 | RFKTlhbnfXA | 2683 | |
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 | |
Israel kamakawiwo'ole somewhere over the rainbow | This is a Hawaiian folk music rendition of a jazz music piece. There is a male vocalist singing melodically in the lead. The simple tune is being played by a mellow sounding ukulele. There is a peaceful and relaxing atmosphere. This piece could be playing in the background of a coffee shop. It could also be included in the soundtrack of a feelgood movie/TV series. Another good use would be in the background of wholesome social media content. | 2008-03-11T15:20:37Z | Lasse Jespersen | this is about the danish soldiers in the schleswig war, and of course Israe Kamakawiwo'ole. I have choosen this song because when you are a soldier and you face an enemy that 3 times as big as yours ( as it was in the Schleswig wars), then there might be something over the rainbow that's better than what you are facing right now. | ["Folk music", "Music", "Middle Eastern music"] | ["hawaiian folk", "world music", "male vocal", "melodic singing", "ukulele", "gentle", "peaceful", "calming", "relaxing", "easygoing"] | 9 | p2jnUySmuvA | 4682 | |
Gezuar 2016: Shyhrete Behluli - N'daq nafaka me t'ba lum | A female vocalist sings this captivating melody. The tempo is medium with enthusiastic drumming, soft keyboard harmony, steady bass lines and a middle eastern instrument. The song is rhythmic, catchy, peppy, vivacious and has a dance groove. This song is a Regional Pop song. | 2015-12-08T19:33:06Z | VizioniLibonia | Onair Media - https://smarturl.it/Onair.Media Follow VizioniLibonia on… FB: https://smarturl.it/VizioniLiboniaFB IG: https://smarturl.it/VizioniLiboniaIG Subscribe: https://smarturl.it/VizioniLiboniaSub © & ℗ VizioniLibonia & Onair Media. All Rights Reserved | ["Singing", "Folk music", "Music"] | ["female singer", "medium tempo", "foreign language", "regional pop", "world music", "tambourine", "unique instrument", "captivating", "steady drumming", "percussion instrument", "simple bass lines", "keyboard harmony", "arabic music", "middle eastern music"] | 7 | sZwZ2fOWWSg | 4962 |
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;