69100 County FIPS Code

Rota Municipality

Commonwealth of the Northern Mariana Islands · Active county or equivalent

FIPS code 69100 is Rota Municipality, Commonwealth of the Northern Mariana Islands. The state FIPS code for Commonwealth of the Northern Mariana Islands is 69. This code is used in Census Bureau, BLS, EPA, HUD, and USDA federal datasets to identify this county.

County FIPS

69100

State FIPS

Urban/Rural

Nonmetro — completely rural

RUCC 9

How This FIPS Code Works

69 100

69 = State FIPS (Commonwealth of the Northern Mariana Islands)

100 = County FIPS

The 5-digit FIPS code 69100 is formed by combining the 2-digit state identifier 69 (Commonwealth of the Northern Mariana Islands) with the 3-digit county identifier 100. Together they uniquely identify Rota Municipality in every US federal dataset. No two counties share the same 5-digit FIPS code.

Federal Datasets Using Code 69100

FIPS code 69100 appears as the county identifier in the following federal datasets. Analysts joining data across these sources use this code as the common geographic key.

Census Bureau ACS American Community Survey — demographics, income, housing for Rota Municipality Decennial Census Population counts from the 2020 and 2010 Census BLS QCEW Quarterly Census of Employment and Wages — jobs and payroll by county EPA Environmental Air quality monitors, Superfund sites, water data by county HUD Fair Market Rents Section 8 FMRs and housing assistance — county level USDA ERS Economic Research Service — county-level agricultural and rural data BEA Personal Income Bureau of Economic Analysis — per capita income by county CDC Health Statistics County-level mortality, disease, and health outcome data CMS Medicare Data Centers for Medicare & Medicaid Services county utilization data

Using FIPS Code 69100 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 69100

import requests

url = "https://api.census.gov/data/2022/acs/acs5"
params = {
    "get":  "NAME,B19013_001E,B01003_001E",
    "for":  "county:100",
    "in":   "state:69",
    "key":  "YOUR_CENSUS_API_KEY",
}
r = requests.get(url, params=params)
data = r.json()  # [[header...], [Rota Municipality, Commonwealth of the Northern Mariana Islands, income, pop, ...]

SQL — filtering by county FIPS 69100

-- 5-digit combined FIPS (state + county)
SELECT * FROM your_table WHERE county_fips = '69100';

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

-- ⚠ Never cast to integer — leading zeros are lost:
-- county_fips = 69100 is WRONG for this county

R — tidycensus 69100

library(tidycensus)

get_acs(
  geography = "county",
  variables = c(income = "B19013_001E", pop = "B01003_001E"),
  state     = "69",
  county    = "100",
  year      = 2022
)

Zero-padding reminder: FIPS codes must always be stored and compared as zero-padded strings. 69 (not 69) and 100 (not 100) — losing the leading zeros is one of the most common data-join bugs in federal datasets. Full guide →

ZIP Codes in Rota Municipality

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 Rota Municipality. Why FIPS ≠ ZIP →

ZIP Code	Land area share	County land total	% in county
96951	100.0%	—	100.0%

Other Counties in Commonwealth of the Northern Mariana Islands

Northern Islands Municipality 69085 Saipan Municipality 69110 Tinian Municipality 69120