ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 17027 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
606310 | 606310 | 2020-10-07 | Clinton | Illinois | 17027 | 1338 | 23 |
603068 | 603068 | 2020-10-06 | Clinton | Illinois | 17027 | 1319 | 22 |
599825 | 599825 | 2020-10-05 | Clinton | Illinois | 17027 | 1309 | 21 |
596583 | 596583 | 2020-10-04 | Clinton | Illinois | 17027 | 1297 | 21 |
593341 | 593341 | 2020-10-03 | Clinton | Illinois | 17027 | 1279 | 21 |
590100 | 590100 | 2020-10-02 | Clinton | Illinois | 17027 | 1261 | 21 |
586859 | 586859 | 2020-10-01 | Clinton | Illinois | 17027 | 1239 | 21 |
583619 | 583619 | 2020-09-30 | Clinton | Illinois | 17027 | 1222 | 21 |
580380 | 580380 | 2020-09-29 | Clinton | Illinois | 17027 | 1203 | 21 |
577139 | 577139 | 2020-09-28 | Clinton | Illinois | 17027 | 1190 | 20 |
573897 | 573897 | 2020-09-27 | Clinton | Illinois | 17027 | 1169 | 20 |
570654 | 570654 | 2020-09-26 | Clinton | Illinois | 17027 | 1153 | 20 |
567412 | 567412 | 2020-09-25 | Clinton | Illinois | 17027 | 1129 | 20 |
564172 | 564172 | 2020-09-24 | Clinton | Illinois | 17027 | 1101 | 20 |
560932 | 560932 | 2020-09-23 | Clinton | Illinois | 17027 | 1088 | 20 |
557696 | 557696 | 2020-09-22 | Clinton | Illinois | 17027 | 1084 | 20 |
554459 | 554459 | 2020-09-21 | Clinton | Illinois | 17027 | 1071 | 20 |
551220 | 551220 | 2020-09-20 | Clinton | Illinois | 17027 | 1064 | 20 |
547981 | 547981 | 2020-09-19 | Clinton | Illinois | 17027 | 1051 | 20 |
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);