musiccaps_details (view)
14 rows where search matches "guitar", musiccaps_aspects contains "energetic" and musiccaps_names contains "Independent music" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) 148 ✖
- energetic · 14 ✖
- rock 6
- groovy bass guitar 5
- punchy snare 5
- flat male vocal 4
- low quality 4
- punchy kick 4
- shimmering hi hats 4
- youthful 4
- enthusiastic 3
- medium tempo 3
- acoustic drums 2
- addictive 2
- aggressive 2
- alternative 2
- bass guitar 2
- electric guitar 2
- electric guitar melody 2
- emotional 2
- fast tempo 2
- groovy 2
- indie rock 2
- live performance 2
- male singer 2
- melodious 2
- passionate 2
- passionate female vocal 2
- wide electric guitar chords 2
- addictive synth keys melody 1
- adventurous 1
- amplified instruments 1
- boy band 1
- buoyant 1
- bustling 1
- busy 1
- classic rock band 1
- classic rock music 1
- concert 1
- cover 1
- crowd cheering 1
- crowd screaming 1
- crowd talking sounds 1
- cymbals crashing 1
- dance groove 1
- digital drums 1
- distorted bass guitar 1
- distortion guitars 1
- documentary soundtrack 1
- doubled flat male vocals 1
- droning melody 1
- drum roll 1
- electric guitar lead 1
- electric guitar solo melody 1
- electronic music 1
- electronic sound effect 1
- electronica 1
- energetic crash cymbal 1
- energetic crash cymbals 1
- energetic cymbals 1
- energetic drums 1
- engaging 1
- fans 1
- fans going berserk 1
- fans going crazy 1
- female singer 1
- female vocal 1
- female vocalist 1
- flat female vocal 1
- foreign language 1
- funky bass lines 1
- groovy bass 1
- groovy bass line 1
- groovy bass lines 1
- groovy piano melody 1
- groovy wide electric guitar riff 1
- guitar harmony 1
- guitar rhythm 1
- happy 1
- hard rock 1
- harmonizing high pitched female vocal 1
- harsh 1
- heartbeat kick pattern 1
- hip 1
- hit song 1
- hollow 1
- indie 1
- inferior quality audio 1
- instrumental music 1
- intense 1
- intense electric guitar feed back 1
- k-pop 1
- keyboard accompaniment 1
- laser 1
- live audience 1
- lively piano 1
- loud singing 1
- love song 1
- male vocal 1
- me 1
- mellow 1
- mellow kick hits 1
- mellow synth bells melody 1
- melodic singing 1
- melodipiano accompaniment 1
- metal 1
- muffled 1
- muffled audio 1
- nasal 1
- normal tempo 1
- percussive bass line 1
- pleasant vocals 1
- poignant 1
- pop 1
- pop rock 1
- popularity 1
- post-punk 1
- psychedelic background 1
- punchy drumming 1
- retro pop hits 1
- rhythmic acoustic guitar 1
- rock band 1
- rock music 1
- romantic 1
- science experiment 1
- shimmering cymbals 1
- soft male vocal 1
- song climax 1
- sound effects 1
- spirited 1
- steady drumming 1
- steady drumming rhythm 1
- strong bass line 1
- strong rock drumming 1
- synth arrangements 1
- synth lead melody 1
- synth pop 1
- synthesiser arrangements 1
- teen pop 1
- thai 1
- thin 1
- tom roll 1
- tv show 1
- uplifting 1
- uptempo acoustic rhythm guitar 1
- vibrant 1
- vibrant vivacious 1
- vigorous drumming 1
- wide electric guitar melody 1
musiccaps_names (array) 17 ✖
- Independent music · 14 ✖
- Music 12
- Heavy metal 3
- Pop music 3
- Progressive rock 3
- Punk rock 3
- Rock music 3
- Speech 2
- Cacophony 1
- Folk music 1
- Funk 1
- Grunge 1
- Music of Asia 1
- Psychedelic rock 1
- Rapping 1
- Singing 1
- Tick-tock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
7 o'clock Teaser นี่เธอไม่รู้หรือแกล้งไม่รู้ | This is a rock music piece. It starts with a clock. There is a female vocalist singing melodically in the Thai language. The overdriven electric guitar is strumming the chords of the main tune while the bass guitar is supporting it in the background. The acoustic drum is playing a simple but powerful beat. The general atmosphere is energetic. The piece can be used as a soundtrack in a coming-of-age drama taking place in Thailand. | 2009-09-03T06:40:52Z | Chanin Yanyong | The complete teaser of 7 o'clock นี่เธอไม่รู้หรือแกล้งไม่รู้ | ["Heavy metal", "Music", "Independent music", "Pop music", "Tick-tock", "Progressive rock"] | ["rock music", "thai", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "normal tempo", "sound effects", "energetic"] | 9 | B1beLwV4yzw | 1193 | |
Felix Hagan & The Family - Sing Your Last Lullaby | The Rock song features a flat male vocal singing over a wide electric guitar melody, shimmering hi hats, energetic crash cymbals, punchy snare and kick hits, groovy bass guitar and piano chord progression. At the end of the loop, there is a short tom roll, representing a transition to the next section. It sounds energetic - like something you would hear on a radio. | 2013-08-13T22:24:25Z | Felix Hagan | This is the second video from our EP, String Up The Entertainer, which will be released in September. It is quite possibly the silliest thing we have ever done. We hope you enjoy it. For gigs, news, photos and everything else visit: http://www.facebook.com/felixhaganmusic The EP, along with our last album, will be available to download at: http://felixhagan.bandcamp.com/ Twitter also exists: @FelixHagan Feel free to check out our other videos on here and if you like them, come down to a show! We'd love to meet you. Crew: Director: Joe Mannion - sleepingstate.com DOP: Guy Gotto Camera Assistant: Rob Abercrombie Hair and Make Up: Rebecca Doney Cast: Jesus: Felix Hagan Judas: Ellie Cowan Peter: Will Stanley Disciples: Tash Hodgson, Stuart Mann, Tom Webber, Effie Stoodley, Gareth Williams, Rebecca Doney, Jess O'Neill, Amy Schofield, David Wilson and Rob Abercrombie. We would especially like to thank Clare College, Cambridge and Effie Stoodley for being simply beautiful and providing us with the perfect location in which to hurl custard about. We would also like to thank Dunn's Bakery, Crouch End for arming us with such delicious ammo. Go there and eat everything. That's an order. | ["Music", "Punk rock", "Independent music"] | ["rock", "flat male vocal", "wide electric guitar melody", "groovy piano melody", "shimmering hi hats", "energetic crash cymbals", "punchy kick", "groovy bass guitar", "energetic", "tom roll"] | 4 | CIoEXRnAr-Y | 1349 | |
"Nashville Indie Music Rocks" [Nokia - Sundance London Film Festival Entry by Russb] | The low quality recording features an indie rock song that consists of passionate female vocal singing over energetic drums, electric guitar solo melody and groovy bass, over which there is a flat, nasal and muffled male vocal narrating. The song sounds energetic and uplifting. | 2013-03-21T09:15:50Z | Joy Collins Music | DOWNLOAD Great Indie Music @ http://bit.ly/iTunesJoyCollins Visit http://countrymusicsongs.co Go TO http://bit.ly/NashvilleIndieMusicDocumentary AND Click The "SUPPORT RUSS" Button for the http://facebook.com/NokiaMusic #NokiaXSundanceLDN #Lumia920 Music Contest. Our documentary is about the extremely talented, diverse, Nashville Independent Music Scene. Please share this with all of your friends and help us take our documentary to the upcoming Sundance Film Festival in London. Stop by http://twitter.com/NokiaMusic and let them know that you support The Indie Music Scene in Nashville and would like to see our city chosen as a participant! Thanks and PLEASE SHARE and COMMENT!! Nashville Independent Music Rocks! For collaborations and business inquiries, please contact via Channel Pages: http://ChannelPages.com/CountryMusicSongs4u | ["Music", "Independent music", "Speech"] | ["low quality", "flat male vocal", "indie rock", "passionate female vocal", "energetic drums", "electric guitar solo melody", "groovy bass guitar", "energetic", "uplifting", "muffled", "nasal"] | 4 | CKO35LsM0XI | 1352 | |
Indie/Pop/Folk Compilation - Christmas Playlist | A female singer sings this spirited song. The tempo is fast with a lively piano accompaniment, punchy drumming, funky bass line, rhythmic acoustic guitar, and a droning synthesiser harmony. The music is loud, busy, chaotic and bustling and the vocals are subdued. This clip sounds like the song climax as the instrumentation is strong and powerful. The song is spirited, melodic,energetic, enthusiastic, youthful and engaging. This song is an Indie Pop song. | 2014-11-24T09:53:53Z | alexrainbirdMusic | Listen to a collection of indie songs perfect for the festive season! Tracklist below... Subscribe to be the first to hear the finest independent music! http://bit.ly/145fFnx Please contact alexrainbirdmusic@gmail.com if you’d like your band to be featured on my channel. Tracklist: 0:00 LAYLA -- 'Winter, You Tease' https://www.facebook.com/listentolayla 3:39 Sugarcult -- 'Freezing' https://www.facebook.com/pages/Sugarcult/122472207779743 5:29 Sleeping At Last -- 'Silver Bells’ https://www.facebook.com/sleepingatlast 8:29 Brighten -- ‘Merry Christmas Baby’ https://www.facebook.com/pages/Brighten/108211255873665 11:39 Golden Youth -- ‘Have Yourself A Merry Little Christmas’ https://www.facebook.com/ourgoldenyouth Find alexrainbirdMusic on: Facebook: https://www.facebook.com/alexrainbirdMusic Twitter: https://twitter.com/alxrnbdMusic Spotify: https://play.spotify.com/user/alxrnbrdmusic Soundcloud: https://soundcloud.com/alexrainbirdmusic Instagram: https://instagram.com/alexrainbirdmusic/ Grab an official t-shirt: UK Store: http://shop.spreadshirt.co.uk/alexrainbirdmusic US Store: http://shop.spreadshirt.com/alexrainbirdmusic About alexrainbirdMusic: Since 2011, Alex Rainbird has been hunting down and showcasing the very best in independent music. Featuring over 45 new artists a month, Alex hopes to provide a platform for underrated musicians to be heard and for viewers to find their new favourite band. Join Alex's +44,000 subscribers today to be the first to hear the finest independent music. | ["Folk music", "Music", "Independent music", "Pop music"] | ["female singer", "fast tempo", "electronic music", "melodious", "youthful", "energetic", "enthusiastic", "song climax", "busy", "bustling", "melodipiano accompaniment", "punchy drumming", "synthesiser arrangements", "funky bass lines", "rhythmic acoustic guitar", "psychedelic background", "droning melody", "synth pop", "electronica", "amplified instruments", "pleasant vocals", "indie", "pop", "alternative"] | 7 | FGZ0sLt4dXA | 1631 | |
ITV Chart Show Indie Chart July 1995 | A female vocalist sings this energetic song. The tempo is fast with furiously energetic drumming, intense electric guitar, groovy bass lines, keyboard harmony, vocal backup and synthesiser arrangements. The song is passionate, spirited,youthful, buoyant, punchy, energetic and animated. The audio is muddy and incoherent. This song is Pop Rock. | 2007-09-09T16:56:00Z | David Bryant | Features: Buffalo Tom - Summer Song Menswear - Daydreamer | ["Music", "Independent music"] | ["female vocalist", "loud singing", "fast tempo", "pop rock", "hard rock", "dance groove", "buoyant", "spirited", "passionate", "vibrant", "enthusiastic", "energetic", "intense", "vigorous drumming", "intense electric guitar feed back", "groovy bass lines", "synth arrangements", "digital drums", "muffled audio", "inferior quality audio", "rock"] | 7 | J48F0e0guSQ | 1966 | |
Bouncing Steel Balls on Water | The song is an instrumental. The tempo is medium with a strong rock drumming rhythm, groovy bass slime, electric guitars playing lead and guitar harmony. The song is exciting, youthful and emotional. The song is a classic rock instrumental. | 2009-08-26T21:41:24Z | protonsforbreakfast | Some slow-motion footage of experiments bouncing 25 mm diameter steel balls on water. The Balls were fired from a specially constructed air gun and had a muzzle velocity of around 40 meters per second (90 miles per hour). The bouncing is easy to see and the general effect delightful. Enjoy! The experiment was performed on the site of a 'Ship Tank' at the UK's National Physical Laboratory in which the original experiments were conducted in 1943 on a so-called 'bouncing bomb'. | ["Heavy metal", "Music", "Punk rock", "Independent music", "Rock music", "Progressive rock"] | ["classic rock music", "instrumental music", "emotional", "groovy", "poignant", "drum roll", "distortion guitars", "tv show", "instrumental music", "medium tempo", "electric guitar lead", "guitar harmony", "strong bass line", "adventurous", "energetic", "documentary soundtrack", "science experiment", "strong rock drumming", "me"] | 1 | XfdySM4X9Xo | 3209 | |
Teemo Shroom (Original) [#TeemoTuesdays Cypher 2014] - The Yordles | The low quality recording features a metal song that contains a flat male vocal, alongside harmonizing high pitched female vocal, singing over punchy kick and snare hits, shimmering hi hats, distorted bass guitar, mellow synth bells melody and groovy wide electric guitar riff. It sounds energetic, groovy, aggressive. | 2014-05-06T20:59:26Z | The Yordles | Discuss on Reddit: http://www.reddit.com/r/leagueoflegends/search?q=%23TeemoTuesdays+Cypher&restrict_sr=on&sort=relevance&t=all #TeemoTuesdays 2014 Cypher Playlist: http://bit.ly/1shDnEo Buy this song ► http://itunes.apple.com/album/id874427098 Support us directly ► https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=HCX3JYNEFQV3Y Play LoL for free ► http://signup.leagueoflegends.com/?ref=4e3b93caab1b6183697184 Twitter ► http://www.twitter.com/theyordles Facebook ► http://www.facebook.com/theyordles Livestream ► http://www.twitch.tv/theyordles Buy our songs ► http://theyordles.bandcamp.com or iTunes Spotify ► https://play.spotify.com/artist/2QOvTVjxq2ss2co5pqpnWY UberGuitarDude uses Pro Built Systems ► http://www.probuiltsystems.com ► http://www.twitter.com/probuiltsystems Join "The Yordles" chat in League Of Legends - Click the bottom right corner of the LoL client, type in The Yordles, and join! Be sure to set it to auto-join and stay in the family! Join us on the The Yordles Raidcall! ► http://www.raidcall.com/go.php?sid=6870409 ► Group ID: 6870409 ◄ Lyrics: [Verse 1] From the land of Bandle City All across the Summoner's Rift The yordle known as Teemo A scout who's small and swift Camouflaged in top lane Or perhaps he's creeping mid Armed and ready with his blowgun And escape he will forbid [Pre chorus] Never underestimate The power of the scout's code He will seal your fate HUT 2, 3, 4!!! [Chorus] The Swift Scout, A Bandle City citizen Tell Lee Sin that there's a new Legend Reporting in, size doesn't mean everythin' Move quick, toxic shot, that's got a sting Blinding dart, missing every single swing In the end if you're still standing THEN I'LL GET YA WITH MY TEEMO SHROOMS! [Verse 2] With the cuteness of a Moogle, Dunks like Shaquille O'neal A mask that's not Majora's And a global taunt so real. The source of all his power Shrooms 1-UP, death counts Ryze With the courage to move forward, And the wisdom to survive [Bridge] The hero of Bandle City The hero that we all need … | ["Music", "Independent music"] | ["low quality", "metal", "flat male vocal", "harmonizing high pitched female vocal", "punchy kick", "punchy snare", "distorted bass guitar", "groovy wide electric guitar riff", "shimmering hi hats", "aggressive", "groovy", "energetic", "mellow synth bells melody"] | 4 | ZOzavOPeuJQ | 3373 | |
I've Got My Glasses On 👓 Wearing Glasses Song for Children 🧐🤓😎 The Wiggles | The low quality recording features a rock song that consists of a flat male vocal and flat female vocal talking, followed by punchy kick and snare hits, shimmering hi hats, energetic crash hits, wide electric guitar chords, groovy bass guitar and synth lead melody. It sounds energetic. | 2013-02-07T23:21:04Z | The Wiggles | Subscribe to our channel for more Wiggly videos: http://ab.co/WigglesYouTube For more Wiggly fun: Website ► http://TheWiggles.com.au Facebook ► http://facebook.com/TheWiggles Twitter ► http://twitter.com/TheWiggles Instagram ► http://instagram.com/TheWiggles Spotify ► https://ab.co/TheWigglesSpotify US & UK Shop ► https://thewigglestore.com/ AUS Shop ► https://thewigglestore.com.au/ #glasses #kidsglasses #thewiggles | ["Music", "Independent music", "Speech"] | ["low quality", "rock", "flat female vocal", "flat male vocal", "energetic crash cymbal", "groovy bass guitar", "wide electric guitar chords", "synth lead melody", "shimmering hi hats", "punchy kick", "punchy snare", "energetic"] | 4 | b-Y-AjW6MJ0 | 3594 | |
BTOB - Beep Beep (Feb 20, 2014) | A male vocalist sings this melodious pop song. The tempo is medium with piano accompaniment, rhythmic acoustic guitar, groovy bass line ,steady drumming and energetic vocal backup. The song is spirited, youthful, vivacious, popular, bright and engaging. The song is a live performance and there are sounds of people cheering, hooting hysterically and singing along. This song is a hit in K-Pop. | 2014-02-21T07:07:36Z | Minhyuk ครับผม | 140220 BTOB - Beep Beep @ M Countdown Comeback Stage | ["Music of Asia", "Funk", "Music", "Independent music", "Pop music", "Rapping"] | ["male singer", "foreign language", "medium tempo", "youthful", "engaging", "energetic", "enthusiastic", "vibrant vivacious", "concert", "teen pop", "k-pop", "live performance", "concert", "live audience", "enthusiastic", "crowd cheering", "crowd screaming", "fans", "fans going crazy", "fans going berserk", "popularity", "hit song", "boy band", "melodious", "steady drumming", "lively piano", "groovy bass line"] | 7 | cADT8fUucLQ | 3686 | |
Maps (UCSC Version) - Yeah Yeah Yeahs | The cover of a rock song consists of soft male vocal singing over shimmering cymbals, punchy snare and kick hits, groovy bass guitar, addictive synth keys melody and electric guitar melody. It sounds energetic, but yet mellow and addictive - thanks to that cadence. | 2006-08-06T04:59:47Z | Michael Tucker | "Fantastically Creepy" is one way it has been described. How would you describe it? Video for "Maps" by the Yeah Yeah Yeahs. Go UCSC (University of California at Santa Cruz). Check out more of our movies at http://www.finite-films.com | ["Independent music"] | ["cover", "rock", "soft male vocal", "shimmering cymbals", "punchy snare", "punchy kick", "groovy bass guitar", "addictive synth keys melody", "electric guitar melody", "energetic", "addictive", "mellow"] | 4 | nZOgoVEud_w | 4553 | |
Hoover EmPower Vacuum Jingle | The Rock song features a doubled flat male vocals singing over wide electric guitar chords, groovy bass guitar, energetic cymbals, punchy snare hits and heartbeat kick pattern. It lacks low frequencies, therefore it sounds thin, hollow and harsh, but regardless, also energetic and aggressive. | 2011-03-07T07:54:13Z | Jim Simonian | This was a fun jingle that we did for the Hoover Empower Vacuum cleaner back in 2005. Kelly Derrick - vocals, Jim Simonian - Drums, Vocals, Ron Gregorcic - Guitars. | ["Heavy metal", "Music", "Punk rock", "Independent music", "Psychedelic rock", "Rock music", "Progressive rock", "Grunge"] | ["rock", "wide electric guitar chords", "groovy bass guitar", "doubled flat male vocals", "energetic cymbals", "punchy snare", "heartbeat kick pattern", "harsh", "thin", "hollow", "aggressive", "energetic"] | 4 | qDiTICmdUQg | 4765 | |
2014 REWIND Meet & Greet Highlights | The low quality recording features a rock song that consists of a passionate female vocal singing over shimmering hi hats, punchy snare, mellow kick hits, uptempo acoustic rhythm guitar, groovy bass and some crowd talking sounds in the background. It sounds energetic, happy and addictive. | 2014-12-27T20:59:50Z | How To Cook That | Subscribe: http://bit.ly/H2CThat Recipe: http://howtocookthat.net How To Cook That Channel: http://youtube.com/howtocookthat ❤️Support on patreon: https://patreon.com/h2ct ❤️merch: https://youtube.com/howtocookthat/store Hi I am Ann, How to Cook Join me for creative cakes, chocolate & desserts. New video every Friday. SUBSCRIBE ( http://bit.ly/H2CThat ) for step by step tutorials for yummy desserts, sweet macarons, cupcakes, chocolate and cake decorating. Recipe details: http://www.howtocookthat.net SUBSCRIBE on youtube : http://bit.ly/H2CThat SUBSCRIBE for EMAIL updates: http://bit.ly/H2CTemail MEET & GREET VOLUNTEERS: Mandy Andrews insta: http://goo.gl/mgn5c2 Brendan Andrews Mark Pedlow youtube: http://goo.gl/tAmgca Naomi Scesny youtube: http://goo.gl/g4XGGu Mickey insta: http://goo.gl/MlWqb4 David Reardon insta: http://goo.gl/bspEfY My Kids youtube: http://goo.gl/ehwKkl THUMBNAIL: polymer clay cakes by Priscilla H a subscriber since Jan 2013 Youtube Channel: http://youtube.com/howtocookthat Google Plus: http://google.com/+Howtocookthat Facebook: https://www.facebook.com/howtocookthat Twitter: https://twitter.com/howtocookthat Instagram: http://instagram.com/howtocookthat Pinterest: http://www.pinterest.com/howtocookthat/ More videos by Ann: CHOCOLATE TUTORIALS: http://goo.gl/xFznw DESSERT RECIPES: http://goo.gl/fSr1u CAKE DECORATING LESSONS: http://goo.gl/1RyOh MACARONS & CAKE POPS: http://goo.gl/GzdXl Business enquiries only: howtocookthat [at] iinet.net.au MUSIC BY: SET SAIL used with permission, check out their other songs on iTunes... https://itunes.apple.com/au/artist/set-sail/id388088498?uo=4&at=11lsF8 SEND MAIL TO: Ann Reardon PO Box 202 Chirnside Park LPO Australia 3116 | ["Independent music"] | ["low quality", "rock", "passionate female vocal", "shimmering hi hats", "punchy snare", "uptempo acoustic rhythm guitar", "electric guitar melody", "groovy bass", "crowd talking sounds", "mellow kick hits", "happy", "addictive", "energetic"] | 4 | t8SLY7xn7Sc | 5009 | |
Bloc Party - Hunting For Witches @ Bristol Academy 7/2/07 | This is the live performance of an indie rock/post-punk piece. There is a male vocalist in the lead. The tune is being played by the electric guitar and the bass guitar while an electronic sound effect that resembles a laser is adding texture. There is a fast and slightly off-tempo acoustic drum beat playing in the rhythmic background. The atmosphere is energetic. The piece could be playing in the soundtrack of a teenage drama TV series. | 2007-02-23T17:52:05Z | matthewm674 | Bloc Party performing Hunting For Witches live at the Bristol Carling Academy - 7th Feb 2007. | ["Singing", "Music", "Independent music", "Rock music", "Cacophony"] | ["live performance", "indie rock", "post-punk", "alternative", "male vocal", "electric guitar", "bass guitar", "electronic sound effect", "laser", "acoustic drums", "energetic", "hip", "youthful"] | 9 | xUMzNtC2ITA | 5332 |
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;