musiccaps_details (view)
23 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "punchy kick"
This data as json, CSV (advanced)
musiccaps_aspects (array) 103 ✖
- groovy bass · 23 ✖
- passionate · 23 ✖
- punchy kick · 23 ✖
- low quality 19
- shimmering hi hats 13
- punchy snare 12
- emotional 9
- groovy 9
- live performance 9
- energetic 6
- funky 5
- addictive 4
- jazz 4
- noisy 4
- pop 4
- soulful 4
- claps 3
- disco 3
- electric guitar melody 3
- funky electric guitar melody 3
- passionate female vocal 3
- passionate male vocal 3
- rock 3
- shimmering cymbals 3
- flat male vocal 2
- groovy piano melody 2
- harmonizing male vocals 2
- mellow piano melody 2
- shimmering crash cymbal 2
- snappy rimshots 2
- sustained strings melody 2
- synth pad 2
- wooden percussions 2
- accordion melody 1
- acoustic rhythm guitar 1
- addictive female vocal 1
- background music 1
- brass melody 1
- choir 1
- cinematic 1
- crowd cheering 1
- crowd singing 1
- dissonant brass stabs 1
- distorted 1
- easygoing 1
- echoing flat male vocal 1
- echoing synth bell melody 1
- energetic crash cymbal 1
- energetic male vocal 1
- folk 1
- fruity male vocal 1
- funky synth lead melody 1
- gospel 1
- groovy rhodes keys melody 1
- groovy synth keys melody 1
- harmonizing background vocals 1
- harmonizing choir 1
- harmonizing female vocals 1
- harmonizing male vocal 1
- harsh 1
- joyful 1
- mellow keys chords 1
- mellow piano chords 1
- messy 1
- mono 1
- muffled passionate male vocal 1
- passionate boy vocal 1
- passionate echoing female vocal 1
- passionate female vocals 1
- pulsating synth melody 1
- punchy tom 1
- regional mexican 1
- repetitive electric guitar melody 1
- repetitive synth lead melody 1
- saxophone melody 1
- saxophone solo melody 1
- shimmering open hats 1
- shimmering shakers 1
- short drums roll 1
- simple hi hats 1
- snare roll 1
- soul 1
- string melody 1
- strings melody 1
- sustained strings 1
- synth keys chords 1
- synth pad chords 1
- tenor sax solo melody 1
- traditional 1
- traditional pop 1
- trumpet melody 1
- unbalanced stereo 1
- upbeat 1
- wide acoustic rhythm guitar 1
- wide acoustic rhythm guitars 1
- wide bouncy wooden percussion 1
- wide electric guitar melody 1
- wide funky electric guitar melody 1
- wide harmonizing vocals 1
- wide passionate harmonizing male vocals 1
- wide sustained strings melody 1
- wide wooden percussions 1
- wooden snare hits 1
musiccaps_names (array) 32 ✖
- Music 20
- Singing 4
- Ska 4
- Choir 3
- Jazz 3
- Music of Asia 3
- Exciting music 2
- Funk 2
- Keyboard (musical) 2
- Musical instrument 2
- Opera 2
- Piano 2
- Rhythm and blues 2
- Accordion 1
- Blues 1
- Brass instrument 1
- Christian music 1
- Classical music 1
- Disco 1
- Electric piano 1
- Electronic music 1
- Electronic organ 1
- Gospel music 1
- Organ 1
- Pop music 1
- Salsa music 1
- Saxophone 1
- Song 1
- Swing music 1
- Techno 1
- Tender music 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 |
---|---|---|---|---|---|---|---|---|---|---|
Red Hot Chili Peppers - Nothing To Lose - B-Side [HD] | The Rock song features an energetic male vocal singing over repetitive electric guitar melody, groovy bass, punchy kick and snare, shimmering hi hats and energetic crash cymbal. There is a short drum roll that represents a variation in a repetitive loop. It sounds energetic and passionate. | 2011-07-31T19:54:18Z | llllphaserllll | "Nothing To Lose" is a live jam B-Side of the Red Hot Chili Peppers single "Can't Stop" from their 2002 album "By The Way". [HD VIDEOS] + RHCP Live in Koln 2011 - http://www.youtube.com/user/IIIIphaserIIII + RHCP B-Sides + Bonus Tracks - http://www.youtube.com/user/llllphaserllll + RHCP Live Off The Map - http://www.youtube.com/user/IIphaserII + RHCP Live at the BBC - http://www.youtube.com/user/Iphaserl + RHCP Live at Slane Castle - http://www.youtube.com/user/IlasterixIl + RHCP Live in Poland - http://www.youtube.com/user/lllasterixlll + RHCP Live in Red Square Moscow - http://www.youtube.com/user/llphaserll + Radiohead In Rainbows Live From The Basement - http://www.youtube.com/user/IIIphaserIII + Radiohead The King Of Limbs Live From The Basement - http://www.youtube.com/user/lllphaserlll + Radiohead TV Performances / Live At The Grammys - http://www.youtube.com/user/lIphaserlI + Radiohead HD Official Videos http://www.youtube.com/user/lphaserI Tags: Red Hot Chili Peppers Nothing To Lose Rare B-Side Bonus Track 2002 Can't Stop Single By The Way HD High Definition HQ Quality 1080p Anthony Kiedis Flea John Frusciante Chad Smith | ["Music", "Ska"] | ["rock", "energetic male vocal", "repetitive electric guitar melody", "groovy bass", "punchy snare", "punchy kick", "shimmering hi hats", "short drums roll", "energetic crash cymbal", "energetic", "passionate"] | 4 | 0EzWmAPwoTs | 137 | |
El Pali - De Agujeritos! | The low quality recording features a regional Mexican song that consists of harmonizing male vocals singing over wide, bouncy wooden percussion, wide acoustic rhythm guitar, groovy bass, punchy kick and strings melody. It sounds passionate, energetic and groovy. | 2009-02-08T22:49:27Z | frager046 | ["Music", "Ska"] | ["regional mexican", "low quality", "wide bouncy wooden percussion", "wide acoustic rhythm guitar", "harmonizing male vocals", "groovy bass", "punchy kick", "strings melody", "passionate", "energetic", "groovy"] | 4 | 3rbWoeUg9yo | 508 | ||
Lee Min Ho - Faith Korean Drama 2012 | The low quality recording features a pop song that consists of an electric guitar melody, shimmering hi hats, groovy bass, sustained strings melody, pulsating synth melody, punchy kick and echoing synth bell melody. It sounds emotional, passionate and cinematic, as it also sounds like something that would go well as a background music for movies. | 2012-11-02T12:16:52Z | MsDallia91 | Faith also called the great doctor is a Korean historical drama made in 2012 with Lee Min Ho and Kim Hee Sun. | ["Music", "Tender music"] | ["pop", "low quality", "electric guitar melody", "shimmering hi hats", "groovy bass", "sustained strings melody", "pulsating synth melody", "punchy kick", "echoing synth bell melody", "emotional", "passionate", "cinematic", "background music"] | 4 | 8FZb_R2UANY | 906 | |
Devil in Disguise | The low quality features a rock song that consists of a muffled passionate male vocal singing over wide acoustic rhythm guitars chords, shimmering cymbals, punchy kick and groovy bass. It sounds addictive, passionate and groovy - like something you would hear in pubs and bars during the 50s. | 2009-07-27T16:11:01Z | autopeerke | ["Music", "Rhythm and blues", "Ska"] | ["low quality", "rock", "muffled passionate male vocal", "wide acoustic rhythm guitars", "shimmering cymbals", "punchy kick", "groovy bass", "passionate", "addictive", "groovy"] | 4 | 9UOPRQhNzQ8 | 1014 | ||
Cody Simpson - Perfect - Music Video - Full - HQ | The low quality recording features a passionate boy vocal singing over punchy kick, groovy bass, shimmering hi hats and crash cymbal hit and groovy piano melody. It sounds emotional and passionate. | 2010-01-11T17:02:15Z | CodySupport | CREATE AND ORDER YOUR OWN GUITAR PICK HERE http://www.MyPickShopOnline.com/ Learn To Play Guitar Online: http://youtube.com/EasyTabber/ | ["Blues", "Music", "Pop music"] | ["low quality", "groovy bass", "punchy kick", "passionate boy vocal", "shimmering hi hats", "shimmering crash cymbal", "groovy piano melody", "emotional", "passionate"] | 4 | 9cojCCMSABc | 1029 | |
Shukri Jamal - Abbaan lafaa dhabe lafasaa (Oromo Music 2014 New) | The low quality recording features an echoing flat male vocal, alongside harmonizing male vocal, singing over sustained strings melody, shimmering open hats, wooden percussions, punchy kick and groovy bass. It sounds traditional and passionate. | 2014-04-18T18:56:19Z | Oromp3 | Check http://www.oromp3.com/ for more Oromo music, comedy, drama & MP3 Songs. | ["Jazz", "Music"] | ["low quality", "echoing flat male vocal", "wooden percussions", "shimmering open hats", "sustained strings melody", "punchy kick", "groovy bass", "joyful", "passionate", "traditional", "harmonizing male vocal"] | 4 | Bap5P9buB0Y | 1264 | |
Chemong ding chu - Janglal Khongsai | The Soul song features a passionate male vocal singing over shimmering hi hats and shakers, groovy bass, widely spread wooden percussions, punchy kick and snare hits, wide sustained strings melody and mellow piano melody. It sounds emotional and passionate. | 2015-11-12T17:56:14Z | Bombiel Media | Senorita 3: Thadou-Kuki Visual Album M.Lien Thugs Production | ["Music of Asia", "Christian music", "Music", "Song"] | ["soul", "passionate male vocal", "wide wooden percussions", "punchy kick", "groovy bass", "wide sustained strings melody", "mellow piano melody", "shimmering hi hats", "punchy snare", "emotional", "passionate"] | 4 | BiQik0xsWxk | 1279 | |
Brian Auger - Compared to what (Live at Baked Potato) | The low quality recording features a live performance of a jazz song and it consists of a groovy bass guitar, groovy rhodes keys, electric guitar melody, shimmering hi hats, punchy kick and punchy snare hits. It sounds groovy, funky and passionate. The recording is noisy and in mono. | 2011-11-22T14:17:10Z | Bluedreams | The Brian Auger's Oblivion express live at "Baked Potato", Hollywood 2004. The Band is: Brian Auger - Hammond Organ, Keyboards and Electric piano Savannah Grace Auger - Vocals Derek Frank - Bass Karma D. Auger - Drums | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "jazz", "live performance", "mono", "noisy", "groovy bass", "groovy rhodes keys melody", "electric guitar melody", "shimmering hi hats", "punchy kick", "punchy snare", "funky", "groovy", "passionate"] | 4 | CrkxrgTiVyk | 1410 | |
Norske Artister - Venn | The low quality recording features a live performance of a rock song that contains harmonizing background vocals, alongside passionate female vocals, singing over wide electric guitar melody, punchy snare, groovy bass, punchy kick and shimmering hi hats and crash cymbals. It sounds emotional, passionate and addictive - thanks to that cadence. | 2007-12-08T21:06:41Z | Primož Dimnik | Norske Artister - Venn (Live) Espen Lind, Lene Marlin, Sivert Hoyem, Thomas Dybdahl; Espen Lind, Lene Marlin, Bertine Zetlitz, Sissel Kyrkjebø, Kurt Nilsen; Ravi, Morten Abel, ... | ["Singing", "Music", "Choir"] | ["low quality", "live performance", "rock", "harmonizing background vocals", "passionate female vocals", "wide electric guitar melody", "punchy snare", "groovy bass", "punchy kick", "shimmering hi hats", "emotional", "passionate", "addictive", "shimmering crash cymbal"] | 4 | EsssGCL-Axw | 1597 | |
70s Disco Hits - A Video Compilation of Disco Music from the 70's | The Disco song features a passionate male vocalist singing over funky electric guitar melody, groovy bass, punchy kick and snare hits, shimmering hi hats and groovy synth keys melody. It sounds groovy, funky and passionate. | 2008-11-27T00:42:17Z | TheGreat70s | Song List w/ Full Videos : https://thegreat70s.com/Song-List-70s-Disco-Hits.html 70 Disco Music Video Station: https://thegreat70s.com/music-video-stations/ Video Description: A medley of video clips of Disco music from the 70s. For more great 70s videos visit https://www.thegreat70s.com | ["Music", "Rhythm and blues"] | ["disco", "passionate male vocal", "funky electric guitar melody", "groovy bass", "punchy kick", "punchy snare", "shimmering hi hats", "groovy synth keys melody", "passionate", "groovy", "funky"] | 4 | JlzlNpttvVM | 2031 | |
Fender Rhodes Mark VII | The low quality recording features a live performance of a jazz song and it consists of a saxophone solo melody played over mellow keys chords, groovy bass, punchy snare and kick hits and shimmering hi hats. It sounds passionate and soulful. | 2007-01-29T02:12:06Z | alex.rodrigues | Namm Show report on New Rhodes MK 7 http://www.rhodespiano.com/namm_info.htm | ["Jazz", "Music", "Keyboard (musical)", "Piano"] | ["low quality", "jazz", "live performance", "saxophone solo melody", "shimmering hi hats", "punchy kick", "punchy snare", "mellow keys chords", "groovy bass", "passionate", "soulful"] | 4 | Oe_xSG_ic-c | 2455 | |
Take Me to the Water (Rollo Dilworth) - NH All State 2010 | The low quality recording features a choir singing over punchy kick and snare hits, shimmering hi hats, groovy piano and groovy bass. In the first half, there are harmonizing female vocals singing, after which the male harmonizing vocals start singing. It sounds soulful, passionate and emotional. The recording is a bit noisy. | 2010-04-27T21:15:01Z | musiclvr731 | (Take Me to the Water) The 2010 NH All State Mixed Choir under the direction of Dr. Janet Galvan performs Take Me to the Water by Rollo Dilworth. | ["Singing", "Music", "Opera", "Classical music", "Choir"] | ["low quality", "noisy", "choir", "harmonizing female vocals", "harmonizing male vocals", "punchy snare", "punchy kick", "shimmering hi hats", "groovy piano melody", "groovy bass", "live performance", "soulful", "passionate", "emotional"] | 4 | TokHdpvX7Es | 2866 | |
Fifth Element - Techno opera | The low quality recording features a passionate female vocalist singing over dissonant brass stabs, groovy bass, wooden snare hits, synth pad chords, punchy kicks and shimmering hi-hats. It sounds groovy and passionate. | 2010-05-17T19:22:17Z | 1kRaFt (KRAFTWIN) | Fifth Element - Techno opera. Original: Performed by Inva Mula. Composed and Produced by Eric Serra. More: http://www.imdb.com/title/tt0119116/soundtrack | ["Electronic music", "Music", "Opera", "Techno"] | ["low quality", "dissonant brass stabs", "groovy bass", "passionate female vocal", "wooden snare hits", "punchy kick", "shimmering hi hats", "groovy", "passionate", "synth pad chords"] | 4 | WE0JqjuhaQI | 3076 | |
PUFF DADDY & FAITH feat. 112 - ILL BE MISSING YOU | The low quality recording features a live performance of a pop song that consists of flat male vocal talking, passionate female vocal, alongside harmonizing wide female vocals, singing over punchy kick and snare hits, shimmering hi hats and groovy bass. There are crowd singing and cheering sounds in the background. It sounds groovy, emotional, energetic and passionate. | 2009-06-24T16:34:33Z | PaulP | I'll Be Missing You by Puff Daddy (Dedicated to Notorious B.I.G.) (Puff) Seems like yesterday we used to rock the show I lace the track you lock the flow So far from hanging on the block of dough Notorious they got to know that Life ain't always as it seem to be Words can't express what you mean to me And though you're gone We still a team Through your family I'll fulfill your dreams In the future can't wait to see If you'll open up the gates for me Remenice sometime The night they took my friend Try to black it out but it plays again When it's weird feelin' it's really hard to conceil Can't imagine all the pain I feel Give everything to hear half your breath I know you still livin' your life after death CHORUS: (Faith) Every step I take Every move I make Every single day Every time I pray I'll be missing you Thinking of the day When you went away What a life to take What a bond to break I'll be missing you (Puff) It's kind of hard wit you not around Know you in heaven smilin' down Watchin' us while we pray for you Everyday we pray for you Till the day we meet again In my heart is where I'll keep you friend Memories give me the strength I need to proceed Strength I need to believe My thoughts big I just can't define Wish I could turn back the hands of time Bust in the 6 Shop for new clothes and kicks You and me taking flicks Making hits stages they receive you on Still can't believe you're gone Give anything to hear half your breath I know you still livin' your life after death CHORUS: (Faith) Every step I take Every move I make Every single day Every time I pray I'll be missing you Thinking of the day When you went away What a life to take What a bond to break I'll be missing you some glad morning When this life is over I know I'll see your face CHORUS (112) x4 Every night I pray E… | ["Singing", "Music of Asia", "Music"] | ["pop", "low quality", "live performance", "flat male vocal", "passionate female vocal", "wide harmonizing vocals", "punchy kick", "punchy snare", "shimmering hi hats", "groovy bass", "crowd cheering", "crowd singing", "energetic", "groovy", "emotional", "passionate"] | 4 | XILyHZyyCik | 3174 | |
บาสโลบจังหวะดิสโก้ | The low quality recording features a pop song that consists of a passionate male vocal singing over punchy kick and snare hits, shimmering shakers, synth pad, groovy bass and brass melody. It sounds passionate, emotional, energetic and upbeat. | 2012-10-08T01:26:28Z | Tanwarat mu | เพลงนี้ใช่ท่าจังหวะบาสโลบที่ 3 ใช้เพลงจังหวะดิสโก้เป็นจังหวะที่สนุก ฝึกความจำและสมาธิในการเต้น | ["Disco", "Music"] | ["low quality", "pop", "punchy kick", "punchy snare", "groovy bass", "synth pad", "shimmering shakers", "passionate male vocal", "brass melody", "passionate", "emotional", "energetic", "upbeat"] | 4 | _x4a974Pl-A | 3500 | |
Jon Cleary - When You Get Back (Live at Jazz Fest 2007) | The low quality recording features a live performance of a jazz song that consists of a wide passionate, harmonizing male vocals singing over punchy snare and kick hits, shimmering hi hats, groovy bass guitar, synth pad and funky electric guitar melody. It sounds funky, groovy and passionate. | 2009-04-24T23:01:22Z | Jon Cleary | Jon Cleary live at the New Orleans Jazz & Heritage Festival Follow Jon https://www.facebook.com/jonclearymusicofficial/ https://www.instagram.com/jonclearymusic/ https://twitter.com/jonclearymusic http://www.bandsintown.com/JonCleary | ["Ska"] | ["low quality", "noisy", "jazz", "live performance", "synth pad", "groovy bass", "funky electric guitar melody", "wide passionate harmonizing male vocals", "punchy kick", "punchy kick", "shimmering hi hats", "funky", "groovy", "passionate"] | 4 | _y07ENAx2_E | 3503 | |
Fatima Tuz Zahra Oyshee-De De pal Tule de - Live on RTV MUSIC STATION | The low quality recording features a live performance of a traditional pop song and it consists of an addictive female vocal singing over punchy kick and snare hits, groovy bass, electric guitar melody, strings melody and wooden percussion. There is a short snare roll, right before the bass drops. It sounds messy, a bit harsh, distorted, but also passionate, addictive and energetic. | 2015-11-15T15:01:18Z | Oyshee Express | Singer- Fatima Tuz zahra Oyshee Lyric & Tune: Abdur Rahman Boyati Produced by Khoshru Anchored by Liza Bass Guitar- Sohel Rana Flute: Kamrul Lead Guitar: Roman Keyboard: Nadim Pad: Sakib Percussion: Ujjol | ["Music of Asia", "Music", "Salsa music"] | ["live performance", "low quality", "traditional pop", "addictive female vocal", "punchy snare", "wooden percussions", "snare roll", "groovy bass", "string melody", "electric guitar melody", "punchy kick", "messy", "distorted", "harsh", "passionate", "addictive", "energetic"] | 4 | eISYX9koocM | 3855 | |
Karène Neuville 14 ans - Pasos Lesterps 2015 | The low quality recording features a live performance of a folk song that contains an accordion melody playing over acoustic rhythm guitar, groovy bass, punchy kick and snare hits, shimmering cymbals, saxophone and trumpet melody. It sounds passionate and easygoing, even though the recording is noisy and the stereo image is unbalanced, due to the fact that the sound is leaning towards the left channel. | 2015-07-21T19:29:48Z | Armand Boudet | Je vous invite aujourd'hui à visiter le site www.kareneneuville.fr dans lequel vous trouverez toutes les infos sur l'agenda de Karène et les CD disponibles à la vente | ["Swing music", "Music", "Musical instrument", "Accordion"] | ["low quality", "live performance", "folk", "accordion melody", "acoustic rhythm guitar", "shimmering cymbals", "punchy kick", "punchy snare", "saxophone melody", "trumpet melody", "groovy bass", "noisy", "unbalanced stereo", "passionate", "easygoing"] | 4 | gsIB8HjsRtw | 4064 | |
ronaldinho vs robinho | The low quality recording features a pop song that consists of a passionate, echoing female vocal singing over punchy kick, groovy bass, repetitive synth lead melody and some claps. It sounds energetic, passionate and addictive. | 2006-07-31T13:04:30Z | Claudio Maio | the gods of tricks see the new video: henry vs zlatan ibrahimovic melhorado | ["Music", "Exciting music"] | ["low quality", "pop", "punchy kick", "groovy bass", "claps", "passionate echoing female vocal", "repetitive synth lead melody", "energetic", "passionate", "addictive"] | 4 | kAAGkKPVgZ8 | 4302 | |
FGHT Dallas: Rev. Timothy Wright sings 'He Kept Me', 80/50 Celebration | The low quality recording features a fruity male vocal talking, after which he starts singing over harmonizing choir, groovy bass, mellow piano melody, shimmering cymbals, punchy kick, punchy tom and snappy rimshots. It sounds emotional, soulful and passionate. | 2008-01-08T05:19:40Z | Full Gospel Holy Temple | Rev. Timothy Wright ministers with this song. | ["Singing", "Gospel music", "Choir"] | ["low quality", "fruity male vocal", "gospel", "harmonizing choir", "groovy bass", "mellow piano melody", "shimmering cymbals", "punchy kick", "punchy tom", "snappy rimshots", "emotional", "soulful", "passionate"] | 4 | lSbCqHZy_l4 | 4399 | |
Sick Funk Jam! Hug Me Squeeze Me! | The Disco song features a passionate female vocalist singing over a funky electric guitar melody, groovy bass, punchy kick and claps. It sounds passionate, funky and groovy - like something you would hear in clubs during the 80s. | 2010-06-21T23:33:22Z | turtle101392 | Debra Hurd- Hug me Squeeze Me | ["Funk", "Music", "Exciting music"] | ["disco", "low quality", "passionate female vocal", "funky electric guitar melody", "groovy bass", "punchy kick", "claps", "passionate", "funky", "groovy"] | 4 | lXrypwLQO3U | 4406 | |
*Classy Freak* | The Disco song features a flat male vocal singing over a wide funky electric guitar melody, groovy bass, synth keys chords, funky synth lead melody, punchy kick, punchy snare layered with some claps and simple hi hats. It sounds passionate, funky and groovy. | 2008-06-22T21:32:10Z | IwYlAj | PLAIR 1984 Label: P.A.R. | ["Funk", "Music"] | ["disco", "wide funky electric guitar melody", "synth keys chords", "funky synth lead melody", "groovy bass", "punchy kick", "punchy snare", "simple hi hats", "claps", "flat male vocal", "passionate", "funky", "groovy"] | 4 | p8xxC2um9xQ | 4688 | |
Tony on Tenor Sax | The low quality recording features a live performance of a jazz song that consists of a tenor sax solo melody playing over mellow piano chords, sustained strings, groovy bass, snappy rimshots, shimmering hi hats and punchy kicks. It sounds emotional, passionate and soulful. | 2008-01-24T22:22:32Z | Tony Bolivar | Because of Who You Are | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Wedding music", "Saxophone"] | ["low quality", "live performance", "jazz", "tenor sax solo melody", "groovy bass", "mellow piano chords", "shimmering hi hats", "punchy kick", "snappy rimshots", "sustained strings", "passionate", "emotional", "soulful"] | 4 | tuoBmxts5Xo | 5075 |
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;