published_press (view)

1 row where "date" is on date 2009-01-20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: publish_on (date), date (date)

id publish publish_on title date source_url quote release_id body
20 1 2009-01-20 15:36:23 The Boston Globe 2009-01-20 http://www.boston.com/ae/music/articles/2009/01/20/dear_leader_rises_up_with_feeling/ 1  

Accented by cello and brass, HTH delivered a dynamically charged set of literate indie rock that filtered the free-associative wordplay of Guided By Voices through the antediluvian old-time feel of the Decemberists.

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW published_press as
select * from music_press where publish;