Re:Changes to accessing and using Geolite2 databases
by rubyfan on Thursday January 02, 2020 @11:11PM
(#21943073)
Excellent analysis. That’s like 2% or less of households in the US? So even at the Zip9 level not ideal for identifying specific households but problematic if you’re one of those 2M Zip9s.
12 of those states, Arkansas, Georgia, Iowa, Kansas, Nebraska, North Carolina, Ohio, Oklahoma, South Dakota, Tennessee, Vermont, and Washington, use address-based tax rates. (The other 12 either just have one rate for the whole state, or just go by ZIP).
For each ZIP-9 in the address files for the 12 address-based states, I found the lowest and the highest street number for that ZIP-9. I then counted how many of the ZIP-9s had the lowest street number the same as the highest street number.
There were a total of 9,311,327 distinct ZIP-9 values.
2,415,305 of them had a low to high range that only included one number.
That's about 26% of the ZIP-9's having a unique street number. Note that this does not necessarily mean a single household, because I'm not looking at the full address. Apartment buildings, for instance, will in many cases show up in that 26%.
[1] https://www.streamlinedsalestax.org/Shared-Pages/rate-and-bo...