ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
720 rows where county = "Jackson" 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 |
---|---|---|---|---|---|---|---|
922931 | 922931 | 2021-01-12 | Jackson | South Dakota | 46071 | 267 | 12 |
919686 | 919686 | 2021-01-11 | Jackson | South Dakota | 46071 | 267 | 12 |
916441 | 916441 | 2021-01-10 | Jackson | South Dakota | 46071 | 267 | 12 |
913196 | 913196 | 2021-01-09 | Jackson | South Dakota | 46071 | 267 | 11 |
909951 | 909951 | 2021-01-08 | Jackson | South Dakota | 46071 | 267 | 11 |
906706 | 906706 | 2021-01-07 | Jackson | South Dakota | 46071 | 267 | 10 |
903460 | 903460 | 2021-01-06 | Jackson | South Dakota | 46071 | 265 | 8 |
900215 | 900215 | 2021-01-05 | Jackson | South Dakota | 46071 | 263 | 8 |
896970 | 896970 | 2021-01-04 | Jackson | South Dakota | 46071 | 262 | 8 |
893724 | 893724 | 2021-01-03 | Jackson | South Dakota | 46071 | 262 | 8 |
890478 | 890478 | 2021-01-02 | Jackson | South Dakota | 46071 | 262 | 8 |
887231 | 887231 | 2021-01-01 | Jackson | South Dakota | 46071 | 262 | 8 |
883986 | 883986 | 2020-12-31 | Jackson | South Dakota | 46071 | 262 | 8 |
880741 | 880741 | 2020-12-30 | Jackson | South Dakota | 46071 | 262 | 8 |
877496 | 877496 | 2020-12-29 | Jackson | South Dakota | 46071 | 262 | 8 |
874251 | 874251 | 2020-12-28 | Jackson | South Dakota | 46071 | 262 | 8 |
871006 | 871006 | 2020-12-27 | Jackson | South Dakota | 46071 | 261 | 8 |
867761 | 867761 | 2020-12-26 | Jackson | South Dakota | 46071 | 260 | 8 |
864516 | 864516 | 2020-12-25 | Jackson | South Dakota | 46071 | 260 | 8 |
861271 | 861271 | 2020-12-24 | Jackson | South Dakota | 46071 | 260 | 8 |
858026 | 858026 | 2020-12-23 | Jackson | South Dakota | 46071 | 258 | 8 |
854781 | 854781 | 2020-12-22 | Jackson | South Dakota | 46071 | 257 | 8 |
851536 | 851536 | 2020-12-21 | Jackson | South Dakota | 46071 | 257 | 8 |
848291 | 848291 | 2020-12-20 | Jackson | South Dakota | 46071 | 257 | 8 |
845046 | 845046 | 2020-12-19 | Jackson | South Dakota | 46071 | 256 | 8 |
841800 | 841800 | 2020-12-18 | Jackson | South Dakota | 46071 | 255 | 8 |
838555 | 838555 | 2020-12-17 | Jackson | South Dakota | 46071 | 254 | 8 |
835309 | 835309 | 2020-12-16 | Jackson | South Dakota | 46071 | 254 | 8 |
832063 | 832063 | 2020-12-15 | Jackson | South Dakota | 46071 | 252 | 8 |
828816 | 828816 | 2020-12-14 | Jackson | South Dakota | 46071 | 252 | 8 |
825570 | 825570 | 2020-12-13 | Jackson | South Dakota | 46071 | 242 | 8 |
822323 | 822323 | 2020-12-12 | Jackson | South Dakota | 46071 | 240 | 8 |
819077 | 819077 | 2020-12-11 | Jackson | South Dakota | 46071 | 235 | 8 |
815831 | 815831 | 2020-12-10 | Jackson | South Dakota | 46071 | 232 | 8 |
812585 | 812585 | 2020-12-09 | Jackson | South Dakota | 46071 | 229 | 8 |
809341 | 809341 | 2020-12-08 | Jackson | South Dakota | 46071 | 222 | 8 |
806096 | 806096 | 2020-12-07 | Jackson | South Dakota | 46071 | 219 | 8 |
802851 | 802851 | 2020-12-06 | Jackson | South Dakota | 46071 | 218 | 8 |
799606 | 799606 | 2020-12-05 | Jackson | South Dakota | 46071 | 216 | 8 |
796361 | 796361 | 2020-12-04 | Jackson | South Dakota | 46071 | 213 | 8 |
793116 | 793116 | 2020-12-03 | Jackson | South Dakota | 46071 | 213 | 8 |
789871 | 789871 | 2020-12-02 | Jackson | South Dakota | 46071 | 213 | 8 |
786626 | 786626 | 2020-12-01 | Jackson | South Dakota | 46071 | 205 | 8 |
783382 | 783382 | 2020-11-30 | Jackson | South Dakota | 46071 | 205 | 8 |
780137 | 780137 | 2020-11-29 | Jackson | South Dakota | 46071 | 200 | 8 |
776891 | 776891 | 2020-11-28 | Jackson | South Dakota | 46071 | 198 | 8 |
773646 | 773646 | 2020-11-27 | Jackson | South Dakota | 46071 | 196 | 6 |
770401 | 770401 | 2020-11-26 | Jackson | South Dakota | 46071 | 188 | 6 |
767155 | 767155 | 2020-11-25 | Jackson | South Dakota | 46071 | 188 | 6 |
763910 | 763910 | 2020-11-24 | Jackson | South Dakota | 46071 | 186 | 6 |
760665 | 760665 | 2020-11-23 | Jackson | South Dakota | 46071 | 186 | 6 |
757420 | 757420 | 2020-11-22 | Jackson | South Dakota | 46071 | 187 | 6 |
754173 | 754173 | 2020-11-21 | Jackson | South Dakota | 46071 | 185 | 6 |
750927 | 750927 | 2020-11-20 | Jackson | South Dakota | 46071 | 183 | 6 |
747681 | 747681 | 2020-11-19 | Jackson | South Dakota | 46071 | 183 | 5 |
744435 | 744435 | 2020-11-18 | Jackson | South Dakota | 46071 | 183 | 5 |
741188 | 741188 | 2020-11-17 | Jackson | South Dakota | 46071 | 180 | 5 |
737942 | 737942 | 2020-11-16 | Jackson | South Dakota | 46071 | 180 | 5 |
734698 | 734698 | 2020-11-15 | Jackson | South Dakota | 46071 | 180 | 5 |
731452 | 731452 | 2020-11-14 | Jackson | South Dakota | 46071 | 178 | 5 |
728208 | 728208 | 2020-11-13 | Jackson | South Dakota | 46071 | 173 | 4 |
724964 | 724964 | 2020-11-12 | Jackson | South Dakota | 46071 | 167 | 4 |
721721 | 721721 | 2020-11-11 | Jackson | South Dakota | 46071 | 165 | 4 |
718478 | 718478 | 2020-11-10 | Jackson | South Dakota | 46071 | 164 | 4 |
715235 | 715235 | 2020-11-09 | Jackson | South Dakota | 46071 | 159 | 4 |
711991 | 711991 | 2020-11-08 | Jackson | South Dakota | 46071 | 159 | 4 |
708747 | 708747 | 2020-11-07 | Jackson | South Dakota | 46071 | 153 | 4 |
705504 | 705504 | 2020-11-06 | Jackson | South Dakota | 46071 | 149 | 4 |
702261 | 702261 | 2020-11-05 | Jackson | South Dakota | 46071 | 147 | 3 |
699017 | 699017 | 2020-11-04 | Jackson | South Dakota | 46071 | 143 | 3 |
695774 | 695774 | 2020-11-03 | Jackson | South Dakota | 46071 | 141 | 3 |
692532 | 692532 | 2020-11-02 | Jackson | South Dakota | 46071 | 137 | 3 |
689288 | 689288 | 2020-11-01 | Jackson | South Dakota | 46071 | 137 | 3 |
686043 | 686043 | 2020-10-31 | Jackson | South Dakota | 46071 | 135 | 3 |
682800 | 682800 | 2020-10-30 | Jackson | South Dakota | 46071 | 132 | 1 |
679557 | 679557 | 2020-10-29 | Jackson | South Dakota | 46071 | 126 | 1 |
676314 | 676314 | 2020-10-28 | Jackson | South Dakota | 46071 | 121 | 1 |
673071 | 673071 | 2020-10-27 | Jackson | South Dakota | 46071 | 115 | 1 |
669829 | 669829 | 2020-10-26 | Jackson | South Dakota | 46071 | 113 | 1 |
666585 | 666585 | 2020-10-25 | Jackson | South Dakota | 46071 | 109 | 1 |
663340 | 663340 | 2020-10-24 | Jackson | South Dakota | 46071 | 105 | 1 |
660096 | 660096 | 2020-10-23 | Jackson | South Dakota | 46071 | 105 | 1 |
656852 | 656852 | 2020-10-22 | Jackson | South Dakota | 46071 | 100 | 1 |
653607 | 653607 | 2020-10-21 | Jackson | South Dakota | 46071 | 94 | 1 |
650362 | 650362 | 2020-10-20 | Jackson | South Dakota | 46071 | 85 | 1 |
647118 | 647118 | 2020-10-19 | Jackson | South Dakota | 46071 | 78 | 1 |
643872 | 643872 | 2020-10-18 | Jackson | South Dakota | 46071 | 75 | 1 |
640624 | 640624 | 2020-10-17 | Jackson | South Dakota | 46071 | 72 | 1 |
637378 | 637378 | 2020-10-16 | Jackson | South Dakota | 46071 | 72 | 1 |
634132 | 634132 | 2020-10-15 | Jackson | South Dakota | 46071 | 69 | 1 |
630887 | 630887 | 2020-10-14 | Jackson | South Dakota | 46071 | 64 | 1 |
627643 | 627643 | 2020-10-13 | Jackson | South Dakota | 46071 | 57 | 1 |
624401 | 624401 | 2020-10-12 | Jackson | South Dakota | 46071 | 57 | 1 |
621158 | 621158 | 2020-10-11 | Jackson | South Dakota | 46071 | 55 | 1 |
617915 | 617915 | 2020-10-10 | Jackson | South Dakota | 46071 | 52 | 1 |
614673 | 614673 | 2020-10-09 | Jackson | South Dakota | 46071 | 50 | 1 |
611432 | 611432 | 2020-10-08 | Jackson | South Dakota | 46071 | 46 | 1 |
608190 | 608190 | 2020-10-07 | Jackson | South Dakota | 46071 | 44 | 1 |
604947 | 604947 | 2020-10-06 | Jackson | South Dakota | 46071 | 38 | 1 |
601705 | 601705 | 2020-10-05 | Jackson | South Dakota | 46071 | 38 | 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);