Lobbyist Data - Lobbyists

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id tq3e-t5yq
Name Lobbyist Data - Lobbyists
Attribution City of Chicago
Category Ethics
Tags ethics, lobbyists
Created 2015-04-24T21:58:19Z
Publication Date 2015-10-20T22:06:25Z

Description

Lobbyists registered with the Chicago Board of Ethics since 2012. Due to requirements for lobbyists to re-register and the importance of showing year for most lobbying-related data, the same lobbyist often will have multiple records. See http://www.cityofchicago.org/city/en/depts/ethics/provdrs/lobby.html for more information on the Board of Ethics’ role in regulating and reporting on lobbying in Chicago.

Columns

| Included | Schema Type | Field Name     | Name           | Data Type     | Render Type   |
| ======== | =========== | ============== | ============== | ============= | ============= |
| No       |             | year           | YEAR           | number        | number        |
| Yes      | series tag  | lobbyist_id    | LOBBYIST_ID    | text          | number        |
| Yes      | series tag  | salutation     | SALUTATION     | text          | text          |
| Yes      | series tag  | first_name     | FIRST_NAME     | text          | text          |
| Yes      | series tag  | middle_initial | MIDDLE_INITIAL | text          | text          |
| Yes      | series tag  | last_name      | LAST_NAME      | text          | text          |
| Yes      | series tag  | suffix         | SUFFIX         | text          | text          |
| No       |             | address_1      | ADDRESS_1      | text          | text          |
| No       |             | address_2      | ADDRESS_2      | text          | text          |
| Yes      | series tag  | city           | CITY           | text          | text          |
| Yes      | series tag  | state          | STATE          | text          | text          |
| Yes      | series tag  | zip            | ZIP            | text          | text          |
| Yes      | series tag  | country        | COUNTRY        | text          | text          |
| Yes      | series tag  | email          | EMAIL          | text          | text          |
| Yes      | series tag  | phone          | PHONE          | text          | text          |
| Yes      | series tag  | fax            | FAX            | text          | text          |
| Yes      | series tag  | employer_id    | EMPLOYER_ID    | text          | number        |
| Yes      | series tag  | employer_name  | EMPLOYER_NAME  | text          | text          |
| Yes      | time        | created_date   | CREATED_DATE   | calendar_date | calendar_date |

Time Field

Value = created_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = address_1,address_2,year

Data Commands

series e:tq3e-t5yq d:2015-06-09T14:10:04.000Z t:first_name=Marilyn t:employer_id=4089 t:zip=60610 t:phone=312-822-0505 t:fax=312-822-0568 t:email=mkatz@mkcpr.com t:lobbyist_id=6152 t:employer_name="MK Communications" t:last_name=Katz t:state=IL t:salutation=Ms t:country="United States" t:city=Chicago m:row_number.tq3e-t5yq=1

series e:tq3e-t5yq d:2015-06-09T14:10:04.000Z t:zip=60638 t:employer_id=4090 t:phone=773-586-8181 t:fax=773-586-8182 t:lobbyist_id=6153 t:middle_initial=J t:employer_name="Intergovernmental Consulting Group, Inc" t:state=Il t:city=Chicago t:country="United States" t:first_name=Mark t:email=mfary.icg@sbcglobal.net t:last_name=Fary t:salutation=Mr m:row_number.tq3e-t5yq=2

series e:tq3e-t5yq d:2015-06-09T14:10:04.000Z t:zip=60603 t:employer_id=4091 t:phone=312-346-7500 t:fax=312-580-2201 t:lobbyist_id=6154 t:middle_initial=P t:employer_name="Thompson Coburn LLP (dba Thompson Coburn Fagel Haber)" t:state=IL t:suffix=Esq t:city=Chicago t:country="United States" t:first_name=Clinton t:email=chansen@tcfhlaw.com t:last_name=Hansen t:salutation=Mr m:row_number.tq3e-t5yq=3

Meta Commands

metric m:row_number.tq3e-t5yq p:long l:"Row Number"

entity e:tq3e-t5yq l:"Lobbyist Data - Lobbyists" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/tq3e-t5yq

property e:tq3e-t5yq t:meta.view v:id=tq3e-t5yq v:category=Ethics v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="Lobbyist Data - Lobbyists" v:attribution="City of Chicago"

property e:tq3e-t5yq t:meta.view.owner v:id=vewm-vupz v:screenName="Jonathan Levy" v:displayName="Jonathan Levy"

property e:tq3e-t5yq t:meta.view.tableauthor v:id=vewm-vupz v:screenName="Jonathan Levy" v:roleName=administrator v:displayName="Jonathan Levy"

Top Records

| year | lobbyist_id | salutation | first_name | middle_initial | last_name | suffix | address_1                          | address_2 | city        | state | zip   | country       | email                        | phone        | fax          | employer_id | employer_name                                         | created_date | 
| ==== | =========== | ========== | ========== | ============== | ========= | ====== | ================================== | ========= | =========== | ===== | ===== | ============= | ============================ | ============ | ============ | =========== | ===================================================== | ============ | 
| 2011 | 6152        | Ms         | Marilyn    |                | Katz      |        | 350 W. Hubbard St. #200            |           | Chicago     | IL    | 60610 | United States | mkatz@mkcpr.com              | 312-822-0505 | 312-822-0568 | 4089        | MK Communications                                     |              | 
| 2011 | 6153        | Mr         | Mark       | J              | Fary      |        | 6808 W. Archer Ave                 |           | Chicago     | Il    | 60638 | United States | mfary.icg@sbcglobal.net      | 773-586-8181 | 773-586-8182 | 4090        | Intergovernmental Consulting Group, Inc               |              | 
| 2011 | 6154        | Mr         | Clinton    | P              | Hansen    | Esq    | 55 E. Monroe St. 40th Flr          |           | Chicago     | IL    | 60603 | United States | chansen@tcfhlaw.com          | 312-346-7500 | 312-580-2201 | 4091        | Thompson Coburn LLP (dba Thompson Coburn Fagel Haber) |              | 
| 2011 | 6155        | Mr         | Kenneth    | G              | Snyder    |        | 55 W. Van Buren                    |           | Chicago     | IL    | 60605 | United States | ksnyder@unitehere.org        | 312-663-4373 | 312-986-3828 | 4092        | Unite Here Local 1                                    |              | 
| 2011 | 6156        | Mr         | Jerome     | F              | Mytych    |        | 2004 Miner St., 2nd Floor          |           | Des Plaines | IL    | 60016 | United States | jm6714@att.com               | 847-759-5261 | 847-759-5263 | 4093        | AT&T Illinois                                         |              | 
| 2011 | 6157        | Mr         | COURTNEY   | C              | NOTTAGE   |        | 222 NORTH LASALLE STREET SUITE 300 |           | CHICAGO     | IL    | 60601 | United States | courtneynottage@aol.com      | 312-704-3812 | 312-368-4944 | 4094        | Fletcher, O'Brien, Kasper & Nottage, PC               |              | 
| 2011 | 6158        | Mr         | MICHAEL    | J              | KASPER    |        | 222 NORTH LASALLE STREET SUITE 300 |           | CHICAGO     | IL    | 60601 | United States | mjkasper60@aol.com           | 314-704-3292 | 312-368-4944 | 4095        | Fletcher, O'Brien, Kasper & Nottage, PC               |              | 
| 2011 | 6159        | Mr         | Richard    | J              | Guidice   |        | 350 W. 22nd Street, #106           |           | Lombard     | IL    | 60148 | United States | ccgillinois@msn.com          | 6309167400   | 6309167900   | 4096        | Capitol Consulting Group Illionis, LLC                |              | 
| 2011 | 6160        | Mr         | Anthony    | B              | Abbinante |        | 333 W. Wacker Drive, Suite 1100    |           | Chicago     | IL    | 60606 | United States | anthony.abbinante@diageo.com | 3122793464   | 3122793537   | 4740        | Diageo NA                                             |              | 
| 2011 | 6161        | Mr         | Dennis     | E              | Sexton    |        | 12 E. Erie St.                     |           | Chicago     | Il    | 60611 | United States | cidrovo@carpentersunion.org  | 3129511509   | 3129881722   | 4097        | Chicago Regional Council of Carpenters                |              |