ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Daviess" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947430 | 947430 | 2021-01-20 | Daviess | Kentucky | 21059 | 7607 | 123 |
944183 | 944183 | 2021-01-19 | Daviess | Kentucky | 21059 | 7487 | 120 |
940938 | 940938 | 2021-01-18 | Daviess | Kentucky | 21059 | 7437 | 120 |
937693 | 937693 | 2021-01-17 | Daviess | Kentucky | 21059 | 7418 | 118 |
934448 | 934448 | 2021-01-16 | Daviess | Kentucky | 21059 | 7367 | 118 |
931203 | 931203 | 2021-01-15 | Daviess | Kentucky | 21059 | 7287 | 118 |
927958 | 927958 | 2021-01-14 | Daviess | Kentucky | 21059 | 7189 | 116 |
924712 | 924712 | 2021-01-13 | Daviess | Kentucky | 21059 | 7093 | 113 |
921467 | 921467 | 2021-01-12 | Daviess | Kentucky | 21059 | 6919 | 109 |
918222 | 918222 | 2021-01-11 | Daviess | Kentucky | 21059 | 6849 | 108 |
914977 | 914977 | 2021-01-10 | Daviess | Kentucky | 21059 | 6821 | 107 |
911732 | 911732 | 2021-01-09 | Daviess | Kentucky | 21059 | 6737 | 107 |
908487 | 908487 | 2021-01-08 | Daviess | Kentucky | 21059 | 6613 | 107 |
905241 | 905241 | 2021-01-07 | Daviess | Kentucky | 21059 | 6470 | 106 |
901996 | 901996 | 2021-01-06 | Daviess | Kentucky | 21059 | 6378 | 103 |
898751 | 898751 | 2021-01-05 | Daviess | Kentucky | 21059 | 6171 | 99 |
895506 | 895506 | 2021-01-04 | Daviess | Kentucky | 21059 | 6119 | 99 |
892259 | 892259 | 2021-01-03 | Daviess | Kentucky | 21059 | 6080 | 92 |
889013 | 889013 | 2021-01-02 | Daviess | Kentucky | 21059 | 5981 | 92 |
885767 | 885767 | 2021-01-01 | Daviess | Kentucky | 21059 | 5737 | 92 |
882522 | 882522 | 2020-12-31 | Daviess | Kentucky | 21059 | 5737 | 92 |
879277 | 879277 | 2020-12-30 | Daviess | Kentucky | 21059 | 5737 | 90 |
876032 | 876032 | 2020-12-29 | Daviess | Kentucky | 21059 | 5655 | 88 |
872787 | 872787 | 2020-12-28 | Daviess | Kentucky | 21059 | 5589 | 84 |
869542 | 869542 | 2020-12-27 | Daviess | Kentucky | 21059 | 5558 | 82 |
866297 | 866297 | 2020-12-26 | Daviess | Kentucky | 21059 | 5495 | 82 |
863052 | 863052 | 2020-12-25 | Daviess | Kentucky | 21059 | 5363 | 82 |
859807 | 859807 | 2020-12-24 | Daviess | Kentucky | 21059 | 5363 | 82 |
856562 | 856562 | 2020-12-23 | Daviess | Kentucky | 21059 | 5363 | 82 |
853317 | 853317 | 2020-12-22 | Daviess | Kentucky | 21059 | 5263 | 76 |
850072 | 850072 | 2020-12-21 | Daviess | Kentucky | 21059 | 5177 | 76 |
846827 | 846827 | 2020-12-20 | Daviess | Kentucky | 21059 | 5160 | 76 |
843581 | 843581 | 2020-12-19 | Daviess | Kentucky | 21059 | 5130 | 76 |
840336 | 840336 | 2020-12-18 | Daviess | Kentucky | 21059 | 4996 | 76 |
837091 | 837091 | 2020-12-17 | Daviess | Kentucky | 21059 | 4920 | 74 |
833845 | 833845 | 2020-12-16 | Daviess | Kentucky | 21059 | 4824 | 74 |
830598 | 830598 | 2020-12-15 | Daviess | Kentucky | 21059 | 4716 | 73 |
827352 | 827352 | 2020-12-14 | Daviess | Kentucky | 21059 | 4599 | 71 |
824105 | 824105 | 2020-12-13 | Daviess | Kentucky | 21059 | 4588 | 71 |
820859 | 820859 | 2020-12-12 | Daviess | Kentucky | 21059 | 4554 | 71 |
817613 | 817613 | 2020-12-11 | Daviess | Kentucky | 21059 | 4465 | 70 |
814367 | 814367 | 2020-12-10 | Daviess | Kentucky | 21059 | 4404 | 69 |
811122 | 811122 | 2020-12-09 | Daviess | Kentucky | 21059 | 4323 | 65 |
807877 | 807877 | 2020-12-08 | Daviess | Kentucky | 21059 | 4249 | 62 |
804632 | 804632 | 2020-12-07 | Daviess | Kentucky | 21059 | 4151 | 54 |
801387 | 801387 | 2020-12-06 | Daviess | Kentucky | 21059 | 4128 | 54 |
798142 | 798142 | 2020-12-05 | Daviess | Kentucky | 21059 | 4081 | 54 |
794897 | 794897 | 2020-12-04 | Daviess | Kentucky | 21059 | 3948 | 54 |
791652 | 791652 | 2020-12-03 | Daviess | Kentucky | 21059 | 3848 | 54 |
788407 | 788407 | 2020-12-02 | Daviess | Kentucky | 21059 | 3766 | 53 |
785163 | 785163 | 2020-12-01 | Daviess | Kentucky | 21059 | 3675 | 53 |
781918 | 781918 | 2020-11-30 | Daviess | Kentucky | 21059 | 3557 | 48 |
778672 | 778672 | 2020-11-29 | Daviess | Kentucky | 21059 | 3467 | 48 |
775427 | 775427 | 2020-11-28 | Daviess | Kentucky | 21059 | 3335 | 48 |
772182 | 772182 | 2020-11-27 | Daviess | Kentucky | 21059 | 3326 | 48 |
768937 | 768937 | 2020-11-26 | Daviess | Kentucky | 21059 | 3240 | 48 |
765691 | 765691 | 2020-11-25 | Daviess | Kentucky | 21059 | 3240 | 48 |
762446 | 762446 | 2020-11-24 | Daviess | Kentucky | 21059 | 3170 | 45 |
759201 | 759201 | 2020-11-23 | Daviess | Kentucky | 21059 | 3098 | 42 |
755954 | 755954 | 2020-11-22 | Daviess | Kentucky | 21059 | 3071 | 42 |
752708 | 752708 | 2020-11-21 | Daviess | Kentucky | 21059 | 3046 | 41 |
749462 | 749462 | 2020-11-20 | Daviess | Kentucky | 21059 | 2993 | 41 |
746216 | 746216 | 2020-11-19 | Daviess | Kentucky | 21059 | 2901 | 41 |
742969 | 742969 | 2020-11-18 | Daviess | Kentucky | 21059 | 2846 | 40 |
739722 | 739722 | 2020-11-17 | Daviess | Kentucky | 21059 | 2787 | 39 |
736478 | 736478 | 2020-11-16 | Daviess | Kentucky | 21059 | 2694 | 35 |
733232 | 733232 | 2020-11-15 | Daviess | Kentucky | 21059 | 2679 | 35 |
729987 | 729987 | 2020-11-14 | Daviess | Kentucky | 21059 | 2657 | 35 |
726744 | 726744 | 2020-11-13 | Daviess | Kentucky | 21059 | 2593 | 35 |
723501 | 723501 | 2020-11-12 | Daviess | Kentucky | 21059 | 2551 | 35 |
720258 | 720258 | 2020-11-11 | Daviess | Kentucky | 21059 | 2503 | 35 |
717015 | 717015 | 2020-11-10 | Daviess | Kentucky | 21059 | 2432 | 35 |
713771 | 713771 | 2020-11-09 | Daviess | Kentucky | 21059 | 2390 | 34 |
710527 | 710527 | 2020-11-08 | Daviess | Kentucky | 21059 | 2340 | 34 |
707283 | 707283 | 2020-11-07 | Daviess | Kentucky | 21059 | 2320 | 34 |
704040 | 704040 | 2020-11-06 | Daviess | Kentucky | 21059 | 2274 | 33 |
700798 | 700798 | 2020-11-05 | Daviess | Kentucky | 21059 | 2245 | 33 |
697554 | 697554 | 2020-11-04 | Daviess | Kentucky | 21059 | 2201 | 32 |
694311 | 694311 | 2020-11-03 | Daviess | Kentucky | 21059 | 2164 | 32 |
691069 | 691069 | 2020-11-02 | Daviess | Kentucky | 21059 | 2131 | 32 |
687824 | 687824 | 2020-11-01 | Daviess | Kentucky | 21059 | 2111 | 32 |
684580 | 684580 | 2020-10-31 | Daviess | Kentucky | 21059 | 2085 | 32 |
681337 | 681337 | 2020-10-30 | Daviess | Kentucky | 21059 | 2054 | 31 |
678093 | 678093 | 2020-10-29 | Daviess | Kentucky | 21059 | 2024 | 30 |
674851 | 674851 | 2020-10-28 | Daviess | Kentucky | 21059 | 2005 | 29 |
671608 | 671608 | 2020-10-27 | Daviess | Kentucky | 21059 | 1974 | 29 |
668366 | 668366 | 2020-10-26 | Daviess | Kentucky | 21059 | 1952 | 29 |
665122 | 665122 | 2020-10-25 | Daviess | Kentucky | 21059 | 1942 | 29 |
661877 | 661877 | 2020-10-24 | Daviess | Kentucky | 21059 | 1926 | 29 |
658633 | 658633 | 2020-10-23 | Daviess | Kentucky | 21059 | 1887 | 29 |
655388 | 655388 | 2020-10-22 | Daviess | Kentucky | 21059 | 1861 | 28 |
652143 | 652143 | 2020-10-21 | Daviess | Kentucky | 21059 | 1837 | 28 |
648898 | 648898 | 2020-10-20 | Daviess | Kentucky | 21059 | 1822 | 27 |
645654 | 645654 | 2020-10-19 | Daviess | Kentucky | 21059 | 1803 | 26 |
642407 | 642407 | 2020-10-18 | Daviess | Kentucky | 21059 | 1795 | 26 |
639160 | 639160 | 2020-10-17 | Daviess | Kentucky | 21059 | 1781 | 25 |
635914 | 635914 | 2020-10-16 | Daviess | Kentucky | 21059 | 1758 | 24 |
632668 | 632668 | 2020-10-15 | Daviess | Kentucky | 21059 | 1742 | 24 |
629424 | 629424 | 2020-10-14 | Daviess | Kentucky | 21059 | 1730 | 24 |
626180 | 626180 | 2020-10-13 | Daviess | Kentucky | 21059 | 1721 | 24 |
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);