musiccaps_details (view)
25 rows where musiccaps_aspects contains "scratching" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 151 ✖
- scratching · 25 ✖
- turntable 11
- electronic drums 10
- amateur recording 8
- urban 8
- dj 7
- dj mixer 5
- dj performance 5
- fast tempo 5
- instrumental 5
- dance 4
- hip 4
- upbeat 4
- club music 3
- energetic 3
- groovy 3
- hip-hop 3
- hiphop 3
- male vocal sample 3
- turn table 3
- aggressive 2
- ambient sounds 2
- background music 2
- breakbeat 2
- catchy riff 2
- dj set 2
- e-bass 2
- electronic music 2
- enthusiastic 2
- hip-hop breakbeat 2
- hollering sample 2
- live performance 2
- live recording 2
- male voice singing 2
- modern sound 2
- slow tempo 2
- strong bass 2
- synth 2
- techno music 2
- abrupt change 1
- acoustic drums 1
- acoustic guitar 1
- amplified guitar 1
- backing drums 1
- backing track 1
- beat repeat 1
- beeping melody 1
- booming 1
- boomy 1
- catchy vocal riff 1
- chaotic 1
- chattering sounds 1
- cheering hooting 1
- child female voice 1
- clicking sound 1
- congas 1
- dance music 1
- dangerous 1
- death industrial 1
- digital bass 1
- digital drum 1
- digital drum beat 1
- digital drums 1
- dirty sound 1
- disco 1
- drum & bass 1
- drums 1
- e-guitar 1
- eerie 1
- electric guitar 1
- electric guitar riff 1
- electro 1
- electro music 1
- electronic dance music 1
- electronica 1
- empty shells falling 1
- energetic energy 1
- goth rock 1
- groovy bass 1
- groovy bass line 1
- guitar sample 1
- gunshots 1
- hard rock 1
- hard style 1
- hardcore house 1
- hardcore techno 1
- harsh 1
- heavy metal 1
- high pitch 1
- hip-hop beat 1
- home recording 1
- hyper 1
- incoherent audio 1
- intense 1
- intense drumming 1
- keyboard harmony 1
- kids performance 1
- laid back atmosphere 1
- live audience 1
- loud electric guitar feedback 1
- male voice 1
- male voice sample 1
- male voices speaking 1
- medium fast tempo 1
- medium tempo 1
- medium to uptempo 1
- mellow drums 1
- muddled music 1
- muffled music 1
- new age music 1
- noisy 1
- people talking 1
- percussive sounds 1
- phonograph record 1
- poor audio quality 1
- power electronics 1
- psychedelic 1
- pulsating 1
- rap 1
- repetitive 1
- resonating 1
- reverb 1
- rhythmic 1
- robotic sounds 1
- rotating platform 1
- screeching 1
- sharp sound 1
- sitar sample 1
- slower tempo 1
- spirited 1
- static 1
- synth arpeggio 1
- techno pop 1
- thumping beats 1
- trance 1
- trap 1
- turntablist 1
- uptempo 1
- urban sound 1
- vibrations 1
- vigorous 1
- vigorous keyboard 1
- vinyl disc 1
- vinyl record 1
- vinyl record scratching 1
- vinyl records 1
- violence 1
- violent aggressive 1
- vocal samples 1
- voice sample 1
- youthful 1
musiccaps_names (array) 19 ✖
- Music · 25 ✖
- Scratching (performance technique) 18
- Scratch 11
- Beatboxing 3
- Speech 3
- Drum machine 2
- Electronic music 2
- Hip hop music 2
- Musical instrument 2
- Sampler 2
- Drum and bass 1
- Heavy metal 1
- Inside, large room or hall 1
- Inside, small room 1
- Outside, rural or natural 1
- Progressive rock 1
- Reggae 1
- Ringtone 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
tenminmix 2009 jump up drum and bass | This is a drum & bass music piece. There is a constantly repeating hollering sample accompanied by rapid turntable scratching. A synth sound can be heard playing an ominous tune. The rhythmic background consists of a fast-tempo electronic drum beat. The atmosphere is energetic. This piece could be used in the soundtrack of a car racing game. It could also be playing at nightclubs during early-2000s themed parties. | 2009-09-12T09:36:43Z | morbid1980 | another fresh mini mix from myself....little bit of scratching at the start as well tracklisting tantrum desire - electric brain cabbie - come in cabbie - woke up erb n dub - bass deli j - fight club DP - day off catch my sets on www.reflectfm.net | ["Scratching (performance technique)", "Drum and bass", "Music", "Scratch"] | ["drum & bass", "electronic dance music", "hollering sample", "scratching", "synth", "electronic drums", "upbeat", "energetic", "eerie"] | 9 | -Dtir74TiUM | 28 | |
System Of A Down - Chop Suey (Pinkpop Festival 2002) | This song is a vigorous metal instrumental. The tempo is fast with intense drumming, fiery electric guitar riff, amplified guitar rhythms and energetic keyboard accompaniment. The music is energetic, aggressive, youthful, spirited, goth, intense,psychedelic and trance like. This instrumental is Hard Rock/Metal. | 2008-07-10T10:54:28Z | innervis1on | Chop Suey + La Isla Bonita (Cover). Live @ Pinkpop Festival 2002 | ["Heavy metal", "Music", "Progressive rock"] | ["intense", "vigorous", "loud electric guitar feedback", "intense", "psychedelic", "trap", "trance", "hard rock", "enthusiastic", "energetic", "spirited", "hyper", "fast tempo", "goth rock", "heavy metal", "amplified guitar", "intense drumming", "chattering sounds", "scratching", "screeching", "vigorous keyboard"] | 7 | -dVgUSrR8g4 | 68 | |
Scratching with iPhone App "Baby Scratch" | This audio contains someone scratching to a backing drumtrack. This song may be playing at home demonstrating an app to someone. | 2010-03-03T14:03:57Z | MarcFloat | Baby Scratch is a free App available at Apple AppStore. Made a little try out as handling is pretty amazing with awesome sample sound. App has 3 build in beat loops and some samples and voice recording to scratch. Latency of scratch sounds is noticeable but still best of all checked scratch Apps. | ["Scratching (performance technique)", "Music"] | ["amateur recording", "scratching", "backing drums", "medium tempo"] | 6 | 1LA64TXatWk | 262 | |
Dj Bicchio "Scratching with Duca" | This music is an instrumental with a groovy rhythm. The audio is of inferior quality making the sound muddled and difficult to comprehend. There is a steady rhythm in the background with the sound of a turn table, scratching , a catchy riff on the electric guitar and some sound caused by disturbance in electrical energy. | 2007-10-17T21:52:00Z | sistahduka | Dj Bicchio "Scratching with Duca" | ["Scratching (performance technique)", "Music", "Scratch"] | ["instrumental", "fast tempo", "keyboard harmony", "digital drum beat", "scratching", "catchy riff", "electric guitar riff", "muddled music", "home recording", "amateur recording", "sharp sound", "vinyl records", "scratching", "dj", "dj mixer", "clicking sound", "static"] | 7 | 5tt_GKV13G0 | 704 | |
Dj QBert freestyle scratch on "The Sound Of The Sitar" (G.Bonson) | This is the live recording of a DJ performance. The DJ is modifying a hip-hop beat with the use of a turntable through the scratching technique. A repeated sitar sample can be heard in the beat. There is a strong and groovy bass line in the background. The rhythmic structure consists of a slightly fast-paced hip-hop electronic drum beat. There is a modern sounding, urban feel to it. This piece could be playing in the background at a sportswear shop. It could also be played at sports venues. | 2014-10-12T16:50:58Z | G BONSON | Yeah ! Mr Dj QBert scratching on one of my beats !!! This was a really cool moment ! Merci Monsieur ! :) #honored! @ Le Temps Machine / Joué-Les-Tours / France Original track : "The Sound Of The Sitar" from "The Dust & The Incense" EP Watch the clip: https://www.youtube.com/watch?v=n3mtFjwRSpU&list=PLbn6PlbvBH8s0PvVagt3VUR8YDqPdEoIl More music on gbonson.fr | ["Scratching (performance technique)", "Music", "Scratch"] | ["dj performance", "live recording", "scratching", "hip-hop breakbeat", "turntable", "sitar sample", "electronic drums", "strong bass", "dance", "groovy", "urban", "hip", "modern sound"] | 9 | 6EwEo0JQkTg | 736 | |
The Producer Of Whoop Rico | This is a hip-hop beat. There is a turntable scratching sound and a hollering sample constantly repeated in the beat. Later on, a synth sound can be heard taking part in the melodic structure. The rhythm is provided by an electronic drum beat. The atmosphere is hip and aggressive. | 2008-03-14T21:45:30Z | YUNGPIMP1 | im dj gb the fight dj wanna know why they call me the fight dj this is why... | ["Scratching (performance technique)", "Music", "Scratch", "Drum machine"] | ["hip-hop beat", "turntable", "scratching", "hollering sample", "electronic drums", "synth", "hip", "aggressive", "urban"] | 9 | 6L8066DGqcA | 747 | |
2007 - DJ Miya Jima (Japan) - DMC World DJ Final | This song contains someone scratching over a Hip-Hop track. The track contains acoustic drums with a rim-shot as snare and congas playing along. The e-bass and an e-guitar are playing the same lines in the lower register. This song may be playing live at a scratching contest. | 2013-11-18T10:27:09Z | DMC World Championships | DJ Miya Jima (Japan) DMC World DJ Finals 2007 Indig02, The 02, London. www.dmcworld.com www.dmcdjchamps.com www.facebook.com/dmcdjchamps www.twitter.com/dmc_dj_champs | ["Electronic music", "Music", "Scratch", "Speech", "Inside, large room or hall"] | ["hiphop", "scratching", "e-guitar", "acoustic drums", "congas", "e-bass", "male voice sample", "slow tempo"] | 6 | 8oTTgXIO0-I | 946 | |
DJ Sara - Scratch Practice 【2015】 | This music is a youthful instrumental. The tempo is fast with a DJ using a turntable to manipulate sounds and music on a turntable using vinyl records. The music has a repetitive, catchy vocal riff , thumping beats and scratching sounds. | 2015-07-30T05:03:51Z | djsararyusei scratch | Sara (16 years old) | ["Scratching (performance technique)", "Beatboxing", "Music"] | ["instrumental", "fast tempo", "turn table", "thumping beats", "catchy vocal riff", "repetitive", "rotating platform", "phonograph record", "vinyl disc", "disco", "club music", "catchy riff", "dj", "dj mixer", "scratching"] | 7 | Cd7JefC6-Zw | 1384 | |
Next Generation Dj's | This is an amateur recording of a little girl performing on a turntable. The girl can be heard talking to the person behind the camera. There is a repeating male vocal sample and an electronic drum beat in the piece that is playing. There is an urban atmosphere to the track. | 2007-09-25T18:48:01Z | Masta Hanksta | Time coded vinyl $20.00 bucks. Needles Stanton's $30 bucks a pair. Numark Mixer $99.99 Watching my daughters scratch priceless. | ["Scratching (performance technique)", "Music", "Scratch", "Speech"] | ["amateur recording", "child female voice", "dj performance", "male vocal sample", "turntable", "scratching", "electronic drums", "urban sound"] | 9 | DQzg3cZeYSw | 1476 | |
Delayed Prism Scratch By Syndrum | This is the recording of a DJ performance. In the rhythmic background, the electronic drums are playing a simple yet groovy beat. The DJ is scratching the turntable rapidly over this track. The piece is danceable. It has a dirty mix. Parts of this piece can be used as turntable samples for a beat. It could also be used in the soundtrack of a show with a big city setting. | 2008-01-11T16:54:01Z | entoure | delayed prisms | ["Music", "Scratch"] | ["dj set", "scratching", "turntable", "electronic drums", "dirty sound", "groovy", "dance", "urban"] | 9 | Fa1c4qfBqzE | 1652 | |
Cep Telefonu Melodileri/cell phone melody Ringtones | This music is an aggressive instrumental . The tempo is fast with a violent yet melodic tune that dips suddenly to the sound of gunshots and the metallic sound of empty shells hitting the ground. This music is a violent, harsh, loud, and violent Hard Electronica. | 2008-10-26T11:26:23Z | sanalyonetmen | Cep Telefonu Melodileri/cell phone melody riringtones | ["Ringtone", "Music", "Hip hop music"] | ["instrumental", "fast tempo", "electronic music", "beeping melody", "abrupt change", "violence", "harsh", "power electronics", "hard style", "death industrial", "techno music", "gunshots", "empty shells falling", "dj", "dj mixer", "turn table", "scratching", "violent aggressive", "techno pop", "electronica", "dangerous", "hardcore techno", "hardcore house", "aggressive"] | 7 | LnL3KFKGqHE | 2220 | |
vestax vci-100 scratching | Someone is skillfully scratching turntables along to a backing track with drums, bassline and synthesizer sounds. This recording is of poor audio-quality. | 2009-10-13T14:31:17Z | christophteschner | Vestax VCI-100 MIDI controller with new Mac DJ software "djay 3" from algoriddim: http://www.djay-software.com | ["Scratching (performance technique)", "Beatboxing", "Music", "Scratch"] | ["scratching", "background music", "amateur recording", "upbeat"] | 6 | R6mhBqTU0Tc | 2672 | |
DJ Scratch Set Live (from EPMD Reunion Show in NYC) | This music is instrumental. The tempo is fast with incoherent music playing loudly with the sound of a vinyl record being scratched on a turntable. There are ambient sounds of people talking, hooting and cheering. This music is a DJ live in action. | 2006-11-10T19:06:43Z | grandgood | Recorded live at BB Kings 10.14.06 | ["Scratching (performance technique)", "Music", "Musical instrument"] | ["instrumental", "fast tempo", "poor audio quality", "incoherent audio", "chaotic", "noisy", "vinyl record", "ambient sounds", "people talking", "cheering hooting", "dj", "dj mixer", "turntable", "scratching", "muffled music", "energetic", "enthusiastic", "club music", "dance music"] | 7 | W3DwueAy65k | 3058 | |
DJ Kids Scratching! | This is a DJ performance recording of two kids scratching a turntable. The turntable is being scratched over a hip-hop breakbeat that consists of a loud electronic drum beat. The atmosphere is danceable and there is an urban sound. This piece could be played at sports venues. It could also be sampled for use in beat-making. | 2007-09-14T19:58:53Z | valentinesday01 | this little dudes get down on the turntables!! Yeah they're bad asses. For those who continue to say it's fake check out their page: Sarahscratch. Their names are DJ Sara and DJ Ryusei. | ["Scratching (performance technique)", "Music"] | ["dj performance", "live recording", "kids performance", "turntable", "scratching", "hip-hop breakbeat", "electronic drums", "dance", "urban", "upbeat", "modern sound"] | 9 | WiAFUo2nxIk | 3129 | |
Tearing in a Flare | This is a live DJ performance. There is a groovy bass line and a mellow electronic drum beat in the rhythmic background accompanied by the tune of a melodic guitar sample. The turntable is used to make a scratching sound over this track. There is an urban feeling to this piece. It could be used in the soundtrack of a crime movie/TV show taking place in the big city. It could be used in the background of an interesting sports video. | 2011-10-06T09:04:12Z | YoshiTTR | B4B TV on Facebook: http://www.facebook.com/B4Btv B4B TV on Twitter: http://www.twitter.com/B4Btv This is a kind of scratch that I'd imagine Rafik, D-Beam, WSQ and Master's Voice might do. | ["Scratching (performance technique)", "Music"] | ["dj set", "live performance", "scratching", "turntable", "groovy bass", "mellow drums", "guitar sample", "urban"] | 9 | XYOnq7ju7o0 | 3194 | |
DJ Q-Bert "Method Man" scratch 2009 | This music is instrumental. The tempo is medium fast with boomy bass, turntable scratching and digitally arranged music. The music is muffled as the audio quality is inferior but the beats are punchy, buoyant, bouncy, youthful, groovy and energetic. This music is a turntable scratching technique. | 2009-09-16T00:20:26Z | Trikpah | DJ Q-Bert live 2009 | ["Scratching (performance technique)", "Music", "Musical instrument", "Hip hop music"] | ["instrumental", "medium fast tempo", "boomy", "live performance", "live audience", "ambient sounds", "reverb", "resonating", "robotic sounds", "turn table", "scratching", "dj", "dj mixer", "club music", "pulsating", "vibrations", "booming", "vinyl record scratching", "youthful", "new age music", "techno music", "electro music", "percussive sounds", "rhythmic", "turntablist", "hip-hop", "rap"] | 7 | YJKZVSvz1Bk | 3274 | |
Selflessness & Tattoo | This audio seems to contain two songs. In the beginning someone is strumming chords on acoustic drums while a male voice is singing in a high pitch. Then the song switches to a robotic voice sample singing. Then a digital drum comes in with a fat kick and bass sound creating the base together with the vocal sample. In the background you can hear scratching sounds. This song may be playing while working out. | 2015-09-11T05:36:12Z | Nick Bare | SUBSCRIBE TO MY CHANNEL: http://full.sc/1GSFia3 SUPPORT MY COMPANY: www.bareperformancenutrition.com "INSTA10" - 10% off online store APPAREL: http://bareperformancenutrition.spreadshirt.com/ FACEBOOK: http://facebook.com/bareperformancenutrition TWITTER: http://twitter.com/BPN_Supplements INSTAGRAM: http://instagram.com/bareperformancenutrition MYFITNESSPAL: http://myfitnesspal.com/barepn For Business Inquires Only: nick@bareperformancenutrition.com Intro by Kenny Gonzales KGBgraphics www.youtube.com/kgbgraphics | ["Music", "Theremin", "Outside, rural or natural"] | ["amateur recording", "electro", "digital drum", "digital bass", "voice sample", "scratching", "male voice singing", "high pitch", "acoustic guitar", "medium to uptempo", "energetic energy"] | 6 | eZrrzGgTpfk | 3882 | |
DJ DTROY Scratching on Stanton STR8-150 and SA5 Allies Allstar Battle Mixer | Someone is scratching turntables to a backing track coming out of a speaker. This is an amateur recording. This song may be playing at home practicing alone. | 2010-03-07T22:59:24Z | MrDJdtroy | I am a convert, Stanton STR8-150 is my setup. Bye-Bye to Technics SL1210 ! I stopped DJing for approximately 12 years due to commitments in life. However I managed to get a few hours to spare in the week, therefore I couldnt help myself as I had to start DJing again one more time! I got my new DJ set-up which are by Stanton. Unusual as it may seem for people that know me as a DJ because I usually would go for Technics or Vestax. However, I must say these decks are awesome! They are great for freestyling. Anyway, here is a demo of what they can do. Sorry about the sound quality as there was no mic input on my camcorder. DJ DTROY... | ["Scratching (performance technique)", "Music"] | ["scratching", "backing track", "amateur recording", "upbeat"] | 6 | f6H0TMWDaZg | 3921 | |
Chris Paul - Here comes the Hotstepper | This song contains a drumbeat with a funky bassline. A male voice is singing in a higher range. in the background you can hear different voice samples and scratching. This song may be playing while cruising down the street in your car. | 2008-02-07T18:29:09Z | LUXfinest | My Chris Paul Mix | ["Music", "Reggae"] | ["hiphop", "drums", "scratching", "e-bass", "vocal samples", "male voice singing", "laid back atmosphere", "slower tempo"] | 6 | h9zF09TMgLU | 4081 | |
DJ MARCO-HOW TO SCRACH WITH VIRTUAL DJ | This is the recording of a DJ performance. The DJ is performing on a turntable using the scratching technique. The beat in the background has a repeating male vocal sample and a groovy bass sound. The rhythmic background consists of an electronic drum beat. The atmosphere is urban. This piece could be used in the soundtrack of a teenage drama TV series that takes place in the ghettos of a big city. | 2006-10-31T08:01:06Z | ANARCHYE | WWW.MYBAND.RO\DJ MARCO | ["Scratching (performance technique)", "Music"] | ["dj performance", "turntable", "scratching", "hip-hop", "male vocal sample", "groovy bass line", "electronic drums", "hip", "urban"] | 9 | hgJK2ZDgWtU | 4125 | |
D-Styles and Mr. Cerdan scratch session | Someone is scratching along to a hip hop style backing song containing digital drums and a synth arpeggio sound playing in the midrange. Two male voices are speaking. This song may be playing while practicing scratching. | 2014-07-02T00:33:05Z | connah jay | Celsius's studio with D-Styles and Skratch Lounge Seattle crew. Shout out to Skratch Lounge, Skratcher Portland, D-Styles, Celsius, DJ Foodstamp, Mr. Cerdan, PJilla, Jude and Estylz! Portland 6/29/2014 | ["Scratching (performance technique)", "Music", "Scratch", "Speech", "Inside, small room"] | ["amateur recording", "hiphop", "scratching", "male voices speaking", "synth arpeggio", "digital drums", "uptempo"] | 6 | iTV3Otwq_dI | 4189 | |
DJ BabeyDrew Scratch Practice.m4v | This is an electronic music piece performed by a DJ. There is a heavy use of the turntable adding the repeated scratching effect. A male voice sample can be heard alongside the scratching. In the backing track there is an electric guitar playing the melody while a simple electronic drum beat provides the rhythmic background. | 2010-08-28T20:10:40Z | babeydrewmusic | DJ BabeyDrew Quick Scratch Practice 8.28.10 | ["Scratching (performance technique)", "Sampler", "Beatboxing", "Music"] | ["dj", "electronic music", "turntable", "scratching", "electronic drums", "electric guitar", "male voice"] | 9 | q9DzO_I4dXg | 4757 | |
Scratch Break #13 - Sound Waves - (feat. Dopez & DJ Symatic) | This is a breakbeat from a DJ set performance. The DJ is using the turntable to repeat the male vocal sample and add the scratching effect. In the background, the electronic drums and a strong bass are providing the rhythmic background at a medium tempo. It has a groovy, urban atmosphere. This performance could be used in a crime movie or a TV show with an urban ghetto setting. | 2014-09-25T06:07:42Z | Swiftstyle | Twitter https://twitter.com/swift_style Instagram http://instagram.com/swiftstyle Facebook https://www.facebook.com/swiftstyle Scratch Break 13 featuring the homies Dopez (TX) & DJ Symatic (UK) Had a great time making this one. Hope you enjoy the edit!! Hit us up online!! Swiftstyle www.instagram.com/swiftstyle www.facebook.com/swiftstyle Twitter @swift_style Dopez www.instagram.com/dopez1200 Twitter @Dopez1200 Dj Symatic www.facbook.com/si.symatic | ["Scratching (performance technique)", "Music"] | ["dj", "scratching", "breakbeat", "turntable", "male vocal sample", "electronic drums", "strong bass", "dance", "groovy", "urban"] | 9 | qOTk01gmrRo | 4783 | |
DJ K-SWIZZ 2014 DMC ONLINE WORLD FINALS | This is a DJ performance piece. The DJ is scratching the turntable over a breakbeat sample. The constantly shifting electronic drums are in the rhythmic background. There is a beat repeat effect added on the beat in the background. The atmosphere is urban. This piece could be playing in the background of a basketball skills compilation video. | 2014-08-19T12:16:37Z | DJ REMINISE | Thanks everyone for the kind comments & support, I hope you like my set. Ive been djing for 8months & Ive just turned 11years old. Im a huge fan of A-track so I did a tribute for him @ 1:17min https://www.facebook.com/djkswizz | ["Electronic music", "Music", "Scratch"] | ["dj performance", "turntable", "scratching", "hip-hop", "breakbeat", "beat repeat", "electronic drums", "hip", "urban"] | 9 | uqUNGNZoxrg | 5139 | |
NUMARK NS7 SCRATCH SESSION 3 ( ELEVATED SOUNDS ) DJ INCREDIBLE HOKE | Someone is scratching along with a backing track that contains a strong kick, a snare and a dark sounding melody. This is an amateur recording. This song may be playing at home practicing scratching. | 2009-04-07T07:46:07Z | hok3 | TESTING OUT THE NUMARK NS7 CONTROLLER. THIS THING IS THE SHIT... | ["Scratching (performance technique)", "Sampler", "Music", "Scratch", "Drum machine"] | ["scratching", "background music", "amateur recording", "slow tempo"] | 6 | ura8EjHjGC4 | 5140 |
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;