ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Lake" and state = "South Dakota" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
27888 | 27888 | 2020-04-02 | Lake | South Dakota | 46079 | 1 | 0 |
30223 | 30223 | 2020-04-03 | Lake | South Dakota | 46079 | 1 | 0 |
32614 | 32614 | 2020-04-04 | Lake | South Dakota | 46079 | 1 | 0 |
35050 | 35050 | 2020-04-05 | Lake | South Dakota | 46079 | 1 | 0 |
37525 | 37525 | 2020-04-06 | Lake | South Dakota | 46079 | 1 | 0 |
40048 | 40048 | 2020-04-07 | Lake | South Dakota | 46079 | 1 | 0 |
42608 | 42608 | 2020-04-08 | Lake | South Dakota | 46079 | 2 | 0 |
45196 | 45196 | 2020-04-09 | Lake | South Dakota | 46079 | 2 | 0 |
47813 | 47813 | 2020-04-10 | Lake | South Dakota | 46079 | 2 | 0 |
50470 | 50470 | 2020-04-11 | Lake | South Dakota | 46079 | 2 | 0 |
53143 | 53143 | 2020-04-12 | Lake | South Dakota | 46079 | 2 | 0 |
55829 | 55829 | 2020-04-13 | Lake | South Dakota | 46079 | 2 | 0 |
58532 | 58532 | 2020-04-14 | Lake | South Dakota | 46079 | 2 | 0 |
61247 | 61247 | 2020-04-15 | Lake | South Dakota | 46079 | 2 | 0 |
63973 | 63973 | 2020-04-16 | Lake | South Dakota | 46079 | 3 | 0 |
66719 | 66719 | 2020-04-17 | Lake | South Dakota | 46079 | 3 | 0 |
69477 | 69477 | 2020-04-18 | Lake | South Dakota | 46079 | 3 | 0 |
72244 | 72244 | 2020-04-19 | Lake | South Dakota | 46079 | 3 | 0 |
75019 | 75019 | 2020-04-20 | Lake | South Dakota | 46079 | 3 | 0 |
77801 | 77801 | 2020-04-21 | Lake | South Dakota | 46079 | 3 | 0 |
80591 | 80591 | 2020-04-22 | Lake | South Dakota | 46079 | 3 | 0 |
83390 | 83390 | 2020-04-23 | Lake | South Dakota | 46079 | 3 | 0 |
86194 | 86194 | 2020-04-24 | Lake | South Dakota | 46079 | 4 | 0 |
89008 | 89008 | 2020-04-25 | Lake | South Dakota | 46079 | 4 | 0 |
91825 | 91825 | 2020-04-26 | Lake | South Dakota | 46079 | 4 | 0 |
94653 | 94653 | 2020-04-27 | Lake | South Dakota | 46079 | 4 | 0 |
97493 | 97493 | 2020-04-28 | Lake | South Dakota | 46079 | 4 | 0 |
100343 | 100343 | 2020-04-29 | Lake | South Dakota | 46079 | 4 | 0 |
103196 | 103196 | 2020-04-30 | Lake | South Dakota | 46079 | 4 | 0 |
106059 | 106059 | 2020-05-01 | Lake | South Dakota | 46079 | 4 | 0 |
108926 | 108926 | 2020-05-02 | Lake | South Dakota | 46079 | 4 | 0 |
111800 | 111800 | 2020-05-03 | Lake | South Dakota | 46079 | 4 | 0 |
114682 | 114682 | 2020-05-04 | Lake | South Dakota | 46079 | 4 | 0 |
117638 | 117638 | 2020-05-05 | Lake | South Dakota | 46079 | 4 | 0 |
120601 | 120601 | 2020-05-06 | Lake | South Dakota | 46079 | 4 | 0 |
123579 | 123579 | 2020-05-07 | Lake | South Dakota | 46079 | 4 | 0 |
126562 | 126562 | 2020-05-08 | Lake | South Dakota | 46079 | 5 | 0 |
129551 | 129551 | 2020-05-09 | Lake | South Dakota | 46079 | 5 | 0 |
132540 | 132540 | 2020-05-10 | Lake | South Dakota | 46079 | 5 | 0 |
135531 | 135531 | 2020-05-11 | Lake | South Dakota | 46079 | 5 | 0 |
138521 | 138521 | 2020-05-12 | Lake | South Dakota | 46079 | 5 | 0 |
141517 | 141517 | 2020-05-13 | Lake | South Dakota | 46079 | 5 | 0 |
144513 | 144513 | 2020-05-14 | Lake | South Dakota | 46079 | 5 | 0 |
147514 | 147514 | 2020-05-15 | Lake | South Dakota | 46079 | 5 | 0 |
150522 | 150522 | 2020-05-16 | Lake | South Dakota | 46079 | 5 | 0 |
153533 | 153533 | 2020-05-17 | Lake | South Dakota | 46079 | 5 | 0 |
156550 | 156550 | 2020-05-18 | Lake | South Dakota | 46079 | 5 | 0 |
159571 | 159571 | 2020-05-19 | Lake | South Dakota | 46079 | 5 | 0 |
162598 | 162598 | 2020-05-20 | Lake | South Dakota | 46079 | 5 | 0 |
165627 | 165627 | 2020-05-21 | Lake | South Dakota | 46079 | 5 | 0 |
168663 | 168663 | 2020-05-22 | Lake | South Dakota | 46079 | 5 | 0 |
171702 | 171702 | 2020-05-23 | Lake | South Dakota | 46079 | 5 | 0 |
174745 | 174745 | 2020-05-24 | Lake | South Dakota | 46079 | 6 | 0 |
177789 | 177789 | 2020-05-25 | Lake | South Dakota | 46079 | 6 | 0 |
180832 | 180832 | 2020-05-26 | Lake | South Dakota | 46079 | 6 | 0 |
183882 | 183882 | 2020-05-27 | Lake | South Dakota | 46079 | 6 | 0 |
186939 | 186939 | 2020-05-28 | Lake | South Dakota | 46079 | 7 | 0 |
190003 | 190003 | 2020-05-29 | Lake | South Dakota | 46079 | 8 | 0 |
193068 | 193068 | 2020-05-30 | Lake | South Dakota | 46079 | 8 | 0 |
196138 | 196138 | 2020-05-31 | Lake | South Dakota | 46079 | 8 | 0 |
199211 | 199211 | 2020-06-01 | Lake | South Dakota | 46079 | 8 | 0 |
202286 | 202286 | 2020-06-02 | Lake | South Dakota | 46079 | 8 | 0 |
205365 | 205365 | 2020-06-03 | Lake | South Dakota | 46079 | 10 | 0 |
208447 | 208447 | 2020-06-04 | Lake | South Dakota | 46079 | 12 | 0 |
211529 | 211529 | 2020-06-05 | Lake | South Dakota | 46079 | 12 | 0 |
214616 | 214616 | 2020-06-06 | Lake | South Dakota | 46079 | 13 | 0 |
217706 | 217706 | 2020-06-07 | Lake | South Dakota | 46079 | 13 | 0 |
220798 | 220798 | 2020-06-08 | Lake | South Dakota | 46079 | 13 | 0 |
223893 | 223893 | 2020-06-09 | Lake | South Dakota | 46079 | 13 | 1 |
226993 | 226993 | 2020-06-10 | Lake | South Dakota | 46079 | 13 | 1 |
230097 | 230097 | 2020-06-11 | Lake | South Dakota | 46079 | 13 | 1 |
233202 | 233202 | 2020-06-12 | Lake | South Dakota | 46079 | 14 | 1 |
236307 | 236307 | 2020-06-13 | Lake | South Dakota | 46079 | 14 | 1 |
239415 | 239415 | 2020-06-14 | Lake | South Dakota | 46079 | 14 | 1 |
242525 | 242525 | 2020-06-15 | Lake | South Dakota | 46079 | 15 | 1 |
245637 | 245637 | 2020-06-16 | Lake | South Dakota | 46079 | 16 | 1 |
248750 | 248750 | 2020-06-17 | Lake | South Dakota | 46079 | 17 | 1 |
251865 | 251865 | 2020-06-18 | Lake | South Dakota | 46079 | 17 | 1 |
254980 | 254980 | 2020-06-19 | Lake | South Dakota | 46079 | 17 | 1 |
258106 | 258106 | 2020-06-20 | Lake | South Dakota | 46079 | 17 | 1 |
261233 | 261233 | 2020-06-21 | Lake | South Dakota | 46079 | 17 | 1 |
264361 | 264361 | 2020-06-22 | Lake | South Dakota | 46079 | 17 | 1 |
267489 | 267489 | 2020-06-23 | Lake | South Dakota | 46079 | 18 | 1 |
270623 | 270623 | 2020-06-24 | Lake | South Dakota | 46079 | 18 | 1 |
273762 | 273762 | 2020-06-25 | Lake | South Dakota | 46079 | 18 | 1 |
276909 | 276909 | 2020-06-26 | Lake | South Dakota | 46079 | 19 | 1 |
280057 | 280057 | 2020-06-27 | Lake | South Dakota | 46079 | 19 | 1 |
283203 | 283203 | 2020-06-28 | Lake | South Dakota | 46079 | 20 | 1 |
286348 | 286348 | 2020-06-29 | Lake | South Dakota | 46079 | 21 | 1 |
289499 | 289499 | 2020-06-30 | Lake | South Dakota | 46079 | 21 | 1 |
292651 | 292651 | 2020-07-01 | Lake | South Dakota | 46079 | 21 | 1 |
295807 | 295807 | 2020-07-02 | Lake | South Dakota | 46079 | 22 | 1 |
298967 | 298967 | 2020-07-03 | Lake | South Dakota | 46079 | 22 | 1 |
302131 | 302131 | 2020-07-04 | Lake | South Dakota | 46079 | 22 | 1 |
305294 | 305294 | 2020-07-05 | Lake | South Dakota | 46079 | 22 | 1 |
308462 | 308462 | 2020-07-06 | Lake | South Dakota | 46079 | 22 | 1 |
311631 | 311631 | 2020-07-07 | Lake | South Dakota | 46079 | 22 | 1 |
314805 | 314805 | 2020-07-08 | Lake | South Dakota | 46079 | 22 | 1 |
317978 | 317978 | 2020-07-09 | Lake | South Dakota | 46079 | 23 | 1 |
321156 | 321156 | 2020-07-10 | Lake | South Dakota | 46079 | 26 | 1 |
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);