musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass", musiccaps_author = 0, musiccaps_names contains "Christian music" and musiccaps_names contains "Christmas music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Navidad MIX 2010 (Piero) | This song features a trumpet playing the main melody. The melody is like a melody played before announcements are made in a kingdom. This is accompanied by a tambourine and a bass. The bass plays one note four times followed by a higher pitched note eight times and back to the first note once. After a three count rest, the bass phrase is repeated. This song can be played in a movie scene announcing the arrival of royalty. | 2010-12-07T00:36:16Z | Francisco Moises Cruz Carrasco | Un video que contiene un hermoso popurri navideño para escuchar en estas fiestas y alegrar los corazones y el espirito de la navidad sin olvidar el verdadero significado de la navidad EL NACIMIENTO DEL SALVADOR JESUS | ["Christmas music", "Christian music", "Music", "Rattle (instrument)"] | ["trumpet song", "tambourine", "bass", "instrumental", "no voices", "moderate tempo", "holiday mood", "music for announcement"] | 0 | 7kEeYQx2VLE | 878 | |
This Is Christmas (Christmas 2013 ) Paul Martin Feat Shauna Gallon | This pop song features a male and female voice singing the main melody. There are backing voices singing fills in between lines. Children sing in the background. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. A synth plays a pedal chord in staccato. This song can be played at the end credits of a holiday movie. | 2009-10-07T15:44:15Z | Chris tmasMusic | One of the Finest Christmas songs still yet to Make It. Please Share this song written & performed by one of worlds finest Christmas Crooners Paul Martin aka Mr Success featuring future star Shauna Gallon & a cast of family & friends shot in Newcastle upon Tyne in 2009. www.franksinatratributesinger.co.uk | ["Christmas music", "Singing", "Christian music", "Music"] | ["pop song", "holiday theme", "duet", "male voice", "children's voices", "christmas song", "percussion", "bass", "synth", "happy mood", "moderate tempo", "backing voices"] | 0 | ODOrls3MuZI | 2411 | |
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;