Lobbyist Data - Lobbyist Agency Report (Deprecated October 2015)

OUTDATED. See similar current data at https://data.cityofchicago.org/d/pahz-egmi -- The lobbyist agency report is part of the Lobbyist Activity Report, a notarized disclosure that must be filed twice each year (January 20th and July 20th). Lobbyists must report the name of each City agency lobbied and report whether lobbying involved legislative or administrative action, and give a brief description of the legislative or administrative action promoted or opposed. All lobbyist agency 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

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofchicago/lobbyist-data-lobbyist-agency-report-deprecated-4pay-mbmj\".\"lobbyist_data_lobbyist_agency_report_deprecated\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.