ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Sioux" 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 |
---|---|---|---|---|---|---|---|
922483 | 922483 | 2021-01-12 | Sioux | North Dakota | 38085 | 626 | 11 |
919238 | 919238 | 2021-01-11 | Sioux | North Dakota | 38085 | 623 | 11 |
915993 | 915993 | 2021-01-10 | Sioux | North Dakota | 38085 | 623 | 11 |
912748 | 912748 | 2021-01-09 | Sioux | North Dakota | 38085 | 622 | 11 |
909503 | 909503 | 2021-01-08 | Sioux | North Dakota | 38085 | 622 | 11 |
906258 | 906258 | 2021-01-07 | Sioux | North Dakota | 38085 | 621 | 11 |
903012 | 903012 | 2021-01-06 | Sioux | North Dakota | 38085 | 610 | 11 |
899767 | 899767 | 2021-01-05 | Sioux | North Dakota | 38085 | 608 | 11 |
896522 | 896522 | 2021-01-04 | Sioux | North Dakota | 38085 | 607 | 10 |
893276 | 893276 | 2021-01-03 | Sioux | North Dakota | 38085 | 605 | 10 |
890030 | 890030 | 2021-01-02 | Sioux | North Dakota | 38085 | 604 | 10 |
886783 | 886783 | 2021-01-01 | Sioux | North Dakota | 38085 | 604 | 10 |
883538 | 883538 | 2020-12-31 | Sioux | North Dakota | 38085 | 604 | 10 |
880293 | 880293 | 2020-12-30 | Sioux | North Dakota | 38085 | 607 | 10 |
877048 | 877048 | 2020-12-29 | Sioux | North Dakota | 38085 | 605 | 10 |
873803 | 873803 | 2020-12-28 | Sioux | North Dakota | 38085 | 604 | 10 |
870558 | 870558 | 2020-12-27 | Sioux | North Dakota | 38085 | 603 | 10 |
867313 | 867313 | 2020-12-26 | Sioux | North Dakota | 38085 | 600 | 10 |
864068 | 864068 | 2020-12-25 | Sioux | North Dakota | 38085 | 600 | 10 |
860823 | 860823 | 2020-12-24 | Sioux | North Dakota | 38085 | 587 | 10 |
857578 | 857578 | 2020-12-23 | Sioux | North Dakota | 38085 | 581 | 10 |
854333 | 854333 | 2020-12-22 | Sioux | North Dakota | 38085 | 576 | 10 |
851088 | 851088 | 2020-12-21 | Sioux | North Dakota | 38085 | 577 | 10 |
847843 | 847843 | 2020-12-20 | Sioux | North Dakota | 38085 | 577 | 10 |
844598 | 844598 | 2020-12-19 | Sioux | North Dakota | 38085 | 574 | 10 |
841352 | 841352 | 2020-12-18 | Sioux | North Dakota | 38085 | 574 | 10 |
838107 | 838107 | 2020-12-17 | Sioux | North Dakota | 38085 | 572 | 10 |
834861 | 834861 | 2020-12-16 | Sioux | North Dakota | 38085 | 568 | 10 |
831615 | 831615 | 2020-12-15 | Sioux | North Dakota | 38085 | 566 | 10 |
828368 | 828368 | 2020-12-14 | Sioux | North Dakota | 38085 | 561 | 10 |
825122 | 825122 | 2020-12-13 | Sioux | North Dakota | 38085 | 558 | 9 |
821875 | 821875 | 2020-12-12 | Sioux | North Dakota | 38085 | 557 | 9 |
818629 | 818629 | 2020-12-11 | Sioux | North Dakota | 38085 | 556 | 9 |
815383 | 815383 | 2020-12-10 | Sioux | North Dakota | 38085 | 549 | 9 |
812138 | 812138 | 2020-12-09 | Sioux | North Dakota | 38085 | 550 | 9 |
808893 | 808893 | 2020-12-08 | Sioux | North Dakota | 38085 | 546 | 9 |
805648 | 805648 | 2020-12-07 | Sioux | North Dakota | 38085 | 546 | 9 |
802403 | 802403 | 2020-12-06 | Sioux | North Dakota | 38085 | 545 | 9 |
799158 | 799158 | 2020-12-05 | Sioux | North Dakota | 38085 | 537 | 9 |
795913 | 795913 | 2020-12-04 | Sioux | North Dakota | 38085 | 535 | 7 |
792668 | 792668 | 2020-12-03 | Sioux | North Dakota | 38085 | 523 | 7 |
789423 | 789423 | 2020-12-02 | Sioux | North Dakota | 38085 | 514 | 7 |
786178 | 786178 | 2020-12-01 | Sioux | North Dakota | 38085 | 504 | 7 |
782934 | 782934 | 2020-11-30 | Sioux | North Dakota | 38085 | 497 | 7 |
779688 | 779688 | 2020-11-29 | Sioux | North Dakota | 38085 | 495 | 6 |
776443 | 776443 | 2020-11-28 | Sioux | North Dakota | 38085 | 494 | 6 |
773198 | 773198 | 2020-11-27 | Sioux | North Dakota | 38085 | 481 | 6 |
769953 | 769953 | 2020-11-26 | Sioux | North Dakota | 38085 | 476 | 6 |
766707 | 766707 | 2020-11-25 | Sioux | North Dakota | 38085 | 438 | 6 |
763462 | 763462 | 2020-11-24 | Sioux | North Dakota | 38085 | 421 | 6 |
760217 | 760217 | 2020-11-23 | Sioux | North Dakota | 38085 | 419 | 6 |
756971 | 756971 | 2020-11-22 | Sioux | North Dakota | 38085 | 419 | 6 |
753724 | 753724 | 2020-11-21 | Sioux | North Dakota | 38085 | 419 | 6 |
750478 | 750478 | 2020-11-20 | Sioux | North Dakota | 38085 | 398 | 6 |
747232 | 747232 | 2020-11-19 | Sioux | North Dakota | 38085 | 389 | 6 |
743986 | 743986 | 2020-11-18 | Sioux | North Dakota | 38085 | 386 | 5 |
740739 | 740739 | 2020-11-17 | Sioux | North Dakota | 38085 | 384 | 5 |
737494 | 737494 | 2020-11-16 | Sioux | North Dakota | 38085 | 380 | 5 |
734250 | 734250 | 2020-11-15 | Sioux | North Dakota | 38085 | 380 | 5 |
731004 | 731004 | 2020-11-14 | Sioux | North Dakota | 38085 | 378 | 5 |
727760 | 727760 | 2020-11-13 | Sioux | North Dakota | 38085 | 359 | 5 |
724516 | 724516 | 2020-11-12 | Sioux | North Dakota | 38085 | 340 | 5 |
721273 | 721273 | 2020-11-11 | Sioux | North Dakota | 38085 | 334 | 5 |
718030 | 718030 | 2020-11-10 | Sioux | North Dakota | 38085 | 331 | 5 |
714787 | 714787 | 2020-11-09 | Sioux | North Dakota | 38085 | 323 | 5 |
711543 | 711543 | 2020-11-08 | Sioux | North Dakota | 38085 | 308 | 5 |
708299 | 708299 | 2020-11-07 | Sioux | North Dakota | 38085 | 308 | 5 |
705056 | 705056 | 2020-11-06 | Sioux | North Dakota | 38085 | 297 | 5 |
701813 | 701813 | 2020-11-05 | Sioux | North Dakota | 38085 | 294 | 5 |
698569 | 698569 | 2020-11-04 | Sioux | North Dakota | 38085 | 287 | 5 |
695326 | 695326 | 2020-11-03 | Sioux | North Dakota | 38085 | 282 | 5 |
692084 | 692084 | 2020-11-02 | Sioux | North Dakota | 38085 | 277 | 5 |
688840 | 688840 | 2020-11-01 | Sioux | North Dakota | 38085 | 276 | 5 |
685595 | 685595 | 2020-10-31 | Sioux | North Dakota | 38085 | 274 | 5 |
682352 | 682352 | 2020-10-30 | Sioux | North Dakota | 38085 | 265 | 5 |
679109 | 679109 | 2020-10-29 | Sioux | North Dakota | 38085 | 258 | 5 |
675866 | 675866 | 2020-10-28 | Sioux | North Dakota | 38085 | 250 | 5 |
672623 | 672623 | 2020-10-27 | Sioux | North Dakota | 38085 | 249 | 5 |
669381 | 669381 | 2020-10-26 | Sioux | North Dakota | 38085 | 250 | 5 |
666137 | 666137 | 2020-10-25 | Sioux | North Dakota | 38085 | 250 | 4 |
662892 | 662892 | 2020-10-24 | Sioux | North Dakota | 38085 | 243 | 4 |
659648 | 659648 | 2020-10-23 | Sioux | North Dakota | 38085 | 236 | 4 |
656404 | 656404 | 2020-10-22 | Sioux | North Dakota | 38085 | 233 | 4 |
653159 | 653159 | 2020-10-21 | Sioux | North Dakota | 38085 | 218 | 4 |
649914 | 649914 | 2020-10-20 | Sioux | North Dakota | 38085 | 218 | 4 |
646670 | 646670 | 2020-10-19 | Sioux | North Dakota | 38085 | 214 | 4 |
643424 | 643424 | 2020-10-18 | Sioux | North Dakota | 38085 | 213 | 4 |
640176 | 640176 | 2020-10-17 | Sioux | North Dakota | 38085 | 213 | 3 |
636930 | 636930 | 2020-10-16 | Sioux | North Dakota | 38085 | 216 | 3 |
633684 | 633684 | 2020-10-15 | Sioux | North Dakota | 38085 | 211 | 3 |
630439 | 630439 | 2020-10-14 | Sioux | North Dakota | 38085 | 204 | 3 |
627195 | 627195 | 2020-10-13 | Sioux | North Dakota | 38085 | 200 | 3 |
623953 | 623953 | 2020-10-12 | Sioux | North Dakota | 38085 | 192 | 3 |
620710 | 620710 | 2020-10-11 | Sioux | North Dakota | 38085 | 191 | 3 |
617468 | 617468 | 2020-10-10 | Sioux | North Dakota | 38085 | 190 | 3 |
614226 | 614226 | 2020-10-09 | Sioux | North Dakota | 38085 | 184 | 3 |
610985 | 610985 | 2020-10-08 | Sioux | North Dakota | 38085 | 177 | 3 |
607743 | 607743 | 2020-10-07 | Sioux | North Dakota | 38085 | 176 | 3 |
604500 | 604500 | 2020-10-06 | Sioux | North Dakota | 38085 | 173 | 3 |
601258 | 601258 | 2020-10-05 | Sioux | North Dakota | 38085 | 171 | 3 |
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);