Lobbyist Data - Gifts

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id 5d79-9xqr
Name Lobbyist Data - Gifts
Attribution City of Chicago
Category Ethics
Tags ethics, lobbyists
Created 2015-04-24T22:05:06Z
Publication Date 2015-10-20T21:55:11Z

Description

Every gift made by a registered lobbyist during the reporting period to an official or employee of the City. 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     | gift_id              | GIFT_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     | gift                 | GIFT                 | text          | text          |
| Yes      | series tag     | recipient_first_name | RECIPIENT_FIRST_NAME | text          | text          |
| Yes      | series tag     | recipient_last_name  | RECIPIENT_LAST_NAME  | text          | text          |
| Yes      | series tag     | recipient_title      | RECIPIENT_TITLE      | text          | text          |
| Yes      | numeric metric | value                | VALUE                | money         | money         |
| Yes      | series tag     | department           | DEPARTMENT           | text          | text          |
| Yes      | series tag     | lobbyist_id          | LOBBYIST_ID          | text          | number        |
| Yes      | series tag     | lobbyist_firstname   | LOBBYIST_FIRSTNAME   | text          | text          |
| Yes      | series tag     | lobbyist_lastname    | LOBBYIST_LASTNAME    | 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:5d79-9xqr d:2012-10-01T00:00:00.000Z t:recipient_last_name=Erickson t:gift=candy t:recipient_first_name=Carl t:lobbyist_id=6051 t:department="CITY COUNCIL / ALDERMEN" t:gift_id=1101 t:lobbyist_lastname=Zaio t:lobbyist_firstname=Constance t:recipient_title="Adm. Asst" m:value=12

series e:5d79-9xqr d:2012-01-01T00:00:00.000Z t:recipient_last_name=Horton-Newkirk t:gift=lunch t:recipient_first_name=Elizabeth t:lobbyist_id=6077 t:department="FIRE DEPARTMENT" t:gift_id=288 t:lobbyist_lastname=Garman t:lobbyist_firstname=Amy t:recipient_title=employee m:value=12

series e:5d79-9xqr d:2012-01-01T00:00:00.000Z t:recipient_last_name=O'Connor t:gift=Breakfast t:recipient_first_name=Mary t:lobbyist_id=6082 t:department="CITY COUNCIL / ALDERMEN" t:gift_id=88 t:lobbyist_lastname=Lynch t:lobbyist_firstname=Daniel t:recipient_title=Alderman m:value=24

Meta Commands

metric m:value p:double l:VALUE t:dataTypeName=money

entity e:5d79-9xqr l:"Lobbyist Data - Gifts" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/5d79-9xqr

property e:5d79-9xqr t:meta.view v:id=5d79-9xqr v:category=Ethics v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="Lobbyist Data - Gifts" v:attribution="City of Chicago"

property e:5d79-9xqr t:meta.view.owner v:id=vewm-vupz v:screenName="Jonathan Levy" v:displayName="Jonathan Levy"

property e:5d79-9xqr t:meta.view.tableauthor v:id=vewm-vupz v:screenName="Jonathan Levy" v:roleName=administrator v:displayName="Jonathan Levy"

Top Records

| gift_id | period_start        | period_end          | gift                                               | recipient_first_name | recipient_last_name | recipient_title | value | department                       | lobbyist_id | lobbyist_firstname | lobbyist_lastname | created_date        | 
| ======= | =================== | =================== | ================================================== | ==================== | =================== | =============== | ===== | ================================ | =========== | ================== | ================= | =================== | 
| 1101    | 2012-10-01T00:00:00 | 2012-12-31T00:00:00 | candy                                              | Carl                 | Erickson            | Adm. Asst       | 12    | CITY COUNCIL / ALDERMEN          | 6051        | Constance          | Zaio              | 2013-01-29T00:00:00 | 
| 288     | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | lunch                                              | Elizabeth            | Horton-Newkirk      | employee        | 12    | FIRE DEPARTMENT                  | 6077        | Amy                | Garman            | 2012-09-11T00:00:00 | 
| 88      | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | Breakfast                                          | Mary                 | O'Connor            | Alderman        | 24    | CITY COUNCIL / ALDERMEN          | 6082        | Daniel             | Lynch             | 2012-08-14T00:00:00 | 
| 583     | 2012-07-01T00:00:00 | 2012-09-30T00:00:00 | meal / snack                                       | Deborah              | Graham              | alderman        | 13    | CITY COUNCIL / ALDERMEN          | 6123        | Amy                | Brennan           | 2012-10-30T00:00:00 | 
| 601     | 2012-07-01T00:00:00 | 2012-09-30T00:00:00 | None                                               | None                 | None                | None            | 0     | WORLD BUSINESS CHICAGO           | 5703        | Michael            | Laube             | 2012-10-31T00:00:00 | 
| 933     | 2012-10-01T00:00:00 | 2012-12-31T00:00:00 | Gift Basket                                        | Tamra                | Collins             | Ms.             | 46.45 | HOUSING AND ECONOMIC DEVELOPMENT | 6982        | Virginia           | Pace              | 2013-01-14T00:00:00 | 
| 1047    | 2012-10-01T00:00:00 | 2012-12-31T00:00:00 | Lunch                                              | Michael              | Zalewski            | Alderman        | 17.79 | CITY COUNCIL / ALDERMEN          | 5778        | Margaret           | Houlihan          | 2013-01-17T00:00:00 | 
| 1044    | 2012-10-01T00:00:00 | 2012-12-31T00:00:00 | Lunch                                              | Timothy              | Cullerton           | Alderman        | 17.79 | CITY COUNCIL / ALDERMEN          | 5778        | Margaret           | Houlihan          | 2013-01-17T00:00:00 | 
| 939     | 2012-10-01T00:00:00 | 2012-12-31T00:00:00 | Gift Basket                                        | Lawrence             | Grisham             | Mr              | 46.45 | HOUSING AND ECONOMIC DEVELOPMENT | 5872        | Lawrence           | Pusateri          | 2013-01-14T00:00:00 | 
| 255     | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | Invitation for breakfast at Chamber Annual Meeting | Gabe                 | Klein               | commissioner    | 35    | TRANSPORTATION                   | 5980        | Michael            | Mini              | 2012-08-29T00:00:00 |