latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
150 rows where did_not_update = "TRUE" and fips = 89 sorted by date descending
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 |
---|---|---|---|---|---|---|---|---|
292 | 292 | Shasta | Shasta | 89 | 2021-08-29 | 15201 | 252 | TRUE |
353 | 353 | Shasta | Shasta | 89 | 2021-08-28 | 15201 | 252 | TRUE |
719 | 719 | Shasta | Shasta | 89 | 2021-08-22 | 14322 | 251 | TRUE |
780 | 780 | Shasta | Shasta | 89 | 2021-08-21 | 14322 | 251 | TRUE |
1146 | 1146 | Shasta | Shasta | 89 | 2021-08-15 | 13791 | 244 | TRUE |
1207 | 1207 | Shasta | Shasta | 89 | 2021-08-14 | 13791 | 244 | TRUE |
1573 | 1573 | Shasta | Shasta | 89 | 2021-08-08 | 13382 | 243 | TRUE |
1634 | 1634 | Shasta | Shasta | 89 | 2021-08-07 | 13382 | 243 | TRUE |
2000 | 2000 | Shasta | Shasta | 89 | 2021-08-01 | 13043 | 242 | TRUE |
2061 | 2061 | Shasta | Shasta | 89 | 2021-07-31 | 13043 | 242 | TRUE |
2427 | 2427 | Shasta | Shasta | 89 | 2021-07-25 | 12804 | 242 | TRUE |
2488 | 2488 | Shasta | Shasta | 89 | 2021-07-24 | 12804 | 242 | TRUE |
2854 | 2854 | Shasta | Shasta | 89 | 2021-07-18 | 12693 | 242 | TRUE |
3037 | 3037 | Shasta | Shasta | 89 | 2021-07-15 | 12614 | 238 | TRUE |
3098 | 3098 | Shasta | Shasta | 89 | 2021-07-14 | 12614 | 238 | TRUE |
3159 | 3159 | Shasta | Shasta | 89 | 2021-07-13 | 12614 | 238 | TRUE |
3220 | 3220 | Shasta | Shasta | 89 | 2021-07-12 | 12614 | 238 | TRUE |
3281 | 3281 | Shasta | Shasta | 89 | 2021-07-11 | 12614 | 238 | TRUE |
3342 | 3342 | Shasta | Shasta | 89 | 2021-07-10 | 12614 | 238 | TRUE |
3525 | 3525 | Shasta | Shasta | 89 | 2021-07-07 | 12605 | 235 | TRUE |
3586 | 3586 | Shasta | Shasta | 89 | 2021-07-06 | 12605 | 235 | TRUE |
3647 | 3647 | Shasta | Shasta | 89 | 2021-07-05 | 12605 | 235 | TRUE |
3708 | 3708 | Shasta | Shasta | 89 | 2021-07-04 | 12605 | 235 | TRUE |
3769 | 3769 | Shasta | Shasta | 89 | 2021-07-03 | 12605 | 235 | TRUE |
3830 | 3830 | Shasta | Shasta | 89 | 2021-07-02 | 12605 | 235 | TRUE |
3891 | 3891 | Shasta | Shasta | 89 | 2021-07-01 | 12605 | 235 | TRUE |
3952 | 3952 | Shasta | Shasta | 89 | 2021-06-30 | 12605 | 235 | TRUE |
4074 | 4074 | Shasta | Shasta | 89 | 2021-06-28 | 12605 | 235 | TRUE |
4135 | 4135 | Shasta | Shasta | 89 | 2021-06-27 | 12605 | 235 | TRUE |
4196 | 4196 | Shasta | Shasta | 89 | 2021-06-26 | 12605 | 235 | TRUE |
4440 | 4440 | Shasta | Shasta | 89 | 2021-06-22 | 12605 | 235 | TRUE |
4501 | 4501 | Shasta | Shasta | 89 | 2021-06-21 | 12605 | 233 | TRUE |
4562 | 4562 | Shasta | Shasta | 89 | 2021-06-20 | 12605 | 233 | TRUE |
4623 | 4623 | Shasta | Shasta | 89 | 2021-06-19 | 12605 | 233 | TRUE |
4684 | 4684 | Shasta | Shasta | 89 | 2021-06-18 | 12605 | 233 | TRUE |
4745 | 4745 | Shasta | Shasta | 89 | 2021-06-17 | 12605 | 233 | TRUE |
4806 | 4806 | Shasta | Shasta | 89 | 2021-06-16 | 12605 | 233 | TRUE |
4989 | 4989 | Shasta | Shasta | 89 | 2021-06-13 | 12580 | 232 | TRUE |
5050 | 5050 | Shasta | Shasta | 89 | 2021-06-12 | 12580 | 232 | TRUE |
5416 | 5416 | Shasta | Shasta | 89 | 2021-06-06 | 12467 | 230 | TRUE |
5477 | 5477 | Shasta | Shasta | 89 | 2021-06-05 | 12467 | 230 | TRUE |
5782 | 5782 | Shasta | Shasta | 89 | 2021-05-31 | 12413 | 230 | TRUE |
5904 | 5904 | Shasta | Shasta | 89 | 2021-05-29 | 12413 | 230 | TRUE |
6270 | 6270 | Shasta | Shasta | 89 | 2021-05-23 | 12319 | 228 | TRUE |
6331 | 6331 | Shasta | Shasta | 89 | 2021-05-22 | 12319 | 228 | TRUE |
6697 | 6697 | Shasta | Shasta | 89 | 2021-05-16 | 12175 | 226 | TRUE |
6758 | 6758 | Shasta | Shasta | 89 | 2021-05-15 | 12175 | 226 | TRUE |
7124 | 7124 | Shasta | Shasta | 89 | 2021-05-09 | 12071 | 226 | TRUE |
7185 | 7185 | Shasta | Shasta | 89 | 2021-05-08 | 12071 | 226 | TRUE |
7551 | 7551 | Shasta | Shasta | 89 | 2021-05-02 | 11901 | 220 | TRUE |
7978 | 7978 | Shasta | Shasta | 89 | 2021-04-25 | 11801 | 220 | TRUE |
8039 | 8039 | Shasta | Shasta | 89 | 2021-04-24 | 11801 | 220 | TRUE |
8405 | 8405 | Shasta | Shasta | 89 | 2021-04-18 | 11677 | 217 | TRUE |
8466 | 8466 | Shasta | Shasta | 89 | 2021-04-17 | 11677 | 217 | TRUE |
8832 | 8832 | Shasta | Shasta | 89 | 2021-04-11 | 11509 | 213 | TRUE |
8893 | 8893 | Shasta | Shasta | 89 | 2021-04-10 | 11509 | 213 | TRUE |
9015 | 9015 | Shasta | Shasta | 89 | 2021-04-08 | 11480 | 210 | TRUE |
9259 | 9259 | Shasta | Shasta | 89 | 2021-04-04 | 11399 | 208 | TRUE |
9320 | 9320 | Shasta | Shasta | 89 | 2021-04-03 | 11399 | 208 | TRUE |
9686 | 9686 | Shasta | Shasta | 89 | 2021-03-28 | 11333 | 202 | TRUE |
9747 | 9747 | Shasta | Shasta | 89 | 2021-03-27 | 11333 | 202 | TRUE |
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 |
10540 | 10540 | Shasta | Shasta | 89 | 2021-03-14 | 11084 | 190 | TRUE |
10601 | 10601 | Shasta | Shasta | 89 | 2021-03-13 | 11084 | 190 | TRUE |
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 |
11394 | 11394 | Shasta | Shasta | 89 | 2021-02-28 | 10996 | 174 | TRUE |
11821 | 11821 | Shasta | Shasta | 89 | 2021-02-21 | 10868 | 172 | TRUE |
11882 | 11882 | Shasta | Shasta | 89 | 2021-02-20 | 10868 | 172 | TRUE |
12187 | 12187 | Shasta | Shasta | 89 | 2021-02-15 | 10718 | 170 | TRUE |
12248 | 12248 | Shasta | Shasta | 89 | 2021-02-14 | 10718 | 170 | TRUE |
12309 | 12309 | Shasta | Shasta | 89 | 2021-02-13 | 10718 | 170 | TRUE |
12370 | 12370 | Shasta | Shasta | 89 | 2021-02-12 | 10718 | 170 | TRUE |
12675 | 12675 | Shasta | Shasta | 89 | 2021-02-07 | 10632 | 161 | TRUE |
12736 | 12736 | Shasta | Shasta | 89 | 2021-02-06 | 10632 | 161 | TRUE |
13102 | 13102 | Shasta | Shasta | 89 | 2021-01-31 | 10333 | 142 | TRUE |
13163 | 13163 | Shasta | Shasta | 89 | 2021-01-30 | 10333 | 142 | TRUE |
13529 | 13529 | Shasta | Shasta | 89 | 2021-01-24 | 9920 | 129 | TRUE |
13590 | 13590 | Shasta | Shasta | 89 | 2021-01-23 | 9920 | 129 | TRUE |
13895 | 13895 | Shasta | Shasta | 89 | 2021-01-18 | 9594 | 117 | TRUE |
13956 | 13956 | Shasta | Shasta | 89 | 2021-01-17 | 9594 | 117 | TRUE |
14017 | 14017 | Shasta | Shasta | 89 | 2021-01-16 | 9594 | 117 | TRUE |
14383 | 14383 | Shasta | Shasta | 89 | 2021-01-10 | 8917 | 99 | TRUE |
14444 | 14444 | Shasta | Shasta | 89 | 2021-01-09 | 8917 | 99 | TRUE |
14810 | 14810 | Shasta | Shasta | 89 | 2021-01-03 | 8060 | 78 | TRUE |
14871 | 14871 | Shasta | Shasta | 89 | 2021-01-02 | 8060 | 78 | TRUE |
14932 | 14932 | Shasta | Shasta | 89 | 2021-01-01 | 8060 | 78 | TRUE |
15237 | 15237 | Shasta | Shasta | 89 | 2020-12-27 | 7567 | 70 | TRUE |
15298 | 15298 | Shasta | Shasta | 89 | 2020-12-26 | 7567 | 70 | TRUE |
15359 | 15359 | Shasta | Shasta | 89 | 2020-12-25 | 7567 | 70 | TRUE |
15664 | 15664 | Shasta | Shasta | 89 | 2020-12-20 | 7121 | 66 | TRUE |
15725 | 15725 | Shasta | Shasta | 89 | 2020-12-19 | 7121 | 66 | TRUE |
16091 | 16091 | Shasta | Shasta | 89 | 2020-12-13 | 6777 | 58 | TRUE |
16152 | 16152 | Shasta | Shasta | 89 | 2020-12-12 | 6777 | 58 | TRUE |
16518 | 16518 | Shasta | Shasta | 89 | 2020-12-06 | 5490 | 53 | TRUE |
16579 | 16579 | Shasta | Shasta | 89 | 2020-12-05 | 5490 | 53 | TRUE |
16945 | 16945 | Shasta | Shasta | 89 | 2020-11-29 | 4718 | 47 | 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 );