ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 19005 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 354 ✖
- 121 14
- 120 12
- 1529 11
- 7 8
- 1545 7
- 1550 7
- 1555 7
- 1564 7
- 1574 7
- 1591 7
- 1612 7
- 1627 7
- 1666 7
- 1701 7
- 1762 7
- 1812 7
- 1846 7
- 1893 7
- 1929 7
- 1947 7
- 1963 7
- 1982 7
- 1993 7
- 2010 7
- 2046 7
- 2106 7
- 2166 7
- 2229 7
- 2273 7
- 2320 7
- 2382 7
- 2489 7
- 2605 7
- 2692 7
- 2740 7
- 2779 7
- 2809 7
- 2831 7
- 2843 7
- 2846 7
- 2850 7
- 2853 7
- 2861 7
- 2866 7
- 2868 7
- 2869 7
- 2873 7
- 2881 7
- 138 6
- 1386 6
- 1491 6
- 1522 6
- 2 5
- 118 5
- 1526 5
- 122 4
- 139 4
- 163 4
- 1489 4
- 1490 4
- 1495 4
- 1514 4
- 1523 4
- 1525 4
- 1530 4
- 98 3
- 116 3
- 123 3
- 126 3
- 144 3
- 146 3
- 154 3
- 1396 3
- 1436 3
- 1468 3
- 1474 3
- 1483 3
- 1485 3
- 1521 3
- 1524 3
- 2890 3
- 5 2
- 6 2
- 16 2
- 17 2
- 19 2
- 21 2
- 24 2
- 99 2
- 101 2
- 113 2
- 114 2
- 115 2
- 119 2
- 128 2
- 135 2
- 143 2
- 145 2
- 149 2
- 155 2
- 164 2
- 168 2
- 172 2
- 174 2
- 265 2
- 266 2
- 297 2
- 1309 2
- 1316 2
- 1346 2
- 1493 2
- 1494 2
- 1499 2
- 1500 2
- 1502 2
- 1509 2
- 1515 2
- 1527 2
- 3 1
- 15 1
- 18 1
- 20 1
- 23 1
- 26 1
- 27 1
- 34 1
- 36 1
- 40 1
- 44 1
- 45 1
- 46 1
- 50 1
- 56 1
- 68 1
- 72 1
- 86 1
- 88 1
- 89 1
- 90 1
- 93 1
- 111 1
- 112 1
- 125 1
- 131 1
- 133 1
- 141 1
- 148 1
- 150 1
- 151 1
- 152 1
- 156 1
- 158 1
- 160 1
- 162 1
- 165 1
- 166 1
- 167 1
- 169 1
- 182 1
- 183 1
- 184 1
- 185 1
- 186 1
- 189 1
- 190 1
- 193 1
- 201 1
- 203 1
- 211 1
- 213 1
- 215 1
- 217 1
- 224 1
- 225 1
- 227 1
- 236 1
- 237 1
- 242 1
- 245 1
- 248 1
- 251 1
- 253 1
- 256 1
- 259 1
- 261 1
- 264 1
- 269 1
- 270 1
- 271 1
- 277 1
- 278 1
- 281 1
- 286 1
- 292 1
- 295 1
- 296 1
- 302 1
- 308 1
- 317 1
- 319 1
- 324 1
- 327 1
- 335 1
- 337 1
- 351 1
- 353 1
- 360 1
- 363 1
- 371 1
- 382 1
- 388 1
- 400 1
- 418 1
- 428 1
- 431 1
- 439 1
- 449 1
- 456 1
- 474 1
- 480 1
- 488 1
- 506 1
- 521 1
- 544 1
- 555 1
- 567 1
- 587 1
- 606 1
- 609 1
- 626 1
- 640 1
- 663 1
- 674 1
- 688 1
- 695 1
- 711 1
- 724 1
- 732 1
- 764 1
- 768 1
- 790 1
- 799 1
- 818 1
- 828 1
- 850 1
- 870 1
- 884 1
- 912 1
- 922 1
- 925 1
- 939 1
- 940 1
- 964 1
- 980 1
- 995 1
- 1003 1
- 1012 1
- 1017 1
- 1027 1
- 1046 1
- 1056 1
- 1067 1
- 1087 1
- 1091 1
- 1101 1
- 1110 1
- 1122 1
- 1133 1
- 1138 1
- 1142 1
- 1144 1
- 1152 1
- 1171 1
- 1176 1
- 1179 1
- 1184 1
- 1188 1
- 1194 1
- 1207 1
- 1215 1
- 1224 1
- 1227 1
- 1234 1
- 1238 1
- 1241 1
- 1245 1
- 1250 1
- 1254 1
- 1259 1
- 1263 1
- 1268 1
- 1269 1
- 1276 1
- 1279 1
- 1296 1
- 1300 1
- 1302 1
- 1315 1
- 1318 1
- 1319 1
- 1325 1
- 1328 1
- 1329 1
- 1331 1
- 1341 1
- 1343 1
- 1351 1
- 1353 1
- 1355 1
- 1359 1
- 1363 1
- 1370 1
- 1371 1
- 1375 1
- 1376 1
- 1380 1
- 1384 1
- 1385 1
- 1393 1
- 1407 1
- 1412 1
- 1422 1
- 1425 1
- 1449 1
- 1453 1
- 1457 1
- 1462 1
- 1463 1
- 1464 1
- 1470 1
- 1473 1
- 1477 1
- 1478 1
- 1479 1
- 1480 1
- 1482 1
- 1484 1
- 1486 1
- 1487 1
- 1488 1
- 1497 1
- 1498 1
- 1503 1
- 1505 1
- 1508 1
- 1512 1
- 1513 1
- 1516 1
- 1518 1
- 1519 1
- 1520 1
- 1531 1
- 1532 1
- 1533 1
state 1
- Iowa 790
fips 1
- 19005 · 790 ✖
county 1
- Allamakee 790
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500375 | 2500375 | 2022-05-13 | Allamakee | Iowa | 19005 | 2890 | 60 |
2497117 | 2497117 | 2022-05-12 | Allamakee | Iowa | 19005 | 2890 | 60 |
2493859 | 2493859 | 2022-05-11 | Allamakee | Iowa | 19005 | 2890 | 60 |
2490601 | 2490601 | 2022-05-10 | Allamakee | Iowa | 19005 | 2881 | 60 |
2487344 | 2487344 | 2022-05-09 | Allamakee | Iowa | 19005 | 2881 | 60 |
2484086 | 2484086 | 2022-05-08 | Allamakee | Iowa | 19005 | 2881 | 60 |
2480828 | 2480828 | 2022-05-07 | Allamakee | Iowa | 19005 | 2881 | 60 |
2477570 | 2477570 | 2022-05-06 | Allamakee | Iowa | 19005 | 2881 | 60 |
2474312 | 2474312 | 2022-05-05 | Allamakee | Iowa | 19005 | 2881 | 60 |
2471055 | 2471055 | 2022-05-04 | Allamakee | Iowa | 19005 | 2881 | 60 |
2467799 | 2467799 | 2022-05-03 | Allamakee | Iowa | 19005 | 2873 | 60 |
2464544 | 2464544 | 2022-05-02 | Allamakee | Iowa | 19005 | 2873 | 60 |
2461288 | 2461288 | 2022-05-01 | Allamakee | Iowa | 19005 | 2873 | 60 |
2458032 | 2458032 | 2022-04-30 | Allamakee | Iowa | 19005 | 2873 | 60 |
2454776 | 2454776 | 2022-04-29 | Allamakee | Iowa | 19005 | 2873 | 60 |
2451520 | 2451520 | 2022-04-28 | Allamakee | Iowa | 19005 | 2873 | 60 |
2448264 | 2448264 | 2022-04-27 | Allamakee | Iowa | 19005 | 2873 | 60 |
2445008 | 2445008 | 2022-04-26 | Allamakee | Iowa | 19005 | 2869 | 59 |
2441752 | 2441752 | 2022-04-25 | Allamakee | Iowa | 19005 | 2869 | 59 |
2438496 | 2438496 | 2022-04-24 | Allamakee | Iowa | 19005 | 2869 | 59 |
2435240 | 2435240 | 2022-04-23 | Allamakee | Iowa | 19005 | 2869 | 59 |
2431984 | 2431984 | 2022-04-22 | Allamakee | Iowa | 19005 | 2869 | 59 |
2428728 | 2428728 | 2022-04-21 | Allamakee | Iowa | 19005 | 2869 | 59 |
2425472 | 2425472 | 2022-04-20 | Allamakee | Iowa | 19005 | 2869 | 59 |
2422216 | 2422216 | 2022-04-19 | Allamakee | Iowa | 19005 | 2868 | 59 |
2418960 | 2418960 | 2022-04-18 | Allamakee | Iowa | 19005 | 2868 | 59 |
2415704 | 2415704 | 2022-04-17 | Allamakee | Iowa | 19005 | 2868 | 59 |
2412448 | 2412448 | 2022-04-16 | Allamakee | Iowa | 19005 | 2868 | 59 |
2409192 | 2409192 | 2022-04-15 | Allamakee | Iowa | 19005 | 2868 | 59 |
2405936 | 2405936 | 2022-04-14 | Allamakee | Iowa | 19005 | 2868 | 59 |
2402680 | 2402680 | 2022-04-13 | Allamakee | Iowa | 19005 | 2868 | 59 |
2399426 | 2399426 | 2022-04-12 | Allamakee | Iowa | 19005 | 2866 | 59 |
2396170 | 2396170 | 2022-04-11 | Allamakee | Iowa | 19005 | 2866 | 59 |
2392915 | 2392915 | 2022-04-10 | Allamakee | Iowa | 19005 | 2866 | 59 |
2389659 | 2389659 | 2022-04-09 | Allamakee | Iowa | 19005 | 2866 | 59 |
2386403 | 2386403 | 2022-04-08 | Allamakee | Iowa | 19005 | 2866 | 59 |
2383149 | 2383149 | 2022-04-07 | Allamakee | Iowa | 19005 | 2866 | 59 |
2379894 | 2379894 | 2022-04-06 | Allamakee | Iowa | 19005 | 2866 | 59 |
2376639 | 2376639 | 2022-04-05 | Allamakee | Iowa | 19005 | 2861 | 59 |
2373387 | 2373387 | 2022-04-04 | Allamakee | Iowa | 19005 | 2861 | 59 |
2370134 | 2370134 | 2022-04-03 | Allamakee | Iowa | 19005 | 2861 | 59 |
2366881 | 2366881 | 2022-04-02 | Allamakee | Iowa | 19005 | 2861 | 59 |
2363628 | 2363628 | 2022-04-01 | Allamakee | Iowa | 19005 | 2861 | 59 |
2360374 | 2360374 | 2022-03-31 | Allamakee | Iowa | 19005 | 2861 | 59 |
2357120 | 2357120 | 2022-03-30 | Allamakee | Iowa | 19005 | 2861 | 59 |
2353867 | 2353867 | 2022-03-29 | Allamakee | Iowa | 19005 | 2853 | 59 |
2350615 | 2350615 | 2022-03-28 | Allamakee | Iowa | 19005 | 2853 | 59 |
2347362 | 2347362 | 2022-03-27 | Allamakee | Iowa | 19005 | 2853 | 59 |
2344109 | 2344109 | 2022-03-26 | Allamakee | Iowa | 19005 | 2853 | 59 |
2340856 | 2340856 | 2022-03-25 | Allamakee | Iowa | 19005 | 2853 | 59 |
2337603 | 2337603 | 2022-03-24 | Allamakee | Iowa | 19005 | 2853 | 59 |
2334349 | 2334349 | 2022-03-23 | Allamakee | Iowa | 19005 | 2853 | 59 |
2331095 | 2331095 | 2022-03-22 | Allamakee | Iowa | 19005 | 2850 | 59 |
2327843 | 2327843 | 2022-03-21 | Allamakee | Iowa | 19005 | 2850 | 59 |
2324590 | 2324590 | 2022-03-20 | Allamakee | Iowa | 19005 | 2850 | 59 |
2321336 | 2321336 | 2022-03-19 | Allamakee | Iowa | 19005 | 2850 | 59 |
2318082 | 2318082 | 2022-03-18 | Allamakee | Iowa | 19005 | 2850 | 59 |
2314829 | 2314829 | 2022-03-17 | Allamakee | Iowa | 19005 | 2850 | 59 |
2311576 | 2311576 | 2022-03-16 | Allamakee | Iowa | 19005 | 2850 | 59 |
2308323 | 2308323 | 2022-03-15 | Allamakee | Iowa | 19005 | 2846 | 59 |
2305072 | 2305072 | 2022-03-14 | Allamakee | Iowa | 19005 | 2846 | 59 |
2301820 | 2301820 | 2022-03-13 | Allamakee | Iowa | 19005 | 2846 | 59 |
2298568 | 2298568 | 2022-03-12 | Allamakee | Iowa | 19005 | 2846 | 59 |
2295316 | 2295316 | 2022-03-11 | Allamakee | Iowa | 19005 | 2846 | 59 |
2292064 | 2292064 | 2022-03-10 | Allamakee | Iowa | 19005 | 2846 | 59 |
2288812 | 2288812 | 2022-03-09 | Allamakee | Iowa | 19005 | 2846 | 59 |
2285561 | 2285561 | 2022-03-08 | Allamakee | Iowa | 19005 | 2843 | 59 |
2282309 | 2282309 | 2022-03-07 | Allamakee | Iowa | 19005 | 2843 | 59 |
2279056 | 2279056 | 2022-03-06 | Allamakee | Iowa | 19005 | 2843 | 59 |
2275803 | 2275803 | 2022-03-05 | Allamakee | Iowa | 19005 | 2843 | 59 |
2272550 | 2272550 | 2022-03-04 | Allamakee | Iowa | 19005 | 2843 | 59 |
2269298 | 2269298 | 2022-03-03 | Allamakee | Iowa | 19005 | 2843 | 59 |
2266045 | 2266045 | 2022-03-02 | Allamakee | Iowa | 19005 | 2843 | 59 |
2262794 | 2262794 | 2022-03-01 | Allamakee | Iowa | 19005 | 2831 | 59 |
2259543 | 2259543 | 2022-02-28 | Allamakee | Iowa | 19005 | 2831 | 59 |
2256292 | 2256292 | 2022-02-27 | Allamakee | Iowa | 19005 | 2831 | 59 |
2253041 | 2253041 | 2022-02-26 | Allamakee | Iowa | 19005 | 2831 | 59 |
2249790 | 2249790 | 2022-02-25 | Allamakee | Iowa | 19005 | 2831 | 59 |
2246539 | 2246539 | 2022-02-24 | Allamakee | Iowa | 19005 | 2831 | 59 |
2243288 | 2243288 | 2022-02-23 | Allamakee | Iowa | 19005 | 2831 | 59 |
2240037 | 2240037 | 2022-02-22 | Allamakee | Iowa | 19005 | 2809 | 59 |
2236786 | 2236786 | 2022-02-21 | Allamakee | Iowa | 19005 | 2809 | 59 |
2233535 | 2233535 | 2022-02-20 | Allamakee | Iowa | 19005 | 2809 | 59 |
2230284 | 2230284 | 2022-02-19 | Allamakee | Iowa | 19005 | 2809 | 59 |
2227033 | 2227033 | 2022-02-18 | Allamakee | Iowa | 19005 | 2809 | 59 |
2223782 | 2223782 | 2022-02-17 | Allamakee | Iowa | 19005 | 2809 | 59 |
2220531 | 2220531 | 2022-02-16 | Allamakee | Iowa | 19005 | 2809 | 59 |
2217280 | 2217280 | 2022-02-15 | Allamakee | Iowa | 19005 | 2779 | 59 |
2214029 | 2214029 | 2022-02-14 | Allamakee | Iowa | 19005 | 2779 | 59 |
2210777 | 2210777 | 2022-02-13 | Allamakee | Iowa | 19005 | 2779 | 59 |
2207524 | 2207524 | 2022-02-12 | Allamakee | Iowa | 19005 | 2779 | 59 |
2204271 | 2204271 | 2022-02-11 | Allamakee | Iowa | 19005 | 2779 | 59 |
2201018 | 2201018 | 2022-02-10 | Allamakee | Iowa | 19005 | 2779 | 59 |
2197764 | 2197764 | 2022-02-09 | Allamakee | Iowa | 19005 | 2779 | 59 |
2194510 | 2194510 | 2022-02-08 | Allamakee | Iowa | 19005 | 2740 | 58 |
2191256 | 2191256 | 2022-02-07 | Allamakee | Iowa | 19005 | 2740 | 58 |
2188003 | 2188003 | 2022-02-06 | Allamakee | Iowa | 19005 | 2740 | 58 |
2184750 | 2184750 | 2022-02-05 | Allamakee | Iowa | 19005 | 2740 | 58 |
2181498 | 2181498 | 2022-02-04 | Allamakee | Iowa | 19005 | 2740 | 58 |
2178247 | 2178247 | 2022-02-03 | Allamakee | Iowa | 19005 | 2740 | 58 |
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);