ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lincoln" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948901 | 948901 | 2021-01-20 | Lincoln | South Dakota | 46083 | 7281 | 70 |
945655 | 945655 | 2021-01-19 | Lincoln | South Dakota | 46083 | 7248 | 70 |
942408 | 942408 | 2021-01-18 | Lincoln | South Dakota | 46083 | 7240 | 70 |
939163 | 939163 | 2021-01-17 | Lincoln | South Dakota | 46083 | 7231 | 70 |
935918 | 935918 | 2021-01-16 | Lincoln | South Dakota | 46083 | 7215 | 69 |
932673 | 932673 | 2021-01-15 | Lincoln | South Dakota | 46083 | 7190 | 68 |
929428 | 929428 | 2021-01-14 | Lincoln | South Dakota | 46083 | 7162 | 68 |
926183 | 926183 | 2021-01-13 | Lincoln | South Dakota | 46083 | 7142 | 68 |
922937 | 922937 | 2021-01-12 | Lincoln | South Dakota | 46083 | 7114 | 68 |
919692 | 919692 | 2021-01-11 | Lincoln | South Dakota | 46083 | 7089 | 68 |
916447 | 916447 | 2021-01-10 | Lincoln | South Dakota | 46083 | 7078 | 68 |
913202 | 913202 | 2021-01-09 | Lincoln | South Dakota | 46083 | 7052 | 68 |
909957 | 909957 | 2021-01-08 | Lincoln | South Dakota | 46083 | 7030 | 68 |
906712 | 906712 | 2021-01-07 | Lincoln | South Dakota | 46083 | 6993 | 68 |
903466 | 903466 | 2021-01-06 | Lincoln | South Dakota | 46083 | 6968 | 66 |
900221 | 900221 | 2021-01-05 | Lincoln | South Dakota | 46083 | 6937 | 66 |
896976 | 896976 | 2021-01-04 | Lincoln | South Dakota | 46083 | 6911 | 66 |
893730 | 893730 | 2021-01-03 | Lincoln | South Dakota | 46083 | 6904 | 66 |
890484 | 890484 | 2021-01-02 | Lincoln | South Dakota | 46083 | 6823 | 66 |
887237 | 887237 | 2021-01-01 | Lincoln | South Dakota | 46083 | 6780 | 66 |
883992 | 883992 | 2020-12-31 | Lincoln | South Dakota | 46083 | 6780 | 66 |
880747 | 880747 | 2020-12-30 | Lincoln | South Dakota | 46083 | 6758 | 65 |
877502 | 877502 | 2020-12-29 | Lincoln | South Dakota | 46083 | 6710 | 63 |
874257 | 874257 | 2020-12-28 | Lincoln | South Dakota | 46083 | 6676 | 63 |
871012 | 871012 | 2020-12-27 | Lincoln | South Dakota | 46083 | 6653 | 63 |
867767 | 867767 | 2020-12-26 | Lincoln | South Dakota | 46083 | 6629 | 63 |
864522 | 864522 | 2020-12-25 | Lincoln | South Dakota | 46083 | 6588 | 63 |
861277 | 861277 | 2020-12-24 | Lincoln | South Dakota | 46083 | 6588 | 63 |
858032 | 858032 | 2020-12-23 | Lincoln | South Dakota | 46083 | 6545 | 62 |
854787 | 854787 | 2020-12-22 | Lincoln | South Dakota | 46083 | 6499 | 61 |
851542 | 851542 | 2020-12-21 | Lincoln | South Dakota | 46083 | 6472 | 61 |
848297 | 848297 | 2020-12-20 | Lincoln | South Dakota | 46083 | 6410 | 60 |
845052 | 845052 | 2020-12-19 | Lincoln | South Dakota | 46083 | 6381 | 58 |
841806 | 841806 | 2020-12-18 | Lincoln | South Dakota | 46083 | 6332 | 58 |
838561 | 838561 | 2020-12-17 | Lincoln | South Dakota | 46083 | 6265 | 57 |
835315 | 835315 | 2020-12-16 | Lincoln | South Dakota | 46083 | 6220 | 57 |
832069 | 832069 | 2020-12-15 | Lincoln | South Dakota | 46083 | 6155 | 57 |
828822 | 828822 | 2020-12-14 | Lincoln | South Dakota | 46083 | 6132 | 57 |
825576 | 825576 | 2020-12-13 | Lincoln | South Dakota | 46083 | 6108 | 57 |
822329 | 822329 | 2020-12-12 | Lincoln | South Dakota | 46083 | 6049 | 55 |
819083 | 819083 | 2020-12-11 | Lincoln | South Dakota | 46083 | 5995 | 54 |
815837 | 815837 | 2020-12-10 | Lincoln | South Dakota | 46083 | 5925 | 54 |
812591 | 812591 | 2020-12-09 | Lincoln | South Dakota | 46083 | 5886 | 54 |
809347 | 809347 | 2020-12-08 | Lincoln | South Dakota | 46083 | 5835 | 55 |
806102 | 806102 | 2020-12-07 | Lincoln | South Dakota | 46083 | 5792 | 55 |
802857 | 802857 | 2020-12-06 | Lincoln | South Dakota | 46083 | 5760 | 55 |
799612 | 799612 | 2020-12-05 | Lincoln | South Dakota | 46083 | 5715 | 55 |
796367 | 796367 | 2020-12-04 | Lincoln | South Dakota | 46083 | 5653 | 55 |
793122 | 793122 | 2020-12-03 | Lincoln | South Dakota | 46083 | 5598 | 53 |
789877 | 789877 | 2020-12-02 | Lincoln | South Dakota | 46083 | 5523 | 53 |
786632 | 786632 | 2020-12-01 | Lincoln | South Dakota | 46083 | 5453 | 51 |
783388 | 783388 | 2020-11-30 | Lincoln | South Dakota | 46083 | 5424 | 51 |
780143 | 780143 | 2020-11-29 | Lincoln | South Dakota | 46083 | 5410 | 51 |
776897 | 776897 | 2020-11-28 | Lincoln | South Dakota | 46083 | 5353 | 51 |
773652 | 773652 | 2020-11-27 | Lincoln | South Dakota | 46083 | 5321 | 49 |
770407 | 770407 | 2020-11-26 | Lincoln | South Dakota | 46083 | 5182 | 47 |
767161 | 767161 | 2020-11-25 | Lincoln | South Dakota | 46083 | 5182 | 47 |
763916 | 763916 | 2020-11-24 | Lincoln | South Dakota | 46083 | 5099 | 46 |
760671 | 760671 | 2020-11-23 | Lincoln | South Dakota | 46083 | 5033 | 46 |
757426 | 757426 | 2020-11-22 | Lincoln | South Dakota | 46083 | 4973 | 46 |
754179 | 754179 | 2020-11-21 | Lincoln | South Dakota | 46083 | 4921 | 44 |
750933 | 750933 | 2020-11-20 | Lincoln | South Dakota | 46083 | 4834 | 43 |
747687 | 747687 | 2020-11-19 | Lincoln | South Dakota | 46083 | 4775 | 43 |
744441 | 744441 | 2020-11-18 | Lincoln | South Dakota | 46083 | 4689 | 42 |
741194 | 741194 | 2020-11-17 | Lincoln | South Dakota | 46083 | 4601 | 40 |
737948 | 737948 | 2020-11-16 | Lincoln | South Dakota | 46083 | 4536 | 40 |
734704 | 734704 | 2020-11-15 | Lincoln | South Dakota | 46083 | 4466 | 40 |
731458 | 731458 | 2020-11-14 | Lincoln | South Dakota | 46083 | 4393 | 37 |
728214 | 728214 | 2020-11-13 | Lincoln | South Dakota | 46083 | 4270 | 34 |
724970 | 724970 | 2020-11-12 | Lincoln | South Dakota | 46083 | 4140 | 34 |
721727 | 721727 | 2020-11-11 | Lincoln | South Dakota | 46083 | 3974 | 34 |
718484 | 718484 | 2020-11-10 | Lincoln | South Dakota | 46083 | 3864 | 32 |
715241 | 715241 | 2020-11-09 | Lincoln | South Dakota | 46083 | 3782 | 32 |
711997 | 711997 | 2020-11-08 | Lincoln | South Dakota | 46083 | 3704 | 32 |
708753 | 708753 | 2020-11-07 | Lincoln | South Dakota | 46083 | 3598 | 30 |
705510 | 705510 | 2020-11-06 | Lincoln | South Dakota | 46083 | 3541 | 29 |
702267 | 702267 | 2020-11-05 | Lincoln | South Dakota | 46083 | 3443 | 25 |
699023 | 699023 | 2020-11-04 | Lincoln | South Dakota | 46083 | 3367 | 22 |
695780 | 695780 | 2020-11-03 | Lincoln | South Dakota | 46083 | 3292 | 22 |
692538 | 692538 | 2020-11-02 | Lincoln | South Dakota | 46083 | 3226 | 21 |
689294 | 689294 | 2020-11-01 | Lincoln | South Dakota | 46083 | 3193 | 21 |
686049 | 686049 | 2020-10-31 | Lincoln | South Dakota | 46083 | 3097 | 20 |
682806 | 682806 | 2020-10-30 | Lincoln | South Dakota | 46083 | 2953 | 20 |
679563 | 679563 | 2020-10-29 | Lincoln | South Dakota | 46083 | 2830 | 20 |
676320 | 676320 | 2020-10-28 | Lincoln | South Dakota | 46083 | 2759 | 18 |
673077 | 673077 | 2020-10-27 | Lincoln | South Dakota | 46083 | 2661 | 18 |
669835 | 669835 | 2020-10-26 | Lincoln | South Dakota | 46083 | 2623 | 18 |
666591 | 666591 | 2020-10-25 | Lincoln | South Dakota | 46083 | 2584 | 18 |
663346 | 663346 | 2020-10-24 | Lincoln | South Dakota | 46083 | 2526 | 18 |
660102 | 660102 | 2020-10-23 | Lincoln | South Dakota | 46083 | 2437 | 17 |
656858 | 656858 | 2020-10-22 | Lincoln | South Dakota | 46083 | 2383 | 16 |
653613 | 653613 | 2020-10-21 | Lincoln | South Dakota | 46083 | 2313 | 16 |
650368 | 650368 | 2020-10-20 | Lincoln | South Dakota | 46083 | 2273 | 16 |
647124 | 647124 | 2020-10-19 | Lincoln | South Dakota | 46083 | 2229 | 14 |
643878 | 643878 | 2020-10-18 | Lincoln | South Dakota | 46083 | 2178 | 14 |
640630 | 640630 | 2020-10-17 | Lincoln | South Dakota | 46083 | 2141 | 14 |
637384 | 637384 | 2020-10-16 | Lincoln | South Dakota | 46083 | 2094 | 11 |
634138 | 634138 | 2020-10-15 | Lincoln | South Dakota | 46083 | 2022 | 11 |
630893 | 630893 | 2020-10-14 | Lincoln | South Dakota | 46083 | 1976 | 10 |
627649 | 627649 | 2020-10-13 | Lincoln | South Dakota | 46083 | 1897 | 10 |
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);