musiccaps_details (view)
15 rows where musiccaps_aspects contains "piano accompaniment" and musiccaps_aspects contains "slow tempo" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 196 ✖
- piano accompaniment · 15 ✖
- slow tempo · 15 ✖
- emotional 11
- poignant 6
- mellow 5
- instrumental 4
- love song 4
- melancholic 4
- soft 4
- cello 3
- dulcet 3
- ethereal 3
- euphonious 3
- instrumental music 3
- mellifluous 3
- sentimental 3
- soothing 3
- together forever 3
- ambient 2
- captivating 2
- chimes 2
- country music 2
- female singer 2
- female vocalist 2
- foreign language 2
- gospel music 2
- inspiring 2
- jazz music 2
- keyboard harmony 2
- male singer 2
- motivational 2
- movie soundtrack 2
- passionate 2
- peaceful 2
- poor audio quality 2
- reflective 2
- romantic 2
- romantic piano 2
- sad 2
- spirited 2
- steady drumming rhythm 2
- strong bass line 2
- synthesiser arrangement 2
- violin harmony 2
- ambient noises 1
- ambient room noises 1
- ambient sounds of nature 1
- banjo 1
- bass 1
- bass solo 1
- beautiful 1
- beauty 1
- bells ringing 1
- black gospel music influences 1
- blues music 1
- booming bass line 1
- bowed string instrument 1
- building tension 1
- buoyant 1
- calm 1
- celestial 1
- cellist 1
- chaotic harmony 1
- christian contemporary music 1
- christian music 1
- christian praise and worship 1
- christian song 1
- christmas song 1
- church music 1
- clapping randomly 1
- classic pop hits 1
- classic pop song 1
- classic romance 1
- contemporary christian music 1
- country instrumental 1
- delicate 1
- devotional 1
- distant music 1
- dramatic music 1
- dream of you 1
- dreamscapes 1
- drum brushes percussions 1
- duel music 1
- duet 1
- easter song 1
- eerie 1
- electric guitar lead 1
- electric guitar tremolo tones 1
- emphatic vocals 1
- engaging 1
- exciting 1
- exquisite 1
- female opera singer 1
- female vocals 1
- fiddle 1
- foreign music 1
- fretboard sounds 1
- fun 1
- gentle 1
- good friday 1
- groovy 1
- groovy bass line 1
- groovy rhythm 1
- groovy solo 1
- grunge keyboard tones 1
- guitar lead 1
- gunslingers 1
- heart break 1
- icelandic lullaby 1
- icelandic song 1
- inspirational 1
- instrumental cover 1
- jazz and blues 1
- jazz band 1
- jazz drumming rhythm 1
- k-pop 1
- keyboard accompaniment 1
- korean love song 1
- korean song 1
- lifetime experience 1
- live concert 1
- live performance 1
- love you so badly 1
- mandolin 1
- meditational 1
- meditative 1
- melodic 1
- mesmerising 1
- middle eastern influences 1
- minimal instruments 1
- minimalist music 1
- missing you 1
- movie theme song 1
- music box tones 1
- music interlude 1
- no percussions 1
- noise 1
- ominous 1
- operatic drama 1
- pensive 1
- people cheering 1
- percussive bass line 1
- piano playing chords 1
- pleasant 1
- ponderous 1
- poor quality recording 1
- pop song 1
- prayerful 1
- private video 1
- punchy beats 1
- resonator 1
- retro feel 1
- rhythmic acoustic guitar 1
- rock and roll 1
- rock music 1
- sadness 1
- sere 1
- serene 1
- slow burn 1
- smooth jazz 1
- soft pop 1
- soft rock 1
- solemn 1
- song cover 1
- song introduction 1
- sorrowful 1
- soul music 1
- soulful 1
- soundtrack 1
- special someone 1
- steady bassline 1
- steady drumming 1
- story telling 1
- string bass line 1
- string section harmony 1
- symphony 1
- syncopated harmony 1
- tambourine percussions 1
- technique 1
- traditional percussion rhythm 1
- trance like 1
- trendy 1
- triangle percussions 1
- trombone harmony 1
- trudging drum rhythm 1
- trumpets 1
- trumpets playing harmony 1
- tuba accompaniment 1
- vibrato 1
- violin 1
- violins 1
- western classical music 1
- whistling tones 1
- wistful 1
- world music 1
- young love 1
musiccaps_names (array) 22 ✖
- Music 11
- Bowed string instrument 2
- Brass instrument 2
- Cello 2
- Double bass 2
- Sad music 2
- Tender music 2
- Applause 1
- Bass guitar 1
- French horn 1
- Happy music 1
- Humming 1
- Lullaby 1
- Musical instrument 1
- Singing 1
- Song 1
- Soul music 1
- Speech 1
- Traditional music 1
- Trombone 1
- Violin, fiddle 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"My Heart Will Go On" Titanic Theme Cello Cover (Tribute to James Horner) - NDREW | A cellist plays this lilting melody with a piano accompaniment and no other instruments. The music is emotional and tragic. The tempo is slow and has a lot of beauty to it. The song is a cover of a famous love song. | 2015-06-26T04:07:21Z | NDREW | This is my humble rendition to a wonderful man whose music inspired many artists and musicians. R.I.P. James Horner. If you like this then check out my cover of Falling Slowly: https://www.youtube.com/watch?v=KOyzibkm4dw ---------------------------------------------------------------------------------------------------------- Check out my website: http://www.ndrewmusic.com ---------------------------------------------------------------------------------------------------------- iTunes - http://apple.co/2cXx9uu Google Play – https://goo.gl/zgBcwu Amazon - http://amzn.to/2dq2iYq Spotify – https://play.spotify.com/track/3y1vpqQTipKyqnPWHvXK6J Soundcloud – https://soundcloud.com/ndrewmusic/my-heart-will-go-on ----------------------------------------------------------------------------------------------------------- If you'd like you can follow me on: Facebook - https://www.facebook.com/NDREWmusic Twitter - https://twitter.com/NDREWmusic Instagram - https://instagram.com/ndrewmusic/ Snapchat - @NDREWmusic ---------------------------------------------------------------------------------------------------------- I'm also on: iTunes - http://apple.co/2dg5qTt Google Play - https://goo.gl/AEh5sw Amazon - http://amzn.to/2dg4Nck Spotify - https://open.spotify.com/artist/1EhyJoRR3KwBUvm9JZALUS Pandora - http://www.pandora.com/ndrew Soundcloud – https://soundcloud.com/ndrewmusic | ["Cello", "Double bass", "Bowed string instrument"] | ["cello", "cellist", "piano accompaniment", "slow tempo", "movie soundtrack", "vibrato", "technique", "beauty", "trendy", "poignant", "sorrowful", "western classical music", "song cover", "no percussions", "emotional", "love song", "together forever", "classic romance"] | 1 | SlnjJv305Vg | 2788 | |
Transistor OST - In Circles Mashup (Humming & Singing) | A female singer sings this poignant melody. The song is slow tempo with an electric guitar buzzing harmony, piano accompaniment, steady drumming rhythm, keyboard harmony, groovy bass line and Tambour percussions. The song is emotional and melancholic. The song is a poor quality recording of a classic pop song. | 2014-07-04T13:54:06Z | the Dragon Coffee | Lyrics: I hear you buzzing, a fly on the wall In through the window and up through the hall Flying in circles just trying to land I see you hurting I do what I can But I won't save you I won't save you Maybe you're looking for someone to blame Fighting for air while you circle the drain Never be sorry for your little time It's not when you get there, it's always the climb But I won't save you I won't save you I won't save you I won't save you ------------------------------------------------------ THANKS to the Supergiant Games for this AWESOME GAME, and Music! | ["Singing", "Humming", "Music", "Song"] | ["female singer", "grunge keyboard tones", "classic pop hits", "dreamscapes", "tambourine percussions", "steady drumming rhythm", "booming bass line", "traditional percussion rhythm", "chaotic harmony", "poor audio quality", "electric guitar tremolo tones", "piano accompaniment", "pop song", "classic pop song", "inspiring", "emotional", "slow tempo", "trudging drum rhythm", "sadness", "melancholic"] | 1 | z6SNngkMAug | 5457 | |
Alice Fredenham - How Come You Don't Call | A female singer sings this soulful song. The song is slow tempo with piano accompaniment, strong bass line and groovy jazz drumming. The song is soulful and emotional. The song is a blues jazz song. | 2013-07-28T23:41:28Z | Virgilio Gan | Alice Fredenham - How Come You Don't Call http://www.facebook.com/realhealthnwealth Virgilio Gan World Talent Media Group | ["Music", "Happy music"] | ["female singer", "soul music", "jazz music", "blues music", "jazz and blues", "slow tempo", "black gospel music influences", "special someone", "dream of you", "missing you", "percussive bass line", "jazz drumming rhythm", "piano accompaniment", "emotional", "love song", "story telling", "love you so badly", "together forever"] | 1 | XUD-9HkQuTE | 3186 | |
Kom Leuk Torosab Ke Pel Nov Kbe Oun RHM CD Vol 471 | A female vocalist sings this soft song in a foreign language. The tempo is slow with a soft piano accompaniment and sound of chimes. The vocals are mellow, passionate,emotional, sentimental, nostalgic, melancholic and reflective. This song is a sad classic Pop. | 2013-01-16T04:20:07Z | BayKdang | For more Video go to my Channel Youtube : http://www.youtube.com/subscription_center?add_user=BayKdang | ["Music", "Speech", "Sad music"] | ["female vocalist", "slow tempo", "foreign language", "emotional", "sentimental", "poignant", "heart break", "melancholic", "piano accompaniment", "soft", "mellow", "melancholic", "sad", "chimes"] | 7 | 91AmOKytRUM | 970 | |
Yohanna - A lullaby in Icelandic (Beat for Beat) - Jóhanna Guðrún | A female vocalist sings this melodic song in Icelandic. The tempo is slow with vocal emphasis and a soft and romantic piano accompaniment. The song is a mellow, soothing, peaceful, soothing, ethereal, mesmerising and captivating Icelandic lullaby. | 2012-11-25T14:05:24Z | Videos by Yohanna.de | Yohanna sings a lullaby in Icelandic. Very short but very enchanting clip ... ♥️ Piano: Trond Nagell Dahl Part of the TV show "Beat for beat" - November 23, 2012 More infos about Iceland's Most Beautiful Voice (in German): https://www.Yohanna.de | ["Music", "Lullaby"] | ["female vocalist", "slow tempo", "soft", "euphonious", "mellifluous", "piano accompaniment", "emphatic vocals", "icelandic song", "icelandic lullaby", "minimalist music", "romantic piano", "ethereal", "mesmerising", "captivating", "engaging", "peaceful", "soulful", "soothing"] | 7 | Y5RVYmf3uWc | 3253 | |
OUTLAWS Film | The song is an instrumental. The tempo is slow with a female operatic singer singing, piano accompaniment, bells singing, trumpets playing harmony, various percussion hits and strong bass line. The song is full of tension and sounds ominous like an impending gun fight. | 2015-09-22T08:34:40Z | Belstaff | Belstaff Films presents OUTLAWS. A surreal film within a film starring David Beckham as the Stranger - a mysterious drifter and motorcycle stuntman who is hunted by a maniacal Director seeking revenge. The film features Katherine Waterston, Cathy Moriarty and Harvey Keitel. Shot on location in Mexico, the film is written and directed by Geremy Jasper, produced by Belstaff Films and Legs (a Milk Media Company) and Executive Producer Liv Tyler. http://www.belstaff.com/outlaws | ["Brass instrument", "Trombone"] | ["instrumental music", "female opera singer", "bells ringing", "music box tones", "movie soundtrack", "guitar lead", "duel music", "country music", "slow tempo", "trumpets playing harmony", "guitar lead", "slow burn", "gunslingers", "eerie", "ominous", "building tension", "operatic drama", "dramatic music", "emotional", "spirited", "passionate", "movie theme song", "soundtrack", "piano accompaniment"] | 1 | 9HQNvz4eZPU | 988 | |
The Sound Of Intercession - Apostolic/Prophetic Prayer and Worship Music | The song is an instrumental. The song is slow tempo with a steady drumming rhythm, triangle percussions, piano accompaniment, String synth harmony and strong bass line. The song is emotional and deeply meditative. | 2015-08-28T01:56:41Z | Nathaniel Coe III | Instrumental Intercessory Prayer and Apostolic Music https://www.natecoemusic.com/musicstore https://itunes.apple.com/us/album/the-heart-of-a-minstrel/id1035476762 This is a must have prophetic instrumental for Prayer, Worship, Deliverance, and Altar Calls. With the current revival of prayer and intercession, it is my goal and responsibility to dedicate this album to every house that will respond to the call of prayer. In this season, where our churches have become consumed by preaching and teaching, God is requiring that his church begin to rebuild the altar of prayer. "For it is written, my house shall be called a house of prayer..." Matthew 21:13 If You would like to sow into the ministry of Prophet Nathaniel Coe III: http://paypal.me/natecoe3 Please Visit my Facebook Page for up to date information: https://www.facebook.com/ProphetNateCoe3/ http://www.cdbaby.com/cd/nathanielcoeiii - The Heart Of A Minstrel https://www.facebook.com/natecoe3 http://www.periscope.com/tv/natecoe3 http://www.natecoemusic.com/ministries For all booking requests, please visit us at http://www.natecoemusic.com/bookings. Affirmed as an Apostle, Nathaniel is an anointed and gifted Minstrel, Teacher and Preacher who ministers in the Apostolic and Prophetic dimensions of Christ (Ephesians 4:11). Under the leadership of Apostle Alexander Thompson Of The Ever Abundant Life Church in Darby, PA, Prophet Nate excels in the areas of Spiritual Warfare, Deliverance, and Moving in the Prophetic. Nate's Apostolic assignment on the earth is to train leaders for Kingdom Agenda's. | ["Music", "Tender music"] | ["instrumental music", "gospel music", "strong bass line", "christian contemporary music", "triangle percussions", "piano accompaniment", "piano playing chords", "string bass line", "keyboard accompaniment", "string section harmony", "poignant", "solemn", "steady drumming rhythm", "groovy rhythm", "emotional", "passionate", "spirited", "meditational", "trance like", "prayerful", "meditational", "inspirational", "motivational", "slow tempo"] | 1 | zyXa2tdBTGc | 5520 | |
Beaux Arts Trio plays Dvorak "Dumky" Trio, ii | This music is instrumental. The tempo is slow with a melancholic cello harmony, and a piano and violin accompaniment. The music is soft, pensive, melancholic, sentimental, sad, reflective, meditative and delicate. This music is a Violin Instrumental. | 2008-05-09T02:43:46Z | Scott Meek | Live from Herbst Theatre, San Francisco April 20, 2008 Menahem Pressler, piano Daniel Hope, violin Antonio Meneses, cello | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["instrumental", "slow tempo", "cello", "violin", "sad", "reflective", "delicate", "poignant", "meditative", "reflective", "piano accompaniment", "soft", "mellow", "ambient", "pensive", "ponderous", "sentimental", "emotional"] | 7 | EkmHGd0U8yE | 1585 | |
خالد برزنجي . موسيقى خواطر khalid barzanji.. khawater music .. | This music is a mellow, dulcet instrumental. The tempo is slow with a beautiful violin harmony, piano accompaniment and steady bassline with synthesiser arrangements. The music is serene, calming,soothing, sentimental,emotional, wistful,poignant,melancholic and euphonious. This song is an exquisite middle eastern instrumental. | 2012-11-15T13:15:33Z | khalid barzanji | موسيقى خواطر توزيع وعزف خالد برزنجي لحن المنشد الاماراتي احمد بوخاطر | ["Music", "Sad music"] | ["instrumental", "slow tempo", "ethereal", "exquisite", "middle eastern influences", "euphonious", "poignant", "reflective", "violin harmony", "piano accompaniment", "steady bassline", "beautiful", "serene", "mellifluous", "dulcet", "serene", "melancholic", "romantic", "wistful", "love song", "captivating"] | 7 | 1FnT0RrfMEA | 251 | |
Thorns in the Straw | This song is an instrumental interlude of the Gospel song ‘Thorns in the Straw. The music is slow with a melancholic trombone and tuba harmony, acoustic guitar accompaniment , bass, steady drumming,and synthesiser arrangements. The music is soft, mellow, poignant,pensive, sentimental,emotional, reflective and serene. This song is a Gospel Instrumental. | 2008-12-22T00:26:42Z | Mike Rutter | A video using 'Thorns in the Straw' by Graham Kendrick | ["Brass instrument", "French horn"] | ["instrumental", "slow tempo", "rhythmic acoustic guitar", "trumpets", "trombone harmony", "tuba accompaniment", "bass", "piano accompaniment", "synthesiser arrangement", "soft", "mellow", "gospel music", "instrumental cover", "christian song", "christian praise and worship", "easter song", "good friday", "christmas song", "contemporary christian music", "mellow", "dulcet", "euphonious", "sentimental", "sere", "calm", "soothing", "emotional"] | 7 | 7OjXHfVoI64 | 843 | |
Love Is Spoken Here - Jenny Oaks Baker - Music Video | This song is a soothing instrumental. The tempo is slow with a melancholic violin harmony, banjo and resonator accompaniment, sound of chimes and a sharp tinkle. The music is soft, soothing, melancholic, serene, meditative, pensive and nostalgic. The music uses country style instrumentation. | 2015-07-28T21:30:32Z | The Church of Jesus Christ of Latter-day Saints | http://www.mormonchannel.org/watch/series/music-videos Musician Jenny Oaks Baker and her family share their talents in this arrangement of “Love is Spoken Here.” Love at home is happiness at home. I see my mother kneeling with our family each day. I hear the words she whispers as she bows her head to pray. Her plea to the Father quiets all my fears. And I am thankful love is spoken here. Mine is a home where every hour is blessed by the strength of priesthood power. With father and mother leading the way. Teaching me how to trust and obey; And the things they teach are crystal clear, For love is spoken here. Subscribe to Mormon Channel for the latest videos: http://bit.ly/1M0iPwY Download the Mormon Channel App iOS: http://bit.ly/1yGRgRU Android: http://bit.ly/1ukxbeC Follow Mormon Channel Facebook: https://www.facebook.com/mormonchannel Twitter: https://twitter.com/mormonchannel Instagram: https://instagram.com/mormonchannel Pinterest: https://www.pinterest.com/mormonchannel The Church of Jesus Christ of Latter-day Saints | ["Traditional music", "Music"] | ["instrumental", "slow tempo", "violin harmony", "violins", "resonator", "fiddle", "banjo", "country instrumental", "country music", "mandolin", "cello", "chimes", "ambient sounds of nature", "piano accompaniment", "mellow", "celestial", "ethereal", "soothing", "peaceful", "bowed string instrument", "symphony", "melancholic", "mellifluous", "dulcet"] | 7 | 7Vjp9y6wvkY | 851 | |
[MV] 이수민, 신동우 '달리기' 뮤직비디오 ('Cheer up' Music Video) | A male vocalist sings this soft melody. The tempo is slow with soft , ambient piano /keyboard accompaniment. The song is mellow,melodic, romantic, soothing, emotional, idyllic, charming and dreamy. There is a female vocal at the onset of this clip indicating that this could be a duet. | 2016-06-08T00:07:17Z | 현대자동차그룹(HYUNDAI) | 현대자동차그룹 '현이와 대니의 뉴스룸' 의 MC 이수민, 신동우 출연! 윤상의 '달리기'를 10대의 감성으로 부른 새로운 뮤직비디오 공개! MC Lee Soo-Min, Shin Dong-Woo are on Hyundai Motor Group 'Newsroom of Hyuni and Dani'! Yoon Sang 'Cheer Up', reinterpreted in teen unique style is open! [KOR] 지겨운가요 힘든가요 숨이 턱까지 찼나요 할 수 없죠 어차피 시작해 버린 것을 쏟아지는 햇살 속에 입이 바싹 말라와도 할 수 없죠 창피하게 멈춰 설 순 없으니 단 한가지 약속은 틀림없이 끝이 있다는 것 끝난 뒤에 지겨울 만큼 오랫동안 쉴 수 있다는 것 쏟아지는 햇살 속에 입이 바싹 말라와도 할 수 없죠 창피하게 멈춰 설 순 없으니 이유도 없이 가끔은 눈물나게 억울하겠죠 일등아닌 보통들에겐 박수조차 남의 일인걸 단 한가지 약속은 틀림없이 끝이 있다는 것 끝난 뒤에 지겨울 만큼 오랫동안 쉴 수 있다는 것 It′s good enough for me bye bye bye bye "꿈을 향한 여러분의 달리기를 응원합니다." [ENG] Are you bored? Or are you tired? Otherwise are you out of breath now? Even if it is, there's no way around,cause you've already started. Even though your mouth is dried up in the middle of pouring sunshine, you can't just suddenly stop cause it will be embarrassing. The one and only promise is that you will definitely achieve something. After everything is over,you can take a rest as much as you want. Even though your mouth is dried up in the middle of pouring sunshine, you can't suddenly just stop cause it will be embarrassing. Sometimes without any reason you'll feel something is unfair, and burst into tears. For ordinary people, who are not at the top,it is not easy to get a big hand. The one and only promise is that you will definitely achieve something. After everything is over, you can take a rest as much as you want. It′s good enough for me bye bye bye bye "We support your race towards your own dream" | ["Music", "Tender music"] | ["male singer", "slow tempo", "love song", "korean song", "duet", "female vocals", "foreign language", "foreign music", "world music", "soft pop", "keyboard harmony", "ambient", "korean love song", "k-pop", "mellow", "emotional", "gentle", "melodic", "piano accompaniment", "minimal instruments", "emotional", "pleasant", "young love", "romantic piano"] | 7 | 7LGLhQFiE0s | 833 | |
Ray Manzarek - 02 Solar Boat | A male vocalist sings this Soft Rock. The tempo is slow with electronic arrangements,steady drumming, groovy bass line , and syncopated keyboard harmony. The background instruments play a dissonant melody. This song is a mellow, youthful, punchy, buoyant, Soft Rock. | 2009-11-04T21:57:51Z | Simagga | Ray Manzarek - The Golden Scarab | ["Music", "Soul music"] | ["male singer", "slow tempo", "rock music", "soft rock", "keyboard harmony", "groovy bass line", "syncopated harmony", "piano accompaniment", "steady drumming", "electric guitar lead", "synthesiser arrangement", "rock and roll", "retro feel", "groovy", "soft rock", "buoyant", "punchy beats"] | 7 | n4PBoAedWVA | 4517 | |
Аплодисменты Легенде №17 | The song is an instrumental. The tempo is slow with a piano accompaniment and a strong bass line, with people clapping , whistling, and cheering. The song is being played at a live arena with people getting excited to the song introduction. | 2013-04-19T06:39:31Z | Central Partnership | По окончании фильма "Легенда №17" переполненный зал кинотеатра "Октябрь" взорвался аплодисментами. | ["Applause", "Music"] | ["people cheering", "poor audio quality", "private video", "poor quality recording", "fun", "exciting", "emotional", "lifetime experience", "song introduction", "whistling tones", "instrumental music", "slow tempo", "clapping randomly", "noise", "ambient noises", "piano accompaniment", "strong bass line", "distant music", "live concert"] | 1 | XE4NRSDLYG8 | 3168 | |
BELLA's LULLABY / RIVER FLOWS IN YOU - Music Video -- NEW VERSION | The song is an instrumental. The song is slow tempo with gentle drum brushes, percussion, bass guitar solo, and piano accompaniment gently. The song is groovy and emotional. The song is possibly a Christian worship song or a smooth jazz song. The audio quality is average. | 2009-11-25T20:46:54Z | peoplewholovenewmoon | A heartbreakingly beautiful performance of this hit song by the Korean composer Yiruma - which is not the official Bella's Lullaby, but proved much more popular with Twilight fans. The version features not just piano but achingly melancholy solos by superb musicians on bass, guitar, sax, and vocals. | ["Bass guitar", "Music", "Musical instrument", "Wedding music"] | ["slow tempo", "drum brushes percussions", "inspiring", "devotional", "romantic", "together forever", "ambient room noises", "poignant", "jazz music", "bass solo", "piano accompaniment", "jazz band", "smooth jazz", "live performance", "church music", "slow tempo", "groovy solo", "emotional", "romantic", "poignant", "inspiring", "motivational", "fretboard sounds", "christian music", "music interlude"] | 1 | 0EOQco76eXQ | 135 |
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;