Lobbyist Data - Historical - Lobbyist Major Expenditures Report - 2010

The lobbyist expense report is part of the Lobbyist Activity Report, a notarized disclosure that lobbyists were required to file twice during 2010 (January 20th and July 20th). Lobbyists were 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. / Data Owner: Board of Ethics http://j.mp/mbH9BN / Time Period: 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-major-dqw9-xyre\".\"lobbyist_data_historical_lobbyist_major\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.