ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 46057 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388402 | 388402 | 2020-07-31 | Hamlin | South Dakota | 46057 | 14 | 0 |
385185 | 385185 | 2020-07-30 | Hamlin | South Dakota | 46057 | 14 | 0 |
381967 | 381967 | 2020-07-29 | Hamlin | South Dakota | 46057 | 14 | 0 |
378750 | 378750 | 2020-07-28 | Hamlin | South Dakota | 46057 | 14 | 0 |
375534 | 375534 | 2020-07-27 | Hamlin | South Dakota | 46057 | 14 | 0 |
372321 | 372321 | 2020-07-26 | Hamlin | South Dakota | 46057 | 14 | 0 |
369109 | 369109 | 2020-07-25 | Hamlin | South Dakota | 46057 | 14 | 0 |
365900 | 365900 | 2020-07-24 | Hamlin | South Dakota | 46057 | 14 | 0 |
362694 | 362694 | 2020-07-23 | Hamlin | South Dakota | 46057 | 14 | 0 |
359488 | 359488 | 2020-07-22 | Hamlin | South Dakota | 46057 | 14 | 0 |
356284 | 356284 | 2020-07-21 | Hamlin | South Dakota | 46057 | 13 | 0 |
353081 | 353081 | 2020-07-20 | Hamlin | South Dakota | 46057 | 13 | 0 |
349878 | 349878 | 2020-07-19 | Hamlin | South Dakota | 46057 | 13 | 0 |
346678 | 346678 | 2020-07-18 | Hamlin | South Dakota | 46057 | 13 | 0 |
343478 | 343478 | 2020-07-17 | Hamlin | South Dakota | 46057 | 13 | 0 |
340280 | 340280 | 2020-07-16 | Hamlin | South Dakota | 46057 | 13 | 0 |
337083 | 337083 | 2020-07-15 | Hamlin | South Dakota | 46057 | 13 | 0 |
333889 | 333889 | 2020-07-14 | Hamlin | South Dakota | 46057 | 13 | 0 |
330697 | 330697 | 2020-07-13 | Hamlin | South Dakota | 46057 | 13 | 0 |
327511 | 327511 | 2020-07-12 | Hamlin | South Dakota | 46057 | 13 | 0 |
324326 | 324326 | 2020-07-11 | Hamlin | South Dakota | 46057 | 13 | 0 |
321146 | 321146 | 2020-07-10 | Hamlin | South Dakota | 46057 | 13 | 0 |
317968 | 317968 | 2020-07-09 | Hamlin | South Dakota | 46057 | 13 | 0 |
314795 | 314795 | 2020-07-08 | Hamlin | South Dakota | 46057 | 13 | 0 |
311622 | 311622 | 2020-07-07 | Hamlin | South Dakota | 46057 | 13 | 0 |
308453 | 308453 | 2020-07-06 | Hamlin | South Dakota | 46057 | 13 | 0 |
305285 | 305285 | 2020-07-05 | Hamlin | South Dakota | 46057 | 13 | 0 |
302122 | 302122 | 2020-07-04 | Hamlin | South Dakota | 46057 | 13 | 0 |
298958 | 298958 | 2020-07-03 | Hamlin | South Dakota | 46057 | 13 | 0 |
295798 | 295798 | 2020-07-02 | Hamlin | South Dakota | 46057 | 12 | 0 |
292642 | 292642 | 2020-07-01 | Hamlin | South Dakota | 46057 | 12 | 0 |
289490 | 289490 | 2020-06-30 | Hamlin | South Dakota | 46057 | 11 | 0 |
286339 | 286339 | 2020-06-29 | Hamlin | South Dakota | 46057 | 11 | 0 |
283194 | 283194 | 2020-06-28 | Hamlin | South Dakota | 46057 | 11 | 0 |
280048 | 280048 | 2020-06-27 | Hamlin | South Dakota | 46057 | 11 | 0 |
276900 | 276900 | 2020-06-26 | Hamlin | South Dakota | 46057 | 11 | 0 |
273753 | 273753 | 2020-06-25 | Hamlin | South Dakota | 46057 | 11 | 0 |
270614 | 270614 | 2020-06-24 | Hamlin | South Dakota | 46057 | 11 | 0 |
267480 | 267480 | 2020-06-23 | Hamlin | South Dakota | 46057 | 11 | 0 |
264352 | 264352 | 2020-06-22 | Hamlin | South Dakota | 46057 | 11 | 0 |
261224 | 261224 | 2020-06-21 | Hamlin | South Dakota | 46057 | 10 | 0 |
258097 | 258097 | 2020-06-20 | Hamlin | South Dakota | 46057 | 10 | 0 |
254971 | 254971 | 2020-06-19 | Hamlin | South Dakota | 46057 | 10 | 0 |
251856 | 251856 | 2020-06-18 | Hamlin | South Dakota | 46057 | 10 | 0 |
248741 | 248741 | 2020-06-17 | Hamlin | South Dakota | 46057 | 11 | 0 |
245628 | 245628 | 2020-06-16 | Hamlin | South Dakota | 46057 | 11 | 0 |
242516 | 242516 | 2020-06-15 | Hamlin | South Dakota | 46057 | 11 | 0 |
239406 | 239406 | 2020-06-14 | Hamlin | South Dakota | 46057 | 11 | 0 |
236298 | 236298 | 2020-06-13 | Hamlin | South Dakota | 46057 | 10 | 0 |
233193 | 233193 | 2020-06-12 | Hamlin | South Dakota | 46057 | 9 | 0 |
230088 | 230088 | 2020-06-11 | Hamlin | South Dakota | 46057 | 9 | 0 |
226984 | 226984 | 2020-06-10 | Hamlin | South Dakota | 46057 | 9 | 0 |
223884 | 223884 | 2020-06-09 | Hamlin | South Dakota | 46057 | 8 | 0 |
220789 | 220789 | 2020-06-08 | Hamlin | South Dakota | 46057 | 7 | 0 |
217697 | 217697 | 2020-06-07 | Hamlin | South Dakota | 46057 | 6 | 0 |
214607 | 214607 | 2020-06-06 | Hamlin | South Dakota | 46057 | 5 | 0 |
211520 | 211520 | 2020-06-05 | Hamlin | South Dakota | 46057 | 5 | 0 |
208438 | 208438 | 2020-06-04 | Hamlin | South Dakota | 46057 | 5 | 0 |
205356 | 205356 | 2020-06-03 | Hamlin | South Dakota | 46057 | 4 | 0 |
202278 | 202278 | 2020-06-02 | Hamlin | South Dakota | 46057 | 4 | 0 |
199203 | 199203 | 2020-06-01 | Hamlin | South Dakota | 46057 | 4 | 0 |
196130 | 196130 | 2020-05-31 | Hamlin | South Dakota | 46057 | 4 | 0 |
193060 | 193060 | 2020-05-30 | Hamlin | South Dakota | 46057 | 4 | 0 |
189995 | 189995 | 2020-05-29 | Hamlin | South Dakota | 46057 | 4 | 0 |
186932 | 186932 | 2020-05-28 | Hamlin | South Dakota | 46057 | 4 | 0 |
183875 | 183875 | 2020-05-27 | Hamlin | South Dakota | 46057 | 4 | 0 |
180825 | 180825 | 2020-05-26 | Hamlin | South Dakota | 46057 | 4 | 0 |
177782 | 177782 | 2020-05-25 | Hamlin | South Dakota | 46057 | 4 | 0 |
174738 | 174738 | 2020-05-24 | Hamlin | South Dakota | 46057 | 4 | 0 |
171696 | 171696 | 2020-05-23 | Hamlin | South Dakota | 46057 | 3 | 0 |
168657 | 168657 | 2020-05-22 | Hamlin | South Dakota | 46057 | 3 | 0 |
165621 | 165621 | 2020-05-21 | Hamlin | South Dakota | 46057 | 3 | 0 |
162592 | 162592 | 2020-05-20 | Hamlin | South Dakota | 46057 | 3 | 0 |
159565 | 159565 | 2020-05-19 | Hamlin | South Dakota | 46057 | 3 | 0 |
156544 | 156544 | 2020-05-18 | Hamlin | South Dakota | 46057 | 3 | 0 |
153527 | 153527 | 2020-05-17 | Hamlin | South Dakota | 46057 | 3 | 0 |
150516 | 150516 | 2020-05-16 | Hamlin | South Dakota | 46057 | 2 | 0 |
147508 | 147508 | 2020-05-15 | Hamlin | South Dakota | 46057 | 2 | 0 |
144507 | 144507 | 2020-05-14 | Hamlin | South Dakota | 46057 | 2 | 0 |
141511 | 141511 | 2020-05-13 | Hamlin | South Dakota | 46057 | 2 | 0 |
138515 | 138515 | 2020-05-12 | Hamlin | South Dakota | 46057 | 2 | 0 |
135525 | 135525 | 2020-05-11 | Hamlin | South Dakota | 46057 | 2 | 0 |
132534 | 132534 | 2020-05-10 | Hamlin | South Dakota | 46057 | 2 | 0 |
129545 | 129545 | 2020-05-09 | Hamlin | South Dakota | 46057 | 2 | 0 |
126556 | 126556 | 2020-05-08 | Hamlin | South Dakota | 46057 | 2 | 0 |
123573 | 123573 | 2020-05-07 | Hamlin | South Dakota | 46057 | 2 | 0 |
120595 | 120595 | 2020-05-06 | Hamlin | South Dakota | 46057 | 2 | 0 |
117632 | 117632 | 2020-05-05 | Hamlin | South Dakota | 46057 | 2 | 0 |
114676 | 114676 | 2020-05-04 | Hamlin | South Dakota | 46057 | 2 | 0 |
111794 | 111794 | 2020-05-03 | Hamlin | South Dakota | 46057 | 2 | 0 |
108920 | 108920 | 2020-05-02 | Hamlin | South Dakota | 46057 | 2 | 0 |
106053 | 106053 | 2020-05-01 | Hamlin | South Dakota | 46057 | 2 | 0 |
103190 | 103190 | 2020-04-30 | Hamlin | South Dakota | 46057 | 2 | 0 |
100337 | 100337 | 2020-04-29 | Hamlin | South Dakota | 46057 | 2 | 0 |
97487 | 97487 | 2020-04-28 | Hamlin | South Dakota | 46057 | 2 | 0 |
94647 | 94647 | 2020-04-27 | Hamlin | South Dakota | 46057 | 2 | 0 |
91819 | 91819 | 2020-04-26 | Hamlin | South Dakota | 46057 | 2 | 0 |
89003 | 89003 | 2020-04-25 | Hamlin | South Dakota | 46057 | 2 | 0 |
86189 | 86189 | 2020-04-24 | Hamlin | South Dakota | 46057 | 2 | 0 |
83385 | 83385 | 2020-04-23 | Hamlin | South Dakota | 46057 | 2 | 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);