ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-11-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 |
---|---|---|---|---|---|---|---|
1878950 | 1878950 | 2021-11-03 | Adams | Illinois | 17001 | 13419 | 185 |
1878951 | 1878951 | 2021-11-03 | Alexander | Illinois | 17003 | 760 | 13 |
1878952 | 1878952 | 2021-11-03 | Bond | Illinois | 17005 | 2610 | 32 |
1878953 | 1878953 | 2021-11-03 | Boone | Illinois | 17007 | 8072 | 96 |
1878954 | 1878954 | 2021-11-03 | Brown | Illinois | 17009 | 1076 | 17 |
1878955 | 1878955 | 2021-11-03 | Bureau | Illinois | 17011 | 4538 | 105 |
1878956 | 1878956 | 2021-11-03 | Calhoun | Illinois | 17013 | 709 | 5 |
1878957 | 1878957 | 2021-11-03 | Carroll | Illinois | 17015 | 2394 | 40 |
1878958 | 1878958 | 2021-11-03 | Cass | Illinois | 17017 | 2687 | 40 |
1878959 | 1878959 | 2021-11-03 | Champaign | Illinois | 17019 | 27508 | 206 |
1878960 | 1878960 | 2021-11-03 | Christian | Illinois | 17021 | 5479 | 100 |
1878961 | 1878961 | 2021-11-03 | Clark | Illinois | 17023 | 2718 | 50 |
1878962 | 1878962 | 2021-11-03 | Clay | Illinois | 17025 | 2657 | 59 |
1878963 | 1878963 | 2021-11-03 | Clinton | Illinois | 17027 | 7191 | 112 |
1878964 | 1878964 | 2021-11-03 | Coles | Illinois | 17029 | 8078 | 131 |
1878965 | 1878965 | 2021-11-03 | Cook | Illinois | 17031 | 644617 | 11869 |
1878966 | 1878966 | 2021-11-03 | Crawford | Illinois | 17033 | 3384 | 46 |
1878967 | 1878967 | 2021-11-03 | Cumberland | Illinois | 17035 | 1936 | 39 |
1878968 | 1878968 | 2021-11-03 | De Witt | Illinois | 17039 | 2127 | 37 |
1878969 | 1878969 | 2021-11-03 | DeKalb | Illinois | 17037 | 12714 | 139 |
1878970 | 1878970 | 2021-11-03 | Douglas | Illinois | 17041 | 3340 | 44 |
1878971 | 1878971 | 2021-11-03 | DuPage | Illinois | 17043 | 110504 | 1474 |
1878972 | 1878972 | 2021-11-03 | Edgar | Illinois | 17045 | 2660 | 69 |
1878973 | 1878973 | 2021-11-03 | Edwards | Illinois | 17047 | 1049 | 20 |
1878974 | 1878974 | 2021-11-03 | Effingham | Illinois | 17049 | 6763 | 112 |
1878975 | 1878975 | 2021-11-03 | Fayette | Illinois | 17051 | 4398 | 68 |
1878976 | 1878976 | 2021-11-03 | Ford | Illinois | 17053 | 2512 | 67 |
1878977 | 1878977 | 2021-11-03 | Franklin | Illinois | 17055 | 7369 | 128 |
1878978 | 1878978 | 2021-11-03 | Fulton | Illinois | 17057 | 5337 | 90 |
1878979 | 1878979 | 2021-11-03 | Gallatin | Illinois | 17059 | 800 | 10 |
1878980 | 1878980 | 2021-11-03 | Greene | Illinois | 17061 | 2070 | 53 |
1878981 | 1878981 | 2021-11-03 | Grundy | Illinois | 17063 | 7538 | 92 |
1878982 | 1878982 | 2021-11-03 | Hamilton | Illinois | 17065 | 1362 | 25 |
1878983 | 1878983 | 2021-11-03 | Hancock | Illinois | 17067 | 2795 | 45 |
1878984 | 1878984 | 2021-11-03 | Hardin | Illinois | 17069 | 622 | 16 |
1878985 | 1878985 | 2021-11-03 | Henderson | Illinois | 17071 | 731 | 23 |
1878986 | 1878986 | 2021-11-03 | Henry | Illinois | 17073 | 6755 | 106 |
1878987 | 1878987 | 2021-11-03 | Iroquois | Illinois | 17075 | 4312 | 81 |
1878988 | 1878988 | 2021-11-03 | Jackson | Illinois | 17077 | 8166 | 106 |
1878989 | 1878989 | 2021-11-03 | Jasper | Illinois | 17079 | 1632 | 23 |
1878990 | 1878990 | 2021-11-03 | Jefferson | Illinois | 17081 | 6660 | 147 |
1878991 | 1878991 | 2021-11-03 | Jersey | Illinois | 17083 | 3423 | 72 |
1878992 | 1878992 | 2021-11-03 | Jo Daviess | Illinois | 17085 | 2238 | 32 |
1878993 | 1878993 | 2021-11-03 | Johnson | Illinois | 17087 | 2351 | 38 |
1878994 | 1878994 | 2021-11-03 | Kane | Illinois | 17089 | 69488 | 940 |
1878995 | 1878995 | 2021-11-03 | Kankakee | Illinois | 17091 | 18220 | 267 |
1878996 | 1878996 | 2021-11-03 | Kendall | Illinois | 17093 | 17252 | 125 |
1878997 | 1878997 | 2021-11-03 | Knox | Illinois | 17095 | 7504 | 203 |
1878998 | 1878998 | 2021-11-03 | LaSalle | Illinois | 17099 | 15258 | 345 |
1878999 | 1878999 | 2021-11-03 | Lake | Illinois | 17097 | 81589 | 1167 |
1879000 | 1879000 | 2021-11-03 | Lawrence | Illinois | 17101 | 3396 | 44 |
1879001 | 1879001 | 2021-11-03 | Lee | Illinois | 17103 | 4875 | 101 |
1879002 | 1879002 | 2021-11-03 | Livingston | Illinois | 17105 | 6053 | 111 |
1879003 | 1879003 | 2021-11-03 | Logan | Illinois | 17107 | 4996 | 89 |
1879004 | 1879004 | 2021-11-03 | Macon | Illinois | 17115 | 15572 | 262 |
1879005 | 1879005 | 2021-11-03 | Macoupin | Illinois | 17117 | 7170 | 138 |
1879006 | 1879006 | 2021-11-03 | Madison | Illinois | 17119 | 40724 | 679 |
1879007 | 1879007 | 2021-11-03 | Marion | Illinois | 17121 | 7035 | 154 |
1879008 | 1879008 | 2021-11-03 | Marshall | Illinois | 17123 | 1431 | 25 |
1879009 | 1879009 | 2021-11-03 | Mason | Illinois | 17125 | 2174 | 54 |
1879010 | 1879010 | 2021-11-03 | Massac | Illinois | 17127 | 2214 | 56 |
1879011 | 1879011 | 2021-11-03 | McDonough | Illinois | 17109 | 3802 | 77 |
1879012 | 1879012 | 2021-11-03 | McHenry | Illinois | 17111 | 35614 | 362 |
1879013 | 1879013 | 2021-11-03 | McLean | Illinois | 17113 | 23431 | 259 |
1879014 | 1879014 | 2021-11-03 | Menard | Illinois | 17129 | 1747 | 17 |
1879015 | 1879015 | 2021-11-03 | Mercer | Illinois | 17131 | 2110 | 37 |
1879016 | 1879016 | 2021-11-03 | Monroe | Illinois | 17133 | 5316 | 105 |
1879017 | 1879017 | 2021-11-03 | Montgomery | Illinois | 17135 | 5017 | 89 |
1879018 | 1879018 | 2021-11-03 | Morgan | Illinois | 17137 | 5352 | 123 |
1879019 | 1879019 | 2021-11-03 | Moultrie | Illinois | 17139 | 2458 | 41 |
1879020 | 1879020 | 2021-11-03 | Ogle | Illinois | 17141 | 7755 | 100 |
1879021 | 1879021 | 2021-11-03 | Peoria | Illinois | 17143 | 27422 | 407 |
1879022 | 1879022 | 2021-11-03 | Perry | Illinois | 17145 | 4384 | 85 |
1879023 | 1879023 | 2021-11-03 | Piatt | Illinois | 17147 | 2060 | 20 |
1879024 | 1879024 | 2021-11-03 | Pike | Illinois | 17149 | 2685 | 61 |
1879025 | 1879025 | 2021-11-03 | Pope | Illinois | 17151 | 567 | 6 |
1879026 | 1879026 | 2021-11-03 | Pulaski | Illinois | 17153 | 1064 | 12 |
1879027 | 1879027 | 2021-11-03 | Putnam | Illinois | 17155 | 572 | 5 |
1879028 | 1879028 | 2021-11-03 | Randolph | Illinois | 17157 | 5598 | 109 |
1879029 | 1879029 | 2021-11-03 | Richland | Illinois | 17159 | 2865 | 66 |
1879030 | 1879030 | 2021-11-03 | Rock Island | Illinois | 17161 | 19236 | 413 |
1879031 | 1879031 | 2021-11-03 | Saline | Illinois | 17165 | 4408 | 87 |
1879032 | 1879032 | 2021-11-03 | Sangamon | Illinois | 17167 | 26108 | 331 |
1879033 | 1879033 | 2021-11-03 | Schuyler | Illinois | 17169 | 1118 | 24 |
1879034 | 1879034 | 2021-11-03 | Scott | Illinois | 17171 | 718 | 7 |
1879035 | 1879035 | 2021-11-03 | Shelby | Illinois | 17173 | 3605 | 53 |
1879036 | 1879036 | 2021-11-03 | St. Clair | Illinois | 17163 | 40690 | 650 |
1879037 | 1879037 | 2021-11-03 | Stark | Illinois | 17175 | 833 | 28 |
1879038 | 1879038 | 2021-11-03 | Stephenson | Illinois | 17177 | 6085 | 114 |
1879039 | 1879039 | 2021-11-03 | Tazewell | Illinois | 17179 | 20885 | 374 |
1879040 | 1879040 | 2021-11-03 | Union | Illinois | 17181 | 3119 | 52 |
1879041 | 1879041 | 2021-11-03 | Unknown | Illinois | 0 | 847 | |
1879042 | 1879042 | 2021-11-03 | Vermilion | Illinois | 17183 | 14780 | 221 |
1879043 | 1879043 | 2021-11-03 | Wabash | Illinois | 17185 | 2187 | 22 |
1879044 | 1879044 | 2021-11-03 | Warren | Illinois | 17187 | 2485 | 71 |
1879045 | 1879045 | 2021-11-03 | Washington | Illinois | 17189 | 2148 | 35 |
1879046 | 1879046 | 2021-11-03 | Wayne | Illinois | 17191 | 3093 | 65 |
1879047 | 1879047 | 2021-11-03 | White | Illinois | 17193 | 2832 | 43 |
1879048 | 1879048 | 2021-11-03 | Whiteside | Illinois | 17195 | 8553 | 229 |
1879049 | 1879049 | 2021-11-03 | Will | Illinois | 17197 | 93023 | 1214 |
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);