ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
720 rows where county = "Jackson" and fips = 46071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056000 | 1056000 | 2021-02-22 | Jackson | South Dakota | 46071 | 277 | 14 |
1052754 | 1052754 | 2021-02-21 | Jackson | South Dakota | 46071 | 276 | 14 |
1049507 | 1049507 | 2021-02-20 | Jackson | South Dakota | 46071 | 276 | 14 |
1046260 | 1046260 | 2021-02-19 | Jackson | South Dakota | 46071 | 276 | 14 |
1043015 | 1043015 | 2021-02-18 | Jackson | South Dakota | 46071 | 276 | 14 |
1039770 | 1039770 | 2021-02-17 | Jackson | South Dakota | 46071 | 275 | 14 |
1036525 | 1036525 | 2021-02-16 | Jackson | South Dakota | 46071 | 275 | 14 |
1033280 | 1033280 | 2021-02-15 | Jackson | South Dakota | 46071 | 275 | 14 |
1030034 | 1030034 | 2021-02-14 | Jackson | South Dakota | 46071 | 275 | 14 |
1026787 | 1026787 | 2021-02-13 | Jackson | South Dakota | 46071 | 275 | 14 |
1023542 | 1023542 | 2021-02-12 | Jackson | South Dakota | 46071 | 275 | 14 |
1020297 | 1020297 | 2021-02-11 | Jackson | South Dakota | 46071 | 275 | 14 |
1017052 | 1017052 | 2021-02-10 | Jackson | South Dakota | 46071 | 274 | 14 |
1013807 | 1013807 | 2021-02-09 | Jackson | South Dakota | 46071 | 272 | 14 |
1010562 | 1010562 | 2021-02-08 | Jackson | South Dakota | 46071 | 271 | 14 |
1007316 | 1007316 | 2021-02-07 | Jackson | South Dakota | 46071 | 270 | 14 |
1004070 | 1004070 | 2021-02-06 | Jackson | South Dakota | 46071 | 269 | 14 |
1000824 | 1000824 | 2021-02-05 | Jackson | South Dakota | 46071 | 268 | 13 |
997578 | 997578 | 2021-02-04 | Jackson | South Dakota | 46071 | 268 | 13 |
994332 | 994332 | 2021-02-03 | Jackson | South Dakota | 46071 | 268 | 13 |
991086 | 991086 | 2021-02-02 | Jackson | South Dakota | 46071 | 268 | 13 |
987840 | 987840 | 2021-02-01 | Jackson | South Dakota | 46071 | 268 | 13 |
984593 | 984593 | 2021-01-31 | Jackson | South Dakota | 46071 | 268 | 13 |
981346 | 981346 | 2021-01-30 | Jackson | South Dakota | 46071 | 268 | 13 |
978100 | 978100 | 2021-01-29 | Jackson | South Dakota | 46071 | 268 | 13 |
974855 | 974855 | 2021-01-28 | Jackson | South Dakota | 46071 | 268 | 13 |
971610 | 971610 | 2021-01-27 | Jackson | South Dakota | 46071 | 268 | 13 |
968365 | 968365 | 2021-01-26 | Jackson | South Dakota | 46071 | 268 | 13 |
965121 | 965121 | 2021-01-25 | Jackson | South Dakota | 46071 | 269 | 13 |
961876 | 961876 | 2021-01-24 | Jackson | South Dakota | 46071 | 269 | 13 |
958631 | 958631 | 2021-01-23 | Jackson | South Dakota | 46071 | 269 | 13 |
955385 | 955385 | 2021-01-22 | Jackson | South Dakota | 46071 | 269 | 13 |
952140 | 952140 | 2021-01-21 | Jackson | South Dakota | 46071 | 269 | 13 |
948895 | 948895 | 2021-01-20 | Jackson | South Dakota | 46071 | 269 | 13 |
945649 | 945649 | 2021-01-19 | Jackson | South Dakota | 46071 | 269 | 13 |
942402 | 942402 | 2021-01-18 | Jackson | South Dakota | 46071 | 269 | 13 |
939157 | 939157 | 2021-01-17 | Jackson | South Dakota | 46071 | 269 | 13 |
935912 | 935912 | 2021-01-16 | Jackson | South Dakota | 46071 | 267 | 13 |
932667 | 932667 | 2021-01-15 | Jackson | South Dakota | 46071 | 267 | 13 |
929422 | 929422 | 2021-01-14 | Jackson | South Dakota | 46071 | 267 | 13 |
926177 | 926177 | 2021-01-13 | Jackson | South Dakota | 46071 | 267 | 12 |
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 |
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);