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 |