ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clark" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921462 | 921462 | 2021-01-12 | Clark | Kentucky | 21049 | 1723 | 16 |
918217 | 918217 | 2021-01-11 | Clark | Kentucky | 21049 | 1701 | 16 |
914972 | 914972 | 2021-01-10 | Clark | Kentucky | 21049 | 1693 | 15 |
911727 | 911727 | 2021-01-09 | Clark | Kentucky | 21049 | 1682 | 15 |
908482 | 908482 | 2021-01-08 | Clark | Kentucky | 21049 | 1632 | 15 |
905236 | 905236 | 2021-01-07 | Clark | Kentucky | 21049 | 1607 | 15 |
901991 | 901991 | 2021-01-06 | Clark | Kentucky | 21049 | 1562 | 15 |
898746 | 898746 | 2021-01-05 | Clark | Kentucky | 21049 | 1505 | 15 |
895501 | 895501 | 2021-01-04 | Clark | Kentucky | 21049 | 1497 | 15 |
892254 | 892254 | 2021-01-03 | Clark | Kentucky | 21049 | 1487 | 15 |
889008 | 889008 | 2021-01-02 | Clark | Kentucky | 21049 | 1469 | 15 |
885762 | 885762 | 2021-01-01 | Clark | Kentucky | 21049 | 1452 | 15 |
882517 | 882517 | 2020-12-31 | Clark | Kentucky | 21049 | 1452 | 15 |
879272 | 879272 | 2020-12-30 | Clark | Kentucky | 21049 | 1452 | 15 |
876027 | 876027 | 2020-12-29 | Clark | Kentucky | 21049 | 1427 | 15 |
872782 | 872782 | 2020-12-28 | Clark | Kentucky | 21049 | 1425 | 15 |
869537 | 869537 | 2020-12-27 | Clark | Kentucky | 21049 | 1413 | 15 |
866292 | 866292 | 2020-12-26 | Clark | Kentucky | 21049 | 1403 | 15 |
863047 | 863047 | 2020-12-25 | Clark | Kentucky | 21049 | 1379 | 15 |
859802 | 859802 | 2020-12-24 | Clark | Kentucky | 21049 | 1379 | 15 |
856557 | 856557 | 2020-12-23 | Clark | Kentucky | 21049 | 1379 | 15 |
853312 | 853312 | 2020-12-22 | Clark | Kentucky | 21049 | 1359 | 15 |
850067 | 850067 | 2020-12-21 | Clark | Kentucky | 21049 | 1334 | 15 |
846822 | 846822 | 2020-12-20 | Clark | Kentucky | 21049 | 1328 | 14 |
843576 | 843576 | 2020-12-19 | Clark | Kentucky | 21049 | 1326 | 14 |
840331 | 840331 | 2020-12-18 | Clark | Kentucky | 21049 | 1296 | 14 |
837086 | 837086 | 2020-12-17 | Clark | Kentucky | 21049 | 1266 | 13 |
833840 | 833840 | 2020-12-16 | Clark | Kentucky | 21049 | 1252 | 13 |
830593 | 830593 | 2020-12-15 | Clark | Kentucky | 21049 | 1232 | 13 |
827347 | 827347 | 2020-12-14 | Clark | Kentucky | 21049 | 1214 | 13 |
824100 | 824100 | 2020-12-13 | Clark | Kentucky | 21049 | 1205 | 13 |
820854 | 820854 | 2020-12-12 | Clark | Kentucky | 21049 | 1203 | 13 |
817608 | 817608 | 2020-12-11 | Clark | Kentucky | 21049 | 1191 | 13 |
814362 | 814362 | 2020-12-10 | Clark | Kentucky | 21049 | 1161 | 13 |
811117 | 811117 | 2020-12-09 | Clark | Kentucky | 21049 | 1144 | 13 |
807872 | 807872 | 2020-12-08 | Clark | Kentucky | 21049 | 1125 | 12 |
804627 | 804627 | 2020-12-07 | Clark | Kentucky | 21049 | 1088 | 12 |
801382 | 801382 | 2020-12-06 | Clark | Kentucky | 21049 | 1079 | 12 |
798137 | 798137 | 2020-12-05 | Clark | Kentucky | 21049 | 1071 | 12 |
794892 | 794892 | 2020-12-04 | Clark | Kentucky | 21049 | 1049 | 12 |
791647 | 791647 | 2020-12-03 | Clark | Kentucky | 21049 | 1012 | 12 |
788402 | 788402 | 2020-12-02 | Clark | Kentucky | 21049 | 973 | 12 |
785158 | 785158 | 2020-12-01 | Clark | Kentucky | 21049 | 949 | 12 |
781913 | 781913 | 2020-11-30 | Clark | Kentucky | 21049 | 922 | 12 |
778667 | 778667 | 2020-11-29 | Clark | Kentucky | 21049 | 914 | 12 |
775422 | 775422 | 2020-11-28 | Clark | Kentucky | 21049 | 905 | 12 |
772177 | 772177 | 2020-11-27 | Clark | Kentucky | 21049 | 901 | 12 |
768932 | 768932 | 2020-11-26 | Clark | Kentucky | 21049 | 866 | 12 |
765686 | 765686 | 2020-11-25 | Clark | Kentucky | 21049 | 866 | 12 |
762441 | 762441 | 2020-11-24 | Clark | Kentucky | 21049 | 833 | 12 |
759196 | 759196 | 2020-11-23 | Clark | Kentucky | 21049 | 811 | 12 |
755949 | 755949 | 2020-11-22 | Clark | Kentucky | 21049 | 805 | 12 |
752703 | 752703 | 2020-11-21 | Clark | Kentucky | 21049 | 801 | 12 |
749457 | 749457 | 2020-11-20 | Clark | Kentucky | 21049 | 763 | 12 |
746211 | 746211 | 2020-11-19 | Clark | Kentucky | 21049 | 728 | 12 |
742964 | 742964 | 2020-11-18 | Clark | Kentucky | 21049 | 711 | 12 |
739717 | 739717 | 2020-11-17 | Clark | Kentucky | 21049 | 705 | 12 |
736473 | 736473 | 2020-11-16 | Clark | Kentucky | 21049 | 695 | 12 |
733227 | 733227 | 2020-11-15 | Clark | Kentucky | 21049 | 694 | 12 |
729982 | 729982 | 2020-11-14 | Clark | Kentucky | 21049 | 690 | 12 |
726739 | 726739 | 2020-11-13 | Clark | Kentucky | 21049 | 668 | 12 |
723496 | 723496 | 2020-11-12 | Clark | Kentucky | 21049 | 663 | 12 |
720253 | 720253 | 2020-11-11 | Clark | Kentucky | 21049 | 655 | 12 |
717010 | 717010 | 2020-11-10 | Clark | Kentucky | 21049 | 647 | 12 |
713766 | 713766 | 2020-11-09 | Clark | Kentucky | 21049 | 642 | 12 |
710522 | 710522 | 2020-11-08 | Clark | Kentucky | 21049 | 624 | 12 |
707278 | 707278 | 2020-11-07 | Clark | Kentucky | 21049 | 625 | 12 |
704035 | 704035 | 2020-11-06 | Clark | Kentucky | 21049 | 607 | 12 |
700793 | 700793 | 2020-11-05 | Clark | Kentucky | 21049 | 589 | 12 |
697549 | 697549 | 2020-11-04 | Clark | Kentucky | 21049 | 583 | 12 |
694306 | 694306 | 2020-11-03 | Clark | Kentucky | 21049 | 580 | 12 |
691064 | 691064 | 2020-11-02 | Clark | Kentucky | 21049 | 571 | 12 |
687819 | 687819 | 2020-11-01 | Clark | Kentucky | 21049 | 565 | 12 |
684575 | 684575 | 2020-10-31 | Clark | Kentucky | 21049 | 562 | 12 |
681332 | 681332 | 2020-10-30 | Clark | Kentucky | 21049 | 550 | 12 |
678088 | 678088 | 2020-10-29 | Clark | Kentucky | 21049 | 543 | 11 |
674846 | 674846 | 2020-10-28 | Clark | Kentucky | 21049 | 534 | 11 |
671603 | 671603 | 2020-10-27 | Clark | Kentucky | 21049 | 531 | 11 |
668361 | 668361 | 2020-10-26 | Clark | Kentucky | 21049 | 519 | 11 |
665117 | 665117 | 2020-10-25 | Clark | Kentucky | 21049 | 517 | 11 |
661872 | 661872 | 2020-10-24 | Clark | Kentucky | 21049 | 509 | 11 |
658628 | 658628 | 2020-10-23 | Clark | Kentucky | 21049 | 475 | 11 |
655383 | 655383 | 2020-10-22 | Clark | Kentucky | 21049 | 460 | 11 |
652138 | 652138 | 2020-10-21 | Clark | Kentucky | 21049 | 455 | 11 |
648893 | 648893 | 2020-10-20 | Clark | Kentucky | 21049 | 452 | 10 |
645649 | 645649 | 2020-10-19 | Clark | Kentucky | 21049 | 445 | 10 |
642402 | 642402 | 2020-10-18 | Clark | Kentucky | 21049 | 441 | 10 |
639155 | 639155 | 2020-10-17 | Clark | Kentucky | 21049 | 437 | 10 |
635909 | 635909 | 2020-10-16 | Clark | Kentucky | 21049 | 429 | 10 |
632663 | 632663 | 2020-10-15 | Clark | Kentucky | 21049 | 408 | 10 |
629419 | 629419 | 2020-10-14 | Clark | Kentucky | 21049 | 409 | 10 |
626175 | 626175 | 2020-10-13 | Clark | Kentucky | 21049 | 407 | 10 |
622933 | 622933 | 2020-10-12 | Clark | Kentucky | 21049 | 400 | 10 |
619689 | 619689 | 2020-10-11 | Clark | Kentucky | 21049 | 397 | 10 |
616447 | 616447 | 2020-10-10 | Clark | Kentucky | 21049 | 396 | 10 |
613206 | 613206 | 2020-10-09 | Clark | Kentucky | 21049 | 388 | 10 |
609964 | 609964 | 2020-10-08 | Clark | Kentucky | 21049 | 378 | 10 |
606722 | 606722 | 2020-10-07 | Clark | Kentucky | 21049 | 376 | 10 |
603480 | 603480 | 2020-10-06 | Clark | Kentucky | 21049 | 370 | 10 |
600237 | 600237 | 2020-10-05 | Clark | Kentucky | 21049 | 361 | 10 |
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);