musiccaps_details (view)
3 rows where musiccaps_aspects contains "concert", musiccaps_aspects contains "enthralling" and musiccaps_aspects contains "fast tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- concert · 3 ✖
- enthralling · 3 ✖
- fast tempo · 3 ✖
- instrumental 2
- allegro 1
- allergissimo 1
- baroque 1
- captivating 1
- carnatic music 1
- cello 1
- chamber music 1
- clapping 1
- classical 1
- delicate 1
- devotional 1
- dual keyboard 1
- duel 1
- electrifying 1
- enchanting 1
- english dance 1
- ethereal 1
- exquisite 1
- extravagant 1
- ghatak 1
- harpsichord 1
- harpsichord solo 1
- hindu deities 1
- indian classical 1
- italian classical 1
- jugalbandi 1
- live audience 1
- live performance 1
- male vocalist 1
- melodic 1
- melodious 1
- merry 1
- mridangam 1
- muffled audio 1
- orchestra 1
- paino accompaniment 1
- people cheering 1
- pulsating 1
- ragas 1
- renaissance music 1
- sharp sounds 1
- south indian classical 1
- spectacular 1
- sruti 1
- stage performance 1
- symphony 1
- viola 1
- violin 1
- violin solo 1
- violin symphony 1
- vocal duel 1
- western classical 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chembai and Yesudas Shiva Shiva Shiva enarAdA - 2 of 3 | Two male vocalists sing this melodic Indian Classical music. The tempo is medium slow with Carnatic music accompaniments like violin, Ghatak and mridangam. The song is a good natured vocal duel between two carnatically trained vocalists. There is the sound of people cheering and clapping to the beat in the background. | 2010-03-04T07:13:39Z | Sunil Anandatheertha, PhD | This is a classic by "Chembai and Yesudas". In this concert, we get a rare chance to know the Guru-Sishya sambandha of these two great vocalists, wherein, Chembai is actually teaching Yesudas and Yesudas tries very hard to follow his Guru. :) http://vishnuiseverywhere.blog | ["Carnatic music", "Music", "Middle Eastern music", "Classical music"] | ["male vocalist", "fast tempo", "ghatak", "devotional", "hindu deities", "mridangam", "ragas", "sruti", "violin", "carnatic music", "indian classical", "south indian classical", "people cheering", "clapping", "jugalbandi", "duel", "vocal duel", "enthralling", "melodic", "muffled audio", "concert", "stage performance"] | 7 | GHyUAl9Yaos | 1708 | |
Antonio Vivaldi Concerto for Violin in D minor 'Per Pisendel' RV 242 | This music is a rich Italian Classical Orchestra. The tempo is fast with a symphonic orchestra with a rich ,animated violin solo, complete with violin, cello viola , flute and piano accompaniment . This music is a sonic treat. It is rich, expressive, exquisite, spectacular, enthralling and captivating. This music is a Baroque classical. | 2011-12-10T06:57:27Z | Ahmed Barod | ["Orchestra"] | ["instrumental", "fast tempo", "orchestra", "allergissimo", "allegro", "symphony", "violin symphony", "violin solo", "italian classical", "violin solo", "cello", "viola", "classical", "exquisite", "delicate", "merry", "enchanting", "captivating", "enthralling", "baroque", "english dance", "chamber music", "extravagant", "spectacular", "pulsating", "electrifying", "live performance", "live audience", "concert", "paino accompaniment"] | 7 | adHhqDnyZv8 | 3561 | ||
Domenico Scarlatti Sonata K 56 | This music is instrumental. The tempo is fast with an enthralling harpsichord melody. The music is an energetic, high-powered, vibrant, vivacious and melodious western classical. | 2008-07-10T04:33:22Z | Rosana Lanzelotte | Rosana Lanzelotte - Harpsichord | ["Harpsichord", "Keyboard (musical)"] | ["instrumental", "fast tempo", "harpsichord", "renaissance music", "western classical", "concert", "enthralling", "ethereal", "harpsichord solo", "dual keyboard", "sharp sounds", "melodious"] | 7 | jjYXRmE19lQ | 4278 |
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;