home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for 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

25,020 rows where county = "San Mateo" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

  • 81 25,020

county 1

  • San Mateo · 25,020 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
1056 1056 Atherton Atherton 2022-08-19 San Mateo 81 1155   7168
1057 1057 Belmont Belmont 2022-08-19 San Mateo 81 4582   27097
1058 1058 Brisbane Brisbane 2022-08-19 San Mateo 81 903   4697
1059 1059 Broadmoor Broadmoor 2022-08-19 San Mateo 81 1274   5170
1060 1060 Burlingame Burlingame 2022-08-19 San Mateo 81 5445   30576
1061 1061 Colma Colma 2022-08-19 San Mateo 81 858   1302
1062 1062 Daly City Daly City 2022-08-19 San Mateo 81 25439   106677
1063 1063 East Palo Alto East Palo Alto 2022-08-19 San Mateo 81 11481   29593
1064 1064 Emerald Hills Emerald Hills 2022-08-19 San Mateo 81 735   4721
1065 1065 Foster City Foster City 2022-08-19 San Mateo 81 4722   33997
1066 1066 Half Moon Bay Half Moon Bay 2022-08-19 San Mateo 81 2193   12834
1067 1067 Hillsborough Hillsborough 2022-08-19 San Mateo 81 1643   11447
1068 1068 La Honda La Honda 2022-08-19 San Mateo 81 81   960
1069 1069 Ladera Ladera 2022-08-19 San Mateo 81 224   1607
1070 1070 Loma Mar Loma Mar 2022-08-19 San Mateo 81 13   172
1071 1071 Menlo Park Menlo Park 2022-08-19 San Mateo 81 6921   34138
1072 1072 Midcoast Region Midcoast Region 2022-08-19 San Mateo 81 1562   11269
1073 1073 Millbrae Millbrae 2022-08-19 San Mateo 81 3837   22625
1074 1074 North Fair Oaks North Fair Oaks 2022-08-19 San Mateo 81 4717   14372
1075 1075 Pacifica Pacifica 2022-08-19 San Mateo 81 6734   38984
1076 1076 Pescadero Pescadero 2022-08-19 San Mateo 81 43   219
1077 1077 Portola Valley Portola Valley 2022-08-19 San Mateo 81 579   4592
1078 1078 Princeton Princeton 2022-08-19 San Mateo 81 13   382
1079 1079 Redwood City Redwood City 2022-08-19 San Mateo 81 19410   85784
1080 1080 San Bruno San Bruno 2022-08-19 San Mateo 81 9558   43083
1081 1081 San Carlos San Carlos 2022-08-19 San Mateo 81 5179   30154
1082 1082 San Mateo San Mateo 2022-08-19 San Mateo 81 21124   104333
1083 1083 South San Francisco South San Francisco 2022-08-19 San Mateo 81 16640   67408
1084 1084 West Menlo Park West Menlo Park 2022-08-19 San Mateo 81 596   4160
1085 1085 Woodside Woodside 2022-08-19 San Mateo 81 885   5542
2279 2279 Atherton Atherton 2022-08-18 San Mateo 81 1155   7168
2280 2280 Belmont Belmont 2022-08-18 San Mateo 81 4582   27097
2281 2281 Brisbane Brisbane 2022-08-18 San Mateo 81 903   4697
2282 2282 Broadmoor Broadmoor 2022-08-18 San Mateo 81 1274   5170
2283 2283 Burlingame Burlingame 2022-08-18 San Mateo 81 5445   30576
2284 2284 Colma Colma 2022-08-18 San Mateo 81 858   1302
2285 2285 Daly City Daly City 2022-08-18 San Mateo 81 25439   106677
2286 2286 East Palo Alto East Palo Alto 2022-08-18 San Mateo 81 11481   29593
2287 2287 Emerald Hills Emerald Hills 2022-08-18 San Mateo 81 735   4721
2288 2288 Foster City Foster City 2022-08-18 San Mateo 81 4722   33997
2289 2289 Half Moon Bay Half Moon Bay 2022-08-18 San Mateo 81 2193   12834
2290 2290 Hillsborough Hillsborough 2022-08-18 San Mateo 81 1643   11447
2291 2291 La Honda La Honda 2022-08-18 San Mateo 81 81   960
2292 2292 Ladera Ladera 2022-08-18 San Mateo 81 224   1607
2293 2293 Loma Mar Loma Mar 2022-08-18 San Mateo 81 13   172
2294 2294 Menlo Park Menlo Park 2022-08-18 San Mateo 81 6921   34138
2295 2295 Midcoast Region Midcoast Region 2022-08-18 San Mateo 81 1562   11269
2296 2296 Millbrae Millbrae 2022-08-18 San Mateo 81 3837   22625
2297 2297 North Fair Oaks North Fair Oaks 2022-08-18 San Mateo 81 4717   14372
2298 2298 Pacifica Pacifica 2022-08-18 San Mateo 81 6734   38984
2299 2299 Pescadero Pescadero 2022-08-18 San Mateo 81 43   219
2300 2300 Portola Valley Portola Valley 2022-08-18 San Mateo 81 579   4592
2301 2301 Princeton Princeton 2022-08-18 San Mateo 81 13   382
2302 2302 Redwood City Redwood City 2022-08-18 San Mateo 81 19410   85784
2303 2303 San Bruno San Bruno 2022-08-18 San Mateo 81 9558   43083
2304 2304 San Carlos San Carlos 2022-08-18 San Mateo 81 5179   30154
2305 2305 San Mateo San Mateo 2022-08-18 San Mateo 81 21124   104333
2306 2306 South San Francisco South San Francisco 2022-08-18 San Mateo 81 16640   67408
2307 2307 West Menlo Park West Menlo Park 2022-08-18 San Mateo 81 596   4160
2308 2308 Woodside Woodside 2022-08-18 San Mateo 81 885   5542
3517 3517 Atherton Atherton 2022-08-17 San Mateo 81 1155   7168
3518 3518 Belmont Belmont 2022-08-17 San Mateo 81 4582   27097
3519 3519 Brisbane Brisbane 2022-08-17 San Mateo 81 903   4697
3520 3520 Broadmoor Broadmoor 2022-08-17 San Mateo 81 1274   5170
3521 3521 Burlingame Burlingame 2022-08-17 San Mateo 81 5445   30576
3522 3522 Colma Colma 2022-08-17 San Mateo 81 858   1302
3523 3523 Daly City Daly City 2022-08-17 San Mateo 81 25439   106677
3524 3524 East Palo Alto East Palo Alto 2022-08-17 San Mateo 81 11481   29593
3525 3525 Emerald Hills Emerald Hills 2022-08-17 San Mateo 81 735   4721
3526 3526 Foster City Foster City 2022-08-17 San Mateo 81 4722   33997
3527 3527 Half Moon Bay Half Moon Bay 2022-08-17 San Mateo 81 2193   12834
3528 3528 Hillsborough Hillsborough 2022-08-17 San Mateo 81 1643   11447
3529 3529 La Honda La Honda 2022-08-17 San Mateo 81 81   960
3530 3530 Ladera Ladera 2022-08-17 San Mateo 81 224   1607
3531 3531 Loma Mar Loma Mar 2022-08-17 San Mateo 81 13   172
3532 3532 Menlo Park Menlo Park 2022-08-17 San Mateo 81 6921   34138
3533 3533 Midcoast Region Midcoast Region 2022-08-17 San Mateo 81 1562   11269
3534 3534 Millbrae Millbrae 2022-08-17 San Mateo 81 3837   22625
3535 3535 North Fair Oaks North Fair Oaks 2022-08-17 San Mateo 81 4717   14372
3536 3536 Pacifica Pacifica 2022-08-17 San Mateo 81 6734   38984
3537 3537 Pescadero Pescadero 2022-08-17 San Mateo 81 43   219
3538 3538 Portola Valley Portola Valley 2022-08-17 San Mateo 81 579   4592
3539 3539 Princeton Princeton 2022-08-17 San Mateo 81 13   382
3540 3540 Redwood City Redwood City 2022-08-17 San Mateo 81 19410   85784
3541 3541 San Bruno San Bruno 2022-08-17 San Mateo 81 9558   43083
3542 3542 San Carlos San Carlos 2022-08-17 San Mateo 81 5179   30154
3543 3543 San Mateo San Mateo 2022-08-17 San Mateo 81 21124   104333
3544 3544 South San Francisco South San Francisco 2022-08-17 San Mateo 81 16640   67408
3545 3545 West Menlo Park West Menlo Park 2022-08-17 San Mateo 81 596   4160
3546 3546 Woodside Woodside 2022-08-17 San Mateo 81 885   5542
4755 4755 Atherton Atherton 2022-08-16 San Mateo 81 1155   7168
4756 4756 Belmont Belmont 2022-08-16 San Mateo 81 4582   27097
4757 4757 Brisbane Brisbane 2022-08-16 San Mateo 81 903   4697
4758 4758 Broadmoor Broadmoor 2022-08-16 San Mateo 81 1274   5170
4759 4759 Burlingame Burlingame 2022-08-16 San Mateo 81 5445   30576
4760 4760 Colma Colma 2022-08-16 San Mateo 81 858   1302
4761 4761 Daly City Daly City 2022-08-16 San Mateo 81 25439   106677
4762 4762 East Palo Alto East Palo Alto 2022-08-16 San Mateo 81 11481   29593
4763 4763 Emerald Hills Emerald Hills 2022-08-16 San Mateo 81 735   4721
4764 4764 Foster City Foster City 2022-08-16 San Mateo 81 4722   33997

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);
Powered by Datasette · Queries took 1122.012ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals