ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Fayette" and fips = 17051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054131 | 1054131 | 2021-02-22 | Fayette | Illinois | 17051 | 3059 | 55 |
1050884 | 1050884 | 2021-02-21 | Fayette | Illinois | 17051 | 3059 | 55 |
1047637 | 1047637 | 2021-02-20 | Fayette | Illinois | 17051 | 3058 | 55 |
1044392 | 1044392 | 2021-02-19 | Fayette | Illinois | 17051 | 3056 | 55 |
1041147 | 1041147 | 2021-02-18 | Fayette | Illinois | 17051 | 3052 | 55 |
1037902 | 1037902 | 2021-02-17 | Fayette | Illinois | 17051 | 3050 | 55 |
1034657 | 1034657 | 2021-02-16 | Fayette | Illinois | 17051 | 3049 | 55 |
1031411 | 1031411 | 2021-02-15 | Fayette | Illinois | 17051 | 3049 | 55 |
1028164 | 1028164 | 2021-02-14 | Fayette | Illinois | 17051 | 3049 | 55 |
1024919 | 1024919 | 2021-02-13 | Fayette | Illinois | 17051 | 3047 | 55 |
1021674 | 1021674 | 2021-02-12 | Fayette | Illinois | 17051 | 3043 | 55 |
1018429 | 1018429 | 2021-02-11 | Fayette | Illinois | 17051 | 3042 | 55 |
1015184 | 1015184 | 2021-02-10 | Fayette | Illinois | 17051 | 3041 | 55 |
1011939 | 1011939 | 2021-02-09 | Fayette | Illinois | 17051 | 3040 | 55 |
1008693 | 1008693 | 2021-02-08 | Fayette | Illinois | 17051 | 3039 | 55 |
1005447 | 1005447 | 2021-02-07 | Fayette | Illinois | 17051 | 3039 | 55 |
1002201 | 1002201 | 2021-02-06 | Fayette | Illinois | 17051 | 3037 | 55 |
998955 | 998955 | 2021-02-05 | Fayette | Illinois | 17051 | 3035 | 55 |
995709 | 995709 | 2021-02-04 | Fayette | Illinois | 17051 | 3028 | 54 |
992463 | 992463 | 2021-02-03 | Fayette | Illinois | 17051 | 3027 | 54 |
989217 | 989217 | 2021-02-02 | Fayette | Illinois | 17051 | 3018 | 54 |
985970 | 985970 | 2021-02-01 | Fayette | Illinois | 17051 | 3012 | 54 |
982723 | 982723 | 2021-01-31 | Fayette | Illinois | 17051 | 3012 | 54 |
979477 | 979477 | 2021-01-30 | Fayette | Illinois | 17051 | 3011 | 54 |
976232 | 976232 | 2021-01-29 | Fayette | Illinois | 17051 | 3002 | 54 |
972987 | 972987 | 2021-01-28 | Fayette | Illinois | 17051 | 2993 | 53 |
969742 | 969742 | 2021-01-27 | Fayette | Illinois | 17051 | 2985 | 54 |
966498 | 966498 | 2021-01-26 | Fayette | Illinois | 17051 | 2976 | 53 |
963253 | 963253 | 2021-01-25 | Fayette | Illinois | 17051 | 2968 | 53 |
960008 | 960008 | 2021-01-24 | Fayette | Illinois | 17051 | 2967 | 53 |
956762 | 956762 | 2021-01-23 | Fayette | Illinois | 17051 | 2961 | 53 |
953517 | 953517 | 2021-01-22 | Fayette | Illinois | 17051 | 2954 | 53 |
950272 | 950272 | 2021-01-21 | Fayette | Illinois | 17051 | 2936 | 53 |
947026 | 947026 | 2021-01-20 | Fayette | Illinois | 17051 | 2922 | 53 |
943779 | 943779 | 2021-01-19 | Fayette | Illinois | 17051 | 2911 | 53 |
940534 | 940534 | 2021-01-18 | Fayette | Illinois | 17051 | 2906 | 53 |
937289 | 937289 | 2021-01-17 | Fayette | Illinois | 17051 | 2898 | 53 |
934044 | 934044 | 2021-01-16 | Fayette | Illinois | 17051 | 2892 | 53 |
930799 | 930799 | 2021-01-15 | Fayette | Illinois | 17051 | 2885 | 53 |
927554 | 927554 | 2021-01-14 | Fayette | Illinois | 17051 | 2864 | 53 |
924308 | 924308 | 2021-01-13 | Fayette | Illinois | 17051 | 2857 | 53 |
921063 | 921063 | 2021-01-12 | Fayette | Illinois | 17051 | 2842 | 53 |
917818 | 917818 | 2021-01-11 | Fayette | Illinois | 17051 | 2829 | 52 |
914573 | 914573 | 2021-01-10 | Fayette | Illinois | 17051 | 2816 | 52 |
911328 | 911328 | 2021-01-09 | Fayette | Illinois | 17051 | 2810 | 52 |
908083 | 908083 | 2021-01-08 | Fayette | Illinois | 17051 | 2804 | 52 |
904837 | 904837 | 2021-01-07 | Fayette | Illinois | 17051 | 2777 | 51 |
901592 | 901592 | 2021-01-06 | Fayette | Illinois | 17051 | 2756 | 50 |
898347 | 898347 | 2021-01-05 | Fayette | Illinois | 17051 | 2706 | 50 |
895102 | 895102 | 2021-01-04 | Fayette | Illinois | 17051 | 2697 | 50 |
891855 | 891855 | 2021-01-03 | Fayette | Illinois | 17051 | 2692 | 50 |
888608 | 888608 | 2021-01-02 | Fayette | Illinois | 17051 | 2680 | 50 |
885363 | 885363 | 2021-01-01 | Fayette | Illinois | 17051 | 2664 | 49 |
882118 | 882118 | 2020-12-31 | Fayette | Illinois | 17051 | 2664 | 49 |
878873 | 878873 | 2020-12-30 | Fayette | Illinois | 17051 | 2645 | 49 |
875628 | 875628 | 2020-12-29 | Fayette | Illinois | 17051 | 2627 | 49 |
872383 | 872383 | 2020-12-28 | Fayette | Illinois | 17051 | 2602 | 49 |
869138 | 869138 | 2020-12-27 | Fayette | Illinois | 17051 | 2591 | 49 |
865893 | 865893 | 2020-12-26 | Fayette | Illinois | 17051 | 2575 | 49 |
862648 | 862648 | 2020-12-25 | Fayette | Illinois | 17051 | 2571 | 49 |
859403 | 859403 | 2020-12-24 | Fayette | Illinois | 17051 | 2564 | 49 |
856158 | 856158 | 2020-12-23 | Fayette | Illinois | 17051 | 2544 | 48 |
852913 | 852913 | 2020-12-22 | Fayette | Illinois | 17051 | 2530 | 48 |
849668 | 849668 | 2020-12-21 | Fayette | Illinois | 17051 | 2508 | 46 |
846423 | 846423 | 2020-12-20 | Fayette | Illinois | 17051 | 2502 | 46 |
843177 | 843177 | 2020-12-19 | Fayette | Illinois | 17051 | 2496 | 45 |
839932 | 839932 | 2020-12-18 | Fayette | Illinois | 17051 | 2480 | 45 |
836687 | 836687 | 2020-12-17 | Fayette | Illinois | 17051 | 2463 | 44 |
833441 | 833441 | 2020-12-16 | Fayette | Illinois | 17051 | 2432 | 42 |
830194 | 830194 | 2020-12-15 | Fayette | Illinois | 17051 | 2410 | 41 |
826948 | 826948 | 2020-12-14 | Fayette | Illinois | 17051 | 2289 | 41 |
823701 | 823701 | 2020-12-13 | Fayette | Illinois | 17051 | 2285 | 40 |
820455 | 820455 | 2020-12-12 | Fayette | Illinois | 17051 | 2257 | 40 |
817209 | 817209 | 2020-12-11 | Fayette | Illinois | 17051 | 2223 | 40 |
813963 | 813963 | 2020-12-10 | Fayette | Illinois | 17051 | 2176 | 40 |
810718 | 810718 | 2020-12-09 | Fayette | Illinois | 17051 | 2098 | 40 |
807473 | 807473 | 2020-12-08 | Fayette | Illinois | 17051 | 2088 | 40 |
804228 | 804228 | 2020-12-07 | Fayette | Illinois | 17051 | 2041 | 40 |
800983 | 800983 | 2020-12-06 | Fayette | Illinois | 17051 | 2019 | 39 |
797738 | 797738 | 2020-12-05 | Fayette | Illinois | 17051 | 2003 | 39 |
794493 | 794493 | 2020-12-04 | Fayette | Illinois | 17051 | 1955 | 37 |
791248 | 791248 | 2020-12-03 | Fayette | Illinois | 17051 | 1912 | 36 |
788003 | 788003 | 2020-12-02 | Fayette | Illinois | 17051 | 1860 | 33 |
784759 | 784759 | 2020-12-01 | Fayette | Illinois | 17051 | 1812 | 31 |
781514 | 781514 | 2020-11-30 | Fayette | Illinois | 17051 | 1722 | 31 |
778268 | 778268 | 2020-11-29 | Fayette | Illinois | 17051 | 1709 | 31 |
775023 | 775023 | 2020-11-28 | Fayette | Illinois | 17051 | 1705 | 29 |
771778 | 771778 | 2020-11-27 | Fayette | Illinois | 17051 | 1650 | 29 |
768533 | 768533 | 2020-11-26 | Fayette | Illinois | 17051 | 1638 | 28 |
765287 | 765287 | 2020-11-25 | Fayette | Illinois | 17051 | 1525 | 28 |
762042 | 762042 | 2020-11-24 | Fayette | Illinois | 17051 | 1463 | 28 |
758797 | 758797 | 2020-11-23 | Fayette | Illinois | 17051 | 1434 | 28 |
755550 | 755550 | 2020-11-22 | Fayette | Illinois | 17051 | 1411 | 28 |
752304 | 752304 | 2020-11-21 | Fayette | Illinois | 17051 | 1386 | 28 |
749058 | 749058 | 2020-11-20 | Fayette | Illinois | 17051 | 1371 | 27 |
745812 | 745812 | 2020-11-19 | Fayette | Illinois | 17051 | 1347 | 27 |
742565 | 742565 | 2020-11-18 | Fayette | Illinois | 17051 | 1287 | 27 |
739318 | 739318 | 2020-11-17 | Fayette | Illinois | 17051 | 1223 | 26 |
736074 | 736074 | 2020-11-16 | Fayette | Illinois | 17051 | 1187 | 26 |
732828 | 732828 | 2020-11-15 | Fayette | Illinois | 17051 | 1170 | 26 |
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);