Cicero District Match Data Layout#
Introduction#
Fuel your grassroots advocacy campaign or complete targeted mailings in minutes. Upload a spreadsheet of addresses and we’ll return it stamped with the legislators and districts you need.
Appends a wealth of information including legislative districts and our extensive elected official contact information.
Your matched spreadsheet will be returned within hours.
Sample File#
Click here to download the sample file.
Layout and Definitions#
Geocoded Results#
Column Name |
Definition |
|---|---|
Latitude |
Latitude coordinate of geocoded address *for geocoding projects only |
Longitude |
Longitude coordinate of geocoded address *for geocoding projects only |
Geocoded Address |
Geocoded address *for geocoding projects only |
District and Elected Official Information#
Column Name |
Type |
Definition |
|---|---|---|
Status |
Whether the address was Matched or Unmatched to officials |
|
City |
nvarchar (256) |
City of district/official *local level results only |
County |
nvarchar (256) |
County of district/official *local level results only |
District ID |
varchar (100) |
District identifier for official |
Chamber |
varchar (256) |
Name of official’s legislative chamber |
Role |
varchar (256) |
Official’s legislative role |
Party |
varchar (256) |
Political party designation of the official |
First Name |
varchar (256) |
First name of the Official |
Middle Initial |
varchar (256) |
Middle initial of middle name of the Official |
Last Name |
varchar (256) |
Last name of the Official |
Name Suffix |
varchar (256) |
Name suffix of the Official |
Preferred Name |
varchar (256) |
Nickname or preferred name of the Official |
Primary Address 1 |
varchar (256) |
First line of official’s primary (capitol) address |
Primary Address 2 |
varchar (256) |
Second line of official’s primary (capitol) address |
Primary Address 3 |
varchar (256) |
Third line of official’s primary (capitol) address |
Primary City |
varchar (256) |
City of official’s primary address |
Primary State |
varchar (256) |
State of official’s primary address |
Primary Postal |
varchar (256) |
Postal code of official’s primary address |
Primary Phone 1 |
varchar (256) |
Official’s primary phone number |
Primary Phone 2 |
varchar (256) |
Official’s alternate phone at primary address |
Primary Fax 1 |
varchar (256) |
Official’s primary fax number |
Primary Fax 2 |
varchar (256) |
Official’s alternate fax at primary address |
Secondary Address 1 |
varchar (256) |
First line of official’s secondary (district) address |
Secondary Address 2 |
varchar (256) |
Second line of official’s secondary (district) address |
Secondary Address 3 |
varchar (256) |
Third line of official’s secondary (district) address |
Secondary City |
varchar (256) |
City of official’s secondary address |
Secondary State |
varchar (256) |
State of official’s secondary address |
Secondary Postal |
varchar (256) |
Postal code of official’s secondary address |
Secondary Phone 1 |
varchar (256) |
Official’s phone number at secondary address |
Secondary Phone 2 |
varchar (256) |
Official’s alternate phone at secondary address |
Secondary Fax 1 |
varchar (256) |
Official’s fax number at secondary address |
Secondary Fax 2 |
varchar (256) |
Official’s alternate fax at secondary address |
Email 1 |
varchar (256) |
Official’s primary (capitol) email address |
Email 2 |
varchar (256) |
Official’s secondary email address |
Photo Origin URL |
varchar (256) |
URL of the Official’s photo |
URL 1 |
varchar (1024) |
URL of Official’s primary website. Usually the official city/state/national web site with information on the legislator. |
URL 2 |
varchar (1024) |
URL of Official’s secondary website. This may be a web site privately maintained by a legislator. |
Web Form URL |
varchar (1024) |
URL of the Official’s web contact form |
We are able to match locations to elected officials according to our current data coverage. If we are unable to match your addresses or coordinates to elected official data, you will not be charged for the data stamping fee.