ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Lake" and fips = 47095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
273835 | 273835 | 2020-06-25 | Lake | Tennessee | 47095 | 690 | 0 |
270696 | 270696 | 2020-06-24 | Lake | Tennessee | 47095 | 690 | 0 |
267562 | 267562 | 2020-06-23 | Lake | Tennessee | 47095 | 689 | 0 |
264434 | 264434 | 2020-06-22 | Lake | Tennessee | 47095 | 689 | 0 |
261306 | 261306 | 2020-06-21 | Lake | Tennessee | 47095 | 689 | 0 |
258179 | 258179 | 2020-06-20 | Lake | Tennessee | 47095 | 689 | 0 |
255053 | 255053 | 2020-06-19 | Lake | Tennessee | 47095 | 689 | 0 |
251938 | 251938 | 2020-06-18 | Lake | Tennessee | 47095 | 689 | 0 |
248823 | 248823 | 2020-06-17 | Lake | Tennessee | 47095 | 689 | 0 |
245710 | 245710 | 2020-06-16 | Lake | Tennessee | 47095 | 689 | 0 |
242598 | 242598 | 2020-06-15 | Lake | Tennessee | 47095 | 690 | 0 |
239488 | 239488 | 2020-06-14 | Lake | Tennessee | 47095 | 690 | 0 |
236380 | 236380 | 2020-06-13 | Lake | Tennessee | 47095 | 690 | 0 |
233274 | 233274 | 2020-06-12 | Lake | Tennessee | 47095 | 691 | 0 |
230169 | 230169 | 2020-06-11 | Lake | Tennessee | 47095 | 688 | 0 |
227065 | 227065 | 2020-06-10 | Lake | Tennessee | 47095 | 712 | 0 |
223965 | 223965 | 2020-06-09 | Lake | Tennessee | 47095 | 730 | 0 |
220870 | 220870 | 2020-06-08 | Lake | Tennessee | 47095 | 724 | 0 |
217778 | 217778 | 2020-06-07 | Lake | Tennessee | 47095 | 724 | 0 |
214688 | 214688 | 2020-06-06 | Lake | Tennessee | 47095 | 724 | 0 |
211601 | 211601 | 2020-06-05 | Lake | Tennessee | 47095 | 725 | 0 |
208519 | 208519 | 2020-06-04 | Lake | Tennessee | 47095 | 794 | 0 |
205437 | 205437 | 2020-06-03 | Lake | Tennessee | 47095 | 835 | 0 |
202358 | 202358 | 2020-06-02 | Lake | Tennessee | 47095 | 765 | 0 |
199283 | 199283 | 2020-06-01 | Lake | Tennessee | 47095 | 414 | 0 |
196210 | 196210 | 2020-05-31 | Lake | Tennessee | 47095 | 414 | 0 |
193140 | 193140 | 2020-05-30 | Lake | Tennessee | 47095 | 414 | 0 |
190075 | 190075 | 2020-05-29 | Lake | Tennessee | 47095 | 413 | 0 |
187011 | 187011 | 2020-05-28 | Lake | Tennessee | 47095 | 413 | 0 |
183954 | 183954 | 2020-05-27 | Lake | Tennessee | 47095 | 413 | 0 |
180904 | 180904 | 2020-05-26 | Lake | Tennessee | 47095 | 413 | 0 |
177861 | 177861 | 2020-05-25 | Lake | Tennessee | 47095 | 410 | 0 |
174817 | 174817 | 2020-05-24 | Lake | Tennessee | 47095 | 409 | 0 |
171774 | 171774 | 2020-05-23 | Lake | Tennessee | 47095 | 408 | 0 |
168735 | 168735 | 2020-05-22 | Lake | Tennessee | 47095 | 406 | 0 |
165699 | 165699 | 2020-05-21 | Lake | Tennessee | 47095 | 403 | 0 |
162670 | 162670 | 2020-05-20 | Lake | Tennessee | 47095 | 403 | 0 |
159643 | 159643 | 2020-05-19 | Lake | Tennessee | 47095 | 403 | 0 |
156621 | 156621 | 2020-05-18 | Lake | Tennessee | 47095 | 404 | 0 |
153604 | 153604 | 2020-05-17 | Lake | Tennessee | 47095 | 404 | 0 |
150593 | 150593 | 2020-05-16 | Lake | Tennessee | 47095 | 401 | 0 |
147585 | 147585 | 2020-05-15 | Lake | Tennessee | 47095 | 401 | 0 |
144584 | 144584 | 2020-05-14 | Lake | Tennessee | 47095 | 401 | 0 |
141587 | 141587 | 2020-05-13 | Lake | Tennessee | 47095 | 300 | 0 |
138591 | 138591 | 2020-05-12 | Lake | Tennessee | 47095 | 99 | 0 |
135601 | 135601 | 2020-05-11 | Lake | Tennessee | 47095 | 61 | 0 |
132610 | 132610 | 2020-05-10 | Lake | Tennessee | 47095 | 59 | 0 |
129621 | 129621 | 2020-05-09 | Lake | Tennessee | 47095 | 59 | 0 |
126632 | 126632 | 2020-05-08 | Lake | Tennessee | 47095 | 59 | 0 |
123649 | 123649 | 2020-05-07 | Lake | Tennessee | 47095 | 59 | 0 |
120671 | 120671 | 2020-05-06 | Lake | Tennessee | 47095 | 59 | 0 |
117707 | 117707 | 2020-05-05 | Lake | Tennessee | 47095 | 58 | 0 |
114751 | 114751 | 2020-05-04 | Lake | Tennessee | 47095 | 58 | 0 |
111869 | 111869 | 2020-05-03 | Lake | Tennessee | 47095 | 57 | 0 |
108995 | 108995 | 2020-05-02 | Lake | Tennessee | 47095 | 55 | 0 |
106128 | 106128 | 2020-05-01 | Lake | Tennessee | 47095 | 55 | 0 |
103265 | 103265 | 2020-04-30 | Lake | Tennessee | 47095 | 55 | 0 |
100412 | 100412 | 2020-04-29 | Lake | Tennessee | 47095 | 53 | 0 |
97562 | 97562 | 2020-04-28 | Lake | Tennessee | 47095 | 50 | 0 |
94722 | 94722 | 2020-04-27 | Lake | Tennessee | 47095 | 49 | 0 |
91894 | 91894 | 2020-04-26 | Lake | Tennessee | 47095 | 48 | 0 |
89077 | 89077 | 2020-04-25 | Lake | Tennessee | 47095 | 48 | 0 |
86262 | 86262 | 2020-04-24 | Lake | Tennessee | 47095 | 46 | 0 |
83457 | 83457 | 2020-04-23 | Lake | Tennessee | 47095 | 20 | 0 |
80658 | 80658 | 2020-04-22 | Lake | Tennessee | 47095 | 9 | 0 |
77868 | 77868 | 2020-04-21 | Lake | Tennessee | 47095 | 4 | 0 |
75086 | 75086 | 2020-04-20 | Lake | Tennessee | 47095 | 4 | 0 |
72311 | 72311 | 2020-04-19 | Lake | Tennessee | 47095 | 4 | 0 |
69544 | 69544 | 2020-04-18 | Lake | Tennessee | 47095 | 4 | 0 |
66785 | 66785 | 2020-04-17 | Lake | Tennessee | 47095 | 4 | 0 |
64039 | 64039 | 2020-04-16 | Lake | Tennessee | 47095 | 4 | 0 |
61312 | 61312 | 2020-04-15 | Lake | Tennessee | 47095 | 4 | 0 |
58597 | 58597 | 2020-04-14 | Lake | Tennessee | 47095 | 4 | 0 |
55894 | 55894 | 2020-04-13 | Lake | Tennessee | 47095 | 4 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);