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

See the Splitgraph documentation for more information.