ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-10-30" 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 |
---|---|---|---|---|---|---|---|
680907 | 680907 | 2020-10-30 | Adams | Illinois | 17001 | 2237 | 24 |
680908 | 680908 | 2020-10-30 | Alexander | Illinois | 17003 | 147 | 1 |
680909 | 680909 | 2020-10-30 | Bond | Illinois | 17005 | 532 | 9 |
680910 | 680910 | 2020-10-30 | Boone | Illinois | 17007 | 2038 | 25 |
680911 | 680911 | 2020-10-30 | Brown | Illinois | 17009 | 121 | 0 |
680912 | 680912 | 2020-10-30 | Bureau | Illinois | 17011 | 986 | 17 |
680913 | 680913 | 2020-10-30 | Calhoun | Illinois | 17013 | 70 | 0 |
680914 | 680914 | 2020-10-30 | Carroll | Illinois | 17015 | 490 | 13 |
680915 | 680915 | 2020-10-30 | Cass | Illinois | 17017 | 474 | 11 |
680916 | 680916 | 2020-10-30 | Champaign | Illinois | 17019 | 6585 | 28 |
680917 | 680917 | 2020-10-30 | Christian | Illinois | 17021 | 888 | 32 |
680918 | 680918 | 2020-10-30 | Clark | Illinois | 17023 | 328 | 18 |
680919 | 680919 | 2020-10-30 | Clay | Illinois | 17025 | 335 | 14 |
680920 | 680920 | 2020-10-30 | Clinton | Illinois | 17027 | 1877 | 31 |
680921 | 680921 | 2020-10-30 | Coles | Illinois | 17029 | 2111 | 40 |
680922 | 680922 | 2020-10-30 | Cook | Illinois | 17031 | 186405 | 5469 |
680923 | 680923 | 2020-10-30 | Crawford | Illinois | 17033 | 676 | 6 |
680924 | 680924 | 2020-10-30 | Cumberland | Illinois | 17035 | 313 | 6 |
680925 | 680925 | 2020-10-30 | De Witt | Illinois | 17039 | 282 | 6 |
680926 | 680926 | 2020-10-30 | DeKalb | Illinois | 17037 | 2728 | 43 |
680927 | 680927 | 2020-10-30 | Douglas | Illinois | 17041 | 787 | 9 |
680928 | 680928 | 2020-10-30 | DuPage | Illinois | 17043 | 24696 | 619 |
680929 | 680929 | 2020-10-30 | Edgar | Illinois | 17045 | 167 | 11 |
680930 | 680930 | 2020-10-30 | Edwards | Illinois | 17047 | 114 | 0 |
680931 | 680931 | 2020-10-30 | Effingham | Illinois | 17049 | 1285 | 4 |
680932 | 680932 | 2020-10-30 | Fayette | Illinois | 17051 | 720 | 24 |
680933 | 680933 | 2020-10-30 | Ford | Illinois | 17053 | 217 | 16 |
680934 | 680934 | 2020-10-30 | Franklin | Illinois | 17055 | 1081 | 10 |
680935 | 680935 | 2020-10-30 | Fulton | Illinois | 17057 | 622 | 2 |
680936 | 680936 | 2020-10-30 | Gallatin | Illinois | 17059 | 113 | 2 |
680937 | 680937 | 2020-10-30 | Greene | Illinois | 17061 | 329 | 17 |
680938 | 680938 | 2020-10-30 | Grundy | Illinois | 17063 | 1086 | 7 |
680939 | 680939 | 2020-10-30 | Hamilton | Illinois | 17065 | 143 | 2 |
680940 | 680940 | 2020-10-30 | Hancock | Illinois | 17067 | 345 | 4 |
680941 | 680941 | 2020-10-30 | Hardin | Illinois | 17069 | 58 | 0 |
680942 | 680942 | 2020-10-30 | Henderson | Illinois | 17071 | 136 | 0 |
680943 | 680943 | 2020-10-30 | Henry | Illinois | 17073 | 879 | 7 |
680944 | 680944 | 2020-10-30 | Iroquois | Illinois | 17075 | 539 | 19 |
680945 | 680945 | 2020-10-30 | Jackson | Illinois | 17077 | 1637 | 26 |
680946 | 680946 | 2020-10-30 | Jasper | Illinois | 17079 | 280 | 10 |
680947 | 680947 | 2020-10-30 | Jefferson | Illinois | 17081 | 973 | 52 |
680948 | 680948 | 2020-10-30 | Jersey | Illinois | 17083 | 485 | 21 |
680949 | 680949 | 2020-10-30 | Jo Daviess | Illinois | 17085 | 556 | 9 |
680950 | 680950 | 2020-10-30 | Johnson | Illinois | 17087 | 392 | 0 |
680951 | 680951 | 2020-10-30 | Kane | Illinois | 17089 | 18030 | 351 |
680952 | 680952 | 2020-10-30 | Kankakee | Illinois | 17091 | 3682 | 81 |
680953 | 680953 | 2020-10-30 | Kendall | Illinois | 17093 | 2938 | 30 |
680954 | 680954 | 2020-10-30 | Knox | Illinois | 17095 | 1418 | 21 |
680955 | 680955 | 2020-10-30 | LaSalle | Illinois | 17099 | 2652 | 68 |
680956 | 680956 | 2020-10-30 | Lake | Illinois | 17097 | 21819 | 518 |
680957 | 680957 | 2020-10-30 | Lawrence | Illinois | 17101 | 362 | 8 |
680958 | 680958 | 2020-10-30 | Lee | Illinois | 17103 | 840 | 2 |
680959 | 680959 | 2020-10-30 | Livingston | Illinois | 17105 | 730 | 12 |
680960 | 680960 | 2020-10-30 | Logan | Illinois | 17107 | 645 | 4 |
680961 | 680961 | 2020-10-30 | Macon | Illinois | 17115 | 3555 | 56 |
680962 | 680962 | 2020-10-30 | Macoupin | Illinois | 17117 | 854 | 11 |
680963 | 680963 | 2020-10-30 | Madison | Illinois | 17119 | 7622 | 158 |
680964 | 680964 | 2020-10-30 | Marion | Illinois | 17121 | 1170 | 23 |
680965 | 680965 | 2020-10-30 | Marshall | Illinois | 17123 | 171 | 3 |
680966 | 680966 | 2020-10-30 | Mason | Illinois | 17125 | 346 | 5 |
680967 | 680967 | 2020-10-30 | Massac | Illinois | 17127 | 165 | 2 |
680968 | 680968 | 2020-10-30 | McDonough | Illinois | 17109 | 818 | 22 |
680969 | 680969 | 2020-10-30 | McHenry | Illinois | 17111 | 7151 | 126 |
680970 | 680970 | 2020-10-30 | McLean | Illinois | 17113 | 4392 | 37 |
680971 | 680971 | 2020-10-30 | Menard | Illinois | 17129 | 191 | 1 |
680972 | 680972 | 2020-10-30 | Mercer | Illinois | 17131 | 311 | 6 |
680973 | 680973 | 2020-10-30 | Monroe | Illinois | 17133 | 1016 | 30 |
680974 | 680974 | 2020-10-30 | Montgomery | Illinois | 17135 | 667 | 15 |
680975 | 680975 | 2020-10-30 | Morgan | Illinois | 17137 | 1042 | 27 |
680976 | 680976 | 2020-10-30 | Moultrie | Illinois | 17139 | 470 | 6 |
680977 | 680977 | 2020-10-30 | Ogle | Illinois | 17141 | 1354 | 8 |
680978 | 680978 | 2020-10-30 | Peoria | Illinois | 17143 | 4906 | 78 |
680979 | 680979 | 2020-10-30 | Perry | Illinois | 17145 | 485 | 16 |
680980 | 680980 | 2020-10-30 | Piatt | Illinois | 17147 | 282 | 2 |
680981 | 680981 | 2020-10-30 | Pike | Illinois | 17149 | 423 | 7 |
680982 | 680982 | 2020-10-30 | Pope | Illinois | 17151 | 44 | 1 |
680983 | 680983 | 2020-10-30 | Pulaski | Illinois | 17153 | 246 | 1 |
680984 | 680984 | 2020-10-30 | Putnam | Illinois | 17155 | 101 | 0 |
680985 | 680985 | 2020-10-30 | Randolph | Illinois | 17157 | 1358 | 15 |
680986 | 680986 | 2020-10-30 | Richland | Illinois | 17159 | 347 | 18 |
680987 | 680987 | 2020-10-30 | Rock Island | Illinois | 17161 | 4477 | 102 |
680988 | 680988 | 2020-10-30 | Saline | Illinois | 17165 | 637 | 11 |
680989 | 680989 | 2020-10-30 | Sangamon | Illinois | 17167 | 4450 | 66 |
680990 | 680990 | 2020-10-30 | Schuyler | Illinois | 17169 | 101 | 1 |
680991 | 680991 | 2020-10-30 | Scott | Illinois | 17171 | 116 | 0 |
680992 | 680992 | 2020-10-30 | Shelby | Illinois | 17173 | 746 | 12 |
680993 | 680993 | 2020-10-30 | St. Clair | Illinois | 17163 | 9246 | 224 |
680994 | 680994 | 2020-10-30 | Stark | Illinois | 17175 | 96 | 3 |
680995 | 680995 | 2020-10-30 | Stephenson | Illinois | 17177 | 1182 | 9 |
680996 | 680996 | 2020-10-30 | Tazewell | Illinois | 17179 | 2905 | 60 |
680997 | 680997 | 2020-10-30 | Union | Illinois | 17181 | 810 | 25 |
680998 | 680998 | 2020-10-30 | Unknown | Illinois | 6061 | 278 | |
680999 | 680999 | 2020-10-30 | Vermilion | Illinois | 17183 | 1893 | 11 |
681000 | 681000 | 2020-10-30 | Wabash | Illinois | 17185 | 256 | 6 |
681001 | 681001 | 2020-10-30 | Warren | Illinois | 17187 | 561 | 9 |
681002 | 681002 | 2020-10-30 | Washington | Illinois | 17189 | 339 | 2 |
681003 | 681003 | 2020-10-30 | Wayne | Illinois | 17191 | 532 | 17 |
681004 | 681004 | 2020-10-30 | White | Illinois | 17193 | 289 | 5 |
681005 | 681005 | 2020-10-30 | Whiteside | Illinois | 17195 | 1784 | 30 |
681006 | 681006 | 2020-10-30 | Will | Illinois | 17197 | 19946 | 439 |
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);