musiccaps_details (view)
2 rows where musiccaps_aspects contains "chordophone" and musiccaps_author = 7 sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- chordophone · 2 ✖
- instrumental 2
- ancient instrument 1
- beautiful 1
- bow shaped harp 1
- calming 1
- carnatic music 1
- cascading melody 1
- celestial 1
- classical music 1
- clear 1
- dexterous 1
- dreamy 1
- ethereal 1
- flowing 1
- full sounding 1
- gentle 1
- harp 1
- harp solo 1
- hindu mythology 1
- indian classical 1
- instrument of a goddess 1
- medium fast tempo 1
- mellow 1
- minimalist 1
- oldest instrument 1
- plucked string instrument 1
- resonating 1
- rich 1
- sharp sound 1
- skilled musician 1
- slow tempo 1
- soothing 1
- south indian music 1
- string instrument 1
- stringed instrument 1
- tanpura accompaniment 1
- veena solo 1
- western classical 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Excerpts in carnatic music. VEENA - shree raga tanam by emani shankara shastri | A musician plays this classical instrumental. The tempo is medium with the musician playing a beautiful harmony using ragas with skill and dexterity with a tanpura accompaniment .The music is calming, complex, pleasant, classic and melodic. | 2011-09-12T20:57:10Z | Sunil Anandatheertha, PhD | ["Carnatic music", "Music", "Sitar"] | ["instrumental", "indian classical", "tanpura accompaniment", "medium fast tempo", "veena solo", "string instrument", "ancient instrument", "dexterous", "skilled musician", "south indian music", "carnatic music", "chordophone", "instrument of a goddess", "hindu mythology"] | 7 | QKkhwAAGLIE | 2614 | ||
Bach Prelude and Fugue BWV 539 | This music is a beautiful Harp instrumental. The tempo is slow with a mellow, gentle and rich Harp melody. The music is dreamy, cascading, ethereal, soothing, calming and harmonic. This music is a Western Classical Harp Solo. | 2011-01-08T20:54:38Z | cbembia | Caroline Bembia playing Bach's Prelude and Fugue in d minor, transcribed for harp | ["Harp", "Pizzicato"] | ["instrumental", "slow tempo", "harp", "gentle", "mellow", "soothing", "harp solo", "minimalist", "celestial", "ethereal", "beautiful", "calming", "stringed instrument", "plucked string instrument", "classical music", "western classical", "bow shaped harp", "chordophone", "oldest instrument", "full sounding", "clear", "flowing", "dreamy", "resonating", "sharp sound", "cascading melody", "rich"] | 7 | POOu05eUvqE | 2531 |
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;