ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 21165 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535503 | 535503 | 2020-09-15 | Menifee | Kentucky | 21165 | 41 | 0 |
532268 | 532268 | 2020-09-14 | Menifee | Kentucky | 21165 | 40 | 0 |
529031 | 529031 | 2020-09-13 | Menifee | Kentucky | 21165 | 40 | 0 |
525795 | 525795 | 2020-09-12 | Menifee | Kentucky | 21165 | 40 | 0 |
522559 | 522559 | 2020-09-11 | Menifee | Kentucky | 21165 | 39 | 0 |
519322 | 519322 | 2020-09-10 | Menifee | Kentucky | 21165 | 39 | 0 |
516087 | 516087 | 2020-09-09 | Menifee | Kentucky | 21165 | 35 | 0 |
512854 | 512854 | 2020-09-08 | Menifee | Kentucky | 21165 | 35 | 0 |
509622 | 509622 | 2020-09-07 | Menifee | Kentucky | 21165 | 35 | 0 |
506389 | 506389 | 2020-09-06 | Menifee | Kentucky | 21165 | 35 | 0 |
503155 | 503155 | 2020-09-05 | Menifee | Kentucky | 21165 | 35 | 0 |
499922 | 499922 | 2020-09-04 | Menifee | Kentucky | 21165 | 35 | 0 |
496688 | 496688 | 2020-09-03 | Menifee | Kentucky | 21165 | 34 | 0 |
493455 | 493455 | 2020-09-02 | Menifee | Kentucky | 21165 | 34 | 0 |
490221 | 490221 | 2020-09-01 | Menifee | Kentucky | 21165 | 34 | 0 |
486988 | 486988 | 2020-08-31 | Menifee | Kentucky | 21165 | 33 | 0 |
483753 | 483753 | 2020-08-30 | Menifee | Kentucky | 21165 | 33 | 0 |
480519 | 480519 | 2020-08-29 | Menifee | Kentucky | 21165 | 33 | 0 |
477286 | 477286 | 2020-08-28 | Menifee | Kentucky | 21165 | 30 | 0 |
474053 | 474053 | 2020-08-27 | Menifee | Kentucky | 21165 | 31 | 0 |
470821 | 470821 | 2020-08-26 | Menifee | Kentucky | 21165 | 30 | 0 |
467592 | 467592 | 2020-08-25 | Menifee | Kentucky | 21165 | 31 | 0 |
464363 | 464363 | 2020-08-24 | Menifee | Kentucky | 21165 | 29 | 0 |
461132 | 461132 | 2020-08-23 | Menifee | Kentucky | 21165 | 28 | 0 |
457905 | 457905 | 2020-08-22 | Menifee | Kentucky | 21165 | 28 | 0 |
454677 | 454677 | 2020-08-21 | Menifee | Kentucky | 21165 | 28 | 0 |
451449 | 451449 | 2020-08-20 | Menifee | Kentucky | 21165 | 28 | 0 |
448221 | 448221 | 2020-08-19 | Menifee | Kentucky | 21165 | 28 | 0 |
444994 | 444994 | 2020-08-18 | Menifee | Kentucky | 21165 | 28 | 0 |
441768 | 441768 | 2020-08-17 | Menifee | Kentucky | 21165 | 28 | 0 |
438541 | 438541 | 2020-08-16 | Menifee | Kentucky | 21165 | 28 | 0 |
435316 | 435316 | 2020-08-15 | Menifee | Kentucky | 21165 | 28 | 0 |
432091 | 432091 | 2020-08-14 | Menifee | Kentucky | 21165 | 28 | 0 |
428863 | 428863 | 2020-08-13 | Menifee | Kentucky | 21165 | 28 | 0 |
425639 | 425639 | 2020-08-12 | Menifee | Kentucky | 21165 | 28 | 0 |
422418 | 422418 | 2020-08-11 | Menifee | Kentucky | 21165 | 28 | 0 |
419196 | 419196 | 2020-08-10 | Menifee | Kentucky | 21165 | 28 | 0 |
415975 | 415975 | 2020-08-09 | Menifee | Kentucky | 21165 | 28 | 0 |
412755 | 412755 | 2020-08-08 | Menifee | Kentucky | 21165 | 28 | 0 |
409535 | 409535 | 2020-08-07 | Menifee | Kentucky | 21165 | 28 | 0 |
406315 | 406315 | 2020-08-06 | Menifee | Kentucky | 21165 | 29 | 0 |
403097 | 403097 | 2020-08-05 | Menifee | Kentucky | 21165 | 29 | 0 |
399880 | 399880 | 2020-08-04 | Menifee | Kentucky | 21165 | 29 | 0 |
396665 | 396665 | 2020-08-03 | Menifee | Kentucky | 21165 | 29 | 0 |
393449 | 393449 | 2020-08-02 | Menifee | Kentucky | 21165 | 29 | 0 |
390232 | 390232 | 2020-08-01 | Menifee | Kentucky | 21165 | 29 | 0 |
387015 | 387015 | 2020-07-31 | Menifee | Kentucky | 21165 | 29 | 0 |
383797 | 383797 | 2020-07-30 | Menifee | Kentucky | 21165 | 28 | 0 |
380580 | 380580 | 2020-07-29 | Menifee | Kentucky | 21165 | 26 | 0 |
377363 | 377363 | 2020-07-28 | Menifee | Kentucky | 21165 | 24 | 0 |
374148 | 374148 | 2020-07-27 | Menifee | Kentucky | 21165 | 24 | 0 |
370936 | 370936 | 2020-07-26 | Menifee | Kentucky | 21165 | 23 | 0 |
367726 | 367726 | 2020-07-25 | Menifee | Kentucky | 21165 | 22 | 0 |
364519 | 364519 | 2020-07-24 | Menifee | Kentucky | 21165 | 21 | 0 |
361312 | 361312 | 2020-07-23 | Menifee | Kentucky | 21165 | 19 | 0 |
358107 | 358107 | 2020-07-22 | Menifee | Kentucky | 21165 | 19 | 0 |
354904 | 354904 | 2020-07-21 | Menifee | Kentucky | 21165 | 19 | 0 |
351702 | 351702 | 2020-07-20 | Menifee | Kentucky | 21165 | 19 | 0 |
348502 | 348502 | 2020-07-19 | Menifee | Kentucky | 21165 | 19 | 0 |
345301 | 345301 | 2020-07-18 | Menifee | Kentucky | 21165 | 19 | 0 |
342101 | 342101 | 2020-07-17 | Menifee | Kentucky | 21165 | 18 | 0 |
338905 | 338905 | 2020-07-16 | Menifee | Kentucky | 21165 | 18 | 0 |
335709 | 335709 | 2020-07-15 | Menifee | Kentucky | 21165 | 14 | 0 |
332516 | 332516 | 2020-07-14 | Menifee | Kentucky | 21165 | 14 | 0 |
329329 | 329329 | 2020-07-13 | Menifee | Kentucky | 21165 | 15 | 0 |
326143 | 326143 | 2020-07-12 | Menifee | Kentucky | 21165 | 14 | 0 |
322960 | 322960 | 2020-07-11 | Menifee | Kentucky | 21165 | 14 | 0 |
319781 | 319781 | 2020-07-10 | Menifee | Kentucky | 21165 | 13 | 0 |
316606 | 316606 | 2020-07-09 | Menifee | Kentucky | 21165 | 13 | 0 |
313432 | 313432 | 2020-07-08 | Menifee | Kentucky | 21165 | 13 | 0 |
310262 | 310262 | 2020-07-07 | Menifee | Kentucky | 21165 | 13 | 0 |
307094 | 307094 | 2020-07-06 | Menifee | Kentucky | 21165 | 13 | 0 |
303927 | 303927 | 2020-07-05 | Menifee | Kentucky | 21165 | 13 | 0 |
300763 | 300763 | 2020-07-04 | Menifee | Kentucky | 21165 | 13 | 0 |
297601 | 297601 | 2020-07-03 | Menifee | Kentucky | 21165 | 13 | 0 |
294443 | 294443 | 2020-07-02 | Menifee | Kentucky | 21165 | 13 | 0 |
291289 | 291289 | 2020-07-01 | Menifee | Kentucky | 21165 | 13 | 0 |
288139 | 288139 | 2020-06-30 | Menifee | Kentucky | 21165 | 13 | 0 |
284990 | 284990 | 2020-06-29 | Menifee | Kentucky | 21165 | 13 | 0 |
281844 | 281844 | 2020-06-28 | Menifee | Kentucky | 21165 | 13 | 0 |
278696 | 278696 | 2020-06-27 | Menifee | Kentucky | 21165 | 12 | 0 |
275548 | 275548 | 2020-06-26 | Menifee | Kentucky | 21165 | 12 | 0 |
272405 | 272405 | 2020-06-25 | Menifee | Kentucky | 21165 | 12 | 0 |
269269 | 269269 | 2020-06-24 | Menifee | Kentucky | 21165 | 12 | 0 |
266136 | 266136 | 2020-06-23 | Menifee | Kentucky | 21165 | 12 | 0 |
263009 | 263009 | 2020-06-22 | Menifee | Kentucky | 21165 | 11 | 0 |
259880 | 259880 | 2020-06-21 | Menifee | Kentucky | 21165 | 11 | 0 |
256754 | 256754 | 2020-06-20 | Menifee | Kentucky | 21165 | 11 | 0 |
253634 | 253634 | 2020-06-19 | Menifee | Kentucky | 21165 | 11 | 0 |
250519 | 250519 | 2020-06-18 | Menifee | Kentucky | 21165 | 11 | 0 |
247407 | 247407 | 2020-06-17 | Menifee | Kentucky | 21165 | 11 | 0 |
244294 | 244294 | 2020-06-16 | Menifee | Kentucky | 21165 | 11 | 0 |
241183 | 241183 | 2020-06-15 | Menifee | Kentucky | 21165 | 11 | 0 |
238074 | 238074 | 2020-06-14 | Menifee | Kentucky | 21165 | 11 | 0 |
234967 | 234967 | 2020-06-13 | Menifee | Kentucky | 21165 | 10 | 0 |
231862 | 231862 | 2020-06-12 | Menifee | Kentucky | 21165 | 10 | 0 |
228758 | 228758 | 2020-06-11 | Menifee | Kentucky | 21165 | 10 | 0 |
225656 | 225656 | 2020-06-10 | Menifee | Kentucky | 21165 | 10 | 0 |
222560 | 222560 | 2020-06-09 | Menifee | Kentucky | 21165 | 10 | 0 |
219465 | 219465 | 2020-06-08 | Menifee | Kentucky | 21165 | 10 | 0 |
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);