Northumberland County
Pennsylvania · County seat: Sunbury · Active county or equivalent
FIPS code 42097 is Northumberland County, Pennsylvania. With a population of 91,340 (2022 ACS estimate), it ranks #32 in Pennsylvania and #651 nationally. Northumberland County is part of the Sunbury, PA. The state FIPS code for Pennsylvania is 42. This code is used in Census Bureau, BLS, EPA, HUD, and USDA federal datasets to identify this county.
County FIPS
42097
Population
91,340
2022 ACS · #651 nationally
Density
199.3/mi²
people per sq mile
Land Area
458
sq miles
Urban/Rural
Nonmetro — urban 20K+, adjacent to metro
RUCC 4
How This FIPS Code Works
The 5-digit FIPS code 42097 is formed by combining the 2-digit state identifier 42 (Pennsylvania) with the 3-digit county identifier 097. Together they uniquely identify Northumberland County in every US federal dataset. No two counties share the same 5-digit FIPS code.
Census ACS Data for FIPS 42097
From the 2022 ACS 5-year estimates — the same values you'd retrieve by querying the Census API with county FIPS 42097.
Median Household Income
$55,952
ACS B19013_001E
Poverty Rate
12.4%
ACS B17001 (below poverty level)
Median Age
44.5
ACS B01002_001E
Metropolitan Area
Adjacent Counties (9)
Counties that share a border with Northumberland County. Useful for regional analysis — these are the geographies you'd typically include when studying labor markets, commuting zones, or environmental spillovers around FIPS 42097.
Federal Datasets Using Code 42097
FIPS code 42097 appears as the county identifier in the following federal datasets. Analysts joining data across these sources use this code as the common geographic key.
Using FIPS Code 42097 in Code
Common patterns for querying federal datasets by this county's FIPS code. The leading zeros are significant — always treat FIPS codes as strings, not integers.
import requests
url = "https://api.census.gov/data/2022/acs/acs5"
params = {
"get": "NAME,B19013_001E,B01003_001E",
"for": "county:097",
"in": "state:42",
"key": "YOUR_CENSUS_API_KEY",
}
r = requests.get(url, params=params)
data = r.json() # [[header...], [Northumberland County, Pennsylvania, income, pop, ...]-- 5-digit combined FIPS (state + county)
SELECT * FROM your_table WHERE county_fips = '42097';
-- Some datasets store state and county separately
SELECT * FROM your_table
WHERE state_fips = '42'
AND county_fips = '097';
-- ⚠ Never cast to integer — leading zeros are lost:
-- county_fips = 42097 is WRONG for this countylibrary(tidycensus)
get_acs(
geography = "county",
variables = c(income = "B19013_001E", pop = "B01003_001E"),
state = "42",
county = "097",
year = 2022
)ZIP Codes in Northumberland County
ZIP codes do not align perfectly with county boundaries — a single ZIP code can span multiple counties, and a county can contain parts of many ZIP codes. The ratios below (from the Census 2020 ZCTA relationship file) show the land area share of each ZCTA that falls within Northumberland County. Why FIPS ≠ ZIP →
| ZIP Code | % in county |
|---|---|
| 17865 | 100.0% |
| 17730 | 100.0% |
| 17749 | 100.0% |
| 17881 | 100.0% |
| 17872 | 100.0% |
| 17860 | 100.0% |
| 17866 | 100.0% |
| 17801 | 100.0% |
| 17868 | 100.0% |
| 17823 | 100.0% |
| 17867 | 100.0% |
| 17830 | 100.0% |
| 17832 | 100.0% |
| 17834 | 100.0% |
| 17836 | 100.0% |
| 17840 | 100.0% |
| 17850 | 100.0% |
| 17851 | 100.0% |
| 17857 | 100.0% |
| 17777 | 96.9% |
| 17847 | 79.9% |
| 17017 | 78.2% |
| 17824 | 43.9% |
| 17941 | 36.3% |
| 17772 | 31.4% |
| 17821 | 23.5% |
| 17756 | 13.5% |
| 17964 | 10.3% |