published_press (view)
4 rows where title = "DigBoston"
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 |
|---|---|---|---|---|---|---|---|---|
| 87 | 1 | 2016-01-05 07:20:22.044000 | DigBoston | 2015-12-30 | https://digboston.com/so-this-is-the-new-year-when-and-where-to-see-live-music-on-new-years-eve/ | 1 | The best of folk punk, alt-rock, and political-style punches somewhere between Titus Andronicus and the Hold Steady. |
|
| 92 | 1 | 2016-04-10 14:20:58.037000 | DigBoston | 2016-03-22 | 1 | 12 | bold riffs with emotional lyrics, and storytelling with the gusto of your biggest friend crush |
|
| 98 | 1 | 2016-05-08 17:14:09 | DigBoston | 2016-04-20 | https://digboston.com/video-premiere-hallelujah-the-hills-the-mountain-that-wanted-more/ | 1 | 12 | Hallelujah The Hills’ fifth full-length album…brings their flavor of indie rock back to our ears so we can do air guitar in our bedrooms and learn new lyrics to scream live. There’s chipper synth, succinct drums, and Walsh’s rounded tone of voice that never ruffles your feathers the wrong way. |
| 100 | 1 | 2016-05-23 22:36:54 | DigBoston | 2016-05-12 | https://digboston.com/the-gospel-of-rock-hallelujah-the-hills-still-slay-over-ten-years-later/ | 1 | 12 | In Boston, a city ripe with remarkable rock acts…local treasure Hallelujah The Hills sits at the top of that throne. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW published_press as select * from music_press where publish;