musiccaps_details (view)
2 rows where musiccaps_aspects contains "out of tune" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- out of tune · 2 ✖
- atonal 1
- blues licks 1
- clean tone 1
- dissonant 1
- harpsichord 1
- old music box 1
- recorder 1
- single notes 1
- solo electric guitar 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 |
---|---|---|---|---|---|---|---|---|---|---|
Awesome 1957 Silvertone Danelectro 1317 Electric Guitar | solo electric guitar music with a clean tone. The guitar is slightly out of tune. The music mostly consists of single notes as opposed to chords. The guitar plays blues licks. | 2007-07-25T00:59:20Z | LarryLeeHolman | Joe Diehl, again, puts a vintage Electric Guitar through its Paces. This Guitar is for Sale on eBay: just search for member kayak4aoj , then look for items for sale or call 1.800.673.0310 A piece of Danelectro Silvertone History can Be Yours. Nat Daniels would Be Proud. Groove On Brother Play On Drummer | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["solo electric guitar", "clean tone", "out of tune", "blues licks", "single notes"] | 8 | CKEPPcaCjbw | 1351 | |
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
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;