musiccaps_details (view)
15 rows where musiccaps_aspects contains "persuasive"
This data as json, CSV (advanced)
musiccaps_aspects (array) 176 ✖
- persuasive · 15 ✖
- passionate 11
- hip-hop 9
- youthful 9
- male vocalist 8
- rap 8
- rhythmic patter 8
- emotional 6
- medium tempo 6
- emphatic 5
- engaging 5
- intense 5
- male singer 5
- synthesiser arrangements 5
- vocal backup 5
- compelling 4
- disco rap 4
- enthusiastic 4
- fast tempo 4
- rhythmic speech 4
- slow tempo 4
- digital drum 3
- dj mixer 3
- drum machine 3
- energetic 3
- hip-hop hits 3
- steady drumming 3
- story telling 3
- street vernacular 3
- club music 2
- dance groove 2
- dj 2
- edm 2
- female vocalist 2
- impactful 2
- keyboard harmony 2
- melodic 2
- pop rap 2
- profanity 2
- punk rap 2
- sentimental 2
- slangy lyrics 2
- soft 2
- soothing 2
- synthesiser articulation 2
- acapella 1
- acoustic guitar harmony 1
- aggressive singing 1
- airway vibrations 1
- ambient 1
- amplified guitar 1
- amplified organ 1
- amplified piano 1
- animated piano harmony 1
- anthem 1
- baritone 1
- bass 1
- buoyant 1
- burgeoning music 1
- cajun beat 1
- calming 1
- captivating 1
- catchy 1
- chanting 1
- chimes 1
- church organ 1
- complex chords 1
- contemporary pop 1
- cover song 1
- cymbals 1
- dance music 1
- dance pop 1
- dance rap 1
- devotee 1
- devotional song 1
- digital beats 1
- digital drum rhythm 1
- digital drumming 1
- digital drums 1
- digital music 1
- drum machines 1
- edm trap 1
- electric guitar lead 1
- electro hop 1
- electro house 1
- electronic arrangements 1
- electronic instruments 1
- electronic music 1
- electronica 1
- eloquent vocals 1
- emotional punchy bass line 1
- emphatic vocals 1
- female vocal backup 1
- foreign language 1
- freestyle rap 1
- funk 1
- funk rap 1
- funky 1
- funky bass lines 1
- funky drumming 1
- funky snare drumming 1
- gangsta rap 1
- groovy 1
- groovy bass 1
- groovy bass line 1
- groovy bass lines 1
- hard rock 1
- harmonium accompaniment 1
- heavy bass 1
- hindi bhajan 1
- hindi devotion 1
- hindu bhajan 1
- hypnotic 1
- incessant 1
- indian classical 1
- indian music 1
- insightful 1
- insistent 1
- insistetnyouthful 1
- inspirational 1
- intense drumming 1
- intense organ music 1
- jazz style piano 1
- keyboard accompaniment 1
- lilting melody 1
- live singing 1
- lively electric guitar 1
- loud 1
- love song 1
- medium fast tempo 1
- mellow 1
- melodious vocal backup 1
- melody keyboard 1
- minimalist 1
- no instrumentation 1
- objectionable lyrics 1
- party music 1
- passioante 1
- passionate emotional 1
- pop 1
- pop rock 1
- powerful 1
- powerful vocals 1
- progressive 1
- psychedelic 1
- punchy 1
- punchy bass 1
- punchy bass lines 1
- r&b 1
- rap hits 1
- rapper 1
- rave music 1
- recurring beat 1
- reggae 1
- rhythmic beat 1
- rhythmic chanting 1
- rock 1
- romantic 1
- sad vibe 1
- slang 1
- slick drumming 1
- slick vocal drum beats 1
- soul 1
- sound of picture being clicked 1
- street rapper 1
- syncopated piano accompaniment 1
- synth pop 1
- tabla rhythm 1
- tambourine beats 1
- trap 1
- turn table 1
- vigorous drumming 1
- vigorous vocals 1
- vocal chant 1
- vocal percussion 1
- vocal riff 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Narcy featuring Shadia Mansour "Hamdulillah" Official Music Video | A male vocalist sings this Rap. The tempo is slow with enthusiastic drumming, syncopated piano harmony, digital beats ,keyboard arrangements with vocal backup and a catchy vocal riff. The rap is catchy, youthful, insightful, enthusiastic, intense, passionate, emotional and persuasive. This song is contemporary Rap/Hip-Hop. | 2010-09-14T17:43:13Z | IRAQ-A-FELLA | Available on iTunes, Shazam, Rdio, Anghami and AmazonMP3 Follow The Narcicyst Facebook: https://www.facebook.com/Narcicyst Twitter: http://www.twitter.com/TheNarcicyst Insta: http://www.instagram.com/narcynarce http://www.thenarcicyst.com The Narcicyst featuring Shadia Mansour - "Hamdulillah" (Official Music Video) Directed and Edited by Ridwan Adhami Written by Yassin Alsalman and Shadia Mansour Original Track produced by SandhiLL Piano by Stefan Christoff Additional production and arrangement by Doctor Dinar and The Narcicyst To say 'Hamdulillah' is to be grateful for what one has. The images of the past decades have cast a veil on our identity as a people. We, as international brothers and sisters, are now witness to injustice in real time. We watch our Wars in HD. It is time for us to claim our faces back. This video is a global collaborative effort by 10 photographers- from London to Lebanon, Cairo To Canada, Abu Dhabi to America- to create a portrait of the New Global Citizens. They are DJs, MCs, poets, architects, teachers, doctors, parents and children. Most of all they are people. Thank you to everyone that was involved. We are blessed to have each other. LYRICS Bismillah, like the feeling when I miss Falah, then wish to God in clouds to lift us all Hamdulilah, wonder if Bibi can ever see me, and if I back to Basrah will it ever receive me, Bismillah, homies that have the time to talk, Now I wish to stars that angel find Nawaf. Hamdulillah, I stand awed at the strength of my sister Kiss her and thank God our mission is planned for us. Bismillah, mamati inti hayati, moms the best one, hold her close to heart like my left lung Hamdulillah, for the truth in a being as beaming the moon queen you blessed my future to be with Bismillah, for the souls anguish, love, and the moment my brothers programmed these drums, Hamdulillah, We put the truth to the test, proof that we're blessed students of this music at best. Bismillah, Before I spit this bar, way Before Militants tried to split t… | ["Music", "Pop music", "Middle Eastern music"] | ["male vocalist", "slow tempo", "hip-hop", "rap", "progressive", "vocal backup", "youthful", "funky snare drumming", "digital beats", "syncopated piano accompaniment", "groovy bass line", "synthesiser arrangements", "persuasive", "story telling", "rhythmic patter", "rhythmic speech", "intense", "passionate", "emotional", "intense", "vocal riff"] | 7 | 0ISHZQJdeSw | 142 | |
Lately (Official Music Video) | A male vocalist sings this mellow rap. The tempo is medium with a groovy bass line, keyboard harmony , slick drumming and vocal backup. The song is youthful, story telling, passionate, impactful, compelling and engaging. This song is contemporary Hip-Hop/Rap. | 2016-04-16T18:42:59Z | Official Lobo | Song: Lately Artist: Lobo Directed/Produced/Edited by: Lobo Shot by: CHRIS Kai Bordenave Lobo | ["Music", "Tender music"] | ["male singer", "slow tempo", "funky bass lines", "intense drumming", "synthesiser arrangements", "vocal backup", "hip-hop", "rap", "pop rap", "hip-hop hits", "disco rap", "rhythmic speech", "story telling", "passionate", "emotional", "persuasive", "compelling", "engaging", "persuasive", "youthful"] | 7 | 0Ubu4BqSWmU | 174 | |
SRPSKE RASE PASA-Serbian Dog Breeds | A male vocalist sings this intense melody in a foreign language.The tempo is slow with a keyboard and organ accompaniment that is burgeoning as the song progresses. The vocals are eloquent, emphatic, persuasive and lilting and the vibe of the song is mellow, persuasive, passionate, emotional and appealing. | 2014-06-08T08:25:31Z | Miroslav Visnjic | http://www.srpskipas.com/ | ["Mantra", "Music"] | ["male singer", "slow tempo", "foreign language", "passionate", "burgeoning music", "eloquent vocals", "emphatic", "persuasive", "sad vibe", "keyboard harmony", "church organ", "minimalist", "lilting melody", "soft", "mellow", "emotional", "passioante", "intense"] | 7 | 2dyxjGTXSpA | 393 | |
2014 Corolla: AZIATIX - "Baby Let's Go" [OFFICIAL MUSIC VIDEO] | Toyota | A male vocalist sings this enthusiastic Electro Hop. The tempo is fast with synthesiser articulation, Dj mixer and digital drum beats. The song has emphatic, insistent vocals, punchy, youthful, buoyant, funky,strong,psychedelic, persuasive, groovy and untiring. This song is a contemporary Electronic HIp-Hop. | 2013-10-25T05:43:31Z | Toyota USA | AZIATIX partners with Toyota on a brand new single for the all-new 2014 Corolla. It's the highly anticipated track where you're going to get a workout. So baby, let's go! Learn more about the Toyota Corolla or download the free "Baby Let's Go" MP3 at http://www.toyota.com/corollaready (LYRICS) [INTRO NICKY AND EDDIE] Baby let's go-oh-oh Go-oh-oh Don't be afraid to live your life So baby let's go-oh-oh Go-oh-oh Go make your dreams come alive So baby let's go [RAP VERSE FLOWSIK] Follow the leader? I rather follow my heart I look in the mirror see myself yeah look at that star I'm so ready for the bright future Destiny I'm headed right to ya Gather my strength I loads it up them I blows it up like booyah booyah Hand me the mic and I'll never let go, hit the jackpot then it's time to get more In a moment presto, it'll be upward so baby let's go... [VERSE NICKY] Baby let's go-oh-oh Go-oh-oh Don't be afraid to live your life [VERSE EDDIE] So baby let's go-oh-oh Go-oh-oh Go make your dreams come alive [VERSE AZIATIX] Let's Go, go, go, go [CHORUS NICKY AND EDDIE] So baby let's go-oh-oh Go-oh-oh Don't be afraid to live your life So baby let's go-oh-oh Go-oh-oh Go make your dreams come alive So baby let's go [RAP VERSE FLOWSIK] Yeah It's me myself and I, spread my wings I'm feeling so fly I'm ringing on heaven's bell up in the sky, I live for the best 'cuz dreams will never die Turn that key lets get it started // you know I'm gon' ride hard 'til I'm on it From daytime to early morning, I'm going all in, no one can call it I must hang tight whenever destiny calls must get back up whenever I fall Hear me loud let it echo go with the flow, out the door so let's go [CHORUS REPEAT] [VERSE EDDIE] Wherever you go just follow your heart Wherever you go just follow your heart [SYNTH] Let's get it started, started Baby let's go Baby let's go, go Baby let's go Ba-baby let's go places, places [CHORUS NICKY AND EDDIE] So baby let's go-oh-oh Go-oh-oh Don't be afraid to live your life So baby let's go-oh-oh Go-oh-oh Go… | ["Blues", "Music", "Pop music"] | ["male vocalist", "fast tempo", "rap", "hip-hop", "edm", "funky", "drum machines", "electronica", "trap", "dance music", "club music", "electro hop", "heavy bass", "electro house", "edm trap", "rave music", "psychedelic", "hypnotic", "dj mixer", "electronic arrangements", "digital drums", "synthesiser articulation", "rhythmic patter", "vigorous vocals", "youthful", "incessant", "persuasive", "emphatic", "energetic", "enthusiastic"] | 7 | 7avMUhHOCR8 | 865 | |
New Electro House Mix 2012 Best Disco Dance Music DJ aSSa Part2 | A male vocalist sings this enthusiastic song,the tempo is fast with synthesiser articulation, rhythmic digital drum, cymbals and vocal backup. The music is upbeat, youthful, enthusiastic, compelling, intense and passionate with a catchy beat and riff. This song is an EDM/Synth pop. | 2012-05-11T10:31:07Z | DjMB84 | ►CHECK MY FACEBOOK FunkyDiscoTech | http://goo.gl/WVPyYC Electro House | http://on.fb.me/1qyijd9 ►SOUNDCLOUD ⇒ https://soundcloud.com/djassa ►TWITTER ⇒https://twitter.com/MrDJaSSa | ["Disco", "House music", "Music", "Dance music"] | ["fast tempo", "male vocalist", "loud", "digital drum", "synth pop", "aggressive singing", "enthusiastic", "energetic", "passionate", "intense", "persuasive", "vocal chant", "synthesiser articulation", "digital music", "edm", "profanity", "drum machine", "dj", "dj mixer", "anthem", "vocal backup", "youthful"] | 7 | AVJ-NxMmF6E | 1124 | |
Street King Energy Track #8 by 50 Cent | 50 Cent Music | A male vocalist sings this spirited rap. The tempo is fast with an animated piano accompaniment, groovy bass lines, intense drumming, cymbal rides and vocal backup. The song is youthful, vibrant, vivacious, animated, compelling ,enthusiastic and passionate . This song is contemporary Hip-Hop/Rap. | 2011-10-01T22:36:47Z | 50 Cent | SUBSCRIBE: http://bit.ly/YeOjEy New track by 50 Cent: Track #8 (Freestyle) Street King Energy Track #8 Order Street King at http://orders.streetking.com/ Previously: * 50 Cent - Street King Energy Track #7: http://www.youtube.com/watch?v=smqxZG2MLy0 * 50 Cent - Love, Hate, Love (Street King Energy Track #6): http://www.youtube.com/watch?v=NYjMKEYgAvI Permalink: http://www.thisis50.com/profiles/blogs/50-cent-street-king-energy-track-8 50 Cent - Street King Energy Track #8 About 50 Cent: Curtis James Jackson III, better known by his stage name 50 Cent, is an American rapper, entrepreneur, investor, and actor. This is his official YouTube Music Channel. Connect with 50 Cent Online: Visit 50 Cent Website: http://bit.ly/WM9S21 Like 50 Cent on Facebook: http://on.fb.me/XxuVyR Follow 50 Cent on Twitter: http://bit.ly/Y4XxPY Follow 50 Cent on Instagram: http://bit.ly/VLeAeX Buy 50 Cent Music Online: iTunes: http://bit.ly/1663kwB Amazon: http://amzn.to/14p4Gic Street King Energy Track #8 by 50 Cent | 50 Cent Music http://www.youtube.com/user/50centmusic | ["Jazz", "Music"] | ["male singer", "fast tempo", "rap", "rapper", "dance groove", "club music", "party music", "funk", "dance pop", "dance rap", "disco rap", "hip-hop", "hip-hop hits", "energetic", "enthusiastic", "rhythmic patter", "passionate emotional", "animated piano harmony", "vigorous drumming", "cymbals", "digital drumming", "punchy bass lines", "vocal backup", "street vernacular", "punk rap", "funk rap", "dance groove", "youthful", "compelling", "persuasive"] | 7 | Brc_nOquNbY | 1297 | |
Ginuwine - Stingy | A male vocalist sings this mellow song.he tempo is medium with jazz style piano accompaniment, synthesiser articulation, slick drumming, funky bass line, cajun beat and an interactive vocal harmony. The music is mellow, soothing, ambient, soulful, passionate, emotional and persuasive. This song is a contemporary R&B/Soul. | 2010-12-30T03:27:51Z | PrezSteej | ["Singing", "Music", "Rhythm and blues"] | ["male singer", "medium tempo", "soft", "romantic", "passionate", "persuasive", "sentimental", "melodious vocal backup", "r&b", "soul", "jazz style piano", "synthesiser arrangements", "pop", "contemporary pop", "ambient", "love song", "passionate", "complex chords", "slick drumming", "groovy bass", "cajun beat", "digital drum", "drum machine"] | 7 | C0AQyOVGvFM | 1316 | ||
ROCAFELLA FREESTYLES: PT.1 "WHO SHOT YA?" | A male vocalist sings this passionate Hip-Hop. The tempo is medium fast with synthesiser articulation, digital drumming and turn table effects with vocal backup. The song is enthusiastic, passionate, persuasive, emphatic, emotional , youthful and groovy. This song is a freestyle Hip-Hop. | 2008-11-03T18:30:55Z | Cipha Sounds | CIPHA SOUNDS HAS DUG INTO THE VAULT TO FIND THIS NEVER BEFORE SEEN VIDEO OF THE ROCAFELLA CAMP FREESTYLING ON FUNKMASTER FLEX SHOW ON HOT97 FROM 2001! | ["Scratching (performance technique)"] | ["male vocalist", "medium fast tempo", "persuasive", "insistent", "turn table", "rap", "hip-hop", "dj", "dj mixer", "youthful", "emphatic", "youthful", "rhythmic speech", "rhythmic patter", "street vernacular", "rhythmic beat", "punchy", "buoyant", "freestyle rap"] | 7 | C5Zs-Lb2rIM | 1328 | |
R.A The Rugged Man - Midnight Thud | A male vocalist sings this passionate Rap. The tempo is medium with steady drumming, keyboard harmony, amplified piano accompaniment, and groovy bass lines . The song is emotional, intense, persuasive, intense and has a catchy groove. This song is contemporary Rap/Hip-Hop. | 2008-09-10T09:04:15Z | Markus Priebe Jakobsson | The song Midnight Thud by the rugged man, with lyrics. | ["Music", "Rapping", "Hip hop music"] | ["male vocalist", "medium tempo", "hip-hop", "rap", "rhythmic patter", "rhythmic speech", "slang", "objectionable lyrics", "passionate", "emotional", "intense", "emphatic", "persuasive", "catchy", "youthful", "steady drumming", "melody keyboard", "amplified piano", "groovy bass lines"] | 7 | CrbZHPkHeV4 | 1407 | |
Hurricane Chris "FREESTYLE" *51/50 RATCHET IN STORES NOW* | A male vocalist sings this passionate rap. The tempo is medium with keyboard harmony, slick drumming, funky bass lines , sound of chimes and synthesiser arrangements. The song is emotional, passionate, emphatic, persuasive, youthful, impactful and rhythmic chanting. The song is a contemporary Hip-Hop/RAo. | 2007-11-01T00:16:48Z | Hurricane Chris | CHECK OUT HURRICANE CHRIS KILL THE "WHITE GIRL" TRACK!!! MAKE SURE YOU POST THIS ON YOUR PAGE AND SEND IT TO FRIENDS!! 51/50 RATCHET IN STORES NOW!! | ["Music", "Rapping", "Hip hop music"] | ["male singer", "medium tempo", "synthesiser arrangements", "rhythmic chanting", "disco rap", "pop rap", "hip-hop", "rap", "punk rap", "gangsta rap", "electronic instruments", "steady drumming", "punchy bass", "intense", "amplified organ", "intense organ music", "sound of picture being clicked", "chimes", "digital drum rhythm", "persuasive", "emotional", "passionate", "story telling", "rhythmic patter"] | 7 | IEVVHo9nr7g | 1883 | |
Hindi Devotional Bhajan: Knock, and the door will open! | A female vocalist sings this Hindi Bhajan. The tempo is slow with a harmonium accompaniment and tabla rhythm. The song is mellow, soft, devotional, inspiring,insightful, emotional and persuasive. This song is a Hindi Devotional Bhajan. | 2008-05-09T20:44:03Z | Gurumaa Ashram | Caught up in the glitz and glamor of the world and the routine and clamor of our daily grind, we have closed our eyes and heart to the beauty around us. The Lord's Grace is everflowing, abundant and loving but are we present fully? In this kirtan, Gurumaaji inspires us to be open, to seek the Lord's mercy and Grace and not to distance ourselves from the eternal shower of blessings awaiting us, once we are ready and willing to receive. For more Hindi bhajans by Anandmurti Gurumaa visit, https://www.youtube.com/playlist?list=PLBFB117E72F43F7E0&feature=view_all Connect with Anandmurti Gurumaa on Facebook at http://www.facebook.com/G.Ashram and on Twitter @GurumaaAshram. | ["Carnatic music", "Mantra", "Music of Asia", "Music"] | ["female vocalist", "slow tempo", "tabla rhythm", "live singing", "melodic", "soothing", "calming", "devotee", "harmonium accompaniment", "indian music", "indian classical", "hindi bhajan", "hindi devotion", "devotional song", "hindu bhajan", "melodic", "engaging", "insightful", "persuasive", "impactful"] | 7 | Jjr0_CbcYdg | 2029 | |
Don't Worry Be Happy - DeMix | A male vocalist sings this energetic Rap. The tempo is fast with the vocalist singing a Hip-Hop song with Acapella . No instrumentation is used apart from the vocal percussive beats. The song is a youthful, enthusiastic,engaging, insistent, passionate , groovy, rhythmic patter with slangy lyrics and a dance groove. This song is contemporary Hip-Hop/Rap. | 2013-01-21T03:26:28Z | DeStorm Power | My vines; http://t.co/LOHY4Q0S2d My Instagram: http://www.instagram.com/destorm My Google+ http://www.gplus.to/DeStorm My Twitter: http://www.twitter.com/destorm My main channel: http://www.youtube.com/destorm My vlog channel: http://www.youtube.com/destormtv My fitness channel: http://www.youtube.com/powerhousestreetteam Don't Worry Be Happy - DeMix Don't Worry Be Happy - DeMix Don't Worry Be Happy - DeMix | ["Music", "Rapping", "Vocal music"] | ["male vocalist", "fast tempo", "hip-hop", "acapella", "slangy lyrics", "dance groove", "persuasive", "profanity", "engaging", "insistetnyouthful", "enthusiastic", "passionate", "baritone", "bass", "no instrumentation", "vocal percussion", "airway vibrations", "rhythmic patter", "slick vocal drum beats"] | 7 | M-RX7LqL50A | 2234 | |
Pete Kolo Feat Chop Chop - "Help Wanted" | A male vocalist sings this spirited rap. The tempo is medium with keyboard accompaniment, digital drums,electric guitar riff and synthesiser arrangements with vocal backup. The song is passionate, compelling, strong telling, chanting, persuasive and youthful. This song is Contemporary Rap-Hip-Hop. | 2012-09-11T19:47:40Z | 2beyond1 | #Theanbm Pete Kolo releases single "Help wanted" ft. Chop Chop #SOB Anbm.inc@gmail.com @Theanbm @PeteGotBeats @ChopChop_SOB Director: @Stedy4dog , 2DCProductions | ["Music", "Rhythm and blues"] | ["male vocalist", "medium tempo", "rap", "rap hits", "digital drum", "youthful", "street rapper", "disco rap", "hip-hop", "hip-hop hits", "rhythmic patter", "electronic music", "drum machine", "synthesiser arrangements", "vocal backup", "passionate", "engaging", "compelling", "persuasive", "street vernacular", "slangy lyrics", "chanting", "recurring beat", "amplified guitar"] | 7 | SxYnb9_qDtk | 2800 | |
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 | |
Bob Marley & The Wailers - One Love / People Get Ready | A male vocalist sings this beautiful Reggae song. The tempo is medium with a keyboard harmony, punchy and infectious bass line and funky drumming with harmonic vocal backup. The song talks about world peace, kindness towards humankind and unity. The song is inspirational, passionate, youthful, emotional,persuasive,impactful, melodic , engaging and captivating. | 2015-05-16T05:31:51Z | doogie Five-Four | Track 12 From Bob Marley & The Wailers - The Very Best of Bob Marley & The Wailers (Limited Edition) (2001) | ["Music", "Reggae"] | ["male vocalist", "medium tempo", "keyboard harmony", "emotional", "youthful", "passionate", "emotional punchy bass line", "funky drumming", "female vocal backup", "reggae", "inspirational", "emotional", "sentimental", "persuasive", "impactful", "soothing", "melodic", "engaging", "captivating", "groovy"] | 7 | opu2tXoVNKU | 4658 |
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;