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 840
- 17089 794
- 17111 794
- 17097 793
- 17203 791
- 17035 790
- 17043 790
- 17163 790
- 17167 790
- 17201 790
- 17027 789
- 17195 789
- 17143 788
- 17197 788
- 17199 787
- 17077 786
- 17091 786
- 17093 786
- 17099 786
- 17119 786
- 17189 786
- 17001 784
- 17021 784
- 17113 784
- 17037 783
- 17019 782
- 17085 782
- 17105 782
- 17161 782
- 17177 782
- …
county >30
- Cook 840
- Kane 794
- McHenry 794
- Lake 793
- Woodford 791
- Cumberland 790
- DuPage 790
- Sangamon 790
- St. Clair 790
- Winnebago 790
- Clinton 789
- Whiteside 789
- Peoria 788
- Will 788
- Williamson 787
- Jackson 786
- Kankakee 786
- Kendall 786
- LaSalle 786
- Madison 786
- Washington 786
- Adams 784
- Christian 784
- McLean 784
- DeKalb 783
- Champaign 782
- Jo Daviess 782
- Livingston 782
- Rock Island 782
- Stephenson 782
- …
state 1
- Illinois · 79,402 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500277 | 2500277 | 2022-05-13 | Williamson | Illinois | 17199 | 22816 | 263 |
2500278 | 2500278 | 2022-05-13 | Winnebago | Illinois | 17201 | 79104 | 855 |
2500279 | 2500279 | 2022-05-13 | Woodford | Illinois | 17203 | 10578 | 124 |
2496919 | 2496919 | 2022-05-12 | Adams | Illinois | 17001 | 22513 | 238 |
2496920 | 2496920 | 2022-05-12 | Alexander | Illinois | 17003 | 1288 | 15 |
2496921 | 2496921 | 2022-05-12 | Bond | Illinois | 17005 | 4369 | 37 |
2496922 | 2496922 | 2022-05-12 | Boone | Illinois | 17007 | 14140 | 130 |
2496923 | 2496923 | 2022-05-12 | Brown | Illinois | 17009 | 2428 | 21 |
2496924 | 2496924 | 2022-05-12 | Bureau | Illinois | 17011 | 8454 | 140 |
2496925 | 2496925 | 2022-05-12 | Calhoun | Illinois | 17013 | 1537 | 8 |
2496926 | 2496926 | 2022-05-12 | Carroll | Illinois | 17015 | 4300 | 49 |
2496927 | 2496927 | 2022-05-12 | Cass | Illinois | 17017 | 4640 | 44 |
2496928 | 2496928 | 2022-05-12 | Champaign | Illinois | 17019 | 66959 | 296 |
2496929 | 2496929 | 2022-05-12 | Christian | Illinois | 17021 | 10324 | 131 |
2496930 | 2496930 | 2022-05-12 | Clark | Illinois | 17023 | 4885 | 60 |
2496931 | 2496931 | 2022-05-12 | Clay | Illinois | 17025 | 4748 | 74 |
2496932 | 2496932 | 2022-05-12 | Clinton | Illinois | 17027 | 12053 | 122 |
2496933 | 2496933 | 2022-05-12 | Coles | Illinois | 17029 | 15514 | 175 |
2496934 | 2496934 | 2022-05-12 | Cook | Illinois | 17031 | 1189960 | 14932 |
2496935 | 2496935 | 2022-05-12 | Crawford | Illinois | 17033 | 6245 | 61 |
2496936 | 2496936 | 2022-05-12 | Cumberland | Illinois | 17035 | 3380 | 49 |
2496937 | 2496937 | 2022-05-12 | De Witt | Illinois | 17039 | 4416 | 45 |
2496938 | 2496938 | 2022-05-12 | DeKalb | Illinois | 17037 | 24463 | 201 |
2496939 | 2496939 | 2022-05-12 | Douglas | Illinois | 17041 | 6605 | 61 |
2496940 | 2496940 | 2022-05-12 | DuPage | Illinois | 17043 | 223877 | 1806 |
2496941 | 2496941 | 2022-05-12 | Edgar | Illinois | 17045 | 5205 | 79 |
2496942 | 2496942 | 2022-05-12 | Edwards | Illinois | 17047 | 1749 | 29 |
2496943 | 2496943 | 2022-05-12 | Effingham | Illinois | 17049 | 10709 | 150 |
2496944 | 2496944 | 2022-05-12 | Fayette | Illinois | 17051 | 7151 | 104 |
2496945 | 2496945 | 2022-05-12 | Ford | Illinois | 17053 | 4492 | 75 |
2496946 | 2496946 | 2022-05-12 | Franklin | Illinois | 17055 | 12266 | 178 |
2496947 | 2496947 | 2022-05-12 | Fulton | Illinois | 17057 | 10230 | 135 |
2496948 | 2496948 | 2022-05-12 | Gallatin | Illinois | 17059 | 1415 | 18 |
2496949 | 2496949 | 2022-05-12 | Greene | Illinois | 17061 | 3659 | 58 |
2496950 | 2496950 | 2022-05-12 | Grundy | Illinois | 17063 | 12988 | 140 |
2496951 | 2496951 | 2022-05-12 | Hamilton | Illinois | 17065 | 2181 | 34 |
2496952 | 2496952 | 2022-05-12 | Hancock | Illinois | 17067 | 4419 | 58 |
2496953 | 2496953 | 2022-05-12 | Hardin | Illinois | 17069 | 1059 | 20 |
2496954 | 2496954 | 2022-05-12 | Henderson | Illinois | 17071 | 1165 | 28 |
2496955 | 2496955 | 2022-05-12 | Henry | Illinois | 17073 | 12873 | 150 |
2496956 | 2496956 | 2022-05-12 | Iroquois | Illinois | 17075 | 7285 | 118 |
2496957 | 2496957 | 2022-05-12 | Jackson | Illinois | 17077 | 15801 | 130 |
2496958 | 2496958 | 2022-05-12 | Jasper | Illinois | 17079 | 2691 | 33 |
2496959 | 2496959 | 2022-05-12 | Jefferson | Illinois | 17081 | 11155 | 176 |
2496960 | 2496960 | 2022-05-12 | Jersey | Illinois | 17083 | 6314 | 91 |
2496961 | 2496961 | 2022-05-12 | Jo Daviess | Illinois | 17085 | 4095 | 39 |
2496962 | 2496962 | 2022-05-12 | Johnson | Illinois | 17087 | 4532 | 46 |
2496963 | 2496963 | 2022-05-12 | Kane | Illinois | 17089 | 131372 | 1179 |
2496964 | 2496964 | 2022-05-12 | Kankakee | Illinois | 17091 | 29300 | 373 |
2496965 | 2496965 | 2022-05-12 | Kendall | Illinois | 17093 | 32402 | 171 |
2496966 | 2496966 | 2022-05-12 | Knox | Illinois | 17095 | 12705 | 246 |
2496967 | 2496967 | 2022-05-12 | LaSalle | Illinois | 17099 | 29656 | 441 |
2496968 | 2496968 | 2022-05-12 | Lake | Illinois | 17097 | 158607 | 1466 |
2496969 | 2496969 | 2022-05-12 | Lawrence | Illinois | 17101 | 5487 | 52 |
2496970 | 2496970 | 2022-05-12 | Lee | Illinois | 17103 | 9004 | 118 |
2496971 | 2496971 | 2022-05-12 | Livingston | Illinois | 17105 | 10910 | 148 |
2496972 | 2496972 | 2022-05-12 | Logan | Illinois | 17107 | 9896 | 100 |
2496973 | 2496973 | 2022-05-12 | Macon | Illinois | 17115 | 31078 | 354 |
2496974 | 2496974 | 2022-05-12 | Macoupin | Illinois | 17117 | 12956 | 171 |
2496975 | 2496975 | 2022-05-12 | Madison | Illinois | 17119 | 71499 | 866 |
2496976 | 2496976 | 2022-05-12 | Marion | Illinois | 17121 | 11929 | 217 |
2496977 | 2496977 | 2022-05-12 | Marshall | Illinois | 17123 | 2806 | 33 |
2496978 | 2496978 | 2022-05-12 | Mason | Illinois | 17125 | 3974 | 61 |
2496979 | 2496979 | 2022-05-12 | Massac | Illinois | 17127 | 3886 | 71 |
2496980 | 2496980 | 2022-05-12 | McDonough | Illinois | 17109 | 7298 | 105 |
2496981 | 2496981 | 2022-05-12 | McHenry | Illinois | 17111 | 78920 | 511 |
2496982 | 2496982 | 2022-05-12 | McLean | Illinois | 17113 | 52186 | 330 |
2496983 | 2496983 | 2022-05-12 | Menard | Illinois | 17129 | 3557 | 24 |
2496984 | 2496984 | 2022-05-12 | Mercer | Illinois | 17131 | 4078 | 47 |
2496985 | 2496985 | 2022-05-12 | Monroe | Illinois | 17133 | 9621 | 128 |
2496986 | 2496986 | 2022-05-12 | Montgomery | Illinois | 17135 | 9868 | 111 |
2496987 | 2496987 | 2022-05-12 | Morgan | Illinois | 17137 | 9652 | 144 |
2496988 | 2496988 | 2022-05-12 | Moultrie | Illinois | 17139 | 4097 | 52 |
2496989 | 2496989 | 2022-05-12 | Ogle | Illinois | 17141 | 14277 | 136 |
2496990 | 2496990 | 2022-05-12 | Peoria | Illinois | 17143 | 47813 | 555 |
2496991 | 2496991 | 2022-05-12 | Perry | Illinois | 17145 | 7506 | 106 |
2496992 | 2496992 | 2022-05-12 | Piatt | Illinois | 17147 | 4570 | 29 |
2496993 | 2496993 | 2022-05-12 | Pike | Illinois | 17149 | 5047 | 70 |
2496994 | 2496994 | 2022-05-12 | Pope | Illinois | 17151 | 960 | 8 |
2496995 | 2496995 | 2022-05-12 | Pulaski | Illinois | 17153 | 1729 | 19 |
2496996 | 2496996 | 2022-05-12 | Putnam | Illinois | 17155 | 1158 | 10 |
2496997 | 2496997 | 2022-05-12 | Randolph | Illinois | 17157 | 10555 | 132 |
2496998 | 2496998 | 2022-05-12 | Richland | Illinois | 17159 | 5167 | 83 |
2496999 | 2496999 | 2022-05-12 | Rock Island | Illinois | 17161 | 33773 | 523 |
2497000 | 2497000 | 2022-05-12 | Saline | Illinois | 17165 | 7930 | 111 |
2497001 | 2497001 | 2022-05-12 | Sangamon | Illinois | 17167 | 56524 | 432 |
2497002 | 2497002 | 2022-05-12 | Schuyler | Illinois | 17169 | 1975 | 29 |
2497003 | 2497003 | 2022-05-12 | Scott | Illinois | 17171 | 1275 | 12 |
2497004 | 2497004 | 2022-05-12 | Shelby | Illinois | 17173 | 6259 | 80 |
2497005 | 2497005 | 2022-05-12 | St. Clair | Illinois | 17163 | 70463 | 776 |
2497006 | 2497006 | 2022-05-12 | Stark | Illinois | 17175 | 1531 | 33 |
2497007 | 2497007 | 2022-05-12 | Stephenson | Illinois | 17177 | 11662 | 176 |
2497008 | 2497008 | 2022-05-12 | Tazewell | Illinois | 17179 | 37579 | 500 |
2497009 | 2497009 | 2022-05-12 | Union | Illinois | 17181 | 5411 | 68 |
2497010 | 2497010 | 2022-05-12 | Unknown | Illinois | 0 | 2270 | |
2497011 | 2497011 | 2022-05-12 | Vermilion | Illinois | 17183 | 28253 | 313 |
2497012 | 2497012 | 2022-05-12 | Wabash | Illinois | 17185 | 3730 | 31 |
2497013 | 2497013 | 2022-05-12 | Warren | Illinois | 17187 | 4082 | 87 |
2497014 | 2497014 | 2022-05-12 | Washington | Illinois | 17189 | 3454 | 41 |
2497015 | 2497015 | 2022-05-12 | Wayne | Illinois | 17191 | 5320 | 85 |
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);