# Data quality report

Generated 2026-10-26 22:37 (Asia/Karachi). Rows: **6,459** across **19 states**. Window: notices from 2024-10-01 onward.

Build: 16,948 source rows parsed; 10,320 older than the window dropped; 5 exact duplicates removed; 164 rows rejected and logged in `data/rejected.csv` (amendments/rescissions of earlier notices, future-dated notices).

## Per state

| State | Notices | First month | Last month | Employees (sum) | Null employees | Null city | Null county | Null effective date | Day-precision dates |
|---|---:|---|---|---:|---:|---:|---:|---:|---:|
| AK | 4 | 2024-12 | 2026-07 | 343 | 0% | 0% | 100% | 25% | 100% |
| AL | 64 | 2024-11 | 2026-10 | 6,931 | 0% | 0% | 100% | 0% | 100% |
| CA | 3,186 | 2024-10 | 2026-10 | 176,487 | 0% | 88% | 0% | 0% | 100% |
| FL | 586 | 2024-10 | 2026-10 | 40,432 | 0% | 0% | 100% | 0% | 100% |
| IA | 210 | 2024-10 | 2026-10 | 10,097 | 0% | 0% | 0% | 0% | 100% |
| IL | 263 | 2024-10 | 2026-10 | 39,688 | 0% | 0% | 0% | 100% | 100% |
| IN | 66 | 2024-10 | 2026-10 | 9,497 | 0% | 0% | 100% | 0% | 100% |
| MD | 270 | 2024-10 | 2026-10 | 19,283 | 3% | 6% | 0% | 0% | 100% |
| NC | 68 | 2026-01 | 2026-10 | 6,789 | 0% | 0% | 7% | 0% | 100% |
| NJ | 236 | 2024-10 | 2026-10 | 31,302 | 0% | 0% | 100% | 0% | 0% |
| NY | 341 | 2024-10 | 2026-10 | 12,222 | 40% | 100% | 38% | 38% | 100% |
| OH | 66 | 2026-01 | 2026-10 | 7,506 | 0% | 0% | 0% | 0% | 100% |
| OR | 89 | 2024-10 | 2026-10 | 13,634 | 1% | 9% | 100% | 1% | 100% |
| SD | 10 | 2025-01 | 2026-08 | 987 | 10% | 10% | 100% | 100% | 100% |
| TX | 442 | 2024-10 | 2026-10 | 47,561 | 0% | 0% | 0% | 0% | 100% |
| UT | 39 | 2024-10 | 2026-09 | 5,955 | 0% | 0% | 100% | 100% | 100% |
| VA | 126 | 2024-10 | 2026-10 | 14,944 | 1% | 0% | 100% | 0% | 100% |
| WA | 271 | 2024-10 | 2026-10 | 62,880 | 0% | 0% | 100% | 0% | 100% |
| WI | 122 | 2024-10 | 2026-10 | 9,279 | 2% | 1% | 1% | 1% | 100% |

## Overall null rates

| Column | Null rate |
|---|---:|
| id | 0.0% |
| state | 0.0% |
| company | 0.0% |
| address | 32.9% |
| city | 49.1% |
| county | 25.4% |
| notice_date | 3.7% |
| notice_month | 0.0% |
| date_precision | 0.0% |
| received_date | 15.9% |
| effective_date | 6.9% |
| effective_date_text | 85.0% |
| employees | 2.4% |
| notice_type | 0.0% |
| notice_type_raw | 22.3% |
| industry | 74.7% |
| naics | 90.9% |
| note | 98.0% |
| source_url | 0.0% |
| retrieved_at | 0.0% |

## Notices per month (all states)

| Month | Notices | Employees |
|---|---:|---:|
| 2024-10 | 229 | 17,595 |
| 2024-11 | 390 | 21,018 |
| 2024-12 | 166 | 10,075 |
| 2025-01 | 221 | 15,015 |
| 2025-02 | 288 | 22,539 |
| 2025-03 | 261 | 20,253 |
| 2025-04 | 334 | 18,289 |
| 2025-05 | 244 | 36,658 |
| 2025-06 | 206 | 15,677 |
| 2025-07 | 365 | 19,801 |
| 2025-08 | 209 | 15,280 |
| 2025-09 | 227 | 25,390 |
| 2025-10 | 435 | 36,604 |
| 2025-11 | 188 | 18,113 |
| 2025-12 | 114 | 8,459 |
| 2026-01 | 303 | 29,567 |
| 2026-02 | 314 | 23,291 |
| 2026-03 | 296 | 18,150 |
| 2026-04 | 369 | 24,109 |
| 2026-05 | 219 | 27,051 |
| 2026-06 | 298 | 15,734 |
| 2026-07 | 196 | 17,391 |
| 2026-08 | 238 | 19,763 |
| 2026-09 | 237 | 29,318 |
| 2026-10 | 112 | 10,677 |

## Anomalies flagged (kept as published; not edited)

- Notices with more than 10,000 employees: 1 — Tend Exchange Subsidiary LLC and Delaware Tender Staffing Los Angeles County (CA, 16,132)
- Effective date more than a year before the notice date: 1
- NJ publishes only the month a notice was posted (month precision); the `notice_date` column is empty for NJ and `notice_month` is used.
- NY: the state's current dashboard export covers 2026 only; Oct 2024–Mar 2025 come from legacy pages (no employee counts); **Apr–Dec 2025 is not available** from a scriptable source.
- OH and NC: only 2026 is available in a scriptable form (see SOURCES.md).

## Validation

PASS