musiccaps_details (view)
14 rows where search matches "guitar", musiccaps_aspects contains "live audience" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 198 ✖
- live audience · 14 ✖
- live performance 9
- exciting 7
- passionate 7
- poor audio quality 7
- emotional 5
- instrumental music 5
- energetic 4
- groovy music 4
- guitar accompaniment 4
- medium tempo 4
- spirited 4
- adrenaline rush 3
- bad audio quality 3
- dance rhythm 3
- groovy bass line 3
- male singer 3
- percussive bass line 3
- ambient crowd noises 2
- ambient noises 2
- ambient room noises 2
- crowds cheering 2
- cymbals crashing 2
- enthusiastic 2
- excitement 2
- female singer 2
- guitar band 2
- guitar solo 2
- haunting 2
- live in concert 2
- love song 2
- medium fast tempo 2
- romantic 2
- screaming vocals 2
- acapella singers 1
- acoustic guitar lead 1
- acoustic song 1
- ambient crowd noise 1
- ambient keyboard tones 1
- ambient room noise 1
- arena 1
- audience cheering 1
- average audio quality 1
- bass guitar solo 1
- beach party 1
- beautiful love 1
- black gospel music 1
- blues dance music 1
- blues guitar 1
- blues legends 1
- blues music 1
- blues turnaround 1
- church music 1
- clapping percussions 1
- congressional music 1
- country blues band 1
- country blues hits 1
- country blues music 1
- country music 1
- cowboys 1
- dance club 1
- dance mix 1
- death metal 1
- deteriorated audio 1
- devotional 1
- distorted guitar rhythm 1
- dj 1
- echoes 1
- eerie 1
- electric guitar 1
- electric guitar lead 1
- electric guitar riff 1
- emo 1
- emo teens 1
- endless love 1
- engaging crowds 1
- entertaining 1
- epic stories 1
- excitement in the air 1
- famous guitarist 1
- folk singers 1
- forever together 1
- fret noise 1
- fretboard sounds 1
- funk jazz 1
- fusion music 1
- g]adrenaline rush 1
- gospel hits 1
- gospel music 1
- groove to the music 1
- groovy 1
- groovy drumming rhythm 1
- groovy rhythm 1
- guitar lead 1
- guitar master class 1
- guitar notes playing 1
- guitar pick percussions 1
- guitar playing 1
- guitar playing rhythm 1
- guitar rhythm 1
- guitar strumming 1
- guitarist talks 1
- gunslingers 1
- haunting vocals 1
- heavy metal 1
- heroes and villains 1
- hindustani music 1
- hissing ambient sound 1
- hissing sounds 1
- home video 1
- improvisational 1
- improvisational music 1
- indian classical music 1
- inspiring 1
- jazz funk 1
- keyboard harmony 1
- kiss 1
- latin percussions 1
- latin pop hits 1
- laughing 1
- laughing devilishly 1
- legends 1
- lifetime experience 1
- lilting vocals 1
- live band 1
- live concert 1
- live recording 1
- madly in love 1
- male and female singer 1
- male singers 1
- melancholic music 1
- motivational 1
- no fixed tempo 1
- noisy crowds 1
- people cheering 1
- people clapping 1
- people dancing 1
- performer 1
- poor audio recording 1
- pop diva 1
- pop song 1
- pop super hits 1
- pulsating rhythm 1
- punk rock 1
- pure and innocent 1
- random notes 1
- rebellious 1
- rebellious nature 1
- reggae band 1
- reggae music 1
- retro blues 1
- retro blues hits 1
- retro death metal hits 1
- retro latin hits 1
- retro rock hits 1
- rhythm guitars 1
- rock band 1
- rock drumming rhythm 1
- rock music 1
- rock singer 1
- sad 1
- saxophone solo 1
- scratching tones 1
- singer talking 1
- singing long notes 1
- slow tempo 1
- smooth jazz 1
- soloist 1
- song covers 1
- song introduction 1
- soul music 1
- soul singer 1
- steady drumming 1
- steady drumming rhythm 1
- steady rhythm 1
- steady rock drumming 1
- story tellers 1
- strings scratched with plectrum percussions 1
- strong drumming rhythm 1
- strong walking bass 1
- studio recording 1
- sunday morning 1
- suspense 1
- tabla percussions 1
- teenage age angst 1
- tense 1
- the wild west 1
- theremin 1
- traditional folk song 1
- traditional music 1
- trumpets play percussively 1
- tuning legs 1
- tuning notes 1
- tuning pegs 1
- vocal harmony 1
- yodelling melody 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 26 ✖
- Music 14
- Guitar 4
- Singing 4
- Musical instrument 2
- Plucked string instrument 2
- Rock music 2
- Tapping (guitar technique) 2
- Yell 2
- /t/dd00004 1
- Afrobeat 1
- Angry music 1
- Blues 1
- Chant 1
- Country 1
- Electric guitar 1
- Flamenco 1
- Grunge 1
- Harmonic 1
- Inside, large room or hall 1
- Jazz 1
- Progressive rock 1
- Psychedelic rock 1
- Steel guitar, slide guitar 1
- Strum 1
- Theremin 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tubular Bells (Start of the 2nd part) on Theremin | The song is an instrumental. The song is in slow tempo with a theremin playing a melancholic melody with a guitar accompaniment. The song is emotional and lilting. The audio quality is poor. | 2007-05-29T15:55:35Z | DANI ROTTENBRAIN | Versión thereministica del principio de la segunda parte de tubular bells de Mike Oldfield | ["Music", "Theremin"] | ["theremin", "emotional", "guitar accompaniment", "poor audio quality", "romantic", "love song", "endless love", "forever together", "ambient noises", "youtube music video", "beautiful love", "pure and innocent", "live performance", "live audience", "melancholic music", "instrumental music", "slow tempo", "emotional", "sad"] | 1 | 03frQGyrgQ4 | 114 | |
Los Autenticos Decadentes - Veni Raquel (Vivo Pepsi Music 2010) HD | A male singer sings this exciting Latin dance melody. The tempo is medium fast with a saxophone solo, percussive bass line, guitar accompaniment, latin percussion, steady drumming rhythm, and cymbal crashes. The song is exciting with the crowds going crazy. The audio quality is poor. | 2010-11-03T06:42:47Z | popartdiscosvivo | ARTISTA: LOS AUTENTICOS DECADENTES TEMA: VENI RAQUEL EN VIVO EN EL PEPSI MUSIC 2010 - COSTANERA SUR, BUENOS AIRES, ARGENTINA - 23/10/10 | ["Jazz", "Music"] | ["live audience", "saxophone solo", "bass guitar solo", "arena", "excitement in the air", "latin percussions", "strong drumming rhythm", "guitar accompaniment", "latin pop hits", "retro latin hits", "crowds cheering", "poor audio quality", "live in concert", "exciting", "energetic", "passionate", "adrenaline rush", "medium fast tempo", "male singer"] | 1 | 244y56-vLWE | 328 | |
2014: Willow (Jeff Hardy) 14th & New TNA Theme Song - "Willow's Way" + DL w/Lyrics | A male singer screams and laughs loudly. The song is medium tempo with steady rock drumming, groovy bass line and electric guitar rhythm. The song is energetic and haunting. The song is a modern punk rock song. | 2014-04-25T19:35:34Z | TheGreatWhiteHD | Title: "Willow's Way" Artist: PeroxWhy?Gen Album: Evolution XIV Genre: Rock Released: April, 2014. Download Link: .mp3: http://www.sendspace.com/file/4k1s14 ShopTNA: http://bit.ly/1lbRokM Theme Count: 1st: "Modest" (as Jeff Hardy) 2nd: "Alien Waltz" (Instrumental with "Modest" Intro) (as Jeff Hardy) 3rd: "Alien Waltz" (Instrumental) (as Jeff Hardy) 4th: "Modest" (Intro Cut) (as Jeff Hardy) 5th: "Alien Waltz" (with "Modest" Intro) (as Jeff Hardy) 6th: "Alien Waltz" (as Jeff Hardy) 7th: "Modest" (V2) (as Jeff Hardy) 8th: "Modest" (V3) (as Jeff Hardy) 9th: "Another Me" (as Jeff Hardy) 10th: "Resurrected" (as Jeff Hardy) 11th: "Similar Creatures" (BFG Mix of Themes Intro) (as Jeff Hardy) 12th: "Time & Fate" (BFG Mix of Themes Intro) (as Jeff Hardy) 13th: "Time & Fate" (Intro Cut) (BFG Mix of Themes Intro) (as Jeff Hardy) 14th: "Willow's Way" (as Willow) Lyrics: Pointless to memorize Inklings that writting They calculate who we are Shedding the skin of Bizzare They make their voice and they know Systematically they're low I am leaving away I saw it out in two face Pointless to analyze What we cannot energize Hatred is steering me wrong Because the hope is all gone And the angels fly on by Head down the hope is all gone While the demons hide inside It's down the hope is all gone The devil sets fire to evil souls Worship and pray While God's ambitious plan unfolds In Willow's Way Pointless to even pretend It doesn't matter within' They justify who we are Shedding the weight of bizzare They make their dates and they know Charismatically they're low I wide open seen the soul It's just the way I was born Pointless to even defend What we cannot comprehend Hatred is guiding me wrong Because the faith is all gone And the angels fly on by Head down the faith is all gone While the demons hide inside It's down the faith is all gone The devil sets fire to evil souls Worship and pray While God's ambitious plan unfolds In Willow's Way Worship and pray In Wilow's Way Worship and pray Nothin left to say In Willow's Way And… | ["Music", "Angry music"] | ["screaming vocals", "rock band", "punk rock", "youthful", "emo teens", "eerie", "live audience", "pulsating rhythm", "rebellious nature", "ambient keyboard tones", "keyboard harmony", "laughing devilishly", "emo", "kiss", "haunting vocals", "heavy metal", "medium tempo", "haunting", "passionate", "exciting", "groovy bass line"] | 1 | 2ATMQxWVpXk | 338 | |
The Good, the Bad and the Ugly / Reel Matawa by California Guitar Trio & Montreal Guitar Trio | The song is an instrumental. The song is medium tempo with a guitar playing lead and several guitarists playing harmony and accompaniment and a pick scratching guitar strings producing a percussive line. The song is immersive and has a classic country gun fight duel vibe to it. The song has ambient room noises. | 2009-11-19T18:55:29Z | MG3 : Montréal Guitare Trio / Montreal Guitar Trio | Montreal Guitar Trio & California Guitar Trio performed The Good, the Bad and the Ugly by Ennio Morricone followed by the Reel Matawa by Richard Forest at Palais Montcalm in Quebec City, October 23, 2009. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["guitar band", "guitar solo", "scratching tones", "guitar pick percussions", "song covers", "strings scratched with plectrum percussions", "live performance", "live audience", "ambient room noises", "echoes", "average audio quality", "groovy music", "instrumental music", "country music", "tense", "suspense", "gunslingers", "groovy", "story tellers", "the wild west", "emotional", "passionate", "heroes and villains", "legends", "epic stories", "electric guitar", "rhythm guitars", "cowboys"] | 1 | 3w3fD54bNvU | 521 | |
Adele North American Tour 2008 | A female singer sings this bluesy melody. The song is medium tempo with minimal guitar accompaniment and no other instrumentation. The song's medium tempo is very emotional and passionate. The song is a modern pop hit but with poor audio quality. | 2011-03-17T20:16:50Z | Viswijfable | This shortfilm was on the bonus disc. of 19. Directed by Charlie Robins © | ["Singing", "Music", "/t/dd00004", "Inside, large room or hall"] | ["female singer", "blues music", "live audience", "romantic", "hissing ambient sound", "madly in love", "love song", "passionate", "ambient crowd noise", "guitar playing", "singer talking", "song introduction", "blues turnaround", "fret noise", "pop song", "pop super hits", "pop diva", "poor audio quality", "guitar notes playing", "live performance", "lilting vocals", "soul singer", "soul music"] | 1 | B90BOtSOD2Q | 1210 | |
Hole - Dicknail (live) | A female singer sings this screaming metal melody. The song is medium tempo with a steady metal drumming rhythm, steady bass line and a distorted guitar playing rhythm. The song is rebellious and passionate. The audio quality is very poor. | 2006-11-03T22:44:40Z | distillersdemon | Just a video of Hole performing Dicknail... | ["Singing", "Music", "Rock music", "Yell", "Grunge"] | ["poor audio quality", "death metal", "retro death metal hits", "female singer", "screaming vocals", "haunting", "rebellious", "poor audio quality", "live audience", "live performance", "teenage age angst", "rebellious", "passionate", "emotional", "poor audio quality", "deteriorated audio", "steady drumming rhythm", "distorted guitar rhythm", "percussive bass line", "ambient room noise", "medium tempo"] | 1 | Cwbtn_h6TP8 | 1416 | |
喃語 LIVE @札幌SOUND CRUE 2015/11/03 | The song is an instrumental. The song is medium tempo with a groovy drumming rhythm, percussive bass line and cool electric guitar riff played repeatedly. The song is exciting and energetic. The song has smooth jazz or funk jazz roots. | 2015-11-18T13:14:34Z | YASASHIIKIMOCHI RECORDS | 2015/11/03@札幌SOUND CRUE 忍者ワールド 0:00 https://youtu.be/BTE_WG2fiT8 山の巨大ゴリラ村を荒らす 05:02 https://youtu.be/qPwVkHXKdsI 清らかな生き物 09:10 https://youtu.be/guj0H2Pdvcg 映像撮影・編集 つるりん こんちゃん てるてる 音声編集 北川 昭行 (Hello Micro Computer) 喃語(nango) http://naango.tumblr.com/ Twitter https://twitter.com/naaango Soundcloud http://soundcloud.com/nang0 Facebook https://www.facebook.com/naaaango | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Psychedelic rock", "Progressive rock"] | ["electric guitar lead", "live performance", "live band", "guitar band", "exciting", "instrumental music", "adrenaline rush", "energetic", "electric guitar riff", "live audience", "entertaining", "funk jazz", "groovy drumming rhythm", "percussive bass line", "cymbals crashing", "improvisational music", "jazz funk", "smooth jazz", "groovy music", "medium fast tempo"] | 1 | Nqb7nw58q08 | 2370 | |
Anil Shahi - Maya Mantra (Instrumental) | The song is an instrumental. The song is medium tempo with a percussive tabla rhythm, groovy bass line and a guitar strumming rhythm and playing lead. The song is Indian classical fusion with a poor audio quality. | 2013-02-23T19:05:58Z | NepaliLyricsChords | http://NepaliLyricsChords.com Anil Shahi performing Maya Mantra (Instrumental) in Thamel Square Grand Opening Program Program Name: Thamel Square Grand Opening Location: JP Road, Thamel. Kathmandu Facebook Page (Thamel Square): https://www.facebook.com/ThamelSquare Facebook Page (Nepali Lyrics Chords): http://www.facebook.com/Golomech | ["Country", "Flamenco", "Music"] | ["indian classical music", "hindustani music", "improvisational", "energetic", "exciting", "passionate", "spirited", "live audience", "ambient noises", "dance rhythm", "guitar lead", "poor audio quality", "poor audio quality", "tabla percussions", "groovy rhythm", "guitar strumming", "instrumental music", "percussive bass line", "fusion music"] | 1 | TWm_2QncYXg | 2841 | |
Andy McKee explains fanned frets (Multi-scale Geometry) - Piermont, NY 3/3/09 (7/10) | A guitarist is tuning his guitar making string noises, peg sounds and fretboard noises. The audio is very bad with a boomy low end. The conversation is engaging and keeps the crowds occupied as the guitarist gets ready for the next song. | 2009-04-11T05:55:32Z | Rael0505 | While preparing for Shanghai (as requested by someone in the audience), Andy McKee broke a string and began talking about his tour in Asia while restringing. Towards the end of the video he explains why the frets on his guitar are crooked, a question a lot of people are wondering. Basically, the fanned frets on his new Greenfield guitar are both comfortable ergonomically and provide more accurate intonation. And although he doesn't mention it in this video, fan frets handle dropped tunings much better than regular frets do (and since Andy plays in so many different alternate tunings, fanned frets must be a dream come true). Thicker strings are naturally designed for a wider scale length - I would say all guitars should be built this way, and for a lot of handmade instruments with more than 6 strings, they are mandatory. You can see him play Shanghai in the next video, linked below: http://www.youtube.com/watch?v=uuUeAwnTYzA&fmt=18 | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["guitarist talks", "tuning notes", "tuning pegs", "guitar master class", "guitar solo", "live concert", "live audience", "soloist", "random notes", "laughing", "bad audio quality", "engaging crowds", "performer", "famous guitarist", "tuning legs", "fretboard sounds", "no fixed tempo", "bad audio quality", "ambient crowd noises"] | 1 | cQX-WgT0ACQ | 3705 | |
robzn - Kill the sound boy feat. Karen Firlej | A male singer sings this reggae melody with a live audience. The song is medium tempo with a groovy drum rhythm, trumpet playing rhythmically, guitar playing accompaniment and a groovy bass line. The song is exciting and cheerful. The song is a modern reggae tune and played in both a live audience situation and studio recording quality. | 2015-03-08T15:21:56Z | Das Octagon | Luiggis Finest Kill the sound boy feat. Karen Firlej Karen: https://www.facebook.com/pages/Karen-Firlej/179074595612477 robzn: https://www.facebook.com/robznoffiziellergehtnicht http://robznoffiziell.de/ vrob: https://www.facebook.com/vroboffiziellergehtnicht Luiggis Finest: https://soundcloud.com/luiggisfinest/luiggis-finest-hip-hop-reggaeneration | ["Afrobeat", "Music"] | ["reggae music", "live recording", "reggae band", "exciting", "energetic", "dance rhythm", "spirited", "beach party", "dance club", "dance mix", "excitement", "groove to the music", "people dancing", "studio recording", "dj", "noisy crowds", "people cheering", "guitar playing rhythm", "trumpets play percussively", "steady drumming", "live audience", "live performance", "male singer", "people cheering", "dance rhythm", "groovy bass line"] | 1 | fWypK9RHJJI | 3955 | |
Roy Rogers (slide guitar) - Look Over Yonders Wall | The song is an instrumental. The song is medium tempo, with an acoustic guitar playing blues, strong drumming rhythm, walking bass line and keyboard harmony. The song is exciting and has a dance rhythm. The audio quality is poor. | 2007-11-22T23:21:53Z | Vladimir BluesJammer | Roy Rogers (slide guitar) - performance from his video "Slide Guitar For Rock & Blues" http://www.homespuntapes.com | ["Blues", "Guitar", "Music", "Steel guitar, slide guitar"] | ["acoustic guitar lead", "country blues music", "poor audio quality", "instrumental music", "blues legends", "blues legends", "live performance", "live audience", "live in concert", "country blues band", "retro blues hits", "bad audio quality", "strong walking bass", "blues guitar", "steady rock drumming", "exciting", "enthusiastic", "retro blues", "country blues hits", "emotional", "enthusiastic", "groovy music", "blues dance music"] | 1 | hzznbzry5R8 | 4156 | |
요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel _ 목장주인김원섭 _ 박진아 | A male singer sings with a female backup singer in vocal harmony. The song is medium tempo with a yodelling medley and guitar strumming rhythm and no other instrumentation. The song is exciting and passionate. The song has poor audio quality. | 2010-11-11T11:53:45Z | 목장주인tv | 요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel 2009.5.7. 성남아트센터 김원섭(010-4061-6404)의 '나눔의 열린 음악회'중에서 kmwonseop@hanmail.net | ["Singing", "Chant", "Music", "Vocal music"] | ["male and female singer", "yodelling melody", "poor audio quality", "clapping percussions", "dance rhythm", "spirited", "traditional music", "guitar accompaniment", "acoustic song", "traditional folk song", "folk singers", "live performance", "live audience", "ambient room noises", "hissing sounds", "exciting", "emotional", "medium tempo", "people clapping"] | 1 | m9MQdg0k1t0 | 4448 | |
Los Mejores Gritos de Axl Rose/Best Cries Of Axl Rose [El Mejor Grito De La Historia] | A male rock singer sings this climatic solo with a long sustained note. The tempo is medium with strong rock drumming, guitar rhythm; guitar lead and a percussive bass line. The song is hard rock with a lot of spirit and excitement. The audio quality is bad with a lot of ambient crowd noises. | 2013-01-27T02:36:43Z | M. Adonis Ortiz | Like Please: http://www.facebook.com/ILoveGunsNRoses1 Únete/Me Gusta Por Favor: http://www.facebook.com/ILoveGunsNRoses1 Lista de gritos de Axl Rose LIVE. Una maravilla de 4 octavas: Axl Rose. Un bajo-barítono que se empuja hacia la 5ª octava. Algunos dicen que Axl suena como una guitarra, y tiene razón! No es un cantante melódico pero hace el trabajo! 01.El pasaje grave hacia el final de ¨Sweet child o' mine¨, la nota más baja es F#2. 02.La armonía grave en el comienzo de ¨Paradise City¨, también F#2. 03.Un sólido D#2 en ¨You ain´t the first¨. 04.La versión en vivo tiene dos D#2 :s. 05.C#2 desde ¨Shackler´s revenge¨ en Chinese Democracy (Que bueno que Axl Por fin lo terminó). 06.Puede Axl bajar más? El está hablando en la parte inferior de su segunda octava acá y canta un C#2 (una vez más) al final del Rockumental de MTV. 07.Axl se desliza hacia abajo para un C2 tambaleante, pero sostenido, al final de ¨Ain´t going down¨ (demo). 08.Un lindo B1 de ¨Don´t cry¨. 09.El B1 también está en esta conocida canción, ¨November rain¨ (¿Voz de fritura?) 10.Esto también suena como B1, una armonía baja (separada de la voz principal) de ¨There was a time¨. 11.La nota más baja de Axl, A1, de ¨Get in the ring con un A2¨. La armonia tiene una línea en B1, una línea en D2, una en A1 y una línea más en B1, luego las repite. 12.Hora de ir hacia arriba. Un C#5 de ¨Paradise City¨. 13.El final clásico de ¨Sweet Child o' mine¨ donde Axl toca D#5 varias veces :s y también un corto E5. 14.D#5 con trinos de ¨Welcome to the jungle¨. 15.Un D#5 de ¨Anything goes¨. 16.F5 de ¨You could be mine¨. 17.Misma nota, pero en vivo. 18.Cantando hasta F#5! y luego manteniendo esa nota, en ¨There was a time¨. Su nota más alta cantada, esto debe ser duro para él en los conciertos. 19.Gran F#5 de ¨I.R.S¨. 20.Un G5 de una versión en vivo de ¨Welcome to the jungle¨. 21.G5 en ¨Chinese democracy¨. 22.Linda cadenza hasta G#5 de ¨Scraped¨ con una armonía de C#2 abajo. 23.Manteniendo un G#5 junto con Sebastian Bach (que tenía y tiene excelent… | ["Singing", "Music", "Rock music", "Yell"] | ["live performance", "bad audio quality", "singing long notes", "rock singer", "male singer", "crowds cheering", "rock music", "rock drumming rhythm", "cymbals crashing", "live audience", "ambient crowd noises", "groovy bass line", "guitar rhythm", "g]adrenaline rush", "lifetime experience", "groovy music", "excitement", "enthusiastic", "adrenaline rush", "passionate", "spirited", "retro rock hits"] | 1 | pHC25Ia8Dxo | 4694 | |
Harmonic Brothers - I'll Fly Away | Male singers sing this gospel tune in vocal harmony. The song is medium tempo with a guitar accompaniment . The song is devotional amid inspiring. The song is a black gospel acapella recorded live in a church with poor quality audio. | 2010-05-17T07:00:46Z | anewbeginning2009 | ["Music", "Harmonic"] | ["acapella singers", "male singers", "home video", "devotional", "inspiring", "motivational", "gospel hits", "sunday morning", "guitar accompaniment", "live audience", "church music", "gospel music", "medium tempo", "steady rhythm", "vocal harmony", "poor audio recording", "congressional music", "audience cheering", "black gospel music"] | 1 | yAqznhOhoIk | 5389 |
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;