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 |
---|---|---|---|---|---|---|---|
386966 | 386966 | 2020-07-31 | Fayette | Kentucky | 21067 | 3164 | 46 |
383748 | 383748 | 2020-07-30 | Fayette | Kentucky | 21067 | 3075 | 45 |
380531 | 380531 | 2020-07-29 | Fayette | Kentucky | 21067 | 3026 | 45 |
377314 | 377314 | 2020-07-28 | Fayette | Kentucky | 21067 | 2972 | 45 |
374099 | 374099 | 2020-07-27 | Fayette | Kentucky | 21067 | 2856 | 45 |
370887 | 370887 | 2020-07-26 | Fayette | Kentucky | 21067 | 2758 | 44 |
367677 | 367677 | 2020-07-25 | Fayette | Kentucky | 21067 | 2758 | 44 |
364470 | 364470 | 2020-07-24 | Fayette | Kentucky | 21067 | 2711 | 42 |
361263 | 361263 | 2020-07-23 | Fayette | Kentucky | 21067 | 2611 | 42 |
358058 | 358058 | 2020-07-22 | Fayette | Kentucky | 21067 | 2558 | 42 |
354855 | 354855 | 2020-07-21 | Fayette | Kentucky | 21067 | 2521 | 41 |
351653 | 351653 | 2020-07-20 | Fayette | Kentucky | 21067 | 2460 | 41 |
348453 | 348453 | 2020-07-19 | Fayette | Kentucky | 21067 | 2343 | 41 |
345252 | 345252 | 2020-07-18 | Fayette | Kentucky | 21067 | 2343 | 41 |
342052 | 342052 | 2020-07-17 | Fayette | Kentucky | 21067 | 2296 | 41 |
338856 | 338856 | 2020-07-16 | Fayette | Kentucky | 21067 | 2248 | 40 |
335660 | 335660 | 2020-07-15 | Fayette | Kentucky | 21067 | 2179 | 39 |
332467 | 332467 | 2020-07-14 | Fayette | Kentucky | 21067 | 2134 | 38 |
329280 | 329280 | 2020-07-13 | Fayette | Kentucky | 21067 | 2076 | 36 |
326094 | 326094 | 2020-07-12 | Fayette | Kentucky | 21067 | 1987 | 33 |
322911 | 322911 | 2020-07-11 | Fayette | Kentucky | 21067 | 1987 | 33 |
319732 | 319732 | 2020-07-10 | Fayette | Kentucky | 21067 | 1922 | 33 |
316557 | 316557 | 2020-07-09 | Fayette | Kentucky | 21067 | 1839 | 32 |
313383 | 313383 | 2020-07-08 | Fayette | Kentucky | 21067 | 1800 | 32 |
310213 | 310213 | 2020-07-07 | Fayette | Kentucky | 21067 | 1775 | 32 |
307045 | 307045 | 2020-07-06 | Fayette | Kentucky | 21067 | 1713 | 31 |
303878 | 303878 | 2020-07-05 | Fayette | Kentucky | 21067 | 1661 | 30 |
300714 | 300714 | 2020-07-04 | Fayette | Kentucky | 21067 | 1661 | 30 |
297552 | 297552 | 2020-07-03 | Fayette | Kentucky | 21067 | 1637 | 30 |
294394 | 294394 | 2020-07-02 | Fayette | Kentucky | 21067 | 1599 | 29 |
291240 | 291240 | 2020-07-01 | Fayette | Kentucky | 21067 | 1553 | 29 |
288090 | 288090 | 2020-06-30 | Fayette | Kentucky | 21067 | 1514 | 28 |
284941 | 284941 | 2020-06-29 | Fayette | Kentucky | 21067 | 1491 | 27 |
281795 | 281795 | 2020-06-28 | Fayette | Kentucky | 21067 | 1439 | 24 |
278647 | 278647 | 2020-06-27 | Fayette | Kentucky | 21067 | 1439 | 24 |
275499 | 275499 | 2020-06-26 | Fayette | Kentucky | 21067 | 1398 | 24 |
272356 | 272356 | 2020-06-25 | Fayette | Kentucky | 21067 | 1374 | 23 |
269220 | 269220 | 2020-06-24 | Fayette | Kentucky | 21067 | 1334 | 22 |
266087 | 266087 | 2020-06-23 | Fayette | Kentucky | 21067 | 1307 | 22 |
262960 | 262960 | 2020-06-22 | Fayette | Kentucky | 21067 | 1284 | 21 |
259831 | 259831 | 2020-06-21 | Fayette | Kentucky | 21067 | 1235 | 21 |
256705 | 256705 | 2020-06-20 | Fayette | Kentucky | 21067 | 1235 | 21 |
253585 | 253585 | 2020-06-19 | Fayette | Kentucky | 21067 | 1214 | 21 |
250470 | 250470 | 2020-06-18 | Fayette | Kentucky | 21067 | 1194 | 21 |
247358 | 247358 | 2020-06-17 | Fayette | Kentucky | 21067 | 1158 | 20 |
244245 | 244245 | 2020-06-16 | Fayette | Kentucky | 21067 | 1146 | 20 |
241134 | 241134 | 2020-06-15 | Fayette | Kentucky | 21067 | 1129 | 20 |
238025 | 238025 | 2020-06-14 | Fayette | Kentucky | 21067 | 1075 | 17 |
234918 | 234918 | 2020-06-13 | Fayette | Kentucky | 21067 | 1075 | 17 |
231813 | 231813 | 2020-06-12 | Fayette | Kentucky | 21067 | 1041 | 17 |
228709 | 228709 | 2020-06-11 | Fayette | Kentucky | 21067 | 1008 | 15 |
225607 | 225607 | 2020-06-10 | Fayette | Kentucky | 21067 | 978 | 14 |
222511 | 222511 | 2020-06-09 | Fayette | Kentucky | 21067 | 947 | 14 |
219416 | 219416 | 2020-06-08 | Fayette | Kentucky | 21067 | 928 | 14 |
216324 | 216324 | 2020-06-07 | Fayette | Kentucky | 21067 | 872 | 14 |
213237 | 213237 | 2020-06-06 | Fayette | Kentucky | 21067 | 872 | 14 |
210152 | 210152 | 2020-06-05 | Fayette | Kentucky | 21067 | 847 | 14 |
207071 | 207071 | 2020-06-04 | Fayette | Kentucky | 21067 | 812 | 13 |
203990 | 203990 | 2020-06-03 | Fayette | Kentucky | 21067 | 803 | 13 |
200913 | 200913 | 2020-06-02 | Fayette | Kentucky | 21067 | 781 | 13 |
197841 | 197841 | 2020-06-01 | Fayette | Kentucky | 21067 | 760 | 13 |
194770 | 194770 | 2020-05-31 | Fayette | Kentucky | 21067 | 714 | 13 |
191702 | 191702 | 2020-05-30 | Fayette | Kentucky | 21067 | 714 | 13 |
188638 | 188638 | 2020-05-29 | Fayette | Kentucky | 21067 | 702 | 13 |
185580 | 185580 | 2020-05-28 | Fayette | Kentucky | 21067 | 673 | 13 |
182526 | 182526 | 2020-05-27 | Fayette | Kentucky | 21067 | 650 | 13 |
179481 | 179481 | 2020-05-26 | Fayette | Kentucky | 21067 | 644 | 13 |
176437 | 176437 | 2020-05-25 | Fayette | Kentucky | 21067 | 619 | 13 |
173393 | 173393 | 2020-05-24 | Fayette | Kentucky | 21067 | 619 | 13 |
170352 | 170352 | 2020-05-23 | Fayette | Kentucky | 21067 | 619 | 13 |
167314 | 167314 | 2020-05-22 | Fayette | Kentucky | 21067 | 603 | 13 |
164278 | 164278 | 2020-05-21 | Fayette | Kentucky | 21067 | 596 | 13 |
161249 | 161249 | 2020-05-20 | Fayette | Kentucky | 21067 | 591 | 12 |
158223 | 158223 | 2020-05-19 | Fayette | Kentucky | 21067 | 596 | 12 |
155206 | 155206 | 2020-05-18 | Fayette | Kentucky | 21067 | 564 | 12 |
152192 | 152192 | 2020-05-17 | Fayette | Kentucky | 21067 | 550 | 12 |
149181 | 149181 | 2020-05-16 | Fayette | Kentucky | 21067 | 550 | 12 |
146177 | 146177 | 2020-05-15 | Fayette | Kentucky | 21067 | 532 | 12 |
143177 | 143177 | 2020-05-14 | Fayette | Kentucky | 21067 | 529 | 10 |
140181 | 140181 | 2020-05-13 | Fayette | Kentucky | 21067 | 457 | 10 |
137188 | 137188 | 2020-05-12 | Fayette | Kentucky | 21067 | 426 | 10 |
134198 | 134198 | 2020-05-11 | Fayette | Kentucky | 21067 | 411 | 10 |
131207 | 131207 | 2020-05-10 | Fayette | Kentucky | 21067 | 389 | 9 |
128217 | 128217 | 2020-05-09 | Fayette | Kentucky | 21067 | 386 | 9 |
125229 | 125229 | 2020-05-08 | Fayette | Kentucky | 21067 | 361 | 9 |
122247 | 122247 | 2020-05-07 | Fayette | Kentucky | 21067 | 336 | 9 |
119277 | 119277 | 2020-05-06 | Fayette | Kentucky | 21067 | 320 | 9 |
116316 | 116316 | 2020-05-05 | Fayette | Kentucky | 21067 | 298 | 9 |
113434 | 113434 | 2020-05-04 | Fayette | Kentucky | 21067 | 295 | 9 |
110557 | 110557 | 2020-05-03 | Fayette | Kentucky | 21067 | 292 | 9 |
107686 | 107686 | 2020-05-02 | Fayette | Kentucky | 21067 | 254 | 9 |
104821 | 104821 | 2020-05-01 | Fayette | Kentucky | 21067 | 254 | 9 |
101960 | 101960 | 2020-04-30 | Fayette | Kentucky | 21067 | 248 | 9 |
99108 | 99108 | 2020-04-29 | Fayette | Kentucky | 21067 | 246 | 9 |
96262 | 96262 | 2020-04-28 | Fayette | Kentucky | 21067 | 242 | 10 |
93429 | 93429 | 2020-04-27 | Fayette | Kentucky | 21067 | 239 | 9 |
90608 | 90608 | 2020-04-26 | Fayette | Kentucky | 21067 | 238 | 8 |
87792 | 87792 | 2020-04-25 | Fayette | Kentucky | 21067 | 235 | 8 |
84983 | 84983 | 2020-04-24 | Fayette | Kentucky | 21067 | 226 | 8 |
82180 | 82180 | 2020-04-23 | Fayette | Kentucky | 21067 | 223 | 8 |
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);