latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
183 rows where deaths = 7 and fips = 43 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
1008 | 1008 | 2021-08-16 | Mariposa | 43 | 662 | 7 | 26 | 0 |
1066 | 1066 | 2021-08-15 | Mariposa | 43 | 636 | 7 | 0 | 0 |
1124 | 1124 | 2021-08-14 | Mariposa | 43 | 636 | 7 | 0 | 0 |
1182 | 1182 | 2021-08-13 | Mariposa | 43 | 636 | 7 | 10 | 0 |
1240 | 1240 | 2021-08-12 | Mariposa | 43 | 626 | 7 | 25 | 0 |
1298 | 1298 | 2021-08-11 | Mariposa | 43 | 601 | 7 | 9 | 0 |
1356 | 1356 | 2021-08-10 | Mariposa | 43 | 592 | 7 | 5 | 0 |
1414 | 1414 | 2021-08-09 | Mariposa | 43 | 587 | 7 | 28 | 0 |
1472 | 1472 | 2021-08-08 | Mariposa | 43 | 559 | 7 | 0 | 0 |
1530 | 1530 | 2021-08-07 | Mariposa | 43 | 559 | 7 | 0 | 0 |
1588 | 1588 | 2021-08-06 | Mariposa | 43 | 559 | 7 | 12 | 0 |
1646 | 1646 | 2021-08-05 | Mariposa | 43 | 547 | 7 | 10 | 0 |
1704 | 1704 | 2021-08-04 | Mariposa | 43 | 537 | 7 | 16 | 0 |
1762 | 1762 | 2021-08-03 | Mariposa | 43 | 521 | 7 | 0 | 0 |
1820 | 1820 | 2021-08-02 | Mariposa | 43 | 521 | 7 | 21 | 0 |
1878 | 1878 | 2021-08-01 | Mariposa | 43 | 500 | 7 | 0 | 0 |
1936 | 1936 | 2021-07-31 | Mariposa | 43 | 500 | 7 | 0 | 0 |
1994 | 1994 | 2021-07-30 | Mariposa | 43 | 500 | 7 | 2 | 0 |
2052 | 2052 | 2021-07-29 | Mariposa | 43 | 498 | 7 | 1 | 0 |
2110 | 2110 | 2021-07-28 | Mariposa | 43 | 497 | 7 | 2 | 0 |
2168 | 2168 | 2021-07-27 | Mariposa | 43 | 495 | 7 | 1 | 0 |
2226 | 2226 | 2021-07-26 | Mariposa | 43 | 494 | 7 | 9 | 0 |
2284 | 2284 | 2021-07-25 | Mariposa | 43 | 485 | 7 | 0 | 0 |
2342 | 2342 | 2021-07-24 | Mariposa | 43 | 485 | 7 | 0 | 0 |
2400 | 2400 | 2021-07-23 | Mariposa | 43 | 485 | 7 | 5 | 0 |
2458 | 2458 | 2021-07-22 | Mariposa | 43 | 480 | 7 | 5 | 0 |
2516 | 2516 | 2021-07-21 | Mariposa | 43 | 475 | 7 | 1 | 0 |
2574 | 2574 | 2021-07-20 | Mariposa | 43 | 474 | 7 | 1 | 0 |
2632 | 2632 | 2021-07-19 | Mariposa | 43 | 473 | 7 | 1 | 0 |
2690 | 2690 | 2021-07-18 | Mariposa | 43 | 472 | 7 | 0 | 0 |
2748 | 2748 | 2021-07-17 | Mariposa | 43 | 472 | 7 | 0 | 0 |
2806 | 2806 | 2021-07-16 | Mariposa | 43 | 472 | 7 | 1 | 0 |
2864 | 2864 | 2021-07-15 | Mariposa | 43 | 471 | 7 | 2 | 0 |
2922 | 2922 | 2021-07-14 | Mariposa | 43 | 469 | 7 | 0 | 0 |
2980 | 2980 | 2021-07-13 | Mariposa | 43 | 469 | 7 | 1 | 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 |
3386 | 3386 | 2021-07-06 | Mariposa | 43 | 468 | 7 | 1 | 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 |
3792 | 3792 | 2021-06-29 | Mariposa | 43 | 467 | 7 | 1 | 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 |
4082 | 4082 | 2021-06-24 | Mariposa | 43 | 466 | 7 | 1 | 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 |
4488 | 4488 | 2021-06-17 | Mariposa | 43 | 465 | 7 | 1 | 0 |
4546 | 4546 | 2021-06-16 | Mariposa | 43 | 464 | 7 | 0 | 0 |
4604 | 4604 | 2021-06-15 | Mariposa | 43 | 464 | 7 | 3 | 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 |
5358 | 5358 | 2021-06-02 | Mariposa | 43 | 461 | 7 | 3 | 0 |
5416 | 5416 | 2021-06-01 | Mariposa | 43 | 458 | 7 | 4 | 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 |
5822 | 5822 | 2021-05-25 | Mariposa | 43 | 454 | 7 | 1 | 0 |
5880 | 5880 | 2021-05-24 | Mariposa | 43 | 453 | 7 | 1 | 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 |
6112 | 6112 | 2021-05-20 | Mariposa | 43 | 452 | 7 | 2 | 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 |
6402 | 6402 | 2021-05-15 | Mariposa | 43 | 450 | 7 | 2 | 0 |
6460 | 6460 | 2021-05-14 | Mariposa | 43 | 448 | 7 | 0 | 0 |
6518 | 6518 | 2021-05-13 | Mariposa | 43 | 448 | 7 | 0 | 0 |
6576 | 6576 | 2021-05-12 | Mariposa | 43 | 448 | 7 | 1 | 0 |
6634 | 6634 | 2021-05-11 | Mariposa | 43 | 447 | 7 | 0 | 0 |
6692 | 6692 | 2021-05-10 | Mariposa | 43 | 447 | 7 | 2 | 0 |
6750 | 6750 | 2021-05-09 | Mariposa | 43 | 445 | 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 );