ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-02-05" 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 |
---|---|---|---|---|---|---|---|
998930 | 998930 | 2021-02-05 | Adams | Illinois | 17001 | 7825 | 138 |
998931 | 998931 | 2021-02-05 | Alexander | Illinois | 17003 | 426 | 8 |
998932 | 998932 | 2021-02-05 | Bond | Illinois | 17005 | 1824 | 27 |
998933 | 998933 | 2021-02-05 | Boone | Illinois | 17007 | 5776 | 85 |
998934 | 998934 | 2021-02-05 | Brown | Illinois | 17009 | 647 | 12 |
998935 | 998935 | 2021-02-05 | Bureau | Illinois | 17011 | 3161 | 86 |
998936 | 998936 | 2021-02-05 | Calhoun | Illinois | 17013 | 461 | 5 |
998937 | 998937 | 2021-02-05 | Carroll | Illinois | 17015 | 1522 | 33 |
998938 | 998938 | 2021-02-05 | Cass | Illinois | 17017 | 1845 | 31 |
998939 | 998939 | 2021-02-05 | Champaign | Illinois | 17019 | 16755 | 114 |
998940 | 998940 | 2021-02-05 | Christian | Illinois | 17021 | 3160 | 80 |
998941 | 998941 | 2021-02-05 | Clark | Illinois | 17023 | 1614 | 36 |
998942 | 998942 | 2021-02-05 | Clay | Illinois | 17025 | 1393 | 43 |
998943 | 998943 | 2021-02-05 | Clinton | Illinois | 17027 | 5428 | 94 |
998944 | 998944 | 2021-02-05 | Coles | Illinois | 17029 | 4960 | 90 |
998945 | 998945 | 2021-02-05 | Cook | Illinois | 17031 | 458600 | 9532 |
998946 | 998946 | 2021-02-05 | Crawford | Illinois | 17033 | 1931 | 37 |
998947 | 998947 | 2021-02-05 | Cumberland | Illinois | 17035 | 1138 | 28 |
998948 | 998948 | 2021-02-05 | De Witt | Illinois | 17039 | 1215 | 29 |
998949 | 998949 | 2021-02-05 | DeKalb | Illinois | 17037 | 8100 | 110 |
998950 | 998950 | 2021-02-05 | Douglas | Illinois | 17041 | 2162 | 35 |
998951 | 998951 | 2021-02-05 | DuPage | Illinois | 17043 | 73399 | 1208 |
998952 | 998952 | 2021-02-05 | Edgar | Illinois | 17045 | 1518 | 54 |
998953 | 998953 | 2021-02-05 | Edwards | Illinois | 17047 | 506 | 9 |
998954 | 998954 | 2021-02-05 | Effingham | Illinois | 17049 | 4422 | 79 |
998955 | 998955 | 2021-02-05 | Fayette | Illinois | 17051 | 3035 | 55 |
998956 | 998956 | 2021-02-05 | Ford | Illinois | 17053 | 1474 | 51 |
998957 | 998957 | 2021-02-05 | Franklin | Illinois | 17055 | 4029 | 75 |
998958 | 998958 | 2021-02-05 | Fulton | Illinois | 17057 | 2734 | 52 |
998959 | 998959 | 2021-02-05 | Gallatin | Illinois | 17059 | 415 | 4 |
998960 | 998960 | 2021-02-05 | Greene | Illinois | 17061 | 1338 | 43 |
998961 | 998961 | 2021-02-05 | Grundy | Illinois | 17063 | 4772 | 61 |
998962 | 998962 | 2021-02-05 | Hamilton | Illinois | 17065 | 757 | 17 |
998963 | 998963 | 2021-02-05 | Hancock | Illinois | 17067 | 1610 | 37 |
998964 | 998964 | 2021-02-05 | Hardin | Illinois | 17069 | 326 | 10 |
998965 | 998965 | 2021-02-05 | Henderson | Illinois | 17071 | 485 | 17 |
998966 | 998966 | 2021-02-05 | Henry | Illinois | 17073 | 4217 | 82 |
998967 | 998967 | 2021-02-05 | Iroquois | Illinois | 17075 | 2698 | 60 |
998968 | 998968 | 2021-02-05 | Jackson | Illinois | 17077 | 4473 | 70 |
998969 | 998969 | 2021-02-05 | Jasper | Illinois | 17079 | 1090 | 19 |
998970 | 998970 | 2021-02-05 | Jefferson | Illinois | 17081 | 3812 | 110 |
998971 | 998971 | 2021-02-05 | Jersey | Illinois | 17083 | 2397 | 63 |
998972 | 998972 | 2021-02-05 | Jo Daviess | Illinois | 17085 | 1568 | 25 |
998973 | 998973 | 2021-02-05 | Johnson | Illinois | 17087 | 1318 | 15 |
998974 | 998974 | 2021-02-05 | Kane | Illinois | 17089 | 48821 | 738 |
998975 | 998975 | 2021-02-05 | Kankakee | Illinois | 17091 | 12000 | 193 |
998976 | 998976 | 2021-02-05 | Kendall | Illinois | 17093 | 10612 | 89 |
998977 | 998977 | 2021-02-05 | Knox | Illinois | 17095 | 4837 | 150 |
998978 | 998978 | 2021-02-05 | LaSalle | Illinois | 17099 | 10234 | 257 |
998979 | 998979 | 2021-02-05 | Lake | Illinois | 17097 | 56869 | 959 |
998980 | 998980 | 2021-02-05 | Lawrence | Illinois | 17101 | 2245 | 32 |
998981 | 998981 | 2021-02-05 | Lee | Illinois | 17103 | 3233 | 80 |
998982 | 998982 | 2021-02-05 | Livingston | Illinois | 17105 | 4000 | 79 |
998983 | 998983 | 2021-02-05 | Logan | Illinois | 17107 | 3251 | 63 |
998984 | 998984 | 2021-02-05 | Macon | Illinois | 17115 | 9222 | 187 |
998985 | 998985 | 2021-02-05 | Macoupin | Illinois | 17117 | 4194 | 102 |
998986 | 998986 | 2021-02-05 | Madison | Illinois | 17119 | 26666 | 510 |
998987 | 998987 | 2021-02-05 | Marion | Illinois | 17121 | 4207 | 114 |
998988 | 998988 | 2021-02-05 | Marshall | Illinois | 17123 | 793 | 16 |
998989 | 998989 | 2021-02-05 | Mason | Illinois | 17125 | 1247 | 42 |
998990 | 998990 | 2021-02-05 | Massac | Illinois | 17127 | 1184 | 33 |
998991 | 998991 | 2021-02-05 | McDonough | Illinois | 17109 | 2256 | 51 |
998992 | 998992 | 2021-02-05 | McHenry | Illinois | 17111 | 23135 | 278 |
998993 | 998993 | 2021-02-05 | McLean | Illinois | 17113 | 14108 | 182 |
998994 | 998994 | 2021-02-05 | Menard | Illinois | 17129 | 986 | 10 |
998995 | 998995 | 2021-02-05 | Mercer | Illinois | 17131 | 1229 | 31 |
998996 | 998996 | 2021-02-05 | Monroe | Illinois | 17133 | 3892 | 75 |
998997 | 998997 | 2021-02-05 | Montgomery | Illinois | 17135 | 3315 | 70 |
998998 | 998998 | 2021-02-05 | Morgan | Illinois | 17137 | 3474 | 95 |
998999 | 998999 | 2021-02-05 | Moultrie | Illinois | 17139 | 1450 | 28 |
999000 | 999000 | 2021-02-05 | Ogle | Illinois | 17141 | 4835 | 75 |
999001 | 999001 | 2021-02-05 | Peoria | Illinois | 17143 | 16118 | 259 |
999002 | 999002 | 2021-02-05 | Perry | Illinois | 17145 | 2940 | 65 |
999003 | 999003 | 2021-02-05 | Piatt | Illinois | 17147 | 1260 | 19 |
999004 | 999004 | 2021-02-05 | Pike | Illinois | 17149 | 1649 | 51 |
999005 | 999005 | 2021-02-05 | Pope | Illinois | 17151 | 270 | 3 |
999006 | 999006 | 2021-02-05 | Pulaski | Illinois | 17153 | 654 | 4 |
999007 | 999007 | 2021-02-05 | Putnam | Illinois | 17155 | 380 | 4 |
999008 | 999008 | 2021-02-05 | Randolph | Illinois | 17157 | 3893 | 80 |
999009 | 999009 | 2021-02-05 | Richland | Illinois | 17159 | 1611 | 46 |
999010 | 999010 | 2021-02-05 | Rock Island | Illinois | 17161 | 12571 | 321 |
999011 | 999011 | 2021-02-05 | Saline | Illinois | 17165 | 2188 | 59 |
999012 | 999012 | 2021-02-05 | Sangamon | Illinois | 17167 | 15453 | 253 |
999013 | 999013 | 2021-02-05 | Schuyler | Illinois | 17169 | 664 | 17 |
999014 | 999014 | 2021-02-05 | Scott | Illinois | 17171 | 433 | 1 |
999015 | 999015 | 2021-02-05 | Shelby | Illinois | 17173 | 2069 | 36 |
999016 | 999016 | 2021-02-05 | St. Clair | Illinois | 17163 | 26513 | 479 |
999017 | 999017 | 2021-02-05 | Stark | Illinois | 17175 | 510 | 21 |
999018 | 999018 | 2021-02-05 | Stephenson | Illinois | 17177 | 3806 | 84 |
999019 | 999019 | 2021-02-05 | Tazewell | Illinois | 17179 | 12880 | 261 |
999020 | 999020 | 2021-02-05 | Union | Illinois | 17181 | 2144 | 34 |
999021 | 999021 | 2021-02-05 | Unknown | Illinois | 0 | 67 | |
999022 | 999022 | 2021-02-05 | Vermilion | Illinois | 17183 | 8160 | 124 |
999023 | 999023 | 2021-02-05 | Wabash | Illinois | 17185 | 1275 | 15 |
999024 | 999024 | 2021-02-05 | Warren | Illinois | 17187 | 1644 | 46 |
999025 | 999025 | 2021-02-05 | Washington | Illinois | 17189 | 1543 | 27 |
999026 | 999026 | 2021-02-05 | Wayne | Illinois | 17191 | 1613 | 45 |
999027 | 999027 | 2021-02-05 | White | Illinois | 17193 | 1527 | 33 |
999028 | 999028 | 2021-02-05 | Whiteside | Illinois | 17195 | 5727 | 181 |
999029 | 999029 | 2021-02-05 | Will | Illinois | 17197 | 62143 | 931 |
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);