musiccaps_details (view)
1 row where musiccaps_aspects contains "sarangi", musiccaps_author = 0 and musiccaps_names contains "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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;