musiccaps_details (view)
3 rows where "youtube_published" is on date 2007-05-07
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- hindi 2
- tablas 2
- amateur recording 1
- audio stuttering 1
- childish vocal 1
- crushed 1
- fast tempo 1
- female voice singing 1
- fun 1
- funky guitar melody 1
- groovy piano 1
- happy 1
- kids song 1
- low quality 1
- messy 1
- mono 1
- muffled 1
- noisy 1
- string instrument 1
- thin 1
- uptempo 1
- zitar 1
musiccaps_names (array) 10 ✖
- Music 2
- Carnatic music 1
- Classical music 1
- Drum 1
- Inside, small room 1
- Music of Asia 1
- Percussion 1
- Singing 1
- Synthetic singing 1
- Tabla 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DEVADHI DEVA- M S SUBBULAKSHMI | This audio contains someone playing tablas along to a string instrument playing a melody with a bow. A female voice is singing the same melody. This song may be playing live singing along to train singing. | 2007-05-07T03:58:56Z | crazydock | one of the excellent krithis! | ["Singing", "Carnatic music", "Music of Asia", "Music", "Classical music"] | ["hindi", "tablas", "string instrument", "female voice singing", "uptempo"] | 6 | CaCjiFUL6Fg | 1382 | |
Elmo | The low quality recording features a kids song played through a toy and it consists of childish vocal singing over groovy piano chords and funky guitar melody. It is noisy, in mono and it sounds happy, fun, but also thin, messy, muffled and crushed. | 2007-05-07T00:40:48Z | lttleD03 | Me dancing we elmo lol | ["Music", "Synthetic singing", "Inside, small room"] | ["low quality", "noisy", "kids song", "crushed", "mono", "audio stuttering", "muffled", "messy", "thin", "happy", "fun", "groovy piano", "childish vocal", "funky guitar melody"] | 4 | J7d3nuS9wqg | 1969 | |
Ustad Shujaat Khan Performs Shudh Kalyan | Someone is playing a fast paced melody on a sitar accompanied by someone playing a rhythm on tablas. This song may be playing live during a concert. | 2007-05-07T15:50:46Z | kamalhyder | This recording is from a live concert in Calcutta on March 13, 2005. Accompanying Khansahib on tabla is Yogesh Samsi, a brilliant young artist. The clarity and speed of Khansahib's jhalla is unbelievable!! | ["Tabla", "Drum", "Percussion"] | ["amateur recording", "hindi", "zitar", "tablas", "fast tempo"] | 6 | OseeYF_ud7g | 2477 |
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;