ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
713 rows where fips = 46053 and state = "South Dakota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
196129 | 196129 | 2020-05-31 | Gregory | South Dakota | 46053 | 1 | 0 |
199202 | 199202 | 2020-06-01 | Gregory | South Dakota | 46053 | 1 | 0 |
202277 | 202277 | 2020-06-02 | Gregory | South Dakota | 46053 | 1 | 0 |
205355 | 205355 | 2020-06-03 | Gregory | South Dakota | 46053 | 1 | 0 |
208437 | 208437 | 2020-06-04 | Gregory | South Dakota | 46053 | 1 | 0 |
211519 | 211519 | 2020-06-05 | Gregory | South Dakota | 46053 | 1 | 0 |
214606 | 214606 | 2020-06-06 | Gregory | South Dakota | 46053 | 1 | 0 |
217696 | 217696 | 2020-06-07 | Gregory | South Dakota | 46053 | 1 | 0 |
220788 | 220788 | 2020-06-08 | Gregory | South Dakota | 46053 | 1 | 0 |
223883 | 223883 | 2020-06-09 | Gregory | South Dakota | 46053 | 1 | 0 |
226983 | 226983 | 2020-06-10 | Gregory | South Dakota | 46053 | 1 | 0 |
230087 | 230087 | 2020-06-11 | Gregory | South Dakota | 46053 | 1 | 0 |
233192 | 233192 | 2020-06-12 | Gregory | South Dakota | 46053 | 1 | 0 |
236297 | 236297 | 2020-06-13 | Gregory | South Dakota | 46053 | 1 | 0 |
239405 | 239405 | 2020-06-14 | Gregory | South Dakota | 46053 | 1 | 0 |
242515 | 242515 | 2020-06-15 | Gregory | South Dakota | 46053 | 1 | 0 |
245627 | 245627 | 2020-06-16 | Gregory | South Dakota | 46053 | 1 | 0 |
248740 | 248740 | 2020-06-17 | Gregory | South Dakota | 46053 | 1 | 0 |
251855 | 251855 | 2020-06-18 | Gregory | South Dakota | 46053 | 1 | 0 |
254970 | 254970 | 2020-06-19 | Gregory | South Dakota | 46053 | 1 | 0 |
258096 | 258096 | 2020-06-20 | Gregory | South Dakota | 46053 | 1 | 0 |
261223 | 261223 | 2020-06-21 | Gregory | South Dakota | 46053 | 1 | 0 |
264351 | 264351 | 2020-06-22 | Gregory | South Dakota | 46053 | 1 | 0 |
267479 | 267479 | 2020-06-23 | Gregory | South Dakota | 46053 | 1 | 0 |
270613 | 270613 | 2020-06-24 | Gregory | South Dakota | 46053 | 1 | 0 |
273752 | 273752 | 2020-06-25 | Gregory | South Dakota | 46053 | 1 | 0 |
276899 | 276899 | 2020-06-26 | Gregory | South Dakota | 46053 | 2 | 0 |
280047 | 280047 | 2020-06-27 | Gregory | South Dakota | 46053 | 2 | 0 |
283193 | 283193 | 2020-06-28 | Gregory | South Dakota | 46053 | 2 | 0 |
286338 | 286338 | 2020-06-29 | Gregory | South Dakota | 46053 | 3 | 0 |
289489 | 289489 | 2020-06-30 | Gregory | South Dakota | 46053 | 3 | 0 |
292641 | 292641 | 2020-07-01 | Gregory | South Dakota | 46053 | 4 | 0 |
295797 | 295797 | 2020-07-02 | Gregory | South Dakota | 46053 | 4 | 0 |
298957 | 298957 | 2020-07-03 | Gregory | South Dakota | 46053 | 4 | 0 |
302121 | 302121 | 2020-07-04 | Gregory | South Dakota | 46053 | 4 | 0 |
305284 | 305284 | 2020-07-05 | Gregory | South Dakota | 46053 | 4 | 0 |
308451 | 308451 | 2020-07-06 | Gregory | South Dakota | 46053 | 4 | 0 |
311620 | 311620 | 2020-07-07 | Gregory | South Dakota | 46053 | 4 | 0 |
314793 | 314793 | 2020-07-08 | Gregory | South Dakota | 46053 | 4 | 0 |
317966 | 317966 | 2020-07-09 | Gregory | South Dakota | 46053 | 5 | 0 |
321144 | 321144 | 2020-07-10 | Gregory | South Dakota | 46053 | 5 | 0 |
324324 | 324324 | 2020-07-11 | Gregory | South Dakota | 46053 | 5 | 0 |
327509 | 327509 | 2020-07-12 | Gregory | South Dakota | 46053 | 5 | 0 |
330695 | 330695 | 2020-07-13 | Gregory | South Dakota | 46053 | 5 | 0 |
333887 | 333887 | 2020-07-14 | Gregory | South Dakota | 46053 | 6 | 0 |
337081 | 337081 | 2020-07-15 | Gregory | South Dakota | 46053 | 6 | 0 |
340278 | 340278 | 2020-07-16 | Gregory | South Dakota | 46053 | 6 | 0 |
343476 | 343476 | 2020-07-17 | Gregory | South Dakota | 46053 | 6 | 0 |
346676 | 346676 | 2020-07-18 | Gregory | South Dakota | 46053 | 6 | 0 |
349876 | 349876 | 2020-07-19 | Gregory | South Dakota | 46053 | 6 | 0 |
353079 | 353079 | 2020-07-20 | Gregory | South Dakota | 46053 | 6 | 0 |
356282 | 356282 | 2020-07-21 | Gregory | South Dakota | 46053 | 6 | 0 |
359486 | 359486 | 2020-07-22 | Gregory | South Dakota | 46053 | 6 | 0 |
362692 | 362692 | 2020-07-23 | Gregory | South Dakota | 46053 | 6 | 0 |
365898 | 365898 | 2020-07-24 | Gregory | South Dakota | 46053 | 6 | 0 |
369107 | 369107 | 2020-07-25 | Gregory | South Dakota | 46053 | 6 | 0 |
372319 | 372319 | 2020-07-26 | Gregory | South Dakota | 46053 | 6 | 0 |
375532 | 375532 | 2020-07-27 | Gregory | South Dakota | 46053 | 6 | 0 |
378748 | 378748 | 2020-07-28 | Gregory | South Dakota | 46053 | 7 | 0 |
381965 | 381965 | 2020-07-29 | Gregory | South Dakota | 46053 | 7 | 0 |
385183 | 385183 | 2020-07-30 | Gregory | South Dakota | 46053 | 7 | 0 |
388400 | 388400 | 2020-07-31 | Gregory | South Dakota | 46053 | 7 | 0 |
391617 | 391617 | 2020-08-01 | Gregory | South Dakota | 46053 | 7 | 0 |
394833 | 394833 | 2020-08-02 | Gregory | South Dakota | 46053 | 7 | 0 |
398050 | 398050 | 2020-08-03 | Gregory | South Dakota | 46053 | 7 | 0 |
401265 | 401265 | 2020-08-04 | Gregory | South Dakota | 46053 | 7 | 0 |
404483 | 404483 | 2020-08-05 | Gregory | South Dakota | 46053 | 7 | 0 |
407703 | 407703 | 2020-08-06 | Gregory | South Dakota | 46053 | 7 | 0 |
410922 | 410922 | 2020-08-07 | Gregory | South Dakota | 46053 | 7 | 0 |
414142 | 414142 | 2020-08-08 | Gregory | South Dakota | 46053 | 7 | 0 |
417363 | 417363 | 2020-08-09 | Gregory | South Dakota | 46053 | 7 | 0 |
420584 | 420584 | 2020-08-10 | Gregory | South Dakota | 46053 | 7 | 0 |
423806 | 423806 | 2020-08-11 | Gregory | South Dakota | 46053 | 7 | 0 |
427029 | 427029 | 2020-08-12 | Gregory | South Dakota | 46053 | 7 | 0 |
430255 | 430255 | 2020-08-13 | Gregory | South Dakota | 46053 | 7 | 0 |
433480 | 433480 | 2020-08-14 | Gregory | South Dakota | 46053 | 7 | 0 |
436707 | 436707 | 2020-08-15 | Gregory | South Dakota | 46053 | 7 | 0 |
439932 | 439932 | 2020-08-16 | Gregory | South Dakota | 46053 | 7 | 0 |
443159 | 443159 | 2020-08-17 | Gregory | South Dakota | 46053 | 8 | 0 |
446385 | 446385 | 2020-08-18 | Gregory | South Dakota | 46053 | 8 | 0 |
449613 | 449613 | 2020-08-19 | Gregory | South Dakota | 46053 | 8 | 0 |
452841 | 452841 | 2020-08-20 | Gregory | South Dakota | 46053 | 8 | 0 |
456069 | 456069 | 2020-08-21 | Gregory | South Dakota | 46053 | 8 | 0 |
459297 | 459297 | 2020-08-22 | Gregory | South Dakota | 46053 | 8 | 0 |
462525 | 462525 | 2020-08-23 | Gregory | South Dakota | 46053 | 8 | 0 |
465754 | 465754 | 2020-08-24 | Gregory | South Dakota | 46053 | 9 | 0 |
468982 | 468982 | 2020-08-25 | Gregory | South Dakota | 46053 | 10 | 0 |
472214 | 472214 | 2020-08-26 | Gregory | South Dakota | 46053 | 10 | 0 |
475448 | 475448 | 2020-08-27 | Gregory | South Dakota | 46053 | 14 | 0 |
478681 | 478681 | 2020-08-28 | Gregory | South Dakota | 46053 | 16 | 0 |
481915 | 481915 | 2020-08-29 | Gregory | South Dakota | 46053 | 17 | 0 |
485150 | 485150 | 2020-08-30 | Gregory | South Dakota | 46053 | 19 | 0 |
488383 | 488383 | 2020-08-31 | Gregory | South Dakota | 46053 | 22 | 0 |
491616 | 491616 | 2020-09-01 | Gregory | South Dakota | 46053 | 25 | 0 |
494850 | 494850 | 2020-09-02 | Gregory | South Dakota | 46053 | 32 | 1 |
498083 | 498083 | 2020-09-03 | Gregory | South Dakota | 46053 | 34 | 1 |
501317 | 501317 | 2020-09-04 | Gregory | South Dakota | 46053 | 35 | 1 |
504551 | 504551 | 2020-09-05 | Gregory | South Dakota | 46053 | 35 | 1 |
507783 | 507783 | 2020-09-06 | Gregory | South Dakota | 46053 | 37 | 1 |
511016 | 511016 | 2020-09-07 | Gregory | South Dakota | 46053 | 39 | 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);