ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where county = "Hand" and state = "South Dakota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
91820 | 91820 | 2020-04-26 | Hand | South Dakota | 46059 | 1 | 0 |
94648 | 94648 | 2020-04-27 | Hand | South Dakota | 46059 | 1 | 0 |
97488 | 97488 | 2020-04-28 | Hand | South Dakota | 46059 | 1 | 0 |
100338 | 100338 | 2020-04-29 | Hand | South Dakota | 46059 | 1 | 0 |
103191 | 103191 | 2020-04-30 | Hand | South Dakota | 46059 | 1 | 0 |
106054 | 106054 | 2020-05-01 | Hand | South Dakota | 46059 | 1 | 0 |
108921 | 108921 | 2020-05-02 | Hand | South Dakota | 46059 | 1 | 0 |
111795 | 111795 | 2020-05-03 | Hand | South Dakota | 46059 | 1 | 0 |
114677 | 114677 | 2020-05-04 | Hand | South Dakota | 46059 | 1 | 0 |
117633 | 117633 | 2020-05-05 | Hand | South Dakota | 46059 | 1 | 0 |
120596 | 120596 | 2020-05-06 | Hand | South Dakota | 46059 | 1 | 0 |
123574 | 123574 | 2020-05-07 | Hand | South Dakota | 46059 | 1 | 0 |
126557 | 126557 | 2020-05-08 | Hand | South Dakota | 46059 | 1 | 0 |
129546 | 129546 | 2020-05-09 | Hand | South Dakota | 46059 | 1 | 0 |
132535 | 132535 | 2020-05-10 | Hand | South Dakota | 46059 | 1 | 0 |
135526 | 135526 | 2020-05-11 | Hand | South Dakota | 46059 | 1 | 0 |
138516 | 138516 | 2020-05-12 | Hand | South Dakota | 46059 | 1 | 0 |
141512 | 141512 | 2020-05-13 | Hand | South Dakota | 46059 | 1 | 0 |
144508 | 144508 | 2020-05-14 | Hand | South Dakota | 46059 | 1 | 0 |
147509 | 147509 | 2020-05-15 | Hand | South Dakota | 46059 | 1 | 0 |
150517 | 150517 | 2020-05-16 | Hand | South Dakota | 46059 | 1 | 0 |
153528 | 153528 | 2020-05-17 | Hand | South Dakota | 46059 | 1 | 0 |
156545 | 156545 | 2020-05-18 | Hand | South Dakota | 46059 | 1 | 0 |
159566 | 159566 | 2020-05-19 | Hand | South Dakota | 46059 | 1 | 0 |
162593 | 162593 | 2020-05-20 | Hand | South Dakota | 46059 | 1 | 0 |
165622 | 165622 | 2020-05-21 | Hand | South Dakota | 46059 | 1 | 0 |
168658 | 168658 | 2020-05-22 | Hand | South Dakota | 46059 | 1 | 0 |
171697 | 171697 | 2020-05-23 | Hand | South Dakota | 46059 | 1 | 0 |
174739 | 174739 | 2020-05-24 | Hand | South Dakota | 46059 | 1 | 0 |
177783 | 177783 | 2020-05-25 | Hand | South Dakota | 46059 | 1 | 0 |
180826 | 180826 | 2020-05-26 | Hand | South Dakota | 46059 | 1 | 0 |
183876 | 183876 | 2020-05-27 | Hand | South Dakota | 46059 | 1 | 0 |
186933 | 186933 | 2020-05-28 | Hand | South Dakota | 46059 | 2 | 0 |
189996 | 189996 | 2020-05-29 | Hand | South Dakota | 46059 | 2 | 0 |
193061 | 193061 | 2020-05-30 | Hand | South Dakota | 46059 | 2 | 0 |
196131 | 196131 | 2020-05-31 | Hand | South Dakota | 46059 | 2 | 0 |
199204 | 199204 | 2020-06-01 | Hand | South Dakota | 46059 | 2 | 0 |
202279 | 202279 | 2020-06-02 | Hand | South Dakota | 46059 | 2 | 0 |
205357 | 205357 | 2020-06-03 | Hand | South Dakota | 46059 | 3 | 0 |
208439 | 208439 | 2020-06-04 | Hand | South Dakota | 46059 | 3 | 0 |
211521 | 211521 | 2020-06-05 | Hand | South Dakota | 46059 | 4 | 0 |
214608 | 214608 | 2020-06-06 | Hand | South Dakota | 46059 | 5 | 0 |
217698 | 217698 | 2020-06-07 | Hand | South Dakota | 46059 | 5 | 0 |
220790 | 220790 | 2020-06-08 | Hand | South Dakota | 46059 | 5 | 0 |
223885 | 223885 | 2020-06-09 | Hand | South Dakota | 46059 | 5 | 0 |
226985 | 226985 | 2020-06-10 | Hand | South Dakota | 46059 | 5 | 0 |
230089 | 230089 | 2020-06-11 | Hand | South Dakota | 46059 | 6 | 0 |
233194 | 233194 | 2020-06-12 | Hand | South Dakota | 46059 | 6 | 0 |
236299 | 236299 | 2020-06-13 | Hand | South Dakota | 46059 | 6 | 0 |
239407 | 239407 | 2020-06-14 | Hand | South Dakota | 46059 | 6 | 0 |
242517 | 242517 | 2020-06-15 | Hand | South Dakota | 46059 | 6 | 0 |
245629 | 245629 | 2020-06-16 | Hand | South Dakota | 46059 | 6 | 0 |
248742 | 248742 | 2020-06-17 | Hand | South Dakota | 46059 | 6 | 0 |
251857 | 251857 | 2020-06-18 | Hand | South Dakota | 46059 | 6 | 0 |
254972 | 254972 | 2020-06-19 | Hand | South Dakota | 46059 | 6 | 0 |
258098 | 258098 | 2020-06-20 | Hand | South Dakota | 46059 | 7 | 0 |
261225 | 261225 | 2020-06-21 | Hand | South Dakota | 46059 | 7 | 0 |
264353 | 264353 | 2020-06-22 | Hand | South Dakota | 46059 | 7 | 0 |
267481 | 267481 | 2020-06-23 | Hand | South Dakota | 46059 | 7 | 0 |
270615 | 270615 | 2020-06-24 | Hand | South Dakota | 46059 | 7 | 0 |
273754 | 273754 | 2020-06-25 | Hand | South Dakota | 46059 | 7 | 0 |
276901 | 276901 | 2020-06-26 | Hand | South Dakota | 46059 | 7 | 0 |
280049 | 280049 | 2020-06-27 | Hand | South Dakota | 46059 | 7 | 0 |
283195 | 283195 | 2020-06-28 | Hand | South Dakota | 46059 | 7 | 0 |
286340 | 286340 | 2020-06-29 | Hand | South Dakota | 46059 | 7 | 0 |
289491 | 289491 | 2020-06-30 | Hand | South Dakota | 46059 | 7 | 0 |
292643 | 292643 | 2020-07-01 | Hand | South Dakota | 46059 | 7 | 0 |
295799 | 295799 | 2020-07-02 | Hand | South Dakota | 46059 | 7 | 0 |
298959 | 298959 | 2020-07-03 | Hand | South Dakota | 46059 | 7 | 0 |
302123 | 302123 | 2020-07-04 | Hand | South Dakota | 46059 | 7 | 0 |
305286 | 305286 | 2020-07-05 | Hand | South Dakota | 46059 | 7 | 0 |
308454 | 308454 | 2020-07-06 | Hand | South Dakota | 46059 | 7 | 0 |
311623 | 311623 | 2020-07-07 | Hand | South Dakota | 46059 | 7 | 0 |
314796 | 314796 | 2020-07-08 | Hand | South Dakota | 46059 | 7 | 0 |
317969 | 317969 | 2020-07-09 | Hand | South Dakota | 46059 | 7 | 0 |
321147 | 321147 | 2020-07-10 | Hand | South Dakota | 46059 | 7 | 0 |
324327 | 324327 | 2020-07-11 | Hand | South Dakota | 46059 | 7 | 0 |
327512 | 327512 | 2020-07-12 | Hand | South Dakota | 46059 | 7 | 0 |
330698 | 330698 | 2020-07-13 | Hand | South Dakota | 46059 | 7 | 0 |
333890 | 333890 | 2020-07-14 | Hand | South Dakota | 46059 | 7 | 0 |
337084 | 337084 | 2020-07-15 | Hand | South Dakota | 46059 | 7 | 0 |
340281 | 340281 | 2020-07-16 | Hand | South Dakota | 46059 | 7 | 0 |
343479 | 343479 | 2020-07-17 | Hand | South Dakota | 46059 | 7 | 0 |
346679 | 346679 | 2020-07-18 | Hand | South Dakota | 46059 | 7 | 0 |
349879 | 349879 | 2020-07-19 | Hand | South Dakota | 46059 | 7 | 0 |
353082 | 353082 | 2020-07-20 | Hand | South Dakota | 46059 | 7 | 0 |
356285 | 356285 | 2020-07-21 | Hand | South Dakota | 46059 | 7 | 0 |
359489 | 359489 | 2020-07-22 | Hand | South Dakota | 46059 | 7 | 0 |
362695 | 362695 | 2020-07-23 | Hand | South Dakota | 46059 | 7 | 0 |
365901 | 365901 | 2020-07-24 | Hand | South Dakota | 46059 | 7 | 0 |
369110 | 369110 | 2020-07-25 | Hand | South Dakota | 46059 | 7 | 0 |
372322 | 372322 | 2020-07-26 | Hand | South Dakota | 46059 | 7 | 0 |
375535 | 375535 | 2020-07-27 | Hand | South Dakota | 46059 | 7 | 0 |
378751 | 378751 | 2020-07-28 | Hand | South Dakota | 46059 | 7 | 0 |
381968 | 381968 | 2020-07-29 | Hand | South Dakota | 46059 | 7 | 0 |
385186 | 385186 | 2020-07-30 | Hand | South Dakota | 46059 | 7 | 0 |
388403 | 388403 | 2020-07-31 | Hand | South Dakota | 46059 | 7 | 0 |
391620 | 391620 | 2020-08-01 | Hand | South Dakota | 46059 | 7 | 0 |
394836 | 394836 | 2020-08-02 | Hand | South Dakota | 46059 | 7 | 0 |
398053 | 398053 | 2020-08-03 | Hand | South Dakota | 46059 | 7 | 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);