ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Fayette" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535454 | 535454 | 2020-09-15 | Fayette | Kentucky | 21067 | 7296 | 70 |
532219 | 532219 | 2020-09-14 | Fayette | Kentucky | 21067 | 7200 | 70 |
528982 | 528982 | 2020-09-13 | Fayette | Kentucky | 21067 | 7000 | 69 |
525746 | 525746 | 2020-09-12 | Fayette | Kentucky | 21067 | 7000 | 69 |
522510 | 522510 | 2020-09-11 | Fayette | Kentucky | 21067 | 6833 | 66 |
519273 | 519273 | 2020-09-10 | Fayette | Kentucky | 21067 | 6684 | 66 |
516038 | 516038 | 2020-09-09 | Fayette | Kentucky | 21067 | 6561 | 63 |
512805 | 512805 | 2020-09-08 | Fayette | Kentucky | 21067 | 6499 | 61 |
509573 | 509573 | 2020-09-07 | Fayette | Kentucky | 21067 | 6450 | 61 |
506340 | 506340 | 2020-09-06 | Fayette | Kentucky | 21067 | 6256 | 60 |
503106 | 503106 | 2020-09-05 | Fayette | Kentucky | 21067 | 6256 | 60 |
499873 | 499873 | 2020-09-04 | Fayette | Kentucky | 21067 | 6146 | 59 |
496639 | 496639 | 2020-09-03 | Fayette | Kentucky | 21067 | 6035 | 58 |
493406 | 493406 | 2020-09-02 | Fayette | Kentucky | 21067 | 5915 | 58 |
490172 | 490172 | 2020-09-01 | Fayette | Kentucky | 21067 | 5793 | 58 |
486939 | 486939 | 2020-08-31 | Fayette | Kentucky | 21067 | 5726 | 56 |
483704 | 483704 | 2020-08-30 | Fayette | Kentucky | 21067 | 5520 | 55 |
480470 | 480470 | 2020-08-29 | Fayette | Kentucky | 21067 | 5520 | 55 |
477237 | 477237 | 2020-08-28 | Fayette | Kentucky | 21067 | 5401 | 55 |
474004 | 474004 | 2020-08-27 | Fayette | Kentucky | 21067 | 5289 | 54 |
470772 | 470772 | 2020-08-26 | Fayette | Kentucky | 21067 | 5187 | 53 |
467543 | 467543 | 2020-08-25 | Fayette | Kentucky | 21067 | 5129 | 53 |
464314 | 464314 | 2020-08-24 | Fayette | Kentucky | 21067 | 5067 | 53 |
461083 | 461083 | 2020-08-23 | Fayette | Kentucky | 21067 | 4911 | 53 |
457856 | 457856 | 2020-08-22 | Fayette | Kentucky | 21067 | 4911 | 53 |
454628 | 454628 | 2020-08-21 | Fayette | Kentucky | 21067 | 4849 | 53 |
451400 | 451400 | 2020-08-20 | Fayette | Kentucky | 21067 | 4763 | 53 |
448172 | 448172 | 2020-08-19 | Fayette | Kentucky | 21067 | 4676 | 52 |
444945 | 444945 | 2020-08-18 | Fayette | Kentucky | 21067 | 4602 | 51 |
441719 | 441719 | 2020-08-17 | Fayette | Kentucky | 21067 | 4521 | 51 |
438492 | 438492 | 2020-08-16 | Fayette | Kentucky | 21067 | 4392 | 51 |
435267 | 435267 | 2020-08-15 | Fayette | Kentucky | 21067 | 4392 | 51 |
432042 | 432042 | 2020-08-14 | Fayette | Kentucky | 21067 | 4287 | 50 |
428814 | 428814 | 2020-08-13 | Fayette | Kentucky | 21067 | 4186 | 49 |
425590 | 425590 | 2020-08-12 | Fayette | Kentucky | 21067 | 4106 | 48 |
422369 | 422369 | 2020-08-11 | Fayette | Kentucky | 21067 | 4044 | 47 |
419147 | 419147 | 2020-08-10 | Fayette | Kentucky | 21067 | 3995 | 47 |
415926 | 415926 | 2020-08-09 | Fayette | Kentucky | 21067 | 3857 | 47 |
412706 | 412706 | 2020-08-08 | Fayette | Kentucky | 21067 | 3857 | 47 |
409486 | 409486 | 2020-08-07 | Fayette | Kentucky | 21067 | 3726 | 47 |
406266 | 406266 | 2020-08-06 | Fayette | Kentucky | 21067 | 3642 | 47 |
403048 | 403048 | 2020-08-05 | Fayette | Kentucky | 21067 | 3552 | 46 |
399831 | 399831 | 2020-08-04 | Fayette | Kentucky | 21067 | 3447 | 46 |
396616 | 396616 | 2020-08-03 | Fayette | Kentucky | 21067 | 3400 | 46 |
393400 | 393400 | 2020-08-02 | Fayette | Kentucky | 21067 | 3255 | 46 |
390183 | 390183 | 2020-08-01 | Fayette | Kentucky | 21067 | 3255 | 46 |
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 |
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);