53033 FipsDecoder
38057 County FIPS Code

Mercer County

North Dakota · County seat: Stanton · Active county or equivalent

View on CensusDepth ↗

FIPS code 38057 is Mercer County, North Dakota. With a population of 8,366 (2022 ACS estimate), it ranks #17 in North Dakota and #2618 nationally. The state FIPS code for North Dakota is 38. This code is used in Census Bureau, BLS, EPA, HUD, and USDA federal datasets to identify this county.

County FIPS

38057

State FIPS

38

ND

Population

8,366

2022 ACS · #2618 nationally

Density

8.0/mi²

people per sq mile

Land Area

1,043

sq miles

Urban/Rural

Nonmetro — rural, adjacent to metro

RUCC 8

How This FIPS Code Works

38 057
38 = State FIPS (North Dakota)
057 = County FIPS

The 5-digit FIPS code 38057 is formed by combining the 2-digit state identifier 38 (North Dakota) with the 3-digit county identifier 057. Together they uniquely identify Mercer County in every US federal dataset. No two counties share the same 5-digit FIPS code.

Census ACS Data for FIPS 38057

From the 2022 ACS 5-year estimates — the same values you'd retrieve by querying the Census API with county FIPS 38057.

Median Household Income

$82,155

ACS B19013_001E

Poverty Rate

9.6%

ACS B17001 (below poverty level)

Median Age

44.0

ACS B01002_001E

Adjacent Counties (5)

Counties that share a border with Mercer County. Useful for regional analysis — these are the geographies you'd typically include when studying labor markets, commuting zones, or environmental spillovers around FIPS 38057.

Federal Datasets Using Code 38057

FIPS code 38057 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 38057 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.

Census ACS API — Python 38057
import requests

url = "https://api.census.gov/data/2022/acs/acs5"
params = {
    "get":  "NAME,B19013_001E,B01003_001E",
    "for":  "county:057",
    "in":   "state:38",
    "key":  "YOUR_CENSUS_API_KEY",
}
r = requests.get(url, params=params)
data = r.json()  # [[header...], [Mercer County, North Dakota, income, pop, ...]
SQL — filtering by county FIPS 38057
-- 5-digit combined FIPS (state + county)
SELECT * FROM your_table WHERE county_fips = '38057';

-- Some datasets store state and county separately
SELECT * FROM your_table
WHERE state_fips = '38'
  AND county_fips = '057';

-- ⚠ Never cast to integer — leading zeros are lost:
-- county_fips = 38057 is WRONG for this county
R — tidycensus 38057
library(tidycensus)

get_acs(
  geography = "county",
  variables = c(income = "B19013_001E", pop = "B01003_001E"),
  state     = "38",
  county    = "057",
  year      = 2022
)
Zero-padding reminder: FIPS codes must always be stored and compared as zero-padded strings. 38 (not 38) and 057 (not 57) — losing the leading zeros is one of the most common data-join bugs in federal datasets. Full guide →

ZIP Codes in Mercer 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 Mercer County. Why FIPS ≠ ZIP →

ZIP Code % in county
58580 100.0%
58541 100.0%
58545 76.0%
58523 70.9%
58571 69.7%
58638 30.2%
58625 27.6%
58631 8.8%
58636 6.1%
58530 0.4%

Other Counties in North Dakota