ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 1119 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 490 ✖
- 1057 18
- 1062 9
- 2574 8
- 2575 8
- 1029 7
- 1056 7
- 286 5
- 365 5
- 438 5
- 1023 5
- 1036 5
- 1071 5
- 2117 5
- 275 4
- 411 4
- 414 4
- 890 4
- 1022 4
- 1024 4
- 1033 4
- 1053 4
- 1067 4
- 1340 4
- 1358 4
- 1365 4
- 1392 4
- 1398 4
- 1737 4
- 2561 4
- 2564 4
- 2567 4
- 2570 4
- 2576 4
- 2581 4
- 2586 4
- 2589 4
- 264 3
- 269 3
- 366 3
- 413 3
- 418 3
- 437 3
- 457 3
- 464 3
- 472 3
- 983 3
- 1010 3
- 1013 3
- 1031 3
- 1032 3
- 1041 3
- 1043 3
- 1050 3
- 1061 3
- 1163 3
- 1295 3
- 1311 3
- 1332 3
- 1375 3
- 1405 3
- 1412 3
- 2523 3
- 2548 3
- 2563 3
- 2585 3
- 2587 3
- 2590 3
- 1 2
- 7 2
- 17 2
- 51 2
- 55 2
- 110 2
- 229 2
- 249 2
- 272 2
- 285 2
- 326 2
- 372 2
- 386 2
- 397 2
- 400 2
- 402 2
- 403 2
- 406 2
- 409 2
- 417 2
- 434 2
- 443 2
- 487 2
- 488 2
- 510 2
- 547 2
- 553 2
- 586 2
- 865 2
- 882 2
- 887 2
- 891 2
- 905 2
- 928 2
- 949 2
- 952 2
- 969 2
- 973 2
- 982 2
- 1018 2
- 1030 2
- 1045 2
- 1047 2
- 1049 2
- 1052 2
- 1058 2
- 1060 2
- 1063 2
- 1069 2
- 1080 2
- 1095 2
- 1103 2
- 1116 2
- 1138 2
- 1144 2
- 1159 2
- 1179 2
- 1197 2
- 1241 2
- 1247 2
- 1256 2
- 1333 2
- 1357 2
- 1390 2
- 1397 2
- 1406 2
- 1408 2
- 1409 2
- 1418 2
- 1473 2
- 2281 2
- 2313 2
- 2337 2
- 2566 2
- 2578 2
- 3 1
- 4 1
- 6 1
- 10 1
- 15 1
- 18 1
- 19 1
- 20 1
- 23 1
- 26 1
- 30 1
- 31 1
- 33 1
- 35 1
- 36 1
- 40 1
- 44 1
- 46 1
- 47 1
- 53 1
- 56 1
- 64 1
- 68 1
- 72 1
- 77 1
- 81 1
- 85 1
- 87 1
- 92 1
- 93 1
- 98 1
- 100 1
- 106 1
- 115 1
- 120 1
- 124 1
- 127 1
- 136 1
- 148 1
- 164 1
- 170 1
- 172 1
- 185 1
- 191 1
- 193 1
- 204 1
- 210 1
- 213 1
- 216 1
- 220 1
- 224 1
- 225 1
- 227 1
- 237 1
- 244 1
- 246 1
- 248 1
- 254 1
- 258 1
- 261 1
- 265 1
- 267 1
- 268 1
- 270 1
- 276 1
- 277 1
- 280 1
- 288 1
- 292 1
- 293 1
- 298 1
- 305 1
- 307 1
- 310 1
- 313 1
- 316 1
- 318 1
- 324 1
- 325 1
- 331 1
- 341 1
- 342 1
- 352 1
- 354 1
- 355 1
- 357 1
- 364 1
- 367 1
- 369 1
- 377 1
- 378 1
- 380 1
- 381 1
- 385 1
- 387 1
- 394 1
- 398 1
- 399 1
- 412 1
- 423 1
- 432 1
- 435 1
- 436 1
- 441 1
- 452 1
- 454 1
- 459 1
- 461 1
- 463 1
- 467 1
- 468 1
- 470 1
- 473 1
- 474 1
- 477 1
- 486 1
- 489 1
- 490 1
- 494 1
- 502 1
- 506 1
- 509 1
- 514 1
- 517 1
- 521 1
- 527 1
- 533 1
- 536 1
- 537 1
- 542 1
- 552 1
- 562 1
- 571 1
- 575 1
- 577 1
- 581 1
- 584 1
- 589 1
- 595 1
- 601 1
- 612 1
- 619 1
- 622 1
- 623 1
- 630 1
- 636 1
- 643 1
- 659 1
- 666 1
- 668 1
- 686 1
- 696 1
- 701 1
- 733 1
- 738 1
- 743 1
- 749 1
- 771 1
- 798 1
- 802 1
- 815 1
- 816 1
- 818 1
- 822 1
- 825 1
- 834 1
- 849 1
- 857 1
- 863 1
- 874 1
- 885 1
- 888 1
- 889 1
- 895 1
- 896 1
- 897 1
- 900 1
- 906 1
- 908 1
- 912 1
- 925 1
- 930 1
- 934 1
- 937 1
- 942 1
- 955 1
- 957 1
- 958 1
- 963 1
- 964 1
- 968 1
- 970 1
- 975 1
- 977 1
- 978 1
- 981 1
- 984 1
- 985 1
- 986 1
- 994 1
- 997 1
- 1004 1
- 1008 1
- 1009 1
- 1016 1
- 1021 1
- 1025 1
- 1026 1
- 1028 1
- 1035 1
- 1037 1
- 1038 1
- 1039 1
- 1040 1
- 1044 1
- 1048 1
- 1054 1
- 1055 1
- 1066 1
- 1072 1
- 1075 1
- 1078 1
- 1084 1
- 1087 1
- 1090 1
- 1104 1
- 1106 1
- 1109 1
- 1112 1
- 1114 1
- 1119 1
- 1123 1
- 1124 1
- 1130 1
- 1149 1
- 1151 1
- 1153 1
- 1161 1
- 1171 1
- 1175 1
- 1178 1
- 1182 1
- 1191 1
- 1193 1
- 1195 1
- 1198 1
- 1199 1
- 1202 1
- 1205 1
- 1208 1
- 1218 1
- 1222 1
- 1224 1
- 1225 1
- 1226 1
- 1227 1
- 1229 1
- 1233 1
- 1234 1
- 1236 1
- 1238 1
- 1243 1
- 1244 1
- 1245 1
- 1248 1
- 1250 1
- 1253 1
- 1254 1
- 1283 1
- 1287 1
- 1289 1
- 1292 1
- 1298 1
- 1302 1
- 1307 1
- 1310 1
- 1313 1
- 1320 1
- 1327 1
- 1329 1
- 1330 1
- 1342 1
- 1349 1
- 1359 1
- 1360 1
- 1362 1
- 1366 1
- 1368 1
- 1372 1
- 1377 1
- 1381 1
- 1393 1
- 1402 1
- 1413 1
- 1415 1
- 1416 1
- 1417 1
- 1420 1
- 1422 1
- 1432 1
- 1460 1
- 1485 1
- 1488 1
- 1498 1
- 1523 1
- 1561 1
- 1628 1
- 1664 1
- 1683 1
- 1692 1
- 1705 1
- 1802 1
- 1808 1
- 1817 1
- 1862 1
- 1926 1
- 1982 1
- 2060 1
- 2108 1
- 2249 1
- 2268 1
- 2271 1
- 2273 1
- 2312 1
- 2317 1
- 2325 1
- 2343 1
- 2366 1
- 2369 1
- 2370 1
- 2395 1
- 2469 1
- 2514 1
- 2519 1
- 2524 1
- 2526 1
- 2534 1
- 2538 1
- 2555 1
- 2558 1
- 2559 1
- 2565 1
- 2568 1
- 2569 1
- 2572 1
- 2573 1
- 2583 1
- 2594 1
state 1
- Alabama · 775 ✖
fips 1
- 1119 · 775 ✖
county 1
- Sumter 775
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499634 | 2499634 | 2022-05-13 | Sumter | Alabama | 1119 | 2594 | 51 |
2496376 | 2496376 | 2022-05-12 | Sumter | Alabama | 1119 | 2590 | 51 |
2493118 | 2493118 | 2022-05-11 | Sumter | Alabama | 1119 | 2590 | 51 |
2489860 | 2489860 | 2022-05-10 | Sumter | Alabama | 1119 | 2590 | 51 |
2486603 | 2486603 | 2022-05-09 | Sumter | Alabama | 1119 | 2589 | 51 |
2483345 | 2483345 | 2022-05-08 | Sumter | Alabama | 1119 | 2589 | 51 |
2480087 | 2480087 | 2022-05-07 | Sumter | Alabama | 1119 | 2589 | 51 |
2476829 | 2476829 | 2022-05-06 | Sumter | Alabama | 1119 | 2589 | 51 |
2473571 | 2473571 | 2022-05-05 | Sumter | Alabama | 1119 | 2587 | 51 |
2470314 | 2470314 | 2022-05-04 | Sumter | Alabama | 1119 | 2587 | 51 |
2467058 | 2467058 | 2022-05-03 | Sumter | Alabama | 1119 | 2587 | 51 |
2463803 | 2463803 | 2022-05-02 | Sumter | Alabama | 1119 | 2586 | 51 |
2460547 | 2460547 | 2022-05-01 | Sumter | Alabama | 1119 | 2586 | 51 |
2457291 | 2457291 | 2022-04-30 | Sumter | Alabama | 1119 | 2586 | 51 |
2454035 | 2454035 | 2022-04-29 | Sumter | Alabama | 1119 | 2586 | 51 |
2450779 | 2450779 | 2022-04-28 | Sumter | Alabama | 1119 | 2585 | 51 |
2447523 | 2447523 | 2022-04-27 | Sumter | Alabama | 1119 | 2585 | 51 |
2444267 | 2444267 | 2022-04-26 | Sumter | Alabama | 1119 | 2585 | 51 |
2441011 | 2441011 | 2022-04-25 | Sumter | Alabama | 1119 | 2583 | 51 |
2437755 | 2437755 | 2022-04-24 | Sumter | Alabama | 1119 | 2581 | 51 |
2434499 | 2434499 | 2022-04-23 | Sumter | Alabama | 1119 | 2581 | 51 |
2431243 | 2431243 | 2022-04-22 | Sumter | Alabama | 1119 | 2581 | 51 |
2427987 | 2427987 | 2022-04-21 | Sumter | Alabama | 1119 | 2581 | 51 |
2424731 | 2424731 | 2022-04-20 | Sumter | Alabama | 1119 | 2578 | 51 |
2421475 | 2421475 | 2022-04-19 | Sumter | Alabama | 1119 | 2578 | 51 |
2418219 | 2418219 | 2022-04-18 | Sumter | Alabama | 1119 | 2576 | 51 |
2414963 | 2414963 | 2022-04-17 | Sumter | Alabama | 1119 | 2576 | 51 |
2411707 | 2411707 | 2022-04-16 | Sumter | Alabama | 1119 | 2576 | 51 |
2408451 | 2408451 | 2022-04-15 | Sumter | Alabama | 1119 | 2576 | 51 |
2405195 | 2405195 | 2022-04-14 | Sumter | Alabama | 1119 | 2575 | 51 |
2401940 | 2401940 | 2022-04-13 | Sumter | Alabama | 1119 | 2575 | 51 |
2398685 | 2398685 | 2022-04-12 | Sumter | Alabama | 1119 | 2575 | 51 |
2395430 | 2395430 | 2022-04-11 | Sumter | Alabama | 1119 | 2575 | 51 |
2392174 | 2392174 | 2022-04-10 | Sumter | Alabama | 1119 | 2575 | 51 |
2388918 | 2388918 | 2022-04-09 | Sumter | Alabama | 1119 | 2575 | 51 |
2385663 | 2385663 | 2022-04-08 | Sumter | Alabama | 1119 | 2575 | 51 |
2382408 | 2382408 | 2022-04-07 | Sumter | Alabama | 1119 | 2575 | 51 |
2379153 | 2379153 | 2022-04-06 | Sumter | Alabama | 1119 | 2574 | 51 |
2375899 | 2375899 | 2022-04-05 | Sumter | Alabama | 1119 | 2574 | 51 |
2372647 | 2372647 | 2022-04-04 | Sumter | Alabama | 1119 | 2574 | 51 |
2369394 | 2369394 | 2022-04-03 | Sumter | Alabama | 1119 | 2574 | 51 |
2366141 | 2366141 | 2022-04-02 | Sumter | Alabama | 1119 | 2574 | 51 |
2362888 | 2362888 | 2022-04-01 | Sumter | Alabama | 1119 | 2574 | 51 |
2359634 | 2359634 | 2022-03-31 | Sumter | Alabama | 1119 | 2574 | 50 |
2356380 | 2356380 | 2022-03-30 | Sumter | Alabama | 1119 | 2574 | 50 |
2353127 | 2353127 | 2022-03-29 | Sumter | Alabama | 1119 | 2573 | 50 |
2349875 | 2349875 | 2022-03-28 | Sumter | Alabama | 1119 | 2572 | 50 |
2346622 | 2346622 | 2022-03-27 | Sumter | Alabama | 1119 | 2570 | 49 |
2343369 | 2343369 | 2022-03-26 | Sumter | Alabama | 1119 | 2570 | 49 |
2340116 | 2340116 | 2022-03-25 | Sumter | Alabama | 1119 | 2570 | 49 |
2336863 | 2336863 | 2022-03-24 | Sumter | Alabama | 1119 | 2570 | 49 |
2333609 | 2333609 | 2022-03-23 | Sumter | Alabama | 1119 | 2569 | 49 |
2330355 | 2330355 | 2022-03-22 | Sumter | Alabama | 1119 | 2568 | 49 |
2327103 | 2327103 | 2022-03-21 | Sumter | Alabama | 1119 | 2567 | 49 |
2323850 | 2323850 | 2022-03-20 | Sumter | Alabama | 1119 | 2567 | 49 |
2320596 | 2320596 | 2022-03-19 | Sumter | Alabama | 1119 | 2567 | 49 |
2317342 | 2317342 | 2022-03-18 | Sumter | Alabama | 1119 | 2567 | 49 |
2314089 | 2314089 | 2022-03-17 | Sumter | Alabama | 1119 | 2566 | 49 |
2310836 | 2310836 | 2022-03-16 | Sumter | Alabama | 1119 | 2566 | 49 |
2307583 | 2307583 | 2022-03-15 | Sumter | Alabama | 1119 | 2565 | 49 |
2304332 | 2304332 | 2022-03-14 | Sumter | Alabama | 1119 | 2564 | 49 |
2301080 | 2301080 | 2022-03-13 | Sumter | Alabama | 1119 | 2564 | 49 |
2297828 | 2297828 | 2022-03-12 | Sumter | Alabama | 1119 | 2564 | 49 |
2294576 | 2294576 | 2022-03-11 | Sumter | Alabama | 1119 | 2564 | 49 |
2291324 | 2291324 | 2022-03-10 | Sumter | Alabama | 1119 | 2563 | 48 |
2288072 | 2288072 | 2022-03-09 | Sumter | Alabama | 1119 | 2563 | 48 |
2284820 | 2284820 | 2022-03-08 | Sumter | Alabama | 1119 | 2563 | 48 |
2281568 | 2281568 | 2022-03-07 | Sumter | Alabama | 1119 | 2561 | 47 |
2278315 | 2278315 | 2022-03-06 | Sumter | Alabama | 1119 | 2561 | 46 |
2275062 | 2275062 | 2022-03-05 | Sumter | Alabama | 1119 | 2561 | 46 |
2271809 | 2271809 | 2022-03-04 | Sumter | Alabama | 1119 | 2561 | 46 |
2268557 | 2268557 | 2022-03-03 | Sumter | Alabama | 1119 | 2559 | 46 |
2265304 | 2265304 | 2022-03-02 | Sumter | Alabama | 1119 | 2558 | 45 |
2262054 | 2262054 | 2022-03-01 | Sumter | Alabama | 1119 | 2555 | 45 |
2258803 | 2258803 | 2022-02-28 | Sumter | Alabama | 1119 | 2548 | 45 |
2255552 | 2255552 | 2022-02-27 | Sumter | Alabama | 1119 | 2548 | 45 |
2252301 | 2252301 | 2022-02-26 | Sumter | Alabama | 1119 | 2548 | 45 |
2249050 | 2249050 | 2022-02-25 | Sumter | Alabama | 1119 | 2538 | 45 |
2245799 | 2245799 | 2022-02-24 | Sumter | Alabama | 1119 | 2534 | 45 |
2242548 | 2242548 | 2022-02-23 | Sumter | Alabama | 1119 | 2526 | 45 |
2239297 | 2239297 | 2022-02-22 | Sumter | Alabama | 1119 | 2524 | 45 |
2236046 | 2236046 | 2022-02-21 | Sumter | Alabama | 1119 | 2523 | 45 |
2232795 | 2232795 | 2022-02-20 | Sumter | Alabama | 1119 | 2523 | 45 |
2229544 | 2229544 | 2022-02-19 | Sumter | Alabama | 1119 | 2523 | 45 |
2226293 | 2226293 | 2022-02-18 | Sumter | Alabama | 1119 | 2519 | 45 |
2223042 | 2223042 | 2022-02-17 | Sumter | Alabama | 1119 | 2514 | 45 |
2219791 | 2219791 | 2022-02-16 | Sumter | Alabama | 1119 | 2469 | 45 |
2216541 | 2216541 | 2022-02-15 | Sumter | Alabama | 1119 | 2395 | 44 |
2213290 | 2213290 | 2022-02-14 | Sumter | Alabama | 1119 | 2370 | 44 |
2210037 | 2210037 | 2022-02-13 | Sumter | Alabama | 1119 | 2369 | 44 |
2206784 | 2206784 | 2022-02-12 | Sumter | Alabama | 1119 | 2366 | 44 |
2203531 | 2203531 | 2022-02-11 | Sumter | Alabama | 1119 | 2343 | 44 |
2200277 | 2200277 | 2022-02-10 | Sumter | Alabama | 1119 | 2337 | 44 |
2197023 | 2197023 | 2022-02-09 | Sumter | Alabama | 1119 | 2337 | 43 |
2193768 | 2193768 | 2022-02-08 | Sumter | Alabama | 1119 | 2325 | 43 |
2190515 | 2190515 | 2022-02-07 | Sumter | Alabama | 1119 | 2317 | 43 |
2187262 | 2187262 | 2022-02-06 | Sumter | Alabama | 1119 | 2313 | 43 |
2184009 | 2184009 | 2022-02-05 | Sumter | Alabama | 1119 | 2313 | 43 |
2180757 | 2180757 | 2022-02-04 | Sumter | Alabama | 1119 | 2312 | 43 |
2177506 | 2177506 | 2022-02-03 | Sumter | Alabama | 1119 | 2281 | 43 |
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);