ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Fayette" and fips = 21067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054540 | 1054540 | 2021-02-22 | Fayette | Kentucky | 21067 | 32131 | 230 |
1051293 | 1051293 | 2021-02-21 | Fayette | Kentucky | 21067 | 32099 | 224 |
1048046 | 1048046 | 2021-02-20 | Fayette | Kentucky | 21067 | 32009 | 224 |
1044801 | 1044801 | 2021-02-19 | Fayette | Kentucky | 21067 | 31935 | 223 |
1041556 | 1041556 | 2021-02-18 | Fayette | Kentucky | 21067 | 31821 | 219 |
1038311 | 1038311 | 2021-02-17 | Fayette | Kentucky | 21067 | 31757 | 218 |
1035066 | 1035066 | 2021-02-16 | Fayette | Kentucky | 21067 | 31654 | 218 |
1031820 | 1031820 | 2021-02-15 | Fayette | Kentucky | 21067 | 31526 | 217 |
1028573 | 1028573 | 2021-02-14 | Fayette | Kentucky | 21067 | 31465 | 212 |
1025328 | 1025328 | 2021-02-13 | Fayette | Kentucky | 21067 | 31299 | 212 |
1022083 | 1022083 | 2021-02-12 | Fayette | Kentucky | 21067 | 31252 | 212 |
1018838 | 1018838 | 2021-02-11 | Fayette | Kentucky | 21067 | 31173 | 211 |
1015593 | 1015593 | 2021-02-10 | Fayette | Kentucky | 21067 | 31065 | 211 |
1012348 | 1012348 | 2021-02-09 | Fayette | Kentucky | 21067 | 30917 | 211 |
1009102 | 1009102 | 2021-02-08 | Fayette | Kentucky | 21067 | 30799 | 209 |
1005856 | 1005856 | 2021-02-07 | Fayette | Kentucky | 21067 | 30728 | 206 |
1002610 | 1002610 | 2021-02-06 | Fayette | Kentucky | 21067 | 30601 | 206 |
999364 | 999364 | 2021-02-05 | Fayette | Kentucky | 21067 | 30454 | 205 |
996118 | 996118 | 2021-02-04 | Fayette | Kentucky | 21067 | 30321 | 205 |
992872 | 992872 | 2021-02-03 | Fayette | Kentucky | 21067 | 30165 | 196 |
989626 | 989626 | 2021-02-02 | Fayette | Kentucky | 21067 | 30009 | 196 |
986379 | 986379 | 2021-02-01 | Fayette | Kentucky | 21067 | 29870 | 195 |
983132 | 983132 | 2021-01-31 | Fayette | Kentucky | 21067 | 29758 | 195 |
979886 | 979886 | 2021-01-30 | Fayette | Kentucky | 21067 | 29617 | 195 |
976640 | 976640 | 2021-01-29 | Fayette | Kentucky | 21067 | 29439 | 194 |
973395 | 973395 | 2021-01-28 | Fayette | Kentucky | 21067 | 29241 | 191 |
970150 | 970150 | 2021-01-27 | Fayette | Kentucky | 21067 | 29032 | 191 |
966906 | 966906 | 2021-01-26 | Fayette | Kentucky | 21067 | 28845 | 189 |
963661 | 963661 | 2021-01-25 | Fayette | Kentucky | 21067 | 28662 | 187 |
960416 | 960416 | 2021-01-24 | Fayette | Kentucky | 21067 | 28523 | 179 |
957170 | 957170 | 2021-01-23 | Fayette | Kentucky | 21067 | 28352 | 179 |
953925 | 953925 | 2021-01-22 | Fayette | Kentucky | 21067 | 28140 | 179 |
950680 | 950680 | 2021-01-21 | Fayette | Kentucky | 21067 | 27881 | 179 |
947434 | 947434 | 2021-01-20 | Fayette | Kentucky | 21067 | 27652 | 176 |
944187 | 944187 | 2021-01-19 | Fayette | Kentucky | 21067 | 27435 | 174 |
940942 | 940942 | 2021-01-18 | Fayette | Kentucky | 21067 | 27358 | 174 |
937697 | 937697 | 2021-01-17 | Fayette | Kentucky | 21067 | 27127 | 173 |
934452 | 934452 | 2021-01-16 | Fayette | Kentucky | 21067 | 26909 | 173 |
931207 | 931207 | 2021-01-15 | Fayette | Kentucky | 21067 | 26703 | 173 |
927962 | 927962 | 2021-01-14 | Fayette | Kentucky | 21067 | 26453 | 170 |
924716 | 924716 | 2021-01-13 | Fayette | Kentucky | 21067 | 26282 | 168 |
921471 | 921471 | 2021-01-12 | Fayette | Kentucky | 21067 | 26045 | 167 |
918226 | 918226 | 2021-01-11 | Fayette | Kentucky | 21067 | 25905 | 167 |
914981 | 914981 | 2021-01-10 | Fayette | Kentucky | 21067 | 25725 | 166 |
911736 | 911736 | 2021-01-09 | Fayette | Kentucky | 21067 | 25502 | 166 |
908491 | 908491 | 2021-01-08 | Fayette | Kentucky | 21067 | 25219 | 165 |
905245 | 905245 | 2021-01-07 | Fayette | Kentucky | 21067 | 24924 | 165 |
902000 | 902000 | 2021-01-06 | Fayette | Kentucky | 21067 | 24660 | 165 |
898755 | 898755 | 2021-01-05 | Fayette | Kentucky | 21067 | 24285 | 163 |
895510 | 895510 | 2021-01-04 | Fayette | Kentucky | 21067 | 24149 | 163 |
892263 | 892263 | 2021-01-03 | Fayette | Kentucky | 21067 | 23978 | 160 |
889017 | 889017 | 2021-01-02 | Fayette | Kentucky | 21067 | 23758 | 160 |
885771 | 885771 | 2021-01-01 | Fayette | Kentucky | 21067 | 23169 | 160 |
882526 | 882526 | 2020-12-31 | Fayette | Kentucky | 21067 | 23169 | 160 |
879281 | 879281 | 2020-12-30 | Fayette | Kentucky | 21067 | 23078 | 159 |
876036 | 876036 | 2020-12-29 | Fayette | Kentucky | 21067 | 22804 | 156 |
872791 | 872791 | 2020-12-28 | Fayette | Kentucky | 21067 | 22723 | 155 |
869546 | 869546 | 2020-12-27 | Fayette | Kentucky | 21067 | 22682 | 155 |
866301 | 866301 | 2020-12-26 | Fayette | Kentucky | 21067 | 22588 | 155 |
863056 | 863056 | 2020-12-25 | Fayette | Kentucky | 21067 | 22165 | 153 |
859811 | 859811 | 2020-12-24 | Fayette | Kentucky | 21067 | 22165 | 153 |
856566 | 856566 | 2020-12-23 | Fayette | Kentucky | 21067 | 22165 | 153 |
853321 | 853321 | 2020-12-22 | Fayette | Kentucky | 21067 | 22016 | 152 |
850076 | 850076 | 2020-12-21 | Fayette | Kentucky | 21067 | 21891 | 152 |
846831 | 846831 | 2020-12-20 | Fayette | Kentucky | 21067 | 21791 | 147 |
843585 | 843585 | 2020-12-19 | Fayette | Kentucky | 21067 | 21627 | 147 |
840340 | 840340 | 2020-12-18 | Fayette | Kentucky | 21067 | 21489 | 144 |
837095 | 837095 | 2020-12-17 | Fayette | Kentucky | 21067 | 21304 | 143 |
833849 | 833849 | 2020-12-16 | Fayette | Kentucky | 21067 | 21160 | 143 |
830602 | 830602 | 2020-12-15 | Fayette | Kentucky | 21067 | 20978 | 143 |
827356 | 827356 | 2020-12-14 | Fayette | Kentucky | 21067 | 20824 | 143 |
824109 | 824109 | 2020-12-13 | Fayette | Kentucky | 21067 | 20682 | 143 |
820863 | 820863 | 2020-12-12 | Fayette | Kentucky | 21067 | 20536 | 143 |
817617 | 817617 | 2020-12-11 | Fayette | Kentucky | 21067 | 20271 | 141 |
814371 | 814371 | 2020-12-10 | Fayette | Kentucky | 21067 | 20026 | 140 |
811126 | 811126 | 2020-12-09 | Fayette | Kentucky | 21067 | 19669 | 137 |
807881 | 807881 | 2020-12-08 | Fayette | Kentucky | 21067 | 19451 | 136 |
804636 | 804636 | 2020-12-07 | Fayette | Kentucky | 21067 | 19282 | 132 |
801391 | 801391 | 2020-12-06 | Fayette | Kentucky | 21067 | 19131 | 129 |
798146 | 798146 | 2020-12-05 | Fayette | Kentucky | 21067 | 18898 | 129 |
794901 | 794901 | 2020-12-04 | Fayette | Kentucky | 21067 | 18595 | 128 |
791656 | 791656 | 2020-12-03 | Fayette | Kentucky | 21067 | 18244 | 123 |
788411 | 788411 | 2020-12-02 | Fayette | Kentucky | 21067 | 17873 | 120 |
785167 | 785167 | 2020-12-01 | Fayette | Kentucky | 21067 | 17654 | 113 |
781922 | 781922 | 2020-11-30 | Fayette | Kentucky | 21067 | 17413 | 112 |
778676 | 778676 | 2020-11-29 | Fayette | Kentucky | 21067 | 17204 | 112 |
775431 | 775431 | 2020-11-28 | Fayette | Kentucky | 21067 | 16920 | 112 |
772186 | 772186 | 2020-11-27 | Fayette | Kentucky | 21067 | 16703 | 112 |
768941 | 768941 | 2020-11-26 | Fayette | Kentucky | 21067 | 16201 | 113 |
765695 | 765695 | 2020-11-25 | Fayette | Kentucky | 21067 | 16201 | 113 |
762450 | 762450 | 2020-11-24 | Fayette | Kentucky | 21067 | 15965 | 112 |
759205 | 759205 | 2020-11-23 | Fayette | Kentucky | 21067 | 15798 | 112 |
755958 | 755958 | 2020-11-22 | Fayette | Kentucky | 21067 | 15540 | 112 |
752712 | 752712 | 2020-11-21 | Fayette | Kentucky | 21067 | 15241 | 112 |
749466 | 749466 | 2020-11-20 | Fayette | Kentucky | 21067 | 14967 | 109 |
746220 | 746220 | 2020-11-19 | Fayette | Kentucky | 21067 | 14663 | 106 |
742973 | 742973 | 2020-11-18 | Fayette | Kentucky | 21067 | 14485 | 105 |
739726 | 739726 | 2020-11-17 | Fayette | Kentucky | 21067 | 14300 | 104 |
736482 | 736482 | 2020-11-16 | Fayette | Kentucky | 21067 | 14071 | 104 |
733236 | 733236 | 2020-11-15 | Fayette | Kentucky | 21067 | 13888 | 104 |
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);