1975 Guide

[regan008]

@haileybrink Here is a working checklist of data integrity issues to look for:

• [x] - States should be listed with abbreviations not full names. i.e. CA not California. Is an issue in at least parts of 85, 81, 77.
• [x] - City names in 75 need to be checked for /s i.e. Lithia/Tampa. Check guide for more specific location. If not listed in guide use this geocoding tool
• [x] entries listed as statewide need to have blank cities instead.
• [x] Washington DC entries should be listed as Washington in city rather than Washington, D.C.. because dc is in the state column for geocoding purposes.
• [x] Some cities need to be more specific. Look through to find any with a / splitting metro areas. Check guides and if no more specific location is listed, use geocoding tool linked above.
• [x] verify locations with blank cities to ensure they are statewide
• [x] states should have abbreviations not full names i.e. CA rather than California
• [x] Filter and check that locations without addresses are marked unclear. PO Boxes too.

[haileybrink]

I have completed all of the things on the checklist. After going through the scanned issue, i didn't find any additional statewide entries. Additionally, there is an entry for MA that is statewide that I could not find in the issue - this is noted in the airtable section for that listing.

[heinz-am]

@haileybrink Thanks for your excellent work! We resolved the mystery DOB entry. (The home city had been mistakenly left off.)

[regan008]

@Hmknipp Column names in airtable for 1975 will need to be updated. Use the names from 1983 as a guide. I'll let you know when the geocoding script is updated and ready to go