US Cities by State

Every U.S. city, town, and village as a free CSV — split by state. 48,490 places compiled from U.S. Census Bureau data and keyed on FIPS.

Maintained by US City List.

Coverage

48,490 places across all 50 states, the District of Columbia, and Puerto Rico. One CSV per state in data/by-state, plus a combined data/us-cities.csv.

What's in each file

Every file is UTF-8 CSV with a header row and these columns:

Column	Type	Description
fips_place_code	text	Place GEOID (state + place FIPS). The join key.
name	text	Place name.
name_ascii	text	ASCII-only version of the name (diacritics removed).
state_code	text	USPS two-letter code.
state_name	text	Full state or territory name.
type	text	Place type (city, town, village, CDP, and similar Census classifications).
incorporated	boolean	TRUE for incorporated municipalities; FALSE for CDPs, townships, etc.
county_fips	text	County FIPS code.
county_name	text	County name.

Attribution

This dataset is licensed under CC BY 4.0. Use it freely, but attribution is required — credit the source with a link:

Data from US City List

Using it

UTF-8 CSV. Opens in Excel, Google Sheets, pandas, or any database. Join to other datasets on fips_place_code (or name + state_code as a fallback).

Files by state

State	File
Alabama	us-cities-al.csv
Alaska	us-cities-ak.csv
Arizona	us-cities-az.csv
Arkansas	us-cities-ar.csv
California	us-cities-ca.csv
Colorado	us-cities-co.csv
Connecticut	us-cities-ct.csv
Delaware	us-cities-de.csv
District of Columbia	us-cities-dc.csv
Florida	us-cities-fl.csv
Georgia	us-cities-ga.csv
Hawaii	us-cities-hi.csv
Idaho	us-cities-id.csv
Illinois	us-cities-il.csv
Indiana	us-cities-in.csv
Iowa	us-cities-ia.csv
Kansas	us-cities-ks.csv
Kentucky	us-cities-ky.csv
Louisiana	us-cities-la.csv
Maine	us-cities-me.csv
Maryland	us-cities-md.csv
Massachusetts	us-cities-ma.csv
Michigan	us-cities-mi.csv
Minnesota	us-cities-mn.csv
Mississippi	us-cities-ms.csv
Missouri	us-cities-mo.csv
Montana	us-cities-mt.csv
Nebraska	us-cities-ne.csv
Nevada	us-cities-nv.csv
New Hampshire	us-cities-nh.csv
New Jersey	us-cities-nj.csv
New Mexico	us-cities-nm.csv
New York	us-cities-ny.csv
North Carolina	us-cities-nc.csv
North Dakota	us-cities-nd.csv
Ohio	us-cities-oh.csv
Oklahoma	us-cities-ok.csv
Oregon	us-cities-or.csv
Pennsylvania	us-cities-pa.csv
Puerto Rico	us-cities-pr.csv
Rhode Island	us-cities-ri.csv
South Carolina	us-cities-sc.csv
South Dakota	us-cities-sd.csv
Tennessee	us-cities-tn.csv
Texas	us-cities-tx.csv
Utah	us-cities-ut.csv
Vermont	us-cities-vt.csv
Virginia	us-cities-va.csv
Washington	us-cities-wa.csv
West Virginia	us-cities-wv.csv
Wisconsin	us-cities-wi.csv
Wyoming	us-cities-wy.csv

More data

This is the free identification-only list. Expanded editions with additional fields and tiers — including coordinates and demographics — are available at US City List.

License

Released under CC BY 4.0. In plain terms: you're free to use, share, and adapt this data — including commercially — as long as you credit US City List with a link (see Attribution above). This is a summary, not a substitute; the full and authoritative terms are in LICENSE.md.

Source

Compiled from U.S. Census Bureau data.