State, County and City FIPS (Federal Information Processing Standards) codes are a set of numeric designations given to state, cities and counties by the U.S. federal government. All geographic data submitted to the FRA must have a FIPS code.

Unlock the power of geographical precision with this comprehensive ZIP to FIPS dataset. Seamlessly map ZIP codes to Federal Information Processing Standards (FIPS) codes, enabling accurate location-based analyses. Ideal for geospatial applications, demographic research, and data integration. Explore the seamless fusion of ZIP and FIPS codes for enhanced spatial insights.

This dataset, which represents county Federal Information Processing System (FIPS) codes for each county as a raster, is utilized by reVX to compute setbacks (distances). Setbacks can be computed either locally (on a per-county basis with specified distances or multipliers) or globally under a generic setback multiplier assumption applied to either the turbine tip height or the base setback distance. A County FIPS code is a five-digit numerical identifier that uniquely identifies counties and county equivalents in the United States The initial two digits represent the FIPS state code, while the final three digits signify the county's unique code within that state. For instance, 55025 corresponds to Dane County, Wisconsin. The first two digits - 55 - represent Wisconsin, and the last three digits - 025 - denote Dane County. Further information can be accessed at the "Federal Information Processing System (FIPS) Codes for States and Counties" resource below.

This tool--a simple csv or Stata file for merging--gives you a fast way to assign Census county FIPS codes to variously presented county names. This is useful for dealing with county names collected from official sources, such as election returns, which inconsistently present county names and often have misspellings. It will likely take less than ten minutes the first time, and about one minute thereafter--assuming all versions of your county names are in this file. There are about 3,142 counties in the U.S., and there are 77,613 different permutations of county names in this file (ave=25 per county, max=382). Counties with more likely permutations have more versions. Misspellings were added as I came across them over time. I DON'T expect people to cite the use of this tool. DO feel free to suggest the addition of other county name permutations.

BackgroundThis table contains State and County codes for all 50 States. One column contains a CalHHS Departmental "local" County code. This code is the numeric sequence of the 58 Counties in California. Many of the State systems (especially legacy systems) can only work with these legacy local County codes.FIPS Class Codes (CLASSFP)H1: Identifies an active county or statistically equivalent entity that does not qualify under subclass C7 or H6.H4: Identifies a legally defined inactive or nonfunctioning county or statistically equivalent entity that does not qualify under subclass H6.H5: Identifies census areas in Alaska, a statistical county equivalent entity.H6: Identifies a county or statistically equivalent entity that is coextensive in area or governmentally consolidated with an incorporated place, part of an incorporated place, or a consolidated city.C7: Identifies an incorporated place that is an independent of any county.Functional Status Codes (FUNCSTAT)A: Identifies an active government providing primary general-purpose functions.B: Identifies an active government that is partially consolidated with another government but with separate officials providing primary general-purpose functions.C: Identifies an active government consolidated with another government with a single set of officials.F: Identifies a fictitious entity created to fill the Census Bureau's geographic hierarchy.G: Identifies an active government that is subordinate to another unit of government.N: Identifies a nonfunctioning legal entity.S: Identifies a statistical entity

Context

Dataset created to link between County - State Name, State-County FIPS, and ZIP Code.

Acknowledgements

Data Sources

• US HUD

https://www.huduser.gov/portal/datasets/usps.html

• Census Bureau

https://www2.census.gov/geo/docs/reference/codes/files/national_county.txt https://www.census.gov/geo/reference/codes/cou.html

Data cleaned by Data4Democracy and hosted originally on Data.World: https://github.com/Data4Democracy/zip-code-to-county https://data.world/niccolley/us-zipcode-to-county-state

ZCTA data from USPS 6.2017 release.

Image from Reddit.

US Geographic Codes Dataset

This code is used to generate a combined data set of US ZIP, FIPS, and County data for most ZIP Codes in the U.S. (41,867 to be exact).

Code to generate the data set from the government files listed below can be found here.

The Data

The dataset is organized as follows:

• Zip Code: USPS ZIP code from here
• State Name: Full state name (E.g. Michigan)
• State Abrv: USPS abbreviated state name (E.g: MI)
• State Code: FIPS State Code from here
• County Name: County in which ZIP is located
• County Code: FIPS County Code
• FIPS Code: FIPS State Code + FIPS County Code from here
• ANSI Code: American National Standards Institute Code
• Centroid Lat: Latitude value of the county center
• Centroid Long: Longitude value of the county center

Sources

The data used to create this data set was taken from several recent government data sets.

These are:

• 2017 US Gazetteer FIPS Dataset
• 2017 US Census County Polygons Dataset
• 2015 Department of Labor GPCI Dataset
• General Census State Code Reference Document

Disclaimers

The final csv is in 'latin1' encoding to preserve the Spanish county names in Puerto Rico.

This data is from, and shall remain in the public domain, and the onus of responsibility lies with the user of this data.

A listing of NYS counties with accompanying Federal Information Processing System (FIPS) and US Postal Service ZIP codes sourced from the NYS GIS Clearinghouse.

Context

There is no story behind this data.

These are just supplementary datasets which I plan on using for plotting county wise data on maps.. (in particular for using with my kernel : https://www.kaggle.com/stansilas/maps-are-beautiful-unemployment-is-not/)
As that data set didn't have the info I needed for plotting an interactive map using highcharter .

Content

Since I noticed that most demographic datasets here on Kaggle, either have state code, state name, or county name + state name but not all of it i.e county name, fips code, state name + state code.

Using these two datasets one can get any combination of state county codes etc.

States.csv has State name + code
US counties.csv has county wise data.

Acknowledgements

Picture : https://unsplash.com/search/usa-states?photo=-RO2DFPl7wE
Counties : https://www.census.gov/geo/reference/codes/cou.html
State :

Inspiration

Not Applicable.

A list of Connecticut municipalities with the 3-digit tax code and the 2010 10-digit FIPS code for county subdivisions, assigned by the U.S. Census Bureau

The US Census Bureau's online County Look-up Tool provides the unique 3-digit code for the Identification of Counties and Equivalent Entities of the United States, its Possessions, and Insular Areas.

This dataset was created to facilitate the conversion of Uniform Crime Reporting (UCR) Program state and county codes to Federal Information Processing Standards (FIPS) state and county codes. The four UCR agency-level data files archived at ICPSR in Uniform Crime Reporting Program Data: United States contain UCR state and county codes as geographic identifiers. Researchers who wish to use these data with other sources, such as Census data, may want to convert these UCR codes to FIPS codes in order to link the different data sources. This file was created to facilitate this linkage. It contains state abbreviations, UCR state and county codes, FIPS state and county codes, and county names for all counties present in the UCR data files since 1990. These same FIPS codes were used to create the UCR County-Level Detailed Arrest and Offense files from 1990-1996.

This file maps the state and county fips codes in the data files to standard state and county names.

Context

This is the 24th decennial US Census. The data was released on August 12, 2021 to public

Content

The dataset contains 12 GB of complete US Census data of 2020 of all 50 states. Column headers for each state file are given below:

FILEID File Identification STUSAB State/US-Abbreviation (USPS) SUMLEV Summary Level GEOVAR Geographic Variant GEOCOMP Geographic Component CHARITER Characteristic Iteration CIFSN Characteristic Iteration File Sequence Number LOGRECNO Logical Record Number GEOID Geographic Record Identifier GEOCODE Geographic Code Identifier REGION Region DIVISION Division STATE State (FIPS) STATENS State (NS) COUNTY County (FIPS) COUNTYCC FIPS County Class Code COUNTYNS County (NS) COUSUB County Subdivision (FIPS) COUSUBCC FIPS County Subdivision Class Code COUSUBNS County Subdivision (NS) SUBMCD Subminor Civil Division (FIPS) SUBMCDCC FIPS Subminor Civil Division Class Code SUBMCDNS Subminor Civil Division (NS) ESTATE Estate (FIPS) ESTATECC FIPS Estate Class Code ESTATENS Estate (NS) CONCIT Consolidated City (FIPS) CONCITCC FIPS Consolidated City Class Code CONCITNS Consolidated City (NS) PLACE Place (FIPS) PLACECC FIPS Place Class Code PLACENS Place (NS) TRACT Census Tract BLKGRP Block Group BLOCK Block AIANHH American Indian Area/Alaska Native Area/Hawaiian Home Land (Census) AIHHTLI American Indian Trust Land/Hawaiian Home Land Indicator AIANHHFP American Indian Area/Alaska Native Area/Hawaiian Home Land (FIPS) AIANHHCC FIPS American Indian Area/Alaska Native Area/Hawaiian Home Land Class Code AIANHHNS American Indian Area/Alaska Native Area/Hawaiian Home Land (NS) AITS American Indian Tribal Subdivision (Census) AITSFP American Indian Tribal Subdivision (FIPS) AITSCC FIPS American Indian Tribal Subdivision Class Code AITSNS American Indian Tribal Subdivision (NS) TTRACT Tribal Census Tract TBLKGRP Tribal Block Group ANRC Alaska Native Regional Corporation (FIPS) ANRCCC FIPS Alaska Native Regional Corporation Class Code ANRCNS Alaska Native Regional Corporation (NS) CBSA Metropolitan Statistical Area/Micropolitan Statistical Area MEMI Metropolitan/Micropolitan Indicator CSA Combined Statistical Area METDIV Metropolitan Division NECTA New England City and Town Area NMEMI NECTA Metropolitan/Micropolitan Indicator CNECTA Combined New England City and Town Area NECTADIV New England City and Town Area Division CBSAPCI Metropolitan Statistical Area/Micropolitan Statistical Area Principal City Indicator NECTAPCI New England City and Town Area Principal City Indicator UA Urban Area UATYPE Urban Area Type UR Urban/Rural CD116 Congressional District (116th) CD118 Congressional District (118th) CD119 Congressional District (119th) CD120 Congressional District (120th) CD121 Congressional District (121st) SLDU18 State Legislative District (Upper Chamber) (2018) SLDU22 State Legislative District (Upper Chamber) (2022) SLDU24 State Legislative District (Upper Chamber) (2024) SLDU26 State Legislative District (Upper Chamber) (2026) SLDU28 State Legislative District (Upper Chamber) (2028) SLDL18 State Legislative District (Lower Chamber) (2018) SLDL22 State Legislative District (Lower Chamber) (2022) SLDL24 State Legislative District (Lower Chamber) (2024) SLDL26 State Legislative District (Lower Chamber) (2026) SLDL28 State Legislative District (Lower Chamber) (2028) VTD Voting District VTDI Voting District Indicator ZCTA ZIP Code Tabulation Area (5-Digit) SDELM School District (Elementary) SDSEC School District (Secondary) SDUNI School District (Unified) PUMA Public Use Microdata Area AREALAND Area (Land) AREAWATR Area (Water) BASENAME Area Base Name NAME Area Name-Legal/Statistical Area Description (LSAD) Term-Part Indicator FUNCSTAT Functional Status Code GCUNI Geographic Change User Note Indicator POP100 Population Count (100%) HU100 Housing Unit Count (100%) INTPTLAT Internal Point (Latitude) INTPTLON Internal Point (Longitude) LSADC Legal/Statistical Area Descrip...

explain the relationship between DMA, FIPS and county

ChatGPT said: Here's a breakdown of the relationship between DMA, FIPS, and county:

🗺️ 1. County A county is a geographic and administrative subdivision of a U.S. state.

For example: Cook County in Illinois or Los Angeles County in California.

The U.S. has over 3,000 counties or county-equivalents.

🔢 2. FIPS Code FIPS = Federal Information Processing Standards code.

Used to uniquely identify geographic areas like states and counties.

It consists of:

State FIPS (2 digits) — e.g., California = 06

County FIPS (3 digits) — e.g., Los Angeles County = 037

Together: 06037 (California + Los Angeles County)

FIPS codes are used in datasets, GIS, and federal data standards to track data consistently across agencies.

📺 3. DMA (Designated Market Area) DMA is a geographic region defined by Nielsen where the population receives the same (or similar) TV and radio content.

Used in advertising, media, and Google Trends to segment the market by media consumption patterns.

There are 210 DMAs in the U.S., each labeled by Nielsen with a DMA code or name (e.g., "New York", "Chicago", "Palm Springs").

📌 How They Relate Concept Level Code Type Example County Local FIPS Los Angeles County (06037) FIPS Code System Numeric Encodes state + county DMA Media Region Name/Index Los Angeles DMA

One DMA contains multiple counties.

Example: The Los Angeles DMA includes Los Angeles County, Orange County, Ventura County, etc.

Each county has a unique FIPS code, but a DMA might span counties in multiple states.

When mapping or analyzing data (e.g., in GIS or Google Trends), you often merge county-level data (FIPS) into DMAs for media or market analysis.

🧭 Example State County FIPS DMA Name DMA Code California Los Angeles 06037 Los Angeles 803 California Orange 06059 Los Angeles 803 California Riverside 06065 Palm Springs 804

👉 DMA for FIPS 02013?

Alaska is unique: it’s sparsely populated and has limited Nielsen DMA coverage.

Most of rural Alaska does not belong to a defined DMA. Instead, large parts of Alaska are treated as “non-DMA” or are grouped into a single large DMA (often labeled Anchorage DMA if included).

This dataset contains data about FIPS (Federal Information Processing Standards) codes for US states and counties. This dataset provides demographic data that could be necessary for evaluation and organization of medical services and population health evaluation.

Dataset

This dataset was created by haakakak

Contents

The TIGER/Line Files include both incorporated places (legal entities) and census designated places or CDPs (statistical entities). An incorporated place is established to provide governmental functions for a concentration of people as opposed to a minor civil division (MCD), which generally is created to provide services or administer an area without regard, necessarily, to population. Places always nest within a State, but may extend across county and county subdivision boundaries. An incorporated place usually is a city, town, village, or borough, but can have other legal descriptions. CDPs are delineated for the decennial census as the statistical counterparts of incorporated places. CDPs are delineated to provide data for settled concentrations of population that are identifiable by name, but are not legally incorporated under the laws of the State in which they are located. The boundaries for CDPs often are defined in partnership with State, local, and/or tribal officials and usually coincide with visible features or the boundary of an adjacent incorporated place or another legal entity. CDP boundaries often change from one decennial census to the next with changes in the settlement pattern and development; a CDP with the same name as in an earlier census does not necessarily have the same boundary. The only population/housing size requirement for CDPs for the 2010 Census is that they must contain some housing and population. The boundaries of all 2020 Census incorporated places are as of January 1, 2020 as reported through the Census Bureau's Boundary and Annexation Survey (BAS). The boundaries of all 2020 Census CDPs were delineated as part of the Census Bureau's Participant Statistical Areas Program (PSAP).STATEFP 2 String State FIPS codeCONCTYFP 5 String Consolidated city FIPS codeCONCTYNS 8 String Consolidated city GNIS codeGEOID 7 String Consolidated city identifier; a concatenation of current state FIPS code and consolidated city FIPS codeNAME 100 String Consolidated city nameNAMELSAD 100 String Name and the translated legal/statistical area description for consolidated cityLSAD 2 String Legal/statistical area description code for consolidated cityCLASSFP 2 String FIPS class codeMTFCC 5 String MAF/TIGER Feature Class Code (G4120)FUNCSTAT 1 String Functional statusALAND 14 Number Land areaAWATER 14 Number Water areaINTPTLAT 11 String Latitude of the internal pointINTPTLON 12 String Longitude of the internal poinhttps://www2.census.gov/geo/pdfs/maps-data/data/tiger/tgrshp_rd18/TGRSHPRD18_TechDoc.pdf

With coverage for the entire continental USA, this county-level shapefile is based on the FIPS codes used by the Bureau of Economic Analysis (BEA). Different than other governmental agencies, the BEA combines the independent cities in Virginia with their adjacent counties (https://www.bea.gov/regional/docs/statelist.cfm). This shapefile is to be used when analyzing county-level data from the BEA.

This is a lookup table containing various data related to cities, townships, unorganized territories (CTUs) and any divisions created by county boundaries splitting them. These are termed Minor Civil Division (MCDs) by the Census Bureau. The table encompases the Twin Cities 7-county metropolitan area. It is intended to be a Council wide master lookup table for these entites. It contains official federal and state unique identifiers for CTUs and MCDs as well as identifiers created and used by other organizations. The table also contains historical MCDs dating back to the 1990s and a few other non-MCD records that are of importance to Met. Council use of this table.

The County CTU Lookup Table relates to the Counties and Cities & Townships, Twin Cities Metropolitan Area dataset here: https://gisdata.mn.gov/dataset/us-mn-state-metc-bdry-metro-counties-and-ctus

NOTES:

- On 5/28/2014 a new field was added to reflect the new community designations defined in the Council's Thrive MSP 2040 regional plan - COMDES2040

- On 3/17/2011 it was discovered that the CTU ID used for the City of Lake St. Croix Beach was incorrect. It was changed from 2394379 to 2395599 to match GNIS.

- On 3/17/2011 it was discovered that the CTU ID used for the City of Lilydale was incorrect. It was changed from 2394457 to 2395708 to match GNIS.

- On 11/9/2010 it was discovered that the CTU ID used for the City of Crystal was incorrect. It was changed from 2393541 to 2393683 to match GNIS.

- Effective April 2008, a change was made in GNIS to match the FIPS place codes to the "civil" feature for each city instead of the "populated place" feature. Both cities and townships are now "civil" features within GNIS. This means that the official GNIS unique ID for every city in Minnesota has changed.

- As of January 1, 2006, the five digit FIPS 55-3 Place codes that were used as unique identifiers in this dataset (CTU_CODE and COCTU_CODE fields) were officially retired by the Federal governement. They are replaced by a set of integer codes from the Geographic Names Information System (GNIS_CODE field). Both codes will be kept in this database, but the GNIS_CODE is considered the official unique identifier from this point forward. The GNIS codes are also slated to become official ANSI codes for these geographic features. While GNIS treats these codes as 6 to 8 digit integer data types, the Census Bureau formats them as 8 digit text fields, right justified with leading zeros included.

- The Census Bureau will continue to create FIPS 55 Place codes for new cities and townships through the 2010 Census. After that, no new FIPS 55 codes will be created. Note that for townships that wholly incorporate into cities, the same FIPS 55 code will be used for the new city. (GNIS creates a new ID for the new city.)

- Cities and townships have also been referred to as ''MCDs'' (a Census term), however this term technically refers to the part of each city or township within a single county. Thus, a few cities in the metro area that are split by county boundaries are actually comprised of two different MCDs. This was part of the impetus for a proposed MN state data standard that uses the ''CTU'' terminology for clarity.

- A variety of civil divisions of the land exist within the United States. In Minnesota, only three types exist - cities, townships and unorganized territories. All three of these exist within the Twin Cities seven county area. The only unorganized territory is Fort Snelling (a large portion of which is occupied by the MSP International Airport).

- Some cities are split between two counties. Only those parts of cities within the 7-county area are included.

- Prior to the 2000 census, the FIPS Place code for the City of Greenwood in Hennepin County was changed from 25928 to 25918. This dataset reflects that change.