musiccaps_details (view)
1 row where musiccaps_aspects contains "grunge tones", musiccaps_aspects contains "people dancing" and musiccaps_author = 1
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Pioneer DJ DDJ-SB2 Official Introduction | The song is an instrumental. The tempo is medium with a DJ creating cool rhythmic structures; groovy drum rhythm, percussion hits, grunge tones and staccato notes. The song is exciting and energetic. The song is a techno dance tune. | 2015-08-10T07:24:41Z | Pioneer DJ | https://www.pioneerdj.com/en/product/controller/ddj-sb2/black/overview DJs now have uncompromised control, with the launch of the DDJ-SB2 professional entry-level controller for Serato DJ Intro and Serato DJ. The two-channel DDJ-SB2 boasts all the features of the original DDJ-SB – including Filter Fade, Performance Pads and advanced features not usually available at this price point – and adds trim pots, level meters, the Pad Trans beat effect and 4-deck control. The DDJ-SB has been hugely popular, thanks to its intuitive, plug-and-play control of Serato DJ Intro (free) and Serato DJ (paid upgrade), which offers features including iZotope FX, Slip Mode, record and a host of expansion packs. The controller’s innovative Filter Fade lets DJs mix seamlessly, adjusting the volume and high pass filter with just one hand. So they’ve got a spare hand to unleash their creativity – using the tactile Performance Pads and buttons to trigger samples, FX, loops and cues. Now the DDJ-SB2 adds pro-DJ features usually found on top-flight controllers, including trim pots and level meters to control the volumes on each channel. Also new at this price point are four-deck control and the quantized Pad Trans Pad beat effect, which cuts the volume in time with the BPM when the DJ hits the Performance Pads. The USB-powered DDJ-SB2 is more compact and portable than its pro-DJ stable mates, the DDJ-SX2 and DDJ-SZ, but offers the same intuitive layout, high-quality build, and many advanced features. The DDJ-SB2, bundled with Serato DJ Intro, is available from September 2015 Find out more: http://www.pioneerdj.com Music used: Dave Silcox – Everything - Zerothree https://pro.beatport.com/track/everything-original-mix/5692264 Evol Waves – Inferno – Protocol Recordings https://pro.beatport.com/track/inferno-original-mix/5967078 Low Steppa – The Dub 97 – Simma Black https://pro.beatport.com/track/the-dub-97-original-mix/4636151 Nicky Romero – Symphonica (Bare Remix) - Protocol Recordings https://pro.beatport.com/track/symphonica… | ["Electronic music", "House music", "Music", "Electronic dance music"] | ["dj", "electronic dance music", "groovy rhythms", "sensuous", "dance all night", "ibiza party", "turntable", "cool and sophisticated", "syncopated rhythms", "grunge tones", "instrumental music", "medium tempo", "people dancing", "pulsating tones", "groovy sounds", "dance club", "dance floor", "people dancing", "staccatto tones", "home studio", "song fade"] | 1 | diSfkEkTVkE | 3808 |
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;