musiccaps_details (view)
2 rows where musiccaps_aspects contains "dark" and musiccaps_aspects contains "warm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- dark · 2 ✖
- low quality 2
- noisy 2
- warm · 2 ✖
- crackling 1
- dark moody piano melody 1
- dramatic 1
- flat male vocal snippet 1
- jazz 1
- mono 1
- muffled snare hit 1
- saxophone solo melody 1
- shimmering cymbals 1
- suspenseful 1
- trombone melody 1
- vinyl 1
- walking double bass 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Children Of The Damned-Don't talk to Frank(Prod. by Lee Scott) | The low quality recording features a dark moody piano melody and at the very end of the loop, a short snippet of muffled snare hit and flat male vocals. It sounds very noisy, as there are vinyl cracklings, but also warm, suspenseful, dark and dramatic - almost like a horror movie melody theme. | 2012-01-09T09:19:33Z | noxious gases | (In Order Of Appearance)... Dilner The Lost Kid, Salar, Monster Under The Bed, Flash 4Dem, Lee Scott, TL, Bill Shakes & Karlos 10th track on... Children Of The Damned-Tourettes Camp(2007) Released 01 June 2007 by BLAH RECORDS The debut from British mega group CHILDREN OF THE DAMNED, a collective who's origins are in Liverpool,London,Runcorn,Blackburn & Accrington. Late night slow burners, smoked-out music for the demented. Features production from Lee Scott, Col. Mustard & Beatgees. Artwork by STMK. Tracklist 01.Damnednation 02.The killing jar 03.It's them 04.Smoke crack if you're wack 05.Ode to nothing 06.What the hook? 07.Crooked 08.Choke 09.Clean living 10.Don't talk to Frank Buy Album On... http://www.suspect-packages.com/artists/a-f/CHILDREN_OF_THE_DAMNED.php & http://cotdblah.bandcamp.com/album/tourettes-camp Youtube Page http://www.youtube.com/user/BlahRecords COTD Pages... http://www.facebook.com/blahrecords http://www.blahrecords.com http://www.youtube.com/blahrecords http://www.myspace.com/blahrecords http://www.twitter.com/blahrecs http://www.facebook.com/blahrecs http://www.cdbaby.com/cd/cotd Peace to COTD from Athens(Greece) | ["Music", "Harmonic"] | ["low quality", "noisy", "crackling", "vinyl", "dark moody piano melody", "muffled snare hit", "flat male vocal snippet", "dark", "suspenseful", "dramatic", "warm"] | 4 | QUB_vpjogmo | 2622 | |
Drought Hack: Paint Your Lawn Green... | The low quality recording features a jazz performance that consists of saxophone solo melody played over shimmering cymbals, followed by trombone melody and walking double bass. It sounds warm, but dark, due to the poor quality microphone it was recorded with. | 2015-07-21T19:18:52Z | AJ+ | Lawn painting is one way Californians are dealing with the drought – literally turning brown lawns green. Fresno lawn painter Josh Cox shows AJ+ how it's not too different from painting a house. From video journalist Jessica Sherry in California. Subscribe for more videos: http://www.youtube.com/channel/UCV3Nm3T-XAgVhKH9jT0ViRg?sub_confirmation=1 Like us on Facebook: https://www.facebook.com/ajplusenglish Download the AJ+ app at http://www.ajplus.net/ Follow us on Twitter: https://twitter.com/ajplus | ["Jazz"] | ["low quality", "mono", "noisy", "shimmering cymbals", "trombone melody", "saxophone solo melody", "walking double bass", "jazz", "warm", "dark"] | 4 | e6lTl9JIW5Y | 3844 |
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;