Data Layout#
Introduction#
Match zip codes to national, state, or local legislative districts with our zip code lookup files. Choose from a variety of options and match types.
Though less accurate than full address matching, zip codes are still a popular way to match areas to legislative districts. We provide 5 or 9 digit zip to district files that can be customized to your needs at any level of government. We can also improve the match rate with our population based zip to district matching.
List of Files#
Click on the file name to download the sample file.
Layout and Definitions#
Column Name |
Type |
Definition |
|---|---|---|
zipcode |
nvarchar (5) leading zeroes will be preserved |
5-digit zipcode as designated by USPS (from source zipcode data) |
plus4low |
nvarchar (4) leading zeroes will be preserved |
zipcode add-on low number in the range (from source zipcode data) |
plus4high |
nvarchar (4) leading zeroes will be preserved |
zipcode add-on high number in the range (from source zipcode data) |
zip_state |
nvarchar (2) |
state abbreviation (from source zipcode data) |
county_fips |
nvarchar (3) leading zeroes will be preserved |
county FIPS identifier (from source zipcode data) |
state_fips |
nvarchar (2) leading zeroes will be preserved |
state FIPS identifier (from source zipcode data) |
city |
nvarchar (28) |
city name (from source zipcode data) |
district_id |
nvarchar (100) |
ID of the state legislative or Congressional district. For states with At Large Congressional districts, the district ID is the state abbreviation. |
district_state |
nvarchar (100) |
state abbreviation from the Cicero database (included for quality purposes) |
Chamber |
nvarchar (256) |
Name of official’s legislative chamber |
cicero_id |
integer |
internal Cicero identifier for the district |
subtype |
nvarchar (50) |
internal hierarchical descriptor for district type |
district_type |
nvarchar (100) |
internal hierarchical descriptor that refers to chamber type and district subtype |
ocd_id |
nvarchar (1024) |
Open Civic Data Identifier |
label |
nvarchar (100) |
plain English district description |