musiccaps_details (view)
3 rows where musiccaps_aspects contains "devotional" and musiccaps_aspects contains "trance" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 54 ✖
- devotional · 3 ✖
- trance · 3 ✖
- asian stringed instruments 1
- bad audio quality 1
- catchy riff 1
- chant 1
- choral chants 1
- congregation singing 1
- contemporary 1
- deteriorated audio quality 1
- drunken stupor 1
- enigmatic 1
- female singer 1
- festival 1
- flute melody 1
- groovy bass lines 1
- groovy music 1
- hare krishna 1
- high spirits 1
- hypnotic 1
- indian classical 1
- indian god 1
- indian music 1
- inspiring 1
- keyboard accompaniment 1
- male singer chanting 1
- me drum fats tempo 1
- meditational 1
- meditative 1
- medium fast tempo 1
- melodious 1
- passionate 1
- people clapping 1
- poor audio quality 1
- prayer chanting 1
- psychedelic chanting 1
- psychedelic harmony 1
- puja 1
- religious 1
- slow tempo 1
- small hand cymbals 1
- spirited 1
- steel pan percussion 1
- stringed indian instruments 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- tabla playing percussively 1
- tambourine percussions 1
- trippy music 1
- unison singing 1
- violin playing 1
- vocal chanting 1
- warbled string harmony 1
- worship 1
musiccaps_names (array) 8 ✖
- Music 3
- Mantra 2
- Folk music 1
- Middle Eastern music 1
- Music of Asia 1
- Rattle (instrument) 1
- Sitar 1
- Song 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 | |
Maha Mantra Hare Krishna | A female vocalist sings this pleasant chant. The song is medium fast tempo with groovy basslines, mellifluous flute, steel pan beat,small hand cymbals and synthesiser arrangement. The song is sweet, melodic, hypnotic, enthralling, enigmatic, trance-like, trippy and psychedelic. This song is a contemporary indian worship song. | 2010-06-28T19:06:46Z | Nettan Von Pavarga | Hare Krishna mantra sung by Krishna Premi Krishna Premi (ACBSP) from her album "Nectar of the Holy Name". | ["Mantra", "Folk music", "Music", "Middle Eastern music", "Song"] | ["female singer", "medium fast tempo", "enigmatic", "hypnotic", "trance", "contemporary", "synthesiser arrangements", "flute melody", "small hand cymbals", "groovy bass lines", "keyboard accompaniment", "steel pan percussion", "synthesiser arrangement", "psychedelic harmony", "chant", "meditative", "indian classical", "puja", "devotional", "catchy riff", "melodious", "contemporary", "indian god", "worship"] | 7 | tdrz4EkIsow | 5055 | |
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;