latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
31,362 rows sorted by county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Los Angeles 586
- Orange 586
- Santa Clara 586
- San Benito 581
- Humboldt 564
- Sacramento 564
- Solano 560
- Alameda 559
- Calaveras 559
- Contra Costa 559
- Marin 559
- Placer 559
- Riverside 559
- San Diego 559
- San Francisco 559
- San Mateo 559
- Santa Cruz 559
- Shasta 559
- Sonoma 559
- Stanislaus 559
- Ventura 559
- Yolo 559
- Fresno 555
- San Joaquin 551
- Madera 545
- Imperial 541
- Tulare 541
- Amador 539
- San Luis Obispo 538
- San Bernardino 537
- …
Link | rowid | date | county ▲ | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
58 | 58 | 2021-09-02 | Yuba | 115 | 8865 | 52 | 81 | 0 |
116 | 116 | 2021-09-01 | Yuba | 115 | 8784 | 52 | 233 | 2 |
174 | 174 | 2021-08-31 | Yuba | 115 | 8551 | 50 | 0 | 0 |
232 | 232 | 2021-08-30 | Yuba | 115 | 8551 | 50 | 134 | 0 |
290 | 290 | 2021-08-29 | Yuba | 115 | 8417 | 50 | 0 | 0 |
348 | 348 | 2021-08-28 | Yuba | 115 | 8417 | 50 | 0 | 0 |
406 | 406 | 2021-08-27 | Yuba | 115 | 8417 | 50 | 100 | 1 |
464 | 464 | 2021-08-26 | Yuba | 115 | 8317 | 49 | 118 | 1 |
522 | 522 | 2021-08-25 | Yuba | 115 | 8199 | 48 | 20 | 1 |
580 | 580 | 2021-08-24 | Yuba | 115 | 8179 | 47 | 104 | 1 |
638 | 638 | 2021-08-23 | Yuba | 115 | 8075 | 46 | 130 | 1 |
696 | 696 | 2021-08-22 | Yuba | 115 | 7945 | 45 | 0 | 0 |
754 | 754 | 2021-08-21 | Yuba | 115 | 7945 | 45 | 85 | 1 |
812 | 812 | 2021-08-20 | Yuba | 115 | 7860 | 44 | 0 | 0 |
870 | 870 | 2021-08-19 | Yuba | 115 | 7860 | 44 | 71 | 0 |
928 | 928 | 2021-08-18 | Yuba | 115 | 7789 | 44 | 52 | 0 |
986 | 986 | 2021-08-17 | Yuba | 115 | 7737 | 44 | 153 | 0 |
1044 | 1044 | 2021-08-16 | Yuba | 115 | 7584 | 44 | 22 | 0 |
1102 | 1102 | 2021-08-15 | Yuba | 115 | 7562 | 44 | 0 | 0 |
1160 | 1160 | 2021-08-14 | Yuba | 115 | 7562 | 44 | 0 | 0 |
1218 | 1218 | 2021-08-13 | Yuba | 115 | 7562 | 44 | 46 | 0 |
1276 | 1276 | 2021-08-12 | Yuba | 115 | 7516 | 44 | 68 | 0 |
1334 | 1334 | 2021-08-11 | Yuba | 115 | 7448 | 44 | 64 | 0 |
1392 | 1392 | 2021-08-10 | Yuba | 115 | 7384 | 44 | 63 | 0 |
1450 | 1450 | 2021-08-09 | Yuba | 115 | 7321 | 44 | 53 | 0 |
1508 | 1508 | 2021-08-08 | Yuba | 115 | 7268 | 44 | 0 | 0 |
1566 | 1566 | 2021-08-07 | Yuba | 115 | 7268 | 44 | 0 | 0 |
1624 | 1624 | 2021-08-06 | Yuba | 115 | 7268 | 44 | 55 | 0 |
1682 | 1682 | 2021-08-05 | Yuba | 115 | 7213 | 44 | 65 | 2 |
1740 | 1740 | 2021-08-04 | Yuba | 115 | 7148 | 42 | 19 | 0 |
1798 | 1798 | 2021-08-03 | Yuba | 115 | 7129 | 42 | 21 | 1 |
1856 | 1856 | 2021-08-02 | Yuba | 115 | 7108 | 41 | 104 | 0 |
1914 | 1914 | 2021-08-01 | Yuba | 115 | 7004 | 41 | 0 | 0 |
1972 | 1972 | 2021-07-31 | Yuba | 115 | 7004 | 41 | 0 | 0 |
2030 | 2030 | 2021-07-30 | Yuba | 115 | 7004 | 41 | 19 | 0 |
2088 | 2088 | 2021-07-29 | Yuba | 115 | 6985 | 41 | 36 | 0 |
2146 | 2146 | 2021-07-28 | Yuba | 115 | 6949 | 41 | 33 | 0 |
2204 | 2204 | 2021-07-27 | Yuba | 115 | 6916 | 41 | 38 | 0 |
2262 | 2262 | 2021-07-26 | Yuba | 115 | 6878 | 41 | 35 | 0 |
2320 | 2320 | 2021-07-25 | Yuba | 115 | 6843 | 41 | 0 | 0 |
2378 | 2378 | 2021-07-24 | Yuba | 115 | 6843 | 41 | 0 | 0 |
2436 | 2436 | 2021-07-23 | Yuba | 115 | 6843 | 41 | 27 | 0 |
2494 | 2494 | 2021-07-22 | Yuba | 115 | 6816 | 41 | 27 | 0 |
2552 | 2552 | 2021-07-21 | Yuba | 115 | 6789 | 41 | 31 | 0 |
2610 | 2610 | 2021-07-20 | Yuba | 115 | 6758 | 41 | 28 | 0 |
2668 | 2668 | 2021-07-19 | Yuba | 115 | 6730 | 41 | 39 | 0 |
2726 | 2726 | 2021-07-18 | Yuba | 115 | 6691 | 41 | 0 | 0 |
2784 | 2784 | 2021-07-17 | Yuba | 115 | 6691 | 41 | 0 | 0 |
2842 | 2842 | 2021-07-16 | Yuba | 115 | 6691 | 41 | 21 | 0 |
2900 | 2900 | 2021-07-15 | Yuba | 115 | 6670 | 41 | 19 | 0 |
2958 | 2958 | 2021-07-14 | Yuba | 115 | 6651 | 41 | 15 | 0 |
3016 | 3016 | 2021-07-13 | Yuba | 115 | 6636 | 41 | 10 | 0 |
3074 | 3074 | 2021-07-12 | Yuba | 115 | 6626 | 41 | 28 | 0 |
3132 | 3132 | 2021-07-11 | Yuba | 115 | 6598 | 41 | 0 | 0 |
3190 | 3190 | 2021-07-10 | Yuba | 115 | 6598 | 41 | 0 | 0 |
3248 | 3248 | 2021-07-09 | Yuba | 115 | 6598 | 41 | 12 | 0 |
3306 | 3306 | 2021-07-08 | Yuba | 115 | 6586 | 41 | 9 | 0 |
3364 | 3364 | 2021-07-07 | Yuba | 115 | 6577 | 41 | 1 | 0 |
3422 | 3422 | 2021-07-06 | Yuba | 115 | 6576 | 41 | 21 | 0 |
3480 | 3480 | 2021-07-05 | Yuba | 115 | 6555 | 41 | 0 | 0 |
3538 | 3538 | 2021-07-04 | Yuba | 115 | 6555 | 41 | 0 | 0 |
3596 | 3596 | 2021-07-03 | Yuba | 115 | 6555 | 41 | 0 | 0 |
3654 | 3654 | 2021-07-02 | Yuba | 115 | 6555 | 41 | 10 | 0 |
3712 | 3712 | 2021-07-01 | Yuba | 115 | 6545 | 41 | 7 | 0 |
3770 | 3770 | 2021-06-30 | Yuba | 115 | 6538 | 41 | 0 | 0 |
3828 | 3828 | 2021-06-29 | Yuba | 115 | 6538 | 41 | 9 | 0 |
3886 | 3886 | 2021-06-28 | Yuba | 115 | 6529 | 41 | 3 | 0 |
3944 | 3944 | 2021-06-27 | Yuba | 115 | 6526 | 41 | 0 | 0 |
4002 | 4002 | 2021-06-26 | Yuba | 115 | 6526 | 41 | 0 | 0 |
4060 | 4060 | 2021-06-25 | Yuba | 115 | 6526 | 41 | 5 | 0 |
4118 | 4118 | 2021-06-24 | Yuba | 115 | 6521 | 41 | 2 | 0 |
4176 | 4176 | 2021-06-23 | Yuba | 115 | 6519 | 41 | 7 | 0 |
4234 | 4234 | 2021-06-22 | Yuba | 115 | 6512 | 41 | 23 | 0 |
4292 | 4292 | 2021-06-21 | Yuba | 115 | 6489 | 41 | 4 | 0 |
4350 | 4350 | 2021-06-20 | Yuba | 115 | 6485 | 41 | 0 | 0 |
4408 | 4408 | 2021-06-19 | Yuba | 115 | 6485 | 41 | 0 | 0 |
4466 | 4466 | 2021-06-18 | Yuba | 115 | 6485 | 41 | 21 | 0 |
4524 | 4524 | 2021-06-17 | Yuba | 115 | 6464 | 41 | 0 | 0 |
4582 | 4582 | 2021-06-16 | Yuba | 115 | 6464 | 41 | 0 | 0 |
4640 | 4640 | 2021-06-15 | Yuba | 115 | 6464 | 41 | 3 | 0 |
4698 | 4698 | 2021-06-14 | Yuba | 115 | 6461 | 41 | 13 | 0 |
4756 | 4756 | 2021-06-13 | Yuba | 115 | 6448 | 41 | 0 | 0 |
4814 | 4814 | 2021-06-12 | Yuba | 115 | 6448 | 41 | 0 | 0 |
4872 | 4872 | 2021-06-11 | Yuba | 115 | 6448 | 41 | 5 | 0 |
4930 | 4930 | 2021-06-10 | Yuba | 115 | 6443 | 41 | 5 | 0 |
4988 | 4988 | 2021-06-09 | Yuba | 115 | 6438 | 41 | 12 | 0 |
5046 | 5046 | 2021-06-08 | Yuba | 115 | 6426 | 41 | 3 | 0 |
5104 | 5104 | 2021-06-07 | Yuba | 115 | 6423 | 41 | 18 | 0 |
5162 | 5162 | 2021-06-06 | Yuba | 115 | 6405 | 41 | 0 | 0 |
5220 | 5220 | 2021-06-05 | Yuba | 115 | 6405 | 41 | 0 | 0 |
5278 | 5278 | 2021-06-04 | Yuba | 115 | 6405 | 41 | 1 | 0 |
5336 | 5336 | 2021-06-03 | Yuba | 115 | 6404 | 41 | 3 | 0 |
5394 | 5394 | 2021-06-02 | Yuba | 115 | 6401 | 41 | 12 | 0 |
5452 | 5452 | 2021-06-01 | Yuba | 115 | 6389 | 41 | 18 | 0 |
5510 | 5510 | 2021-05-31 | Yuba | 115 | 6371 | 41 | 0 | 0 |
5568 | 5568 | 2021-05-30 | Yuba | 115 | 6371 | 41 | 0 | 0 |
5626 | 5626 | 2021-05-29 | Yuba | 115 | 6371 | 41 | 0 | 0 |
5684 | 5684 | 2021-05-28 | Yuba | 115 | 6371 | 41 | 9 | 0 |
5742 | 5742 | 2021-05-27 | Yuba | 115 | 6362 | 41 | 11 | 0 |
5800 | 5800 | 2021-05-26 | Yuba | 115 | 6351 | 41 | 7 | 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 );