lacity/registered-city-lobbyists-j4zm-9kqu
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 11 months ago
Indexed 1 month ago

Registered City Lobbyists

An individual who directly communicates with a City official for the purpose of influencing a legislative or administrative matter and is compensated to spend 30 or more hours in any consecutive three-month period engaged in lobbying activities must register with the Ethics Commission as a lobbyist. This also applies to in-house lobbyists (employees who are compensated to lobby only on behalf of their employers).

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 \"lacity/registered-city-lobbyists-j4zm-9kqu\".\"registered_city_lobbyists\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • registered_city_lobbyists
     
     
     
     
     
Upstream Metadata