latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where fips = 89 sorted by new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
277 | 277 | 2021-08-29 | Shasta | 89 | 15201 | 252 | 0 | 0 |
335 | 335 | 2021-08-28 | Shasta | 89 | 15201 | 252 | 0 | 0 |
683 | 683 | 2021-08-22 | Shasta | 89 | 14322 | 251 | 0 | 0 |
741 | 741 | 2021-08-21 | Shasta | 89 | 14322 | 251 | 0 | 0 |
1089 | 1089 | 2021-08-15 | Shasta | 89 | 13791 | 244 | 0 | 0 |
1147 | 1147 | 2021-08-14 | Shasta | 89 | 13791 | 244 | 0 | 0 |
1495 | 1495 | 2021-08-08 | Shasta | 89 | 13382 | 243 | 0 | 0 |
1553 | 1553 | 2021-08-07 | Shasta | 89 | 13382 | 243 | 0 | 0 |
1901 | 1901 | 2021-08-01 | Shasta | 89 | 13043 | 242 | 0 | 0 |
1959 | 1959 | 2021-07-31 | Shasta | 89 | 13043 | 242 | 0 | 0 |
2307 | 2307 | 2021-07-25 | Shasta | 89 | 12804 | 242 | 0 | 0 |
2365 | 2365 | 2021-07-24 | Shasta | 89 | 12804 | 242 | 0 | 0 |
2713 | 2713 | 2021-07-18 | Shasta | 89 | 12693 | 242 | 0 | 0 |
2771 | 2771 | 2021-07-17 | Shasta | 89 | 12693 | 242 | 0 | 0 |
2887 | 2887 | 2021-07-15 | Shasta | 89 | 12614 | 238 | 0 | 0 |
2945 | 2945 | 2021-07-14 | Shasta | 89 | 12614 | 238 | 0 | 0 |
3003 | 3003 | 2021-07-13 | Shasta | 89 | 12614 | 238 | 0 | 0 |
3061 | 3061 | 2021-07-12 | Shasta | 89 | 12614 | 238 | 0 | 0 |
3119 | 3119 | 2021-07-11 | Shasta | 89 | 12614 | 238 | 0 | 0 |
3177 | 3177 | 2021-07-10 | Shasta | 89 | 12614 | 238 | 0 | 0 |
3293 | 3293 | 2021-07-08 | Shasta | 89 | 12605 | 238 | 0 | 3 |
3351 | 3351 | 2021-07-07 | Shasta | 89 | 12605 | 235 | 0 | 0 |
3409 | 3409 | 2021-07-06 | Shasta | 89 | 12605 | 235 | 0 | 0 |
3467 | 3467 | 2021-07-05 | Shasta | 89 | 12605 | 235 | 0 | 0 |
3525 | 3525 | 2021-07-04 | Shasta | 89 | 12605 | 235 | 0 | 0 |
3583 | 3583 | 2021-07-03 | Shasta | 89 | 12605 | 235 | 0 | 0 |
3641 | 3641 | 2021-07-02 | Shasta | 89 | 12605 | 235 | 0 | 0 |
3699 | 3699 | 2021-07-01 | Shasta | 89 | 12605 | 235 | 0 | 0 |
3757 | 3757 | 2021-06-30 | Shasta | 89 | 12605 | 235 | 0 | 0 |
3815 | 3815 | 2021-06-29 | Shasta | 89 | 12605 | 235 | 0 | 0 |
3873 | 3873 | 2021-06-28 | Shasta | 89 | 12605 | 235 | 0 | 0 |
3931 | 3931 | 2021-06-27 | Shasta | 89 | 12605 | 235 | 0 | 0 |
3989 | 3989 | 2021-06-26 | Shasta | 89 | 12605 | 235 | 0 | 0 |
4047 | 4047 | 2021-06-25 | Shasta | 89 | 12605 | 235 | 0 | 0 |
4105 | 4105 | 2021-06-24 | Shasta | 89 | 12605 | 235 | 0 | 0 |
4163 | 4163 | 2021-06-23 | Shasta | 89 | 12605 | 235 | 0 | 0 |
4221 | 4221 | 2021-06-22 | Shasta | 89 | 12605 | 235 | 0 | 2 |
4279 | 4279 | 2021-06-21 | Shasta | 89 | 12605 | 233 | 0 | 0 |
4337 | 4337 | 2021-06-20 | Shasta | 89 | 12605 | 233 | 0 | 0 |
4395 | 4395 | 2021-06-19 | Shasta | 89 | 12605 | 233 | 0 | 0 |
4453 | 4453 | 2021-06-18 | Shasta | 89 | 12605 | 233 | 0 | 0 |
4511 | 4511 | 2021-06-17 | Shasta | 89 | 12605 | 233 | 0 | 0 |
4569 | 4569 | 2021-06-16 | Shasta | 89 | 12605 | 233 | 0 | 0 |
4743 | 4743 | 2021-06-13 | Shasta | 89 | 12580 | 232 | 0 | 0 |
4801 | 4801 | 2021-06-12 | Shasta | 89 | 12580 | 232 | 0 | 0 |
5149 | 5149 | 2021-06-06 | Shasta | 89 | 12467 | 230 | 0 | 0 |
5207 | 5207 | 2021-06-05 | Shasta | 89 | 12467 | 230 | 0 | 0 |
5381 | 5381 | 2021-06-02 | Shasta | 89 | 12420 | 230 | 0 | 0 |
5497 | 5497 | 2021-05-31 | Shasta | 89 | 12413 | 230 | 0 | 0 |
5555 | 5555 | 2021-05-30 | Shasta | 89 | 12413 | 230 | 0 | 0 |
5613 | 5613 | 2021-05-29 | Shasta | 89 | 12413 | 230 | 0 | 0 |
5787 | 5787 | 2021-05-26 | Shasta | 89 | 12382 | 229 | 0 | 1 |
5961 | 5961 | 2021-05-23 | Shasta | 89 | 12319 | 228 | 0 | 0 |
6019 | 6019 | 2021-05-22 | Shasta | 89 | 12319 | 228 | 0 | 0 |
6193 | 6193 | 2021-05-19 | Shasta | 89 | 12252 | 226 | 0 | 0 |
6367 | 6367 | 2021-05-16 | Shasta | 89 | 12175 | 226 | 0 | 0 |
6425 | 6425 | 2021-05-15 | Shasta | 89 | 12175 | 226 | 0 | 0 |
6599 | 6599 | 2021-05-12 | Shasta | 89 | 12126 | 226 | 0 | 0 |
6773 | 6773 | 2021-05-09 | Shasta | 89 | 12071 | 226 | 0 | 0 |
6831 | 6831 | 2021-05-08 | Shasta | 89 | 12071 | 226 | 0 | 0 |
7005 | 7005 | 2021-05-05 | Shasta | 89 | 11987 | 225 | 0 | 1 |
7179 | 7179 | 2021-05-02 | Shasta | 89 | 11901 | 220 | 0 | 0 |
7237 | 7237 | 2021-05-01 | Shasta | 89 | 11901 | 220 | 0 | 0 |
7411 | 7411 | 2021-04-28 | Shasta | 89 | 11849 | 220 | 0 | 0 |
7585 | 7585 | 2021-04-25 | Shasta | 89 | 11801 | 220 | 0 | 0 |
7643 | 7643 | 2021-04-24 | Shasta | 89 | 11801 | 220 | 0 | 0 |
7817 | 7817 | 2021-04-21 | Shasta | 89 | 11743 | 219 | 0 | 0 |
7991 | 7991 | 2021-04-18 | Shasta | 89 | 11677 | 217 | 0 | 0 |
8049 | 8049 | 2021-04-17 | Shasta | 89 | 11677 | 217 | 0 | 0 |
8397 | 8397 | 2021-04-11 | Shasta | 89 | 11509 | 213 | 0 | 0 |
8455 | 8455 | 2021-04-10 | Shasta | 89 | 11509 | 213 | 0 | 0 |
8571 | 8571 | 2021-04-08 | Shasta | 89 | 11480 | 210 | 0 | 0 |
8629 | 8629 | 2021-04-07 | Shasta | 89 | 11480 | 210 | 0 | 2 |
8803 | 8803 | 2021-04-04 | Shasta | 89 | 11399 | 208 | 0 | 0 |
8861 | 8861 | 2021-04-03 | Shasta | 89 | 11399 | 208 | 0 | 0 |
9035 | 9035 | 2021-03-31 | Shasta | 89 | 11353 | 207 | 0 | 3 |
9093 | 9093 | 2021-03-30 | Shasta | 89 | 11353 | 204 | 0 | 0 |
9209 | 9209 | 2021-03-28 | Shasta | 89 | 11333 | 202 | 0 | 0 |
9267 | 9267 | 2021-03-27 | Shasta | 89 | 11333 | 202 | 0 | 0 |
9615 | 9615 | 2021-03-21 | Shasta | 89 | 11113 | 195 | 0 | 0 |
9673 | 9673 | 2021-03-20 | Shasta | 89 | 11113 | 195 | 0 | 0 |
9731 | 9731 | 2021-03-19 | Shasta | 89 | 11113 | 195 | 0 | 0 |
9847 | 9847 | 2021-03-17 | Shasta | 89 | 11084 | 194 | 0 | 0 |
9905 | 9905 | 2021-03-16 | Shasta | 89 | 11084 | 194 | 0 | 2 |
9963 | 9963 | 2021-03-15 | Shasta | 89 | 11084 | 192 | 0 | 2 |
10021 | 10021 | 2021-03-14 | Shasta | 89 | 11084 | 190 | 0 | 0 |
10079 | 10079 | 2021-03-13 | Shasta | 89 | 11084 | 190 | 0 | 0 |
10137 | 10137 | 2021-03-12 | Shasta | 89 | 11084 | 190 | 0 | 2 |
10195 | 10195 | 2021-03-11 | Shasta | 89 | 11084 | 188 | 0 | 6 |
10253 | 10253 | 2021-03-10 | Shasta | 89 | 11084 | 182 | 0 | 3 |
10311 | 10311 | 2021-03-09 | Shasta | 89 | 11084 | 179 | 0 | 0 |
10369 | 10369 | 2021-03-08 | Shasta | 89 | 11084 | 179 | 0 | 0 |
10427 | 10427 | 2021-03-07 | Shasta | 89 | 11084 | 179 | 0 | 0 |
10485 | 10485 | 2021-03-06 | Shasta | 89 | 11084 | 179 | 0 | 0 |
10543 | 10543 | 2021-03-05 | Shasta | 89 | 11084 | 179 | 0 | 0 |
10833 | 10833 | 2021-02-28 | Shasta | 89 | 10996 | 174 | 0 | 0 |
10891 | 10891 | 2021-02-27 | Shasta | 89 | 10996 | 174 | 0 | 0 |
11007 | 11007 | 2021-02-25 | Shasta | 89 | 10944 | 174 | 0 | 0 |
11065 | 11065 | 2021-02-24 | Shasta | 89 | 10944 | 174 | 0 | 2 |
11239 | 11239 | 2021-02-21 | Shasta | 89 | 10868 | 172 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );