oaklandca-gov/campaign-finance-fppc-form-465-supplemental-6ejr-39gh
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated almost 3 years ago
Indexed 2 hours ago

Campaign Finance - FPPC Form 465 - Supplemental Independent Expenditure Report - Part 3 - Independent Expenditures Made

This dataset includes all itemized independent expenditures ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 465 Part 3 Independent Expenditures Made from 2011 to the present.

The data is current as of the last modified date on this dataset.

See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76

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-fppc-form-465-supplemental-6ejr-39gh\".\"campaign_finance_fppc_form_465_supplemental\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • campaign_finance_fppc_form_465_supplemental
     
     
     
     
     
Upstream Metadata