musiccaps_details (view)
4 rows where musiccaps_aspects contains "dissonant" and musiccaps_author = 8 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- dissonant · 4 ✖
- 8 bit 1
- ambient 1
- atonal 1
- chaotic 1
- children's melody 1
- cold 1
- desolate 1
- digital distortion 1
- experimental 1
- female choir pad 1
- foreboding 1
- harpsichord 1
- harsh 1
- instrumental 1
- low string melody 1
- menacing 1
- metallic 1
- old music box 1
- orchestral 1
- out of tune 1
- random sounds 1
- recorder 1
- reverb 1
- sci-fi 1
- screeching 1
- sinister 1
- space sounds 1
- synthesizer filter sweep 1
- tritone 1
- video game sounds 1
- wooshing 1
musiccaps_names (array) 5 ✖
- Music 4
- Cacophony 1
- Drawer open or close 1
- Scary music 1
- Sonar 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pokemon Blue - Glitchy stuff | Music and random sounds from an old 8 bit video game. A children's melody interspersed with harsh, digitally distorted sounds. Experimental and dissonant to the point of being chaotic. | 2006-11-18T05:07:25Z | Krauser912 | I crossed "illegally" to Route 12 causing the sprites to be messed up. Then I used cheat codes to catch "h poke", which causes a very unusual glitch. | ["Music", "Cacophony"] | ["8 bit", "video game sounds", "digital distortion", "experimental", "children's melody", "random sounds", "dissonant", "harsh", "chaotic"] | 8 | MkPhe7TLLZ0 | 2293 | |
Thirumathi Selvam Episode 1306, 03/01/13 | Sinister sounding orchestral music with a foreboding low string melody using a tritone interval while the high strings and female choir hold a dissonant chord. | 2013-01-03T15:01:01Z | VikatanTV | Thirumathi Selvam, Episode 1306, Tamil Serial , SUN TV, Produced by - Vikatan Televistas Pvt. Ltd. Chennai, INDIA Subscribe http://www.youtube.com/subscription_center?add_user=vikatantv Channel http://www.youtube.com/user/VikatanTV ShowPage http://www.youtube.com/show/thirumathiselvam | ["Music", "Scary music"] | ["foreboding", "menacing", "dissonant", "tritone", "sinister", "orchestral", "low string melody", "female choir pad"] | 8 | OBJM1TqPvu4 | 2410 | |
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 | |
Bad Company - Thin Air | ambient space sounds that are a cold and desolate feeling. Metallic screeching, whooshing distant bells ringing, lots of reverb and a long synthesizer filter sweep. Good for a science fiction film. | 2008-11-12T23:03:47Z | IBGriffith | Bad Company - [HUMA8006-2] Thin Air | ["Music", "Sonar"] | ["ambient", "sci-fi", "space sounds", "screeching", "metallic", "synthesizer filter sweep", "instrumental", "cold", "desolate", "dissonant", "reverb", "wooshing"] | 8 | Xf0aZ3a3Toc | 3206 |
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;