published_press (view)
2 rows where quote = 1 and title = "The Line of Best Fit"
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 |
|---|---|---|---|---|---|---|---|---|
| 76 | 1 | 2014-12-18 22:19:12 | The Line of Best Fit | 2014-05-06 | http://www.thelineofbestfit.com/reviews/albums/hallelujah-the-hills-have-you-ever-done-something-evil | 1 | 10 | Dizzying, heaving at its brim, full of ideas both lyrical and musical |
| 119 | 1 | 2019-11-25 10:29:11.733000 | The Line of Best Fit | 2019-11-19 | https://www.thelineofbestfit.com/reviews/albums/hallelujah-the-hills-im-you-album-review | 1 | 15 | 9/10. Ties up everything they've been working towards into one glorious hour-long burst. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW published_press as select * from music_press where publish;