Agriculture Production Data in Pennsylvania 1850 census PA Historical and Museum Commission

Agriculture has guided Pennsylvania's economic growth and cultural development and has profoundly shaped the lands and people of the Commonwealth. The 1850 Federal Decennial Census was the first time in history that data was collected on agricultural production at a national scale. The census manuscripts for Pennsylvania were digitized by PHMC from the original documents in the collections of the National Archives and Records Administration.

This dataset includes agricultural production data compiled from Schedule 4 - Productions of Agriculture of the 1850 census and aggregated at the county and municipality level.

The visualization combines a timeless practice with the latest advancements in technology. The interactive map of Pennsylvania depicting the value of farms and amounts of livestock provides users with a glimpse into agricultural life in 1850.

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/agriculture-production-data-in-pennsylvania-1850-a5ik-vwk6\".\"agriculture_production_data_in_pennsylvania_1850\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.