ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2022-04-27" 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 |
---|---|---|---|---|---|---|---|
2448066 | 2448066 | 2022-04-27 | Adams | Illinois | 17001 | 22398 | 238 |
2448067 | 2448067 | 2022-04-27 | Alexander | Illinois | 17003 | 1286 | 15 |
2448068 | 2448068 | 2022-04-27 | Bond | Illinois | 17005 | 4343 | 37 |
2448069 | 2448069 | 2022-04-27 | Boone | Illinois | 17007 | 13919 | 129 |
2448070 | 2448070 | 2022-04-27 | Brown | Illinois | 17009 | 2415 | 21 |
2448071 | 2448071 | 2022-04-27 | Bureau | Illinois | 17011 | 8387 | 140 |
2448072 | 2448072 | 2022-04-27 | Calhoun | Illinois | 17013 | 1526 | 8 |
2448073 | 2448073 | 2022-04-27 | Carroll | Illinois | 17015 | 4268 | 49 |
2448074 | 2448074 | 2022-04-27 | Cass | Illinois | 17017 | 4622 | 44 |
2448075 | 2448075 | 2022-04-27 | Champaign | Illinois | 17019 | 65055 | 296 |
2448076 | 2448076 | 2022-04-27 | Christian | Illinois | 17021 | 10266 | 129 |
2448077 | 2448077 | 2022-04-27 | Clark | Illinois | 17023 | 4861 | 60 |
2448078 | 2448078 | 2022-04-27 | Clay | Illinois | 17025 | 4743 | 74 |
2448079 | 2448079 | 2022-04-27 | Clinton | Illinois | 17027 | 11995 | 122 |
2448080 | 2448080 | 2022-04-27 | Coles | Illinois | 17029 | 15404 | 175 |
2448081 | 2448081 | 2022-04-27 | Cook | Illinois | 17031 | 1156672 | 14888 |
2448082 | 2448082 | 2022-04-27 | Crawford | Illinois | 17033 | 6210 | 61 |
2448083 | 2448083 | 2022-04-27 | Cumberland | Illinois | 17035 | 3365 | 49 |
2448084 | 2448084 | 2022-04-27 | De Witt | Illinois | 17039 | 4353 | 44 |
2448085 | 2448085 | 2022-04-27 | DeKalb | Illinois | 17037 | 23750 | 200 |
2448086 | 2448086 | 2022-04-27 | Douglas | Illinois | 17041 | 6507 | 61 |
2448087 | 2448087 | 2022-04-27 | DuPage | Illinois | 17043 | 215700 | 1796 |
2448088 | 2448088 | 2022-04-27 | Edgar | Illinois | 17045 | 5182 | 79 |
2448089 | 2448089 | 2022-04-27 | Edwards | Illinois | 17047 | 1742 | 29 |
2448090 | 2448090 | 2022-04-27 | Effingham | Illinois | 17049 | 10684 | 148 |
2448091 | 2448091 | 2022-04-27 | Fayette | Illinois | 17051 | 7119 | 104 |
2448092 | 2448092 | 2022-04-27 | Ford | Illinois | 17053 | 4443 | 74 |
2448093 | 2448093 | 2022-04-27 | Franklin | Illinois | 17055 | 12235 | 177 |
2448094 | 2448094 | 2022-04-27 | Fulton | Illinois | 17057 | 10122 | 134 |
2448095 | 2448095 | 2022-04-27 | Gallatin | Illinois | 17059 | 1407 | 18 |
2448096 | 2448096 | 2022-04-27 | Greene | Illinois | 17061 | 3616 | 58 |
2448097 | 2448097 | 2022-04-27 | Grundy | Illinois | 17063 | 12788 | 140 |
2448098 | 2448098 | 2022-04-27 | Hamilton | Illinois | 17065 | 2177 | 34 |
2448099 | 2448099 | 2022-04-27 | Hancock | Illinois | 17067 | 4389 | 58 |
2448100 | 2448100 | 2022-04-27 | Hardin | Illinois | 17069 | 1054 | 20 |
2448101 | 2448101 | 2022-04-27 | Henderson | Illinois | 17071 | 1153 | 28 |
2448102 | 2448102 | 2022-04-27 | Henry | Illinois | 17073 | 12755 | 149 |
2448103 | 2448103 | 2022-04-27 | Iroquois | Illinois | 17075 | 7217 | 117 |
2448104 | 2448104 | 2022-04-27 | Jackson | Illinois | 17077 | 15624 | 130 |
2448105 | 2448105 | 2022-04-27 | Jasper | Illinois | 17079 | 2681 | 32 |
2448106 | 2448106 | 2022-04-27 | Jefferson | Illinois | 17081 | 11117 | 176 |
2448107 | 2448107 | 2022-04-27 | Jersey | Illinois | 17083 | 6264 | 91 |
2448108 | 2448108 | 2022-04-27 | Jo Daviess | Illinois | 17085 | 4049 | 39 |
2448109 | 2448109 | 2022-04-27 | Johnson | Illinois | 17087 | 4478 | 46 |
2448110 | 2448110 | 2022-04-27 | Kane | Illinois | 17089 | 128228 | 1177 |
2448111 | 2448111 | 2022-04-27 | Kankakee | Illinois | 17091 | 28998 | 373 |
2448112 | 2448112 | 2022-04-27 | Kendall | Illinois | 17093 | 31502 | 170 |
2448113 | 2448113 | 2022-04-27 | Knox | Illinois | 17095 | 12596 | 246 |
2448114 | 2448114 | 2022-04-27 | LaSalle | Illinois | 17099 | 29159 | 439 |
2448115 | 2448115 | 2022-04-27 | Lake | Illinois | 17097 | 153214 | 1460 |
2448116 | 2448116 | 2022-04-27 | Lawrence | Illinois | 17101 | 5485 | 52 |
2448117 | 2448117 | 2022-04-27 | Lee | Illinois | 17103 | 8847 | 118 |
2448118 | 2448118 | 2022-04-27 | Livingston | Illinois | 17105 | 10793 | 148 |
2448119 | 2448119 | 2022-04-27 | Logan | Illinois | 17107 | 9627 | 100 |
2448120 | 2448120 | 2022-04-27 | Macon | Illinois | 17115 | 30733 | 354 |
2448121 | 2448121 | 2022-04-27 | Macoupin | Illinois | 17117 | 12843 | 171 |
2448122 | 2448122 | 2022-04-27 | Madison | Illinois | 17119 | 70740 | 864 |
2448123 | 2448123 | 2022-04-27 | Marion | Illinois | 17121 | 11891 | 217 |
2448124 | 2448124 | 2022-04-27 | Marshall | Illinois | 17123 | 2777 | 33 |
2448125 | 2448125 | 2022-04-27 | Mason | Illinois | 17125 | 3917 | 61 |
2448126 | 2448126 | 2022-04-27 | Massac | Illinois | 17127 | 3882 | 71 |
2448127 | 2448127 | 2022-04-27 | McDonough | Illinois | 17109 | 7240 | 104 |
2448128 | 2448128 | 2022-04-27 | McHenry | Illinois | 17111 | 77009 | 508 |
2448129 | 2448129 | 2022-04-27 | McLean | Illinois | 17113 | 50895 | 329 |
2448130 | 2448130 | 2022-04-27 | Menard | Illinois | 17129 | 3528 | 24 |
2448131 | 2448131 | 2022-04-27 | Mercer | Illinois | 17131 | 4031 | 47 |
2448132 | 2448132 | 2022-04-27 | Monroe | Illinois | 17133 | 9533 | 127 |
2448133 | 2448133 | 2022-04-27 | Montgomery | Illinois | 17135 | 9824 | 111 |
2448134 | 2448134 | 2022-04-27 | Morgan | Illinois | 17137 | 9546 | 144 |
2448135 | 2448135 | 2022-04-27 | Moultrie | Illinois | 17139 | 4078 | 52 |
2448136 | 2448136 | 2022-04-27 | Ogle | Illinois | 17141 | 14077 | 136 |
2448137 | 2448137 | 2022-04-27 | Peoria | Illinois | 17143 | 47014 | 555 |
2448138 | 2448138 | 2022-04-27 | Perry | Illinois | 17145 | 7479 | 106 |
2448139 | 2448139 | 2022-04-27 | Piatt | Illinois | 17147 | 4512 | 29 |
2448140 | 2448140 | 2022-04-27 | Pike | Illinois | 17149 | 5038 | 70 |
2448141 | 2448141 | 2022-04-27 | Pope | Illinois | 17151 | 961 | 8 |
2448142 | 2448142 | 2022-04-27 | Pulaski | Illinois | 17153 | 1725 | 19 |
2448143 | 2448143 | 2022-04-27 | Putnam | Illinois | 17155 | 1149 | 10 |
2448144 | 2448144 | 2022-04-27 | Randolph | Illinois | 17157 | 10498 | 131 |
2448145 | 2448145 | 2022-04-27 | Richland | Illinois | 17159 | 5161 | 83 |
2448146 | 2448146 | 2022-04-27 | Rock Island | Illinois | 17161 | 33342 | 521 |
2448147 | 2448147 | 2022-04-27 | Saline | Illinois | 17165 | 7886 | 111 |
2448148 | 2448148 | 2022-04-27 | Sangamon | Illinois | 17167 | 55440 | 432 |
2448149 | 2448149 | 2022-04-27 | Schuyler | Illinois | 17169 | 1963 | 29 |
2448150 | 2448150 | 2022-04-27 | Scott | Illinois | 17171 | 1264 | 12 |
2448151 | 2448151 | 2022-04-27 | Shelby | Illinois | 17173 | 6237 | 80 |
2448152 | 2448152 | 2022-04-27 | St. Clair | Illinois | 17163 | 69774 | 774 |
2448153 | 2448153 | 2022-04-27 | Stark | Illinois | 17175 | 1517 | 33 |
2448154 | 2448154 | 2022-04-27 | Stephenson | Illinois | 17177 | 11538 | 176 |
2448155 | 2448155 | 2022-04-27 | Tazewell | Illinois | 17179 | 37006 | 498 |
2448156 | 2448156 | 2022-04-27 | Union | Illinois | 17181 | 5381 | 68 |
2448157 | 2448157 | 2022-04-27 | Unknown | Illinois | 0 | 2259 | |
2448158 | 2448158 | 2022-04-27 | Vermilion | Illinois | 17183 | 28040 | 313 |
2448159 | 2448159 | 2022-04-27 | Wabash | Illinois | 17185 | 3716 | 31 |
2448160 | 2448160 | 2022-04-27 | Warren | Illinois | 17187 | 4043 | 87 |
2448161 | 2448161 | 2022-04-27 | Washington | Illinois | 17189 | 3437 | 41 |
2448162 | 2448162 | 2022-04-27 | Wayne | Illinois | 17191 | 5303 | 85 |
2448163 | 2448163 | 2022-04-27 | White | Illinois | 17193 | 4404 | 59 |
2448164 | 2448164 | 2022-04-27 | Whiteside | Illinois | 17195 | 15477 | 267 |
2448165 | 2448165 | 2022-04-27 | Will | Illinois | 17197 | 164820 | 1607 |
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);