latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
175 rows where deaths = 40 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
fips 27
county 27
- Siskiyou 55
- Yuba 55
- Lake 7
- San Francisco 7
- Tuolumne 7
- Mendocino 6
- Tulare 6
- Amador 3
- Santa Cruz 3
- Solano 3
- Ventura 3
- Butte 2
- Humboldt 2
- Kings 2
- Tehama 2
- Contra Costa 1
- Fresno 1
- Kern 1
- Madera 1
- Marin 1
- Monterey 1
- Napa 1
- Placer 1
- San Bernardino 1
- San Diego 1
- San Joaquin 1
- Santa Clara 1
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
221 | 221 | 2021-08-30 | Siskiyou | 93 | 3203 | 40 | 0 | 0 |
279 | 279 | 2021-08-29 | Siskiyou | 93 | 3203 | 40 | 0 | 0 |
337 | 337 | 2021-08-28 | Siskiyou | 93 | 3203 | 40 | 0 | 0 |
395 | 395 | 2021-08-27 | Siskiyou | 93 | 3203 | 40 | 44 | 0 |
453 | 453 | 2021-08-26 | Siskiyou | 93 | 3159 | 40 | 52 | 0 |
511 | 511 | 2021-08-25 | Siskiyou | 93 | 3107 | 40 | 48 | 0 |
569 | 569 | 2021-08-24 | Siskiyou | 93 | 3059 | 40 | 45 | 0 |
627 | 627 | 2021-08-23 | Siskiyou | 93 | 3014 | 40 | 70 | 0 |
685 | 685 | 2021-08-22 | Siskiyou | 93 | 2944 | 40 | 0 | 0 |
743 | 743 | 2021-08-21 | Siskiyou | 93 | 2944 | 40 | 0 | 0 |
801 | 801 | 2021-08-20 | Siskiyou | 93 | 2944 | 40 | 27 | 0 |
859 | 859 | 2021-08-19 | Siskiyou | 93 | 2917 | 40 | 18 | 0 |
917 | 917 | 2021-08-18 | Siskiyou | 93 | 2899 | 40 | 23 | 0 |
975 | 975 | 2021-08-17 | Siskiyou | 93 | 2876 | 40 | 54 | 0 |
1033 | 1033 | 2021-08-16 | Siskiyou | 93 | 2822 | 40 | 36 | 0 |
1091 | 1091 | 2021-08-15 | Siskiyou | 93 | 2786 | 40 | 0 | 0 |
1149 | 1149 | 2021-08-14 | Siskiyou | 93 | 2786 | 40 | 0 | 0 |
1207 | 1207 | 2021-08-13 | Siskiyou | 93 | 2786 | 40 | 31 | 0 |
1265 | 1265 | 2021-08-12 | Siskiyou | 93 | 2755 | 40 | 20 | 0 |
1323 | 1323 | 2021-08-11 | Siskiyou | 93 | 2735 | 40 | 27 | 0 |
1381 | 1381 | 2021-08-10 | Siskiyou | 93 | 2708 | 40 | 30 | 0 |
1439 | 1439 | 2021-08-09 | Siskiyou | 93 | 2678 | 40 | 44 | 0 |
1497 | 1497 | 2021-08-08 | Siskiyou | 93 | 2634 | 40 | 0 | 0 |
1555 | 1555 | 2021-08-07 | Siskiyou | 93 | 2634 | 40 | 0 | 0 |
1613 | 1613 | 2021-08-06 | Siskiyou | 93 | 2634 | 40 | 12 | 0 |
1671 | 1671 | 2021-08-05 | Siskiyou | 93 | 2622 | 40 | 17 | 0 |
1729 | 1729 | 2021-08-04 | Siskiyou | 93 | 2605 | 40 | 9 | 0 |
1787 | 1787 | 2021-08-03 | Siskiyou | 93 | 2596 | 40 | 16 | 0 |
1845 | 1845 | 2021-08-02 | Siskiyou | 93 | 2580 | 40 | 14 | 0 |
1903 | 1903 | 2021-08-01 | Siskiyou | 93 | 2566 | 40 | 0 | 0 |
1961 | 1961 | 2021-07-31 | Siskiyou | 93 | 2566 | 40 | 0 | 0 |
2019 | 2019 | 2021-07-30 | Siskiyou | 93 | 2566 | 40 | 5 | 0 |
2077 | 2077 | 2021-07-29 | Siskiyou | 93 | 2561 | 40 | 7 | 0 |
2135 | 2135 | 2021-07-28 | Siskiyou | 93 | 2554 | 40 | 6 | 0 |
2193 | 2193 | 2021-07-27 | Siskiyou | 93 | 2548 | 40 | 10 | 0 |
2251 | 2251 | 2021-07-26 | Siskiyou | 93 | 2538 | 40 | 1 | 0 |
2309 | 2309 | 2021-07-25 | Siskiyou | 93 | 2537 | 40 | 0 | 0 |
2367 | 2367 | 2021-07-24 | Siskiyou | 93 | 2537 | 40 | 0 | 0 |
2425 | 2425 | 2021-07-23 | Siskiyou | 93 | 2537 | 40 | 10 | 0 |
2483 | 2483 | 2021-07-22 | Siskiyou | 93 | 2527 | 40 | 18 | 0 |
2541 | 2541 | 2021-07-21 | Siskiyou | 93 | 2509 | 40 | 8 | 0 |
2599 | 2599 | 2021-07-20 | Siskiyou | 93 | 2501 | 40 | 10 | 0 |
2657 | 2657 | 2021-07-19 | Siskiyou | 93 | 2491 | 40 | 13 | 0 |
2715 | 2715 | 2021-07-18 | Siskiyou | 93 | 2478 | 40 | 0 | 0 |
2773 | 2773 | 2021-07-17 | Siskiyou | 93 | 2478 | 40 | 0 | 0 |
2831 | 2831 | 2021-07-16 | Siskiyou | 93 | 2478 | 40 | 6 | 0 |
2889 | 2889 | 2021-07-15 | Siskiyou | 93 | 2472 | 40 | 6 | 0 |
2947 | 2947 | 2021-07-14 | Siskiyou | 93 | 2466 | 40 | 2 | 0 |
3005 | 3005 | 2021-07-13 | Siskiyou | 93 | 2464 | 40 | 11 | 0 |
3063 | 3063 | 2021-07-12 | Siskiyou | 93 | 2453 | 40 | 11 | 0 |
3121 | 3121 | 2021-07-11 | Siskiyou | 93 | 2442 | 40 | 0 | 0 |
3179 | 3179 | 2021-07-10 | Siskiyou | 93 | 2442 | 40 | 0 | 0 |
3237 | 3237 | 2021-07-09 | Siskiyou | 93 | 2442 | 40 | 9 | 0 |
3295 | 3295 | 2021-07-08 | Siskiyou | 93 | 2433 | 40 | 10 | 0 |
3353 | 3353 | 2021-07-07 | Siskiyou | 93 | 2423 | 40 | 8 | 1 |
6624 | 6624 | 2021-05-11 | Humboldt | 23 | 3984 | 40 | 4 | 0 |
6682 | 6682 | 2021-05-10 | Humboldt | 23 | 3980 | 40 | 45 | 1 |
7076 | 7076 | 2021-05-04 | Yuba | 115 | 6209 | 40 | 6 | 0 |
7134 | 7134 | 2021-05-03 | Yuba | 115 | 6203 | 40 | 18 | 0 |
7192 | 7192 | 2021-05-02 | Yuba | 115 | 6185 | 40 | 0 | 0 |
7250 | 7250 | 2021-05-01 | Yuba | 115 | 6185 | 40 | 0 | 0 |
7308 | 7308 | 2021-04-30 | Yuba | 115 | 6185 | 40 | 5 | 0 |
7366 | 7366 | 2021-04-29 | Yuba | 115 | 6180 | 40 | 8 | 0 |
7424 | 7424 | 2021-04-28 | Yuba | 115 | 6172 | 40 | 7 | 0 |
7482 | 7482 | 2021-04-27 | Yuba | 115 | 6165 | 40 | 0 | 0 |
7540 | 7540 | 2021-04-26 | Yuba | 115 | 6165 | 40 | 23 | 0 |
7598 | 7598 | 2021-04-25 | Yuba | 115 | 6142 | 40 | 0 | 0 |
7656 | 7656 | 2021-04-24 | Yuba | 115 | 6142 | 40 | 0 | 0 |
7714 | 7714 | 2021-04-23 | Yuba | 115 | 6142 | 40 | 4 | 0 |
7772 | 7772 | 2021-04-22 | Yuba | 115 | 6138 | 40 | 2 | 0 |
7830 | 7830 | 2021-04-21 | Yuba | 115 | 6136 | 40 | 9 | 0 |
7888 | 7888 | 2021-04-20 | Yuba | 115 | 6127 | 40 | 17 | 0 |
7946 | 7946 | 2021-04-19 | Yuba | 115 | 6110 | 40 | 12 | 0 |
8004 | 8004 | 2021-04-18 | Yuba | 115 | 6098 | 40 | 0 | 0 |
8062 | 8062 | 2021-04-17 | Yuba | 115 | 6098 | 40 | 0 | 0 |
8120 | 8120 | 2021-04-16 | Yuba | 115 | 6098 | 40 | 5 | 0 |
8178 | 8178 | 2021-04-15 | Yuba | 115 | 6093 | 40 | 9 | 0 |
8236 | 8236 | 2021-04-14 | Yuba | 115 | 6084 | 40 | 1 | 0 |
8294 | 8294 | 2021-04-13 | Yuba | 115 | 6083 | 40 | 10 | 0 |
8352 | 8352 | 2021-04-12 | Yuba | 115 | 6073 | 40 | 9 | 0 |
8410 | 8410 | 2021-04-11 | Yuba | 115 | 6064 | 40 | 0 | 0 |
8468 | 8468 | 2021-04-10 | Yuba | 115 | 6064 | 40 | 0 | 0 |
8526 | 8526 | 2021-04-09 | Yuba | 115 | 6064 | 40 | 3 | 0 |
8584 | 8584 | 2021-04-08 | Yuba | 115 | 6061 | 40 | 10 | 0 |
8642 | 8642 | 2021-04-07 | Yuba | 115 | 6051 | 40 | 5 | 0 |
8700 | 8700 | 2021-04-06 | Yuba | 115 | 6046 | 40 | 5 | 0 |
8758 | 8758 | 2021-04-05 | Yuba | 115 | 6041 | 40 | 20 | 0 |
8816 | 8816 | 2021-04-04 | Yuba | 115 | 6021 | 40 | 0 | 0 |
8874 | 8874 | 2021-04-03 | Yuba | 115 | 6021 | 40 | 0 | 0 |
8932 | 8932 | 2021-04-02 | Yuba | 115 | 6021 | 40 | 16 | 0 |
8990 | 8990 | 2021-04-01 | Yuba | 115 | 6005 | 40 | 6 | 0 |
9048 | 9048 | 2021-03-31 | Yuba | 115 | 5999 | 40 | 16 | 0 |
9106 | 9106 | 2021-03-30 | Yuba | 115 | 5983 | 40 | 2 | 0 |
9164 | 9164 | 2021-03-29 | Yuba | 115 | 5981 | 40 | 28 | 0 |
9222 | 9222 | 2021-03-28 | Yuba | 115 | 5953 | 40 | 0 | 0 |
9280 | 9280 | 2021-03-27 | Yuba | 115 | 5953 | 40 | 0 | 0 |
9338 | 9338 | 2021-03-26 | Yuba | 115 | 5953 | 40 | 14 | 0 |
9396 | 9396 | 2021-03-25 | Yuba | 115 | 5939 | 40 | 13 | 0 |
9454 | 9454 | 2021-03-24 | Yuba | 115 | 5926 | 40 | 11 | 0 |
9512 | 9512 | 2021-03-23 | Yuba | 115 | 5915 | 40 | 3 | 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 );