Lobbyist Data - Historical - Lobbyist Gift Report - 2010

The lobbyist gift report is part of the Lobbyist Activity Report, a notarized disclosure that lobbyista were required to file twice during 2010 (January 20th and July 20th).

Lobbyists were required to report every gift given to an official or employee of the City by the lobbyist during the reporting period.

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

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-gift-report-2010-5d24-2bpp\".\"lobbyist_data_historical_lobbyist_gift_report_2010\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.