musiccaps_details (view)
2 rows where musiccaps_aspects contains "high-spirited", musiccaps_aspects contains "instrumental", musiccaps_author = 7 and musiccaps_names contains "Wind instrument, woodwind instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Rollin' & Tumblin' | This music is an energetic instrumental. The tempo is fast with a vivacious harmonica lead, lively guitar rhythm, enthusiastic cello and punchy drumming. The song starts with an enthusiastic vocal riff. The music is an upbeat, catchy, buoyant, peppy, youthful, energetic and lively Harmonica instrumental. | 2009-07-27T19:59:29Z | petermadcatruth | Madcat, Kane & Maxwell Street play "Rollin' & Tumblin" recorded live at the Creole Gallery in Lansing Michigan, January 11, 2009. For more information check out: http://www.madcatmusic.net/ Peter Madcat Ruth - harmonica, vocals Shari Kane - guitar Mark Schrock - string bass Mike Shimmin - drums | ["Harmonica", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "spirited harmonica lead", "lively acoustic guitar", "enthusiastic cello", "infectious drumming", "male vocalisation", "punchy", "perky", "buoyant", "high-spirited"] | 7 | CRUd8kY3L70 | 1367 | |
Gordon Walker 4 - Glenfiddich Ceilidh 2003 | This music is a lively Bagpiper instrumental. The tempo is fast with a piper playing a cheerful harmony on the bagpiper with an enthusiastic acoustic guitar accompaniment. The music is vibrant, vivacious, vigorous, engaging, cheerful and merry. The performance is live with a live audience and ambient sounds. | 2007-06-29T17:30:17Z | Chris Eyre | The last of 4 clips of Gordon Walker giving a wonderful and entertaining display during the ceilidh at the New Scotland Hotel in Pitlochry on the evening following the Glenfiddich competition at Blair Castle. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "bagpiper", "acoustic guitar accompaniment", "live performance", "live audience", "ambient sounds", "lively", "spirited", "rich", "drone pipes", "melody pie", "bellows", "double reed instrument", "piper", "passionate", "spirited", "emotional", "high-spirited", "engaging", "mesmerising", "sharp sounds", "high notes"] | 7 | JjF1G5wgcvY | 2028 |
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;