musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "hindi song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- amateur recording · 2 ✖
- high pitch 2
- hindi song · 2 ✖
- ambient sounds 1
- devotional song 1
- female vocals 1
- female voice singing 1
- high notes 1
- hindi movie song 1
- hindu devotion music 1
- indian classical 1
- indian devotion music 1
- indian music 1
- inferior audio quality 1
- keyboard 1
- keyboard harmony 1
- live performance 1
- people cheering 1
- percussion's 1
- shakers 1
- slow tempo 1
- slower to medium tempo 1
- song introduction 1
- strings 1
- tambourine 1
- tanpura 1
- violin harmony 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
nitin chakrdhari katra ( jk ) satyam shivam | A female vocalist sings this Hindi Devotion song. The tempo is slow with keyboard harmony,tambourine beats, violin melody and rhythmic tanpura accompaniment. This clip is the song introduction with slow chants like singing. The song is a Hindu Devotion song to the God Shiva. It is emotional, sentimental, devotional, prayerful praise and worship. There are ambient sounds of people talking and cheering, indicating that this is a live performance. | 2012-03-20T04:43:45Z | NCRC STUDIO | nitin chakrdhari enterainmant perfomer | ["Music of Asia", "Music", "Synthetic singing"] | ["female vocals", "slow tempo", "high pitch", "high notes", "tambourine", "indian classical", "indian devotion music", "hindu devotion music", "indian music", "keyboard harmony", "hindi song", "hindi movie song", "devotional song", "song introduction", "amateur recording", "inferior audio quality", "live performance", "people cheering", "violin harmony", "keyboard", "shakers", "tanpura", "ambient sounds"] | 7 | HdRPdh-cSTw | 1821 | |
Anita's Dance Factory-Old Hindi Songs Medley | This song contains a female voice singing in a high pitch along to strings playing their own supportive melody and percussion's holding a groove with different elements. This is an amateur recording. This song may be playing at a gym during dancing classes. | 2013-12-23T13:14:15Z | It's Anita Arora | Music: Aaj Phir Jeene Ki Tamana Hai-Guide Hothon Pe Aasi Baat-Jewal Thief Mera Naam Chin Chin Choo-Howrah Bridge http://www.anitasdancefactory.co.uk/ https://www.facebook.com/anitasdancefactory anitasdancefactory@mail.com | ["Singing", "Music", "Song", "Tambourine", "Music of Bollywood"] | ["hindi song", "female voice singing", "high pitch", "strings", "percussion's", "slower to medium tempo", "amateur recording"] | 6 | N_LKZjw9DLk | 2349 |
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;