Icon for Socrata external plugin
Open repository in Console
Updated 16 hours ago
Indexed 1 hour ago

Lobbyist Data - Lobbying Activity

List of each City agency lobbied, whether it involved legislative or administrative action (or both) and a brief description of the action promoted or opposed, as reported by registered lobbyists. See for more information on the Board of Ethics' role in regulating and reporting on lobbying in Chicago.

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofchicago/lobbyist-data-lobbying-activity-pahz-egmi\".\"lobbyist_data_lobbying_activity\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • lobbyist_data_lobbying_activity
Upstream Metadata