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 464
- 17089 418
- 17111 418
- 17097 417
- 17203 415
- 17035 414
- 17043 414
- 17163 414
- 17167 414
- 17201 414
- 17027 413
- 17195 413
- 17143 412
- 17197 412
- 17199 411
- 17077 410
- 17091 410
- 17093 410
- 17099 410
- 17119 410
- 17189 410
- 17001 408
- 17021 408
- 17113 408
- 17037 407
- 17019 406
- 17085 406
- 17105 406
- 17161 406
- 17177 406
- …
county >30
- Cook 464
- Kane 418
- McHenry 418
- Lake 417
- Woodford 415
- Cumberland 414
- DuPage 414
- Sangamon 414
- St. Clair 414
- Winnebago 414
- Clinton 413
- Whiteside 413
- Peoria 412
- Will 412
- Williamson 411
- Jackson 410
- Kankakee 410
- Kendall 410
- LaSalle 410
- Madison 410
- Washington 410
- Adams 408
- Christian 408
- McLean 408
- DeKalb 407
- Champaign 406
- Jo Daviess 406
- Livingston 406
- Rock Island 406
- Stephenson 406
- …
state 1
- Illinois · 40,674 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278244 | 1278244 | 2021-05-02 | Williamson | Illinois | 17199 | 7332 | 140 |
1278245 | 1278245 | 2021-05-02 | Winnebago | Illinois | 17201 | 32381 | 499 |
1278246 | 1278246 | 2021-05-02 | Woodford | Illinois | 17203 | 4653 | 87 |
1274897 | 1274897 | 2021-05-01 | Adams | Illinois | 17001 | 8325 | 148 |
1274898 | 1274898 | 2021-05-01 | Alexander | Illinois | 17003 | 464 | 11 |
1274899 | 1274899 | 2021-05-01 | Bond | Illinois | 17005 | 2018 | 30 |
1274900 | 1274900 | 2021-05-01 | Boone | Illinois | 17007 | 6582 | 83 |
1274901 | 1274901 | 2021-05-01 | Brown | Illinois | 17009 | 696 | 12 |
1274902 | 1274902 | 2021-05-01 | Bureau | Illinois | 17011 | 3630 | 95 |
1274903 | 1274903 | 2021-05-01 | Calhoun | Illinois | 17013 | 515 | 5 |
1274904 | 1274904 | 2021-05-01 | Carroll | Illinois | 17015 | 1732 | 37 |
1274905 | 1274905 | 2021-05-01 | Cass | Illinois | 17017 | 1971 | 33 |
1274906 | 1274906 | 2021-05-01 | Champaign | Illinois | 17019 | 20304 | 152 |
1274907 | 1274907 | 2021-05-01 | Christian | Illinois | 17021 | 3601 | 91 |
1274908 | 1274908 | 2021-05-01 | Clark | Illinois | 17023 | 1779 | 40 |
1274909 | 1274909 | 2021-05-01 | Clay | Illinois | 17025 | 1480 | 48 |
1274910 | 1274910 | 2021-05-01 | Clinton | Illinois | 17027 | 5735 | 99 |
1274911 | 1274911 | 2021-05-01 | Coles | Illinois | 17029 | 5635 | 96 |
1274912 | 1274912 | 2021-05-01 | Cook | Illinois | 17031 | 535614 | 10515 |
1274913 | 1274913 | 2021-05-01 | Crawford | Illinois | 17033 | 2106 | 42 |
1274914 | 1274914 | 2021-05-01 | Cumberland | Illinois | 17035 | 1288 | 31 |
1274915 | 1274915 | 2021-05-01 | De Witt | Illinois | 17039 | 1442 | 31 |
1274916 | 1274916 | 2021-05-01 | DeKalb | Illinois | 17037 | 9885 | 124 |
1274917 | 1274917 | 2021-05-01 | Douglas | Illinois | 17041 | 2568 | 41 |
1274918 | 1274918 | 2021-05-01 | DuPage | Illinois | 17043 | 88941 | 1351 |
1274919 | 1274919 | 2021-05-01 | Edgar | Illinois | 17045 | 1683 | 59 |
1274920 | 1274920 | 2021-05-01 | Edwards | Illinois | 17047 | 566 | 13 |
1274921 | 1274921 | 2021-05-01 | Effingham | Illinois | 17049 | 4700 | 83 |
1274922 | 1274922 | 2021-05-01 | Fayette | Illinois | 17051 | 3150 | 58 |
1274923 | 1274923 | 2021-05-01 | Ford | Illinois | 17053 | 1742 | 54 |
1274924 | 1274924 | 2021-05-01 | Franklin | Illinois | 17055 | 4388 | 82 |
1274925 | 1274925 | 2021-05-01 | Fulton | Illinois | 17057 | 3801 | 59 |
1274926 | 1274926 | 2021-05-01 | Gallatin | Illinois | 17059 | 457 | 5 |
1274927 | 1274927 | 2021-05-01 | Greene | Illinois | 17061 | 1431 | 46 |
1274928 | 1274928 | 2021-05-01 | Grundy | Illinois | 17063 | 5770 | 75 |
1274929 | 1274929 | 2021-05-01 | Hamilton | Illinois | 17065 | 828 | 18 |
1274930 | 1274930 | 2021-05-01 | Hancock | Illinois | 17067 | 1741 | 41 |
1274931 | 1274931 | 2021-05-01 | Hardin | Illinois | 17069 | 382 | 12 |
1274932 | 1274932 | 2021-05-01 | Henderson | Illinois | 17071 | 522 | 23 |
1274933 | 1274933 | 2021-05-01 | Henry | Illinois | 17073 | 4867 | 92 |
1274934 | 1274934 | 2021-05-01 | Iroquois | Illinois | 17075 | 2956 | 66 |
1274935 | 1274935 | 2021-05-01 | Jackson | Illinois | 17077 | 4941 | 74 |
1274936 | 1274936 | 2021-05-01 | Jasper | Illinois | 17079 | 1148 | 20 |
1274937 | 1274937 | 2021-05-01 | Jefferson | Illinois | 17081 | 4222 | 120 |
1274938 | 1274938 | 2021-05-01 | Jersey | Illinois | 17083 | 2678 | 68 |
1274939 | 1274939 | 2021-05-01 | Jo Daviess | Illinois | 17085 | 1796 | 27 |
1274940 | 1274940 | 2021-05-01 | Johnson | Illinois | 17087 | 1412 | 20 |
1274941 | 1274941 | 2021-05-01 | Kane | Illinois | 17089 | 57295 | 817 |
1274942 | 1274942 | 2021-05-01 | Kankakee | Illinois | 17091 | 13877 | 214 |
1274943 | 1274943 | 2021-05-01 | Kendall | Illinois | 17093 | 13181 | 100 |
1274944 | 1274944 | 2021-05-01 | Knox | Illinois | 17095 | 5461 | 169 |
1274945 | 1274945 | 2021-05-01 | LaSalle | Illinois | 17099 | 12212 | 293 |
1274946 | 1274946 | 2021-05-01 | Lake | Illinois | 17097 | 66075 | 1046 |
1274947 | 1274947 | 2021-05-01 | Lawrence | Illinois | 17101 | 2400 | 34 |
1274948 | 1274948 | 2021-05-01 | Lee | Illinois | 17103 | 4094 | 91 |
1274949 | 1274949 | 2021-05-01 | Livingston | Illinois | 17105 | 4731 | 96 |
1274950 | 1274950 | 2021-05-01 | Logan | Illinois | 17107 | 3786 | 70 |
1274951 | 1274951 | 2021-05-01 | Macon | Illinois | 17115 | 10517 | 204 |
1274952 | 1274952 | 2021-05-01 | Macoupin | Illinois | 17117 | 4645 | 110 |
1274953 | 1274953 | 2021-05-01 | Madison | Illinois | 17119 | 30187 | 590 |
1274954 | 1274954 | 2021-05-01 | Marion | Illinois | 17121 | 4437 | 121 |
1274955 | 1274955 | 2021-05-01 | Marshall | Illinois | 17123 | 1025 | 20 |
1274956 | 1274956 | 2021-05-01 | Mason | Illinois | 17125 | 1471 | 43 |
1274957 | 1274957 | 2021-05-01 | Massac | Illinois | 17127 | 1327 | 43 |
1274958 | 1274958 | 2021-05-01 | McDonough | Illinois | 17109 | 2743 | 57 |
1274959 | 1274959 | 2021-05-01 | McHenry | Illinois | 17111 | 28000 | 309 |
1274960 | 1274960 | 2021-05-01 | McLean | Illinois | 17113 | 17689 | 210 |
1274961 | 1274961 | 2021-05-01 | Menard | Illinois | 17129 | 1207 | 16 |
1274962 | 1274962 | 2021-05-01 | Mercer | Illinois | 17131 | 1421 | 33 |
1274963 | 1274963 | 2021-05-01 | Monroe | Illinois | 17133 | 4343 | 91 |
1274964 | 1274964 | 2021-05-01 | Montgomery | Illinois | 17135 | 3684 | 79 |
1274965 | 1274965 | 2021-05-01 | Morgan | Illinois | 17137 | 3908 | 101 |
1274966 | 1274966 | 2021-05-01 | Moultrie | Illinois | 17139 | 1595 | 34 |
1274967 | 1274967 | 2021-05-01 | Ogle | Illinois | 17141 | 5986 | 88 |
1274968 | 1274968 | 2021-05-01 | Peoria | Illinois | 17143 | 22534 | 318 |
1274969 | 1274969 | 2021-05-01 | Perry | Illinois | 17145 | 3140 | 68 |
1274970 | 1274970 | 2021-05-01 | Piatt | Illinois | 17147 | 1449 | 20 |
1274971 | 1274971 | 2021-05-01 | Pike | Illinois | 17149 | 1782 | 54 |
1274972 | 1274972 | 2021-05-01 | Pope | Illinois | 17151 | 313 | 4 |
1274973 | 1274973 | 2021-05-01 | Pulaski | Illinois | 17153 | 683 | 7 |
1274974 | 1274974 | 2021-05-01 | Putnam | Illinois | 17155 | 466 | 4 |
1274975 | 1274975 | 2021-05-01 | Randolph | Illinois | 17157 | 4115 | 90 |
1274976 | 1274976 | 2021-05-01 | Richland | Illinois | 17159 | 1732 | 49 |
1274977 | 1274977 | 2021-05-01 | Rock Island | Illinois | 17161 | 14635 | 348 |
1274978 | 1274978 | 2021-05-01 | Saline | Illinois | 17165 | 2549 | 69 |
1274979 | 1274979 | 2021-05-01 | Sangamon | Illinois | 17167 | 18338 | 273 |
1274980 | 1274980 | 2021-05-01 | Schuyler | Illinois | 17169 | 730 | 17 |
1274981 | 1274981 | 2021-05-01 | Scott | Illinois | 17171 | 476 | 1 |
1274982 | 1274982 | 2021-05-01 | Shelby | Illinois | 17173 | 2272 | 40 |
1274983 | 1274983 | 2021-05-01 | St. Clair | Illinois | 17163 | 30495 | 553 |
1274984 | 1274984 | 2021-05-01 | Stark | Illinois | 17175 | 628 | 23 |
1274985 | 1274985 | 2021-05-01 | Stephenson | Illinois | 17177 | 4636 | 100 |
1274986 | 1274986 | 2021-05-01 | Tazewell | Illinois | 17179 | 16569 | 307 |
1274987 | 1274987 | 2021-05-01 | Union | Illinois | 17181 | 2241 | 44 |
1274988 | 1274988 | 2021-05-01 | Unknown | Illinois | 0 | 317 | |
1274989 | 1274989 | 2021-05-01 | Vermilion | Illinois | 17183 | 9303 | 148 |
1274990 | 1274990 | 2021-05-01 | Wabash | Illinois | 17185 | 1341 | 15 |
1274991 | 1274991 | 2021-05-01 | Warren | Illinois | 17187 | 1773 | 49 |
1274992 | 1274992 | 2021-05-01 | Washington | Illinois | 17189 | 1636 | 31 |
1274993 | 1274993 | 2021-05-01 | Wayne | Illinois | 17191 | 1754 | 53 |
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);