latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
167 rows where deaths = 25 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
fips 28
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
8 | 8 | 2021-09-02 | Del Norte | 15 | 3012 | 25 | 44 | 2 |
4078 | 4078 | 2021-06-24 | Lassen | 35 | 5808 | 25 | 9 | 0 |
4136 | 4136 | 2021-06-23 | Lassen | 35 | 5799 | 25 | 0 | 0 |
4194 | 4194 | 2021-06-22 | Lassen | 35 | 5799 | 25 | 0 | 1 |
5811 | 5811 | 2021-05-25 | Glenn | 21 | 2341 | 25 | 0 | 0 |
5869 | 5869 | 2021-05-24 | Glenn | 21 | 2341 | 25 | 0 | 0 |
5927 | 5927 | 2021-05-23 | Glenn | 21 | 2341 | 25 | 0 | 0 |
5985 | 5985 | 2021-05-22 | Glenn | 21 | 2341 | 25 | 0 | 0 |
6043 | 6043 | 2021-05-21 | Glenn | 21 | 2341 | 25 | 0 | 0 |
6101 | 6101 | 2021-05-20 | Glenn | 21 | 2341 | 25 | 1 | 0 |
6159 | 6159 | 2021-05-19 | Glenn | 21 | 2340 | 25 | 0 | 0 |
6217 | 6217 | 2021-05-18 | Glenn | 21 | 2340 | 25 | 3 | 0 |
6275 | 6275 | 2021-05-17 | Glenn | 21 | 2337 | 25 | 1 | 0 |
6333 | 6333 | 2021-05-16 | Glenn | 21 | 2336 | 25 | 0 | 0 |
6369 | 6369 | 2021-05-16 | Siskiyou | 93 | 2255 | 25 | 0 | 0 |
6391 | 6391 | 2021-05-15 | Glenn | 21 | 2336 | 25 | 0 | 0 |
6427 | 6427 | 2021-05-15 | Siskiyou | 93 | 2255 | 25 | 0 | 0 |
6449 | 6449 | 2021-05-14 | Glenn | 21 | 2336 | 25 | 4 | 0 |
6485 | 6485 | 2021-05-14 | Siskiyou | 93 | 2255 | 25 | 10 | 1 |
6507 | 6507 | 2021-05-13 | Glenn | 21 | 2332 | 25 | 4 | 0 |
6565 | 6565 | 2021-05-12 | Glenn | 21 | 2328 | 25 | 1 | 0 |
6623 | 6623 | 2021-05-11 | Glenn | 21 | 2327 | 25 | 4 | 0 |
6681 | 6681 | 2021-05-10 | Glenn | 21 | 2323 | 25 | 2 | 0 |
6739 | 6739 | 2021-05-09 | Glenn | 21 | 2321 | 25 | 0 | 0 |
6797 | 6797 | 2021-05-08 | Glenn | 21 | 2321 | 25 | 0 | 0 |
6855 | 6855 | 2021-05-07 | Glenn | 21 | 2321 | 25 | 3 | 0 |
6913 | 6913 | 2021-05-06 | Glenn | 21 | 2318 | 25 | 3 | 0 |
6971 | 6971 | 2021-05-05 | Glenn | 21 | 2315 | 25 | 3 | 0 |
7029 | 7029 | 2021-05-04 | Glenn | 21 | 2312 | 25 | 3 | 0 |
7087 | 7087 | 2021-05-03 | Glenn | 21 | 2309 | 25 | 0 | 0 |
7145 | 7145 | 2021-05-02 | Glenn | 21 | 2309 | 25 | 0 | 0 |
7203 | 7203 | 2021-05-01 | Glenn | 21 | 2309 | 25 | 0 | 0 |
7261 | 7261 | 2021-04-30 | Glenn | 21 | 2309 | 25 | 0 | 0 |
7319 | 7319 | 2021-04-29 | Glenn | 21 | 2309 | 25 | 1 | 0 |
7377 | 7377 | 2021-04-28 | Glenn | 21 | 2308 | 25 | 0 | 0 |
7435 | 7435 | 2021-04-27 | Glenn | 21 | 2308 | 25 | 5 | 0 |
7493 | 7493 | 2021-04-26 | Glenn | 21 | 2303 | 25 | 1 | 0 |
7551 | 7551 | 2021-04-25 | Glenn | 21 | 2302 | 25 | 0 | 0 |
7609 | 7609 | 2021-04-24 | Glenn | 21 | 2302 | 25 | 0 | 0 |
7667 | 7667 | 2021-04-23 | Glenn | 21 | 2302 | 25 | 0 | 0 |
7725 | 7725 | 2021-04-22 | Glenn | 21 | 2302 | 25 | 2 | 0 |
7783 | 7783 | 2021-04-21 | Glenn | 21 | 2300 | 25 | 0 | 0 |
7841 | 7841 | 2021-04-20 | Glenn | 21 | 2300 | 25 | 1 | 0 |
7899 | 7899 | 2021-04-19 | Glenn | 21 | 2299 | 25 | 2 | 0 |
7957 | 7957 | 2021-04-18 | Glenn | 21 | 2297 | 25 | 0 | 0 |
8015 | 8015 | 2021-04-17 | Glenn | 21 | 2297 | 25 | 0 | 0 |
8073 | 8073 | 2021-04-16 | Glenn | 21 | 2297 | 25 | 3 | 0 |
8131 | 8131 | 2021-04-15 | Glenn | 21 | 2294 | 25 | 2 | 0 |
8189 | 8189 | 2021-04-14 | Glenn | 21 | 2292 | 25 | 0 | 0 |
8247 | 8247 | 2021-04-13 | Glenn | 21 | 2292 | 25 | 2 | 0 |
8305 | 8305 | 2021-04-12 | Glenn | 21 | 2290 | 25 | 6 | 0 |
8363 | 8363 | 2021-04-11 | Glenn | 21 | 2284 | 25 | 0 | 0 |
8421 | 8421 | 2021-04-10 | Glenn | 21 | 2284 | 25 | 0 | 0 |
8479 | 8479 | 2021-04-09 | Glenn | 21 | 2284 | 25 | 0 | 0 |
8537 | 8537 | 2021-04-08 | Glenn | 21 | 2284 | 25 | 0 | 0 |
8595 | 8595 | 2021-04-07 | Glenn | 21 | 2284 | 25 | 5 | 0 |
8653 | 8653 | 2021-04-06 | Glenn | 21 | 2279 | 25 | 3 | 0 |
8711 | 8711 | 2021-04-05 | Glenn | 21 | 2276 | 25 | 6 | 0 |
8769 | 8769 | 2021-04-04 | Glenn | 21 | 2270 | 25 | 0 | 0 |
8827 | 8827 | 2021-04-03 | Glenn | 21 | 2270 | 25 | 0 | 0 |
8885 | 8885 | 2021-04-02 | Glenn | 21 | 2270 | 25 | 9 | 0 |
8943 | 8943 | 2021-04-01 | Glenn | 21 | 2261 | 25 | 3 | 0 |
9001 | 9001 | 2021-03-31 | Glenn | 21 | 2258 | 25 | 0 | 0 |
9059 | 9059 | 2021-03-30 | Glenn | 21 | 2258 | 25 | 1 | 0 |
9117 | 9117 | 2021-03-29 | Glenn | 21 | 2257 | 25 | 5 | 0 |
9175 | 9175 | 2021-03-28 | Glenn | 21 | 2252 | 25 | 0 | 0 |
9233 | 9233 | 2021-03-27 | Glenn | 21 | 2252 | 25 | 0 | 0 |
9291 | 9291 | 2021-03-26 | Glenn | 21 | 2252 | 25 | 6 | 1 |
9588 | 9588 | 2021-03-21 | Lassen | 35 | 5634 | 25 | 0 | 0 |
9646 | 9646 | 2021-03-20 | Lassen | 35 | 5634 | 25 | 0 | 1 |
11083 | 11083 | 2021-02-23 | Calaveras | 9 | 1902 | 25 | 1 | 0 |
11141 | 11141 | 2021-02-22 | Calaveras | 9 | 1901 | 25 | 3 | 0 |
11199 | 11199 | 2021-02-21 | Calaveras | 9 | 1898 | 25 | 0 | 0 |
11257 | 11257 | 2021-02-20 | Calaveras | 9 | 1898 | 25 | 0 | 0 |
11315 | 11315 | 2021-02-19 | Calaveras | 9 | 1898 | 25 | 2 | 0 |
11373 | 11373 | 2021-02-18 | Calaveras | 9 | 1896 | 25 | 0 | 0 |
11431 | 11431 | 2021-02-17 | Calaveras | 9 | 1896 | 25 | 60 | 0 |
11489 | 11489 | 2021-02-16 | Calaveras | 9 | 1836 | 25 | 11 | 0 |
11547 | 11547 | 2021-02-15 | Calaveras | 9 | 1825 | 25 | 0 | 0 |
11605 | 11605 | 2021-02-14 | Calaveras | 9 | 1825 | 25 | 0 | 0 |
11663 | 11663 | 2021-02-13 | Calaveras | 9 | 1825 | 25 | 0 | 0 |
11721 | 11721 | 2021-02-12 | Calaveras | 9 | 1825 | 25 | 3 | 0 |
11779 | 11779 | 2021-02-11 | Calaveras | 9 | 1822 | 25 | 4 | 0 |
11837 | 11837 | 2021-02-10 | Calaveras | 9 | 1818 | 25 | 5 | 2 |
12830 | 12830 | 2021-01-24 | Humboldt | 23 | 2494 | 25 | 0 | 0 |
12888 | 12888 | 2021-01-23 | Humboldt | 23 | 2494 | 25 | 0 | 0 |
12946 | 12946 | 2021-01-22 | Humboldt | 23 | 2494 | 25 | 36 | 0 |
13004 | 13004 | 2021-01-21 | Humboldt | 23 | 2458 | 25 | 31 | 0 |
13062 | 13062 | 2021-01-20 | Humboldt | 23 | 2427 | 25 | 34 | 1 |
13688 | 13688 | 2021-01-10 | Yuba | 115 | 4440 | 25 | 0 | 0 |
13746 | 13746 | 2021-01-09 | Yuba | 115 | 4440 | 25 | 57 | 0 |
13804 | 13804 | 2021-01-08 | Yuba | 115 | 4383 | 25 | 0 | 0 |
13821 | 13821 | 2021-01-07 | Lake | 33 | 2055 | 25 | 26 | 0 |
13862 | 13862 | 2021-01-07 | Yuba | 115 | 4383 | 25 | 89 | 1 |
13879 | 13879 | 2021-01-06 | Lake | 33 | 2029 | 25 | 24 | 0 |
13934 | 13934 | 2021-01-05 | Inyo | 27 | 709 | 25 | 34 | 3 |
13937 | 13937 | 2021-01-05 | Lake | 33 | 2005 | 25 | 7 | 1 |
14523 | 14523 | 2020-12-26 | Mendocino | 45 | 2382 | 25 | 68 | 0 |
14581 | 14581 | 2020-12-25 | Mendocino | 45 | 2314 | 25 | 0 | 0 |
14639 | 14639 | 2020-12-24 | Mendocino | 45 | 2314 | 25 | 0 | 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 );