ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,502 rows where state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 17031 357
- 17089 311
- 17111 311
- 17097 310
- 17203 308
- 17035 307
- 17043 307
- 17163 307
- 17167 307
- 17201 307
- 17027 306
- 17195 306
- 17143 305
- 17197 305
- 17077 303
- 17091 303
- 17093 303
- 17099 303
- 17119 303
- 17189 303
- 17199 303
- 17001 301
- 17021 301
- 17113 301
- 17037 300
- 17019 299
- 17085 299
- 17105 299
- 17161 299
- 17177 299
- …
county >30
- Cook 357
- Kane 311
- McHenry 311
- Lake 310
- Woodford 308
- Cumberland 307
- DuPage 307
- Sangamon 307
- St. Clair 307
- Winnebago 307
- Clinton 306
- Whiteside 306
- Peoria 305
- Will 305
- Jackson 303
- Kankakee 303
- Kendall 303
- LaSalle 303
- Madison 303
- Washington 303
- Williamson 303
- Adams 301
- Christian 301
- McLean 301
- DeKalb 300
- Champaign 299
- Jo Daviess 299
- Livingston 299
- Rock Island 299
- Stephenson 299
- …
state 1
- Illinois · 29,667 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930874 | 930874 | 2021-01-15 | Winnebago | Illinois | 17201 | 25971 | 407 |
930875 | 930875 | 2021-01-15 | Woodford | Illinois | 17203 | 3211 | 66 |
927529 | 927529 | 2021-01-14 | Adams | Illinois | 17001 | 7266 | 108 |
927530 | 927530 | 2021-01-14 | Alexander | Illinois | 17003 | 376 | 7 |
927531 | 927531 | 2021-01-14 | Bond | Illinois | 17005 | 1715 | 23 |
927532 | 927532 | 2021-01-14 | Boone | Illinois | 17007 | 5470 | 77 |
927533 | 927533 | 2021-01-14 | Brown | Illinois | 17009 | 598 | 11 |
927534 | 927534 | 2021-01-14 | Bureau | Illinois | 17011 | 2966 | 82 |
927535 | 927535 | 2021-01-14 | Calhoun | Illinois | 17013 | 430 | 4 |
927536 | 927536 | 2021-01-14 | Carroll | Illinois | 17015 | 1415 | 32 |
927537 | 927537 | 2021-01-14 | Cass | Illinois | 17017 | 1722 | 31 |
927538 | 927538 | 2021-01-14 | Champaign | Illinois | 17019 | 15148 | 93 |
927539 | 927539 | 2021-01-14 | Christian | Illinois | 17021 | 2923 | 72 |
927540 | 927540 | 2021-01-14 | Clark | Illinois | 17023 | 1434 | 26 |
927541 | 927541 | 2021-01-14 | Clay | Illinois | 17025 | 1298 | 38 |
927542 | 927542 | 2021-01-14 | Clinton | Illinois | 17027 | 4910 | 83 |
927543 | 927543 | 2021-01-14 | Coles | Illinois | 17029 | 4644 | 78 |
927544 | 927544 | 2021-01-14 | Cook | Illinois | 17031 | 426658 | 8889 |
927545 | 927545 | 2021-01-14 | Crawford | Illinois | 17033 | 1727 | 34 |
927546 | 927546 | 2021-01-14 | Cumberland | Illinois | 17035 | 1059 | 27 |
927547 | 927547 | 2021-01-14 | De Witt | Illinois | 17039 | 1112 | 26 |
927548 | 927548 | 2021-01-14 | DeKalb | Illinois | 17037 | 7425 | 89 |
927549 | 927549 | 2021-01-14 | Douglas | Illinois | 17041 | 1982 | 33 |
927550 | 927550 | 2021-01-14 | DuPage | Illinois | 17043 | 67651 | 1129 |
927551 | 927551 | 2021-01-14 | Edgar | Illinois | 17045 | 1420 | 50 |
927552 | 927552 | 2021-01-14 | Edwards | Illinois | 17047 | 456 | 8 |
927553 | 927553 | 2021-01-14 | Effingham | Illinois | 17049 | 4258 | 67 |
927554 | 927554 | 2021-01-14 | Fayette | Illinois | 17051 | 2864 | 53 |
927555 | 927555 | 2021-01-14 | Ford | Illinois | 17053 | 1358 | 49 |
927556 | 927556 | 2021-01-14 | Franklin | Illinois | 17055 | 3762 | 66 |
927557 | 927557 | 2021-01-14 | Fulton | Illinois | 17057 | 2512 | 48 |
927558 | 927558 | 2021-01-14 | Gallatin | Illinois | 17059 | 378 | 4 |
927559 | 927559 | 2021-01-14 | Greene | Illinois | 17061 | 1242 | 42 |
927560 | 927560 | 2021-01-14 | Grundy | Illinois | 17063 | 4261 | 54 |
927561 | 927561 | 2021-01-14 | Hamilton | Illinois | 17065 | 705 | 15 |
927562 | 927562 | 2021-01-14 | Hancock | Illinois | 17067 | 1455 | 32 |
927563 | 927563 | 2021-01-14 | Hardin | Illinois | 17069 | 298 | 8 |
927564 | 927564 | 2021-01-14 | Henderson | Illinois | 17071 | 439 | 16 |
927565 | 927565 | 2021-01-14 | Henry | Illinois | 17073 | 3958 | 75 |
927566 | 927566 | 2021-01-14 | Iroquois | Illinois | 17075 | 2545 | 54 |
927567 | 927567 | 2021-01-14 | Jackson | Illinois | 17077 | 4067 | 67 |
927568 | 927568 | 2021-01-14 | Jasper | Illinois | 17079 | 1015 | 15 |
927569 | 927569 | 2021-01-14 | Jefferson | Illinois | 17081 | 3329 | 100 |
927570 | 927570 | 2021-01-14 | Jersey | Illinois | 17083 | 2158 | 52 |
927571 | 927571 | 2021-01-14 | Jo Daviess | Illinois | 17085 | 1467 | 24 |
927572 | 927572 | 2021-01-14 | Johnson | Illinois | 17087 | 1200 | 15 |
927573 | 927573 | 2021-01-14 | Kane | Illinois | 17089 | 45073 | 662 |
927574 | 927574 | 2021-01-14 | Kankakee | Illinois | 17091 | 11393 | 175 |
927575 | 927575 | 2021-01-14 | Kendall | Illinois | 17093 | 9622 | 76 |
927576 | 927576 | 2021-01-14 | Knox | Illinois | 17095 | 4507 | 139 |
927577 | 927577 | 2021-01-14 | LaSalle | Illinois | 17099 | 9212 | 247 |
927578 | 927578 | 2021-01-14 | Lake | Illinois | 17097 | 52264 | 874 |
927579 | 927579 | 2021-01-14 | Lawrence | Illinois | 17101 | 2138 | 29 |
927580 | 927580 | 2021-01-14 | Lee | Illinois | 17103 | 2996 | 72 |
927581 | 927581 | 2021-01-14 | Livingston | Illinois | 17105 | 3524 | 66 |
927582 | 927582 | 2021-01-14 | Logan | Illinois | 17107 | 3028 | 56 |
927583 | 927583 | 2021-01-14 | Macon | Illinois | 17115 | 8639 | 178 |
927584 | 927584 | 2021-01-14 | Macoupin | Illinois | 17117 | 3739 | 92 |
927585 | 927585 | 2021-01-14 | Madison | Illinois | 17119 | 23664 | 449 |
927586 | 927586 | 2021-01-14 | Marion | Illinois | 17121 | 3896 | 111 |
927587 | 927587 | 2021-01-14 | Marshall | Illinois | 17123 | 644 | 13 |
927588 | 927588 | 2021-01-14 | Mason | Illinois | 17125 | 1150 | 40 |
927589 | 927589 | 2021-01-14 | Massac | Illinois | 17127 | 999 | 30 |
927590 | 927590 | 2021-01-14 | McDonough | Illinois | 17109 | 2105 | 50 |
927591 | 927591 | 2021-01-14 | McHenry | Illinois | 17111 | 21132 | 238 |
927592 | 927592 | 2021-01-14 | McLean | Illinois | 17113 | 12931 | 152 |
927593 | 927593 | 2021-01-14 | Menard | Illinois | 17129 | 848 | 10 |
927594 | 927594 | 2021-01-14 | Mercer | Illinois | 17131 | 1157 | 28 |
927595 | 927595 | 2021-01-14 | Monroe | Illinois | 17133 | 3495 | 67 |
927596 | 927596 | 2021-01-14 | Montgomery | Illinois | 17135 | 2943 | 37 |
927597 | 927597 | 2021-01-14 | Morgan | Illinois | 17137 | 3289 | 90 |
927598 | 927598 | 2021-01-14 | Moultrie | Illinois | 17139 | 1345 | 28 |
927599 | 927599 | 2021-01-14 | Ogle | Illinois | 17141 | 4535 | 70 |
927600 | 927600 | 2021-01-14 | Peoria | Illinois | 17143 | 14655 | 231 |
927601 | 927601 | 2021-01-14 | Perry | Illinois | 17145 | 2591 | 60 |
927602 | 927602 | 2021-01-14 | Piatt | Illinois | 17147 | 1152 | 15 |
927603 | 927603 | 2021-01-14 | Pike | Illinois | 17149 | 1520 | 45 |
927604 | 927604 | 2021-01-14 | Pope | Illinois | 17151 | 237 | 2 |
927605 | 927605 | 2021-01-14 | Pulaski | Illinois | 17153 | 595 | 3 |
927606 | 927606 | 2021-01-14 | Putnam | Illinois | 17155 | 345 | 1 |
927607 | 927607 | 2021-01-14 | Randolph | Illinois | 17157 | 3644 | 64 |
927608 | 927608 | 2021-01-14 | Richland | Illinois | 17159 | 1503 | 43 |
927609 | 927609 | 2021-01-14 | Rock Island | Illinois | 17161 | 11688 | 301 |
927610 | 927610 | 2021-01-14 | Saline | Illinois | 17165 | 1985 | 52 |
927611 | 927611 | 2021-01-14 | Sangamon | Illinois | 17167 | 14227 | 232 |
927612 | 927612 | 2021-01-14 | Schuyler | Illinois | 17169 | 605 | 15 |
927613 | 927613 | 2021-01-14 | Scott | Illinois | 17171 | 366 | 1 |
927614 | 927614 | 2021-01-14 | Shelby | Illinois | 17173 | 1943 | 34 |
927615 | 927615 | 2021-01-14 | St. Clair | Illinois | 17163 | 23809 | 410 |
927616 | 927616 | 2021-01-14 | Stark | Illinois | 17175 | 490 | 20 |
927617 | 927617 | 2021-01-14 | Stephenson | Illinois | 17177 | 3467 | 74 |
927618 | 927618 | 2021-01-14 | Tazewell | Illinois | 17179 | 11742 | 238 |
927619 | 927619 | 2021-01-14 | Union | Illinois | 17181 | 1946 | 32 |
927620 | 927620 | 2021-01-14 | Vermilion | Illinois | 17183 | 7265 | 107 |
927621 | 927621 | 2021-01-14 | Wabash | Illinois | 17185 | 1157 | 14 |
927622 | 927622 | 2021-01-14 | Warren | Illinois | 17187 | 1572 | 43 |
927623 | 927623 | 2021-01-14 | Washington | Illinois | 17189 | 1423 | 25 |
927624 | 927624 | 2021-01-14 | Wayne | Illinois | 17191 | 1480 | 43 |
927625 | 927625 | 2021-01-14 | White | Illinois | 17193 | 1299 | 29 |
927626 | 927626 | 2021-01-14 | Whiteside | Illinois | 17195 | 5297 | 172 |
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);