Home

Welcome to the covid19 wiki!

LA Data

https://www.latimes.com/projects/california-coronavirus-cases-tracking-outbreak/

=VLOOKUP(B2,'3/22'!$A$1:$B$109,2,false)

Add new LA data, paste into spreadsheet, add the formula to find new cities:

=FILTER(W2:W500,ISERROR(MATCH(W2:W500,B2:B500,0)))

Make ungeocoded rows into a hyperlink to google maps:

=hyperlink(CONCATENATE("https://www.google.com/maps/place/",B147," ",A147))