ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-11-23" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1943947 | 1943947 | 2021-11-23 | Adams | Illinois | 17001 | 14111 | 187 |
1943948 | 1943948 | 2021-11-23 | Alexander | Illinois | 17003 | 800 | 13 |
1943949 | 1943949 | 2021-11-23 | Bond | Illinois | 17005 | 2694 | 34 |
1943950 | 1943950 | 2021-11-23 | Boone | Illinois | 17007 | 8482 | 96 |
1943951 | 1943951 | 2021-11-23 | Brown | Illinois | 17009 | 1096 | 18 |
1943952 | 1943952 | 2021-11-23 | Bureau | Illinois | 17011 | 4805 | 110 |
1943953 | 1943953 | 2021-11-23 | Calhoun | Illinois | 17013 | 760 | 5 |
1943954 | 1943954 | 2021-11-23 | Carroll | Illinois | 17015 | 2590 | 42 |
1943955 | 1943955 | 2021-11-23 | Cass | Illinois | 17017 | 2745 | 40 |
1943956 | 1943956 | 2021-11-23 | Champaign | Illinois | 17019 | 29129 | 212 |
1943957 | 1943957 | 2021-11-23 | Christian | Illinois | 17021 | 5685 | 101 |
1943958 | 1943958 | 2021-11-23 | Clark | Illinois | 17023 | 2897 | 50 |
1943959 | 1943959 | 2021-11-23 | Clay | Illinois | 17025 | 2791 | 59 |
1943960 | 1943960 | 2021-11-23 | Clinton | Illinois | 17027 | 7368 | 114 |
1943961 | 1943961 | 2021-11-23 | Coles | Illinois | 17029 | 8455 | 136 |
1943962 | 1943962 | 2021-11-23 | Cook | Illinois | 17031 | 668246 | 12003 |
1943963 | 1943963 | 2021-11-23 | Crawford | Illinois | 17033 | 3497 | 47 |
1943964 | 1943964 | 2021-11-23 | Cumberland | Illinois | 17035 | 2032 | 39 |
1943965 | 1943965 | 2021-11-23 | De Witt | Illinois | 17039 | 2334 | 37 |
1943966 | 1943966 | 2021-11-23 | DeKalb | Illinois | 17037 | 13428 | 144 |
1943967 | 1943967 | 2021-11-23 | Douglas | Illinois | 17041 | 3470 | 44 |
1943968 | 1943968 | 2021-11-23 | DuPage | Illinois | 17043 | 115663 | 1488 |
1943969 | 1943969 | 2021-11-23 | Edgar | Illinois | 17045 | 2815 | 70 |
1943970 | 1943970 | 2021-11-23 | Edwards | Illinois | 17047 | 1114 | 20 |
1943971 | 1943971 | 2021-11-23 | Effingham | Illinois | 17049 | 7039 | 117 |
1943972 | 1943972 | 2021-11-23 | Fayette | Illinois | 17051 | 4567 | 72 |
1943973 | 1943973 | 2021-11-23 | Ford | Illinois | 17053 | 2619 | 67 |
1943974 | 1943974 | 2021-11-23 | Franklin | Illinois | 17055 | 7600 | 130 |
1943975 | 1943975 | 2021-11-23 | Fulton | Illinois | 17057 | 5534 | 93 |
1943976 | 1943976 | 2021-11-23 | Gallatin | Illinois | 17059 | 815 | 10 |
1943977 | 1943977 | 2021-11-23 | Greene | Illinois | 17061 | 2139 | 53 |
1943978 | 1943978 | 2021-11-23 | Grundy | Illinois | 17063 | 7980 | 94 |
1943979 | 1943979 | 2021-11-23 | Hamilton | Illinois | 17065 | 1400 | 26 |
1943980 | 1943980 | 2021-11-23 | Hancock | Illinois | 17067 | 2981 | 45 |
1943981 | 1943981 | 2021-11-23 | Hardin | Illinois | 17069 | 655 | 16 |
1943982 | 1943982 | 2021-11-23 | Henderson | Illinois | 17071 | 804 | 23 |
1943983 | 1943983 | 2021-11-23 | Henry | Illinois | 17073 | 7139 | 111 |
1943984 | 1943984 | 2021-11-23 | Iroquois | Illinois | 17075 | 4530 | 84 |
1943985 | 1943985 | 2021-11-23 | Jackson | Illinois | 17077 | 8328 | 106 |
1943986 | 1943986 | 2021-11-23 | Jasper | Illinois | 17079 | 1704 | 23 |
1943987 | 1943987 | 2021-11-23 | Jefferson | Illinois | 17081 | 6875 | 148 |
1943988 | 1943988 | 2021-11-23 | Jersey | Illinois | 17083 | 3618 | 73 |
1943989 | 1943989 | 2021-11-23 | Jo Daviess | Illinois | 17085 | 2503 | 32 |
1943990 | 1943990 | 2021-11-23 | Johnson | Illinois | 17087 | 2423 | 38 |
1943991 | 1943991 | 2021-11-23 | Kane | Illinois | 17089 | 72344 | 950 |
1943992 | 1943992 | 2021-11-23 | Kankakee | Illinois | 17091 | 19130 | 272 |
1943993 | 1943993 | 2021-11-23 | Kendall | Illinois | 17093 | 17933 | 128 |
1943994 | 1943994 | 2021-11-23 | Knox | Illinois | 17095 | 7825 | 206 |
1943995 | 1943995 | 2021-11-23 | LaSalle | Illinois | 17099 | 15836 | 348 |
1943996 | 1943996 | 2021-11-23 | Lake | Illinois | 17097 | 85462 | 1179 |
1943997 | 1943997 | 2021-11-23 | Lawrence | Illinois | 17101 | 3462 | 45 |
1943998 | 1943998 | 2021-11-23 | Lee | Illinois | 17103 | 5047 | 104 |
1943999 | 1943999 | 2021-11-23 | Livingston | Illinois | 17105 | 6219 | 113 |
1944000 | 1944000 | 2021-11-23 | Logan | Illinois | 17107 | 5165 | 89 |
1944001 | 1944001 | 2021-11-23 | Macon | Illinois | 17115 | 16273 | 269 |
1944002 | 1944002 | 2021-11-23 | Macoupin | Illinois | 17117 | 7464 | 144 |
1944003 | 1944003 | 2021-11-23 | Madison | Illinois | 17119 | 42035 | 687 |
1944004 | 1944004 | 2021-11-23 | Marion | Illinois | 17121 | 7390 | 157 |
1944005 | 1944005 | 2021-11-23 | Marshall | Illinois | 17123 | 1496 | 25 |
1944006 | 1944006 | 2021-11-23 | Mason | Illinois | 17125 | 2240 | 54 |
1944007 | 1944007 | 2021-11-23 | Massac | Illinois | 17127 | 2282 | 57 |
1944008 | 1944008 | 2021-11-23 | McDonough | Illinois | 17109 | 3972 | 78 |
1944009 | 1944009 | 2021-11-23 | McHenry | Illinois | 17111 | 38094 | 369 |
1944010 | 1944010 | 2021-11-23 | McLean | Illinois | 17113 | 24668 | 263 |
1944011 | 1944011 | 2021-11-23 | Menard | Illinois | 17129 | 1879 | 18 |
1944012 | 1944012 | 2021-11-23 | Mercer | Illinois | 17131 | 2261 | 37 |
1944013 | 1944013 | 2021-11-23 | Monroe | Illinois | 17133 | 5510 | 105 |
1944014 | 1944014 | 2021-11-23 | Montgomery | Illinois | 17135 | 5248 | 90 |
1944015 | 1944015 | 2021-11-23 | Morgan | Illinois | 17137 | 5433 | 123 |
1944016 | 1944016 | 2021-11-23 | Moultrie | Illinois | 17139 | 2563 | 41 |
1944017 | 1944017 | 2021-11-23 | Ogle | Illinois | 17141 | 8331 | 103 |
1944018 | 1944018 | 2021-11-23 | Peoria | Illinois | 17143 | 28471 | 420 |
1944019 | 1944019 | 2021-11-23 | Perry | Illinois | 17145 | 4504 | 86 |
1944020 | 1944020 | 2021-11-23 | Piatt | Illinois | 17147 | 2230 | 20 |
1944021 | 1944021 | 2021-11-23 | Pike | Illinois | 17149 | 2806 | 61 |
1944022 | 1944022 | 2021-11-23 | Pope | Illinois | 17151 | 574 | 6 |
1944023 | 1944023 | 2021-11-23 | Pulaski | Illinois | 17153 | 1078 | 12 |
1944024 | 1944024 | 2021-11-23 | Putnam | Illinois | 17155 | 617 | 5 |
1944025 | 1944025 | 2021-11-23 | Randolph | Illinois | 17157 | 5695 | 109 |
1944026 | 1944026 | 2021-11-23 | Richland | Illinois | 17159 | 3042 | 68 |
1944027 | 1944027 | 2021-11-23 | Rock Island | Illinois | 17161 | 20343 | 417 |
1944028 | 1944028 | 2021-11-23 | Saline | Illinois | 17165 | 4494 | 87 |
1944029 | 1944029 | 2021-11-23 | Sangamon | Illinois | 17167 | 26951 | 336 |
1944030 | 1944030 | 2021-11-23 | Schuyler | Illinois | 17169 | 1157 | 24 |
1944031 | 1944031 | 2021-11-23 | Scott | Illinois | 17171 | 727 | 7 |
1944032 | 1944032 | 2021-11-23 | Shelby | Illinois | 17173 | 3790 | 54 |
1944033 | 1944033 | 2021-11-23 | St. Clair | Illinois | 17163 | 41967 | 662 |
1944034 | 1944034 | 2021-11-23 | Stark | Illinois | 17175 | 874 | 29 |
1944035 | 1944035 | 2021-11-23 | Stephenson | Illinois | 17177 | 6858 | 122 |
1944036 | 1944036 | 2021-11-23 | Tazewell | Illinois | 17179 | 21829 | 383 |
1944037 | 1944037 | 2021-11-23 | Union | Illinois | 17181 | 3231 | 54 |
1944038 | 1944038 | 2021-11-23 | Unknown | Illinois | 0 | 909 | |
1944039 | 1944039 | 2021-11-23 | Vermilion | Illinois | 17183 | 15819 | 227 |
1944040 | 1944040 | 2021-11-23 | Wabash | Illinois | 17185 | 2226 | 22 |
1944041 | 1944041 | 2021-11-23 | Warren | Illinois | 17187 | 2576 | 71 |
1944042 | 1944042 | 2021-11-23 | Washington | Illinois | 17189 | 2216 | 36 |
1944043 | 1944043 | 2021-11-23 | Wayne | Illinois | 17191 | 3210 | 66 |
1944044 | 1944044 | 2021-11-23 | White | Illinois | 17193 | 2873 | 43 |
1944045 | 1944045 | 2021-11-23 | Whiteside | Illinois | 17195 | 9023 | 230 |
1944046 | 1944046 | 2021-11-23 | Will | Illinois | 17197 | 97449 | 1232 |
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);