Lobbyist Data - Clients

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id g8p5-y4m5
Name Lobbyist Data - Clients
Attribution City of Chicago
Category Ethics
Tags ethics, lobbyists
Created 2015-06-10T19:40:12Z
Publication Date 2015-09-01T22:01:07Z

Description

Clients represented by registered lobbyists as reported in their Lobbyist Statements of Registration. Due to requirements for lobbyists to re-register and the importance of showing year for most lobbying-related data, the same client 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  | client_id    | CLIENT_ID    | text          | number        |
| Yes      | series tag  | name         | NAME         | 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      | time        | created_date | CREATED_DATE | calendar_date | calendar_date |
| Yes      | series tag  | active       | ACTIVE       | text          | text          |

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:g8p5-y4m5 d:2015-06-12T15:13:42.000Z t:zip=60616 t:name="Mercy Hospital and Medical Center" t:state=IL t:active=Y t:client_id=12301 t:country="United States" t:city=Chicago m:row_number.g8p5-y4m5=1

series e:g8p5-y4m5 d:2015-06-12T15:13:42.000Z t:zip=60601 t:name="International Property Developers" t:state=IL t:active=Y t:client_id=12314 t:country="United States" t:city=Chicago m:row_number.g8p5-y4m5=2

series e:g8p5-y4m5 d:2015-06-12T15:13:42.000Z t:zip=60625 t:name="Ten East Delaware LLC" t:state=IL t:active=Y t:client_id=12315 t:country="United States" t:city=Chicago m:row_number.g8p5-y4m5=3

Meta Commands

metric m:row_number.g8p5-y4m5 p:long l:"Row Number"

entity e:g8p5-y4m5 l:"Lobbyist Data - Clients" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/g8p5-y4m5

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

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

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

Top Records

| year | client_id | name                              | address_1                     | address_2 | city       | state | zip   | country       | created_date | active | 
| ==== | ========= | ================================= | ============================= | ========= | ========== | ===== | ===== | ============= | ============ | ====== | 
| 2011 | 12301     | Mercy Hospital and Medical Center | 2525 S. Michigan Avenue       |           | Chicago    | IL    | 60616 | United States |              | Y      | 
| 2011 | 12314     | International Property Developers | 404 W. Harrison               |           | Chicago    | IL    | 60601 | United States |              | Y      | 
| 2011 | 12315     | Ten East Delaware LLC             | 321 N. Clark , Ste. 2500      |           | Chicago    | IL    | 60625 | United States |              | Y      | 
| 2011 | 13630     | Tsang, Terry                      | 2539 N. Kedzie, Ste. 6        |           | Chicag     | Il    | 60647 | United States |              | Y      | 
| 2011 | 13634     | BRB Development                   | 800 Frontage Rd               |           | Northfield | IL    | 60093 | United States |              | Y      | 
| 2011 | 12323     | Harmening, Thomas (Mr. & Mrs.)    | 1834 N. Cleveland Ave.        |           | Chicago    | IL    | 60614 | United States |              | Y      | 
| 2011 | 13639     | Halsted Grace Ventures, LLC       | 4104 N. Harlem                |           | Norridge   | IL    | 60706 | United States |              | Y      | 
| 2011 | 13644     | SOS Children's Village Illinois   | 216 W Jackson Blvd, Ste. 925  |           | Chicago    | IL    | 60606 | United States |              | Y      | 
| 2011 | 13645     | Solo Cup Co.                      | 150 S. Saunders Rd., Ste. 150 |           | Chicago    | IL    | 60045 | United States |              | Y      | 
| 2011 | 12348     | United Airlines                   | 77 West Wacker Dr             |           | Chicago    | IL    | 60601 | United States |              | Y      |