musiccaps_details (view)
13 rows where musiccaps_aspects contains "choral harmony" and musiccaps_author = 7 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 195 ✖
- choral harmony · 13 ✖
- vocalisation 5
- fast tempo 4
- acoustic guitar 3
- alto 3
- celestial 3
- chanting 3
- melodic 3
- soprano 3
- steady drumming 3
- vocal backup 3
- animated 2
- animated vocals 2
- bass 2
- brass band 2
- children’s song 2
- christmas carols 2
- christmas songs 2
- ethereal 2
- grim 2
- happy 2
- high notes 2
- inferior audio quality 2
- intense 2
- keyboard harmony 2
- male singer 2
- male vocalist 2
- medium tempo 2
- muffled audio 2
- peppy 2
- sinister 2
- soothing 2
- tenor 2
- vivacious 2
- acapella 1
- acoustic guitar rhythm 1
- amateur recording 1
- angelic 1
- animated guitar 1
- animated piano 1
- animated trumpets 1
- anthem 1
- baritone 1
- bells 1
- calming 1
- captivating 1
- celebration 1
- cello bass 1
- chanting sutras 1
- charming 1
- cheerful 1
- children vocals 1
- children’s favourite christmas song 1
- children’s ryymes 1
- christmas cheer 1
- christmas greeting 1
- christmas tree 1
- classic 1
- dangerous tense sounds 1
- dark 1
- devotion 1
- dissonant sounds 1
- duet 1
- educational 1
- eerie 1
- electronic organ 1
- emotional 1
- empahtic vocals 1
- engaging 1
- enigmatic 1
- excited 1
- female singer 1
- female vocalists 1
- female voice 1
- festivities 1
- foreign language 1
- fresh 1
- fun 1
- funk 1
- glass harp 1
- grave 1
- greek song 1
- groovy bass lines 1
- hand drums 1
- hand percussion 1
- hard hitting drumming 1
- harmonic 1
- harmonious 1
- harmonizing 1
- home recording 1
- hypnotic music 1
- incantation 1
- incoherent lyrics 1
- incoherent vocal riffs 1
- intense bass lines 1
- joyful 1
- keyboard accompaniment 1
- learning 1
- lively cello 1
- lively trumpets 1
- loud 1
- love 1
- low notes 1
- low pitch 1
- low pitched strings 1
- loyalty 1
- male harmony 1
- male voice 1
- mediocre sound recording 1
- meditation 1
- meditative 1
- medium fast tempo 1
- mellifluous 1
- mellow 1
- melodious 1
- merry 1
- mesmerising 1
- mezzo 1
- mezzo-soprano 1
- mind stimulating 1
- minimal instrumentation 1
- minimalist music 1
- multi vocalists 1
- musical verse 1
- mysterious 1
- no instrumentation 1
- no instruments 1
- nostalgia 1
- orchestral music 1
- outworldly 1
- passionate 1
- patriotic 1
- patriotism 1
- perfect sync 1
- perky 1
- playful 1
- pleasant 1
- pop 1
- prayer 1
- presents 1
- psychedelic 1
- quality of 1
- r&b 1
- reindeer 1
- religious recitation 1
- retro 1
- retro pop 1
- rhythmic acoustic guitar 1
- rustling 1
- sacred 1
- sacred sounds 1
- santa claus 1
- scuffling 1
- seconds 1
- sentimental 1
- shomyo 1
- simple 1
- slick drumming 1
- slow tempo 1
- snow 1
- songs for children 1
- songs for kids 1
- soul 1
- soulful 1
- sound healing 1
- sound of chatter 1
- sound of viola 1
- spirited 1
- spooky 1
- sprightly acoustic guitar 1
- steady bass line 1
- sticks 1
- sweet 1
- swing 1
- swing beat 1
- syncopated sounds 1
- synthesised choral harmony 1
- tambourine 1
- tambourine beats 1
- threatening 1
- timeless 1
- toddlers 1
- tranquil 1
- trombone 1
- unity 1
- vibrations 1
- vigorous 1
- vigorous instrumentation 1
- viola harmony 1
- violins 1
- vital 1
- vocal riff 1
- vocal vibrations 1
- whirring sound 1
- white noise 1
musiccaps_names (array) 19 ✖
- Music 13
- Vocal music 3
- Chant 2
- Happy music 2
- Mantra 2
- /t/dd00003 1
- A capella 1
- Christian music 1
- Christmas music 1
- Folk music 1
- Harmonic 1
- Jazz 1
- Rattle (instrument) 1
- Roll 1
- Singing 1
- Song 1
- Swing music 1
- Theme music 1
- Whale vocalization 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fill the World With Love 6-09 | A female vocalist sings this mellifluous song.The tempo is slow with the vocalist singing a soprano, with alto choral harmony. There are sounds of rustling, whirring,scuttling and people talking in the background. The vocals are beautiful, mellifluous,and ethereal. | 2009-06-07T23:08:18Z | noodlebrain500 | Fill the World With Love 6-09 | ["Music", "Vocal music", "A capella"] | ["female singer", "high notes", "choral harmony", "ethereal", "vocal vibrations", "ethereal", "soprano", "alto", "whirring sound", "seconds", "melodic", "angelic", "celestial", "no instruments", "sound of chatter", "rustling", "scuffling", "harmonious", "amateur recording", "mediocre sound recording", "inferior audio quality", "quality of"] | 7 | -YIT4HBM__g | 61 | |
Royals - Lorde - Vintage/Swing Cover by Flash Mob Jazz ft Lady Armstrong | A group of female vocalists sing this enthusiastic swing song. The tempo is fast with bright trumpet harmony, cello , rhythmic acoustic guitar and slick drumming. The song is upbeat with vocal emphasis and a lively orchestra. This song is a Classic Swing. | 2015-07-09T13:46:23Z | Flash Mob Jazz | *Subscribe for more modern Covers Coming Soon* EP OUT NOW: http://flashmobjazz.bandcamp.com/releases We collaborated with the stunning Lady Armstrong team to creating this fun cover of Royals by Lorde! Check out our Digital albums at www.flashmobjazz.bandcamp.com Thanks for all the support! Website: www.flashmobjazz.com Instagram: @flashmobjazz Facebook: www.facebook.com/FlashMobJazz Twitter: @flashmobjazz Bandcamp: www.flashmobjazz.bandcamp.com Please direct all inquiries to: flashmobjazz@hotmail.co.uk Special thanks to Worthing Theatres and Lee Payne! Audio production: http://www.benjaminjamesrecording.com/ | ["Singing", "Swing music", "Jazz", "Music"] | ["female vocalists", "fast tempo", "choral harmony", "mezzo-soprano", "cello bass", "lively trumpets", "brass band", "slick drumming", "swing beat", "swing", "animated vocals", "melodic", "empahtic vocals", "alto", "soprano", "classic", "lively cello", "acoustic guitar"] | 7 | CWKBzt-v8w4 | 1372 | |
Η γη των μακεδόνων. Τhe Land of the Macedonians. TRADITIONAL Folklore Music | A male chorus sings this passionate song in a foreign language which sounds like Greek. The song is medium tempo with hand percussion like drums, small hand drum, tambourine and a beat with sticks. The vocals are emphatic and sung in lively parts. The song is passionate, emotional, sentimental, and sounds like an anthem or a love song for the Country or a Leader. | 2010-03-08T11:03:55Z | Florinamak | http://florinamak.blogspot.com/2010/03/blog-post.html H ΓΗ ΤΟΥ ΜΕΓΑΛΕΞΑΝΔΡΟΥ Η γη του Μεγαλέξανδρου η γη των Μακεδόνων Η γη του Μεγαλέξανδρου η γη των Μακεδόνων ήταν και θα ναι ελληνική το καμάρι των αιώνων ήταν και θα ναι ελληνική το καμάρι των αιώνων Απ το βορά ως το νοτιά Ανατολή και Δύση Απ τον βορά ως το νοτιά Ανατολή και Δύση Ένα τραγούδι αντηχεί Ποιος θα το σταματήσει Ένα τραγούδι αντηχεί Ποιος θα το σταματήσει Μπάτε κορίστα στο χορό Αγόρια στο μεθύσι Μπάτε κορίστα στο χορό Αγόρια στο μεθύσι Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Μπάτε κορίστα στο χορό Αγόρια στο μεθύσι Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσειιιι ΤΑ ΤΡΑΓΟΥΔΙΑ ΤΗΣ ΜΑΚΕΔΟΝΙΑΣ ΤΕΡΖΗΣ ΜΠΑΓΙΩΚΗΣ | ["Mantra", "Chant", "Folk music", "Music", "Vocal music"] | ["male harmony", "medium tempo", "foreign language", "greek song", "anthem", "hand percussion", "tambourine", "hand drums", "sticks", "choral harmony", "unity", "patriotic", "anthem", "patriotism", "passionate", "emotional", "sentimental", "love", "devotion", "loyalty", "intense", "tenor", "baritone", "bass"] | 7 | 2JnlmS1zzls | 352 | |
Chant pour la guérison | A male sings this resounding chant. The tempo is slow with no instrumentation. The chants are musical verses, meditative choral harmony.it is prayerful, calming, pensive, sacred, prayerful and soulful. | 2012-06-10T10:34:15Z | roda8358 | Chant Pour La Guérison En réalité Mantra de Hein Braat (on vient de me le dire) Maha Mrityeonjaya Mantra http://www.heinbraat.com/discographie/ Télécharger sur votre ordinateur : (actuellement écouter ...) (Dure plus d'un heure) http://www.filancia.com/dl/DalaiLama-ChantPourLaGuerison.mp3 Chant découvert grâce à la crétrice du Site l'unité, Vous pouvez vous joindre http://l-unite.ning.com/ Om Tryambakam Yajamahe Sugandhim Pushtivardhanam Urvarukamiva Bandhanan Mrityor Mukshiya Maamritat We Meditate on the Three-eyed reality Which permeates and nourishes all like a fragrance. May we be liberated from death for the sake of immortality, Even as the cucumber is severed from bondage to the creeper. Nous méditons sur la réalité du troisième oeil Qui imprègne et nourrit tout comme un parfum. Puissions-nous être libérés de la mort pour l'amour de l'immortalité, Alors même que le concombre est sevré de l'esclavage de la vigne Aller voir un de mes blogs : Spiritualité Partage http://roselyne-83.spiritualite.over-blog.com/ Puissent tous les êtres posséder le bonheur et les causes du bonheur Puissent-ils être séparés de la souffrance et des causes de la souffrance ! Puissent-ils n'être jamais séparés du bonheur exempt de souffrance ! Puissent-ils demeurer dans l'équanimité sans attachement ni aversion ! Les 4 Incommensurables (prière bouddhiste) Puisse l'ignorance et la haine disparaître de la surface de la Terre, et le coeur des êtres se remplir d'amour, de compassion et de sagesse. « On peut conquérir des milliers d'hommes dans une bataille ; mais celui qui se conquiert lui-même, lui seul est le plus noble des conquérants. » « L'apaisement réside en chacun de nous. » « Le désarmement extérieur passe par le désarmement intérieur. Le seul vrai garant de la paix est en soi. » « Sème un acte, tu récolteras une habitude ; sème une habitude, tu récolteras un caractère ; sème un caractère, tu récolteras une destinée. » « Il n'y a personne qui soit né sous une mauvaise étoile, il … | ["Mantra", "Music", "Vocal music"] | ["male voice", "chanting", "musical verse", "vibrations", "chanting sutras", "religious recitation", "no instrumentation", "vocalisation", "choral harmony", "meditation", "prayer", "sacred", "sacred sounds", "shomyo", "incantation", "calming", "soothing", "soulful"] | 7 | KZ8gBHLNmH0 | 2094 | |
Yantara Jiro - Harmonic Overtone Meditation 和諧泛音靜心 | A male vocalist chants this captivating harmony. The tempo is slow with electronic music, and vocals sung melodiously to create this hypnotic music. The music is calming, soothing, healing, meditative, psychedelic, trance like, hypnotic and ethereal. The instruments used could be glass harp, a low pitched string instrument and choral vocal chanting. | 2013-06-13T10:10:55Z | 空間逸流 | ["Music", "Harmonic"] | ["vocalisation", "chanting", "hypnotic music", "glass harp", "low pitched strings", "ethereal", "celestial", "choral harmony", "sound healing", "meditative", "psychedelic", "harmonic", "melodious", "captivating"] | 7 | Zhurw43-Y1g | 3405 | ||
Pregnant Singing Guinea Pig | A male vocalist sings this animated melody. The tempo is medium with loud vocals, incoherent lyrics and synthesised choral harmony followed by white noise. | 2008-01-25T17:32:33Z | Myplayvidz | Animated Guinea Pig sings a short clip | ["Music", "/t/dd00003"] | ["male singer", "medium tempo", "incoherent lyrics", "vocal riff", "synthesised choral harmony", "animated", "excited", "loud", "white noise", "vocalisation", "choral harmony", "high notes", "spirited"] | 7 | T7ZSZhcsfjA | 2812 | |
Looking Out My Window - Tom Jones | A male vocalist sings this energetic funk pop. The audio quality is inferior and the song is not clear.The tempo is. Fast with animated trumpets, with a boomy trombone, infectious drumming, keyboard harmony, groovy bass lines, rhythmic electric and acoustic guitar and melodious choral backup. The song is melodic, enthusiastic, energetic, animated and captivating Retro Funk/Pop. | 2008-12-16T18:46:37Z | bomtraumusic | Looking Out My Window Tom Jones | ["Music", "Roll"] | ["male vocalist", "fast tempo", "pop", "retro", "retro pop", "muffled audio", "inferior audio quality", "vivacious", "vigorous", "vital", "funk", "r&b", "soul", "vigorous instrumentation", "brass band", "animated trumpets", "trombone", "hard hitting drumming", "keyboard harmony", "choral harmony", "groovy bass lines", "acoustic guitar rhythm", "brass band"] | 7 | DE6bdmnmPtg | 1454 | |
We Wish You A Merry Christmas (Cover By The Vamps) | A male vocalist sings this popular Christmas carol . The tempo is medium with soft acoustic guitar and steady drumming. The emphasis is on vocals and the highlight of this song is the cheerful and perfectly synced and harmonised vocalisation. It adds layers and textures and gives this age old song a makeover. It is light, happy, peppy, joyful, playful and cheerful. | 2014-01-03T18:50:11Z | The Vamps | Get Wild Heart now on iTunes! http://po.st/VampsiT If you prefer physical copies, a DVD maybe or our bundles with extras go to http://po.st/VampsCDStore ------------------------------------------------------------------- Visit our website to find out news, media and our new store! http://thevamps.net ------------------------------------------------------------------- Like us on Facebook... https://www.facebook.com/thevampsofficial ------------------------------------------------------------------- Follow our band account and personal accounts on Twitter... https://twitter.com/TheVampsband Brad Simpson - https://twitter.com/TheVampsBrad James McVey - https://twitter.com/TheVampsJames Connor Ball - https://twitter.com/TheVampsCon Tristan Evans - https://twitter.com/TheVampsTristan ------------------------------------------------------------------- Subscribe to our YouTube channel for more videos... http://www.youtube.com/user/thevampsofficial ------------------------------------------------------------------- Directed & Edited by Dean Sherwood http://www.twitter.com/DeanSherwood / http://www.deansherwood.com | ["Music", "Happy music"] | ["male vocalist", "acoustic guitar", "vocalisation", "vocal backup", "choral harmony", "cheerful", "fresh", "happy", "vivacious", "joyful", "playful", "timeless", "harmonizing", "christmas carols", "christmas songs", "christmas cheer", "acoustic guitar", "steady drumming", "minimalist music", "christmas greeting"] | 7 | AGsMCWB1tTk | 1096 | |
Jingle Bell Rock - Hall & Oates | A vocalist sings this cheerful Christmas carol. The tempo is medium with an animated piano accompaniment, steady drumming, cymbals, tambourine beats, steady bass line and rhythmic acoustic guitar and melodic backup vocals;. The song is happy, fun, festive, celebratory, wishful, peppy and nostalgic. This song is a Christmas Carol. | 2010-11-26T02:57:05Z | R2197 | "Jingle Bell Rock" cover by Daryl Hall and John Oates. I do not own this music. No copyright infringement intended. For entertainment purposes only. Courtesy of Daryl Hall and John Oates. From the updated 2006 album "Home for Christmas". Enjoy. Lyrics: Jingle bell, jingle bell, jingle bell rock Jingle bells swing and jingle bells ring Snowin' and blowin' up bushels of fun Now the jingle hop has begun Jingle bell, jingle bell, jingle bell rock Jingle bells chime in jingle bell time Dancin' and prancin' in Jingle Bell Square In the frosty air What a bright time, it's the right time To rock the night away Jingle bell time is a swell time To go glidin' in a one-horse sleigh Giddy-up jingle horse, pick up your feet Jingle around the clock Mix and a-mingle in the jinglin' feet That's the jingle bell rock Jingle bell, jingle bell, jingle bell rock (repeat verse1's Jingle bells chime in jingle bell time last 4 lines) Dancin' and prancin' in Jingle Bell Square In the frosty air What a bright time, it's the right time To rock the night away Jingle bell time is a swell time To go glidin' in a one-horse sleigh Giddy-up jingle horse, pick up your feet Jingle around the clock Mix and a-mingle in the jinglin' feet That's the jingle bell That's the jingle bell That's the jingle bell rock! | ["Christmas music", "Christian music", "Music", "Song"] | ["male singer", "medium fast tempo", "animated piano", "vocal backup", "bells", "tambourine beats", "steady drumming", "steady bass line", "choral harmony", "rhythmic acoustic guitar", "christmas songs", "christmas carols", "children’s song", "children’s favourite christmas song", "santa claus", "christmas tree", "presents", "snow", "reindeer", "fun", "celebration", "festivities", "merry", "perky", "peppy", "nostalgia"] | 7 | ZUcHBeueBww | 3382 | |
Misty Mountains from "The Hobbit" A Cappella - Street Corner Symphony | This song is a choral harmony. The tempo is slow with intense bass and an instrument that sounds like a viola. The song is grim, grave, intense, sinister; eerie; spooky; scary, chant-like, and dreary. | 2013-01-05T10:52:17Z | Street Corner Symphony | iTunes: http://bit.ly/Dwarves Amazon MP3: http://bit.ly/DwarvesA Google Play: http://bit.ly/DwarvesGP https://www.streetcornersymphony.com Facebook: https://www.facebook.com/StreetCornerSymphony Twitter: @StreetCornerSym Instagram: @streetcornersym Sung by Project Pigeon (1/3 of Street Corner Symphony), featuring Adam Chance (1/6 of Street Corner Symphony). They tell us that adds up to half of SCS, but math is hard. This is an expanded version of the beautiful dwarf ballad from the 2012 film "The Hobbit: An Unexpected Journey," arranged by John Martin, using the parts of Tolkien's poem describing Smaug's arrival at Erebor. We hope you love it! Please share with the world, leave a comment, and let us know what else you'd like to hear from us. We made this video in about a week, each of us videoing himself in his own home (Tuscaloosa, AL; Montgomery, AL; Nashville, TN). Mixed by John Martin Video Edited by Mark McLemore Sung by John Martin: Lead and Lots of Other Parts Adam Chance: Bass, Baritone and Burger Mark McLemore: Everything Else Follow Project Pigeon on Twitter! @ProjectPigeon1 The three of us are part of Street Corner Symphony. @StreetCornerSym http://streetcornersymphony.com | ["Chant", "Music"] | ["choral harmony", "slow tempo", "viola harmony", "sinister", "mysterious", "grim", "grave", "intense", "spooky", "acapella", "chanting", "threatening", "low pitch", "low notes", "intense", "grave", "sound of viola", "minimal instrumentation", "intense bass lines", "mellow", "intense", "dark"] | 7 | aY8-pXDdwiw | 3552 | |
Care bears movie song" forest of feelings" | This song is an animated Children’s Song. The tempo is fast with many singing different parts. The song is simple and happy with spirited backup vocals, female, male and child vocals with an animated keyboard harmony, rhythmic drumming , acoustic guitar and choral harmony. The song is light, peppy, engaging and is designed for toddlers and children. The audio is a home recording and the song is muffled. | 2013-03-30T01:01:25Z | Kristy Rivera | Forest of feelings song when the care bears and Kim and jason get sent to earth buy instead get trapped between a world between care a lot and earth. | ["Music", "Rattle (instrument)"] | ["duet", "fast tempo", "multi vocalists", "engaging", "toddlers", "choral harmony", "peppy", "happy", "acoustic guitar", "muffled audio", "home recording", "animated", "muffled audio", "animated guitar", "vocal backup", "keyboard harmony", "steady drumming", "animated vocals", "children vocals", "children’s song", "children’s ryymes", "songs for kids", "songs for children", "educational", "learning", "mind stimulating", "animated"] | 7 | w3QIsHxQfPE | 5234 | |
I Seek Sensei Song - SGI Youth March16 toward 2030.wmv | This song is an instrumental. The tempo is fast with an enthusiastic acoustic guitar melody, keyboard accompaniment and a mellifluous female vocalisation with choral harmony. The music is rhythmic, youthful, simple,beautiful, charming, soothing, pleasant, charming, and tranquil. | 2012-03-07T17:18:10Z | OricoApps | Celebrating Youth Division and future growth toward Soka Gakkai's 100thanniversary. ChantBuddy creates "I seek Sensei" clip for everybody to sing along in group activity. Enjoy http://www.chantbuddy.com/ | ["Music", "Happy music"] | ["female voice", "fast tempo", "choral harmony", "charming", "pleasant", "simple", "tranquil", "soothing", "keyboard accompaniment", "sweet", "mellifluous", "melodic", "vocalisation", "sprightly acoustic guitar"] | 7 | 3VEMHWnewuc | 473 | |
~ Whales Singing - Walgesang ~ | This song is an orchestral piece. The tempo is slow with the vocalist singing in soprano,alto, mezzo, treble and bass harmony. The song is intense, grim, sinister, indicative of danger, eerie, enigmatic, out worldly and mesmerising. There are incoherent vocal riffs and sounds towards the end of this clip. | 2012-03-12T15:25:34Z | 𝓐𝓼𝓱𝓪𝓽𝓾𝓻 | +++++++++++++++++++++++++++++++++++ ♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡♡ Galactic Federation of Light First Contact Ashtar Command Project World Evacuation Cropcircles REVOLUTION is Now love liebe truth wahrheit maya alien et ufo Planet X Nibiru evakuierung 2012 dna dimension galactic Consciousness Bewusstsein fifth dimension God Jesus Christ paradise kingdom of heaven New Golden Age of Aquarius Pleiadians Sheldan Nidle Mayan Calendar Bibel ovni нло круги на полях инопланетяне cropcircles kornkreise Shambhala Agharta Third Reich Atlantis enigma spiritual era delerium romantic ryan farish amethystium sleepthief spirit new age ambient final fantasy Spiritual Awakening Mandalas meditation StarWheels chillout Myst 4 IV Revelation Apocalypse Apokalypse Enthüllung Offenbarung | ["Theme music", "Whale vocalization", "Music"] | ["orchestral music", "choral harmony", "sinister", "incoherent vocal riffs", "mesmerising", "outworldly", "soprano", "celestial", "enigmatic", "perfect sync", "grim", "sinister", "mezzo", "alto", "mezzo", "tenor", "bass", "violins", "syncopated sounds", "dissonant sounds", "sinister", "eerie", "dangerous tense sounds", "electronic organ"] | 7 | fBEGBuO3RXg | 3929 |
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;