ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clinton" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930787 | 930787 | 2021-01-15 | Clinton | Illinois | 17027 | 4953 | 84 |
927542 | 927542 | 2021-01-14 | Clinton | Illinois | 17027 | 4910 | 83 |
924296 | 924296 | 2021-01-13 | Clinton | Illinois | 17027 | 4885 | 82 |
921051 | 921051 | 2021-01-12 | Clinton | Illinois | 17027 | 4831 | 81 |
917806 | 917806 | 2021-01-11 | Clinton | Illinois | 17027 | 4813 | 81 |
914561 | 914561 | 2021-01-10 | Clinton | Illinois | 17027 | 4790 | 81 |
911316 | 911316 | 2021-01-09 | Clinton | Illinois | 17027 | 4777 | 81 |
908071 | 908071 | 2021-01-08 | Clinton | Illinois | 17027 | 4754 | 81 |
904825 | 904825 | 2021-01-07 | Clinton | Illinois | 17027 | 4695 | 81 |
901580 | 901580 | 2021-01-06 | Clinton | Illinois | 17027 | 4663 | 81 |
898335 | 898335 | 2021-01-05 | Clinton | Illinois | 17027 | 4600 | 80 |
895090 | 895090 | 2021-01-04 | Clinton | Illinois | 17027 | 4573 | 80 |
891843 | 891843 | 2021-01-03 | Clinton | Illinois | 17027 | 4547 | 80 |
888596 | 888596 | 2021-01-02 | Clinton | Illinois | 17027 | 4531 | 80 |
885351 | 885351 | 2021-01-01 | Clinton | Illinois | 17027 | 4485 | 80 |
882106 | 882106 | 2020-12-31 | Clinton | Illinois | 17027 | 4485 | 80 |
878861 | 878861 | 2020-12-30 | Clinton | Illinois | 17027 | 4420 | 80 |
875616 | 875616 | 2020-12-29 | Clinton | Illinois | 17027 | 4381 | 80 |
872371 | 872371 | 2020-12-28 | Clinton | Illinois | 17027 | 4352 | 80 |
869126 | 869126 | 2020-12-27 | Clinton | Illinois | 17027 | 4342 | 80 |
865881 | 865881 | 2020-12-26 | Clinton | Illinois | 17027 | 4328 | 80 |
862636 | 862636 | 2020-12-25 | Clinton | Illinois | 17027 | 4322 | 80 |
859391 | 859391 | 2020-12-24 | Clinton | Illinois | 17027 | 4307 | 79 |
856146 | 856146 | 2020-12-23 | Clinton | Illinois | 17027 | 4267 | 79 |
852901 | 852901 | 2020-12-22 | Clinton | Illinois | 17027 | 4209 | 79 |
849656 | 849656 | 2020-12-21 | Clinton | Illinois | 17027 | 4175 | 77 |
846411 | 846411 | 2020-12-20 | Clinton | Illinois | 17027 | 4156 | 77 |
843165 | 843165 | 2020-12-19 | Clinton | Illinois | 17027 | 4133 | 77 |
839920 | 839920 | 2020-12-18 | Clinton | Illinois | 17027 | 4117 | 77 |
836675 | 836675 | 2020-12-17 | Clinton | Illinois | 17027 | 4070 | 77 |
833429 | 833429 | 2020-12-16 | Clinton | Illinois | 17027 | 4040 | 74 |
830182 | 830182 | 2020-12-15 | Clinton | Illinois | 17027 | 3979 | 74 |
826936 | 826936 | 2020-12-14 | Clinton | Illinois | 17027 | 3926 | 72 |
823689 | 823689 | 2020-12-13 | Clinton | Illinois | 17027 | 3908 | 72 |
820443 | 820443 | 2020-12-12 | Clinton | Illinois | 17027 | 3878 | 72 |
817197 | 817197 | 2020-12-11 | Clinton | Illinois | 17027 | 3854 | 67 |
813951 | 813951 | 2020-12-10 | Clinton | Illinois | 17027 | 3796 | 66 |
810706 | 810706 | 2020-12-09 | Clinton | Illinois | 17027 | 3751 | 66 |
807461 | 807461 | 2020-12-08 | Clinton | Illinois | 17027 | 3684 | 66 |
804216 | 804216 | 2020-12-07 | Clinton | Illinois | 17027 | 3649 | 65 |
800971 | 800971 | 2020-12-06 | Clinton | Illinois | 17027 | 3617 | 65 |
797726 | 797726 | 2020-12-05 | Clinton | Illinois | 17027 | 3584 | 65 |
794481 | 794481 | 2020-12-04 | Clinton | Illinois | 17027 | 3557 | 63 |
791236 | 791236 | 2020-12-03 | Clinton | Illinois | 17027 | 3491 | 63 |
787991 | 787991 | 2020-12-02 | Clinton | Illinois | 17027 | 3453 | 62 |
784747 | 784747 | 2020-12-01 | Clinton | Illinois | 17027 | 3380 | 61 |
781502 | 781502 | 2020-11-30 | Clinton | Illinois | 17027 | 3337 | 61 |
778256 | 778256 | 2020-11-29 | Clinton | Illinois | 17027 | 3308 | 61 |
775011 | 775011 | 2020-11-28 | Clinton | Illinois | 17027 | 3279 | 61 |
771766 | 771766 | 2020-11-27 | Clinton | Illinois | 17027 | 3247 | 61 |
768521 | 768521 | 2020-11-26 | Clinton | Illinois | 17027 | 3235 | 60 |
765275 | 765275 | 2020-11-25 | Clinton | Illinois | 17027 | 3109 | 59 |
762030 | 762030 | 2020-11-24 | Clinton | Illinois | 17027 | 3035 | 56 |
758785 | 758785 | 2020-11-23 | Clinton | Illinois | 17027 | 2984 | 56 |
755538 | 755538 | 2020-11-22 | Clinton | Illinois | 17027 | 2943 | 56 |
752292 | 752292 | 2020-11-21 | Clinton | Illinois | 17027 | 2910 | 56 |
749046 | 749046 | 2020-11-20 | Clinton | Illinois | 17027 | 2875 | 56 |
745800 | 745800 | 2020-11-19 | Clinton | Illinois | 17027 | 2784 | 56 |
742553 | 742553 | 2020-11-18 | Clinton | Illinois | 17027 | 2727 | 55 |
739306 | 739306 | 2020-11-17 | Clinton | Illinois | 17027 | 2647 | 52 |
736062 | 736062 | 2020-11-16 | Clinton | Illinois | 17027 | 2579 | 52 |
732816 | 732816 | 2020-11-15 | Clinton | Illinois | 17027 | 2542 | 51 |
729571 | 729571 | 2020-11-14 | Clinton | Illinois | 17027 | 2512 | 50 |
726328 | 726328 | 2020-11-13 | Clinton | Illinois | 17027 | 2453 | 47 |
723085 | 723085 | 2020-11-12 | Clinton | Illinois | 17027 | 2392 | 47 |
719842 | 719842 | 2020-11-11 | Clinton | Illinois | 17027 | 2368 | 39 |
716599 | 716599 | 2020-11-10 | Clinton | Illinois | 17027 | 2294 | 37 |
713355 | 713355 | 2020-11-09 | Clinton | Illinois | 17027 | 2207 | 36 |
710111 | 710111 | 2020-11-08 | Clinton | Illinois | 17027 | 2164 | 36 |
706867 | 706867 | 2020-11-07 | Clinton | Illinois | 17027 | 2142 | 36 |
703624 | 703624 | 2020-11-06 | Clinton | Illinois | 17027 | 2100 | 36 |
700381 | 700381 | 2020-11-05 | Clinton | Illinois | 17027 | 2031 | 35 |
697137 | 697137 | 2020-11-04 | Clinton | Illinois | 17027 | 1988 | 32 |
693895 | 693895 | 2020-11-03 | Clinton | Illinois | 17027 | 1966 | 32 |
690652 | 690652 | 2020-11-02 | Clinton | Illinois | 17027 | 1936 | 31 |
687407 | 687407 | 2020-11-01 | Clinton | Illinois | 17027 | 1919 | 31 |
684163 | 684163 | 2020-10-31 | Clinton | Illinois | 17027 | 1877 | 31 |
680920 | 680920 | 2020-10-30 | Clinton | Illinois | 17027 | 1877 | 31 |
677677 | 677677 | 2020-10-29 | Clinton | Illinois | 17027 | 1856 | 31 |
674434 | 674434 | 2020-10-28 | Clinton | Illinois | 17027 | 1828 | 29 |
671192 | 671192 | 2020-10-27 | Clinton | Illinois | 17027 | 1811 | 28 |
667949 | 667949 | 2020-10-26 | Clinton | Illinois | 17027 | 1789 | 26 |
664705 | 664705 | 2020-10-25 | Clinton | Illinois | 17027 | 1755 | 26 |
661460 | 661460 | 2020-10-24 | Clinton | Illinois | 17027 | 1733 | 26 |
658216 | 658216 | 2020-10-23 | Clinton | Illinois | 17027 | 1709 | 26 |
654971 | 654971 | 2020-10-22 | Clinton | Illinois | 17027 | 1687 | 25 |
651726 | 651726 | 2020-10-21 | Clinton | Illinois | 17027 | 1663 | 25 |
648482 | 648482 | 2020-10-20 | Clinton | Illinois | 17027 | 1631 | 24 |
645237 | 645237 | 2020-10-19 | Clinton | Illinois | 17027 | 1587 | 24 |
641990 | 641990 | 2020-10-18 | Clinton | Illinois | 17027 | 1560 | 24 |
638743 | 638743 | 2020-10-17 | Clinton | Illinois | 17027 | 1541 | 24 |
635497 | 635497 | 2020-10-16 | Clinton | Illinois | 17027 | 1515 | 23 |
632251 | 632251 | 2020-10-15 | Clinton | Illinois | 17027 | 1480 | 23 |
629007 | 629007 | 2020-10-14 | Clinton | Illinois | 17027 | 1452 | 23 |
625764 | 625764 | 2020-10-13 | Clinton | Illinois | 17027 | 1438 | 23 |
622522 | 622522 | 2020-10-12 | Clinton | Illinois | 17027 | 1430 | 23 |
619278 | 619278 | 2020-10-11 | Clinton | Illinois | 17027 | 1411 | 23 |
616036 | 616036 | 2020-10-10 | Clinton | Illinois | 17027 | 1400 | 23 |
612795 | 612795 | 2020-10-09 | Clinton | Illinois | 17027 | 1377 | 23 |
609553 | 609553 | 2020-10-08 | Clinton | Illinois | 17027 | 1355 | 23 |
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);