ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
738 rows where county = "Grant" and state = "South Dakota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
433479 | 433479 | 2020-08-14 | Grant | South Dakota | 46051 | 31 | 0 |
436706 | 436706 | 2020-08-15 | Grant | South Dakota | 46051 | 32 | 0 |
439931 | 439931 | 2020-08-16 | Grant | South Dakota | 46051 | 33 | 0 |
443158 | 443158 | 2020-08-17 | Grant | South Dakota | 46051 | 33 | 0 |
446384 | 446384 | 2020-08-18 | Grant | South Dakota | 46051 | 34 | 0 |
449612 | 449612 | 2020-08-19 | Grant | South Dakota | 46051 | 34 | 0 |
452840 | 452840 | 2020-08-20 | Grant | South Dakota | 46051 | 34 | 0 |
456068 | 456068 | 2020-08-21 | Grant | South Dakota | 46051 | 38 | 0 |
459296 | 459296 | 2020-08-22 | Grant | South Dakota | 46051 | 39 | 0 |
462524 | 462524 | 2020-08-23 | Grant | South Dakota | 46051 | 39 | 0 |
465753 | 465753 | 2020-08-24 | Grant | South Dakota | 46051 | 39 | 0 |
468981 | 468981 | 2020-08-25 | Grant | South Dakota | 46051 | 39 | 0 |
472213 | 472213 | 2020-08-26 | Grant | South Dakota | 46051 | 39 | 0 |
475447 | 475447 | 2020-08-27 | Grant | South Dakota | 46051 | 41 | 0 |
478680 | 478680 | 2020-08-28 | Grant | South Dakota | 46051 | 41 | 0 |
481914 | 481914 | 2020-08-29 | Grant | South Dakota | 46051 | 41 | 0 |
485149 | 485149 | 2020-08-30 | Grant | South Dakota | 46051 | 42 | 0 |
488382 | 488382 | 2020-08-31 | Grant | South Dakota | 46051 | 42 | 0 |
491615 | 491615 | 2020-09-01 | Grant | South Dakota | 46051 | 42 | 0 |
494849 | 494849 | 2020-09-02 | Grant | South Dakota | 46051 | 44 | 0 |
498082 | 498082 | 2020-09-03 | Grant | South Dakota | 46051 | 45 | 0 |
501316 | 501316 | 2020-09-04 | Grant | South Dakota | 46051 | 47 | 0 |
504550 | 504550 | 2020-09-05 | Grant | South Dakota | 46051 | 50 | 0 |
507782 | 507782 | 2020-09-06 | Grant | South Dakota | 46051 | 51 | 0 |
511015 | 511015 | 2020-09-07 | Grant | South Dakota | 46051 | 51 | 0 |
514248 | 514248 | 2020-09-08 | Grant | South Dakota | 46051 | 51 | 0 |
517483 | 517483 | 2020-09-09 | Grant | South Dakota | 46051 | 52 | 0 |
520719 | 520719 | 2020-09-10 | Grant | South Dakota | 46051 | 55 | 0 |
523955 | 523955 | 2020-09-11 | Grant | South Dakota | 46051 | 58 | 0 |
527191 | 527191 | 2020-09-12 | Grant | South Dakota | 46051 | 60 | 1 |
530428 | 530428 | 2020-09-13 | Grant | South Dakota | 46051 | 63 | 1 |
533663 | 533663 | 2020-09-14 | Grant | South Dakota | 46051 | 64 | 1 |
536899 | 536899 | 2020-09-15 | Grant | South Dakota | 46051 | 66 | 1 |
540136 | 540136 | 2020-09-16 | Grant | South Dakota | 46051 | 72 | 1 |
543372 | 543372 | 2020-09-17 | Grant | South Dakota | 46051 | 75 | 1 |
546609 | 546609 | 2020-09-18 | Grant | South Dakota | 46051 | 85 | 1 |
549848 | 549848 | 2020-09-19 | Grant | South Dakota | 46051 | 87 | 1 |
553087 | 553087 | 2020-09-20 | Grant | South Dakota | 46051 | 90 | 1 |
556324 | 556324 | 2020-09-21 | Grant | South Dakota | 46051 | 92 | 1 |
559561 | 559561 | 2020-09-22 | Grant | South Dakota | 46051 | 94 | 1 |
562798 | 562798 | 2020-09-23 | Grant | South Dakota | 46051 | 98 | 1 |
566039 | 566039 | 2020-09-24 | Grant | South Dakota | 46051 | 106 | 1 |
569280 | 569280 | 2020-09-25 | Grant | South Dakota | 46051 | 114 | 1 |
572522 | 572522 | 2020-09-26 | Grant | South Dakota | 46051 | 124 | 1 |
575766 | 575766 | 2020-09-27 | Grant | South Dakota | 46051 | 128 | 1 |
579007 | 579007 | 2020-09-28 | Grant | South Dakota | 46051 | 133 | 1 |
582247 | 582247 | 2020-09-29 | Grant | South Dakota | 46051 | 139 | 1 |
585487 | 585487 | 2020-09-30 | Grant | South Dakota | 46051 | 144 | 1 |
588727 | 588727 | 2020-10-01 | Grant | South Dakota | 46051 | 158 | 1 |
591968 | 591968 | 2020-10-02 | Grant | South Dakota | 46051 | 165 | 1 |
595209 | 595209 | 2020-10-03 | Grant | South Dakota | 46051 | 172 | 1 |
598452 | 598452 | 2020-10-04 | Grant | South Dakota | 46051 | 180 | 1 |
601695 | 601695 | 2020-10-05 | Grant | South Dakota | 46051 | 185 | 1 |
604937 | 604937 | 2020-10-06 | Grant | South Dakota | 46051 | 188 | 1 |
608180 | 608180 | 2020-10-07 | Grant | South Dakota | 46051 | 194 | 1 |
611422 | 611422 | 2020-10-08 | Grant | South Dakota | 46051 | 197 | 1 |
614663 | 614663 | 2020-10-09 | Grant | South Dakota | 46051 | 206 | 2 |
617905 | 617905 | 2020-10-10 | Grant | South Dakota | 46051 | 213 | 2 |
621148 | 621148 | 2020-10-11 | Grant | South Dakota | 46051 | 217 | 2 |
624391 | 624391 | 2020-10-12 | Grant | South Dakota | 46051 | 222 | 2 |
627633 | 627633 | 2020-10-13 | Grant | South Dakota | 46051 | 224 | 2 |
630877 | 630877 | 2020-10-14 | Grant | South Dakota | 46051 | 228 | 2 |
634122 | 634122 | 2020-10-15 | Grant | South Dakota | 46051 | 237 | 2 |
637368 | 637368 | 2020-10-16 | Grant | South Dakota | 46051 | 244 | 2 |
640614 | 640614 | 2020-10-17 | Grant | South Dakota | 46051 | 251 | 2 |
643862 | 643862 | 2020-10-18 | Grant | South Dakota | 46051 | 257 | 2 |
647108 | 647108 | 2020-10-19 | Grant | South Dakota | 46051 | 262 | 2 |
650352 | 650352 | 2020-10-20 | Grant | South Dakota | 46051 | 269 | 2 |
653597 | 653597 | 2020-10-21 | Grant | South Dakota | 46051 | 273 | 2 |
656842 | 656842 | 2020-10-22 | Grant | South Dakota | 46051 | 278 | 2 |
660086 | 660086 | 2020-10-23 | Grant | South Dakota | 46051 | 280 | 2 |
663330 | 663330 | 2020-10-24 | Grant | South Dakota | 46051 | 284 | 2 |
666575 | 666575 | 2020-10-25 | Grant | South Dakota | 46051 | 290 | 2 |
669819 | 669819 | 2020-10-26 | Grant | South Dakota | 46051 | 290 | 2 |
673061 | 673061 | 2020-10-27 | Grant | South Dakota | 46051 | 290 | 2 |
676304 | 676304 | 2020-10-28 | Grant | South Dakota | 46051 | 304 | 2 |
679547 | 679547 | 2020-10-29 | Grant | South Dakota | 46051 | 305 | 2 |
682790 | 682790 | 2020-10-30 | Grant | South Dakota | 46051 | 310 | 2 |
686033 | 686033 | 2020-10-31 | Grant | South Dakota | 46051 | 313 | 2 |
689278 | 689278 | 2020-11-01 | Grant | South Dakota | 46051 | 326 | 2 |
692522 | 692522 | 2020-11-02 | Grant | South Dakota | 46051 | 330 | 3 |
695764 | 695764 | 2020-11-03 | Grant | South Dakota | 46051 | 334 | 3 |
699007 | 699007 | 2020-11-04 | Grant | South Dakota | 46051 | 341 | 3 |
702251 | 702251 | 2020-11-05 | Grant | South Dakota | 46051 | 348 | 3 |
705494 | 705494 | 2020-11-06 | Grant | South Dakota | 46051 | 362 | 3 |
708737 | 708737 | 2020-11-07 | Grant | South Dakota | 46051 | 375 | 4 |
711981 | 711981 | 2020-11-08 | Grant | South Dakota | 46051 | 391 | 4 |
715225 | 715225 | 2020-11-09 | Grant | South Dakota | 46051 | 398 | 4 |
718468 | 718468 | 2020-11-10 | Grant | South Dakota | 46051 | 402 | 4 |
721711 | 721711 | 2020-11-11 | Grant | South Dakota | 46051 | 413 | 4 |
724954 | 724954 | 2020-11-12 | Grant | South Dakota | 46051 | 425 | 4 |
728198 | 728198 | 2020-11-13 | Grant | South Dakota | 46051 | 442 | 4 |
731442 | 731442 | 2020-11-14 | Grant | South Dakota | 46051 | 462 | 5 |
734688 | 734688 | 2020-11-15 | Grant | South Dakota | 46051 | 475 | 5 |
737932 | 737932 | 2020-11-16 | Grant | South Dakota | 46051 | 482 | 5 |
741178 | 741178 | 2020-11-17 | Grant | South Dakota | 46051 | 488 | 5 |
744425 | 744425 | 2020-11-18 | Grant | South Dakota | 46051 | 495 | 5 |
747671 | 747671 | 2020-11-19 | Grant | South Dakota | 46051 | 505 | 5 |
750917 | 750917 | 2020-11-20 | Grant | South Dakota | 46051 | 522 | 5 |
754163 | 754163 | 2020-11-21 | Grant | South Dakota | 46051 | 539 | 5 |
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);