ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 1127 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 689 ✖
- 7372 5
- 15805 5
- 1 4
- 7284 4
- 13579 4
- 18652 4
- 18658 4
- 49 3
- 83 3
- 84 3
- 7205 3
- 7310 3
- 7318 3
- 7338 3
- 7353 3
- 8751 3
- 18484 3
- 18515 3
- 18525 3
- 18536 3
- 18598 3
- 18729 3
- 18736 3
- 18748 3
- 32 2
- 72 2
- 85 2
- 89 2
- 90 2
- 91 2
- 93 2
- 97 2
- 100 2
- 106 2
- 126 2
- 6131 2
- 6689 2
- 7017 2
- 7087 2
- 7149 2
- 7261 2
- 7263 2
- 7270 2
- 7274 2
- 7315 2
- 7335 2
- 7341 2
- 7351 2
- 7362 2
- 7371 2
- 7400 2
- 7421 2
- 7437 2
- 7718 2
- 8008 2
- 8262 2
- 12011 2
- 12635 2
- 17677 2
- 17819 2
- 18521 2
- 18656 2
- 18727 2
- 18732 2
- 3 1
- 5 1
- 9 1
- 18 1
- 24 1
- 28 1
- 30 1
- 31 1
- 34 1
- 54 1
- 64 1
- 68 1
- 78 1
- 92 1
- 94 1
- 95 1
- 99 1
- 101 1
- 103 1
- 105 1
- 107 1
- 110 1
- 111 1
- 116 1
- 119 1
- 139 1
- 148 1
- 164 1
- 172 1
- 179 1
- 191 1
- 198 1
- 239 1
- 272 1
- 282 1
- 299 1
- 330 1
- 344 1
- 354 1
- 380 1
- 388 1
- 391 1
- 396 1
- 407 1
- 443 1
- 462 1
- 470 1
- 477 1
- 491 1
- 510 1
- 533 1
- 550 1
- 578 1
- 588 1
- 621 1
- 626 1
- 652 1
- 674 1
- 679 1
- 693 1
- 705 1
- 722 1
- 741 1
- 761 1
- 774 1
- 791 1
- 797 1
- 840 1
- 855 1
- 880 1
- 884 1
- 918 1
- 927 1
- 952 1
- 991 1
- 998 1
- 1031 1
- 1066 1
- 1070 1
- 1077 1
- 1091 1
- 1129 1
- 1143 1
- 1152 1
- 1178 1
- 1220 1
- 1243 1
- 1254 1
- 1274 1
- 1276 1
- 1290 1
- 1312 1
- 1358 1
- 1377 1
- 1385 1
- 1419 1
- 1429 1
- 1432 1
- 1445 1
- 1466 1
- 1475 1
- 1484 1
- 1500 1
- 1506 1
- 1511 1
- 1532 1
- 1536 1
- 1555 1
- 1561 1
- 1577 1
- 1584 1
- 1588 1
- 1603 1
- 1624 1
- 1648 1
- 1670 1
- 1684 1
- 1703 1
- 1718 1
- 1749 1
- 1761 1
- 1771 1
- 1778 1
- 1832 1
- 1839 1
- 1853 1
- 1873 1
- 1886 1
- 1900 1
- 1907 1
- 1914 1
- 1937 1
- 1945 1
- 1977 1
- 2000 1
- 2008 1
- 2029 1
- 2061 1
- 2067 1
- 2085 1
- 2099 1
- 2113 1
- 2124 1
- 2153 1
- 2159 1
- 2164 1
- 2174 1
- 2177 1
- 2191 1
- 2207 1
- 2226 1
- 2243 1
- 2250 1
- 2253 1
- 2284 1
- 2306 1
- 2316 1
- 2319 1
- 2330 1
- 2354 1
- 2369 1
- 2376 1
- 2403 1
- 2415 1
- 2424 1
- 2436 1
- 2448 1
- 2472 1
- 2493 1
- 2513 1
- 2527 1
- 2533 1
- 2539 1
- 2586 1
- 2590 1
- 2602 1
- 2615 1
- 2627 1
- 2641 1
- 2680 1
- 2688 1
- 2699 1
- 2722 1
- 2755 1
- 2772 1
- 2794 1
- 2823 1
- 2837 1
- 2855 1
- 2874 1
- 2902 1
- 2949 1
- 2966 1
- 2985 1
- 2992 1
- 3056 1
- 3083 1
- 3109 1
- 3129 1
- 3141 1
- 3152 1
- 3155 1
- 3176 1
- 3203 1
- 3252 1
- 3278 1
- 3294 1
- 3307 1
- 3326 1
- 3377 1
- 3399 1
- 3424 1
- 3458 1
- 3480 1
- 3490 1
- 3561 1
- 3588 1
- 3620 1
- 3634 1
- 3657 1
- 3689 1
- 3710 1
- 3735 1
- 3818 1
- 3861 1
- 3914 1
- 3950 1
- 3983 1
- 4002 1
- 4128 1
- 4190 1
- 4293 1
- 4355 1
- 4396 1
- 4424 1
- 4445 1
- 4479 1
- 4512 1
- 4568 1
- 4648 1
- 4699 1
- 4720 1
- 4741 1
- 4825 1
- 4882 1
- 4933 1
- 4994 1
- 5022 1
- 5036 1
- 5046 1
- 5069 1
- 5185 1
- 5259 1
- 5296 1
- 5357 1
- 5374 1
- 5377 1
- 5421 1
- 5464 1
- 5537 1
- 5648 1
- 5714 1
- 5734 1
- 5758 1
- 5775 1
- 5803 1
- 5834 1
- 5852 1
- 5880 1
- 5897 1
- 5903 1
- 5930 1
- 5954 1
- 5993 1
- 6002 1
- 6028 1
- 6036 1
- 6050 1
- 6068 1
- 6078 1
- 6105 1
- 6158 1
- 6165 1
- 6180 1
- 6192 1
- 6216 1
- 6229 1
- 6251 1
- 6256 1
- 6259 1
- 6273 1
- 6305 1
- 6325 1
- 6347 1
- 6353 1
- 6360 1
- 6366 1
- 6375 1
- 6384 1
- 6403 1
- 6426 1
- 6443 1
- 6447 1
- 6451 1
- 6466 1
- 6492 1
- 6504 1
- 6509 1
- 6514 1
- 6518 1
- 6524 1
- 6538 1
- 6571 1
- 6585 1
- 6593 1
- 6600 1
- 6601 1
- 6606 1
- 6625 1
- 6636 1
- 6679 1
- 6680 1
- 6973 1
- 6979 1
- 6989 1
- 7000 1
- 7005 1
- 7010 1
- 7015 1
- 7026 1
- 7029 1
- 7032 1
- 7040 1
- 7043 1
- 7046 1
- 7053 1
- 7058 1
- 7066 1
- 7067 1
- 7069 1
- 7070 1
- 7073 1
- 7076 1
- 7079 1
- 7080 1
- 7083 1
- 7092 1
- 7100 1
- 7101 1
- 7126 1
- 7139 1
- 7146 1
- 7151 1
- 7153 1
- 7160 1
- 7167 1
- 7170 1
- 7175 1
- 7176 1
- 7184 1
- 7190 1
- 7199 1
- 7200 1
- 7203 1
- 7214 1
- 7222 1
- 7223 1
- 7231 1
- 7235 1
- 7236 1
- 7241 1
- 7244 1
- 7246 1
- 7259 1
- 7260 1
- 7268 1
- 7278 1
- 7282 1
- 7283 1
- 7296 1
- 7304 1
- 7306 1
- 7313 1
- 7316 1
- 7330 1
- 7334 1
- 7412 1
- 7449 1
- 7466 1
- 7476 1
- 7488 1
- 7491 1
- 7498 1
- 7524 1
- 7535 1
- 7545 1
- 7566 1
- 7581 1
- 7594 1
- 7619 1
- 7659 1
- 7681 1
- 7775 1
- 7793 1
- 7817 1
- 7840 1
- 7873 1
- 7906 1
- 7968 1
- 8053 1
- 8115 1
- 8158 1
- 8212 1
- 8318 1
- 8336 1
- 8426 1
- 8488 1
- 8529 1
- 8588 1
- 8693 1
- 8730 1
- 8853 1
- 8915 1
- 8967 1
- 9004 1
- 9058 1
- 9158 1
- 9200 1
- 9274 1
- 9359 1
- 9407 1
- 9429 1
- 9464 1
- 9542 1
- 9596 1
- 9638 1
- 9723 1
- 9800 1
- 9829 1
- 9886 1
- 9987 1
- 10047 1
- 10110 1
- 10171 1
- 10231 1
- 10260 1
- 10308 1
- 10393 1
- 10430 1
- 10495 1
- 10524 1
- 10561 1
- 10588 1
- 10604 1
- 10633 1
- 10671 1
- 10723 1
- 10749 1
- 10777 1
- 10791 1
- 10806 1
- 10854 1
- 10898 1
- 10919 1
- 10955 1
- 10969 1
- 10976 1
- 10990 1
- 11026 1
- 11043 1
- 11055 1
- 11069 1
- 11085 1
- 11089 1
- 11096 1
- 11119 1
- 11142 1
- 11162 1
- 11180 1
- 11202 1
- 11206 1
- 11221 1
- 11255 1
- 11351 1
- 11391 1
- 11423 1
- 11435 1
- 11443 1
- 11450 1
- 11477 1
- 11502 1
- 11591 1
- 11608 1
- 11623 1
- 11638 1
- 11658 1
- 11770 1
- 11781 1
- 11808 1
- 11824 1
- 11836 1
- 11847 1
- 11850 1
- 11883 1
- 11890 1
- 11916 1
- 11928 1
- 11943 1
- 11949 1
- 11956 1
- 11978 1
- 11992 1
- 12020 1
- 12029 1
- 12030 1
- 12067 1
- 12081 1
- 12119 1
- 12138 1
- 12168 1
- 12170 1
- 12180 1
- 12202 1
- 12223 1
- 12245 1
- 12258 1
- 12272 1
- 12286 1
- 12292 1
- 12304 1
- 12322 1
- 12342 1
- 12347 1
- 12363 1
- 12375 1
- 12381 1
- 12410 1
- 12426 1
- 12441 1
- 12457 1
- 12473 1
- 12478 1
- 12484 1
- 12511 1
- 12542 1
- 12588 1
- 12757 1
- 12791 1
- 12861 1
- 12930 1
- 13075 1
- 13196 1
- 13256 1
- 13365 1
- 13397 1
- 13484 1
- 14076 1
- 14154 1
- 14304 1
- 14726 1
- 14984 1
- 15206 1
- 15540 1
- 15687 1
- 17075 1
- 17272 1
- 17395 1
- 17620 1
- 17800 1
- 17865 1
- 17974 1
- 18014 1
- 18064 1
- 18101 1
- 18135 1
- 18182 1
- 18202 1
- 18255 1
- 18292 1
- 18321 1
- 18347 1
- 18361 1
- 18365 1
- 18374 1
- 18395 1
- 18407 1
- 18420 1
- 18434 1
- 18448 1
- 18454 1
- 18457 1
- 18469 1
- 18471 1
- 18480 1
- 18506 1
- 18507 1
- 18508 1
- 18514 1
- 18519 1
- 18524 1
- 18529 1
- 18531 1
- 18532 1
- 18533 1
- 18538 1
- 18564 1
- 18572 1
- 18592 1
- 18621 1
- 18633 1
- 18635 1
- 18654 1
- 18657 1
- 18726 1
- 18733 1
- 18734 1
- 18737 1
- 18741 1
- 18743 1
- 18745 1
- 18749 1
- 18751 1
- 18758 1
- 18763 1
- 18767 1
state 1
- Alabama 786
fips 1
- 1127 · 786 ✖
county 1
- Walker 786
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499638 | 2499638 | 2022-05-13 | Walker | Alabama | 1127 | 18767 | 447 |
2496380 | 2496380 | 2022-05-12 | Walker | Alabama | 1127 | 18763 | 447 |
2493122 | 2493122 | 2022-05-11 | Walker | Alabama | 1127 | 18758 | 446 |
2489864 | 2489864 | 2022-05-10 | Walker | Alabama | 1127 | 18751 | 446 |
2486607 | 2486607 | 2022-05-09 | Walker | Alabama | 1127 | 18749 | 446 |
2483349 | 2483349 | 2022-05-08 | Walker | Alabama | 1127 | 18748 | 446 |
2480091 | 2480091 | 2022-05-07 | Walker | Alabama | 1127 | 18748 | 446 |
2476833 | 2476833 | 2022-05-06 | Walker | Alabama | 1127 | 18748 | 446 |
2473575 | 2473575 | 2022-05-05 | Walker | Alabama | 1127 | 18745 | 445 |
2470318 | 2470318 | 2022-05-04 | Walker | Alabama | 1127 | 18743 | 445 |
2467062 | 2467062 | 2022-05-03 | Walker | Alabama | 1127 | 18741 | 444 |
2463807 | 2463807 | 2022-05-02 | Walker | Alabama | 1127 | 18737 | 443 |
2460551 | 2460551 | 2022-05-01 | Walker | Alabama | 1127 | 18736 | 443 |
2457295 | 2457295 | 2022-04-30 | Walker | Alabama | 1127 | 18736 | 443 |
2454039 | 2454039 | 2022-04-29 | Walker | Alabama | 1127 | 18736 | 443 |
2450783 | 2450783 | 2022-04-28 | Walker | Alabama | 1127 | 18734 | 443 |
2447527 | 2447527 | 2022-04-27 | Walker | Alabama | 1127 | 18733 | 443 |
2444271 | 2444271 | 2022-04-26 | Walker | Alabama | 1127 | 18732 | 443 |
2441015 | 2441015 | 2022-04-25 | Walker | Alabama | 1127 | 18732 | 443 |
2437759 | 2437759 | 2022-04-24 | Walker | Alabama | 1127 | 18729 | 443 |
2434503 | 2434503 | 2022-04-23 | Walker | Alabama | 1127 | 18729 | 443 |
2431247 | 2431247 | 2022-04-22 | Walker | Alabama | 1127 | 18729 | 443 |
2427991 | 2427991 | 2022-04-21 | Walker | Alabama | 1127 | 18727 | 443 |
2424735 | 2424735 | 2022-04-20 | Walker | Alabama | 1127 | 18727 | 443 |
2421479 | 2421479 | 2022-04-19 | Walker | Alabama | 1127 | 18726 | 443 |
2418223 | 2418223 | 2022-04-18 | Walker | Alabama | 1127 | 18658 | 443 |
2414967 | 2414967 | 2022-04-17 | Walker | Alabama | 1127 | 18658 | 443 |
2411711 | 2411711 | 2022-04-16 | Walker | Alabama | 1127 | 18658 | 443 |
2408455 | 2408455 | 2022-04-15 | Walker | Alabama | 1127 | 18658 | 443 |
2405199 | 2405199 | 2022-04-14 | Walker | Alabama | 1127 | 18657 | 442 |
2401944 | 2401944 | 2022-04-13 | Walker | Alabama | 1127 | 18656 | 440 |
2398689 | 2398689 | 2022-04-12 | Walker | Alabama | 1127 | 18656 | 440 |
2395434 | 2395434 | 2022-04-11 | Walker | Alabama | 1127 | 18654 | 438 |
2392178 | 2392178 | 2022-04-10 | Walker | Alabama | 1127 | 18652 | 438 |
2388922 | 2388922 | 2022-04-09 | Walker | Alabama | 1127 | 18652 | 438 |
2385667 | 2385667 | 2022-04-08 | Walker | Alabama | 1127 | 18652 | 438 |
2382412 | 2382412 | 2022-04-07 | Walker | Alabama | 1127 | 18652 | 438 |
2379157 | 2379157 | 2022-04-06 | Walker | Alabama | 1127 | 18635 | 438 |
2375903 | 2375903 | 2022-04-05 | Walker | Alabama | 1127 | 18633 | 438 |
2372651 | 2372651 | 2022-04-04 | Walker | Alabama | 1127 | 18621 | 438 |
2369398 | 2369398 | 2022-04-03 | Walker | Alabama | 1127 | 18598 | 438 |
2366145 | 2366145 | 2022-04-02 | Walker | Alabama | 1127 | 18598 | 438 |
2362892 | 2362892 | 2022-04-01 | Walker | Alabama | 1127 | 18598 | 438 |
2359638 | 2359638 | 2022-03-31 | Walker | Alabama | 1127 | 18592 | 438 |
2356384 | 2356384 | 2022-03-30 | Walker | Alabama | 1127 | 18572 | 438 |
2353131 | 2353131 | 2022-03-29 | Walker | Alabama | 1127 | 18564 | 438 |
2349879 | 2349879 | 2022-03-28 | Walker | Alabama | 1127 | 18538 | 437 |
2346626 | 2346626 | 2022-03-27 | Walker | Alabama | 1127 | 18536 | 436 |
2343373 | 2343373 | 2022-03-26 | Walker | Alabama | 1127 | 18536 | 436 |
2340120 | 2340120 | 2022-03-25 | Walker | Alabama | 1127 | 18536 | 436 |
2336867 | 2336867 | 2022-03-24 | Walker | Alabama | 1127 | 18533 | 433 |
2333613 | 2333613 | 2022-03-23 | Walker | Alabama | 1127 | 18532 | 433 |
2330359 | 2330359 | 2022-03-22 | Walker | Alabama | 1127 | 18531 | 433 |
2327107 | 2327107 | 2022-03-21 | Walker | Alabama | 1127 | 18529 | 432 |
2323854 | 2323854 | 2022-03-20 | Walker | Alabama | 1127 | 18525 | 429 |
2320600 | 2320600 | 2022-03-19 | Walker | Alabama | 1127 | 18525 | 429 |
2317346 | 2317346 | 2022-03-18 | Walker | Alabama | 1127 | 18525 | 429 |
2314093 | 2314093 | 2022-03-17 | Walker | Alabama | 1127 | 18524 | 429 |
2310840 | 2310840 | 2022-03-16 | Walker | Alabama | 1127 | 18521 | 428 |
2307587 | 2307587 | 2022-03-15 | Walker | Alabama | 1127 | 18521 | 428 |
2304336 | 2304336 | 2022-03-14 | Walker | Alabama | 1127 | 18519 | 426 |
2301084 | 2301084 | 2022-03-13 | Walker | Alabama | 1127 | 18515 | 426 |
2297832 | 2297832 | 2022-03-12 | Walker | Alabama | 1127 | 18515 | 426 |
2294580 | 2294580 | 2022-03-11 | Walker | Alabama | 1127 | 18515 | 426 |
2291328 | 2291328 | 2022-03-10 | Walker | Alabama | 1127 | 18514 | 426 |
2288076 | 2288076 | 2022-03-09 | Walker | Alabama | 1127 | 18508 | 424 |
2284824 | 2284824 | 2022-03-08 | Walker | Alabama | 1127 | 18507 | 424 |
2281572 | 2281572 | 2022-03-07 | Walker | Alabama | 1127 | 18506 | 422 |
2278319 | 2278319 | 2022-03-06 | Walker | Alabama | 1127 | 18484 | 419 |
2275066 | 2275066 | 2022-03-05 | Walker | Alabama | 1127 | 18484 | 419 |
2271813 | 2271813 | 2022-03-04 | Walker | Alabama | 1127 | 18484 | 419 |
2268561 | 2268561 | 2022-03-03 | Walker | Alabama | 1127 | 18480 | 419 |
2265308 | 2265308 | 2022-03-02 | Walker | Alabama | 1127 | 18471 | 415 |
2262058 | 2262058 | 2022-03-01 | Walker | Alabama | 1127 | 18469 | 413 |
2258807 | 2258807 | 2022-02-28 | Walker | Alabama | 1127 | 18457 | 413 |
2255556 | 2255556 | 2022-02-27 | Walker | Alabama | 1127 | 18454 | 413 |
2252305 | 2252305 | 2022-02-26 | Walker | Alabama | 1127 | 18448 | 413 |
2249054 | 2249054 | 2022-02-25 | Walker | Alabama | 1127 | 18434 | 413 |
2245803 | 2245803 | 2022-02-24 | Walker | Alabama | 1127 | 18420 | 412 |
2242552 | 2242552 | 2022-02-23 | Walker | Alabama | 1127 | 18407 | 411 |
2239301 | 2239301 | 2022-02-22 | Walker | Alabama | 1127 | 18395 | 410 |
2236050 | 2236050 | 2022-02-21 | Walker | Alabama | 1127 | 18374 | 410 |
2232799 | 2232799 | 2022-02-20 | Walker | Alabama | 1127 | 18365 | 410 |
2229548 | 2229548 | 2022-02-19 | Walker | Alabama | 1127 | 18361 | 410 |
2226297 | 2226297 | 2022-02-18 | Walker | Alabama | 1127 | 18347 | 408 |
2223046 | 2223046 | 2022-02-17 | Walker | Alabama | 1127 | 18321 | 406 |
2219795 | 2219795 | 2022-02-16 | Walker | Alabama | 1127 | 18292 | 405 |
2216545 | 2216545 | 2022-02-15 | Walker | Alabama | 1127 | 18255 | 403 |
2213294 | 2213294 | 2022-02-14 | Walker | Alabama | 1127 | 18202 | 401 |
2210041 | 2210041 | 2022-02-13 | Walker | Alabama | 1127 | 18182 | 401 |
2206788 | 2206788 | 2022-02-12 | Walker | Alabama | 1127 | 18135 | 401 |
2203535 | 2203535 | 2022-02-11 | Walker | Alabama | 1127 | 18101 | 401 |
2200281 | 2200281 | 2022-02-10 | Walker | Alabama | 1127 | 18064 | 401 |
2197027 | 2197027 | 2022-02-09 | Walker | Alabama | 1127 | 18014 | 400 |
2193772 | 2193772 | 2022-02-08 | Walker | Alabama | 1127 | 17974 | 399 |
2190519 | 2190519 | 2022-02-07 | Walker | Alabama | 1127 | 17865 | 399 |
2187266 | 2187266 | 2022-02-06 | Walker | Alabama | 1127 | 17819 | 399 |
2184013 | 2184013 | 2022-02-05 | Walker | Alabama | 1127 | 17819 | 399 |
2180761 | 2180761 | 2022-02-04 | Walker | Alabama | 1127 | 17800 | 399 |
2177510 | 2177510 | 2022-02-03 | Walker | Alabama | 1127 | 17677 | 398 |
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);