musiccaps_details (view)
1 row where musiccaps_aspects contains "pop rock", musiccaps_aspects contains "soft acoustic rhythm guitar" and "youtube_published" is on date 2013-07-17
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| "Radioactive" - Imagine Dragons (The Sam Willows Cover) | The Recording features a cover of a pop rock song and it consists of soft acoustic rhythm guitar located in the left channel and angelically harmonized mixed vocals singing on top of it. It sounds hopeful and emotional. | 2013-07-17T13:19:24Z | The Sam Willows | Catch up with us! Follow us here for our latest updates: - https://www.facebook.com/thesamwillows - https://www.twitter.com/thesamwillows - https://www.instagram.com/thesamwillows Purchase The Sam Willows EP here: https://cdbaby.com/thesamwillows -------- MORE ABOUT US www.thesamwillows.com The Sam Willows are a Singaporean indie-folk quartet of siblings Benjamin and Narelle Kheng, and their friends Sandra Riley Tang and Jon Chua, who burst onto the scene in the middle of 2012 with what Singapore's leading broadsheet, The Straits Times, described as a group with "lush, multi-part, girl-boy melodies and breezy and soulful acoustic pop tunes". Their first EP of original songs (which is available at http://thesamwillows.com/music) was released in October 2012 and made the top 10 local iTunes charts and top 50 albums sold on iTunes Pop Charts Singapore. In slightly over a year, The Sam Willows' YouTube account has drawn close to 524,000 views with their mixture of unique covers and fresh originals. The Sam Willows are the first Singaporean band to be named leading Singapore young adult hit radio station 987FM's Rising Star, alongside international acts like Birdy and Ed Sheeran. They have won the m:idea Youth Choice Award 2013 in the band category by popular vote. Separately, they were selected to have a song recorded and produced by 5 time Grammy Award winning producer, Steve Lillywhite, CBE. *Glasshouse (Lillywhite Edition) that was released in July 2013! The Sam Willows are currently the youngest Singaporean music act ever invited to play two prominent North American Music Festivals - South by Southwest Music Festival in Austin, Texas, (named SXSW 2013 - Freshman Favourite by review site Operation Every Band) and the Canadian Music Festival in Toronto, Ontario. Their North American tour also covered Los Angeles, where they played at venues including Villain's Tavern and The Roxy - On the Rox. Special Thanks to: Benjamin Ong ---------------------------- "Radioactive" originally by Imagine Dragons Wr… | ["Humming", "Music"] | ["soft acoustic rhythm guitar", "angelically harmonized mixed vocals", "pop rock", "cover", "hopeful", "emotional"] | 4 | O9Ag-dE-yfQ | 2405 |
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;