latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
930 rows where deaths = 2 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
fips >30
county >30
- Mariposa 128
- San Benito 116
- Mono 92
- Santa Cruz 72
- Sutter 71
- Madera 54
- Tuolumne 44
- Del Norte 43
- Napa 38
- El Dorado 35
- Sonoma 23
- Calaveras 21
- Santa Clara 18
- Lake 14
- Solano 14
- Trinity 13
- Kings 11
- Santa Barbara 11
- Humboldt 9
- Monterey 8
- Butte 7
- Colusa 7
- Placer 7
- San Joaquin 7
- San Luis Obispo 7
- Siskiyou 7
- Kern 6
- Nevada 6
- Plumas 6
- Amador 4
- …
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
12768 | 12768 | 2021-01-25 | Del Norte | 15 | 874 | 2 | 1 | 0 |
12826 | 12826 | 2021-01-24 | Del Norte | 15 | 873 | 2 | 0 | 0 |
12884 | 12884 | 2021-01-23 | Del Norte | 15 | 873 | 2 | 3 | 0 |
12942 | 12942 | 2021-01-22 | Del Norte | 15 | 870 | 2 | 1 | 0 |
13000 | 13000 | 2021-01-21 | Del Norte | 15 | 869 | 2 | 2 | 0 |
13058 | 13058 | 2021-01-20 | Del Norte | 15 | 867 | 2 | 1 | 0 |
13116 | 13116 | 2021-01-19 | Del Norte | 15 | 866 | 2 | 5 | 0 |
13174 | 13174 | 2021-01-18 | Del Norte | 15 | 861 | 2 | 4 | 0 |
13232 | 13232 | 2021-01-17 | Del Norte | 15 | 857 | 2 | 4 | 0 |
13290 | 13290 | 2021-01-16 | Del Norte | 15 | 853 | 2 | 6 | 0 |
13348 | 13348 | 2021-01-15 | Del Norte | 15 | 847 | 2 | 3 | 0 |
13406 | 13406 | 2021-01-14 | Del Norte | 15 | 844 | 2 | 17 | 0 |
13464 | 13464 | 2021-01-13 | Del Norte | 15 | 827 | 2 | 1 | 0 |
13522 | 13522 | 2021-01-12 | Del Norte | 15 | 826 | 2 | 3 | 0 |
13580 | 13580 | 2021-01-11 | Del Norte | 15 | 823 | 2 | 7 | 0 |
13638 | 13638 | 2021-01-10 | Del Norte | 15 | 816 | 2 | 0 | 0 |
13696 | 13696 | 2021-01-09 | Del Norte | 15 | 816 | 2 | 9 | 0 |
13754 | 13754 | 2021-01-08 | Del Norte | 15 | 807 | 2 | 8 | 0 |
13812 | 13812 | 2021-01-07 | Del Norte | 15 | 799 | 2 | 8 | 0 |
13870 | 13870 | 2021-01-06 | Del Norte | 15 | 791 | 2 | 8 | 0 |
13928 | 13928 | 2021-01-05 | Del Norte | 15 | 783 | 2 | 6 | 0 |
13986 | 13986 | 2021-01-04 | Del Norte | 15 | 777 | 2 | 1 | 0 |
14044 | 14044 | 2021-01-03 | Del Norte | 15 | 776 | 2 | 7 | 0 |
14102 | 14102 | 2021-01-02 | Del Norte | 15 | 769 | 2 | 0 | 0 |
14160 | 14160 | 2021-01-01 | Del Norte | 15 | 769 | 2 | 9 | 0 |
14218 | 14218 | 2020-12-31 | Del Norte | 15 | 760 | 2 | 6 | 0 |
14276 | 14276 | 2020-12-30 | Del Norte | 15 | 754 | 2 | 21 | 0 |
14334 | 14334 | 2020-12-29 | Del Norte | 15 | 733 | 2 | 4 | 0 |
14392 | 14392 | 2020-12-28 | Del Norte | 15 | 729 | 2 | 34 | 0 |
14450 | 14450 | 2020-12-27 | Del Norte | 15 | 695 | 2 | 0 | 0 |
14474 | 14474 | 2020-12-27 | Plumas | 63 | 455 | 2 | 0 | 0 |
14495 | 14495 | 2020-12-27 | Trinity | 105 | 265 | 2 | 0 | 0 |
14508 | 14508 | 2020-12-26 | Del Norte | 15 | 695 | 2 | 0 | 0 |
14532 | 14532 | 2020-12-26 | Plumas | 63 | 455 | 2 | 12 | 0 |
14553 | 14553 | 2020-12-26 | Trinity | 105 | 265 | 2 | 0 | 0 |
14566 | 14566 | 2020-12-25 | Del Norte | 15 | 695 | 2 | 0 | 0 |
14590 | 14590 | 2020-12-25 | Plumas | 63 | 443 | 2 | 0 | 0 |
14611 | 14611 | 2020-12-25 | Trinity | 105 | 265 | 2 | 0 | 0 |
14624 | 14624 | 2020-12-24 | Del Norte | 15 | 695 | 2 | 15 | 0 |
14648 | 14648 | 2020-12-24 | Plumas | 63 | 443 | 2 | 0 | 0 |
14669 | 14669 | 2020-12-24 | Trinity | 105 | 265 | 2 | 0 | 0 |
14682 | 14682 | 2020-12-23 | Del Norte | 15 | 680 | 2 | 1 | 0 |
14706 | 14706 | 2020-12-23 | Plumas | 63 | 443 | 2 | 8 | 0 |
14727 | 14727 | 2020-12-23 | Trinity | 105 | 265 | 2 | 3 | 0 |
14740 | 14740 | 2020-12-22 | Del Norte | 15 | 679 | 2 | 6 | 0 |
14764 | 14764 | 2020-12-22 | Plumas | 63 | 435 | 2 | 11 | 1 |
14785 | 14785 | 2020-12-22 | Trinity | 105 | 262 | 2 | 0 | 0 |
14798 | 14798 | 2020-12-21 | Del Norte | 15 | 673 | 2 | 30 | 0 |
14843 | 14843 | 2020-12-21 | Trinity | 105 | 262 | 2 | 11 | 0 |
14856 | 14856 | 2020-12-20 | Del Norte | 15 | 643 | 2 | 0 | 0 |
14901 | 14901 | 2020-12-20 | Trinity | 105 | 251 | 2 | 0 | 0 |
14914 | 14914 | 2020-12-19 | Del Norte | 15 | 643 | 2 | 0 | 0 |
14959 | 14959 | 2020-12-19 | Trinity | 105 | 251 | 2 | 0 | 0 |
14972 | 14972 | 2020-12-18 | Del Norte | 15 | 643 | 2 | 38 | 0 |
15017 | 15017 | 2020-12-18 | Trinity | 105 | 251 | 2 | 6 | 0 |
15030 | 15030 | 2020-12-17 | Del Norte | 15 | 605 | 2 | 18 | 0 |
15075 | 15075 | 2020-12-17 | Trinity | 105 | 245 | 2 | 5 | 0 |
15088 | 15088 | 2020-12-16 | Del Norte | 15 | 587 | 2 | 5 | 0 |
15133 | 15133 | 2020-12-16 | Trinity | 105 | 240 | 2 | 5 | 0 |
15146 | 15146 | 2020-12-15 | Del Norte | 15 | 582 | 2 | 11 | 0 |
15191 | 15191 | 2020-12-15 | Trinity | 105 | 235 | 2 | 4 | 1 |
15204 | 15204 | 2020-12-14 | Del Norte | 15 | 571 | 2 | 35 | 1 |
16030 | 16030 | 2020-11-30 | Mariposa | 43 | 139 | 2 | 8 | 0 |
16088 | 16088 | 2020-11-29 | Mariposa | 43 | 131 | 2 | 1 | 0 |
16113 | 16113 | 2020-11-29 | Siskiyou | 93 | 624 | 2 | 0 | 0 |
16146 | 16146 | 2020-11-28 | Mariposa | 43 | 130 | 2 | 2 | 0 |
16171 | 16171 | 2020-11-28 | Siskiyou | 93 | 624 | 2 | 0 | 0 |
16204 | 16204 | 2020-11-27 | Mariposa | 43 | 128 | 2 | 2 | 0 |
16229 | 16229 | 2020-11-27 | Siskiyou | 93 | 624 | 2 | 0 | 0 |
16262 | 16262 | 2020-11-26 | Mariposa | 43 | 126 | 2 | 2 | 0 |
16287 | 16287 | 2020-11-26 | Siskiyou | 93 | 624 | 2 | 0 | 0 |
16320 | 16320 | 2020-11-25 | Mariposa | 43 | 124 | 2 | 4 | 0 |
16345 | 16345 | 2020-11-25 | Siskiyou | 93 | 624 | 2 | 42 | 0 |
16378 | 16378 | 2020-11-24 | Mariposa | 43 | 120 | 2 | 8 | 0 |
16403 | 16403 | 2020-11-24 | Siskiyou | 93 | 582 | 2 | 17 | 0 |
16436 | 16436 | 2020-11-23 | Mariposa | 43 | 112 | 2 | 8 | 0 |
16461 | 16461 | 2020-11-23 | Siskiyou | 93 | 565 | 2 | 70 | 1 |
16494 | 16494 | 2020-11-22 | Mariposa | 43 | 104 | 2 | 3 | 0 |
16552 | 16552 | 2020-11-21 | Mariposa | 43 | 101 | 2 | 7 | 0 |
16610 | 16610 | 2020-11-20 | Mariposa | 43 | 94 | 2 | 1 | 0 |
16668 | 16668 | 2020-11-19 | Mariposa | 43 | 93 | 2 | 0 | 0 |
16726 | 16726 | 2020-11-18 | Mariposa | 43 | 93 | 2 | 1 | 0 |
16730 | 16730 | 2020-11-18 | Mono | 51 | 493 | 2 | 0 | 0 |
16780 | 16780 | 2020-11-17 | Lassen | 35 | 1177 | 2 | 42 | 1 |
16784 | 16784 | 2020-11-17 | Mariposa | 43 | 92 | 2 | 1 | 0 |
16788 | 16788 | 2020-11-17 | Mono | 51 | 493 | 2 | 0 | 0 |
16842 | 16842 | 2020-11-16 | Mariposa | 43 | 91 | 2 | 0 | 0 |
16846 | 16846 | 2020-11-16 | Mono | 51 | 493 | 2 | 9 | 0 |
16900 | 16900 | 2020-11-15 | Mariposa | 43 | 91 | 2 | 0 | 0 |
16904 | 16904 | 2020-11-15 | Mono | 51 | 484 | 2 | 4 | 0 |
16958 | 16958 | 2020-11-14 | Mariposa | 43 | 91 | 2 | 2 | 0 |
16962 | 16962 | 2020-11-14 | Mono | 51 | 480 | 2 | 0 | 0 |
17016 | 17016 | 2020-11-13 | Mariposa | 43 | 89 | 2 | 0 | 0 |
17020 | 17020 | 2020-11-13 | Mono | 51 | 480 | 2 | 8 | 0 |
17074 | 17074 | 2020-11-12 | Mariposa | 43 | 89 | 2 | 1 | 0 |
17078 | 17078 | 2020-11-12 | Mono | 51 | 472 | 2 | 2 | 0 |
17132 | 17132 | 2020-11-11 | Mariposa | 43 | 88 | 2 | 0 | 0 |
17136 | 17136 | 2020-11-11 | Mono | 51 | 470 | 2 | 3 | 0 |
17190 | 17190 | 2020-11-10 | Mariposa | 43 | 88 | 2 | 0 | 0 |
17194 | 17194 | 2020-11-10 | Mono | 51 | 467 | 2 | 5 | 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 );