latimes_county_totals

Table actions
⚠️ 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_county_totals

559 rows where county = "San Mateo" sorted by date descending

✎ View and edit SQL

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

Suggested facets: new_deaths, date (date)

fips 1

county 1

  • San Mateo · 559 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
41 41 2021-09-02 San Mateo 81 49186 595 158 0
99 99 2021-09-01 San Mateo 81 49028 595 268 0
157 157 2021-08-31 San Mateo 81 48760 595 215 0
215 215 2021-08-30 San Mateo 81 48545 595 484 0
273 273 2021-08-29 San Mateo 81 48061 595 0 0
331 331 2021-08-28 San Mateo 81 48061 595 0 0
389 389 2021-08-27 San Mateo 81 48061 595 186 1
447 447 2021-08-26 San Mateo 81 47875 594 71 0
505 505 2021-08-25 San Mateo 81 47804 594 101 0
563 563 2021-08-24 San Mateo 81 47703 594 68 0
621 621 2021-08-23 San Mateo 81 47635 594 450 0
679 679 2021-08-22 San Mateo 81 47185 594 0 0
737 737 2021-08-21 San Mateo 81 47185 594 0 0
795 795 2021-08-20 San Mateo 81 47185 594 0 0
853 853 2021-08-19 San Mateo 81 47185 594 281 2
911 911 2021-08-18 San Mateo 81 46904 592 0 0
969 969 2021-08-17 San Mateo 81 46904 592 144 0
1027 1027 2021-08-16 San Mateo 81 46760 592 529 0
1085 1085 2021-08-15 San Mateo 81 46231 592 0 0
1143 1143 2021-08-14 San Mateo 81 46231 592 0 0
1201 1201 2021-08-13 San Mateo 81 46231 592 0 0
1259 1259 2021-08-12 San Mateo 81 46231 592 176 4
1317 1317 2021-08-11 San Mateo 81 46055 588 253 0
1375 1375 2021-08-10 San Mateo 81 45802 588 0 0
1433 1433 2021-08-09 San Mateo 81 45802 588 486 0
1491 1491 2021-08-08 San Mateo 81 45316 588 0 0
1549 1549 2021-08-07 San Mateo 81 45316 588 0 0
1607 1607 2021-08-06 San Mateo 81 45316 588 0 0
1665 1665 2021-08-05 San Mateo 81 45316 588 118 0
1723 1723 2021-08-04 San Mateo 81 45198 588 260 0
1781 1781 2021-08-03 San Mateo 81 44938 588 0 0
1839 1839 2021-08-02 San Mateo 81 44938 588 508 0
1897 1897 2021-08-01 San Mateo 81 44430 588 0 0
1955 1955 2021-07-31 San Mateo 81 44430 588 0 0
2013 2013 2021-07-30 San Mateo 81 44430 588 0 0
2071 2071 2021-07-29 San Mateo 81 44430 588 143 0
2129 2129 2021-07-28 San Mateo 81 44287 588 220 0
2187 2187 2021-07-27 San Mateo 81 44067 588 0 0
2245 2245 2021-07-26 San Mateo 81 44067 588 391 0
2303 2303 2021-07-25 San Mateo 81 43676 588 0 0
2361 2361 2021-07-24 San Mateo 81 43676 588 0 0
2419 2419 2021-07-23 San Mateo 81 43676 588 117 4
2477 2477 2021-07-22 San Mateo 81 43559 584 115 0
2535 2535 2021-07-21 San Mateo 81 43444 584 101 0
2593 2593 2021-07-20 San Mateo 81 43343 584 275 0
2651 2651 2021-07-19 San Mateo 81 43068 584 0 0
2709 2709 2021-07-18 San Mateo 81 43068 584 0 0
2767 2767 2021-07-17 San Mateo 81 43068 584 0 0
2825 2825 2021-07-16 San Mateo 81 43068 584 50 1
2883 2883 2021-07-15 San Mateo 81 43018 583 71 0
2941 2941 2021-07-14 San Mateo 81 42947 583 77 0
2999 2999 2021-07-13 San Mateo 81 42870 583 15 0
3057 3057 2021-07-12 San Mateo 81 42855 583 141 0
3115 3115 2021-07-11 San Mateo 81 42714 583 0 0
3173 3173 2021-07-10 San Mateo 81 42714 583 0 0
3231 3231 2021-07-09 San Mateo 81 42714 583 60 2
3289 3289 2021-07-08 San Mateo 81 42654 581 30 0
3347 3347 2021-07-07 San Mateo 81 42624 581 115 0
3405 3405 2021-07-06 San Mateo 81 42509 581 0 0
3463 3463 2021-07-05 San Mateo 81 42509 581 0 0
3521 3521 2021-07-04 San Mateo 81 42509 581 0 0
3579 3579 2021-07-03 San Mateo 81 42509 581 0 0
3637 3637 2021-07-02 San Mateo 81 42509 581 22 0
3695 3695 2021-07-01 San Mateo 81 42487 581 34 0
3753 3753 2021-06-30 San Mateo 81 42453 581 0 0
3811 3811 2021-06-29 San Mateo 81 42453 581 15 0
3869 3869 2021-06-28 San Mateo 81 42438 581 52 0
3927 3927 2021-06-27 San Mateo 81 42386 581 0 0
3985 3985 2021-06-26 San Mateo 81 42386 581 0 0
4043 4043 2021-06-25 San Mateo 81 42386 581 0 0
4101 4101 2021-06-24 San Mateo 81 42386 581 19 0
4159 4159 2021-06-23 San Mateo 81 42367 581 36 0
4217 4217 2021-06-22 San Mateo 81 42331 581 0 0
4275 4275 2021-06-21 San Mateo 81 42331 581 38 0
4333 4333 2021-06-20 San Mateo 81 42293 581 0 0
4391 4391 2021-06-19 San Mateo 81 42293 581 0 0
4449 4449 2021-06-18 San Mateo 81 42293 581 9 0
4507 4507 2021-06-17 San Mateo 81 42284 581 10 0
4565 4565 2021-06-16 San Mateo 81 42274 581 12 0
4623 4623 2021-06-15 San Mateo 81 42262 581 48 0
4681 4681 2021-06-14 San Mateo 81 42214 581 0 0
4739 4739 2021-06-13 San Mateo 81 42214 581 0 0
4797 4797 2021-06-12 San Mateo 81 42214 581 0 0
4855 4855 2021-06-11 San Mateo 81 42214 581 24 2
4913 4913 2021-06-10 San Mateo 81 42190 579 14 0
4971 4971 2021-06-09 San Mateo 81 42176 579 6 0
5029 5029 2021-06-08 San Mateo 81 42170 579 64 0
5087 5087 2021-06-07 San Mateo 81 42106 579 0 0
5145 5145 2021-06-06 San Mateo 81 42106 579 0 0
5203 5203 2021-06-05 San Mateo 81 42106 579 0 0
5261 5261 2021-06-04 San Mateo 81 42106 579 9 3
5319 5319 2021-06-03 San Mateo 81 42097 576 0 0
5377 5377 2021-06-02 San Mateo 81 42097 576 4 0
5435 5435 2021-06-01 San Mateo 81 42093 576 24 0
5493 5493 2021-05-31 San Mateo 81 42069 576 0 0
5551 5551 2021-05-30 San Mateo 81 42069 576 0 0
5609 5609 2021-05-29 San Mateo 81 42069 576 0 0
5667 5667 2021-05-28 San Mateo 81 42069 576 13 3
5725 5725 2021-05-27 San Mateo 81 42056 573 13 0
5783 5783 2021-05-26 San Mateo 81 42043 573 14 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);