ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
720 rows where county = "Jackson" and state = "South Dakota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
174743 | 174743 | 2020-05-24 | Jackson | South Dakota | 46071 | 1 | 0 |
177787 | 177787 | 2020-05-25 | Jackson | South Dakota | 46071 | 1 | 0 |
180830 | 180830 | 2020-05-26 | Jackson | South Dakota | 46071 | 2 | 0 |
183880 | 183880 | 2020-05-27 | Jackson | South Dakota | 46071 | 2 | 0 |
186937 | 186937 | 2020-05-28 | Jackson | South Dakota | 46071 | 3 | 0 |
190000 | 190000 | 2020-05-29 | Jackson | South Dakota | 46071 | 3 | 0 |
193065 | 193065 | 2020-05-30 | Jackson | South Dakota | 46071 | 4 | 0 |
196135 | 196135 | 2020-05-31 | Jackson | South Dakota | 46071 | 4 | 0 |
199208 | 199208 | 2020-06-01 | Jackson | South Dakota | 46071 | 4 | 0 |
202283 | 202283 | 2020-06-02 | Jackson | South Dakota | 46071 | 4 | 0 |
205362 | 205362 | 2020-06-03 | Jackson | South Dakota | 46071 | 4 | 0 |
208444 | 208444 | 2020-06-04 | Jackson | South Dakota | 46071 | 4 | 0 |
211526 | 211526 | 2020-06-05 | Jackson | South Dakota | 46071 | 4 | 0 |
214613 | 214613 | 2020-06-06 | Jackson | South Dakota | 46071 | 4 | 0 |
217703 | 217703 | 2020-06-07 | Jackson | South Dakota | 46071 | 4 | 0 |
220795 | 220795 | 2020-06-08 | Jackson | South Dakota | 46071 | 4 | 0 |
223890 | 223890 | 2020-06-09 | Jackson | South Dakota | 46071 | 4 | 0 |
226990 | 226990 | 2020-06-10 | Jackson | South Dakota | 46071 | 4 | 0 |
230094 | 230094 | 2020-06-11 | Jackson | South Dakota | 46071 | 4 | 0 |
233199 | 233199 | 2020-06-12 | Jackson | South Dakota | 46071 | 4 | 0 |
236304 | 236304 | 2020-06-13 | Jackson | South Dakota | 46071 | 5 | 0 |
239412 | 239412 | 2020-06-14 | Jackson | South Dakota | 46071 | 5 | 0 |
242522 | 242522 | 2020-06-15 | Jackson | South Dakota | 46071 | 5 | 0 |
245634 | 245634 | 2020-06-16 | Jackson | South Dakota | 46071 | 6 | 0 |
248747 | 248747 | 2020-06-17 | Jackson | South Dakota | 46071 | 6 | 0 |
251862 | 251862 | 2020-06-18 | Jackson | South Dakota | 46071 | 6 | 0 |
254977 | 254977 | 2020-06-19 | Jackson | South Dakota | 46071 | 6 | 1 |
258103 | 258103 | 2020-06-20 | Jackson | South Dakota | 46071 | 6 | 1 |
261230 | 261230 | 2020-06-21 | Jackson | South Dakota | 46071 | 6 | 1 |
264358 | 264358 | 2020-06-22 | Jackson | South Dakota | 46071 | 6 | 1 |
267486 | 267486 | 2020-06-23 | Jackson | South Dakota | 46071 | 6 | 1 |
270620 | 270620 | 2020-06-24 | Jackson | South Dakota | 46071 | 6 | 1 |
273759 | 273759 | 2020-06-25 | Jackson | South Dakota | 46071 | 6 | 1 |
276906 | 276906 | 2020-06-26 | Jackson | South Dakota | 46071 | 6 | 1 |
280054 | 280054 | 2020-06-27 | Jackson | South Dakota | 46071 | 6 | 1 |
283200 | 283200 | 2020-06-28 | Jackson | South Dakota | 46071 | 6 | 1 |
286345 | 286345 | 2020-06-29 | Jackson | South Dakota | 46071 | 6 | 1 |
289496 | 289496 | 2020-06-30 | Jackson | South Dakota | 46071 | 6 | 1 |
292648 | 292648 | 2020-07-01 | Jackson | South Dakota | 46071 | 6 | 1 |
295804 | 295804 | 2020-07-02 | Jackson | South Dakota | 46071 | 6 | 1 |
298964 | 298964 | 2020-07-03 | Jackson | South Dakota | 46071 | 6 | 1 |
302128 | 302128 | 2020-07-04 | Jackson | South Dakota | 46071 | 6 | 1 |
305291 | 305291 | 2020-07-05 | Jackson | South Dakota | 46071 | 6 | 1 |
308459 | 308459 | 2020-07-06 | Jackson | South Dakota | 46071 | 6 | 1 |
311628 | 311628 | 2020-07-07 | Jackson | South Dakota | 46071 | 6 | 1 |
314801 | 314801 | 2020-07-08 | Jackson | South Dakota | 46071 | 6 | 1 |
317974 | 317974 | 2020-07-09 | Jackson | South Dakota | 46071 | 6 | 1 |
321152 | 321152 | 2020-07-10 | Jackson | South Dakota | 46071 | 6 | 1 |
324332 | 324332 | 2020-07-11 | Jackson | South Dakota | 46071 | 6 | 1 |
327517 | 327517 | 2020-07-12 | Jackson | South Dakota | 46071 | 7 | 1 |
330703 | 330703 | 2020-07-13 | Jackson | South Dakota | 46071 | 7 | 1 |
333895 | 333895 | 2020-07-14 | Jackson | South Dakota | 46071 | 7 | 1 |
337089 | 337089 | 2020-07-15 | Jackson | South Dakota | 46071 | 7 | 1 |
340286 | 340286 | 2020-07-16 | Jackson | South Dakota | 46071 | 7 | 1 |
343484 | 343484 | 2020-07-17 | Jackson | South Dakota | 46071 | 7 | 1 |
346684 | 346684 | 2020-07-18 | Jackson | South Dakota | 46071 | 7 | 1 |
349884 | 349884 | 2020-07-19 | Jackson | South Dakota | 46071 | 7 | 1 |
353087 | 353087 | 2020-07-20 | Jackson | South Dakota | 46071 | 7 | 1 |
356290 | 356290 | 2020-07-21 | Jackson | South Dakota | 46071 | 7 | 1 |
359494 | 359494 | 2020-07-22 | Jackson | South Dakota | 46071 | 7 | 1 |
362700 | 362700 | 2020-07-23 | Jackson | South Dakota | 46071 | 7 | 1 |
365906 | 365906 | 2020-07-24 | Jackson | South Dakota | 46071 | 7 | 1 |
369115 | 369115 | 2020-07-25 | Jackson | South Dakota | 46071 | 7 | 1 |
372327 | 372327 | 2020-07-26 | Jackson | South Dakota | 46071 | 7 | 1 |
375540 | 375540 | 2020-07-27 | Jackson | South Dakota | 46071 | 7 | 1 |
378756 | 378756 | 2020-07-28 | Jackson | South Dakota | 46071 | 7 | 1 |
381973 | 381973 | 2020-07-29 | Jackson | South Dakota | 46071 | 7 | 1 |
385191 | 385191 | 2020-07-30 | Jackson | South Dakota | 46071 | 7 | 1 |
388408 | 388408 | 2020-07-31 | Jackson | South Dakota | 46071 | 8 | 1 |
391625 | 391625 | 2020-08-01 | Jackson | South Dakota | 46071 | 8 | 1 |
394841 | 394841 | 2020-08-02 | Jackson | South Dakota | 46071 | 9 | 1 |
398058 | 398058 | 2020-08-03 | Jackson | South Dakota | 46071 | 10 | 1 |
401273 | 401273 | 2020-08-04 | Jackson | South Dakota | 46071 | 10 | 1 |
404491 | 404491 | 2020-08-05 | Jackson | South Dakota | 46071 | 11 | 1 |
407711 | 407711 | 2020-08-06 | Jackson | South Dakota | 46071 | 11 | 1 |
410930 | 410930 | 2020-08-07 | Jackson | South Dakota | 46071 | 11 | 1 |
414150 | 414150 | 2020-08-08 | Jackson | South Dakota | 46071 | 11 | 1 |
417371 | 417371 | 2020-08-09 | Jackson | South Dakota | 46071 | 11 | 1 |
420592 | 420592 | 2020-08-10 | Jackson | South Dakota | 46071 | 11 | 1 |
423814 | 423814 | 2020-08-11 | Jackson | South Dakota | 46071 | 11 | 1 |
427037 | 427037 | 2020-08-12 | Jackson | South Dakota | 46071 | 11 | 1 |
430264 | 430264 | 2020-08-13 | Jackson | South Dakota | 46071 | 11 | 1 |
433489 | 433489 | 2020-08-14 | Jackson | South Dakota | 46071 | 11 | 1 |
436716 | 436716 | 2020-08-15 | Jackson | South Dakota | 46071 | 11 | 1 |
439941 | 439941 | 2020-08-16 | Jackson | South Dakota | 46071 | 12 | 1 |
443168 | 443168 | 2020-08-17 | Jackson | South Dakota | 46071 | 12 | 1 |
446394 | 446394 | 2020-08-18 | Jackson | South Dakota | 46071 | 12 | 1 |
449622 | 449622 | 2020-08-19 | Jackson | South Dakota | 46071 | 12 | 1 |
452850 | 452850 | 2020-08-20 | Jackson | South Dakota | 46071 | 12 | 1 |
456078 | 456078 | 2020-08-21 | Jackson | South Dakota | 46071 | 12 | 1 |
459306 | 459306 | 2020-08-22 | Jackson | South Dakota | 46071 | 12 | 1 |
462534 | 462534 | 2020-08-23 | Jackson | South Dakota | 46071 | 12 | 1 |
465763 | 465763 | 2020-08-24 | Jackson | South Dakota | 46071 | 12 | 1 |
468991 | 468991 | 2020-08-25 | Jackson | South Dakota | 46071 | 12 | 1 |
472223 | 472223 | 2020-08-26 | Jackson | South Dakota | 46071 | 12 | 1 |
475457 | 475457 | 2020-08-27 | Jackson | South Dakota | 46071 | 12 | 1 |
478690 | 478690 | 2020-08-28 | Jackson | South Dakota | 46071 | 12 | 1 |
481924 | 481924 | 2020-08-29 | Jackson | South Dakota | 46071 | 12 | 1 |
485159 | 485159 | 2020-08-30 | Jackson | South Dakota | 46071 | 12 | 1 |
488392 | 488392 | 2020-08-31 | Jackson | South Dakota | 46071 | 12 | 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);