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 |
---|---|---|---|---|---|---|---|
253022 | 253022 | 2020-06-19 | Fayette | Georgia | 13113 | 278 | 16 |
253192 | 253192 | 2020-06-19 | Fayette | Illinois | 17051 | 23 | 3 |
253289 | 253289 | 2020-06-19 | Fayette | Indiana | 18041 | 133 | 7 |
253393 | 253393 | 2020-06-19 | Fayette | Iowa | 19065 | 28 | 0 |
253585 | 253585 | 2020-06-19 | Fayette | Kentucky | 21067 | 1214 | 21 |
254576 | 254576 | 2020-06-19 | Fayette | Ohio | 39047 | 45 | 0 |
254774 | 254774 | 2020-06-19 | Fayette | Pennsylvania | 42051 | 103 | 4 |
255029 | 255029 | 2020-06-19 | Fayette | Tennessee | 47047 | 193 | 2 |
255172 | 255172 | 2020-06-19 | Fayette | Texas | 48149 | 52 | 2 |
255565 | 255565 | 2020-06-19 | Fayette | West Virginia | 54019 | 56 | 4 |
249500 | 249500 | 2020-06-18 | Fayette | Alabama | 1057 | 52 | 1 |
249907 | 249907 | 2020-06-18 | Fayette | Georgia | 13113 | 271 | 16 |
250077 | 250077 | 2020-06-18 | Fayette | Illinois | 17051 | 23 | 3 |
250174 | 250174 | 2020-06-18 | Fayette | Indiana | 18041 | 133 | 7 |
250278 | 250278 | 2020-06-18 | Fayette | Iowa | 19065 | 28 | 0 |
250470 | 250470 | 2020-06-18 | Fayette | Kentucky | 21067 | 1194 | 21 |
251461 | 251461 | 2020-06-18 | Fayette | Ohio | 39047 | 45 | 0 |
251659 | 251659 | 2020-06-18 | Fayette | Pennsylvania | 42051 | 100 | 4 |
251914 | 251914 | 2020-06-18 | Fayette | Tennessee | 47047 | 189 | 2 |
252057 | 252057 | 2020-06-18 | Fayette | Texas | 48149 | 51 | 2 |
252446 | 252446 | 2020-06-18 | Fayette | West Virginia | 54019 | 56 | 4 |
246388 | 246388 | 2020-06-17 | Fayette | Alabama | 1057 | 52 | 0 |
246795 | 246795 | 2020-06-17 | Fayette | Georgia | 13113 | 271 | 16 |
246965 | 246965 | 2020-06-17 | Fayette | Illinois | 17051 | 23 | 3 |
247062 | 247062 | 2020-06-17 | Fayette | Indiana | 18041 | 131 | 7 |
247166 | 247166 | 2020-06-17 | Fayette | Iowa | 19065 | 28 | 0 |
247358 | 247358 | 2020-06-17 | Fayette | Kentucky | 21067 | 1158 | 20 |
248346 | 248346 | 2020-06-17 | Fayette | Ohio | 39047 | 45 | 0 |
248544 | 248544 | 2020-06-17 | Fayette | Pennsylvania | 42051 | 98 | 4 |
248799 | 248799 | 2020-06-17 | Fayette | Tennessee | 47047 | 186 | 2 |
248942 | 248942 | 2020-06-17 | Fayette | Texas | 48149 | 52 | 2 |
249331 | 249331 | 2020-06-17 | Fayette | West Virginia | 54019 | 54 | 4 |
243275 | 243275 | 2020-06-16 | Fayette | Alabama | 1057 | 50 | 0 |
243682 | 243682 | 2020-06-16 | Fayette | Georgia | 13113 | 270 | 16 |
243852 | 243852 | 2020-06-16 | Fayette | Illinois | 17051 | 22 | 3 |
243949 | 243949 | 2020-06-16 | Fayette | Indiana | 18041 | 130 | 7 |
244053 | 244053 | 2020-06-16 | Fayette | Iowa | 19065 | 28 | 0 |
244245 | 244245 | 2020-06-16 | Fayette | Kentucky | 21067 | 1146 | 20 |
245233 | 245233 | 2020-06-16 | Fayette | Ohio | 39047 | 45 | 0 |
245431 | 245431 | 2020-06-16 | Fayette | Pennsylvania | 42051 | 95 | 4 |
245686 | 245686 | 2020-06-16 | Fayette | Tennessee | 47047 | 183 | 2 |
245829 | 245829 | 2020-06-16 | Fayette | Texas | 48149 | 45 | 2 |
246219 | 246219 | 2020-06-16 | Fayette | West Virginia | 54019 | 54 | 4 |
240164 | 240164 | 2020-06-15 | Fayette | Alabama | 1057 | 48 | 0 |
240571 | 240571 | 2020-06-15 | Fayette | Georgia | 13113 | 261 | 15 |
240741 | 240741 | 2020-06-15 | Fayette | Illinois | 17051 | 22 | 3 |
240838 | 240838 | 2020-06-15 | Fayette | Indiana | 18041 | 130 | 7 |
240942 | 240942 | 2020-06-15 | Fayette | Iowa | 19065 | 28 | 0 |
241134 | 241134 | 2020-06-15 | Fayette | Kentucky | 21067 | 1129 | 20 |
242121 | 242121 | 2020-06-15 | Fayette | Ohio | 39047 | 45 | 0 |
242319 | 242319 | 2020-06-15 | Fayette | Pennsylvania | 42051 | 95 | 4 |
242574 | 242574 | 2020-06-15 | Fayette | Tennessee | 47047 | 177 | 2 |
242717 | 242717 | 2020-06-15 | Fayette | Texas | 48149 | 44 | 2 |
243106 | 243106 | 2020-06-15 | Fayette | West Virginia | 54019 | 54 | 4 |
237056 | 237056 | 2020-06-14 | Fayette | Alabama | 1057 | 46 | 0 |
237463 | 237463 | 2020-06-14 | Fayette | Georgia | 13113 | 261 | 14 |
237633 | 237633 | 2020-06-14 | Fayette | Illinois | 17051 | 22 | 3 |
237730 | 237730 | 2020-06-14 | Fayette | Indiana | 18041 | 129 | 7 |
237834 | 237834 | 2020-06-14 | Fayette | Iowa | 19065 | 28 | 0 |
238025 | 238025 | 2020-06-14 | Fayette | Kentucky | 21067 | 1075 | 17 |
239012 | 239012 | 2020-06-14 | Fayette | Ohio | 39047 | 45 | 0 |
239210 | 239210 | 2020-06-14 | Fayette | Pennsylvania | 42051 | 95 | 4 |
239464 | 239464 | 2020-06-14 | Fayette | Tennessee | 47047 | 172 | 2 |
239607 | 239607 | 2020-06-14 | Fayette | Texas | 48149 | 44 | 2 |
239995 | 239995 | 2020-06-14 | Fayette | West Virginia | 54019 | 54 | 4 |
233949 | 233949 | 2020-06-13 | Fayette | Alabama | 1057 | 40 | 0 |
234356 | 234356 | 2020-06-13 | Fayette | Georgia | 13113 | 260 | 14 |
234526 | 234526 | 2020-06-13 | Fayette | Illinois | 17051 | 22 | 3 |
234623 | 234623 | 2020-06-13 | Fayette | Indiana | 18041 | 129 | 7 |
234727 | 234727 | 2020-06-13 | Fayette | Iowa | 19065 | 28 | 0 |
234918 | 234918 | 2020-06-13 | Fayette | Kentucky | 21067 | 1075 | 17 |
235904 | 235904 | 2020-06-13 | Fayette | Ohio | 39047 | 44 | 0 |
236102 | 236102 | 2020-06-13 | Fayette | Pennsylvania | 42051 | 95 | 4 |
236356 | 236356 | 2020-06-13 | Fayette | Tennessee | 47047 | 169 | 2 |
236499 | 236499 | 2020-06-13 | Fayette | Texas | 48149 | 43 | 2 |
236887 | 236887 | 2020-06-13 | Fayette | West Virginia | 54019 | 54 | 4 |
230844 | 230844 | 2020-06-12 | Fayette | Alabama | 1057 | 29 | 0 |
231250 | 231250 | 2020-06-12 | Fayette | Georgia | 13113 | 259 | 14 |
231420 | 231420 | 2020-06-12 | Fayette | Illinois | 17051 | 22 | 3 |
231517 | 231517 | 2020-06-12 | Fayette | Indiana | 18041 | 127 | 7 |
231621 | 231621 | 2020-06-12 | Fayette | Iowa | 19065 | 28 | 0 |
231813 | 231813 | 2020-06-12 | Fayette | Kentucky | 21067 | 1041 | 17 |
232799 | 232799 | 2020-06-12 | Fayette | Ohio | 39047 | 44 | 0 |
232997 | 232997 | 2020-06-12 | Fayette | Pennsylvania | 42051 | 95 | 4 |
233250 | 233250 | 2020-06-12 | Fayette | Tennessee | 47047 | 167 | 2 |
233393 | 233393 | 2020-06-12 | Fayette | Texas | 48149 | 44 | 2 |
233780 | 233780 | 2020-06-12 | Fayette | West Virginia | 54019 | 54 | 4 |
227740 | 227740 | 2020-06-11 | Fayette | Alabama | 1057 | 26 | 0 |
228147 | 228147 | 2020-06-11 | Fayette | Georgia | 13113 | 258 | 14 |
228317 | 228317 | 2020-06-11 | Fayette | Illinois | 17051 | 22 | 3 |
228414 | 228414 | 2020-06-11 | Fayette | Indiana | 18041 | 126 | 7 |
228518 | 228518 | 2020-06-11 | Fayette | Iowa | 19065 | 28 | 0 |
228709 | 228709 | 2020-06-11 | Fayette | Kentucky | 21067 | 1008 | 15 |
229694 | 229694 | 2020-06-11 | Fayette | Ohio | 39047 | 44 | 0 |
229892 | 229892 | 2020-06-11 | Fayette | Pennsylvania | 42051 | 96 | 4 |
230145 | 230145 | 2020-06-11 | Fayette | Tennessee | 47047 | 163 | 2 |
230289 | 230289 | 2020-06-11 | Fayette | Texas | 48149 | 43 | 2 |
230675 | 230675 | 2020-06-11 | Fayette | West Virginia | 54019 | 54 | 4 |
224639 | 224639 | 2020-06-10 | Fayette | Alabama | 1057 | 26 | 0 |
225045 | 225045 | 2020-06-10 | Fayette | Georgia | 13113 | 254 | 14 |
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);