musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate", musiccaps_aspects contains "poor audio quality" and musiccaps_names contains "Rattle (instrument)"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- passionate · 2 ✖
- poor audio quality · 2 ✖
- arabian music influences 1
- choral chants 1
- congregation singing 1
- devotional 1
- drum rolls 1
- emotional 1
- entertaining 1
- festival 1
- flute solo 1
- folk music 1
- groovy music 1
- hare krishna 1
- indian music 1
- inspiring 1
- instrumental music 1
- keyboard accompaniment 1
- me drum fats tempo 1
- medium tempo 1
- people clapping 1
- religious 1
- retro songs 1
- romantic 1
- spirited 1
- steady drumming rhythm 1
- stringed indian instruments 1
- strong bass line 1
- tabla playing percussively 1
- tambourine percussions 1
- …
musiccaps_names (array) 4 ✖
- Music 2
- Rattle (instrument) · 2 ✖
- Mantra 1
- Music of Asia 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 | |
Az Baraye Ghame Man-Ahmad Zahir.wmv | The song is an instrumental. The song is medium tempo and has a delightful flute solo with keyboard accompaniment groovy bass line and a groovy drumming rhythm. The song has a poor recording quality. The song's middle eastern folk music vibes. | 2011-01-25T19:32:28Z | afgking16 | Ahmad Zahir Az Baraye Ghame Man | ["Music", "Rattle (instrument)"] | ["poor audio quality", "flute solo", "arabian music influences", "medium tempo", "folk music", "instrumental music", "steady drumming rhythm", "folk music", "strong bass line", "drum rolls", "retro songs", "entertaining", "emotional", "romantic", "passionate", "keyboard accompaniment"] | 1 | eHeUipPZHIc | 3853 |
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;