ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2022-02-03" 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 |
---|---|---|---|---|---|---|---|
2178050 | 2178050 | 2022-02-03 | Adams | Illinois | 17001 | 21360 | 219 |
2178051 | 2178051 | 2022-02-03 | Alexander | Illinois | 17003 | 1231 | 13 |
2178052 | 2178052 | 2022-02-03 | Bond | Illinois | 17005 | 4162 | 34 |
2178053 | 2178053 | 2022-02-03 | Boone | Illinois | 17007 | 13210 | 115 |
2178054 | 2178054 | 2022-02-03 | Brown | Illinois | 17009 | 2315 | 19 |
2178055 | 2178055 | 2022-02-03 | Bureau | Illinois | 17011 | 7987 | 135 |
2178056 | 2178056 | 2022-02-03 | Calhoun | Illinois | 17013 | 1490 | 7 |
2178057 | 2178057 | 2022-02-03 | Carroll | Illinois | 17015 | 3893 | 46 |
2178058 | 2178058 | 2022-02-03 | Cass | Illinois | 17017 | 4475 | 43 |
2178059 | 2178059 | 2022-02-03 | Champaign | Illinois | 17019 | 59144 | 273 |
2178060 | 2178060 | 2022-02-03 | Christian | Illinois | 17021 | 9613 | 121 |
2178061 | 2178061 | 2022-02-03 | Clark | Illinois | 17023 | 4560 | 55 |
2178062 | 2178062 | 2022-02-03 | Clay | Illinois | 17025 | 4532 | 67 |
2178063 | 2178063 | 2022-02-03 | Clinton | Illinois | 17027 | 11480 | 119 |
2178064 | 2178064 | 2022-02-03 | Coles | Illinois | 17029 | 14627 | 158 |
2178065 | 2178065 | 2022-02-03 | Cook | Illinois | 17031 | 1084468 | 13988 |
2178066 | 2178066 | 2022-02-03 | Crawford | Illinois | 17033 | 5906 | 55 |
2178067 | 2178067 | 2022-02-03 | Cumberland | Illinois | 17035 | 3245 | 48 |
2178068 | 2178068 | 2022-02-03 | De Witt | Illinois | 17039 | 4195 | 40 |
2178069 | 2178069 | 2022-02-03 | DeKalb | Illinois | 17037 | 22002 | 188 |
2178070 | 2178070 | 2022-02-03 | Douglas | Illinois | 17041 | 6276 | 56 |
2178071 | 2178071 | 2022-02-03 | DuPage | Illinois | 17043 | 198539 | 1679 |
2178072 | 2178072 | 2022-02-03 | Edgar | Illinois | 17045 | 4926 | 76 |
2178073 | 2178073 | 2022-02-03 | Edwards | Illinois | 17047 | 1723 | 26 |
2178074 | 2178074 | 2022-02-03 | Effingham | Illinois | 17049 | 10302 | 137 |
2178075 | 2178075 | 2022-02-03 | Fayette | Illinois | 17051 | 6834 | 92 |
2178076 | 2178076 | 2022-02-03 | Ford | Illinois | 17053 | 4252 | 70 |
2178077 | 2178077 | 2022-02-03 | Franklin | Illinois | 17055 | 11738 | 162 |
2178078 | 2178078 | 2022-02-03 | Fulton | Illinois | 17057 | 9579 | 119 |
2178079 | 2178079 | 2022-02-03 | Gallatin | Illinois | 17059 | 1283 | 13 |
2178080 | 2178080 | 2022-02-03 | Greene | Illinois | 17061 | 3498 | 55 |
2178081 | 2178081 | 2022-02-03 | Grundy | Illinois | 17063 | 12214 | 129 |
2178082 | 2178082 | 2022-02-03 | Hamilton | Illinois | 17065 | 2078 | 31 |
2178083 | 2178083 | 2022-02-03 | Hancock | Illinois | 17067 | 4144 | 53 |
2178084 | 2178084 | 2022-02-03 | Hardin | Illinois | 17069 | 1012 | 18 |
2178085 | 2178085 | 2022-02-03 | Henderson | Illinois | 17071 | 1087 | 26 |
2178086 | 2178086 | 2022-02-03 | Henry | Illinois | 17073 | 12042 | 139 |
2178087 | 2178087 | 2022-02-03 | Iroquois | Illinois | 17075 | 6900 | 106 |
2178088 | 2178088 | 2022-02-03 | Jackson | Illinois | 17077 | 14732 | 116 |
2178089 | 2178089 | 2022-02-03 | Jasper | Illinois | 17079 | 2583 | 26 |
2178090 | 2178090 | 2022-02-03 | Jefferson | Illinois | 17081 | 10466 | 162 |
2178091 | 2178091 | 2022-02-03 | Jersey | Illinois | 17083 | 6038 | 81 |
2178092 | 2178092 | 2022-02-03 | Jo Daviess | Illinois | 17085 | 3789 | 36 |
2178093 | 2178093 | 2022-02-03 | Johnson | Illinois | 17087 | 3985 | 44 |
2178094 | 2178094 | 2022-02-03 | Kane | Illinois | 17089 | 119863 | 1093 |
2178095 | 2178095 | 2022-02-03 | Kankakee | Illinois | 17091 | 27981 | 353 |
2178096 | 2178096 | 2022-02-03 | Kendall | Illinois | 17093 | 29304 | 152 |
2178097 | 2178097 | 2022-02-03 | Knox | Illinois | 17095 | 12035 | 230 |
2178098 | 2178098 | 2022-02-03 | LaSalle | Illinois | 17099 | 27644 | 416 |
2178099 | 2178099 | 2022-02-03 | Lake | Illinois | 17097 | 141359 | 1316 |
2178100 | 2178100 | 2022-02-03 | Lawrence | Illinois | 17101 | 5257 | 49 |
2178101 | 2178101 | 2022-02-03 | Lee | Illinois | 17103 | 8305 | 113 |
2178102 | 2178102 | 2022-02-03 | Livingston | Illinois | 17105 | 10292 | 139 |
2178103 | 2178103 | 2022-02-03 | Logan | Illinois | 17107 | 9060 | 96 |
2178104 | 2178104 | 2022-02-03 | Macon | Illinois | 17115 | 29356 | 327 |
2178105 | 2178105 | 2022-02-03 | Macoupin | Illinois | 17117 | 12262 | 157 |
2178106 | 2178106 | 2022-02-03 | Madison | Illinois | 17119 | 67788 | 802 |
2178107 | 2178107 | 2022-02-03 | Marion | Illinois | 17121 | 11360 | 196 |
2178108 | 2178108 | 2022-02-03 | Marshall | Illinois | 17123 | 2639 | 31 |
2178109 | 2178109 | 2022-02-03 | Mason | Illinois | 17125 | 3719 | 60 |
2178110 | 2178110 | 2022-02-03 | Massac | Illinois | 17127 | 3633 | 67 |
2178111 | 2178111 | 2022-02-03 | McDonough | Illinois | 17109 | 6743 | 92 |
2178112 | 2178112 | 2022-02-03 | McHenry | Illinois | 17111 | 70588 | 454 |
2178113 | 2178113 | 2022-02-03 | McLean | Illinois | 17113 | 47237 | 306 |
2178114 | 2178114 | 2022-02-03 | Menard | Illinois | 17129 | 3388 | 22 |
2178115 | 2178115 | 2022-02-03 | Mercer | Illinois | 17131 | 3830 | 41 |
2178116 | 2178116 | 2022-02-03 | Monroe | Illinois | 17133 | 9150 | 120 |
2178117 | 2178117 | 2022-02-03 | Montgomery | Illinois | 17135 | 9231 | 100 |
2178118 | 2178118 | 2022-02-03 | Morgan | Illinois | 17137 | 8997 | 133 |
2178119 | 2178119 | 2022-02-03 | Moultrie | Illinois | 17139 | 3940 | 50 |
2178120 | 2178120 | 2022-02-03 | Ogle | Illinois | 17141 | 13299 | 134 |
2178121 | 2178121 | 2022-02-03 | Peoria | Illinois | 17143 | 44650 | 524 |
2178122 | 2178122 | 2022-02-03 | Perry | Illinois | 17145 | 7048 | 99 |
2178123 | 2178123 | 2022-02-03 | Piatt | Illinois | 17147 | 4186 | 27 |
2178124 | 2178124 | 2022-02-03 | Pike | Illinois | 17149 | 4855 | 66 |
2178125 | 2178125 | 2022-02-03 | Pope | Illinois | 17151 | 920 | 7 |
2178126 | 2178126 | 2022-02-03 | Pulaski | Illinois | 17153 | 1663 | 16 |
2178127 | 2178127 | 2022-02-03 | Putnam | Illinois | 17155 | 1089 | 8 |
2178128 | 2178128 | 2022-02-03 | Randolph | Illinois | 17157 | 9927 | 120 |
2178129 | 2178129 | 2022-02-03 | Richland | Illinois | 17159 | 4999 | 79 |
2178130 | 2178130 | 2022-02-03 | Rock Island | Illinois | 17161 | 31762 | 490 |
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 |
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);