ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

10,473 rows where state = "Illinois" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Illinois · 10,473
Link rowid date ▲ county state fips cases deaths
317038 2020-07-11 Adams Illinois 17001 167 1
317039 2020-07-11 Alexander Illinois 17003 24 0
317040 2020-07-11 Bond Illinois 17005 20 1
317041 2020-07-11 Boone Illinois 17007 635 21
317042 2020-07-11 Brown Illinois 17009 10 0
317043 2020-07-11 Bureau Illinois 17011 37 2
317044 2020-07-11 Calhoun Illinois 17013 1 0
317045 2020-07-11 Carroll Illinois 17015 20 2
317046 2020-07-11 Cass Illinois 17017 138 8
317047 2020-07-11 Champaign Illinois 17019 1038 17
317048 2020-07-11 Christian Illinois 17021 50 5
317049 2020-07-11 Clark Illinois 17023 40 0
317050 2020-07-11 Clay Illinois 17025 5 0
317051 2020-07-11 Clinton Illinois 17027 247 17
317052 2020-07-11 Coles Illinois 17029 190 17
317053 2020-07-11 Cook Illinois 17031 95138 4711
317054 2020-07-11 Crawford Illinois 17033 20 0
317055 2020-07-11 Cumberland Illinois 17035 29 0
317056 2020-07-11 De Witt Illinois 17039 18 0
317057 2020-07-11 DeKalb Illinois 17037 653 20
317058 2020-07-11 Douglas Illinois 17041 61 0
317059 2020-07-11 DuPage Illinois 17043 9641 485
317060 2020-07-11 Edgar Illinois 17045 19 0
317061 2020-07-11 Edwards Illinois 17047 5 0
317062 2020-07-11 Effingham Illinois 17049 30 1
317063 2020-07-11 Fayette Illinois 17051 24 3
317064 2020-07-11 Ford Illinois 17053 42 1
317065 2020-07-11 Franklin Illinois 17055 45 0
317066 2020-07-11 Fulton Illinois 17057 16 0
317067 2020-07-11 Gallatin Illinois 17059 6 0
317068 2020-07-11 Greene Illinois 17061 8 0
317069 2020-07-11 Grundy Illinois 17063 193 5
317070 2020-07-11 Hamilton Illinois 17065 7 0
317071 2020-07-11 Hancock Illinois 17067 20 1
317072 2020-07-11 Hardin Illinois 17069 2 0
317073 2020-07-11 Henderson Illinois 17071 8 0
317074 2020-07-11 Henry Illinois 17073 111 1
317075 2020-07-11 Iroquois Illinois 17075 175 5
317076 2020-07-11 Jackson Illinois 17077 351 19
317077 2020-07-11 Jasper Illinois 17079 47 7
317078 2020-07-11 Jefferson Illinois 17081 114 17
317079 2020-07-11 Jersey Illinois 17083 40 1
317080 2020-07-11 Jo Daviess Illinois 17085 54 1
317081 2020-07-11 Johnson Illinois 17087 27 0
317082 2020-07-11 Kane Illinois 17089 8139 281
317083 2020-07-11 Kankakee Illinois 17091 1465 66
317084 2020-07-11 Kendall Illinois 17093 1099 23
317085 2020-07-11 Knox Illinois 17095 168 0
317086 2020-07-11 LaSalle Illinois 17099 254 17
317087 2020-07-11 Lake Illinois 17097 10318 428
317088 2020-07-11 Lawrence Illinois 17101 12 0
317089 2020-07-11 Lee Illinois 17103 105 2
317090 2020-07-11 Livingston Illinois 17105 54 2
317091 2020-07-11 Logan Illinois 17107 20 0
317092 2020-07-11 Macon Illinois 17115 250 22
317093 2020-07-11 Macoupin Illinois 17117 67 3
317094 2020-07-11 Madison Illinois 17119 1167 70
317095 2020-07-11 Marion Illinois 17121 77 0
317096 2020-07-11 Marshall Illinois 17123 12 0
317097 2020-07-11 Mason Illinois 17125 24 0
317098 2020-07-11 Massac Illinois 17127 16 0
317099 2020-07-11 McDonough Illinois 17109 106 15
317100 2020-07-11 McHenry Illinois 17111 2303 103
317101 2020-07-11 McLean Illinois 17113 315 15
317102 2020-07-11 Menard Illinois 17129 31 0
317103 2020-07-11 Mercer Illinois 17131 29 0
317104 2020-07-11 Monroe Illinois 17133 155 13
317105 2020-07-11 Montgomery Illinois 17135 73 0
317106 2020-07-11 Morgan Illinois 17137 134 3
317107 2020-07-11 Moultrie Illinois 17139 24 0
317108 2020-07-11 Ogle Illinois 17141 307 5
317109 2020-07-11 Peoria Illinois 17143 644 30
317110 2020-07-11 Perry Illinois 17145 61 1
317111 2020-07-11 Piatt Illinois 17147 21 0
317112 2020-07-11 Pike Illinois 17149 6 0
317113 2020-07-11 Pope Illinois 17151 1 0
317114 2020-07-11 Pulaski Illinois 17153 84 0
317115 2020-07-11 Putnam Illinois 17155 1 0
317116 2020-07-11 Randolph Illinois 17157 310 7
317117 2020-07-11 Richland Illinois 17159 9 0
317118 2020-07-11 Rock Island Illinois 17161 1195 30
317119 2020-07-11 Saline Illinois 17165 16 0
317120 2020-07-11 Sangamon Illinois 17167 519 34
317121 2020-07-11 Schuyler Illinois 17169 13 0
317122 2020-07-11 Scott Illinois 17171 1 0
317123 2020-07-11 Shelby Illinois 17173 20 1
317124 2020-07-11 St. Clair Illinois 17163 2471 144
317125 2020-07-11 Stark Illinois 17175 6 0
317126 2020-07-11 Stephenson Illinois 17177 283 6
317127 2020-07-11 Tazewell Illinois 17179 172 8
317128 2020-07-11 Union Illinois 17181 205 19
317129 2020-07-11 Unknown Illinois   1132 201
317130 2020-07-11 Vermilion Illinois 17183 89 2
317131 2020-07-11 Wabash Illinois 17185 23 0
317132 2020-07-11 Warren Illinois 17187 149 0
317133 2020-07-11 Washington Illinois 17189 25 0
317134 2020-07-11 Wayne Illinois 17191 18 1
317135 2020-07-11 White Illinois 17193 10 0
317136 2020-07-11 Whiteside Illinois 17195 209 15
317137 2020-07-11 Will Illinois 17197 7223 325

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1095.688ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette