musiccaps_details (view)
3 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "synth lead melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- energetic 3
- flat male vocal · 3 ✖
- low quality 3
- punchy kick · 3 ✖
- synth lead melody · 3 ✖
- electro 2
- punchy snare 2
- boomy bass 1
- claps 1
- dj scratching 1
- energetic crash cymbal 1
- exciting 1
- flat female vocal 1
- groovy 1
- groovy bass guitar 1
- mono 1
- noisy 1
- reverberant metallic impact 1
- rock 1
- shimmering cymbals 1
- shimmering hi hats 1
- wide electric guitar chords 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jabbawockeez - Run This Town | The low quality recording features an electro song played on a device that produces the mono sound only. The song features a flat male vocal rapping, after which there is a drop that consists of punchy kick and snare hits, shimmering cymbals and synth lead melody. It sounds exciting and energetic, while the recording is noisy and in mono. | 2010-01-15T02:49:51Z | imajhaynation | http://jbwkz.com | ["Singing", "Scratching (performance technique)", "Music"] | ["low quality", "electro", "flat male vocal", "punchy kick", "punchy snare", "shimmering cymbals", "synth lead melody", "energetic", "exciting", "noisy", "mono"] | 4 | AzGtPHlrlzU | 1187 | |
DJ Shiftee in Total Kontrol with Z2 and MASCHINE | Native Instruments | The low quality recording features an electro song being scratched by a DJ. The song consists of synth lead melody, punchy kick, claps, boomy bass and reverberant metallic impacts. It sounds groovy and energetic. | 2012-12-12T16:05:30Z | Native Instruments | Watch DJ Shiftee perform a standout scratch routine in a New York warehouse -- with Traktor Kontrol Z2 and Maschine. On the Z2, Shiftee works it with Remix Decks, post-fader effects, and Traktor Pro's new Macro FX and Flux Mode. He also shows how he uses Maschine to control the same Remix Decks and cue points set up on the Z2, making it the ultimate performance partner to the world's first 2+2 control mixer. More about Traktor Kontrol Z2: http://www.native-instruments.com/z2-dj-mixer More about Maschine: http://www.native-instruments.com/maschine More DJ Shiftee: http://facebook.com/djshiftee http://twitter.com/djshiftee 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", "House music", "Music"] | ["electro", "low quality", "dj scratching", "flat male vocal", "synth lead melody", "punchy kick", "claps", "boomy bass", "energetic", "reverberant metallic impact", "groovy"] | 4 | UDTsCTLkZzc | 2897 | |
I've Got My Glasses On 👓 Wearing Glasses Song for Children 🧐🤓😎 The Wiggles | The low quality recording features a rock song that consists of a flat male vocal and flat female vocal talking, followed by punchy kick and snare hits, shimmering hi hats, energetic crash hits, wide electric guitar chords, groovy bass guitar and synth lead melody. It sounds energetic. | 2013-02-07T23:21:04Z | The Wiggles | Subscribe to our channel for more Wiggly videos: http://ab.co/WigglesYouTube For more Wiggly fun: Website ► http://TheWiggles.com.au Facebook ► http://facebook.com/TheWiggles Twitter ► http://twitter.com/TheWiggles Instagram ► http://instagram.com/TheWiggles Spotify ► https://ab.co/TheWigglesSpotify US & UK Shop ► https://thewigglestore.com/ AUS Shop ► https://thewigglestore.com.au/ #glasses #kidsglasses #thewiggles | ["Music", "Independent music", "Speech"] | ["low quality", "rock", "flat female vocal", "flat male vocal", "energetic crash cymbal", "groovy bass guitar", "wide electric guitar chords", "synth lead melody", "shimmering hi hats", "punchy kick", "punchy snare", "energetic"] | 4 | b-Y-AjW6MJ0 | 3594 |
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;