musiccaps_details (view)

1 row where musiccaps_aspects contains "crackling", musiccaps_aspects contains "dramatic", musiccaps_aspects contains "vinyl" and musiccaps_author = 4

✎ 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
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

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;