ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21101 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
- 21101 · 392 ✖
county 1
- Henderson 392
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1220145 | 1220145 | 2021-04-14 | Henderson | Kentucky | 21101 | 4572 | 74 |
1216897 | 1216897 | 2021-04-13 | Henderson | Kentucky | 21101 | 4559 | 72 |
1213650 | 1213650 | 2021-04-12 | Henderson | Kentucky | 21101 | 4553 | 72 |
1210402 | 1210402 | 2021-04-11 | Henderson | Kentucky | 21101 | 4548 | 72 |
1207153 | 1207153 | 2021-04-10 | Henderson | Kentucky | 21101 | 4549 | 72 |
1203905 | 1203905 | 2021-04-09 | Henderson | Kentucky | 21101 | 4540 | 72 |
1200657 | 1200657 | 2021-04-08 | Henderson | Kentucky | 21101 | 4535 | 72 |
1197408 | 1197408 | 2021-04-07 | Henderson | Kentucky | 21101 | 4532 | 72 |
1194160 | 1194160 | 2021-04-06 | Henderson | Kentucky | 21101 | 4523 | 71 |
1190910 | 1190910 | 2021-04-05 | Henderson | Kentucky | 21101 | 4518 | 71 |
1187663 | 1187663 | 2021-04-04 | Henderson | Kentucky | 21101 | 4514 | 71 |
1184416 | 1184416 | 2021-04-03 | Henderson | Kentucky | 21101 | 4514 | 71 |
1181169 | 1181169 | 2021-04-02 | Henderson | Kentucky | 21101 | 4507 | 71 |
1177922 | 1177922 | 2021-04-01 | Henderson | Kentucky | 21101 | 4499 | 71 |
1174675 | 1174675 | 2021-03-31 | Henderson | Kentucky | 21101 | 4495 | 71 |
1171428 | 1171428 | 2021-03-30 | Henderson | Kentucky | 21101 | 4487 | 71 |
1168180 | 1168180 | 2021-03-29 | Henderson | Kentucky | 21101 | 4482 | 71 |
1164932 | 1164932 | 2021-03-28 | Henderson | Kentucky | 21101 | 4480 | 71 |
1161684 | 1161684 | 2021-03-27 | Henderson | Kentucky | 21101 | 4474 | 71 |
1158436 | 1158436 | 2021-03-26 | Henderson | Kentucky | 21101 | 4467 | 71 |
1155189 | 1155189 | 2021-03-25 | Henderson | Kentucky | 21101 | 4459 | 71 |
1151942 | 1151942 | 2021-03-24 | Henderson | Kentucky | 21101 | 4453 | 71 |
1148695 | 1148695 | 2021-03-23 | Henderson | Kentucky | 21101 | 4447 | 70 |
1145448 | 1145448 | 2021-03-22 | Henderson | Kentucky | 21101 | 4443 | 70 |
1142201 | 1142201 | 2021-03-21 | Henderson | Kentucky | 21101 | 4441 | 70 |
1138955 | 1138955 | 2021-03-20 | Henderson | Kentucky | 21101 | 4435 | 70 |
1135709 | 1135709 | 2021-03-19 | Henderson | Kentucky | 21101 | 4428 | 69 |
1132462 | 1132462 | 2021-03-18 | Henderson | Kentucky | 21101 | 4410 | 64 |
1129214 | 1129214 | 2021-03-17 | Henderson | Kentucky | 21101 | 4403 | 62 |
1125968 | 1125968 | 2021-03-16 | Henderson | Kentucky | 21101 | 4384 | 62 |
1122722 | 1122722 | 2021-03-15 | Henderson | Kentucky | 21101 | 4380 | 62 |
1119475 | 1119475 | 2021-03-14 | Henderson | Kentucky | 21101 | 4374 | 60 |
1116228 | 1116228 | 2021-03-13 | Henderson | Kentucky | 21101 | 4370 | 60 |
1112982 | 1112982 | 2021-03-12 | Henderson | Kentucky | 21101 | 4366 | 60 |
1109736 | 1109736 | 2021-03-11 | Henderson | Kentucky | 21101 | 4363 | 60 |
1106490 | 1106490 | 2021-03-10 | Henderson | Kentucky | 21101 | 4357 | 60 |
1103244 | 1103244 | 2021-03-09 | Henderson | Kentucky | 21101 | 4354 | 60 |
1099998 | 1099998 | 2021-03-08 | Henderson | Kentucky | 21101 | 4351 | 60 |
1096750 | 1096750 | 2021-03-07 | Henderson | Kentucky | 21101 | 4347 | 60 |
1093504 | 1093504 | 2021-03-06 | Henderson | Kentucky | 21101 | 4342 | 60 |
1090258 | 1090258 | 2021-03-05 | Henderson | Kentucky | 21101 | 4340 | 60 |
1087013 | 1087013 | 2021-03-04 | Henderson | Kentucky | 21101 | 4337 | 60 |
1083767 | 1083767 | 2021-03-03 | Henderson | Kentucky | 21101 | 4336 | 60 |
1080521 | 1080521 | 2021-03-02 | Henderson | Kentucky | 21101 | 4329 | 59 |
1077276 | 1077276 | 2021-03-01 | Henderson | Kentucky | 21101 | 4327 | 59 |
1074030 | 1074030 | 2021-02-28 | Henderson | Kentucky | 21101 | 4325 | 59 |
1070784 | 1070784 | 2021-02-27 | Henderson | Kentucky | 21101 | 4322 | 59 |
1067539 | 1067539 | 2021-02-26 | Henderson | Kentucky | 21101 | 4316 | 57 |
1064294 | 1064294 | 2021-02-25 | Henderson | Kentucky | 21101 | 4312 | 57 |
1061049 | 1061049 | 2021-02-24 | Henderson | Kentucky | 21101 | 4310 | 57 |
1057803 | 1057803 | 2021-02-23 | Henderson | Kentucky | 21101 | 4304 | 57 |
1054557 | 1054557 | 2021-02-22 | Henderson | Kentucky | 21101 | 4298 | 57 |
1051310 | 1051310 | 2021-02-21 | Henderson | Kentucky | 21101 | 4294 | 57 |
1048063 | 1048063 | 2021-02-20 | Henderson | Kentucky | 21101 | 4284 | 57 |
1044818 | 1044818 | 2021-02-19 | Henderson | Kentucky | 21101 | 4275 | 57 |
1041573 | 1041573 | 2021-02-18 | Henderson | Kentucky | 21101 | 4274 | 57 |
1038328 | 1038328 | 2021-02-17 | Henderson | Kentucky | 21101 | 4267 | 57 |
1035083 | 1035083 | 2021-02-16 | Henderson | Kentucky | 21101 | 4262 | 57 |
1031837 | 1031837 | 2021-02-15 | Henderson | Kentucky | 21101 | 4249 | 57 |
1028590 | 1028590 | 2021-02-14 | Henderson | Kentucky | 21101 | 4240 | 57 |
1025345 | 1025345 | 2021-02-13 | Henderson | Kentucky | 21101 | 4230 | 57 |
1022100 | 1022100 | 2021-02-12 | Henderson | Kentucky | 21101 | 4224 | 57 |
1018855 | 1018855 | 2021-02-11 | Henderson | Kentucky | 21101 | 4211 | 57 |
1015610 | 1015610 | 2021-02-10 | Henderson | Kentucky | 21101 | 4195 | 57 |
1012365 | 1012365 | 2021-02-09 | Henderson | Kentucky | 21101 | 4174 | 57 |
1009119 | 1009119 | 2021-02-08 | Henderson | Kentucky | 21101 | 4153 | 57 |
1005873 | 1005873 | 2021-02-07 | Henderson | Kentucky | 21101 | 4148 | 57 |
1002627 | 1002627 | 2021-02-06 | Henderson | Kentucky | 21101 | 4130 | 57 |
999381 | 999381 | 2021-02-05 | Henderson | Kentucky | 21101 | 4095 | 57 |
996135 | 996135 | 2021-02-04 | Henderson | Kentucky | 21101 | 4071 | 57 |
992889 | 992889 | 2021-02-03 | Henderson | Kentucky | 21101 | 4048 | 57 |
989643 | 989643 | 2021-02-02 | Henderson | Kentucky | 21101 | 4026 | 57 |
986396 | 986396 | 2021-02-01 | Henderson | Kentucky | 21101 | 4010 | 57 |
983149 | 983149 | 2021-01-31 | Henderson | Kentucky | 21101 | 3997 | 57 |
979903 | 979903 | 2021-01-30 | Henderson | Kentucky | 21101 | 3967 | 57 |
976657 | 976657 | 2021-01-29 | Henderson | Kentucky | 21101 | 3930 | 56 |
973412 | 973412 | 2021-01-28 | Henderson | Kentucky | 21101 | 3899 | 56 |
970167 | 970167 | 2021-01-27 | Henderson | Kentucky | 21101 | 3873 | 56 |
966923 | 966923 | 2021-01-26 | Henderson | Kentucky | 21101 | 3851 | 55 |
963678 | 963678 | 2021-01-25 | Henderson | Kentucky | 21101 | 3834 | 53 |
960433 | 960433 | 2021-01-24 | Henderson | Kentucky | 21101 | 3832 | 53 |
957187 | 957187 | 2021-01-23 | Henderson | Kentucky | 21101 | 3815 | 53 |
953942 | 953942 | 2021-01-22 | Henderson | Kentucky | 21101 | 3780 | 53 |
950697 | 950697 | 2021-01-21 | Henderson | Kentucky | 21101 | 3765 | 52 |
947451 | 947451 | 2021-01-20 | Henderson | Kentucky | 21101 | 3716 | 52 |
944204 | 944204 | 2021-01-19 | Henderson | Kentucky | 21101 | 3655 | 52 |
940959 | 940959 | 2021-01-18 | Henderson | Kentucky | 21101 | 3649 | 52 |
937714 | 937714 | 2021-01-17 | Henderson | Kentucky | 21101 | 3640 | 52 |
934469 | 934469 | 2021-01-16 | Henderson | Kentucky | 21101 | 3619 | 52 |
931224 | 931224 | 2021-01-15 | Henderson | Kentucky | 21101 | 3564 | 52 |
927979 | 927979 | 2021-01-14 | Henderson | Kentucky | 21101 | 3528 | 52 |
924733 | 924733 | 2021-01-13 | Henderson | Kentucky | 21101 | 3497 | 52 |
921488 | 921488 | 2021-01-12 | Henderson | Kentucky | 21101 | 3439 | 52 |
918243 | 918243 | 2021-01-11 | Henderson | Kentucky | 21101 | 3401 | 52 |
914998 | 914998 | 2021-01-10 | Henderson | Kentucky | 21101 | 3343 | 52 |
911753 | 911753 | 2021-01-09 | Henderson | Kentucky | 21101 | 3319 | 52 |
908508 | 908508 | 2021-01-08 | Henderson | Kentucky | 21101 | 3223 | 52 |
905262 | 905262 | 2021-01-07 | Henderson | Kentucky | 21101 | 3181 | 51 |
902017 | 902017 | 2021-01-06 | Henderson | Kentucky | 21101 | 3153 | 51 |
898772 | 898772 | 2021-01-05 | Henderson | Kentucky | 21101 | 3096 | 50 |
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);