musiccaps_details (view)
15 rows where musiccaps_aspects contains "pleasant" and musiccaps_aspects contains "steady drumming" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 183 ✖
- pleasant · 15 ✖
- steady drumming · 15 ✖
- medium tempo 9
- instrumental 7
- romantic 7
- sentimental 6
- emotional 5
- groovy 5
- melodic 5
- simple melody 5
- ambient 4
- dulcet 4
- groovy bass lines 4
- keyboard harmony 4
- male singer 4
- soothing 4
- youthful 4
- catchy 3
- engaging 3
- keyboard accompaniment 3
- love song 3
- medium fast tempo 3
- nostalgic 3
- pop 3
- rhythmic acoustic guitar 3
- soft pop 3
- soft rock 3
- synth pop 3
- synthesiser arrangements 3
- tambourine beats 3
- bongos 2
- brass band 2
- chimes 2
- cymbals 2
- electro pop 2
- electronic music 2
- euphonious 2
- groovy bass line 2
- mellifluous 2
- passionate 2
- pop rock 2
- proposal song 2
- punchy 2
- r&b 2
- romantic piano 2
- simple 2
- slow tempo 2
- soul 2
- trumpets 2
- vocal backup 2
- world music 2
- acoustic guitar 1
- acoustic guitar accompaniment 1
- african music 1
- ambient music 1
- amplified flute 1
- amplified ney 1
- atmospheric 1
- atmospheric synthesiser 1
- auto harp 1
- autoharp accompaniment 1
- backup singers 1
- bad audio quality 1
- bluegrass 1
- blues 1
- boy band 1
- breezy fresh 1
- bulgarian 1
- cajun 1
- cajun beat 1
- carrie an music 1
- cheerful 1
- clapping cheering 1
- classic county hits 1
- club music 1
- complex harmony 1
- concert 1
- congas 1
- country classics 1
- country instrument 1
- country music 1
- country song 1
- country song instrumental 1
- dance music 1
- dance pop 1
- drum pads 1
- duet 1
- electric guitar 1
- electric guitar lead 1
- electric guitar melody 1
- electronic instrumentation 1
- electronic machine 1
- emphatic lead 1
- enthusiastic 1
- euro pop 1
- everlasting hits 1
- exciting 1
- falling in love 1
- fast tempo 1
- female singer 1
- female vocalist 1
- fluid 1
- folk music 1
- foreign language 1
- funk rock 1
- funky 1
- groovy bass 1
- groovy rhythm 1
- guitar strumming 1
- hand percussion 1
- hand percussions 1
- happy 1
- harmonious 1
- hissing 1
- inspiring 1
- intense electric guitar 1
- jazz 1
- k-pop 1
- k-pop hips 1
- korean song 1
- lingering 1
- live performance 1
- male vocalist 1
- melancholic 1
- mellow 1
- melodic electric guitar lead 1
- melodious 1
- middle eastern music 1
- minimalist 1
- mood 1
- neo soul 1
- ney 1
- nostalgia 1
- old memories 1
- oud 1
- oud rhythm 1
- pedal steel guitar 1
- pepeasant 1
- perky 1
- pleasant melody 1
- pop folk 1
- pop hits 1
- pop super hits 1
- psychedelic synthesiser 1
- reggae 1
- reggae tones 1
- regional music 1
- retro hits 1
- retro pop 1
- rhythmic 1
- rhythmic acousitc guitar 1
- rock and roll 1
- saxophone harmony 1
- sedate 1
- shakers 1
- simple bass lines violin hamony 1
- simple beat 1
- soft 1
- soft keyboard harmony 1
- soft piano accompaniment 1
- soft soothing 1
- soft vocals 1
- song cover 1
- spirited 1
- stage performance 1
- steady rhythm 1
- steel guitar 1
- story telling 1
- straightforward bass lines 1
- string instruments 1
- subtle bass line 1
- subtle bass lines 1
- syncopated 1
- synthesiser arrangement 1
- the lord’s prayer 1
- uncomplicated harmony 1
- violins 1
- vocalisation 1
- walking bas s line 1
- walking bass line 1
- wedding song 1
- whooshing sound 1
- young love 1
musiccaps_names (array) 20 ✖
- Music 13
- Blues 2
- Reggae 2
- Soul music 2
- Wedding music 2
- /t/dd00004 1
- Christian music 1
- Distortion 1
- Electric guitar 1
- Happy music 1
- Independent music 1
- Music of Africa 1
- Musical instrument 1
- Ping 1
- Pop music 1
- Singing 1
- Ska 1
- Spray 1
- Steel guitar, slide guitar 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Arnel Pineda in AMO, 1988, singing "Lights" by Journey | A male vocalist sings this soft melody. The tempo is slow with a mellow keyboard harmony, steady drumming, subtle bass line and acoustic guitar accompaniment. The song is soft, romantic, melodic, emotional , sentimental, melancholic and pleasant. This song is classic Soft Rock. | 2008-03-22T11:10:43Z | ArnelPinedaFan | Audio only. Arnel Pineda with AMO, performing live "Lights" (originally by Journey) in 1998, almost 20 years before he became Journey's lead singer. Photos from Arnel's "journey" accompany the video. NOTE: Sorry I can't approve non-English comments because I don't understand them. | ["Singing", "Music", "Soul music", "/t/dd00004"] | ["male singer", "medium tempo", "soft keyboard harmony", "steady drumming", "subtle bass line", "rhythmic acoustic guitar", "romantic", "pleasant", "soft pop", "pop", "pop hits", "romantic", "sentimental", "emotional", "nostalgic", "melodic"] | 7 | thHSYzhoLo4 | 5057 | |
Dave and John ....pedal steel and telecaster | This music is an electronic guitar instrumental. The tempo is medium with a harmonious electric guitar lead, steady drumming, subtle bass ,tambourine beats and synthesiser arrangement. The music is a pleasant, soothing, unhurried, calm, romantic, sentimental , sedate and lingering Electric Guitar, soft pop instrumental. | 2011-02-03T01:36:36Z | Bob Adams | David Hartley and John Stannard's duet on Chasing Rainbows.. super stuff as ever! At JD's steel meeting in the south of England Jan 2011 | ["Electric guitar", "Music", "Wedding music", "Distortion"] | ["instrumental", "medium tempo", "electric guitar", "lingering", "sedate", "romantic", "sentimental", "soft pop", "soft rock", "subtle bass lines", "steady drumming", "tambourine beats", "melodic", "pleasant", "soothing", "ambient", "romantic", "synthesiser arrangement", "steady drumming", "cymbals", "simple melody", "euphonious", "engaging", "cheerful", "sentimental", "ambient"] | 7 | bt7rDryN7G4 | 3663 | |
Richard Burton... pedal steel guitar... last date | This music is a Country song instrumental. The tempo is medium with a pedal steel guitar lead harmony with steady drumming and keyboard accompaniment. The music is a simple,minimalist, sweet, dulcet, sentimental, nostalgic, soothing, pleasant and mellifluous , classic Country music instrumental. | 2011-02-03T00:25:39Z | Bob Adams | Richard's rendition of Floyd Cramer's 'Last Date' A sweet sound from that ZB Richard! | ["Blues", "Music", "Steel guitar, slide guitar"] | ["instrumental", "medium tempo", "keyboard accompaniment", "minimalist", "dulcet", "auto harp", "steel guitar", "pedal steel guitar", "steady drumming", "country song", "country song instrumental", "country instrument", "bluegrass", "regional music", "folk music", "pleasant", "nostalgic", "sentimental", "soothing", "mellifluous"] | 7 | qVT6GX1KHUY | 4788 | |
Israel Vibration African Unification | A male vocalist sings the Lord’s Prayer. The tempo is medium with Keyboard harmony, steady drumming, groovy basslines, rhythmic guitar,beat of shakers, vocal backup and a trumpet flourish. The music is simple, rhythmic, pleasant, catchy, soulful and punchy Reggae. There are sounds of people clapping and cheering in the background indicating that this is a live performance. | 2007-02-25T01:52:21Z | David Ruiz | Israel Vibration African Unification | ["Music", "Reggae", "Ska"] | ["male singer", "medium tempo", "reggae", "live performance", "stage performance", "concert", "rhythmic acousitc guitar", "clapping cheering", "vocal backup", "shakers", "pleasant", "punchy", "groovy", "happy", "simple", "pleasant", "reggae tones", "groovy bass lines", "trumpets", "brass band", "shakers", "steady drumming", "keyboard accompaniment", "the lord’s prayer", "carrie an music", "african music", "r&b", "world music", "catchy"] | 7 | blsYgo-B1k8 | 3650 | |
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 | |
ANDREA (SAHARA) ft Kristali - NA EKS - produced by COSTI 2011 | A female vocalist sings this spirited pop. The tempo is medium fast with percussion accompaniment like congas, bongos and drums , tambourine beats,along with amplified flute like the Ney and rhythmic oud. The music is catchy, youthful, groovy, breezy, romantic, pleasant and spirited. This music is contemporary Folk Pop. | 2011-04-27T13:59:10Z | FORZZA MUSIC | Subscribe to my channel: https://bit.ly/ForzzaMusic Subscribe 👉https://bit.ly/2Siqg8P 🔝🎶 NA EKS - produced by COSTI COSTI Grammy Nominated Producer Billboard Hot💯🇺🇸🇷🇴 producer, songwriter, top-liner, compozitor & artist. FORTZAAAA 🔝🎶 Powered by Doctor Music® 2017 Productions & Booking : drstudio@costi.ro International PR Department : office@doctormusic.ro http://www.facebook.com/DrCosti.TheProducer http://twitter.com/CostiOfficial https://instagram.com/costiofficial/ http://www.soundcloud.com/CostiOfficial Costi (The Music Producer) - the first Romanian producer with a Grammy Nomination (Grammy Awards 2012) All rights reserved. Unauthorized reproduction is a violation of applicable laws. | ["Music of Africa", "Music"] | ["female vocalist", "medium fast tempo", "simple melody", "romantic", "breezy fresh", "pleasant", "groovy", "dance music", "dance pop", "club music", "tambourine beats", "catchy", "punchy", "perky", "amplified flute", "ney", "oud", "electronic music", "pop folk", "bulgarian", "middle eastern music", "hand percussion", "congas", "bongos", "steady drumming", "synthesiser arrangements", "amplified ney", "oud rhythm"] | 7 | tJHFSRTPyew | 5026 | |
Ritchie Valens "MEMORIES" ((R.I.P.Tribute)) | This song is an instrumental. The tempo is medium with a melodious lead on the electric guitar, steady drumming, groovy bass lines and acoustic guitar accompaniment. The melody is simple, mellow, pleasant, melancholic, nostalgic and ambient. This instrumental song is a Classic Rock and Roll. | 2008-02-16T02:42:07Z | JESSE OROS | R.I.P.†DOLORES MARTINEZ† 12/26/12 QUERIDA MADRE http://www.ritchievalens.com/ Ritchie Valens "MEMORIES" (SLEEP-WALK) | ["Swing music", "Music"] | ["retro pop", "slow tempo", "instrumental", "acoustic guitar accompaniment", "emphatic lead", "simple melody", "dulcet", "mood", "fluid", "romantic", "ambient", "melodic electric guitar lead", "steady drumming", "groovy bass lines", "acoustic guitar accompaniment", "mellow", "soft", "pleasant", "melancholic", "nostalgic", "rock and roll"] | 7 | xKc_9B3RiOc | 5318 | |
GALAXIE Secado Spray | This music is instrumental. The tempo is medium fast with a melodious keyboard harmony, steady drumming, groovy bass, synthesiser arrangements , electronically articulated sounds and tambourine beats . The melody is harmonious, pleasant, uncomplicated and well layered. This music is Synth Pop. | 2010-01-30T16:53:24Z | José Straatman | Sitio Web: http://www.galaxie.com.ar _ GALAXIE produce con la última tecnología, para todo tipo de industria, equipos de secado llave en mano, para Argentina y el Mundo. GALAXIE fue fundada en el año 1970 y a través de tres generaciones de constante desarrollo empresario llega hasta nuestros días como una empresa líder es Secado Spray con reconocimiento internacional. Originalmente orientada a la pequeña industria, actualmente provee plantas llave en mano en todo el mundo para empresas de primer nivel como: BAYER, HENKEL, LIQUID CARBONIC, PFIZER, SANOFI Bio-Ind., SANDOS, AVEBE, INDUCORN-CPC, HOECHST, QUEST International, QUICKFOOD, Elf ATOCHEM y BASF. _ PRODUCTOS QUE INDUSTRIALIZA / COMERCIALIZA GALAXIE trabaja principalmente fabricando Secadores Spray con materiales y accesorios de primera calidad, pero también ayudando a sus clientes con asesoramiento, reforma, modernización y traslado de equipos existentes, brindando facilidades para el ensayo de productos y secado por terceros, alquiler de equipos, adiestramiento de personal y proveyendo equipos auxiliares de acuerdo a cada necesidad. _ SECADO POR ATOMIZACIÓN (SECADO SPRAY) El secado por atomización es el proceso de pulverizar una solución o suspensión en una corriente de aire caliente que los dehidrata en forma casi instantánea. Lo cual presenta grandes ventajas en relación a otro tipo de secados. _ VENTAJAS QUE OFRECE EL SECADO SPRAY: • Alto rendimiento, pues el proceso es muy rápido (algunos segundos). • La evaporación del agua contenida, refrigera la partícula permitiendo usar altas temperaturas de aire de secado sin afectar las cualidades del producto. • Proceso continuo y constantemente controlado. • Homogeneidad de la producción. • Inmejorable presentación del producto. • Un solo operario maneja la instalación. • Fácil automatización. • Puede trabajar continuo 24 Hs. _ RUBROS ORIENTADOS A LA INDUSTRIA: • Química • Alimenticia • Frigorífica • Farmacéutica • Minera • Petroquímica Más información en : http://www.galaxie.com.… | ["Music", "Reggae"] | ["instrumental", "medium fast tempo", "synth pop", "groovy", "uncomplicated harmony", "pleasant", "harmonious", "euphonious", "rhythmic", "keyboard harmony", "steady drumming", "electronic instrumentation", "synthesiser arrangements", "simple beat", "simple melody", "catchy", "rhythmic", "cymbals", "tambourine beats", "groovy bass"] | 7 | HNf9eHqDT1A | 1796 | |
NapoliTube | Maradona: palleggio con pallone, palla da tennis e pallina da ping pong! | RIP D10S! | This music is instrumental. The tempo is fast with rhythmic acoustic guitar, steady drumming, keyboard harmony, groovy bass line and electric guitar accompaniment. The music is mellow,nostalgic, emotional, simple, pleasant, charming and melodic pop. | 2013-11-19T20:26:34Z | NapoliTube | NAPOLITUBE | La Videoenciclopedia del Napoli: https://www.napolitube.eu SEGUI TUTTA LA STORIA DEL NAPOLI IN VIDEO SU https://www.napolitube.eu LA VIDEOENCICLOPEDIA DEL NAPOLI! | ["Music", "Ping"] | ["instrumental", "fast tempo", "rhythmic acoustic guitar", "pop", "steady drumming", "simple melody", "pleasant", "mellifluous", "inspiring", "emotional", "string instruments", "keyboard harmony", "steady drumming", "groovy bass lines", "electric guitar melody", "pleasant melody", "simple", "steady rhythm", "soothing", "engaging"] | 7 | aYoRcnmz6ZE | 3553 | |
Tedeschi Trucks Band - Midnight in Harlem (Live from Atlanta) | This music is a melodic instrumental. The tempo is medium with a captivating electric guitar lead, rhythmic acoustic guitar, funky bass line, keyboard accompaniment, steady drumming and trumpets. The music is soothing, atmospheric, euphonious, youthful, and soulful. This instrumental is a Soft Rock/Funk pop. | 2011-08-18T07:00:00Z | TedeschiTrucksVEVO | Music video by Tedeschi Trucks Band performing Midnight in Harlem (Live from Atlanta). (C) 2011 Sony Music Entertainment | ["Blues"] | ["instrumental", "medium tempo", "electric guitar lead", "ambient", "steady drumming", "groovy bass line", "trumpets", "melodic", "pleasant", "funky", "groovy", "soft rock", "pop rock", "funk rock", "youthful", "atmospheric", "brass band", "soul", "neo soul", "soothing", "rhythmic acoustic guitar"] | 7 | -wVWjl9Kq6U | 104 | |
2013 Wedding Song (You Are) Derek Rusel | A male vocalist sings this soft love song. The tempo is slow with a romantic piano accompaniment, groovy bass line, steady drumming and ambient saxophone harmony. The song is a romantic, emotional, mellow, sentimental, proposal or wedding song. This song is a R&B/Soul song. | 2011-01-14T10:13:18Z | Vent Music | ["Music", "Wedding music"] | ["male singer", "slow tempo", "romantic piano", "ambient music", "saxophone harmony", "steady drumming", "groovy bass line", "r&b", "soul", "blues", "jazz", "complex harmony", "syncopated", "pleasant", "romantic", "emotional", "sentimental", "love song", "wedding song", "proposal song"] | 7 | 07xGXxIHOL4 | 125 | ||
Aleksander Mežek - Siva pot | A male singer sings this popular country hit with backup singers in vocal harmony. The song is in medium tempo with a walking bass , acoustic guitar strumming rhythmically, autoharp accompaniment and steady drumming rhythm. The song is an emotional and nostalgic country hit. The audio quality is poor. | 2006-12-19T14:33:29Z | jaki386 | Aleksander Mežek - Siva pot | ["Christian music", "Music", "Musical instrument"] | ["male singer", "backup singers", "guitar strumming", "everlasting hits", "euro pop", "medium tempo", "walking bass line", "autoharp accompaniment", "walking bas s line", "steady drumming", "story telling", "nostalgia", "pleasant", "exciting", "enthusiastic", "old memories", "classic county hits", "pop super hits", "retro hits", "groovy rhythm", "country classics", "bad audio quality", "song cover", "country music"] | 1 | 3KQy3Cajo4E | 456 | |
{Hetalia} Hetaoni: Never enter the mansion. | A female vocalist sings this melodic Soft Rock. The tempo is medium with intense electric guitar harmony, keyboard accompaniment, synthesiser arrangements, steady drumming and subtle bass. The vocals are soft and melodic . The song is passionate, emotional, euphonious, simple, fresh and pleasant. This song is contemporary soft rock. | 2011-12-11T14:23:00Z | kaida55 | ♥Hetalia MEP video♥ ♥Watch in HD ♥ ---------------------- 100+ fav in less than a week? Thanks from everyone who made a part in this video. And again people, thank you so much! Thanks for the 600+ fav in less than a half year time :D Thanks for 1500+ fav! -------------------------------- Parts: 0:00 -- 0:20 hetaliafan41 0:20 -- 0:40 EndlessxRequiem 0:40 -- 1:00 sxrlove06 1:00 -- 1:20 001Dragonheart 1:20 -- 1:40 Irosama0410 1:40 -- 2:00 rose103097 2:00 -- 2:20 XxSilverCharmxX2 2:20 -- 2:40 TimefulAngel 2:40 -- 3:00 Goldenstar7z 3:00 -- 3:20 kaida55 3:20 -- 3:40 melancholywish 3:40 -- 3:56 animerockz290 HetaOni images, and the latest uploads: http://hetaoni.tumblr.com/ | ["Independent music"] | ["female singer", "medium tempo", "intense electric guitar", "keyboard harmony", "steady drumming", "keyboard harmony", "synthesiser arrangements", "electronic music", "electro pop", "synth pop", "melodic", "youthful", "passionate", "emotional", "pleasant", "pop rock", "soft rock"] | 7 | EHm7vLZewS0 | 1542 | |
BEAST/B2ST - Clenching A Fist Tight | A male vocalist sings this soft Korean Melody. The tempo is medium with a romantic piano accompaniment, steady drumming, simple bass lines, chimes, synthesiser arrangements and male vocal backup. The song is a soft, mellow, romantic, emotional, sentimental, dulcet, melodic love song. This song is a Korean Soft Pop/K-pop song. | 2010-09-17T04:03:08Z | megcapati | BEAST's 3rd Mini Album MASTERMIND. SUPPORT BEAST BUY BUYING THEIR 3RD MINI ALBUM MASTERMIND! :D :D :D ~~ Another awesome ballad. Perfect song to listen to if you want to cry. ~~ CHECK OUT MY OTHER VIDEOS :D Twitter: http://www.twitter.com/meggiewegsss Tumblr: http://www.meggiewegsss.tumblr.com Facebook: http://www.facebook.com/meggiewegsss B2STLYB2UTIES website coming soon~♥ Twitter: http://www.twitter.com/B2STLYB2UTIES Facebook: http://www.facebook.com/pages/B2stlyb2uties/144520828909598 Every 2 weeks is the birth of a new parody made by EMDEE Parodies ^_^v Twitter: http://www.twitter.com/EMDEEparodies YouTube: http://www.youtube.com/user/EMDEEparodies | ["Music", "Pop music", "Soul music"] | ["male vocalist", "medium tempo", "dulcet", "sentimental", "emotional", "love song", "melodic", "world music", "k-pop hips", "youthful", "young love", "soft soothing", "romantic piano", "steady drumming", "straightforward bass lines", "chimes", "atmospheric synthesiser", "boy band", "vocal backup", "ambient", "pop", "soft pop", "romantic", "pleasant", "emotional", "melodic", "foreign language", "korean song", "k-pop"] | 7 | 0F-Z0zF1504 | 138 | |
How to Spray a Vent With the Preval Sprayer | This music is instrumental. The tempo is medium with a peppy keyboard harmony, groovy bass line, slick drumming and synthesiser arrangements with a hissing or whooshing sound in the background. The song is catchy, groovy, trippy, trance and youthful. | 2014-01-09T18:47:31Z | prevalspraygun | Get step-by-step instructions for a flawless paint finish. Match your vents precisely to your room color with the Preval Spray System. http://www.preval.com | ["Music", "Spray"] | ["instrumental", "medium fast tempo", "groovy bass lines", "psychedelic synthesiser", "steady drumming", "keyboard harmony", "hand percussions", "whooshing sound", "hissing", "pleasant", "groovy", "youthful", "spirited", "engaging", "electro pop", "synth pop", "drum pads", "electronic machine"] | 7 | HyJ2YaNrA3U | 1853 |
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;