Federal Compliance Duplication & Docket Gaps
Processed vs consolidated records, title reuse, and docket sparsity across the compliance dataset
Processed records
25
raw extracted rows
Consolidated records
24
96.0% retained
Exact duplicates removed
1
4.0% of processed
Sparse dockets
16
84.2% of consolidated dockets
Redundancy snapshot
This view separates exact row-level duplication from broader overlap caused by reused titles and thin docket coverage.
- 1 exact duplicate record were removed when the processed file was consolidated.
- 16 of 19 consolidated dockets contain a single document, so sparsity remains the dominant pattern.
- 11 of 25 processed records belong to only 2 repeated normalized title clusters.
- The largest overlap cluster accounts for 9 records across 9 dockets.
At-a-glance overlap signals
Repeated-title exposure
11 / 25
records fall into repeated normalized title groups
Largest title cluster
9
records in the biggest overlap cluster
Singleton dockets
16
consolidated dockets still contain only one document
No-docket rows
1
rows remain after consolidation without a docket bucket
Document volume by agency: processed vs consolidated
Exact duplicates are limited, but title reuse remains concentrated
Document-count distribution per docket highlights a sparse long tail
Normalized title clusters show where overlap is actually concentrated
Most populated dockets
| Docket ID | Processed | Consolidated | Removed |
|---|---|---|---|
| EPA-HQ-OAR-2001-0012 | 4 | 4 | 0 |
| NO_DOCKET | 2 | 1 | 1 |
| EPA-HQ-OW-2021-0736 | 2 | 2 | 0 |
| PHMSA-2008-0327 | 2 | 2 | 0 |
| CPSC-2023-0004 | 1 | 1 | 0 |
| EPA-HQ-OW-2009-0819 | 1 | 1 | 0 |
| FMCSA-2020-0101 | 1 | 1 | 0 |
| FMCSA-2022-0003 | 1 | 1 | 0 |
| FMCSA-2025-0622 | 1 | 1 | 0 |
| FRA-2005-21613 | 1 | 1 | 0 |
| FRA-2013-0069 | 1 | 1 | 0 |
| FRA-2016-0086 | 1 | 1 | 0 |
Top normalized title clusters
| Title cluster | Records | Dockets | Agencies |
|---|---|---|---|
| Petition for Waiver of Compliance | 9 | 9 | 1 |
| Parcel Dimension Compliance | 2 | 1 | 1 |
| 1st Quarter 2026 Compliance Report (Special Permit) Docket No. PHMSA-2008-0327 | 1 | 1 | 1 |
| 1st Quarter 2026 Compliance Report - Lake Charles LNG | 1 | 1 | 1 |
| AMWTP Continued Compliance Letter Final 8-21-24 | 1 | 1 | 1 |
| Analysis of Compliance Costs [DCN MP00551] | 1 | 1 | 1 |
| Analysis of Compliance Costs [DCN MP01605] | 1 | 1 | 1 |
| Analysis of Compliance Costs and Economic Impacts -DCN SE12148 | 1 | 1 | 1 |
| DISA Entertainment Compliance Solutions - Request for Renewal of Exemption | 1 | 1 | 1 |
| FMCSA Report of Compliance Investigation April 15 2025 | 1 | 1 | 1 |