Lobbyist Data - Lobbyist Categorized Expenditures Report (Deprecated October 2015)
City of Chicago
@usgov.city_of_chicago_lobbyist_lobbyist_categorized_expendit_9916810a
City of Chicago
@usgov.city_of_chicago_lobbyist_lobbyist_categorized_expendit_9916810a
OUTDATED. See similar current data at https://data.cityofchicago.org/d/eqdx-4qxd -- The lobbyist categorized expenditures 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 the total amount of lobbying-related expenditures paid by the lobbyist or charged to the client in each of the categories listed on Form C, Part 3 of 3, Section H, Question 3 (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]
Organization: City of Chicago
Last updated: 2020-11-10T16:54:40.726156
Tags: deprecated, ethics, lobbyists
CREATE TABLE table_1 (
"filing_year" BIGINT,
"last_name" VARCHAR,
"first_name" VARCHAR,
"middle_initial" VARCHAR,
"client_name" VARCHAR,
"office_expenses" DOUBLE,
"compensation_to_others" BIGINT,
"public_education" DOUBLE,
"personal_sustenance" DOUBLE,
"other_expenses" DOUBLE,
"total_expenses" DOUBLE,
"filing_period" BIGINT
);Anyone who has the link will be able to view this.