Hello, I downloaded a total population table 2000-present. I selected options to have it by zip code, county, and congressional district. I received a few separate files, each one exclusive of another. I was hoping to have congressional district, zip code, and county all in one spreadsheet. Is there…

Hi Richard, Do you want to have the data structured so that each record is a unique combination of ZIP code, county and CD? We do not have a data file that provides information for that combination of geographic units. It is possible to generate a dataset like that from the decennial census data. …

Hello Dave, thank you for the reply. Yes, I was hoping to obtain that unique combination. A combination of zip codes-congressional district would work just as well. However, I know that a single zip code can, at times, map to several congressional districts. Also, from tables that I did download, it…

Hi Richard, I’ve looked at our 2000 block-level census data, and we don’t provide a ZIP code or congressional district code on those files. Thus, the way I thought you could generate the ZIP code - CD - County records will not work! Since we don’t have the codes in the data files, the fallback met…

I will also check with a colleague (who’s on vacation this week) about whether we have any internal 2000 block data with the ZIP codes and CD codes on them.

Hello Dave, thank you for your response. I believe that the first congressional districts drawn based on the 2000 census did not roll out until the 108th congress. So I believe that the 106th and 107th congressional districts were still based on the 1990 census, but there is a lag to how the CDs are…

Unfortunately, it is not a straightforward process to conduct the process if you’re not familiar with geospatial software. The basic outline is: Obtain 51 census block shapefiles from 2000 Obtain the CD and ZCTA shapefiles Merge them into a nationwide file Convert the blocks to centroids Overlay t…

Dave, thank you for the instructions. I will see if I can obtain ArcGIS or perhaps a free geospatial software if there is one? Regarding which block shapefiles to grab. You mention again the year 2000, but I am worried those will not align with the 106th and 107th CDs. Do you have information on th…

There are two possible free options for you to use. QGIS is a free, open-source GIS package. You can also do spatial analysis in R, if you use that for your other stats work. With respect to the 2000 census blocks vs. the 106th/107th CDs, I need a little more clarification about what you’re trying …

Dave, thank you for the clarification. I use Stata and SAS and only use R for limited tasks, so perhaps QGIS is my best bet. Okay, as I understand you, it does sound like the 2000 census blocks would be what I want then. Actually, all I really need is the CDs-zip code matches for the 106-107th CDs…

Hi Richard, I’m Dave’s colleague who was on vacation last week. I hope you’ve had some luck with your QGIS exploration. In case not, I pulled together some data to simplify your work. In this zip file , there’s a fixed-width data file and a data dictionary. The data file is an extract from our inter…

Joining data on congressional districts

Max_Ghenis August 8, 2021, 4:28am 17

Is there a similar tool or crosswalk from 2010 Census Block to latest (117th) Congressional District?

Topic		Replies	Views
Congressional districts/counties relationship files for the period 1953 -- 2010.	3	555	June 19, 2017
Is there a way to link addresses (street name,ZIP codes etc) and congressional districts since 1950s? USA	1	425	June 19, 2017
How can I identify congressional districts in 1986 CPS or Census (1980) data?	1	460	December 29, 2014
Is data on population size of congressional districts available for 1972-2012? Or at all, by interpolation?	1	468	February 12, 2015
Match 1860-1920 census data to county subdivisions in 2010 TIGER shapefile USA	3	903	September 10, 2014

Joining data on congressional districts

Related topics