latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
493 rows where fips = 43 sorted by new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, new_confirmed_cases, new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
254 | 254 | 2021-08-29 | Mariposa | 43 | 781 | 10 | 0 | 0 |
312 | 312 | 2021-08-28 | Mariposa | 43 | 781 | 10 | 0 | 0 |
660 | 660 | 2021-08-22 | Mariposa | 43 | 700 | 10 | 0 | 0 |
718 | 718 | 2021-08-21 | Mariposa | 43 | 700 | 10 | 0 | 0 |
1066 | 1066 | 2021-08-15 | Mariposa | 43 | 636 | 7 | 0 | 0 |
1124 | 1124 | 2021-08-14 | Mariposa | 43 | 636 | 7 | 0 | 0 |
1472 | 1472 | 2021-08-08 | Mariposa | 43 | 559 | 7 | 0 | 0 |
1530 | 1530 | 2021-08-07 | Mariposa | 43 | 559 | 7 | 0 | 0 |
1762 | 1762 | 2021-08-03 | Mariposa | 43 | 521 | 7 | 0 | 0 |
1878 | 1878 | 2021-08-01 | Mariposa | 43 | 500 | 7 | 0 | 0 |
1936 | 1936 | 2021-07-31 | Mariposa | 43 | 500 | 7 | 0 | 0 |
2284 | 2284 | 2021-07-25 | Mariposa | 43 | 485 | 7 | 0 | 0 |
2342 | 2342 | 2021-07-24 | Mariposa | 43 | 485 | 7 | 0 | 0 |
2690 | 2690 | 2021-07-18 | Mariposa | 43 | 472 | 7 | 0 | 0 |
2748 | 2748 | 2021-07-17 | Mariposa | 43 | 472 | 7 | 0 | 0 |
2922 | 2922 | 2021-07-14 | Mariposa | 43 | 469 | 7 | 0 | 0 |
3038 | 3038 | 2021-07-12 | Mariposa | 43 | 468 | 7 | 0 | 0 |
3096 | 3096 | 2021-07-11 | Mariposa | 43 | 468 | 7 | 0 | 0 |
3154 | 3154 | 2021-07-10 | Mariposa | 43 | 468 | 7 | 0 | 0 |
3212 | 3212 | 2021-07-09 | Mariposa | 43 | 468 | 7 | 0 | 0 |
3270 | 3270 | 2021-07-08 | Mariposa | 43 | 468 | 7 | 0 | 0 |
3328 | 3328 | 2021-07-07 | Mariposa | 43 | 468 | 7 | 0 | 0 |
3444 | 3444 | 2021-07-05 | Mariposa | 43 | 467 | 7 | 0 | 0 |
3502 | 3502 | 2021-07-04 | Mariposa | 43 | 467 | 7 | 0 | 0 |
3560 | 3560 | 2021-07-03 | Mariposa | 43 | 467 | 7 | 0 | 0 |
3618 | 3618 | 2021-07-02 | Mariposa | 43 | 467 | 7 | 0 | 0 |
3676 | 3676 | 2021-07-01 | Mariposa | 43 | 467 | 7 | 0 | 0 |
3734 | 3734 | 2021-06-30 | Mariposa | 43 | 467 | 7 | 0 | 0 |
3850 | 3850 | 2021-06-28 | Mariposa | 43 | 466 | 7 | 0 | 0 |
3908 | 3908 | 2021-06-27 | Mariposa | 43 | 466 | 7 | 0 | 0 |
3966 | 3966 | 2021-06-26 | Mariposa | 43 | 466 | 7 | 0 | 0 |
4024 | 4024 | 2021-06-25 | Mariposa | 43 | 466 | 7 | 0 | 0 |
4140 | 4140 | 2021-06-23 | Mariposa | 43 | 465 | 7 | 0 | 0 |
4198 | 4198 | 2021-06-22 | Mariposa | 43 | 465 | 7 | 0 | 0 |
4256 | 4256 | 2021-06-21 | Mariposa | 43 | 465 | 7 | 0 | 0 |
4314 | 4314 | 2021-06-20 | Mariposa | 43 | 465 | 7 | 0 | 0 |
4372 | 4372 | 2021-06-19 | Mariposa | 43 | 465 | 7 | 0 | 0 |
4430 | 4430 | 2021-06-18 | Mariposa | 43 | 465 | 7 | 0 | 0 |
4546 | 4546 | 2021-06-16 | Mariposa | 43 | 464 | 7 | 0 | 0 |
4662 | 4662 | 2021-06-14 | Mariposa | 43 | 461 | 7 | 0 | 0 |
4720 | 4720 | 2021-06-13 | Mariposa | 43 | 461 | 7 | 0 | 0 |
4778 | 4778 | 2021-06-12 | Mariposa | 43 | 461 | 7 | 0 | 0 |
4836 | 4836 | 2021-06-11 | Mariposa | 43 | 461 | 7 | 0 | 0 |
4894 | 4894 | 2021-06-10 | Mariposa | 43 | 461 | 7 | 0 | 0 |
4952 | 4952 | 2021-06-09 | Mariposa | 43 | 461 | 7 | 0 | 0 |
5010 | 5010 | 2021-06-08 | Mariposa | 43 | 461 | 7 | 0 | 0 |
5068 | 5068 | 2021-06-07 | Mariposa | 43 | 461 | 7 | 0 | 0 |
5126 | 5126 | 2021-06-06 | Mariposa | 43 | 461 | 7 | 0 | 0 |
5184 | 5184 | 2021-06-05 | Mariposa | 43 | 461 | 7 | 0 | 0 |
5242 | 5242 | 2021-06-04 | Mariposa | 43 | 461 | 7 | 0 | 0 |
5300 | 5300 | 2021-06-03 | Mariposa | 43 | 461 | 7 | 0 | 0 |
5474 | 5474 | 2021-05-31 | Mariposa | 43 | 454 | 7 | 0 | 0 |
5532 | 5532 | 2021-05-30 | Mariposa | 43 | 454 | 7 | 0 | 0 |
5590 | 5590 | 2021-05-29 | Mariposa | 43 | 454 | 7 | 0 | 0 |
5648 | 5648 | 2021-05-28 | Mariposa | 43 | 454 | 7 | 0 | 0 |
5706 | 5706 | 2021-05-27 | Mariposa | 43 | 454 | 7 | 0 | 0 |
5764 | 5764 | 2021-05-26 | Mariposa | 43 | 454 | 7 | 0 | 0 |
5938 | 5938 | 2021-05-23 | Mariposa | 43 | 452 | 7 | 0 | 0 |
5996 | 5996 | 2021-05-22 | Mariposa | 43 | 452 | 7 | 0 | 0 |
6054 | 6054 | 2021-05-21 | Mariposa | 43 | 452 | 7 | 0 | 0 |
6170 | 6170 | 2021-05-19 | Mariposa | 43 | 450 | 7 | 0 | 0 |
6228 | 6228 | 2021-05-18 | Mariposa | 43 | 450 | 7 | 0 | 0 |
6286 | 6286 | 2021-05-17 | Mariposa | 43 | 450 | 7 | 0 | 0 |
6344 | 6344 | 2021-05-16 | Mariposa | 43 | 450 | 7 | 0 | 0 |
6460 | 6460 | 2021-05-14 | Mariposa | 43 | 448 | 7 | 0 | 0 |
6518 | 6518 | 2021-05-13 | Mariposa | 43 | 448 | 7 | 0 | 0 |
6634 | 6634 | 2021-05-11 | Mariposa | 43 | 447 | 7 | 0 | 0 |
6750 | 6750 | 2021-05-09 | Mariposa | 43 | 445 | 7 | 0 | 0 |
6808 | 6808 | 2021-05-08 | Mariposa | 43 | 445 | 7 | 0 | 0 |
6866 | 6866 | 2021-05-07 | Mariposa | 43 | 445 | 7 | 0 | 0 |
6924 | 6924 | 2021-05-06 | Mariposa | 43 | 445 | 7 | 0 | 0 |
7040 | 7040 | 2021-05-04 | Mariposa | 43 | 444 | 7 | 0 | 0 |
7156 | 7156 | 2021-05-02 | Mariposa | 43 | 441 | 7 | 0 | 0 |
7214 | 7214 | 2021-05-01 | Mariposa | 43 | 441 | 7 | 0 | 0 |
7272 | 7272 | 2021-04-30 | Mariposa | 43 | 441 | 7 | 0 | 0 |
7330 | 7330 | 2021-04-29 | Mariposa | 43 | 441 | 7 | 0 | 0 |
7388 | 7388 | 2021-04-28 | Mariposa | 43 | 441 | 7 | 0 | 0 |
7562 | 7562 | 2021-04-25 | Mariposa | 43 | 436 | 7 | 0 | 0 |
7736 | 7736 | 2021-04-22 | Mariposa | 43 | 429 | 7 | 0 | 0 |
7968 | 7968 | 2021-04-18 | Mariposa | 43 | 424 | 7 | 0 | 0 |
8084 | 8084 | 2021-04-16 | Mariposa | 43 | 419 | 7 | 0 | 0 |
8200 | 8200 | 2021-04-14 | Mariposa | 43 | 417 | 7 | 0 | 0 |
8374 | 8374 | 2021-04-11 | Mariposa | 43 | 415 | 7 | 0 | 0 |
8432 | 8432 | 2021-04-10 | Mariposa | 43 | 415 | 7 | 0 | 0 |
8490 | 8490 | 2021-04-09 | Mariposa | 43 | 415 | 7 | 0 | 0 |
8548 | 8548 | 2021-04-08 | Mariposa | 43 | 415 | 7 | 0 | 0 |
8722 | 8722 | 2021-04-05 | Mariposa | 43 | 411 | 7 | 0 | 0 |
8838 | 8838 | 2021-04-03 | Mariposa | 43 | 410 | 7 | 0 | 0 |
8896 | 8896 | 2021-04-02 | Mariposa | 43 | 410 | 7 | 0 | 0 |
8954 | 8954 | 2021-04-01 | Mariposa | 43 | 410 | 7 | 0 | 0 |
9012 | 9012 | 2021-03-31 | Mariposa | 43 | 410 | 7 | 0 | 0 |
9070 | 9070 | 2021-03-30 | Mariposa | 43 | 410 | 7 | 0 | 0 |
9186 | 9186 | 2021-03-28 | Mariposa | 43 | 408 | 7 | 0 | 0 |
9244 | 9244 | 2021-03-27 | Mariposa | 43 | 408 | 7 | 0 | 0 |
9302 | 9302 | 2021-03-26 | Mariposa | 43 | 408 | 7 | 0 | 0 |
9592 | 9592 | 2021-03-21 | Mariposa | 43 | 402 | 7 | 0 | 0 |
9708 | 9708 | 2021-03-19 | Mariposa | 43 | 400 | 7 | 0 | 0 |
9766 | 9766 | 2021-03-18 | Mariposa | 43 | 400 | 7 | 0 | 0 |
9998 | 9998 | 2021-03-14 | Mariposa | 43 | 396 | 7 | 0 | 0 |
10056 | 10056 | 2021-03-13 | Mariposa | 43 | 396 | 7 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );