Contracts Awarding

This Indicator measures the percent by race/ethnicity of Prime contractors for construction and professional services contracts who received under $100,000. Additional data is provided on the average amount received by these contractors. Data is from fiscal year 2015-16 and the date used to assign contracts to a fiscal year is the date that the compliance analysis was completed, or the review date. The dollar amounts represent the initial award; any negotiated bid amounts or change orders are not taken into account. The initial award is adjusted to how much of the total contract went to the Prime as opposed to Subprime contractors.

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/contracts-awarding-3fhs-xfjc\".\"contracts_awarding\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.