ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Washington" and fips = 50023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1196028 | 1196028 | 2021-04-06 | Washington | Vermont | 50023 | 1649 | 15 |
1192780 | 1192780 | 2021-04-05 | Washington | Vermont | 50023 | 1644 | 15 |
1189531 | 1189531 | 2021-04-04 | Washington | Vermont | 50023 | 1639 | 15 |
1186284 | 1186284 | 2021-04-03 | Washington | Vermont | 50023 | 1630 | 15 |
1183037 | 1183037 | 2021-04-02 | Washington | Vermont | 50023 | 1622 | 15 |
1179790 | 1179790 | 2021-04-01 | Washington | Vermont | 50023 | 1611 | 15 |
1176543 | 1176543 | 2021-03-31 | Washington | Vermont | 50023 | 1604 | 15 |
1173296 | 1173296 | 2021-03-30 | Washington | Vermont | 50023 | 1596 | 14 |
1170049 | 1170049 | 2021-03-29 | Washington | Vermont | 50023 | 1596 | 14 |
1166801 | 1166801 | 2021-03-28 | Washington | Vermont | 50023 | 1587 | 14 |
1163553 | 1163553 | 2021-03-27 | Washington | Vermont | 50023 | 1577 | 14 |
1160304 | 1160304 | 2021-03-26 | Washington | Vermont | 50023 | 1574 | 14 |
1157057 | 1157057 | 2021-03-25 | Washington | Vermont | 50023 | 1564 | 14 |
1153810 | 1153810 | 2021-03-24 | Washington | Vermont | 50023 | 1562 | 14 |
1150563 | 1150563 | 2021-03-23 | Washington | Vermont | 50023 | 1557 | 14 |
1147316 | 1147316 | 2021-03-22 | Washington | Vermont | 50023 | 1553 | 14 |
1144069 | 1144069 | 2021-03-21 | Washington | Vermont | 50023 | 1551 | 14 |
1140822 | 1140822 | 2021-03-20 | Washington | Vermont | 50023 | 1544 | 14 |
1137576 | 1137576 | 2021-03-19 | Washington | Vermont | 50023 | 1537 | 14 |
1134330 | 1134330 | 2021-03-18 | Washington | Vermont | 50023 | 1530 | 14 |
1131082 | 1131082 | 2021-03-17 | Washington | Vermont | 50023 | 1532 | 14 |
1127835 | 1127835 | 2021-03-16 | Washington | Vermont | 50023 | 1531 | 14 |
1124589 | 1124589 | 2021-03-15 | Washington | Vermont | 50023 | 1529 | 14 |
1121343 | 1121343 | 2021-03-14 | Washington | Vermont | 50023 | 1523 | 14 |
1118096 | 1118096 | 2021-03-13 | Washington | Vermont | 50023 | 1518 | 14 |
1114849 | 1114849 | 2021-03-12 | Washington | Vermont | 50023 | 1513 | 14 |
1111603 | 1111603 | 2021-03-11 | Washington | Vermont | 50023 | 1501 | 14 |
1108357 | 1108357 | 2021-03-10 | Washington | Vermont | 50023 | 1492 | 14 |
1105111 | 1105111 | 2021-03-09 | Washington | Vermont | 50023 | 1489 | 14 |
1101865 | 1101865 | 2021-03-08 | Washington | Vermont | 50023 | 1480 | 14 |
1098619 | 1098619 | 2021-03-07 | Washington | Vermont | 50023 | 1467 | 14 |
1095371 | 1095371 | 2021-03-06 | Washington | Vermont | 50023 | 1457 | 14 |
1092125 | 1092125 | 2021-03-05 | Washington | Vermont | 50023 | 1455 | 14 |
1088879 | 1088879 | 2021-03-04 | Washington | Vermont | 50023 | 1448 | 14 |
1085634 | 1085634 | 2021-03-03 | Washington | Vermont | 50023 | 1445 | 14 |
1082388 | 1082388 | 2021-03-02 | Washington | Vermont | 50023 | 1444 | 14 |
1079142 | 1079142 | 2021-03-01 | Washington | Vermont | 50023 | 1442 | 14 |
1075897 | 1075897 | 2021-02-28 | Washington | Vermont | 50023 | 1440 | 13 |
1072651 | 1072651 | 2021-02-27 | Washington | Vermont | 50023 | 1432 | 13 |
1069405 | 1069405 | 2021-02-26 | Washington | Vermont | 50023 | 1433 | 13 |
1066160 | 1066160 | 2021-02-25 | Washington | Vermont | 50023 | 1429 | 13 |
1062915 | 1062915 | 2021-02-24 | Washington | Vermont | 50023 | 1427 | 13 |
1059670 | 1059670 | 2021-02-23 | Washington | Vermont | 50023 | 1427 | 13 |
1056424 | 1056424 | 2021-02-22 | Washington | Vermont | 50023 | 1424 | 13 |
1053178 | 1053178 | 2021-02-21 | Washington | Vermont | 50023 | 1416 | 13 |
1049931 | 1049931 | 2021-02-20 | Washington | Vermont | 50023 | 1406 | 13 |
1046684 | 1046684 | 2021-02-19 | Washington | Vermont | 50023 | 1404 | 13 |
1043439 | 1043439 | 2021-02-18 | Washington | Vermont | 50023 | 1400 | 13 |
1040194 | 1040194 | 2021-02-17 | Washington | Vermont | 50023 | 1384 | 12 |
1036949 | 1036949 | 2021-02-16 | Washington | Vermont | 50023 | 1378 | 12 |
1033704 | 1033704 | 2021-02-15 | Washington | Vermont | 50023 | 1377 | 12 |
1030458 | 1030458 | 2021-02-14 | Washington | Vermont | 50023 | 1358 | 12 |
1027211 | 1027211 | 2021-02-13 | Washington | Vermont | 50023 | 1350 | 12 |
1023966 | 1023966 | 2021-02-12 | Washington | Vermont | 50023 | 1332 | 12 |
1020721 | 1020721 | 2021-02-11 | Washington | Vermont | 50023 | 1314 | 12 |
1017476 | 1017476 | 2021-02-10 | Washington | Vermont | 50023 | 1324 | 12 |
1014231 | 1014231 | 2021-02-09 | Washington | Vermont | 50023 | 1324 | 12 |
1010986 | 1010986 | 2021-02-08 | Washington | Vermont | 50023 | 1325 | 12 |
1007740 | 1007740 | 2021-02-07 | Washington | Vermont | 50023 | 1310 | 12 |
1004494 | 1004494 | 2021-02-06 | Washington | Vermont | 50023 | 1294 | 12 |
1001248 | 1001248 | 2021-02-05 | Washington | Vermont | 50023 | 1276 | 12 |
998002 | 998002 | 2021-02-04 | Washington | Vermont | 50023 | 1270 | 12 |
994756 | 994756 | 2021-02-03 | Washington | Vermont | 50023 | 1254 | 12 |
991510 | 991510 | 2021-02-02 | Washington | Vermont | 50023 | 1234 | 12 |
988264 | 988264 | 2021-02-01 | Washington | Vermont | 50023 | 1225 | 12 |
985017 | 985017 | 2021-01-31 | Washington | Vermont | 50023 | 1217 | 12 |
981770 | 981770 | 2021-01-30 | Washington | Vermont | 50023 | 1212 | 12 |
978524 | 978524 | 2021-01-29 | Washington | Vermont | 50023 | 1200 | 12 |
975279 | 975279 | 2021-01-28 | Washington | Vermont | 50023 | 1183 | 12 |
972034 | 972034 | 2021-01-27 | Washington | Vermont | 50023 | 1166 | 12 |
968789 | 968789 | 2021-01-26 | Washington | Vermont | 50023 | 1154 | 12 |
965545 | 965545 | 2021-01-25 | Washington | Vermont | 50023 | 1115 | 12 |
962300 | 962300 | 2021-01-24 | Washington | Vermont | 50023 | 1107 | 12 |
959055 | 959055 | 2021-01-23 | Washington | Vermont | 50023 | 1092 | 12 |
955809 | 955809 | 2021-01-22 | Washington | Vermont | 50023 | 1081 | 12 |
952564 | 952564 | 2021-01-21 | Washington | Vermont | 50023 | 1064 | 12 |
949319 | 949319 | 2021-01-20 | Washington | Vermont | 50023 | 1051 | 11 |
946073 | 946073 | 2021-01-19 | Washington | Vermont | 50023 | 1042 | 11 |
942826 | 942826 | 2021-01-18 | Washington | Vermont | 50023 | 1035 | 11 |
939581 | 939581 | 2021-01-17 | Washington | Vermont | 50023 | 1017 | 11 |
936336 | 936336 | 2021-01-16 | Washington | Vermont | 50023 | 1002 | 11 |
933091 | 933091 | 2021-01-15 | Washington | Vermont | 50023 | 991 | 11 |
929846 | 929846 | 2021-01-14 | Washington | Vermont | 50023 | 974 | 11 |
926601 | 926601 | 2021-01-13 | Washington | Vermont | 50023 | 968 | 10 |
923355 | 923355 | 2021-01-12 | Washington | Vermont | 50023 | 962 | 10 |
920110 | 920110 | 2021-01-11 | Washington | Vermont | 50023 | 944 | 10 |
916865 | 916865 | 2021-01-10 | Washington | Vermont | 50023 | 943 | 10 |
913620 | 913620 | 2021-01-09 | Washington | Vermont | 50023 | 935 | 10 |
910375 | 910375 | 2021-01-08 | Washington | Vermont | 50023 | 925 | 10 |
907130 | 907130 | 2021-01-07 | Washington | Vermont | 50023 | 917 | 10 |
903884 | 903884 | 2021-01-06 | Washington | Vermont | 50023 | 905 | 10 |
900639 | 900639 | 2021-01-05 | Washington | Vermont | 50023 | 901 | 10 |
897394 | 897394 | 2021-01-04 | Washington | Vermont | 50023 | 899 | 9 |
894148 | 894148 | 2021-01-03 | Washington | Vermont | 50023 | 897 | 9 |
890902 | 890902 | 2021-01-02 | Washington | Vermont | 50023 | 886 | 9 |
887655 | 887655 | 2021-01-01 | Washington | Vermont | 50023 | 884 | 9 |
884410 | 884410 | 2020-12-31 | Washington | Vermont | 50023 | 884 | 9 |
881165 | 881165 | 2020-12-30 | Washington | Vermont | 50023 | 876 | 9 |
877920 | 877920 | 2020-12-29 | Washington | Vermont | 50023 | 872 | 9 |
874675 | 874675 | 2020-12-28 | Washington | Vermont | 50023 | 871 | 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);