ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where date = "2021-01-24" 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 |
---|---|---|---|---|---|---|---|
959983 | 959983 | 2021-01-24 | Adams | Illinois | 17001 | 7545 | 129 |
959984 | 959984 | 2021-01-24 | Alexander | Illinois | 17003 | 404 | 7 |
959985 | 959985 | 2021-01-24 | Bond | Illinois | 17005 | 1782 | 24 |
959986 | 959986 | 2021-01-24 | Boone | Illinois | 17007 | 5656 | 79 |
959987 | 959987 | 2021-01-24 | Brown | Illinois | 17009 | 622 | 11 |
959988 | 959988 | 2021-01-24 | Bureau | Illinois | 17011 | 3056 | 85 |
959989 | 959989 | 2021-01-24 | Calhoun | Illinois | 17013 | 450 | 4 |
959990 | 959990 | 2021-01-24 | Carroll | Illinois | 17015 | 1468 | 33 |
959991 | 959991 | 2021-01-24 | Cass | Illinois | 17017 | 1794 | 31 |
959992 | 959992 | 2021-01-24 | Champaign | Illinois | 17019 | 15883 | 106 |
959993 | 959993 | 2021-01-24 | Christian | Illinois | 17021 | 3056 | 79 |
959994 | 959994 | 2021-01-24 | Clark | Illinois | 17023 | 1529 | 34 |
959995 | 959995 | 2021-01-24 | Clay | Illinois | 17025 | 1340 | 40 |
959996 | 959996 | 2021-01-24 | Clinton | Illinois | 17027 | 5174 | 86 |
959997 | 959997 | 2021-01-24 | Coles | Illinois | 17029 | 4790 | 85 |
959998 | 959998 | 2021-01-24 | Cook | Illinois | 17031 | 444927 | 9243 |
959999 | 959999 | 2021-01-24 | Crawford | Illinois | 17033 | 1831 | 35 |
960000 | 960000 | 2021-01-24 | Cumberland | Illinois | 17035 | 1117 | 27 |
960001 | 960001 | 2021-01-24 | De Witt | Illinois | 17039 | 1190 | 28 |
960002 | 960002 | 2021-01-24 | DeKalb | Illinois | 17037 | 7755 | 94 |
960003 | 960003 | 2021-01-24 | Douglas | Illinois | 17041 | 2045 | 34 |
960004 | 960004 | 2021-01-24 | DuPage | Illinois | 17043 | 70890 | 1168 |
960005 | 960005 | 2021-01-24 | Edgar | Illinois | 17045 | 1492 | 53 |
960006 | 960006 | 2021-01-24 | Edwards | Illinois | 17047 | 478 | 9 |
960007 | 960007 | 2021-01-24 | Effingham | Illinois | 17049 | 4373 | 72 |
960008 | 960008 | 2021-01-24 | Fayette | Illinois | 17051 | 2967 | 53 |
960009 | 960009 | 2021-01-24 | Ford | Illinois | 17053 | 1406 | 51 |
960010 | 960010 | 2021-01-24 | Franklin | Illinois | 17055 | 3937 | 71 |
960011 | 960011 | 2021-01-24 | Fulton | Illinois | 17057 | 2625 | 49 |
960012 | 960012 | 2021-01-24 | Gallatin | Illinois | 17059 | 397 | 4 |
960013 | 960013 | 2021-01-24 | Greene | Illinois | 17061 | 1282 | 43 |
960014 | 960014 | 2021-01-24 | Grundy | Illinois | 17063 | 4531 | 54 |
960015 | 960015 | 2021-01-24 | Hamilton | Illinois | 17065 | 731 | 17 |
960016 | 960016 | 2021-01-24 | Hancock | Illinois | 17067 | 1550 | 35 |
960017 | 960017 | 2021-01-24 | Hardin | Illinois | 17069 | 312 | 8 |
960018 | 960018 | 2021-01-24 | Henderson | Illinois | 17071 | 466 | 16 |
960019 | 960019 | 2021-01-24 | Henry | Illinois | 17073 | 4102 | 77 |
960020 | 960020 | 2021-01-24 | Iroquois | Illinois | 17075 | 2624 | 58 |
960021 | 960021 | 2021-01-24 | Jackson | Illinois | 17077 | 4302 | 70 |
960022 | 960022 | 2021-01-24 | Jasper | Illinois | 17079 | 1061 | 15 |
960023 | 960023 | 2021-01-24 | Jefferson | Illinois | 17081 | 3557 | 105 |
960024 | 960024 | 2021-01-24 | Jersey | Illinois | 17083 | 2301 | 61 |
960025 | 960025 | 2021-01-24 | Jo Daviess | Illinois | 17085 | 1523 | 25 |
960026 | 960026 | 2021-01-24 | Johnson | Illinois | 17087 | 1256 | 15 |
960027 | 960027 | 2021-01-24 | Kane | Illinois | 17089 | 47171 | 705 |
960028 | 960028 | 2021-01-24 | Kankakee | Illinois | 17091 | 11720 | 187 |
960029 | 960029 | 2021-01-24 | Kendall | Illinois | 17093 | 10081 | 81 |
960030 | 960030 | 2021-01-24 | Knox | Illinois | 17095 | 4706 | 147 |
960031 | 960031 | 2021-01-24 | LaSalle | Illinois | 17099 | 9791 | 250 |
960032 | 960032 | 2021-01-24 | Lake | Illinois | 17097 | 54700 | 921 |
960033 | 960033 | 2021-01-24 | Lawrence | Illinois | 17101 | 2207 | 30 |
960034 | 960034 | 2021-01-24 | Lee | Illinois | 17103 | 3142 | 76 |
960035 | 960035 | 2021-01-24 | Livingston | Illinois | 17105 | 3792 | 70 |
960036 | 960036 | 2021-01-24 | Logan | Illinois | 17107 | 3169 | 59 |
960037 | 960037 | 2021-01-24 | Macon | Illinois | 17115 | 8982 | 182 |
960038 | 960038 | 2021-01-24 | Macoupin | Illinois | 17117 | 4009 | 96 |
960039 | 960039 | 2021-01-24 | Madison | Illinois | 17119 | 25299 | 477 |
960040 | 960040 | 2021-01-24 | Marion | Illinois | 17121 | 4081 | 113 |
960041 | 960041 | 2021-01-24 | Marshall | Illinois | 17123 | 705 | 15 |
960042 | 960042 | 2021-01-24 | Mason | Illinois | 17125 | 1195 | 41 |
960043 | 960043 | 2021-01-24 | Massac | Illinois | 17127 | 1072 | 33 |
960044 | 960044 | 2021-01-24 | McDonough | Illinois | 17109 | 2193 | 51 |
960045 | 960045 | 2021-01-24 | McHenry | Illinois | 17111 | 22214 | 258 |
960046 | 960046 | 2021-01-24 | McLean | Illinois | 17113 | 13564 | 171 |
960047 | 960047 | 2021-01-24 | Menard | Illinois | 17129 | 916 | 10 |
960048 | 960048 | 2021-01-24 | Mercer | Illinois | 17131 | 1187 | 30 |
960049 | 960049 | 2021-01-24 | Monroe | Illinois | 17133 | 3673 | 71 |
960050 | 960050 | 2021-01-24 | Montgomery | Illinois | 17135 | 3159 | 53 |
960051 | 960051 | 2021-01-24 | Morgan | Illinois | 17137 | 3362 | 93 |
960052 | 960052 | 2021-01-24 | Moultrie | Illinois | 17139 | 1415 | 28 |
960053 | 960053 | 2021-01-24 | Ogle | Illinois | 17141 | 4700 | 72 |
960054 | 960054 | 2021-01-24 | Peoria | Illinois | 17143 | 15466 | 251 |
960055 | 960055 | 2021-01-24 | Perry | Illinois | 17145 | 2792 | 62 |
960056 | 960056 | 2021-01-24 | Piatt | Illinois | 17147 | 1195 | 18 |
960057 | 960057 | 2021-01-24 | Pike | Illinois | 17149 | 1600 | 48 |
960058 | 960058 | 2021-01-24 | Pope | Illinois | 17151 | 257 | 3 |
960059 | 960059 | 2021-01-24 | Pulaski | Illinois | 17153 | 625 | 3 |
960060 | 960060 | 2021-01-24 | Putnam | Illinois | 17155 | 357 | 2 |
960061 | 960061 | 2021-01-24 | Randolph | Illinois | 17157 | 3802 | 73 |
960062 | 960062 | 2021-01-24 | Richland | Illinois | 17159 | 1571 | 46 |
960063 | 960063 | 2021-01-24 | Rock Island | Illinois | 17161 | 12195 | 308 |
960064 | 960064 | 2021-01-24 | Saline | Illinois | 17165 | 2087 | 54 |
960065 | 960065 | 2021-01-24 | Sangamon | Illinois | 17167 | 14918 | 242 |
960066 | 960066 | 2021-01-24 | Schuyler | Illinois | 17169 | 646 | 17 |
960067 | 960067 | 2021-01-24 | Scott | Illinois | 17171 | 408 | 1 |
960068 | 960068 | 2021-01-24 | Shelby | Illinois | 17173 | 2022 | 35 |
960069 | 960069 | 2021-01-24 | St. Clair | Illinois | 17163 | 25243 | 450 |
960070 | 960070 | 2021-01-24 | Stark | Illinois | 17175 | 499 | 20 |
960071 | 960071 | 2021-01-24 | Stephenson | Illinois | 17177 | 3639 | 77 |
960072 | 960072 | 2021-01-24 | Tazewell | Illinois | 17179 | 12296 | 251 |
960073 | 960073 | 2021-01-24 | Union | Illinois | 17181 | 2036 | 32 |
960074 | 960074 | 2021-01-24 | Vermilion | Illinois | 17183 | 7784 | 117 |
960075 | 960075 | 2021-01-24 | Wabash | Illinois | 17185 | 1218 | 15 |
960076 | 960076 | 2021-01-24 | Warren | Illinois | 17187 | 1603 | 44 |
960077 | 960077 | 2021-01-24 | Washington | Illinois | 17189 | 1493 | 26 |
960078 | 960078 | 2021-01-24 | Wayne | Illinois | 17191 | 1547 | 43 |
960079 | 960079 | 2021-01-24 | White | Illinois | 17193 | 1402 | 32 |
960080 | 960080 | 2021-01-24 | Whiteside | Illinois | 17195 | 5487 | 175 |
960081 | 960081 | 2021-01-24 | Will | Illinois | 17197 | 59768 | 888 |
960082 | 960082 | 2021-01-24 | Williamson | Illinois | 17199 | 6358 | 119 |
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);