latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
74 rows where deaths = 4 and fips = 89 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
24579 | 24579 | 2020-07-06 | Shasta | 89 | 157 | 4 | 3 | 0 |
24637 | 24637 | 2020-07-05 | Shasta | 89 | 154 | 4 | 1 | 0 |
24695 | 24695 | 2020-07-04 | Shasta | 89 | 153 | 4 | 5 | 0 |
24753 | 24753 | 2020-07-03 | Shasta | 89 | 148 | 4 | 13 | 0 |
24811 | 24811 | 2020-07-02 | Shasta | 89 | 135 | 4 | 6 | 0 |
24869 | 24869 | 2020-07-01 | Shasta | 89 | 129 | 4 | 11 | 0 |
24927 | 24927 | 2020-06-30 | Shasta | 89 | 118 | 4 | 6 | 0 |
24985 | 24985 | 2020-06-29 | Shasta | 89 | 112 | 4 | 7 | 0 |
25043 | 25043 | 2020-06-28 | Shasta | 89 | 105 | 4 | 4 | 0 |
25101 | 25101 | 2020-06-27 | Shasta | 89 | 101 | 4 | 4 | 0 |
25159 | 25159 | 2020-06-26 | Shasta | 89 | 97 | 4 | 1 | 0 |
25217 | 25217 | 2020-06-25 | Shasta | 89 | 96 | 4 | 4 | 0 |
25275 | 25275 | 2020-06-24 | Shasta | 89 | 92 | 4 | 4 | 0 |
25333 | 25333 | 2020-06-23 | Shasta | 89 | 88 | 4 | 2 | 0 |
25391 | 25391 | 2020-06-22 | Shasta | 89 | 86 | 4 | 5 | 0 |
25449 | 25449 | 2020-06-21 | Shasta | 89 | 81 | 4 | 1 | 0 |
25507 | 25507 | 2020-06-20 | Shasta | 89 | 80 | 4 | 4 | 0 |
25565 | 25565 | 2020-06-19 | Shasta | 89 | 76 | 4 | 14 | 0 |
25623 | 25623 | 2020-06-18 | Shasta | 89 | 62 | 4 | 4 | 0 |
25681 | 25681 | 2020-06-17 | Shasta | 89 | 58 | 4 | 7 | 0 |
25739 | 25739 | 2020-06-16 | Shasta | 89 | 51 | 4 | 0 | 0 |
25797 | 25797 | 2020-06-15 | Shasta | 89 | 51 | 4 | 1 | 0 |
25855 | 25855 | 2020-06-14 | Shasta | 89 | 50 | 4 | 1 | 0 |
25913 | 25913 | 2020-06-13 | Shasta | 89 | 49 | 4 | 1 | 0 |
25971 | 25971 | 2020-06-12 | Shasta | 89 | 48 | 4 | 0 | 0 |
26029 | 26029 | 2020-06-11 | Shasta | 89 | 48 | 4 | 1 | 0 |
26087 | 26087 | 2020-06-10 | Shasta | 89 | 47 | 4 | 0 | 0 |
26145 | 26145 | 2020-06-09 | Shasta | 89 | 47 | 4 | 1 | 0 |
26203 | 26203 | 2020-06-08 | Shasta | 89 | 46 | 4 | 2 | 0 |
26261 | 26261 | 2020-06-07 | Shasta | 89 | 44 | 4 | 2 | 0 |
26319 | 26319 | 2020-06-06 | Shasta | 89 | 42 | 4 | 0 | 0 |
26377 | 26377 | 2020-06-05 | Shasta | 89 | 42 | 4 | 0 | 0 |
26435 | 26435 | 2020-06-04 | Shasta | 89 | 42 | 4 | 2 | 0 |
26493 | 26493 | 2020-06-03 | Shasta | 89 | 40 | 4 | 0 | 0 |
26551 | 26551 | 2020-06-02 | Shasta | 89 | 40 | 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 |
26725 | 26725 | 2020-05-30 | Shasta | 89 | 39 | 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 |
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 |
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 |
27595 | 27595 | 2020-05-15 | Shasta | 89 | 33 | 4 | 0 | 0 |
27653 | 27653 | 2020-05-14 | Shasta | 89 | 33 | 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 |
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 |
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 |
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 );