musiccaps_details (view)
3 rows where musiccaps_aspects contains "ambient noises" and musiccaps_aspects contains "groovy rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- ambient noises · 3 ✖
- energetic 3
- groovy rhythm · 3 ✖
- dance rhythm 2
- instrumental music 2
- passionate 2
- poor audio quality 2
- spirited 2
- animated interactions 1
- animated sounds 1
- bad audio quality 1
- beatboxer 1
- beatboxing 1
- dance groove 1
- demonstration 1
- entertainer 1
- exciting 1
- female percussionist 1
- fusion music 1
- grunting noises 1
- guitar lead 1
- guitar strumming 1
- hindustani music 1
- hissing tones 1
- home video 1
- improvisational 1
- increasing tempos 1
- indian classical music 1
- latin percussions 1
- live performance 1
- live audience 1
- male singer 1
- maracas playing percussion 1
- medium tempo 1
- music artist 1
- percussion styles 1
- percussive bass line 1
- performer 1
- solo instrument 1
- soloist 1
- tabla percussions 1
- various tempos 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
MARACAS II | The song is an instrumental. The tempo is varying with maracas being played percussively. The playing is energetic and exciting. The song is a home music video and probably a demonstration of Latin percussion styles. | 2008-06-06T19:51:39Z | Grace LASCANO GARRIDO | Ejercicios MARACAS | ["Music", "Maraca"] | ["maracas playing percussion", "female percussionist", "dance rhythm", "percussion styles", "demonstration", "music artist", "groovy rhythm", "home video", "poor audio quality", "various tempos", "latin percussions", "dance groove", "solo instrument", "instrumental music", "ambient noises", "hissing tones", "increasing tempos", "energetic"] | 1 | MwE7REVj8JQ | 2309 | |
Anil Shahi - Maya Mantra (Instrumental) | The song is an instrumental. The song is medium tempo with a percussive tabla rhythm, groovy bass line and a guitar strumming rhythm and playing lead. The song is Indian classical fusion with a poor audio quality. | 2013-02-23T19:05:58Z | NepaliLyricsChords | http://NepaliLyricsChords.com Anil Shahi performing Maya Mantra (Instrumental) in Thamel Square Grand Opening Program Program Name: Thamel Square Grand Opening Location: JP Road, Thamel. Kathmandu Facebook Page (Thamel Square): https://www.facebook.com/ThamelSquare Facebook Page (Nepali Lyrics Chords): http://www.facebook.com/Golomech | ["Country", "Flamenco", "Music"] | ["indian classical music", "hindustani music", "improvisational", "energetic", "exciting", "passionate", "spirited", "live audience", "ambient noises", "dance rhythm", "guitar lead", "poor audio quality", "poor audio quality", "tabla percussions", "groovy rhythm", "guitar strumming", "instrumental music", "percussive bass line", "fusion music"] | 1 | TWm_2QncYXg | 2841 | |
ALBERTO THE MUSIC BOX - BTV MUSIC VIDEO AWARDS 2008 (BalconyTV) | A male beatboxer creates a cool groove with animated sounds like grunting and mouth percussion. The song is medium tempo with no other instrumentation. The song is energetic and passionate. The song has bad audio quality. | 2008-08-29T01:09:19Z | BALCONY | Alberto the Human Beatbox returns for the BalconyTV Music Video Awards 2008. Subscribe to us right now at - http://bit.ly/subscribetoBalconyTV 'Like' us on Facebook - http://Facebook.com/balconytv Follow us on Twitter - http://Twitter.com/balconytv PART 9 BALCONYTV MUSIC VIDEO AWARDS 2008 JUNE 20th 2008 LIVE FROM THE SUGAR CLUB DUBLIN In association with Budvar, The Goethe Institute Dublin, The Sunday World, Captive Advertising, Clarion Hotels. | ["Beatboxing", "Vocal music"] | ["male singer", "beatboxing", "medium tempo", "energetic", "passionate", "live performance", "ambient noises", "beatboxer", "spirited", "animated sounds", "grunting noises", "soloist", "entertainer", "performer", "groovy rhythm", "animated interactions", "bad audio quality"] | 1 | kZPz8ExTzBk | 4329 |
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;