ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 17027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 607 ✖
- 3 7
- 5789 6
- 5787 5
- 7379 5
- 5798 4
- 5807 4
- 6580 4
- 7017 4
- 7976 4
- 8266 4
- 10171 4
- 11650 4
- 11764 4
- 5 3
- 8 3
- 186 3
- 193 3
- 224 3
- 5571 3
- 5603 3
- 5678 3
- 5689 3
- 5751 3
- 5766 3
- 5775 3
- 5777 3
- 5782 3
- 5793 3
- 5831 3
- 5858 3
- 5942 3
- 6031 3
- 6171 3
- 6271 3
- 6418 3
- 6674 3
- 6764 3
- 6837 3
- 6902 3
- 7095 3
- 7136 3
- 7168 3
- 7223 3
- 7278 3
- 7338 3
- 7518 3
- 7687 3
- 7822 3
- 9146 3
- 10879 3
- 11301 3
- 11515 3
- 11801 3
- 11821 3
- 11851 3
- 11864 3
- 11892 3
- 11952 3
- 11965 3
- 11969 3
- 11981 3
- 12000 3
- 12023 3
- 1 2
- 6 2
- 10 2
- 11 2
- 37 2
- 38 2
- 39 2
- 45 2
- 110 2
- 126 2
- 161 2
- 176 2
- 178 2
- 188 2
- 220 2
- 236 2
- 242 2
- 244 2
- 246 2
- 1877 2
- 4485 2
- 5581 2
- 5583 2
- 5661 2
- 5696 2
- 5721 2
- 5726 2
- 5732 2
- 5776 2
- 5778 2
- 5783 2
- 7264 2
- 11480 2
- 11966 2
- 11968 2
- 11971 2
- 12009 2
- 2 1
- 4 1
- 7 1
- 13 1
- 31 1
- 32 1
- 42 1
- 44 1
- 46 1
- 49 1
- 51 1
- 73 1
- 82 1
- 84 1
- 85 1
- 90 1
- 101 1
- 106 1
- 112 1
- 114 1
- 115 1
- 116 1
- 122 1
- 125 1
- 127 1
- 128 1
- 142 1
- 155 1
- 159 1
- 162 1
- 165 1
- 167 1
- 169 1
- 173 1
- 177 1
- 180 1
- 181 1
- 189 1
- 190 1
- 196 1
- 197 1
- 198 1
- 203 1
- 207 1
- 209 1
- 213 1
- 214 1
- 216 1
- 223 1
- 225 1
- 226 1
- 229 1
- 231 1
- 233 1
- 237 1
- 239 1
- 240 1
- 241 1
- 243 1
- 245 1
- 247 1
- 252 1
- 256 1
- 260 1
- 264 1
- 267 1
- 268 1
- 271 1
- 273 1
- 278 1
- 288 1
- 292 1
- 294 1
- 298 1
- 306 1
- 311 1
- 319 1
- 321 1
- 330 1
- 333 1
- 338 1
- 349 1
- 353 1
- 366 1
- 378 1
- 387 1
- 396 1
- 407 1
- 411 1
- 415 1
- 419 1
- 433 1
- 454 1
- 468 1
- 485 1
- 492 1
- 512 1
- 524 1
- 548 1
- 553 1
- 574 1
- 582 1
- 606 1
- 632 1
- 647 1
- 667 1
- 670 1
- 691 1
- 692 1
- 715 1
- 740 1
- 765 1
- 771 1
- 809 1
- 832 1
- 842 1
- 857 1
- 869 1
- 884 1
- 902 1
- 922 1
- 936 1
- 950 1
- 961 1
- 971 1
- 987 1
- 1004 1
- 1022 1
- 1051 1
- 1064 1
- 1071 1
- 1084 1
- 1088 1
- 1101 1
- 1129 1
- 1153 1
- 1169 1
- 1190 1
- 1203 1
- 1222 1
- 1239 1
- 1261 1
- 1279 1
- 1297 1
- 1309 1
- 1319 1
- 1338 1
- 1355 1
- 1377 1
- 1400 1
- 1411 1
- 1430 1
- 1438 1
- 1452 1
- 1480 1
- 1515 1
- 1541 1
- 1560 1
- 1587 1
- 1631 1
- 1663 1
- 1687 1
- 1709 1
- 1733 1
- 1755 1
- 1789 1
- 1811 1
- 1828 1
- 1856 1
- 1919 1
- 1936 1
- 1966 1
- 1988 1
- 2031 1
- 2100 1
- 2142 1
- 2164 1
- 2207 1
- 2294 1
- 2368 1
- 2392 1
- 2453 1
- 2512 1
- 2542 1
- 2579 1
- 2647 1
- 2727 1
- 2784 1
- 2875 1
- 2910 1
- 2943 1
- 2984 1
- 3035 1
- 3109 1
- 3235 1
- 3247 1
- 3279 1
- 3308 1
- 3337 1
- 3380 1
- 3453 1
- 3491 1
- 3557 1
- 3584 1
- 3617 1
- 3649 1
- 3684 1
- 3751 1
- 3796 1
- 3854 1
- 3878 1
- 3908 1
- 3926 1
- 3979 1
- 4040 1
- 4070 1
- 4117 1
- 4133 1
- 4156 1
- 4175 1
- 4209 1
- 4267 1
- 4307 1
- 4322 1
- 4328 1
- 4342 1
- 4352 1
- 4381 1
- 4420 1
- 4531 1
- 4547 1
- 4573 1
- 4600 1
- 4663 1
- 4695 1
- 4754 1
- 4777 1
- 4790 1
- 4813 1
- 4831 1
- 4885 1
- 4910 1
- 4953 1
- 4979 1
- 4989 1
- 5006 1
- 5032 1
- 5082 1
- 5107 1
- 5145 1
- 5162 1
- 5174 1
- 5188 1
- 5208 1
- 5247 1
- 5265 1
- 5289 1
- 5305 1
- 5318 1
- 5325 1
- 5349 1
- 5372 1
- 5407 1
- 5428 1
- 5449 1
- 5456 1
- 5462 1
- 5474 1
- 5500 1
- 5507 1
- 5515 1
- 5517 1
- 5520 1
- 5522 1
- 5525 1
- 5527 1
- 5528 1
- 5537 1
- 5540 1
- 5544 1
- 5548 1
- 5551 1
- 5556 1
- 5563 1
- 5566 1
- 5575 1
- 5578 1
- 5579 1
- 5582 1
- 5596 1
- 5598 1
- 5604 1
- 5608 1
- 5626 1
- 5633 1
- 5638 1
- 5642 1
- 5646 1
- 5647 1
- 5654 1
- 5657 1
- 5658 1
- 5663 1
- 5664 1
- 5667 1
- 5672 1
- 5674 1
- 5676 1
- 5677 1
- 5680 1
- 5682 1
- 5687 1
- 5691 1
- 5693 1
- 5698 1
- 5702 1
- 5703 1
- 5705 1
- 5708 1
- 5718 1
- 5722 1
- 5731 1
- 5735 1
- 5737 1
- 5739 1
- 5741 1
- 5744 1
- 5746 1
- 5748 1
- 5754 1
- 5755 1
- 5757 1
- 5760 1
- 5761 1
- 5763 1
- 5765 1
- 5768 1
- 5769 1
- 5770 1
- 5772 1
- 5774 1
- 5781 1
- 5784 1
- 5788 1
- 5790 1
- 5794 1
- 5795 1
- 5796 1
- 5797 1
- 5801 1
- 5803 1
- 5814 1
- 5816 1
- 5817 1
- 5821 1
- 5838 1
- 5842 1
- 5844 1
- 5852 1
- 5889 1
- 5906 1
- 5919 1
- 5928 1
- 5965 1
- 5983 1
- 6001 1
- 6021 1
- 6065 1
- 6096 1
- 6124 1
- 6146 1
- 6204 1
- 6224 1
- 6242 1
- 6253 1
- 6304 1
- 6323 1
- 6355 1
- 6375 1
- 6470 1
- 6500 1
- 6533 1
- 6545 1
- 6621 1
- 6641 1
- 6660 1
- 6702 1
- 6719 1
- 6735 1
- 6746 1
- 6783 1
- 6805 1
- 6814 1
- 6820 1
- 6849 1
- 6865 1
- 6873 1
- 6883 1
- 6936 1
- 6948 1
- 6958 1
- 6980 1
- 7036 1
- 7060 1
- 7080 1
- 7113 1
- 7115 1
- 7124 1
- 7129 1
- 7143 1
- 7149 1
- 7152 1
- 7158 1
- 7180 1
- 7185 1
- 7191 1
- 7210 1
- 7238 1
- 7255 1
- 7296 1
- 7316 1
- 7324 1
- 7328 1
- 7349 1
- 7368 1
- 7414 1
- 7451 1
- 7472 1
- 7485 1
- 7560 1
- 7596 1
- 7639 1
- 7662 1
- 7726 1
- 7756 1
- 7780 1
- 7794 1
- 7872 1
- 7913 1
- 7937 1
- 8048 1
- 8115 1
- 8155 1
- 8453 1
- 8680 1
- 8840 1
- 9021 1
- 9492 1
- 9692 1
- 9817 1
- 10035 1
- 10480 1
- 10639 1
- 10770 1
- 11046 1
- 11130 1
- 11194 1
- 11247 1
- 11387 1
- 11450 1
- 11569 1
- 11600 1
- 11623 1
- 11696 1
- 11735 1
- 11738 1
- 11751 1
- 11783 1
- 11790 1
- 11799 1
- 11810 1
- 11814 1
- 11816 1
- 11817 1
- 11834 1
- 11840 1
- 11844 1
- 11849 1
- 11856 1
- 11858 1
- 11862 1
- 11863 1
- 11866 1
- 11868 1
- 11883 1
- 11887 1
- 11901 1
- 11904 1
- 11941 1
- 11947 1
- 11957 1
- 11960 1
- 11961 1
- 11964 1
- 11974 1
- 11978 1
- 11988 1
- 11992 1
- 11995 1
- 11998 1
- 12007 1
- 12010 1
- 12028 1
- 12037 1
- 12043 1
- 12053 1
- 12066 1
state 1
- Illinois 790
fips 1
- 17027 · 790 ✖
county 1
- Clinton 790
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500190 | 2500190 | 2022-05-13 | Clinton | Illinois | 17027 | 12066 | 122 |
2496932 | 2496932 | 2022-05-12 | Clinton | Illinois | 17027 | 12053 | 122 |
2493674 | 2493674 | 2022-05-11 | Clinton | Illinois | 17027 | 12043 | 122 |
2490416 | 2490416 | 2022-05-10 | Clinton | Illinois | 17027 | 12037 | 122 |
2487159 | 2487159 | 2022-05-09 | Clinton | Illinois | 17027 | 12028 | 122 |
2483901 | 2483901 | 2022-05-08 | Clinton | Illinois | 17027 | 12023 | 122 |
2480643 | 2480643 | 2022-05-07 | Clinton | Illinois | 17027 | 12023 | 122 |
2477385 | 2477385 | 2022-05-06 | Clinton | Illinois | 17027 | 12023 | 122 |
2474127 | 2474127 | 2022-05-05 | Clinton | Illinois | 17027 | 12010 | 122 |
2470870 | 2470870 | 2022-05-04 | Clinton | Illinois | 17027 | 12009 | 122 |
2467614 | 2467614 | 2022-05-03 | Clinton | Illinois | 17027 | 12009 | 122 |
2464359 | 2464359 | 2022-05-02 | Clinton | Illinois | 17027 | 12007 | 122 |
2461103 | 2461103 | 2022-05-01 | Clinton | Illinois | 17027 | 12000 | 122 |
2457847 | 2457847 | 2022-04-30 | Clinton | Illinois | 17027 | 12000 | 122 |
2454591 | 2454591 | 2022-04-29 | Clinton | Illinois | 17027 | 12000 | 122 |
2451335 | 2451335 | 2022-04-28 | Clinton | Illinois | 17027 | 11998 | 122 |
2448079 | 2448079 | 2022-04-27 | Clinton | Illinois | 17027 | 11995 | 122 |
2444823 | 2444823 | 2022-04-26 | Clinton | Illinois | 17027 | 11992 | 122 |
2441567 | 2441567 | 2022-04-25 | Clinton | Illinois | 17027 | 11988 | 122 |
2438311 | 2438311 | 2022-04-24 | Clinton | Illinois | 17027 | 11981 | 122 |
2435055 | 2435055 | 2022-04-23 | Clinton | Illinois | 17027 | 11981 | 122 |
2431799 | 2431799 | 2022-04-22 | Clinton | Illinois | 17027 | 11981 | 122 |
2428543 | 2428543 | 2022-04-21 | Clinton | Illinois | 17027 | 11978 | 122 |
2425287 | 2425287 | 2022-04-20 | Clinton | Illinois | 17027 | 11974 | 122 |
2422031 | 2422031 | 2022-04-19 | Clinton | Illinois | 17027 | 11971 | 122 |
2418775 | 2418775 | 2022-04-18 | Clinton | Illinois | 17027 | 11971 | 122 |
2415519 | 2415519 | 2022-04-17 | Clinton | Illinois | 17027 | 11969 | 122 |
2412263 | 2412263 | 2022-04-16 | Clinton | Illinois | 17027 | 11969 | 122 |
2409007 | 2409007 | 2022-04-15 | Clinton | Illinois | 17027 | 11969 | 122 |
2405751 | 2405751 | 2022-04-14 | Clinton | Illinois | 17027 | 11968 | 122 |
2402496 | 2402496 | 2022-04-13 | Clinton | Illinois | 17027 | 11968 | 122 |
2399241 | 2399241 | 2022-04-12 | Clinton | Illinois | 17027 | 11966 | 122 |
2395986 | 2395986 | 2022-04-11 | Clinton | Illinois | 17027 | 11966 | 122 |
2392730 | 2392730 | 2022-04-10 | Clinton | Illinois | 17027 | 11965 | 122 |
2389474 | 2389474 | 2022-04-09 | Clinton | Illinois | 17027 | 11965 | 122 |
2386219 | 2386219 | 2022-04-08 | Clinton | Illinois | 17027 | 11965 | 122 |
2382964 | 2382964 | 2022-04-07 | Clinton | Illinois | 17027 | 11964 | 122 |
2379709 | 2379709 | 2022-04-06 | Clinton | Illinois | 17027 | 11961 | 122 |
2376455 | 2376455 | 2022-04-05 | Clinton | Illinois | 17027 | 11960 | 122 |
2373203 | 2373203 | 2022-04-04 | Clinton | Illinois | 17027 | 11957 | 122 |
2369950 | 2369950 | 2022-04-03 | Clinton | Illinois | 17027 | 11952 | 122 |
2366697 | 2366697 | 2022-04-02 | Clinton | Illinois | 17027 | 11952 | 122 |
2363444 | 2363444 | 2022-04-01 | Clinton | Illinois | 17027 | 11952 | 122 |
2360190 | 2360190 | 2022-03-31 | Clinton | Illinois | 17027 | 11947 | 122 |
2356936 | 2356936 | 2022-03-30 | Clinton | Illinois | 17027 | 11941 | 122 |
2353683 | 2353683 | 2022-03-29 | Clinton | Illinois | 17027 | 11904 | 122 |
2350431 | 2350431 | 2022-03-28 | Clinton | Illinois | 17027 | 11901 | 122 |
2347178 | 2347178 | 2022-03-27 | Clinton | Illinois | 17027 | 11892 | 122 |
2343925 | 2343925 | 2022-03-26 | Clinton | Illinois | 17027 | 11892 | 122 |
2340672 | 2340672 | 2022-03-25 | Clinton | Illinois | 17027 | 11892 | 122 |
2337419 | 2337419 | 2022-03-24 | Clinton | Illinois | 17027 | 11887 | 122 |
2334165 | 2334165 | 2022-03-23 | Clinton | Illinois | 17027 | 11883 | 122 |
2330911 | 2330911 | 2022-03-22 | Clinton | Illinois | 17027 | 11868 | 122 |
2327659 | 2327659 | 2022-03-21 | Clinton | Illinois | 17027 | 11866 | 122 |
2324406 | 2324406 | 2022-03-20 | Clinton | Illinois | 17027 | 11864 | 122 |
2321152 | 2321152 | 2022-03-19 | Clinton | Illinois | 17027 | 11864 | 122 |
2317898 | 2317898 | 2022-03-18 | Clinton | Illinois | 17027 | 11864 | 122 |
2314645 | 2314645 | 2022-03-17 | Clinton | Illinois | 17027 | 11863 | 122 |
2311392 | 2311392 | 2022-03-16 | Clinton | Illinois | 17027 | 11862 | 122 |
2308139 | 2308139 | 2022-03-15 | Clinton | Illinois | 17027 | 11858 | 122 |
2304888 | 2304888 | 2022-03-14 | Clinton | Illinois | 17027 | 11856 | 122 |
2301636 | 2301636 | 2022-03-13 | Clinton | Illinois | 17027 | 11851 | 122 |
2298384 | 2298384 | 2022-03-12 | Clinton | Illinois | 17027 | 11851 | 122 |
2295132 | 2295132 | 2022-03-11 | Clinton | Illinois | 17027 | 11851 | 122 |
2291880 | 2291880 | 2022-03-10 | Clinton | Illinois | 17027 | 11849 | 122 |
2288628 | 2288628 | 2022-03-09 | Clinton | Illinois | 17027 | 11844 | 122 |
2285377 | 2285377 | 2022-03-08 | Clinton | Illinois | 17027 | 11840 | 122 |
2282125 | 2282125 | 2022-03-07 | Clinton | Illinois | 17027 | 11834 | 122 |
2278872 | 2278872 | 2022-03-06 | Clinton | Illinois | 17027 | 11821 | 122 |
2275619 | 2275619 | 2022-03-05 | Clinton | Illinois | 17027 | 11821 | 122 |
2272366 | 2272366 | 2022-03-04 | Clinton | Illinois | 17027 | 11821 | 122 |
2269114 | 2269114 | 2022-03-03 | Clinton | Illinois | 17027 | 11817 | 122 |
2265861 | 2265861 | 2022-03-02 | Clinton | Illinois | 17027 | 11816 | 122 |
2262610 | 2262610 | 2022-03-01 | Clinton | Illinois | 17027 | 11814 | 122 |
2259359 | 2259359 | 2022-02-28 | Clinton | Illinois | 17027 | 11810 | 122 |
2256108 | 2256108 | 2022-02-27 | Clinton | Illinois | 17027 | 11801 | 122 |
2252857 | 2252857 | 2022-02-26 | Clinton | Illinois | 17027 | 11801 | 122 |
2249606 | 2249606 | 2022-02-25 | Clinton | Illinois | 17027 | 11801 | 122 |
2246355 | 2246355 | 2022-02-24 | Clinton | Illinois | 17027 | 11799 | 122 |
2243104 | 2243104 | 2022-02-23 | Clinton | Illinois | 17027 | 11790 | 122 |
2239853 | 2239853 | 2022-02-22 | Clinton | Illinois | 17027 | 11783 | 122 |
2236602 | 2236602 | 2022-02-21 | Clinton | Illinois | 17027 | 11764 | 122 |
2233351 | 2233351 | 2022-02-20 | Clinton | Illinois | 17027 | 11764 | 122 |
2230100 | 2230100 | 2022-02-19 | Clinton | Illinois | 17027 | 11764 | 122 |
2226849 | 2226849 | 2022-02-18 | Clinton | Illinois | 17027 | 11764 | 122 |
2223598 | 2223598 | 2022-02-17 | Clinton | Illinois | 17027 | 11751 | 122 |
2220347 | 2220347 | 2022-02-16 | Clinton | Illinois | 17027 | 11738 | 122 |
2217096 | 2217096 | 2022-02-15 | Clinton | Illinois | 17027 | 11735 | 122 |
2213845 | 2213845 | 2022-02-14 | Clinton | Illinois | 17027 | 11696 | 122 |
2210593 | 2210593 | 2022-02-13 | Clinton | Illinois | 17027 | 11650 | 121 |
2207340 | 2207340 | 2022-02-12 | Clinton | Illinois | 17027 | 11650 | 121 |
2204087 | 2204087 | 2022-02-11 | Clinton | Illinois | 17027 | 11650 | 121 |
2200834 | 2200834 | 2022-02-10 | Clinton | Illinois | 17027 | 11650 | 121 |
2197580 | 2197580 | 2022-02-09 | Clinton | Illinois | 17027 | 11623 | 121 |
2194326 | 2194326 | 2022-02-08 | Clinton | Illinois | 17027 | 11600 | 120 |
2191072 | 2191072 | 2022-02-07 | Clinton | Illinois | 17027 | 11569 | 120 |
2187819 | 2187819 | 2022-02-06 | Clinton | Illinois | 17027 | 11515 | 119 |
2184566 | 2184566 | 2022-02-05 | Clinton | Illinois | 17027 | 11515 | 119 |
2181314 | 2181314 | 2022-02-04 | Clinton | Illinois | 17027 | 11515 | 119 |
2178063 | 2178063 | 2022-02-03 | Clinton | Illinois | 17027 | 11480 | 119 |
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);