musiccaps_details (view)
2 rows where musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "lively piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- keyboard harmony · 2 ✖
- lively piano · 2 ✖
- animated 1
- animated piano 1
- bouncy 1
- brass band 1
- brass instruments 1
- bright trumpet 1
- buoyant 1
- captivating 1
- congas 1
- dance music 1
- energetic 1
- engaging 1
- enthralling 1
- enthusiastic 1
- enthusiastic drumming 1
- ethereal 1
- fast tempo 1
- female soprano like sound 1
- groovy bass lines 1
- high notes 1
- instrumental 1
- latin dance music 1
- latin folk 1
- latin music 1
- latin pop 1
- male singer 1
- melodic 1
- mesmerising 1
- piano accompaniment 1
- rhythmic acoustic guitar 1
- skilful 1
- skilled musician 1
- spanish guitar 1
- spirited 1
- steady bass lines 1
- steady drumming 1
- synthesised arrangements 1
- tambourine 1
- theremin 1
- thereminist 1
- unique 1
- upbeat 1
- vibrant 1
- vigorous 1
- world music 1
- youthful 1
musiccaps_names (array) 4 ✖
youtube_published (date) 2 ✖
- 2009-03-25 1
- 2011-09-18 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Thereminist IN HIS NATURAL HABITAT | A feminist plays this intriguing instrumental. The tempo is fast with keyboard accompaniment, steady drumming, rhythmic acoustic guitar, lively piano harmony , steady bass lines and shakers. The music is sharp, height pitched and almost like a female soprano vocalising. The song is energetic, spirited, melodic, animated, unique, skilful, engaging, ethereal and captivating; | 2009-03-25T22:15:57Z | ThomasGrillo | http://www.thomasgrillo.com Enjoy a little tour of "the coolest room in town" according to an anthropology major who recently documented thereminist Thomas Grillo in his natural habitat. ;) The song is an original jazz compostion by Thomas Grillo, called Mint Julep Fantasy, which is now available on CD, and MP3. Just visit http://www.thomasgrillo.com/shop.html and check out the album, Secret Agents from the id. The piece has been much improved since this video's release. Video was shot by professional photographer Josh Haley. Visit him at http://www.joshhaileystudio.com The lens was a 120 degree wide angle, fish eye lens. ;) Song and video are Copyright 2009 Thomas Grillo, and Josh Hailey. | ["Music", "Theremin"] | ["instrumental", "keyboard harmony", "theremin", "tambourine", "unique", "melodic", "spirited", "enthralling", "melodic", "skilful", "ethereal", "captivating", "steady bass lines", "lively piano", "mesmerising", "engaging", "animated", "thereminist", "piano accompaniment", "steady drumming", "synthesised arrangements", "rhythmic acoustic guitar", "theremin", "high notes", "female soprano like sound", "skilled musician"] | 7 | bHiRX6QYwEk | 3613 | |
Toño Rosario-El Hot Dog | A male vocalist sings this lively Latino song. The tempo is fast with an animated piano accompaniment, bright trumpets, energetic and rhythmic drumming, groovy bass and keyboard. The song is energetic, lively, buoyant, bouncy, vibrant and vivacious with a dance groove. This song is Latin Pop. | 2011-09-18T02:16:01Z | TheBombers27 | ["Music", "Music of Latin America", "Salsa music"] | ["male singer", "fast tempo", "brass band", "brass instruments", "vibrant", "animated piano", "youthful", "buoyant", "bouncy", "enthusiastic", "energetic", "vigorous", "latin music", "bright trumpet", "groovy bass lines", "keyboard harmony", "enthusiastic drumming", "spanish guitar", "upbeat", "latin pop", "latin dance music", "latin folk", "lively piano", "world music", "congas", "dance music", "latin pop"] | 7 | vMU7ZKY2Eso | 5174 |
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;