latimes_place_totals

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

1,053 rows where fips = 81 sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

fips

  • 81 · 1,053

county

Link rowid date ▲ county fips place confirmed_cases note x y
1895 2020-10-29 San Mateo 81 Atherton 42   -122.202983 37.45118
1896 2020-10-29 San Mateo 81 Belmont 163   -122.290029 37.517802
1897 2020-10-29 San Mateo 81 Brisbane 38   -122.407083 37.694842
1898 2020-10-29 San Mateo 81 Broadmoor 59   -122.478889 37.6925
1899 2020-10-29 San Mateo 81 Burlingame 251   -122.367428 37.568525
1900 2020-10-29 San Mateo 81 Colma 60   -122.452386 37.690456
1901 2020-10-29 San Mateo 81 Daly City 1713   -122.486349 37.68
1902 2020-10-29 San Mateo 81 East Palo Alto 1403   -122.117826 37.453055
1903 2020-10-29 San Mateo 81 El Granada 42   -122.47323 37.503766
1904 2020-10-29 San Mateo 81 Emerald Hills 32   -122.268 37.4647
1905 2020-10-29 San Mateo 81 Foster City 145   -122.27106 37.554948
1906 2020-10-29 San Mateo 81 Half Moon Bay 311   -122.4354 37.490308
1907 2020-10-29 San Mateo 81 Hillsborough 68   -122.3794 37.5741
1908 2020-10-29 San Mateo 81 La Honda 1 9 or fewer -122.208658 37.291115
1909 2020-10-29 San Mateo 81 Ladera 12   -122.197222 37.399444
1910 2020-10-29 San Mateo 81 Loma Mar 1 9 or fewer -122.276731 37.27042
1911 2020-10-29 San Mateo 81 Menlo Park 394   -122.180281 37.448491
1912 2020-10-29 San Mateo 81 Millbrae 214   -122.418411 37.595895
1913 2020-10-29 San Mateo 81 Montara 14   -122.511815 37.540905
1914 2020-10-29 San Mateo 81 Moss Beach 14   -122.486349 37.546354
1915 2020-10-29 San Mateo 81 North Fair Oaks 551   -122.1966 37.4744
1916 2020-10-29 San Mateo 81 Pacifica 237   122.480689 37.610177
1917 2020-10-29 San Mateo 81 Pescadero 20   -122.333426 37.205116
1918 2020-10-29 San Mateo 81 Portola Valley 24   -122.208658 37.387118
1919 2020-10-29 San Mateo 81 Princeton 1 9 or fewer -122.01 39.4032
1920 2020-10-29 San Mateo 81 Redwood City 1614   -122.2364 37.4852
1921 2020-10-29 San Mateo 81 San Bruno 513   -122.429737 37.62107
1922 2020-10-29 San Mateo 81 San Carlos 143   -122.27106 37.497516
1923 2020-10-29 San Mateo 81 San Mateo 1665   -122.3255 37.563
1924 2020-10-29 San Mateo 81 South San Francisco 1204   -122.418411 37.65319
1925 2020-10-29 San Mateo 81 West Menlo Park 13   -122.203 37.4335
1926 2020-10-29 San Mateo 81 Woodside 39   -122.2539 37.4299
7098 2020-10-23 San Mateo 81 Atherton 44   -122.202983 37.45118
7099 2020-10-23 San Mateo 81 Belmont 160   -122.290029 37.517802
7100 2020-10-23 San Mateo 81 Brisbane 36   -122.407083 37.694842
7101 2020-10-23 San Mateo 81 Broadmoor 1 9 or fewer -122.478889 37.6925
7102 2020-10-23 San Mateo 81 Burlingame 247   -122.367428 37.568525
7103 2020-10-23 San Mateo 81 Colma 31   -122.452386 37.690456
7104 2020-10-23 San Mateo 81 Daly City 1747   -122.486349 37.68
7105 2020-10-23 San Mateo 81 East Palo Alto 1370   -122.117826 37.453055
7106 2020-10-23 San Mateo 81 El Granada 29   -122.47323 37.503766
7107 2020-10-23 San Mateo 81 Emerald Hills 25   -122.268 37.4647
7108 2020-10-23 San Mateo 81 Foster City 139   -122.27106 37.554948
7109 2020-10-23 San Mateo 81 Half Moon Bay 375   -122.4354 37.490308
7110 2020-10-23 San Mateo 81 Hillsborough 63   -122.3794 37.5741
7111 2020-10-23 San Mateo 81 La Honda 1 9 or fewer -122.208658 37.291115
7112 2020-10-23 San Mateo 81 Ladera 1 9 or fewer -122.197222 37.399444
7113 2020-10-23 San Mateo 81 Loma Mar 1 9 or fewer -122.276731 37.27042
7114 2020-10-23 San Mateo 81 Menlo Park 451   -122.180281 37.448491
7115 2020-10-23 San Mateo 81 Millbrae 211   -122.418411 37.595895
7116 2020-10-23 San Mateo 81 Montara 13   -122.511815 37.540905
7117 2020-10-23 San Mateo 81 Moss Beach 48   -122.486349 37.546354
7118 2020-10-23 San Mateo 81 North Fair Oaks 1 9 or fewer -122.1966 37.4744
7119 2020-10-23 San Mateo 81 Pacifica 228   122.480689 37.610177
7120 2020-10-23 San Mateo 81 Pescadero 25   -122.333426 37.205116
7121 2020-10-23 San Mateo 81 Portola Valley 38   -122.208658 37.387118
7122 2020-10-23 San Mateo 81 Princeton 1 9 or fewer -122.01 39.4032
7123 2020-10-23 San Mateo 81 Redwood City 2163   -122.2364 37.4852
7124 2020-10-23 San Mateo 81 San Bruno 495   -122.429737 37.62107
7125 2020-10-23 San Mateo 81 San Carlos 147   -122.27106 37.497516
7126 2020-10-23 San Mateo 81 San Mateo 1643   -122.3255 37.563
7127 2020-10-23 San Mateo 81 South San Francisco 1173   -122.418411 37.65319
7128 2020-10-23 San Mateo 81 West Menlo Park 1 9 or fewer -122.203 37.4335
7129 2020-10-23 San Mateo 81 Woodside 43   -122.2539 37.4299
13235 2020-10-16 San Mateo 81 Atherton 45   -122.202983 37.45118
13236 2020-10-16 San Mateo 81 Belmont 149   -122.290029 37.517802
13237 2020-10-16 San Mateo 81 Brisbane 36   -122.407083 37.694842
13238 2020-10-16 San Mateo 81 Broadmoor 1 9 or fewer -122.478889 37.6925
13239 2020-10-16 San Mateo 81 Burlingame 237   -122.367428 37.568525
13240 2020-10-16 San Mateo 81 Colma 26   -122.452386 37.690456
13241 2020-10-16 San Mateo 81 Daly City 1694   -122.486349 37.68
13242 2020-10-16 San Mateo 81 East Palo Alto 1334   -122.117826 37.453055
13243 2020-10-16 San Mateo 81 El Granada 29   -122.47323 37.503766
13244 2020-10-16 San Mateo 81 Emerald Hills 25   -122.268 37.4647
13245 2020-10-16 San Mateo 81 Foster City 134   -122.27106 37.554948
13246 2020-10-16 San Mateo 81 Half Moon Bay 368   -122.4354 37.490308
13247 2020-10-16 San Mateo 81 Hillsborough 58   -122.3794 37.5741
13248 2020-10-16 San Mateo 81 La Honda 1 9 or fewer -122.208658 37.291115
13249 2020-10-16 San Mateo 81 Ladera 1 9 or fewer -122.197222 37.399444
13250 2020-10-16 San Mateo 81 Loma Mar 1 9 or fewer -122.276731 37.27042
13251 2020-10-16 San Mateo 81 Menlo Park 433   -122.180281 37.448491
13252 2020-10-16 San Mateo 81 Millbrae 207   -122.418411 37.595895
13253 2020-10-16 San Mateo 81 Montara 13   -122.511815 37.540905
13254 2020-10-16 San Mateo 81 Moss Beach 46   -122.486349 37.546354
13255 2020-10-16 San Mateo 81 North Fair Oaks 1 9 or fewer -122.1966 37.4744
13256 2020-10-16 San Mateo 81 Pacifica 223   122.480689 37.610177
13257 2020-10-16 San Mateo 81 Pescadero 24   -122.333426 37.205116
13258 2020-10-16 San Mateo 81 Portola Valley 38   -122.208658 37.387118
13259 2020-10-16 San Mateo 81 Princeton 1 9 or fewer -122.01 39.4032
13260 2020-10-16 San Mateo 81 Redwood City 2122   -122.2364 37.4852
13261 2020-10-16 San Mateo 81 San Bruno 482   -122.429737 37.62107
13262 2020-10-16 San Mateo 81 San Carlos 143   -122.27106 37.497516
13263 2020-10-16 San Mateo 81 San Mateo 1591   -122.3255 37.563
13264 2020-10-16 San Mateo 81 South San Francisco 1135   -122.418411 37.65319
13265 2020-10-16 San Mateo 81 West Menlo Park 1 9 or fewer -122.203 37.4335
13266 2020-10-16 San Mateo 81 Woodside 40   -122.2539 37.4299
19278 2020-10-09 San Mateo 81 Atherton 45   -122.202983 37.45118
19279 2020-10-09 San Mateo 81 Belmont 145   -122.290029 37.517802
19280 2020-10-09 San Mateo 81 Brisbane 36   -122.407083 37.694842
19281 2020-10-09 San Mateo 81 Broadmoor 1 9 or fewer -122.478889 37.6925

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 870.538ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals