musiccaps_details (view)
21 rows where musiccaps_aspects contains "hip hop", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "punchy kick"
This data as json, CSV (advanced)
musiccaps_aspects (array) 103 ✖
- hip hop · 21 ✖
- low quality · 21 ✖
- punchy kick · 21 ✖
- punchy snare 14
- shimmering hi hats 13
- groovy 12
- energetic 10
- flat male vocal 6
- noisy 6
- groovy bass 5
- clapping 3
- claps 3
- exciting 3
- mono 3
- muffled 3
- addictive 2
- boomy 808 bass 2
- boomy bass 2
- brass melody 2
- dj scratching sounds 2
- easygoing 2
- muddy 2
- shimmering open hat 2
- shimmering shakers 2
- soft crash cymbal 2
- synth lead melody 2
- upbeat 2
- addictive plucked strings melody 1
- animated music video 1
- arpeggiated synth melody 1
- background male ad libs 1
- background male vocals 1
- blood spillage sound effects 1
- boomy 1
- bouncy 1
- bouncy hi hats 1
- bright 1
- buzzy synth lead 1
- camera shuttering sound effects 1
- chill 1
- chimes bells 1
- dj scratching 1
- dj scratching sound effect 1
- dj scratching vinyl 1
- dry flat male vocal 1
- echoing male vocal 1
- echoing whispering vocal 1
- electric guitar melody 1
- emotional 1
- filtered female vocal 1
- filtered male vocal 1
- fruity male vocal 1
- funky electric guitar 1
- groovy piano chords 1
- groovy piano melody 1
- groovy synth keys melody 1
- grunting sound effects 1
- haunting 1
- low pitched male vocal 1
- low toms 1
- man yelling 1
- manic 1
- mellow arpeggiated piano melody 1
- mellow piano chord progression 1
- passionate 1
- passionate female vocal 1
- people chattering 1
- phone dialing sound effects 1
- plastic tapping sounds 1
- poor mix 1
- punchy muffled snare 1
- quiet snare hits 1
- repetitive synth chords 1
- repetitive wooden percussive elements 1
- reverberant 1
- reverberant female vocal melody 1
- reverberant vocal chant 1
- reversed crash cymbal riser 1
- short flat female vocal 1
- short toms roll 1
- simple hi hats 1
- siren sound effect 1
- slap snare 1
- sloppy 1
- strings power chords 1
- stuttering filter modulated synth riser 1
- stuttering synth chords 1
- sustained filter mod bass 1
- sustained strings melody 1
- sword slicing sound effect 1
- syncopated open hat 1
- synth keys melody 1
- thin 1
- tinny percussive elements 1
- tinny wooden percussive elements 1
- unnatural mix 1
- uptempo 1
- uptempo hi hat triplets 1
- user busy sound effect 1
- weird funny repetitive percussion 1
- wide arpeggiated synth melody 1
- wide reverberant flat male vocal 1
- wide shimmering bells 1
musiccaps_names (array) 23 ✖
- Music 20
- Hip hop music 8
- Scratching (performance technique) 6
- Rapping 4
- Scratch 3
- Electronic music 2
- Funk 2
- Soul music 2
- Tender music 2
- Dance music 1
- Dial tone 1
- Ding-dong 1
- Drum and bass 1
- Drum machine 1
- Folk music 1
- Happy music 1
- Rhythm and blues 1
- Sampler 1
- Single-lens reflex camera 1
- Speech 1
- Steelpan 1
- Synthesizer 1
- Wail, moan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fortune Family - Young Hearts (Official Music Video) | The Low Quality Hip Hop song features a dry, flat male vocal rapping over punchy kick layered with shimmering open hats, punchy kick, simple hi hats, claps, syncopated snare hits, wide arpeggiated synth melody and stuttering synth chords. It sounds energetic and kind of unnatural, since the vocal is so detached from the instrumental due to the bad mixing of the song. | 2011-08-08T23:13:33Z | FortuneFam | Fortune Family is back with a new single "Young Hearts," directed by Ryan Do and presented by ThisSongIsSick.com. http://www.facebook.com/FF610 http://www.twitter.com/FortuneFamily Young Hearts samples Rod Stewart's "Young Turks." Download Link http://www.mediafire.com/?xem05efdcddgwqn For management and booking, contact Nick McCarthy at dpreppp@gmail.com | ["Funk", "Music", "Dance music", "Soul music", "Happy music"] | ["low quality", "dry flat male vocal", "punchy kick", "shimmering open hat", "simple hi hats", "soft crash cymbal", "stuttering synth chords", "wide arpeggiated synth melody", "clapping", "hip hop", "unnatural mix", "energetic"] | 4 | 2kcSUBkFbaQ | 404 | |
Breakin Part 1, Final Dance Battle | The low quality recording features a hip hop song that consists of a flat male vocal rapping over punchy kick and snare hits, shimmering hi hats, DJ scratching sound effects and groovy bass. It sounds energetic, upbeat and groovy. | 2009-12-10T11:29:51Z | babeygurl05 | Final dance battle at the club, Ozone, Turbo and Kelly win! | ["Scratching (performance technique)"] | ["low quality", "hip hop", "punchy snare", "dj scratching sounds", "punchy kick", "groovy bass", "flat male vocal", "shimmering hi hats", "upbeat", "groovy", "energetic"] | 4 | A5fPSkTvjmY | 1067 | |
Prizm scratch easy explained. | The low quality recording features a DJ that scratches his vinyl hip hop song. The song consists of punchy snare and kick hits, bouncy hi hats and boomy bass. It is noisy, uptempo, energetic and it sounds a bit sloppy. | 2008-04-30T16:41:13Z | Dj Fast-M | All in the video. | ["Scratching (performance technique)", "Music"] | ["low quality", "noisy", "dj scratching sound effect", "hip hop", "punchy snare", "uptempo", "boomy bass", "punchy kick", "bouncy hi hats", "energetic", "sloppy"] | 4 | B32m9Jqqrpo | 1198 | |
scratch "Funky Lesson" freestyle scratch フリースタイルスクラッチ | The low quality recording features a DJ scratching a hip hop song that consists of punchy kick and snare hits, shimmering hi hats and syncopated open hats. There are some plastic tapping sounds. The recording is noisy, in mono and it sounds groovy. | 2008-01-31T12:56:53Z | Juni Dope Fresco | just practice scratch with both hands | ["Scratching (performance technique)", "Funk", "Music", "Scratch"] | ["low quality", "hip hop", "dj scratching sounds", "punchy kick", "punchy snare", "shimmering hi hats", "syncopated open hat", "noisy", "mono", "plastic tapping sounds", "groovy"] | 4 | FmytwY7SAfU | 1665 | |
Edo Maajka Feat Alejuandro Buendija - Boing | The low quality recording features a hip hop song that consists of flat male vocals, alongside background male ad libs, rapping over boomy bass, punchy kick, slap snare, shimmering hi hats, tinny percussive elements and weird, funny and repetitive percussion. It sounds groovy and boomy, but also muddy and poorly mixed. | 2009-03-24T12:32:06Z | interist89 | Edo Maajka Feat Alejuandro Buendija - Boing | ["Music", "Rhythm and blues", "Hip hop music"] | ["low quality", "hip hop", "reverberant vocal chant", "boomy bass", "punchy kick", "slap snare", "flat male vocal", "shimmering hi hats", "tinny percussive elements", "weird funny repetitive percussion", "groovy", "background male ad libs", "poor mix", "boomy", "muddy"] | 4 | GOujNXEtDmg | 1716 | |
New York State Of Mind - Cuban Link, Poe Rilla & Mysonne (OFFICIAL VIDEO) | The low quality recording features hip hop song that contains a low pitched male vocal singing over some camera shuttering sound effects, after which an echoing male vocal starts rapping over punchy kick and snare hits, low toms, electric guitar melody, reversed crash cymbal riser and shimmering hi hats. It sounds groovy. | 2011-07-02T06:00:06Z | 326MUZIK | 3.2.6 Muzik Presents Cuban Link, Mysonne & PoeRilla.... Ny State Of Mind !!! Directed By Picture Perfect Produced By The Salazar Brothers | ["Music", "Single-lens reflex camera", "Hip hop music"] | ["low quality", "low pitched male vocal", "camera shuttering sound effects", "punchy kick", "punchy snare", "electric guitar melody", "reversed crash cymbal riser", "shimmering hi hats", "echoing male vocal", "hip hop", "groovy", "low toms"] | 4 | I06TOd9pXng | 1861 | |
Trying To BREAK a Windshield w/ LOUD Sound System BASS | GLASS Window Car Audio FLEX | The low quality recording features a hip hop song, that consists of flat male vocal rapping over widely spread shimmering bells, punchy kicks and claps, playing in the background. Right before the beat drops there is a short flat female vocal. There are some people talking to each other, while one of them is yelling. It sounds noisy and haunting and energetic thanks to the song. | 2012-02-27T23:00:08Z | EXOabigdeal | Keith's Jeep attempting to break the windshield on 40,000 watts - hovering around the 164db mark! Also added some cool footage from a big 3X event back in the day - ENJOY :) Thanks For Rating & Subscribing! http://www.youtube.com/EXOabigdeal 1st Song: "Down South Choppers" By L-Ement 2nd Song: "Young Pimpin" By MWO Beats 3rd Song: "Riot Boy" By L-Ement L-Ement's Channel & Facebook http://www.youtube.com/user/lement24kproductions http://www.facebook.com/lement MWO Beats' Channel http://www.youtube.com/user/MWObeatz Keith's SPL Sound System 2 18" T3 TSNS Subs 4 Soundstream XXX 10,000 Watt Amps RMS Range : 40,000 Watts Burping Frequency : 58 to 62 hz EXOcontralto Bassheads Unite 2012 | ["Music", "Ding-dong"] | ["low quality", "wide shimmering bells", "noisy", "people chattering", "man yelling", "flat male vocal", "short flat female vocal", "punchy kick", "clapping", "hip hop", "energetic", "haunting"] | 4 | OvX68hqDjeA | 2480 | |
Roy Jones Jr - I Smoke I Drank | The low quality recording features a hip hop song that consists of a wide reverberant flat male vocal rapping over synth lead melody, sire sound effects, punchy kick, boomy 808 bass, claps and shimmering hi hats. It sounds exciting, energetic and addictive - like something you would hear in clubs. | 2008-10-03T14:48:46Z | Body Head Entertainment Films | Roy Jones Jr, Youngbloods and Body Head Bangerz | ["Music", "Rapping", "Hip hop music"] | ["low quality", "hip hop", "synth lead melody", "siren sound effect", "punchy kick", "boomy 808 bass", "claps", "shimmering hi hats", "wide reverberant flat male vocal", "energetic", "exciting", "addictive"] | 4 | RmDfwz0OG8E | 2723 | |
Skibadee + Bashy MC FACEOFF 1XTRA | The low quality recording features a hip hop song where a fruity male vocal is rapping over punchy kick and snare hits, shimmering hi hats, groovy bass and brass melody. It sounds bouncy, groovy and upbeat. | 2007-04-17T08:17:05Z | danshish | Skibadee + Bashy MC FACEOFF on 1XTRA then some other mc's | ["Drum and bass", "Electronic music", "Music", "Rapping", "Hip hop music"] | ["low quality", "hip hop", "fruity male vocal", "brass melody", "punchy kick", "punchy snare", "shimmering hi hats", "groovy bass", "groovy", "bouncy", "upbeat"] | 4 | YZvv4hOlNqw | 3294 | |
Turntablist legend DJ Craze Performs on TRAKTOR SCRATCH PRO and KONTROL X1 | Native Instruments | The low quality recording features a hip hop song that consists of punchy snare and kick hits, shimmering hi hats and buzzy synth lead, played by a DJ that manually made beat breaks, which resulted in stuttering filter modulated synth riser. It sounds energetic and exciting thanks to that riser. | 2010-05-12T09:52:06Z | Native Instruments | 5x DMC World Champion DJ Craze takes things to the next level in this new turntablism routine, using TRAKTOR SCRATCH PRO and the KONTROL X1 controller. Using the X1, Craze simultaneously triggers cue points on both decks, while still staying true to his roots with some serious beatjuggling. By combining traditional vinyl techniques like juggling, scratching and body tricks with advanced controller-based functions such as cue point manipulation, tempo-synced effects and ultra-quick track changes, this performance showcases the cutting edge of turntablism and controllerism using the latest digital DJing technology. DJ Craze on Myspace: http://www.myspace.com/crazearoni For more information on TRAKTOR and KONTROL X1, please see http://www.native-instruments.com Link section: Subscribe to our YouTube channel https://www.youtube.com/user/NativeInstruments https://www.facebook.com/NativeInstruments General info Native Instruments is a leading manufacturer of software and hardware for computer-based audio production and DJing. The company's mission is to develop innovative, fully-integrated solutions for all musical styles and professions. The resulting products regularly push technological boundaries and open up new creative horizons for professionals and amateurs alike. For more info visit our website: https://www.native-instruments.com | ["Scratching (performance technique)", "Electronic music", "Music"] | ["low quality", "hip hop", "punchy snare", "punchy kick", "buzzy synth lead", "shimmering hi hats", "stuttering filter modulated synth riser", "energetic", "exciting"] | 4 | aCA4yiPfFIg | 3519 | |
The "Java Life" Rap Music Video | The low quality recording features a hip hop song that consists of flat male vocals, alongside echoing whispering vocals, rapping over shimmering hi hats, punchy kick, boomy 808 bass, claps, quiet snare hits and arpeggiated synth melody. The song sounds energetic, especially because of the uptempo hi hat triplets. | 2011-10-03T02:14:24Z | Java | This original rap music video made for JavaOne 2011 celebrates the "Java Life". Dedicated to the developer homies everywhere who code hard day and night. Think Java programmers meet street Hip Hop. | ["Music", "Rapping", "Hip hop music"] | ["low quality", "hip hop", "echoing whispering vocal", "flat male vocal", "shimmering hi hats", "boomy 808 bass", "punchy kick", "claps", "quiet snare hits", "arpeggiated synth melody", "energetic", "uptempo hi hat triplets"] | 4 | b-Cr0EWwaTk | 3593 | |
Tona - Dial Tone | The low quality recording features a hip hop song that contains a phone dialing sound effects, alongside filtered female vocal talking as the user is busy on the phone. In the second half of the loop, there are punchy kicks and snare hits playing. It sounds groovy and energetic overall. | 2007-06-22T05:47:30Z | King Sampson | Tona's video Dial Tone. First single off of his Dont Holla Ep. Bring it back tone.......set it set it. | ["Dial tone", "Music", "Speech", "Hip hop music"] | ["low quality", "hip hop", "noisy", "mono", "punchy kick", "punchy snare", "phone dialing sound effects", "filtered female vocal", "user busy sound effect", "energetic", "groovy"] | 4 | eX1Hynef5Rc | 3874 | |
Jam Master Jay Tribute feat. TJ Mizell & DJ Scratch | The low quality recording features a DJ scratching the vinyl of a hip hop song that consists of punchy kick and snare, repetitive wooden percussive elements, shimmering hi hats and open hats and soft crash cymbals. It sounds manic, energetic and kind of muffled, since it was probably recorded with a poor quality microphone. | 2014-01-22T16:31:25Z | ScratchDJAcademy | TJ Mizell and the renowned DJ Scratch pay homage with a custom routine in front of the Jam Master Jay memorial in Hollis, Queens For more info - www.Scratch.com Like Us - https://www.facebook.com/scratchdjacademy Follow Us - http://instagram.com/scratchdjacademy Tweet Us - https://twitter.com/ScratchDJAcdmy | ["Scratching (performance technique)", "Music", "Scratch"] | ["low quality", "dj scratching vinyl", "hip hop", "punchy snare", "punchy kick", "repetitive wooden percussive elements", "shimmering hi hats", "soft crash cymbal", "muffled", "energetic", "manic"] | 4 | hu6sChY-Yps | 4149 | |
Mali Bang Mag Mahal by CRSP (official music video) | The low quality recording features a hip hop song that consists of a mellow arpeggiated piano melody played over sustained strings melody, chime bell and filtered male vocal in the first half of the loop. In the second half the beat drops and it consists of a punchy kick and snare hits, shimmering hi hats and passionate female vocals singing over. It sounds passionate, groovy and emotional. | 2013-07-04T05:19:16Z | MrRight VEVO | Directed by : Lilcoli Tugista Singer : Still One & Loraine Composed by : Right One Arranged by : Still One & Right One Released : July 2013 | ["Music", "Tender music"] | ["low quality", "hip hop", "mellow arpeggiated piano melody", "filtered male vocal", "sustained strings melody", "chimes bells", "punchy kick", "punchy snare", "shimmering hi hats", "passionate female vocal", "passionate", "emotional", "groovy"] | 4 | jD0nqkyuHPg | 4242 | |
DJ Woody presents 'Polyphonic Scratching' | The low quality recording features a hip hop song that consists of synth keys melody, punchy kick, punchy muffled snare, shimmering open hat and shakers and short toms roll. It sounds groovy and easygoing, like something you would listen to when riding a car. | 2015-06-25T12:39:04Z | DJ Woody / Woodwurk Records | One thing i've always been interested in developing is the melodic use of the turntable, this was advanced by the release of the Vestax PDX 2000 turntable in 2001 with it's increased pitch range and higher torque. I soon discovered that with the PDX it was possible rotate the tone arm a full 360 degrees so i started experimenting with using 2 tone arms on the platter of one turntable. This mainly interested me because it enabled be to control 2 sets of sounds via one turntable platter. In 2003 i was fortunate enough to get involved in the development of the Controller One turntable. This revolutionised what was possible in terms of musically accurate pitch manipulation. However one thing that somewhat frustrated me was the fact that the turntable was still essentially a monophonic instrument, controlling 1 sound or voice at a time. I recently figured out a way utilising Serato DJ and the Rane Sixty Four mixer to controller up to 4 independent sound sources or voices using one turntable allowing me to play and manipulate true chords and create independent melodies from 1 turntable platter (unlike the soon to be released STEMS format.) I've since been informed that this is similar to Traktors 'remix decks'. Not being a traktor user i was unaware however this Serato hack is massively exciting for me and opens up whole new creative door. I'm still learning and discovering the new skill set required for 'polyphonic scratching', needless to say this video is just a starting point. Woody SUPPORT MY WORK Buy records & merch: https://www.woodwurkrecords.com EU vinyl orders & digital scratch tools: https://woodwurkrecords.bandcamp.com Woodwurk Members Club: https://woodwurkrecords.bandcamp.com/subscribe Find me on the web: https://www.instagram.com/djwoodymusic https://www.facebook.com/djwoodymusic https://www.mixcloud.com/djwoodymusic https://www.twitter.com/djwoodymusic https://soundcloud.com/djwoodymusic Bookings & business enquiries contact: djwoodyinfo@gmail.com | ["Music", "Soul music"] | ["low quality", "hip hop", "synth keys melody", "punchy kick", "shimmering shakers", "punchy muffled snare", "shimmering open hat", "short toms roll", "groovy", "easygoing"] | 4 | m4Dj_vTsAt0 | 4443 | |
Whimper | The low quality recording features a hip hop song that consists of groovy bass, groovy piano chords, shimmering hi-hats and punchy kick and snare hits over sword slicing, blood spillage and grunting sound effects. Overall the song is very groovy, bright and judging by the volume of the sounds, it could be an Animated Music Video. | 2012-12-02T16:12:34Z | SaladUK | Xperiment - Stayin' Steady http://www.facebook.com/saladuk http://www.twitter.com/saladuk http://vine.co/saladuk | ["Music", "Wail, moan"] | ["low quality", "hip hop", "groovy bass", "grunting sound effects", "blood spillage sound effects", "animated music video", "sword slicing sound effect", "groovy piano chords", "punchy kick", "punchy snare", "shimmering hi hats", "bright", "groovy"] | 4 | n3X8RGZsGg4 | 4516 | |
Jonny Pow Khaen Lao | The low quality recording features a hip hop instrumental that consists of punchy kick, claps, repetitive synth chords, addictive plucked strings melody and tinny wooden percussive elements. It sounds groovy and very addictive, due to that string melody. | 2011-02-02T03:34:15Z | Jonny Olsen | This is Jonny's theme song. Jonny raps in English and Nyot sings along with a catchy chorus "Jonny Pow Khaen Lao." ຈອນນີ ເປ່ົາແຄນລາວ The second part where Nyot sings is the Sueng Bung Fai melody. Jonny loves to entertain you all and had a fun time teaming up with Nyot Sengathid- Morlum Hip Hop Savannakhet. We can learn about other people's culture. We can share ideas, have fun, and make the world a better place. Lets all get along and love each other. End the hate. Thank you. Album-"Mawlum Hip Hop Lao-America 2010." Jonny is the first Farang or foreigner to ever make and release an album in Laos. He is also the first foreigner to win a khaen competition in Khon Kaen, Thailand 2005. Thank you 🙏❤ | ["Music", "Steelpan"] | ["hip hop", "punchy kick", "claps", "repetitive synth chords", "addictive plucked strings melody", "low quality", "tinny wooden percussive elements", "addictive", "groovy"] | 4 | navn7jCBp_o | 4559 | |
Destruct - Time's Up [Official Music Video] | The low quality recording features a hip hop song that consists of flat male vocals talking over reverberant female vocal melody, punchy snare and kick hits, shimmering hi hats, groovy bass and mellow piano chord progression. It has a lot of reverb on it and it sounds easygoing, chill and groovy - like something you would listen to on a car ride. | 2012-06-29T08:09:36Z | destructmc | Download the album "Leaving yet?" for free @ http://www.destructmusic.com/album/leaving-yet Add Me @ http://www.facebook.com/mcdestruct Follow Me @ https://twitter.com/mcdestruct Guest starring Marz Prod. by Michael Omar Perez Directed by Jacqueline Arevalo DP by Ace Fillmore Edited by Komprza Subscribe now to http://www.youtube.com/destructmc Cop That fresh gear @ http://www.facebook.com/Faktnclothing | ["Music", "Hip hop music", "Tender music"] | ["low quality", "hip hop", "flat male vocal", "reverberant female vocal melody", "punchy snare", "punchy kick", "shimmering hi hats", "groovy bass", "mellow piano chord progression", "easygoing", "chill", "groovy", "reverberant"] | 4 | nrcfdP6LrLo | 4583 | |
Electrum Drum Machine / Sampler for Android devices | The low quality recording features a hip hop song played on a speaker that features groovy piano melody, synth lead melody, strings power chords, punchy snare, shimmering shakers, claps and punchy kick hits. It sounds noisy and thin as it lacks bass frequencies. | 2011-01-30T23:05:05Z | nikotwenty | Video demo of Electrum Drum Machine running on a Samsung Galaxy Tablet. Demonstrating some of the features, especially playing with loading loops unto the drum pads, and switching live between patterns, as well as a small demo of playing the multitouch pad dialog pads. | ["Folk music", "Music"] | ["low quality", "hip hop", "noisy", "thin", "muffled", "groovy piano melody", "synth lead melody", "strings power chords", "punchy snare", "shimmering shakers", "clapping", "punchy kick"] | 4 | wg_kYW4xvz4 | 5282 | |
Fabolous, Jay Z, & Young Jeezy F A B O L O U S Vol 2 Block On Smash | The low quality recording features a hip hop song that consists of a flat male vocal, alongside some background male vocals, rapping over punchy kick and snare hits, shimmering hi hats, funky electric guitar, brass melody, groovy synth keys melody and groovy bass. It sounds energetic, groovy and exciting. | 2009-08-07T17:12:38Z | briellehursl21 | ["Music", "Rapping", "Hip hop music"] | ["hip hop", "punchy snare", "punchy kick", "funky electric guitar", "brass melody", "groovy synth keys melody", "groovy bass", "shimmering hi hats", "flat male vocal", "background male vocals", "energetic", "groovy", "exciting", "low quality"] | 4 | x6U1gX5a_4M | 5304 | ||
scratch session d'astro | The low quality recording features a DJ scratching the vinyl of a hip hop instrumental that consists of punchy kick and snare hits and sustained filter modulated bass. The recording is muffled, noisy, mono and muddy, as it was probably recorded with a phone. | 2006-11-30T11:34:41Z | Jerome GARCIA | petite session scratch... | ["Scratching (performance technique)", "Sampler", "Music", "Scratch", "Drum machine", "Synthesizer"] | ["low quality", "dj scratching", "hip hop", "sustained filter mod bass", "punchy kick", "punchy snare", "muffled", "noisy", "mono", "muddy"] | 4 | zNgRUFOj3HI | 5470 |
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;