latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
530 rows where fips = 47 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
24 | 24 | 2021-09-02 | Merced | 47 | 37265 | 513 | 178 | 1 |
82 | 82 | 2021-09-01 | Merced | 47 | 37087 | 512 | 170 | 3 |
140 | 140 | 2021-08-31 | Merced | 47 | 36917 | 509 | 177 | 1 |
198 | 198 | 2021-08-30 | Merced | 47 | 36740 | 508 | 388 | 2 |
256 | 256 | 2021-08-29 | Merced | 47 | 36352 | 506 | 0 | 0 |
314 | 314 | 2021-08-28 | Merced | 47 | 36352 | 506 | 0 | 0 |
372 | 372 | 2021-08-27 | Merced | 47 | 36352 | 506 | 239 | 0 |
430 | 430 | 2021-08-26 | Merced | 47 | 36113 | 506 | 112 | 2 |
488 | 488 | 2021-08-25 | Merced | 47 | 36001 | 504 | 181 | 2 |
546 | 546 | 2021-08-24 | Merced | 47 | 35820 | 502 | 172 | 3 |
604 | 604 | 2021-08-23 | Merced | 47 | 35648 | 499 | 163 | 0 |
662 | 662 | 2021-08-22 | Merced | 47 | 35485 | 499 | 0 | 0 |
720 | 720 | 2021-08-21 | Merced | 47 | 35485 | 499 | 0 | 0 |
778 | 778 | 2021-08-20 | Merced | 47 | 35485 | 499 | 927 | 7 |
836 | 836 | 2021-08-19 | Merced | 47 | 34558 | 492 | 0 | 0 |
894 | 894 | 2021-08-18 | Merced | 47 | 34558 | 492 | 0 | 0 |
952 | 952 | 2021-08-17 | Merced | 47 | 34558 | 492 | 0 | 0 |
1010 | 1010 | 2021-08-16 | Merced | 47 | 34558 | 492 | 0 | 0 |
1068 | 1068 | 2021-08-15 | Merced | 47 | 34558 | 492 | 0 | 0 |
1126 | 1126 | 2021-08-14 | Merced | 47 | 34558 | 492 | 0 | 0 |
1184 | 1184 | 2021-08-13 | Merced | 47 | 34558 | 492 | 797 | 4 |
1242 | 1242 | 2021-08-12 | Merced | 47 | 33761 | 488 | 0 | 0 |
1300 | 1300 | 2021-08-11 | Merced | 47 | 33761 | 488 | 0 | 0 |
1358 | 1358 | 2021-08-10 | Merced | 47 | 33761 | 488 | 0 | 0 |
1416 | 1416 | 2021-08-09 | Merced | 47 | 33761 | 488 | 0 | 0 |
1474 | 1474 | 2021-08-08 | Merced | 47 | 33761 | 488 | 0 | 0 |
1532 | 1532 | 2021-08-07 | Merced | 47 | 33761 | 488 | 0 | 0 |
1590 | 1590 | 2021-08-06 | Merced | 47 | 33761 | 488 | 440 | 3 |
1648 | 1648 | 2021-08-05 | Merced | 47 | 33321 | 485 | 0 | 0 |
1706 | 1706 | 2021-08-04 | Merced | 47 | 33321 | 485 | 0 | 0 |
1764 | 1764 | 2021-08-03 | Merced | 47 | 33321 | 485 | 0 | 0 |
1822 | 1822 | 2021-08-02 | Merced | 47 | 33321 | 485 | 0 | 0 |
1880 | 1880 | 2021-08-01 | Merced | 47 | 33321 | 485 | 0 | 0 |
1938 | 1938 | 2021-07-31 | Merced | 47 | 33321 | 485 | 0 | 0 |
1996 | 1996 | 2021-07-30 | Merced | 47 | 33321 | 485 | 360 | 1 |
2054 | 2054 | 2021-07-29 | Merced | 47 | 32961 | 484 | 0 | 0 |
2112 | 2112 | 2021-07-28 | Merced | 47 | 32961 | 484 | 0 | 0 |
2170 | 2170 | 2021-07-27 | Merced | 47 | 32961 | 484 | 0 | 0 |
2228 | 2228 | 2021-07-26 | Merced | 47 | 32961 | 484 | 0 | 0 |
2286 | 2286 | 2021-07-25 | Merced | 47 | 32961 | 484 | 0 | 0 |
2344 | 2344 | 2021-07-24 | Merced | 47 | 32961 | 484 | 0 | 0 |
2402 | 2402 | 2021-07-23 | Merced | 47 | 32961 | 484 | 147 | 0 |
2460 | 2460 | 2021-07-22 | Merced | 47 | 32814 | 484 | 0 | 0 |
2518 | 2518 | 2021-07-21 | Merced | 47 | 32814 | 484 | 0 | 0 |
2576 | 2576 | 2021-07-20 | Merced | 47 | 32814 | 484 | 32 | 0 |
2634 | 2634 | 2021-07-19 | Merced | 47 | 32782 | 484 | 161 | 1 |
2692 | 2692 | 2021-07-18 | Merced | 47 | 32621 | 483 | 0 | 0 |
2750 | 2750 | 2021-07-17 | Merced | 47 | 32621 | 483 | 0 | 0 |
2808 | 2808 | 2021-07-16 | Merced | 47 | 32621 | 483 | 39 | 0 |
2866 | 2866 | 2021-07-15 | Merced | 47 | 32582 | 483 | 41 | 0 |
2924 | 2924 | 2021-07-14 | Merced | 47 | 32541 | 483 | 15 | 0 |
2982 | 2982 | 2021-07-13 | Merced | 47 | 32526 | 483 | 13 | 0 |
3040 | 3040 | 2021-07-12 | Merced | 47 | 32513 | 483 | 34 | 0 |
3098 | 3098 | 2021-07-11 | Merced | 47 | 32479 | 483 | 0 | 0 |
3156 | 3156 | 2021-07-10 | Merced | 47 | 32479 | 483 | 0 | 0 |
3214 | 3214 | 2021-07-09 | Merced | 47 | 32479 | 483 | 13 | 1 |
3272 | 3272 | 2021-07-08 | Merced | 47 | 32466 | 482 | 22 | 0 |
3330 | 3330 | 2021-07-07 | Merced | 47 | 32444 | 482 | 7 | 0 |
3388 | 3388 | 2021-07-06 | Merced | 47 | 32437 | 482 | 46 | 0 |
3446 | 3446 | 2021-07-05 | Merced | 47 | 32391 | 482 | 0 | 0 |
3504 | 3504 | 2021-07-04 | Merced | 47 | 32391 | 482 | 0 | 0 |
3562 | 3562 | 2021-07-03 | Merced | 47 | 32391 | 482 | 0 | 0 |
3620 | 3620 | 2021-07-02 | Merced | 47 | 32391 | 482 | 11 | 0 |
3678 | 3678 | 2021-07-01 | Merced | 47 | 32380 | 482 | 11 | 1 |
3736 | 3736 | 2021-06-30 | Merced | 47 | 32369 | 481 | 7 | 0 |
3794 | 3794 | 2021-06-29 | Merced | 47 | 32362 | 481 | 2 | 0 |
3852 | 3852 | 2021-06-28 | Merced | 47 | 32360 | 481 | 25 | 0 |
3910 | 3910 | 2021-06-27 | Merced | 47 | 32335 | 481 | 0 | 0 |
3968 | 3968 | 2021-06-26 | Merced | 47 | 32335 | 481 | 0 | 0 |
4026 | 4026 | 2021-06-25 | Merced | 47 | 32335 | 481 | 10 | 0 |
4084 | 4084 | 2021-06-24 | Merced | 47 | 32325 | 481 | 8 | 0 |
4142 | 4142 | 2021-06-23 | Merced | 47 | 32317 | 481 | 2 | 2 |
4200 | 4200 | 2021-06-22 | Merced | 47 | 32315 | 479 | 2 | 1 |
4258 | 4258 | 2021-06-21 | Merced | 47 | 32313 | 478 | 22 | 0 |
4316 | 4316 | 2021-06-20 | Merced | 47 | 32291 | 478 | 0 | 0 |
4374 | 4374 | 2021-06-19 | Merced | 47 | 32291 | 478 | 0 | 0 |
4432 | 4432 | 2021-06-18 | Merced | 47 | 32291 | 478 | 7 | 1 |
4490 | 4490 | 2021-06-17 | Merced | 47 | 32284 | 477 | 6 | 0 |
4548 | 4548 | 2021-06-16 | Merced | 47 | 32278 | 477 | 5 | 1 |
4606 | 4606 | 2021-06-15 | Merced | 47 | 32273 | 476 | 1 | 2 |
4664 | 4664 | 2021-06-14 | Merced | 47 | 32272 | 474 | 19 | 0 |
4722 | 4722 | 2021-06-13 | Merced | 47 | 32253 | 474 | 0 | 0 |
4780 | 4780 | 2021-06-12 | Merced | 47 | 32253 | 474 | 0 | 0 |
4838 | 4838 | 2021-06-11 | Merced | 47 | 32253 | 474 | 12 | 0 |
4896 | 4896 | 2021-06-10 | Merced | 47 | 32241 | 474 | 7 | 0 |
4954 | 4954 | 2021-06-09 | Merced | 47 | 32234 | 474 | 9 | 1 |
5012 | 5012 | 2021-06-08 | Merced | 47 | 32225 | 473 | 10 | 0 |
5070 | 5070 | 2021-06-07 | Merced | 47 | 32215 | 473 | 22 | 2 |
5128 | 5128 | 2021-06-06 | Merced | 47 | 32193 | 471 | 0 | 0 |
5186 | 5186 | 2021-06-05 | Merced | 47 | 32193 | 471 | 0 | 0 |
5244 | 5244 | 2021-06-04 | Merced | 47 | 32193 | 471 | 10 | 0 |
5302 | 5302 | 2021-06-03 | Merced | 47 | 32183 | 471 | 5 | 0 |
5360 | 5360 | 2021-06-02 | Merced | 47 | 32178 | 471 | 10 | 1 |
5418 | 5418 | 2021-06-01 | Merced | 47 | 32168 | 470 | 26 | 1 |
5476 | 5476 | 2021-05-31 | Merced | 47 | 32142 | 469 | 0 | 0 |
5534 | 5534 | 2021-05-30 | Merced | 47 | 32142 | 469 | 0 | 0 |
5592 | 5592 | 2021-05-29 | Merced | 47 | 32142 | 469 | 0 | 0 |
5650 | 5650 | 2021-05-28 | Merced | 47 | 32142 | 469 | 32 | 1 |
5708 | 5708 | 2021-05-27 | Merced | 47 | 32110 | 468 | 0 | 0 |
5766 | 5766 | 2021-05-26 | Merced | 47 | 32110 | 468 | 17 | 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 );