musiccaps_details (view)
2 rows where musiccaps_aspects contains "indian percussion" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- indian classical 2
- indian percussion · 2 ✖
- christian music 1
- christian worship song 1
- classical music 1
- concert 1
- devotional 1
- digital drum 1
- fast tempo 1
- female vocalist 1
- foreign language 1
- hindustani 1
- hindustani instrumental 1
- indian music 1
- indian string instrument 1
- indian wind instrument 1
- instrumental 1
- lively veena harmony 1
- mellow 1
- melodic flute harmony 1
- north indian classical music 1
- raga 1
- rhythmic acoustic guitar 1
- sandhya raag 1
- saxophone 1
- slow tempo 1
- soft melody 1
- south indian music 1
- sruti 1
- taal 1
- tabla 1
- tabla rhythm 1
- tambourine 1
- tamil christian worship 1
- tamil music 1
- tanpura 1
- violin harmony 1
- wood wind 1
musiccaps_names (array) 5 ✖
- Music 2
- Folk music 1
- Gospel music 1
- Independent music 1
- Sitar 1
youtube_channel 2 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ravi Shankar Playing Sandhya Raag And Asaad Khaan On Veena | This music is a lively instrumental of the Indian Classical instruments. The tempo is fast with a lead Veena harmony, spirited tabla and tanpura rhythm and melodic flute accompaniment. The music is euphoric, mellifluous, dulcet, lively, high spirited and rich. This music is a Indian Classical Veena instrumental. | 2008-07-09T03:07:28Z | shreend | enjoy ppl | ["Folk music", "Music", "Sitar"] | ["instrumental", "fast tempo", "lively veena harmony", "raga", "indian classical", "hindustani instrumental", "concert", "north indian classical music", "indian string instrument", "indian wind instrument", "sandhya raag", "classical music", "hindustani", "taal", "sruti", "melodic flute harmony", "tanpura", "tabla rhythm", "indian percussion"] | 7 | 4Yc71_dU3m4 | 584 | |
Tamil Christian Song - Nee illatha by Hema John- Zion Music Festival '09 | A female vocalist sings this soft melody. The tempo is slow with violin harmony, keyboard accompaniment, saxophone, digital drum, tabla and tambourine beats. The song is mellow, soft, melodic, soothing, calming , devotional and euphonious. This song is a Tamil Christian Song. | 2010-11-04T07:04:36Z | endtimezionministry | http://www.endtimezionministries.org Through Him (Jesus) all things were made; without Him nothing was made that has been made. In Him was life, and that life was the light of all mankind. John:1:3,4 | ["Gospel music", "Music", "Independent music"] | ["female vocalist", "slow tempo", "foreign language", "wood wind", "rhythmic acoustic guitar", "tabla", "indian percussion", "tambourine", "indian music", "indian classical", "south indian music", "tamil music", "violin harmony", "digital drum", "saxophone", "soft melody", "mellow", "devotional", "christian music", "christian worship song", "tamil christian worship"] | 7 | ghW2xZMvpIQ | 4046 |
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;