published_press (view)
1 row where quote = 1 and title = "Dig Boston"
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 |
|---|---|---|---|---|---|---|---|---|
| 136 | 1 | 2019-12-31 22:13:14.924000 | Dig Boston | 2019-12-19 | https://digboston.com/stick-to-the-plan-hallelujah-the-hills-went-through-hell-but-returned-for-seventh-lp/ | 1 | 15 | A deep and encompassing sound that pulls you in by the ears and spins you for a walk through bursts of thoughtful lyrics and enchanting harmonies, all built within the framework of firm rock beats |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW published_press as select * from music_press where publish;