I can’t do it, but it would be really great, and make NamUs more user-friendly, if people would round up all the cases from each city (say, San Francisco, California) and make sure they’re listed under the city of San Francisco, California and nowhere else.
I decided, on a whim, to do San Francisco cases today. And this is what happens when I try to type “San Francisco” into the appropriate slot in the form:
I’m having to check all those misspelled ones and the ones in all capital letters or no capital letters see if there’s anyone listed under there. Sometimes there is, but sometimes there isn’t.
They really all ought to be listed under just “San Francisco” and nowhere else. I’m just sayin’. And other cities have the same problem. Here’s two other examples:
The Charley Project Blog 
I will let Todd know asap and get all the cities states counties fixed.
Thanks Christie! If the problem is fixed that could fix several things. Like, it could stop cases from being inadvertently entered twice (once under the correct spelling of the city, once under the typo).
I can work on it —see how it goes -I can start tomorrow
Never mind I thought you meant one of your followers I reread your post and I think meeting someone at mamas in any case I think you have a good idea
At one of the VA Medical Centers I worked the police officers, had entered three or more versions of the same person. So I spent many an hour after duty, slowly cleaning things up in the database. Then editing the bad entries so that they had one entry that all the reports were linked to.
It takes time someone in a leadership position to clean it up, and set up a protocol on how to check first before reinventing the wheel.