musiccaps_details (view)
2 rows where musiccaps_aspects contains "hindustani music" and musiccaps_names contains "Classical music" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- hindustani music · 2 ✖
- captivating 1
- dexterous 1
- energetic dholak 1
- engaging 1
- fast tempo 1
- hindustani classical 1
- indian classical 1
- indian percussions 1
- indian string instrument 1
- instrumental 1
- intermittent cutting off of sound 1
- lively sitar 1
- low quality audio 1
- moderate tempo 1
- no other instruments 1
- no voices 1
- raga 1
- skilled 1
- sound cut off 1
- spirited tabla 1
- subtle keyboard harmony 1
- taal 1
- veena 1
- vibrant 1
- vigorous 1
- vivacious 1
musiccaps_names (array) 6 ✖
- Classical music · 2 ✖
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Carnatic music 1
- Sitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Taj Mahal Tea presents E-baithak, India’s biggest classical concert. | This music is an Indian classical instrumental. The tempo is fast with an animated Sitar lead, supported with rhythmic beats of lively tabla and dholak , along with a soft and subtle keyboard accompaniment. The music is upbeat, vibrant, vivacious, vigorous , engaging and captivating. This instrumental is a Hindustani classical. | 2014-12-19T12:37:54Z | Taj Mahal Tea | Experience Indian Classical Music at its best with E-baithak, India’s biggest classical concert featuring the maestro Niladri Kumar and hosted by the gorgeous Madhuri Dixit. We are sure that this experience will make your heart say ‘Wah Taj!’ | ["Music", "Musical instrument", "Plucked string instrument", "Classical music", "Sitar"] | ["instrumental", "fast tempo", "lively sitar", "hindustani music", "dexterous", "skilled", "hindustani classical", "spirited tabla", "vivacious", "vibrant", "energetic dholak", "indian percussions", "indian string instrument", "indian classical", "raga", "taal", "subtle keyboard harmony", "vigorous", "engaging", "captivating"] | 7 | nUs5SJyQPnM | 4544 | |
Notable Vainika Series: Jayanthi Kumaresh | This is a low quality recording of a veena being played. This is a classical Hindustani song. The veena plays a note bending the string to a higher note and then descending back to the original note. The audio gets cut off intermittently. Briefly, during the places where the audio is heard, a tabla is heard. There are no voices in this song. This song can be played in a conservative Indian movie featuring a wedding scene. | 2007-05-30T23:22:30Z | GopalMeera | Part-1: An exponent of the Tanjore style and a direct desciple of the legendary Veena S. Balachander. | ["Carnatic music", "Music", "Musical instrument", "Plucked string instrument", "Classical music"] | ["low quality audio", "hindustani music", "veena", "no voices", "no other instruments", "sound cut off", "intermittent cutting off of sound", "moderate tempo"] | 0 | XzRxO8n3WRE | 3243 |
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;