ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92,572 rows where state = "Kentucky" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 21067 799
- 21097 797
- 21111 797
- 21173 793
- 21017 791
- 21179 791
- 21049 790
- 21143 788
- 21073 787
- 21117 787
- 21227 787
- 21047 786
- 21059 786
- 21101 786
- 21199 786
- 21209 786
- 21035 785
- 21005 784
- 21151 784
- 21215 784
- 21003 783
- 21025 783
- 21093 783
- 21113 783
- 21185 783
- 21141 782
- 21145 781
- 21159 781
- 21165 781
- 21177 781
- …
county >30
- Fayette 799
- Harrison 797
- Jefferson 797
- Montgomery 793
- Bourbon 791
- Nelson 791
- Clark 790
- Lyon 788
- Franklin 787
- Kenton 787
- Warren 787
- Christian 786
- Daviess 786
- Henderson 786
- Pulaski 786
- Scott 786
- Calloway 785
- Anderson 784
- Madison 784
- Spencer 784
- Allen 783
- Breathitt 783
- Hardin 783
- Jessamine 783
- Oldham 783
- Logan 782
- Martin 781
- McCracken 781
- Menifee 781
- Muhlenberg 781
- …
state 1
- Kentucky · 92,472 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
332434 | 332434 | 2020-07-14 | Adair | Kentucky | 21001 | 160 | 19 |
335627 | 335627 | 2020-07-15 | Adair | Kentucky | 21001 | 163 | 19 |
338823 | 338823 | 2020-07-16 | Adair | Kentucky | 21001 | 170 | 19 |
342019 | 342019 | 2020-07-17 | Adair | Kentucky | 21001 | 173 | 19 |
345219 | 345219 | 2020-07-18 | Adair | Kentucky | 21001 | 174 | 19 |
348420 | 348420 | 2020-07-19 | Adair | Kentucky | 21001 | 176 | 19 |
351620 | 351620 | 2020-07-20 | Adair | Kentucky | 21001 | 179 | 19 |
354822 | 354822 | 2020-07-21 | Adair | Kentucky | 21001 | 180 | 19 |
358025 | 358025 | 2020-07-22 | Adair | Kentucky | 21001 | 184 | 19 |
361230 | 361230 | 2020-07-23 | Adair | Kentucky | 21001 | 187 | 19 |
364437 | 364437 | 2020-07-24 | Adair | Kentucky | 21001 | 198 | 19 |
367644 | 367644 | 2020-07-25 | Adair | Kentucky | 21001 | 198 | 19 |
370854 | 370854 | 2020-07-26 | Adair | Kentucky | 21001 | 198 | 19 |
374066 | 374066 | 2020-07-27 | Adair | Kentucky | 21001 | 198 | 19 |
377281 | 377281 | 2020-07-28 | Adair | Kentucky | 21001 | 198 | 19 |
380498 | 380498 | 2020-07-29 | Adair | Kentucky | 21001 | 200 | 19 |
383715 | 383715 | 2020-07-30 | Adair | Kentucky | 21001 | 201 | 19 |
386933 | 386933 | 2020-07-31 | Adair | Kentucky | 21001 | 202 | 19 |
390150 | 390150 | 2020-08-01 | Adair | Kentucky | 21001 | 204 | 19 |
393367 | 393367 | 2020-08-02 | Adair | Kentucky | 21001 | 205 | 19 |
396583 | 396583 | 2020-08-03 | Adair | Kentucky | 21001 | 211 | 19 |
399798 | 399798 | 2020-08-04 | Adair | Kentucky | 21001 | 217 | 19 |
403015 | 403015 | 2020-08-05 | Adair | Kentucky | 21001 | 218 | 19 |
406233 | 406233 | 2020-08-06 | Adair | Kentucky | 21001 | 226 | 19 |
409453 | 409453 | 2020-08-07 | Adair | Kentucky | 21001 | 230 | 19 |
412673 | 412673 | 2020-08-08 | Adair | Kentucky | 21001 | 231 | 19 |
415893 | 415893 | 2020-08-09 | Adair | Kentucky | 21001 | 232 | 19 |
419114 | 419114 | 2020-08-10 | Adair | Kentucky | 21001 | 236 | 19 |
422336 | 422336 | 2020-08-11 | Adair | Kentucky | 21001 | 236 | 19 |
425557 | 425557 | 2020-08-12 | Adair | Kentucky | 21001 | 237 | 19 |
428781 | 428781 | 2020-08-13 | Adair | Kentucky | 21001 | 237 | 19 |
432009 | 432009 | 2020-08-14 | Adair | Kentucky | 21001 | 238 | 19 |
435234 | 435234 | 2020-08-15 | Adair | Kentucky | 21001 | 239 | 19 |
438459 | 438459 | 2020-08-16 | Adair | Kentucky | 21001 | 239 | 19 |
441686 | 441686 | 2020-08-17 | Adair | Kentucky | 21001 | 243 | 19 |
444912 | 444912 | 2020-08-18 | Adair | Kentucky | 21001 | 243 | 19 |
448139 | 448139 | 2020-08-19 | Adair | Kentucky | 21001 | 243 | 19 |
451367 | 451367 | 2020-08-20 | Adair | Kentucky | 21001 | 245 | 19 |
454595 | 454595 | 2020-08-21 | Adair | Kentucky | 21001 | 253 | 19 |
457823 | 457823 | 2020-08-22 | Adair | Kentucky | 21001 | 254 | 19 |
461050 | 461050 | 2020-08-23 | Adair | Kentucky | 21001 | 257 | 19 |
464281 | 464281 | 2020-08-24 | Adair | Kentucky | 21001 | 257 | 19 |
467510 | 467510 | 2020-08-25 | Adair | Kentucky | 21001 | 259 | 19 |
470739 | 470739 | 2020-08-26 | Adair | Kentucky | 21001 | 263 | 19 |
473971 | 473971 | 2020-08-27 | Adair | Kentucky | 21001 | 265 | 19 |
477204 | 477204 | 2020-08-28 | Adair | Kentucky | 21001 | 267 | 19 |
480437 | 480437 | 2020-08-29 | Adair | Kentucky | 21001 | 267 | 19 |
483671 | 483671 | 2020-08-30 | Adair | Kentucky | 21001 | 267 | 19 |
486906 | 486906 | 2020-08-31 | Adair | Kentucky | 21001 | 270 | 19 |
490139 | 490139 | 2020-09-01 | Adair | Kentucky | 21001 | 272 | 19 |
493373 | 493373 | 2020-09-02 | Adair | Kentucky | 21001 | 277 | 19 |
496606 | 496606 | 2020-09-03 | Adair | Kentucky | 21001 | 277 | 19 |
499840 | 499840 | 2020-09-04 | Adair | Kentucky | 21001 | 282 | 19 |
503073 | 503073 | 2020-09-05 | Adair | Kentucky | 21001 | 282 | 19 |
506307 | 506307 | 2020-09-06 | Adair | Kentucky | 21001 | 282 | 19 |
509540 | 509540 | 2020-09-07 | Adair | Kentucky | 21001 | 282 | 19 |
512772 | 512772 | 2020-09-08 | Adair | Kentucky | 21001 | 287 | 19 |
516005 | 516005 | 2020-09-09 | Adair | Kentucky | 21001 | 289 | 19 |
519240 | 519240 | 2020-09-10 | Adair | Kentucky | 21001 | 289 | 19 |
522477 | 522477 | 2020-09-11 | Adair | Kentucky | 21001 | 289 | 19 |
525713 | 525713 | 2020-09-12 | Adair | Kentucky | 21001 | 289 | 19 |
528949 | 528949 | 2020-09-13 | Adair | Kentucky | 21001 | 290 | 19 |
532186 | 532186 | 2020-09-14 | Adair | Kentucky | 21001 | 291 | 19 |
535421 | 535421 | 2020-09-15 | Adair | Kentucky | 21001 | 296 | 19 |
538658 | 538658 | 2020-09-16 | Adair | Kentucky | 21001 | 298 | 19 |
541894 | 541894 | 2020-09-17 | Adair | Kentucky | 21001 | 299 | 19 |
545130 | 545130 | 2020-09-18 | Adair | Kentucky | 21001 | 301 | 19 |
548368 | 548368 | 2020-09-19 | Adair | Kentucky | 21001 | 301 | 19 |
551607 | 551607 | 2020-09-20 | Adair | Kentucky | 21001 | 302 | 19 |
554846 | 554846 | 2020-09-21 | Adair | Kentucky | 21001 | 306 | 19 |
558083 | 558083 | 2020-09-22 | Adair | Kentucky | 21001 | 314 | 19 |
561319 | 561319 | 2020-09-23 | Adair | Kentucky | 21001 | 314 | 19 |
564559 | 564559 | 2020-09-24 | Adair | Kentucky | 21001 | 315 | 19 |
567799 | 567799 | 2020-09-25 | Adair | Kentucky | 21001 | 316 | 19 |
571041 | 571041 | 2020-09-26 | Adair | Kentucky | 21001 | 317 | 19 |
574284 | 574284 | 2020-09-27 | Adair | Kentucky | 21001 | 317 | 19 |
577526 | 577526 | 2020-09-28 | Adair | Kentucky | 21001 | 321 | 19 |
580767 | 580767 | 2020-09-29 | Adair | Kentucky | 21001 | 322 | 19 |
584007 | 584007 | 2020-09-30 | Adair | Kentucky | 21001 | 325 | 19 |
587247 | 587247 | 2020-10-01 | Adair | Kentucky | 21001 | 334 | 19 |
590488 | 590488 | 2020-10-02 | Adair | Kentucky | 21001 | 339 | 19 |
593729 | 593729 | 2020-10-03 | Adair | Kentucky | 21001 | 343 | 19 |
596971 | 596971 | 2020-10-04 | Adair | Kentucky | 21001 | 344 | 19 |
600213 | 600213 | 2020-10-05 | Adair | Kentucky | 21001 | 348 | 19 |
603456 | 603456 | 2020-10-06 | Adair | Kentucky | 21001 | 362 | 19 |
606698 | 606698 | 2020-10-07 | Adair | Kentucky | 21001 | 369 | 19 |
609940 | 609940 | 2020-10-08 | Adair | Kentucky | 21001 | 378 | 19 |
613182 | 613182 | 2020-10-09 | Adair | Kentucky | 21001 | 387 | 20 |
616423 | 616423 | 2020-10-10 | Adair | Kentucky | 21001 | 400 | 20 |
619665 | 619665 | 2020-10-11 | Adair | Kentucky | 21001 | 405 | 20 |
622909 | 622909 | 2020-10-12 | Adair | Kentucky | 21001 | 418 | 20 |
626151 | 626151 | 2020-10-13 | Adair | Kentucky | 21001 | 423 | 20 |
629395 | 629395 | 2020-10-14 | Adair | Kentucky | 21001 | 430 | 20 |
632639 | 632639 | 2020-10-15 | Adair | Kentucky | 21001 | 438 | 21 |
635885 | 635885 | 2020-10-16 | Adair | Kentucky | 21001 | 446 | 21 |
639131 | 639131 | 2020-10-17 | Adair | Kentucky | 21001 | 448 | 21 |
642378 | 642378 | 2020-10-18 | Adair | Kentucky | 21001 | 453 | 21 |
645625 | 645625 | 2020-10-19 | Adair | Kentucky | 21001 | 461 | 21 |
648869 | 648869 | 2020-10-20 | Adair | Kentucky | 21001 | 472 | 22 |
652114 | 652114 | 2020-10-21 | Adair | Kentucky | 21001 | 485 | 22 |
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);