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

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.

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.

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.

NAME: MSA2010tiger DESCRIPTION: Major Statistical Areas (derived from raw 2010 TIGER census tracts) FEATURE TYPE: Polygon EXTENT: San Diego region DATE OF DATA: 2010 NUMBER OF RECORDS: 7 MAPPING SOURCE: SANDAG; U.S. Department of Commerce, U.S. Census Bureau, Geography Division, TIGER/Line Shapefile Notes: The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). Census Tracts nest within Subregional Areas (SRAs) which nest within Major Statistical Areas (MSAs). There are only minor differences between the 1980, 1990, 2000, and 2010 SRA and MSA boundaries due to some census tract boundary realignments. Original TIGER Shapefiles can be obtained at http://www.census.gov/geo/www/tiger Code Documentation: Attribute Description MSA Major Statistical Area Code NAME Major Statistical Area Name MSA Name 0 Central 1 North City 2 South Suburban 3 East Suburban 4 North County West 5 North County East 6 East County Last revised: March 2011

Place-based Constructs, Variables, and Data Sources.

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.

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

The 1990 Census Block Statistics portion of the Archive of Census Related Products (ACRP) contains population and housing data from the U.S. Census Bureau's 1990 Summary Tape File (STF1B). The population data includes total population, age, race, and hispanic origin, while the housing data comprises number of housing Units, tenure, room density, mean contract rent, mean value, and mean number of rooms. Additional data includes land area, water area, centroids, Metropolitan Statistical Area (MSA) codes, place codes, and special area codes. This portion of the ACRP is produced by the Columbia University Center for International Earth Science Information Network (CIESIN).

What is Rental Data?

Rental data encompasses detailed information about residential rental properties, including single-family homes, multifamily units, and large apartment complexes. This data often includes key metrics such as rental prices, occupancy rates, property amenities, and detailed property descriptions. Advanced rental datasets integrate listings directly sourced from property management software systems, ensuring real-time accuracy and eliminating reliance on outdated or scraped information.

Additional Rental Data Details

The rental data is sourced from over 20,000 property managers via direct feeds and property management platforms, covering over 30 percent of the national rental housing market for diverse and broad representation. Real-time updates ensure data remains current, while verified listings enhance accuracy, avoiding errors typical of survey-based or scraped datasets. The dataset includes 14+ million rental units with detailed descriptions, rich photography, and amenities, offering address-level granularity for precise market analysis. Its extensive coverage of small multifamily and single-family rentals sets it apart from competitors focused on premium multifamily properties.

Rental Data Includes:

• Property Types
• Single-Family Rentals
• Small Multi-family Units
• Premium Apartments
• 16,000+ ZIP Codes
• 800+ MSAs
• Pricing Trends
• Lease Terms Amenities

The 1990 Census Block Statistics portion of the Archive of Census Related Products (ACRP) contains population and housing data from the U.S. Census Bureau's 1990 Summary Tape File (STF1B). The population data includes total population, age, race, and hispanic origin, while the housing data comprises number of housing Units, tenure, room density, mean contract rent, mean value, and mean number of rooms. Additional data includes land area, water area, centroids, Metropolitan Statistical Area (MSA) codes, place codes, and special area codes. This portion of the ACRP is produced by the Columbia University Center for International Earth Science Information Network (CIESIN).

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

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.

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.

Components Generated by the Principal Components Analysis.

This layer was developed by the Research & Analytics Division of the Atlanta Regional Commission to represent the United States Census Bureau's 2000 Decennial Census at the block group geography.Attributes:FIPSSTCO = The Federal Information Processing Series (FIPS) state and county codes. FIPS codes were formerly known as Federal Information Processing Standards codes, until the National Institute of Standards and Technology (NIST) announced its decision in 2005 to remove geographic entity codes from its oversight. The Census Bureau continues to maintain and issue codes for geographic entities covered under FIPS oversight, albeit with a revised meaning for the FIPS acronym. Geographic entities covered under FIPS include states, counties, congressional districts, core based statistical areas, places, county subdivisions, subminor civil divisions, consolidated cities, and all types of American Indian, Alaska Native, and Native Hawaiian areas. FIPS codes are assigned alphabetically according to the name of the geographic entity and may change to maintain alphabetic sort when new entities are created or names change. FIPS codes for specific geographic entity types are usually unique within the next highest level of geographic entity with which a nesting relationship exists. For example, FIPS state, congressional district, and core based statistical area codes are unique within nation; FIPS county, place, county subdivision, and subminor civil division codes are unique within state. The codes for American Indian, Alaska Native, and Native Hawaiian areas also are unique within state; those areas in multiple states will have different codes for each state.TRACT = Census Tract Codes and Numbers. Census tracts are identified by an up to four-digit integer number and may have an optional two-digit suffix; for example 1457.02 or 23. The census tract codes consist of six digits with an implied decimal between the fourth and fifth digit corresponding to the basic census tract number but with leading zeroes and trailing zeroes for census tracts without a suffix. The tract number examples above would have codes of 145702 and 002300, respectively.GROUP_ = Block Group Codes. Block Groups have a valid code range of 0 through 9. Block Groups beginning with a zero only contain water area and are generally in coastal and Great Lakes water and territorial seas, but also in larger inland water bodies. STFID = A concatenation of FIPSSTCO, TRACT, and GROUP_, which creates the entire FIPS code for this geography.POP100 = The population of the Block Group at the time of the census.HU100 = The number of housing units in the Block group at the time of the census.WFD = Workforce Development Area (WFD) is a seven-county area created by agreement of county chief-elected officials, administered by the Atlanta Regional Commission and funded for training and employment activities under the federal Workforce Investment Act (WIA). For more information on ARC’s Workforce Development programs and services please consult www.atlantaregional.com/workforce/workforce.html.RDC_AAA = ARC Area Agency on Aging is a 10-county area funded by the Department of Human Resources and designated by the Older Americans Act to plan for the needs of the rapidly expanding group of older citizens in the Atlanta region. It is part of a statewide network of 12 AAAs and a national network of more than 670 AAAs. For more information on aging services please consult www.agewiseconnection.com.MNGWPD = The Metro North Georgia Water Planning District provides water resource plans, policies and coordination for metropolitan Atlanta. The District has developed regional plans for stormwater management, wastewater treatment and water supply and water conservation. The 15-county Water Planning District includes the ten counties in the ARC plus five additional counties (Bartow, Coweta, Forsyth, Hall, & Paulding). For more information please consult www.northgeorgiawater.org. MPO = The Metropolitan Planning Organization (MPO) is a 19-county area federally-designated for regional transportation planning to meet air quality standards and for programming projects to implement the adopted Regional Transportation Plan (RTP). The MPO planning area boundary includes the 10-county state-designated Regional Commission and nine additional counties (all of Coweta, Forsyth, & Paulding and parts of Barrow, Dawson, Newton, Pike, Spalding and Walton). This boundary takes into consideration both the current urbanized area as well as areas forecast to become urbanized in the next 20 years.MSA = the 29-County “Atlanta-Sandy Springs-Roswell, GA” Metropolitan Statistical Area (MSA) and the 39-county “Atlanta--Athens-Clarke County--Sandy Springs, GA” Combined Statistical Area (CSA), which includes the 29 counties of the Atlanta MSA along with the Athens-Clarke County and Gainesville MSAs and the micropolitan statistical areas of Calhoun, Cedartown, Jefferson, LaGrange and Thomaston, GA. The U.S. Office of Management and Budget (OMB) defines CSAs, MSAs and the smaller micropolitan statistical areas nationwide according to published standards applied to U.S. Census Bureau data. These various statistical areas describe substantial core areas of population together with adjacent communities having a high degree of economic and social integration, often illustrated in high rates of commuting from the adjacent areas to job locations in the core. For more information, please consult http://www.census.gov/population/metro/data/metrodef.htmlF1HR_NA = The Federal 1-Hour Air Quality Non-Attainment Area is a fine particulate matter standard (PM2.5). The non-attainment area under this standard includes the 15-county eight-hour ozone nonattainment area plus Barrow, Carroll, Hall, Spalding, Walton, and small parts of Heard and Putnam counties.F8HR_NA: The Federal 8-Hour Air Quality Non-Attainment Area for the 2008 eight-hour ozone standard is 15 counties.ACRES = The number of acres contained within the Block Group.SQ_MILES = The number of square miles contained within the Block Group.Source: United States Census Bureau, Atlanta Regional CommissionDate: 2000For additional information, please visit the Atlanta Regional Commission at www.atlantaregional.com.

Schema: Patent No (x) Inventor Name (y) Inventor Last Name (before the semicolon) Inventor First Name + Middle Name (after the semicolon) Original Sequence of (y) in (x) Disambiguated Inventor ID X,XXX,XXX-Y, where X,XXX,XXX is the very first patent of that inventor and Y is the order of appearance of that inventor in X,XXX,XXX City State Country County name IF IN USA FIPS 5-digit (state + city combined) IF IN USA FIPS 2-digit (state code) IF IN USA FIPS 3-digit (city code) IF IN USA Latitude disambiguated Longitude disambiguated Zipcode IF IN USA Metropolitan statistical area (MSA) IF IN USA Assignee PDPASS Data source: Latitude, longitude: Google MAP API County and FIPS code: US Census Zipcode and ZCTA translation: USPS MSA: US Department of Labor Assignee PDPASS: based on NBER 1976-2006, expanded by way of KNN