musiccaps_details (view)
4 rows where musiccaps_aspects contains "passionate", musiccaps_author = 1 and musiccaps_names contains "Classical music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- passionate · 4 ✖
- carnatic music 3
- live performance 3
- medium tempo 3
- spirited 3
- emotional 2
- indian classical music 2
- live audience 2
- amateur quality recording 1
- ambient noise 1
- bad audio quality 1
- carnatic vocals 1
- cellist 1
- cello concerto 1
- classical singing style 1
- concert hall 1
- conductor 1
- devotional 1
- double reed instruments 1
- drone harmony tones 1
- dvorak 1
- emotional music 1
- energetic 1
- exciting 1
- female singers 1
- flute countermelody 1
- great composers 1
- great technique 1
- groovy music 1
- guitar accompaniment 1
- heartfelt 1
- indian wind instrument 1
- instrumental music 1
- lyrical melody 1
- male vocalist 1
- meditational 1
- mridangam percussion 1
- nadaswaram playing 1
- opera hall 1
- philharmonic orchestra 1
- poor audio quality 1
- prayers 1
- steady techno drumming rhythm 1
- string section 1
- stringed instrument countermelody 1
- stringed instrument harmony 1
- strong bass line 1
- tabla 1
- tamil devotional songs 1
- timpani bangs loud 1
- violins playing harmony 1
- virtuously 1
- vocal duo 1
- vocal harmony 1
- western classical music 1
- wind sections 1
musiccaps_names (array) 11 ✖
- Classical music · 4 ✖
- Music 4
- Carnatic music 3
- Musical instrument 3
- Bowed string instrument 1
- Cello 1
- Music of Asia 1
- Orchestra 1
- Percussion 1
- Singing 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Natheswaram Thavil Kachcheri SMT 2015 | The song is an instrumental Indian classical tune. The song is medium tempo with two Indian double reed instruments called nadaswaram playing in a duet. The song is emotional and highly lyrical . The song is amateur quality recording and a classic Carnatic music tune. | 2015-02-11T08:27:22Z | Rasiah Sriravindrarajah | Srilankan Natheswaram and Thavil vidwans played famous songs at an Inisai Kachcheri at the Sydney Murugan Cultural Hall on 10th Feb. 2015. Listed to three songs at the end of the Kachceri. | ["Carnatic music", "Music", "Musical instrument", "Classical music"] | ["carnatic music", "live performance", "nadaswaram playing", "medium tempo", "indian wind instrument", "double reed instruments", "emotional music", "lyrical melody", "ambient noise", "amateur quality recording", "indian classical music", "spirited", "passionate", "drone harmony tones"] | 1 | AjLX_1rBDPM | 1159 | |
DR.M.BALAMURALIKRISHNA - THILLANA | A male vocalist sings this traditional Carnatic vocals. The song is medium tempo with a violin accompaniment, tabla and mridangam playing percussion. The song is energetic and passionate and highlights the traditional Carnatic music art form. The audio quality is bad. | 2007-04-17T07:21:47Z | Musique4ever | Dr.M.Balamuralikrishna sings a thillana in Ahir Bhairav. | ["Singing", "Carnatic music", "Music", "Musical instrument", "Classical music", "Percussion"] | ["carnatic music", "male vocalist", "medium tempo", "tabla", "energetic", "passionate", "indian classical music", "bad audio quality", "live performance", "live audience", "passionate", "spirited", "exciting", "mridangam percussion", "carnatic vocals"] | 1 | Emc18GpAeRY | 1588 | |
Parvai ondre pothume - Carnatic Fusion Tamil Kannan Song by S. J. Jananiy | Female singers sing this vocal in Tamil harmony. The song is medium tempo with a strong techno drumming rhythm, guitar accompaniment, stringed instrument accompaniment, flute countermelody, and a strong bass line. The song is devotional and highly passionate. The song is a Carnatic Hindu devotional song sung in Tamil. | 2010-02-08T22:06:22Z | Saumi Music | Sharing another beautiful carnatic fusion sung by S.J. Jananiy. Follow us on Facebook: https://www.facebook.com/pages/Gnanalayam-Berlin/246868511997333 | ["Carnatic music", "Music of Asia", "Music", "Classical music"] | ["carnatic music", "female singers", "vocal harmony", "guitar accompaniment", "stringed instrument harmony", "emotional", "passionate", "meditational", "devotional", "heartfelt", "classical singing style", "vocal duo", "tamil devotional songs", "prayers", "flute countermelody", "guitar accompaniment", "stringed instrument countermelody", "strong bass line", "steady techno drumming rhythm"] | 1 | ROA6DMBPlNM | 2695 | |
Dvořák: Cello Concerto / Isserlis · Gilbert · Berliner Philharmoniker | The song is an instrumental. The tempo is medium with a cellist playing a virtuoso solo accompanied by a string section harmony, flutes in harmony and a loud banging timpani. The song is spirited and passionate with poor audio quality. The song is a western classical piece. | 2009-06-19T08:28:26Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/27/?a=youtube&c=true Antonín Dvořák: Cello Concerto / Steven Isserlis, cello · Alan Gilbert, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 19 April 2009. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Cello", "Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["cellist", "string section", "philharmonic orchestra", "cello concerto", "dvorak", "virtuously", "timpani bangs loud", "medium tempo", "wind sections", "violins playing harmony", "groovy music", "western classical music", "great composers", "conductor", "opera hall", "live audience", "live performance", "instrumental music", "passionate", "spirited", "emotional", "great technique", "poor audio quality", "concert hall"] | 1 | yrme-KRBvzk | 5445 |
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;