musiccaps_details (view)
2 rows where musiccaps_aspects contains "trance" and musiccaps_author = 1 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- devotional 2
- trance · 2 ✖
- asian stringed instruments 1
- bad audio quality 1
- choral chants 1
- congregation singing 1
- deteriorated audio quality 1
- drunken stupor 1
- festival 1
- groovy music 1
- hare krishna 1
- high spirits 1
- indian music 1
- inspiring 1
- male singer chanting 1
- me drum fats tempo 1
- meditational 1
- passionate 1
- people clapping 1
- poor audio quality 1
- prayer chanting 1
- psychedelic chanting 1
- religious 1
- slow tempo 1
- spirited 1
- stringed indian instruments 1
- tabla playing percussively 1
- tambourine percussions 1
- trippy music 1
- unison singing 1
- violin playing 1
- vocal chanting 1
- warbled string harmony 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 | |
Nhạc Ru Bé Ngủ Dân Ca Nam Bộ | A male singer sings this chanting vocals. The song is slow tempo with stringed instrument harmony that warbles and creates a psychedelic effect with no percussion. The song is trance and probably a prayer chant. The song is poor in audio quality. | 2015-03-21T14:12:10Z | Đặng Hoàng Phúc | Cho bé giấc ngủ ngon. | ["Music", "Sitar"] | ["bad audio quality", "warbled string harmony", "male singer chanting", "slow tempo", "psychedelic chanting", "trippy music", "trance", "asian stringed instruments", "meditational", "high spirits", "drunken stupor", "vocal chanting", "devotional", "prayer chanting", "deteriorated audio quality"] | 1 | BSe5J0KlN3k | 1241 |
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;