musiccaps_details (view)
2 rows where musiccaps_aspects contains "engaging", musiccaps_aspects contains "vibrant" and musiccaps_aspects contains "vivacious"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- engaging · 2 ✖
- fast tempo 2
- vibrant · 2 ✖
- vivacious · 2 ✖
- alternative rock 1
- captivating 1
- classic rock 1
- dexterous 1
- energetic dholak 1
- female vocalist 1
- groovy bass lines 1
- hindustani classical 1
- hindustani music 1
- indian classical 1
- indian percussions 1
- indian string instrument 1
- instrumental 1
- lively sitar 1
- powerful 1
- progressive rock 1
- raga 1
- rock 1
- skilled 1
- slick drumming 1
- soft rock 1
- spirited tabla 1
- subtle keyboard harmony 1
- symphonic rock 1
- synthesiser articulation 1
- taal 1
- vibrant electric guitars 1
- vigorous 1
- youthful 1
musiccaps_names (array) 12 ✖
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 | |
Magenta - King Of The Skies | A female vocalist sings this spirited song. The tempo is fast with enthusiastic electric guitar harmony, slick drumming, groovy bass lines and synthesiser arrangements. The song is energetic, youthful, fun, pulsating, engaging and emphatic. This song is Alternative Rock. | 2006-06-21T17:59:15Z | chrismagenta | Track from Magenta's The Gathering DVD. Amazing Welsh Progressive Rock band in the vain of Genesis, Yes and Renaissance. | ["Singing", "Heavy metal", "Music", "Independent music", "Pop music", "Rock music", "Song", "Progressive rock"] | ["female vocalist", "fast tempo", "vibrant electric guitars", "progressive rock", "symphonic rock", "alternative rock", "slick drumming", "synthesiser articulation", "vivacious", "youthful", "vibrant", "groovy bass lines", "engaging", "powerful", "rock", "classic rock", "soft rock"] | 7 | pp6eSGANq0Y | 4737 |
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;