37,297 TOTAL RECORDS
Delinquent line items in county dataset
13,985 UNIQUE OWNERS
Avg 2.7 delinquent bills per owner
$80.29M TOTAL DEBT DUE
Cumulative tax debt (2017–2025)
$733.17 MEDIAN BILL
50th percentile delinquent bill
$481.6K LARGEST BILL
Single highest tax lien balance
2017–2025 TAX YEARS
42.9% of debt in 2025 cycle
📊

Tax Year Trend Analysis

Delinquency distribution across Gwinnett tax cycles (2017–2025).

2017
$8,480.84
2018
$1.07M
2019
$1.84M
2020
$3.36M
2021
$4.44M
2022
$6.69M
2023
$10.72M
2024
$17.74M
2025
$34.43M
INTERACTIVE POLICY TOOL

Tax Collection Revenue Simulator

Drag the threshold slider to simulate county revenue recovery by targeting delinquent bills over a specific dollar amount.

Target Minimum Bill Threshold: $0 (All Bills)
$0 (All Bills) $100 $500 $1,000 $5,000+ (Whale Debt)
$80.3M
Est. Recoverable Debt
100.0% of total debt
37,297
Records Targeted
100.0% of all rows
~13,985
Approx. Owners Affected
Baseline Target
01 / INGESTION
✓ 9,915-Page PDF Document
Mainframe PDF report (DQ205GADEK) ingested offline via pypdf stream extraction.
Offline Source
02 / INTEGRITY
✓ 0 Malformed Rows
100% line accounting. Headers, subtotals, and dollar amounts validated without skipping.
Zero Dropped Rows
03 / REPAIR
✓ 32 Column Swaps Fixed
Auto-corrected overflow rows using a deterministic 5-column checksum verification.
Auto-Corrected
04 / DETERMINISM
✓ Byte-Identical Hash
Runs reproducibly on any machine yielding exact 409,142-row CSV outputs.
100% Deterministic
05 / AGGREGATION
✓ JSON Analytics Engine
Compiles amount bands, tax flags, and yearly totals into dashboard JSON feeds.
Structured Output
06 / TESTING
✓ 90 Automated Tests
Full test suite covering parser, models, registry, schemas, and export integrity.
90 Fixtures Passing