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 235
- 17089 189
- 17111 189
- 17097 188
- 17203 186
- 17035 185
- 17043 185
- 17163 185
- 17167 185
- 17201 185
- 17027 184
- 17195 184
- 17143 183
- 17197 183
- 17199 182
- 17077 181
- 17091 181
- 17093 181
- 17099 181
- 17119 181
- 17189 181
- 17001 179
- 17021 179
- 17113 179
- 17037 178
- 17019 177
- 17085 177
- 17105 177
- 17161 177
- 17177 177
- …
county >30
- Cook 235
- Kane 189
- McHenry 189
- Lake 188
- Woodford 186
- Cumberland 185
- DuPage 185
- Sangamon 185
- St. Clair 185
- Winnebago 185
- Clinton 184
- Whiteside 184
- Peoria 183
- Will 183
- Williamson 182
- Jackson 181
- Kankakee 181
- Kendall 181
- LaSalle 181
- Madison 181
- Washington 181
- Adams 179
- Christian 179
- McLean 179
- DeKalb 178
- Champaign 177
- Jo Daviess 177
- Livingston 177
- Rock Island 177
- Stephenson 177
- …
state 1
- Illinois · 17,171 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535121 | 535121 | 2020-09-15 | Williamson | Illinois | 17199 | 1204 | 27 |
535122 | 535122 | 2020-09-15 | Winnebago | Illinois | 17201 | 4883 | 152 |
535123 | 535123 | 2020-09-15 | Woodford | Illinois | 17203 | 368 | 5 |
531786 | 531786 | 2020-09-14 | Adams | Illinois | 17001 | 888 | 10 |
531787 | 531787 | 2020-09-14 | Alexander | Illinois | 17003 | 61 | 1 |
531788 | 531788 | 2020-09-14 | Bond | Illinois | 17005 | 241 | 4 |
531789 | 531789 | 2020-09-14 | Boone | Illinois | 17007 | 969 | 23 |
531790 | 531790 | 2020-09-14 | Brown | Illinois | 17009 | 29 | 0 |
531791 | 531791 | 2020-09-14 | Bureau | Illinois | 17011 | 497 | 9 |
531792 | 531792 | 2020-09-14 | Calhoun | Illinois | 17013 | 34 | 0 |
531793 | 531793 | 2020-09-14 | Carroll | Illinois | 17015 | 194 | 4 |
531794 | 531794 | 2020-09-14 | Cass | Illinois | 17017 | 350 | 11 |
531795 | 531795 | 2020-09-14 | Champaign | Illinois | 17019 | 4059 | 20 |
531796 | 531796 | 2020-09-14 | Christian | Illinois | 17021 | 306 | 10 |
531797 | 531797 | 2020-09-14 | Clark | Illinois | 17023 | 140 | 2 |
531798 | 531798 | 2020-09-14 | Clay | Illinois | 17025 | 132 | 0 |
531799 | 531799 | 2020-09-14 | Clinton | Illinois | 17027 | 961 | 19 |
531800 | 531800 | 2020-09-14 | Coles | Illinois | 17029 | 1248 | 26 |
531801 | 531801 | 2020-09-14 | Cook | Illinois | 17031 | 135274 | 5134 |
531802 | 531802 | 2020-09-14 | Crawford | Illinois | 17033 | 261 | 1 |
531803 | 531803 | 2020-09-14 | Cumberland | Illinois | 17035 | 182 | 4 |
531804 | 531804 | 2020-09-14 | De Witt | Illinois | 17039 | 83 | 1 |
531805 | 531805 | 2020-09-14 | DeKalb | Illinois | 17037 | 1375 | 36 |
531806 | 531806 | 2020-09-14 | Douglas | Illinois | 17041 | 262 | 5 |
531807 | 531807 | 2020-09-14 | DuPage | Illinois | 17043 | 16123 | 545 |
531808 | 531808 | 2020-09-14 | Edgar | Illinois | 17045 | 104 | 3 |
531809 | 531809 | 2020-09-14 | Edwards | Illinois | 17047 | 55 | 0 |
531810 | 531810 | 2020-09-14 | Effingham | Illinois | 17049 | 751 | 1 |
531811 | 531811 | 2020-09-14 | Fayette | Illinois | 17051 | 260 | 3 |
531812 | 531812 | 2020-09-14 | Ford | Illinois | 17053 | 90 | 4 |
531813 | 531813 | 2020-09-14 | Franklin | Illinois | 17055 | 432 | 1 |
531814 | 531814 | 2020-09-14 | Fulton | Illinois | 17057 | 125 | 0 |
531815 | 531815 | 2020-09-14 | Gallatin | Illinois | 17059 | 68 | 2 |
531816 | 531816 | 2020-09-14 | Greene | Illinois | 17061 | 183 | 2 |
531817 | 531817 | 2020-09-14 | Grundy | Illinois | 17063 | 586 | 5 |
531818 | 531818 | 2020-09-14 | Hamilton | Illinois | 17065 | 53 | 0 |
531819 | 531819 | 2020-09-14 | Hancock | Illinois | 17067 | 170 | 2 |
531820 | 531820 | 2020-09-14 | Hardin | Illinois | 17069 | 26 | 0 |
531821 | 531821 | 2020-09-14 | Henderson | Illinois | 17071 | 60 | 0 |
531822 | 531822 | 2020-09-14 | Henry | Illinois | 17073 | 580 | 4 |
531823 | 531823 | 2020-09-14 | Iroquois | Illinois | 17075 | 336 | 19 |
531824 | 531824 | 2020-09-14 | Jackson | Illinois | 17077 | 1159 | 24 |
531825 | 531825 | 2020-09-14 | Jasper | Illinois | 17079 | 180 | 7 |
531826 | 531826 | 2020-09-14 | Jefferson | Illinois | 17081 | 519 | 37 |
531827 | 531827 | 2020-09-14 | Jersey | Illinois | 17083 | 360 | 12 |
531828 | 531828 | 2020-09-14 | Jo Daviess | Illinois | 17085 | 215 | 2 |
531829 | 531829 | 2020-09-14 | Johnson | Illinois | 17087 | 130 | 0 |
531830 | 531830 | 2020-09-14 | Kane | Illinois | 17089 | 12188 | 325 |
531831 | 531831 | 2020-09-14 | Kankakee | Illinois | 17091 | 2574 | 72 |
531832 | 531832 | 2020-09-14 | Kendall | Illinois | 17093 | 1867 | 26 |
531833 | 531833 | 2020-09-14 | Knox | Illinois | 17095 | 527 | 3 |
531834 | 531834 | 2020-09-14 | LaSalle | Illinois | 17099 | 1508 | 54 |
531835 | 531835 | 2020-09-14 | Lake | Illinois | 17097 | 15832 | 481 |
531836 | 531836 | 2020-09-14 | Lawrence | Illinois | 17101 | 235 | 0 |
531837 | 531837 | 2020-09-14 | Lee | Illinois | 17103 | 303 | 1 |
531838 | 531838 | 2020-09-14 | Livingston | Illinois | 17105 | 270 | 4 |
531839 | 531839 | 2020-09-14 | Logan | Illinois | 17107 | 390 | 1 |
531840 | 531840 | 2020-09-14 | Macon | Illinois | 17115 | 1229 | 32 |
531841 | 531841 | 2020-09-14 | Macoupin | Illinois | 17117 | 435 | 6 |
531842 | 531842 | 2020-09-14 | Madison | Illinois | 17119 | 4965 | 121 |
531843 | 531843 | 2020-09-14 | Marion | Illinois | 17121 | 436 | 0 |
531844 | 531844 | 2020-09-14 | Marshall | Illinois | 17123 | 74 | 0 |
531845 | 531845 | 2020-09-14 | Mason | Illinois | 17125 | 109 | 1 |
531846 | 531846 | 2020-09-14 | Massac | Illinois | 17127 | 85 | 1 |
531847 | 531847 | 2020-09-14 | McDonough | Illinois | 17109 | 404 | 15 |
531848 | 531848 | 2020-09-14 | McHenry | Illinois | 17111 | 4342 | 119 |
531849 | 531849 | 2020-09-14 | McLean | Illinois | 17113 | 2931 | 18 |
531850 | 531850 | 2020-09-14 | Menard | Illinois | 17129 | 98 | 0 |
531851 | 531851 | 2020-09-14 | Mercer | Illinois | 17131 | 118 | 5 |
531852 | 531852 | 2020-09-14 | Monroe | Illinois | 17133 | 581 | 15 |
531853 | 531853 | 2020-09-14 | Montgomery | Illinois | 17135 | 288 | 11 |
531854 | 531854 | 2020-09-14 | Morgan | Illinois | 17137 | 615 | 21 |
531855 | 531855 | 2020-09-14 | Moultrie | Illinois | 17139 | 196 | 3 |
531856 | 531856 | 2020-09-14 | Ogle | Illinois | 17141 | 592 | 5 |
531857 | 531857 | 2020-09-14 | Peoria | Illinois | 17143 | 2954 | 44 |
531858 | 531858 | 2020-09-14 | Perry | Illinois | 17145 | 323 | 13 |
531859 | 531859 | 2020-09-14 | Piatt | Illinois | 17147 | 120 | 0 |
531860 | 531860 | 2020-09-14 | Pike | Illinois | 17149 | 101 | 1 |
531861 | 531861 | 2020-09-14 | Pope | Illinois | 17151 | 23 | 1 |
531862 | 531862 | 2020-09-14 | Pulaski | Illinois | 17153 | 148 | 1 |
531863 | 531863 | 2020-09-14 | Putnam | Illinois | 17155 | 31 | 0 |
531864 | 531864 | 2020-09-14 | Randolph | Illinois | 17157 | 863 | 9 |
531865 | 531865 | 2020-09-14 | Richland | Illinois | 17159 | 117 | 4 |
531866 | 531866 | 2020-09-14 | Rock Island | Illinois | 17161 | 2705 | 74 |
531867 | 531867 | 2020-09-14 | Saline | Illinois | 17165 | 213 | 3 |
531868 | 531868 | 2020-09-14 | Sangamon | Illinois | 17167 | 2142 | 44 |
531869 | 531869 | 2020-09-14 | Schuyler | Illinois | 17169 | 34 | 0 |
531870 | 531870 | 2020-09-14 | Scott | Illinois | 17171 | 62 | 0 |
531871 | 531871 | 2020-09-14 | Shelby | Illinois | 17173 | 310 | 3 |
531872 | 531872 | 2020-09-14 | St. Clair | Illinois | 17163 | 6704 | 180 |
531873 | 531873 | 2020-09-14 | Stark | Illinois | 17175 | 46 | 1 |
531874 | 531874 | 2020-09-14 | Stephenson | Illinois | 17177 | 431 | 6 |
531875 | 531875 | 2020-09-14 | Tazewell | Illinois | 17179 | 1397 | 16 |
531876 | 531876 | 2020-09-14 | Union | Illinois | 17181 | 473 | 24 |
531877 | 531877 | 2020-09-14 | Unknown | Illinois | 2028 | 232 | |
531878 | 531878 | 2020-09-14 | Vermilion | Illinois | 17183 | 475 | 4 |
531879 | 531879 | 2020-09-14 | Wabash | Illinois | 17185 | 133 | 1 |
531880 | 531880 | 2020-09-14 | Warren | Illinois | 17187 | 282 | 1 |
531881 | 531881 | 2020-09-14 | Washington | Illinois | 17189 | 158 | 1 |
531882 | 531882 | 2020-09-14 | Wayne | Illinois | 17191 | 219 | 4 |
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);