musiccaps_details (view)
1 row where musiccaps_aspects contains "folk rock", musiccaps_aspects contains "suspenseful" and musiccaps_aspects contains "sustained bass"
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 |
---|---|---|---|---|---|---|---|---|---|---|
BAGS OF ROCK - 'Rain Stain' Inverness Hogmanay 2011 (remastered) | The low quality recording features a folk rock song that consists of a sustained bagpipe melody and sustained synth bass, followed by funky synth keys and punchy toms. It sounds suspenseful and intense. | 2013-03-13T14:31:18Z | bags of rock | www.bagsofrock.com www.facebook.com/BORbandpage www.twitter.com/bagsofrock Filmed with thanks to Norman Strachan and Gerry Reynolds BAGS OF ROCK deliver a massive stadium sound of heavy rock, bagpipes ... and original, ground breaking compositions... not for the faint hearted !!!!!! Scottish New Music Awards 2012 "Rock Recording of the Year" and "Group of the Year" winners -- Glasgow's BAGS OF ROCK fuse cutting-edge heavy rock with The Great Highland Bagpipe. Delivering performances with an infectious conviction to their art, BAGS OF ROCK have created a trail blazing musical combination that takes this new genre to the next level. Since their first gig in April 2011, BAGS OF ROCK have already played to capacity crowds in Glasgow's George Square, headlined the o2 Academy, supported the Proclaimers, rocked tens of thousands at festivals around the UK, performed internationally from Kiev to Kuala Lumpur and topped the German Charts twice with tracks from their debut album 'The Next Level' ! BAGS OF ROCK even received praise from media guru Simon Cowell who described the band as "Great ambassadors for Scotland - obviously very talented musicians". They also performed for HRH Queen Elizabeth as part of the 2012 Diamond Jubilee celebrations. The band Features.... The well-known Mohawked, Madcap Celtic-Rock Guitarist Gregor "G-man" James... The Lone Piper, who appeared to a televised audience of a Billion people as the Delhi Commonwealth Games "hero piper"... A two times Solo World Champion snare drummer... Plus a slamming rhythm section incorporating the Cream of Scotland's Session Music Scene.. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["sustained bagpipe melody", "sustained bass", "funky synth keys", "punchy toms", "suspenseful", "intense", "low quality", "folk rock"] | 4 | ZtcHktwEfAU | 3425 |
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;