latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
530 rows where agency = "Merced" and county = "Merced" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
27 | 27 | Merced | Merced | 47 | 2021-09-02 | 37265 | 513 | |
88 | 88 | Merced | Merced | 47 | 2021-09-01 | 37087 | 512 | |
149 | 149 | Merced | Merced | 47 | 2021-08-31 | 36917 | 509 | |
210 | 210 | Merced | Merced | 47 | 2021-08-30 | 36740 | 508 | |
271 | 271 | Merced | Merced | 47 | 2021-08-29 | 36352 | 506 | TRUE |
332 | 332 | Merced | Merced | 47 | 2021-08-28 | 36352 | 506 | TRUE |
393 | 393 | Merced | Merced | 47 | 2021-08-27 | 36352 | 506 | |
454 | 454 | Merced | Merced | 47 | 2021-08-26 | 36113 | 506 | |
515 | 515 | Merced | Merced | 47 | 2021-08-25 | 36001 | 504 | |
576 | 576 | Merced | Merced | 47 | 2021-08-24 | 35820 | 502 | |
637 | 637 | Merced | Merced | 47 | 2021-08-23 | 35648 | 499 | |
698 | 698 | Merced | Merced | 47 | 2021-08-22 | 35485 | 499 | TRUE |
759 | 759 | Merced | Merced | 47 | 2021-08-21 | 35485 | 499 | TRUE |
820 | 820 | Merced | Merced | 47 | 2021-08-20 | 35485 | 499 | |
881 | 881 | Merced | Merced | 47 | 2021-08-19 | 34558 | 492 | TRUE |
942 | 942 | Merced | Merced | 47 | 2021-08-18 | 34558 | 492 | TRUE |
1003 | 1003 | Merced | Merced | 47 | 2021-08-17 | 34558 | 492 | TRUE |
1064 | 1064 | Merced | Merced | 47 | 2021-08-16 | 34558 | 492 | TRUE |
1125 | 1125 | Merced | Merced | 47 | 2021-08-15 | 34558 | 492 | TRUE |
1186 | 1186 | Merced | Merced | 47 | 2021-08-14 | 34558 | 492 | TRUE |
1247 | 1247 | Merced | Merced | 47 | 2021-08-13 | 34558 | 492 | |
1308 | 1308 | Merced | Merced | 47 | 2021-08-12 | 33761 | 488 | TRUE |
1369 | 1369 | Merced | Merced | 47 | 2021-08-11 | 33761 | 488 | TRUE |
1430 | 1430 | Merced | Merced | 47 | 2021-08-10 | 33761 | 488 | TRUE |
1491 | 1491 | Merced | Merced | 47 | 2021-08-09 | 33761 | 488 | TRUE |
1552 | 1552 | Merced | Merced | 47 | 2021-08-08 | 33761 | 488 | TRUE |
1613 | 1613 | Merced | Merced | 47 | 2021-08-07 | 33761 | 488 | TRUE |
1674 | 1674 | Merced | Merced | 47 | 2021-08-06 | 33761 | 488 | |
1735 | 1735 | Merced | Merced | 47 | 2021-08-05 | 33321 | 485 | TRUE |
1796 | 1796 | Merced | Merced | 47 | 2021-08-04 | 33321 | 485 | TRUE |
1857 | 1857 | Merced | Merced | 47 | 2021-08-03 | 33321 | 485 | |
1918 | 1918 | Merced | Merced | 47 | 2021-08-02 | 33321 | 485 | TRUE |
1979 | 1979 | Merced | Merced | 47 | 2021-08-01 | 33321 | 485 | TRUE |
2040 | 2040 | Merced | Merced | 47 | 2021-07-31 | 33321 | 485 | TRUE |
2101 | 2101 | Merced | Merced | 47 | 2021-07-30 | 33321 | 485 | |
2162 | 2162 | Merced | Merced | 47 | 2021-07-29 | 32961 | 484 | TRUE |
2223 | 2223 | Merced | Merced | 47 | 2021-07-28 | 32961 | 484 | TRUE |
2284 | 2284 | Merced | Merced | 47 | 2021-07-27 | 32961 | 484 | TRUE |
2345 | 2345 | Merced | Merced | 47 | 2021-07-26 | 32961 | 484 | TRUE |
2406 | 2406 | Merced | Merced | 47 | 2021-07-25 | 32961 | 484 | TRUE |
2467 | 2467 | Merced | Merced | 47 | 2021-07-24 | 32961 | 484 | TRUE |
2528 | 2528 | Merced | Merced | 47 | 2021-07-23 | 32961 | 484 | |
2589 | 2589 | Merced | Merced | 47 | 2021-07-22 | 32814 | 484 | TRUE |
2650 | 2650 | Merced | Merced | 47 | 2021-07-21 | 32814 | 484 | TRUE |
2711 | 2711 | Merced | Merced | 47 | 2021-07-20 | 32814 | 484 | |
2772 | 2772 | Merced | Merced | 47 | 2021-07-19 | 32782 | 484 | |
2833 | 2833 | Merced | Merced | 47 | 2021-07-18 | 32621 | 483 | TRUE |
2894 | 2894 | Merced | Merced | 47 | 2021-07-17 | 32621 | 483 | TRUE |
2955 | 2955 | Merced | Merced | 47 | 2021-07-16 | 32621 | 483 | |
3016 | 3016 | Merced | Merced | 47 | 2021-07-15 | 32582 | 483 | |
3077 | 3077 | Merced | Merced | 47 | 2021-07-14 | 32541 | 483 | |
3138 | 3138 | Merced | Merced | 47 | 2021-07-13 | 32526 | 483 | |
3199 | 3199 | Merced | Merced | 47 | 2021-07-12 | 32513 | 483 | |
3260 | 3260 | Merced | Merced | 47 | 2021-07-11 | 32479 | 483 | TRUE |
3321 | 3321 | Merced | Merced | 47 | 2021-07-10 | 32479 | 483 | TRUE |
3382 | 3382 | Merced | Merced | 47 | 2021-07-09 | 32479 | 483 | |
3443 | 3443 | Merced | Merced | 47 | 2021-07-08 | 32466 | 482 | |
3504 | 3504 | Merced | Merced | 47 | 2021-07-07 | 32444 | 482 | |
3565 | 3565 | Merced | Merced | 47 | 2021-07-06 | 32437 | 482 | |
3626 | 3626 | Merced | Merced | 47 | 2021-07-05 | 32391 | 482 | TRUE |
3687 | 3687 | Merced | Merced | 47 | 2021-07-04 | 32391 | 482 | TRUE |
3748 | 3748 | Merced | Merced | 47 | 2021-07-03 | 32391 | 482 | TRUE |
3809 | 3809 | Merced | Merced | 47 | 2021-07-02 | 32391 | 482 | |
3870 | 3870 | Merced | Merced | 47 | 2021-07-01 | 32380 | 482 | |
3931 | 3931 | Merced | Merced | 47 | 2021-06-30 | 32369 | 481 | |
3992 | 3992 | Merced | Merced | 47 | 2021-06-29 | 32362 | 481 | |
4053 | 4053 | Merced | Merced | 47 | 2021-06-28 | 32360 | 481 | |
4114 | 4114 | Merced | Merced | 47 | 2021-06-27 | 32335 | 481 | TRUE |
4175 | 4175 | Merced | Merced | 47 | 2021-06-26 | 32335 | 481 | TRUE |
4236 | 4236 | Merced | Merced | 47 | 2021-06-25 | 32335 | 481 | |
4297 | 4297 | Merced | Merced | 47 | 2021-06-24 | 32325 | 481 | |
4358 | 4358 | Merced | Merced | 47 | 2021-06-23 | 32317 | 481 | |
4419 | 4419 | Merced | Merced | 47 | 2021-06-22 | 32315 | 479 | |
4480 | 4480 | Merced | Merced | 47 | 2021-06-21 | 32313 | 478 | |
4541 | 4541 | Merced | Merced | 47 | 2021-06-20 | 32291 | 478 | TRUE |
4602 | 4602 | Merced | Merced | 47 | 2021-06-19 | 32291 | 478 | TRUE |
4663 | 4663 | Merced | Merced | 47 | 2021-06-18 | 32291 | 478 | |
4724 | 4724 | Merced | Merced | 47 | 2021-06-17 | 32284 | 477 | |
4785 | 4785 | Merced | Merced | 47 | 2021-06-16 | 32278 | 477 | |
4846 | 4846 | Merced | Merced | 47 | 2021-06-15 | 32273 | 476 | |
4907 | 4907 | Merced | Merced | 47 | 2021-06-14 | 32272 | 474 | |
4968 | 4968 | Merced | Merced | 47 | 2021-06-13 | 32253 | 474 | TRUE |
5029 | 5029 | Merced | Merced | 47 | 2021-06-12 | 32253 | 474 | TRUE |
5090 | 5090 | Merced | Merced | 47 | 2021-06-11 | 32253 | 474 | |
5151 | 5151 | Merced | Merced | 47 | 2021-06-10 | 32241 | 474 | |
5212 | 5212 | Merced | Merced | 47 | 2021-06-09 | 32234 | 474 | |
5273 | 5273 | Merced | Merced | 47 | 2021-06-08 | 32225 | 473 | |
5334 | 5334 | Merced | Merced | 47 | 2021-06-07 | 32215 | 473 | |
5395 | 5395 | Merced | Merced | 47 | 2021-06-06 | 32193 | 471 | TRUE |
5456 | 5456 | Merced | Merced | 47 | 2021-06-05 | 32193 | 471 | TRUE |
5517 | 5517 | Merced | Merced | 47 | 2021-06-04 | 32193 | 471 | |
5578 | 5578 | Merced | Merced | 47 | 2021-06-03 | 32183 | 471 | |
5639 | 5639 | Merced | Merced | 47 | 2021-06-02 | 32178 | 471 | |
5700 | 5700 | Merced | Merced | 47 | 2021-06-01 | 32168 | 470 | |
5761 | 5761 | Merced | Merced | 47 | 2021-05-31 | 32142 | 469 | TRUE |
5822 | 5822 | Merced | Merced | 47 | 2021-05-30 | 32142 | 469 | |
5883 | 5883 | Merced | Merced | 47 | 2021-05-29 | 32142 | 469 | TRUE |
5944 | 5944 | Merced | Merced | 47 | 2021-05-28 | 32142 | 469 | |
6005 | 6005 | Merced | Merced | 47 | 2021-05-27 | 32110 | 468 | |
6066 | 6066 | Merced | Merced | 47 | 2021-05-26 | 32110 | 468 |
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 );