musiccaps_details (view)
3 rows where musiccaps_aspects contains "male voice", musiccaps_aspects contains "moderate tempo" and musiccaps_names contains "Folk music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LaurelBellydance - Middle Eastern Music & Dance Camp 2011 | This middle-eastern song features a male voice singing the main melody. An oud plays the same melody as the voice. This is accompanied by middle-eastern percussion instruments played with the hands. A tambourine is played to accent the percussion beats. After the voice, the main melody is played on a flute. This is accompanied by a qanun. This song can be played for a belly dance programme. | 2011-09-04T20:49:36Z | LaurelBellydance | www.laurelbellydance.com | ["Folk music", "Music", "Middle Eastern music", "Bluegrass", "Bowed string instrument"] | ["middle eastern song", "flute", "oud", "qanun", "percussion", "tambourine", "song for belly dance", "male voice", "moderate tempo"] | 0 | NHA1l_Czm38 | 2327 | |
Entertainment | Rajasthan Folk Music | India Folk Dance | Banjara | Banjaran | This amateur recording features a folk song played in India. The main melody is sung by a male voice. This is accompanied by a tabla and dhol playing the percussion parts in an Indian beat. A sarangi plays the same melody as the main voice. The sitar plays the rhythm parts. Cymbals are played at every count of each bar. This song can be played for a cultural dance programme. | 2012-02-23T07:57:26Z | Pooja Sharma | Banjara tribe of Indian state of Rajasthan nomadic people and also known as "Gypsies of India". Their colourful dresses, traditional jewellery, folk dance and folk music is world famous. The male members of Banjara tribe are called "Banjara" and the female members are called "Banjaran". In this video, you can see the traditional folk dance of a "Banjaran" on the beats of a folk music of Rajasthan. Join me at Facebook : http://www.facebook.com/profile.php?id=100003591671951 Join me at Twitter : https://twitter.com/#!/Pooja1186 | ["Folk music", "Music", "Song", "Maraca"] | ["amateur recording", "indian folk song", "tabla", "sarangi", "moderate tempo", "male voice"] | 0 | OoyxPPoPmt0 | 2472 | |
Cairo Egyptian Folk Song | This Middle eastern folk song features a male singer singing the main melody. This is accompanied by percussion playing a simple beat. A stringed instrument plays the backing melody. A shaker plays in an eight note pattern. This song can be played at a village fair. | 2007-12-07T00:49:47Z | evanmurph1 | Cairo Egyptian Folk Song | ["Folk music", "Music", "Rattle (instrument)"] | ["middle eastern folk music", "low quality audio", "percussion", "shaker", "stringed instrument", "moderate tempo", "male voice"] | 0 | yYpfb_xV--4 | 5417 |
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;