musiccaps_details (view)

1 row where musiccaps_aspects contains "harpsichord", musiccaps_aspects contains "out of tune" and musiccaps_names contains "Drawer open or close"

✎ 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
The Roentgens' Berlin Secretary Cabinet Very sounds like an old out of tune mechanical music making machine with harpsichord and recorder sounds. Very dissonant and atonal. 2012-10-25T15:10:45Z The Met Discover the hidden features and intricate interior of this cabinet. One of the finest achievements of European furniture making, this cabinet is the most important product from Abraham (1711--1793) and David Roentgen's (1743--1807) workshop. A writing cabinet crowned with a chiming clock, it features finely designed marquetry panels and elaborate mechanisms that allow for doors and drawers to be opened automatically at the touch of a button. Owned by King Frederick William II, the Berlin cabinet is uniquely remarkable for its ornate decoration, mechanical complexity, and sheer size. This cabinet is from Kunstgewerbemuseum, Staatliche Museen zu Berlin, and is on view at The Metropolitan Museum of Art in the exhibition Extravagant Inventions: The Princely Furniture of the Roentgens Footage courtesy of VideoART GmbH and Kunstgewerbemuseum, Staatliche Museen zu Berlin. ["Music", "Drawer open or close"] ["old music box", "out of tune", "harpsichord", "recorder", "dissonant", "atonal"] 8 MKikHxKeodA 2257

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;