ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 412 ✖
- 1 25
- 4 17
- 5 14
- 2924 14
- 2927 14
- 1383 13
- 1378 11
- 99 10
- 1376 10
- 98 9
- 122 7
- 1382 7
- 1385 7
- 1392 7
- 1399 7
- 1401 7
- 1402 7
- 1405 7
- 2923 7
- 2926 7
- 2931 7
- 2934 7
- 2941 7
- 2 6
- 1384 6
- 20 5
- 96 5
- 116 5
- 1356 5
- 1374 5
- 1393 5
- 1690 5
- 1872 5
- 2109 5
- 2908 5
- 18 4
- 100 4
- 1233 4
- 1309 4
- 1328 4
- 1411 4
- 1412 4
- 1518 4
- 2137 4
- 2415 4
- 2909 4
- 10 3
- 13 3
- 17 3
- 32 3
- 91 3
- 103 3
- 113 3
- 128 3
- 129 3
- 1342 3
- 1352 3
- 1377 3
- 1455 3
- 1487 3
- 1545 3
- 1570 3
- 1609 3
- 1662 3
- 1706 3
- 1713 3
- 1724 3
- 1749 3
- 1772 3
- 1846 3
- 1971 3
- 2056 3
- 2097 3
- 2236 3
- 2624 3
- 2763 3
- 2852 3
- 2890 3
- 2917 3
- 2942 3
- 3 2
- 8 2
- 9 2
- 16 2
- 21 2
- 49 2
- 90 2
- 101 2
- 114 2
- 124 2
- 125 2
- 804 2
- 1085 2
- 1090 2
- 1112 2
- 1127 2
- 1208 2
- 1229 2
- 1248 2
- 1294 2
- 1337 2
- 1354 2
- 1361 2
- 1364 2
- 1388 2
- 1711 2
- 1767 2
- 6 1
- 7 1
- 11 1
- 12 1
- 14 1
- 30 1
- 37 1
- 41 1
- 45 1
- 47 1
- 48 1
- 56 1
- 57 1
- 58 1
- 68 1
- 70 1
- 75 1
- 82 1
- 85 1
- 86 1
- 95 1
- 97 1
- 104 1
- 105 1
- 109 1
- 112 1
- 115 1
- 117 1
- 119 1
- 127 1
- 134 1
- 135 1
- 136 1
- 139 1
- 140 1
- 143 1
- 150 1
- 156 1
- 159 1
- 160 1
- 171 1
- 173 1
- 174 1
- 177 1
- 184 1
- 196 1
- 198 1
- 206 1
- 213 1
- 217 1
- 225 1
- 234 1
- 239 1
- 248 1
- 255 1
- 262 1
- 267 1
- 268 1
- 277 1
- 289 1
- 293 1
- 307 1
- 311 1
- 312 1
- 316 1
- 320 1
- 332 1
- 350 1
- 360 1
- 365 1
- 371 1
- 376 1
- 391 1
- 398 1
- 410 1
- 421 1
- 438 1
- 443 1
- 453 1
- 467 1
- 492 1
- 511 1
- 519 1
- 530 1
- 535 1
- 548 1
- 561 1
- 576 1
- 603 1
- 611 1
- 632 1
- 640 1
- 652 1
- 672 1
- 690 1
- 703 1
- 744 1
- 760 1
- 774 1
- 793 1
- 827 1
- 850 1
- 860 1
- 878 1
- 892 1
- 911 1
- 922 1
- 936 1
- 946 1
- 960 1
- 969 1
- 976 1
- 987 1
- 998 1
- 1017 1
- 1022 1
- 1027 1
- 1030 1
- 1036 1
- 1046 1
- 1048 1
- 1056 1
- 1060 1
- 1063 1
- 1070 1
- 1073 1
- 1076 1
- 1088 1
- 1098 1
- 1109 1
- 1122 1
- 1130 1
- 1144 1
- 1151 1
- 1153 1
- 1155 1
- 1156 1
- 1159 1
- 1164 1
- 1171 1
- 1173 1
- 1175 1
- 1178 1
- 1182 1
- 1184 1
- 1185 1
- 1187 1
- 1198 1
- 1201 1
- 1202 1
- 1217 1
- 1219 1
- 1220 1
- 1223 1
- 1224 1
- 1230 1
- 1231 1
- 1232 1
- 1234 1
- 1236 1
- 1240 1
- 1246 1
- 1251 1
- 1257 1
- 1258 1
- 1261 1
- 1263 1
- 1266 1
- 1269 1
- 1270 1
- 1275 1
- 1276 1
- 1279 1
- 1283 1
- 1288 1
- 1300 1
- 1305 1
- 1307 1
- 1308 1
- 1311 1
- 1316 1
- 1317 1
- 1318 1
- 1319 1
- 1320 1
- 1321 1
- 1322 1
- 1326 1
- 1330 1
- 1336 1
- 1341 1
- 1347 1
- 1348 1
- 1355 1
- 1359 1
- 1360 1
- 1366 1
- 1367 1
- 1369 1
- 1371 1
- 1372 1
- 1375 1
- 1379 1
- 1380 1
- 1381 1
- 1391 1
- 1448 1
- 1460 1
- 1469 1
- 1478 1
- 1483 1
- 1491 1
- 1498 1
- 1506 1
- 1512 1
- 1522 1
- 1532 1
- 1540 1
- 1548 1
- 1555 1
- 1559 1
- 1565 1
- 1575 1
- 1581 1
- 1597 1
- 1599 1
- 1611 1
- 1623 1
- 1644 1
- 1649 1
- 1673 1
- 1683 1
- 1687 1
- 1695 1
- 1701 1
- 1702 1
- 1707 1
- 1712 1
- 1715 1
- 1717 1
- 1720 1
- 1721 1
- 1727 1
- 1732 1
- 1735 1
- 1743 1
- 1753 1
- 1761 1
- 1790 1
- 1810 1
- 1817 1
- 1834 1
- 1849 1
- 1863 1
- 1888 1
- 1910 1
- 1943 1
- 1957 1
- 1984 1
- 2017 1
- 2036 1
- 2044 1
- 2061 1
- 2065 1
- 2080 1
- 2093 1
- 2100 1
- 2104 1
- 2110 1
- 2127 1
- 2131 1
- 2141 1
- 2148 1
- 2192 1
- 2218 1
- 2261 1
- 2317 1
- 2343 1
- 2381 1
- 2465 1
- 2543 1
- 2592 1
- 2659 1
- 2701 1
- 2724 1
- 2742 1
- 2779 1
- 2806 1
- 2823 1
- 2837 1
- 2860 1
- 2866 1
- 2882 1
- 2886 1
- 2898 1
- 2902 1
- 2904 1
- 2905 1
- 2910 1
- 2912 1
- 2914 1
- 2915 1
- 2916 1
- 2918 1
- 2921 1
state 1
- South Dakota 795
fips 1
- 46023 · 795 ✖
county 1
- Charles Mix 795
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502055 | 2502055 | 2022-05-13 | Charles Mix | South Dakota | 46023 | 2942 | 35 |
2498797 | 2498797 | 2022-05-12 | Charles Mix | South Dakota | 46023 | 2942 | 35 |
2495539 | 2495539 | 2022-05-11 | Charles Mix | South Dakota | 46023 | 2942 | 35 |
2492281 | 2492281 | 2022-05-10 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2489023 | 2489023 | 2022-05-09 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2485766 | 2485766 | 2022-05-08 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2482508 | 2482508 | 2022-05-07 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2479250 | 2479250 | 2022-05-06 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2475992 | 2475992 | 2022-05-05 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2472735 | 2472735 | 2022-05-04 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2469479 | 2469479 | 2022-05-03 | Charles Mix | South Dakota | 46023 | 2934 | 35 |
2466223 | 2466223 | 2022-05-02 | Charles Mix | South Dakota | 46023 | 2934 | 35 |
2462968 | 2462968 | 2022-05-01 | Charles Mix | South Dakota | 46023 | 2934 | 35 |
2459712 | 2459712 | 2022-04-30 | Charles Mix | South Dakota | 46023 | 2934 | 35 |
2456456 | 2456456 | 2022-04-29 | Charles Mix | South Dakota | 46023 | 2934 | 35 |
2453200 | 2453200 | 2022-04-28 | Charles Mix | South Dakota | 46023 | 2934 | 35 |
2449944 | 2449944 | 2022-04-27 | Charles Mix | South Dakota | 46023 | 2934 | 35 |
2446687 | 2446687 | 2022-04-26 | Charles Mix | South Dakota | 46023 | 2931 | 35 |
2443432 | 2443432 | 2022-04-25 | Charles Mix | South Dakota | 46023 | 2931 | 35 |
2440176 | 2440176 | 2022-04-24 | Charles Mix | South Dakota | 46023 | 2931 | 35 |
2436920 | 2436920 | 2022-04-23 | Charles Mix | South Dakota | 46023 | 2931 | 35 |
2433664 | 2433664 | 2022-04-22 | Charles Mix | South Dakota | 46023 | 2931 | 35 |
2430408 | 2430408 | 2022-04-21 | Charles Mix | South Dakota | 46023 | 2931 | 35 |
2427152 | 2427152 | 2022-04-20 | Charles Mix | South Dakota | 46023 | 2931 | 35 |
2423896 | 2423896 | 2022-04-19 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2420640 | 2420640 | 2022-04-18 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2417384 | 2417384 | 2022-04-17 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2414128 | 2414128 | 2022-04-16 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2410872 | 2410872 | 2022-04-15 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2407616 | 2407616 | 2022-04-14 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2404360 | 2404360 | 2022-04-13 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2401105 | 2401105 | 2022-04-12 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2397850 | 2397850 | 2022-04-11 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2394595 | 2394595 | 2022-04-10 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2391339 | 2391339 | 2022-04-09 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2388083 | 2388083 | 2022-04-08 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2384828 | 2384828 | 2022-04-07 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2381573 | 2381573 | 2022-04-06 | Charles Mix | South Dakota | 46023 | 2927 | 35 |
2378318 | 2378318 | 2022-04-05 | Charles Mix | South Dakota | 46023 | 2926 | 35 |
2375064 | 2375064 | 2022-04-04 | Charles Mix | South Dakota | 46023 | 2926 | 35 |
2371812 | 2371812 | 2022-04-03 | Charles Mix | South Dakota | 46023 | 2926 | 35 |
2368559 | 2368559 | 2022-04-02 | Charles Mix | South Dakota | 46023 | 2926 | 35 |
2365306 | 2365306 | 2022-04-01 | Charles Mix | South Dakota | 46023 | 2926 | 35 |
2362053 | 2362053 | 2022-03-31 | Charles Mix | South Dakota | 46023 | 2926 | 35 |
2358799 | 2358799 | 2022-03-30 | Charles Mix | South Dakota | 46023 | 2926 | 35 |
2355545 | 2355545 | 2022-03-29 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2352292 | 2352292 | 2022-03-28 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2349040 | 2349040 | 2022-03-27 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2345787 | 2345787 | 2022-03-26 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2342534 | 2342534 | 2022-03-25 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2339281 | 2339281 | 2022-03-24 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2336027 | 2336027 | 2022-03-23 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2332773 | 2332773 | 2022-03-22 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2329520 | 2329520 | 2022-03-21 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2326268 | 2326268 | 2022-03-20 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2323015 | 2323015 | 2022-03-19 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2319761 | 2319761 | 2022-03-18 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2316507 | 2316507 | 2022-03-17 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2313254 | 2313254 | 2022-03-16 | Charles Mix | South Dakota | 46023 | 2924 | 35 |
2310001 | 2310001 | 2022-03-15 | Charles Mix | South Dakota | 46023 | 2923 | 34 |
2306748 | 2306748 | 2022-03-14 | Charles Mix | South Dakota | 46023 | 2923 | 34 |
2303497 | 2303497 | 2022-03-13 | Charles Mix | South Dakota | 46023 | 2923 | 34 |
2300245 | 2300245 | 2022-03-12 | Charles Mix | South Dakota | 46023 | 2923 | 34 |
2296993 | 2296993 | 2022-03-11 | Charles Mix | South Dakota | 46023 | 2923 | 34 |
2293741 | 2293741 | 2022-03-10 | Charles Mix | South Dakota | 46023 | 2923 | 34 |
2290489 | 2290489 | 2022-03-09 | Charles Mix | South Dakota | 46023 | 2923 | 33 |
2287237 | 2287237 | 2022-03-08 | Charles Mix | South Dakota | 46023 | 2921 | 33 |
2283985 | 2283985 | 2022-03-07 | Charles Mix | South Dakota | 46023 | 2918 | 33 |
2280733 | 2280733 | 2022-03-06 | Charles Mix | South Dakota | 46023 | 2917 | 33 |
2277480 | 2277480 | 2022-03-05 | Charles Mix | South Dakota | 46023 | 2917 | 33 |
2274227 | 2274227 | 2022-03-04 | Charles Mix | South Dakota | 46023 | 2917 | 33 |
2270974 | 2270974 | 2022-03-03 | Charles Mix | South Dakota | 46023 | 2915 | 33 |
2267722 | 2267722 | 2022-03-02 | Charles Mix | South Dakota | 46023 | 2916 | 33 |
2264469 | 2264469 | 2022-03-01 | Charles Mix | South Dakota | 46023 | 2914 | 33 |
2261219 | 2261219 | 2022-02-28 | Charles Mix | South Dakota | 46023 | 2912 | 33 |
2257968 | 2257968 | 2022-02-27 | Charles Mix | South Dakota | 46023 | 2909 | 33 |
2254717 | 2254717 | 2022-02-26 | Charles Mix | South Dakota | 46023 | 2909 | 33 |
2251466 | 2251466 | 2022-02-25 | Charles Mix | South Dakota | 46023 | 2909 | 33 |
2248215 | 2248215 | 2022-02-24 | Charles Mix | South Dakota | 46023 | 2910 | 33 |
2244964 | 2244964 | 2022-02-23 | Charles Mix | South Dakota | 46023 | 2909 | 33 |
2241713 | 2241713 | 2022-02-22 | Charles Mix | South Dakota | 46023 | 2908 | 33 |
2238462 | 2238462 | 2022-02-21 | Charles Mix | South Dakota | 46023 | 2908 | 33 |
2235211 | 2235211 | 2022-02-20 | Charles Mix | South Dakota | 46023 | 2908 | 33 |
2231960 | 2231960 | 2022-02-19 | Charles Mix | South Dakota | 46023 | 2908 | 33 |
2228709 | 2228709 | 2022-02-18 | Charles Mix | South Dakota | 46023 | 2908 | 33 |
2225458 | 2225458 | 2022-02-17 | Charles Mix | South Dakota | 46023 | 2905 | 33 |
2222207 | 2222207 | 2022-02-16 | Charles Mix | South Dakota | 46023 | 2904 | 32 |
2218956 | 2218956 | 2022-02-15 | Charles Mix | South Dakota | 46023 | 2902 | 32 |
2215705 | 2215705 | 2022-02-14 | Charles Mix | South Dakota | 46023 | 2898 | 32 |
2212454 | 2212454 | 2022-02-13 | Charles Mix | South Dakota | 46023 | 2890 | 32 |
2209201 | 2209201 | 2022-02-12 | Charles Mix | South Dakota | 46023 | 2890 | 32 |
2205948 | 2205948 | 2022-02-11 | Charles Mix | South Dakota | 46023 | 2890 | 32 |
2202695 | 2202695 | 2022-02-10 | Charles Mix | South Dakota | 46023 | 2886 | 32 |
2199441 | 2199441 | 2022-02-09 | Charles Mix | South Dakota | 46023 | 2882 | 32 |
2196187 | 2196187 | 2022-02-08 | Charles Mix | South Dakota | 46023 | 2866 | 32 |
2192933 | 2192933 | 2022-02-07 | Charles Mix | South Dakota | 46023 | 2860 | 32 |
2189679 | 2189679 | 2022-02-06 | Charles Mix | South Dakota | 46023 | 2852 | 32 |
2186426 | 2186426 | 2022-02-05 | Charles Mix | South Dakota | 46023 | 2852 | 32 |
2183174 | 2183174 | 2022-02-04 | Charles Mix | South Dakota | 46023 | 2852 | 32 |
2179922 | 2179922 | 2022-02-03 | Charles Mix | South Dakota | 46023 | 2837 | 32 |
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);