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 358
- 17089 312
- 17111 312
- 17097 311
- 17035 308
- 17043 308
- 17163 308
- 17167 308
- 17203 308
- 17027 307
- 17195 307
- 17201 307
- 17143 306
- 17197 306
- 17077 304
- 17091 304
- 17093 304
- 17099 304
- 17119 304
- 17189 304
- 17199 304
- 17001 302
- 17021 302
- 17113 302
- 17037 301
- 17019 300
- 17085 300
- 17105 300
- 17161 300
- 17177 300
- …
county >30
- Cook 358
- Kane 312
- McHenry 312
- Lake 311
- Cumberland 308
- DuPage 308
- Sangamon 308
- St. Clair 308
- Woodford 308
- Clinton 307
- Whiteside 307
- Winnebago 307
- Peoria 306
- Will 306
- Jackson 304
- Kankakee 304
- Kendall 304
- LaSalle 304
- Madison 304
- Washington 304
- Williamson 304
- Adams 302
- Christian 302
- McLean 302
- DeKalb 301
- Champaign 300
- Jo Daviess 300
- Livingston 300
- Rock Island 300
- Stephenson 300
- …
state 1
- Illinois · 29,767 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930774 | 930774 | 2021-01-15 | Adams | Illinois | 17001 | 7314 | 114 |
930775 | 930775 | 2021-01-15 | Alexander | Illinois | 17003 | 380 | 7 |
930776 | 930776 | 2021-01-15 | Bond | Illinois | 17005 | 1720 | 23 |
930777 | 930777 | 2021-01-15 | Boone | Illinois | 17007 | 5490 | 77 |
930778 | 930778 | 2021-01-15 | Brown | Illinois | 17009 | 599 | 11 |
930779 | 930779 | 2021-01-15 | Bureau | Illinois | 17011 | 2985 | 82 |
930780 | 930780 | 2021-01-15 | Calhoun | Illinois | 17013 | 435 | 4 |
930781 | 930781 | 2021-01-15 | Carroll | Illinois | 17015 | 1418 | 32 |
930782 | 930782 | 2021-01-15 | Cass | Illinois | 17017 | 1730 | 31 |
930783 | 930783 | 2021-01-15 | Champaign | Illinois | 17019 | 15239 | 95 |
930784 | 930784 | 2021-01-15 | Christian | Illinois | 17021 | 2953 | 73 |
930785 | 930785 | 2021-01-15 | Clark | Illinois | 17023 | 1446 | 28 |
930786 | 930786 | 2021-01-15 | Clay | Illinois | 17025 | 1301 | 38 |
930787 | 930787 | 2021-01-15 | Clinton | Illinois | 17027 | 4953 | 84 |
930788 | 930788 | 2021-01-15 | Coles | Illinois | 17029 | 4663 | 79 |
930789 | 930789 | 2021-01-15 | Cook | Illinois | 17031 | 429270 | 8939 |
930790 | 930790 | 2021-01-15 | Crawford | Illinois | 17033 | 1734 | 34 |
930791 | 930791 | 2021-01-15 | Cumberland | Illinois | 17035 | 1064 | 27 |
930792 | 930792 | 2021-01-15 | De Witt | Illinois | 17039 | 1120 | 26 |
930793 | 930793 | 2021-01-15 | DeKalb | Illinois | 17037 | 7469 | 90 |
930794 | 930794 | 2021-01-15 | Douglas | Illinois | 17041 | 1986 | 33 |
930795 | 930795 | 2021-01-15 | DuPage | Illinois | 17043 | 68156 | 1136 |
930796 | 930796 | 2021-01-15 | Edgar | Illinois | 17045 | 1425 | 52 |
930797 | 930797 | 2021-01-15 | Edwards | Illinois | 17047 | 461 | 9 |
930798 | 930798 | 2021-01-15 | Effingham | Illinois | 17049 | 4279 | 68 |
930799 | 930799 | 2021-01-15 | Fayette | Illinois | 17051 | 2885 | 53 |
930800 | 930800 | 2021-01-15 | Ford | Illinois | 17053 | 1366 | 49 |
930801 | 930801 | 2021-01-15 | Franklin | Illinois | 17055 | 3783 | 67 |
930802 | 930802 | 2021-01-15 | Fulton | Illinois | 17057 | 2530 | 48 |
930803 | 930803 | 2021-01-15 | Gallatin | Illinois | 17059 | 380 | 4 |
930804 | 930804 | 2021-01-15 | Greene | Illinois | 17061 | 1249 | 42 |
930805 | 930805 | 2021-01-15 | Grundy | Illinois | 17063 | 4290 | 54 |
930806 | 930806 | 2021-01-15 | Hamilton | Illinois | 17065 | 709 | 16 |
930807 | 930807 | 2021-01-15 | Hancock | Illinois | 17067 | 1460 | 32 |
930808 | 930808 | 2021-01-15 | Hardin | Illinois | 17069 | 298 | 8 |
930809 | 930809 | 2021-01-15 | Henderson | Illinois | 17071 | 445 | 16 |
930810 | 930810 | 2021-01-15 | Henry | Illinois | 17073 | 3976 | 75 |
930811 | 930811 | 2021-01-15 | Iroquois | Illinois | 17075 | 2557 | 55 |
930812 | 930812 | 2021-01-15 | Jackson | Illinois | 17077 | 4107 | 67 |
930813 | 930813 | 2021-01-15 | Jasper | Illinois | 17079 | 1019 | 16 |
930814 | 930814 | 2021-01-15 | Jefferson | Illinois | 17081 | 3356 | 102 |
930815 | 930815 | 2021-01-15 | Jersey | Illinois | 17083 | 2172 | 52 |
930816 | 930816 | 2021-01-15 | Jo Daviess | Illinois | 17085 | 1474 | 24 |
930817 | 930817 | 2021-01-15 | Johnson | Illinois | 17087 | 1208 | 15 |
930818 | 930818 | 2021-01-15 | Kane | Illinois | 17089 | 45300 | 667 |
930819 | 930819 | 2021-01-15 | Kankakee | Illinois | 17091 | 11393 | 177 |
930820 | 930820 | 2021-01-15 | Kendall | Illinois | 17093 | 9681 | 77 |
930821 | 930821 | 2021-01-15 | Knox | Illinois | 17095 | 4531 | 140 |
930822 | 930822 | 2021-01-15 | LaSalle | Illinois | 17099 | 9271 | 247 |
930823 | 930823 | 2021-01-15 | Lake | Illinois | 17097 | 52591 | 877 |
930824 | 930824 | 2021-01-15 | Lawrence | Illinois | 17101 | 2151 | 30 |
930825 | 930825 | 2021-01-15 | Lee | Illinois | 17103 | 3003 | 72 |
930826 | 930826 | 2021-01-15 | Livingston | Illinois | 17105 | 3579 | 66 |
930827 | 930827 | 2021-01-15 | Logan | Illinois | 17107 | 3042 | 56 |
930828 | 930828 | 2021-01-15 | Macon | Illinois | 17115 | 8701 | 178 |
930829 | 930829 | 2021-01-15 | Macoupin | Illinois | 17117 | 3772 | 94 |
930830 | 930830 | 2021-01-15 | Madison | Illinois | 17119 | 23853 | 455 |
930831 | 930831 | 2021-01-15 | Marion | Illinois | 17121 | 3923 | 111 |
930832 | 930832 | 2021-01-15 | Marshall | Illinois | 17123 | 652 | 13 |
930833 | 930833 | 2021-01-15 | Mason | Illinois | 17125 | 1155 | 40 |
930834 | 930834 | 2021-01-15 | Massac | Illinois | 17127 | 1004 | 30 |
930835 | 930835 | 2021-01-15 | McDonough | Illinois | 17109 | 2114 | 50 |
930836 | 930836 | 2021-01-15 | McHenry | Illinois | 17111 | 21268 | 244 |
930837 | 930837 | 2021-01-15 | McLean | Illinois | 17113 | 13013 | 156 |
930838 | 930838 | 2021-01-15 | Menard | Illinois | 17129 | 853 | 10 |
930839 | 930839 | 2021-01-15 | Mercer | Illinois | 17131 | 1161 | 28 |
930840 | 930840 | 2021-01-15 | Monroe | Illinois | 17133 | 3517 | 68 |
930841 | 930841 | 2021-01-15 | Montgomery | Illinois | 17135 | 2970 | 37 |
930842 | 930842 | 2021-01-15 | Morgan | Illinois | 17137 | 3306 | 90 |
930843 | 930843 | 2021-01-15 | Moultrie | Illinois | 17139 | 1352 | 28 |
930844 | 930844 | 2021-01-15 | Ogle | Illinois | 17141 | 4554 | 70 |
930845 | 930845 | 2021-01-15 | Peoria | Illinois | 17143 | 14800 | 235 |
930846 | 930846 | 2021-01-15 | Perry | Illinois | 17145 | 2613 | 60 |
930847 | 930847 | 2021-01-15 | Piatt | Illinois | 17147 | 1159 | 16 |
930848 | 930848 | 2021-01-15 | Pike | Illinois | 17149 | 1529 | 45 |
930849 | 930849 | 2021-01-15 | Pope | Illinois | 17151 | 240 | 2 |
930850 | 930850 | 2021-01-15 | Pulaski | Illinois | 17153 | 605 | 3 |
930851 | 930851 | 2021-01-15 | Putnam | Illinois | 17155 | 345 | 1 |
930852 | 930852 | 2021-01-15 | Randolph | Illinois | 17157 | 3665 | 66 |
930853 | 930853 | 2021-01-15 | Richland | Illinois | 17159 | 1510 | 44 |
930854 | 930854 | 2021-01-15 | Rock Island | Illinois | 17161 | 11752 | 301 |
930855 | 930855 | 2021-01-15 | Saline | Illinois | 17165 | 1998 | 53 |
930856 | 930856 | 2021-01-15 | Sangamon | Illinois | 17167 | 14299 | 232 |
930857 | 930857 | 2021-01-15 | Schuyler | Illinois | 17169 | 612 | 16 |
930858 | 930858 | 2021-01-15 | Scott | Illinois | 17171 | 367 | 1 |
930859 | 930859 | 2021-01-15 | Shelby | Illinois | 17173 | 1950 | 35 |
930860 | 930860 | 2021-01-15 | St. Clair | Illinois | 17163 | 24023 | 415 |
930861 | 930861 | 2021-01-15 | Stark | Illinois | 17175 | 492 | 20 |
930862 | 930862 | 2021-01-15 | Stephenson | Illinois | 17177 | 3488 | 74 |
930863 | 930863 | 2021-01-15 | Tazewell | Illinois | 17179 | 11822 | 242 |
930864 | 930864 | 2021-01-15 | Union | Illinois | 17181 | 1957 | 32 |
930865 | 930865 | 2021-01-15 | Vermilion | Illinois | 17183 | 7325 | 110 |
930866 | 930866 | 2021-01-15 | Wabash | Illinois | 17185 | 1162 | 14 |
930867 | 930867 | 2021-01-15 | Warren | Illinois | 17187 | 1575 | 43 |
930868 | 930868 | 2021-01-15 | Washington | Illinois | 17189 | 1432 | 25 |
930869 | 930869 | 2021-01-15 | Wayne | Illinois | 17191 | 1487 | 43 |
930870 | 930870 | 2021-01-15 | White | Illinois | 17193 | 1314 | 29 |
930871 | 930871 | 2021-01-15 | Whiteside | Illinois | 17195 | 5323 | 173 |
930872 | 930872 | 2021-01-15 | Will | Illinois | 17197 | 57429 | 861 |
930873 | 930873 | 2021-01-15 | Williamson | Illinois | 17199 | 6102 | 114 |
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);