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 |
---|---|---|---|---|---|---|---|
535084 | 535084 | 2020-09-15 | McLean | Illinois | 17113 | 2980 | 18 |
531849 | 531849 | 2020-09-14 | McLean | Illinois | 17113 | 2931 | 18 |
528612 | 528612 | 2020-09-13 | McLean | Illinois | 17113 | 2909 | 18 |
525376 | 525376 | 2020-09-12 | McLean | Illinois | 17113 | 2881 | 18 |
522140 | 522140 | 2020-09-11 | McLean | Illinois | 17113 | 2827 | 18 |
518903 | 518903 | 2020-09-10 | McLean | Illinois | 17113 | 2783 | 18 |
515668 | 515668 | 2020-09-09 | McLean | Illinois | 17113 | 2697 | 17 |
512435 | 512435 | 2020-09-08 | McLean | Illinois | 17113 | 2662 | 17 |
509202 | 509202 | 2020-09-07 | McLean | Illinois | 17113 | 2640 | 17 |
505970 | 505970 | 2020-09-06 | McLean | Illinois | 17113 | 2607 | 17 |
502736 | 502736 | 2020-09-05 | McLean | Illinois | 17113 | 2550 | 17 |
499502 | 499502 | 2020-09-04 | McLean | Illinois | 17113 | 2454 | 17 |
496269 | 496269 | 2020-09-03 | McLean | Illinois | 17113 | 2162 | 16 |
493035 | 493035 | 2020-09-02 | McLean | Illinois | 17113 | 2063 | 16 |
489802 | 489802 | 2020-09-01 | McLean | Illinois | 17113 | 1869 | 16 |
486569 | 486569 | 2020-08-31 | McLean | Illinois | 17113 | 1788 | 16 |
483334 | 483334 | 2020-08-30 | McLean | Illinois | 17113 | 1674 | 16 |
480100 | 480100 | 2020-08-29 | McLean | Illinois | 17113 | 1474 | 16 |
476867 | 476867 | 2020-08-28 | McLean | Illinois | 17113 | 1379 | 16 |
473634 | 473634 | 2020-08-27 | McLean | Illinois | 17113 | 1323 | 16 |
470402 | 470402 | 2020-08-26 | McLean | Illinois | 17113 | 1250 | 16 |
467173 | 467173 | 2020-08-25 | McLean | Illinois | 17113 | 1188 | 16 |
463944 | 463944 | 2020-08-24 | McLean | Illinois | 17113 | 1138 | 16 |
460715 | 460715 | 2020-08-23 | McLean | Illinois | 17113 | 1082 | 16 |
457488 | 457488 | 2020-08-22 | McLean | Illinois | 17113 | 1004 | 16 |
454260 | 454260 | 2020-08-21 | McLean | Illinois | 17113 | 936 | 16 |
451032 | 451032 | 2020-08-20 | McLean | Illinois | 17113 | 896 | 16 |
447804 | 447804 | 2020-08-19 | McLean | Illinois | 17113 | 876 | 16 |
444577 | 444577 | 2020-08-18 | McLean | Illinois | 17113 | 834 | 16 |
441351 | 441351 | 2020-08-17 | McLean | Illinois | 17113 | 782 | 16 |
438125 | 438125 | 2020-08-16 | McLean | Illinois | 17113 | 773 | 15 |
434899 | 434899 | 2020-08-15 | McLean | Illinois | 17113 | 756 | 15 |
431674 | 431674 | 2020-08-14 | McLean | Illinois | 17113 | 730 | 15 |
428446 | 428446 | 2020-08-13 | McLean | Illinois | 17113 | 703 | 15 |
425222 | 425222 | 2020-08-12 | McLean | Illinois | 17113 | 686 | 15 |
422001 | 422001 | 2020-08-11 | McLean | Illinois | 17113 | 670 | 15 |
418778 | 418778 | 2020-08-10 | McLean | Illinois | 17113 | 655 | 15 |
415557 | 415557 | 2020-08-09 | McLean | Illinois | 17113 | 651 | 15 |
412337 | 412337 | 2020-08-08 | McLean | Illinois | 17113 | 638 | 15 |
409118 | 409118 | 2020-08-07 | McLean | Illinois | 17113 | 624 | 15 |
405898 | 405898 | 2020-08-06 | McLean | Illinois | 17113 | 611 | 15 |
402680 | 402680 | 2020-08-05 | McLean | Illinois | 17113 | 595 | 15 |
399464 | 399464 | 2020-08-04 | McLean | Illinois | 17113 | 584 | 15 |
396248 | 396248 | 2020-08-03 | McLean | Illinois | 17113 | 572 | 15 |
393032 | 393032 | 2020-08-02 | McLean | Illinois | 17113 | 562 | 15 |
389815 | 389815 | 2020-08-01 | McLean | Illinois | 17113 | 552 | 15 |
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 |
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);