“Corrected” = standardized after repair (spelling, abbreviation, formatting). Rows that could not be standardized are the ones most likely to fail in the mail stream — verify or retire them first.
| Gap | Rows | Share |
|---|---|---|
| Missing ZIP entirely | 0 | 0% |
| 5-digit only (no +4) | 20 | 100% |
| Address (largest clusters) | Cluster size |
|---|---|
| 1600 PENNSYLVANIA AVE NW, WASHINGTON, DC, 20500 | 2 rows |
| 11 WALL ST, NEW YORK, NY, 10005 | 2 rows |
4 rows sit in duplicate clusters; keeping one per cluster retires 2 rows.
| County | Rows | Share of geocoded |
|---|---|---|
| New York County, New York | 4 | 23.5% |
| District of Columbia, District of Columbia | 2 | 11.8% |
| Suffolk County, Massachusetts | 2 | 11.8% |
| Cook County, Illinois | 2 | 11.8% |
| Los Angeles County, California | 2 | 11.8% |
| San Francisco County, California | 1 | 5.9% |
| Travis County, Texas | 1 | 5.9% |
| San Juan Municipio, Puerto Rico | 1 | 5.9% |
Median household income across matched neighborhoods (Census ACS 5-year, tract level): p25 $76,524 · median $108,158 · p75 $159,556 — sampled over 15 enriched rows.
9 rows sit in census tracts with ≥10% housing vacancy (average tract vacancy across the list: 14.2%). High-vacancy tracts correlate with address churn — treat these rows as the second verification priority after the could-not-standardize set.
| Repair | Rows |
|---|---|
| ZIP codes repaired (Excel-stripped zeros, +4 formation) | 3 |
| State names normalized to USPS two-letter codes | 8 |
| Whitespace / formatting repaired | 1 |
| Duplicate rows flagged | 0 |
| Assumption (editable — tell us yours and we re-run it) | Value |
|---|---|
| Postage per piece (metered first-class letter) | $0.73 |
| Print + materials per piece | $0.35 |
| Mailings per year | 4 |
| At-risk rows (could not standardize + blank) | 3 |
| Redundant duplicate rows | 2 |
| Waste per mailing | $5.40 |
Method. Addresses were standardized, geocoded and deduplicated against the U.S. Census Bureau's national address inventory (Public_AR_Current benchmark), with neighborhood enrichment from the ACS 5-year survey at census-tract level. This report describes standardization quality and statistical delivery risk; it is not a postal certification and does not include change-of-address processing. Files and reports are deleted 30 days after upload. Questions — [email protected].