musiccaps_details (view)
4 rows where musiccaps_aspects contains "passionate", musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "tambourine percussions"
This data as json, CSV (advanced)
musiccaps_aspects (array) 64 ✖
- passionate · 4 ✖
- poor audio quality · 4 ✖
- tambourine percussions · 4 ✖
- emotional 2
- medium tempo 2
- spirited 2
- adrenaline rush 1
- adventure of a lifetime 1
- auto tuned vocals 1
- backing track 1
- beeping tones 1
- bollywood music 1
- breakup song 1
- choral chants 1
- classic rock 1
- congregation singing 1
- dance groove 1
- dance rhythm 1
- devotional 1
- dholak percussions 1
- energetic 1
- excitement 1
- fast tempo 1
- fats tempo 1
- festival 1
- groovy music 1
- groovy rhythm 1
- grunge keyboard tones 1
- guitar demo 1
- guitar lead 1
- guitar solo 1
- hare krishna 1
- home music video 1
- indian music 1
- indian percussions 1
- inspiring 1
- instrumental music 1
- keyboard harmony 1
- love songs 1
- male rapper 1
- male singer 1
- me drum fats tempo 1
- organ accompaniment 1
- people clapping 1
- people dancing 1
- percussive bass line 1
- psychedelic 1
- punjabi songs 1
- rap hits 1
- religious 1
- retro rap hits 1
- retro rock music 1
- romantic 1
- soloist 1
- steady bass line 1
- steady rock drumming 1
- story telling 1
- stringed indian instruments 1
- strong drumming rhythm 1
- tabla playing percussively 1
- trance 1
- unison singing 1
- vintage rock vibes 1
- violin playing 1
musiccaps_names (array) 8 ✖
- Music 4
- Grunge 1
- Mantra 1
- Music of Asia 1
- Music of Bollywood 1
- Rapping 1
- Rattle (instrument) 1
- Sad music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kai - Grind Low | A male rapper sings this exciting melody. The tempo is fast with a groovy bass line, grunge keyboard tones, strong drumming rhythm, various percussion hits and beeping tones. The song is pulsating and energetic. The audio quality is very poor. | 2008-03-06T13:46:34Z | kilickai | ["Music", "Rapping"] | ["male rapper", "poor audio quality", "beeping tones", "fast tempo", "people dancing", "retro rap hits", "tambourine percussions", "strong drumming rhythm", "percussive bass line", "story telling", "adrenaline rush", "passionate", "energetic", "excitement", "dance rhythm", "dance groove", "fats tempo", "poor audio quality", "rap hits", "grunge keyboard tones"] | 1 | 9STauy5DsC8 | 1009 | ||
Singer: Ranjodh Hear, Music: Harry Sandhu, Song: Sajjan Label: Bhangra Records Punjabi Sad song | A male singer sings this passionate melody with auto tuned vocals. The song is medium tempo with Indian percussion, dholak percussion, keyboard accompaniment and various percussion hits. The song is a Punjabi pop song with poor audio quality. | 2010-10-08T00:03:45Z | Harrie Sandhu | http://www.facebook.com/pages/Singer-Music-Producer-Harry-Sandhu-Fan-Page/193683947331859 Singer: Ranjodh Hear Music: Harry Sandhu Song: Sajjan Label: Bhangra Records Presentation:Raghbir Dhudike | ["Music", "Music of Bollywood", "Sad music"] | ["male singer", "auto tuned vocals", "romantic", "breakup song", "emotional", "passionate", "bollywood music", "punjabi songs", "love songs", "poor audio quality", "keyboard harmony", "indian percussions", "dholak percussions", "tambourine percussions", "medium tempo"] | 1 | OmjfHQB_lcs | 2467 | |
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 | |
Snap Crackle and how`s your Dad | The song is an instrumental. The song is medium tempo with a groovy bass line, rock drumming, tambourine percussion, guitar rhythm and guitar lead. The song is adventurous and emotional. The song is classic rock and has a poor audio quality. | 2010-06-19T06:13:50Z | BurnsErnst | Here is another special tune by The Shadows. Backing track is from the original vinyl record without the first lead. On some parts, where the lead was on both channels, I try to play as exactly along with Hank as I could. I hope it`s ok. | ["Music", "Grunge"] | ["instrumental music", "guitar lead", "soloist", "guitar solo", "vintage rock vibes", "emotional", "spirited", "passionate", "groovy rhythm", "psychedelic", "backing track", "classic rock", "tambourine percussions", "medium tempo", "steady rock drumming", "organ accompaniment", "poor audio quality", "home music video", "guitar demo", "retro rock music", "steady bass line", "adventure of a lifetime"] | 1 | g6f-LxiT9Eo | 4006 |
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;