latimes_county_totals

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: new_deaths, date (date)

fips 1

  • 89 · 559 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
45 45 2021-09-02 Shasta 89 15889 255 159 1
103 103 2021-09-01 Shasta 89 15730 254 216 0
161 161 2021-08-31 Shasta 89 15514 254 161 0
219 219 2021-08-30 Shasta 89 15353 254 152 2
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
567 567 2021-08-24 Shasta 89 14766 252 175 1
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
857 857 2021-08-19 Shasta 89 14224 251 124 1
915 915 2021-08-18 Shasta 89 14100 250 99 3
973 973 2021-08-17 Shasta 89 14001 247 84 3
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
1379 1379 2021-08-10 Shasta 89 13485 244 73 1
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
1669 1669 2021-08-05 Shasta 89 13310 243 131 1
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
2829 2829 2021-07-16 Shasta 89 12693 242 79 4
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
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
4627 4627 2021-06-15 Shasta 89 12605 233 6 1
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
4917 4917 2021-06-10 Shasta 89 12559 232 20 2
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
5671 5671 2021-05-28 Shasta 89 12413 230 4 1
5729 5729 2021-05-27 Shasta 89 12409 229 27 0
5787 5787 2021-05-26 Shasta 89 12382 229 0 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);