Lobbyist Data - Lobbyist Major Expenditures Report (Deprecated October 2015)
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.cityofchicago.org |
| Id | txma-ntnk |
| Name | Lobbyist Data - Lobbyist Major Expenditures Report (Deprecated October 2015) |
| Attribution | City of Chicago |
| Category | Ethics |
| Tags | lobbyists, ethics, deprecated |
| Created | 2011-09-30T08:01:04Z |
| Publication Date | 2016-12-06T10:30:31Z |
Description
OUTDATED. See similar current data at https://data.cityofchicago.org/d/xika-473c –The lobbyist expense report is part of the Lobbyist Activity Report, a notarized disclosure that must be filed twice each year (January 20th and July 20th). Lobbyists are required to report single expenditures paid by the lobbyist or charged to the client totaling $250.00 or more on Form C Part 3 Section H Question 2 (http://bit.ly/q2lRTh). All lobbyist activity reports are submitted to the Board of Ethics in paper form and are available in their entirety in the Board’s offices. The Board has, since 2000, compiled and posted static lists of all lobbyists and their clients online. / Data Owner: Board of Ethics [http://j.mp/mbH9BN] / Time Period: January 1, 2011 to present/ Frequency: Data is updated daily / Related Applications: Registered Lobbyist List [http://bit.ly/FOctNY]
Columns
| Included | Schema Type | Field Name | Name | Data Type | Render Type |
| ======== | ============== | ======================= | ======================= | ============= | ============= |
| No | | filing_year | FILING YEAR | number | number |
| Yes | series tag | lobbyist_last_name | LOBBYIST LAST NAME | text | text |
| Yes | series tag | lobbyist_first_name | LOBBYIST FIRST NAME | text | text |
| Yes | series tag | lobbyist_middle_initial | LOBBYIST MIDDLE INITIAL | text | text |
| Yes | time | expense_date | EXPENSE DATE | calendar_date | calendar_date |
| Yes | series tag | recipient_name | RECIPIENT NAME | text | text |
| Yes | series tag | purpose | PURPOSE | text | text |
| Yes | numeric metric | amount | AMOUNT | money | money |
| Yes | series tag | action | ACTION | text | text |
| Yes | series tag | client | CLIENT | text | text |
| Yes | numeric metric | filing_period | FILING PERIOD | number | text |
Time Field
Value = expense_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss
Series Fields
Excluded Fields = filing_year
Data Commands
series e:txma-ntnk d:2011-01-17T00:00:00.000Z t:lobbyist_first_name="B. John" t:client="Wal-Mart Stores, Inc." t:action="Gen. education of business in city" t:purpose=airfare t:recipient_name="American Airlines" t:lobbyist_last_name=Bisio m:amount=1038.62 m:filing_period=1
series e:txma-ntnk d:2011-01-09T00:00:00.000Z t:lobbyist_first_name="B. John" t:client="Wal-Mart Stores, Inc." t:action="Gen. education of business in city" t:purpose=lodging t:recipient_name=Doubletree t:lobbyist_last_name=Bisio m:amount=443.88 m:filing_period=1
series e:txma-ntnk d:2011-01-09T00:00:00.000Z t:lobbyist_first_name="B. John" t:client="Wal-Mart Stores, Inc." t:action="Gen. education of business in city" t:purpose=airfare t:recipient_name="American Airlines" t:lobbyist_last_name=Bisio m:amount=772.08 m:filing_period=1
Meta Commands
metric m:amount p:double l:AMOUNT t:dataTypeName=money
metric m:filing_period p:integer l:"FILING PERIOD" t:dataTypeName=number
entity e:txma-ntnk l:"Lobbyist Data - Lobbyist Major Expenditures Report (Deprecated October 2015)" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/txma-ntnk
property e:txma-ntnk t:meta.view v:id=txma-ntnk v:category=Ethics v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="Lobbyist Data - Lobbyist Major Expenditures Report (Deprecated October 2015)" v:attribution="City of Chicago"
property e:txma-ntnk t:meta.view.owner v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:displayName=cocadmin v:privilegesDisabled=false
property e:txma-ntnk t:meta.view.tableauthor v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:roleName=administrator v:displayName=cocadmin v:privilegesDisabled=false
Top Records
| filing_year | lobbyist_last_name | lobbyist_first_name | lobbyist_middle_initial | expense_date | recipient_name | purpose | amount | action | client | filing_period |
| =========== | ================== | =================== | ======================= | =================== | ================= | ======= | ======= | ================================== | ===================== | ============= |
| 2011 | Bisio | B. John | | 2011-01-17T00:00:00 | American Airlines | airfare | 1038.62 | Gen. education of business in city | Wal-Mart Stores, Inc. | 1 |
| 2011 | Bisio | B. John | | 2011-01-09T00:00:00 | Doubletree | lodging | 443.88 | Gen. education of business in city | Wal-Mart Stores, Inc. | 1 |
| 2011 | Bisio | B. John | | 2011-01-09T00:00:00 | American Airlines | airfare | 772.08 | Gen. education of business in city | Wal-Mart Stores, Inc. | 1 |
| 2011 | Bisio | B. John | | 2011-01-01T00:00:00 | Doubletree | lodging | 409.08 | Gen. education of business in city | Wal-Mart Stores, Inc. | 1 |
| 2011 | Bisio | B. John | | 2011-01-01T00:00:00 | American Airlines | airfare | 772.08 | Gen. education of business in city | Wal-Mart Stores, Inc. | 1 |
| 2011 | Bisio | B. John | | 2011-01-25T00:00:00 | American Airlines | airfare | 446.72 | Gen. education of business in city | Wal-Mart Stores, Inc. | 1 |
| 2011 | Bisio | B. John | | 2011-01-19T00:00:00 | American Airlines | airfare | 1028.84 | Gen. education of business in city | Wal-Mart Stores, Inc. | 1 |
| 2011 | Bisio | B. John | | 2011-01-11T00:00:00 | Hotel Felix | lodging | 706.5 | Gen. education of business in city | Wal-Mart Stores, Inc. | 1 |
| 2011 | Bisio | B. John | | 2011-01-11T00:00:00 | American Airlines | airfare | 602.38 | Gen. education of business in city | Wal-Mart Stores, Inc. | 1 |
| 2011 | Bisio | B. John | | 2011-01-05T00:00:00 | American Airlines | airfare | 1028.84 | Gen. education of business in city | Wal-Mart Stores, Inc. | 1 |