musiccaps_details (view)
1 row where musiccaps_aspects contains "noisy" and "youtube_published" is on date 2012-01-09
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;