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)
date (date) >30 ✖
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- …
state 1
- Kentucky · 392 ✖
fips 1
- 21059 · 392 ✖
county 1
- Daviess 392
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1220124 | 1220124 | 2021-04-14 | Daviess | Kentucky | 21059 | 10345 | 177 |
1216876 | 1216876 | 2021-04-13 | Daviess | Kentucky | 21059 | 10334 | 177 |
1213629 | 1213629 | 2021-04-12 | Daviess | Kentucky | 21059 | 10315 | 177 |
1210381 | 1210381 | 2021-04-11 | Daviess | Kentucky | 21059 | 10303 | 177 |
1207132 | 1207132 | 2021-04-10 | Daviess | Kentucky | 21059 | 10293 | 176 |
1203884 | 1203884 | 2021-04-09 | Daviess | Kentucky | 21059 | 10283 | 176 |
1200636 | 1200636 | 2021-04-08 | Daviess | Kentucky | 21059 | 10269 | 175 |
1197387 | 1197387 | 2021-04-07 | Daviess | Kentucky | 21059 | 10259 | 174 |
1194139 | 1194139 | 2021-04-06 | Daviess | Kentucky | 21059 | 10237 | 173 |
1190889 | 1190889 | 2021-04-05 | Daviess | Kentucky | 21059 | 10230 | 173 |
1187642 | 1187642 | 2021-04-04 | Daviess | Kentucky | 21059 | 10217 | 173 |
1184395 | 1184395 | 2021-04-03 | Daviess | Kentucky | 21059 | 10217 | 173 |
1181148 | 1181148 | 2021-04-02 | Daviess | Kentucky | 21059 | 10207 | 173 |
1177901 | 1177901 | 2021-04-01 | Daviess | Kentucky | 21059 | 10192 | 173 |
1174654 | 1174654 | 2021-03-31 | Daviess | Kentucky | 21059 | 10174 | 174 |
1171407 | 1171407 | 2021-03-30 | Daviess | Kentucky | 21059 | 10148 | 174 |
1168159 | 1168159 | 2021-03-29 | Daviess | Kentucky | 21059 | 10126 | 175 |
1164911 | 1164911 | 2021-03-28 | Daviess | Kentucky | 21059 | 10120 | 175 |
1161663 | 1161663 | 2021-03-27 | Daviess | Kentucky | 21059 | 10114 | 175 |
1158415 | 1158415 | 2021-03-26 | Daviess | Kentucky | 21059 | 10095 | 175 |
1155168 | 1155168 | 2021-03-25 | Daviess | Kentucky | 21059 | 10084 | 175 |
1151921 | 1151921 | 2021-03-24 | Daviess | Kentucky | 21059 | 10063 | 175 |
1148674 | 1148674 | 2021-03-23 | Daviess | Kentucky | 21059 | 10047 | 174 |
1145427 | 1145427 | 2021-03-22 | Daviess | Kentucky | 21059 | 10021 | 173 |
1142180 | 1142180 | 2021-03-21 | Daviess | Kentucky | 21059 | 10012 | 173 |
1138934 | 1138934 | 2021-03-20 | Daviess | Kentucky | 21059 | 10007 | 173 |
1135688 | 1135688 | 2021-03-19 | Daviess | Kentucky | 21059 | 9984 | 173 |
1132441 | 1132441 | 2021-03-18 | Daviess | Kentucky | 21059 | 9959 | 165 |
1129193 | 1129193 | 2021-03-17 | Daviess | Kentucky | 21059 | 9943 | 162 |
1125947 | 1125947 | 2021-03-16 | Daviess | Kentucky | 21059 | 9929 | 162 |
1122701 | 1122701 | 2021-03-15 | Daviess | Kentucky | 21059 | 9906 | 162 |
1119454 | 1119454 | 2021-03-14 | Daviess | Kentucky | 21059 | 9902 | 162 |
1116207 | 1116207 | 2021-03-13 | Daviess | Kentucky | 21059 | 9896 | 162 |
1112961 | 1112961 | 2021-03-12 | Daviess | Kentucky | 21059 | 9882 | 162 |
1109715 | 1109715 | 2021-03-11 | Daviess | Kentucky | 21059 | 9869 | 162 |
1106469 | 1106469 | 2021-03-10 | Daviess | Kentucky | 21059 | 9851 | 162 |
1103223 | 1103223 | 2021-03-09 | Daviess | Kentucky | 21059 | 9832 | 162 |
1099977 | 1099977 | 2021-03-08 | Daviess | Kentucky | 21059 | 9817 | 162 |
1096729 | 1096729 | 2021-03-07 | Daviess | Kentucky | 21059 | 9814 | 162 |
1093483 | 1093483 | 2021-03-06 | Daviess | Kentucky | 21059 | 9799 | 162 |
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 |
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);