ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
677 rows where county = "Haakon" and state = "South Dakota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
308452 | 308452 | 2020-07-06 | Haakon | South Dakota | 46055 | 1 | 0 |
311621 | 311621 | 2020-07-07 | Haakon | South Dakota | 46055 | 1 | 0 |
314794 | 314794 | 2020-07-08 | Haakon | South Dakota | 46055 | 1 | 0 |
317967 | 317967 | 2020-07-09 | Haakon | South Dakota | 46055 | 1 | 0 |
321145 | 321145 | 2020-07-10 | Haakon | South Dakota | 46055 | 1 | 0 |
324325 | 324325 | 2020-07-11 | Haakon | South Dakota | 46055 | 1 | 0 |
327510 | 327510 | 2020-07-12 | Haakon | South Dakota | 46055 | 1 | 0 |
330696 | 330696 | 2020-07-13 | Haakon | South Dakota | 46055 | 1 | 0 |
333888 | 333888 | 2020-07-14 | Haakon | South Dakota | 46055 | 1 | 0 |
337082 | 337082 | 2020-07-15 | Haakon | South Dakota | 46055 | 1 | 0 |
340279 | 340279 | 2020-07-16 | Haakon | South Dakota | 46055 | 1 | 0 |
343477 | 343477 | 2020-07-17 | Haakon | South Dakota | 46055 | 1 | 0 |
346677 | 346677 | 2020-07-18 | Haakon | South Dakota | 46055 | 1 | 0 |
349877 | 349877 | 2020-07-19 | Haakon | South Dakota | 46055 | 1 | 0 |
353080 | 353080 | 2020-07-20 | Haakon | South Dakota | 46055 | 1 | 0 |
356283 | 356283 | 2020-07-21 | Haakon | South Dakota | 46055 | 1 | 0 |
359487 | 359487 | 2020-07-22 | Haakon | South Dakota | 46055 | 1 | 0 |
362693 | 362693 | 2020-07-23 | Haakon | South Dakota | 46055 | 1 | 0 |
365899 | 365899 | 2020-07-24 | Haakon | South Dakota | 46055 | 1 | 0 |
369108 | 369108 | 2020-07-25 | Haakon | South Dakota | 46055 | 1 | 0 |
372320 | 372320 | 2020-07-26 | Haakon | South Dakota | 46055 | 1 | 0 |
375533 | 375533 | 2020-07-27 | Haakon | South Dakota | 46055 | 1 | 0 |
378749 | 378749 | 2020-07-28 | Haakon | South Dakota | 46055 | 1 | 0 |
381966 | 381966 | 2020-07-29 | Haakon | South Dakota | 46055 | 1 | 0 |
385184 | 385184 | 2020-07-30 | Haakon | South Dakota | 46055 | 1 | 0 |
388401 | 388401 | 2020-07-31 | Haakon | South Dakota | 46055 | 1 | 0 |
391618 | 391618 | 2020-08-01 | Haakon | South Dakota | 46055 | 2 | 0 |
394834 | 394834 | 2020-08-02 | Haakon | South Dakota | 46055 | 2 | 0 |
398051 | 398051 | 2020-08-03 | Haakon | South Dakota | 46055 | 2 | 0 |
401266 | 401266 | 2020-08-04 | Haakon | South Dakota | 46055 | 2 | 0 |
404484 | 404484 | 2020-08-05 | Haakon | South Dakota | 46055 | 2 | 0 |
407704 | 407704 | 2020-08-06 | Haakon | South Dakota | 46055 | 2 | 0 |
410923 | 410923 | 2020-08-07 | Haakon | South Dakota | 46055 | 2 | 0 |
414143 | 414143 | 2020-08-08 | Haakon | South Dakota | 46055 | 2 | 0 |
417364 | 417364 | 2020-08-09 | Haakon | South Dakota | 46055 | 2 | 0 |
420585 | 420585 | 2020-08-10 | Haakon | South Dakota | 46055 | 2 | 0 |
423807 | 423807 | 2020-08-11 | Haakon | South Dakota | 46055 | 2 | 0 |
427030 | 427030 | 2020-08-12 | Haakon | South Dakota | 46055 | 2 | 0 |
430256 | 430256 | 2020-08-13 | Haakon | South Dakota | 46055 | 2 | 0 |
433481 | 433481 | 2020-08-14 | Haakon | South Dakota | 46055 | 2 | 0 |
436708 | 436708 | 2020-08-15 | Haakon | South Dakota | 46055 | 2 | 0 |
439933 | 439933 | 2020-08-16 | Haakon | South Dakota | 46055 | 2 | 0 |
443160 | 443160 | 2020-08-17 | Haakon | South Dakota | 46055 | 2 | 0 |
446386 | 446386 | 2020-08-18 | Haakon | South Dakota | 46055 | 2 | 0 |
449614 | 449614 | 2020-08-19 | Haakon | South Dakota | 46055 | 3 | 0 |
452842 | 452842 | 2020-08-20 | Haakon | South Dakota | 46055 | 3 | 0 |
456070 | 456070 | 2020-08-21 | Haakon | South Dakota | 46055 | 3 | 0 |
459298 | 459298 | 2020-08-22 | Haakon | South Dakota | 46055 | 3 | 0 |
462526 | 462526 | 2020-08-23 | Haakon | South Dakota | 46055 | 3 | 0 |
465755 | 465755 | 2020-08-24 | Haakon | South Dakota | 46055 | 3 | 0 |
468983 | 468983 | 2020-08-25 | Haakon | South Dakota | 46055 | 3 | 0 |
472215 | 472215 | 2020-08-26 | Haakon | South Dakota | 46055 | 3 | 0 |
475449 | 475449 | 2020-08-27 | Haakon | South Dakota | 46055 | 5 | 0 |
478682 | 478682 | 2020-08-28 | Haakon | South Dakota | 46055 | 6 | 0 |
481916 | 481916 | 2020-08-29 | Haakon | South Dakota | 46055 | 6 | 0 |
485151 | 485151 | 2020-08-30 | Haakon | South Dakota | 46055 | 6 | 0 |
488384 | 488384 | 2020-08-31 | Haakon | South Dakota | 46055 | 6 | 0 |
491617 | 491617 | 2020-09-01 | Haakon | South Dakota | 46055 | 6 | 0 |
494851 | 494851 | 2020-09-02 | Haakon | South Dakota | 46055 | 6 | 0 |
498084 | 498084 | 2020-09-03 | Haakon | South Dakota | 46055 | 6 | 0 |
501318 | 501318 | 2020-09-04 | Haakon | South Dakota | 46055 | 6 | 0 |
504552 | 504552 | 2020-09-05 | Haakon | South Dakota | 46055 | 6 | 0 |
507784 | 507784 | 2020-09-06 | Haakon | South Dakota | 46055 | 6 | 0 |
511017 | 511017 | 2020-09-07 | Haakon | South Dakota | 46055 | 7 | 0 |
514250 | 514250 | 2020-09-08 | Haakon | South Dakota | 46055 | 8 | 0 |
517485 | 517485 | 2020-09-09 | Haakon | South Dakota | 46055 | 8 | 0 |
520721 | 520721 | 2020-09-10 | Haakon | South Dakota | 46055 | 8 | 0 |
523957 | 523957 | 2020-09-11 | Haakon | South Dakota | 46055 | 10 | 0 |
527193 | 527193 | 2020-09-12 | Haakon | South Dakota | 46055 | 10 | 0 |
530430 | 530430 | 2020-09-13 | Haakon | South Dakota | 46055 | 11 | 0 |
533665 | 533665 | 2020-09-14 | Haakon | South Dakota | 46055 | 11 | 0 |
536901 | 536901 | 2020-09-15 | Haakon | South Dakota | 46055 | 12 | 0 |
540138 | 540138 | 2020-09-16 | Haakon | South Dakota | 46055 | 15 | 0 |
543374 | 543374 | 2020-09-17 | Haakon | South Dakota | 46055 | 15 | 0 |
546611 | 546611 | 2020-09-18 | Haakon | South Dakota | 46055 | 15 | 0 |
549850 | 549850 | 2020-09-19 | Haakon | South Dakota | 46055 | 17 | 0 |
553089 | 553089 | 2020-09-20 | Haakon | South Dakota | 46055 | 17 | 0 |
556326 | 556326 | 2020-09-21 | Haakon | South Dakota | 46055 | 18 | 0 |
559563 | 559563 | 2020-09-22 | Haakon | South Dakota | 46055 | 18 | 0 |
562800 | 562800 | 2020-09-23 | Haakon | South Dakota | 46055 | 19 | 0 |
566041 | 566041 | 2020-09-24 | Haakon | South Dakota | 46055 | 21 | 0 |
569282 | 569282 | 2020-09-25 | Haakon | South Dakota | 46055 | 22 | 0 |
572524 | 572524 | 2020-09-26 | Haakon | South Dakota | 46055 | 23 | 0 |
575768 | 575768 | 2020-09-27 | Haakon | South Dakota | 46055 | 24 | 0 |
579009 | 579009 | 2020-09-28 | Haakon | South Dakota | 46055 | 26 | 0 |
582249 | 582249 | 2020-09-29 | Haakon | South Dakota | 46055 | 26 | 0 |
585489 | 585489 | 2020-09-30 | Haakon | South Dakota | 46055 | 27 | 0 |
588729 | 588729 | 2020-10-01 | Haakon | South Dakota | 46055 | 28 | 1 |
591970 | 591970 | 2020-10-02 | Haakon | South Dakota | 46055 | 29 | 1 |
595211 | 595211 | 2020-10-03 | Haakon | South Dakota | 46055 | 32 | 1 |
598454 | 598454 | 2020-10-04 | Haakon | South Dakota | 46055 | 33 | 1 |
601697 | 601697 | 2020-10-05 | Haakon | South Dakota | 46055 | 33 | 1 |
604939 | 604939 | 2020-10-06 | Haakon | South Dakota | 46055 | 33 | 1 |
608182 | 608182 | 2020-10-07 | Haakon | South Dakota | 46055 | 37 | 1 |
611424 | 611424 | 2020-10-08 | Haakon | South Dakota | 46055 | 37 | 1 |
614665 | 614665 | 2020-10-09 | Haakon | South Dakota | 46055 | 41 | 1 |
617907 | 617907 | 2020-10-10 | Haakon | South Dakota | 46055 | 41 | 1 |
621150 | 621150 | 2020-10-11 | Haakon | South Dakota | 46055 | 44 | 1 |
624393 | 624393 | 2020-10-12 | Haakon | South Dakota | 46055 | 46 | 1 |
627635 | 627635 | 2020-10-13 | Haakon | South Dakota | 46055 | 51 | 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);