pa-gov/pennsylvania-historical-markers-historical-and-xt8f-pzzz
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

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.

 
Preview
  • pennsylvania_historical_markers_historical_and
     
     
     
     
     
Upstream Metadata