musiccaps_details (view)
4 rows where musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Folk music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- slow tempo · 4 ✖
- male voice 2
- pensive 2
- accordion 1
- acoustic bass 1
- acoustic guitar 1
- alap 1
- banjo 1
- bluegrass 1
- chanting 1
- chinese fiddle 1
- classical music 1
- contemplative 1
- country folk songs 1
- country hits 1
- country music 1
- emotional 1
- emotional song 1
- flute 1
- folk lyrics 1
- folk music 1
- high pitched voice 1
- hillbilly music 1
- indian bowed string instrument 1
- low quality audio 1
- lucid vocals 1
- male vocalist 1
- meditative 1
- melancholic 1
- melancholy 1
- mellow 1
- nostalgic 1
- old-time country rock 1
- oriental folk song 1
- oriental percussion 1
- poignant 1
- raga 1
- regional music 1
- rubab 1
- sad 1
- sarangi 1
- sentimental 1
- simple melody 1
- soft 1
- story telling 1
- swar 1
- tremulous voice 1
- violin 1
- vocalisation 1
- wistful 1
musiccaps_names (array) 5 ✖
- Folk music · 4 ✖
- Music 4
- Carnatic music 1
- Mantra 1
- Music of Asia 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Uzbek Classic Music | This folk song features a male voice singing the main melody in an emotional mood. This is accompanied by an accordion playing fills in the background. A violin plays a droning melody. There is no percussion in this song. This song can be played at a Central Asian classical concert. | 2008-01-24T15:19:53Z | TashChaynar | Bobomurod Hamdamov Ayrilma | ["Folk music", "Music"] | ["folk music", "rubab", "male voice", "slow tempo", "emotional song", "low quality audio", "violin", "accordion"] | 0 | -5f6hjZf9Yw | 12 | |
Missing from YouTube | This song is an oriental folk song featuring a male voice singing at a high pitch. The voice is tremulous. This is accompanied by the Chinese fiddle playing a melody similar to the main voice. A flute also plays the same melody as the voice. The percussion plays random beats leaving a lot of room in between. This song can be played in an Asian movie where a man is trying to woo a girl in a village. | ["Music of Asia", "Folk music", "Music"] | ["oriental folk song", "male voice", "high pitched voice", "chinese fiddle", "oriental percussion", "flute", "slow tempo", "tremulous voice"] | 0 | 2328 | |||||
Light of Asia - Teaser original music by Divana Ensemble (Film concert) | A male singer sings this pensive melody. The tempo is slow with a Sarangi accompaniment . The instrumentation is minimal with vocal emphasis. The song uses classical Ragas and alaps to form a melody. The song is sad, pensive, regretful, pensive, melancholic, emotional, contemplative, wistful and meditative. This song is an Indian Classical. | 2013-07-17T06:13:03Z | ZamanProduction | a film directed by Franz Osten and Himansu Rai (1925) Film concert produced by Zaman Production Special thanks to British Film Institute, Arte TV, and Théâtre National de Toulouse | ["Carnatic music", "Mantra", "Folk music", "Music"] | ["classical music", "slow tempo", "alap", "raga", "sarangi", "meditative", "contemplative", "wistful", "lucid vocals", "melancholic", "pensive", "emotional", "indian bowed string instrument", "swar", "vocalisation", "chanting", "sad", "poignant"] | 7 | QfM5-WqvquQ | 2635 | |
Sam Stone - John Prine | A male vocalist sings this melancholic country song. The tempo is slow with acoustic guitar lead and harmony with another string instrument accompanying. The song is soft, mellow, sad, pensive, melancholic and poignant with a sweet , pleasant melody. This song is a Classic Country song. | 2009-12-03T02:53:38Z | HouseOBVIOUSLY | Classic John Prine right here. | ["Folk music", "Music"] | ["male vocalist", "slow tempo", "acoustic guitar", "simple melody", "hillbilly music", "banjo", "old-time country rock", "folk lyrics", "country music", "bluegrass", "country hits", "regional music", "country folk songs", "acoustic bass", "mellow", "soft", "sentimental", "nostalgic", "pensive", "melancholy", "story telling"] | 7 | Sl9ZkYViEIs | 2787 |
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;