ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 648 ✖
- 1 5
- 15884 5
- 3 4
- 6 4
- 12802 4
- 13858 4
- 14836 4
- 18215 4
- 19108 4
- 23961 4
- 28063 4
- 28390 4
- 121 3
- 140 3
- 12779 3
- 12793 3
- 12795 3
- 12834 3
- 12860 3
- 12904 3
- 12987 3
- 13095 3
- 13256 3
- 13418 3
- 13611 3
- 14088 3
- 14349 3
- 14539 3
- 14685 3
- 14954 3
- 15078 3
- 15173 3
- 15300 3
- 15488 3
- 15724 3
- 16385 3
- 17055 3
- 17673 3
- 21263 3
- 25857 3
- 27109 3
- 27740 3
- 28533 3
- 28634 3
- 28709 3
- 28777 3
- 28819 3
- 28864 3
- 28931 3
- 29012 3
- 29098 3
- 29216 3
- 29421 3
- 4 2
- 17 2
- 27 2
- 49 2
- 105 2
- 130 2
- 153 2
- 160 2
- 177 2
- 183 2
- 188 2
- 190 2
- 205 2
- 2652 2
- 8363 2
- 12737 2
- 12791 2
- 15404 2
- 27644 2
- 2 1
- 5 1
- 7 1
- 8 1
- 11 1
- 15 1
- 18 1
- 19 1
- 20 1
- 21 1
- 23 1
- 24 1
- 25 1
- 28 1
- 30 1
- 33 1
- 38 1
- 39 1
- 42 1
- 43 1
- 44 1
- 46 1
- 53 1
- 54 1
- 65 1
- 67 1
- 69 1
- 70 1
- 84 1
- 91 1
- 93 1
- 102 1
- 106 1
- 111 1
- 113 1
- 117 1
- 120 1
- 129 1
- 134 1
- 139 1
- 141 1
- 147 1
- 150 1
- 154 1
- 157 1
- 159 1
- 164 1
- 166 1
- 168 1
- 172 1
- 175 1
- 178 1
- 181 1
- 189 1
- 191 1
- 195 1
- 199 1
- 201 1
- 208 1
- 216 1
- 219 1
- 220 1
- 224 1
- 225 1
- 226 1
- 228 1
- 233 1
- 237 1
- 239 1
- 246 1
- 254 1
- 259 1
- 270 1
- 280 1
- 286 1
- 298 1
- 306 1
- 313 1
- 328 1
- 343 1
- 350 1
- 362 1
- 379 1
- 388 1
- 409 1
- 414 1
- 419 1
- 428 1
- 442 1
- 463 1
- 480 1
- 497 1
- 515 1
- 560 1
- 577 1
- 590 1
- 666 1
- 684 1
- 739 1
- 766 1
- 783 1
- 801 1
- 825 1
- 878 1
- 910 1
- 932 1
- 953 1
- 960 1
- 992 1
- 1008 1
- 1031 1
- 1063 1
- 1085 1
- 1093 1
- 1115 1
- 1128 1
- 1148 1
- 1180 1
- 1203 1
- 1219 1
- 1237 1
- 1256 1
- 1273 1
- 1291 1
- 1302 1
- 1357 1
- 1376 1
- 1399 1
- 1406 1
- 1413 1
- 1419 1
- 1429 1
- 1457 1
- 1475 1
- 1496 1
- 1508 1
- 1518 1
- 1530 1
- 1546 1
- 1568 1
- 1590 1
- 1608 1
- 1616 1
- 1630 1
- 1640 1
- 1658 1
- 1682 1
- 1701 1
- 1712 1
- 1725 1
- 1742 1
- 1758 1
- 1768 1
- 1794 1
- 1818 1
- 1831 1
- 1855 1
- 1861 1
- 1873 1
- 1910 1
- 1926 1
- 1947 1
- 1974 1
- 1995 1
- 2004 1
- 2041 1
- 2069 1
- 2100 1
- 2128 1
- 2157 1
- 2184 1
- 2207 1
- 2235 1
- 2281 1
- 2320 1
- 2378 1
- 2408 1
- 2426 1
- 2473 1
- 2554 1
- 2584 1
- 2776 1
- 2842 1
- 2937 1
- 2997 1
- 3136 1
- 3356 1
- 3490 1
- 3606 1
- 3763 1
- 3891 1
- 4046 1
- 4174 1
- 4386 1
- 4559 1
- 4658 1
- 4775 1
- 4885 1
- 5059 1
- 5187 1
- 5331 1
- 5450 1
- 5548 1
- 5608 1
- 5687 1
- 5808 1
- 5907 1
- 5975 1
- 6041 1
- 6108 1
- 6161 1
- 6274 1
- 6358 1
- 6471 1
- 6587 1
- 6728 1
- 6797 1
- 6885 1
- 6971 1
- 7041 1
- 7157 1
- 7274 1
- 7364 1
- 7430 1
- 7504 1
- 7542 1
- 7629 1
- 7679 1
- 7727 1
- 7762 1
- 7810 1
- 7828 1
- 7868 1
- 7951 1
- 8008 1
- 8059 1
- 8108 1
- 8135 1
- 8160 1
- 8199 1
- 8292 1
- 8471 1
- 8512 1
- 8536 1
- 8566 1
- 8660 1
- 8763 1
- 8848 1
- 8906 1
- 8955 1
- 8991 1
- 9031 1
- 9113 1
- 9212 1
- 9271 1
- 9328 1
- 9392 1
- 9427 1
- 9478 1
- 9537 1
- 9595 1
- 9704 1
- 9757 1
- 9791 1
- 9807 1
- 9834 1
- 9901 1
- 9971 1
- 10016 1
- 10056 1
- 10088 1
- 10104 1
- 10128 1
- 10148 1
- 10191 1
- 10234 1
- 10264 1
- 10286 1
- 10310 1
- 10325 1
- 10353 1
- 10390 1
- 10418 1
- 10451 1
- 10478 1
- 10491 1
- 10509 1
- 10535 1
- 10562 1
- 10582 1
- 10601 1
- 10648 1
- 10665 1
- 10681 1
- 10706 1
- 10746 1
- 10764 1
- 10786 1
- 10798 1
- 10810 1
- 10823 1
- 10845 1
- 10861 1
- 10884 1
- 10910 1
- 10924 1
- 10928 1
- 10943 1
- 10967 1
- 10990 1
- 11000 1
- 11010 1
- 11019 1
- 11026 1
- 11044 1
- 11068 1
- 11092 1
- 11110 1
- 11122 1
- 11135 1
- 11140 1
- 11154 1
- 11164 1
- 11178 1
- 11198 1
- 11210 1
- 11232 1
- 11242 1
- 11263 1
- 11283 1
- 11318 1
- 11347 1
- 11364 1
- 11385 1
- 11397 1
- 11407 1
- 11434 1
- 11456 1
- 11485 1
- 11518 1
- 11537 1
- 11553 1
- 11594 1
- 11634 1
- 11664 1
- 11706 1
- 11739 1
- 11755 1
- 11786 1
- 11800 1
- 11835 1
- 11878 1
- 11917 1
- 11963 1
- 11988 1
- 12011 1
- 12049 1
- 12094 1
- 12129 1
- 12175 1
- 12212 1
- 12236 1
- 12257 1
- 12286 1
- 12327 1
- 12369 1
- 12405 1
- 12430 1
- 12459 1
- 12469 1
- 12488 1
- 12516 1
- 12536 1
- 12553 1
- 12573 1
- 12585 1
- 12589 1
- 12598 1
- 12616 1
- 12633 1
- 12653 1
- 12666 1
- 12667 1
- 12670 1
- 12679 1
- 12690 1
- 12694 1
- 12702 1
- 12706 1
- 12708 1
- 12710 1
- 12713 1
- 12718 1
- 12724 1
- 12734 1
- 12738 1
- 12741 1
- 12747 1
- 12752 1
- 12761 1
- 12763 1
- 12766 1
- 12767 1
- 12768 1
- 12772 1
- 12777 1
- 12789 1
- 12790 1
- 12801 1
- 12822 1
- 12824 1
- 12829 1
- 12844 1
- 12848 1
- 12855 1
- 12859 1
- 12872 1
- 12874 1
- 12879 1
- 12894 1
- 12938 1
- 12954 1
- 12968 1
- 12975 1
- 13019 1
- 13037 1
- 13049 1
- 13066 1
- 13143 1
- 13172 1
- 13206 1
- 13235 1
- 13300 1
- 13327 1
- 13349 1
- 13378 1
- 13496 1
- 13516 1
- 13543 1
- 13578 1
- 13690 1
- 13719 1
- 13774 1
- 13812 1
- 13959 1
- 13986 1
- 14029 1
- 14172 1
- 14209 1
- 14258 1
- 14310 1
- 14419 1
- 14454 1
- 14496 1
- 14520 1
- 14590 1
- 14609 1
- 14638 1
- 14660 1
- 14744 1
- 14765 1
- 14790 1
- 14817 1
- 14894 1
- 14921 1
- 14943 1
- 14983 1
- 15011 1
- 15030 1
- 15052 1
- 15106 1
- 15119 1
- 15144 1
- 15159 1
- 15220 1
- 15251 1
- 15258 1
- 15289 1
- 15348 1
- 15370 1
- 15566 1
- 15585 1
- 15625 1
- 15668 1
- 15809 1
- 15836 1
- 16028 1
- 16093 1
- 16155 1
- 16311 1
- 16639 1
- 16742 1
- 16859 1
- 16945 1
- 17248 1
- 17346 1
- 17462 1
- 17553 1
- 17916 1
- 18001 1
- 18099 1
- 18523 1
- 18687 1
- 18857 1
- 19713 1
- 20054 1
- 20374 1
- 20680 1
- 22172 1
- 22772 1
- 23234 1
- 23569 1
- 24935 1
- 25227 1
- 25469 1
- 26316 1
- 26516 1
- 26693 1
- 26917 1
- 27376 1
- 27507 1
- 27880 1
- 27950 1
- 27986 1
- 28220 1
- 28258 1
- 28319 1
- 28352 1
- 28460 1
- 28482 1
- 28509 1
- 28569 1
- 28581 1
- 28605 1
- 28622 1
- 28669 1
- 28678 1
- 28689 1
- 28701 1
- 28729 1
- 28743 1
- 28755 1
- 28764 1
- 28797 1
- 28804 1
- 28809 1
- 28817 1
- 28829 1
- 28838 1
- 28844 1
- 28853 1
- 28877 1
- 28888 1
- 28902 1
- 28908 1
- 28969 1
- 28977 1
- 28985 1
- 28998 1
- 29033 1
- 29042 1
- 29064 1
- 29083 1
- 29131 1
- 29146 1
- 29159 1
- 29178 1
- 29264 1
- 29287 1
- 29334 1
- 29364 1
- 29528 1
- 29579 1
- 29627 1
- 29656 1
- 29734 1
state 1
- Illinois 787
fips 1
- 17099 · 787 ✖
county 1
- LaSalle 787
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500225 | 2500225 | 2022-05-13 | LaSalle | Illinois | 17099 | 29734 | 442 |
2496967 | 2496967 | 2022-05-12 | LaSalle | Illinois | 17099 | 29656 | 441 |
2493709 | 2493709 | 2022-05-11 | LaSalle | Illinois | 17099 | 29627 | 441 |
2490451 | 2490451 | 2022-05-10 | LaSalle | Illinois | 17099 | 29579 | 441 |
2487194 | 2487194 | 2022-05-09 | LaSalle | Illinois | 17099 | 29528 | 441 |
2483936 | 2483936 | 2022-05-08 | LaSalle | Illinois | 17099 | 29421 | 440 |
2480678 | 2480678 | 2022-05-07 | LaSalle | Illinois | 17099 | 29421 | 440 |
2477420 | 2477420 | 2022-05-06 | LaSalle | Illinois | 17099 | 29421 | 440 |
2474162 | 2474162 | 2022-05-05 | LaSalle | Illinois | 17099 | 29364 | 440 |
2470905 | 2470905 | 2022-05-04 | LaSalle | Illinois | 17099 | 29334 | 440 |
2467649 | 2467649 | 2022-05-03 | LaSalle | Illinois | 17099 | 29287 | 440 |
2464394 | 2464394 | 2022-05-02 | LaSalle | Illinois | 17099 | 29264 | 440 |
2461138 | 2461138 | 2022-05-01 | LaSalle | Illinois | 17099 | 29216 | 440 |
2457882 | 2457882 | 2022-04-30 | LaSalle | Illinois | 17099 | 29216 | 440 |
2454626 | 2454626 | 2022-04-29 | LaSalle | Illinois | 17099 | 29216 | 440 |
2451370 | 2451370 | 2022-04-28 | LaSalle | Illinois | 17099 | 29178 | 440 |
2448114 | 2448114 | 2022-04-27 | LaSalle | Illinois | 17099 | 29159 | 439 |
2444858 | 2444858 | 2022-04-26 | LaSalle | Illinois | 17099 | 29146 | 439 |
2441602 | 2441602 | 2022-04-25 | LaSalle | Illinois | 17099 | 29131 | 439 |
2438346 | 2438346 | 2022-04-24 | LaSalle | Illinois | 17099 | 29098 | 439 |
2435090 | 2435090 | 2022-04-23 | LaSalle | Illinois | 17099 | 29098 | 439 |
2431834 | 2431834 | 2022-04-22 | LaSalle | Illinois | 17099 | 29098 | 439 |
2428578 | 2428578 | 2022-04-21 | LaSalle | Illinois | 17099 | 29083 | 439 |
2425322 | 2425322 | 2022-04-20 | LaSalle | Illinois | 17099 | 29064 | 439 |
2422066 | 2422066 | 2022-04-19 | LaSalle | Illinois | 17099 | 29042 | 439 |
2418810 | 2418810 | 2022-04-18 | LaSalle | Illinois | 17099 | 29033 | 439 |
2415554 | 2415554 | 2022-04-17 | LaSalle | Illinois | 17099 | 29012 | 439 |
2412298 | 2412298 | 2022-04-16 | LaSalle | Illinois | 17099 | 29012 | 439 |
2409042 | 2409042 | 2022-04-15 | LaSalle | Illinois | 17099 | 29012 | 439 |
2405786 | 2405786 | 2022-04-14 | LaSalle | Illinois | 17099 | 28998 | 439 |
2402531 | 2402531 | 2022-04-13 | LaSalle | Illinois | 17099 | 28985 | 439 |
2399276 | 2399276 | 2022-04-12 | LaSalle | Illinois | 17099 | 28977 | 439 |
2396021 | 2396021 | 2022-04-11 | LaSalle | Illinois | 17099 | 28969 | 438 |
2392765 | 2392765 | 2022-04-10 | LaSalle | Illinois | 17099 | 28931 | 438 |
2389509 | 2389509 | 2022-04-09 | LaSalle | Illinois | 17099 | 28931 | 438 |
2386254 | 2386254 | 2022-04-08 | LaSalle | Illinois | 17099 | 28931 | 438 |
2382999 | 2382999 | 2022-04-07 | LaSalle | Illinois | 17099 | 28908 | 437 |
2379744 | 2379744 | 2022-04-06 | LaSalle | Illinois | 17099 | 28902 | 437 |
2376490 | 2376490 | 2022-04-05 | LaSalle | Illinois | 17099 | 28888 | 437 |
2373238 | 2373238 | 2022-04-04 | LaSalle | Illinois | 17099 | 28877 | 436 |
2369985 | 2369985 | 2022-04-03 | LaSalle | Illinois | 17099 | 28864 | 436 |
2366732 | 2366732 | 2022-04-02 | LaSalle | Illinois | 17099 | 28864 | 436 |
2363479 | 2363479 | 2022-04-01 | LaSalle | Illinois | 17099 | 28864 | 436 |
2360225 | 2360225 | 2022-03-31 | LaSalle | Illinois | 17099 | 28853 | 436 |
2356971 | 2356971 | 2022-03-30 | LaSalle | Illinois | 17099 | 28844 | 436 |
2353718 | 2353718 | 2022-03-29 | LaSalle | Illinois | 17099 | 28838 | 436 |
2350466 | 2350466 | 2022-03-28 | LaSalle | Illinois | 17099 | 28829 | 436 |
2347213 | 2347213 | 2022-03-27 | LaSalle | Illinois | 17099 | 28819 | 436 |
2343960 | 2343960 | 2022-03-26 | LaSalle | Illinois | 17099 | 28819 | 436 |
2340707 | 2340707 | 2022-03-25 | LaSalle | Illinois | 17099 | 28819 | 436 |
2337454 | 2337454 | 2022-03-24 | LaSalle | Illinois | 17099 | 28817 | 436 |
2334200 | 2334200 | 2022-03-23 | LaSalle | Illinois | 17099 | 28809 | 436 |
2330946 | 2330946 | 2022-03-22 | LaSalle | Illinois | 17099 | 28804 | 436 |
2327694 | 2327694 | 2022-03-21 | LaSalle | Illinois | 17099 | 28797 | 435 |
2324441 | 2324441 | 2022-03-20 | LaSalle | Illinois | 17099 | 28777 | 435 |
2321187 | 2321187 | 2022-03-19 | LaSalle | Illinois | 17099 | 28777 | 435 |
2317933 | 2317933 | 2022-03-18 | LaSalle | Illinois | 17099 | 28777 | 435 |
2314680 | 2314680 | 2022-03-17 | LaSalle | Illinois | 17099 | 28764 | 434 |
2311427 | 2311427 | 2022-03-16 | LaSalle | Illinois | 17099 | 28755 | 434 |
2308174 | 2308174 | 2022-03-15 | LaSalle | Illinois | 17099 | 28743 | 434 |
2304923 | 2304923 | 2022-03-14 | LaSalle | Illinois | 17099 | 28729 | 434 |
2301671 | 2301671 | 2022-03-13 | LaSalle | Illinois | 17099 | 28709 | 434 |
2298419 | 2298419 | 2022-03-12 | LaSalle | Illinois | 17099 | 28709 | 434 |
2295167 | 2295167 | 2022-03-11 | LaSalle | Illinois | 17099 | 28709 | 434 |
2291915 | 2291915 | 2022-03-10 | LaSalle | Illinois | 17099 | 28701 | 433 |
2288663 | 2288663 | 2022-03-09 | LaSalle | Illinois | 17099 | 28689 | 432 |
2285412 | 2285412 | 2022-03-08 | LaSalle | Illinois | 17099 | 28678 | 432 |
2282160 | 2282160 | 2022-03-07 | LaSalle | Illinois | 17099 | 28669 | 432 |
2278907 | 2278907 | 2022-03-06 | LaSalle | Illinois | 17099 | 28634 | 432 |
2275654 | 2275654 | 2022-03-05 | LaSalle | Illinois | 17099 | 28634 | 432 |
2272401 | 2272401 | 2022-03-04 | LaSalle | Illinois | 17099 | 28634 | 432 |
2269149 | 2269149 | 2022-03-03 | LaSalle | Illinois | 17099 | 28622 | 431 |
2265896 | 2265896 | 2022-03-02 | LaSalle | Illinois | 17099 | 28605 | 431 |
2262645 | 2262645 | 2022-03-01 | LaSalle | Illinois | 17099 | 28581 | 431 |
2259394 | 2259394 | 2022-02-28 | LaSalle | Illinois | 17099 | 28569 | 430 |
2256143 | 2256143 | 2022-02-27 | LaSalle | Illinois | 17099 | 28533 | 430 |
2252892 | 2252892 | 2022-02-26 | LaSalle | Illinois | 17099 | 28533 | 430 |
2249641 | 2249641 | 2022-02-25 | LaSalle | Illinois | 17099 | 28533 | 430 |
2246390 | 2246390 | 2022-02-24 | LaSalle | Illinois | 17099 | 28509 | 430 |
2243139 | 2243139 | 2022-02-23 | LaSalle | Illinois | 17099 | 28482 | 429 |
2239888 | 2239888 | 2022-02-22 | LaSalle | Illinois | 17099 | 28460 | 429 |
2236637 | 2236637 | 2022-02-21 | LaSalle | Illinois | 17099 | 28390 | 429 |
2233386 | 2233386 | 2022-02-20 | LaSalle | Illinois | 17099 | 28390 | 429 |
2230135 | 2230135 | 2022-02-19 | LaSalle | Illinois | 17099 | 28390 | 429 |
2226884 | 2226884 | 2022-02-18 | LaSalle | Illinois | 17099 | 28390 | 429 |
2223633 | 2223633 | 2022-02-17 | LaSalle | Illinois | 17099 | 28352 | 428 |
2220382 | 2220382 | 2022-02-16 | LaSalle | Illinois | 17099 | 28319 | 428 |
2217131 | 2217131 | 2022-02-15 | LaSalle | Illinois | 17099 | 28258 | 427 |
2213880 | 2213880 | 2022-02-14 | LaSalle | Illinois | 17099 | 28220 | 425 |
2210628 | 2210628 | 2022-02-13 | LaSalle | Illinois | 17099 | 28063 | 422 |
2207375 | 2207375 | 2022-02-12 | LaSalle | Illinois | 17099 | 28063 | 422 |
2204122 | 2204122 | 2022-02-11 | LaSalle | Illinois | 17099 | 28063 | 422 |
2200869 | 2200869 | 2022-02-10 | LaSalle | Illinois | 17099 | 28063 | 422 |
2197615 | 2197615 | 2022-02-09 | LaSalle | Illinois | 17099 | 27986 | 421 |
2194361 | 2194361 | 2022-02-08 | LaSalle | Illinois | 17099 | 27950 | 420 |
2191107 | 2191107 | 2022-02-07 | LaSalle | Illinois | 17099 | 27880 | 420 |
2187854 | 2187854 | 2022-02-06 | LaSalle | Illinois | 17099 | 27740 | 418 |
2184601 | 2184601 | 2022-02-05 | LaSalle | Illinois | 17099 | 27740 | 418 |
2181349 | 2181349 | 2022-02-04 | LaSalle | Illinois | 17099 | 27740 | 418 |
2178098 | 2178098 | 2022-02-03 | LaSalle | Illinois | 17099 | 27644 | 416 |
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);