musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic steel drum", musiccaps_names contains "Music" and musiccaps_names contains "Steelpan"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Fanfare" - Hang Drum Solo by Dante Bucci | This song is an instrumental. The tempo is fast with a lively keyboard harmony and rhythmic steel pan . It is minimal and rhythmic. The harmony is simple , straight and the steel pan adds an interesting layer to it. The music is engaging, interesting, energetic, spirited and melodic. | 2008-08-13T16:11:38Z | Dante Bucci | This is a solo acoustic version of "Fanfare" performed on the HandPan (PANArt Hang). Dm Pentatonic Scale: (D) A C D F G A C F major Pentatonic Scale: (F) A Bb C E F A Bb C Copyright 2008 Dante Bucci UFOTunes/ASCAP. http://itunes.dantebucci.com http://facebook.dantebucci.com ~~~~~~~~~~~~~~~~~~~~~~~ If you want a HandPan: The makers of the "Hang" are no longer creating a musical instrument. PANArt is now focusing on creating a tool for meditation that does not follow the conventions of traditional musical notes. If you would like to purchase a hand-pan, I would suggest you look into one of the several other instrument makers who are creating very high-quality instruments. Websites for other Hand-Pan makers: www.spacedrum.fr www.bellart.es www.pantheonsteel.com www.balisteelpan.com www.caisa-music.com | ["Music", "Steelpan"] | ["instrumental", "fast tempo", "pleasant sounds", "simple harmony", "energetic", "spirited", "vibrant", "engaging", "steel drums", "steel pan", "rhythmic", "resounding melody", "african percussion", "pannist", "lively keyboard accompaniment", "home video", "stainless steel instrument", "recycled instrument", "acoustic steel drum"] | 7 | UNJswfXKJ3s | 2909 |
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;