ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Warren" and fips = 21227 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
931287 | 931287 | 2021-01-15 | Warren | Kentucky | 21227 | 12066 | 90 |
928042 | 928042 | 2021-01-14 | Warren | Kentucky | 21227 | 11929 | 88 |
924796 | 924796 | 2021-01-13 | Warren | Kentucky | 21227 | 11800 | 88 |
921551 | 921551 | 2021-01-12 | Warren | Kentucky | 21227 | 11665 | 88 |
918306 | 918306 | 2021-01-11 | Warren | Kentucky | 21227 | 11599 | 88 |
915061 | 915061 | 2021-01-10 | Warren | Kentucky | 21227 | 11473 | 88 |
911816 | 911816 | 2021-01-09 | Warren | Kentucky | 21227 | 11375 | 88 |
908571 | 908571 | 2021-01-08 | Warren | Kentucky | 21227 | 11283 | 88 |
905325 | 905325 | 2021-01-07 | Warren | Kentucky | 21227 | 11122 | 88 |
902080 | 902080 | 2021-01-06 | Warren | Kentucky | 21227 | 10949 | 88 |
898835 | 898835 | 2021-01-05 | Warren | Kentucky | 21227 | 10690 | 87 |
895590 | 895590 | 2021-01-04 | Warren | Kentucky | 21227 | 10530 | 87 |
892343 | 892343 | 2021-01-03 | Warren | Kentucky | 21227 | 10409 | 84 |
889097 | 889097 | 2021-01-02 | Warren | Kentucky | 21227 | 10294 | 84 |
885851 | 885851 | 2021-01-01 | Warren | Kentucky | 21227 | 10194 | 84 |
882606 | 882606 | 2020-12-31 | Warren | Kentucky | 21227 | 10194 | 84 |
879361 | 879361 | 2020-12-30 | Warren | Kentucky | 21227 | 10194 | 84 |
876116 | 876116 | 2020-12-29 | Warren | Kentucky | 21227 | 10049 | 84 |
872871 | 872871 | 2020-12-28 | Warren | Kentucky | 21227 | 9804 | 84 |
869626 | 869626 | 2020-12-27 | Warren | Kentucky | 21227 | 9750 | 84 |
866381 | 866381 | 2020-12-26 | Warren | Kentucky | 21227 | 9716 | 84 |
863136 | 863136 | 2020-12-25 | Warren | Kentucky | 21227 | 9583 | 83 |
859891 | 859891 | 2020-12-24 | Warren | Kentucky | 21227 | 9583 | 83 |
856646 | 856646 | 2020-12-23 | Warren | Kentucky | 21227 | 9583 | 83 |
853401 | 853401 | 2020-12-22 | Warren | Kentucky | 21227 | 9480 | 83 |
850156 | 850156 | 2020-12-21 | Warren | Kentucky | 21227 | 9379 | 83 |
846911 | 846911 | 2020-12-20 | Warren | Kentucky | 21227 | 9218 | 83 |
843665 | 843665 | 2020-12-19 | Warren | Kentucky | 21227 | 9105 | 83 |
840420 | 840420 | 2020-12-18 | Warren | Kentucky | 21227 | 9054 | 83 |
837175 | 837175 | 2020-12-17 | Warren | Kentucky | 21227 | 8958 | 83 |
833929 | 833929 | 2020-12-16 | Warren | Kentucky | 21227 | 8891 | 83 |
830682 | 830682 | 2020-12-15 | Warren | Kentucky | 21227 | 8740 | 83 |
827436 | 827436 | 2020-12-14 | Warren | Kentucky | 21227 | 8653 | 83 |
824189 | 824189 | 2020-12-13 | Warren | Kentucky | 21227 | 8562 | 83 |
820943 | 820943 | 2020-12-12 | Warren | Kentucky | 21227 | 8520 | 83 |
817697 | 817697 | 2020-12-11 | Warren | Kentucky | 21227 | 8440 | 81 |
814451 | 814451 | 2020-12-10 | Warren | Kentucky | 21227 | 8339 | 81 |
811206 | 811206 | 2020-12-09 | Warren | Kentucky | 21227 | 8231 | 81 |
807961 | 807961 | 2020-12-08 | Warren | Kentucky | 21227 | 8174 | 81 |
804716 | 804716 | 2020-12-07 | Warren | Kentucky | 21227 | 8070 | 81 |
801471 | 801471 | 2020-12-06 | Warren | Kentucky | 21227 | 7915 | 81 |
798226 | 798226 | 2020-12-05 | Warren | Kentucky | 21227 | 7842 | 81 |
794981 | 794981 | 2020-12-04 | Warren | Kentucky | 21227 | 7816 | 78 |
791736 | 791736 | 2020-12-03 | Warren | Kentucky | 21227 | 7733 | 78 |
788491 | 788491 | 2020-12-02 | Warren | Kentucky | 21227 | 7648 | 73 |
785247 | 785247 | 2020-12-01 | Warren | Kentucky | 21227 | 7531 | 73 |
782002 | 782002 | 2020-11-30 | Warren | Kentucky | 21227 | 7360 | 73 |
778756 | 778756 | 2020-11-29 | Warren | Kentucky | 21227 | 7211 | 73 |
775511 | 775511 | 2020-11-28 | Warren | Kentucky | 21227 | 7176 | 69 |
772266 | 772266 | 2020-11-27 | Warren | Kentucky | 21227 | 7094 | 65 |
769021 | 769021 | 2020-11-26 | Warren | Kentucky | 21227 | 6984 | 64 |
765775 | 765775 | 2020-11-25 | Warren | Kentucky | 21227 | 6984 | 64 |
762530 | 762530 | 2020-11-24 | Warren | Kentucky | 21227 | 6837 | 62 |
759285 | 759285 | 2020-11-23 | Warren | Kentucky | 21227 | 6837 | 62 |
756038 | 756038 | 2020-11-22 | Warren | Kentucky | 21227 | 6703 | 61 |
752792 | 752792 | 2020-11-21 | Warren | Kentucky | 21227 | 6680 | 61 |
749546 | 749546 | 2020-11-20 | Warren | Kentucky | 21227 | 6680 | 61 |
746300 | 746300 | 2020-11-19 | Warren | Kentucky | 21227 | 6577 | 61 |
743053 | 743053 | 2020-11-18 | Warren | Kentucky | 21227 | 6510 | 61 |
739806 | 739806 | 2020-11-17 | Warren | Kentucky | 21227 | 6396 | 61 |
736562 | 736562 | 2020-11-16 | Warren | Kentucky | 21227 | 6329 | 61 |
733316 | 733316 | 2020-11-15 | Warren | Kentucky | 21227 | 6214 | 61 |
730071 | 730071 | 2020-11-14 | Warren | Kentucky | 21227 | 6190 | 61 |
726828 | 726828 | 2020-11-13 | Warren | Kentucky | 21227 | 6187 | 61 |
723585 | 723585 | 2020-11-12 | Warren | Kentucky | 21227 | 6152 | 59 |
720342 | 720342 | 2020-11-11 | Warren | Kentucky | 21227 | 6088 | 59 |
717099 | 717099 | 2020-11-10 | Warren | Kentucky | 21227 | 6030 | 59 |
713855 | 713855 | 2020-11-09 | Warren | Kentucky | 21227 | 5992 | 59 |
710611 | 710611 | 2020-11-08 | Warren | Kentucky | 21227 | 5853 | 59 |
707367 | 707367 | 2020-11-07 | Warren | Kentucky | 21227 | 5839 | 59 |
704124 | 704124 | 2020-11-06 | Warren | Kentucky | 21227 | 5760 | 58 |
700882 | 700882 | 2020-11-05 | Warren | Kentucky | 21227 | 5760 | 58 |
697638 | 697638 | 2020-11-04 | Warren | Kentucky | 21227 | 5681 | 58 |
694395 | 694395 | 2020-11-03 | Warren | Kentucky | 21227 | 5551 | 58 |
691153 | 691153 | 2020-11-02 | Warren | Kentucky | 21227 | 5489 | 58 |
687908 | 687908 | 2020-11-01 | Warren | Kentucky | 21227 | 5456 | 58 |
684664 | 684664 | 2020-10-31 | Warren | Kentucky | 21227 | 5432 | 58 |
681421 | 681421 | 2020-10-30 | Warren | Kentucky | 21227 | 5432 | 58 |
678177 | 678177 | 2020-10-29 | Warren | Kentucky | 21227 | 5359 | 58 |
674935 | 674935 | 2020-10-28 | Warren | Kentucky | 21227 | 5301 | 57 |
671692 | 671692 | 2020-10-27 | Warren | Kentucky | 21227 | 5260 | 57 |
668450 | 668450 | 2020-10-26 | Warren | Kentucky | 21227 | 5208 | 57 |
665206 | 665206 | 2020-10-25 | Warren | Kentucky | 21227 | 5125 | 57 |
661961 | 661961 | 2020-10-24 | Warren | Kentucky | 21227 | 5092 | 57 |
658717 | 658717 | 2020-10-23 | Warren | Kentucky | 21227 | 5092 | 57 |
655472 | 655472 | 2020-10-22 | Warren | Kentucky | 21227 | 5054 | 57 |
652227 | 652227 | 2020-10-21 | Warren | Kentucky | 21227 | 4976 | 57 |
648982 | 648982 | 2020-10-20 | Warren | Kentucky | 21227 | 4976 | 57 |
645738 | 645738 | 2020-10-19 | Warren | Kentucky | 21227 | 4944 | 57 |
642491 | 642491 | 2020-10-18 | Warren | Kentucky | 21227 | 4897 | 57 |
639244 | 639244 | 2020-10-17 | Warren | Kentucky | 21227 | 4894 | 57 |
635998 | 635998 | 2020-10-16 | Warren | Kentucky | 21227 | 4894 | 57 |
632752 | 632752 | 2020-10-15 | Warren | Kentucky | 21227 | 4841 | 57 |
629508 | 629508 | 2020-10-14 | Warren | Kentucky | 21227 | 4804 | 57 |
626264 | 626264 | 2020-10-13 | Warren | Kentucky | 21227 | 4754 | 57 |
623022 | 623022 | 2020-10-12 | Warren | Kentucky | 21227 | 4718 | 57 |
619778 | 619778 | 2020-10-11 | Warren | Kentucky | 21227 | 4664 | 57 |
616536 | 616536 | 2020-10-10 | Warren | Kentucky | 21227 | 4635 | 56 |
613295 | 613295 | 2020-10-09 | Warren | Kentucky | 21227 | 4635 | 56 |
610053 | 610053 | 2020-10-08 | Warren | Kentucky | 21227 | 4608 | 56 |
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);