ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where fips = 17071 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 324 ✖
- 8 70
- 534 24
- 529 23
- 530 16
- 1147 16
- 1148 14
- 521 13
- 9 11
- 519 11
- 1153 11
- 525 10
- 4 9
- 1149 9
- 490 8
- 498 6
- 524 6
- 528 6
- 2 5
- 5 5
- 513 5
- 518 5
- 522 5
- 526 5
- 683 5
- 716 5
- 806 5
- 1145 5
- 1150 5
- 6 4
- 7 4
- 45 4
- 60 4
- 62 4
- 66 4
- 505 4
- 532 4
- 594 4
- 690 4
- 696 4
- 871 4
- 886 4
- 964 4
- 1117 4
- 1131 4
- 1137 4
- 1156 4
- 10 3
- 24 3
- 57 3
- 504 3
- 507 3
- 516 3
- 531 3
- 541 3
- 565 3
- 583 3
- 608 3
- 631 3
- 661 3
- 709 3
- 746 3
- 777 3
- 793 3
- 829 3
- 844 3
- 855 3
- 923 3
- 1023 3
- 1066 3
- 1107 3
- 12 2
- 13 2
- 28 2
- 37 2
- 44 2
- 56 2
- 63 2
- 78 2
- 93 2
- 111 2
- 121 2
- 128 2
- 129 2
- 136 2
- 314 2
- 356 2
- 367 2
- 394 2
- 397 2
- 456 2
- 466 2
- 472 2
- 476 2
- 477 2
- 487 2
- 489 2
- 491 2
- 492 2
- 508 2
- 512 2
- 520 2
- 573 2
- 674 2
- 770 2
- 841 2
- 863 2
- 1087 2
- 1114 2
- 1130 2
- 1144 2
- 1154 2
- 1 1
- 3 1
- 14 1
- 15 1
- 21 1
- 22 1
- 23 1
- 25 1
- 35 1
- 36 1
- 40 1
- 41 1
- 51 1
- 52 1
- 59 1
- 61 1
- 64 1
- 69 1
- 70 1
- 71 1
- 72 1
- 73 1
- 76 1
- 77 1
- 79 1
- 82 1
- 83 1
- 85 1
- 86 1
- 88 1
- 90 1
- 95 1
- 101 1
- 108 1
- 115 1
- 131 1
- 132 1
- 137 1
- 144 1
- 145 1
- 153 1
- 158 1
- 162 1
- 169 1
- 172 1
- 175 1
- 182 1
- 192 1
- 194 1
- 204 1
- 211 1
- 226 1
- 229 1
- 230 1
- 238 1
- 241 1
- 243 1
- 248 1
- 254 1
- 258 1
- 261 1
- 265 1
- 276 1
- 279 1
- 286 1
- 289 1
- 290 1
- 299 1
- 303 1
- 306 1
- 325 1
- 330 1
- 342 1
- 343 1
- 344 1
- 348 1
- 354 1
- 363 1
- 365 1
- 368 1
- 369 1
- 371 1
- 373 1
- 377 1
- 384 1
- 387 1
- 389 1
- 393 1
- 395 1
- 401 1
- 403 1
- 404 1
- 405 1
- 411 1
- 417 1
- 421 1
- 427 1
- 429 1
- 430 1
- 432 1
- 434 1
- 439 1
- 445 1
- 448 1
- 451 1
- 452 1
- 453 1
- 465 1
- 468 1
- 470 1
- 475 1
- 479 1
- 482 1
- 485 1
- 493 1
- 495 1
- 497 1
- 500 1
- 501 1
- 506 1
- 509 1
- 511 1
- 515 1
- 527 1
- 536 1
- 550 1
- 553 1
- 554 1
- 560 1
- 577 1
- 581 1
- 586 1
- 590 1
- 592 1
- 595 1
- 599 1
- 603 1
- 605 1
- 615 1
- 619 1
- 626 1
- 630 1
- 640 1
- 650 1
- 651 1
- 656 1
- 668 1
- 680 1
- 686 1
- 688 1
- 692 1
- 693 1
- 698 1
- 702 1
- 703 1
- 706 1
- 712 1
- 713 1
- 719 1
- 725 1
- 731 1
- 742 1
- 758 1
- 761 1
- 778 1
- 782 1
- 786 1
- 787 1
- 799 1
- 804 1
- 810 1
- 811 1
- 817 1
- 822 1
- 836 1
- 838 1
- 849 1
- 850 1
- 851 1
- 854 1
- 866 1
- 872 1
- 874 1
- 879 1
- 897 1
- 903 1
- 913 1
- 915 1
- 932 1
- 941 1
- 946 1
- 960 1
- 996 1
- 1009 1
- 1014 1
- 1034 1
- 1043 1
- 1050 1
- 1055 1
- 1083 1
- 1084 1
- 1113 1
- 1124 1
- 1129 1
- 1134 1
- 1136 1
- 1151 1
- 1152 1
- 1158 1
- 1160 1
- 1163 1
- 1165 1
- 1166 1
state 1
- Illinois · 757 ✖
fips 1
- 17071 · 757 ✖
county 1
- Henderson 757
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500212 | 2500212 | 2022-05-13 | Henderson | Illinois | 17071 | 1166 | 28 |
2496954 | 2496954 | 2022-05-12 | Henderson | Illinois | 17071 | 1165 | 28 |
2493696 | 2493696 | 2022-05-11 | Henderson | Illinois | 17071 | 1163 | 28 |
2490438 | 2490438 | 2022-05-10 | Henderson | Illinois | 17071 | 1160 | 28 |
2487181 | 2487181 | 2022-05-09 | Henderson | Illinois | 17071 | 1158 | 28 |
2483923 | 2483923 | 2022-05-08 | Henderson | Illinois | 17071 | 1156 | 28 |
2480665 | 2480665 | 2022-05-07 | Henderson | Illinois | 17071 | 1156 | 28 |
2477407 | 2477407 | 2022-05-06 | Henderson | Illinois | 17071 | 1156 | 28 |
2474149 | 2474149 | 2022-05-05 | Henderson | Illinois | 17071 | 1156 | 28 |
2470892 | 2470892 | 2022-05-04 | Henderson | Illinois | 17071 | 1154 | 28 |
2467636 | 2467636 | 2022-05-03 | Henderson | Illinois | 17071 | 1153 | 28 |
2464381 | 2464381 | 2022-05-02 | Henderson | Illinois | 17071 | 1153 | 28 |
2461125 | 2461125 | 2022-05-01 | Henderson | Illinois | 17071 | 1153 | 28 |
2457869 | 2457869 | 2022-04-30 | Henderson | Illinois | 17071 | 1153 | 28 |
2454613 | 2454613 | 2022-04-29 | Henderson | Illinois | 17071 | 1153 | 28 |
2451357 | 2451357 | 2022-04-28 | Henderson | Illinois | 17071 | 1153 | 28 |
2448101 | 2448101 | 2022-04-27 | Henderson | Illinois | 17071 | 1153 | 28 |
2444845 | 2444845 | 2022-04-26 | Henderson | Illinois | 17071 | 1154 | 28 |
2441589 | 2441589 | 2022-04-25 | Henderson | Illinois | 17071 | 1153 | 28 |
2438333 | 2438333 | 2022-04-24 | Henderson | Illinois | 17071 | 1153 | 28 |
2435077 | 2435077 | 2022-04-23 | Henderson | Illinois | 17071 | 1153 | 28 |
2431821 | 2431821 | 2022-04-22 | Henderson | Illinois | 17071 | 1153 | 28 |
2428565 | 2428565 | 2022-04-21 | Henderson | Illinois | 17071 | 1152 | 28 |
2425309 | 2425309 | 2022-04-20 | Henderson | Illinois | 17071 | 1151 | 28 |
2422053 | 2422053 | 2022-04-19 | Henderson | Illinois | 17071 | 1148 | 28 |
2418797 | 2418797 | 2022-04-18 | Henderson | Illinois | 17071 | 1148 | 28 |
2415541 | 2415541 | 2022-04-17 | Henderson | Illinois | 17071 | 1148 | 28 |
2412285 | 2412285 | 2022-04-16 | Henderson | Illinois | 17071 | 1148 | 28 |
2409029 | 2409029 | 2022-04-15 | Henderson | Illinois | 17071 | 1148 | 28 |
2405773 | 2405773 | 2022-04-14 | Henderson | Illinois | 17071 | 1148 | 28 |
2402518 | 2402518 | 2022-04-13 | Henderson | Illinois | 17071 | 1148 | 28 |
2399263 | 2399263 | 2022-04-12 | Henderson | Illinois | 17071 | 1148 | 27 |
2396008 | 2396008 | 2022-04-11 | Henderson | Illinois | 17071 | 1148 | 27 |
2392752 | 2392752 | 2022-04-10 | Henderson | Illinois | 17071 | 1148 | 27 |
2389496 | 2389496 | 2022-04-09 | Henderson | Illinois | 17071 | 1148 | 27 |
2386241 | 2386241 | 2022-04-08 | Henderson | Illinois | 17071 | 1148 | 27 |
2382986 | 2382986 | 2022-04-07 | Henderson | Illinois | 17071 | 1148 | 27 |
2379731 | 2379731 | 2022-04-06 | Henderson | Illinois | 17071 | 1148 | 27 |
2376477 | 2376477 | 2022-04-05 | Henderson | Illinois | 17071 | 1149 | 27 |
2373225 | 2373225 | 2022-04-04 | Henderson | Illinois | 17071 | 1149 | 27 |
2369972 | 2369972 | 2022-04-03 | Henderson | Illinois | 17071 | 1150 | 27 |
2366719 | 2366719 | 2022-04-02 | Henderson | Illinois | 17071 | 1150 | 27 |
2363466 | 2363466 | 2022-04-01 | Henderson | Illinois | 17071 | 1150 | 27 |
2360212 | 2360212 | 2022-03-31 | Henderson | Illinois | 17071 | 1150 | 27 |
2356958 | 2356958 | 2022-03-30 | Henderson | Illinois | 17071 | 1150 | 27 |
2353705 | 2353705 | 2022-03-29 | Henderson | Illinois | 17071 | 1149 | 27 |
2350453 | 2350453 | 2022-03-28 | Henderson | Illinois | 17071 | 1149 | 27 |
2347200 | 2347200 | 2022-03-27 | Henderson | Illinois | 17071 | 1149 | 27 |
2343947 | 2343947 | 2022-03-26 | Henderson | Illinois | 17071 | 1149 | 27 |
2340694 | 2340694 | 2022-03-25 | Henderson | Illinois | 17071 | 1149 | 27 |
2337441 | 2337441 | 2022-03-24 | Henderson | Illinois | 17071 | 1149 | 27 |
2334187 | 2334187 | 2022-03-23 | Henderson | Illinois | 17071 | 1149 | 27 |
2330933 | 2330933 | 2022-03-22 | Henderson | Illinois | 17071 | 1147 | 27 |
2327681 | 2327681 | 2022-03-21 | Henderson | Illinois | 17071 | 1147 | 27 |
2324428 | 2324428 | 2022-03-20 | Henderson | Illinois | 17071 | 1147 | 27 |
2321174 | 2321174 | 2022-03-19 | Henderson | Illinois | 17071 | 1147 | 27 |
2317920 | 2317920 | 2022-03-18 | Henderson | Illinois | 17071 | 1147 | 27 |
2314667 | 2314667 | 2022-03-17 | Henderson | Illinois | 17071 | 1147 | 27 |
2311414 | 2311414 | 2022-03-16 | Henderson | Illinois | 17071 | 1147 | 27 |
2308161 | 2308161 | 2022-03-15 | Henderson | Illinois | 17071 | 1147 | 27 |
2304910 | 2304910 | 2022-03-14 | Henderson | Illinois | 17071 | 1147 | 27 |
2301658 | 2301658 | 2022-03-13 | Henderson | Illinois | 17071 | 1147 | 27 |
2298406 | 2298406 | 2022-03-12 | Henderson | Illinois | 17071 | 1147 | 27 |
2295154 | 2295154 | 2022-03-11 | Henderson | Illinois | 17071 | 1147 | 27 |
2291902 | 2291902 | 2022-03-10 | Henderson | Illinois | 17071 | 1147 | 27 |
2288650 | 2288650 | 2022-03-09 | Henderson | Illinois | 17071 | 1147 | 26 |
2285399 | 2285399 | 2022-03-08 | Henderson | Illinois | 17071 | 1147 | 26 |
2282147 | 2282147 | 2022-03-07 | Henderson | Illinois | 17071 | 1147 | 26 |
2278894 | 2278894 | 2022-03-06 | Henderson | Illinois | 17071 | 1145 | 26 |
2275641 | 2275641 | 2022-03-05 | Henderson | Illinois | 17071 | 1145 | 26 |
2272388 | 2272388 | 2022-03-04 | Henderson | Illinois | 17071 | 1145 | 26 |
2269136 | 2269136 | 2022-03-03 | Henderson | Illinois | 17071 | 1145 | 26 |
2265883 | 2265883 | 2022-03-02 | Henderson | Illinois | 17071 | 1144 | 26 |
2262632 | 2262632 | 2022-03-01 | Henderson | Illinois | 17071 | 1144 | 26 |
2259381 | 2259381 | 2022-02-28 | Henderson | Illinois | 17071 | 1145 | 26 |
2256130 | 2256130 | 2022-02-27 | Henderson | Illinois | 17071 | 1137 | 26 |
2252879 | 2252879 | 2022-02-26 | Henderson | Illinois | 17071 | 1137 | 26 |
2249628 | 2249628 | 2022-02-25 | Henderson | Illinois | 17071 | 1137 | 26 |
2246377 | 2246377 | 2022-02-24 | Henderson | Illinois | 17071 | 1137 | 26 |
2243126 | 2243126 | 2022-02-23 | Henderson | Illinois | 17071 | 1136 | 26 |
2239875 | 2239875 | 2022-02-22 | Henderson | Illinois | 17071 | 1134 | 26 |
2236624 | 2236624 | 2022-02-21 | Henderson | Illinois | 17071 | 1131 | 26 |
2233373 | 2233373 | 2022-02-20 | Henderson | Illinois | 17071 | 1131 | 26 |
2230122 | 2230122 | 2022-02-19 | Henderson | Illinois | 17071 | 1131 | 26 |
2226871 | 2226871 | 2022-02-18 | Henderson | Illinois | 17071 | 1131 | 26 |
2223620 | 2223620 | 2022-02-17 | Henderson | Illinois | 17071 | 1130 | 26 |
2220369 | 2220369 | 2022-02-16 | Henderson | Illinois | 17071 | 1130 | 26 |
2217118 | 2217118 | 2022-02-15 | Henderson | Illinois | 17071 | 1129 | 26 |
2213867 | 2213867 | 2022-02-14 | Henderson | Illinois | 17071 | 1124 | 26 |
2210615 | 2210615 | 2022-02-13 | Henderson | Illinois | 17071 | 1117 | 26 |
2207362 | 2207362 | 2022-02-12 | Henderson | Illinois | 17071 | 1117 | 26 |
2204109 | 2204109 | 2022-02-11 | Henderson | Illinois | 17071 | 1117 | 26 |
2200856 | 2200856 | 2022-02-10 | Henderson | Illinois | 17071 | 1117 | 26 |
2197602 | 2197602 | 2022-02-09 | Henderson | Illinois | 17071 | 1114 | 26 |
2194348 | 2194348 | 2022-02-08 | Henderson | Illinois | 17071 | 1114 | 26 |
2191094 | 2191094 | 2022-02-07 | Henderson | Illinois | 17071 | 1113 | 26 |
2187841 | 2187841 | 2022-02-06 | Henderson | Illinois | 17071 | 1107 | 26 |
2184588 | 2184588 | 2022-02-05 | Henderson | Illinois | 17071 | 1107 | 26 |
2181336 | 2181336 | 2022-02-04 | Henderson | Illinois | 17071 | 1107 | 26 |
2178085 | 2178085 | 2022-02-03 | Henderson | Illinois | 17071 | 1087 | 26 |
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);