Pennsylvania Historical Markers, Historical and Museum Commission
Since 1913, the Pennsylvania Historical and Museum Commission has administered a program of historical markers to capture the memory of people, places, and events that have affected the lives of Pennsylvanians over the centuries since William Penn founded his Commonwealth. More than 2,000 bronze plaques and cast aluminum markers tell the stories of Native Americans and settlers, government and politics, athletes, entertainers, artists, struggles for freedom and equality, factories and businesses, and a multitude of other topics. This dataset includes Pennsylvania historical markers by title, dedication date, location, county, category and marker text.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"pa-gov/pennsylvania-historical-markers-historical-and-xt8f-pzzz\".\"pennsylvania_historical_markers_historical_and\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.