ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46005 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 |
---|---|---|---|---|---|---|---|
1393626 | 1393626 | 2021-06-06 | Beadle | South Dakota | 46005 | 2965 | 40 |
1390381 | 1390381 | 2021-06-05 | Beadle | South Dakota | 46005 | 2965 | 40 |
1387136 | 1387136 | 2021-06-04 | Beadle | South Dakota | 46005 | 2965 | 40 |
1383891 | 1383891 | 2021-06-03 | Beadle | South Dakota | 46005 | 2965 | 40 |
1380645 | 1380645 | 2021-06-02 | Beadle | South Dakota | 46005 | 2965 | 40 |
1377400 | 1377400 | 2021-06-01 | Beadle | South Dakota | 46005 | 2964 | 40 |
1374154 | 1374154 | 2021-05-31 | Beadle | South Dakota | 46005 | 2964 | 40 |
1370909 | 1370909 | 2021-05-30 | Beadle | South Dakota | 46005 | 2964 | 40 |
1367663 | 1367663 | 2021-05-29 | Beadle | South Dakota | 46005 | 2964 | 40 |
1364417 | 1364417 | 2021-05-28 | Beadle | South Dakota | 46005 | 2964 | 40 |
1361171 | 1361171 | 2021-05-27 | Beadle | South Dakota | 46005 | 2964 | 40 |
1357925 | 1357925 | 2021-05-26 | Beadle | South Dakota | 46005 | 2962 | 40 |
1354679 | 1354679 | 2021-05-25 | Beadle | South Dakota | 46005 | 2960 | 40 |
1351433 | 1351433 | 2021-05-24 | Beadle | South Dakota | 46005 | 2960 | 40 |
1348187 | 1348187 | 2021-05-23 | Beadle | South Dakota | 46005 | 2960 | 40 |
1344939 | 1344939 | 2021-05-22 | Beadle | South Dakota | 46005 | 2960 | 40 |
1341691 | 1341691 | 2021-05-21 | Beadle | South Dakota | 46005 | 2960 | 40 |
1338443 | 1338443 | 2021-05-20 | Beadle | South Dakota | 46005 | 2959 | 40 |
1335196 | 1335196 | 2021-05-19 | Beadle | South Dakota | 46005 | 2958 | 40 |
1331949 | 1331949 | 2021-05-18 | Beadle | South Dakota | 46005 | 2959 | 40 |
1328702 | 1328702 | 2021-05-17 | Beadle | South Dakota | 46005 | 2957 | 40 |
1325456 | 1325456 | 2021-05-16 | Beadle | South Dakota | 46005 | 2956 | 40 |
1322210 | 1322210 | 2021-05-15 | Beadle | South Dakota | 46005 | 2956 | 40 |
1318964 | 1318964 | 2021-05-14 | Beadle | South Dakota | 46005 | 2956 | 40 |
1315716 | 1315716 | 2021-05-13 | Beadle | South Dakota | 46005 | 2955 | 40 |
1312470 | 1312470 | 2021-05-12 | Beadle | South Dakota | 46005 | 2955 | 40 |
1309223 | 1309223 | 2021-05-11 | Beadle | South Dakota | 46005 | 2954 | 40 |
1305977 | 1305977 | 2021-05-10 | Beadle | South Dakota | 46005 | 2953 | 40 |
1302731 | 1302731 | 2021-05-09 | Beadle | South Dakota | 46005 | 2952 | 40 |
1299484 | 1299484 | 2021-05-08 | Beadle | South Dakota | 46005 | 2952 | 40 |
1296237 | 1296237 | 2021-05-07 | Beadle | South Dakota | 46005 | 2952 | 40 |
1292991 | 1292991 | 2021-05-06 | Beadle | South Dakota | 46005 | 2948 | 40 |
1289745 | 1289745 | 2021-05-05 | Beadle | South Dakota | 46005 | 2945 | 40 |
1286499 | 1286499 | 2021-05-04 | Beadle | South Dakota | 46005 | 2943 | 40 |
1283253 | 1283253 | 2021-05-03 | Beadle | South Dakota | 46005 | 2935 | 40 |
1280006 | 1280006 | 2021-05-02 | Beadle | South Dakota | 46005 | 2933 | 40 |
1276759 | 1276759 | 2021-05-01 | Beadle | South Dakota | 46005 | 2933 | 40 |
1273512 | 1273512 | 2021-04-30 | Beadle | South Dakota | 46005 | 2933 | 40 |
1270265 | 1270265 | 2021-04-29 | Beadle | South Dakota | 46005 | 2932 | 40 |
1267018 | 1267018 | 2021-04-28 | Beadle | South Dakota | 46005 | 2932 | 40 |
1263771 | 1263771 | 2021-04-27 | Beadle | South Dakota | 46005 | 2929 | 40 |
1260524 | 1260524 | 2021-04-26 | Beadle | South Dakota | 46005 | 2927 | 40 |
1257277 | 1257277 | 2021-04-25 | Beadle | South Dakota | 46005 | 2927 | 40 |
1254030 | 1254030 | 2021-04-24 | Beadle | South Dakota | 46005 | 2927 | 40 |
1250783 | 1250783 | 2021-04-23 | Beadle | South Dakota | 46005 | 2921 | 40 |
1247536 | 1247536 | 2021-04-22 | Beadle | South Dakota | 46005 | 2919 | 40 |
1244289 | 1244289 | 2021-04-21 | Beadle | South Dakota | 46005 | 2916 | 40 |
1241042 | 1241042 | 2021-04-20 | Beadle | South Dakota | 46005 | 2915 | 40 |
1237795 | 1237795 | 2021-04-19 | Beadle | South Dakota | 46005 | 2915 | 40 |
1234548 | 1234548 | 2021-04-18 | Beadle | South Dakota | 46005 | 2912 | 40 |
1231300 | 1231300 | 2021-04-17 | Beadle | South Dakota | 46005 | 2912 | 40 |
1228052 | 1228052 | 2021-04-16 | Beadle | South Dakota | 46005 | 2907 | 40 |
1224804 | 1224804 | 2021-04-15 | Beadle | South Dakota | 46005 | 2906 | 40 |
1221557 | 1221557 | 2021-04-14 | Beadle | South Dakota | 46005 | 2903 | 40 |
1218309 | 1218309 | 2021-04-13 | Beadle | South Dakota | 46005 | 2896 | 40 |
1215061 | 1215061 | 2021-04-12 | Beadle | South Dakota | 46005 | 2892 | 40 |
1211814 | 1211814 | 2021-04-11 | Beadle | South Dakota | 46005 | 2890 | 40 |
1208565 | 1208565 | 2021-04-10 | Beadle | South Dakota | 46005 | 2890 | 40 |
1205317 | 1205317 | 2021-04-09 | Beadle | South Dakota | 46005 | 2888 | 40 |
1202069 | 1202069 | 2021-04-08 | Beadle | South Dakota | 46005 | 2885 | 40 |
1198820 | 1198820 | 2021-04-07 | Beadle | South Dakota | 46005 | 2882 | 40 |
1195571 | 1195571 | 2021-04-06 | Beadle | South Dakota | 46005 | 2879 | 40 |
1192323 | 1192323 | 2021-04-05 | Beadle | South Dakota | 46005 | 2872 | 40 |
1189074 | 1189074 | 2021-04-04 | Beadle | South Dakota | 46005 | 2870 | 40 |
1185827 | 1185827 | 2021-04-03 | Beadle | South Dakota | 46005 | 2870 | 40 |
1182580 | 1182580 | 2021-04-02 | Beadle | South Dakota | 46005 | 2867 | 40 |
1179333 | 1179333 | 2021-04-01 | Beadle | South Dakota | 46005 | 2869 | 40 |
1176086 | 1176086 | 2021-03-31 | Beadle | South Dakota | 46005 | 2869 | 40 |
1172839 | 1172839 | 2021-03-30 | Beadle | South Dakota | 46005 | 2864 | 40 |
1169592 | 1169592 | 2021-03-29 | Beadle | South Dakota | 46005 | 2863 | 40 |
1166344 | 1166344 | 2021-03-28 | Beadle | South Dakota | 46005 | 2862 | 40 |
1163096 | 1163096 | 2021-03-27 | Beadle | South Dakota | 46005 | 2857 | 40 |
1159847 | 1159847 | 2021-03-26 | Beadle | South Dakota | 46005 | 2852 | 40 |
1156600 | 1156600 | 2021-03-25 | Beadle | South Dakota | 46005 | 2851 | 40 |
1153353 | 1153353 | 2021-03-24 | Beadle | South Dakota | 46005 | 2849 | 40 |
1150106 | 1150106 | 2021-03-23 | Beadle | South Dakota | 46005 | 2842 | 39 |
1146859 | 1146859 | 2021-03-22 | Beadle | South Dakota | 46005 | 2841 | 39 |
1143612 | 1143612 | 2021-03-21 | Beadle | South Dakota | 46005 | 2841 | 39 |
1140365 | 1140365 | 2021-03-20 | Beadle | South Dakota | 46005 | 2840 | 39 |
1137119 | 1137119 | 2021-03-19 | Beadle | South Dakota | 46005 | 2838 | 39 |
1133873 | 1133873 | 2021-03-18 | Beadle | South Dakota | 46005 | 2832 | 39 |
1130625 | 1130625 | 2021-03-17 | Beadle | South Dakota | 46005 | 2827 | 39 |
1127378 | 1127378 | 2021-03-16 | Beadle | South Dakota | 46005 | 2827 | 39 |
1124132 | 1124132 | 2021-03-15 | Beadle | South Dakota | 46005 | 2825 | 39 |
1120886 | 1120886 | 2021-03-14 | Beadle | South Dakota | 46005 | 2825 | 39 |
1117639 | 1117639 | 2021-03-13 | Beadle | South Dakota | 46005 | 2822 | 39 |
1114392 | 1114392 | 2021-03-12 | Beadle | South Dakota | 46005 | 2820 | 39 |
1111146 | 1111146 | 2021-03-11 | Beadle | South Dakota | 46005 | 2819 | 39 |
1107900 | 1107900 | 2021-03-10 | Beadle | South Dakota | 46005 | 2813 | 39 |
1104654 | 1104654 | 2021-03-09 | Beadle | South Dakota | 46005 | 2805 | 39 |
1101408 | 1101408 | 2021-03-08 | Beadle | South Dakota | 46005 | 2791 | 39 |
1098162 | 1098162 | 2021-03-07 | Beadle | South Dakota | 46005 | 2789 | 39 |
1094914 | 1094914 | 2021-03-06 | Beadle | South Dakota | 46005 | 2785 | 39 |
1091668 | 1091668 | 2021-03-05 | Beadle | South Dakota | 46005 | 2780 | 39 |
1088422 | 1088422 | 2021-03-04 | Beadle | South Dakota | 46005 | 2772 | 39 |
1085177 | 1085177 | 2021-03-03 | Beadle | South Dakota | 46005 | 2752 | 39 |
1081931 | 1081931 | 2021-03-02 | Beadle | South Dakota | 46005 | 2740 | 39 |
1078685 | 1078685 | 2021-03-01 | Beadle | South Dakota | 46005 | 2733 | 39 |
1075440 | 1075440 | 2021-02-28 | Beadle | South Dakota | 46005 | 2730 | 39 |
1072194 | 1072194 | 2021-02-27 | Beadle | South Dakota | 46005 | 2724 | 39 |
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);