409,142 TOTAL RECORDS
Delinquent line items in county dataset
15,145 UNIQUE OWNERS
Avg 27.0 delinquent bills per owner
$62.75M TOTAL DEBT DUE
Cumulative tax debt (2018–2025)
$19.23 MEDIAN BILL
50th percentile delinquent bill
$206.3K LARGEST BILL
Single highest tax lien balance
2018–2025 TAX YEARS
56.9% of debt in 2025 cycle
📊

Tax Year Trend Analysis

Delinquency distribution across Dekalb tax cycles (2018–2025).

2018
$1.92M
2019
$4.09M
2020
$2.24M
2021
$2.62M
2022
$3.00M
2023
$3.89M
2024
$9.26M
2025
$35.73M
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)
$62.8M
Est. Recoverable Debt
100.0% of total debt
409,142
Records Targeted
100.0% of all rows
~15,145
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