musiccaps_details (view)

1 row where musiccaps_aspects contains "organ" and musiccaps_names contains "Progressive rock"

✎ View and edit SQL

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
Renaissance - Carpet of the Sun - Progressive rock 70's This folk song features a female voice. This is accompanied by percussion played on the Congas. An acoustic guitar strums the chords. The bass plays a running bassline providing fills and giving depth to the low end of the musicscape. An organ plays chords in the background. The song has a hippie feel. This song can be used in a retro movie with a hippie movement theme. 2011-03-26T13:31:46Z Johnnyprogger johnnyprogger chanel - art rock music. Listen to other progressive rock bands like Genesis, Focus, Pink Floyd, ELP, Yes, Rush, Niacin, Queen, Jehtro Tull, Kansas, Gentle Giant, Marillion, Camel, besides Deep Purple, Beatles, Iron Maiden. Carpet of the Sun (lyrics) Come along with me Down into the world of seeing Come and you'll be free Take the time to find the feeling See everything on it's own And you'll find you know the way And you'll know the things you're shown Owe everything to the day Chorus: See the carpet of the sun The green grass soft and sweet Sands upon the shores of time Of oceans mountains deep Part of the world that you live in You are the part that you're giving Come into the day Feel the sunshine warmth around you Sounds from far away Music of the love that found you The seed that you plant today Tomorrow will be a tree And living goes on this way It's all part of you and me Repeat chorus two times See the carpet of the sun See the carpet of the sun See the carpet of the sun See the carpet of the sun ["Christmas music", "Christian music", "Music", "Rock music", "Song", "Progressive rock"] ["folk song", "female voice", "guitar", "organ", "bass", "conga percussion", "moderate tempo", "hippie style song"] 0 piY4mt4F9xg 4731

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;