Campaign Finance - Transaction Detail Dataset

This table lists individual transactions as reported on the Texas Ethics Commission C/OH Form. Each row represents an individual filer's transaction, which may be a loan, expenditure, credit, pledge or contribution. For information about each report filed, please visit the Reports Table at: https://data.austintexas.gov/Government/Campaign-Finance-Data-Reports-Table/b2pc-2s8n

A data dictionary for this dataset is available at http://www.austintexas.gov/edims/document.cfm?id=247730

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 \"austintexas-gov/campaign-finance-transaction-detail-dataset-g4yx-aw9r\".\"campaign_finance_transaction_detail_dataset\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.