musiccaps_details (view)
2 rows where musiccaps_names contains "Mantra" and musiccaps_names contains "Rattle (instrument)" sorted by youtube_link
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 39 ✖
- ambient outdoor sounds 1
- animated acoustic guitar rhythm 1
- choral chants 1
- congregation singing 1
- devotional 1
- earnest singing 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- festival 1
- folk song 1
- foreign language 1
- groovy music 1
- hand percussions 1
- hare krishna 1
- indian music 1
- inspiring 1
- lively 1
- male vocalists 1
- me drum fats tempo 1
- melodic 1
- outdoor singing 1
- passionate 1
- people clapping 1
- poor audio quality 1
- regional song 1
- religious 1
- shakers 1
- simple 1
- smal hand drum 1
- spirited 1
- stringed indian instruments 1
- tabla playing percussively 1
- tambourine 1
- tambourine percussions 1
- tambourine used as hand drum 1
- trance 1
- unison singing 1
- violin playing 1
musiccaps_names (array) 6 ✖
- Mantra · 2 ✖
- Music 2
- Rattle (instrument) · 2 ✖
- Bowed string instrument 1
- Music of Asia 1
- Musical instrument 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 | |
SINCHI WAIRA. MANTRA SUMA AMBIWASKA | A group of male vocalists sing this folk song in a foreign language. The tempo is fast with minimalist instruments like a lively acoustic guitar harmony, shakers and tambourine beat;The vocals are energetic, youthful, earnest, cheerful , happy, simple and chirpy. | 2013-04-23T07:17:55Z | Daniel Ortega | Poderoso mantra de sanación. Taita John Muchavisoy, Nicolas Lozada y Cristiam Herrán. Centro de sanación SINCHI WAIRA. | ["Mantra", "Music", "Musical instrument", "Rattle (instrument)", "Bowed string instrument"] | ["male vocalists", "fast tempo", "foreign language", "tambourine", "tambourine used as hand drum", "animated acoustic guitar rhythm", "hand percussions", "shakers", "smal hand drum", "folk song", "regional song", "outdoor singing", "ambient outdoor sounds", "engaging", "lively", "simple", "earnest singing", "enthusiastic", "melodic"] | 7 | qbIPQGY8RRA | 4800 |
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;