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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
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 |
6077 | 6077 | 2021-05-21 | Shasta | 89 | 12319 | 228 | 30 | 2 |
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 |
6773 | 6773 | 2021-05-09 | Shasta | 89 | 12071 | 226 | 0 | 0 |
6831 | 6831 | 2021-05-08 | Shasta | 89 | 12071 | 226 | 0 | 0 |
6889 | 6889 | 2021-05-07 | Shasta | 89 | 12071 | 226 | 29 | 0 |
6947 | 6947 | 2021-05-06 | Shasta | 89 | 12042 | 226 | 55 | 1 |
7005 | 7005 | 2021-05-05 | Shasta | 89 | 11987 | 225 | 0 | 1 |
7063 | 7063 | 2021-05-04 | Shasta | 89 | 11987 | 224 | 51 | 4 |
7121 | 7121 | 2021-05-03 | Shasta | 89 | 11936 | 220 | 35 | 0 |
7179 | 7179 | 2021-05-02 | Shasta | 89 | 11901 | 220 | 0 | 0 |
7237 | 7237 | 2021-05-01 | Shasta | 89 | 11901 | 220 | 0 | 0 |
7295 | 7295 | 2021-04-30 | Shasta | 89 | 11901 | 220 | 21 | 0 |
7353 | 7353 | 2021-04-29 | Shasta | 89 | 11880 | 220 | 31 | 0 |
7411 | 7411 | 2021-04-28 | Shasta | 89 | 11849 | 220 | 0 | 0 |
7469 | 7469 | 2021-04-27 | Shasta | 89 | 11849 | 220 | 19 | 0 |
7527 | 7527 | 2021-04-26 | Shasta | 89 | 11830 | 220 | 29 | 0 |
7585 | 7585 | 2021-04-25 | Shasta | 89 | 11801 | 220 | 0 | 0 |
7643 | 7643 | 2021-04-24 | Shasta | 89 | 11801 | 220 | 0 | 0 |
7701 | 7701 | 2021-04-23 | Shasta | 89 | 11801 | 220 | 22 | 1 |
7759 | 7759 | 2021-04-22 | Shasta | 89 | 11779 | 219 | 36 | 0 |
7817 | 7817 | 2021-04-21 | Shasta | 89 | 11743 | 219 | 0 | 0 |
7875 | 7875 | 2021-04-20 | Shasta | 89 | 11743 | 219 | 21 | 1 |
7933 | 7933 | 2021-04-19 | Shasta | 89 | 11722 | 218 | 45 | 1 |
7991 | 7991 | 2021-04-18 | Shasta | 89 | 11677 | 217 | 0 | 0 |
8049 | 8049 | 2021-04-17 | Shasta | 89 | 11677 | 217 | 0 | 0 |
8107 | 8107 | 2021-04-16 | Shasta | 89 | 11677 | 217 | 26 | 1 |
8165 | 8165 | 2021-04-15 | Shasta | 89 | 11651 | 216 | 24 | 0 |
8223 | 8223 | 2021-04-14 | Shasta | 89 | 11627 | 216 | 57 | 2 |
8281 | 8281 | 2021-04-13 | Shasta | 89 | 11570 | 214 | 31 | 0 |
8339 | 8339 | 2021-04-12 | Shasta | 89 | 11539 | 214 | 30 | 1 |
8397 | 8397 | 2021-04-11 | Shasta | 89 | 11509 | 213 | 0 | 0 |
8455 | 8455 | 2021-04-10 | Shasta | 89 | 11509 | 213 | 0 | 0 |
8513 | 8513 | 2021-04-09 | Shasta | 89 | 11509 | 213 | 29 | 3 |
8571 | 8571 | 2021-04-08 | Shasta | 89 | 11480 | 210 | 0 | 0 |
8629 | 8629 | 2021-04-07 | Shasta | 89 | 11480 | 210 | 0 | 2 |
8687 | 8687 | 2021-04-06 | Shasta | 89 | 11480 | 208 | 17 | 0 |
8745 | 8745 | 2021-04-05 | Shasta | 89 | 11463 | 208 | 64 | 0 |
8803 | 8803 | 2021-04-04 | Shasta | 89 | 11399 | 208 | 0 | 0 |
8861 | 8861 | 2021-04-03 | Shasta | 89 | 11399 | 208 | 0 | 0 |
8919 | 8919 | 2021-04-02 | Shasta | 89 | 11399 | 208 | 18 | 1 |
8977 | 8977 | 2021-04-01 | Shasta | 89 | 11381 | 207 | 28 | 0 |
9035 | 9035 | 2021-03-31 | Shasta | 89 | 11353 | 207 | 0 | 3 |
9093 | 9093 | 2021-03-30 | Shasta | 89 | 11353 | 204 | 0 | 0 |
9151 | 9151 | 2021-03-29 | Shasta | 89 | 11353 | 204 | 20 | 2 |
9209 | 9209 | 2021-03-28 | Shasta | 89 | 11333 | 202 | 0 | 0 |
9267 | 9267 | 2021-03-27 | Shasta | 89 | 11333 | 202 | 0 | 0 |
9325 | 9325 | 2021-03-26 | Shasta | 89 | 11333 | 202 | 14 | 2 |
9383 | 9383 | 2021-03-25 | Shasta | 89 | 11319 | 200 | 12 | 0 |
9441 | 9441 | 2021-03-24 | Shasta | 89 | 11307 | 200 | 108 | 0 |
9499 | 9499 | 2021-03-23 | Shasta | 89 | 11199 | 200 | 20 | 1 |
9557 | 9557 | 2021-03-22 | Shasta | 89 | 11179 | 199 | 66 | 4 |
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 |
9789 | 9789 | 2021-03-18 | Shasta | 89 | 11113 | 195 | 29 | 1 |
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 |
10601 | 10601 | 2021-03-04 | Shasta | 89 | 11084 | 179 | 30 | 0 |
10659 | 10659 | 2021-03-03 | Shasta | 89 | 11054 | 179 | 9 | 0 |
10717 | 10717 | 2021-03-02 | Shasta | 89 | 11045 | 179 | 28 | 5 |
10775 | 10775 | 2021-03-01 | Shasta | 89 | 11017 | 174 | 21 | 0 |
10833 | 10833 | 2021-02-28 | Shasta | 89 | 10996 | 174 | 0 | 0 |
10891 | 10891 | 2021-02-27 | Shasta | 89 | 10996 | 174 | 0 | 0 |
10949 | 10949 | 2021-02-26 | Shasta | 89 | 10996 | 174 | 52 | 0 |
11007 | 11007 | 2021-02-25 | Shasta | 89 | 10944 | 174 | 0 | 0 |
11065 | 11065 | 2021-02-24 | Shasta | 89 | 10944 | 174 | 0 | 2 |
11123 | 11123 | 2021-02-23 | Shasta | 89 | 10944 | 172 | 35 | 0 |
11181 | 11181 | 2021-02-22 | Shasta | 89 | 10909 | 172 | 41 | 0 |
11239 | 11239 | 2021-02-21 | Shasta | 89 | 10868 | 172 | 0 | 0 |
11297 | 11297 | 2021-02-20 | Shasta | 89 | 10868 | 172 | 0 | 0 |
11355 | 11355 | 2021-02-19 | Shasta | 89 | 10868 | 172 | 34 | 1 |
11413 | 11413 | 2021-02-18 | Shasta | 89 | 10834 | 171 | 54 | 0 |
11471 | 11471 | 2021-02-17 | Shasta | 89 | 10780 | 171 | 0 | 0 |
11529 | 11529 | 2021-02-16 | Shasta | 89 | 10780 | 171 | 62 | 1 |
11587 | 11587 | 2021-02-15 | Shasta | 89 | 10718 | 170 | 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 );