musiccaps_details (view)

1 row where musiccaps_aspects contains "mellow instrumental", musiccaps_author = 3 and musiccaps_names contains "Theremin"

✎ 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
MINI ELECTRONIC THEREMIN MUSICAL INSTRUMENT Unboxing & Build - made by Gakken of Japan The clip features calm instrumentation, led by a theremin. The percussion is simple and derivative of hip hop. The tune is a sort of calm, soothing kind. 2015-01-11T17:41:50Z Museum of Working Miniatures Japan for the win once again!! It was always going to be the home of the working miniature, but when The Curator found this little diamond on his travels, it really sets the musical bar higher! The mini electronic Theremin kit by Gakken of Japan, is just all-round cool. Coming as a magazine with ready-to-assemble parts, you can create a true working miniature electronic instrument. The Theremin is widely used in science fiction for its eerie electronic sound, but its also considered a true orchestral instrument. So join us with The Curator as he showcases and assembles this miniature marvel from Japan - and who knows? He may even give us a tune (of sorts) Colin will also no doubt be trekking on through we imagine. SHARE, LIKE & SUBSCRIBE to keep the videos coming out of The Museum! Check out our blog at http://www.workingminiatures.com for more info, or you can follow us on: Facebook http://www.facebook.com/WorkingMiniatures Twitter http://www.twitter.com/MoWM_Curator Google+ - https://plus.google.com/+Workingminiatures ["Music", "Theremin"] ["instrumental piece", "theremin", "mellow instrumental", "chill instrumental", "soothing instrumental", "simple hip hop style drum beat", "fuzzy high pitched instrument", "hollow echoing piano sounds"] 3 fFYMsrMGQtU 3937

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;