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 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 |
---|---|---|---|---|---|---|---|---|
30919 | 30919 | 2020-03-07 | Shasta | 89 | 0 | 0 | 0 | 0 |
30943 | 30943 | 2020-03-06 | Shasta | 89 | 0 | 0 | 0 | 0 |
30967 | 30967 | 2020-03-05 | Shasta | 89 | 0 | 0 | 0 | 0 |
30991 | 30991 | 2020-03-04 | Shasta | 89 | 0 | 0 | 0 | 0 |
31015 | 31015 | 2020-03-03 | Shasta | 89 | 0 | 0 | 0 | 0 |
31039 | 31039 | 2020-03-02 | Shasta | 89 | 0 | 0 | 0 | 0 |
31063 | 31063 | 2020-03-01 | Shasta | 89 | 0 | 0 | 0 | 0 |
31086 | 31086 | 2020-02-29 | Shasta | 89 | 0 | 0 | 0 | 0 |
31109 | 31109 | 2020-02-28 | Shasta | 89 | 0 | 0 | 0 | 0 |
31140 | 31140 | 2020-02-26 | Shasta | 89 | 0 | 0 | 0 | 0 |
31186 | 31186 | 2020-02-21 | Shasta | 89 | 0 | 0 | 0 | 0 |
31208 | 31208 | 2020-02-20 | Shasta | 89 | 0 | 0 | 0 | 0 |
31298 | 31298 | 2020-02-02 | Shasta | 89 | 0 | 0 | 0 | 0 |
31323 | 31323 | 2020-01-31 | Shasta | 89 | 0 | 0 | 0 | 0 |
31357 | 31357 | 2020-01-26 | Shasta | 89 | 0 | 0 | ||
30502 | 30502 | 2020-03-21 | Shasta | 89 | 1 | 0 | 0 | 0 |
30540 | 30540 | 2020-03-20 | Shasta | 89 | 1 | 0 | 0 | 0 |
30575 | 30575 | 2020-03-19 | Shasta | 89 | 1 | 0 | 0 | 0 |
30610 | 30610 | 2020-03-18 | Shasta | 89 | 1 | 0 | 0 | 0 |
30644 | 30644 | 2020-03-17 | Shasta | 89 | 1 | 0 | 0 | 0 |
30676 | 30676 | 2020-03-16 | Shasta | 89 | 1 | 0 | 0 | 0 |
30707 | 30707 | 2020-03-15 | Shasta | 89 | 1 | 0 | 0 | 0 |
30736 | 30736 | 2020-03-14 | Shasta | 89 | 1 | 0 | 0 | 0 |
30764 | 30764 | 2020-03-13 | Shasta | 89 | 1 | 0 | 0 | 0 |
30791 | 30791 | 2020-03-12 | Shasta | 89 | 1 | 0 | 0 | 0 |
30818 | 30818 | 2020-03-11 | Shasta | 89 | 1 | 0 | 0 | 0 |
30844 | 30844 | 2020-03-10 | Shasta | 89 | 1 | 0 | 0 | 0 |
30869 | 30869 | 2020-03-09 | Shasta | 89 | 1 | 0 | 0 | 0 |
30894 | 30894 | 2020-03-08 | Shasta | 89 | 1 | 0 | 1 | 0 |
30462 | 30462 | 2020-03-22 | Shasta | 89 | 2 | 0 | 1 | 0 |
30247 | 30247 | 2020-03-27 | Shasta | 89 | 3 | 1 | 0 | 0 |
30291 | 30291 | 2020-03-26 | Shasta | 89 | 3 | 1 | 0 | 0 |
30335 | 30335 | 2020-03-25 | Shasta | 89 | 3 | 1 | 0 | 1 |
30378 | 30378 | 2020-03-24 | Shasta | 89 | 3 | 0 | 0 | 0 |
30420 | 30420 | 2020-03-23 | Shasta | 89 | 3 | 0 | 1 | 0 |
30153 | 30153 | 2020-03-29 | Shasta | 89 | 4 | 1 | 0 | 0 |
30200 | 30200 | 2020-03-28 | Shasta | 89 | 4 | 1 | 1 | 0 |
30105 | 30105 | 2020-03-30 | Shasta | 89 | 6 | 1 | 2 | 0 |
30005 | 30005 | 2020-04-01 | Shasta | 89 | 7 | 1 | 0 | 0 |
30056 | 30056 | 2020-03-31 | Shasta | 89 | 7 | 1 | 1 | 0 |
29954 | 29954 | 2020-04-02 | Shasta | 89 | 11 | 1 | 4 | 0 |
29902 | 29902 | 2020-04-03 | Shasta | 89 | 12 | 2 | 1 | 1 |
29850 | 29850 | 2020-04-04 | Shasta | 89 | 17 | 2 | 5 | 0 |
29798 | 29798 | 2020-04-05 | Shasta | 89 | 20 | 3 | 3 | 1 |
29745 | 29745 | 2020-04-06 | Shasta | 89 | 21 | 3 | 1 | 0 |
29692 | 29692 | 2020-04-07 | Shasta | 89 | 23 | 3 | 2 | 0 |
29427 | 29427 | 2020-04-12 | Shasta | 89 | 24 | 3 | 0 | 0 |
29480 | 29480 | 2020-04-11 | Shasta | 89 | 24 | 3 | 0 | 0 |
29533 | 29533 | 2020-04-10 | Shasta | 89 | 24 | 3 | 0 | 0 |
29586 | 29586 | 2020-04-09 | Shasta | 89 | 24 | 3 | 0 | 0 |
29639 | 29639 | 2020-04-08 | Shasta | 89 | 24 | 3 | 1 | 0 |
29268 | 29268 | 2020-04-15 | Shasta | 89 | 25 | 3 | 0 | 0 |
29321 | 29321 | 2020-04-14 | Shasta | 89 | 25 | 3 | 0 | 0 |
29374 | 29374 | 2020-04-13 | Shasta | 89 | 25 | 3 | 1 | 0 |
28950 | 28950 | 2020-04-21 | Shasta | 89 | 26 | 3 | 0 | 0 |
29003 | 29003 | 2020-04-20 | Shasta | 89 | 26 | 3 | 0 | 0 |
29056 | 29056 | 2020-04-19 | Shasta | 89 | 26 | 3 | 0 | 0 |
29109 | 29109 | 2020-04-18 | Shasta | 89 | 26 | 3 | 0 | 0 |
29162 | 29162 | 2020-04-17 | Shasta | 89 | 26 | 3 | 0 | 0 |
29215 | 29215 | 2020-04-16 | Shasta | 89 | 26 | 3 | 1 | 0 |
28897 | 28897 | 2020-04-22 | Shasta | 89 | 27 | 3 | 1 | 0 |
28844 | 28844 | 2020-04-23 | Shasta | 89 | 28 | 3 | 1 | 0 |
28632 | 28632 | 2020-04-27 | Shasta | 89 | 30 | 4 | 0 | 0 |
28685 | 28685 | 2020-04-26 | Shasta | 89 | 30 | 4 | 0 | 0 |
28738 | 28738 | 2020-04-25 | Shasta | 89 | 30 | 4 | 0 | 0 |
28791 | 28791 | 2020-04-24 | Shasta | 89 | 30 | 4 | 2 | 1 |
27885 | 27885 | 2020-05-10 | Shasta | 89 | 31 | 4 | 0 | 0 |
27943 | 27943 | 2020-05-09 | Shasta | 89 | 31 | 4 | 0 | 0 |
28001 | 28001 | 2020-05-08 | Shasta | 89 | 31 | 4 | 0 | 0 |
28059 | 28059 | 2020-05-07 | Shasta | 89 | 31 | 4 | 0 | 0 |
28117 | 28117 | 2020-05-06 | Shasta | 89 | 31 | 4 | 0 | 0 |
28175 | 28175 | 2020-05-05 | Shasta | 89 | 31 | 4 | 0 | 0 |
28233 | 28233 | 2020-05-04 | Shasta | 89 | 31 | 4 | 0 | 0 |
28291 | 28291 | 2020-05-03 | Shasta | 89 | 31 | 4 | 0 | 0 |
28349 | 28349 | 2020-05-02 | Shasta | 89 | 31 | 4 | 0 | 0 |
28407 | 28407 | 2020-05-01 | Shasta | 89 | 31 | 4 | 0 | 0 |
28465 | 28465 | 2020-04-30 | Shasta | 89 | 31 | 4 | 0 | 0 |
28523 | 28523 | 2020-04-29 | Shasta | 89 | 31 | 4 | 0 | 0 |
28579 | 28579 | 2020-04-28 | Shasta | 89 | 31 | 4 | 1 | 0 |
27711 | 27711 | 2020-05-13 | Shasta | 89 | 32 | 4 | 0 | 0 |
27769 | 27769 | 2020-05-12 | Shasta | 89 | 32 | 4 | 0 | 0 |
27827 | 27827 | 2020-05-11 | Shasta | 89 | 32 | 4 | 1 | 0 |
27595 | 27595 | 2020-05-15 | Shasta | 89 | 33 | 4 | 0 | 0 |
27653 | 27653 | 2020-05-14 | Shasta | 89 | 33 | 4 | 1 | 0 |
27247 | 27247 | 2020-05-21 | Shasta | 89 | 34 | 4 | 0 | 0 |
27305 | 27305 | 2020-05-20 | Shasta | 89 | 34 | 4 | 0 | 0 |
27363 | 27363 | 2020-05-19 | Shasta | 89 | 34 | 4 | 0 | 0 |
27421 | 27421 | 2020-05-18 | Shasta | 89 | 34 | 4 | 0 | 0 |
27479 | 27479 | 2020-05-17 | Shasta | 89 | 34 | 4 | 0 | 0 |
27537 | 27537 | 2020-05-16 | Shasta | 89 | 34 | 4 | 1 | 0 |
26957 | 26957 | 2020-05-26 | Shasta | 89 | 36 | 4 | 0 | 0 |
27015 | 27015 | 2020-05-25 | Shasta | 89 | 36 | 4 | 0 | 0 |
27073 | 27073 | 2020-05-24 | Shasta | 89 | 36 | 4 | 0 | 0 |
27131 | 27131 | 2020-05-23 | Shasta | 89 | 36 | 4 | 0 | 0 |
27189 | 27189 | 2020-05-22 | Shasta | 89 | 36 | 4 | 2 | 0 |
26783 | 26783 | 2020-05-29 | Shasta | 89 | 37 | 4 | 0 | 0 |
26841 | 26841 | 2020-05-28 | Shasta | 89 | 37 | 4 | 0 | 0 |
26899 | 26899 | 2020-05-27 | Shasta | 89 | 37 | 4 | 1 | 0 |
26609 | 26609 | 2020-06-01 | Shasta | 89 | 39 | 4 | 0 | 0 |
26667 | 26667 | 2020-05-31 | Shasta | 89 | 39 | 4 | 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 );