ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21199 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635984 | 635984 | 2020-10-16 | Pulaski | Kentucky | 21199 | 953 | 12 |
632738 | 632738 | 2020-10-15 | Pulaski | Kentucky | 21199 | 942 | 12 |
629494 | 629494 | 2020-10-14 | Pulaski | Kentucky | 21199 | 931 | 12 |
626250 | 626250 | 2020-10-13 | Pulaski | Kentucky | 21199 | 921 | 12 |
623008 | 623008 | 2020-10-12 | Pulaski | Kentucky | 21199 | 915 | 12 |
619764 | 619764 | 2020-10-11 | Pulaski | Kentucky | 21199 | 905 | 12 |
616522 | 616522 | 2020-10-10 | Pulaski | Kentucky | 21199 | 900 | 12 |
613281 | 613281 | 2020-10-09 | Pulaski | Kentucky | 21199 | 893 | 12 |
610039 | 610039 | 2020-10-08 | Pulaski | Kentucky | 21199 | 876 | 11 |
606797 | 606797 | 2020-10-07 | Pulaski | Kentucky | 21199 | 867 | 11 |
603555 | 603555 | 2020-10-06 | Pulaski | Kentucky | 21199 | 858 | 11 |
600312 | 600312 | 2020-10-05 | Pulaski | Kentucky | 21199 | 849 | 11 |
597070 | 597070 | 2020-10-04 | Pulaski | Kentucky | 21199 | 840 | 11 |
593828 | 593828 | 2020-10-03 | Pulaski | Kentucky | 21199 | 836 | 11 |
590587 | 590587 | 2020-10-02 | Pulaski | Kentucky | 21199 | 833 | 11 |
587346 | 587346 | 2020-10-01 | Pulaski | Kentucky | 21199 | 830 | 11 |
584106 | 584106 | 2020-09-30 | Pulaski | Kentucky | 21199 | 827 | 10 |
580866 | 580866 | 2020-09-29 | Pulaski | Kentucky | 21199 | 819 | 10 |
577625 | 577625 | 2020-09-28 | Pulaski | Kentucky | 21199 | 810 | 10 |
574383 | 574383 | 2020-09-27 | Pulaski | Kentucky | 21199 | 806 | 10 |
571140 | 571140 | 2020-09-26 | Pulaski | Kentucky | 21199 | 797 | 10 |
567898 | 567898 | 2020-09-25 | Pulaski | Kentucky | 21199 | 795 | 10 |
564658 | 564658 | 2020-09-24 | Pulaski | Kentucky | 21199 | 789 | 10 |
561418 | 561418 | 2020-09-23 | Pulaski | Kentucky | 21199 | 778 | 10 |
558182 | 558182 | 2020-09-22 | Pulaski | Kentucky | 21199 | 770 | 10 |
554945 | 554945 | 2020-09-21 | Pulaski | Kentucky | 21199 | 759 | 10 |
551706 | 551706 | 2020-09-20 | Pulaski | Kentucky | 21199 | 752 | 10 |
548467 | 548467 | 2020-09-19 | Pulaski | Kentucky | 21199 | 745 | 10 |
545229 | 545229 | 2020-09-18 | Pulaski | Kentucky | 21199 | 736 | 10 |
541993 | 541993 | 2020-09-17 | Pulaski | Kentucky | 21199 | 724 | 10 |
538757 | 538757 | 2020-09-16 | Pulaski | Kentucky | 21199 | 715 | 9 |
535520 | 535520 | 2020-09-15 | Pulaski | Kentucky | 21199 | 710 | 9 |
532285 | 532285 | 2020-09-14 | Pulaski | Kentucky | 21199 | 703 | 9 |
529048 | 529048 | 2020-09-13 | Pulaski | Kentucky | 21199 | 697 | 9 |
525812 | 525812 | 2020-09-12 | Pulaski | Kentucky | 21199 | 693 | 8 |
522576 | 522576 | 2020-09-11 | Pulaski | Kentucky | 21199 | 684 | 8 |
519339 | 519339 | 2020-09-10 | Pulaski | Kentucky | 21199 | 674 | 8 |
516104 | 516104 | 2020-09-09 | Pulaski | Kentucky | 21199 | 652 | 8 |
512871 | 512871 | 2020-09-08 | Pulaski | Kentucky | 21199 | 645 | 7 |
509639 | 509639 | 2020-09-07 | Pulaski | Kentucky | 21199 | 639 | 7 |
506406 | 506406 | 2020-09-06 | Pulaski | Kentucky | 21199 | 638 | 7 |
503172 | 503172 | 2020-09-05 | Pulaski | Kentucky | 21199 | 634 | 7 |
499939 | 499939 | 2020-09-04 | Pulaski | Kentucky | 21199 | 626 | 7 |
496705 | 496705 | 2020-09-03 | Pulaski | Kentucky | 21199 | 602 | 7 |
493472 | 493472 | 2020-09-02 | Pulaski | Kentucky | 21199 | 592 | 7 |
490238 | 490238 | 2020-09-01 | Pulaski | Kentucky | 21199 | 564 | 7 |
487005 | 487005 | 2020-08-31 | Pulaski | Kentucky | 21199 | 557 | 7 |
483770 | 483770 | 2020-08-30 | Pulaski | Kentucky | 21199 | 552 | 7 |
480536 | 480536 | 2020-08-29 | Pulaski | Kentucky | 21199 | 530 | 7 |
477303 | 477303 | 2020-08-28 | Pulaski | Kentucky | 21199 | 523 | 7 |
474070 | 474070 | 2020-08-27 | Pulaski | Kentucky | 21199 | 515 | 6 |
470838 | 470838 | 2020-08-26 | Pulaski | Kentucky | 21199 | 499 | 6 |
467609 | 467609 | 2020-08-25 | Pulaski | Kentucky | 21199 | 487 | 6 |
464380 | 464380 | 2020-08-24 | Pulaski | Kentucky | 21199 | 475 | 6 |
461149 | 461149 | 2020-08-23 | Pulaski | Kentucky | 21199 | 468 | 6 |
457922 | 457922 | 2020-08-22 | Pulaski | Kentucky | 21199 | 463 | 6 |
454694 | 454694 | 2020-08-21 | Pulaski | Kentucky | 21199 | 439 | 6 |
451466 | 451466 | 2020-08-20 | Pulaski | Kentucky | 21199 | 427 | 6 |
448238 | 448238 | 2020-08-19 | Pulaski | Kentucky | 21199 | 416 | 6 |
445011 | 445011 | 2020-08-18 | Pulaski | Kentucky | 21199 | 409 | 5 |
441785 | 441785 | 2020-08-17 | Pulaski | Kentucky | 21199 | 396 | 5 |
438558 | 438558 | 2020-08-16 | Pulaski | Kentucky | 21199 | 391 | 5 |
435333 | 435333 | 2020-08-15 | Pulaski | Kentucky | 21199 | 387 | 5 |
432108 | 432108 | 2020-08-14 | Pulaski | Kentucky | 21199 | 383 | 5 |
428880 | 428880 | 2020-08-13 | Pulaski | Kentucky | 21199 | 379 | 5 |
425656 | 425656 | 2020-08-12 | Pulaski | Kentucky | 21199 | 368 | 5 |
422435 | 422435 | 2020-08-11 | Pulaski | Kentucky | 21199 | 362 | 5 |
419213 | 419213 | 2020-08-10 | Pulaski | Kentucky | 21199 | 359 | 5 |
415992 | 415992 | 2020-08-09 | Pulaski | Kentucky | 21199 | 350 | 5 |
412772 | 412772 | 2020-08-08 | Pulaski | Kentucky | 21199 | 347 | 5 |
409552 | 409552 | 2020-08-07 | Pulaski | Kentucky | 21199 | 343 | 4 |
406332 | 406332 | 2020-08-06 | Pulaski | Kentucky | 21199 | 335 | 3 |
403114 | 403114 | 2020-08-05 | Pulaski | Kentucky | 21199 | 328 | 2 |
399897 | 399897 | 2020-08-04 | Pulaski | Kentucky | 21199 | 319 | 2 |
396682 | 396682 | 2020-08-03 | Pulaski | Kentucky | 21199 | 311 | 2 |
393466 | 393466 | 2020-08-02 | Pulaski | Kentucky | 21199 | 298 | 2 |
390249 | 390249 | 2020-08-01 | Pulaski | Kentucky | 21199 | 290 | 2 |
387032 | 387032 | 2020-07-31 | Pulaski | Kentucky | 21199 | 280 | 2 |
383814 | 383814 | 2020-07-30 | Pulaski | Kentucky | 21199 | 265 | 2 |
380597 | 380597 | 2020-07-29 | Pulaski | Kentucky | 21199 | 257 | 2 |
377380 | 377380 | 2020-07-28 | Pulaski | Kentucky | 21199 | 248 | 2 |
374165 | 374165 | 2020-07-27 | Pulaski | Kentucky | 21199 | 240 | 2 |
370953 | 370953 | 2020-07-26 | Pulaski | Kentucky | 21199 | 225 | 2 |
367743 | 367743 | 2020-07-25 | Pulaski | Kentucky | 21199 | 220 | 2 |
364536 | 364536 | 2020-07-24 | Pulaski | Kentucky | 21199 | 212 | 2 |
361329 | 361329 | 2020-07-23 | Pulaski | Kentucky | 21199 | 205 | 2 |
358124 | 358124 | 2020-07-22 | Pulaski | Kentucky | 21199 | 200 | 2 |
354921 | 354921 | 2020-07-21 | Pulaski | Kentucky | 21199 | 192 | 2 |
351719 | 351719 | 2020-07-20 | Pulaski | Kentucky | 21199 | 182 | 2 |
348519 | 348519 | 2020-07-19 | Pulaski | Kentucky | 21199 | 179 | 2 |
345318 | 345318 | 2020-07-18 | Pulaski | Kentucky | 21199 | 168 | 2 |
342118 | 342118 | 2020-07-17 | Pulaski | Kentucky | 21199 | 164 | 2 |
338922 | 338922 | 2020-07-16 | Pulaski | Kentucky | 21199 | 155 | 2 |
335726 | 335726 | 2020-07-15 | Pulaski | Kentucky | 21199 | 150 | 2 |
332533 | 332533 | 2020-07-14 | Pulaski | Kentucky | 21199 | 149 | 2 |
329346 | 329346 | 2020-07-13 | Pulaski | Kentucky | 21199 | 146 | 2 |
326160 | 326160 | 2020-07-12 | Pulaski | Kentucky | 21199 | 137 | 2 |
322977 | 322977 | 2020-07-11 | Pulaski | Kentucky | 21199 | 135 | 2 |
319798 | 319798 | 2020-07-10 | Pulaski | Kentucky | 21199 | 131 | 2 |
316623 | 316623 | 2020-07-09 | Pulaski | Kentucky | 21199 | 126 | 2 |
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);