ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Washington" and fips = 21229 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194224 | 1194224 | 2021-04-06 | Washington | Kentucky | 21229 | 1396 | 36 |
1190974 | 1190974 | 2021-04-05 | Washington | Kentucky | 21229 | 1396 | 36 |
1187727 | 1187727 | 2021-04-04 | Washington | Kentucky | 21229 | 1396 | 36 |
1184480 | 1184480 | 2021-04-03 | Washington | Kentucky | 21229 | 1396 | 36 |
1181233 | 1181233 | 2021-04-02 | Washington | Kentucky | 21229 | 1396 | 36 |
1177986 | 1177986 | 2021-04-01 | Washington | Kentucky | 21229 | 1396 | 36 |
1174739 | 1174739 | 2021-03-31 | Washington | Kentucky | 21229 | 1395 | 36 |
1171492 | 1171492 | 2021-03-30 | Washington | Kentucky | 21229 | 1395 | 36 |
1168244 | 1168244 | 2021-03-29 | Washington | Kentucky | 21229 | 1393 | 35 |
1164996 | 1164996 | 2021-03-28 | Washington | Kentucky | 21229 | 1393 | 35 |
1161748 | 1161748 | 2021-03-27 | Washington | Kentucky | 21229 | 1393 | 35 |
1158500 | 1158500 | 2021-03-26 | Washington | Kentucky | 21229 | 1391 | 35 |
1155253 | 1155253 | 2021-03-25 | Washington | Kentucky | 21229 | 1389 | 35 |
1152006 | 1152006 | 2021-03-24 | Washington | Kentucky | 21229 | 1387 | 34 |
1148759 | 1148759 | 2021-03-23 | Washington | Kentucky | 21229 | 1388 | 33 |
1145512 | 1145512 | 2021-03-22 | Washington | Kentucky | 21229 | 1385 | 33 |
1142265 | 1142265 | 2021-03-21 | Washington | Kentucky | 21229 | 1383 | 33 |
1139019 | 1139019 | 2021-03-20 | Washington | Kentucky | 21229 | 1383 | 32 |
1135773 | 1135773 | 2021-03-19 | Washington | Kentucky | 21229 | 1381 | 32 |
1132526 | 1132526 | 2021-03-18 | Washington | Kentucky | 21229 | 1379 | 32 |
1129278 | 1129278 | 2021-03-17 | Washington | Kentucky | 21229 | 1378 | 31 |
1126032 | 1126032 | 2021-03-16 | Washington | Kentucky | 21229 | 1375 | 31 |
1122786 | 1122786 | 2021-03-15 | Washington | Kentucky | 21229 | 1373 | 31 |
1119539 | 1119539 | 2021-03-14 | Washington | Kentucky | 21229 | 1372 | 31 |
1116292 | 1116292 | 2021-03-13 | Washington | Kentucky | 21229 | 1371 | 31 |
1113046 | 1113046 | 2021-03-12 | Washington | Kentucky | 21229 | 1370 | 31 |
1109800 | 1109800 | 2021-03-11 | Washington | Kentucky | 21229 | 1368 | 31 |
1106554 | 1106554 | 2021-03-10 | Washington | Kentucky | 21229 | 1366 | 31 |
1103308 | 1103308 | 2021-03-09 | Washington | Kentucky | 21229 | 1363 | 30 |
1100062 | 1100062 | 2021-03-08 | Washington | Kentucky | 21229 | 1357 | 30 |
1096814 | 1096814 | 2021-03-07 | Washington | Kentucky | 21229 | 1355 | 30 |
1093568 | 1093568 | 2021-03-06 | Washington | Kentucky | 21229 | 1354 | 30 |
1090322 | 1090322 | 2021-03-05 | Washington | Kentucky | 21229 | 1350 | 30 |
1087077 | 1087077 | 2021-03-04 | Washington | Kentucky | 21229 | 1343 | 30 |
1083831 | 1083831 | 2021-03-03 | Washington | Kentucky | 21229 | 1340 | 30 |
1080585 | 1080585 | 2021-03-02 | Washington | Kentucky | 21229 | 1337 | 30 |
1077340 | 1077340 | 2021-03-01 | Washington | Kentucky | 21229 | 1331 | 30 |
1074094 | 1074094 | 2021-02-28 | Washington | Kentucky | 21229 | 1330 | 30 |
1070848 | 1070848 | 2021-02-27 | Washington | Kentucky | 21229 | 1330 | 29 |
1067603 | 1067603 | 2021-02-26 | Washington | Kentucky | 21229 | 1327 | 29 |
1064358 | 1064358 | 2021-02-25 | Washington | Kentucky | 21229 | 1324 | 29 |
1061113 | 1061113 | 2021-02-24 | Washington | Kentucky | 21229 | 1320 | 29 |
1057867 | 1057867 | 2021-02-23 | Washington | Kentucky | 21229 | 1317 | 29 |
1054621 | 1054621 | 2021-02-22 | Washington | Kentucky | 21229 | 1308 | 29 |
1051374 | 1051374 | 2021-02-21 | Washington | Kentucky | 21229 | 1305 | 29 |
1048127 | 1048127 | 2021-02-20 | Washington | Kentucky | 21229 | 1299 | 29 |
1044882 | 1044882 | 2021-02-19 | Washington | Kentucky | 21229 | 1295 | 29 |
1041637 | 1041637 | 2021-02-18 | Washington | Kentucky | 21229 | 1288 | 28 |
1038392 | 1038392 | 2021-02-17 | Washington | Kentucky | 21229 | 1284 | 28 |
1035147 | 1035147 | 2021-02-16 | Washington | Kentucky | 21229 | 1282 | 28 |
1031901 | 1031901 | 2021-02-15 | Washington | Kentucky | 21229 | 1280 | 28 |
1028654 | 1028654 | 2021-02-14 | Washington | Kentucky | 21229 | 1279 | 28 |
1025409 | 1025409 | 2021-02-13 | Washington | Kentucky | 21229 | 1272 | 28 |
1022164 | 1022164 | 2021-02-12 | Washington | Kentucky | 21229 | 1266 | 28 |
1018919 | 1018919 | 2021-02-11 | Washington | Kentucky | 21229 | 1260 | 27 |
1015674 | 1015674 | 2021-02-10 | Washington | Kentucky | 21229 | 1248 | 27 |
1012429 | 1012429 | 2021-02-09 | Washington | Kentucky | 21229 | 1243 | 27 |
1009183 | 1009183 | 2021-02-08 | Washington | Kentucky | 21229 | 1234 | 25 |
1005937 | 1005937 | 2021-02-07 | Washington | Kentucky | 21229 | 1230 | 24 |
1002691 | 1002691 | 2021-02-06 | Washington | Kentucky | 21229 | 1228 | 24 |
999445 | 999445 | 2021-02-05 | Washington | Kentucky | 21229 | 1221 | 24 |
996199 | 996199 | 2021-02-04 | Washington | Kentucky | 21229 | 1213 | 24 |
992953 | 992953 | 2021-02-03 | Washington | Kentucky | 21229 | 1187 | 24 |
989707 | 989707 | 2021-02-02 | Washington | Kentucky | 21229 | 1182 | 23 |
986460 | 986460 | 2021-02-01 | Washington | Kentucky | 21229 | 1173 | 23 |
983213 | 983213 | 2021-01-31 | Washington | Kentucky | 21229 | 1167 | 23 |
979967 | 979967 | 2021-01-30 | Washington | Kentucky | 21229 | 1165 | 22 |
976721 | 976721 | 2021-01-29 | Washington | Kentucky | 21229 | 1153 | 22 |
973476 | 973476 | 2021-01-28 | Washington | Kentucky | 21229 | 1142 | 22 |
970231 | 970231 | 2021-01-27 | Washington | Kentucky | 21229 | 1130 | 18 |
966987 | 966987 | 2021-01-26 | Washington | Kentucky | 21229 | 1118 | 18 |
963742 | 963742 | 2021-01-25 | Washington | Kentucky | 21229 | 1110 | 18 |
960497 | 960497 | 2021-01-24 | Washington | Kentucky | 21229 | 1108 | 17 |
957251 | 957251 | 2021-01-23 | Washington | Kentucky | 21229 | 1099 | 16 |
954006 | 954006 | 2021-01-22 | Washington | Kentucky | 21229 | 1079 | 16 |
950761 | 950761 | 2021-01-21 | Washington | Kentucky | 21229 | 1076 | 16 |
947515 | 947515 | 2021-01-20 | Washington | Kentucky | 21229 | 1050 | 16 |
944268 | 944268 | 2021-01-19 | Washington | Kentucky | 21229 | 1039 | 16 |
941023 | 941023 | 2021-01-18 | Washington | Kentucky | 21229 | 1038 | 16 |
937778 | 937778 | 2021-01-17 | Washington | Kentucky | 21229 | 1034 | 16 |
934533 | 934533 | 2021-01-16 | Washington | Kentucky | 21229 | 1024 | 16 |
931288 | 931288 | 2021-01-15 | Washington | Kentucky | 21229 | 1014 | 16 |
928043 | 928043 | 2021-01-14 | Washington | Kentucky | 21229 | 1002 | 14 |
924797 | 924797 | 2021-01-13 | Washington | Kentucky | 21229 | 991 | 14 |
921552 | 921552 | 2021-01-12 | Washington | Kentucky | 21229 | 971 | 12 |
918307 | 918307 | 2021-01-11 | Washington | Kentucky | 21229 | 962 | 12 |
915062 | 915062 | 2021-01-10 | Washington | Kentucky | 21229 | 959 | 12 |
911817 | 911817 | 2021-01-09 | Washington | Kentucky | 21229 | 953 | 12 |
908572 | 908572 | 2021-01-08 | Washington | Kentucky | 21229 | 939 | 12 |
905326 | 905326 | 2021-01-07 | Washington | Kentucky | 21229 | 931 | 12 |
902081 | 902081 | 2021-01-06 | Washington | Kentucky | 21229 | 920 | 12 |
898836 | 898836 | 2021-01-05 | Washington | Kentucky | 21229 | 899 | 11 |
895591 | 895591 | 2021-01-04 | Washington | Kentucky | 21229 | 892 | 11 |
892344 | 892344 | 2021-01-03 | Washington | Kentucky | 21229 | 889 | 11 |
889098 | 889098 | 2021-01-02 | Washington | Kentucky | 21229 | 886 | 11 |
885852 | 885852 | 2021-01-01 | Washington | Kentucky | 21229 | 869 | 9 |
882607 | 882607 | 2020-12-31 | Washington | Kentucky | 21229 | 869 | 9 |
879362 | 879362 | 2020-12-30 | Washington | Kentucky | 21229 | 869 | 9 |
876117 | 876117 | 2020-12-29 | Washington | Kentucky | 21229 | 860 | 9 |
872872 | 872872 | 2020-12-28 | Washington | Kentucky | 21229 | 850 | 9 |
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);