colorado-gov/bill-information-and-position-with-income-of-gxnn-wthy
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month 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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"colorado-gov/bill-information-and-position-with-income-of-gxnn-wthy\".\"bill_information_and_position_with_income_of\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • bill_information_and_position_with_income_of
     
     
     
     
     
Upstream Metadata