latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where agency = "Shasta" sorted by did_not_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | agency | county | fips | date | confirmed_cases | deaths | did_not_update ▼ |
---|---|---|---|---|---|---|---|---|
48 | 48 | Shasta | Shasta | 89 | 2021-09-02 | 15889 | 255 | |
109 | 109 | Shasta | Shasta | 89 | 2021-09-01 | 15730 | 254 | |
170 | 170 | Shasta | Shasta | 89 | 2021-08-31 | 15514 | 254 | |
231 | 231 | Shasta | Shasta | 89 | 2021-08-30 | 15353 | 254 | |
414 | 414 | Shasta | Shasta | 89 | 2021-08-27 | 15201 | 252 | |
475 | 475 | Shasta | Shasta | 89 | 2021-08-26 | 15060 | 252 | |
536 | 536 | Shasta | Shasta | 89 | 2021-08-25 | 14881 | 252 | |
597 | 597 | Shasta | Shasta | 89 | 2021-08-24 | 14766 | 252 | |
658 | 658 | Shasta | Shasta | 89 | 2021-08-23 | 14591 | 251 | |
841 | 841 | Shasta | Shasta | 89 | 2021-08-20 | 14322 | 251 | |
902 | 902 | Shasta | Shasta | 89 | 2021-08-19 | 14224 | 251 | |
963 | 963 | Shasta | Shasta | 89 | 2021-08-18 | 14100 | 250 | |
1024 | 1024 | Shasta | Shasta | 89 | 2021-08-17 | 14001 | 247 | |
1085 | 1085 | Shasta | Shasta | 89 | 2021-08-16 | 13917 | 244 | |
1268 | 1268 | Shasta | Shasta | 89 | 2021-08-13 | 13791 | 244 | |
1329 | 1329 | Shasta | Shasta | 89 | 2021-08-12 | 13685 | 244 | |
1390 | 1390 | Shasta | Shasta | 89 | 2021-08-11 | 13604 | 244 | |
1451 | 1451 | Shasta | Shasta | 89 | 2021-08-10 | 13485 | 244 | |
1512 | 1512 | Shasta | Shasta | 89 | 2021-08-09 | 13412 | 243 | |
1695 | 1695 | Shasta | Shasta | 89 | 2021-08-06 | 13382 | 243 | |
1756 | 1756 | Shasta | Shasta | 89 | 2021-08-05 | 13310 | 243 | |
1817 | 1817 | Shasta | Shasta | 89 | 2021-08-04 | 13179 | 242 | |
1878 | 1878 | Shasta | Shasta | 89 | 2021-08-03 | 13119 | 242 | |
1939 | 1939 | Shasta | Shasta | 89 | 2021-08-02 | 13068 | 242 | |
2122 | 2122 | Shasta | Shasta | 89 | 2021-07-30 | 13043 | 242 | |
2183 | 2183 | Shasta | Shasta | 89 | 2021-07-29 | 12963 | 242 | |
2244 | 2244 | Shasta | Shasta | 89 | 2021-07-28 | 12925 | 242 | |
2305 | 2305 | Shasta | Shasta | 89 | 2021-07-27 | 12876 | 242 | |
2366 | 2366 | Shasta | Shasta | 89 | 2021-07-26 | 12845 | 242 | |
2549 | 2549 | Shasta | Shasta | 89 | 2021-07-23 | 12804 | 242 | |
2610 | 2610 | Shasta | Shasta | 89 | 2021-07-22 | 12786 | 242 | |
2671 | 2671 | Shasta | Shasta | 89 | 2021-07-21 | 12766 | 242 | |
2732 | 2732 | Shasta | Shasta | 89 | 2021-07-20 | 12749 | 242 | |
2793 | 2793 | Shasta | Shasta | 89 | 2021-07-19 | 12728 | 242 | |
2915 | 2915 | Shasta | Shasta | 89 | 2021-07-17 | 12693 | 242 | |
2976 | 2976 | Shasta | Shasta | 89 | 2021-07-16 | 12693 | 242 | |
3403 | 3403 | Shasta | Shasta | 89 | 2021-07-09 | 12614 | 238 | |
3464 | 3464 | Shasta | Shasta | 89 | 2021-07-08 | 12605 | 238 | |
4013 | 4013 | Shasta | Shasta | 89 | 2021-06-29 | 12605 | 235 | |
4257 | 4257 | Shasta | Shasta | 89 | 2021-06-25 | 12605 | 235 | |
4318 | 4318 | Shasta | Shasta | 89 | 2021-06-24 | 12605 | 235 | |
4379 | 4379 | Shasta | Shasta | 89 | 2021-06-23 | 12605 | 235 | |
4867 | 4867 | Shasta | Shasta | 89 | 2021-06-15 | 12605 | 233 | |
4928 | 4928 | Shasta | Shasta | 89 | 2021-06-14 | 12599 | 232 | |
5111 | 5111 | Shasta | Shasta | 89 | 2021-06-11 | 12580 | 232 | |
5172 | 5172 | Shasta | Shasta | 89 | 2021-06-10 | 12559 | 232 | |
5233 | 5233 | Shasta | Shasta | 89 | 2021-06-09 | 12539 | 230 | |
5294 | 5294 | Shasta | Shasta | 89 | 2021-06-08 | 12526 | 230 | |
5355 | 5355 | Shasta | Shasta | 89 | 2021-06-07 | 12494 | 230 | |
5538 | 5538 | Shasta | Shasta | 89 | 2021-06-04 | 12467 | 230 | |
5599 | 5599 | Shasta | Shasta | 89 | 2021-06-03 | 12446 | 230 | |
5660 | 5660 | Shasta | Shasta | 89 | 2021-06-02 | 12420 | 230 | |
5721 | 5721 | Shasta | Shasta | 89 | 2021-06-01 | 12420 | 230 | |
5843 | 5843 | Shasta | Shasta | 89 | 2021-05-30 | 12413 | 230 | |
5965 | 5965 | Shasta | Shasta | 89 | 2021-05-28 | 12413 | 230 | |
6026 | 6026 | Shasta | Shasta | 89 | 2021-05-27 | 12409 | 229 | |
6087 | 6087 | Shasta | Shasta | 89 | 2021-05-26 | 12382 | 229 | |
6148 | 6148 | Shasta | Shasta | 89 | 2021-05-25 | 12382 | 228 | |
6209 | 6209 | Shasta | Shasta | 89 | 2021-05-24 | 12360 | 228 | |
6392 | 6392 | Shasta | Shasta | 89 | 2021-05-21 | 12319 | 228 | |
6453 | 6453 | Shasta | Shasta | 89 | 2021-05-20 | 12289 | 226 | |
6514 | 6514 | Shasta | Shasta | 89 | 2021-05-19 | 12252 | 226 | |
6575 | 6575 | Shasta | Shasta | 89 | 2021-05-18 | 12252 | 226 | |
6636 | 6636 | Shasta | Shasta | 89 | 2021-05-17 | 12208 | 226 | |
6819 | 6819 | Shasta | Shasta | 89 | 2021-05-14 | 12175 | 226 | |
6880 | 6880 | Shasta | Shasta | 89 | 2021-05-13 | 12152 | 226 | |
6941 | 6941 | Shasta | Shasta | 89 | 2021-05-12 | 12126 | 226 | |
7002 | 7002 | Shasta | Shasta | 89 | 2021-05-11 | 12126 | 226 | |
7063 | 7063 | Shasta | Shasta | 89 | 2021-05-10 | 12110 | 226 | |
7246 | 7246 | Shasta | Shasta | 89 | 2021-05-07 | 12071 | 226 | |
7307 | 7307 | Shasta | Shasta | 89 | 2021-05-06 | 12042 | 226 | |
7368 | 7368 | Shasta | Shasta | 89 | 2021-05-05 | 11987 | 225 | |
7429 | 7429 | Shasta | Shasta | 89 | 2021-05-04 | 11987 | 224 | |
7490 | 7490 | Shasta | Shasta | 89 | 2021-05-03 | 11936 | 220 | |
7612 | 7612 | Shasta | Shasta | 89 | 2021-05-01 | 11901 | 220 | |
7673 | 7673 | Shasta | Shasta | 89 | 2021-04-30 | 11901 | 220 | |
7734 | 7734 | Shasta | Shasta | 89 | 2021-04-29 | 11880 | 220 | |
7795 | 7795 | Shasta | Shasta | 89 | 2021-04-28 | 11849 | 220 | |
7856 | 7856 | Shasta | Shasta | 89 | 2021-04-27 | 11849 | 220 | |
7917 | 7917 | Shasta | Shasta | 89 | 2021-04-26 | 11830 | 220 | |
8100 | 8100 | Shasta | Shasta | 89 | 2021-04-23 | 11801 | 220 | |
8161 | 8161 | Shasta | Shasta | 89 | 2021-04-22 | 11779 | 219 | |
8222 | 8222 | Shasta | Shasta | 89 | 2021-04-21 | 11743 | 219 | |
8283 | 8283 | Shasta | Shasta | 89 | 2021-04-20 | 11743 | 219 | |
8344 | 8344 | Shasta | Shasta | 89 | 2021-04-19 | 11722 | 218 | |
8527 | 8527 | Shasta | Shasta | 89 | 2021-04-16 | 11677 | 217 | |
8588 | 8588 | Shasta | Shasta | 89 | 2021-04-15 | 11651 | 216 | |
8649 | 8649 | Shasta | Shasta | 89 | 2021-04-14 | 11627 | 216 | |
8710 | 8710 | Shasta | Shasta | 89 | 2021-04-13 | 11570 | 214 | |
8771 | 8771 | Shasta | Shasta | 89 | 2021-04-12 | 11539 | 214 | |
8954 | 8954 | Shasta | Shasta | 89 | 2021-04-09 | 11509 | 213 | |
9076 | 9076 | Shasta | Shasta | 89 | 2021-04-07 | 11480 | 210 | |
9137 | 9137 | Shasta | Shasta | 89 | 2021-04-06 | 11480 | 208 | |
9198 | 9198 | Shasta | Shasta | 89 | 2021-04-05 | 11463 | 208 | |
9381 | 9381 | Shasta | Shasta | 89 | 2021-04-02 | 11399 | 208 | |
9442 | 9442 | Shasta | Shasta | 89 | 2021-04-01 | 11381 | 207 | |
9503 | 9503 | Shasta | Shasta | 89 | 2021-03-31 | 11353 | 207 | |
9564 | 9564 | Shasta | Shasta | 89 | 2021-03-30 | 11353 | 204 | |
9625 | 9625 | Shasta | Shasta | 89 | 2021-03-29 | 11353 | 204 | |
9808 | 9808 | Shasta | Shasta | 89 | 2021-03-26 | 11333 | 202 |
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 );