musiccaps_details (view)
2 rows where musiccaps_aspects contains "female voice", musiccaps_names contains "Christian music" and musiccaps_names contains "Christmas music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- female voice · 2 ✖
- acoustic drums 1
- bass 1
- bass guitar 1
- cebuano language 1
- cheerful 1
- christmas music 1
- conga percussion 1
- electric guitar 1
- electric piano 1
- festive 1
- folk song 1
- guitar 1
- hippie style song 1
- male voice 1
- melodic singing 1
- moderate tempo 1
- organ 1
musiccaps_names (array) 7 ✖
- Christian music · 2 ✖
- Christmas music · 2 ✖
- Music 2
- Jingle (music) 1
- Progressive rock 1
- Rock music 1
- Song 1
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 | |
Mag-ambahan | This is a Christmas music piece. There is a male voice and a female voice singing melodically in the Cebuano language. The electric piano is playing the main melody while the electric guitar and the bass guitar are playing in the background. The rhythm is provided by a simple and upbeat acoustic drum beat. The atmosphere is festive and cheerful. This piece could be the opening theme of a Christmas movie that takes place in the southern Philippines. | 2010-12-10T09:35:04Z | ryahnz | Mag-ambahan ta ning pasko sa kalipay Ang kagul-anan ta ato nga isalikway Ug duyog ning awit sa malipayong dughan Issignit ta ang kalipay'g hudyaka Kay pasko karon sa pagmaya Wad-on ta ang mga kayugot Isalikway ta ang pagdumot Ang pagpasaylo mao'y angay buhaton ta Ning adlaw sa manunubos (Repeat Mag-ambahan stanza) Issignit ta ang kalipay'g hudyaka Kay pasko karon sa pagmaya | ["Christmas music", "Christian music", "Jingle (music)", "Music"] | ["christmas music", "male voice", "female voice", "melodic singing", "cebuano language", "electric piano", "electric guitar", "bass guitar", "acoustic drums", "festive", "cheerful"] | 9 | tDZPGf8WYmI | 5016 |
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;