latimes_county_totals
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );