ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "McLean" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386598 | 386598 | 2020-07-31 | McLean | Illinois | 17113 | 536 | 15 |
383380 | 383380 | 2020-07-30 | McLean | Illinois | 17113 | 520 | 15 |
380163 | 380163 | 2020-07-29 | McLean | Illinois | 17113 | 504 | 15 |
376946 | 376946 | 2020-07-28 | McLean | Illinois | 17113 | 487 | 15 |
373731 | 373731 | 2020-07-27 | McLean | Illinois | 17113 | 471 | 15 |
370519 | 370519 | 2020-07-26 | McLean | Illinois | 17113 | 461 | 15 |
367309 | 367309 | 2020-07-25 | McLean | Illinois | 17113 | 456 | 15 |
364102 | 364102 | 2020-07-24 | McLean | Illinois | 17113 | 442 | 15 |
360895 | 360895 | 2020-07-23 | McLean | Illinois | 17113 | 432 | 15 |
357690 | 357690 | 2020-07-22 | McLean | Illinois | 17113 | 418 | 15 |
354488 | 354488 | 2020-07-21 | McLean | Illinois | 17113 | 408 | 15 |
351286 | 351286 | 2020-07-20 | McLean | Illinois | 17113 | 404 | 15 |
348086 | 348086 | 2020-07-19 | McLean | Illinois | 17113 | 386 | 15 |
344885 | 344885 | 2020-07-18 | McLean | Illinois | 17113 | 382 | 15 |
341685 | 341685 | 2020-07-17 | McLean | Illinois | 17113 | 368 | 15 |
338489 | 338489 | 2020-07-16 | McLean | Illinois | 17113 | 349 | 15 |
335293 | 335293 | 2020-07-15 | McLean | Illinois | 17113 | 340 | 15 |
332100 | 332100 | 2020-07-14 | McLean | Illinois | 17113 | 334 | 15 |
328913 | 328913 | 2020-07-13 | McLean | Illinois | 17113 | 326 | 15 |
325727 | 325727 | 2020-07-12 | McLean | Illinois | 17113 | 322 | 15 |
322546 | 322546 | 2020-07-11 | McLean | Illinois | 17113 | 315 | 15 |
319367 | 319367 | 2020-07-10 | McLean | Illinois | 17113 | 308 | 15 |
316194 | 316194 | 2020-07-09 | McLean | Illinois | 17113 | 301 | 15 |
313020 | 313020 | 2020-07-08 | McLean | Illinois | 17113 | 292 | 14 |
309850 | 309850 | 2020-07-07 | McLean | Illinois | 17113 | 289 | 13 |
306682 | 306682 | 2020-07-06 | McLean | Illinois | 17113 | 285 | 13 |
303517 | 303517 | 2020-07-05 | McLean | Illinois | 17113 | 277 | 13 |
300353 | 300353 | 2020-07-04 | McLean | Illinois | 17113 | 273 | 13 |
297191 | 297191 | 2020-07-03 | McLean | Illinois | 17113 | 267 | 13 |
294034 | 294034 | 2020-07-02 | McLean | Illinois | 17113 | 265 | 13 |
290880 | 290880 | 2020-07-01 | McLean | Illinois | 17113 | 261 | 13 |
287730 | 287730 | 2020-06-30 | McLean | Illinois | 17113 | 260 | 13 |
284581 | 284581 | 2020-06-29 | McLean | Illinois | 17113 | 257 | 13 |
281436 | 281436 | 2020-06-28 | McLean | Illinois | 17113 | 257 | 13 |
278288 | 278288 | 2020-06-27 | McLean | Illinois | 17113 | 256 | 13 |
275140 | 275140 | 2020-06-26 | McLean | Illinois | 17113 | 255 | 13 |
271998 | 271998 | 2020-06-25 | McLean | Illinois | 17113 | 254 | 13 |
268861 | 268861 | 2020-06-24 | McLean | Illinois | 17113 | 253 | 13 |
265731 | 265731 | 2020-06-23 | McLean | Illinois | 17113 | 253 | 13 |
262603 | 262603 | 2020-06-22 | McLean | Illinois | 17113 | 254 | 13 |
259476 | 259476 | 2020-06-21 | McLean | Illinois | 17113 | 251 | 13 |
256350 | 256350 | 2020-06-20 | McLean | Illinois | 17113 | 247 | 13 |
253230 | 253230 | 2020-06-19 | McLean | Illinois | 17113 | 246 | 13 |
250115 | 250115 | 2020-06-18 | McLean | Illinois | 17113 | 246 | 13 |
247003 | 247003 | 2020-06-17 | McLean | Illinois | 17113 | 246 | 13 |
243890 | 243890 | 2020-06-16 | McLean | Illinois | 17113 | 243 | 13 |
240779 | 240779 | 2020-06-15 | McLean | Illinois | 17113 | 241 | 13 |
237671 | 237671 | 2020-06-14 | McLean | Illinois | 17113 | 241 | 13 |
234564 | 234564 | 2020-06-13 | McLean | Illinois | 17113 | 241 | 13 |
231458 | 231458 | 2020-06-12 | McLean | Illinois | 17113 | 238 | 13 |
228355 | 228355 | 2020-06-11 | McLean | Illinois | 17113 | 235 | 13 |
225253 | 225253 | 2020-06-10 | McLean | Illinois | 17113 | 231 | 13 |
222158 | 222158 | 2020-06-09 | McLean | Illinois | 17113 | 230 | 13 |
219063 | 219063 | 2020-06-08 | McLean | Illinois | 17113 | 228 | 13 |
215972 | 215972 | 2020-06-07 | McLean | Illinois | 17113 | 226 | 13 |
212885 | 212885 | 2020-06-06 | McLean | Illinois | 17113 | 226 | 13 |
209800 | 209800 | 2020-06-05 | McLean | Illinois | 17113 | 226 | 13 |
206719 | 206719 | 2020-06-04 | McLean | Illinois | 17113 | 224 | 13 |
203639 | 203639 | 2020-06-03 | McLean | Illinois | 17113 | 224 | 13 |
200563 | 200563 | 2020-06-02 | McLean | Illinois | 17113 | 221 | 13 |
197490 | 197490 | 2020-06-01 | McLean | Illinois | 17113 | 220 | 13 |
194420 | 194420 | 2020-05-31 | McLean | Illinois | 17113 | 220 | 13 |
191353 | 191353 | 2020-05-30 | McLean | Illinois | 17113 | 218 | 13 |
188288 | 188288 | 2020-05-29 | McLean | Illinois | 17113 | 217 | 13 |
185230 | 185230 | 2020-05-28 | McLean | Illinois | 17113 | 216 | 13 |
182176 | 182176 | 2020-05-27 | McLean | Illinois | 17113 | 215 | 13 |
179132 | 179132 | 2020-05-26 | McLean | Illinois | 17113 | 212 | 10 |
176088 | 176088 | 2020-05-25 | McLean | Illinois | 17113 | 211 | 10 |
173044 | 173044 | 2020-05-24 | McLean | Illinois | 17113 | 204 | 10 |
170003 | 170003 | 2020-05-23 | McLean | Illinois | 17113 | 202 | 9 |
166966 | 166966 | 2020-05-22 | McLean | Illinois | 17113 | 195 | 9 |
163933 | 163933 | 2020-05-21 | McLean | Illinois | 17113 | 195 | 9 |
160905 | 160905 | 2020-05-20 | McLean | Illinois | 17113 | 191 | 6 |
157879 | 157879 | 2020-05-19 | McLean | Illinois | 17113 | 189 | 6 |
154863 | 154863 | 2020-05-18 | McLean | Illinois | 17113 | 186 | 6 |
151851 | 151851 | 2020-05-17 | McLean | Illinois | 17113 | 170 | 6 |
148842 | 148842 | 2020-05-16 | McLean | Illinois | 17113 | 158 | 4 |
145839 | 145839 | 2020-05-15 | McLean | Illinois | 17113 | 132 | 4 |
142839 | 142839 | 2020-05-14 | McLean | Illinois | 17113 | 130 | 3 |
139843 | 139843 | 2020-05-13 | McLean | Illinois | 17113 | 127 | 3 |
136851 | 136851 | 2020-05-12 | McLean | Illinois | 17113 | 126 | 3 |
133862 | 133862 | 2020-05-11 | McLean | Illinois | 17113 | 121 | 3 |
130871 | 130871 | 2020-05-10 | McLean | Illinois | 17113 | 117 | 3 |
127880 | 127880 | 2020-05-09 | McLean | Illinois | 17113 | 115 | 3 |
124893 | 124893 | 2020-05-08 | McLean | Illinois | 17113 | 112 | 3 |
121914 | 121914 | 2020-05-07 | McLean | Illinois | 17113 | 110 | 3 |
118944 | 118944 | 2020-05-06 | McLean | Illinois | 17113 | 108 | 3 |
115984 | 115984 | 2020-05-05 | McLean | Illinois | 17113 | 103 | 3 |
113101 | 113101 | 2020-05-04 | McLean | Illinois | 17113 | 103 | 3 |
110226 | 110226 | 2020-05-03 | McLean | Illinois | 17113 | 99 | 3 |
107356 | 107356 | 2020-05-02 | McLean | Illinois | 17113 | 99 | 3 |
104491 | 104491 | 2020-05-01 | McLean | Illinois | 17113 | 97 | 3 |
101635 | 101635 | 2020-04-30 | McLean | Illinois | 17113 | 95 | 3 |
98784 | 98784 | 2020-04-29 | McLean | Illinois | 17113 | 94 | 3 |
95940 | 95940 | 2020-04-28 | McLean | Illinois | 17113 | 94 | 3 |
93108 | 93108 | 2020-04-27 | McLean | Illinois | 17113 | 92 | 3 |
90289 | 90289 | 2020-04-26 | McLean | Illinois | 17113 | 88 | 3 |
87473 | 87473 | 2020-04-25 | McLean | Illinois | 17113 | 88 | 3 |
84663 | 84663 | 2020-04-24 | McLean | Illinois | 17113 | 87 | 3 |
81863 | 81863 | 2020-04-23 | McLean | Illinois | 17113 | 87 | 3 |
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);