musiccaps_details (view)
4 rows where musiccaps_aspects contains "tablas" and musiccaps_names contains "Folk music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- tablas · 4 ✖
- hindi 2
- accordion-like wind instrument 1
- acoustic guitar 1
- bansuri flute 1
- clapping 1
- energetic meditative 1
- female voice singing in higher register 1
- higher pitch 1
- hindi/pop 1
- kids voice singing 1
- male voice singing 1
- male voices singing 1
- medium tempo 1
- medium to upbeat 1
- medium to uptempo 1
- oriental music 1
- peaceful sounding 1
- percussion's 1
- slower to medium tempo 1
- string instrument 1
- strings 1
- violin 1
musiccaps_names (array) 6 ✖
- Folk music · 4 ✖
- Music 4
- Carnatic music 1
- Music of Bollywood 1
- Singing 1
- Sitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
swamy ayappan | This audio contains a lot of percussion such as tablas playing a rhythm along with shakers and more. Male voices are singing something like a mantra repeating the same melody. Kids' voices are also singing the same melody in a higher octave. A bansuri flute adds little melody lines. This song may be playing during a ceremony. | 2007-11-26T15:05:19Z | maheshmanohar4u | ayappa music video, director maheshmanohar, | ["Singing", "Folk music", "Music"] | ["hindi", "bansuri flute", "male voices singing", "kids voice singing", "tablas", "string instrument", "slower to medium tempo", "energetic meditative"] | 6 | HyXMWRU9Owc | 1854 | |
Dil ka khilona haye toot gya.flv | Percussions and tablas are playing a steady rhythm while a female voice sings a sad sounding melody in a high pitched voice. String instruments are playing along with the melody while others are adding a short melody at the end of a musical phrase. This song may be playing in a Hindi-movie. | 2010-08-23T05:48:40Z | Muhammad Ahmad | Old is Gold, Old Songs, Lata Mangeshkar | ["Folk music", "Music", "Music of Bollywood"] | ["hindi", "percussion's", "strings", "tablas", "female voice singing in higher register", "medium tempo"] | 6 | KSye2ifWZ_Y | 2084 | |
Canti indiani e harmonium | A accordion-like wind instrument is playing a melody along with someone playing a rhythm on the tablas. This song may be playing at a music school jamming with the teacher. | 2009-12-01T17:08:58Z | Scuola Olistica Ananda Ashram Milano | http://www.yogamilano.it/corsi-settimanali/musica-indiana/ | ["Carnatic music", "Folk music", "Music", "Sitar"] | ["oriental music", "accordion-like wind instrument", "tablas", "medium to upbeat"] | 6 | U4UtZeTl2DE | 2886 | |
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;