Chicago Spend Audit

Methodology

The source is the City of Chicago Payments dataset (s4vu-giwb) on the open data portal. A load is kept only when the row count and the amount total match the portal. Older years are summary rows whose check date is a four-digit year. About the last two years are individual payments. Names that look like "LAST, FIRST" and carry no business token are marked private and are left out of this site, the public views, and any draft.

Department spellings are collapsed in config/department_map.csv. Typos and abbreviations map to one name, and a few renamed offices map to the successor that still does the work (Revenue into Finance, Fleet and Innovation and Technology into Assets, Information and Services, Cultural Affairs and Special Events together). Independent bodies such as the Police Board, the Inspector General, and the Treasurer stay separate.

The $100,000 line used by the threshold and split tests is the Department of Procurement Services formal competitive bidding threshold. Tests that flag more than 5 percent of their population were left as they are. Split payments flag about 22 percent because many vendors receive several payments under $100,000 in one week that sum past that line. Near-duplicates flag about 6 percent. The vendor-name test looks only at vendors that already have two aliases, and most of those aliases still differ after punctuation is removed.

Load reconciliation

StartedSource rowsLoaded rowsReconciled
2026-11-17 20:00:27.034533+00:00 487211 487211 yes
2026-11-17 19:57:14.038640+00:00 487211 487211 yes
2026-11-17 19:54:27.667611+00:00 487211 487211 yes
2026-11-17 19:52:00.733135+00:00 487211 487211 yes
2026-11-17 19:49:17.386534+00:00 487211 487211 yes
2026-11-17 19:46:58.019888+00:00 487211 487211 yes

Rows left unparsed

0

Department mapping

Raw spellings and the name used for tests.

Raw nameDepartment
ADMINISTRATIVE ADJUDICATIONDepartment of Administrative Hearings
BOARD OF ETHICSBoard of Ethics
CHICAGO ANIMAL CARE AND CONTROLChicago Animal Care and Control
CHICAGO COMMISSION ON HUMAN RELATIONSChicago Commission on Human Relations
CHICAGO DEPARTMENT OF AVIATIONChicago Department of Aviation
CHICAGO DEPARTMENT OF PUBLIC HEALTHChicago Department of Public Health
CHICAGO DEPARTMENT OF TRANSPORTATIONChicago Department of Transportation
CHICAGO FIRE DEPARTMENTChicago Fire Department
CHICAGO POLICE BOARDChicago Police Board
CHICAGO POLICE DEPARTMENTChicago Police Department
CITY TREASURER'S OFFICECity Treasurer
CITYWIDE/MULTIPLECitywide
DEPARTMENT OF ADMINISTRATIVE HEARINGSDepartment of Administrative Hearings
DEPARTMENT OF BUILDINGSDepartment of Buildings
DEPARTMENT OF BUSINESS AFFAIRS AND CONSUMER PROTECTIONDepartment of Business Affairs and Consumer Protection
DEPARTMENT OF BUSINESS AFFAIRS AND LICENSINGDepartment of Business Affairs and Consumer Protection
DEPARTMENT OF CHILDREN AND YOUTH SERVICESDepartment of Family and Support Services
DEPARTMENT OF CONSTRUCTION AND PERMITSDepartment of Buildings
DEPARTMENT OF CULTURAL AFFAIRSDepartment of Cultural Affairs and Special Events
DEPARTMENT OF CULTURAL AFFAIRS AND SPECIAL EVENTSDepartment of Cultural Affairs and Special Events
DEPARTMENT OF ENVIROMENTDepartment of Environment
DEPARTMENT OF ENVIRONMENTDepartment of Environment
DEPARTMENT OF FAMILY AND SUPPORT SERVICESDepartment of Family and Support Services
DEPARTMENT OF FINANCEDepartment of Finance
DEPARTMENT OF FLEET AND FACILITY MANAGEMENTDepartment of Assets Information and Services
DEPARTMENT OF HOUSINGDepartment of Housing
DEPARTMENT OF HUMAN RESOURCESDepartment of Human Resources
DEPARTMENT OF LAWDepartment of Law
DEPARTMENT OF PERSONNELDepartment of Human Resources
DEPARTMENT OF PLANNING AND DEVELOPMENTDepartment of Planning and Development
DEPARTMENT OF PROCUREMENT SERVICESDepartment of Procurement Services
DEPARTMENT OF REVENUEDepartment of Finance
DEPARTMENT OF STREETS AND SANITATIONDepartment of Streets and Sanitation
DEPARTMENT OF TECHNOLOGY AND INNOVATIONDepartment of Assets Information and Services
DEPARTMENT OF WATER MANAGEMENTDepartment of Water Management
DEPARTMENT OF ZONINGDepartment of Planning and Development
DEPT OF ASSETS INFORMATION AND SERVICESDepartment of Assets Information and Services
DEPT OF BUSINESS & INFORMATION SERVICESDepartment of Assets Information and Services
DEPT OF BUSINESS AFFAIRS & CONSUMER PROTECTIONDepartment of Business Affairs and Consumer Protection
DEPT OF CONSUMER SERVICESDepartment of Business Affairs and Consumer Protection
DEPT OF FLEET MGMTDepartment of Assets Information and Services
DEPT OF GENERAL SERVICESDepartment of Assets Information and Services
DEPT OF INNOVATION & TECHNOLOGYDepartment of Assets Information and Services
DEPT OF ZONING & LAND USE PLANNINGDepartment of Planning and Development
DEPT ON AGINGDepartment of Family and Support Services
FINANCE GENERALDepartment of Finance
GRAPHICS & REPRODUCTION CTRDepartment of Assets Information and Services
INDEPENDENT POLICE REVIEW AUTHORITYIndependent Police Review Authority
LIC COMM & LOCAL LIQ CTRL COMMLicense Appeal Commission
MAYORS OFFICE FOR PEOPLE WITH DISABILITIESMayor's Office for People with Disabilities
MAYORS OFFICE OF WORKFORCE DEVELOPMENTDepartment of Family and Support Services
OFFICE OF BUDGET & MANAGEMENTOffice of Budget and Management
OFFICE OF CABLE COMMUNICATION ADMOffice of Cable Communications
OFFICE OF CITY CLERKOffice of the City Clerk
OFFICE OF COMPLIANCEOffice of Compliance
OFFICE OF EMERGENCY MANAGEMENT AND COMMUNICATIONSOffice of Emergency Management and Communications
OFFICE OF INSPECTOR GENERALOffice of Inspector General
OFFICE OF PUBLIC SAFETY ADMINISTRATIONOffice of Public Safety Administration
OFFICE OF SPECIAL EVENTSDepartment of Cultural Affairs and Special Events
OFFICE OF THE MAYOROffice of the Mayor
OHARE MODERNIZATION PROJECTChicago Department of Aviation
PLANNING & DEVELOPMENTDepartment of Planning and Development
CHICAGO PUBLIC LIBRARYChicago Public Library

Model

Risk score = 0.6 × scaled rule hits + 0.4 × scaled Isolation Forest score. Weights are read from config/criteria.yaml.

Draft review

Drafts 0. Approved without edits 0. Approved with edits 0. Rejected 0.

Built with Claude Code

The pipeline, tests, and this site were written with Claude Code in Cursor against the City of Chicago open data portal. Draft observations are produced from a fixed fact sheet and stay off the public pages until a person approves them.