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_deaths
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 ▼ |
---|---|---|---|---|---|---|---|---|
103 | 103 | 2021-09-01 | Shasta | 89 | 15730 | 254 | 216 | 0 |
161 | 161 | 2021-08-31 | Shasta | 89 | 15514 | 254 | 161 | 0 |
277 | 277 | 2021-08-29 | Shasta | 89 | 15201 | 252 | 0 | 0 |
335 | 335 | 2021-08-28 | Shasta | 89 | 15201 | 252 | 0 | 0 |
393 | 393 | 2021-08-27 | Shasta | 89 | 15201 | 252 | 141 | 0 |
451 | 451 | 2021-08-26 | Shasta | 89 | 15060 | 252 | 179 | 0 |
509 | 509 | 2021-08-25 | Shasta | 89 | 14881 | 252 | 115 | 0 |
625 | 625 | 2021-08-23 | Shasta | 89 | 14591 | 251 | 269 | 0 |
683 | 683 | 2021-08-22 | Shasta | 89 | 14322 | 251 | 0 | 0 |
741 | 741 | 2021-08-21 | Shasta | 89 | 14322 | 251 | 0 | 0 |
799 | 799 | 2021-08-20 | Shasta | 89 | 14322 | 251 | 98 | 0 |
1031 | 1031 | 2021-08-16 | Shasta | 89 | 13917 | 244 | 126 | 0 |
1089 | 1089 | 2021-08-15 | Shasta | 89 | 13791 | 244 | 0 | 0 |
1147 | 1147 | 2021-08-14 | Shasta | 89 | 13791 | 244 | 0 | 0 |
1205 | 1205 | 2021-08-13 | Shasta | 89 | 13791 | 244 | 106 | 0 |
1263 | 1263 | 2021-08-12 | Shasta | 89 | 13685 | 244 | 81 | 0 |
1321 | 1321 | 2021-08-11 | Shasta | 89 | 13604 | 244 | 119 | 0 |
1437 | 1437 | 2021-08-09 | Shasta | 89 | 13412 | 243 | 30 | 0 |
1495 | 1495 | 2021-08-08 | Shasta | 89 | 13382 | 243 | 0 | 0 |
1553 | 1553 | 2021-08-07 | Shasta | 89 | 13382 | 243 | 0 | 0 |
1611 | 1611 | 2021-08-06 | Shasta | 89 | 13382 | 243 | 72 | 0 |
1727 | 1727 | 2021-08-04 | Shasta | 89 | 13179 | 242 | 60 | 0 |
1785 | 1785 | 2021-08-03 | Shasta | 89 | 13119 | 242 | 51 | 0 |
1843 | 1843 | 2021-08-02 | Shasta | 89 | 13068 | 242 | 25 | 0 |
1901 | 1901 | 2021-08-01 | Shasta | 89 | 13043 | 242 | 0 | 0 |
1959 | 1959 | 2021-07-31 | Shasta | 89 | 13043 | 242 | 0 | 0 |
2017 | 2017 | 2021-07-30 | Shasta | 89 | 13043 | 242 | 80 | 0 |
2075 | 2075 | 2021-07-29 | Shasta | 89 | 12963 | 242 | 38 | 0 |
2133 | 2133 | 2021-07-28 | Shasta | 89 | 12925 | 242 | 49 | 0 |
2191 | 2191 | 2021-07-27 | Shasta | 89 | 12876 | 242 | 31 | 0 |
2249 | 2249 | 2021-07-26 | Shasta | 89 | 12845 | 242 | 41 | 0 |
2307 | 2307 | 2021-07-25 | Shasta | 89 | 12804 | 242 | 0 | 0 |
2365 | 2365 | 2021-07-24 | Shasta | 89 | 12804 | 242 | 0 | 0 |
2423 | 2423 | 2021-07-23 | Shasta | 89 | 12804 | 242 | 18 | 0 |
2481 | 2481 | 2021-07-22 | Shasta | 89 | 12786 | 242 | 20 | 0 |
2539 | 2539 | 2021-07-21 | Shasta | 89 | 12766 | 242 | 17 | 0 |
2597 | 2597 | 2021-07-20 | Shasta | 89 | 12749 | 242 | 21 | 0 |
2655 | 2655 | 2021-07-19 | Shasta | 89 | 12728 | 242 | 35 | 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 |
3235 | 3235 | 2021-07-09 | Shasta | 89 | 12614 | 238 | 9 | 0 |
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 |
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 |
4685 | 4685 | 2021-06-14 | Shasta | 89 | 12599 | 232 | 19 | 0 |
4743 | 4743 | 2021-06-13 | Shasta | 89 | 12580 | 232 | 0 | 0 |
4801 | 4801 | 2021-06-12 | Shasta | 89 | 12580 | 232 | 0 | 0 |
4859 | 4859 | 2021-06-11 | Shasta | 89 | 12580 | 232 | 21 | 0 |
4975 | 4975 | 2021-06-09 | Shasta | 89 | 12539 | 230 | 13 | 0 |
5033 | 5033 | 2021-06-08 | Shasta | 89 | 12526 | 230 | 32 | 0 |
5091 | 5091 | 2021-06-07 | Shasta | 89 | 12494 | 230 | 27 | 0 |
5149 | 5149 | 2021-06-06 | Shasta | 89 | 12467 | 230 | 0 | 0 |
5207 | 5207 | 2021-06-05 | Shasta | 89 | 12467 | 230 | 0 | 0 |
5265 | 5265 | 2021-06-04 | Shasta | 89 | 12467 | 230 | 21 | 0 |
5323 | 5323 | 2021-06-03 | Shasta | 89 | 12446 | 230 | 26 | 0 |
5381 | 5381 | 2021-06-02 | Shasta | 89 | 12420 | 230 | 0 | 0 |
5439 | 5439 | 2021-06-01 | Shasta | 89 | 12420 | 230 | 7 | 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 |
5729 | 5729 | 2021-05-27 | Shasta | 89 | 12409 | 229 | 27 | 0 |
5845 | 5845 | 2021-05-25 | Shasta | 89 | 12382 | 228 | 22 | 0 |
5903 | 5903 | 2021-05-24 | Shasta | 89 | 12360 | 228 | 41 | 0 |
5961 | 5961 | 2021-05-23 | Shasta | 89 | 12319 | 228 | 0 | 0 |
6019 | 6019 | 2021-05-22 | Shasta | 89 | 12319 | 228 | 0 | 0 |
6135 | 6135 | 2021-05-20 | Shasta | 89 | 12289 | 226 | 37 | 0 |
6193 | 6193 | 2021-05-19 | Shasta | 89 | 12252 | 226 | 0 | 0 |
6251 | 6251 | 2021-05-18 | Shasta | 89 | 12252 | 226 | 44 | 0 |
6309 | 6309 | 2021-05-17 | Shasta | 89 | 12208 | 226 | 33 | 0 |
6367 | 6367 | 2021-05-16 | Shasta | 89 | 12175 | 226 | 0 | 0 |
6425 | 6425 | 2021-05-15 | Shasta | 89 | 12175 | 226 | 0 | 0 |
6483 | 6483 | 2021-05-14 | Shasta | 89 | 12175 | 226 | 23 | 0 |
6541 | 6541 | 2021-05-13 | Shasta | 89 | 12152 | 226 | 26 | 0 |
6599 | 6599 | 2021-05-12 | Shasta | 89 | 12126 | 226 | 0 | 0 |
6657 | 6657 | 2021-05-11 | Shasta | 89 | 12126 | 226 | 16 | 0 |
6715 | 6715 | 2021-05-10 | Shasta | 89 | 12110 | 226 | 39 | 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 );