latimes_agency_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_agency_totals

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

✎ View and edit SQL

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

Suggested facets: did_not_update, date (date)

fips 1

  • 9 559

county 1

  • Calaveras · 559 ✖

agency 1

  • Calaveras · 559 ✖
Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
6 6 Calaveras Calaveras 9 2021-09-02 2948 63  
67 67 Calaveras Calaveras 9 2021-09-01 2923 63  
128 128 Calaveras Calaveras 9 2021-08-31 2864 61  
189 189 Calaveras Calaveras 9 2021-08-30 2835 61  
250 250 Calaveras Calaveras 9 2021-08-29 2764 61 TRUE
311 311 Calaveras Calaveras 9 2021-08-28 2764 61 TRUE
372 372 Calaveras Calaveras 9 2021-08-27 2764 61  
433 433 Calaveras Calaveras 9 2021-08-26 2729 61  
494 494 Calaveras Calaveras 9 2021-08-25 2708 61  
555 555 Calaveras Calaveras 9 2021-08-24 2688 61  
616 616 Calaveras Calaveras 9 2021-08-23 2660 61  
677 677 Calaveras Calaveras 9 2021-08-22 2636 61 TRUE
738 738 Calaveras Calaveras 9 2021-08-21 2636 61 TRUE
799 799 Calaveras Calaveras 9 2021-08-20 2636 61  
860 860 Calaveras Calaveras 9 2021-08-19 2627 61  
921 921 Calaveras Calaveras 9 2021-08-18 2607 61  
982 982 Calaveras Calaveras 9 2021-08-17 2590 61  
1043 1043 Calaveras Calaveras 9 2021-08-16 2556 61  
1104 1104 Calaveras Calaveras 9 2021-08-15 2537 58 TRUE
1165 1165 Calaveras Calaveras 9 2021-08-14 2537 58 TRUE
1226 1226 Calaveras Calaveras 9 2021-08-13 2537 58  
1287 1287 Calaveras Calaveras 9 2021-08-12 2510 58  
1348 1348 Calaveras Calaveras 9 2021-08-11 2485 58  
1409 1409 Calaveras Calaveras 9 2021-08-10 2458 58  
1470 1470 Calaveras Calaveras 9 2021-08-09 2426 58  
1531 1531 Calaveras Calaveras 9 2021-08-08 2406 58 TRUE
1592 1592 Calaveras Calaveras 9 2021-08-07 2406 58 TRUE
1653 1653 Calaveras Calaveras 9 2021-08-06 2406 58  
1714 1714 Calaveras Calaveras 9 2021-08-05 2389 58  
1775 1775 Calaveras Calaveras 9 2021-08-04 2359 58  
1836 1836 Calaveras Calaveras 9 2021-08-03 2344 58  
1897 1897 Calaveras Calaveras 9 2021-08-02 2321 58  
1958 1958 Calaveras Calaveras 9 2021-08-01 2316 58 TRUE
2019 2019 Calaveras Calaveras 9 2021-07-31 2316 58 TRUE
2080 2080 Calaveras Calaveras 9 2021-07-30 2316 58  
2141 2141 Calaveras Calaveras 9 2021-07-29 2307 58  
2202 2202 Calaveras Calaveras 9 2021-07-28 2295 58  
2263 2263 Calaveras Calaveras 9 2021-07-27 2287 58  
2324 2324 Calaveras Calaveras 9 2021-07-26 2283 58  
2385 2385 Calaveras Calaveras 9 2021-07-25 2281 58 TRUE
2446 2446 Calaveras Calaveras 9 2021-07-24 2281 58 TRUE
2507 2507 Calaveras Calaveras 9 2021-07-23 2281 58  
2568 2568 Calaveras Calaveras 9 2021-07-22 2279 58  
2629 2629 Calaveras Calaveras 9 2021-07-21 2267 58  
2690 2690 Calaveras Calaveras 9 2021-07-20 2266 58 TRUE
2751 2751 Calaveras Calaveras 9 2021-07-19 2256 58 TRUE
2812 2812 Calaveras Calaveras 9 2021-07-18 2256 58 TRUE
2873 2873 Calaveras Calaveras 9 2021-07-17 2256 58 TRUE
2934 2934 Calaveras Calaveras 9 2021-07-16 2256 58  
2995 2995 Calaveras Calaveras 9 2021-07-15 2253 58  
3056 3056 Calaveras Calaveras 9 2021-07-14 2251 58  
3117 3117 Calaveras Calaveras 9 2021-07-13 2235 58 TRUE
3178 3178 Calaveras Calaveras 9 2021-07-12 2235 58  
3239 3239 Calaveras Calaveras 9 2021-07-11 2233 58 TRUE
3300 3300 Calaveras Calaveras 9 2021-07-10 2233 58 TRUE
3361 3361 Calaveras Calaveras 9 2021-07-09 2233 58  
3422 3422 Calaveras Calaveras 9 2021-07-08 2232 58  
3483 3483 Calaveras Calaveras 9 2021-07-07 2228 58  
3544 3544 Calaveras Calaveras 9 2021-07-06 2227 58  
3605 3605 Calaveras Calaveras 9 2021-07-05 2220 56 TRUE
3666 3666 Calaveras Calaveras 9 2021-07-04 2220 56 TRUE
3727 3727 Calaveras Calaveras 9 2021-07-03 2220 56  
3788 3788 Calaveras Calaveras 9 2021-07-02 2220 56  
3849 3849 Calaveras Calaveras 9 2021-07-01 2217 56  
3910 3910 Calaveras Calaveras 9 2021-06-30 2215 56  
3971 3971 Calaveras Calaveras 9 2021-06-29 2214 56  
4032 4032 Calaveras Calaveras 9 2021-06-28 2213 56  
4093 4093 Calaveras Calaveras 9 2021-06-27 2210 56 TRUE
4154 4154 Calaveras Calaveras 9 2021-06-26 2210 56 TRUE
4215 4215 Calaveras Calaveras 9 2021-06-25 2210 56  
4276 4276 Calaveras Calaveras 9 2021-06-24 2210 56  
4337 4337 Calaveras Calaveras 9 2021-06-23 2209 56  
4398 4398 Calaveras Calaveras 9 2021-06-22 2208 56  
4459 4459 Calaveras Calaveras 9 2021-06-21 2207 56  
4520 4520 Calaveras Calaveras 9 2021-06-20 2201 56 TRUE
4581 4581 Calaveras Calaveras 9 2021-06-19 2201 56 TRUE
4642 4642 Calaveras Calaveras 9 2021-06-18 2201 56 TRUE
4703 4703 Calaveras Calaveras 9 2021-06-17 2201 56  
4764 4764 Calaveras Calaveras 9 2021-06-16 2201 56  
4825 4825 Calaveras Calaveras 9 2021-06-15 2201 56  
4886 4886 Calaveras Calaveras 9 2021-06-14 2201 56  
4947 4947 Calaveras Calaveras 9 2021-06-13 2200 56 TRUE
5008 5008 Calaveras Calaveras 9 2021-06-12 2200 56 TRUE
5069 5069 Calaveras Calaveras 9 2021-06-11 2200 56  
5130 5130 Calaveras Calaveras 9 2021-06-10 2199 56  
5191 5191 Calaveras Calaveras 9 2021-06-09 2198 56  
5252 5252 Calaveras Calaveras 9 2021-06-08 2195 56  
5313 5313 Calaveras Calaveras 9 2021-06-07 2195 56  
5374 5374 Calaveras Calaveras 9 2021-06-06 2193 56 TRUE
5435 5435 Calaveras Calaveras 9 2021-06-05 2193 56 TRUE
5496 5496 Calaveras Calaveras 9 2021-06-04 2193 56  
5557 5557 Calaveras Calaveras 9 2021-06-03 2192 56  
5618 5618 Calaveras Calaveras 9 2021-06-02 2186 56  
5679 5679 Calaveras Calaveras 9 2021-06-01 2184 56  
5740 5740 Calaveras Calaveras 9 2021-05-31 2174 56 TRUE
5801 5801 Calaveras Calaveras 9 2021-05-30 2174 56  
5862 5862 Calaveras Calaveras 9 2021-05-29 2174 56 TRUE
5923 5923 Calaveras Calaveras 9 2021-05-28 2174 56  
5984 5984 Calaveras Calaveras 9 2021-05-27 2168 56  
6045 6045 Calaveras Calaveras 9 2021-05-26 2166 56  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_agency_totals] (
   [agency] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [did_not_update] TEXT
);