musiccaps_details (view)
17 rows where musiccaps_aspects contains "keyboard accompaniment", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- keyboard accompaniment · 17 ✖
- medium tempo · 17 ✖
- passionate · 17 ✖
- romantic 9
- emotional 7
- poor audio quality 7
- steady drumming rhythm 7
- love song 6
- energetic 5
- groovy music 4
- guitar rhythm 4
- male singer 4
- strong bass line 4
- bad audio quality 3
- instrumental music 3
- percussive bass line 3
- retro pop hits 3
- spirited 3
- vocal harmony 3
- acoustic guitar 2
- female singer 2
- groovy bass line 2
- live performance 2
- love songs 2
- male singers 2
- steady drumming 2
- tambourine percussions 2
- telephone ringing 2
- youthful 2
- acoustic guitar harmony 1
- …
musiccaps_names (array) 28 ✖
- Music 16
- Singing 4
- Christian music 2
- Happy music 2
- Hip hop music 2
- Middle Eastern music 2
- Telephone bell ringing 2
- Choir 1
- Crowd 1
- Electric piano 1
- Electronic organ 1
- Exciting music 1
- Folk music 1
- Gospel music 1
- Grunge 1
- Harmonic 1
- Independent music 1
- Inside, large room or hall 1
- Inside, small room 1
- Jazz 1
- Keyboard (musical) 1
- Music of Asia 1
- Organ 1
- Piano 1
- Rattle (instrument) 1
- Salsa music 1
- Theremin 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
*NSYNC - (God Must Have Spent) A Little More Time On You (Videoclip) | Male singers sing this vocal harmony. The tempo is medium with a steady drumming rhythm, various percussion tones, keyboard accompaniment, steady bass line and tambourine percussion. The song is soothing and romantic. The song is a retro pop hit. | 2009-10-25T06:55:08Z | NSYNCVEVO | 'N SYNC's official music video for '(God Must Have Spent) A Little More Time On You'. Click to listen to 'N SYNC on Spotify: http://smarturl.it/NSYNCSpot?IQid=NSYNCGMH As featured on *NSYNC: Greatest Hits. Click to buy the track or album via iTunes: http://smarturl.it/NSYNCGreatestHits?IQid=NSYNCGMH Google Play: http://smarturl.it/GMHGPlay?IQid=NSYNCGMH Amazon: http://smarturl.it/NSYGHAmazon?IQid=NSYNCGMH More From 'N SYNC It's Gonna Be Me: https://youtu.be/GQMlWwIXg3M This I Promise You: https://youtu.be/6thmPrTxBtI Pop: https://youtu.be/TWZKw_MgUPI More great 00s videos here: http://smarturl.it/Ultimate00?IQid=NSYNCGMH Follow 'N SYNC Facebook: https://www.facebook.com/nsync Twitter: https://twitter.com/nsync Subscribe to 'N SYNC on YouTube: http://smarturl.it/NSYNCSub?IQid=NSYNCGMH --------- Lyrics: Yeah.... Oh yes Ohhh..yeah.. Can this be true? Tell me, can this be real? How can I put into words what I feel? My life was complete I thought I was whole Why do I feel like I'm losing control? I never thought that love could feel like this and you've changed my world with just one kiss. How can it be that right here with me there's an angel? It's a miracle... Your love is like a river Peaceful and deep Your soul is like a secret That I never could keep When I look into your eyes I know that it's true God must have spent... A little more time On you... (A little more time, yes he did baby) | ["Music of Asia", "Music"] | ["boy band", "male singers", "vocal harmony", "retro pop hits", "singing parts", "medium tempo", "keyboard accompaniment", "steady drumming rhythm", "steady bass line", "tambourine percussions", "love song", "romantic", "passionate", "groovy music", "inspiring", "passionate", "spirited", "soothing", "relaxing", "comforting", "bells percussions"] | 1 | -fxh7jAJR8U | 73 | |
Coro Gospel AGUAVIVA en Albacete 1 | A female vocalist sings this Gospel song. The tempo is medium with groovy bass lines, keyboard accompaniment, electric guitar and acoustic guitar rhythm,tambourine beats and choral harmony. The song is a spirited,emotional,fervent, earnest and devotional Christian Worship Song. | 2010-02-07T02:22:15Z | MakinGospel | Video Oficial producido por MAKINGOSPEL del concierto del Coro Gospel Aguaviva en Albacete el 21-03-09, primera parte. | ["Singing", "Gospel music", "Christian music", "Crowd", "Music", "Choir"] | ["female singer", "medium tempo", "electric guitar", "groovy bass", "keyboard accompaniment", "choral backup", "christian music", "christian song", "hymns", "christian gospel song", "devotional", "praise and worship", "fervent", "earnest", "passionate", "emotional", "acoustic guitar"] | 7 | 0oIFGARD9xE | 210 | |
Rif Music 2018 | A female singer sings this sultry vocals. The song is medium tempo with traditional Arabic percussions playing steadily, tambourine percussion, keyboard accompaniment and a strong bass-line. The song is romantic and passionate. The audio quality is poor. | 2010-04-16T23:11:47Z | Moha Dulce Rifeño | www.Rifmelody.com | ["Folk music", "Music"] | ["female singer", "arabic music", "medium tempo", "poor audio quality", "groovy music", "arabic dance music sultry vocals", "tambourine percussion", "keyboard accompaniment", "steady drumming rhythm", "dholak percussions", "arabic percussion", "passionate", "romantic", "love songs", "dance tunes"] | 1 | 7dmT4SgS_EM | 869 | |
'Kiss a Girl Sessions' Video Keith Urban AOL Music | A male country singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a strong drumming rhythm, guitar accompaniment, guitar lead, percussive bass line and percussion hits. The song is passionate and romantic. The song has bad audio quality. | 2009-04-16T00:03:13Z | Nick Czapiewski | http://nickwinch.blogspot.com/ Keith Urban singing Kiss a Girl on AOL music. Make sure you pick up "Defying Gravity" in stores and online now!! ***NO INFRINGEMENT INTENDED*** just spreading the good news of Keith Urban | ["Music", "Happy music", "Exciting music"] | ["male singer", "country singer", "backup singers", "vocal harmony", "crooning vocals", "medium tempo", "guitar leads", "guitar strumming", "percussive bass line", "keyboard accompaniment", "energetic", "passionate", "love song", "romantic", "country guitar band", "modern country love songs", "country super hits", "madly in love", "bad audio quality"] | 1 | 9uToez74x_M | 1048 | |
music wydad 2010 | A male singer leads backup singers in a vocal harmony. The song is medium tempo with a heavy percussive drum rhythm, strong bass line, keyboard accompaniment and a trumpet playing in unison with the vocals. The song is groovy and passionate and sounds like the theme song of a football club. The song audio quality is very poor. | 2010-10-01T18:21:22Z | zouhir564 | music wydad 2010 | ["Jazz", "Music", "Middle Eastern music"] | ["male singers", "vocal harmony", "trumpet playing in unison", "percussive bass line", "heavy bass drum rhythm", "brass band", "football match theme", "bad audio quality", "hissing tones", "spirited", "emotional", "medium tempo", "passionate", "fans", "steady drumming rhythm", "keyboard accompaniment"] | 1 | A3vsvL-Yx0Q | 1063 | |
Aye Hip Hopper - ishQ Bector ft Sunidhi Chauhan | Amruta Khanvilkar [OFFICIAL VIDEO] | A female singer sings this passionate melody. The song is a medium tempo with a groovy bass line , steady drumming, keyboard accompaniment, Indian percussion and tambourine accompaniment. The song is playful and romantic. The song is a modern Bollywood pop song with average quality audio. | 2009-12-26T23:05:57Z | ishQ Bector | Starring: IshQ Bector & Amruta Khanvilkar Produced by Sykz Total Fitness Directed by: WildKumar Music: Hanif Shaikh + Chirantan Bhatt Song Produced by IshQ Bector, Chirantan Bhatt & Hanif Shaikh Lyrics: IshQ Bector, Nitin Gupta, Amitabh Bhattachariya, Chirantan Bhatt, & Hanif Shaikh Recorded at the House of IshQ "Aye Hip-Hopper"(Album- Dakku Daddy), is an epic love story between a star Hip-Hopper and his bai (maid)! Will this hot bai be able to sweep IshQ off his feet? ---------------------------------------- ---- Naashta tayaar hai sir. Aur kuch chahiye? Bolo to mein? Yeah. Just gimme some Hip-Hop! Aye Hip-Hopper mujhe pyar to kar Aye Hip-Hopper Mere pyar ke dariya mein, mere laoo (love) ke dariya mein Ek dubki lo na sir! Aye Hip-Hopper! Kya tu bak rahi hai? Aise tak rahi hai Khopdi pak rahi hai Ruk Ruk Ruk Ruk Bakshish bhi diya aur, Bonus bhi diya aur, Chahiye tujko kya? Chal! Phut. Phut. Phut. Phut. Tere ghar me bartan shartan maanjti hun mein barabar. Tu kabhie tho mere dil ke ghar mein pocha kar de aa kar. God she thinks she's hot like Rekha, Maybe but she's not my flavour. Loving her is too much labour. Labour. L-Labour. How can I? I'm a star Hip-Hopper. She's my bai just a part time naukar. Aye aye bhai gotta be high to rock her. Rock her. Rock her. Just gimme some Hip-Hop! Aye Hip-Hopper mujhe pyar to kar Aye Hip-Hopper Mere pyar ke rickshaw ko, mere love ke rickshaw ko. Ek dhakaa do na sir! Aye Hip-Hopper! Ish! Sir.. lo na.. phone.. Meri girlfriend aa rahi hai. Tu kab jah rahi hai? Kyun sataa rahi hai? Ruk Ruk Ruk Ruk Us ko pata joh. Chale to hoga voh. Socha na hoga joh. Phut. Phut. Phut. Phut. Tujko har din khana-vana main khilaati hun pakaa kar. Aaj mere dil ke tave pe, rotiyan tu sekle aa kar. There's no bai I know quite like her. If my girl finds out she'll strike her. But she's the bomb! Dam I wanna light her. Light her. L- Light her. Lock the door bend down lets do it. Mop the floor turn around lets do it. All the bais cook it up get to it. To it. To it. Just gimme some … | ["Singing", "Music", "Telephone bell ringing", "Hip hop music"] | ["telephone ringing", "hindi pop music", "medium tempo", "indian percussions", "tambourine percussions", "female singers", "romantic", "love song", "hindi pop song", "guitar rhythm", "strong bass line", "energetic", "passionate", "bollywood dance music", "average audio quality", "keyboard accompaniment"] | 1 | DCFrCX4HPO8 | 1452 | |
SALSA CLASICA ROMANTICA MIX RONNY MUSIC | A male singer sings this Latin melody. The song is medium tempo with a groovy Latin percussive rhythm, keyboard accompaniment, brass band harmony and a groovy bass line. The song is romantic and emotional. The song is a salsa dance hit, but has poor audio quality issues.. | 2011-09-30T01:08:54Z | ronnymusic01 | BY DJ RONNY MUSIC | ["Music", "Middle Eastern music", "Salsa music"] | ["salsa", "latin folk music", "male singer", "spirited singing", "emotional", "couples dancing", "passionate song", "mysterious", "latin percussions", "trumpets playing", "medium tempo", "various percussion hits", "keyboard harmony", "romantic", "love songs", "latin romantic hits", "keyboard accompaniment", "poor audio quality", "passionate", "groovy bass line"] | 1 | DKflAAykh6A | 1464 | |
STEPHEN CURRY I SOULJA BOY I OFFICAL MUSIC VIDEO HD 2015 🎵 | A male vocalist sings this HIp-hop. The tempo is medium with subdued keyboard accompaniment, slick drumming, boomy bass drops, synthesised arrangements and vocal backup. The song is youthful; enthusiastic, passionate, insistent, repetitive, groovy,rhythmic chanting with a dance groove. This song is Contemporary Hip-Hop/Rap. | 2016-01-25T22:24:17Z | Mike P | (No copyright infringement is intended) All rights belong to the NBA & ESPN. Entertainment. Music: Soulja Boy - Stephen Curry This for my boy Steph Curry We did it Yeah [Hook] I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish, swish Stephen Curry, Stephen Curry, Steph Curry Stephen Curry, Steph Curry, swish Steph Curry I'm stuntin' on 'em like I'm Stephen Curry [Verse 1] Steph Curry Number 30 I was stuntin' on 'em, they wouldn't believe me Shootin' 3's from half court, make it look easy I'm the best point guard in the league NBA All day I cross Lebron, shot a 3 in his face Steph Curry, I be Curry with the shot boy I be Chef Curry with pot boy [Hook] I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish, swish Stephen Curry, Stephen Curry, Steph Curry Stephen Curry, Steph Curry, swish Steph Curry I'm stuntin' on 'em like I'm Stephen Curry [Verse 2] I know that they hate Cause this dope nation Ghost, they want me (?) we made it All we had to do was be some patience So we been patient And I done haters Steph Curry pullin' up with a new drop Steph Curry, make a half court jump shot Hop up out the 'Rari with a lot of guap I'm team Curry (?) [Hook] I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry I'm feelin' like Stephen Curry, swish, swish Stephen Curry, Stephen Curry, Steph Curry Stephen Curry, Steph Curry, swish Steph Curry I'm stuntin' on 'em like I'm Stephen Curry [Outro] Aye, aye, aye, swish Aye, aye, aye, aye Aye, aye, aye, aye Congratulations my boys Keep doin' your thing boo Know I'm a big fan, nigga Congratulations my boys Forreal Copyright Disclaimer Unde… | ["Music", "Zing", "Hip hop music"] | ["male vocalist", "medium tempo", "rap", "raper", "vocal riff", "reverb", "syncopated background harmony", "hip-hop", "pop rap", "rhythmic patter", "boomy bass lines", "slick drumming", "drum machine", "digital drums", "rhythmic", "chanting", "repetitive", "passionate", "insistent", "keyboard accompaniment", "synthesiser arrangements", "electronic music", "groovy", "dance music", "trap", "trippy", "youthful", "female vocal backup"] | 7 | GwTXkfuc5v8 | 1764 | |
"White Christmas" on the Theremin | The song is an instrumental. The tempo is medium with theremin playing passionately, steady drumming rhythm ,groovy bass line and keyboard accompaniment . The tunes are Christmas carols with poor audio quality. | 2007-12-14T14:56:17Z | Pekkanini55 | Thereminist Pekkanini plays his own version of the Bing Crosby-hit "White Christmas". | ["Music", "Theremin"] | ["theremin", "christmas carols", "medium tempo", "carols", "christmas time", "santa claus", "poor audio quality", "reggae music influence", "steady drumming rhythm", "strong bass line", "emotional", "passionate", "exciting", "cheerful", "melancholic", "keyboard accompaniment", "theremin player", "instrumental music", "steady drumming rhythm", "strong bas slime", "live audience", "live performance", "guitar rhythm"] | 1 | OwUzGq0ceT8 | 2483 | |
Frank Heinen auf der Wersi-Orgel in Konzert! | The song is an instrumental. The tempo is medium with a groovy bass line, keyboard accompaniment, percussive bass line , steady drumming drumming and other percussion hits. The song is a pop song cover with a bad audio quality. | 2009-08-26T20:34:40Z | derjaschka | Ausschnitte von diversen Veranstaltungen 2009! https://www.facebook.com/frankheinenwersi | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["church organ playing", "instrumental music", "passionate", "emotional", "romantic", "love song", "greatest love sings", "song cover", "live performance", "ambient noises", "bad audio quality", "medium tempo", "ethereal harmony", "bell tones", "keyboard accompaniment", "groovy bass line", "pop super hits", "retro pop hits", "romantic", "eternal love", "together forever", "never give up"] | 1 | Pgpd1yxLcLI | 2558 | |
Lissie - Bad Romance (Lady Gaga live cover) | A female vocalist sings this passionate Rock song. The tempo is medium with infectious electric guitars on lead and harmony, tambourine beats , steady drumming and keyboard accompaniment. The song is intense, passionate, empathic, powerful, persuasive and compelling. This song is Soft Rock. | 2010-09-10T10:21:50Z | LissieVEVO | Music video by Lissie performing Bad Romance. (C) 2010 Fat Possum Records in US; (C) 2010 Sony Music Entertainment UK Limited in remaining countries | ["Singing", "Music", "Grunge"] | ["female vocalist", "medium tempo", "cover song", "passionate", "emphatic", "powerful", "persuasive", "compelling", "tambourine beats", "lively electric guitar", "electric guitar lead", "acoustic guitar harmony", "keyboard accompaniment", "emphatic vocals", "powerful vocals", "steady drumming", "rock", "hard rock", "pop rock"] | 7 | W2EJai-3k2w | 3055 | |
Kelly Family - Santa Maria video in English | A female child singer sings this soaring melody. The song is medium tempo with a steady drum rhythm, groovy bass line, piano accompaniment and keyboard harmony. The song is lilting and inspiring. The song is a pop song with poor audio quality. | 2007-03-05T01:42:33Z | Al Girard | Kelly Family - terrific talents | ["Christian music", "Music"] | ["female child singer", "poor audio quality", "passionate", "keyboard accompaniment", "guitar rhythm", "soaring vocals", "pop hits", "medium tempo", "angelic", "motivational", "spirited", "keybiard accompaniment", "steady drumming rhythm", "strong bass line", "child prodigy", "new age"] | 1 | cs-zcTX2tRA | 3750 | |
Heaven - Nu Flavor(lyrics) | This song is a romantic duet.the tempo is medium with a soft keyboard harmony, steady drumming, violin harmony, chimes, Cajun beat, bongos rhythm, steady bass line and acoustic guitar .the song is a proposal song.it is romantic, emotional, passionate, soft, ambient, mellifluous and dulcet. This song is a Soft Pop song. | 2010-07-29T07:11:49Z | Escanor | Heaven, heaven oh heaven can't you help me? I looked in her eyes, now she's all I see... Heaven oh heaven can't you help me? First time i saw you girl, You turn me upside down I can't stop thinking bout you My head is spinning round I got to find away to get with you somehow Girl i'm so crazy for you You know i want you now And everyminute of every single day I'm dreaming of how it could be And everynight before i go to sleep I'm praying that soon you'll be here with me Chorus Heaven, heaven oh heaven can't you help I looked in her eyes now she's all i see Heaven oh heaven can't you help me I'm down on my knees please help me Cant fall alseep tonight I don't know what to do I hold my pillow but i wanna be holding you And when close my eyes i always see your face I know my happiness is only kiss away And every hour here in the dark Everyday of my lonely heart Tells me that i need to be with you Heaven oh heaven what can i do Chorus Heaven, heaven oh heaven can't you help me I'm giving my love for eternity Heaven oh heaven can't you help me I'm down on my knees help me Instrumental Girl i'd give anything if you were here with me Give anything you want and anything you need I never thought that i could feel the way i do But now i wanna spend the rest of my with you And every day that we are apart I'm saving this love here in my heart And every night before i go to sleep I'm praying that soon you'll be here with me Chorus Heaven, heaven oh heaven cant you help me I looked in her eyes now shes all i see Heaven oh heaven cant you help me I'm down on my knees please, heaven Heaven....(repeat until fade) Heaven by Nu Flavor Copyright not intended | ["Music", "Happy music"] | ["duet", "medium tempo", "acoustic guitar", "pleasant", "simple bass lines violin hamony", "soft piano accompaniment", "soft vocals", "vocalisation", "cajun beat", "dulcet", "steady drumming", "bongos", "keyboard accompaniment", "violins", "chimes", "cajun", "pepeasant", "love song", "romantic", "passionate", "sentimental", "proposal song", "melodious", "falling in love", "love song", "proposal song"] | 7 | e2tZmQI8ICw | 3838 | |
Az Baraye Ghame Man-Ahmad Zahir.wmv | The song is an instrumental. The song is medium tempo and has a delightful flute solo with keyboard accompaniment groovy bass line and a groovy drumming rhythm. The song has a poor recording quality. The song's middle eastern folk music vibes. | 2011-01-25T19:32:28Z | afgking16 | Ahmad Zahir Az Baraye Ghame Man | ["Music", "Rattle (instrument)"] | ["poor audio quality", "flute solo", "arabian music influences", "medium tempo", "folk music", "instrumental music", "steady drumming rhythm", "folk music", "strong bass line", "drum rolls", "retro songs", "entertaining", "emotional", "romantic", "passionate", "keyboard accompaniment"] | 1 | eHeUipPZHIc | 3853 | |
Missing from YouTube | A male singer sings this rock melody. The tempo is medium with a groovy bass line, guitar rhythm , keyboard accompaniment, and heavy rock drumming with cymbals crashing. The song is energetic and passionate. The song is a retro pop-rock song. | ["Music", "Independent music"] | ["male singer", "classic rock band", "cymbals crashing", "rock band", "emotional", "steady drumming rhythm", "medium tempo", "guitar rhythm", "keyboard accompaniment", "romantic", "emotional", "love song", "energetic", "youthful", "passionate", "retro pop hits", "percussive bass line"] | 1 | 4437 | |||||
'For Little Jimmy' (Official Music Video) - Ron Killings aka WWE Superstar "R-Truth" | A male singer with a rough voice sings this hip hop dance song. The song is medium tempo with a distorted electric guitar playing rhythm, keyboard accompaniment, slick drumming rhythm, telephone ring tones and various percussion hits. The song ends with a fade . The song has poor audio quality. | 2013-02-10T14:09:09Z | RonKillingsTV | 'For Little Jimmy' official music video from Ron Killings aka WWE Superstar "R-Truth" #RTruth #WWE #ForLittleJimmy #RonKillings #LittleJimmy Subscribe to RonKillingsTV: https://www.youtube.com/channel/UCkK8dn3G5IxAigWgRbdJmyw Website: https://www.theofficialronkillings.com Merchandise: https://www.ronkillings.com Facebook: https://www.facebook.com/ronkillings Twitter: https://www.twitter.com/ronkillings Tik Tok: https://www.tiktok.com/ronkillings1 Youtube: https://www.youtube.com/ronkillingstv IG: https://www.instagram.com/ronkillings1 Booking info: ronkillingsbooking1@gmail.com https://www.textrke.com (fan text line) (310) 406-7100 Director IG handle(s): @shotbyreginald | ["Music", "Telephone bell ringing", "Inside, small room", "Inside, large room or hall"] | ["male singer", "rapping vocals", "hip hop music", "telephone ringing", "slick drumming rhythm", "song stops playing", "keyboard beep tones", "keyboard accompaniment", "story telling", "enthusiastic", "medium tempo", "rough male vocals", "energetic", "passionate", "poor audio quality", "groovy music", "electric rhythm guitar plays", "song fade"] | 1 | sgJT5lIFttM | 4970 | |
More Bounce To The ounce Rendition | A male singer sings this vocals with a vocoder. The song is medium tempo with a groovy techno drumming rhythm and keyboard accompaniment. The song is passionate but an amateurish production. The audio quality is very poor. | 2007-11-24T00:35:38Z | TalkBoxerDX | Me playing the talkbox first run! This is shout out to all my talk boxers out there! and to TRCP my dads band! also wanna give a special shout out to curbswirvin if it wasn't for him i wouldn't be doing it! | ["Singing", "Music", "Harmonic"] | ["vocoder", "male singers love performance", "poor audio quality", "jam session", "amateur jazz musician", "medium tempo", "amateur musician", "jazz musician", "keyboard accompaniment", "groovy music", "techno drumming rhythm", "poor audio quality", "people talking", "unimpressive", "excited", "energetic", "passionate", "ambient room noises"] | 1 | xL7Krm6FSWE | 5320 |
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;