Campaign Finance - Filers with Delinquent Campaign Filings

This dataset summarizes Oakland campaign committees with deliquent campaign filings. Under the Oakland Campaign Reform Act, any person required by State or local law to file a campaign statement or report with the local filing officer, must file the statement or report in an electronic format with the Public Ethics Commission. The Commission publishes the names of campaign committees and officers with filings that are more than 45 days overdue.

Please note that this list is subject to change and the dataset below may not include all delinquent filers or reflect the most recent activity. Posted filers are removed from the list after filing their past-due campaign statement(s) or two years have elapsed since the applicable filing deadline.

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/campaign-finance-filers-with-delinquent-campaign-4qra-2jsu\".\"campaign_finance_filers_with_delinquent_campaign\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.