musiccaps_details (view)
17 rows where musiccaps_aspects contains "e-bass", musiccaps_aspects contains "e-guitar" and musiccaps_aspects contains "medium to uptempo"
This data as json, CSV (advanced)
musiccaps_names (array) >30 ✖
- Music 17
- Singing 4
- Grunge 3
- Independent music 3
- Musical instrument 3
- Angry music 2
- Rock music 2
- Song 2
- Swing music 2
- Applause 1
- Blues 1
- Christian music 1
- Dance music 1
- Electronic music 1
- Exciting music 1
- Funk 1
- Gospel music 1
- Guitar 1
- Happy music 1
- Maraca 1
- Percussion 1
- Plucked string instrument 1
- Pop music 1
- Progressive rock 1
- Radio 1
- Reggae 1
- Rhythm and blues 1
- Scrape 1
- Ska 1
- Soul music 1
- …
musiccaps_aspects (array) >30 ✖
- e-bass · 17 ✖
- e-guitar · 17 ✖
- medium to uptempo · 17 ✖
- acoustic drums 11
- piano 6
- male voice singing 3
- rock 3
- tambourine 3
- acoustic guitar 2
- amateur recording 2
- energetic 2
- female voice singing 2
- accordion 1
- acoustic piano 1
- aggressive energy 1
- agrgressive 1
- backing track 1
- backing voices 1
- banjo 1
- bongos 1
- brass section 1
- cowbell 1
- crowd cheering and clapping 1
- digital drums 1
- digital strings 1
- drums 1
- electric organ 1
- electronic sounds 1
- female soul voice 1
- female voices singing 1
- …
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Stream Radio Software | The first song starts with a hihat, e-guitar playing a melody and a bassline. Then the song changes after some radio noise sounds into a pop song containing a piano; male backing voices; synth lead sound and a female singer. These songs may be playing for an advertisement. | 2012-09-26T03:49:04Z | OnlineSoftwareRadio | http://linkclick.me/OnlineRadio ◄ Retail version (no ads) http://linkclick.me/FreeRadio ◄ Stream Radio Software Enjoy 5,325 world Radio stations with No monthly fees! Listen to thousands of HQ radio stations from your computer! 2 minutes and your computer will become an amazing Music player! Turn your computer into a multi-channel WEB Radio! With our service you can listen to thousands of Radio stations from all over the world, Installation is simple and easy - in just a few seconds you will be able to listen to thousands of stations. Online Radio is the perfect solution, a simple and convenient alternative to Satellite Radio. Absolutely ZERO monthly costs -- Online Radio is free of any monthly charge or recurring monthly subscription. A lifetime license for free updates is included in this package. Thousands of stations - Select your favorites out of thousands international internet based stations from all over the world. No additional hardware required - This is software only, one that can be installed on any Internet enabled PC desktop or Laptop. There is no need to add additional hardware such as a Radio tuner or DVR card. Easy to use -- Everyone can use this. A simple interface makes it as easy as listening to your regular radio set! Works everywhere in the world --Listen to internet Radio with your PC in any country with Internet access. 100% Legal -- This software is not illegal in any way, as it streams all the free FREE web stations available on the Internet. Runs on Windows Platform -- Works smoothly on every PC running any version of the Microsoft Windows operating system including Windows 98, XP, Vista and Windows 7. A one time payment of less Than $15 and you can stream over thousands of web Radio stations free! A free Premier auto update license is included in this package. | ["Music", "Radio"] | ["rock", "pop", "e-guitar", "e-bass", "piano", "female voice singing", "synth", "drums", "song change", "medium to uptempo"] | 6 | 0EvpBtracsk | 136 | |
Making a knife from an old file | This song contains a simple acoustic drum groove with a cowbell and a bassline following. Two e-guitars are playing a melody then a male voice starts singing loud and in the mid-range. This song may be playing while working in the garage. | 2011-12-27T01:03:54Z | Splattis1996 | This video is about making a knife from an old file. | ["Music", "Independent music", "Grunge"] | ["rock", "cowbell", "e-bass", "e-guitar", "male voice", "mid-range singing acoustic drums", "medium to uptempo"] | 6 | 9IdAIIywBfY | 989 | |
Crossfaith - "Jägerbomb" Official Music Video | This song has a bassline that repeats itself playing along with a distorted guitar that supports the melody by playing the low notes along with slight variations and licks. The acoustic drums sound in the background but are played at full force. Fast paced with a lot of hits on different crashes and using a double bass kick. The male voice is screaming full force then a synthesizer lead sound is playing a simple melody that is panned to the right side of the speakers. This song may be playing at a live-concert jumping up and down enjoying the energetic energy of the surrounding and the music. | 2013-01-14T17:00:06Z | CrossfaithOfficial | Crossfaith's new SPECIES EP is out on May 20th (Japan) / 22nd (Worldwide), pre-save / pre-add now: https://unfd.lnk.to/PresaveSPECIESEP Crossfaith on Facebook: https://www.facebook.com/crossfaithof... Crossfaith on Instagram: https://www.instagram.com/crossfaithj... Crossfaith on Twitter: https://twitter.com/CrossfaithJapan New album XENO out now! iTunes - http://apple.co/1gHgZDg // Spotify - http://spoti.fi/1OqiOTT // Amazon - http://amzn.to/1IqjSn7 // UK LP - uk.unfdcentral.com // AU merch - http://bit.ly/24HXeno // US merch - http://merchnow.com/catalogs/crossfaith // EVERYTHING - crossfaith.jp CROSSFAITH headline UK & European tour 2016! Feb 25th - La Laiterie, Strasbourg, France Feb 26th - La Cafe Charbon, Nervers, France Feb 27th - L’orange Bleue, Vitry-Le-Francois, France Feb 28th - Chato Do, Blois, France Mar 1st - Logo, Hamburg, Germany Mar 2nd - Trix Club, Antwerp, Belgium Mar 3rd - Helling, Utrecht, Netherlands Mar 4th - Strom, Munich, Germany Mar 5th - Officina Degli Angeli, Verona, Italy Mar 7th - Dynamo, Zurich, Switzerland Mar 8th - Arena, Vienna, Austria Mar 9th - Rock Cafe, Prague, Czech Republic Mar 11th - Magnet, Berlin, Germany Mar 12th - Luxor, Cologne, Germany Mar 13th - Brise Glace, Annecy, France Mar 14th - Le Trabendo, Paris, France Mar 16th - Chinnerys, Southend, UK Mar 17th - Wedgewood Rooms, Portsmouth, UK Mar 18th - The Haunt, Brighton, UK Mar 19th - Y Plas, Cardiff, UK Mar 20th - The Hub, Plymouth, UK Mar 22nd - Key Club, Leeds, UK Mar 23rd - Sub 89, Reading, UK Mar 24th - Slade Rooms, Wolverhampton, UK Mar 25th - Academy 2, Liverpool, UK Mar 26th - Academy 2, Manchester, UK Mar 28th - King Tuts, Glasgow, UK Mar 29th - Cooperation, Sheffield, UK Mar 30th - Waterfront, Norwich, UK Mar 31st - Electric Brixton, London, UK Apr 2nd - Volta Club, Moscow, Russia Apr 3rd - Club Zal, St.Petersburg, Russia www.crossfaith.jp Follow the band: @KenCrossfaith @HiroCrossfaith @TeruCrossfaith @KazuCrossfaith @TatsuCrossfaith ▼Video Shooting N' Production Directed by INNI VISION http://inn… | ["Blues", "Music", "Rhythm and blues", "Dance music", "Exciting music"] | ["punkrock", "e-guitar", "e-bass", "loud acoustic drums", "male", "screaming voice", "synthesizer lead sound", "energetic", "medium to uptempo"] | 6 | BT4env-Tw2o | 1242 | |
Sweet Soul Music 31 Scorching Classics 1964 | A male voice is singing along to a blues/rock bassline and acoustic drums. A e-guitar and a banjo are playing the same melody as the bass. All the instruments are playing when the male voice is not singing. Then after fading out a new song starts with a percussive sound, an upright bass, piano and a female voice singing.This song may be playing in a bar. | 2009-11-28T18:40:58Z | BearFamilyRecords | Various Artists Sweet Soul Music 29 Scorching Classics 1964 (1-CD DigiPac with 96-page booklet. 29 tracks, playing time: 79:48) -- Here comes the eagerly anticipated sequel to our first five volumes of 'Sweet Soul Music,' as well as the highly acclaimed, award-winning R&B series 'Blowin' The Fuse.' This is ehe sound that influences musicians who weren't even born when it came out, like Amy Winehouse and Joss Stone! All the greatest and most influential soul hits of the 1960s, including some surprisingly hard-to-find selections! Every song is the original version. The ultimate soul collection spread across ten individual CDs! The soul-searing soundtrack to the 1960s! Massive, beautifully illustrated booklets with detailed notes, incredible vintage photos, and ephemera. -- Over the course of ten spectacular years, R&B morphed into soul music with a side order of funk, and became the soundtrack to a social revolution. The riveting story of that incredible decade is told in full for the first time on Bear Family's 'Sweet Soul Music' series. Some record companies have compiled anthologies from their own vaults, but Bear Family has gone the extra mile... and then some, licensing classic recordings from virtually every record label at the epicenter of '60s soul to compile the greatest hits with the finest sound quality. -- The second five volumes, available now, cover the years 1966-1970. Though gospel remained the bedrock of soul music, the sound was transforming fast, thanks to Motown, Stax, the regional innovations of Chicago, New Orleans, and Muscle Shoals, and the funk revolution, led by James Brown and Sly & The Family Stone. The civil rights and antiwar movements were now rolling full speed ahead, and the messages at the heart of the music were often as powerful and invigorating as the grooves themselves. The second half of this incredible story is just as fascinating as the first. Bill Dahl's track-by-track commentary provides extensive biographical info on every artist on every disc. -- The prelude to this seri… | ["Music", "Pop music", "Soul music"] | ["rock&roll/soul", "e-guitar", "e-bass", "acoustic guitar", "piano", "banjo", "two songs", "male voice singing", "female voice singing", "upright bass", "medium to uptempo"] | 6 | DGbMEkQerYs | 1458 | |
Dmitry Zharkov - Olga Kulikova | Final Slow Fox | Finland Open 2016 Grand Slam | An acoustic drum is playing a jazzy groove on the ride along with a bassline while an e-guitar is playing jazz chords with a lot of changes together with an acoustic piano rendering phrases with an uplifting melody. The singer's voice sounds low and romantic. This song may be playing while dancing with a partner. | 2016-03-26T13:14:27Z | in.media | Finland Open 2016 Grand Slam Standard Final Round Slow Foxtrot Dmitry Zharkov - Olga Kulikova | ["Singing", "Applause", "Music"] | ["jazz/ballad", "acoustic piano", "acoustic drums", "e-bass", "e-guitar", "male deep voice singing", "crowd cheering and clapping", "medium to uptempo", "romantic"] | 6 | HLz3N5nG8fQ | 1793 | |
The Raveonettes -- "That Great Love Sound" | This song contains an acoustic drum playing a kick and snare together on every beat along with a tambourine shaker. An e-bass is playing a distorted bassline. Two e-guitars are playing a modified melody on top of that. A female and male voice are singing together creating harmony. This song may be playing in a live concert. | 2007-10-03T20:40:43Z | DJ Andy Anderson | The Raveonettes performing "That Great Love Sound" live at CBGB in NYC. Produced by Andy Anderson. Directed by Sorrel Ahlfeld. | ["Music", "Independent music", "Scrape"] | ["rock/pop", "e-bass", "e-guitar", "acoustic drums", "tambourine", "male and female singer", "medium to uptempo"] | 6 | JDrnf3vldLw | 1982 | |
Toasted Western Swing Band: Leaving and Saying Goodbye | An acoustic drum is playing a groove with brushes while an e-bass is playing a walking bassline. Someone is strumming chords on an acoustic guitar while an e-guitar is playing rhythmic chords on the offbeat along with a slide guitar playing a melody. A mid-ranged male voice is singing a melody supported by male and female backing singers. This song may be playing in a coffee shop in the morning. | 2012-01-27T00:53:15Z | ArtistsTribute | http://festivalentertainment.ca/toasted-western-swing-band/ You will feel the nostalgic magic in the air when Canada's Favourite Cowboys and Cowgirls take the stage with their thrilling tribute to the Legends of Texas Swing Music! This crowd pleasing band has plenty of pedigree as they have performed live on stage at some of Canada's largest Music Event Festivals. They have opened shows for many legendary performers to include Martina McBride, Shenandoah, Sawyer Brown, Joe Nichols, Doug Kershaw, Tommy Hunter, Jeannie Sealy, and more! The Toasted Western Swing Band delivers to their audience a foot stompin/ toe tapping celebration of the great songs of such Texas Swing Legends such as Bob Wills and the Texas Playboys, Ray Charles, Jeannie Sealy, Asleep at the Wheel, Willie Nelson, Johnny Cash, Buck Owens, Dwight Yoakum and Much More! Find out why the Toasted Western Swing Band was held over for 47 straight weeks at the Best Western Hotel in Niagara Falls! It don't mean a thing unless its got that Texas Swing! Yeeeeee Hawwwwwww!!! | ["Singing", "Swing music", "Music", "Independent music", "Song"] | ["western/county", "acoustic guitar", "slide guitar", "e-guitar", "acoustic drums", "e-bass", "male and female singers", "medium to uptempo"] | 6 | MwK9HYjeeN0 | 2310 | |
Try a little tendernes_The Commitmens | A male voice is singing loud and soulfully. A saxophone is playing a slight variation of the singer's melody. A piano is playing bluesy/jazzy chord chops accompanied by an electric organ playing along with the melody. Panned to the left side of the speaker, a e-guitar is playing one single chord as a rhythmic element. The e-bass is playing a line along with a simple rimshot and shakers that are barely noticeable. This song may be playing at a live concert. | 2010-09-27T10:52:20Z | dimosk100 | ["Singing", "Music", "Ska"] | ["soul/blues/jazz", "male soul voice singing", "e-guitar", "saxophone", "piano", "electric organ", "e-bass", "acoustic drums", "soulful", "medium to uptempo"] | 6 | dTVkk4GSmNA | 3790 | ||
Improve Your Squat! (ATG- 315lbs) | This audio contains digital drums with an open hi hat. A distorted e-guitar and an e-bass are both playing the same melody in the lower register. A synth pluck is playing a simple repeating rhythmic melody on top. You can hear the sound of glass breaking. This song may be playing at a live festival. | 2013-04-04T14:14:35Z | ScottHermanFitness | 12 WEEK TRANSFORMATION CHALLENGE! http://muscularstrength.com/twelve-week-transformation-challenge Easiest Bodyfat Measuring Tool! - SKULPT AIM: http://goo.gl/hvapTN High Protein Food! - Pasta, Oatmeal, Granola, and Snack Bars! - http://muscularstrength.com/true-gains Website: http://www.MuscularStrength.com/join (ONE MONTH FREE - PROMOCODE: FREEFITNESS) FX-SPORT Headphones (Wireless & Waterproof!) Use code SCOTT20 for $20 off - http://goo.gl/0YNmyU Bar Grips, Wrist Wraps/Straps, Fractional Plates & More! - IronBullStrength - 10% off coupon code! "MS10" - CLICK HERE - http://goo.gl/b05PxB Online Coaching (Custom Routine & Meal Plan) http://muscularstrength.com/consultations Fitness Genes - Maximize YOUR Genetic Potential! - CLICK HERE (30% Off) - https://goo.gl/FSBMWc THYNC - Want To Sleep Better & Focus More During Your Workouts? - http://goo.gl/BwYlxZ Twitter: https://www.twitter.com/Scott_Herman Facebook: http://www.facebook.com/ScottHermanFitness Instagram: http://www.instagram.com/ScottHermanFitness Squatting is more than just bringing the weight down and up. From foot stance to opening up your hips, there are many tips you can incorporate into your squat to get more out of it. If you are going to do something, you better do it right! | ["Music", "Angry music"] | ["hard-rock", "digital drums", "e-guitar", "e-bass", "synth pluck", "medium to uptempo", "agrgressive", "energetic"] | 6 | gfIqYbQQq10 | 4043 | |
Electric Callboy - We Are The Mess (OFFICIAL VIDEO) | This song is a mixture of punk rock with acoustic drums with crash hits, e-guitar playing low notes along with the bassline, a male voice aggressively, loud screaming and digital higher pitched sample sounds being panned to the left and right side of the speakers. This song may be playing at a live concert in an underground club. | 2013-11-29T08:17:57Z | Electric Callboy | New Single "We Are The Mess" - Out Now! iTunes: http://bit.ly/1cFo7bM Amazon Digital: http://amzn.to/1egxoch "We Are The Mess" taken from the upcoming album "We are The Mess"! Street Date: 10th January 2014. GET MERCHANDISE: http://www.electriccallboy.com (worldwide shipping) Thanks for your support!!! Video Production: Directed by Eskimo Callboy & Oliver Schillo Edit and VFX by Oliver Schillo & Pascal Schillo Sound Design by Pascal Schillo Music & Lyrics by Electric Callboy Produced by Daniel Haniß and Pascal Schillo Recorded by Electric Callboy Mixed by Daniel Haniß and Pascal Schillo Mastered by Kristian "Kohle" Kohlmannslehner at Kohlekeller Studio Published by BMG Rights Management. Redfield Records 2014. Lyrcis: We don't wanna be sober anymore let's get fucked up with those bitches and whores We don't wanna be sober anymore, let's get fucked up with those bitches and whores Baby let me be your bartender let's get fucked up that we can't remember last night I'm alright when you're here with me I'm alright when you're here with me We are looking for some trouble tonight We wanna party like a g6 looking for those hot chicks I said get out the way I wanna rock the dance floor I got the moves you got the keys for the backdoor Life is a party Why are you so serious ? We make you look ridiculous Ladies get naughty! Gentlemen are in da club Sing along let's get fucked up! Baby let me be your bartender let's get fucked up that we can't remember last night I'm alright when you're here with me I'm alright when you're here with me Baby let me be your bartender let's get fucked up that we can't remember last night I'm alright when you're here with me I'm alright when you're here with me We break the girl's hearts still before we have a drink We're smoking the last cigarette before your girlfriends show us pink and you can't fuck with us and you can't fuck with me We are the new kids from the block and you're just cheesy Life is a party why are you so serious ? We make you look ri… | ["Singing", "Music", "Angry music"] | ["punkrock/electronic", "electronic sounds", "e-guitar", "e-bass", "acoustic drums", "male voice streaming", "aggressive energy", "medium to uptempo"] | 6 | hj7VJnNq6A4 | 4131 | |
Is This Love? | This audio contains someone playing a melody on steeldrums along to a backing track containing an e-bass playing a melody along with an e-guitar. A kick is being played on every beat. This song may be played on the streets by a busker. | 2011-03-22T14:37:55Z | Steel Drum Music | Bob Marley's classic reggae hit played in 2011 at the Harbor Beach Marriott, Fort Lauderdale, Florida. This song is featured on the 'Steel Drum Rub-a-Dub: Bob Marley Tribute' album. You can get it at: iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA or directly from Bob Lyons' web site: http://www.SteelDrumMusic.net | ["Music", "Musical instrument", "Percussion", "Steelpan"] | ["amateur recording", "reggae", "backing track", "e-bass", "acoustic drums", "steel drums", "e-guitar", "medium to uptempo"] | 6 | msnm_tYXcYw | 4497 | |
Chief Rockhead - Lit my Soul [official Music Video] | Someone is playing acoustic drums with a half open hi hat holding a simple rock groove with snare hits as fill-ins. An e-bass plays a bassline along while an e-guitar is strumming slightly distorted chords. A male voice is singing in the mid-range. The whole recording sounds clean but is not a high professional recording. This song may be playing at a local festival. | 2013-11-17T18:02:36Z | Sascha Weins | Chief Rockhead -- Lit my Soul From the Album - Came to Stray Get the Album here: http://www.chief-rockhead.de/music.php?lang=de Published by -- spell on you! records Written & Performed by - Chief Rockhead Camera & Editing - Sascha Weins Many Thanks to: Blues Rock Garaasj - www.blues-rock-garaasj.nl Tom Engels - Tor2 Studio - www.tomengels.de De Rots Antwerpen - www.de-rots.be Karken MSF - www.msf-karken.de AUE Open Air - www.aue-openair.de The Pogs - www.irish-pup-mg.de Night Live Düsseldorf - www.dae-spiegel.de www.chief-rockhead.de www.spell-on-you.de www.elvis-productions.de | ["Music", "Rock music", "Progressive rock", "Grunge"] | ["rock&roll", "acoustic drums", "e-bass", "e-guitar", "male mid range singer", "semi professional recording", "medium to uptempo"] | 6 | pWZqzEpygE0 | 4716 | |
FUNK MONSTERS SUPER 70´s MEDLEY | A male voice is singing a melody in the midrange sounding like having fun while doing so. Backing vocals are shouting at the end of his phrase. In the background you can hear the instruments playing funky melodies; rhythms and grooves. What stands out is a flute playing a flute melody sounding like a traditional chinese melody and digital strings are playing in the midrange. This song may be playing celebrating graduation with costumes. | 2008-10-29T19:50:41Z | dodefonk | FUNK MONSTERS | ["Funk", "Music", "Happy music"] | ["funk", "e-bass", "acoustic drums", "piano", "transverse flute", "digital strings", "e-guitar", "male voice singing", "medium to uptempo", "positive energy"] | 6 | tUZB_Xf1m6k | 5040 | |
Tweet feat Missy Elliott - Thugman aka Steady Thug (Reggae Mash Up by Dedy Dread) | A female voice is singing soulfully. She gets support from several backing vocals singing harmonies along. A tambourine is holding the rhythm along with a bassline and a e-guitar giving the song a reggae feeling. This song may be playing in a car. This is an amateur recording. | 2012-01-01T12:10:38Z | Bismarck126 | Putting this vocal to this old Studio One rhythm (Larry and Alvin's 'Your Love', originally) is inspired. | ["Music", "Maraca"] | ["r&b/reggae/soul", "female soul voice", "backing voices", "tambourine", "e-bass", "e-guitar", "medium to uptempo", "relaxing vibe"] | 6 | uTfLf1Y8hhM | 5117 | |
ARCHIE BELL & THE DRELLS - DANCING TO YOUR MUSIC (GLADES) | This song contains acoustic drums playing a groove along with an e-bass and a tambourine. A brass section is playing along with the drum fills and the bongos. A piano is playing a melody together with a guitar strumming chords in the mid range. The male singer sounds loud and soulful. This song may be playing in a rollerblade disco. | 2011-09-16T12:58:50Z | EddiesSoulSounds | More early 70's brilliance. This one from Texas giants Archie and the Drells who released this cracking mid-tempo dancer on the Miami based Gllades label from 1972. Great stuff! | ["Swing music", "Music", "Musical instrument", "Reggae", "Song"] | ["r&b/soul", "e-bass", "brass section", "e-guitar", "bongos", "acoustic drums", "male voice singing", "tambourine", "piano", "medium to uptempo"] | 6 | vx5iuWuE2Ng | 5220 | |
The Sunshine Underground - Put You In Your Place | This song contains a male voice repeating the same melody in a loop while another male voice is singing on top in a higher register. An acoustic drum is holding a four on the floor groove with a kick on every beat. The e-bass and e-guitar are playing along to the loop, repeating themselves. This song may be playing at a live concert downtown. | 2006-04-17T19:07:34Z | TomasTurbado | Videoclip indie rock | ["Electronic music", "Guitar", "Music", "Musical instrument", "Rock music", "Grunge", "Plucked string instrument"] | ["rock", "e-guitar", "e-bass", "male voices singing", "acoustic drums", "medium to uptempo"] | 6 | x7tOPTm31tQ | 5305 | |
Myanmar Gospel Song New: ဆာလံ ၂၃ | This song contains acoustic drums playing along with a bass creating a folksong atmosphere along with an accordion like sounding instrument. A piano and guitar are playing a melody along with an accordion -like instrument taking the main melody from the instruments. Female voices are singing at a higher pitch. This song is in poor audio-quality. This song may be playing live at a church. | 2013-09-19T14:11:27Z | Samuel Thio | Let's sing joyfully and praise our Lord. May the Lord bless you dear friend. ဒီသီခ်င္းကို ၾကည္ခဲ့ရင္ ၾကည့္ခဲ့တဲ့ အေၾကာင္းအသိေပးေပးပါ။ | ["Gospel music", "Christian music", "Music"] | ["gospel/folk", "amateur recording", "acoustic drums", "e-bass", "female voices singing", "piano", "e-guitar", "accordion", "medium to uptempo"] | 6 | yOVaak2hemM | 5405 |
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;