ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21059 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090237 | 1090237 | 2021-03-05 | Daviess | Kentucky | 21059 | 9788 | 162 |
1086992 | 1086992 | 2021-03-04 | Daviess | Kentucky | 21059 | 9779 | 162 |
1083746 | 1083746 | 2021-03-03 | Daviess | Kentucky | 21059 | 9761 | 161 |
1080500 | 1080500 | 2021-03-02 | Daviess | Kentucky | 21059 | 9741 | 159 |
1077255 | 1077255 | 2021-03-01 | Daviess | Kentucky | 21059 | 9719 | 159 |
1074009 | 1074009 | 2021-02-28 | Daviess | Kentucky | 21059 | 9714 | 159 |
1070763 | 1070763 | 2021-02-27 | Daviess | Kentucky | 21059 | 9698 | 159 |
1067518 | 1067518 | 2021-02-26 | Daviess | Kentucky | 21059 | 9682 | 159 |
1064273 | 1064273 | 2021-02-25 | Daviess | Kentucky | 21059 | 9666 | 155 |
1061028 | 1061028 | 2021-02-24 | Daviess | Kentucky | 21059 | 9627 | 155 |
1057782 | 1057782 | 2021-02-23 | Daviess | Kentucky | 21059 | 9598 | 155 |
1054536 | 1054536 | 2021-02-22 | Daviess | Kentucky | 21059 | 9555 | 155 |
1051289 | 1051289 | 2021-02-21 | Daviess | Kentucky | 21059 | 9544 | 154 |
1048042 | 1048042 | 2021-02-20 | Daviess | Kentucky | 21059 | 9522 | 154 |
1044797 | 1044797 | 2021-02-19 | Daviess | Kentucky | 21059 | 9490 | 154 |
1041552 | 1041552 | 2021-02-18 | Daviess | Kentucky | 21059 | 9434 | 154 |
1038307 | 1038307 | 2021-02-17 | Daviess | Kentucky | 21059 | 9420 | 154 |
1035062 | 1035062 | 2021-02-16 | Daviess | Kentucky | 21059 | 9397 | 154 |
1031816 | 1031816 | 2021-02-15 | Daviess | Kentucky | 21059 | 9364 | 151 |
1028569 | 1028569 | 2021-02-14 | Daviess | Kentucky | 21059 | 9347 | 151 |
1025324 | 1025324 | 2021-02-13 | Daviess | Kentucky | 21059 | 9300 | 151 |
1022079 | 1022079 | 2021-02-12 | Daviess | Kentucky | 21059 | 9282 | 151 |
1018834 | 1018834 | 2021-02-11 | Daviess | Kentucky | 21059 | 9261 | 150 |
1015589 | 1015589 | 2021-02-10 | Daviess | Kentucky | 21059 | 9214 | 150 |
1012344 | 1012344 | 2021-02-09 | Daviess | Kentucky | 21059 | 9159 | 150 |
1009098 | 1009098 | 2021-02-08 | Daviess | Kentucky | 21059 | 9102 | 150 |
1005852 | 1005852 | 2021-02-07 | Daviess | Kentucky | 21059 | 9079 | 150 |
1002606 | 1002606 | 2021-02-06 | Daviess | Kentucky | 21059 | 9008 | 150 |
999360 | 999360 | 2021-02-05 | Daviess | Kentucky | 21059 | 8978 | 148 |
996114 | 996114 | 2021-02-04 | Daviess | Kentucky | 21059 | 8911 | 147 |
992868 | 992868 | 2021-02-03 | Daviess | Kentucky | 21059 | 8833 | 145 |
989622 | 989622 | 2021-02-02 | Daviess | Kentucky | 21059 | 8730 | 145 |
986375 | 986375 | 2021-02-01 | Daviess | Kentucky | 21059 | 8655 | 141 |
983128 | 983128 | 2021-01-31 | Daviess | Kentucky | 21059 | 8571 | 141 |
979882 | 979882 | 2021-01-30 | Daviess | Kentucky | 21059 | 8519 | 141 |
976636 | 976636 | 2021-01-29 | Daviess | Kentucky | 21059 | 8457 | 141 |
973391 | 973391 | 2021-01-28 | Daviess | Kentucky | 21059 | 8347 | 140 |
970146 | 970146 | 2021-01-27 | Daviess | Kentucky | 21059 | 8250 | 136 |
966902 | 966902 | 2021-01-26 | Daviess | Kentucky | 21059 | 8150 | 133 |
963657 | 963657 | 2021-01-25 | Daviess | Kentucky | 21059 | 8029 | 130 |
960412 | 960412 | 2021-01-24 | Daviess | Kentucky | 21059 | 8005 | 130 |
957166 | 957166 | 2021-01-23 | Daviess | Kentucky | 21059 | 7914 | 130 |
953921 | 953921 | 2021-01-22 | Daviess | Kentucky | 21059 | 7828 | 127 |
950676 | 950676 | 2021-01-21 | Daviess | Kentucky | 21059 | 7731 | 124 |
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 |
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);