latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
493 rows where fips = 43 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, did_not_update, date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
25 | 25 | Mariposa | Mariposa | 43 | 2021-09-02 | 833 | 10 | |
86 | 86 | Mariposa | Mariposa | 43 | 2021-09-01 | 825 | 10 | |
147 | 147 | Mariposa | Mariposa | 43 | 2021-08-31 | 816 | 10 | |
208 | 208 | Mariposa | Mariposa | 43 | 2021-08-30 | 803 | 10 | |
269 | 269 | Mariposa | Mariposa | 43 | 2021-08-29 | 781 | 10 | |
330 | 330 | Mariposa | Mariposa | 43 | 2021-08-28 | 781 | 10 | TRUE |
391 | 391 | Mariposa | Mariposa | 43 | 2021-08-27 | 781 | 10 | |
452 | 452 | Mariposa | Mariposa | 43 | 2021-08-26 | 769 | 10 | |
513 | 513 | Mariposa | Mariposa | 43 | 2021-08-25 | 754 | 10 | |
574 | 574 | Mariposa | Mariposa | 43 | 2021-08-24 | 749 | 10 | |
635 | 635 | Mariposa | Mariposa | 43 | 2021-08-23 | 740 | 10 | |
696 | 696 | Mariposa | Mariposa | 43 | 2021-08-22 | 700 | 10 | TRUE |
757 | 757 | Mariposa | Mariposa | 43 | 2021-08-21 | 700 | 10 | TRUE |
818 | 818 | Mariposa | Mariposa | 43 | 2021-08-20 | 700 | 10 | |
879 | 879 | Mariposa | Mariposa | 43 | 2021-08-19 | 694 | 8 | |
940 | 940 | Mariposa | Mariposa | 43 | 2021-08-18 | 678 | 8 | |
1001 | 1001 | Mariposa | Mariposa | 43 | 2021-08-17 | 673 | 8 | |
1062 | 1062 | Mariposa | Mariposa | 43 | 2021-08-16 | 662 | 7 | |
1123 | 1123 | Mariposa | Mariposa | 43 | 2021-08-15 | 636 | 7 | TRUE |
1184 | 1184 | Mariposa | Mariposa | 43 | 2021-08-14 | 636 | 7 | TRUE |
1245 | 1245 | Mariposa | Mariposa | 43 | 2021-08-13 | 636 | 7 | |
1306 | 1306 | Mariposa | Mariposa | 43 | 2021-08-12 | 626 | 7 | |
1367 | 1367 | Mariposa | Mariposa | 43 | 2021-08-11 | 601 | 7 | |
1428 | 1428 | Mariposa | Mariposa | 43 | 2021-08-10 | 592 | 7 | |
1489 | 1489 | Mariposa | Mariposa | 43 | 2021-08-09 | 587 | 7 | |
1550 | 1550 | Mariposa | Mariposa | 43 | 2021-08-08 | 559 | 7 | TRUE |
1611 | 1611 | Mariposa | Mariposa | 43 | 2021-08-07 | 559 | 7 | TRUE |
1672 | 1672 | Mariposa | Mariposa | 43 | 2021-08-06 | 559 | 7 | |
1733 | 1733 | Mariposa | Mariposa | 43 | 2021-08-05 | 547 | 7 | |
1794 | 1794 | Mariposa | Mariposa | 43 | 2021-08-04 | 537 | 7 | |
1855 | 1855 | Mariposa | Mariposa | 43 | 2021-08-03 | 521 | 7 | |
1916 | 1916 | Mariposa | Mariposa | 43 | 2021-08-02 | 521 | 7 | |
1977 | 1977 | Mariposa | Mariposa | 43 | 2021-08-01 | 500 | 7 | TRUE |
2038 | 2038 | Mariposa | Mariposa | 43 | 2021-07-31 | 500 | 7 | TRUE |
2099 | 2099 | Mariposa | Mariposa | 43 | 2021-07-30 | 500 | 7 | |
2160 | 2160 | Mariposa | Mariposa | 43 | 2021-07-29 | 498 | 7 | |
2221 | 2221 | Mariposa | Mariposa | 43 | 2021-07-28 | 497 | 7 | |
2282 | 2282 | Mariposa | Mariposa | 43 | 2021-07-27 | 495 | 7 | |
2343 | 2343 | Mariposa | Mariposa | 43 | 2021-07-26 | 494 | 7 | |
2404 | 2404 | Mariposa | Mariposa | 43 | 2021-07-25 | 485 | 7 | TRUE |
2465 | 2465 | Mariposa | Mariposa | 43 | 2021-07-24 | 485 | 7 | TRUE |
2526 | 2526 | Mariposa | Mariposa | 43 | 2021-07-23 | 485 | 7 | |
2587 | 2587 | Mariposa | Mariposa | 43 | 2021-07-22 | 480 | 7 | |
2648 | 2648 | Mariposa | Mariposa | 43 | 2021-07-21 | 475 | 7 | |
2709 | 2709 | Mariposa | Mariposa | 43 | 2021-07-20 | 474 | 7 | |
2770 | 2770 | Mariposa | Mariposa | 43 | 2021-07-19 | 473 | 7 | |
2831 | 2831 | Mariposa | Mariposa | 43 | 2021-07-18 | 472 | 7 | TRUE |
2892 | 2892 | Mariposa | Mariposa | 43 | 2021-07-17 | 472 | 7 | TRUE |
2953 | 2953 | Mariposa | Mariposa | 43 | 2021-07-16 | 472 | 7 | |
3014 | 3014 | Mariposa | Mariposa | 43 | 2021-07-15 | 471 | 7 | |
3075 | 3075 | Mariposa | Mariposa | 43 | 2021-07-14 | 469 | 7 | |
3136 | 3136 | Mariposa | Mariposa | 43 | 2021-07-13 | 469 | 7 | |
3197 | 3197 | Mariposa | Mariposa | 43 | 2021-07-12 | 468 | 7 | |
3258 | 3258 | Mariposa | Mariposa | 43 | 2021-07-11 | 468 | 7 | TRUE |
3319 | 3319 | Mariposa | Mariposa | 43 | 2021-07-10 | 468 | 7 | TRUE |
3380 | 3380 | Mariposa | Mariposa | 43 | 2021-07-09 | 468 | 7 | |
3441 | 3441 | Mariposa | Mariposa | 43 | 2021-07-08 | 468 | 7 | TRUE |
3502 | 3502 | Mariposa | Mariposa | 43 | 2021-07-07 | 468 | 7 | |
3563 | 3563 | Mariposa | Mariposa | 43 | 2021-07-06 | 468 | 7 | |
3624 | 3624 | Mariposa | Mariposa | 43 | 2021-07-05 | 467 | 7 | TRUE |
3685 | 3685 | Mariposa | Mariposa | 43 | 2021-07-04 | 467 | 7 | TRUE |
3746 | 3746 | Mariposa | Mariposa | 43 | 2021-07-03 | 467 | 7 | TRUE |
3807 | 3807 | Mariposa | Mariposa | 43 | 2021-07-02 | 467 | 7 | |
3868 | 3868 | Mariposa | Mariposa | 43 | 2021-07-01 | 467 | 7 | |
3929 | 3929 | Mariposa | Mariposa | 43 | 2021-06-30 | 467 | 7 | |
3990 | 3990 | Mariposa | Mariposa | 43 | 2021-06-29 | 467 | 7 | |
4051 | 4051 | Mariposa | Mariposa | 43 | 2021-06-28 | 466 | 7 | |
4112 | 4112 | Mariposa | Mariposa | 43 | 2021-06-27 | 466 | 7 | TRUE |
4173 | 4173 | Mariposa | Mariposa | 43 | 2021-06-26 | 466 | 7 | TRUE |
4234 | 4234 | Mariposa | Mariposa | 43 | 2021-06-25 | 466 | 7 | |
4295 | 4295 | Mariposa | Mariposa | 43 | 2021-06-24 | 466 | 7 | |
4356 | 4356 | Mariposa | Mariposa | 43 | 2021-06-23 | 465 | 7 | TRUE |
4417 | 4417 | Mariposa | Mariposa | 43 | 2021-06-22 | 465 | 7 | |
4478 | 4478 | Mariposa | Mariposa | 43 | 2021-06-21 | 465 | 7 | |
4539 | 4539 | Mariposa | Mariposa | 43 | 2021-06-20 | 465 | 7 | TRUE |
4600 | 4600 | Mariposa | Mariposa | 43 | 2021-06-19 | 465 | 7 | TRUE |
4661 | 4661 | Mariposa | Mariposa | 43 | 2021-06-18 | 465 | 7 | |
4722 | 4722 | Mariposa | Mariposa | 43 | 2021-06-17 | 465 | 7 | |
4783 | 4783 | Mariposa | Mariposa | 43 | 2021-06-16 | 464 | 7 | |
4844 | 4844 | Mariposa | Mariposa | 43 | 2021-06-15 | 464 | 7 | |
4905 | 4905 | Mariposa | Mariposa | 43 | 2021-06-14 | 461 | 7 | |
4966 | 4966 | Mariposa | Mariposa | 43 | 2021-06-13 | 461 | 7 | TRUE |
5027 | 5027 | Mariposa | Mariposa | 43 | 2021-06-12 | 461 | 7 | TRUE |
5088 | 5088 | Mariposa | Mariposa | 43 | 2021-06-11 | 461 | 7 | TRUE |
5149 | 5149 | Mariposa | Mariposa | 43 | 2021-06-10 | 461 | 7 | |
5210 | 5210 | Mariposa | Mariposa | 43 | 2021-06-09 | 461 | 7 | |
5271 | 5271 | Mariposa | Mariposa | 43 | 2021-06-08 | 461 | 7 | |
5332 | 5332 | Mariposa | Mariposa | 43 | 2021-06-07 | 461 | 7 | |
5393 | 5393 | Mariposa | Mariposa | 43 | 2021-06-06 | 461 | 7 | TRUE |
5454 | 5454 | Mariposa | Mariposa | 43 | 2021-06-05 | 461 | 7 | TRUE |
5515 | 5515 | Mariposa | Mariposa | 43 | 2021-06-04 | 461 | 7 | |
5576 | 5576 | Mariposa | Mariposa | 43 | 2021-06-03 | 461 | 7 | |
5637 | 5637 | Mariposa | Mariposa | 43 | 2021-06-02 | 461 | 7 | |
5698 | 5698 | Mariposa | Mariposa | 43 | 2021-06-01 | 458 | 7 | |
5759 | 5759 | Mariposa | Mariposa | 43 | 2021-05-31 | 454 | 7 | TRUE |
5820 | 5820 | Mariposa | Mariposa | 43 | 2021-05-30 | 454 | 7 | |
5881 | 5881 | Mariposa | Mariposa | 43 | 2021-05-29 | 454 | 7 | TRUE |
5942 | 5942 | Mariposa | Mariposa | 43 | 2021-05-28 | 454 | 7 | |
6003 | 6003 | Mariposa | Mariposa | 43 | 2021-05-27 | 454 | 7 | |
6064 | 6064 | Mariposa | Mariposa | 43 | 2021-05-26 | 454 | 7 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );