musiccaps_details (view)
2 rows where musiccaps_aspects contains "inspiring", musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "tambourine percussions"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- inspiring · 2 ✖
- poor audio quality · 2 ✖
- tambourine percussions · 2 ✖
- booming bass line 1
- chaotic harmony 1
- choral chants 1
- classic pop hits 1
- classic pop song 1
- congregation singing 1
- devotional 1
- dreamscapes 1
- electric guitar tremolo tones 1
- emotional 1
- female singer 1
- festival 1
- groovy music 1
- grunge keyboard tones 1
- hare krishna 1
- indian music 1
- me drum fats tempo 1
- melancholic 1
- passionate 1
- people clapping 1
- piano accompaniment 1
- pop song 1
- religious 1
- sadness 1
- slow tempo 1
- spirited 1
- steady drumming rhythm 1
- stringed indian instruments 1
- tabla playing percussively 1
- traditional percussion rhythm 1
- trance 1
- trudging drum rhythm 1
- unison singing 1
- violin playing 1
musiccaps_names (array) 7 ✖
- Music 2
- Humming 1
- Mantra 1
- Music of Asia 1
- Rattle (instrument) 1
- Singing 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 | |
Transistor OST - In Circles Mashup (Humming & Singing) | A female singer sings this poignant melody. The song is slow tempo with an electric guitar buzzing harmony, piano accompaniment, steady drumming rhythm, keyboard harmony, groovy bass line and Tambour percussions. The song is emotional and melancholic. The song is a poor quality recording of a classic pop song. | 2014-07-04T13:54:06Z | the Dragon Coffee | Lyrics: I hear you buzzing, a fly on the wall In through the window and up through the hall Flying in circles just trying to land I see you hurting I do what I can But I won't save you I won't save you Maybe you're looking for someone to blame Fighting for air while you circle the drain Never be sorry for your little time It's not when you get there, it's always the climb But I won't save you I won't save you I won't save you I won't save you ------------------------------------------------------ THANKS to the Supergiant Games for this AWESOME GAME, and Music! | ["Singing", "Humming", "Music", "Song"] | ["female singer", "grunge keyboard tones", "classic pop hits", "dreamscapes", "tambourine percussions", "steady drumming rhythm", "booming bass line", "traditional percussion rhythm", "chaotic harmony", "poor audio quality", "electric guitar tremolo tones", "piano accompaniment", "pop song", "classic pop song", "inspiring", "emotional", "slow tempo", "trudging drum rhythm", "sadness", "melancholic"] | 1 | z6SNngkMAug | 5457 |
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;