musiccaps_details (view)
2 rows where musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "tabla playing percussively" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- passionate 2
- poor audio quality · 2 ✖
- tabla playing percussively · 2 ✖
- ambient noises 1
- choral chants 1
- classical hindustani music 1
- concert hall 1
- congregation singing 1
- devotional 1
- double time percussion rhythm 1
- emotional 1
- ethic indian instruments 1
- festival 1
- groovy 1
- groovy music 1
- hare krishna 1
- himdustani music hits 1
- indian music 1
- inspiring 1
- instrumentals music 1
- live performance 1
- love performance 1
- me drum fats tempo 1
- medium tempo 1
- nostalgia 1
- people clapping 1
- religious 1
- replacing 1
- romantic 1
- sitar playing 1
- sitarist 1
- spirited 1
- stringed indian instruments 1
- tambourine percussions 1
- trance 1
- unison singing 1
- violin playing 1
musiccaps_names (array) 5 ✖
- Music 2
- Mantra 1
- Music of Asia 1
- Rattle (instrument) 1
- Sitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
HARE KRSNA - MAHA MANTRA KIRTAN 7 | People chant and sing in unison. The song is medium fast tempo with Indian percussion playing fast, violins and other stringed instruments playing harmony along with people clapping. The song is meditational and spirited. The audio quality is poor. | 2010-04-10T10:45:05Z | mitcmantraable | HH Indradyumna Swami HARE KRSNA | ["Mantra", "Music of Asia", "Music", "Rattle (instrument)"] | ["congregation singing", "unison singing", "poor audio quality", "people clapping", "indian music", "festival", "religious", "choral chants", "me drum fats tempo", "tambourine percussions", "tabla playing percussively", "stringed indian instruments", "violin playing", "trance", "hare krishna", "inspiring", "devotional", "passionate", "spirited", "groovy music"] | 1 | ZCKzgf3QD4M | 3346 | |
Pt Ravi Shankar at the Taj Mahal | The song is an instrumental. The song is medium tempo with a sitar playing solo, tabla playing percussively and other Indian percussion instruments. The song is emotional and poignant. The audio quality is very ordinary. | 2009-06-02T11:58:02Z | tripmonk0 | From Z-TV. This is the pandit's performance with his daughter, Anoushka, at the Taj Mahal in India. | ["Music", "Sitar"] | ["classical hindustani music", "sitar playing", "sitarist", "ethic indian instruments", "double time percussion rhythm", "groovy", "himdustani music hits", "live performance", "tabla playing percussively", "medium tempo", "love performance", "concert hall", "instrumentals music", "replacing", "passionate", "emotional", "romantic", "nostalgia", "poor audio quality", "ambient noises"] | 1 | 2Ic1zm9mBjk | 349 |
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;