ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,612 rows where county = "Fayette" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053951 | 1053951 | 2021-02-22 | Fayette | Georgia | 13113 | 7735 | 138 |
1054131 | 1054131 | 2021-02-22 | Fayette | Illinois | 17051 | 3059 | 55 |
1054229 | 1054229 | 2021-02-22 | Fayette | Indiana | 18041 | 2834 | 56 |
1054333 | 1054333 | 2021-02-22 | Fayette | Iowa | 19065 | 1757 | 32 |
1054540 | 1054540 | 2021-02-22 | Fayette | Kentucky | 21067 | 32131 | 230 |
1055589 | 1055589 | 2021-02-22 | Fayette | Ohio | 39047 | 2647 | 42 |
1055793 | 1055793 | 2021-02-22 | Fayette | Pennsylvania | 42051 | 10311 | 260 |
1056055 | 1056055 | 2021-02-22 | Fayette | Tennessee | 47047 | 4631 | 71 |
1056202 | 1056202 | 2021-02-22 | Fayette | Texas | 48149 | 2233 | 50 |
1056611 | 1056611 | 2021-02-22 | Fayette | West Virginia | 54019 | 2609 | 70 |
1050287 | 1050287 | 2021-02-21 | Fayette | Alabama | 1057 | 1983 | 54 |
1050704 | 1050704 | 2021-02-21 | Fayette | Georgia | 13113 | 7720 | 137 |
1050884 | 1050884 | 2021-02-21 | Fayette | Illinois | 17051 | 3059 | 55 |
1050982 | 1050982 | 2021-02-21 | Fayette | Indiana | 18041 | 2831 | 56 |
1051086 | 1051086 | 2021-02-21 | Fayette | Iowa | 19065 | 1757 | 32 |
1051293 | 1051293 | 2021-02-21 | Fayette | Kentucky | 21067 | 32099 | 224 |
1052343 | 1052343 | 2021-02-21 | Fayette | Ohio | 39047 | 2645 | 40 |
1052547 | 1052547 | 2021-02-21 | Fayette | Pennsylvania | 42051 | 10306 | 260 |
1052809 | 1052809 | 2021-02-21 | Fayette | Tennessee | 47047 | 4630 | 71 |
1052956 | 1052956 | 2021-02-21 | Fayette | Texas | 48149 | 2229 | 50 |
1053365 | 1053365 | 2021-02-21 | Fayette | West Virginia | 54019 | 2605 | 70 |
1047040 | 1047040 | 2021-02-20 | Fayette | Alabama | 1057 | 1982 | 54 |
1047457 | 1047457 | 2021-02-20 | Fayette | Georgia | 13113 | 7691 | 137 |
1047637 | 1047637 | 2021-02-20 | Fayette | Illinois | 17051 | 3058 | 55 |
1047735 | 1047735 | 2021-02-20 | Fayette | Indiana | 18041 | 2830 | 55 |
1047839 | 1047839 | 2021-02-20 | Fayette | Iowa | 19065 | 1757 | 32 |
1048046 | 1048046 | 2021-02-20 | Fayette | Kentucky | 21067 | 32009 | 224 |
1049096 | 1049096 | 2021-02-20 | Fayette | Ohio | 39047 | 2640 | 40 |
1049300 | 1049300 | 2021-02-20 | Fayette | Pennsylvania | 42051 | 10283 | 260 |
1049562 | 1049562 | 2021-02-20 | Fayette | Tennessee | 47047 | 4628 | 71 |
1049709 | 1049709 | 2021-02-20 | Fayette | Texas | 48149 | 2229 | 50 |
1050118 | 1050118 | 2021-02-20 | Fayette | West Virginia | 54019 | 2596 | 70 |
1043795 | 1043795 | 2021-02-19 | Fayette | Alabama | 1057 | 1982 | 54 |
1044212 | 1044212 | 2021-02-19 | Fayette | Georgia | 13113 | 7652 | 136 |
1044392 | 1044392 | 2021-02-19 | Fayette | Illinois | 17051 | 3056 | 55 |
1044490 | 1044490 | 2021-02-19 | Fayette | Indiana | 18041 | 2826 | 55 |
1044594 | 1044594 | 2021-02-19 | Fayette | Iowa | 19065 | 1757 | 32 |
1044801 | 1044801 | 2021-02-19 | Fayette | Kentucky | 21067 | 31935 | 223 |
1045849 | 1045849 | 2021-02-19 | Fayette | Ohio | 39047 | 2634 | 40 |
1046053 | 1046053 | 2021-02-19 | Fayette | Pennsylvania | 42051 | 10253 | 259 |
1046315 | 1046315 | 2021-02-19 | Fayette | Tennessee | 47047 | 4615 | 71 |
1046462 | 1046462 | 2021-02-19 | Fayette | Texas | 48149 | 2229 | 50 |
1046871 | 1046871 | 2021-02-19 | Fayette | West Virginia | 54019 | 2587 | 69 |
1040550 | 1040550 | 2021-02-18 | Fayette | Alabama | 1057 | 1979 | 53 |
1040967 | 1040967 | 2021-02-18 | Fayette | Georgia | 13113 | 7610 | 132 |
1041147 | 1041147 | 2021-02-18 | Fayette | Illinois | 17051 | 3052 | 55 |
1041245 | 1041245 | 2021-02-18 | Fayette | Indiana | 18041 | 2821 | 55 |
1041349 | 1041349 | 2021-02-18 | Fayette | Iowa | 19065 | 1757 | 32 |
1041556 | 1041556 | 2021-02-18 | Fayette | Kentucky | 21067 | 31821 | 219 |
1042604 | 1042604 | 2021-02-18 | Fayette | Ohio | 39047 | 2631 | 39 |
1042808 | 1042808 | 2021-02-18 | Fayette | Pennsylvania | 42051 | 10226 | 257 |
1043070 | 1043070 | 2021-02-18 | Fayette | Tennessee | 47047 | 4614 | 71 |
1043217 | 1043217 | 2021-02-18 | Fayette | Texas | 48149 | 2224 | 50 |
1043626 | 1043626 | 2021-02-18 | Fayette | West Virginia | 54019 | 2578 | 68 |
1037305 | 1037305 | 2021-02-17 | Fayette | Alabama | 1057 | 1957 | 54 |
1037722 | 1037722 | 2021-02-17 | Fayette | Georgia | 13113 | 7578 | 131 |
1037902 | 1037902 | 2021-02-17 | Fayette | Illinois | 17051 | 3050 | 55 |
1038000 | 1038000 | 2021-02-17 | Fayette | Indiana | 18041 | 2817 | 55 |
1038104 | 1038104 | 2021-02-17 | Fayette | Iowa | 19065 | 1755 | 32 |
1038311 | 1038311 | 2021-02-17 | Fayette | Kentucky | 21067 | 31757 | 218 |
1039359 | 1039359 | 2021-02-17 | Fayette | Ohio | 39047 | 2624 | 39 |
1039563 | 1039563 | 2021-02-17 | Fayette | Pennsylvania | 42051 | 10202 | 256 |
1039825 | 1039825 | 2021-02-17 | Fayette | Tennessee | 47047 | 4618 | 71 |
1039972 | 1039972 | 2021-02-17 | Fayette | Texas | 48149 | 2219 | 50 |
1040381 | 1040381 | 2021-02-17 | Fayette | West Virginia | 54019 | 2576 | 68 |
1034060 | 1034060 | 2021-02-16 | Fayette | Alabama | 1057 | 1956 | 51 |
1034477 | 1034477 | 2021-02-16 | Fayette | Georgia | 13113 | 7539 | 130 |
1034657 | 1034657 | 2021-02-16 | Fayette | Illinois | 17051 | 3049 | 55 |
1034755 | 1034755 | 2021-02-16 | Fayette | Indiana | 18041 | 2811 | 55 |
1034859 | 1034859 | 2021-02-16 | Fayette | Iowa | 19065 | 1751 | 31 |
1035066 | 1035066 | 2021-02-16 | Fayette | Kentucky | 21067 | 31654 | 218 |
1036114 | 1036114 | 2021-02-16 | Fayette | Ohio | 39047 | 2611 | 39 |
1036318 | 1036318 | 2021-02-16 | Fayette | Pennsylvania | 42051 | 10156 | 251 |
1036580 | 1036580 | 2021-02-16 | Fayette | Tennessee | 47047 | 4620 | 71 |
1036727 | 1036727 | 2021-02-16 | Fayette | Texas | 48149 | 2219 | 50 |
1037136 | 1037136 | 2021-02-16 | Fayette | West Virginia | 54019 | 2568 | 67 |
1030814 | 1030814 | 2021-02-15 | Fayette | Alabama | 1057 | 1953 | 51 |
1031231 | 1031231 | 2021-02-15 | Fayette | Georgia | 13113 | 7508 | 128 |
1031411 | 1031411 | 2021-02-15 | Fayette | Illinois | 17051 | 3049 | 55 |
1031509 | 1031509 | 2021-02-15 | Fayette | Indiana | 18041 | 2809 | 55 |
1031613 | 1031613 | 2021-02-15 | Fayette | Iowa | 19065 | 1747 | 31 |
1031820 | 1031820 | 2021-02-15 | Fayette | Kentucky | 21067 | 31526 | 217 |
1032869 | 1032869 | 2021-02-15 | Fayette | Ohio | 39047 | 2608 | 38 |
1033073 | 1033073 | 2021-02-15 | Fayette | Pennsylvania | 42051 | 10142 | 250 |
1033335 | 1033335 | 2021-02-15 | Fayette | Tennessee | 47047 | 4607 | 71 |
1033482 | 1033482 | 2021-02-15 | Fayette | Texas | 48149 | 2208 | 50 |
1033891 | 1033891 | 2021-02-15 | Fayette | West Virginia | 54019 | 2566 | 67 |
1027567 | 1027567 | 2021-02-14 | Fayette | Alabama | 1057 | 1942 | 51 |
1027984 | 1027984 | 2021-02-14 | Fayette | Georgia | 13113 | 7469 | 127 |
1028164 | 1028164 | 2021-02-14 | Fayette | Illinois | 17051 | 3049 | 55 |
1028262 | 1028262 | 2021-02-14 | Fayette | Indiana | 18041 | 2807 | 55 |
1028366 | 1028366 | 2021-02-14 | Fayette | Iowa | 19065 | 1747 | 31 |
1028573 | 1028573 | 2021-02-14 | Fayette | Kentucky | 21067 | 31465 | 212 |
1029623 | 1029623 | 2021-02-14 | Fayette | Ohio | 39047 | 2600 | 38 |
1029827 | 1029827 | 2021-02-14 | Fayette | Pennsylvania | 42051 | 10128 | 250 |
1030089 | 1030089 | 2021-02-14 | Fayette | Tennessee | 47047 | 4586 | 71 |
1030236 | 1030236 | 2021-02-14 | Fayette | Texas | 48149 | 2208 | 50 |
1030645 | 1030645 | 2021-02-14 | Fayette | West Virginia | 54019 | 2556 | 67 |
1024322 | 1024322 | 2021-02-13 | Fayette | Alabama | 1057 | 1939 | 51 |
1024739 | 1024739 | 2021-02-13 | Fayette | Georgia | 13113 | 7435 | 126 |
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);