Strategic Measure__Percentage of prime contractors that meet solicitation goals (at time of award) through the utilization of certified minority-owned, women-owned, and disadvantaged businesses on applicable City of Austin contracts set by the Small and M

This dataset contains the Small & Minority Business Resources Department's (SMBR) Strategic Measure for Strategic Direction 2023. It captures contracting data within the City of Austin's MBE/WBE/DBE programs as it relates to prime contractors meeting solicitation goals, as well as certified firm participation breakdowns by racial/ethnic and gender categories. Data can be dis-aggregated by procurement category, SMBR reviewed projects, goal determination, prime contractor ethnicity, prime contractor zip, project cost estimate, and sponsor department. The dataset is captured by fiscal year and stored on the City of Austin network drive in an MS Excel file, and shares information with the SMBR Council Awards Report.

View more details and insights related to this dataset on the story page: https://data.austintexas.gov/stories/s/Prime-Contractors-Meeting-SMBR-Solicitation-Goals/9q8x-qhyx/edit

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/strategic-measurepercentage-of-prime-contractors-kzyg-7x4s\".\"strategic_measurepercentage_of_prime_contractors\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.