Lobbyist Data - Historical - Lobbyist Termination Report - 2010

All lobbyist termination fillings submitted to the Board of Ethics and electronically transcribed by Board of Ethics employees during the 2010 reporting period. /

When a lobbyist terminates all activity that requires registration, the lobbyist must file a termination notice and a final activity report that covers the period between the most recently filed activity report and the date of termination.

Data for the 2010 reporting period is limited because previous policy did not require the Board of Ethics to prioritize the reporting of all data available from paper filings. /

Data Owner: Board of Ethics

http://j.mp/mbH9BN /

Time Period: January 1, 2010 to December 31, 2010 /

Related Applications: Registered Lobbyist List http://j.mp/l8LwAq,

2011 Lobbyist Termination Report

http://j.mp/kT56zH

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-historical-lobbyist-termination-2mtu-ysnw\".\"lobbyist_data_historical_lobbyist_termination\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.