published_press (view)
4 rows where title = "The Boston Globe"
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 |
|---|---|---|---|---|---|---|---|---|
| 6 | 1 | 2007-08-24 13:44:36 | The Boston Globe | 2008-08-24 | http://www.boston.com/ae/music/articles/2007/08/24/beyond_borders/ | 1 | 1 | It's the sound of music without limits, made by a band reveling in its own vast creative potential and the cumulative collision of its early influences. |
| 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. |
|
| 96 | 1 | 2016-05-06 09:50:42 | The Boston Globe | 2016-05-04 | https://www.bostonglobe.com/arts/music/2016/05/04/hallelujah-hills-maintain-winning-streak/EF7rgmyd3P6pW0RJ98rSjJ/story.html | 1 | 12 | Hallelujah the Hills has racked up its share of war stories through more than 10 years of making music on the Boston scene, accruing a body of work that reflects Walsh’s interest in energetic, sometimes-shambolic rock music with a sly sense of humor embedded within. |
| 129 | 1 | 2019-12-17 00:31:52.550000 | The Boston Globe | 2019-12-12 | https://www.bostonglobe.com/2019/12/13/arts/another-true-story-hallelujah-hills-frontman-ryan-walsh/ | 1 | 15 | The result is an album unlike anything Hallelujah the Hills has done. |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW published_press as select * from music_press where publish;