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

564 rows where agency = "Humboldt" 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

county 1

agency 1

  • Humboldt · 564 ✖
Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
13 13 Humboldt Humboldt 23 2021-09-02 7308 75  
74 74 Humboldt Humboldt 23 2021-09-01 7169 75  
135 135 Humboldt Humboldt 23 2021-08-31 7111 75  
196 196 Humboldt Humboldt 23 2021-08-30 6992 75  
257 257 Humboldt Humboldt 23 2021-08-29 6874 71 TRUE
318 318 Humboldt Humboldt 23 2021-08-28 6874 71 TRUE
379 379 Humboldt Humboldt 23 2021-08-27 6874 71  
440 440 Humboldt Humboldt 23 2021-08-26 6855 65  
501 501 Humboldt Humboldt 23 2021-08-25 6741 65  
562 562 Humboldt Humboldt 23 2021-08-24 6643 62  
623 623 Humboldt Humboldt 23 2021-08-23 6529 62  
684 684 Humboldt Humboldt 23 2021-08-22 6427 61 TRUE
745 745 Humboldt Humboldt 23 2021-08-21 6427 61 TRUE
806 806 Humboldt Humboldt 23 2021-08-20 6427 61  
867 867 Humboldt Humboldt 23 2021-08-19 6341 59  
928 928 Humboldt Humboldt 23 2021-08-18 6288 59  
989 989 Humboldt Humboldt 23 2021-08-17 6252 59  
1050 1050 Humboldt Humboldt 23 2021-08-16 6161 59  
1111 1111 Humboldt Humboldt 23 2021-08-15 5970 58 TRUE
1172 1172 Humboldt Humboldt 23 2021-08-14 5970 58 TRUE
1233 1233 Humboldt Humboldt 23 2021-08-13 5970 58  
1294 1294 Humboldt Humboldt 23 2021-08-12 5929 58  
1355 1355 Humboldt Humboldt 23 2021-08-11 5841 57  
1416 1416 Humboldt Humboldt 23 2021-08-10 5808 57  
1477 1477 Humboldt Humboldt 23 2021-08-09 5717 56  
1538 1538 Humboldt Humboldt 23 2021-08-08 5501 56 TRUE
1599 1599 Humboldt Humboldt 23 2021-08-07 5501 56 TRUE
1660 1660 Humboldt Humboldt 23 2021-08-06 5501 56  
1721 1721 Humboldt Humboldt 23 2021-08-05 5401 55  
1782 1782 Humboldt Humboldt 23 2021-08-04 5351 54  
1843 1843 Humboldt Humboldt 23 2021-08-03 5269 54  
1904 1904 Humboldt Humboldt 23 2021-08-02 5114 53 TRUE
1965 1965 Humboldt Humboldt 23 2021-08-01 5114 53 TRUE
2026 2026 Humboldt Humboldt 23 2021-07-31 5114 53 TRUE
2087 2087 Humboldt Humboldt 23 2021-07-30 5114 53  
2148 2148 Humboldt Humboldt 23 2021-07-29 5045 53  
2209 2209 Humboldt Humboldt 23 2021-07-28 5010 53  
2270 2270 Humboldt Humboldt 23 2021-07-27 4989 53  
2331 2331 Humboldt Humboldt 23 2021-07-26 4971 53  
2392 2392 Humboldt Humboldt 23 2021-07-25 4897 53 TRUE
2453 2453 Humboldt Humboldt 23 2021-07-24 4897 53 TRUE
2514 2514 Humboldt Humboldt 23 2021-07-23 4897 53  
2575 2575 Humboldt Humboldt 23 2021-07-22 4853 53  
2636 2636 Humboldt Humboldt 23 2021-07-21 4824 53  
2697 2697 Humboldt Humboldt 23 2021-07-20 4798 53  
2758 2758 Humboldt Humboldt 23 2021-07-19 4775 53  
2819 2819 Humboldt Humboldt 23 2021-07-18 4730 53 TRUE
2880 2880 Humboldt Humboldt 23 2021-07-17 4730 53 TRUE
2941 2941 Humboldt Humboldt 23 2021-07-16 4730 53  
3002 3002 Humboldt Humboldt 23 2021-07-15 4711 53  
3063 3063 Humboldt Humboldt 23 2021-07-14 4703 53  
3124 3124 Humboldt Humboldt 23 2021-07-13 4691 52  
3185 3185 Humboldt Humboldt 23 2021-07-12 4675 51  
3246 3246 Humboldt Humboldt 23 2021-07-11 4647 51 TRUE
3307 3307 Humboldt Humboldt 23 2021-07-10 4647 51 TRUE
3368 3368 Humboldt Humboldt 23 2021-07-09 4647 51  
3429 3429 Humboldt Humboldt 23 2021-07-08 4621 51  
3490 3490 Humboldt Humboldt 23 2021-07-07 4614 51  
3551 3551 Humboldt Humboldt 23 2021-07-06 4608 51  
3612 3612 Humboldt Humboldt 23 2021-07-05 4586 50 TRUE
3673 3673 Humboldt Humboldt 23 2021-07-04 4586 50 TRUE
3734 3734 Humboldt Humboldt 23 2021-07-03 4586 50 TRUE
3795 3795 Humboldt Humboldt 23 2021-07-02 4586 50  
3856 3856 Humboldt Humboldt 23 2021-07-01 4582 50  
3917 3917 Humboldt Humboldt 23 2021-06-30 4569 50  
3978 3978 Humboldt Humboldt 23 2021-06-29 4560 50  
4039 4039 Humboldt Humboldt 23 2021-06-28 4554 50  
4100 4100 Humboldt Humboldt 23 2021-06-27 4533 50 TRUE
4161 4161 Humboldt Humboldt 23 2021-06-26 4533 50 TRUE
4222 4222 Humboldt Humboldt 23 2021-06-25 4533 50  
4283 4283 Humboldt Humboldt 23 2021-06-24 4528 49  
4344 4344 Humboldt Humboldt 23 2021-06-23 4514 49  
4405 4405 Humboldt Humboldt 23 2021-06-22 4508 49  
4466 4466 Humboldt Humboldt 23 2021-06-21 4499 48  
4527 4527 Humboldt Humboldt 23 2021-06-20 4462 48 TRUE
4588 4588 Humboldt Humboldt 23 2021-06-19 4462 48 TRUE
4649 4649 Humboldt Humboldt 23 2021-06-18 4462 48  
4710 4710 Humboldt Humboldt 23 2021-06-17 4462 48  
4771 4771 Humboldt Humboldt 23 2021-06-16 4451 48  
4832 4832 Humboldt Humboldt 23 2021-06-15 4442 47  
4893 4893 Humboldt Humboldt 23 2021-06-14 4434 46  
4954 4954 Humboldt Humboldt 23 2021-06-13 4415 46 TRUE
5015 5015 Humboldt Humboldt 23 2021-06-12 4415 46 TRUE
5076 5076 Humboldt Humboldt 23 2021-06-11 4415 46  
5137 5137 Humboldt Humboldt 23 2021-06-10 4408 46  
5198 5198 Humboldt Humboldt 23 2021-06-09 4405 46  
5259 5259 Humboldt Humboldt 23 2021-06-08 4390 46  
5320 5320 Humboldt Humboldt 23 2021-06-07 4382 46  
5381 5381 Humboldt Humboldt 23 2021-06-06 4355 45 TRUE
5442 5442 Humboldt Humboldt 23 2021-06-05 4355 45 TRUE
5503 5503 Humboldt Humboldt 23 2021-06-04 4355 45  
5564 5564 Humboldt Humboldt 23 2021-06-03 4339 44  
5625 5625 Humboldt Humboldt 23 2021-06-02 4325 43  
5686 5686 Humboldt Humboldt 23 2021-06-01 4323 43  
5747 5747 Humboldt Humboldt 23 2021-05-31 4285 43 TRUE
5808 5808 Humboldt Humboldt 23 2021-05-30 4285 43  
5869 5869 Humboldt Humboldt 23 2021-05-29 4285 43 TRUE
5930 5930 Humboldt Humboldt 23 2021-05-28 4285 43  
5991 5991 Humboldt Humboldt 23 2021-05-27 4279 43  
6052 6052 Humboldt Humboldt 23 2021-05-26 4266 43  

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
);