Foreign-Born Population By Metro Area By Year (2019) Department of Community & Economic Development
The population living in selected Pennsylvania Metro Areas who were born in a foreign country, compared to Pennsylvania.
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/foreignborn-population-by-metro-area-by-year-2019-6a8w-u999\".\"foreignborn_population_by_metro_area_by_year_2019\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.