ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Lee" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921089 | 921089 | 2021-01-12 | Lee | Illinois | 17103 | 2921 | 70 |
917844 | 917844 | 2021-01-11 | Lee | Illinois | 17103 | 2909 | 69 |
914599 | 914599 | 2021-01-10 | Lee | Illinois | 17103 | 2885 | 69 |
911354 | 911354 | 2021-01-09 | Lee | Illinois | 17103 | 2869 | 69 |
908109 | 908109 | 2021-01-08 | Lee | Illinois | 17103 | 2864 | 69 |
904863 | 904863 | 2021-01-07 | Lee | Illinois | 17103 | 2843 | 69 |
901618 | 901618 | 2021-01-06 | Lee | Illinois | 17103 | 2821 | 66 |
898373 | 898373 | 2021-01-05 | Lee | Illinois | 17103 | 2772 | 65 |
895128 | 895128 | 2021-01-04 | Lee | Illinois | 17103 | 2750 | 64 |
891881 | 891881 | 2021-01-03 | Lee | Illinois | 17103 | 2744 | 64 |
888634 | 888634 | 2021-01-02 | Lee | Illinois | 17103 | 2741 | 64 |
885389 | 885389 | 2021-01-01 | Lee | Illinois | 17103 | 2707 | 64 |
882144 | 882144 | 2020-12-31 | Lee | Illinois | 17103 | 2707 | 64 |
878899 | 878899 | 2020-12-30 | Lee | Illinois | 17103 | 2694 | 64 |
875654 | 875654 | 2020-12-29 | Lee | Illinois | 17103 | 2670 | 64 |
872409 | 872409 | 2020-12-28 | Lee | Illinois | 17103 | 2658 | 64 |
869164 | 869164 | 2020-12-27 | Lee | Illinois | 17103 | 2648 | 64 |
865919 | 865919 | 2020-12-26 | Lee | Illinois | 17103 | 2641 | 64 |
862674 | 862674 | 2020-12-25 | Lee | Illinois | 17103 | 2629 | 63 |
859429 | 859429 | 2020-12-24 | Lee | Illinois | 17103 | 2604 | 63 |
856184 | 856184 | 2020-12-23 | Lee | Illinois | 17103 | 2585 | 64 |
852939 | 852939 | 2020-12-22 | Lee | Illinois | 17103 | 2560 | 64 |
849694 | 849694 | 2020-12-21 | Lee | Illinois | 17103 | 2550 | 63 |
846449 | 846449 | 2020-12-20 | Lee | Illinois | 17103 | 2535 | 62 |
843203 | 843203 | 2020-12-19 | Lee | Illinois | 17103 | 2522 | 62 |
839958 | 839958 | 2020-12-18 | Lee | Illinois | 17103 | 2481 | 61 |
836713 | 836713 | 2020-12-17 | Lee | Illinois | 17103 | 2450 | 60 |
833467 | 833467 | 2020-12-16 | Lee | Illinois | 17103 | 2431 | 59 |
830220 | 830220 | 2020-12-15 | Lee | Illinois | 17103 | 2412 | 59 |
826974 | 826974 | 2020-12-14 | Lee | Illinois | 17103 | 2400 | 54 |
823727 | 823727 | 2020-12-13 | Lee | Illinois | 17103 | 2386 | 54 |
820481 | 820481 | 2020-12-12 | Lee | Illinois | 17103 | 2329 | 54 |
817235 | 817235 | 2020-12-11 | Lee | Illinois | 17103 | 2299 | 52 |
813989 | 813989 | 2020-12-10 | Lee | Illinois | 17103 | 2282 | 48 |
810744 | 810744 | 2020-12-09 | Lee | Illinois | 17103 | 2246 | 47 |
807499 | 807499 | 2020-12-08 | Lee | Illinois | 17103 | 2220 | 43 |
804254 | 804254 | 2020-12-07 | Lee | Illinois | 17103 | 2217 | 42 |
801009 | 801009 | 2020-12-06 | Lee | Illinois | 17103 | 2200 | 42 |
797764 | 797764 | 2020-12-05 | Lee | Illinois | 17103 | 2188 | 42 |
794519 | 794519 | 2020-12-04 | Lee | Illinois | 17103 | 2133 | 38 |
791274 | 791274 | 2020-12-03 | Lee | Illinois | 17103 | 2113 | 38 |
788029 | 788029 | 2020-12-02 | Lee | Illinois | 17103 | 2059 | 37 |
784785 | 784785 | 2020-12-01 | Lee | Illinois | 17103 | 2046 | 36 |
781540 | 781540 | 2020-11-30 | Lee | Illinois | 17103 | 2019 | 35 |
778294 | 778294 | 2020-11-29 | Lee | Illinois | 17103 | 2010 | 34 |
775049 | 775049 | 2020-11-28 | Lee | Illinois | 17103 | 1989 | 34 |
771804 | 771804 | 2020-11-27 | Lee | Illinois | 17103 | 1963 | 34 |
768559 | 768559 | 2020-11-26 | Lee | Illinois | 17103 | 1894 | 29 |
765313 | 765313 | 2020-11-25 | Lee | Illinois | 17103 | 1801 | 26 |
762068 | 762068 | 2020-11-24 | Lee | Illinois | 17103 | 1722 | 24 |
758823 | 758823 | 2020-11-23 | Lee | Illinois | 17103 | 1699 | 22 |
755576 | 755576 | 2020-11-22 | Lee | Illinois | 17103 | 1680 | 22 |
752330 | 752330 | 2020-11-21 | Lee | Illinois | 17103 | 1645 | 20 |
749084 | 749084 | 2020-11-20 | Lee | Illinois | 17103 | 1603 | 18 |
745838 | 745838 | 2020-11-19 | Lee | Illinois | 17103 | 1564 | 17 |
742591 | 742591 | 2020-11-18 | Lee | Illinois | 17103 | 1532 | 14 |
739344 | 739344 | 2020-11-17 | Lee | Illinois | 17103 | 1520 | 14 |
736100 | 736100 | 2020-11-16 | Lee | Illinois | 17103 | 1470 | 14 |
732854 | 732854 | 2020-11-15 | Lee | Illinois | 17103 | 1425 | 14 |
729609 | 729609 | 2020-11-14 | Lee | Illinois | 17103 | 1384 | 13 |
726366 | 726366 | 2020-11-13 | Lee | Illinois | 17103 | 1366 | 11 |
723123 | 723123 | 2020-11-12 | Lee | Illinois | 17103 | 1296 | 9 |
719880 | 719880 | 2020-11-11 | Lee | Illinois | 17103 | 1273 | 9 |
716637 | 716637 | 2020-11-10 | Lee | Illinois | 17103 | 1248 | 8 |
713393 | 713393 | 2020-11-09 | Lee | Illinois | 17103 | 1201 | 8 |
710149 | 710149 | 2020-11-08 | Lee | Illinois | 17103 | 1150 | 7 |
706905 | 706905 | 2020-11-07 | Lee | Illinois | 17103 | 1103 | 6 |
703662 | 703662 | 2020-11-06 | Lee | Illinois | 17103 | 1056 | 6 |
700419 | 700419 | 2020-11-05 | Lee | Illinois | 17103 | 1018 | 4 |
697175 | 697175 | 2020-11-04 | Lee | Illinois | 17103 | 997 | 4 |
693933 | 693933 | 2020-11-03 | Lee | Illinois | 17103 | 973 | 4 |
690690 | 690690 | 2020-11-02 | Lee | Illinois | 17103 | 955 | 2 |
687445 | 687445 | 2020-11-01 | Lee | Illinois | 17103 | 926 | 2 |
684201 | 684201 | 2020-10-31 | Lee | Illinois | 17103 | 840 | 2 |
680958 | 680958 | 2020-10-30 | Lee | Illinois | 17103 | 840 | 2 |
677715 | 677715 | 2020-10-29 | Lee | Illinois | 17103 | 787 | 2 |
674472 | 674472 | 2020-10-28 | Lee | Illinois | 17103 | 769 | 2 |
671230 | 671230 | 2020-10-27 | Lee | Illinois | 17103 | 754 | 2 |
667987 | 667987 | 2020-10-26 | Lee | Illinois | 17103 | 740 | 2 |
664743 | 664743 | 2020-10-25 | Lee | Illinois | 17103 | 710 | 2 |
661498 | 661498 | 2020-10-24 | Lee | Illinois | 17103 | 705 | 1 |
658254 | 658254 | 2020-10-23 | Lee | Illinois | 17103 | 669 | 1 |
655009 | 655009 | 2020-10-22 | Lee | Illinois | 17103 | 658 | 1 |
651764 | 651764 | 2020-10-21 | Lee | Illinois | 17103 | 641 | 1 |
648520 | 648520 | 2020-10-20 | Lee | Illinois | 17103 | 627 | 1 |
645275 | 645275 | 2020-10-19 | Lee | Illinois | 17103 | 612 | 1 |
642028 | 642028 | 2020-10-18 | Lee | Illinois | 17103 | 592 | 1 |
638781 | 638781 | 2020-10-17 | Lee | Illinois | 17103 | 564 | 1 |
635535 | 635535 | 2020-10-16 | Lee | Illinois | 17103 | 562 | 1 |
632289 | 632289 | 2020-10-15 | Lee | Illinois | 17103 | 549 | 1 |
629045 | 629045 | 2020-10-14 | Lee | Illinois | 17103 | 525 | 1 |
625802 | 625802 | 2020-10-13 | Lee | Illinois | 17103 | 517 | 1 |
622560 | 622560 | 2020-10-12 | Lee | Illinois | 17103 | 505 | 1 |
619316 | 619316 | 2020-10-11 | Lee | Illinois | 17103 | 501 | 1 |
616074 | 616074 | 2020-10-10 | Lee | Illinois | 17103 | 497 | 1 |
612833 | 612833 | 2020-10-09 | Lee | Illinois | 17103 | 484 | 1 |
609591 | 609591 | 2020-10-08 | Lee | Illinois | 17103 | 472 | 1 |
606348 | 606348 | 2020-10-07 | Lee | Illinois | 17103 | 451 | 1 |
603106 | 603106 | 2020-10-06 | Lee | Illinois | 17103 | 442 | 1 |
599863 | 599863 | 2020-10-05 | Lee | Illinois | 17103 | 440 | 1 |
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);