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

564 rows where fips = 23 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

  • 23 · 564 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
12 12 2021-09-02 Humboldt 23 7308 75 139 0
70 70 2021-09-01 Humboldt 23 7169 75 58 0
128 128 2021-08-31 Humboldt 23 7111 75 119 0
186 186 2021-08-30 Humboldt 23 6992 75 118 4
244 244 2021-08-29 Humboldt 23 6874 71 0 0
302 302 2021-08-28 Humboldt 23 6874 71 0 0
360 360 2021-08-27 Humboldt 23 6874 71 19 6
418 418 2021-08-26 Humboldt 23 6855 65 114 0
476 476 2021-08-25 Humboldt 23 6741 65 98 3
534 534 2021-08-24 Humboldt 23 6643 62 114 0
592 592 2021-08-23 Humboldt 23 6529 62 102 1
650 650 2021-08-22 Humboldt 23 6427 61 0 0
708 708 2021-08-21 Humboldt 23 6427 61 0 0
766 766 2021-08-20 Humboldt 23 6427 61 86 2
824 824 2021-08-19 Humboldt 23 6341 59 53 0
882 882 2021-08-18 Humboldt 23 6288 59 36 0
940 940 2021-08-17 Humboldt 23 6252 59 91 0
998 998 2021-08-16 Humboldt 23 6161 59 191 1
1056 1056 2021-08-15 Humboldt 23 5970 58 0 0
1114 1114 2021-08-14 Humboldt 23 5970 58 0 0
1172 1172 2021-08-13 Humboldt 23 5970 58 41 0
1230 1230 2021-08-12 Humboldt 23 5929 58 88 1
1288 1288 2021-08-11 Humboldt 23 5841 57 33 0
1346 1346 2021-08-10 Humboldt 23 5808 57 91 1
1404 1404 2021-08-09 Humboldt 23 5717 56 216 0
1462 1462 2021-08-08 Humboldt 23 5501 56 0 0
1520 1520 2021-08-07 Humboldt 23 5501 56 0 0
1578 1578 2021-08-06 Humboldt 23 5501 56 100 1
1636 1636 2021-08-05 Humboldt 23 5401 55 50 1
1694 1694 2021-08-04 Humboldt 23 5351 54 82 0
1752 1752 2021-08-03 Humboldt 23 5269 54 155 1
1810 1810 2021-08-02 Humboldt 23 5114 53 0 0
1868 1868 2021-08-01 Humboldt 23 5114 53 0 0
1926 1926 2021-07-31 Humboldt 23 5114 53 0 0
1984 1984 2021-07-30 Humboldt 23 5114 53 69 0
2042 2042 2021-07-29 Humboldt 23 5045 53 35 0
2100 2100 2021-07-28 Humboldt 23 5010 53 21 0
2158 2158 2021-07-27 Humboldt 23 4989 53 18 0
2216 2216 2021-07-26 Humboldt 23 4971 53 74 0
2274 2274 2021-07-25 Humboldt 23 4897 53 0 0
2332 2332 2021-07-24 Humboldt 23 4897 53 0 0
2390 2390 2021-07-23 Humboldt 23 4897 53 44 0
2448 2448 2021-07-22 Humboldt 23 4853 53 29 0
2506 2506 2021-07-21 Humboldt 23 4824 53 26 0
2564 2564 2021-07-20 Humboldt 23 4798 53 23 0
2622 2622 2021-07-19 Humboldt 23 4775 53 45 0
2680 2680 2021-07-18 Humboldt 23 4730 53 0 0
2738 2738 2021-07-17 Humboldt 23 4730 53 0 0
2796 2796 2021-07-16 Humboldt 23 4730 53 19 0
2854 2854 2021-07-15 Humboldt 23 4711 53 8 0
2912 2912 2021-07-14 Humboldt 23 4703 53 12 1
2970 2970 2021-07-13 Humboldt 23 4691 52 16 1
3028 3028 2021-07-12 Humboldt 23 4675 51 28 0
3086 3086 2021-07-11 Humboldt 23 4647 51 0 0
3144 3144 2021-07-10 Humboldt 23 4647 51 0 0
3202 3202 2021-07-09 Humboldt 23 4647 51 26 0
3260 3260 2021-07-08 Humboldt 23 4621 51 7 0
3318 3318 2021-07-07 Humboldt 23 4614 51 6 0
3376 3376 2021-07-06 Humboldt 23 4608 51 22 1
3434 3434 2021-07-05 Humboldt 23 4586 50 0 0
3492 3492 2021-07-04 Humboldt 23 4586 50 0 0
3550 3550 2021-07-03 Humboldt 23 4586 50 0 0
3608 3608 2021-07-02 Humboldt 23 4586 50 4 0
3666 3666 2021-07-01 Humboldt 23 4582 50 13 0
3724 3724 2021-06-30 Humboldt 23 4569 50 9 0
3782 3782 2021-06-29 Humboldt 23 4560 50 6 0
3840 3840 2021-06-28 Humboldt 23 4554 50 21 0
3898 3898 2021-06-27 Humboldt 23 4533 50 0 0
3956 3956 2021-06-26 Humboldt 23 4533 50 0 0
4014 4014 2021-06-25 Humboldt 23 4533 50 5 1
4072 4072 2021-06-24 Humboldt 23 4528 49 14 0
4130 4130 2021-06-23 Humboldt 23 4514 49 6 0
4188 4188 2021-06-22 Humboldt 23 4508 49 9 1
4246 4246 2021-06-21 Humboldt 23 4499 48 37 0
4304 4304 2021-06-20 Humboldt 23 4462 48 0 0
4362 4362 2021-06-19 Humboldt 23 4462 48 0 0
4420 4420 2021-06-18 Humboldt 23 4462 48 0 0
4478 4478 2021-06-17 Humboldt 23 4462 48 11 0
4536 4536 2021-06-16 Humboldt 23 4451 48 9 1
4594 4594 2021-06-15 Humboldt 23 4442 47 8 1
4652 4652 2021-06-14 Humboldt 23 4434 46 19 0
4710 4710 2021-06-13 Humboldt 23 4415 46 0 0
4768 4768 2021-06-12 Humboldt 23 4415 46 0 0
4826 4826 2021-06-11 Humboldt 23 4415 46 7 0
4884 4884 2021-06-10 Humboldt 23 4408 46 3 0
4942 4942 2021-06-09 Humboldt 23 4405 46 15 0
5000 5000 2021-06-08 Humboldt 23 4390 46 8 0
5058 5058 2021-06-07 Humboldt 23 4382 46 27 1
5116 5116 2021-06-06 Humboldt 23 4355 45 0 0
5174 5174 2021-06-05 Humboldt 23 4355 45 0 0
5232 5232 2021-06-04 Humboldt 23 4355 45 16 1
5290 5290 2021-06-03 Humboldt 23 4339 44 14 1
5348 5348 2021-06-02 Humboldt 23 4325 43 2 0
5406 5406 2021-06-01 Humboldt 23 4323 43 38 0
5464 5464 2021-05-31 Humboldt 23 4285 43 0 0
5522 5522 2021-05-30 Humboldt 23 4285 43 0 0
5580 5580 2021-05-29 Humboldt 23 4285 43 0 0
5638 5638 2021-05-28 Humboldt 23 4285 43 6 0
5696 5696 2021-05-27 Humboldt 23 4279 43 13 0
5754 5754 2021-05-26 Humboldt 23 4266 43 13 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
);