It's a slow process (as I've been respectful of the rate-limit on the reverse geocoding API I'm using), but I finished mapping four states and hope to complete the other 46 by the end of this week.
How about adding something to the page itself about completion status?
I went and looked, before reading your second paragraph, and the clusters immediately jumped out, and it either seemed suspect or wrong. Then I had to come back here to see why it was wrong.
Great, we can now walk around with pitchforks. I'm kidding These loans have benefited numerous small businesses but we can now keep an eye on those who did not really need it.
Are the locations in Canada the headquarters of a Canadian company? I've read about non-US companies receiving PPP money so I'm just curious about that.
Yep, automotive car dealers in my area have different names on their LLC and the dealership. It's a tough one to crack but implementing google street view would solve 70% of the checks.
My goal for this map was a tool to search for PPP recipients within your own neighborhood.
You're right that it would be interesting to do analysis on population-adjusted loan amounts for different regions... maybe something like a loan $ per capita map?
I was thinking the same thing about the author from above as well.
What I think would be much more interesting is to see what businesses have physical B&M locations. In other words, cross reference Yelp/Google Places with the legal entity's address. Or maybe cross referenced against unemployment numbers by state/city (if that data exists).
Nit: what you're doing is geocoding, not reverse geocoding. Geocoding is the process of turning strings into lats/longs. Reverse is the reverse of that, namely lats/longs into strings.
It's a slow process (as I've been respectful of the rate-limit on the reverse geocoding API I'm using), but I finished mapping four states and hope to complete the other 46 by the end of this week.