Lobbyist Data - Expenditures - Small
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.cityofchicago.org |
| Id | eqdx-4qxd |
| Name | Lobbyist Data - Expenditures - Small |
| Attribution | City of Chicago |
| Category | Ethics |
| Tags | ethics, lobbyists |
| Created | 2015-06-18T20:29:07Z |
| Publication Date | 2015-10-20T20:59:24Z |
Description
Expenditures under $250 per transaction, summarized per three-month reporting period. Larger expenditures are itemized in https://data.cityofchicago.org/d/xika-473c. 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 | compensation_id | COMPENSATION_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 | lobbyist_id | LOBBYIST_ID | text | number |
| 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 | numeric metric | compensation_to_others_expense | COMPENSATION_TO_OTHERS_EXPENSE | money | money |
| Yes | numeric metric | office_expense | OFFICE_EXPENSE | money | money |
| Yes | numeric metric | personal_sustenance_expense | PERSONAL_SUSTENANCE_EXPENSE | money | money |
| Yes | numeric metric | public_education_expense | PUBLIC_EDUCATION_EXPENSE | money | money |
| Yes | numeric metric | other_expenses | OTHER_EXPENSES | money | money |
| Yes | numeric metric | total_expenses | TOTAL_EXPENSES | money | money |
| Yes | series tag | client_id | CLIENT_ID | text | number |
| Yes | series tag | client_name | CLIENT_NAME | 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:eqdx-4qxd d:2014-04-01T00:00:00.000Z t:lobbyist_first_name=Jeffrey t:lobbyist_id=17144 t:client_id=12433 t:compensation_id=23619 t:client_name="Goldman, Sachs & Co" t:lobbyist_last_name=Scruggs m:compensation_to_others_expense=0 m:other_expenses=0 m:public_education_expense=0 m:office_expense=0 m:total_expenses=505.5 m:personal_sustenance_expense=505.5
series e:eqdx-4qxd d:2012-01-01T00:00:00.000Z t:lobbyist_first_name=Freda t:lobbyist_id=5807 t:client_id=12433 t:compensation_id=597 t:client_name="Goldman, Sachs & Co" t:lobbyist_last_name=Wang m:compensation_to_others_expense=0 m:other_expenses=0 m:public_education_expense=0 m:office_expense=0 m:total_expenses=423.65 m:personal_sustenance_expense=423.65
series e:eqdx-4qxd d:2012-07-01T00:00:00.000Z t:lobbyist_first_name=Scott t:lobbyist_id=10225 t:client_id=12435 t:compensation_id=14552 t:client_name="US Bancorp Investments, Inc" t:lobbyist_last_name=Verch m:compensation_to_others_expense=0 m:other_expenses=0 m:public_education_expense=0 m:office_expense=0 m:total_expenses=352.6 m:personal_sustenance_expense=352.6
Meta Commands
metric m:compensation_to_others_expense p:double l:COMPENSATION_TO_OTHERS_EXPENSE t:dataTypeName=money
metric m:office_expense p:double l:OFFICE_EXPENSE t:dataTypeName=money
metric m:personal_sustenance_expense p:double l:PERSONAL_SUSTENANCE_EXPENSE t:dataTypeName=money
metric m:public_education_expense p:double l:PUBLIC_EDUCATION_EXPENSE t:dataTypeName=money
metric m:other_expenses p:double l:OTHER_EXPENSES t:dataTypeName=money
metric m:total_expenses p:double l:TOTAL_EXPENSES d:"Sum of the expense columns." t:dataTypeName=money
entity e:eqdx-4qxd l:"Lobbyist Data - Expenditures - Small" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/eqdx-4qxd
property e:eqdx-4qxd t:meta.view v:id=eqdx-4qxd v:category=Ethics v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="Lobbyist Data - Expenditures - Small" v:attribution="City of Chicago"
property e:eqdx-4qxd t:meta.view.owner v:id=vewm-vupz v:screenName="Jonathan Levy" v:displayName="Jonathan Levy"
property e:eqdx-4qxd t:meta.view.tableauthor v:id=vewm-vupz v:screenName="Jonathan Levy" v:roleName=administrator v:displayName="Jonathan Levy"
Top Records
| compensation_id | period_start | period_end | lobbyist_id | lobbyist_first_name | lobbyist_middle_initial | lobbyist_last_name | compensation_to_others_expense | office_expense | personal_sustenance_expense | public_education_expense | other_expenses | total_expenses | client_id | client_name | created_date |
| =============== | =================== | =================== | =========== | =================== | ======================= | ================== | ============================== | ============== | =========================== | ======================== | ============== | ============== | ========= | ================================== | =================== |
| 23619 | 2014-04-01T00:00:00 | 2014-06-30T00:00:00 | 17144 | Jeffrey | | Scruggs | 0 | 0 | 505.5 | 0 | 0 | 505.5 | 12433 | Goldman, Sachs & Co | 2014-07-07T00:00:00 |
| 597 | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 5807 | Freda | | Wang | 0 | 0 | 423.65 | 0 | 0 | 423.65 | 12433 | Goldman, Sachs & Co | 2012-08-21T00:00:00 |
| 14552 | 2012-07-01T00:00:00 | 2012-09-30T00:00:00 | 10225 | Scott | | Verch | 0 | 0 | 352.6 | 0 | 0 | 352.6 | 12435 | US Bancorp Investments, Inc | 2013-10-03T00:00:00 |
| 487 | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 5809 | Richard | E | Kolman | 0 | 0 | 61.74 | 0 | 0 | 61.74 | 12435 | US Bancorp Investments, Inc | 2012-08-14T00:00:00 |
| 21084 | 2014-01-01T00:00:00 | 2014-03-31T00:00:00 | 16611 | Richard | E | Kolman | 0 | 0 | 470 | 0 | 0 | 470 | 12436 | US Bank Municipal Securities Group | 2014-04-14T00:00:00 |
| 2488 | 2012-01-01T00:00:00 | 2012-06-30T00:00:00 | 9241 | Richard | E | Kolman | 0 | 0 | 61.74 | 0 | 0 | 61.74 | 12436 | US Bank Municipal Securities Group | 2012-09-27T00:00:00 |
| 8916 | 2013-01-01T00:00:00 | 2013-03-31T00:00:00 | 11103 | B. John | | Bisio | 0 | 0 | 480.44 | 0 | 0 | 480.44 | 12443 | Wal-Mart Stores, Inc. | 2013-04-18T00:00:00 |
| 28130 | 2014-07-01T00:00:00 | 2014-09-30T00:00:00 | 20187 | Ann | T | Moroney | 0 | 4418.36 | 0 | 0 | 0 | 4418.36 | 12469 | Swedish Covenant Hospital | 2014-10-15T00:00:00 |
| 25866 | 2014-01-01T00:00:00 | 2014-03-31T00:00:00 | 20383 | Bernard | I | Citron | 0 | 75 | 0 | 0 | 0 | 75 | 12470 | Imperial Realty Co. | 2014-07-31T00:00:00 |
| 38061 | 2015-04-01T00:00:00 | 2015-06-30T00:00:00 | 22834 | David | R | Hill | 0 | 5.75 | 0 | 0 | 0 | 5.75 | 12474 | Celadon Holdings LLC | 2015-06-16T00:00:00 |