musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental" and "youtube_published" is on date 2009-07-27
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- instrumental · 2 ✖
- bagpipe music 1
- buoyant 1
- enthusiastic cello 1
- fast tempo 1
- folk music 1
- high-spirited 1
- infectious drumming 1
- lively acoustic guitar 1
- male vocalisation 1
- no other instruments 1
- no voices 1
- perky 1
- punchy 1
- solo 1
- spirited harmonica lead 1
- traditional scottish music 1
musiccaps_names (array) 3 ✖
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 | |
Chris Armstrong 10yrs | This song features an instrumental played on bagpipes. One pedal note is played continuously on the lower register while the higher notes are played to a melody. There are no other instruments in this song. There are no voices in this song. This is an instrumental song. This song can be played at a Scottish fair. | 2009-07-27T17:04:52Z | MacNeillofTiree | Competition | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["bagpipe music", "solo", "no other instruments", "folk music", "no voices", "instrumental", "traditional scottish music"] | 0 | aDlWOvCdNMk | 3522 |
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;