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 |
---|---|---|---|---|---|---|---|
1193137 | 1193137 | 2021-04-06 | Fayette | Alabama | 1057 | 2074 | 59 |
1193554 | 1193554 | 2021-04-06 | Fayette | Georgia | 13113 | 8593 | 157 |
1193734 | 1193734 | 2021-04-06 | Fayette | Illinois | 17051 | 3108 | 57 |
1193832 | 1193832 | 2021-04-06 | Fayette | Indiana | 18041 | 2895 | 63 |
1193936 | 1193936 | 2021-04-06 | Fayette | Iowa | 19065 | 1825 | 41 |
1194143 | 1194143 | 2021-04-06 | Fayette | Kentucky | 21067 | 34294 | 290 |
1195192 | 1195192 | 2021-04-06 | Fayette | Ohio | 39047 | 2757 | 48 |
1195397 | 1195397 | 2021-04-06 | Fayette | Pennsylvania | 42051 | 11461 | 291 |
1195659 | 1195659 | 2021-04-06 | Fayette | Tennessee | 47047 | 4822 | 77 |
1195806 | 1195806 | 2021-04-06 | Fayette | Texas | 48149 | 2551 | 57 |
1196216 | 1196216 | 2021-04-06 | Fayette | West Virginia | 54019 | 3102 | 77 |
1189887 | 1189887 | 2021-04-05 | Fayette | Alabama | 1057 | 2069 | 59 |
1190304 | 1190304 | 2021-04-05 | Fayette | Georgia | 13113 | 8584 | 157 |
1190484 | 1190484 | 2021-04-05 | Fayette | Illinois | 17051 | 3105 | 57 |
1190582 | 1190582 | 2021-04-05 | Fayette | Indiana | 18041 | 2895 | 63 |
1190686 | 1190686 | 2021-04-05 | Fayette | Iowa | 19065 | 1823 | 41 |
1190893 | 1190893 | 2021-04-05 | Fayette | Kentucky | 21067 | 34277 | 290 |
1191944 | 1191944 | 2021-04-05 | Fayette | Ohio | 39047 | 2757 | 48 |
1192149 | 1192149 | 2021-04-05 | Fayette | Pennsylvania | 42051 | 11396 | 290 |
1192411 | 1192411 | 2021-04-05 | Fayette | Tennessee | 47047 | 4823 | 77 |
1192558 | 1192558 | 2021-04-05 | Fayette | Texas | 48149 | 2542 | 57 |
1192968 | 1192968 | 2021-04-05 | Fayette | West Virginia | 54019 | 3095 | 77 |
1186640 | 1186640 | 2021-04-04 | Fayette | Alabama | 1057 | 2069 | 59 |
1187057 | 1187057 | 2021-04-04 | Fayette | Georgia | 13113 | 8580 | 157 |
1187237 | 1187237 | 2021-04-04 | Fayette | Illinois | 17051 | 3104 | 57 |
1187335 | 1187335 | 2021-04-04 | Fayette | Indiana | 18041 | 2894 | 63 |
1187439 | 1187439 | 2021-04-04 | Fayette | Iowa | 19065 | 1822 | 41 |
1187646 | 1187646 | 2021-04-04 | Fayette | Kentucky | 21067 | 34270 | 290 |
1188695 | 1188695 | 2021-04-04 | Fayette | Ohio | 39047 | 2756 | 48 |
1188900 | 1188900 | 2021-04-04 | Fayette | Pennsylvania | 42051 | 11376 | 290 |
1189162 | 1189162 | 2021-04-04 | Fayette | Tennessee | 47047 | 4808 | 78 |
1189309 | 1189309 | 2021-04-04 | Fayette | Texas | 48149 | 2536 | 57 |
1189718 | 1189718 | 2021-04-04 | Fayette | West Virginia | 54019 | 3087 | 76 |
1183393 | 1183393 | 2021-04-03 | Fayette | Alabama | 1057 | 2068 | 59 |
1183810 | 1183810 | 2021-04-03 | Fayette | Georgia | 13113 | 8573 | 157 |
1183990 | 1183990 | 2021-04-03 | Fayette | Illinois | 17051 | 3101 | 57 |
1184088 | 1184088 | 2021-04-03 | Fayette | Indiana | 18041 | 2892 | 63 |
1184192 | 1184192 | 2021-04-03 | Fayette | Iowa | 19065 | 1822 | 41 |
1184399 | 1184399 | 2021-04-03 | Fayette | Kentucky | 21067 | 34270 | 290 |
1185448 | 1185448 | 2021-04-03 | Fayette | Ohio | 39047 | 2756 | 48 |
1185653 | 1185653 | 2021-04-03 | Fayette | Pennsylvania | 42051 | 11352 | 290 |
1185915 | 1185915 | 2021-04-03 | Fayette | Tennessee | 47047 | 4808 | 78 |
1186062 | 1186062 | 2021-04-03 | Fayette | Texas | 48149 | 2536 | 57 |
1186471 | 1186471 | 2021-04-03 | Fayette | West Virginia | 54019 | 3064 | 76 |
1180146 | 1180146 | 2021-04-02 | Fayette | Alabama | 1057 | 2068 | 59 |
1180563 | 1180563 | 2021-04-02 | Fayette | Georgia | 13113 | 8563 | 157 |
1180743 | 1180743 | 2021-04-02 | Fayette | Illinois | 17051 | 3100 | 57 |
1180841 | 1180841 | 2021-04-02 | Fayette | Indiana | 18041 | 2891 | 62 |
1180945 | 1180945 | 2021-04-02 | Fayette | Iowa | 19065 | 1821 | 39 |
1181152 | 1181152 | 2021-04-02 | Fayette | Kentucky | 21067 | 34220 | 286 |
1182201 | 1182201 | 2021-04-02 | Fayette | Ohio | 39047 | 2755 | 48 |
1182406 | 1182406 | 2021-04-02 | Fayette | Pennsylvania | 42051 | 11279 | 289 |
1182668 | 1182668 | 2021-04-02 | Fayette | Tennessee | 47047 | 4808 | 78 |
1182815 | 1182815 | 2021-04-02 | Fayette | Texas | 48149 | 2523 | 57 |
1183224 | 1183224 | 2021-04-02 | Fayette | West Virginia | 54019 | 3050 | 75 |
1176899 | 1176899 | 2021-04-01 | Fayette | Alabama | 1057 | 2063 | 59 |
1177316 | 1177316 | 2021-04-01 | Fayette | Georgia | 13113 | 8555 | 157 |
1177496 | 1177496 | 2021-04-01 | Fayette | Illinois | 17051 | 3100 | 57 |
1177594 | 1177594 | 2021-04-01 | Fayette | Indiana | 18041 | 2890 | 61 |
1177698 | 1177698 | 2021-04-01 | Fayette | Iowa | 19065 | 1821 | 39 |
1177905 | 1177905 | 2021-04-01 | Fayette | Kentucky | 21067 | 34187 | 286 |
1178954 | 1178954 | 2021-04-01 | Fayette | Ohio | 39047 | 2753 | 48 |
1179159 | 1179159 | 2021-04-01 | Fayette | Pennsylvania | 42051 | 11239 | 289 |
1179421 | 1179421 | 2021-04-01 | Fayette | Tennessee | 47047 | 4808 | 78 |
1179568 | 1179568 | 2021-04-01 | Fayette | Texas | 48149 | 2521 | 56 |
1179977 | 1179977 | 2021-04-01 | Fayette | West Virginia | 54019 | 3023 | 74 |
1173652 | 1173652 | 2021-03-31 | Fayette | Alabama | 1057 | 2063 | 59 |
1174069 | 1174069 | 2021-03-31 | Fayette | Georgia | 13113 | 8546 | 156 |
1174249 | 1174249 | 2021-03-31 | Fayette | Illinois | 17051 | 3097 | 57 |
1174347 | 1174347 | 2021-03-31 | Fayette | Indiana | 18041 | 2890 | 61 |
1174451 | 1174451 | 2021-03-31 | Fayette | Iowa | 19065 | 1821 | 39 |
1174658 | 1174658 | 2021-03-31 | Fayette | Kentucky | 21067 | 34153 | 282 |
1175707 | 1175707 | 2021-03-31 | Fayette | Ohio | 39047 | 2747 | 48 |
1175912 | 1175912 | 2021-03-31 | Fayette | Pennsylvania | 42051 | 11216 | 288 |
1176174 | 1176174 | 2021-03-31 | Fayette | Tennessee | 47047 | 4794 | 78 |
1176321 | 1176321 | 2021-03-31 | Fayette | Texas | 48149 | 2516 | 56 |
1176730 | 1176730 | 2021-03-31 | Fayette | West Virginia | 54019 | 2994 | 74 |
1170405 | 1170405 | 2021-03-30 | Fayette | Alabama | 1057 | 2063 | 59 |
1170822 | 1170822 | 2021-03-30 | Fayette | Georgia | 13113 | 8536 | 156 |
1171002 | 1171002 | 2021-03-30 | Fayette | Illinois | 17051 | 3089 | 57 |
1171100 | 1171100 | 2021-03-30 | Fayette | Indiana | 18041 | 2888 | 61 |
1171204 | 1171204 | 2021-03-30 | Fayette | Iowa | 19065 | 1819 | 39 |
1171411 | 1171411 | 2021-03-30 | Fayette | Kentucky | 21067 | 34089 | 282 |
1172460 | 1172460 | 2021-03-30 | Fayette | Ohio | 39047 | 2742 | 48 |
1172665 | 1172665 | 2021-03-30 | Fayette | Pennsylvania | 42051 | 11174 | 286 |
1172927 | 1172927 | 2021-03-30 | Fayette | Tennessee | 47047 | 4790 | 78 |
1173074 | 1173074 | 2021-03-30 | Fayette | Texas | 48149 | 2504 | 56 |
1173483 | 1173483 | 2021-03-30 | Fayette | West Virginia | 54019 | 2981 | 74 |
1167157 | 1167157 | 2021-03-29 | Fayette | Alabama | 1057 | 2061 | 59 |
1167574 | 1167574 | 2021-03-29 | Fayette | Georgia | 13113 | 8528 | 156 |
1167754 | 1167754 | 2021-03-29 | Fayette | Illinois | 17051 | 3088 | 57 |
1167852 | 1167852 | 2021-03-29 | Fayette | Indiana | 18041 | 2886 | 61 |
1167956 | 1167956 | 2021-03-29 | Fayette | Iowa | 19065 | 1817 | 39 |
1168163 | 1168163 | 2021-03-29 | Fayette | Kentucky | 21067 | 34032 | 281 |
1169213 | 1169213 | 2021-03-29 | Fayette | Ohio | 39047 | 2740 | 48 |
1169418 | 1169418 | 2021-03-29 | Fayette | Pennsylvania | 42051 | 11152 | 286 |
1169680 | 1169680 | 2021-03-29 | Fayette | Tennessee | 47047 | 4791 | 78 |
1169827 | 1169827 | 2021-03-29 | Fayette | Texas | 48149 | 2500 | 56 |
1170236 | 1170236 | 2021-03-29 | Fayette | West Virginia | 54019 | 2974 | 74 |
1163909 | 1163909 | 2021-03-28 | Fayette | Alabama | 1057 | 2060 | 59 |
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);