ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Williams" and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
782945 | 782945 | 2020-11-30 | Williams | North Dakota | 38105 | 3040 | 23 |
779699 | 779699 | 2020-11-29 | Williams | North Dakota | 38105 | 3033 | 23 |
776454 | 776454 | 2020-11-28 | Williams | North Dakota | 38105 | 2993 | 23 |
773209 | 773209 | 2020-11-27 | Williams | North Dakota | 38105 | 2976 | 23 |
769964 | 769964 | 2020-11-26 | Williams | North Dakota | 38105 | 2945 | 23 |
766718 | 766718 | 2020-11-25 | Williams | North Dakota | 38105 | 2925 | 23 |
763473 | 763473 | 2020-11-24 | Williams | North Dakota | 38105 | 2902 | 22 |
760228 | 760228 | 2020-11-23 | Williams | North Dakota | 38105 | 2879 | 22 |
756982 | 756982 | 2020-11-22 | Williams | North Dakota | 38105 | 2849 | 22 |
753735 | 753735 | 2020-11-21 | Williams | North Dakota | 38105 | 2819 | 22 |
750489 | 750489 | 2020-11-20 | Williams | North Dakota | 38105 | 2759 | 22 |
747243 | 747243 | 2020-11-19 | Williams | North Dakota | 38105 | 2724 | 22 |
743997 | 743997 | 2020-11-18 | Williams | North Dakota | 38105 | 2687 | 22 |
740750 | 740750 | 2020-11-17 | Williams | North Dakota | 38105 | 2646 | 22 |
737505 | 737505 | 2020-11-16 | Williams | North Dakota | 38105 | 2606 | 22 |
734261 | 734261 | 2020-11-15 | Williams | North Dakota | 38105 | 2577 | 22 |
731015 | 731015 | 2020-11-14 | Williams | North Dakota | 38105 | 2544 | 22 |
727771 | 727771 | 2020-11-13 | Williams | North Dakota | 38105 | 2457 | 22 |
724527 | 724527 | 2020-11-12 | Williams | North Dakota | 38105 | 2401 | 22 |
721284 | 721284 | 2020-11-11 | Williams | North Dakota | 38105 | 2376 | 21 |
718041 | 718041 | 2020-11-10 | Williams | North Dakota | 38105 | 2348 | 21 |
714798 | 714798 | 2020-11-09 | Williams | North Dakota | 38105 | 2315 | 21 |
711554 | 711554 | 2020-11-08 | Williams | North Dakota | 38105 | 2273 | 21 |
708310 | 708310 | 2020-11-07 | Williams | North Dakota | 38105 | 2244 | 20 |
705067 | 705067 | 2020-11-06 | Williams | North Dakota | 38105 | 2168 | 19 |
701824 | 701824 | 2020-11-05 | Williams | North Dakota | 38105 | 2109 | 19 |
698580 | 698580 | 2020-11-04 | Williams | North Dakota | 38105 | 2065 | 18 |
695337 | 695337 | 2020-11-03 | Williams | North Dakota | 38105 | 2042 | 18 |
692095 | 692095 | 2020-11-02 | Williams | North Dakota | 38105 | 2017 | 18 |
688851 | 688851 | 2020-11-01 | Williams | North Dakota | 38105 | 1989 | 18 |
685606 | 685606 | 2020-10-31 | Williams | North Dakota | 38105 | 1967 | 18 |
682363 | 682363 | 2020-10-30 | Williams | North Dakota | 38105 | 1905 | 17 |
679120 | 679120 | 2020-10-29 | Williams | North Dakota | 38105 | 1848 | 16 |
675877 | 675877 | 2020-10-28 | Williams | North Dakota | 38105 | 1830 | 16 |
672634 | 672634 | 2020-10-27 | Williams | North Dakota | 38105 | 1797 | 16 |
669392 | 669392 | 2020-10-26 | Williams | North Dakota | 38105 | 1773 | 15 |
666148 | 666148 | 2020-10-25 | Williams | North Dakota | 38105 | 1763 | 14 |
662903 | 662903 | 2020-10-24 | Williams | North Dakota | 38105 | 1748 | 13 |
659659 | 659659 | 2020-10-23 | Williams | North Dakota | 38105 | 1705 | 12 |
656415 | 656415 | 2020-10-22 | Williams | North Dakota | 38105 | 1681 | 12 |
653170 | 653170 | 2020-10-21 | Williams | North Dakota | 38105 | 1651 | 12 |
649925 | 649925 | 2020-10-20 | Williams | North Dakota | 38105 | 1633 | 12 |
646681 | 646681 | 2020-10-19 | Williams | North Dakota | 38105 | 1601 | 12 |
643435 | 643435 | 2020-10-18 | Williams | North Dakota | 38105 | 1593 | 12 |
640187 | 640187 | 2020-10-17 | Williams | North Dakota | 38105 | 1585 | 11 |
636941 | 636941 | 2020-10-16 | Williams | North Dakota | 38105 | 1550 | 11 |
633695 | 633695 | 2020-10-15 | Williams | North Dakota | 38105 | 1516 | 10 |
630450 | 630450 | 2020-10-14 | Williams | North Dakota | 38105 | 1491 | 10 |
627206 | 627206 | 2020-10-13 | Williams | North Dakota | 38105 | 1468 | 10 |
623964 | 623964 | 2020-10-12 | Williams | North Dakota | 38105 | 1458 | 9 |
620721 | 620721 | 2020-10-11 | Williams | North Dakota | 38105 | 1440 | 9 |
617479 | 617479 | 2020-10-10 | Williams | North Dakota | 38105 | 1408 | 9 |
614237 | 614237 | 2020-10-09 | Williams | North Dakota | 38105 | 1325 | 9 |
610996 | 610996 | 2020-10-08 | Williams | North Dakota | 38105 | 1308 | 9 |
607754 | 607754 | 2020-10-07 | Williams | North Dakota | 38105 | 1276 | 9 |
604511 | 604511 | 2020-10-06 | Williams | North Dakota | 38105 | 1246 | 8 |
601269 | 601269 | 2020-10-05 | Williams | North Dakota | 38105 | 1224 | 8 |
598026 | 598026 | 2020-10-04 | Williams | North Dakota | 38105 | 1202 | 8 |
594783 | 594783 | 2020-10-03 | Williams | North Dakota | 38105 | 1173 | 7 |
591542 | 591542 | 2020-10-02 | Williams | North Dakota | 38105 | 1154 | 7 |
588301 | 588301 | 2020-10-01 | Williams | North Dakota | 38105 | 1137 | 7 |
585061 | 585061 | 2020-09-30 | Williams | North Dakota | 38105 | 1086 | 7 |
581820 | 581820 | 2020-09-29 | Williams | North Dakota | 38105 | 1046 | 7 |
578580 | 578580 | 2020-09-28 | Williams | North Dakota | 38105 | 1019 | 7 |
575339 | 575339 | 2020-09-27 | Williams | North Dakota | 38105 | 991 | 7 |
572095 | 572095 | 2020-09-26 | Williams | North Dakota | 38105 | 978 | 7 |
568853 | 568853 | 2020-09-25 | Williams | North Dakota | 38105 | 953 | 7 |
565612 | 565612 | 2020-09-24 | Williams | North Dakota | 38105 | 917 | 7 |
562371 | 562371 | 2020-09-23 | Williams | North Dakota | 38105 | 905 | 7 |
559134 | 559134 | 2020-09-22 | Williams | North Dakota | 38105 | 848 | 6 |
555897 | 555897 | 2020-09-21 | Williams | North Dakota | 38105 | 836 | 5 |
552660 | 552660 | 2020-09-20 | Williams | North Dakota | 38105 | 811 | 5 |
549421 | 549421 | 2020-09-19 | Williams | North Dakota | 38105 | 794 | 5 |
546182 | 546182 | 2020-09-18 | Williams | North Dakota | 38105 | 779 | 5 |
542945 | 542945 | 2020-09-17 | Williams | North Dakota | 38105 | 759 | 5 |
539709 | 539709 | 2020-09-16 | Williams | North Dakota | 38105 | 742 | 5 |
536472 | 536472 | 2020-09-15 | Williams | North Dakota | 38105 | 691 | 5 |
533236 | 533236 | 2020-09-14 | Williams | North Dakota | 38105 | 669 | 5 |
530001 | 530001 | 2020-09-13 | Williams | North Dakota | 38105 | 657 | 5 |
526764 | 526764 | 2020-09-12 | Williams | North Dakota | 38105 | 639 | 5 |
523528 | 523528 | 2020-09-11 | Williams | North Dakota | 38105 | 634 | 4 |
520292 | 520292 | 2020-09-10 | Williams | North Dakota | 38105 | 616 | 4 |
517056 | 517056 | 2020-09-09 | Williams | North Dakota | 38105 | 607 | 4 |
513821 | 513821 | 2020-09-08 | Williams | North Dakota | 38105 | 540 | 4 |
510588 | 510588 | 2020-09-07 | Williams | North Dakota | 38105 | 538 | 4 |
507355 | 507355 | 2020-09-06 | Williams | North Dakota | 38105 | 527 | 4 |
504123 | 504123 | 2020-09-05 | Williams | North Dakota | 38105 | 515 | 4 |
500889 | 500889 | 2020-09-04 | Williams | North Dakota | 38105 | 494 | 4 |
497655 | 497655 | 2020-09-03 | Williams | North Dakota | 38105 | 482 | 4 |
494422 | 494422 | 2020-09-02 | Williams | North Dakota | 38105 | 475 | 3 |
491188 | 491188 | 2020-09-01 | Williams | North Dakota | 38105 | 440 | 2 |
487955 | 487955 | 2020-08-31 | Williams | North Dakota | 38105 | 429 | 2 |
484722 | 484722 | 2020-08-30 | Williams | North Dakota | 38105 | 427 | 2 |
481487 | 481487 | 2020-08-29 | Williams | North Dakota | 38105 | 418 | 2 |
478254 | 478254 | 2020-08-28 | Williams | North Dakota | 38105 | 386 | 2 |
475021 | 475021 | 2020-08-27 | Williams | North Dakota | 38105 | 374 | 2 |
471787 | 471787 | 2020-08-26 | Williams | North Dakota | 38105 | 356 | 2 |
468555 | 468555 | 2020-08-25 | Williams | North Dakota | 38105 | 338 | 2 |
465327 | 465327 | 2020-08-24 | Williams | North Dakota | 38105 | 331 | 2 |
462098 | 462098 | 2020-08-23 | Williams | North Dakota | 38105 | 326 | 2 |
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);