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
| Started | Source rows | Loaded rows | Reconciled |
|---|---|---|---|
| 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 name | Department |
|---|---|
| ADMINISTRATIVE ADJUDICATION | Department of Administrative Hearings |
| BOARD OF ETHICS | Board of Ethics |
| CHICAGO ANIMAL CARE AND CONTROL | Chicago Animal Care and Control |
| CHICAGO COMMISSION ON HUMAN RELATIONS | Chicago Commission on Human Relations |
| CHICAGO DEPARTMENT OF AVIATION | Chicago Department of Aviation |
| CHICAGO DEPARTMENT OF PUBLIC HEALTH | Chicago Department of Public Health |
| CHICAGO DEPARTMENT OF TRANSPORTATION | Chicago Department of Transportation |
| CHICAGO FIRE DEPARTMENT | Chicago Fire Department |
| CHICAGO POLICE BOARD | Chicago Police Board |
| CHICAGO POLICE DEPARTMENT | Chicago Police Department |
| CITY TREASURER'S OFFICE | City Treasurer |
| CITYWIDE/MULTIPLE | Citywide |
| DEPARTMENT OF ADMINISTRATIVE HEARINGS | Department of Administrative Hearings |
| DEPARTMENT OF BUILDINGS | Department of Buildings |
| DEPARTMENT OF BUSINESS AFFAIRS AND CONSUMER PROTECTION | Department of Business Affairs and Consumer Protection |
| DEPARTMENT OF BUSINESS AFFAIRS AND LICENSING | Department of Business Affairs and Consumer Protection |
| DEPARTMENT OF CHILDREN AND YOUTH SERVICES | Department of Family and Support Services |
| DEPARTMENT OF CONSTRUCTION AND PERMITS | Department of Buildings |
| DEPARTMENT OF CULTURAL AFFAIRS | Department of Cultural Affairs and Special Events |
| DEPARTMENT OF CULTURAL AFFAIRS AND SPECIAL EVENTS | Department of Cultural Affairs and Special Events |
| DEPARTMENT OF ENVIROMENT | Department of Environment |
| DEPARTMENT OF ENVIRONMENT | Department of Environment |
| DEPARTMENT OF FAMILY AND SUPPORT SERVICES | Department of Family and Support Services |
| DEPARTMENT OF FINANCE | Department of Finance |
| DEPARTMENT OF FLEET AND FACILITY MANAGEMENT | Department of Assets Information and Services |
| DEPARTMENT OF HOUSING | Department of Housing |
| DEPARTMENT OF HUMAN RESOURCES | Department of Human Resources |
| DEPARTMENT OF LAW | Department of Law |
| DEPARTMENT OF PERSONNEL | Department of Human Resources |
| DEPARTMENT OF PLANNING AND DEVELOPMENT | Department of Planning and Development |
| DEPARTMENT OF PROCUREMENT SERVICES | Department of Procurement Services |
| DEPARTMENT OF REVENUE | Department of Finance |
| DEPARTMENT OF STREETS AND SANITATION | Department of Streets and Sanitation |
| DEPARTMENT OF TECHNOLOGY AND INNOVATION | Department of Assets Information and Services |
| DEPARTMENT OF WATER MANAGEMENT | Department of Water Management |
| DEPARTMENT OF ZONING | Department of Planning and Development |
| DEPT OF ASSETS INFORMATION AND SERVICES | Department of Assets Information and Services |
| DEPT OF BUSINESS & INFORMATION SERVICES | Department of Assets Information and Services |
| DEPT OF BUSINESS AFFAIRS & CONSUMER PROTECTION | Department of Business Affairs and Consumer Protection |
| DEPT OF CONSUMER SERVICES | Department of Business Affairs and Consumer Protection |
| DEPT OF FLEET MGMT | Department of Assets Information and Services |
| DEPT OF GENERAL SERVICES | Department of Assets Information and Services |
| DEPT OF INNOVATION & TECHNOLOGY | Department of Assets Information and Services |
| DEPT OF ZONING & LAND USE PLANNING | Department of Planning and Development |
| DEPT ON AGING | Department of Family and Support Services |
| FINANCE GENERAL | Department of Finance |
| GRAPHICS & REPRODUCTION CTR | Department of Assets Information and Services |
| INDEPENDENT POLICE REVIEW AUTHORITY | Independent Police Review Authority |
| LIC COMM & LOCAL LIQ CTRL COMM | License Appeal Commission |
| MAYORS OFFICE FOR PEOPLE WITH DISABILITIES | Mayor's Office for People with Disabilities |
| MAYORS OFFICE OF WORKFORCE DEVELOPMENT | Department of Family and Support Services |
| OFFICE OF BUDGET & MANAGEMENT | Office of Budget and Management |
| OFFICE OF CABLE COMMUNICATION ADM | Office of Cable Communications |
| OFFICE OF CITY CLERK | Office of the City Clerk |
| OFFICE OF COMPLIANCE | Office of Compliance |
| OFFICE OF EMERGENCY MANAGEMENT AND COMMUNICATIONS | Office of Emergency Management and Communications |
| OFFICE OF INSPECTOR GENERAL | Office of Inspector General |
| OFFICE OF PUBLIC SAFETY ADMINISTRATION | Office of Public Safety Administration |
| OFFICE OF SPECIAL EVENTS | Department of Cultural Affairs and Special Events |
| OFFICE OF THE MAYOR | Office of the Mayor |
| OHARE MODERNIZATION PROJECT | Chicago Department of Aviation |
| PLANNING & DEVELOPMENT | Department of Planning and Development |
| CHICAGO PUBLIC LIBRARY | Chicago 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.