Lobbyist Data - Lobbyist, Employer, Client Combinations

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id 2eqz-3nvz
Name Lobbyist Data - Lobbyist, Employer, Client Combinations
Attribution City of Chicago
Category Ethics
Tags ethics, lobbyists
Created 2015-06-10T21:27:46Z
Publication Date 2015-10-20T22:04:15Z

Description

Each unique combination of a lobbyist, his/her employer, and a client of that employer. This dataset can be used to see relationships between these three entities. Each has a separate dataset with more detailed information about each lobbyist, employer, or client. 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      | time        | year                    | Year                    | number    | number      |
| Yes      | series tag  | lobbyist_id             | LOBBYIST_ID             | text      | number      |
| Yes      | series tag  | employer_id             | EMPLOYER_ID             | text      | number      |
| Yes      | series tag  | client_id               | CLIENT_ID               | text      | number      |
| Yes      | series tag  | lobbyist_salutation     | LOBBYIST_SALUTATION     | text      | text        |
| 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      | series tag  | lobbyist_suffix         | LOBBYIST_SUFFIX         | text      | text        |
| Yes      | series tag  | employer_name           | EMPLOYER_NAME           | text      | text        |
| Yes      | series tag  | client_name             | CLIENT_NAME             | text      | text        |

Time Field

Value = year
Format & Zone = yyyy

Data Commands

Meta Commands

entity e:2eqz-3nvz l:"Lobbyist Data - Lobbyist, Employer, Client Combinations" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/2eqz-3nvz

property e:2eqz-3nvz t:meta.view v:id=2eqz-3nvz v:category=Ethics v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="Lobbyist Data - Lobbyist, Employer, Client Combinations" v:attribution="City of Chicago"

property e:2eqz-3nvz t:meta.view.owner v:id=vewm-vupz v:screenName="Jonathan Levy" v:displayName="Jonathan Levy"

property e:2eqz-3nvz t:meta.view.tableauthor v:id=vewm-vupz v:screenName="Jonathan Levy" v:roleName=administrator v:displayName="Jonathan Levy"

Top Records

| year | lobbyist_id | employer_id | client_id | lobbyist_salutation | lobbyist_first_name | lobbyist_middle_initial | lobbyist_last_name | lobbyist_suffix | employer_name          | client_name                        | 
| ==== | =========== | =========== | ========= | =================== | =================== | ======================= | ================== | =============== | ====================== | ================================== | 
| 2011 | 6448        | 4357        | 12296     | Mr                  | Richard             | R                       | Boykin             |                 | Barnes & Thormburg LLP | Youth Connection Charter School    | 
| 2011 | 6450        | 4359        | 12300     | Mr                  | John                | J                       | George             |                 | Daley and George LLP   | Chicago University Commons LLC     | 
| 2011 | 6450        | 4359        | 13615     | Mr                  | John                | J                       | George             |                 | Daley and George LLP   | Boyce-II, LLC                      | 
| 2011 | 6450        | 4359        | 13618     | Mr                  | John                | J                       | George             |                 | Daley and George LLP   | Fourth Presbyterian Church         | 
| 2011 | 6450        | 4359        | 13620     | Mr                  | John                | J                       | George             |                 | Daley and George LLP   | Orchard Heritage Inc               | 
| 2011 | 6450        | 4359        | 13624     | Mr                  | John                | J                       | George             |                 | Daley and George LLP   | Behringer Harvard Burnham LLC      | 
| 2011 | 6450        | 4359        | 13635     | Mr                  | John                | J                       | George             |                 | Daley and George LLP   | SF CH I, LLC                       | 
| 2011 | 6454        | 4363        | 12350     | Mr                  | Thomas              | R                       | Donovan            |                 | Donovan Group LLC      | Quantum Crossings, LLC             | 
| 2011 | 6455        | 4364        | 12359     | Mr                  | John                | J                       | Kelly, Jr.         |                 | ALL-CIRCO, Inc.        | Kinder Morgan Energy Partners      | 
| 2011 | 6458        | 4367        | 12372     | Mr                  | Richard             |                         | Klawiter           |                 | DLA Piper US LLP       | Preservation of Affordable Housing |