Abstract

A crosswalk matching US ZIP codes to corresponding CBSA (core-based statistical area)

Documentation

The denominators used to calculate the address ratios are the ZIP code totals. When a ZIP is split by any of the other geographies, that ZIP code is duplicated in the crosswalk file.

**Example: **ZIP code 03870 is split by two different Census tracts, 33015066000 and 33015071000, which appear in the tract column. The ratio of residential addresses in the first ZIP-Tract record to the total number of residential addresses in the ZIP code is .0042 (.42%). The remaining residential addresses in that ZIP (99.58%) fall into the second ZIP-Tract record.

So, for example, if one wanted to allocate data from ZIP code 03870 to each Census tract located in that ZIP code, one would multiply the number of observations in the ZIP code by the residential ratio for each tract associated with that ZIP code.

https://redivis.com/fileUploads/4ecb405e-f533-4a5b-8286-11e56bb93368%3E" alt="">(Note that the sum of each ratio column for each distinct ZIP code may not always equal 1.00 (or 100%) due to rounding issues.)

CBSA definition

A core-based statistical area (CBSA) is a U.S. geographic area defined by the Office of Management and Budget (OMB) that consists of one or more counties (or equivalents) anchored by an urban center of at least 10,000 people plus adjacent counties that are socioeconomically tied to the urban center by commuting. Areas defined on the basis of these standards applied to Census 2000 data were announced by OMB in June 2003. These standards are used to replace the definitions of metropolitan areas that were defined in 1990. The OMB released new standards based on the 2010 Census on July 15, 2015.

Further reading

The following article demonstrates how to more effectively use the U.S. Department of Housing and Urban Development (HUD) United States Postal Service ZIP Code Crosswalk Files when working with disparate geographies.

Wilson, Ron and Din, Alexander, 2018. “Understanding and Enhancing the U.S. Department of Housing and Urban Development’s ZIP Code Crosswalk Files,” Cityscape: A Journal of Policy Development and Research, Volume 20 Number 2, 277 – 294. URL: https://www.huduser.gov/portal/periodicals/cityscpe/vol20num2/ch16.pdf

Contact authors

Questions regarding these crosswalk files can be directed to Alex Din with the subject line HUD-Crosswalks.

Acknowledgement

This dataset is taken from the U.S. Department of Housing and Urban Development (HUD) office: https://www.huduser.gov/portal/datasets/usps_crosswalk.html#codebook

Summary File 1 (SF1) Urban/Rural Update contains summary statistics on population and housing subjects derived from the responses to the 2010 Census questionnaire. Population items include sex, age, race, Hispanic or Latino origin, household relationship, household type, household size, family type, family size, and group quarters. Housing items include occupancy status, vacancy status, and tenure (whether a housing unit is owner-occupied or renter-occupied). The summary statistics are presented in 333 tables, which are tabulated for multiple levels of observation (called "summary levels" in the Census Bureau's nomenclature), including, but not limited to, regions, divisions, states, metropolitan/micropolitan statistical areas, counties, county subdivisions, places, congressional districts, American Indian Areas, Alaska Native Areas, Hawaiian Home Lands, ZIP Code tabulation areas, census tracts, block groups, and blocks. There are 177 population tables and 58 housing tables shown down to the block level; 84 population tables and 4 housing tables shown down to the census tract level; and 10 population tables shown down to the county level. Some of the summary areas are iterated for "geographic components" or portions of geographic areas, e.g., the principal city of a metropolitan statistical area (MSA) or the urban and rural portions of a MSA. With one variable per table cell and additional variables with geographic information, the collection comprises 2,597 data files, 49 per state, the District of Columbia, Puerto Rico, and the National File. The Census Bureau released SF1 in three stages: initial release, National Update, and Urban/Rural Update. The National Update added summary levels for the United States, regions, divisions, and geographic areas that cross state lines such as Combined Statistical Areas. This update adds urban and rural population and housing unit counts, summary levels for urban areas and the urban/rural components of census tracts and block groups, geographic components involving urbanized areas and urban clusters, and two new tables (household type by relationship for the population 65 years and over and a new tabulation of the total population by race). The initial release and National Update is available as ICPSR 33461. ICPSR supplies this data collection in 54 ZIP archives. There is a separate archive for each state, the District of Columbia, Puerto Rico, and the National File. The last archive contains a Microsoft Access database shell and additional documentation files besides the codebook.

The database includes ZIP code, city name, alias city name, state code, phone area code, city type, county name, country FIPS, time zone, day light saving flag, latitude, longitude, county elevation, Metropolitan Statistical Area (MSA), Primary Metropolitan Statistical Area (PMSA), Core Based Statistical Area (CBSA) and census 2000 data on population by race, average household income, and average house value.

Characteristics of the ZIP Codes (N = 968), Counties (N = 51), and Metropolitan Statistical Areas (MSAs; N = 19) where the 9,077 participants of the 2009 Centers for Disease Control and Prevention’s National HIV Behavioral Surveillance Lived, by Racial/Ethnic Group1.

Zip Codes dataset current as of 2006. Green Co Zip Codes.

TIGER road data for the MSA. When compared to high-resolution imagery and other transportation datasets positional inaccuracies were observed. As a result caution should be taken when using this dataset. TIGER, TIGER/Line, and Census TIGER are registered trademarks of the U.S. Census Bureau. ZCTA is a trademark of the U.S. Census Bureau. The Census 2000 TIGER/Line files are an extract of selected geographic and cartographic information from the Census TIGER data base. The geographic coverage for a single TIGER/Line file is a county or statistical equivalent entity, with the coverage area based on January 1, 2000 legal boundaries. A complete set of census 2000 TIGER/Line files includes all counties and statistically equivalent entities in the United States, Puerto Rico, and the Island Areas. The Census TIGER data base represents a seamless national file with no overlaps or gaps between parts. However, each county-based TIGER/Line file is designed to stand alone as an independent data set or the files can be combined to cover the whole Nation. The Census 2000 TIGER/Line files consist of line segments representing physical features and governmental and statistical boundaries. The boundary information in the TIGER/Line files are for statistical data collection and tabulation purposes only; their depiction and designation for statistical purposes does not constitute a determination of jurisdictional authority or rights of ownership or entitlement. The Census 2000 TIGER/Line files do NOT contain the Census 2000 urban areas which have not yet been delineated. The files contain information distributed over a series of record types for the spatial objects of a county. There are 17 record types, including the basic data record, the shape coordinate points, and geographic codes that can be used with appropriate software to prepare maps. Other geographic information contained in the files includes attributes such as feature identifiers/census feature class codes (CFCC) used to differentiate feature types, address ranges and ZIP Codes, codes for legal and statistical entities, latitude/longitude coordinates of linear and point features, landmark point features, area landmarks, key geographic features, and area boundaries. The Census 2000 TIGER/Line data dictionary contains a complete list of all the fields in the 17 record types. This is part of a collection of 221 Baltimore Ecosystem Study metadata records that point to a geodatabase. The geodatabase is available online and is considerably large. Upon request, and under certain arrangements, it can be shipped on media, such as a usb hard drive. The geodatabase is roughly 51.4 Gb in size, consisting of 4,914 files in 160 folders. Although this metadata record and the others like it are not rich with attributes, it is nonetheless made available because the data that it represents could be indeed useful. This is part of a collection of 221 Baltimore Ecosystem Study metadata records that point to a geodatabase. The geodatabase is available online and is considerably large. Upon request, and under certain arrangements, it can be shipped on media, such as a usb hard drive. The geodatabase is roughly 51.4 Gb in size, consisting of 4,914 files in 160 folders. Although this metadata record and the others like it are not rich with attributes, it is nonetheless made available because the data that it represents could be indeed useful.

File provides the capability of assigning geographic codes (State, County, and Place) to records containing ZIP Code, post office name, and State abbreviation

This version has been updated to include codes for metropolitan statistical areas (MSA's) defined as of 6/30/87, and codes for counties and places in existence as of 1/1/87

Fifty states, the District of Columbia, and Puerto Rico

Multivariable hierarchical generalized linear models regressing the odds of HIV negative status on characteristics of the environments where people who inject drugs (N = 9,077) lived when participating in the National HIV Behavioral Surveillance in 20091.

Place-based Constructs, Variables, and Data Sources.

The tables and interactive maps below allow users to explore the ratio of debt to income by state, metropolitan statistical area, and county for each year since 1999. Household debt is calculated from Federal Reserve Bank of New York (FRBNY) Consumer Credit Panel/Equifax Data, and household income is reported by the Bureau of Labor Statistics.

2003 PRIZM data for the MSA. PRIZM is the Potential Rating Index by Zip code Markets produced by the Claritas corportation - http://www.clusterbigip1.claritas.com/claritas/Default.jsp. Refer to the enclosed doumentation for more information. The block group boundaries in this dataset are consistent with the BES universal MSA boundary derived from GDT census data. This is part of a collection of 221 Baltimore Ecosystem Study metadata records that point to a geodatabase. The geodatabase is available online and is considerably large. Upon request, and under certain arrangements, it can be shipped on media, such as a usb hard drive. The geodatabase is roughly 51.4 Gb in size, consisting of 4,914 files in 160 folders. Although this metadata record and the others like it are not rich with attributes, it is nonetheless made available because the data that it represents could be indeed useful. This is part of a collection of 221 Baltimore Ecosystem Study metadata records that point to a geodatabase. The geodatabase is available online and is considerably large. Upon request, and under certain arrangements, it can be shipped on media, such as a usb hard drive. The geodatabase is roughly 51.4 Gb in size, consisting of 4,914 files in 160 folders. Although this metadata record and the others like it are not rich with attributes, it is nonetheless made available because the data that it represents could be indeed useful.

Components Generated by the Principal Components Analysis.

The Bureau of the Census has released Census 2000 Summary File 1 (SF1) 100-Percent data. The file includes the following population items: sex, age, race, Hispanic or Latino origin, household relationship, and household and family characteristics. Housing items include occupancy status and tenure (whether the unit is owner or renter occupied). SF1 does not include information on incomes, poverty status, overcrowded housing or age of housing. These topics will be covered in Summary File 3. Data are available for states, counties, county subdivisions, places, census tracts, block groups, and, where applicable, American Indian and Alaskan Native Areas and Hawaiian Home Lands. The SF1 data are available on the Bureau's web site and may be retrieved from American FactFinder as tables, lists, or maps. Users may also download a set of compressed ASCII files for each state via the Bureau's FTP server. There are over 8000 data items available for each geographic area. The full listing of these data items is available here as a downloadable compressed data base file named TABLES.ZIP. The uncompressed is in FoxPro data base file (dbf) format and may be imported to ACCESS, EXCEL, and other software formats. While all of this information is useful, the Office of Community Planning and Development has downloaded selected information for all states and areas and is making this information available on the CPD web pages. The tables and data items selected are those items used in the CDBG and HOME allocation formulas plus topics most pertinent to the Comprehensive Housing Affordability Strategy (CHAS), the Consolidated Plan, and similar overall economic and community development plans. The information is contained in five compressed (zipped) dbf tables for each state. When uncompressed the tables are ready for use with FoxPro and they can be imported into ACCESS, EXCEL, and other spreadsheet, GIS and database software. The data are at the block group summary level. The first two characters of the file name are the state abbreviation. The next two letters are BG for block group. Each record is labeled with the code and name of the city and county in which it is located so that the data can be summarized to higher-level geography. The last part of the file name describes the contents . The GEO file contains standard Census Bureau geographic identifiers for each block group, such as the metropolitan area code and congressional district code. The only data included in this table is total population and total housing units. POP1 and POP2 contain selected population variables and selected housing items are in the HU file. The MA05 table data is only for use by State CDBG grantees for the reporting of the racial composition of beneficiaries of Area Benefit activities. The complete package for a state consists of the dictionary file named TABLES, and the five data files for the state. The logical record number (LOGRECNO) links the records across tables.

Vehicle population is updated annually, each April, to reflect the number of vehicles “on the road” during the previous calendar year. Vehicle population counts vehicles whose registration is either current or less than 35 days expired. Sales are higher than population because of vehicle retirements, accidents, owners moving out of state, or other reasons.

Data as of: December 31, 2022

Regional Data Categories Map Filter. Data can be reflected at the county, metropolitan statistical area (MSA), or ZIP code level. Individual registrations were assigned to a region based on mailing address, with the following exceptions:

Out of State: vehicles registered in California with a mailing address in a different state

ZIP Code “99999”: indicates that the ZIP code in the Vehicle Registration database was invalid

Unassigned: remote areas not associated with an MSA

Unknown: Invalid ZIP codes categorized under MSA

This Data contains information from 2010 to 2022.

Please note, that columns 'Manufacturer' and 'Model' include Null values since it was less data in 2010-2012 and more data from 2013.

Examples of Questions you may answer with this Data:

• What is the trend in the number of Battery Electric Vehicles (BEVs) in California from 2010 to 2022?
• How has the adoption of Gasoline vehicles changed over the years in California, specifically for Flex Fuel?
• Which county in California had the highest number of Diesel vehicles in 2010?
• What is the distribution of Gasoline Hybrid vehicles across California counties in 2020?
• How many Natural Gas vehicles were registered in California in 2010, and did this number change significantly by 2020?
• Which car manufacturer produced the most Battery Electric Vehicles (BEVs) in California in 2015?
• What is the overall trend in the number of Zero Emission Vehicles (ZEVs) in California over the past decade?
• What is the average number of vehicles per make and model for all Fuel Types in 2019 in California?
• How has the market share of Battery Electric Vehicles (BEVs) compared to Gasoline vehicles evolved over the years in California?

Columns: Data Year
County
Dashboard Fuel Type Group
Fuel Type
Manufacturer
Model
Number of Vehicles

2005 PRIZM NE data for the Baltimore MSA. PRIZM is the Potential Rating Index by Zip code Markets produced by the Claritas corporation - http://www.clusterbigip1.claritas.com/claritas/Default.jsp. The 2005 edition of the PRIZM dataset uses the New Evolution (NE) codes, which are not compatible with previous versions of PRIZM. PRIZM NE data is clustered at the Segment (66 classes), Social Group (14 classes) and Lifestyle Group (11 classes) level. Refer to the 'Supplemental Information' section and enclosed documentation for more information. The block group boundaries in this dataset are consistent with the BES universal MSA boundary derived from GDT census data.Please refer to the Supplemental Information section and to the metadata enclosures for more information. This is part of a collection of 221 Baltimore Ecosystem Study metadata records that point to a geodatabase. The geodatabase is available online and is considerably large. Upon request, and under certain arrangements, it can be shipped on media, such as a usb hard drive. The geodatabase is roughly 51.4 Gb in size, consisting of 4,914 files in 160 folders. Although this metadata record and the others like it are not rich with attributes, it is nonetheless made available because the data that it represents could be indeed useful. This is part of a collection of 221 Baltimore Ecosystem Study metadata records that point to a geodatabase. The geodatabase is available online and is considerably large. Upon request, and under certain arrangements, it can be shipped on media, such as a usb hard drive. The geodatabase is roughly 51.4 Gb in size, consisting of 4,914 files in 160 folders. Although this metadata record and the others like it are not rich with attributes, it is nonetheless made available because the data that it represents could be indeed useful.

Telecommunications database targeted specifically toward disseminating all valid NPA/NXX combinations in the North American Numbering Plan. It covers all active North American NPA/NXX assignments. Included in the database are NPA (area code), NXX (exchange), country, state, county, latitude, longitude, LATA, time zone, day light saving, population, FIPS, MSA, PMSA, CBSA, ZIP code, Operating Company Number, use type, rate center, COMMON LANGUAGE identifier, and V&H.

This data collection was produced by the San Diego Association of Governments (SANDAG) and donated to the University of California, San Diego Social Science Data Collection (SSDC) for archival retention and public dissemination. The data consists of 1990 April 1 Census Bureau population and housing data and annual SANDAG intercensal estimates of population and housing data from 1991 through 2000. The data have been designed for comparability with historical census data, and these estimates may be used to evaluate changes occurring over time. Estimates are available for the San Diego region, major statistical areas (MSAs), subregional areas (SRAs), census tracts, cities, zip codes, County of San Diego Planning Areas, and City of San Diego Community Planning Areas. Almost 400 variables in the dataset include: Total Population, Population in Households, Housing Units by category, Households by income level, Median Household Income, Employment by broad sector, Occupation by broad category, and land area. Population estimates are available by sex/age/ethnicity. The data use 23 age groupings and four ethnic groupings. The four ethnic groups are Hispanic, non-Hispanic White, non- Hispanic Black, and non-Hispanic Asian. These groups are defined based on comb ined responses to two questions on the U.S. Census form, one concerning race and another concerning Hispanic origin. Those who wish to analyze the data with statistical software or merge the data with GIS boundary files may, from the SSDC files page, download the the original data files as they were distributed by SANDAG, or the merged data files created by SSDC staff, or create subsets and download those in any of a number of popular formats (e.g., SPSS, SAS, csv, etc.). Those who wish to quickly view the statistics in spreadsheet form may wish to use the links below to Excel spreadsheets created by SSDC staff. These spreadsheets do not contain all the data, but do contain the most often used variables and are easy to read and use . Those SANDAG maps and administrative digital boundary files that are available to everyone are available here through SSDC. The UCSD Library GIS Lab has additional digital boundary files that can be used only by UCSD faculty, students and staff.

Bivariate associations between HIV negative status and (a) features of the environments where people who inject drugs (N = 9,077) lived when participating in the 2009 National HIV Behavioral Surveillance, and (b) participant characteristics1.

Graph and download economic data for Median Household Income in the United States (MEHOINUSA646N) from 1984 to 2023 about households, median, income, and USA.

Release Date: 2015-02-27...Table Name.Island Areas: Industry Series: Selected Statistics by Employment Size of Manufacturing Establishments for Puerto Rico, Metropolitan Areas, and Municipios: 2012.....Key Table Information.Refer to Methodology for additional information......Universe.The universe includes all establishments with payroll at any time during 2012, and classified in NAICS sectors 31-33. Data for 2012 are based on the 2012 NAICS Manual......Geography Coverage.The data are shown at the following geographic levels for Puerto Rico:. . State-equivalent (ST - Puerto Rico). Combined Statistical Area (CSA). Metropolitan Statistical Area (MSA). County-equivalent (COUNTY - Municipio). .....Industry Coverage.The data are shown for 2- and 3- digit NAICS code levels.......Data Items and Other Identifying Records.This file contains data on:. . Number of establishments. Number of paid employees. Annual payroll. Value added. Value of shipments. .The data are shown for legal form of organization and employment size-of-establishments......Sort Order.Data are presented in ascending NAICS code by legal form of organization and employment size-of-establishments sequence......FTP Download.Download the entire table athttps://www2.census.gov/econ2012/IA/sector00/IA1200IPRM05.zip....Contact Information.U.S. Census Bureau, Economy-Wide Statistics Division.Island Areas and Business Owners Branch.Tel: (301)763-3314.csd.ia@census.gov...Note: Data for 2012 are based on the 2012 NAICS..Note: The level of geographic detail covered varies for Puerto Rico manufacturing. Refer to geography help for a detailed list of the geographies. Note that tables IA1200IPRM02 and IA1200IPRM05 include different geographic levels (combined statistical areas (CSA), metropolitan and micropolitan statistical areas (MSA), and municipios.) Tables IA1200IPRM12 - IA1200IPRM14 present data at the CSAs and MSAs level..Note: The "Not in metropolitan or micropolitan area, Puerto Rico" category includes Culebra, Las Marías, Maricao, and Vieques municipios which are not part of any CSA or MSA..Note: Includes only establishments with payroll. Data based on the 2012 Economic Census of Island Areas. Figures may not add to total due to rounding. For information on confidentiality protection, sampling error, nonsampling error, and definitions, see Methodology..Symbols:D - Withheld to avoid disclosing data for individual companies; data are included in higher level totalsN - Not available or not comparableFor a complete list of all economic programs symbols, see the Symbols Glossary.Source: U.S. Census Bureau, 2012 Economic Census of Island Areas.Note: The data in this file are based on the 2012 Economic Census of Island Areas. To maintain confidentiality, the U.S. Census Bureau suppresses data to protect the identity of any business or individual. The census results in this file contain sampling and nonsampling error. Data users who create their own estimates using data from this file should cite the U.S. Census Bureau as the source of the original data only. For the full technical documentation, see Methodology link in above headnote.