latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
222 rows where deaths = 0 and fips = 105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
15713 | 15713 | 2020-12-06 | Trinity | 105 | 186 | 0 | 0 | 0 |
15771 | 15771 | 2020-12-05 | Trinity | 105 | 186 | 0 | 0 | 0 |
15829 | 15829 | 2020-12-04 | Trinity | 105 | 186 | 0 | 9 | 0 |
15887 | 15887 | 2020-12-03 | Trinity | 105 | 177 | 0 | 7 | 0 |
15945 | 15945 | 2020-12-02 | Trinity | 105 | 170 | 0 | 2 | 0 |
16003 | 16003 | 2020-12-01 | Trinity | 105 | 168 | 0 | 4 | 0 |
16061 | 16061 | 2020-11-30 | Trinity | 105 | 164 | 0 | 6 | 0 |
16119 | 16119 | 2020-11-29 | Trinity | 105 | 158 | 0 | 0 | 0 |
16177 | 16177 | 2020-11-28 | Trinity | 105 | 158 | 0 | 0 | 0 |
16235 | 16235 | 2020-11-27 | Trinity | 105 | 158 | 0 | 19 | 0 |
16293 | 16293 | 2020-11-26 | Trinity | 105 | 139 | 0 | 0 | 0 |
16351 | 16351 | 2020-11-25 | Trinity | 105 | 139 | 0 | 3 | 0 |
16409 | 16409 | 2020-11-24 | Trinity | 105 | 136 | 0 | 12 | 0 |
16467 | 16467 | 2020-11-23 | Trinity | 105 | 124 | 0 | 11 | 0 |
16525 | 16525 | 2020-11-22 | Trinity | 105 | 113 | 0 | 0 | 0 |
16583 | 16583 | 2020-11-21 | Trinity | 105 | 113 | 0 | 0 | 0 |
16641 | 16641 | 2020-11-20 | Trinity | 105 | 113 | 0 | 7 | 0 |
16699 | 16699 | 2020-11-19 | Trinity | 105 | 106 | 0 | 3 | 0 |
16757 | 16757 | 2020-11-18 | Trinity | 105 | 103 | 0 | 5 | 0 |
16815 | 16815 | 2020-11-17 | Trinity | 105 | 98 | 0 | 15 | 0 |
16873 | 16873 | 2020-11-16 | Trinity | 105 | 83 | 0 | 15 | 0 |
16931 | 16931 | 2020-11-15 | Trinity | 105 | 68 | 0 | 0 | 0 |
16989 | 16989 | 2020-11-14 | Trinity | 105 | 68 | 0 | 0 | 0 |
17047 | 17047 | 2020-11-13 | Trinity | 105 | 68 | 0 | 3 | 0 |
17105 | 17105 | 2020-11-12 | Trinity | 105 | 65 | 0 | 3 | 0 |
17163 | 17163 | 2020-11-11 | Trinity | 105 | 62 | 0 | 0 | 0 |
17221 | 17221 | 2020-11-10 | Trinity | 105 | 62 | 0 | 0 | 0 |
17279 | 17279 | 2020-11-09 | Trinity | 105 | 62 | 0 | 19 | 0 |
17337 | 17337 | 2020-11-08 | Trinity | 105 | 43 | 0 | 0 | 0 |
17395 | 17395 | 2020-11-07 | Trinity | 105 | 43 | 0 | 0 | 0 |
17453 | 17453 | 2020-11-06 | Trinity | 105 | 43 | 0 | 2 | 0 |
17511 | 17511 | 2020-11-05 | Trinity | 105 | 41 | 0 | 1 | 0 |
17569 | 17569 | 2020-11-04 | Trinity | 105 | 40 | 0 | 3 | 0 |
17627 | 17627 | 2020-11-03 | Trinity | 105 | 37 | 0 | 2 | 0 |
17685 | 17685 | 2020-11-02 | Trinity | 105 | 35 | 0 | 2 | 0 |
17743 | 17743 | 2020-11-01 | Trinity | 105 | 33 | 0 | 0 | 0 |
17801 | 17801 | 2020-10-31 | Trinity | 105 | 33 | 0 | 0 | 0 |
17859 | 17859 | 2020-10-30 | Trinity | 105 | 33 | 0 | 5 | 0 |
17917 | 17917 | 2020-10-29 | Trinity | 105 | 28 | 0 | 0 | 0 |
17975 | 17975 | 2020-10-28 | Trinity | 105 | 28 | 0 | 1 | 0 |
18033 | 18033 | 2020-10-27 | Trinity | 105 | 27 | 0 | 0 | 0 |
18091 | 18091 | 2020-10-26 | Trinity | 105 | 27 | 0 | 2 | 0 |
18149 | 18149 | 2020-10-25 | Trinity | 105 | 25 | 0 | 0 | 0 |
18207 | 18207 | 2020-10-24 | Trinity | 105 | 25 | 0 | 0 | 0 |
18265 | 18265 | 2020-10-23 | Trinity | 105 | 25 | 0 | 0 | 0 |
18323 | 18323 | 2020-10-22 | Trinity | 105 | 25 | 0 | 0 | 0 |
18381 | 18381 | 2020-10-21 | Trinity | 105 | 25 | 0 | 0 | 0 |
18439 | 18439 | 2020-10-20 | Trinity | 105 | 25 | 0 | 2 | 0 |
18497 | 18497 | 2020-10-19 | Trinity | 105 | 23 | 0 | 0 | 0 |
18555 | 18555 | 2020-10-18 | Trinity | 105 | 23 | 0 | 3 | 0 |
18613 | 18613 | 2020-10-17 | Trinity | 105 | 20 | 0 | 0 | 0 |
18671 | 18671 | 2020-10-16 | Trinity | 105 | 20 | 0 | 0 | 0 |
18729 | 18729 | 2020-10-15 | Trinity | 105 | 20 | 0 | 0 | 0 |
18787 | 18787 | 2020-10-14 | Trinity | 105 | 20 | 0 | 0 | 0 |
18845 | 18845 | 2020-10-13 | Trinity | 105 | 20 | 0 | 0 | 0 |
18903 | 18903 | 2020-10-12 | Trinity | 105 | 20 | 0 | 0 | 0 |
18961 | 18961 | 2020-10-11 | Trinity | 105 | 20 | 0 | 0 | 0 |
19019 | 19019 | 2020-10-10 | Trinity | 105 | 20 | 0 | 0 | 0 |
19077 | 19077 | 2020-10-09 | Trinity | 105 | 20 | 0 | 1 | 0 |
19135 | 19135 | 2020-10-08 | Trinity | 105 | 19 | 0 | 0 | 0 |
19193 | 19193 | 2020-10-07 | Trinity | 105 | 19 | 0 | 0 | 0 |
19251 | 19251 | 2020-10-06 | Trinity | 105 | 19 | 0 | 0 | 0 |
19309 | 19309 | 2020-10-05 | Trinity | 105 | 19 | 0 | 0 | 0 |
19367 | 19367 | 2020-10-04 | Trinity | 105 | 19 | 0 | 0 | 0 |
19425 | 19425 | 2020-10-03 | Trinity | 105 | 19 | 0 | 3 | 0 |
19483 | 19483 | 2020-10-02 | Trinity | 105 | 16 | 0 | 0 | 0 |
19541 | 19541 | 2020-10-01 | Trinity | 105 | 16 | 0 | 0 | 0 |
19599 | 19599 | 2020-09-30 | Trinity | 105 | 16 | 0 | 0 | 0 |
19657 | 19657 | 2020-09-29 | Trinity | 105 | 16 | 0 | 0 | 0 |
19715 | 19715 | 2020-09-28 | Trinity | 105 | 16 | 0 | 0 | 0 |
19773 | 19773 | 2020-09-27 | Trinity | 105 | 16 | 0 | 0 | 0 |
19831 | 19831 | 2020-09-26 | Trinity | 105 | 16 | 0 | 0 | 0 |
19889 | 19889 | 2020-09-25 | Trinity | 105 | 16 | 0 | 0 | 0 |
19947 | 19947 | 2020-09-24 | Trinity | 105 | 16 | 0 | 1 | 0 |
20005 | 20005 | 2020-09-23 | Trinity | 105 | 15 | 0 | 0 | 0 |
20063 | 20063 | 2020-09-22 | Trinity | 105 | 15 | 0 | 0 | 0 |
20121 | 20121 | 2020-09-21 | Trinity | 105 | 15 | 0 | 0 | 0 |
20179 | 20179 | 2020-09-20 | Trinity | 105 | 15 | 0 | 0 | 0 |
20237 | 20237 | 2020-09-19 | Trinity | 105 | 15 | 0 | 0 | 0 |
20295 | 20295 | 2020-09-18 | Trinity | 105 | 15 | 0 | 0 | 0 |
20353 | 20353 | 2020-09-17 | Trinity | 105 | 15 | 0 | 0 | 0 |
20411 | 20411 | 2020-09-16 | Trinity | 105 | 15 | 0 | 0 | 0 |
20469 | 20469 | 2020-09-15 | Trinity | 105 | 15 | 0 | 0 | 0 |
20527 | 20527 | 2020-09-14 | Trinity | 105 | 15 | 0 | 1 | 0 |
20585 | 20585 | 2020-09-13 | Trinity | 105 | 14 | 0 | 0 | 0 |
20643 | 20643 | 2020-09-12 | Trinity | 105 | 14 | 0 | 0 | 0 |
20701 | 20701 | 2020-09-11 | Trinity | 105 | 14 | 0 | 0 | 0 |
20759 | 20759 | 2020-09-10 | Trinity | 105 | 14 | 0 | 0 | 0 |
20817 | 20817 | 2020-09-09 | Trinity | 105 | 14 | 0 | 0 | 0 |
20875 | 20875 | 2020-09-08 | Trinity | 105 | 14 | 0 | 1 | 0 |
20933 | 20933 | 2020-09-07 | Trinity | 105 | 13 | 0 | 0 | 0 |
20991 | 20991 | 2020-09-06 | Trinity | 105 | 13 | 0 | 0 | 0 |
21049 | 21049 | 2020-09-05 | Trinity | 105 | 13 | 0 | 0 | 0 |
21107 | 21107 | 2020-09-04 | Trinity | 105 | 13 | 0 | 0 | 0 |
21165 | 21165 | 2020-09-03 | Trinity | 105 | 13 | 0 | 0 | 0 |
21223 | 21223 | 2020-09-02 | Trinity | 105 | 13 | 0 | 0 | 0 |
21281 | 21281 | 2020-09-01 | Trinity | 105 | 13 | 0 | 0 | 0 |
21339 | 21339 | 2020-08-31 | Trinity | 105 | 13 | 0 | 0 | 0 |
21397 | 21397 | 2020-08-30 | Trinity | 105 | 13 | 0 | 0 | 0 |
21455 | 21455 | 2020-08-29 | Trinity | 105 | 13 | 0 | 2 | 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 );