Economic Inclusion Certified Vendors - MBE/WBE Program

Data Description: This data set is a list of all vendors who are certified as Minority Business Enterprises; Women-owned Businesses; and Small Business Enterprises. MBE and WBE are terms of art under CMC 324, and refer specifically to the City's new Economic Inclusion program.

To increase economic participation in City contracts for minority- and women-owned businesses, the City enacted C.M.C 324, which authorized creation of the City’s new Economic Inclusion Program, run by the Department of Economic Inclusion (DEI). DEI works with Procurement and City departments to establish subcontracting goals for minority & women-owned businesses to help bolster the City's other inclusion efforts.

Data Creation: DEI certifies vendors through its Business Certification Programs: the process of being certified under C.M.C. 324 and 342 is explained on the Department's website. The active vendors are sent to the Office of Performance and Data Analytics

Data Created By: Department of Economic Inclusion (DEI)

Refresh Frequency: Weekly

CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/Certified-Vendors-MBE-WBE-Program-/69yt-tb5j/

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

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 \"cincinnati-oh-gov/economic-inclusion-certified-vendors-mbewbe-2iq3-bugw\".\"economic_inclusion_certified_vendors_mbewbe\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.