ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
667 rows where county = "Unknown" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
888674 | 888674 | 2021-01-02 | Unknown | Illinois | 0 | 3 | |
700459 | 700459 | 2020-11-05 | Unknown | Illinois | 5932 | 278 | |
697215 | 697215 | 2020-11-04 | Unknown | Illinois | 6087 | 278 | |
693973 | 693973 | 2020-11-03 | Unknown | Illinois | 6034 | 278 | |
690730 | 690730 | 2020-11-02 | Unknown | Illinois | 6034 | 278 | |
687485 | 687485 | 2020-11-01 | Unknown | Illinois | 6061 | 278 | |
684241 | 684241 | 2020-10-31 | Unknown | Illinois | 12048 | 292 | |
680998 | 680998 | 2020-10-30 | Unknown | Illinois | 6061 | 278 | |
677755 | 677755 | 2020-10-29 | Unknown | Illinois | 4529 | 265 | |
674512 | 674512 | 2020-10-28 | Unknown | Illinois | 4553 | 265 | |
671270 | 671270 | 2020-10-27 | Unknown | Illinois | 4560 | 265 | |
668027 | 668027 | 2020-10-26 | Unknown | Illinois | 4574 | 265 | |
664783 | 664783 | 2020-10-25 | Unknown | Illinois | 4577 | 265 | |
661538 | 661538 | 2020-10-24 | Unknown | Illinois | 4577 | 265 | |
658294 | 658294 | 2020-10-23 | Unknown | Illinois | 4577 | 265 | |
655049 | 655049 | 2020-10-22 | Unknown | Illinois | 3458 | 255 | |
651804 | 651804 | 2020-10-21 | Unknown | Illinois | 3458 | 255 | |
648560 | 648560 | 2020-10-20 | Unknown | Illinois | 3462 | 255 | |
645315 | 645315 | 2020-10-19 | Unknown | Illinois | 3467 | 255 | |
642068 | 642068 | 2020-10-18 | Unknown | Illinois | 3477 | 255 | |
638821 | 638821 | 2020-10-17 | Unknown | Illinois | 3477 | 255 | |
635575 | 635575 | 2020-10-16 | Unknown | Illinois | 3477 | 255 | |
632329 | 632329 | 2020-10-15 | Unknown | Illinois | 2939 | 241 | |
629085 | 629085 | 2020-10-14 | Unknown | Illinois | 2941 | 241 | |
625842 | 625842 | 2020-10-13 | Unknown | Illinois | 2943 | 241 | |
622600 | 622600 | 2020-10-12 | Unknown | Illinois | 2652 | 244 | |
619356 | 619356 | 2020-10-11 | Unknown | Illinois | 2652 | 244 | |
616114 | 616114 | 2020-10-10 | Unknown | Illinois | 2652 | 244 | |
612873 | 612873 | 2020-10-09 | Unknown | Illinois | 2652 | 244 | |
609631 | 609631 | 2020-10-08 | Unknown | Illinois | 2654 | 244 | |
606388 | 606388 | 2020-10-07 | Unknown | Illinois | 2658 | 244 | |
603146 | 603146 | 2020-10-06 | Unknown | Illinois | 2659 | 244 | |
599903 | 599903 | 2020-10-05 | Unknown | Illinois | 2659 | 245 | |
596661 | 596661 | 2020-10-04 | Unknown | Illinois | 2661 | 245 | |
593419 | 593419 | 2020-10-03 | Unknown | Illinois | 2661 | 245 | |
590178 | 590178 | 2020-10-02 | Unknown | Illinois | 2661 | 245 | |
586937 | 586937 | 2020-10-01 | Unknown | Illinois | 2412 | 240 | |
583697 | 583697 | 2020-09-30 | Unknown | Illinois | 2412 | 240 | |
580458 | 580458 | 2020-09-29 | Unknown | Illinois | 2413 | 240 | |
577217 | 577217 | 2020-09-28 | Unknown | Illinois | 2413 | 240 | |
573975 | 573975 | 2020-09-27 | Unknown | Illinois | 2416 | 240 | |
570732 | 570732 | 2020-09-26 | Unknown | Illinois | 2416 | 240 | |
567490 | 567490 | 2020-09-25 | Unknown | Illinois | 2416 | 240 | |
564250 | 564250 | 2020-09-24 | Unknown | Illinois | 2125 | 232 | |
561010 | 561010 | 2020-09-23 | Unknown | Illinois | 2127 | 232 | |
557774 | 557774 | 2020-09-22 | Unknown | Illinois | 2128 | 232 | |
554537 | 554537 | 2020-09-21 | Unknown | Illinois | 2130 | 234 | |
551298 | 551298 | 2020-09-20 | Unknown | Illinois | 2131 | 234 | |
548059 | 548059 | 2020-09-19 | Unknown | Illinois | 2131 | 234 | |
544821 | 544821 | 2020-09-18 | Unknown | Illinois | 2131 | 234 | |
541585 | 541585 | 2020-09-17 | Unknown | Illinois | 2028 | 230 | |
538348 | 538348 | 2020-09-16 | Unknown | Illinois | 2028 | 230 | |
535112 | 535112 | 2020-09-15 | Unknown | Illinois | 2027 | 230 | |
531877 | 531877 | 2020-09-14 | Unknown | Illinois | 2028 | 232 | |
528640 | 528640 | 2020-09-13 | Unknown | Illinois | 2027 | 232 | |
525404 | 525404 | 2020-09-12 | Unknown | Illinois | 2027 | 232 | |
522168 | 522168 | 2020-09-11 | Unknown | Illinois | 2027 | 232 | |
518931 | 518931 | 2020-09-10 | Unknown | Illinois | 1863 | 219 | |
515696 | 515696 | 2020-09-09 | Unknown | Illinois | 1863 | 219 | |
512463 | 512463 | 2020-09-08 | Unknown | Illinois | 1863 | 219 | |
509230 | 509230 | 2020-09-07 | Unknown | Illinois | 1863 | 219 | |
505998 | 505998 | 2020-09-06 | Unknown | Illinois | 1863 | 219 | |
502764 | 502764 | 2020-09-05 | Unknown | Illinois | 1863 | 219 | |
499530 | 499530 | 2020-09-04 | Unknown | Illinois | 1863 | 219 | |
496297 | 496297 | 2020-09-03 | Unknown | Illinois | 1641 | 207 | |
493063 | 493063 | 2020-09-02 | Unknown | Illinois | 1641 | 207 | |
489830 | 489830 | 2020-09-01 | Unknown | Illinois | 1645 | 207 | |
486597 | 486597 | 2020-08-31 | Unknown | Illinois | 1645 | 207 | |
483362 | 483362 | 2020-08-30 | Unknown | Illinois | 1645 | 207 | |
480128 | 480128 | 2020-08-29 | Unknown | Illinois | 1645 | 207 | |
476895 | 476895 | 2020-08-28 | Unknown | Illinois | 1645 | 207 | |
473662 | 473662 | 2020-08-27 | Unknown | Illinois | 1361 | 207 | |
470430 | 470430 | 2020-08-26 | Unknown | Illinois | 1374 | 209 | |
467201 | 467201 | 2020-08-25 | Unknown | Illinois | 1362 | 209 | |
463972 | 463972 | 2020-08-24 | Unknown | Illinois | 1361 | 209 | |
460743 | 460743 | 2020-08-23 | Unknown | Illinois | 1415 | 209 | |
457516 | 457516 | 2020-08-22 | Unknown | Illinois | 1417 | 209 | |
454288 | 454288 | 2020-08-21 | Unknown | Illinois | 1361 | 207 | |
451060 | 451060 | 2020-08-20 | Unknown | Illinois | 1276 | 209 | |
447832 | 447832 | 2020-08-19 | Unknown | Illinois | 1276 | 209 | |
444605 | 444605 | 2020-08-18 | Unknown | Illinois | 1332 | 211 | |
441379 | 441379 | 2020-08-17 | Unknown | Illinois | 1275 | 211 | |
438153 | 438153 | 2020-08-16 | Unknown | Illinois | 1274 | 211 | |
434927 | 434927 | 2020-08-15 | Unknown | Illinois | 1296 | 211 | |
431702 | 431702 | 2020-08-14 | Unknown | Illinois | 1274 | 209 | |
428474 | 428474 | 2020-08-13 | Unknown | Illinois | 1244 | 207 | |
425250 | 425250 | 2020-08-12 | Unknown | Illinois | 1244 | 209 | |
422029 | 422029 | 2020-08-11 | Unknown | Illinois | 1244 | 209 | |
418806 | 418806 | 2020-08-10 | Unknown | Illinois | 1300 | 209 | |
415585 | 415585 | 2020-08-09 | Unknown | Illinois | 1300 | 209 | |
412365 | 412365 | 2020-08-08 | Unknown | Illinois | 1274 | 209 | |
409146 | 409146 | 2020-08-07 | Unknown | Illinois | 1244 | 209 | |
405926 | 405926 | 2020-08-06 | Unknown | Illinois | 1264 | 197 | |
402708 | 402708 | 2020-08-05 | Unknown | Illinois | 1251 | 197 | |
399492 | 399492 | 2020-08-04 | Unknown | Illinois | 1228 | 197 | |
396276 | 396276 | 2020-08-03 | Unknown | Illinois | 1228 | 197 | |
393060 | 393060 | 2020-08-02 | Unknown | Illinois | 1281 | 197 | |
389843 | 389843 | 2020-08-01 | Unknown | Illinois | 1256 | 197 | |
386626 | 386626 | 2020-07-31 | Unknown | Illinois | 1229 | 197 | |
383408 | 383408 | 2020-07-30 | Unknown | Illinois | 1190 | 192 |
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);