Lobbyist Data - Compensation

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id dw2f-w78u
Name Lobbyist Data - Compensation
Attribution City of Chicago
Category Ethics
Tags ethics, lobbyists
Created 2015-06-16T17:46:26Z
Publication Date 2015-10-20T16:58:37Z

Description

Lobbying-related compensation received by registered lobbyists as reported in their quarterly reports.
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   |
| ======== | ============== | ======================= | ======================= | ============= | ============= |
| Yes      | series tag     | compensation_id         | COMPENSATION_ID         | text          | number        |
| Yes      | time           | period_start            | PERIOD_START            | calendar_date | calendar_date |
| No       |                | period_end              | PERIOD_END              | calendar_date | calendar_date |
| Yes      | series tag     | lobbyist_id             | LOBBYIST_ID             | text          | number        |
| Yes      | series tag     | lobbyist_first_name     | LOBBYIST_FIRST_NAME     | text          | text          |
| Yes      | series tag     | lobbyist_middle_initial | LOBBYIST_MIDDLE_INITIAL | text          | text          |
| Yes      | series tag     | lobbyist_last_name      | LOBBYIST_LAST_NAME      | text          | text          |
| Yes      | numeric metric | compensation_amount     | COMPENSATION_AMOUNT     | money         | money         |
| Yes      | series tag     | client_id               | CLIENT_ID               | text          | number        |
| Yes      | series tag     | client_name             | CLIENT_NAME             | text          | text          |
| No       |                | created_date            | CREATED_DATE            | calendar_date | calendar_date |

Time Field

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

Series Fields

Excluded Fields = period_end,created_date

Data Commands

series e:dw2f-w78u d:2012-01-01T00:00:00.000Z t:lobbyist_first_name=John t:lobbyist_id=7106 t:client_id=12789 t:compensation_id=33 t:client_name="Spaan Tech" t:lobbyist_last_name=Dunn t:lobbyist_middle_initial=F m:compensation_amount=5000

series e:dw2f-w78u d:2012-01-01T00:00:00.000Z t:lobbyist_first_name=John t:lobbyist_id=8081 t:client_id=12784 t:compensation_id=299 t:client_name="Hudson Group" t:lobbyist_last_name=Dunn t:lobbyist_middle_initial=F m:compensation_amount=52500

series e:dw2f-w78u d:2012-01-01T00:00:00.000Z t:lobbyist_first_name=Mariah t:lobbyist_id=5947 t:client_id=12732 t:compensation_id=328 t:client_name="Great Lakes Prinicipals  c%2fo CD_EP Retail JV LLC" t:lobbyist_last_name=DiGrino m:compensation_amount=25000

Meta Commands

metric m:compensation_amount p:integer l:COMPENSATION_AMOUNT t:dataTypeName=money

entity e:dw2f-w78u l:"Lobbyist Data - Compensation" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/dw2f-w78u

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

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

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

Top Records

| compensation_id | period_start        | period_end          | lobbyist_id | lobbyist_first_name | lobbyist_middle_initial | lobbyist_last_name | compensation_amount | client_id | client_name                                       | created_date        | 
| =============== | =================== | =================== | =========== | =================== | ======================= | ================== | =================== | ========= | ================================================= | =================== | 
| 33              | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 7106        | John                | F                       | Dunn               | 5000                | 12789     | Spaan Tech                                        | 2012-08-02T00:00:00 | 
| 299             | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 8081        | John                | F                       | Dunn               | 52500               | 12784     | Hudson Group                                      | 2012-08-08T00:00:00 | 
| 328             | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 5947        | Mariah              |                         | DiGrino            | 25000               | 12732     | Great Lakes Prinicipals c%2fo CD_EP Retail JV LLC | 2012-08-09T00:00:00 | 
| 402             | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 5710        | John                |                         | Gust               | 3365                | 12163     | Jefferies & Company Inc                           | 2012-08-10T00:00:00 | 
| 496             | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 7005        | John                | F                       | Kattner            | 1500                | 11807     | Thermal Chicago Corp.                             | 2012-08-14T00:00:00 | 
| 506             | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 6039        | Michael             | R                       | Lufrano            | 2000                | 12925     | Chicago Cubs Baseball Club LLC                    | 2012-08-14T00:00:00 | 
| 740             | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 7744        | Langdon             | D                       | Neal               | 1800                | 11633     | Odessy Loft owners                                | 2012-08-23T00:00:00 | 
| 798             | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 6980        | Bridget             | M                       | O'Keefe            | 1600                | 12678     | Remus Partners LLC                                | 2012-08-23T00:00:00 | 
| 806             | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 5988        | Kevin               | P                       | O'Hara             | 4200                | 12822     | Chicago Parking Meters LLC                        | 2012-08-23T00:00:00 | 
| 815             | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 7082        | Samuel              |                         | Panayotovich       | 14000               | 14302     | 7-Eleven, Inc                                     | 2012-08-23T00:00:00 |