musiccaps_details (view)
2 rows where musiccaps_aspects contains "hypnotic" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- hypnotic · 2 ✖
- additive rhythm 1
- drone 1
- hand percussion 1
- male singer 1
- meditative 1
- microtonal 1
- odd meter 1
- regular rhythm 1
- solo sitar 1
- string bending 1
- tape hiss 1
- tape warble 1
- trance inducing 1
- violin 1
- violin doubling singer 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pt Budhaditya Mukherjee, Raga Naaki Kanada Live 1992 Pt 1 | Solo sitar using microtonality, droning and string bending. The music is hypnotic and meditative and there is the sound of tape hiss and warble in the recording. | 2011-12-02T10:59:27Z | tripmonk0 | First part of Raga Nayaki Kanada with Partha Sarathy Mukherjee on tabla.. Made from an old VHS tape so sound & picture a bit ropey!! Sorry!! | ["Carnatic music", "Music", "Musical instrument", "Plucked string instrument", "Sitar"] | ["solo sitar", "drone", "microtonal", "string bending", "meditative", "hypnotic", "tape warble", "tape hiss"] | 8 | feC0L9MtghM | 3966 | |
Ekkadi Manusha Janmam? (Annamacharya song) | Hand percussion accompanies a male singer and violin doubling a melody with a constant regular rhythm. Mood is hypnotic and trance inducing. Features additive rhythms and odd meters. | 2007-06-11T23:00:23Z | musiquebox | Prince Rama Varma renders an eloquent Annamacharya composition in the Raaga Revagupti at NGMA Mumbai. He is accompanied on the violin by Shri Madhavan and on the mridangam by Shri Ganesh. | ["Tabla", "Percussion"] | ["hand percussion", "male singer", "regular rhythm", "violin", "violin doubling singer", "hypnotic", "trance inducing", "additive rhythm", "odd meter"] | 8 | w_XFNKSRgKI | 5276 |
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;