Government
24 columns
48 rows
8 formats

Municipal Supplier Diversity Audit Tracker

This dataset provides detailed tracking of supplier diversity and inclusion metrics for municipal contracts, enabling cities to monitor local, minority-owned, and women-owned business participation. It supports compliance with ESG and regulatory requirements, offering insights into contract values, supplier certifications, diversity spend, and audit outcomes for ongoing and completed procurements.

last updated 14 Jan 2026
by GoMask

The brief that made it

Monitoring and reporting supplier diversity compliance for municipal contracts

Sample rows

preview · 8 of 48 rows · all 24 columns

contract_idstring	diversity_compliance_statusstring	diversity_spend_percentagefloat	primary_supplier_is_localboolean	primary_supplier_certificationsstring	contract_titlestring	contract_statusstring	contract_start_datedate	contract_end_datedate	contract_valuefloat	departmentstring	primary_supplier_idstring	primary_supplier_namestring	primary_supplier_is_minority_ownedboolean	primary_supplier_is_women_ownedboolean	total_subcontractorsinteger	diverse_subcontractors_countinteger	diverse_subcontractors_percentagefloat	diversity_spend_amountfloat	diversity_goal_percentagefloat	last_audit_datedate	auditor_namestring	notesstring	contract_descriptionstring
CT-2024-001	exceeded	45.95	true	WBE,SBE	City Park Renovation	completed	2023-02-15	2023-09-30	1850000.75	Public Works	SUP-1001	GreenScape Constructors	false	true	7	3	42.86	850000	40	2023-10-02	Samantha Lee	Exceeded diversity goals by 5.95%.	Renovation of the downtown city park including landscaping, pathways, and lighting upgrades.
CT-2024-002	not_met	45.65	false	MBE	Municipal Wi-Fi Expansion	ongoing	2024-01-10	blank	920000	Information Technology	SUP-1012	TechConnect Solutions	true	false	4	2	50	420000	50	2024-03-05	David Tran	Short by 4.35% on diversity spend.	Installation of public Wi-Fi hotspots across major transit hubs and community centers.
CT-2024-003	exceeded	66.94	true	MBE	Street Lighting Retrofit	completed	2022-08-05	2023-05-20	1345000.25	Public Works	SUP-1034	BrightWay Electric	true	false	6	4	66.67	900000	60	2023-06-01	Lydia Foster	High minority participation.	Upgrade of street lighting to energy-efficient LED fixtures.
CT-2024-004	not_met	10.93	false	blank	Water Main Replacement	ongoing	2023-11-18	blank	2470000	Utilities	SUP-1052	FlowTech Civil	false	false	9	1	11.11	270000	25	2024-04-20	Michael Chang	Below target on diversity inclusion.	Replacement of aging water mains in northern districts.
CT-2024-005	pending	34.43	true	WBE	City Hall HVAC Modernization	pending	2024-05-01	blank	610000	Facilities Management	SUP-1067	ClimateCare Systems	false	true	3	1	33.33	210000	30	blank	blank	blank	Modernization and upgrade of HVAC systems at City Hall.
CT-2024-006	exceeded	75.47	true	MBE,WBE	Community Center Construction	ongoing	2023-10-05	blank	3180000	Community Development	SUP-1079	BuildWest Group	true	true	10	7	70	2400000	65	2024-01-10	Maria Gutierrez	Strong women-owned business participation.	Construction of a new community center in the West End.
CT-2024-007	not_met	0	false	blank	Downtown Road Resurfacing	completed	2022-06-25	2023-02-12	970000	Transportation	SUP-1083	Urban Asphalt Inc.	false	false	5	0	0	0	20	2023-03-05	Nathaniel Wright	No diverse spend reported.	Resurfacing of major downtown streets for improved traffic flow.
CT-2024-008	exceeded	52.32	true	MBE,SBE	Public Library Refurbishment	completed	2021-11-02	2022-05-19	765000.25	Library Services	SUP-1091	RestoreWorks LLC	true	false	2	1	50	400000	50	2022-06-10	Helen Kim	Exceeded minority spend goals.	Refurbishment of the main public library, including IT infrastructure upgrades.
CT-2024-009	not_met	34.88	false	WBE	Emergency Shelter Operations	ongoing	2023-09-01	blank	430000.5	Emergency Services	SUP-1102	SafeHarbor Logistics	false	true	1	1	100	150000	35	2023-11-25	Rajiv Patel	Marginally below diversity spend target.	Provision of services and supplies for emergency shelters.
CT-2024-010	not_met	49.8	true	SBE	Fleet Vehicle Procurement	completed	2022-03-14	2022-10-20	1225000	Fleet Management	SUP-1113	AutoServe Group	false	false	4	2	50	610000	50	2022-11-02	Jennifer Brooks	Slightly below target due to last-minute supplier change.	Purchase of new hybrid vehicles for the city fleet.
CT-2024-011	exceeded	41.14	false	MBE	Stormwater Drainage Upgrade	ongoing	2023-08-15	blank	1580000	Public Works	SUP-1124	AquaForce LLC	true	false	5	2	40	650000	40	2024-04-02	Nathaniel Wright	Met and slightly exceeded diversity goals.	Upgrading stormwater drainage systems to improve flood resilience.
CT-2024-012	exceeded	71.79	true	MBE,WBE,SBE	Recycling Program Expansion	completed	2022-07-10	2023-03-25	585000	Sanitation	SUP-1135	EcoCycle Services	true	true	2	2	100	420000	60	2023-04-01	Helen Kim	Full diverse subcontractor engagement.	Expansion of recycling collection services to additional neighborhoods.
CT-2024-013	pending	0	false	blank	Transit Shelter Installation	pending	2024-08-12	blank	410000	Transportation	SUP-1146	ShelterWorks Inc.	false	false	0	0	0	0	20	blank	blank	blank	Installation of new bus shelters along major transit routes.
CT-2024-014	not_met	0	false	blank	IT System Modernization	ongoing	2024-02-01	blank	2100000	Information Technology	SUP-1152	SecureNet Solutions	false	false	3	0	0	0	15	2024-03-28	David Tran	No diversity spend reported at last audit.	Modernization of city IT systems for enhanced cybersecurity and efficiency.
CT-2024-015	exceeded	88.57	true	MBE,WBE	Senior Center Accessibility Upgrade	completed	2021-09-25	2022-04-30	350000	Community Development	SUP-1163	AccessBuild Group	true	true	1	1	100	310000	85	2022-05-12	Samantha Lee	High women-owned business engagement.	Upgrades for ADA compliance and accessibility at senior centers.
CT-2024-016	not_met	48	true	SBE	Pedestrian Bridge Construction	ongoing	2023-06-10	blank	1625000	Transportation	SUP-1174	RiverSpan Contractors	false	false	6	3	50	780000	50	2023-11-01	Rajiv Patel	Slightly below target on diversity spend.	Construction of pedestrian bridge over the river.
CT-2024-017	not_met	0	false	blank	Fire Station Upgrade	completed	2022-01-20	2022-09-10	890000	Emergency Services	SUP-1185	RapidBuild Solutions	false	false	2	0	0	0	15	2022-09-15	Michael Chang	No diversity spend reported.	Upgrade of fire station facilities and equipment.
CT-2024-018	exceeded	52.17	true	MBE,SBE	Recreational Fields Maintenance	ongoing	2023-03-01	blank	230000	Parks & Recreation	SUP-1196	FieldCare Services	true	false	1	1	100	120000	50	2023-06-05	Lydia Foster	Exceeded minority participation goals.	Annual maintenance contract for recreational fields in the city.
CT-2024-019	not_met	41.67	false	MBE,WBE	Traffic Signal Upgrade	completed	2021-04-12	2021-12-01	480000	Transportation	SUP-1207	SignalSync Inc.	true	true	2	1	50	200000	45	2021-12-15	Samantha Lee	Below target due to contract amendments.	Upgrade of traffic signals for smart city integration.
CT-2024-020	met	40	true	WBE	Public Art Installation	ongoing	2024-03-12	blank	175000	Arts & Culture	SUP-1218	CreativeMinds Collective	false	true	0	0	0	70000	40	2024-04-01	Maria Gutierrez	Met diversity goals.	Commission and installation of public art at key city locations.

What the 48 rows show

from the 48-row sample

Exceeded (diversity compliance status) stands out: mean diversity_spend_percentage is 57.8, against 27.8 for the rest.

52%primary_supplier_is_local = true
44.7median diversity_spend_percentage
3contract statuses
9auditor names
13departments
700,000median contract_value

Mean diversity_spend_percentage by diversity_compliance_status48 rows

diversity_spend_percentage48 rows, in bands of 10

Median 44.7, from 0.0 to 90.6.

primary_supplier_certifications36 rows with a value · 12 left blank

MBE11
WBE7
WBE,SBE5
MBE,WBE5
MBE,SBE3
SBE3
MBE,WBE,SBE2

24 columns by typefrom the column list below

string 11
integer 2
float 5
date 3
boolean 3

Columns

24 columns in four groups

blueprint · 24 columns
column	type	description	example
Text 11 columns
`contract_id`	string	Unique identifier for each contract tracked by the municipality.unique	CT-2024-001
`contract_title`	string	Descriptive title of the contract or procurement project.	City Park Renovation
`contract_description`	string	Detailed description of the contract's purpose, scope, and deliverables.optional	Renovation of the downtow…
`contract_status`	string	Current status of the contract (e.g., ongoing, completed, cancelled).ongoing · completed · cancelled · pending	completed
`department`	string	Municipal department responsible for the contract.	Public Works
`primary_supplier_id`	string	Unique identifier for the primary supplier or contractor.	SUP-1001
`primary_supplier_name`	string	Name of the primary supplier or contractor.	GreenScape Constructors
`primary_supplier_certifications`	string	Comma-separated list of diversity certifications held by the primary supplier (e.g., MBE, WBE, SBE).7 certificationses · optional	WBE,SBE
`diversity_compliance_status`	string	Indicates whether the contract met, exceeded, or fell short of diversity goals.met · exceeded · not_met · pending · optional	exceeded
`auditor_name`	string	Name of the person or entity responsible for the last audit.9 names · optional	Samantha Lee
`notes`	string	Additional notes, comments, or findings from audits or reviews.optional	Met diversity goals.
Numbers 7 columns
`contract_value`	float	Total monetary value of the contract in local currency.0 or more	1850000.75
`total_subcontractors`	integer	Total number of subcontractors engaged on the contract.0 or more · optional	7
`diverse_subcontractors_count`	integer	Number of subcontractors that are local, minority-owned, or women-owned.0 or more · optional	3
`diverse_subcontractors_percentage`	float	Percentage of subcontractors that are diverse (local, minority-owned, or women-owned).0 to 100 · optional	42.86
`diversity_spend_amount`	float	Total monetary amount spent with diverse suppliers and subcontractors.0 or more · optional	850000
`diversity_spend_percentage`	float	Percentage of total contract value spent with diverse suppliers and subcontractors.0 to 100 · optional	45.95
`diversity_goal_percentage`	float	Target percentage for diverse supplier participation as set by policy or contract.0 to 100 · optional	40
Dates and times 3 columns
`contract_start_date`	date	Date when the contract officially started.	2023-02-15
`contract_end_date`	date	Date when the contract ended or is expected to end.optional	2023-09-30
`last_audit_date`	date	Date of the most recent diversity audit or review for the contract.optional	2023-10-02
True or false 3 columns
`primary_supplier_is_local`	boolean	Indicates if the primary supplier is a local business.	true
`primary_supplier_is_minority_owned`	boolean	Indicates if the primary supplier is a certified minority-owned business.	false
`primary_supplier_is_women_owned`	boolean	Indicates if the primary supplier is a certified women-owned business.	true

Use it for

A government dashboard
The primary_supplier_is_local rate, diversity_spend_percentage by diversity_compliance_status and a breakdown of primary_supplier_certifications. Excel, Power BI or Tableau.
Why do the 23 exceeded rows have a mean diversity_spend_percentage of 57.8?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Contracts48
CT-2024-00145.95exceeded
CT-2024-00245.65not_met
CT-2024-00366.94exceeded
A software demo
Believable contracts with contract_title, contract_description and contract_status to fill a screen in front of a buyer.

This dataset48 rows24 columns

Yours1,000 rows24 columns

blueprint · municipal-supplier-diversity-audit-tracker

Behind this dataset

Same schema. As many rows as you need.

These 48 rows came out of a blueprint — 24 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with

Each row represents a unique supplier contract and fiscal year.
Supplier demographic categories (minority-owned, women-owned, veteran-owned, local) must be explicitly coded and not left blank.
Contract value and awarded amount must be numeric and non-negative.
Compliance status reflects latest audit outcome (in compliance/out of compliance/under review).
Diversity certification must be validated against city-approved registries.

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: municipal-supplier-diversity-audit-tracker

What should your data show?

No signup. No card.

Sample rows

What the 48 rows show

Columns

Use it for

A government dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Government

What should your data show?