ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and fips = 17189 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193804 | 1193804 | 2021-04-06 | Washington | Illinois | 17189 | 1617 | 31 |
1190554 | 1190554 | 2021-04-05 | Washington | Illinois | 17189 | 1616 | 31 |
1187307 | 1187307 | 2021-04-04 | Washington | Illinois | 17189 | 1616 | 31 |
1184060 | 1184060 | 2021-04-03 | Washington | Illinois | 17189 | 1616 | 31 |
1180813 | 1180813 | 2021-04-02 | Washington | Illinois | 17189 | 1615 | 31 |
1177566 | 1177566 | 2021-04-01 | Washington | Illinois | 17189 | 1614 | 31 |
1174319 | 1174319 | 2021-03-31 | Washington | Illinois | 17189 | 1613 | 31 |
1171072 | 1171072 | 2021-03-30 | Washington | Illinois | 17189 | 1609 | 31 |
1167824 | 1167824 | 2021-03-29 | Washington | Illinois | 17189 | 1609 | 31 |
1164576 | 1164576 | 2021-03-28 | Washington | Illinois | 17189 | 1608 | 31 |
1161328 | 1161328 | 2021-03-27 | Washington | Illinois | 17189 | 1608 | 31 |
1158080 | 1158080 | 2021-03-26 | Washington | Illinois | 17189 | 1607 | 31 |
1154833 | 1154833 | 2021-03-25 | Washington | Illinois | 17189 | 1607 | 31 |
1151586 | 1151586 | 2021-03-24 | Washington | Illinois | 17189 | 1607 | 31 |
1148339 | 1148339 | 2021-03-23 | Washington | Illinois | 17189 | 1605 | 31 |
1145092 | 1145092 | 2021-03-22 | Washington | Illinois | 17189 | 1603 | 31 |
1141845 | 1141845 | 2021-03-21 | Washington | Illinois | 17189 | 1602 | 31 |
1138599 | 1138599 | 2021-03-20 | Washington | Illinois | 17189 | 1602 | 31 |
1135353 | 1135353 | 2021-03-19 | Washington | Illinois | 17189 | 1601 | 31 |
1132106 | 1132106 | 2021-03-18 | Washington | Illinois | 17189 | 1599 | 31 |
1128858 | 1128858 | 2021-03-17 | Washington | Illinois | 17189 | 1599 | 31 |
1125612 | 1125612 | 2021-03-16 | Washington | Illinois | 17189 | 1597 | 31 |
1122366 | 1122366 | 2021-03-15 | Washington | Illinois | 17189 | 1597 | 31 |
1119119 | 1119119 | 2021-03-14 | Washington | Illinois | 17189 | 1597 | 31 |
1115872 | 1115872 | 2021-03-13 | Washington | Illinois | 17189 | 1595 | 31 |
1112626 | 1112626 | 2021-03-12 | Washington | Illinois | 17189 | 1594 | 31 |
1109380 | 1109380 | 2021-03-11 | Washington | Illinois | 17189 | 1593 | 30 |
1106134 | 1106134 | 2021-03-10 | Washington | Illinois | 17189 | 1591 | 30 |
1102888 | 1102888 | 2021-03-09 | Washington | Illinois | 17189 | 1590 | 30 |
1099642 | 1099642 | 2021-03-08 | Washington | Illinois | 17189 | 1588 | 30 |
1096394 | 1096394 | 2021-03-07 | Washington | Illinois | 17189 | 1588 | 30 |
1093148 | 1093148 | 2021-03-06 | Washington | Illinois | 17189 | 1587 | 30 |
1089902 | 1089902 | 2021-03-05 | Washington | Illinois | 17189 | 1587 | 30 |
1086657 | 1086657 | 2021-03-04 | Washington | Illinois | 17189 | 1587 | 30 |
1083411 | 1083411 | 2021-03-03 | Washington | Illinois | 17189 | 1587 | 30 |
1080165 | 1080165 | 2021-03-02 | Washington | Illinois | 17189 | 1586 | 29 |
1076920 | 1076920 | 2021-03-01 | Washington | Illinois | 17189 | 1584 | 29 |
1073674 | 1073674 | 2021-02-28 | Washington | Illinois | 17189 | 1583 | 29 |
1070428 | 1070428 | 2021-02-27 | Washington | Illinois | 17189 | 1582 | 29 |
1067183 | 1067183 | 2021-02-26 | Washington | Illinois | 17189 | 1580 | 29 |
1063938 | 1063938 | 2021-02-25 | Washington | Illinois | 17189 | 1578 | 29 |
1060693 | 1060693 | 2021-02-24 | Washington | Illinois | 17189 | 1574 | 29 |
1057447 | 1057447 | 2021-02-23 | Washington | Illinois | 17189 | 1572 | 29 |
1054201 | 1054201 | 2021-02-22 | Washington | Illinois | 17189 | 1570 | 29 |
1050954 | 1050954 | 2021-02-21 | Washington | Illinois | 17189 | 1570 | 29 |
1047707 | 1047707 | 2021-02-20 | Washington | Illinois | 17189 | 1570 | 29 |
1044462 | 1044462 | 2021-02-19 | Washington | Illinois | 17189 | 1568 | 29 |
1041217 | 1041217 | 2021-02-18 | Washington | Illinois | 17189 | 1566 | 29 |
1037972 | 1037972 | 2021-02-17 | Washington | Illinois | 17189 | 1565 | 29 |
1034727 | 1034727 | 2021-02-16 | Washington | Illinois | 17189 | 1563 | 29 |
1031481 | 1031481 | 2021-02-15 | Washington | Illinois | 17189 | 1562 | 29 |
1028234 | 1028234 | 2021-02-14 | Washington | Illinois | 17189 | 1562 | 29 |
1024989 | 1024989 | 2021-02-13 | Washington | Illinois | 17189 | 1559 | 29 |
1021744 | 1021744 | 2021-02-12 | Washington | Illinois | 17189 | 1559 | 29 |
1018499 | 1018499 | 2021-02-11 | Washington | Illinois | 17189 | 1553 | 29 |
1015254 | 1015254 | 2021-02-10 | Washington | Illinois | 17189 | 1550 | 28 |
1012009 | 1012009 | 2021-02-09 | Washington | Illinois | 17189 | 1550 | 28 |
1008763 | 1008763 | 2021-02-08 | Washington | Illinois | 17189 | 1550 | 28 |
1005517 | 1005517 | 2021-02-07 | Washington | Illinois | 17189 | 1548 | 27 |
1002271 | 1002271 | 2021-02-06 | Washington | Illinois | 17189 | 1546 | 27 |
999025 | 999025 | 2021-02-05 | Washington | Illinois | 17189 | 1543 | 27 |
995779 | 995779 | 2021-02-04 | Washington | Illinois | 17189 | 1540 | 27 |
992533 | 992533 | 2021-02-03 | Washington | Illinois | 17189 | 1535 | 27 |
989287 | 989287 | 2021-02-02 | Washington | Illinois | 17189 | 1526 | 27 |
986040 | 986040 | 2021-02-01 | Washington | Illinois | 17189 | 1524 | 27 |
982793 | 982793 | 2021-01-31 | Washington | Illinois | 17189 | 1523 | 26 |
979547 | 979547 | 2021-01-30 | Washington | Illinois | 17189 | 1521 | 26 |
976301 | 976301 | 2021-01-29 | Washington | Illinois | 17189 | 1519 | 26 |
973056 | 973056 | 2021-01-28 | Washington | Illinois | 17189 | 1514 | 26 |
969811 | 969811 | 2021-01-27 | Washington | Illinois | 17189 | 1511 | 26 |
966567 | 966567 | 2021-01-26 | Washington | Illinois | 17189 | 1504 | 26 |
963322 | 963322 | 2021-01-25 | Washington | Illinois | 17189 | 1498 | 26 |
960077 | 960077 | 2021-01-24 | Washington | Illinois | 17189 | 1493 | 26 |
956831 | 956831 | 2021-01-23 | Washington | Illinois | 17189 | 1490 | 26 |
953586 | 953586 | 2021-01-22 | Washington | Illinois | 17189 | 1485 | 26 |
950341 | 950341 | 2021-01-21 | Washington | Illinois | 17189 | 1469 | 25 |
947095 | 947095 | 2021-01-20 | Washington | Illinois | 17189 | 1459 | 25 |
943848 | 943848 | 2021-01-19 | Washington | Illinois | 17189 | 1452 | 25 |
940603 | 940603 | 2021-01-18 | Washington | Illinois | 17189 | 1446 | 25 |
937358 | 937358 | 2021-01-17 | Washington | Illinois | 17189 | 1443 | 25 |
934113 | 934113 | 2021-01-16 | Washington | Illinois | 17189 | 1440 | 25 |
930868 | 930868 | 2021-01-15 | Washington | Illinois | 17189 | 1432 | 25 |
927623 | 927623 | 2021-01-14 | Washington | Illinois | 17189 | 1423 | 25 |
924377 | 924377 | 2021-01-13 | Washington | Illinois | 17189 | 1412 | 25 |
921132 | 921132 | 2021-01-12 | Washington | Illinois | 17189 | 1392 | 25 |
917887 | 917887 | 2021-01-11 | Washington | Illinois | 17189 | 1377 | 25 |
914642 | 914642 | 2021-01-10 | Washington | Illinois | 17189 | 1371 | 25 |
911397 | 911397 | 2021-01-09 | Washington | Illinois | 17189 | 1362 | 25 |
908152 | 908152 | 2021-01-08 | Washington | Illinois | 17189 | 1346 | 24 |
904906 | 904906 | 2021-01-07 | Washington | Illinois | 17189 | 1323 | 24 |
901661 | 901661 | 2021-01-06 | Washington | Illinois | 17189 | 1313 | 24 |
898416 | 898416 | 2021-01-05 | Washington | Illinois | 17189 | 1290 | 24 |
895171 | 895171 | 2021-01-04 | Washington | Illinois | 17189 | 1271 | 24 |
891924 | 891924 | 2021-01-03 | Washington | Illinois | 17189 | 1266 | 24 |
888678 | 888678 | 2021-01-02 | Washington | Illinois | 17189 | 1254 | 25 |
885432 | 885432 | 2021-01-01 | Washington | Illinois | 17189 | 1225 | 24 |
882187 | 882187 | 2020-12-31 | Washington | Illinois | 17189 | 1225 | 24 |
878942 | 878942 | 2020-12-30 | Washington | Illinois | 17189 | 1203 | 23 |
875697 | 875697 | 2020-12-29 | Washington | Illinois | 17189 | 1181 | 23 |
872452 | 872452 | 2020-12-28 | Washington | Illinois | 17189 | 1172 | 21 |
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);