STLCA STLCAThe accountability layer between complaint and policy.
Sanity-checked against the uploaded CSV, not just the narrative draft

SDCI citywide record story, year by year

This page turns the uploaded citywide file into a dashboard story with one chart for each year, plus annotations where the trend actually changes. It is built from 233,543 records covering 2003 through 2025. The broad picture is ugly and simple: overall record volume grew 2631.7% from the first year to the latest year on file, while inspection-date documentation deteriorated from a high of 95.6% in 2010 to a low of 24.8% in 2022.

Volume vs. documented inspection trend

Total records are shown in blue. Documented inspection-date rate is shown in teal. The blue line climbs over time; the teal line eventually falls off a cliff.

17,72914,18310,6377,0923,5460200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252004Data intake explodes2010Best inspection documentation2018Documentation cliff2020Pandemic-era strain2022Worst documentation year2025Highest volume on fileTotal recordsDocumented inspection rate

Sanity check against the draft narrative

The narrative text in the pasted file is close on the broad arc, but several yearly counts do not match the uploaded CSV. That means the HTML should use the CSV as the source of truth.

The draft story gets the big arc right: stronger inspection documentation in the earlier era, deteriorating documentation after 2017, and sustained high volume in the 2020s. What it does not do cleanly is match the actual yearly counts. Below are some of the largest mismatches between the pasted report and the CSV.
Year Draft claimed total CSV actual total Delta
202416,17416,395+221
201914,32214,524+202
201812,63012,814+184
20159,4809,655+175
202316,30616,477+171
202012,27512,425+150
202215,27115,413+142
20098,0758,190+115

One chart for each year

Each card shows total record volume, complaints, violations, citations, missing inspection-date count, and a plain-English annotation grounded in the data.

Year

2003

80.9% documented
Total records649
Complaints462
Violations129
Citations45
Missing insp. date124
YoY totaln/a
ComplaintsViolationsCitations
Inspection documentation rate 80.9%

Baseline year in this file. Small volume, relatively strong documentation.

Year

2004

87.2% documented
Total records6,949
Complaints4,066
Violations1,857
Citations768
Missing insp. date888
YoY total+970.7%
ComplaintsViolationsCitations
Inspection documentation rate 87.2%

Record volume jumps sharply from the prior year. Treat this as a data scale change, not a subtle trend.

Year

2005

88.8% documented
Total records7,148
Complaints4,299
Violations1,883
Citations699
Missing insp. date799
YoY total+2.9%
ComplaintsViolationsCitations
Inspection documentation rate 88.8%

Transitional year. The trend is less about one spike than accumulated drift.

Year

2006

91.3% documented
Total records8,087
Complaints4,717
Violations2,411
Citations694
Missing insp. date707
YoY total+13.1%
ComplaintsViolationsCitations
Inspection documentation rate 91.3%

High-documentation year. Most records still show an inspection date.

Year

2007

92.1% documented
Total records8,850
Complaints5,141
Violations2,076
Citations1,320
Missing insp. date703
YoY total+9.4%
ComplaintsViolationsCitations
Inspection documentation rate 92.1%

High-documentation year. Most records still show an inspection date.

Year

2008

94.8% documented
Total records8,899
Complaints5,320
Violations1,567
Citations1,859
Missing insp. date466
YoY total+0.6%
ComplaintsViolationsCitations
Inspection documentation rate 94.8%

High-documentation year. Most records still show an inspection date.

Year

2009

94.0% documented
Total records8,190
Complaints4,890
Violations1,403
Citations1,782
Missing insp. date491
YoY total-8.0%
ComplaintsViolationsCitations
Inspection documentation rate 94.0%

High-documentation year. Most records still show an inspection date.

Year

2010

95.6% documented
Total records7,782
Complaints4,648
Violations1,219
Citations1,841
Missing insp. date341
YoY total-5.0%
ComplaintsViolationsCitations
Inspection documentation rate 95.6%

Best documented inspection year in the file at 95.6%.

Year

2011

84.8% documented
Total records6,478
Complaints4,439
Violations1,161
Citations811
Missing insp. date987
YoY total-16.8%
ComplaintsViolationsCitations
Inspection documentation rate 84.8%

Sharp decline year: total volume fell 16.8% year over year.

Year

2012

81.4% documented
Total records6,768
Complaints4,658
Violations1,261
Citations730
Missing insp. date1,257
YoY total+4.5%
ComplaintsViolationsCitations
Inspection documentation rate 81.4%

Transitional year. The trend is less about one spike than accumulated drift.

Year

2013

85.1% documented
Total records7,231
Complaints4,946
Violations1,279
Citations895
Missing insp. date1,078
YoY total+6.8%
ComplaintsViolationsCitations
Inspection documentation rate 85.1%

Transitional year. The trend is less about one spike than accumulated drift.

Year

2014

83.1% documented
Total records8,163
Complaints5,651
Violations1,462
Citations864
Missing insp. date1,381
YoY total+12.9%
ComplaintsViolationsCitations
Inspection documentation rate 83.1%

Transitional year. The trend is less about one spike than accumulated drift.

Year

2015

79.9% documented
Total records9,655
Complaints6,873
Violations1,602
Citations933
Missing insp. date1,943
YoY total+18.3%
ComplaintsViolationsCitations
Inspection documentation rate 79.9%

Volume keeps climbing while documentation slips below 80%.

Year

2016

76.2% documented
Total records9,890
Complaints7,206
Violations1,417
Citations1,053
Missing insp. date2,351
YoY total+2.4%
ComplaintsViolationsCitations
Inspection documentation rate 76.2%

Transitional year. The trend is less about one spike than accumulated drift.

Year

2017

74.1% documented
Total records10,689
Complaints7,768
Violations1,673
Citations1,035
Missing insp. date2,769
YoY total+8.1%
ComplaintsViolationsCitations
Inspection documentation rate 74.1%

Transitional year. The trend is less about one spike than accumulated drift.

Year

2018

44.3% documented
Total records12,814
Complaints10,457
Violations1,306
Citations817
Missing insp. date7,136
YoY total+19.9%
ComplaintsViolationsCitations
Inspection documentation rate 44.3%

Structural break year. Documentation drops from 74.1% to 44.3% in one year.

Year

2019

46.4% documented
Total records14,524
Complaints11,796
Violations1,423
Citations1,021
Missing insp. date7,786
YoY total+13.3%
ComplaintsViolationsCitations
Inspection documentation rate 46.4%

Transitional year. The trend is less about one spike than accumulated drift.

Year

2020

37.3% documented
Total records12,425
Complaints10,637
Violations970
Citations564
Missing insp. date7,790
YoY total-14.5%
ComplaintsViolationsCitations
Inspection documentation rate 37.3%

Pandemic-era volume dips, but documentation weakens further.

Year

2021

35.9% documented
Total records12,338
Complaints10,570
Violations969
Citations503
Missing insp. date7,912
YoY total-0.7%
ComplaintsViolationsCitations
Inspection documentation rate 35.9%

Low-documentation year. Missing inspection dates dominate the record.

Year

2022

24.8% documented
Total records15,413
Complaints13,953
Violations1,009
Citations233
Missing insp. date11,592
YoY total+24.9%
ComplaintsViolationsCitations
Inspection documentation rate 24.8%

Worst documented inspection year in the full citywide file at 24.8%.

Year

2023

30.6% documented
Total records16,477
Complaints14,673
Violations1,118
Citations522
Missing insp. date11,436
YoY total+6.9%
ComplaintsViolationsCitations
Inspection documentation rate 30.6%

Low-documentation year. Missing inspection dates dominate the record.

Year

2024

38.3% documented
Total records16,395
Complaints14,288
Violations1,245
Citations720
Missing insp. date10,111
YoY total-0.5%
ComplaintsViolationsCitations
Inspection documentation rate 38.3%

Low-documentation year. Missing inspection dates dominate the record.

Year

2025

29.4% documented
Total records17,729
Complaints15,973
Violations969
Citations631
Missing insp. date12,516
YoY total+8.1%
ComplaintsViolationsCitations
Inspection documentation rate 29.4%

Highest total record volume on file, but only 29.4% show a documented inspection date.