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 |
---|---|---|---|---|---|---|---|---|
6148 | 6148 | Shasta | Shasta | 89 | 2021-05-25 | 12382 | 228 | |
6209 | 6209 | Shasta | Shasta | 89 | 2021-05-24 | 12360 | 228 | |
6270 | 6270 | Shasta | Shasta | 89 | 2021-05-23 | 12319 | 228 | TRUE |
6331 | 6331 | Shasta | Shasta | 89 | 2021-05-22 | 12319 | 228 | TRUE |
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 | |
6697 | 6697 | Shasta | Shasta | 89 | 2021-05-16 | 12175 | 226 | TRUE |
6758 | 6758 | Shasta | Shasta | 89 | 2021-05-15 | 12175 | 226 | TRUE |
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 | |
7124 | 7124 | Shasta | Shasta | 89 | 2021-05-09 | 12071 | 226 | TRUE |
7185 | 7185 | Shasta | Shasta | 89 | 2021-05-08 | 12071 | 226 | TRUE |
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 | |
7551 | 7551 | Shasta | Shasta | 89 | 2021-05-02 | 11901 | 220 | TRUE |
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 | |
7978 | 7978 | Shasta | Shasta | 89 | 2021-04-25 | 11801 | 220 | TRUE |
8039 | 8039 | Shasta | Shasta | 89 | 2021-04-24 | 11801 | 220 | TRUE |
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 | |
8405 | 8405 | Shasta | Shasta | 89 | 2021-04-18 | 11677 | 217 | TRUE |
8466 | 8466 | Shasta | Shasta | 89 | 2021-04-17 | 11677 | 217 | TRUE |
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 | |
8832 | 8832 | Shasta | Shasta | 89 | 2021-04-11 | 11509 | 213 | TRUE |
8893 | 8893 | Shasta | Shasta | 89 | 2021-04-10 | 11509 | 213 | TRUE |
8954 | 8954 | Shasta | Shasta | 89 | 2021-04-09 | 11509 | 213 | |
9015 | 9015 | Shasta | Shasta | 89 | 2021-04-08 | 11480 | 210 | TRUE |
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 | |
9259 | 9259 | Shasta | Shasta | 89 | 2021-04-04 | 11399 | 208 | TRUE |
9320 | 9320 | Shasta | Shasta | 89 | 2021-04-03 | 11399 | 208 | TRUE |
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 | |
9686 | 9686 | Shasta | Shasta | 89 | 2021-03-28 | 11333 | 202 | TRUE |
9747 | 9747 | Shasta | Shasta | 89 | 2021-03-27 | 11333 | 202 | TRUE |
9808 | 9808 | Shasta | Shasta | 89 | 2021-03-26 | 11333 | 202 | |
9869 | 9869 | Shasta | Shasta | 89 | 2021-03-25 | 11319 | 200 | |
9930 | 9930 | Shasta | Shasta | 89 | 2021-03-24 | 11307 | 200 | |
9991 | 9991 | Shasta | Shasta | 89 | 2021-03-23 | 11199 | 200 | |
10052 | 10052 | Shasta | Shasta | 89 | 2021-03-22 | 11179 | 199 | |
10113 | 10113 | Shasta | Shasta | 89 | 2021-03-21 | 11113 | 195 | TRUE |
10174 | 10174 | Shasta | Shasta | 89 | 2021-03-20 | 11113 | 195 | TRUE |
10235 | 10235 | Shasta | Shasta | 89 | 2021-03-19 | 11113 | 195 | TRUE |
10296 | 10296 | Shasta | Shasta | 89 | 2021-03-18 | 11113 | 195 | |
10357 | 10357 | Shasta | Shasta | 89 | 2021-03-17 | 11084 | 194 | |
10418 | 10418 | Shasta | Shasta | 89 | 2021-03-16 | 11084 | 194 | |
10479 | 10479 | Shasta | Shasta | 89 | 2021-03-15 | 11084 | 192 | |
10540 | 10540 | Shasta | Shasta | 89 | 2021-03-14 | 11084 | 190 | TRUE |
10601 | 10601 | Shasta | Shasta | 89 | 2021-03-13 | 11084 | 190 | TRUE |
10662 | 10662 | Shasta | Shasta | 89 | 2021-03-12 | 11084 | 190 | |
10723 | 10723 | Shasta | Shasta | 89 | 2021-03-11 | 11084 | 188 | |
10784 | 10784 | Shasta | Shasta | 89 | 2021-03-10 | 11084 | 182 | |
10845 | 10845 | Shasta | Shasta | 89 | 2021-03-09 | 11084 | 179 | |
10906 | 10906 | Shasta | Shasta | 89 | 2021-03-08 | 11084 | 179 | TRUE |
10967 | 10967 | Shasta | Shasta | 89 | 2021-03-07 | 11084 | 179 | TRUE |
11028 | 11028 | Shasta | Shasta | 89 | 2021-03-06 | 11084 | 179 | TRUE |
11089 | 11089 | Shasta | Shasta | 89 | 2021-03-05 | 11084 | 179 | |
11150 | 11150 | Shasta | Shasta | 89 | 2021-03-04 | 11084 | 179 | |
11211 | 11211 | Shasta | Shasta | 89 | 2021-03-03 | 11054 | 179 | |
11272 | 11272 | Shasta | Shasta | 89 | 2021-03-02 | 11045 | 179 | |
11333 | 11333 | Shasta | Shasta | 89 | 2021-03-01 | 11017 | 174 | |
11394 | 11394 | Shasta | Shasta | 89 | 2021-02-28 | 10996 | 174 | TRUE |
11455 | 11455 | Shasta | Shasta | 89 | 2021-02-27 | 10996 | 174 | |
11516 | 11516 | Shasta | Shasta | 89 | 2021-02-26 | 10996 | 174 | |
11577 | 11577 | Shasta | Shasta | 89 | 2021-02-25 | 10944 | 174 | |
11638 | 11638 | Shasta | Shasta | 89 | 2021-02-24 | 10944 | 174 | |
11699 | 11699 | Shasta | Shasta | 89 | 2021-02-23 | 10944 | 172 | |
11760 | 11760 | Shasta | Shasta | 89 | 2021-02-22 | 10909 | 172 | |
11821 | 11821 | Shasta | Shasta | 89 | 2021-02-21 | 10868 | 172 | TRUE |
11882 | 11882 | Shasta | Shasta | 89 | 2021-02-20 | 10868 | 172 | TRUE |
11943 | 11943 | Shasta | Shasta | 89 | 2021-02-19 | 10868 | 172 | |
12004 | 12004 | Shasta | Shasta | 89 | 2021-02-18 | 10834 | 171 | |
12065 | 12065 | Shasta | Shasta | 89 | 2021-02-17 | 10780 | 171 | |
12126 | 12126 | Shasta | Shasta | 89 | 2021-02-16 | 10780 | 171 | |
12187 | 12187 | Shasta | Shasta | 89 | 2021-02-15 | 10718 | 170 | TRUE |
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 );