# Data quality report

Generated 2026-11-02 06:13 (Asia/Karachi). Rows: **6,683** across **25 states**. Window: notices from 2024-10-01 onward.

Build: 17,098 source rows parsed; 10,386 older than the window dropped; 5 exact duplicates removed; 170 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 | 66 | 2024-11 | 2026-10 | 7,107 | 0% | 0% | 100% | 0% | 100% |
| AZ | 115 | 2024-10 | 2026-10 | 17,588 | 0% | 0% | 100% | 100% | 100% |
| CA | 3,200 | 2024-10 | 2026-10 | 178,465 | 0% | 88% | 0% | 0% | 100% |
| FL | 586 | 2024-10 | 2026-10 | 40,432 | 0% | 0% | 100% | 0% | 100% |
| IA | 214 | 2024-10 | 2026-10 | 10,286 | 0% | 0% | 0% | 0% | 100% |
| IL | 263 | 2024-10 | 2026-10 | 39,688 | 0% | 0% | 0% | 100% | 100% |
| IN | 68 | 2024-10 | 2026-10 | 9,608 | 0% | 0% | 100% | 0% | 100% |
| MD | 272 | 2024-10 | 2026-10 | 19,339 | 3% | 7% | 0% | 0% | 100% |
| ME | 15 | 2024-12 | 2026-10 | 1,034 | 0% | 0% | 100% | 100% | 100% |
| MS | 31 | 2024-10 | 2026-07 | 4,281 | 0% | 0% | 0% | 13% | 100% |
| NC | 70 | 2026-01 | 2026-10 | 6,885 | 0% | 0% | 7% | 0% | 100% |
| ND | 6 | 2024-12 | 2026-01 | 1,029 | 0% | 50% | 100% | 0% | 100% |
| NJ | 239 | 2024-10 | 2026-10 | 31,602 | 0% | 0% | 100% | 0% | 0% |
| NY | 342 | 2024-10 | 2026-10 | 12,105 | 40% | 100% | 37% | 37% | 100% |
| OH | 68 | 2026-01 | 2026-10 | 7,592 | 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 | 439 | 2024-10 | 2026-10 | 45,664 | 0% | 0% | 0% | 0% | 100% |
| UT | 40 | 2024-10 | 2026-10 | 5,963 | 0% | 0% | 100% | 100% | 100% |
| VA | 129 | 2024-10 | 2026-10 | 15,297 | 1% | 0% | 100% | 0% | 100% |
| VT | 16 | 2024-10 | 2026-10 | 1,423 | 0% | 0% | 100% | 100% | 100% |
| WA | 275 | 2024-10 | 2026-10 | 63,452 | 0% | 0% | 100% | 0% | 100% |
| WI | 124 | 2024-10 | 2026-10 | 9,471 | 2% | 1% | 1% | 1% | 100% |
| WV | 2 | 2024-10 | 2024-12 | 67 | 0% | 0% | 0% | 0% | 100% |

## Overall null rates

| Column | Null rate |
|---|---:|
| id | 0.0% |
| state | 0.0% |
| company | 0.0% |
| address | 33.6% |
| city | 47.5% |
| county | 27.0% |
| notice_date | 3.6% |
| notice_month | 0.0% |
| date_precision | 0.0% |
| received_date | 16.1% |
| effective_date | 8.9% |
| effective_date_text | 84.9% |
| employees | 2.3% |
| notice_type | 0.0% |
| notice_type_raw | 23.9% |
| industry | 74.7% |
| naics | 90.7% |
| note | 95.2% |
| source_url | 0.0% |
| retrieved_at | 0.0% |

## Notices per month (all states)

| Month | Notices | Employees |
|---|---:|---:|
| 2024-10 | 237 | 18,893 |
| 2024-11 | 394 | 21,420 |
| 2024-12 | 174 | 10,779 |
| 2025-01 | 225 | 16,056 |
| 2025-02 | 299 | 23,786 |
| 2025-03 | 269 | 21,175 |
| 2025-04 | 342 | 19,200 |
| 2025-05 | 253 | 37,680 |
| 2025-06 | 212 | 16,111 |
| 2025-07 | 379 | 22,821 |
| 2025-08 | 216 | 15,845 |
| 2025-09 | 234 | 26,690 |
| 2025-10 | 440 | 39,874 |
| 2025-11 | 194 | 18,690 |
| 2025-12 | 116 | 8,712 |
| 2026-01 | 315 | 28,859 |
| 2026-02 | 320 | 23,997 |
| 2026-03 | 298 | 18,179 |
| 2026-04 | 381 | 25,866 |
| 2026-05 | 225 | 28,107 |
| 2026-06 | 309 | 17,220 |
| 2026-07 | 199 | 17,835 |
| 2026-08 | 245 | 20,229 |
| 2026-09 | 245 | 30,073 |
| 2026-10 | 162 | 15,245 |

## 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