ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2022-04-15" 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 |
---|---|---|---|---|---|---|---|
2408994 | 2408994 | 2022-04-15 | Adams | Illinois | 17001 | 22334 | 238 |
2408995 | 2408995 | 2022-04-15 | Alexander | Illinois | 17003 | 1284 | 15 |
2408996 | 2408996 | 2022-04-15 | Bond | Illinois | 17005 | 4332 | 37 |
2408997 | 2408997 | 2022-04-15 | Boone | Illinois | 17007 | 13838 | 129 |
2408998 | 2408998 | 2022-04-15 | Brown | Illinois | 17009 | 2407 | 21 |
2408999 | 2408999 | 2022-04-15 | Bureau | Illinois | 17011 | 8354 | 140 |
2409000 | 2409000 | 2022-04-15 | Calhoun | Illinois | 17013 | 1521 | 8 |
2409001 | 2409001 | 2022-04-15 | Carroll | Illinois | 17015 | 4247 | 49 |
2409002 | 2409002 | 2022-04-15 | Cass | Illinois | 17017 | 4614 | 44 |
2409003 | 2409003 | 2022-04-15 | Champaign | Illinois | 17019 | 63786 | 295 |
2409004 | 2409004 | 2022-04-15 | Christian | Illinois | 17021 | 10236 | 129 |
2409005 | 2409005 | 2022-04-15 | Clark | Illinois | 17023 | 4853 | 60 |
2409006 | 2409006 | 2022-04-15 | Clay | Illinois | 17025 | 4733 | 73 |
2409007 | 2409007 | 2022-04-15 | Clinton | Illinois | 17027 | 11969 | 122 |
2409008 | 2409008 | 2022-04-15 | Coles | Illinois | 17029 | 15325 | 175 |
2409009 | 2409009 | 2022-04-15 | Cook | Illinois | 17031 | 1140977 | 14851 |
2409010 | 2409010 | 2022-04-15 | Crawford | Illinois | 17033 | 6198 | 61 |
2409011 | 2409011 | 2022-04-15 | Cumberland | Illinois | 17035 | 3350 | 49 |
2409012 | 2409012 | 2022-04-15 | De Witt | Illinois | 17039 | 4331 | 44 |
2409013 | 2409013 | 2022-04-15 | DeKalb | Illinois | 17037 | 23472 | 199 |
2409014 | 2409014 | 2022-04-15 | Douglas | Illinois | 17041 | 6470 | 61 |
2409015 | 2409015 | 2022-04-15 | DuPage | Illinois | 17043 | 212040 | 1789 |
2409016 | 2409016 | 2022-04-15 | Edgar | Illinois | 17045 | 5170 | 79 |
2409017 | 2409017 | 2022-04-15 | Edwards | Illinois | 17047 | 1741 | 29 |
2409018 | 2409018 | 2022-04-15 | Effingham | Illinois | 17049 | 10664 | 147 |
2409019 | 2409019 | 2022-04-15 | Fayette | Illinois | 17051 | 7092 | 104 |
2409020 | 2409020 | 2022-04-15 | Ford | Illinois | 17053 | 4415 | 73 |
2409021 | 2409021 | 2022-04-15 | Franklin | Illinois | 17055 | 12267 | 177 |
2409022 | 2409022 | 2022-04-15 | Fulton | Illinois | 17057 | 10067 | 134 |
2409023 | 2409023 | 2022-04-15 | Gallatin | Illinois | 17059 | 1408 | 18 |
2409024 | 2409024 | 2022-04-15 | Greene | Illinois | 17061 | 3603 | 58 |
2409025 | 2409025 | 2022-04-15 | Grundy | Illinois | 17063 | 12680 | 140 |
2409026 | 2409026 | 2022-04-15 | Hamilton | Illinois | 17065 | 2177 | 34 |
2409027 | 2409027 | 2022-04-15 | Hancock | Illinois | 17067 | 4380 | 58 |
2409028 | 2409028 | 2022-04-15 | Hardin | Illinois | 17069 | 1054 | 20 |
2409029 | 2409029 | 2022-04-15 | Henderson | Illinois | 17071 | 1148 | 28 |
2409030 | 2409030 | 2022-04-15 | Henry | Illinois | 17073 | 12678 | 149 |
2409031 | 2409031 | 2022-04-15 | Iroquois | Illinois | 17075 | 7192 | 117 |
2409032 | 2409032 | 2022-04-15 | Jackson | Illinois | 17077 | 15562 | 130 |
2409033 | 2409033 | 2022-04-15 | Jasper | Illinois | 17079 | 2675 | 32 |
2409034 | 2409034 | 2022-04-15 | Jefferson | Illinois | 17081 | 11100 | 176 |
2409035 | 2409035 | 2022-04-15 | Jersey | Illinois | 17083 | 6231 | 91 |
2409036 | 2409036 | 2022-04-15 | Jo Daviess | Illinois | 17085 | 4033 | 39 |
2409037 | 2409037 | 2022-04-15 | Johnson | Illinois | 17087 | 4467 | 46 |
2409038 | 2409038 | 2022-04-15 | Kane | Illinois | 17089 | 126748 | 1177 |
2409039 | 2409039 | 2022-04-15 | Kankakee | Illinois | 17091 | 28885 | 373 |
2409040 | 2409040 | 2022-04-15 | Kendall | Illinois | 17093 | 31139 | 170 |
2409041 | 2409041 | 2022-04-15 | Knox | Illinois | 17095 | 12529 | 246 |
2409042 | 2409042 | 2022-04-15 | LaSalle | Illinois | 17099 | 29012 | 439 |
2409043 | 2409043 | 2022-04-15 | Lake | Illinois | 17097 | 150844 | 1451 |
2409044 | 2409044 | 2022-04-15 | Lawrence | Illinois | 17101 | 5485 | 51 |
2409045 | 2409045 | 2022-04-15 | Lee | Illinois | 17103 | 8785 | 118 |
2409046 | 2409046 | 2022-04-15 | Livingston | Illinois | 17105 | 10732 | 148 |
2409047 | 2409047 | 2022-04-15 | Logan | Illinois | 17107 | 9531 | 100 |
2409048 | 2409048 | 2022-04-15 | Macon | Illinois | 17115 | 30529 | 354 |
2409049 | 2409049 | 2022-04-15 | Macoupin | Illinois | 17117 | 12784 | 171 |
2409050 | 2409050 | 2022-04-15 | Madison | Illinois | 17119 | 70413 | 863 |
2409051 | 2409051 | 2022-04-15 | Marion | Illinois | 17121 | 11867 | 216 |
2409052 | 2409052 | 2022-04-15 | Marshall | Illinois | 17123 | 2766 | 33 |
2409053 | 2409053 | 2022-04-15 | Mason | Illinois | 17125 | 3903 | 61 |
2409054 | 2409054 | 2022-04-15 | Massac | Illinois | 17127 | 3870 | 71 |
2409055 | 2409055 | 2022-04-15 | McDonough | Illinois | 17109 | 7198 | 103 |
2409056 | 2409056 | 2022-04-15 | McHenry | Illinois | 17111 | 76244 | 506 |
2409057 | 2409057 | 2022-04-15 | McLean | Illinois | 17113 | 50170 | 327 |
2409058 | 2409058 | 2022-04-15 | Menard | Illinois | 17129 | 3501 | 24 |
2409059 | 2409059 | 2022-04-15 | Mercer | Illinois | 17131 | 4012 | 47 |
2409060 | 2409060 | 2022-04-15 | Monroe | Illinois | 17133 | 9496 | 127 |
2409061 | 2409061 | 2022-04-15 | Montgomery | Illinois | 17135 | 9810 | 111 |
2409062 | 2409062 | 2022-04-15 | Morgan | Illinois | 17137 | 9500 | 144 |
2409063 | 2409063 | 2022-04-15 | Moultrie | Illinois | 17139 | 4070 | 52 |
2409064 | 2409064 | 2022-04-15 | Ogle | Illinois | 17141 | 14001 | 136 |
2409065 | 2409065 | 2022-04-15 | Peoria | Illinois | 17143 | 46658 | 555 |
2409066 | 2409066 | 2022-04-15 | Perry | Illinois | 17145 | 7470 | 106 |
2409067 | 2409067 | 2022-04-15 | Piatt | Illinois | 17147 | 4449 | 29 |
2409068 | 2409068 | 2022-04-15 | Pike | Illinois | 17149 | 5035 | 70 |
2409069 | 2409069 | 2022-04-15 | Pope | Illinois | 17151 | 956 | 8 |
2409070 | 2409070 | 2022-04-15 | Pulaski | Illinois | 17153 | 1723 | 19 |
2409071 | 2409071 | 2022-04-15 | Putnam | Illinois | 17155 | 1145 | 10 |
2409072 | 2409072 | 2022-04-15 | Randolph | Illinois | 17157 | 10470 | 131 |
2409073 | 2409073 | 2022-04-15 | Richland | Illinois | 17159 | 5160 | 83 |
2409074 | 2409074 | 2022-04-15 | Rock Island | Illinois | 17161 | 33173 | 520 |
2409075 | 2409075 | 2022-04-15 | Saline | Illinois | 17165 | 7876 | 110 |
2409076 | 2409076 | 2022-04-15 | Sangamon | Illinois | 17167 | 55028 | 427 |
2409077 | 2409077 | 2022-04-15 | Schuyler | Illinois | 17169 | 1956 | 29 |
2409078 | 2409078 | 2022-04-15 | Scott | Illinois | 17171 | 1256 | 11 |
2409079 | 2409079 | 2022-04-15 | Shelby | Illinois | 17173 | 6203 | 79 |
2409080 | 2409080 | 2022-04-15 | St. Clair | Illinois | 17163 | 69474 | 773 |
2409081 | 2409081 | 2022-04-15 | Stark | Illinois | 17175 | 1513 | 32 |
2409082 | 2409082 | 2022-04-15 | Stephenson | Illinois | 17177 | 11489 | 176 |
2409083 | 2409083 | 2022-04-15 | Tazewell | Illinois | 17179 | 36715 | 498 |
2409084 | 2409084 | 2022-04-15 | Union | Illinois | 17181 | 5370 | 68 |
2409085 | 2409085 | 2022-04-15 | Unknown | Illinois | 0 | 2275 | |
2409086 | 2409086 | 2022-04-15 | Vermilion | Illinois | 17183 | 27944 | 312 |
2409087 | 2409087 | 2022-04-15 | Wabash | Illinois | 17185 | 3713 | 31 |
2409088 | 2409088 | 2022-04-15 | Warren | Illinois | 17187 | 4003 | 87 |
2409089 | 2409089 | 2022-04-15 | Washington | Illinois | 17189 | 3432 | 41 |
2409090 | 2409090 | 2022-04-15 | Wayne | Illinois | 17191 | 5295 | 85 |
2409091 | 2409091 | 2022-04-15 | White | Illinois | 17193 | 4403 | 59 |
2409092 | 2409092 | 2022-04-15 | Whiteside | Illinois | 17195 | 15386 | 267 |
2409093 | 2409093 | 2022-04-15 | Will | Illinois | 17197 | 162921 | 1603 |
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);