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

Campaign Consultants - List of Registered Campaign Consultants and their Respective Clients

In 1997, San Francisco voters approved the Regulation of Campaign Consultants Ordinance (“Ordinance”). The Ordinance requires persons who earn $1,000 or more per year for campaign consultant services to register with the Ethics Commission and file quarterly activity reports. The Ordinance defines “campaign consultant” as a person or entity that receives or is promised $1,000 or more in a calendar year for either campaign management or campaign strategy.

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" \
{"sql": "
    SELECT *
    FROM \"sfgov/campaign-consultants-list-of-registered-campaign-wchi-36a5\".\"campaign_consultants_list_of_registered_campaign\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • campaign_consultants_list_of_registered_campaign
Upstream Metadata