musiccaps_details (view)

1 row where musiccaps_aspects contains "punchy "4 on the floor" kick", musiccaps_names contains "Music" and musiccaps_names contains "Techno"

✎ View and edit SQL

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
Lidless Sound - Simbala Mix2010.12.18. The Techno track features a punchy "4 on the floor" kick pattern, punchy snare, groovy bass, alongside echoing synth keys, short haunting synth lead and weird percussive sound effects. It is groovy and energetic. 2011-03-20T11:04:51Z Lidless Sound SIMBALA is a Deep Dub and Deep Techno label - Our label is for us a platform for beauty, dance, experimental, and every nuances that the spectrum of music has to offer.For this first EP, we want to share with you who we are, what we love and what we will do. The name of the flight that marked the beginnings of Lidless Sound was naturally chosen. He travels through music to Detroit, Chicago, Berlin and many other places in the world. He wanted to share this ubiquity by choosing artists from around the planet. Naturally, one the main references in the world of deep house and techno was chosen. He created an inspiring abstract dubby remix. Banfield Audio as friends and music lovers were exactly in the vein of the artistic direction of the mix: Deep, deep, deep. Experimented and sensitive, they gave to /Surround me/ an abyssal atmosphere that fits perfectly with the whole . Underground quality was searched we hope we found it. Now, listen, share and enjoy. Mixed by Lidless Sound. ["Music", "Techno", "Drum machine", "Electronica"] ["techno", "punchy \"4 on the floor\" kick", "punchy snare", "groovy bass", "echoing synth keys", "short haunting synth lead", "weird percussive sound effects", "groovy", "energetic"] 4 X7LrhZX4rdU 3162

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;