Budget Planning Proposal Lines (Gold Copy

A consolidated dataset that is shared with the Hub. It contains all proposal lines marked as Included, along with all active Reference datasets.

Both this dataset and the HUB equivalent contain Report Header columns needed for Tabular Reporting.

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 \"budget-qa-reporting-data-socrata/budget-planning-proposal-lines-gold-copy-t9jw-um88\".\"budget_planning_proposal_lines_gold_copy\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.