musiccaps_details (view)
2 rows where youtube_channel = "SteeldrumTrust"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
CSI Steelband ~ "Empire State of Mind" ~ Alicia Keyes | The low quality recording features a live performance of loud steel pans melody over playback instrumental that consists of shimmering hi hats, open hats and "4 on the floor" kick pattern. There are some crowd talking noises in the background. It sounds exotic and energetic. | 2010-08-02T14:27:22Z | SteeldrumTrust | CSI Steelband plays "Empire State of Mind" by Alicia Keys. Trafalgar Square Blockorama August 2010 | ["Music", "Steelpan"] | ["low quality", "live performance", "loud steel pans melody", "playback instrumental", "shimmering hi hats", "open hats", "4 on the floor kick", "energetic", "crowd talking", "exotic"] | 4 | 0bvPjMQ_WbE | 190 | |
Sounds of Steel ~ Don't Stop 'til You Get Enough | A lot of people are playing different parts of a funk song on steel-drums. An acoustic drum is playing a faster funk groove together with congas and shakers. This song may be playing outside at a live show. | 2010-08-02T10:55:36Z | SteeldrumTrust | Sounds of Steel play "Don't Stop 'til You Get Enough" by Michael Jackson at the Blockorama in Trafalgar Square August 1st 2010 Video © Steel Drum Trust | ["Music", "Steelpan"] | ["funk", "steeldrums", "acoustic drums", "congas", "shaker", "uptempo", "amateur recording"] | 6 | Db0c4aAwUbY | 1499 |
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;