latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where county = "Shasta" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
19019 | 19019 | Shasta | Shasta | 89 | 2020-10-26 | 1881 | 30 | |
19080 | 19080 | Shasta | Shasta | 89 | 2020-10-25 | 1834 | 30 | TRUE |
19141 | 19141 | Shasta | Shasta | 89 | 2020-10-24 | 1834 | 30 | |
19202 | 19202 | Shasta | Shasta | 89 | 2020-10-23 | 1834 | 30 | |
19263 | 19263 | Shasta | Shasta | 89 | 2020-10-22 | 1834 | 30 | |
19324 | 19324 | Shasta | Shasta | 89 | 2020-10-21 | 1786 | 29 | TRUE |
19385 | 19385 | Shasta | Shasta | 89 | 2020-10-20 | 1786 | 29 | |
19446 | 19446 | Shasta | Shasta | 89 | 2020-10-19 | 1723 | 29 | |
19507 | 19507 | Shasta | Shasta | 89 | 2020-10-18 | 1666 | 29 | TRUE |
19568 | 19568 | Shasta | Shasta | 89 | 2020-10-17 | 1666 | 29 | TRUE |
19629 | 19629 | Shasta | Shasta | 89 | 2020-10-16 | 1666 | 29 | |
19690 | 19690 | Shasta | Shasta | 89 | 2020-10-15 | 1640 | 28 | |
19751 | 19751 | Shasta | Shasta | 89 | 2020-10-14 | 1623 | 28 | |
19812 | 19812 | Shasta | Shasta | 89 | 2020-10-13 | 1597 | 25 | |
19873 | 19873 | Shasta | Shasta | 89 | 2020-10-12 | 1343 | 24 | TRUE |
19934 | 19934 | Shasta | Shasta | 89 | 2020-10-11 | 1343 | 24 | TRUE |
19995 | 19995 | Shasta | Shasta | 89 | 2020-10-10 | 1343 | 24 | TRUE |
20056 | 20056 | Shasta | Shasta | 89 | 2020-10-09 | 1343 | 24 | |
20117 | 20117 | Shasta | Shasta | 89 | 2020-10-08 | 1267 | 24 | |
20178 | 20178 | Shasta | Shasta | 89 | 2020-10-07 | 1242 | 22 | |
20239 | 20239 | Shasta | Shasta | 89 | 2020-10-06 | 1158 | 22 | |
20300 | 20300 | Shasta | Shasta | 89 | 2020-10-05 | 1158 | 22 | |
20361 | 20361 | Shasta | Shasta | 89 | 2020-10-04 | 953 | 22 | TRUE |
20422 | 20422 | Shasta | Shasta | 89 | 2020-10-03 | 953 | 22 | TRUE |
20483 | 20483 | Shasta | Shasta | 89 | 2020-10-02 | 953 | 22 | |
20544 | 20544 | Shasta | Shasta | 89 | 2020-10-01 | 927 | 20 | |
20605 | 20605 | Shasta | Shasta | 89 | 2020-09-30 | 894 | 20 | |
20666 | 20666 | Shasta | Shasta | 89 | 2020-09-29 | 875 | 20 | |
20727 | 20727 | Shasta | Shasta | 89 | 2020-09-28 | 847 | 17 | |
20788 | 20788 | Shasta | Shasta | 89 | 2020-09-27 | 777 | 17 | TRUE |
20849 | 20849 | Shasta | Shasta | 89 | 2020-09-26 | 777 | 17 | TRUE |
20910 | 20910 | Shasta | Shasta | 89 | 2020-09-25 | 777 | 17 | |
20971 | 20971 | Shasta | Shasta | 89 | 2020-09-24 | 759 | 16 | |
21032 | 21032 | Shasta | Shasta | 89 | 2020-09-23 | 751 | 14 | |
21093 | 21093 | Shasta | Shasta | 89 | 2020-09-22 | 724 | 14 | |
21154 | 21154 | Shasta | Shasta | 89 | 2020-09-21 | 709 | 14 | |
21215 | 21215 | Shasta | Shasta | 89 | 2020-09-20 | 668 | 14 | TRUE |
21276 | 21276 | Shasta | Shasta | 89 | 2020-09-19 | 668 | 14 | TRUE |
21337 | 21337 | Shasta | Shasta | 89 | 2020-09-18 | 668 | 14 | |
21398 | 21398 | Shasta | Shasta | 89 | 2020-09-17 | 661 | 14 | |
21459 | 21459 | Shasta | Shasta | 89 | 2020-09-16 | 652 | 12 | |
21520 | 21520 | Shasta | Shasta | 89 | 2020-09-15 | 645 | 12 | |
21581 | 21581 | Shasta | Shasta | 89 | 2020-09-14 | 612 | 12 | TRUE |
21642 | 21642 | Shasta | Shasta | 89 | 2020-09-13 | 612 | 12 | TRUE |
21703 | 21703 | Shasta | Shasta | 89 | 2020-09-12 | 612 | 12 | TRUE |
21764 | 21764 | Shasta | Shasta | 89 | 2020-09-11 | 612 | 12 | |
21825 | 21825 | Shasta | Shasta | 89 | 2020-09-10 | 611 | 12 | |
21886 | 21886 | Shasta | Shasta | 89 | 2020-09-09 | 606 | 12 | |
21947 | 21947 | Shasta | Shasta | 89 | 2020-09-08 | 600 | 12 | |
22008 | 22008 | Shasta | Shasta | 89 | 2020-09-07 | 581 | 12 | TRUE |
22069 | 22069 | Shasta | Shasta | 89 | 2020-09-06 | 581 | 12 | TRUE |
22130 | 22130 | Shasta | Shasta | 89 | 2020-09-05 | 581 | 12 | TRUE |
22191 | 22191 | Shasta | Shasta | 89 | 2020-09-04 | 581 | 12 | |
22252 | 22252 | Shasta | Shasta | 89 | 2020-09-03 | 578 | 12 | |
22313 | 22313 | Shasta | Shasta | 89 | 2020-09-02 | 575 | 12 | |
22374 | 22374 | Shasta | Shasta | 89 | 2020-09-01 | 572 | 12 | |
22435 | 22435 | Shasta | Shasta | 89 | 2020-08-31 | 570 | 12 | |
22496 | 22496 | Shasta | Shasta | 89 | 2020-08-30 | 562 | 12 | TRUE |
22557 | 22557 | Shasta | Shasta | 89 | 2020-08-29 | 562 | 12 | TRUE |
22618 | 22618 | Shasta | Shasta | 89 | 2020-08-28 | 562 | 12 | |
22679 | 22679 | Shasta | Shasta | 89 | 2020-08-27 | 557 | 12 | |
22740 | 22740 | Shasta | Shasta | 89 | 2020-08-26 | 554 | 11 | |
22801 | 22801 | Shasta | Shasta | 89 | 2020-08-25 | 553 | 11 | |
22862 | 22862 | Shasta | Shasta | 89 | 2020-08-24 | 545 | 11 | |
22923 | 22923 | Shasta | Shasta | 89 | 2020-08-23 | 531 | 11 | TRUE |
22984 | 22984 | Shasta | Shasta | 89 | 2020-08-22 | 531 | 11 | TRUE |
23045 | 23045 | Shasta | Shasta | 89 | 2020-08-21 | 531 | 11 | |
23106 | 23106 | Shasta | Shasta | 89 | 2020-08-20 | 521 | 11 | |
23167 | 23167 | Shasta | Shasta | 89 | 2020-08-19 | 515 | 11 | |
23228 | 23228 | Shasta | Shasta | 89 | 2020-08-18 | 511 | 11 | |
23289 | 23289 | Shasta | Shasta | 89 | 2020-08-17 | 508 | 11 | |
23350 | 23350 | Shasta | Shasta | 89 | 2020-08-16 | 488 | 10 | TRUE |
23411 | 23411 | Shasta | Shasta | 89 | 2020-08-15 | 488 | 10 | TRUE |
23472 | 23472 | Shasta | Shasta | 89 | 2020-08-14 | 488 | 10 | |
23533 | 23533 | Shasta | Shasta | 89 | 2020-08-13 | 479 | 10 | |
23594 | 23594 | Shasta | Shasta | 89 | 2020-08-12 | 476 | 10 | |
23655 | 23655 | Shasta | Shasta | 89 | 2020-08-11 | 469 | 10 | |
23716 | 23716 | Shasta | Shasta | 89 | 2020-08-10 | 459 | 10 | |
23777 | 23777 | Shasta | Shasta | 89 | 2020-08-09 | 418 | 10 | TRUE |
23838 | 23838 | Shasta | Shasta | 89 | 2020-08-08 | 418 | 10 | TRUE |
23899 | 23899 | Shasta | Shasta | 89 | 2020-08-07 | 418 | 10 | |
23960 | 23960 | Shasta | Shasta | 89 | 2020-08-06 | 411 | 9 | |
24021 | 24021 | Shasta | Shasta | 89 | 2020-08-05 | 404 | 9 | |
24082 | 24082 | Shasta | Shasta | 89 | 2020-08-04 | 397 | 9 | |
24143 | 24143 | Shasta | Shasta | 89 | 2020-08-03 | 390 | 9 | |
24204 | 24204 | Shasta | Shasta | 89 | 2020-08-02 | 369 | 9 | TRUE |
24265 | 24265 | Shasta | Shasta | 89 | 2020-08-01 | 369 | 9 | TRUE |
24326 | 24326 | Shasta | Shasta | 89 | 2020-07-31 | 369 | 9 | |
24387 | 24387 | Shasta | Shasta | 89 | 2020-07-30 | 360 | 9 | |
24448 | 24448 | Shasta | Shasta | 89 | 2020-07-29 | 348 | 8 | |
24509 | 24509 | Shasta | Shasta | 89 | 2020-07-28 | 339 | 8 | |
24570 | 24570 | Shasta | Shasta | 89 | 2020-07-27 | 323 | 8 | |
24631 | 24631 | Shasta | Shasta | 89 | 2020-07-26 | 311 | 8 | |
24692 | 24692 | Shasta | Shasta | 89 | 2020-07-25 | 291 | 8 | TRUE |
24753 | 24753 | Shasta | Shasta | 89 | 2020-07-24 | 291 | 8 | |
24814 | 24814 | Shasta | Shasta | 89 | 2020-07-23 | 276 | 8 | |
24875 | 24875 | Shasta | Shasta | 89 | 2020-07-22 | 268 | 7 | |
24936 | 24936 | Shasta | Shasta | 89 | 2020-07-21 | 255 | 7 | |
24997 | 24997 | Shasta | Shasta | 89 | 2020-07-20 | 250 | 7 | |
25058 | 25058 | Shasta | Shasta | 89 | 2020-07-19 | 242 | 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 );