musiccaps_details (view)
2 rows where musiccaps_aspects contains "hindi/pop" and musiccaps_names contains "Folk music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- hindi/pop · 2 ✖
- acoustic guitar 1
- clapping 1
- dance 1
- fast tempo 1
- female voice 1
- flutes 1
- higher pitch 1
- higher register 1
- loud 1
- male voice singing 1
- medium to uptempo 1
- peaceful sounding 1
- percussion instruments 1
- tablas 1
- violin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Premlata & Party Live Program | Dhore Mathe Jhupadi | Premlata | Rajasthani Traditional Folk Song | A female voice is singing loud and in a high key. Her voice is full of reverb and a little delay. It is so loud that the speakers are speaking a lot. There are percussive instruments like chimes and tabla like sounds playing a rhythm while a flute is playing a melody in the background. This is an amateur recording with poor recording quality. This song may be playing at a local dance event. | 2015-06-17T08:30:00Z | RDC Rajasthani | एक बार ज़रूर देखिये ट्विंकल वैष्णव का सबसे ज़्यादा देखे जाने वाला सांग ☛ http://bit.do/NachNachAayoPasinoFEMALEVersion Watch:: Premlata & Party Live "Dhore Mathe Jhupadi" Song : Dhore Mathe Jhupadi Singer : Premlata & Party Music Label : PRG Music & Films Studio If you like this video, Please don't forgot to Share with your friends and leave your comments Subscribe Here For More Updates & See Latest Videos : http://www.youtube.com/subscription_center?add_user=RDCRajasthani Follow Us On Dailymotion : http://www.dailymotion.com/RDCRajasthani Like Us On Facebook : https://www.facebook.com/pages/Rangilo-Rajasthan/442823272504970?ref=hl Follow Us On Twitter : https://twitter.com/RDCRajasthani | ["Folk music", "Music"] | ["hindi/pop", "female voice", "loud", "higher register", "percussion instruments", "flutes", "fast tempo", "dance"] | 6 | Bl-lCgr5hGY | 1288 | |
Carrom - 10 Slams and 100 Ideas for Dynamic Carrom - Part1 of 12 | This song contains a tabla rhythm spread across both sides of the speakers. An acoustic guitar melody panned to the right side of the speakers. Far in the background you can hear clapping as part of the song. A male voice is singing in a higher register than a violin takes over playing a melody in a higher register with reverb and a little delay. This song may be playing in a lovely movie-scene. | 2009-09-16T03:35:04Z | carrompassion | 10 Slams and 100 Ideas for Dynamic Carrom - Part1 of 12 | ["Folk music", "Music"] | ["hindi/pop", "tablas", "violin", "acoustic guitar", "clapping", "male voice singing", "higher pitch", "medium to uptempo", "peaceful sounding"] | 6 | nFoktpUVeVw | 4528 |
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;