Lobbyist Data - Employers

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id dmeb-2zra
Name Lobbyist Data - Employers
Attribution City of Chicago
Category Ethics
Tags ethics, lobbyists
Created 2015-06-09T22:21:28Z
Publication Date 2015-10-20T21:01:58Z

Description

Employers of registered lobbyists as reported in the Lobbyist Statement of Registration. Due to requirements for lobbyists to re-register, the importance of showing year for most lobbying-related data, and some employers being reported by multiple lobbyists, the same employer 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  | employer_id  | EMPLOYER_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      | series tag  | phone        | PHONE        | text          | text          |
| Yes      | series tag  | fax          | FAX          | 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:dmeb-2zra d:2015-06-15T13:59:07.000Z t:zip=60603 t:employer_id=4818 t:phone=312-920-1500 t:name="Lighten-Gale LLC" t:state=Il t:active=Y t:country="United States" t:city=Chicago m:row_number.dmeb-2zra=1

series e:dmeb-2zra d:2015-06-15T13:59:07.000Z t:zip=60602 t:employer_id=4099 t:phone=312-701-0221 t:fax=312-658-0464 t:name="Nicolay & Dart LLC" t:state=IL t:active=Y t:country="United States" t:city=Chicago m:row_number.dmeb-2zra=2

series e:dmeb-2zra d:2015-06-15T13:59:07.000Z t:zip=60602 t:employer_id=4099 t:phone=312-701-0221 t:fax=312-658-0464 t:name="Nicolay & Dart LLC" t:state=IL t:active=Y t:country="United States" t:city=Chicago m:row_number.dmeb-2zra=3

Meta Commands

metric m:row_number.dmeb-2zra p:long l:"Row Number"

entity e:dmeb-2zra l:"Lobbyist Data - Employers" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/dmeb-2zra

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

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

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

Top Records

| year | employer_id | name                         | address_1                     | address_2  | city    | state | zip   | country       | phone        | fax          | created_date        | active | 
| ==== | =========== | ============================ | ============================= | ========== | ======= | ===== | ===== | ============= | ============ | ============ | =================== | ====== | 
| 2011 | 4818        | Lighten-Gale LLC             | 39 S. LaSalle St., Ste. 808   |            | Chicago | Il    | 60603 | United States | 312-920-1500 |              |                     | Y      | 
| 2012 | 4099        | Nicolay & Dart LLC           | 33 N. Dearborn St. Ste.2200   |            | Chicago | IL    | 60602 | United States | 312-701-0221 | 312-658-0464 |                     | Y      | 
| 2011 | 4099        | Nicolay & Dart LLC           | 33 N. Dearborn St. Ste.2200   |            | Chicago | IL    | 60602 | United States | 312-701-0221 | 312-658-0464 |                     | Y      | 
| 2013 | 7141        | Carol Ronen                  | 6033 N. Sheridan Rd           |            | Chicago | IL    | 60660 | United States | 773-919-4240 |              | 2013-01-09T00:00:00 | Y      | 
| 2011 | 4687        | Thompson Coburn LLP          | 55 E Monroe - 40th Floor      |            | Chicago | IL    | 60603 | United States | 312-580-2228 | 312-580-2201 |                     | Y      | 
| 2011 | 4186        | Foley & Lardner, LLP         | 321 N Clark St. #2800         |            | Chicago | IL    | 60610 | United States | 312-832-4500 | 312-832-4700 |                     | Y      | 
| 2012 | 4202        | K & L Gates LLP              |                               |            |         |       |       | United States |              |              |                     | Y      | 
| 2011 | 4202        | K & L Gates LLP              |                               |            |         |       |       | United States |              |              |                     | Y      | 
| 2012 | 4368        | DLA Piper US LLP             | 203 N. LaSalle St. Suite 1900 |            | Chicago | IL    | 60601 | United States | 312-368-4000 | 312-236-7516 |                     | Y      | 
|      | 6642        | Carpenter Lipps & Leland LLP | 180 N. LaSalle Street         | Suite 2640 | Chicago | IL    | 60601 | United States | 3127772824   |              | 2012-11-15T00:00:00 | Y      |