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

534 rows where agency = "Mendocino" sorted by rowid

✎ View and edit SQL

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

Suggested facets: confirmed_cases, deaths, did_not_update, date (date)

fips 1

county 1

agency 1

  • Mendocino · 534 ✖
Link rowid ▼ agency county fips date confirmed_cases deaths did_not_update
26 26 Mendocino Mendocino 45 2021-09-02 6117 64  
87 87 Mendocino Mendocino 45 2021-09-01 6075 64  
148 148 Mendocino Mendocino 45 2021-08-31 6027 64  
209 209 Mendocino Mendocino 45 2021-08-30 5927 61 TRUE
270 270 Mendocino Mendocino 45 2021-08-29 5927 61 TRUE
331 331 Mendocino Mendocino 45 2021-08-28 5927 61 TRUE
392 392 Mendocino Mendocino 45 2021-08-27 5885 61  
453 453 Mendocino Mendocino 45 2021-08-26 5825 60  
514 514 Mendocino Mendocino 45 2021-08-25 5796 59  
575 575 Mendocino Mendocino 45 2021-08-24 5729 58  
636 636 Mendocino Mendocino 45 2021-08-23 5605 57 TRUE
697 697 Mendocino Mendocino 45 2021-08-22 5605 57 TRUE
758 758 Mendocino Mendocino 45 2021-08-21 5605 57  
819 819 Mendocino Mendocino 45 2021-08-20 5554 56 TRUE
880 880 Mendocino Mendocino 45 2021-08-19 5554 56  
941 941 Mendocino Mendocino 45 2021-08-18 5499 56  
1002 1002 Mendocino Mendocino 45 2021-08-17 5332 55 TRUE
1063 1063 Mendocino Mendocino 45 2021-08-16 5332 55  
1124 1124 Mendocino Mendocino 45 2021-08-15 5267 54 TRUE
1185 1185 Mendocino Mendocino 45 2021-08-14 5267 54  
1246 1246 Mendocino Mendocino 45 2021-08-13 5211 54 TRUE
1307 1307 Mendocino Mendocino 45 2021-08-12 5211 54  
1368 1368 Mendocino Mendocino 45 2021-08-11 5116 54  
1429 1429 Mendocino Mendocino 45 2021-08-10 5024 54  
1490 1490 Mendocino Mendocino 45 2021-08-09 5024 54  
1551 1551 Mendocino Mendocino 45 2021-08-08 4892 52 TRUE
1612 1612 Mendocino Mendocino 45 2021-08-07 4892 52 TRUE
1673 1673 Mendocino Mendocino 45 2021-08-06 4892 52 TRUE
1734 1734 Mendocino Mendocino 45 2021-08-05 4892 52  
1795 1795 Mendocino Mendocino 45 2021-08-04 4856 52  
1856 1856 Mendocino Mendocino 45 2021-08-03 4830 52  
1917 1917 Mendocino Mendocino 45 2021-08-02 4799 52  
1978 1978 Mendocino Mendocino 45 2021-08-01 4710 52 TRUE
2039 2039 Mendocino Mendocino 45 2021-07-31 4710 52  
2100 2100 Mendocino Mendocino 45 2021-07-30 4683 51 TRUE
2161 2161 Mendocino Mendocino 45 2021-07-29 4658 51 TRUE
2222 2222 Mendocino Mendocino 45 2021-07-28 4658 51  
2283 2283 Mendocino Mendocino 45 2021-07-27 4628 50  
2344 2344 Mendocino Mendocino 45 2021-07-26 4571 50 TRUE
2405 2405 Mendocino Mendocino 45 2021-07-25 4571 50 TRUE
2466 2466 Mendocino Mendocino 45 2021-07-24 4571 50 TRUE
2527 2527 Mendocino Mendocino 45 2021-07-23 4571 50  
2588 2588 Mendocino Mendocino 45 2021-07-22 4571 50  
2649 2649 Mendocino Mendocino 45 2021-07-21 4533 50  
2710 2710 Mendocino Mendocino 45 2021-07-20 4524 50  
2771 2771 Mendocino Mendocino 45 2021-07-19 4502 50 TRUE
2832 2832 Mendocino Mendocino 45 2021-07-18 4502 50 TRUE
2893 2893 Mendocino Mendocino 45 2021-07-17 4502 50 TRUE
2954 2954 Mendocino Mendocino 45 2021-07-16 4502 50  
3015 3015 Mendocino Mendocino 45 2021-07-15 4490 50  
3076 3076 Mendocino Mendocino 45 2021-07-14 4460 50  
3137 3137 Mendocino Mendocino 45 2021-07-13 4448 50 TRUE
3198 3198 Mendocino Mendocino 45 2021-07-12 4448 50  
3259 3259 Mendocino Mendocino 45 2021-07-11 4429 50 TRUE
3320 3320 Mendocino Mendocino 45 2021-07-10 4429 50 TRUE
3381 3381 Mendocino Mendocino 45 2021-07-09 4429 50  
3442 3442 Mendocino Mendocino 45 2021-07-08 4412 50 TRUE
3503 3503 Mendocino Mendocino 45 2021-07-07 4412 50 TRUE
3564 3564 Mendocino Mendocino 45 2021-07-06 4412 50  
3625 3625 Mendocino Mendocino 45 2021-07-05 4398 50 TRUE
3686 3686 Mendocino Mendocino 45 2021-07-04 4398 50 TRUE
3747 3747 Mendocino Mendocino 45 2021-07-03 4398 50  
3808 3808 Mendocino Mendocino 45 2021-07-02 4387 50 TRUE
3869 3869 Mendocino Mendocino 45 2021-07-01 4387 50  
3930 3930 Mendocino Mendocino 45 2021-06-30 4372 50 TRUE
3991 3991 Mendocino Mendocino 45 2021-06-29 4372 50 TRUE
4052 4052 Mendocino Mendocino 45 2021-06-28 4372 50  
4113 4113 Mendocino Mendocino 45 2021-06-27 4363 50 TRUE
4174 4174 Mendocino Mendocino 45 2021-06-26 4363 50 TRUE
4235 4235 Mendocino Mendocino 45 2021-06-25 4363 50  
4296 4296 Mendocino Mendocino 45 2021-06-24 4357 50  
4357 4357 Mendocino Mendocino 45 2021-06-23 4340 50 TRUE
4418 4418 Mendocino Mendocino 45 2021-06-22 4340 50 TRUE
4479 4479 Mendocino Mendocino 45 2021-06-21 4340 50  
4540 4540 Mendocino Mendocino 45 2021-06-20 4321 50 TRUE
4601 4601 Mendocino Mendocino 45 2021-06-19 4321 50 TRUE
4662 4662 Mendocino Mendocino 45 2021-06-18 4321 50  
4723 4723 Mendocino Mendocino 45 2021-06-17 4306 50  
4784 4784 Mendocino Mendocino 45 2021-06-16 4289 50 TRUE
4845 4845 Mendocino Mendocino 45 2021-06-15 4289 50  
4906 4906 Mendocino Mendocino 45 2021-06-14 4282 50  
4967 4967 Mendocino Mendocino 45 2021-06-13 4274 50 TRUE
5028 5028 Mendocino Mendocino 45 2021-06-12 4274 50 TRUE
5089 5089 Mendocino Mendocino 45 2021-06-11 4274 50  
5150 5150 Mendocino Mendocino 45 2021-06-10 4268 50  
5211 5211 Mendocino Mendocino 45 2021-06-09 4263 50  
5272 5272 Mendocino Mendocino 45 2021-06-08 4258 50  
5333 5333 Mendocino Mendocino 45 2021-06-07 4252 50  
5394 5394 Mendocino Mendocino 45 2021-06-06 4239 50 TRUE
5455 5455 Mendocino Mendocino 45 2021-06-05 4239 50 TRUE
5516 5516 Mendocino Mendocino 45 2021-06-04 4239 50  
5577 5577 Mendocino Mendocino 45 2021-06-03 4232 49  
5638 5638 Mendocino Mendocino 45 2021-06-02 4228 49  
5699 5699 Mendocino Mendocino 45 2021-06-01 4223 49  
5760 5760 Mendocino Mendocino 45 2021-05-31 4197 49 TRUE
5821 5821 Mendocino Mendocino 45 2021-05-30 4197 49  
5882 5882 Mendocino Mendocino 45 2021-05-29 4197 49 TRUE
5943 5943 Mendocino Mendocino 45 2021-05-28 4197 49  
6004 6004 Mendocino Mendocino 45 2021-05-27 4197 49  
6065 6065 Mendocino Mendocino 45 2021-05-26 4194 49  

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