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
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 |
---|---|---|---|---|---|---|---|
4415 | 4415 | 2020-03-19 | Walker | Alabama | 1127 | 1 | 0 |
5185 | 5185 | 2020-03-20 | Walker | Alabama | 1127 | 1 | 0 |
6102 | 6102 | 2020-03-21 | Walker | Alabama | 1127 | 1 | 0 |
7136 | 7136 | 2020-03-22 | Walker | Alabama | 1127 | 1 | 0 |
8277 | 8277 | 2020-03-23 | Walker | Alabama | 1127 | 3 | 0 |
9505 | 9505 | 2020-03-24 | Walker | Alabama | 1127 | 5 | 0 |
10874 | 10874 | 2020-03-25 | Walker | Alabama | 1127 | 9 | 0 |
12413 | 12413 | 2020-03-26 | Walker | Alabama | 1127 | 18 | 0 |
14075 | 14075 | 2020-03-27 | Walker | Alabama | 1127 | 24 | 0 |
15854 | 15854 | 2020-03-28 | Walker | Alabama | 1127 | 28 | 0 |
17738 | 17738 | 2020-03-29 | Walker | Alabama | 1127 | 30 | 0 |
19711 | 19711 | 2020-03-30 | Walker | Alabama | 1127 | 31 | 0 |
21783 | 21783 | 2020-03-31 | Walker | Alabama | 1127 | 32 | 0 |
23939 | 23939 | 2020-04-01 | Walker | Alabama | 1127 | 32 | 0 |
26161 | 26161 | 2020-04-02 | Walker | Alabama | 1127 | 34 | 0 |
28458 | 28458 | 2020-04-03 | Walker | Alabama | 1127 | 49 | 0 |
30815 | 30815 | 2020-04-04 | Walker | Alabama | 1127 | 49 | 0 |
33219 | 33219 | 2020-04-05 | Walker | Alabama | 1127 | 49 | 0 |
35658 | 35658 | 2020-04-06 | Walker | Alabama | 1127 | 54 | 0 |
38146 | 38146 | 2020-04-07 | Walker | Alabama | 1127 | 64 | 0 |
40688 | 40688 | 2020-04-08 | Walker | Alabama | 1127 | 68 | 0 |
43262 | 43262 | 2020-04-09 | Walker | Alabama | 1127 | 72 | 0 |
45860 | 45860 | 2020-04-10 | Walker | Alabama | 1127 | 72 | 0 |
48489 | 48489 | 2020-04-11 | Walker | Alabama | 1127 | 78 | 0 |
51151 | 51151 | 2020-04-12 | Walker | Alabama | 1127 | 83 | 0 |
53829 | 53829 | 2020-04-13 | Walker | Alabama | 1127 | 84 | 0 |
56521 | 56521 | 2020-04-14 | Walker | Alabama | 1127 | 84 | 0 |
59229 | 59229 | 2020-04-15 | Walker | Alabama | 1127 | 85 | 0 |
61947 | 61947 | 2020-04-16 | Walker | Alabama | 1127 | 84 | 0 |
64680 | 64680 | 2020-04-17 | Walker | Alabama | 1127 | 83 | 0 |
67428 | 67428 | 2020-04-18 | Walker | Alabama | 1127 | 83 | 0 |
70190 | 70190 | 2020-04-19 | Walker | Alabama | 1127 | 85 | 0 |
72959 | 72959 | 2020-04-20 | Walker | Alabama | 1127 | 90 | 0 |
75735 | 75735 | 2020-04-21 | Walker | Alabama | 1127 | 91 | 0 |
78518 | 78518 | 2020-04-22 | Walker | Alabama | 1127 | 90 | 0 |
81311 | 81311 | 2020-04-23 | Walker | Alabama | 1127 | 89 | 0 |
84112 | 84112 | 2020-04-24 | Walker | Alabama | 1127 | 89 | 0 |
86920 | 86920 | 2020-04-25 | Walker | Alabama | 1127 | 91 | 0 |
89736 | 89736 | 2020-04-26 | Walker | Alabama | 1127 | 92 | 0 |
92554 | 92554 | 2020-04-27 | Walker | Alabama | 1127 | 93 | 0 |
95384 | 95384 | 2020-04-28 | Walker | Alabama | 1127 | 94 | 0 |
98229 | 98229 | 2020-04-29 | Walker | Alabama | 1127 | 93 | 0 |
101079 | 101079 | 2020-04-30 | Walker | Alabama | 1127 | 95 | 0 |
103934 | 103934 | 2020-05-01 | Walker | Alabama | 1127 | 97 | 0 |
106799 | 106799 | 2020-05-02 | Walker | Alabama | 1127 | 97 | 0 |
109668 | 109668 | 2020-05-03 | Walker | Alabama | 1127 | 99 | 0 |
112543 | 112543 | 2020-05-04 | Walker | Alabama | 1127 | 100 | 0 |
115426 | 115426 | 2020-05-05 | Walker | Alabama | 1127 | 100 | 0 |
118385 | 118385 | 2020-05-06 | Walker | Alabama | 1127 | 101 | 0 |
121351 | 121351 | 2020-05-07 | Walker | Alabama | 1127 | 103 | 0 |
124331 | 124331 | 2020-05-08 | Walker | Alabama | 1127 | 105 | 0 |
127316 | 127316 | 2020-05-09 | Walker | Alabama | 1127 | 106 | 0 |
130306 | 130306 | 2020-05-10 | Walker | Alabama | 1127 | 106 | 0 |
133296 | 133296 | 2020-05-11 | Walker | Alabama | 1127 | 107 | 0 |
136286 | 136286 | 2020-05-12 | Walker | Alabama | 1127 | 110 | 0 |
139277 | 139277 | 2020-05-13 | Walker | Alabama | 1127 | 111 | 0 |
142273 | 142273 | 2020-05-14 | Walker | Alabama | 1127 | 116 | 0 |
145272 | 145272 | 2020-05-15 | Walker | Alabama | 1127 | 119 | 0 |
148275 | 148275 | 2020-05-16 | Walker | Alabama | 1127 | 126 | 0 |
151284 | 151284 | 2020-05-17 | Walker | Alabama | 1127 | 126 | 0 |
154296 | 154296 | 2020-05-18 | Walker | Alabama | 1127 | 139 | 0 |
157312 | 157312 | 2020-05-19 | Walker | Alabama | 1127 | 148 | 1 |
160336 | 160336 | 2020-05-20 | Walker | Alabama | 1127 | 164 | 1 |
163364 | 163364 | 2020-05-21 | Walker | Alabama | 1127 | 172 | 1 |
166396 | 166396 | 2020-05-22 | Walker | Alabama | 1127 | 179 | 1 |
169432 | 169432 | 2020-05-23 | Walker | Alabama | 1127 | 191 | 1 |
172473 | 172473 | 2020-05-24 | Walker | Alabama | 1127 | 198 | 1 |
175516 | 175516 | 2020-05-25 | Walker | Alabama | 1127 | 239 | 1 |
178561 | 178561 | 2020-05-26 | Walker | Alabama | 1127 | 272 | 1 |
181605 | 181605 | 2020-05-27 | Walker | Alabama | 1127 | 282 | 1 |
184657 | 184657 | 2020-05-28 | Walker | Alabama | 1127 | 299 | 1 |
187714 | 187714 | 2020-05-29 | Walker | Alabama | 1127 | 330 | 2 |
190778 | 190778 | 2020-05-30 | Walker | Alabama | 1127 | 344 | 2 |
193844 | 193844 | 2020-05-31 | Walker | Alabama | 1127 | 354 | 2 |
196914 | 196914 | 2020-06-01 | Walker | Alabama | 1127 | 380 | 2 |
199987 | 199987 | 2020-06-02 | Walker | Alabama | 1127 | 388 | 2 |
203063 | 203063 | 2020-06-03 | Walker | Alabama | 1127 | 391 | 2 |
206142 | 206142 | 2020-06-04 | Walker | Alabama | 1127 | 396 | 2 |
209224 | 209224 | 2020-06-05 | Walker | Alabama | 1127 | 407 | 3 |
212309 | 212309 | 2020-06-06 | Walker | Alabama | 1127 | 443 | 3 |
215396 | 215396 | 2020-06-07 | Walker | Alabama | 1127 | 462 | 3 |
218486 | 218486 | 2020-06-08 | Walker | Alabama | 1127 | 470 | 5 |
221578 | 221578 | 2020-06-09 | Walker | Alabama | 1127 | 477 | 6 |
224674 | 224674 | 2020-06-10 | Walker | Alabama | 1127 | 491 | 6 |
227775 | 227775 | 2020-06-11 | Walker | Alabama | 1127 | 510 | 6 |
230879 | 230879 | 2020-06-12 | Walker | Alabama | 1127 | 533 | 6 |
233984 | 233984 | 2020-06-13 | Walker | Alabama | 1127 | 550 | 6 |
237091 | 237091 | 2020-06-14 | Walker | Alabama | 1127 | 578 | 6 |
240199 | 240199 | 2020-06-15 | Walker | Alabama | 1127 | 588 | 6 |
243310 | 243310 | 2020-06-16 | Walker | Alabama | 1127 | 621 | 6 |
246423 | 246423 | 2020-06-17 | Walker | Alabama | 1127 | 626 | 6 |
249535 | 249535 | 2020-06-18 | Walker | Alabama | 1127 | 652 | 8 |
252650 | 252650 | 2020-06-19 | Walker | Alabama | 1127 | 674 | 8 |
255769 | 255769 | 2020-06-20 | Walker | Alabama | 1127 | 679 | 8 |
258896 | 258896 | 2020-06-21 | Walker | Alabama | 1127 | 693 | 8 |
262023 | 262023 | 2020-06-22 | Walker | Alabama | 1127 | 705 | 8 |
265152 | 265152 | 2020-06-23 | Walker | Alabama | 1127 | 722 | 10 |
268281 | 268281 | 2020-06-24 | Walker | Alabama | 1127 | 741 | 12 |
271415 | 271415 | 2020-06-25 | Walker | Alabama | 1127 | 761 | 12 |
274555 | 274555 | 2020-06-26 | Walker | Alabama | 1127 | 774 | 13 |
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);