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

559 rows where county = "Calaveras" and fips = 9 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths, new_deaths, date (date)

fips 1

county 1

  • Calaveras · 559 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
5 5 2021-09-02 Calaveras 9 2948 63 25 0
63 63 2021-09-01 Calaveras 9 2923 63 59 2
121 121 2021-08-31 Calaveras 9 2864 61 29 0
179 179 2021-08-30 Calaveras 9 2835 61 71 0
237 237 2021-08-29 Calaveras 9 2764 61 0 0
295 295 2021-08-28 Calaveras 9 2764 61 0 0
353 353 2021-08-27 Calaveras 9 2764 61 35 0
411 411 2021-08-26 Calaveras 9 2729 61 21 0
469 469 2021-08-25 Calaveras 9 2708 61 20 0
527 527 2021-08-24 Calaveras 9 2688 61 28 0
585 585 2021-08-23 Calaveras 9 2660 61 24 0
643 643 2021-08-22 Calaveras 9 2636 61 0 0
701 701 2021-08-21 Calaveras 9 2636 61 0 0
759 759 2021-08-20 Calaveras 9 2636 61 9 0
817 817 2021-08-19 Calaveras 9 2627 61 20 0
875 875 2021-08-18 Calaveras 9 2607 61 17 0
933 933 2021-08-17 Calaveras 9 2590 61 34 0
991 991 2021-08-16 Calaveras 9 2556 61 19 3
1049 1049 2021-08-15 Calaveras 9 2537 58 0 0
1107 1107 2021-08-14 Calaveras 9 2537 58 0 0
1165 1165 2021-08-13 Calaveras 9 2537 58 27 0
1223 1223 2021-08-12 Calaveras 9 2510 58 25 0
1281 1281 2021-08-11 Calaveras 9 2485 58 27 0
1339 1339 2021-08-10 Calaveras 9 2458 58 32 0
1397 1397 2021-08-09 Calaveras 9 2426 58 20 0
1455 1455 2021-08-08 Calaveras 9 2406 58 0 0
1513 1513 2021-08-07 Calaveras 9 2406 58 0 0
1571 1571 2021-08-06 Calaveras 9 2406 58 17 0
1629 1629 2021-08-05 Calaveras 9 2389 58 30 0
1687 1687 2021-08-04 Calaveras 9 2359 58 15 0
1745 1745 2021-08-03 Calaveras 9 2344 58 23 0
1803 1803 2021-08-02 Calaveras 9 2321 58 5 0
1861 1861 2021-08-01 Calaveras 9 2316 58 0 0
1919 1919 2021-07-31 Calaveras 9 2316 58 0 0
1977 1977 2021-07-30 Calaveras 9 2316 58 9 0
2035 2035 2021-07-29 Calaveras 9 2307 58 12 0
2093 2093 2021-07-28 Calaveras 9 2295 58 8 0
2151 2151 2021-07-27 Calaveras 9 2287 58 4 0
2209 2209 2021-07-26 Calaveras 9 2283 58 2 0
2267 2267 2021-07-25 Calaveras 9 2281 58 0 0
2325 2325 2021-07-24 Calaveras 9 2281 58 0 0
2383 2383 2021-07-23 Calaveras 9 2281 58 2 0
2441 2441 2021-07-22 Calaveras 9 2279 58 12 0
2499 2499 2021-07-21 Calaveras 9 2267 58 1 0
2557 2557 2021-07-20 Calaveras 9 2266 58 10 0
2615 2615 2021-07-19 Calaveras 9 2256 58 0 0
2673 2673 2021-07-18 Calaveras 9 2256 58 0 0
2731 2731 2021-07-17 Calaveras 9 2256 58 0 0
2789 2789 2021-07-16 Calaveras 9 2256 58 3 0
2847 2847 2021-07-15 Calaveras 9 2253 58 2 0
2905 2905 2021-07-14 Calaveras 9 2251 58 16 0
2963 2963 2021-07-13 Calaveras 9 2235 58 0 0
3021 3021 2021-07-12 Calaveras 9 2235 58 2 0
3079 3079 2021-07-11 Calaveras 9 2233 58 0 0
3137 3137 2021-07-10 Calaveras 9 2233 58 0 0
3195 3195 2021-07-09 Calaveras 9 2233 58 1 0
3253 3253 2021-07-08 Calaveras 9 2232 58 4 0
3311 3311 2021-07-07 Calaveras 9 2228 58 1 0
3369 3369 2021-07-06 Calaveras 9 2227 58 7 2
3427 3427 2021-07-05 Calaveras 9 2220 56 0 0
3485 3485 2021-07-04 Calaveras 9 2220 56 0 0
3543 3543 2021-07-03 Calaveras 9 2220 56 0 0
3601 3601 2021-07-02 Calaveras 9 2220 56 3 0
3659 3659 2021-07-01 Calaveras 9 2217 56 2 0
3717 3717 2021-06-30 Calaveras 9 2215 56 1 0
3775 3775 2021-06-29 Calaveras 9 2214 56 1 0
3833 3833 2021-06-28 Calaveras 9 2213 56 3 0
3891 3891 2021-06-27 Calaveras 9 2210 56 0 0
3949 3949 2021-06-26 Calaveras 9 2210 56 0 0
4007 4007 2021-06-25 Calaveras 9 2210 56 0 0
4065 4065 2021-06-24 Calaveras 9 2210 56 1 0
4123 4123 2021-06-23 Calaveras 9 2209 56 1 0
4181 4181 2021-06-22 Calaveras 9 2208 56 1 0
4239 4239 2021-06-21 Calaveras 9 2207 56 6 0
4297 4297 2021-06-20 Calaveras 9 2201 56 0 0
4355 4355 2021-06-19 Calaveras 9 2201 56 0 0
4413 4413 2021-06-18 Calaveras 9 2201 56 0 0
4471 4471 2021-06-17 Calaveras 9 2201 56 0 0
4529 4529 2021-06-16 Calaveras 9 2201 56 0 0
4587 4587 2021-06-15 Calaveras 9 2201 56 0 0
4645 4645 2021-06-14 Calaveras 9 2201 56 1 0
4703 4703 2021-06-13 Calaveras 9 2200 56 0 0
4761 4761 2021-06-12 Calaveras 9 2200 56 0 0
4819 4819 2021-06-11 Calaveras 9 2200 56 1 0
4877 4877 2021-06-10 Calaveras 9 2199 56 1 0
4935 4935 2021-06-09 Calaveras 9 2198 56 3 0
4993 4993 2021-06-08 Calaveras 9 2195 56 0 0
5051 5051 2021-06-07 Calaveras 9 2195 56 2 0
5109 5109 2021-06-06 Calaveras 9 2193 56 0 0
5167 5167 2021-06-05 Calaveras 9 2193 56 0 0
5225 5225 2021-06-04 Calaveras 9 2193 56 1 0
5283 5283 2021-06-03 Calaveras 9 2192 56 6 0
5341 5341 2021-06-02 Calaveras 9 2186 56 2 0
5399 5399 2021-06-01 Calaveras 9 2184 56 10 0
5457 5457 2021-05-31 Calaveras 9 2174 56 0 0
5515 5515 2021-05-30 Calaveras 9 2174 56 0 0
5573 5573 2021-05-29 Calaveras 9 2174 56 0 0
5631 5631 2021-05-28 Calaveras 9 2174 56 6 0
5689 5689 2021-05-27 Calaveras 9 2168 56 2 0
5747 5747 2021-05-26 Calaveras 9 2166 56 5 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
);