ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 21097 and state = "Kentucky" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
244260 | 244260 | 2020-06-16 | Harrison | Kentucky | 21097 | 56 | 0 |
247373 | 247373 | 2020-06-17 | Harrison | Kentucky | 21097 | 56 | 0 |
250485 | 250485 | 2020-06-18 | Harrison | Kentucky | 21097 | 56 | 0 |
253600 | 253600 | 2020-06-19 | Harrison | Kentucky | 21097 | 56 | 0 |
256720 | 256720 | 2020-06-20 | Harrison | Kentucky | 21097 | 58 | 0 |
259846 | 259846 | 2020-06-21 | Harrison | Kentucky | 21097 | 59 | 0 |
262975 | 262975 | 2020-06-22 | Harrison | Kentucky | 21097 | 59 | 0 |
266102 | 266102 | 2020-06-23 | Harrison | Kentucky | 21097 | 65 | 0 |
269235 | 269235 | 2020-06-24 | Harrison | Kentucky | 21097 | 65 | 0 |
272371 | 272371 | 2020-06-25 | Harrison | Kentucky | 21097 | 66 | 0 |
275514 | 275514 | 2020-06-26 | Harrison | Kentucky | 21097 | 66 | 0 |
278662 | 278662 | 2020-06-27 | Harrison | Kentucky | 21097 | 68 | 0 |
281810 | 281810 | 2020-06-28 | Harrison | Kentucky | 21097 | 68 | 0 |
284956 | 284956 | 2020-06-29 | Harrison | Kentucky | 21097 | 68 | 0 |
288105 | 288105 | 2020-06-30 | Harrison | Kentucky | 21097 | 70 | 0 |
291255 | 291255 | 2020-07-01 | Harrison | Kentucky | 21097 | 73 | 0 |
294409 | 294409 | 2020-07-02 | Harrison | Kentucky | 21097 | 73 | 0 |
297567 | 297567 | 2020-07-03 | Harrison | Kentucky | 21097 | 74 | 0 |
300729 | 300729 | 2020-07-04 | Harrison | Kentucky | 21097 | 74 | 0 |
303893 | 303893 | 2020-07-05 | Harrison | Kentucky | 21097 | 74 | 0 |
307060 | 307060 | 2020-07-06 | Harrison | Kentucky | 21097 | 79 | 0 |
310228 | 310228 | 2020-07-07 | Harrison | Kentucky | 21097 | 79 | 0 |
313398 | 313398 | 2020-07-08 | Harrison | Kentucky | 21097 | 81 | 0 |
316572 | 316572 | 2020-07-09 | Harrison | Kentucky | 21097 | 81 | 0 |
319747 | 319747 | 2020-07-10 | Harrison | Kentucky | 21097 | 81 | 0 |
322926 | 322926 | 2020-07-11 | Harrison | Kentucky | 21097 | 81 | 0 |
326109 | 326109 | 2020-07-12 | Harrison | Kentucky | 21097 | 81 | 0 |
329295 | 329295 | 2020-07-13 | Harrison | Kentucky | 21097 | 81 | 0 |
332482 | 332482 | 2020-07-14 | Harrison | Kentucky | 21097 | 82 | 0 |
335675 | 335675 | 2020-07-15 | Harrison | Kentucky | 21097 | 86 | 0 |
338871 | 338871 | 2020-07-16 | Harrison | Kentucky | 21097 | 86 | 0 |
342067 | 342067 | 2020-07-17 | Harrison | Kentucky | 21097 | 87 | 0 |
345267 | 345267 | 2020-07-18 | Harrison | Kentucky | 21097 | 88 | 0 |
348468 | 348468 | 2020-07-19 | Harrison | Kentucky | 21097 | 91 | 0 |
351668 | 351668 | 2020-07-20 | Harrison | Kentucky | 21097 | 95 | 0 |
354870 | 354870 | 2020-07-21 | Harrison | Kentucky | 21097 | 99 | 0 |
358073 | 358073 | 2020-07-22 | Harrison | Kentucky | 21097 | 105 | 0 |
361278 | 361278 | 2020-07-23 | Harrison | Kentucky | 21097 | 107 | 0 |
364485 | 364485 | 2020-07-24 | Harrison | Kentucky | 21097 | 107 | 0 |
367692 | 367692 | 2020-07-25 | Harrison | Kentucky | 21097 | 107 | 0 |
370902 | 370902 | 2020-07-26 | Harrison | Kentucky | 21097 | 108 | 0 |
374114 | 374114 | 2020-07-27 | Harrison | Kentucky | 21097 | 110 | 0 |
377329 | 377329 | 2020-07-28 | Harrison | Kentucky | 21097 | 111 | 0 |
380546 | 380546 | 2020-07-29 | Harrison | Kentucky | 21097 | 111 | 0 |
383763 | 383763 | 2020-07-30 | Harrison | Kentucky | 21097 | 113 | 0 |
386981 | 386981 | 2020-07-31 | Harrison | Kentucky | 21097 | 113 | 0 |
390198 | 390198 | 2020-08-01 | Harrison | Kentucky | 21097 | 115 | 0 |
393415 | 393415 | 2020-08-02 | Harrison | Kentucky | 21097 | 116 | 0 |
396631 | 396631 | 2020-08-03 | Harrison | Kentucky | 21097 | 116 | 0 |
399846 | 399846 | 2020-08-04 | Harrison | Kentucky | 21097 | 117 | 0 |
403063 | 403063 | 2020-08-05 | Harrison | Kentucky | 21097 | 117 | 0 |
406281 | 406281 | 2020-08-06 | Harrison | Kentucky | 21097 | 119 | 0 |
409501 | 409501 | 2020-08-07 | Harrison | Kentucky | 21097 | 119 | 0 |
412721 | 412721 | 2020-08-08 | Harrison | Kentucky | 21097 | 121 | 0 |
415941 | 415941 | 2020-08-09 | Harrison | Kentucky | 21097 | 121 | 0 |
419162 | 419162 | 2020-08-10 | Harrison | Kentucky | 21097 | 121 | 0 |
422384 | 422384 | 2020-08-11 | Harrison | Kentucky | 21097 | 121 | 0 |
425605 | 425605 | 2020-08-12 | Harrison | Kentucky | 21097 | 123 | 0 |
428829 | 428829 | 2020-08-13 | Harrison | Kentucky | 21097 | 123 | 0 |
432057 | 432057 | 2020-08-14 | Harrison | Kentucky | 21097 | 123 | 0 |
435282 | 435282 | 2020-08-15 | Harrison | Kentucky | 21097 | 123 | 0 |
438507 | 438507 | 2020-08-16 | Harrison | Kentucky | 21097 | 123 | 0 |
441734 | 441734 | 2020-08-17 | Harrison | Kentucky | 21097 | 123 | 0 |
444960 | 444960 | 2020-08-18 | Harrison | Kentucky | 21097 | 132 | 0 |
448187 | 448187 | 2020-08-19 | Harrison | Kentucky | 21097 | 137 | 0 |
451415 | 451415 | 2020-08-20 | Harrison | Kentucky | 21097 | 137 | 0 |
454643 | 454643 | 2020-08-21 | Harrison | Kentucky | 21097 | 138 | 0 |
457871 | 457871 | 2020-08-22 | Harrison | Kentucky | 21097 | 139 | 0 |
461098 | 461098 | 2020-08-23 | Harrison | Kentucky | 21097 | 139 | 0 |
464329 | 464329 | 2020-08-24 | Harrison | Kentucky | 21097 | 139 | 0 |
467558 | 467558 | 2020-08-25 | Harrison | Kentucky | 21097 | 139 | 0 |
470787 | 470787 | 2020-08-26 | Harrison | Kentucky | 21097 | 146 | 0 |
474019 | 474019 | 2020-08-27 | Harrison | Kentucky | 21097 | 150 | 0 |
477252 | 477252 | 2020-08-28 | Harrison | Kentucky | 21097 | 150 | 0 |
480485 | 480485 | 2020-08-29 | Harrison | Kentucky | 21097 | 151 | 0 |
483719 | 483719 | 2020-08-30 | Harrison | Kentucky | 21097 | 151 | 0 |
486954 | 486954 | 2020-08-31 | Harrison | Kentucky | 21097 | 151 | 0 |
490187 | 490187 | 2020-09-01 | Harrison | Kentucky | 21097 | 155 | 0 |
493421 | 493421 | 2020-09-02 | Harrison | Kentucky | 21097 | 158 | 0 |
496654 | 496654 | 2020-09-03 | Harrison | Kentucky | 21097 | 159 | 0 |
499888 | 499888 | 2020-09-04 | Harrison | Kentucky | 21097 | 158 | 0 |
503121 | 503121 | 2020-09-05 | Harrison | Kentucky | 21097 | 158 | 0 |
506355 | 506355 | 2020-09-06 | Harrison | Kentucky | 21097 | 158 | 0 |
509588 | 509588 | 2020-09-07 | Harrison | Kentucky | 21097 | 158 | 0 |
512820 | 512820 | 2020-09-08 | Harrison | Kentucky | 21097 | 158 | 0 |
516053 | 516053 | 2020-09-09 | Harrison | Kentucky | 21097 | 163 | 0 |
519288 | 519288 | 2020-09-10 | Harrison | Kentucky | 21097 | 163 | 0 |
522525 | 522525 | 2020-09-11 | Harrison | Kentucky | 21097 | 164 | 0 |
525761 | 525761 | 2020-09-12 | Harrison | Kentucky | 21097 | 164 | 0 |
528997 | 528997 | 2020-09-13 | Harrison | Kentucky | 21097 | 164 | 0 |
532234 | 532234 | 2020-09-14 | Harrison | Kentucky | 21097 | 165 | 0 |
535469 | 535469 | 2020-09-15 | Harrison | Kentucky | 21097 | 165 | 0 |
538706 | 538706 | 2020-09-16 | Harrison | Kentucky | 21097 | 167 | 0 |
541942 | 541942 | 2020-09-17 | Harrison | Kentucky | 21097 | 167 | 0 |
545178 | 545178 | 2020-09-18 | Harrison | Kentucky | 21097 | 167 | 0 |
548416 | 548416 | 2020-09-19 | Harrison | Kentucky | 21097 | 167 | 0 |
551655 | 551655 | 2020-09-20 | Harrison | Kentucky | 21097 | 167 | 0 |
554894 | 554894 | 2020-09-21 | Harrison | Kentucky | 21097 | 167 | 0 |
558131 | 558131 | 2020-09-22 | Harrison | Kentucky | 21097 | 169 | 0 |
561367 | 561367 | 2020-09-23 | Harrison | Kentucky | 21097 | 171 | 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);