musiccaps_details (view)
13 rows where musiccaps_aspects contains "buoyant" and musiccaps_aspects contains "male vocalist"
This data as json, CSV (advanced)
musiccaps_aspects (array) 185 ✖
- buoyant · 13 ✖
- male vocalist · 13 ✖
- youthful 9
- punchy 8
- fast tempo 6
- keyboard harmony 5
- club music 4
- dj 4
- enthusiastic 4
- medium fast tempo 4
- rap 4
- dance music 3
- dance pop 3
- digital drums 3
- edm 3
- electronic music 3
- hip-hop 3
- synth pop 3
- synthesiser arrangement 3
- synthesiser arrangements 3
- upbeat 3
- acoustic guitar 2
- animated 2
- boomy 2
- catchy 2
- dance groove 2
- digital drum 2
- dj mixer 2
- engaging 2
- groovy 2
- happy 2
- lively 2
- lively vocal backup 2
- passionate 2
- pop 2
- pop rock 2
- psychedelic 2
- rhythmic 2
- slow tempo 2
- tambourine beats 2
- vivacious 2
- vocal backup 2
- affecting 1
- amateur percussionist 1
- animate 1
- animated instrumentation 1
- animated keyboard harmony 1
- atmospheric synthesiser 1
- auto tune 1
- auto tuned voice 1
- bass drum 1
- beat boxing 1
- beep 1
- boomy bass lines 1
- bouncy 1
- brass band 1
- brass instruments 1
- bright 1
- bright electric guitar 1
- burgeoning music 1
- camera roll sound 1
- catchy vocal riff 1
- cello drone 1
- cheerful 1
- cheerfully 1
- club musc 1
- conga 1
- customised song 1
- cymbals 1
- dance floor 1
- digital drum imitation 1
- digital drumming 1
- drum beats 1
- drum machine 1
- electric guitar 1
- electrifying 1
- electrifying music 1
- electro-hop 1
- electronic arrangement 1
- electronic articulation 1
- electronic instrumentation 1
- electronica 1
- emotional 1
- emphatic 1
- energetic 1
- energetic drumming 1
- energetic drums 1
- energetic vocal backup 1
- enthusiastic vocals 1
- excishakers 1
- female vocal backup 1
- female vocal riff 1
- fervent 1
- flute melody 1
- folk song 1
- foreign language 1
- freestyle rap 1
- funk pop 1
- funky 1
- funky bass line 1
- gallopy rhythm 1
- groovy bass 1
- groovy saxophone 1
- hand percussion 1
- hard hitting drums 1
- high-spirited 1
- hip-hop-rap 1
- house music 1
- hypnotic 1
- infectious drumming 1
- insightful 1
- insistent 1
- intense drumming 1
- jazz 1
- jingle 1
- keyboard accompaniment 1
- latin dance hits 1
- latin dance music 1
- latin music 1
- latin pop 1
- latin song 1
- latin urbano 1
- light 1
- lively trumpet 1
- love song 1
- low audio quality 1
- melodic 1
- melodious acoustic guitar rhythm 1
- middle eastern music 1
- mouth and throat coordinated sounds 1
- organ 1
- oud cymbals 1
- peppy 1
- percussions 1
- perky 1
- persuasive 1
- pipe organ 1
- playful 1
- pleasant 1
- pop hit 1
- pop rap 1
- pulsating 1
- punchy bass lines 1
- reflective 1
- reggae 1
- regional music 1
- remix 1
- repetitive 1
- rhythm arrangement 1
- rhythmic beat 1
- rhythmic patter 1
- rhythmic speech 1
- shakers 1
- skilled 1
- slick drumming 1
- slow beginning 1
- soft paino 1
- soft rock 1
- song beginning 1
- southern hip hop 1
- spirited 1
- steady bass line 1
- steady drumming 1
- street vernacular 1
- surround sound 1
- techno hop 1
- teen pop 1
- trap 1
- trippy 1
- turn table 1
- turn table imitation 1
- vibrant 1
- vigorous 1
- vigorous drumming 1
- vital 1
- vocal percussion 1
- vocal percussionist 1
- vocal riff 1
- vocal turntablism 1
- vocalisation 1
- whirring sound 1
- wind instrument 1
- woodwind 1
- world music 1
- youtube video 1
musiccaps_names (array) 16 ✖
- Music 10
- Burst, pop 2
- Song 2
- Beatboxing 1
- Busy signal 1
- Dance music 1
- Funk 1
- Hip hop music 1
- Independent music 1
- Maraca 1
- Music of Africa 1
- Punk rock 1
- Reggae 1
- Scratching (performance technique) 1
- Whoop 1
- Zing 1
youtube_published (date) 12 ✖
- 2010-02-07 2
- 2008-07-17 1
- 2008-11-03 1
- 2009-06-27 1
- 2010-01-02 1
- 2010-10-15 1
- 2013-08-27 1
- 2013-09-09 1
- 2013-09-13 1
- 2013-12-03 1
- 2014-12-15 1
- 2016-08-16 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Slow Bouncin- Juicy J,Trey Songz ft. Wale X Chop Marley | A male vocalist sings this trippy Electronic song. The tempo is slow with synthesiser arrangement, digital drums and electronically articulated music. The song is catchy, youthful, enthusiastic, trippy, psychedelic , new age, and groovy. This song is an Electro -Hop/ Hip-Hop. | 2013-09-13T23:12:07Z | Dab Marley | The Chopstafarian Is back hope y'all like the new tracks......Bless up. | ["Music", "Hip hop music"] | ["male vocalist", "slow tempo", "electronic music", "electro-hop", "edm", "club music", "house music", "electronica", "hip-hop", "techno hop", "synthesiser arrangement", "electronic articulation", "digital drums", "southern hip hop", "punchy", "buoyant", "youthful", "psychedelic", "hypnotic", "trap", "rap"] | 7 | 0RDz0rLakwc | 165 | |
Amazing beatboxing, you won't believe it! (original, full) | This music clip is of a male vocalist doing a beat box. The tempo is medium fast with the vocalist imitating the digital drums, turntable and Dj mixer to a perfection. This vocal percussion is lively, rhythmic, youthful and engaging. | 2010-02-07T14:15:29Z | Karesz Fromvald | This is the uncut, original and full version of the beatboxing, no camera-changing. This guy is beatboxing like you never heard! MUST SEE! He is Joseph Poolpo, he is from France - thanks for the comment. This is a show, called Nouvelle Star, it's like America's Got Talent, the france version of the talent show. What's the best part? Can you do better? Write in the comments section below. I can't believe it's true! Amazing! Really Cool beatboxing! America's got talent THANKS FOR MORE THAN A MILLION VIEWS!!! #48 - Most Viewed - Music - Israel #37 - Most Viewed - Music - France #52 - Most Viewed - Music - Italy #33 - Most Viewed - Music - Czech Republic #30 - Most Viewed - Music - Czech Republic #18 - Most Viewed - Music - Israel #89 - Most Viewed - Israel #58 - Most Viewed - Music - France Thank you. -REUPLOADED | ["Beatboxing", "Music"] | ["vocalisation", "medium fast tempo", "male vocalist", "punchy", "boomy", "buoyant", "rap", "dance groove", "vocal percussionist", "youthful", "rhythmic", "skilled", "engaging", "beat boxing", "turn table imitation", "vigorous", "youthful", "vocal percussion", "vocal turntablism", "mouth and throat coordinated sounds", "dj", "hip-hop-rap", "digital drum imitation"] | 7 | 0abzD7hBTRk | 187 | |
Buffalo Bills "Shout" Song | A male vocalist sings this energetic pop song. The tempo is fast with an animated keyboard harmony, vigorous drumming, punchy bass lines, vibrant tambourine beats and an enthusiastic vocal backup riff. The song is a remix of an old song. It is vibrant, peppy, punchy, vibrant, vociferous. This song is Pop Rock. | 2013-09-09T00:04:40Z | Logan Warner | The Official Buffalo Bills Fight Song Lyrics: The Bills make me wanna SHOUT! Kick your heels up and SHOUT! Throw your hands up and SHOUT! Throw your head back and SHOUT! C’mon now the Bills are makin’ it happen now… Stand up and c’mon and shout.. YEAA-AAAH! YEAA-AAAH! SAY YOU WILL SHOUT it right now baby SAY YOU WILL C’mon c’mon SAY YOU WILL C’mon and SHOUT! SAY YOU WILL YEAAAAAH! SHOUT! Buffalo’s happenin’ now SHOUT! We’re on the move now SHOUT! The Bills are happenin’ now SHOUT! They’re makin’ it happen now SHOUT! We’ve got the spirit SHOUT! A lotta spirit, yea SHOUT! We’ve got the spirit SHOUT! Just watch it happen now... HEEAAAAY! HEEAAAAY! HEEAAAAY! HEEAAAAY! LET’S GO BUFFALO! LET’S GO BUFFALO! LET’S GO BUFFALO! LET’S GO BUFFALO! The Bills make me wanna SHOUT! | ["Music", "Whoop"] | ["male vocalist", "fast tempo", "punchy", "jingle", "remix", "buoyant", "pop", "pop rock", "lively vocal backup", "energetic", "buoyant", "customised song", "cheerfully", "animated keyboard harmony", "tambourine beats", "hard hitting drums", "punchy bass lines", "gallopy rhythm"] | 7 | 1JpeDWbgUO8 | 257 | |
Novo Smartphone Alcatel POP 4 | A male vocalist sings this lively pop. The tempo is fast and peppy with animated trumpets, groovy saxophone, slick drumming, funky bass line, keyboard harmony, synthesiser arrangements and electronic sounds. The song is upbeat, energetic, enthusiastic, youthful, vibrant, effervescent; passionate and electrifying. This song is Synth Pop. | 2016-08-16T22:34:36Z | Alcatel Brasil | Conheça o novo Smartphone Alcatel POP 4. Com tela de de 5", Memória de 40GB, câmera de 13MP e Selfie de 8MP, 4G e ainda vem com 3 Capinhas diferentes. Para mais informações, acesse nosso site oficial: https://www.alcatelshop.com.br/detalhe-produto/smartphone-alcatel-pop4-5-premium-memoria-40gb8mais32-sd-3-capas-camera-13mp-selfie-8mp-flash4g/493310 | ["Music", "Burst, pop"] | ["male vocalist", "fast tempo", "lively trumpet", "synth pop", "funk pop", "electrifying music", "passionate", "vital", "catchy", "engaging", "buoyant", "groovy saxophone", "keyboard harmony", "slick drumming", "synthesiser arrangements", "digital drums", "brass instruments", "wind instrument", "woodwind", "brass band", "rhythmic", "animated", "youthful", "dance music", "club music", "dj", "dance floor", "dance pop", "enthusiastic", "vivacious", "bright"] | 7 | 1pR0SgbqP3M | 313 | |
ROCAFELLA FREESTYLES: PT.1 "WHO SHOT YA?" | A male vocalist sings this passionate Hip-Hop. The tempo is medium fast with synthesiser articulation, digital drumming and turn table effects with vocal backup. The song is enthusiastic, passionate, persuasive, emphatic, emotional , youthful and groovy. This song is a freestyle Hip-Hop. | 2008-11-03T18:30:55Z | Cipha Sounds | CIPHA SOUNDS HAS DUG INTO THE VAULT TO FIND THIS NEVER BEFORE SEEN VIDEO OF THE ROCAFELLA CAMP FREESTYLING ON FUNKMASTER FLEX SHOW ON HOT97 FROM 2001! | ["Scratching (performance technique)"] | ["male vocalist", "medium fast tempo", "persuasive", "insistent", "turn table", "rap", "hip-hop", "dj", "dj mixer", "youthful", "emphatic", "youthful", "rhythmic speech", "rhythmic patter", "street vernacular", "rhythmic beat", "punchy", "buoyant", "freestyle rap"] | 7 | C5Zs-Lb2rIM | 1328 | |
Three Little Birds -Bob Marley- with lyrics HD | A male vocalist sings this light melody. The tempo is medium with a funky bass line, keyboards accompaniment; slick drumming, groovy electric guitar and acoustic guitar riff with female vocal backup. The song is light, punchy, buoyant, groovy, funky,insightful, reflective and melodic. This song is a spirited Reggae song. | 2013-08-27T16:58:35Z | musicaprayer | Bob Marley & The Wailers Three Little Birds with a original animation. If you like this video, give it a thumbs up! Contact me on Facebook! https://www.facebook.com/shohei.yamatsu | ["Funk"] | ["male vocalist", "medium fast tempo", "reflective", "melodic", "keyboard harmony", "groovy", "funky", "youthful", "buoyant", "reflective", "organ", "electric guitar", "acoustic guitar", "steady drumming", "funky bass line", "bass drum", "pipe organ", "light", "playful", "affecting", "insightful", "cymbals", "female vocal backup", "reggae", "jazz"] | 7 | HCCGZh-TxK0 | 1779 | |
► Animash - United State of Pop - MashUp ◄ || Happy New Year ;D || and now 400+ Subbies :) | A male vocalist sings this animated and upbeat pop song. The song starts with a slow tempo with male vocals and soft but emphatic piano accompaniment and cello drone, and a whirring sound like a camera rolling. Post this the song picks up to an upbeat tempo with hard hitting drumming, cymbal rides, upbeat synthesiser harmony and electronic instruments. The song is a ,vibrant, spirited, bouncy, punchy, vivacious, youthful Electronic Dance music/Synth Pop. | 2010-01-02T11:40:42Z | White Liolynx | Edit - on september 13th Huh... I thougt a long time about it, and now... I delete ALL anotations! becasue of problems, too slow video and they were alredy too much! o.o so, hope nobody is angry of me *blush* and thanks you all for 1.000 "likes" on this video =D _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ UPDATE of the January 5th, 2010 : WOW! I get in 3 days 60 new subbies? omfg, THANK YOOOOOOOOOOOOOOOU!! ANNOTATIONS - LINK : - - - (this link is "closed" now, maybe I will write it someday here again xD) hehe, as I saw this remix, I thoght "ooooh my god!...i love it... yay I'm making an animash with it" =D Its for new yeah, but I've had some problems, so its too late =( well, but I hope you like it anyway =) hmm, I think the video looks really simple..but it was hard to work on it =P weeeell... ^^ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ • PROGRAMM : Sony Vegas Pro 9 Song : United State of Pop 2009 (Blame It on the Pop) © DJ Earworm Clips: Bambi 2 Lady and the Tramp 1 and 2 Lion King 1 and 2 Brother Bear 1 Fox and the Hound 1 and 2 Oliver & Co. Aristocats 101 Dalmatians Bolt © Disney/ Pixar Spirit © Dreamworks Balto 1 © Universal All Dogs go to Heaven 2 © MGM Ice Age © Blue Sky Studios HONORS: Second day: #77 - Most Discussed (Today) - Germany #11 - Most Discussed (Today) - Film & Animation - Germany #10 - Top Favorited (Today) - Germany #2 - Top Favorited (Today) - Film & Animation - Germany #20 - Top Favorited (Today) - Film & Animation #24 - Top Rated (Today) - Germany #2 - Top Rated (Today) - Film & Animation - Germany #51 - Top Rated (Today) - Film & Animation #11 - Top Rated (This Week) - Film & Animation - Germany Third day: #50 - Most Discussed (Today) - Germany #4 - Most Discussed (Today) - Film & Animation - Germany #74 - Most Discussed (Today) - Film & Animation #85 - Most Discussed (This Week) - Film & Animation - Germany #46 - Most Viewed (Today) - Germany #86 - Most Viewed (Today) - Film & Animation - Germany #85 - Most Viewed (Today) - F… | ["Music", "Burst, pop"] | ["male vocalist", "slow beginning", "cello drone", "digital drums", "electronic music", "electronic instrumentation", "auto tune", "fast tempo", "edm", "synth pop", "buoyant", "punchy", "vibrant", "animated", "youthful", "spirited", "burgeoning music", "whirring sound", "camera roll sound", "auto tuned voice", "animated instrumentation", "soft paino", "vigorous drumming", "oud cymbals", "vocal backup", "female vocal riff", "song beginning", "pop", "pop rock", "animate", "buoyant", "happy", "lively", "spirited"] | 7 | KMQmM12G9Z4 | 2076 | |
Pig Rock - อ่าง (SD Version) | A male singer sings this melodic pop song. The tempo is fast with an acoustic guitar accompaniment, keyboard harmony, enthusiastic electric guitar melody and intense drumming. The vocals are emphatic and the song is pleasant, catchy, melodious, youthful, buoyant and fresh. This song is Soft Rock/ Pop. | 2010-02-07T21:32:43Z | PigRockBand | PIG ROCK - Arng : The first official music video of new Thais rock band named PIG ROCK. Their first album will be launched in March, 2010. For more info please visit www.sabarnrecords.com Music Video Director / Cinematographer : Sornpat Prakaranunt | ["Music", "Punk rock", "Independent music", "Song"] | ["male vocalist", "bright electric guitar", "buoyant", "soft rock", "teen pop", "pop hit", "youtube video", "melodious acoustic guitar rhythm", "keyboard accompaniment", "pleasant", "teen pop", "love song", "passionate", "emotional", "enthusiastic vocals", "energetic drumming"] | 7 | QutCXtWmzIs | 2649 | |
DJ HumNoy Maraca YouTube | A male vocalist sings this energetic song. The tempo is fast with synthesiser arrangements, punchy digital drumming, tambourine beats and keyboard harmony. The music is upbeat, punchy, groovy, youthful, buoyant and exciting. This song is Synth Pop. | 2013-12-03T12:25:16Z | ณ๊องจุ้น คนเดิม | ["Music", "Song", "Dance music", "Maraca"] | ["male vocalist", "fast tempo", "energetic drums", "synth pop", "buoyant", "tambourine beats", "digital drum", "synthesiser arrangements", "keyboard harmony", "energetic vocal backup", "dj", "dj mixer", "dance pop", "dance music", "club music", "youthful", "enthusiastic", "vivacious"] | 7 | S7rP6coeLTY | 2742 | ||
Simo Issaoui 2008 by WWW.TOP2008.NEW.FR**05** | A male vocalist sings this upbeat song in a foreign language. The tempo is medium fast with a very perky and bouncy beat. The song is happy, cheerful, groovy, simple light and catchy with middle eastern music influences. This song is a contemporary Folk song. | 2008-07-17T18:21:13Z | jamalyoussef2010 | Simo issaoui issawi hyooh nachat guercif jamal youssef super_jamal@hotmail.fr | ["Music of Africa", "Music"] | ["male vocalist", "medium fast tempo", "foreign language", "buoyant", "peppy", "happy", "cheerful", "middle eastern music", "upbeat", "catchy", "synthesiser arrangement", "conga", "hand percussion", "steady bass line", "flute melody", "folk song", "regional music"] | 7 | XCQMJXkI5bA | 3166 | |
Runescape Dungeoneering Guide - Doors [HD] | This song has a male vocalist singing a rhythmic vocal riff to the beat of digital drumming followed by the sound of a beep. The percussion is amateur and the vocals are muffled as the audio quality is inferior. The song is slow tempo and the beat is punchy, groovy, buoyant and youthful. | 2010-10-15T16:30:46Z | adamchrome | This video shows the different doors that you can encounter during a dungeon and how to complete them all. Doors in dungeoneering are very important in exploring the floor as these are the gateways between rooms. You must know how to bypass all the doors you can be faced with in order to fully explore a dungeon. There are 3 main types of doors: Locked doors requiring a key to open Guardian doors protected by the monsters in the room Skill doors blocked by an obstruction requiring a skill and/or item to bypass Locked doors are opened with keys that can be found throughout the dungeon. One player, known as the key holder, should carry all the keys so that it is easy to manage which keys the team has. If a locked door is a very long way away from the starting room and your team doesn't have the correct key, then it is highly advisable for a team member to place a gatestone at the door to avoid time running through the dungeon. --------------------------------------------------- Guardian doors are doors which can't be opened until all monsters in the room have been killed, except for the dinosaurs. When you are clearing a guardian room with your team, there is a certain order that players should kill the monsters, based on their difficulty. As a basic principle, all monsters that can see through the shadow-silk hood should be eliminated first. Even if you don't own a silk hood, other team members will take less damage when they're dead resulting in less food used in the long run. Mages - Mages should be killed first because of their damaging magic attack and their ability to negate the effects of the shadow-silk hood. Forgotten mages and Necromancers fall under this category. Shades - Shades and ghosts are highly dangerous due to their highly damaging range and magic attacks. Demons and other mages - Lesser, greater and black demons hit quite considerable amounts of damage with magic and melee. Spiders - Spiders should be killed after the dangerous mages because of their poisoning ab… | ["Busy signal", "Music"] | ["percussions", "drum machine", "boomy", "catchy vocal riff", "digital drumming", "youthful", "buoyant", "punchy", "bouncy", "dance groove", "amateur percussionist", "male vocalist", "slow tempo", "pop rap", "low audio quality", "rap", "hip-hop", "beep", "drum beats", "rhythm arrangement"] | 7 | YZx0_GRtvJk | 3295 | |
Scotty Dynamo - On A Roll | A male vocalist sings this spirited song. The tempo is fast with a bright keyboard harmony, boomy bass drops, infectious drumming and atmospheric synthesiser and a vocal riff. The electronic arrangements and synthesised sounds give it a psychedelic, trippy, hypnotic vibe. It is perky, buoyant, thumping, youthful, vivacious with a dance groove. This song is an EDM/Synth Pop song. | 2009-06-27T17:02:38Z | ScottyDynamo | Myspace: http://www.myspace.com/scottydynamo Twitter: http://www.twitter.com/scottydynamo Blog: http://scottydynamo.com Recorded at King West Studio, Toronto, Canada. http://kingweststudio.com/ Verse 1: Don't even trip I got you covered like a placemat/ Shorty keep on starin' I'm like can I have my face back/ I can imagine you've won your share of pageants/ Lay down like a carpet shorty I can play Alladin/ My penmanship is baller, got the wordplay of a scholar/ And I've got men insecure because their bank accounts are smaller/ See her dancing in the spotlight steady throwing out her back and/ All I see is cleavage I should call her Janet Jackson/ Chorus: She's on a roll/ The way she drop it makin' profit down the poll/ She make the people at the party lose control/ The way she drop it makin' profit down the poll/ Oh you can tell that primma donna's on a roll/ Verse 2: She's so primma donna in her Dolce & Gabanna/ Shorty I just wanna see you back it up like a Honda/ Oh she chat it up and I appreciate the banter/ Shorty's Puerto Rican so I couldn't understand her/ I'm wildin' out you know my crew is straight orangutanin'/ Never see me talkin' to a hoochie with her fusions hangin'/ I'm fit to be the kind of lover you deserve/ Met your boyfriend at the party he was serving out or d'oeuvres/ Chorus x2 | ["Music", "Zing"] | ["male vocalist", "electronic music", "fast tempo", "vocal riff", "repetitive", "atmospheric synthesiser", "boomy bass lines", "surround sound", "punchy", "buoyant", "upbeat", "vocal backup", "psychedelic", "trippy", "youthful", "enthusiastic", "lively", "keyboard harmony", "synthesiser arrangement", "infectious drumming", "electronic arrangement", "edm", "dance music", "club music"] | 7 | esIzFH7vYLY | 3902 | |
Danza Kuduro Don Omar Ft, Lucenzo, Daddy Yankee, Akon & Pitbull (DJ Ebo Remix) | A male vocalist sings this upbeat Latin pop song. The tempo is fast with infectious drumming, groovy bass line,electric guitar, keyboard harmony, acoustic guitar, shakers,synthesiser arrangement and digital drumming. The song is youthful , energetic,enthusiastic, animated,fervent, pulsating, electrifying ,exciting,and buoyant. This song is a Latin Urbano. | 2014-12-15T01:48:50Z | DJ EBO | Follow ► https://www.facebook.com/BailaReggaetonUK Follow ► https://www.instagram.com/official.djebo ♫ Follow ► https://soundcloud.com/djeboo ♩ | ["Reggae"] | ["male vocalist", "fast tempo", "latin music", "shakers", "latin pop", "pulsating", "electrifying", "buoyant", "fervent", "enthusiastic", "excishakers", "acoustic guitar", "latin song", "latin urbano", "high-spirited", "buoyant", "upbeat", "groovy", "intense drumming", "groovy bass", "synthesiser arrangements", "keyboard harmony", "digital drum", "lively vocal backup", "latin dance music", "dance pop", "club musc", "latin dance hits", "world music", "punchy", "perky"] | 7 | wj4ukZFNEgs | 5285 |
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;