latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
101 rows where deaths = 4 and fips = 23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
20718 | 20718 | 2020-09-10 | Humboldt | 23 | 442 | 4 | 8 | 0 |
20776 | 20776 | 2020-09-09 | Humboldt | 23 | 434 | 4 | 0 | 0 |
20834 | 20834 | 2020-09-08 | Humboldt | 23 | 434 | 4 | 25 | 0 |
20892 | 20892 | 2020-09-07 | Humboldt | 23 | 409 | 4 | 0 | 0 |
20950 | 20950 | 2020-09-06 | Humboldt | 23 | 409 | 4 | 0 | 0 |
21008 | 21008 | 2020-09-05 | Humboldt | 23 | 409 | 4 | 0 | 0 |
21066 | 21066 | 2020-09-04 | Humboldt | 23 | 409 | 4 | 6 | 0 |
21124 | 21124 | 2020-09-03 | Humboldt | 23 | 403 | 4 | 6 | 0 |
21182 | 21182 | 2020-09-02 | Humboldt | 23 | 397 | 4 | 4 | 0 |
21240 | 21240 | 2020-09-01 | Humboldt | 23 | 393 | 4 | 5 | 0 |
21298 | 21298 | 2020-08-31 | Humboldt | 23 | 388 | 4 | 20 | 0 |
21356 | 21356 | 2020-08-30 | Humboldt | 23 | 368 | 4 | 0 | 0 |
21414 | 21414 | 2020-08-29 | Humboldt | 23 | 368 | 4 | 0 | 0 |
21472 | 21472 | 2020-08-28 | Humboldt | 23 | 368 | 4 | 4 | 0 |
21530 | 21530 | 2020-08-27 | Humboldt | 23 | 364 | 4 | 3 | 0 |
21588 | 21588 | 2020-08-26 | Humboldt | 23 | 361 | 4 | 1 | 0 |
21646 | 21646 | 2020-08-25 | Humboldt | 23 | 360 | 4 | 1 | 0 |
21704 | 21704 | 2020-08-24 | Humboldt | 23 | 359 | 4 | 14 | 0 |
21762 | 21762 | 2020-08-23 | Humboldt | 23 | 345 | 4 | 0 | 0 |
21820 | 21820 | 2020-08-22 | Humboldt | 23 | 345 | 4 | 0 | 0 |
21878 | 21878 | 2020-08-21 | Humboldt | 23 | 345 | 4 | 3 | 0 |
21936 | 21936 | 2020-08-20 | Humboldt | 23 | 342 | 4 | 9 | 0 |
21994 | 21994 | 2020-08-19 | Humboldt | 23 | 333 | 4 | 8 | 0 |
22052 | 22052 | 2020-08-18 | Humboldt | 23 | 325 | 4 | 5 | 0 |
22110 | 22110 | 2020-08-17 | Humboldt | 23 | 320 | 4 | 11 | 0 |
22168 | 22168 | 2020-08-16 | Humboldt | 23 | 309 | 4 | 0 | 0 |
22226 | 22226 | 2020-08-15 | Humboldt | 23 | 309 | 4 | 0 | 0 |
22284 | 22284 | 2020-08-14 | Humboldt | 23 | 309 | 4 | 7 | 0 |
22342 | 22342 | 2020-08-13 | Humboldt | 23 | 302 | 4 | 3 | 0 |
22400 | 22400 | 2020-08-12 | Humboldt | 23 | 299 | 4 | 6 | 0 |
22458 | 22458 | 2020-08-11 | Humboldt | 23 | 293 | 4 | 7 | 0 |
22516 | 22516 | 2020-08-10 | Humboldt | 23 | 286 | 4 | 4 | 0 |
22574 | 22574 | 2020-08-09 | Humboldt | 23 | 282 | 4 | 0 | 0 |
22632 | 22632 | 2020-08-08 | Humboldt | 23 | 282 | 4 | 0 | 0 |
22690 | 22690 | 2020-08-07 | Humboldt | 23 | 282 | 4 | 2 | 0 |
22748 | 22748 | 2020-08-06 | Humboldt | 23 | 280 | 4 | 25 | 0 |
22806 | 22806 | 2020-08-05 | Humboldt | 23 | 255 | 4 | 10 | 0 |
22864 | 22864 | 2020-08-04 | Humboldt | 23 | 245 | 4 | 9 | 0 |
22922 | 22922 | 2020-08-03 | Humboldt | 23 | 236 | 4 | 3 | 0 |
22980 | 22980 | 2020-08-02 | Humboldt | 23 | 233 | 4 | 0 | 0 |
23038 | 23038 | 2020-08-01 | Humboldt | 23 | 233 | 4 | 0 | 0 |
23096 | 23096 | 2020-07-31 | Humboldt | 23 | 233 | 4 | 2 | 0 |
23154 | 23154 | 2020-07-30 | Humboldt | 23 | 231 | 4 | 3 | 0 |
23212 | 23212 | 2020-07-29 | Humboldt | 23 | 228 | 4 | 7 | 0 |
23270 | 23270 | 2020-07-28 | Humboldt | 23 | 221 | 4 | 4 | 0 |
23328 | 23328 | 2020-07-27 | Humboldt | 23 | 217 | 4 | 12 | 0 |
23386 | 23386 | 2020-07-26 | Humboldt | 23 | 205 | 4 | 0 | 0 |
23444 | 23444 | 2020-07-25 | Humboldt | 23 | 205 | 4 | 0 | 0 |
23502 | 23502 | 2020-07-24 | Humboldt | 23 | 205 | 4 | 2 | 0 |
23560 | 23560 | 2020-07-23 | Humboldt | 23 | 203 | 4 | 3 | 0 |
23618 | 23618 | 2020-07-22 | Humboldt | 23 | 200 | 4 | 5 | 0 |
23676 | 23676 | 2020-07-21 | Humboldt | 23 | 195 | 4 | 6 | 0 |
23734 | 23734 | 2020-07-20 | Humboldt | 23 | 189 | 4 | 8 | 0 |
23792 | 23792 | 2020-07-19 | Humboldt | 23 | 181 | 4 | 0 | 0 |
23850 | 23850 | 2020-07-18 | Humboldt | 23 | 181 | 4 | 0 | 0 |
23908 | 23908 | 2020-07-17 | Humboldt | 23 | 181 | 4 | 3 | 0 |
23966 | 23966 | 2020-07-16 | Humboldt | 23 | 178 | 4 | 3 | 0 |
24024 | 24024 | 2020-07-15 | Humboldt | 23 | 175 | 4 | 8 | 0 |
24082 | 24082 | 2020-07-14 | Humboldt | 23 | 167 | 4 | 2 | 0 |
24140 | 24140 | 2020-07-13 | Humboldt | 23 | 165 | 4 | 0 | 0 |
24198 | 24198 | 2020-07-12 | Humboldt | 23 | 165 | 4 | 0 | 0 |
24256 | 24256 | 2020-07-11 | Humboldt | 23 | 165 | 4 | 0 | 0 |
24314 | 24314 | 2020-07-10 | Humboldt | 23 | 165 | 4 | 4 | 0 |
24372 | 24372 | 2020-07-09 | Humboldt | 23 | 161 | 4 | 4 | 0 |
24430 | 24430 | 2020-07-08 | Humboldt | 23 | 157 | 4 | 3 | 0 |
24488 | 24488 | 2020-07-07 | Humboldt | 23 | 154 | 4 | 5 | 0 |
24546 | 24546 | 2020-07-06 | Humboldt | 23 | 149 | 4 | 5 | 0 |
24604 | 24604 | 2020-07-05 | Humboldt | 23 | 144 | 4 | 0 | 0 |
24662 | 24662 | 2020-07-04 | Humboldt | 23 | 144 | 4 | 0 | 0 |
24720 | 24720 | 2020-07-03 | Humboldt | 23 | 144 | 4 | 6 | 0 |
24778 | 24778 | 2020-07-02 | Humboldt | 23 | 138 | 4 | 2 | 0 |
24836 | 24836 | 2020-07-01 | Humboldt | 23 | 136 | 4 | 3 | 0 |
24894 | 24894 | 2020-06-30 | Humboldt | 23 | 133 | 4 | 0 | 0 |
24952 | 24952 | 2020-06-29 | Humboldt | 23 | 133 | 4 | 4 | 0 |
25010 | 25010 | 2020-06-28 | Humboldt | 23 | 129 | 4 | 0 | 0 |
25068 | 25068 | 2020-06-27 | Humboldt | 23 | 129 | 4 | 0 | 0 |
25126 | 25126 | 2020-06-26 | Humboldt | 23 | 129 | 4 | 2 | 0 |
25184 | 25184 | 2020-06-25 | Humboldt | 23 | 127 | 4 | 5 | 0 |
25242 | 25242 | 2020-06-24 | Humboldt | 23 | 122 | 4 | 9 | 0 |
25300 | 25300 | 2020-06-23 | Humboldt | 23 | 113 | 4 | 1 | 0 |
25358 | 25358 | 2020-06-22 | Humboldt | 23 | 112 | 4 | 2 | 0 |
25416 | 25416 | 2020-06-21 | Humboldt | 23 | 110 | 4 | 0 | 0 |
25474 | 25474 | 2020-06-20 | Humboldt | 23 | 110 | 4 | 0 | 0 |
25532 | 25532 | 2020-06-19 | Humboldt | 23 | 110 | 4 | 2 | 0 |
25590 | 25590 | 2020-06-18 | Humboldt | 23 | 108 | 4 | 0 | 0 |
25648 | 25648 | 2020-06-17 | Humboldt | 23 | 108 | 4 | 1 | 0 |
25706 | 25706 | 2020-06-16 | Humboldt | 23 | 107 | 4 | 1 | 0 |
25764 | 25764 | 2020-06-15 | Humboldt | 23 | 106 | 4 | 0 | 0 |
25822 | 25822 | 2020-06-14 | Humboldt | 23 | 106 | 4 | 0 | 0 |
25880 | 25880 | 2020-06-13 | Humboldt | 23 | 106 | 4 | 0 | 0 |
25938 | 25938 | 2020-06-12 | Humboldt | 23 | 106 | 4 | 1 | 0 |
25996 | 25996 | 2020-06-11 | Humboldt | 23 | 105 | 4 | 0 | 0 |
26054 | 26054 | 2020-06-10 | Humboldt | 23 | 105 | 4 | 0 | 0 |
26112 | 26112 | 2020-06-09 | Humboldt | 23 | 105 | 4 | 0 | 0 |
26170 | 26170 | 2020-06-08 | Humboldt | 23 | 105 | 4 | 1 | 0 |
26228 | 26228 | 2020-06-07 | Humboldt | 23 | 104 | 4 | 0 | 0 |
26286 | 26286 | 2020-06-06 | Humboldt | 23 | 104 | 4 | 0 | 0 |
26344 | 26344 | 2020-06-05 | Humboldt | 23 | 104 | 4 | 0 | 0 |
26402 | 26402 | 2020-06-04 | Humboldt | 23 | 104 | 4 | 0 | 0 |
26460 | 26460 | 2020-06-03 | Humboldt | 23 | 104 | 4 | 1 | 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 );