Icon for Socrata external plugin
Open repository in Console
Updated 11 hours ago
Indexed 5 hours ago

Bill Information and Position with Income of Lobbyist in Colorado

Information for each lobbyist and their associated client with the reported bills and positions associated with the client and the total gross income the client paid to lobbyist for the report month for the State of Colorado provided by the Colorado Department of State (CDOS).

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 \"colorado-gov/bill-information-and-position-with-income-of-gxnn-wthy\".\"bill_information_and_position_with_income_of\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • bill_information_and_position_with_income_of
Upstream Metadata