musiccaps_details (view)
3 rows where musiccaps_aspects contains "raga", musiccaps_author = 7 and musiccaps_names contains "Tabla"
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- raga · 3 ✖
- fast tempo 2
- indian classical 2
- instrumental 2
- live performance 2
- sruti 2
- ambient sounds 1
- bhakti 1
- carnatic music 1
- classical 1
- classical music 1
- concert 1
- devotional 1
- drone layer 1
- engaging 1
- ghatam 1
- ghungaroos sound 1
- harmonium melody 1
- hindustani music 1
- indian classical instruments 1
- indian classical music 1
- indian percussion instrument 1
- live audience 1
- lively 1
- lively tabla rhythm 1
- lute 1
- male vocalist 1
- medium tempo 1
- melodic layer 1
- mesmerising 1
- minimalist music 1
- mridangam 1
- oud 1
- pakistani music 1
- people talking 1
- percussion layer 1
- sarod harmony 1
- sing introduction 1
- skilful musicians 1
- sliding pitches 1
- soloist 1
- song interlude 1
- south indian classical music 1
- south indian music 1
- spirited 1
- stringed instrument 1
- sympathetic strings 1
- taal 1
- tabla 1
- violin accompaniment 1
musiccaps_names (array) 7 ✖
- Percussion 3
- Tabla · 3 ✖
- Drum 2
- Guitar 1
- Music 1
- Musical instrument 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Daud Khan Sadozai - live - 2013 | This music is a mellifluous Indian classical instrumental. The tempo is fast with a harmonic sarod and rhythmic Oud accompaniment. The music is mesmerising, spirited, engaging, captivating and skilfully rendered Ragas. This instrumental is an Indian/Pakistani classical music. | 2013-02-10T17:18:05Z | soon4ward | Daud Khan live 26-01-2013 in Hagen, Germany. Daud Khan Sadozai - Robab, Sarod Efren Lopez - Robab, Oud Yma Karin / Shekab Wadwa- Tabla | ["Tabla", "Traditional music", "Guitar", "Music", "Musical instrument", "Percussion"] | ["instrumental", "medium tempo", "sarod harmony", "oud", "hindustani music", "indian classical", "stringed instrument", "lute", "pakistani music", "mesmerising", "engaging", "skilful musicians", "raga", "sympathetic strings", "sliding pitches", "indian classical instruments"] | 7 | ALU-1AILj1c | 1107 | |
Rashid Jahangir (zamanai poak na hum dum) | This music is an instrumental.the tempo is fast with a harmonium melody and tabla accompaniment. The performance is live with ambient sounds of people talking, sound of glass bangles and a woman’s voice. This music is Indian Classical. | 2008-10-30T22:02:58Z | u297777 | Rashid Jahangir from doda city (J&K) | ["Tabla", "Drum", "Percussion"] | ["instrumental", "fast tempo", "harmonium melody", "indian classical", "raga", "sruti", "classical", "indian percussion instrument", "lively tabla rhythm", "live performance", "live audience", "ambient sounds", "people talking", "ghungaroos sound", "people talking", "lively", "spirited", "song interlude", "sing introduction"] | 7 | EnewI6fNhVA | 1590 | |
Malakkuda 2012 - Kacheri By Thrikkodithanam Sachithanandan / Aalayal Thara Venam | A male vocalist sings this Classical song. The tempo is fast with animated ghatam, mridangam and tabla accompaniment and violin harmony. The vocals are classical notes and lyrics in a South Indian language. The song has three layers, the melody, percussion and drone. This song is a devotional Carnatic Classical song. | 2013-03-11T04:02:09Z | Poruvazhy Peruviruthy Malanada Temple | Poruvazhy Peruviruthy Malanada - The one and only Duryodhana Temple in South India | ["Tabla", "Drum", "Percussion"] | ["male vocalist", "fast tempo", "carnatic music", "soloist", "classical music", "indian classical music", "south indian music", "south indian classical music", "ghatam", "mridangam", "violin accompaniment", "tabla", "raga", "sruti", "taal", "concert", "live performance", "melodic layer", "percussion layer", "drone layer", "minimalist music", "bhakti", "devotional"] | 7 | mx7kjFY7ALs | 4505 |
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;