Manually debug and fill out all data in our Airtable "Address" table

[charliehoffs]

Motivation/Context: When entries in our database do not have complete address data, they will also lack a latitude and longitude, and thus cannot appear in our UI. If we are striving towards a standard in which our database is the most updated, accurate, complete listing of Bay Area social service resources, we cannot fulfill that promise unless all our UI accurately displays all the data in our database.

Estimate of time: 3 hours of manual data entry and verification

Definition of Done:

• When every row in our "Address" table has a correct street address, city name, and zip code. We will know it is correct when we run the lat/lon script on it, and lat and longs are generated for each row.

Description:
Here are the specific issues with the data in our "address" table:

• 94 records have an empty address_1 field.
• Some cities have names in all CAPS, like ‘BERKELEY’. See a list of all unique city names here (helpful in seeing what the errors are! https://docs.google.com/spreadsheets/d/1tBIJqQNHld4g4xCN8YVwn-XnNbThWsiD4z3XnL7ygMI/edit#gid=0)
• Records missing city and/or zipcode
• There are 691 records with the zipcode being empty or ‘NA’, and 875 records with the city being empty or ‘NA’. 375 records have both missing.
• 293 of the records with missing city actually have the city in address_1 field.

Please help us rectify these errors! To complete a row that is only partially filled in, look up the needed additional information online. For rows with no information address_1, and if it is unclear which service they correspond to (e.g. if the name under "locations" isn't the name of the service you'd be trying to find the street address for) leave that be for now. We'll find a solution!