ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Monroe" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921523 | 921523 | 2021-01-12 | Monroe | Kentucky | 21171 | 1060 | 28 |
918278 | 918278 | 2021-01-11 | Monroe | Kentucky | 21171 | 1050 | 28 |
915033 | 915033 | 2021-01-10 | Monroe | Kentucky | 21171 | 1047 | 28 |
911788 | 911788 | 2021-01-09 | Monroe | Kentucky | 21171 | 1046 | 28 |
908543 | 908543 | 2021-01-08 | Monroe | Kentucky | 21171 | 1034 | 28 |
905297 | 905297 | 2021-01-07 | Monroe | Kentucky | 21171 | 1022 | 28 |
902052 | 902052 | 2021-01-06 | Monroe | Kentucky | 21171 | 1011 | 28 |
898807 | 898807 | 2021-01-05 | Monroe | Kentucky | 21171 | 991 | 26 |
895562 | 895562 | 2021-01-04 | Monroe | Kentucky | 21171 | 978 | 26 |
892315 | 892315 | 2021-01-03 | Monroe | Kentucky | 21171 | 971 | 26 |
889069 | 889069 | 2021-01-02 | Monroe | Kentucky | 21171 | 969 | 26 |
885823 | 885823 | 2021-01-01 | Monroe | Kentucky | 21171 | 945 | 26 |
882578 | 882578 | 2020-12-31 | Monroe | Kentucky | 21171 | 945 | 26 |
879333 | 879333 | 2020-12-30 | Monroe | Kentucky | 21171 | 945 | 26 |
876088 | 876088 | 2020-12-29 | Monroe | Kentucky | 21171 | 930 | 25 |
872843 | 872843 | 2020-12-28 | Monroe | Kentucky | 21171 | 916 | 25 |
869598 | 869598 | 2020-12-27 | Monroe | Kentucky | 21171 | 916 | 25 |
866353 | 866353 | 2020-12-26 | Monroe | Kentucky | 21171 | 914 | 25 |
863108 | 863108 | 2020-12-25 | Monroe | Kentucky | 21171 | 907 | 21 |
859863 | 859863 | 2020-12-24 | Monroe | Kentucky | 21171 | 907 | 21 |
856618 | 856618 | 2020-12-23 | Monroe | Kentucky | 21171 | 907 | 21 |
853373 | 853373 | 2020-12-22 | Monroe | Kentucky | 21171 | 899 | 21 |
850128 | 850128 | 2020-12-21 | Monroe | Kentucky | 21171 | 881 | 19 |
846883 | 846883 | 2020-12-20 | Monroe | Kentucky | 21171 | 880 | 19 |
843637 | 843637 | 2020-12-19 | Monroe | Kentucky | 21171 | 879 | 19 |
840392 | 840392 | 2020-12-18 | Monroe | Kentucky | 21171 | 868 | 19 |
837147 | 837147 | 2020-12-17 | Monroe | Kentucky | 21171 | 865 | 19 |
833901 | 833901 | 2020-12-16 | Monroe | Kentucky | 21171 | 852 | 18 |
830654 | 830654 | 2020-12-15 | Monroe | Kentucky | 21171 | 850 | 18 |
827408 | 827408 | 2020-12-14 | Monroe | Kentucky | 21171 | 840 | 18 |
824161 | 824161 | 2020-12-13 | Monroe | Kentucky | 21171 | 837 | 18 |
820915 | 820915 | 2020-12-12 | Monroe | Kentucky | 21171 | 826 | 18 |
817669 | 817669 | 2020-12-11 | Monroe | Kentucky | 21171 | 816 | 18 |
814423 | 814423 | 2020-12-10 | Monroe | Kentucky | 21171 | 811 | 18 |
811178 | 811178 | 2020-12-09 | Monroe | Kentucky | 21171 | 799 | 18 |
807933 | 807933 | 2020-12-08 | Monroe | Kentucky | 21171 | 785 | 18 |
804688 | 804688 | 2020-12-07 | Monroe | Kentucky | 21171 | 765 | 18 |
801443 | 801443 | 2020-12-06 | Monroe | Kentucky | 21171 | 766 | 18 |
798198 | 798198 | 2020-12-05 | Monroe | Kentucky | 21171 | 760 | 18 |
794953 | 794953 | 2020-12-04 | Monroe | Kentucky | 21171 | 751 | 18 |
791708 | 791708 | 2020-12-03 | Monroe | Kentucky | 21171 | 743 | 17 |
788463 | 788463 | 2020-12-02 | Monroe | Kentucky | 21171 | 734 | 16 |
785219 | 785219 | 2020-12-01 | Monroe | Kentucky | 21171 | 723 | 16 |
781974 | 781974 | 2020-11-30 | Monroe | Kentucky | 21171 | 706 | 14 |
778728 | 778728 | 2020-11-29 | Monroe | Kentucky | 21171 | 704 | 14 |
775483 | 775483 | 2020-11-28 | Monroe | Kentucky | 21171 | 696 | 14 |
772238 | 772238 | 2020-11-27 | Monroe | Kentucky | 21171 | 691 | 13 |
768993 | 768993 | 2020-11-26 | Monroe | Kentucky | 21171 | 677 | 11 |
765747 | 765747 | 2020-11-25 | Monroe | Kentucky | 21171 | 677 | 11 |
762502 | 762502 | 2020-11-24 | Monroe | Kentucky | 21171 | 676 | 9 |
759257 | 759257 | 2020-11-23 | Monroe | Kentucky | 21171 | 664 | 9 |
756010 | 756010 | 2020-11-22 | Monroe | Kentucky | 21171 | 662 | 9 |
752764 | 752764 | 2020-11-21 | Monroe | Kentucky | 21171 | 655 | 9 |
749518 | 749518 | 2020-11-20 | Monroe | Kentucky | 21171 | 644 | 8 |
746272 | 746272 | 2020-11-19 | Monroe | Kentucky | 21171 | 635 | 8 |
743025 | 743025 | 2020-11-18 | Monroe | Kentucky | 21171 | 625 | 6 |
739778 | 739778 | 2020-11-17 | Monroe | Kentucky | 21171 | 610 | 6 |
736534 | 736534 | 2020-11-16 | Monroe | Kentucky | 21171 | 593 | 5 |
733288 | 733288 | 2020-11-15 | Monroe | Kentucky | 21171 | 588 | 5 |
730043 | 730043 | 2020-11-14 | Monroe | Kentucky | 21171 | 584 | 5 |
726800 | 726800 | 2020-11-13 | Monroe | Kentucky | 21171 | 568 | 5 |
723557 | 723557 | 2020-11-12 | Monroe | Kentucky | 21171 | 548 | 5 |
720314 | 720314 | 2020-11-11 | Monroe | Kentucky | 21171 | 520 | 5 |
717071 | 717071 | 2020-11-10 | Monroe | Kentucky | 21171 | 498 | 5 |
713827 | 713827 | 2020-11-09 | Monroe | Kentucky | 21171 | 473 | 5 |
710583 | 710583 | 2020-11-08 | Monroe | Kentucky | 21171 | 463 | 5 |
707339 | 707339 | 2020-11-07 | Monroe | Kentucky | 21171 | 452 | 5 |
704096 | 704096 | 2020-11-06 | Monroe | Kentucky | 21171 | 434 | 5 |
700854 | 700854 | 2020-11-05 | Monroe | Kentucky | 21171 | 409 | 5 |
697610 | 697610 | 2020-11-04 | Monroe | Kentucky | 21171 | 387 | 5 |
694367 | 694367 | 2020-11-03 | Monroe | Kentucky | 21171 | 373 | 5 |
691125 | 691125 | 2020-11-02 | Monroe | Kentucky | 21171 | 356 | 4 |
687880 | 687880 | 2020-11-01 | Monroe | Kentucky | 21171 | 352 | 4 |
684636 | 684636 | 2020-10-31 | Monroe | Kentucky | 21171 | 345 | 4 |
681393 | 681393 | 2020-10-30 | Monroe | Kentucky | 21171 | 333 | 4 |
678149 | 678149 | 2020-10-29 | Monroe | Kentucky | 21171 | 312 | 4 |
674907 | 674907 | 2020-10-28 | Monroe | Kentucky | 21171 | 298 | 4 |
671664 | 671664 | 2020-10-27 | Monroe | Kentucky | 21171 | 288 | 4 |
668422 | 668422 | 2020-10-26 | Monroe | Kentucky | 21171 | 276 | 4 |
665178 | 665178 | 2020-10-25 | Monroe | Kentucky | 21171 | 272 | 4 |
661933 | 661933 | 2020-10-24 | Monroe | Kentucky | 21171 | 269 | 4 |
658689 | 658689 | 2020-10-23 | Monroe | Kentucky | 21171 | 264 | 4 |
655444 | 655444 | 2020-10-22 | Monroe | Kentucky | 21171 | 258 | 4 |
652199 | 652199 | 2020-10-21 | Monroe | Kentucky | 21171 | 257 | 4 |
648954 | 648954 | 2020-10-20 | Monroe | Kentucky | 21171 | 255 | 4 |
645710 | 645710 | 2020-10-19 | Monroe | Kentucky | 21171 | 251 | 4 |
642463 | 642463 | 2020-10-18 | Monroe | Kentucky | 21171 | 249 | 4 |
639216 | 639216 | 2020-10-17 | Monroe | Kentucky | 21171 | 247 | 4 |
635970 | 635970 | 2020-10-16 | Monroe | Kentucky | 21171 | 245 | 4 |
632724 | 632724 | 2020-10-15 | Monroe | Kentucky | 21171 | 243 | 4 |
629480 | 629480 | 2020-10-14 | Monroe | Kentucky | 21171 | 237 | 4 |
626236 | 626236 | 2020-10-13 | Monroe | Kentucky | 21171 | 234 | 4 |
622994 | 622994 | 2020-10-12 | Monroe | Kentucky | 21171 | 230 | 4 |
619750 | 619750 | 2020-10-11 | Monroe | Kentucky | 21171 | 229 | 4 |
616508 | 616508 | 2020-10-10 | Monroe | Kentucky | 21171 | 229 | 4 |
613267 | 613267 | 2020-10-09 | Monroe | Kentucky | 21171 | 227 | 4 |
610025 | 610025 | 2020-10-08 | Monroe | Kentucky | 21171 | 225 | 4 |
606783 | 606783 | 2020-10-07 | Monroe | Kentucky | 21171 | 222 | 4 |
603541 | 603541 | 2020-10-06 | Monroe | Kentucky | 21171 | 220 | 4 |
600298 | 600298 | 2020-10-05 | Monroe | Kentucky | 21171 | 219 | 4 |
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);