ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where "date" is on date 2022-01-06 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2086972 | 2086972 | 2022-01-06 | Adams | Illinois | 17001 | 17160 | 203 |
2086973 | 2086973 | 2022-01-06 | Alexander | Illinois | 17003 | 925 | 13 |
2086974 | 2086974 | 2022-01-06 | Bond | Illinois | 17005 | 3255 | 34 |
2086975 | 2086975 | 2022-01-06 | Boone | Illinois | 17007 | 10461 | 106 |
2086976 | 2086976 | 2022-01-06 | Brown | Illinois | 17009 | 1258 | 19 |
2086977 | 2086977 | 2022-01-06 | Bureau | Illinois | 17011 | 6140 | 126 |
2086978 | 2086978 | 2022-01-06 | Calhoun | Illinois | 17013 | 1101 | 7 |
2086979 | 2086979 | 2022-01-06 | Carroll | Illinois | 17015 | 3111 | 43 |
2086980 | 2086980 | 2022-01-06 | Cass | Illinois | 17017 | 3360 | 40 |
2086981 | 2086981 | 2022-01-06 | Champaign | Illinois | 17019 | 42843 | 236 |
2086982 | 2086982 | 2022-01-06 | Christian | Illinois | 17021 | 7123 | 112 |
2086983 | 2086983 | 2022-01-06 | Clark | Illinois | 17023 | 3436 | 54 |
2086984 | 2086984 | 2022-01-06 | Clay | Illinois | 17025 | 3560 | 64 |
2086985 | 2086985 | 2022-01-06 | Clinton | Illinois | 17027 | 9021 | 117 |
2086986 | 2086986 | 2022-01-06 | Coles | Illinois | 17029 | 10441 | 148 |
2086987 | 2086987 | 2022-01-06 | Cook | Illinois | 17031 | 900993 | 12714 |
2086988 | 2086988 | 2022-01-06 | Crawford | Illinois | 17033 | 4018 | 52 |
2086989 | 2086989 | 2022-01-06 | Cumberland | Illinois | 17035 | 2447 | 43 |
2086990 | 2086990 | 2022-01-06 | De Witt | Illinois | 17039 | 3183 | 39 |
2086991 | 2086991 | 2022-01-06 | DeKalb | Illinois | 17037 | 17710 | 163 |
2086992 | 2086992 | 2022-01-06 | Douglas | Illinois | 17041 | 4470 | 48 |
2086993 | 2086993 | 2022-01-06 | DuPage | Illinois | 17043 | 157094 | 1548 |
2086994 | 2086994 | 2022-01-06 | Edgar | Illinois | 17045 | 3636 | 75 |
2086995 | 2086995 | 2022-01-06 | Edwards | Illinois | 17047 | 1309 | 23 |
2086996 | 2086996 | 2022-01-06 | Effingham | Illinois | 17049 | 8298 | 124 |
2086997 | 2086997 | 2022-01-06 | Fayette | Illinois | 17051 | 5390 | 76 |
2086998 | 2086998 | 2022-01-06 | Ford | Illinois | 17053 | 3368 | 67 |
2086999 | 2086999 | 2022-01-06 | Franklin | Illinois | 17055 | 8930 | 146 |
2087000 | 2087000 | 2022-01-06 | Fulton | Illinois | 17057 | 7194 | 104 |
2087001 | 2087001 | 2022-01-06 | Gallatin | Illinois | 17059 | 952 | 11 |
2087002 | 2087002 | 2022-01-06 | Greene | Illinois | 17061 | 2757 | 53 |
2087003 | 2087003 | 2022-01-06 | Grundy | Illinois | 17063 | 10447 | 109 |
2087004 | 2087004 | 2022-01-06 | Hamilton | Illinois | 17065 | 1597 | 28 |
2087005 | 2087005 | 2022-01-06 | Hancock | Illinois | 17067 | 3436 | 47 |
2087006 | 2087006 | 2022-01-06 | Hardin | Illinois | 17069 | 796 | 17 |
2087007 | 2087007 | 2022-01-06 | Henderson | Illinois | 17071 | 915 | 24 |
2087008 | 2087008 | 2022-01-06 | Henry | Illinois | 17073 | 9291 | 126 |
2087009 | 2087009 | 2022-01-06 | Iroquois | Illinois | 17075 | 5761 | 94 |
2087010 | 2087010 | 2022-01-06 | Jackson | Illinois | 17077 | 10456 | 113 |
2087011 | 2087011 | 2022-01-06 | Jasper | Illinois | 17079 | 2034 | 25 |
2087012 | 2087012 | 2022-01-06 | Jefferson | Illinois | 17081 | 7899 | 153 |
2087013 | 2087013 | 2022-01-06 | Jersey | Illinois | 17083 | 4647 | 76 |
2087014 | 2087014 | 2022-01-06 | Jo Daviess | Illinois | 17085 | 3026 | 35 |
2087015 | 2087015 | 2022-01-06 | Johnson | Illinois | 17087 | 2878 | 40 |
2087016 | 2087016 | 2022-01-06 | Kane | Illinois | 17089 | 93750 | 1008 |
2087017 | 2087017 | 2022-01-06 | Kankakee | Illinois | 17091 | 24049 | 307 |
2087018 | 2087018 | 2022-01-06 | Kendall | Illinois | 17093 | 23962 | 136 |
2087019 | 2087019 | 2022-01-06 | Knox | Illinois | 17095 | 9543 | 217 |
2087020 | 2087020 | 2022-01-06 | LaSalle | Illinois | 17099 | 20680 | 386 |
2087021 | 2087021 | 2022-01-06 | Lake | Illinois | 17097 | 109715 | 1230 |
2087022 | 2087022 | 2022-01-06 | Lawrence | Illinois | 17101 | 3989 | 47 |
2087023 | 2087023 | 2022-01-06 | Lee | Illinois | 17103 | 6330 | 109 |
2087024 | 2087024 | 2022-01-06 | Livingston | Illinois | 17105 | 7802 | 128 |
2087025 | 2087025 | 2022-01-06 | Logan | Illinois | 17107 | 6662 | 91 |
2087026 | 2087026 | 2022-01-06 | Macon | Illinois | 17115 | 21722 | 292 |
2087027 | 2087027 | 2022-01-06 | Macoupin | Illinois | 17117 | 9128 | 152 |
2087028 | 2087028 | 2022-01-06 | Madison | Illinois | 17119 | 52814 | 731 |
2087029 | 2087029 | 2022-01-06 | Marion | Illinois | 17121 | 8923 | 173 |
2087030 | 2087030 | 2022-01-06 | Marshall | Illinois | 17123 | 2084 | 26 |
2087031 | 2087031 | 2022-01-06 | Mason | Illinois | 17125 | 2897 | 55 |
2087032 | 2087032 | 2022-01-06 | Massac | Illinois | 17127 | 2757 | 64 |
2087033 | 2087033 | 2022-01-06 | McDonough | Illinois | 17109 | 5056 | 84 |
2087034 | 2087034 | 2022-01-06 | McHenry | Illinois | 17111 | 50605 | 397 |
2087035 | 2087035 | 2022-01-06 | McLean | Illinois | 17113 | 34162 | 284 |
2087036 | 2087036 | 2022-01-06 | Menard | Illinois | 17129 | 2499 | 19 |
2087037 | 2087037 | 2022-01-06 | Mercer | Illinois | 17131 | 2960 | 38 |
2087038 | 2087038 | 2022-01-06 | Monroe | Illinois | 17133 | 6935 | 109 |
2087039 | 2087039 | 2022-01-06 | Montgomery | Illinois | 17135 | 6646 | 94 |
2087040 | 2087040 | 2022-01-06 | Morgan | Illinois | 17137 | 6472 | 125 |
2087041 | 2087041 | 2022-01-06 | Moultrie | Illinois | 17139 | 3083 | 47 |
2087042 | 2087042 | 2022-01-06 | Ogle | Illinois | 17141 | 10582 | 124 |
2087043 | 2087043 | 2022-01-06 | Peoria | Illinois | 17143 | 37252 | 469 |
2087044 | 2087044 | 2022-01-06 | Perry | Illinois | 17145 | 5127 | 93 |
2087045 | 2087045 | 2022-01-06 | Piatt | Illinois | 17147 | 3217 | 22 |
2087046 | 2087046 | 2022-01-06 | Pike | Illinois | 17149 | 3781 | 62 |
2087047 | 2087047 | 2022-01-06 | Pope | Illinois | 17151 | 726 | 7 |
2087048 | 2087048 | 2022-01-06 | Pulaski | Illinois | 17153 | 1255 | 15 |
2087049 | 2087049 | 2022-01-06 | Putnam | Illinois | 17155 | 847 | 8 |
2087050 | 2087050 | 2022-01-06 | Randolph | Illinois | 17157 | 6784 | 113 |
2087051 | 2087051 | 2022-01-06 | Richland | Illinois | 17159 | 3616 | 76 |
2087052 | 2087052 | 2022-01-06 | Rock Island | Illinois | 17161 | 25541 | 454 |
2087053 | 2087053 | 2022-01-06 | Saline | Illinois | 17165 | 5320 | 93 |
2087054 | 2087054 | 2022-01-06 | Sangamon | Illinois | 17167 | 37373 | 357 |
2087055 | 2087055 | 2022-01-06 | Schuyler | Illinois | 17169 | 1408 | 26 |
2087056 | 2087056 | 2022-01-06 | Scott | Illinois | 17171 | 979 | 9 |
2087057 | 2087057 | 2022-01-06 | Shelby | Illinois | 17173 | 4640 | 62 |
2087058 | 2087058 | 2022-01-06 | St. Clair | Illinois | 17163 | 52383 | 693 |
2087059 | 2087059 | 2022-01-06 | Stark | Illinois | 17175 | 1072 | 30 |
2087060 | 2087060 | 2022-01-06 | Stephenson | Illinois | 17177 | 8691 | 147 |
2087061 | 2087061 | 2022-01-06 | Tazewell | Illinois | 17179 | 28720 | 423 |
2087062 | 2087062 | 2022-01-06 | Union | Illinois | 17181 | 3799 | 58 |
2087063 | 2087063 | 2022-01-06 | Unknown | Illinois | 0 | 1235 | |
2087064 | 2087064 | 2022-01-06 | Vermilion | Illinois | 17183 | 20314 | 262 |
2087065 | 2087065 | 2022-01-06 | Wabash | Illinois | 17185 | 2542 | 22 |
2087066 | 2087066 | 2022-01-06 | Warren | Illinois | 17187 | 3181 | 75 |
2087067 | 2087067 | 2022-01-06 | Washington | Illinois | 17189 | 2640 | 37 |
2087068 | 2087068 | 2022-01-06 | Wayne | Illinois | 17191 | 3723 | 68 |
2087069 | 2087069 | 2022-01-06 | White | Illinois | 17193 | 3286 | 45 |
2087070 | 2087070 | 2022-01-06 | Whiteside | Illinois | 17195 | 11077 | 238 |
2087071 | 2087071 | 2022-01-06 | Will | Illinois | 17197 | 129679 | 1333 |
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);