Candidate Expenditures (Show Me the Money)

This dataset includes expenditures by candidate campaign committees filed on FPPC Form 460, Schedule E. The Election Year, Election Date, Candidate and Office have been added for each transaction based on the committee's Statement of Organization (FPPC Form 410) and FPPC ID (Filer ID). The data is current as of the last modified date on this dataset.

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 \"oaklandca-gov/candidate-expenditures-show-me-the-money-yjtu-3cj6\".\"candidate_expenditures_show_me_the_money\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.