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 720
- 17089 674
- 17111 674
- 17097 673
- 17203 671
- 17035 670
- 17043 670
- 17163 670
- 17167 670
- 17201 670
- 17027 669
- 17195 669
- 17143 668
- 17197 668
- 17199 667
- 17077 666
- 17091 666
- 17093 666
- 17099 666
- 17119 666
- 17189 666
- 17001 664
- 17021 664
- 17113 664
- 17037 663
- 17019 662
- 17085 662
- 17105 662
- 17161 662
- 17177 662
- …
county >30
- Cook 720
- Kane 674
- McHenry 674
- Lake 673
- Woodford 671
- Cumberland 670
- DuPage 670
- Sangamon 670
- St. Clair 670
- Winnebago 670
- Clinton 669
- Whiteside 669
- Peoria 668
- Will 668
- Williamson 667
- Jackson 666
- Kankakee 666
- Kendall 666
- LaSalle 666
- Madison 666
- Washington 666
- Adams 664
- Christian 664
- McLean 664
- DeKalb 663
- Champaign 662
- Jo Daviess 662
- Livingston 662
- Rock Island 662
- Stephenson 662
- …
state 1
- Illinois · 67,042 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109831 | 2109831 | 2022-01-13 | Williamson | Illinois | 17199 | 16730 | 225 |
2109832 | 2109832 | 2022-01-13 | Winnebago | Illinois | 17201 | 63391 | 727 |
2109833 | 2109833 | 2022-01-13 | Woodford | Illinois | 17203 | 8688 | 112 |
2106480 | 2106480 | 2022-01-12 | Adams | Illinois | 17001 | 18268 | 208 |
2106481 | 2106481 | 2022-01-12 | Alexander | Illinois | 17003 | 963 | 13 |
2106482 | 2106482 | 2022-01-12 | Bond | Illinois | 17005 | 3498 | 34 |
2106483 | 2106483 | 2022-01-12 | Boone | Illinois | 17007 | 11144 | 106 |
2106484 | 2106484 | 2022-01-12 | Brown | Illinois | 17009 | 1367 | 19 |
2106485 | 2106485 | 2022-01-12 | Bureau | Illinois | 17011 | 6632 | 127 |
2106486 | 2106486 | 2022-01-12 | Calhoun | Illinois | 17013 | 1238 | 7 |
2106487 | 2106487 | 2022-01-12 | Carroll | Illinois | 17015 | 3279 | 43 |
2106488 | 2106488 | 2022-01-12 | Cass | Illinois | 17017 | 3664 | 41 |
2106489 | 2106489 | 2022-01-12 | Champaign | Illinois | 17019 | 47121 | 242 |
2106490 | 2106490 | 2022-01-12 | Christian | Illinois | 17021 | 7853 | 115 |
2106491 | 2106491 | 2022-01-12 | Clark | Illinois | 17023 | 3666 | 55 |
2106492 | 2106492 | 2022-01-12 | Clay | Illinois | 17025 | 3787 | 64 |
2106493 | 2106493 | 2022-01-12 | Clinton | Illinois | 17027 | 9817 | 117 |
2106494 | 2106494 | 2022-01-12 | Coles | Illinois | 17029 | 11544 | 148 |
2106495 | 2106495 | 2022-01-12 | Cook | Illinois | 17031 | 966133 | 12961 |
2106496 | 2106496 | 2022-01-12 | Crawford | Illinois | 17033 | 4287 | 53 |
2106497 | 2106497 | 2022-01-12 | Cumberland | Illinois | 17035 | 2610 | 43 |
2106498 | 2106498 | 2022-01-12 | De Witt | Illinois | 17039 | 3456 | 40 |
2106499 | 2106499 | 2022-01-12 | DeKalb | Illinois | 17037 | 18738 | 166 |
2106500 | 2106500 | 2022-01-12 | Douglas | Illinois | 17041 | 4811 | 49 |
2106501 | 2106501 | 2022-01-12 | DuPage | Illinois | 17043 | 170233 | 1575 |
2106502 | 2106502 | 2022-01-12 | Edgar | Illinois | 17045 | 3897 | 75 |
2106503 | 2106503 | 2022-01-12 | Edwards | Illinois | 17047 | 1373 | 24 |
2106504 | 2106504 | 2022-01-12 | Effingham | Illinois | 17049 | 8790 | 127 |
2106505 | 2106505 | 2022-01-12 | Fayette | Illinois | 17051 | 5654 | 81 |
2106506 | 2106506 | 2022-01-12 | Ford | Illinois | 17053 | 3620 | 69 |
2106507 | 2106507 | 2022-01-12 | Franklin | Illinois | 17055 | 9398 | 148 |
2106508 | 2106508 | 2022-01-12 | Fulton | Illinois | 17057 | 7780 | 109 |
2106509 | 2106509 | 2022-01-12 | Gallatin | Illinois | 17059 | 993 | 11 |
2106510 | 2106510 | 2022-01-12 | Greene | Illinois | 17061 | 2986 | 53 |
2106511 | 2106511 | 2022-01-12 | Grundy | Illinois | 17063 | 10995 | 114 |
2106512 | 2106512 | 2022-01-12 | Hamilton | Illinois | 17065 | 1678 | 28 |
2106513 | 2106513 | 2022-01-12 | Hancock | Illinois | 17067 | 3556 | 49 |
2106514 | 2106514 | 2022-01-12 | Hardin | Illinois | 17069 | 835 | 18 |
2106515 | 2106515 | 2022-01-12 | Henderson | Illinois | 17071 | 946 | 24 |
2106516 | 2106516 | 2022-01-12 | Henry | Illinois | 17073 | 10007 | 128 |
2106517 | 2106517 | 2022-01-12 | Iroquois | Illinois | 17075 | 6064 | 94 |
2106518 | 2106518 | 2022-01-12 | Jackson | Illinois | 17077 | 11545 | 114 |
2106519 | 2106519 | 2022-01-12 | Jasper | Illinois | 17079 | 2141 | 26 |
2106520 | 2106520 | 2022-01-12 | Jefferson | Illinois | 17081 | 8386 | 154 |
2106521 | 2106521 | 2022-01-12 | Jersey | Illinois | 17083 | 5059 | 77 |
2106522 | 2106522 | 2022-01-12 | Jo Daviess | Illinois | 17085 | 3210 | 35 |
2106523 | 2106523 | 2022-01-12 | Johnson | Illinois | 17087 | 2988 | 41 |
2106524 | 2106524 | 2022-01-12 | Kane | Illinois | 17089 | 100702 | 1025 |
2106525 | 2106525 | 2022-01-12 | Kankakee | Illinois | 17091 | 25243 | 314 |
2106526 | 2106526 | 2022-01-12 | Kendall | Illinois | 17093 | 25706 | 139 |
2106527 | 2106527 | 2022-01-12 | Knox | Illinois | 17095 | 10468 | 217 |
2106528 | 2106528 | 2022-01-12 | LaSalle | Illinois | 17099 | 23234 | 388 |
2106529 | 2106529 | 2022-01-12 | Lake | Illinois | 17097 | 119305 | 1252 |
2106530 | 2106530 | 2022-01-12 | Lawrence | Illinois | 17101 | 4226 | 48 |
2106531 | 2106531 | 2022-01-12 | Lee | Illinois | 17103 | 6970 | 110 |
2106532 | 2106532 | 2022-01-12 | Livingston | Illinois | 17105 | 8539 | 128 |
2106533 | 2106533 | 2022-01-12 | Logan | Illinois | 17107 | 7412 | 91 |
2106534 | 2106534 | 2022-01-12 | Macon | Illinois | 17115 | 23725 | 297 |
2106535 | 2106535 | 2022-01-12 | Macoupin | Illinois | 17117 | 9958 | 153 |
2106536 | 2106536 | 2022-01-12 | Madison | Illinois | 17119 | 57472 | 743 |
2106537 | 2106537 | 2022-01-12 | Marion | Illinois | 17121 | 9499 | 179 |
2106538 | 2106538 | 2022-01-12 | Marshall | Illinois | 17123 | 2251 | 27 |
2106539 | 2106539 | 2022-01-12 | Mason | Illinois | 17125 | 3083 | 57 |
2106540 | 2106540 | 2022-01-12 | Massac | Illinois | 17127 | 2885 | 64 |
2106541 | 2106541 | 2022-01-12 | McDonough | Illinois | 17109 | 5315 | 86 |
2106542 | 2106542 | 2022-01-12 | McHenry | Illinois | 17111 | 54893 | 406 |
2106543 | 2106543 | 2022-01-12 | McLean | Illinois | 17113 | 38298 | 289 |
2106544 | 2106544 | 2022-01-12 | Menard | Illinois | 17129 | 2765 | 19 |
2106545 | 2106545 | 2022-01-12 | Mercer | Illinois | 17131 | 3167 | 38 |
2106546 | 2106546 | 2022-01-12 | Monroe | Illinois | 17133 | 7669 | 110 |
2106547 | 2106547 | 2022-01-12 | Montgomery | Illinois | 17135 | 7371 | 94 |
2106548 | 2106548 | 2022-01-12 | Morgan | Illinois | 17137 | 7147 | 126 |
2106549 | 2106549 | 2022-01-12 | Moultrie | Illinois | 17139 | 3330 | 47 |
2106550 | 2106550 | 2022-01-12 | Ogle | Illinois | 17141 | 11309 | 126 |
2106551 | 2106551 | 2022-01-12 | Peoria | Illinois | 17143 | 39817 | 480 |
2106552 | 2106552 | 2022-01-12 | Perry | Illinois | 17145 | 5445 | 95 |
2106553 | 2106553 | 2022-01-12 | Piatt | Illinois | 17147 | 3501 | 23 |
2106554 | 2106554 | 2022-01-12 | Pike | Illinois | 17149 | 4012 | 63 |
2106555 | 2106555 | 2022-01-12 | Pope | Illinois | 17151 | 759 | 7 |
2106556 | 2106556 | 2022-01-12 | Pulaski | Illinois | 17153 | 1329 | 15 |
2106557 | 2106557 | 2022-01-12 | Putnam | Illinois | 17155 | 903 | 8 |
2106558 | 2106558 | 2022-01-12 | Randolph | Illinois | 17157 | 7295 | 115 |
2106559 | 2106559 | 2022-01-12 | Richland | Illinois | 17159 | 3896 | 76 |
2106560 | 2106560 | 2022-01-12 | Rock Island | Illinois | 17161 | 27584 | 457 |
2106561 | 2106561 | 2022-01-12 | Saline | Illinois | 17165 | 5714 | 95 |
2106562 | 2106562 | 2022-01-12 | Sangamon | Illinois | 17167 | 41958 | 361 |
2106563 | 2106563 | 2022-01-12 | Schuyler | Illinois | 17169 | 1551 | 27 |
2106564 | 2106564 | 2022-01-12 | Scott | Illinois | 17171 | 1049 | 9 |
2106565 | 2106565 | 2022-01-12 | Shelby | Illinois | 17173 | 4949 | 63 |
2106566 | 2106566 | 2022-01-12 | St. Clair | Illinois | 17163 | 56896 | 698 |
2106567 | 2106567 | 2022-01-12 | Stark | Illinois | 17175 | 1156 | 30 |
2106568 | 2106568 | 2022-01-12 | Stephenson | Illinois | 17177 | 9352 | 151 |
2106569 | 2106569 | 2022-01-12 | Tazewell | Illinois | 17179 | 30779 | 429 |
2106570 | 2106570 | 2022-01-12 | Union | Illinois | 17181 | 4019 | 61 |
2106571 | 2106571 | 2022-01-12 | Unknown | Illinois | 0 | 1347 | |
2106572 | 2106572 | 2022-01-12 | Vermilion | Illinois | 17183 | 22207 | 264 |
2106573 | 2106573 | 2022-01-12 | Wabash | Illinois | 17185 | 2744 | 22 |
2106574 | 2106574 | 2022-01-12 | Warren | Illinois | 17187 | 3380 | 76 |
2106575 | 2106575 | 2022-01-12 | Washington | Illinois | 17189 | 2810 | 37 |
2106576 | 2106576 | 2022-01-12 | Wayne | Illinois | 17191 | 3951 | 70 |
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);