musiccaps_details (view)
2 rows where musiccaps_names contains "Christian music" and musiccaps_names contains "Progressive rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- adventurous 1
- bass 1
- conga percussion 1
- distorted guitar lead 1
- exciting 1
- female voice 1
- folk song 1
- groovy bass line 1
- guitar 1
- guitar rhythm 1
- head bangers 1
- hippie style song 1
- male singer 1
- medium tempo 1
- moderate tempo 1
- organ 1
- people screaming 1
- poor audio quality 1
- positive 1
- retro classic rock 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- romantic 1
- screaming vocals 1
- story telling 1
- youthful 1
musiccaps_names (array) 10 ✖
- Christian music · 2 ✖
- Music 2
- Progressive rock · 2 ✖
- Rock music 2
- Song 2
- Christmas music 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Psychedelic rock 1
youtube_published (date) 2 ✖
- 2010-01-26 1
- 2011-03-26 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Straight way Black or White Christian rock music Doug Middleton lead guitar | A male singer sings this rock melody. The song is medium tempo with a rock drumming rhythm, percussive bass line, distorted guitar accompaniment and keyboard accompaniment. The song is exciting and energetic. The song has poor audio quality. | 2010-01-26T03:10:24Z | tannere1 | Christian music Straight way title black or white doug middleton | ["Christian music", "Guitar", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song", "Progressive rock", "Grunge"] | ["poor audio quality", "rock band", "poor audio quality", "retro classic rock", "story telling", "romantic", "adventurous", "rock groupies", "rock hits", "medium tempo", "guitar rhythm", "groovy bass line", "rock drumming rhythm", "people screaming", "distorted guitar lead", "male singer", "screaming vocals", "exciting", "positive", "youthful", "head bangers"] | 1 | njFM8DvmPVU | 4571 | |
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
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;