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 741
- 17089 695
- 17111 695
- 17097 694
- 17163 692
- 17167 692
- 17203 692
- 17035 691
- 17043 691
- 17195 691
- 17201 691
- 17027 690
- 17197 690
- 17143 689
- 17189 688
- 17199 688
- 17077 687
- 17091 687
- 17093 687
- 17099 687
- 17119 687
- 17001 685
- 17021 685
- 17113 685
- 17037 684
- 17177 684
- 17019 683
- 17085 683
- 17105 683
- 17161 683
- …
county >30
- Cook 741
- Kane 695
- McHenry 695
- Lake 694
- Sangamon 692
- St. Clair 692
- Woodford 692
- Cumberland 691
- DuPage 691
- Whiteside 691
- Winnebago 691
- Clinton 690
- Will 690
- Peoria 689
- Washington 688
- Williamson 688
- Jackson 687
- Kankakee 687
- Kendall 687
- LaSalle 687
- Madison 687
- Adams 685
- Christian 685
- McLean 685
- DeKalb 684
- Stephenson 684
- Champaign 683
- Jo Daviess 683
- Livingston 683
- Rock Island 683
- …
state 1
- Illinois · 69,224 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2178131 | 2178131 | 2022-02-03 | Saline | Illinois | 17165 | 7358 | 100 |
2178132 | 2178132 | 2022-02-03 | Sangamon | Illinois | 17167 | 52515 | 387 |
2178133 | 2178133 | 2022-02-03 | Schuyler | Illinois | 17169 | 1905 | 28 |
2178134 | 2178134 | 2022-02-03 | Scott | Illinois | 17171 | 1228 | 10 |
2178135 | 2178135 | 2022-02-03 | Shelby | Illinois | 17173 | 5920 | 67 |
2178136 | 2178136 | 2022-02-03 | St. Clair | Illinois | 17163 | 66540 | 735 |
2178137 | 2178137 | 2022-02-03 | Stark | Illinois | 17175 | 1436 | 31 |
2178138 | 2178138 | 2022-02-03 | Stephenson | Illinois | 17177 | 10968 | 167 |
2178139 | 2178139 | 2022-02-03 | Tazewell | Illinois | 17179 | 35220 | 470 |
2178140 | 2178140 | 2022-02-03 | Union | Illinois | 17181 | 5112 | 65 |
2178141 | 2178141 | 2022-02-03 | Unknown | Illinois | 0 | 1799 | |
2178142 | 2178142 | 2022-02-03 | Vermilion | Illinois | 17183 | 27049 | 284 |
2178143 | 2178143 | 2022-02-03 | Wabash | Illinois | 17185 | 3596 | 23 |
2178144 | 2178144 | 2022-02-03 | Warren | Illinois | 17187 | 3842 | 81 |
2178145 | 2178145 | 2022-02-03 | Washington | Illinois | 17189 | 3319 | 39 |
2178146 | 2178146 | 2022-02-03 | Wayne | Illinois | 17191 | 5021 | 75 |
2178147 | 2178147 | 2022-02-03 | White | Illinois | 17193 | 4173 | 49 |
2178148 | 2178148 | 2022-02-03 | Whiteside | Illinois | 17195 | 14524 | 256 |
2178149 | 2178149 | 2022-02-03 | Will | Illinois | 17197 | 156064 | 1472 |
2178150 | 2178150 | 2022-02-03 | Williamson | Illinois | 17199 | 21385 | 241 |
2178151 | 2178151 | 2022-02-03 | Winnebago | Illinois | 17201 | 73421 | 789 |
2178152 | 2178152 | 2022-02-03 | Woodford | Illinois | 17203 | 9959 | 118 |
2174797 | 2174797 | 2022-02-02 | Adams | Illinois | 17001 | 21360 | 219 |
2174798 | 2174798 | 2022-02-02 | Alexander | Illinois | 17003 | 1231 | 13 |
2174799 | 2174799 | 2022-02-02 | Bond | Illinois | 17005 | 4162 | 34 |
2174800 | 2174800 | 2022-02-02 | Boone | Illinois | 17007 | 13210 | 115 |
2174801 | 2174801 | 2022-02-02 | Brown | Illinois | 17009 | 2315 | 19 |
2174802 | 2174802 | 2022-02-02 | Bureau | Illinois | 17011 | 7987 | 135 |
2174803 | 2174803 | 2022-02-02 | Calhoun | Illinois | 17013 | 1490 | 7 |
2174804 | 2174804 | 2022-02-02 | Carroll | Illinois | 17015 | 3893 | 46 |
2174805 | 2174805 | 2022-02-02 | Cass | Illinois | 17017 | 4475 | 43 |
2174806 | 2174806 | 2022-02-02 | Champaign | Illinois | 17019 | 59144 | 273 |
2174807 | 2174807 | 2022-02-02 | Christian | Illinois | 17021 | 9613 | 121 |
2174808 | 2174808 | 2022-02-02 | Clark | Illinois | 17023 | 4560 | 55 |
2174809 | 2174809 | 2022-02-02 | Clay | Illinois | 17025 | 4532 | 67 |
2174810 | 2174810 | 2022-02-02 | Clinton | Illinois | 17027 | 11480 | 119 |
2174811 | 2174811 | 2022-02-02 | Coles | Illinois | 17029 | 14627 | 158 |
2174812 | 2174812 | 2022-02-02 | Cook | Illinois | 17031 | 1084468 | 13988 |
2174813 | 2174813 | 2022-02-02 | Crawford | Illinois | 17033 | 5906 | 55 |
2174814 | 2174814 | 2022-02-02 | Cumberland | Illinois | 17035 | 3245 | 48 |
2174815 | 2174815 | 2022-02-02 | De Witt | Illinois | 17039 | 4195 | 40 |
2174816 | 2174816 | 2022-02-02 | DeKalb | Illinois | 17037 | 22002 | 188 |
2174817 | 2174817 | 2022-02-02 | Douglas | Illinois | 17041 | 6276 | 56 |
2174818 | 2174818 | 2022-02-02 | DuPage | Illinois | 17043 | 198539 | 1679 |
2174819 | 2174819 | 2022-02-02 | Edgar | Illinois | 17045 | 4926 | 76 |
2174820 | 2174820 | 2022-02-02 | Edwards | Illinois | 17047 | 1723 | 26 |
2174821 | 2174821 | 2022-02-02 | Effingham | Illinois | 17049 | 10302 | 137 |
2174822 | 2174822 | 2022-02-02 | Fayette | Illinois | 17051 | 6834 | 92 |
2174823 | 2174823 | 2022-02-02 | Ford | Illinois | 17053 | 4252 | 70 |
2174824 | 2174824 | 2022-02-02 | Franklin | Illinois | 17055 | 11738 | 162 |
2174825 | 2174825 | 2022-02-02 | Fulton | Illinois | 17057 | 9579 | 119 |
2174826 | 2174826 | 2022-02-02 | Gallatin | Illinois | 17059 | 1283 | 13 |
2174827 | 2174827 | 2022-02-02 | Greene | Illinois | 17061 | 3498 | 55 |
2174828 | 2174828 | 2022-02-02 | Grundy | Illinois | 17063 | 12214 | 129 |
2174829 | 2174829 | 2022-02-02 | Hamilton | Illinois | 17065 | 2078 | 31 |
2174830 | 2174830 | 2022-02-02 | Hancock | Illinois | 17067 | 4144 | 53 |
2174831 | 2174831 | 2022-02-02 | Hardin | Illinois | 17069 | 1012 | 18 |
2174832 | 2174832 | 2022-02-02 | Henderson | Illinois | 17071 | 1087 | 26 |
2174833 | 2174833 | 2022-02-02 | Henry | Illinois | 17073 | 12042 | 139 |
2174834 | 2174834 | 2022-02-02 | Iroquois | Illinois | 17075 | 6900 | 106 |
2174835 | 2174835 | 2022-02-02 | Jackson | Illinois | 17077 | 14732 | 116 |
2174836 | 2174836 | 2022-02-02 | Jasper | Illinois | 17079 | 2583 | 26 |
2174837 | 2174837 | 2022-02-02 | Jefferson | Illinois | 17081 | 10466 | 162 |
2174838 | 2174838 | 2022-02-02 | Jersey | Illinois | 17083 | 6038 | 81 |
2174839 | 2174839 | 2022-02-02 | Jo Daviess | Illinois | 17085 | 3789 | 36 |
2174840 | 2174840 | 2022-02-02 | Johnson | Illinois | 17087 | 3985 | 44 |
2174841 | 2174841 | 2022-02-02 | Kane | Illinois | 17089 | 119863 | 1093 |
2174842 | 2174842 | 2022-02-02 | Kankakee | Illinois | 17091 | 27981 | 353 |
2174843 | 2174843 | 2022-02-02 | Kendall | Illinois | 17093 | 29304 | 152 |
2174844 | 2174844 | 2022-02-02 | Knox | Illinois | 17095 | 12035 | 230 |
2174845 | 2174845 | 2022-02-02 | LaSalle | Illinois | 17099 | 27644 | 416 |
2174846 | 2174846 | 2022-02-02 | Lake | Illinois | 17097 | 141359 | 1316 |
2174847 | 2174847 | 2022-02-02 | Lawrence | Illinois | 17101 | 5257 | 49 |
2174848 | 2174848 | 2022-02-02 | Lee | Illinois | 17103 | 8305 | 113 |
2174849 | 2174849 | 2022-02-02 | Livingston | Illinois | 17105 | 10292 | 139 |
2174850 | 2174850 | 2022-02-02 | Logan | Illinois | 17107 | 9060 | 96 |
2174851 | 2174851 | 2022-02-02 | Macon | Illinois | 17115 | 29356 | 327 |
2174852 | 2174852 | 2022-02-02 | Macoupin | Illinois | 17117 | 12262 | 157 |
2174853 | 2174853 | 2022-02-02 | Madison | Illinois | 17119 | 67788 | 802 |
2174854 | 2174854 | 2022-02-02 | Marion | Illinois | 17121 | 11360 | 196 |
2174855 | 2174855 | 2022-02-02 | Marshall | Illinois | 17123 | 2639 | 31 |
2174856 | 2174856 | 2022-02-02 | Mason | Illinois | 17125 | 3719 | 60 |
2174857 | 2174857 | 2022-02-02 | Massac | Illinois | 17127 | 3633 | 67 |
2174858 | 2174858 | 2022-02-02 | McDonough | Illinois | 17109 | 6743 | 92 |
2174859 | 2174859 | 2022-02-02 | McHenry | Illinois | 17111 | 70588 | 454 |
2174860 | 2174860 | 2022-02-02 | McLean | Illinois | 17113 | 47237 | 306 |
2174861 | 2174861 | 2022-02-02 | Menard | Illinois | 17129 | 3388 | 22 |
2174862 | 2174862 | 2022-02-02 | Mercer | Illinois | 17131 | 3830 | 41 |
2174863 | 2174863 | 2022-02-02 | Monroe | Illinois | 17133 | 9150 | 120 |
2174864 | 2174864 | 2022-02-02 | Montgomery | Illinois | 17135 | 9231 | 100 |
2174865 | 2174865 | 2022-02-02 | Morgan | Illinois | 17137 | 8997 | 133 |
2174866 | 2174866 | 2022-02-02 | Moultrie | Illinois | 17139 | 3940 | 50 |
2174867 | 2174867 | 2022-02-02 | Ogle | Illinois | 17141 | 13299 | 134 |
2174868 | 2174868 | 2022-02-02 | Peoria | Illinois | 17143 | 44650 | 524 |
2174869 | 2174869 | 2022-02-02 | Perry | Illinois | 17145 | 7048 | 99 |
2174870 | 2174870 | 2022-02-02 | Piatt | Illinois | 17147 | 4186 | 27 |
2174871 | 2174871 | 2022-02-02 | Pike | Illinois | 17149 | 4855 | 66 |
2174872 | 2174872 | 2022-02-02 | Pope | Illinois | 17151 | 920 | 7 |
2174873 | 2174873 | 2022-02-02 | Pulaski | Illinois | 17153 | 1663 | 16 |
2174874 | 2174874 | 2022-02-02 | Putnam | Illinois | 17155 | 1089 | 8 |
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);