ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where county = "Clay" and fips = 21051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921463 | 921463 | 2021-01-12 | Clay | Kentucky | 21051 | 1986 | 10 |
918218 | 918218 | 2021-01-11 | Clay | Kentucky | 21051 | 1964 | 10 |
914973 | 914973 | 2021-01-10 | Clay | Kentucky | 21051 | 1954 | 10 |
911728 | 911728 | 2021-01-09 | Clay | Kentucky | 21051 | 1951 | 9 |
908483 | 908483 | 2021-01-08 | Clay | Kentucky | 21051 | 1808 | 9 |
905237 | 905237 | 2021-01-07 | Clay | Kentucky | 21051 | 1779 | 9 |
901992 | 901992 | 2021-01-06 | Clay | Kentucky | 21051 | 1755 | 9 |
898747 | 898747 | 2021-01-05 | Clay | Kentucky | 21051 | 1723 | 8 |
895502 | 895502 | 2021-01-04 | Clay | Kentucky | 21051 | 1707 | 8 |
892255 | 892255 | 2021-01-03 | Clay | Kentucky | 21051 | 1701 | 8 |
889009 | 889009 | 2021-01-02 | Clay | Kentucky | 21051 | 1692 | 8 |
885763 | 885763 | 2021-01-01 | Clay | Kentucky | 21051 | 1623 | 8 |
882518 | 882518 | 2020-12-31 | Clay | Kentucky | 21051 | 1623 | 8 |
879273 | 879273 | 2020-12-30 | Clay | Kentucky | 21051 | 1623 | 8 |
876028 | 876028 | 2020-12-29 | Clay | Kentucky | 21051 | 1564 | 8 |
872783 | 872783 | 2020-12-28 | Clay | Kentucky | 21051 | 1530 | 8 |
869538 | 869538 | 2020-12-27 | Clay | Kentucky | 21051 | 1528 | 8 |
866293 | 866293 | 2020-12-26 | Clay | Kentucky | 21051 | 1524 | 8 |
863048 | 863048 | 2020-12-25 | Clay | Kentucky | 21051 | 1466 | 8 |
859803 | 859803 | 2020-12-24 | Clay | Kentucky | 21051 | 1466 | 8 |
856558 | 856558 | 2020-12-23 | Clay | Kentucky | 21051 | 1466 | 8 |
853313 | 853313 | 2020-12-22 | Clay | Kentucky | 21051 | 1431 | 8 |
850068 | 850068 | 2020-12-21 | Clay | Kentucky | 21051 | 1378 | 8 |
846823 | 846823 | 2020-12-20 | Clay | Kentucky | 21051 | 1347 | 8 |
843577 | 843577 | 2020-12-19 | Clay | Kentucky | 21051 | 1341 | 8 |
840332 | 840332 | 2020-12-18 | Clay | Kentucky | 21051 | 1325 | 8 |
837087 | 837087 | 2020-12-17 | Clay | Kentucky | 21051 | 1294 | 8 |
833841 | 833841 | 2020-12-16 | Clay | Kentucky | 21051 | 1288 | 8 |
830594 | 830594 | 2020-12-15 | Clay | Kentucky | 21051 | 1262 | 8 |
827348 | 827348 | 2020-12-14 | Clay | Kentucky | 21051 | 1239 | 8 |
824101 | 824101 | 2020-12-13 | Clay | Kentucky | 21051 | 1231 | 8 |
820855 | 820855 | 2020-12-12 | Clay | Kentucky | 21051 | 1229 | 8 |
817609 | 817609 | 2020-12-11 | Clay | Kentucky | 21051 | 1219 | 8 |
814363 | 814363 | 2020-12-10 | Clay | Kentucky | 21051 | 1210 | 8 |
811118 | 811118 | 2020-12-09 | Clay | Kentucky | 21051 | 1194 | 8 |
807873 | 807873 | 2020-12-08 | Clay | Kentucky | 21051 | 1172 | 8 |
804628 | 804628 | 2020-12-07 | Clay | Kentucky | 21051 | 1159 | 8 |
801383 | 801383 | 2020-12-06 | Clay | Kentucky | 21051 | 1155 | 8 |
798138 | 798138 | 2020-12-05 | Clay | Kentucky | 21051 | 1152 | 8 |
794893 | 794893 | 2020-12-04 | Clay | Kentucky | 21051 | 1143 | 8 |
791648 | 791648 | 2020-12-03 | Clay | Kentucky | 21051 | 1122 | 8 |
788403 | 788403 | 2020-12-02 | Clay | Kentucky | 21051 | 1095 | 8 |
785159 | 785159 | 2020-12-01 | Clay | Kentucky | 21051 | 1039 | 8 |
781914 | 781914 | 2020-11-30 | Clay | Kentucky | 21051 | 989 | 8 |
778668 | 778668 | 2020-11-29 | Clay | Kentucky | 21051 | 989 | 8 |
775423 | 775423 | 2020-11-28 | Clay | Kentucky | 21051 | 975 | 8 |
772178 | 772178 | 2020-11-27 | Clay | Kentucky | 21051 | 972 | 8 |
768933 | 768933 | 2020-11-26 | Clay | Kentucky | 21051 | 961 | 8 |
765687 | 765687 | 2020-11-25 | Clay | Kentucky | 21051 | 961 | 8 |
762442 | 762442 | 2020-11-24 | Clay | Kentucky | 21051 | 949 | 8 |
759197 | 759197 | 2020-11-23 | Clay | Kentucky | 21051 | 936 | 8 |
755950 | 755950 | 2020-11-22 | Clay | Kentucky | 21051 | 935 | 8 |
752704 | 752704 | 2020-11-21 | Clay | Kentucky | 21051 | 920 | 8 |
749458 | 749458 | 2020-11-20 | Clay | Kentucky | 21051 | 906 | 8 |
746212 | 746212 | 2020-11-19 | Clay | Kentucky | 21051 | 862 | 8 |
742965 | 742965 | 2020-11-18 | Clay | Kentucky | 21051 | 825 | 8 |
739718 | 739718 | 2020-11-17 | Clay | Kentucky | 21051 | 811 | 7 |
736474 | 736474 | 2020-11-16 | Clay | Kentucky | 21051 | 801 | 7 |
733228 | 733228 | 2020-11-15 | Clay | Kentucky | 21051 | 796 | 7 |
729983 | 729983 | 2020-11-14 | Clay | Kentucky | 21051 | 795 | 7 |
726740 | 726740 | 2020-11-13 | Clay | Kentucky | 21051 | 780 | 7 |
723497 | 723497 | 2020-11-12 | Clay | Kentucky | 21051 | 757 | 7 |
720254 | 720254 | 2020-11-11 | Clay | Kentucky | 21051 | 755 | 6 |
717011 | 717011 | 2020-11-10 | Clay | Kentucky | 21051 | 730 | 6 |
713767 | 713767 | 2020-11-09 | Clay | Kentucky | 21051 | 709 | 6 |
710523 | 710523 | 2020-11-08 | Clay | Kentucky | 21051 | 704 | 6 |
707279 | 707279 | 2020-11-07 | Clay | Kentucky | 21051 | 702 | 6 |
704036 | 704036 | 2020-11-06 | Clay | Kentucky | 21051 | 690 | 6 |
700794 | 700794 | 2020-11-05 | Clay | Kentucky | 21051 | 667 | 6 |
697550 | 697550 | 2020-11-04 | Clay | Kentucky | 21051 | 651 | 6 |
694307 | 694307 | 2020-11-03 | Clay | Kentucky | 21051 | 649 | 6 |
691065 | 691065 | 2020-11-02 | Clay | Kentucky | 21051 | 642 | 6 |
687820 | 687820 | 2020-11-01 | Clay | Kentucky | 21051 | 637 | 6 |
684576 | 684576 | 2020-10-31 | Clay | Kentucky | 21051 | 628 | 6 |
681333 | 681333 | 2020-10-30 | Clay | Kentucky | 21051 | 602 | 6 |
678089 | 678089 | 2020-10-29 | Clay | Kentucky | 21051 | 588 | 6 |
674847 | 674847 | 2020-10-28 | Clay | Kentucky | 21051 | 550 | 6 |
671604 | 671604 | 2020-10-27 | Clay | Kentucky | 21051 | 530 | 6 |
668362 | 668362 | 2020-10-26 | Clay | Kentucky | 21051 | 506 | 6 |
665118 | 665118 | 2020-10-25 | Clay | Kentucky | 21051 | 498 | 6 |
661873 | 661873 | 2020-10-24 | Clay | Kentucky | 21051 | 492 | 6 |
658629 | 658629 | 2020-10-23 | Clay | Kentucky | 21051 | 482 | 6 |
655384 | 655384 | 2020-10-22 | Clay | Kentucky | 21051 | 462 | 6 |
652139 | 652139 | 2020-10-21 | Clay | Kentucky | 21051 | 451 | 6 |
648894 | 648894 | 2020-10-20 | Clay | Kentucky | 21051 | 444 | 6 |
645650 | 645650 | 2020-10-19 | Clay | Kentucky | 21051 | 434 | 6 |
642403 | 642403 | 2020-10-18 | Clay | Kentucky | 21051 | 430 | 6 |
639156 | 639156 | 2020-10-17 | Clay | Kentucky | 21051 | 423 | 6 |
635910 | 635910 | 2020-10-16 | Clay | Kentucky | 21051 | 418 | 6 |
632664 | 632664 | 2020-10-15 | Clay | Kentucky | 21051 | 408 | 6 |
629420 | 629420 | 2020-10-14 | Clay | Kentucky | 21051 | 389 | 6 |
626176 | 626176 | 2020-10-13 | Clay | Kentucky | 21051 | 382 | 6 |
622934 | 622934 | 2020-10-12 | Clay | Kentucky | 21051 | 371 | 6 |
619690 | 619690 | 2020-10-11 | Clay | Kentucky | 21051 | 366 | 6 |
616448 | 616448 | 2020-10-10 | Clay | Kentucky | 21051 | 362 | 6 |
613207 | 613207 | 2020-10-09 | Clay | Kentucky | 21051 | 361 | 6 |
609965 | 609965 | 2020-10-08 | Clay | Kentucky | 21051 | 355 | 6 |
606723 | 606723 | 2020-10-07 | Clay | Kentucky | 21051 | 352 | 6 |
603481 | 603481 | 2020-10-06 | Clay | Kentucky | 21051 | 352 | 6 |
600238 | 600238 | 2020-10-05 | Clay | Kentucky | 21051 | 347 | 6 |
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);