musiccaps_details (view)
2 rows where musiccaps_aspects contains "carnatic music" and musiccaps_aspects contains "emotional"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- carnatic music · 2 ✖
- devotional 2
- emotional · 2 ✖
- arnatic music 1
- classical singing style 1
- distorted harmonies 1
- extremely bad audio quality 1
- female singers 1
- festivities 1
- flute countermelody 1
- garbled tones 1
- guitar accompaniment 1
- heartfelt 1
- indian classical music 1
- me drum tempo 1
- meditational 1
- medium tempo 1
- passionate 1
- prayers 1
- rich traditions 1
- south india 1
- steady techno drumming rhythm 1
- stringed instrument countermelody 1
- stringed instrument harmony 1
- strong bass line 1
- tabla playing 1
- tamil devotional songs 1
- traditional music 1
- various percussions 1
- veena 1
- vocal duo 1
- vocal harmony 1
- well being 1
musiccaps_names (array) 7 ✖
- Carnatic music 1
- Classical music 1
- Drum 1
- Music 1
- Music of Asia 1
- Percussion 1
- Tabla 1
youtube_published (date) 2 ✖
- 2010-02-08 1
- 2012-01-10 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Mylapore Kolam festival, 2012 | The song is an instrumental. The tempo is medium with a tabla playing percussion, Veena and other stringed instruments playing harmony. The audio quality of the video is very poor. The song is a classical Carnatic music tune. | 2012-01-10T10:49:26Z | Karthik Subramanian | Mylapore Day Festival is celebrated every year in Chennai in the month of January, organized by Mylapore Times, local weekly tabloid. It has several events, one of which is the 'Kolam Festival'. Kollams are traditional designs found at Hindu households, drawn at the entrance of the houses using rice flour. | ["Tabla", "Drum", "Percussion"] | ["extremely bad audio quality", "garbled tones", "carnatic music", "medium tempo", "festivities", "south india", "rich traditions", "distorted harmonies", "indian classical music", "arnatic music", "tabla playing", "veena", "various percussions", "me drum tempo", "traditional music", "devotional", "emotional", "well being"] | 1 | njybD3PNrlc | 4572 |
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;