ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 21067 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 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
- …
state 1
- Kentucky · 405 ✖
fips 1
- 21067 · 405 ✖
county 1
- Fayette 405
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1220128 | 1220128 | 2021-04-14 | Fayette | Kentucky | 21067 | 34653 | 296 |
1216880 | 1216880 | 2021-04-13 | Fayette | Kentucky | 21067 | 34593 | 296 |
1213633 | 1213633 | 2021-04-12 | Fayette | Kentucky | 21067 | 34552 | 296 |
1210385 | 1210385 | 2021-04-11 | Fayette | Kentucky | 21067 | 34557 | 296 |
1207136 | 1207136 | 2021-04-10 | Fayette | Kentucky | 21067 | 34495 | 296 |
1203888 | 1203888 | 2021-04-09 | Fayette | Kentucky | 21067 | 34461 | 296 |
1200640 | 1200640 | 2021-04-08 | Fayette | Kentucky | 21067 | 34405 | 293 |
1197391 | 1197391 | 2021-04-07 | Fayette | Kentucky | 21067 | 34359 | 293 |
1194143 | 1194143 | 2021-04-06 | Fayette | Kentucky | 21067 | 34294 | 290 |
1190893 | 1190893 | 2021-04-05 | Fayette | Kentucky | 21067 | 34277 | 290 |
1187646 | 1187646 | 2021-04-04 | Fayette | Kentucky | 21067 | 34270 | 290 |
1184399 | 1184399 | 2021-04-03 | Fayette | Kentucky | 21067 | 34270 | 290 |
1181152 | 1181152 | 2021-04-02 | Fayette | Kentucky | 21067 | 34220 | 286 |
1177905 | 1177905 | 2021-04-01 | Fayette | Kentucky | 21067 | 34187 | 286 |
1174658 | 1174658 | 2021-03-31 | Fayette | Kentucky | 21067 | 34153 | 282 |
1171411 | 1171411 | 2021-03-30 | Fayette | Kentucky | 21067 | 34089 | 282 |
1168163 | 1168163 | 2021-03-29 | Fayette | Kentucky | 21067 | 34032 | 281 |
1164915 | 1164915 | 2021-03-28 | Fayette | Kentucky | 21067 | 34024 | 281 |
1161667 | 1161667 | 2021-03-27 | Fayette | Kentucky | 21067 | 33990 | 281 |
1158419 | 1158419 | 2021-03-26 | Fayette | Kentucky | 21067 | 33938 | 281 |
1155172 | 1155172 | 2021-03-25 | Fayette | Kentucky | 21067 | 33885 | 278 |
1151925 | 1151925 | 2021-03-24 | Fayette | Kentucky | 21067 | 33832 | 277 |
1148678 | 1148678 | 2021-03-23 | Fayette | Kentucky | 21067 | 33789 | 276 |
1145431 | 1145431 | 2021-03-22 | Fayette | Kentucky | 21067 | 33734 | 275 |
1142184 | 1142184 | 2021-03-21 | Fayette | Kentucky | 21067 | 33725 | 273 |
1138938 | 1138938 | 2021-03-20 | Fayette | Kentucky | 21067 | 33691 | 273 |
1135692 | 1135692 | 2021-03-19 | Fayette | Kentucky | 21067 | 33652 | 261 |
1132445 | 1132445 | 2021-03-18 | Fayette | Kentucky | 21067 | 33614 | 255 |
1129197 | 1129197 | 2021-03-17 | Fayette | Kentucky | 21067 | 33563 | 247 |
1125951 | 1125951 | 2021-03-16 | Fayette | Kentucky | 21067 | 33499 | 246 |
1122705 | 1122705 | 2021-03-15 | Fayette | Kentucky | 21067 | 33443 | 245 |
1119458 | 1119458 | 2021-03-14 | Fayette | Kentucky | 21067 | 33407 | 239 |
1116211 | 1116211 | 2021-03-13 | Fayette | Kentucky | 21067 | 33357 | 239 |
1112965 | 1112965 | 2021-03-12 | Fayette | Kentucky | 21067 | 33312 | 238 |
1109719 | 1109719 | 2021-03-11 | Fayette | Kentucky | 21067 | 33233 | 238 |
1106473 | 1106473 | 2021-03-10 | Fayette | Kentucky | 21067 | 33170 | 237 |
1103227 | 1103227 | 2021-03-09 | Fayette | Kentucky | 21067 | 33112 | 237 |
1099981 | 1099981 | 2021-03-08 | Fayette | Kentucky | 21067 | 33054 | 237 |
1096733 | 1096733 | 2021-03-07 | Fayette | Kentucky | 21067 | 33023 | 235 |
1093487 | 1093487 | 2021-03-06 | Fayette | Kentucky | 21067 | 32965 | 235 |
1090241 | 1090241 | 2021-03-05 | Fayette | Kentucky | 21067 | 32908 | 234 |
1086996 | 1086996 | 2021-03-04 | Fayette | Kentucky | 21067 | 32837 | 234 |
1083750 | 1083750 | 2021-03-03 | Fayette | Kentucky | 21067 | 32789 | 234 |
1080504 | 1080504 | 2021-03-02 | Fayette | Kentucky | 21067 | 32734 | 234 |
1077259 | 1077259 | 2021-03-01 | Fayette | Kentucky | 21067 | 32649 | 234 |
1074013 | 1074013 | 2021-02-28 | Fayette | Kentucky | 21067 | 32645 | 234 |
1070767 | 1070767 | 2021-02-27 | Fayette | Kentucky | 21067 | 32590 | 234 |
1067522 | 1067522 | 2021-02-26 | Fayette | Kentucky | 21067 | 32515 | 232 |
1064277 | 1064277 | 2021-02-25 | Fayette | Kentucky | 21067 | 32437 | 232 |
1061032 | 1061032 | 2021-02-24 | Fayette | Kentucky | 21067 | 32355 | 232 |
1057786 | 1057786 | 2021-02-23 | Fayette | Kentucky | 21067 | 32261 | 232 |
1054540 | 1054540 | 2021-02-22 | Fayette | Kentucky | 21067 | 32131 | 230 |
1051293 | 1051293 | 2021-02-21 | Fayette | Kentucky | 21067 | 32099 | 224 |
1048046 | 1048046 | 2021-02-20 | Fayette | Kentucky | 21067 | 32009 | 224 |
1044801 | 1044801 | 2021-02-19 | Fayette | Kentucky | 21067 | 31935 | 223 |
1041556 | 1041556 | 2021-02-18 | Fayette | Kentucky | 21067 | 31821 | 219 |
1038311 | 1038311 | 2021-02-17 | Fayette | Kentucky | 21067 | 31757 | 218 |
1035066 | 1035066 | 2021-02-16 | Fayette | Kentucky | 21067 | 31654 | 218 |
1031820 | 1031820 | 2021-02-15 | Fayette | Kentucky | 21067 | 31526 | 217 |
1028573 | 1028573 | 2021-02-14 | Fayette | Kentucky | 21067 | 31465 | 212 |
1025328 | 1025328 | 2021-02-13 | Fayette | Kentucky | 21067 | 31299 | 212 |
1022083 | 1022083 | 2021-02-12 | Fayette | Kentucky | 21067 | 31252 | 212 |
1018838 | 1018838 | 2021-02-11 | Fayette | Kentucky | 21067 | 31173 | 211 |
1015593 | 1015593 | 2021-02-10 | Fayette | Kentucky | 21067 | 31065 | 211 |
1012348 | 1012348 | 2021-02-09 | Fayette | Kentucky | 21067 | 30917 | 211 |
1009102 | 1009102 | 2021-02-08 | Fayette | Kentucky | 21067 | 30799 | 209 |
1005856 | 1005856 | 2021-02-07 | Fayette | Kentucky | 21067 | 30728 | 206 |
1002610 | 1002610 | 2021-02-06 | Fayette | Kentucky | 21067 | 30601 | 206 |
999364 | 999364 | 2021-02-05 | Fayette | Kentucky | 21067 | 30454 | 205 |
996118 | 996118 | 2021-02-04 | Fayette | Kentucky | 21067 | 30321 | 205 |
992872 | 992872 | 2021-02-03 | Fayette | Kentucky | 21067 | 30165 | 196 |
989626 | 989626 | 2021-02-02 | Fayette | Kentucky | 21067 | 30009 | 196 |
986379 | 986379 | 2021-02-01 | Fayette | Kentucky | 21067 | 29870 | 195 |
983132 | 983132 | 2021-01-31 | Fayette | Kentucky | 21067 | 29758 | 195 |
979886 | 979886 | 2021-01-30 | Fayette | Kentucky | 21067 | 29617 | 195 |
976640 | 976640 | 2021-01-29 | Fayette | Kentucky | 21067 | 29439 | 194 |
973395 | 973395 | 2021-01-28 | Fayette | Kentucky | 21067 | 29241 | 191 |
970150 | 970150 | 2021-01-27 | Fayette | Kentucky | 21067 | 29032 | 191 |
966906 | 966906 | 2021-01-26 | Fayette | Kentucky | 21067 | 28845 | 189 |
963661 | 963661 | 2021-01-25 | Fayette | Kentucky | 21067 | 28662 | 187 |
960416 | 960416 | 2021-01-24 | Fayette | Kentucky | 21067 | 28523 | 179 |
957170 | 957170 | 2021-01-23 | Fayette | Kentucky | 21067 | 28352 | 179 |
953925 | 953925 | 2021-01-22 | Fayette | Kentucky | 21067 | 28140 | 179 |
950680 | 950680 | 2021-01-21 | Fayette | Kentucky | 21067 | 27881 | 179 |
947434 | 947434 | 2021-01-20 | Fayette | Kentucky | 21067 | 27652 | 176 |
944187 | 944187 | 2021-01-19 | Fayette | Kentucky | 21067 | 27435 | 174 |
940942 | 940942 | 2021-01-18 | Fayette | Kentucky | 21067 | 27358 | 174 |
937697 | 937697 | 2021-01-17 | Fayette | Kentucky | 21067 | 27127 | 173 |
934452 | 934452 | 2021-01-16 | Fayette | Kentucky | 21067 | 26909 | 173 |
931207 | 931207 | 2021-01-15 | Fayette | Kentucky | 21067 | 26703 | 173 |
927962 | 927962 | 2021-01-14 | Fayette | Kentucky | 21067 | 26453 | 170 |
924716 | 924716 | 2021-01-13 | Fayette | Kentucky | 21067 | 26282 | 168 |
921471 | 921471 | 2021-01-12 | Fayette | Kentucky | 21067 | 26045 | 167 |
918226 | 918226 | 2021-01-11 | Fayette | Kentucky | 21067 | 25905 | 167 |
914981 | 914981 | 2021-01-10 | Fayette | Kentucky | 21067 | 25725 | 166 |
911736 | 911736 | 2021-01-09 | Fayette | Kentucky | 21067 | 25502 | 166 |
908491 | 908491 | 2021-01-08 | Fayette | Kentucky | 21067 | 25219 | 165 |
905245 | 905245 | 2021-01-07 | Fayette | Kentucky | 21067 | 24924 | 165 |
902000 | 902000 | 2021-01-06 | Fayette | Kentucky | 21067 | 24660 | 165 |
898755 | 898755 | 2021-01-05 | Fayette | Kentucky | 21067 | 24285 | 163 |
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);