ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
711 rows where county = "Estill" and state = "Kentucky" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
200912 | 200912 | 2020-06-02 | Estill | Kentucky | 21065 | 1 | 0 |
203989 | 203989 | 2020-06-03 | Estill | Kentucky | 21065 | 1 | 0 |
207070 | 207070 | 2020-06-04 | Estill | Kentucky | 21065 | 1 | 0 |
210151 | 210151 | 2020-06-05 | Estill | Kentucky | 21065 | 1 | 0 |
213236 | 213236 | 2020-06-06 | Estill | Kentucky | 21065 | 1 | 0 |
216323 | 216323 | 2020-06-07 | Estill | Kentucky | 21065 | 1 | 0 |
219415 | 219415 | 2020-06-08 | Estill | Kentucky | 21065 | 1 | 0 |
222510 | 222510 | 2020-06-09 | Estill | Kentucky | 21065 | 1 | 0 |
225606 | 225606 | 2020-06-10 | Estill | Kentucky | 21065 | 1 | 0 |
228708 | 228708 | 2020-06-11 | Estill | Kentucky | 21065 | 2 | 0 |
231812 | 231812 | 2020-06-12 | Estill | Kentucky | 21065 | 3 | 0 |
234917 | 234917 | 2020-06-13 | Estill | Kentucky | 21065 | 5 | 0 |
238024 | 238024 | 2020-06-14 | Estill | Kentucky | 21065 | 5 | 0 |
241133 | 241133 | 2020-06-15 | Estill | Kentucky | 21065 | 5 | 0 |
244244 | 244244 | 2020-06-16 | Estill | Kentucky | 21065 | 5 | 0 |
247357 | 247357 | 2020-06-17 | Estill | Kentucky | 21065 | 5 | 0 |
250469 | 250469 | 2020-06-18 | Estill | Kentucky | 21065 | 5 | 0 |
253584 | 253584 | 2020-06-19 | Estill | Kentucky | 21065 | 5 | 0 |
256704 | 256704 | 2020-06-20 | Estill | Kentucky | 21065 | 5 | 0 |
259830 | 259830 | 2020-06-21 | Estill | Kentucky | 21065 | 5 | 0 |
262959 | 262959 | 2020-06-22 | Estill | Kentucky | 21065 | 5 | 0 |
266086 | 266086 | 2020-06-23 | Estill | Kentucky | 21065 | 5 | 0 |
269219 | 269219 | 2020-06-24 | Estill | Kentucky | 21065 | 5 | 0 |
272355 | 272355 | 2020-06-25 | Estill | Kentucky | 21065 | 4 | 0 |
275498 | 275498 | 2020-06-26 | Estill | Kentucky | 21065 | 4 | 0 |
278646 | 278646 | 2020-06-27 | Estill | Kentucky | 21065 | 4 | 0 |
281794 | 281794 | 2020-06-28 | Estill | Kentucky | 21065 | 4 | 0 |
284940 | 284940 | 2020-06-29 | Estill | Kentucky | 21065 | 4 | 0 |
288089 | 288089 | 2020-06-30 | Estill | Kentucky | 21065 | 4 | 0 |
291239 | 291239 | 2020-07-01 | Estill | Kentucky | 21065 | 4 | 0 |
294393 | 294393 | 2020-07-02 | Estill | Kentucky | 21065 | 4 | 0 |
297551 | 297551 | 2020-07-03 | Estill | Kentucky | 21065 | 4 | 0 |
300713 | 300713 | 2020-07-04 | Estill | Kentucky | 21065 | 4 | 0 |
303877 | 303877 | 2020-07-05 | Estill | Kentucky | 21065 | 4 | 0 |
307044 | 307044 | 2020-07-06 | Estill | Kentucky | 21065 | 4 | 0 |
310212 | 310212 | 2020-07-07 | Estill | Kentucky | 21065 | 4 | 0 |
313382 | 313382 | 2020-07-08 | Estill | Kentucky | 21065 | 5 | 0 |
316556 | 316556 | 2020-07-09 | Estill | Kentucky | 21065 | 5 | 0 |
319731 | 319731 | 2020-07-10 | Estill | Kentucky | 21065 | 5 | 0 |
322910 | 322910 | 2020-07-11 | Estill | Kentucky | 21065 | 6 | 0 |
326093 | 326093 | 2020-07-12 | Estill | Kentucky | 21065 | 6 | 0 |
329279 | 329279 | 2020-07-13 | Estill | Kentucky | 21065 | 6 | 0 |
332466 | 332466 | 2020-07-14 | Estill | Kentucky | 21065 | 7 | 0 |
335659 | 335659 | 2020-07-15 | Estill | Kentucky | 21065 | 7 | 0 |
338855 | 338855 | 2020-07-16 | Estill | Kentucky | 21065 | 7 | 0 |
342051 | 342051 | 2020-07-17 | Estill | Kentucky | 21065 | 7 | 0 |
345251 | 345251 | 2020-07-18 | Estill | Kentucky | 21065 | 7 | 0 |
348452 | 348452 | 2020-07-19 | Estill | Kentucky | 21065 | 8 | 0 |
351652 | 351652 | 2020-07-20 | Estill | Kentucky | 21065 | 8 | 0 |
354854 | 354854 | 2020-07-21 | Estill | Kentucky | 21065 | 8 | 0 |
358057 | 358057 | 2020-07-22 | Estill | Kentucky | 21065 | 8 | 0 |
361262 | 361262 | 2020-07-23 | Estill | Kentucky | 21065 | 8 | 0 |
364469 | 364469 | 2020-07-24 | Estill | Kentucky | 21065 | 9 | 0 |
367676 | 367676 | 2020-07-25 | Estill | Kentucky | 21065 | 10 | 0 |
370886 | 370886 | 2020-07-26 | Estill | Kentucky | 21065 | 10 | 0 |
374098 | 374098 | 2020-07-27 | Estill | Kentucky | 21065 | 10 | 0 |
377313 | 377313 | 2020-07-28 | Estill | Kentucky | 21065 | 10 | 0 |
380530 | 380530 | 2020-07-29 | Estill | Kentucky | 21065 | 11 | 0 |
383747 | 383747 | 2020-07-30 | Estill | Kentucky | 21065 | 11 | 0 |
386965 | 386965 | 2020-07-31 | Estill | Kentucky | 21065 | 12 | 0 |
390182 | 390182 | 2020-08-01 | Estill | Kentucky | 21065 | 12 | 0 |
393399 | 393399 | 2020-08-02 | Estill | Kentucky | 21065 | 12 | 0 |
396615 | 396615 | 2020-08-03 | Estill | Kentucky | 21065 | 12 | 0 |
399830 | 399830 | 2020-08-04 | Estill | Kentucky | 21065 | 17 | 0 |
403047 | 403047 | 2020-08-05 | Estill | Kentucky | 21065 | 18 | 0 |
406265 | 406265 | 2020-08-06 | Estill | Kentucky | 21065 | 18 | 0 |
409485 | 409485 | 2020-08-07 | Estill | Kentucky | 21065 | 18 | 0 |
412705 | 412705 | 2020-08-08 | Estill | Kentucky | 21065 | 21 | 0 |
415925 | 415925 | 2020-08-09 | Estill | Kentucky | 21065 | 22 | 0 |
419146 | 419146 | 2020-08-10 | Estill | Kentucky | 21065 | 22 | 0 |
422368 | 422368 | 2020-08-11 | Estill | Kentucky | 21065 | 27 | 0 |
425589 | 425589 | 2020-08-12 | Estill | Kentucky | 21065 | 27 | 0 |
428813 | 428813 | 2020-08-13 | Estill | Kentucky | 21065 | 27 | 0 |
432041 | 432041 | 2020-08-14 | Estill | Kentucky | 21065 | 27 | 0 |
435266 | 435266 | 2020-08-15 | Estill | Kentucky | 21065 | 27 | 0 |
438491 | 438491 | 2020-08-16 | Estill | Kentucky | 21065 | 27 | 0 |
441718 | 441718 | 2020-08-17 | Estill | Kentucky | 21065 | 27 | 0 |
444944 | 444944 | 2020-08-18 | Estill | Kentucky | 21065 | 27 | 0 |
448171 | 448171 | 2020-08-19 | Estill | Kentucky | 21065 | 27 | 0 |
451399 | 451399 | 2020-08-20 | Estill | Kentucky | 21065 | 28 | 0 |
454627 | 454627 | 2020-08-21 | Estill | Kentucky | 21065 | 28 | 0 |
457855 | 457855 | 2020-08-22 | Estill | Kentucky | 21065 | 28 | 0 |
461082 | 461082 | 2020-08-23 | Estill | Kentucky | 21065 | 28 | 0 |
464313 | 464313 | 2020-08-24 | Estill | Kentucky | 21065 | 29 | 0 |
467542 | 467542 | 2020-08-25 | Estill | Kentucky | 21065 | 28 | 0 |
470771 | 470771 | 2020-08-26 | Estill | Kentucky | 21065 | 30 | 0 |
474003 | 474003 | 2020-08-27 | Estill | Kentucky | 21065 | 32 | 0 |
477236 | 477236 | 2020-08-28 | Estill | Kentucky | 21065 | 34 | 0 |
480469 | 480469 | 2020-08-29 | Estill | Kentucky | 21065 | 37 | 0 |
483703 | 483703 | 2020-08-30 | Estill | Kentucky | 21065 | 41 | 0 |
486938 | 486938 | 2020-08-31 | Estill | Kentucky | 21065 | 43 | 0 |
490171 | 490171 | 2020-09-01 | Estill | Kentucky | 21065 | 45 | 0 |
493405 | 493405 | 2020-09-02 | Estill | Kentucky | 21065 | 53 | 0 |
496638 | 496638 | 2020-09-03 | Estill | Kentucky | 21065 | 57 | 0 |
499872 | 499872 | 2020-09-04 | Estill | Kentucky | 21065 | 59 | 0 |
503105 | 503105 | 2020-09-05 | Estill | Kentucky | 21065 | 60 | 0 |
506339 | 506339 | 2020-09-06 | Estill | Kentucky | 21065 | 61 | 0 |
509572 | 509572 | 2020-09-07 | Estill | Kentucky | 21065 | 61 | 0 |
512804 | 512804 | 2020-09-08 | Estill | Kentucky | 21065 | 61 | 0 |
516037 | 516037 | 2020-09-09 | Estill | Kentucky | 21065 | 62 | 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);