ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where county = "Wayne" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193805 | 1193805 | 2021-04-06 | Wayne | Illinois | 17191 | 1713 | 51 |
1190555 | 1190555 | 2021-04-05 | Wayne | Illinois | 17191 | 1712 | 51 |
1187308 | 1187308 | 2021-04-04 | Wayne | Illinois | 17191 | 1710 | 51 |
1184061 | 1184061 | 2021-04-03 | Wayne | Illinois | 17191 | 1709 | 51 |
1180814 | 1180814 | 2021-04-02 | Wayne | Illinois | 17191 | 1709 | 51 |
1177567 | 1177567 | 2021-04-01 | Wayne | Illinois | 17191 | 1709 | 51 |
1174320 | 1174320 | 2021-03-31 | Wayne | Illinois | 17191 | 1708 | 51 |
1171073 | 1171073 | 2021-03-30 | Wayne | Illinois | 17191 | 1707 | 51 |
1167825 | 1167825 | 2021-03-29 | Wayne | Illinois | 17191 | 1706 | 50 |
1164577 | 1164577 | 2021-03-28 | Wayne | Illinois | 17191 | 1704 | 50 |
1161329 | 1161329 | 2021-03-27 | Wayne | Illinois | 17191 | 1704 | 50 |
1158081 | 1158081 | 2021-03-26 | Wayne | Illinois | 17191 | 1703 | 50 |
1154834 | 1154834 | 2021-03-25 | Wayne | Illinois | 17191 | 1703 | 50 |
1151587 | 1151587 | 2021-03-24 | Wayne | Illinois | 17191 | 1702 | 50 |
1148340 | 1148340 | 2021-03-23 | Wayne | Illinois | 17191 | 1701 | 50 |
1145093 | 1145093 | 2021-03-22 | Wayne | Illinois | 17191 | 1698 | 50 |
1141846 | 1141846 | 2021-03-21 | Wayne | Illinois | 17191 | 1698 | 50 |
1138600 | 1138600 | 2021-03-20 | Wayne | Illinois | 17191 | 1698 | 50 |
1135354 | 1135354 | 2021-03-19 | Wayne | Illinois | 17191 | 1697 | 50 |
1132107 | 1132107 | 2021-03-18 | Wayne | Illinois | 17191 | 1695 | 50 |
1128859 | 1128859 | 2021-03-17 | Wayne | Illinois | 17191 | 1694 | 50 |
1125613 | 1125613 | 2021-03-16 | Wayne | Illinois | 17191 | 1694 | 50 |
1122367 | 1122367 | 2021-03-15 | Wayne | Illinois | 17191 | 1694 | 50 |
1119120 | 1119120 | 2021-03-14 | Wayne | Illinois | 17191 | 1694 | 50 |
1115873 | 1115873 | 2021-03-13 | Wayne | Illinois | 17191 | 1695 | 50 |
1112627 | 1112627 | 2021-03-12 | Wayne | Illinois | 17191 | 1695 | 50 |
1109381 | 1109381 | 2021-03-11 | Wayne | Illinois | 17191 | 1695 | 50 |
1106135 | 1106135 | 2021-03-10 | Wayne | Illinois | 17191 | 1694 | 50 |
1102889 | 1102889 | 2021-03-09 | Wayne | Illinois | 17191 | 1692 | 50 |
1099643 | 1099643 | 2021-03-08 | Wayne | Illinois | 17191 | 1692 | 50 |
1096395 | 1096395 | 2021-03-07 | Wayne | Illinois | 17191 | 1692 | 50 |
1093149 | 1093149 | 2021-03-06 | Wayne | Illinois | 17191 | 1690 | 50 |
1089903 | 1089903 | 2021-03-05 | Wayne | Illinois | 17191 | 1688 | 50 |
1086658 | 1086658 | 2021-03-04 | Wayne | Illinois | 17191 | 1687 | 50 |
1083412 | 1083412 | 2021-03-03 | Wayne | Illinois | 17191 | 1683 | 50 |
1080166 | 1080166 | 2021-03-02 | Wayne | Illinois | 17191 | 1682 | 50 |
1076921 | 1076921 | 2021-03-01 | Wayne | Illinois | 17191 | 1674 | 49 |
1073675 | 1073675 | 2021-02-28 | Wayne | Illinois | 17191 | 1674 | 49 |
1070429 | 1070429 | 2021-02-27 | Wayne | Illinois | 17191 | 1671 | 49 |
1067184 | 1067184 | 2021-02-26 | Wayne | Illinois | 17191 | 1669 | 49 |
1063939 | 1063939 | 2021-02-25 | Wayne | Illinois | 17191 | 1667 | 49 |
1060694 | 1060694 | 2021-02-24 | Wayne | Illinois | 17191 | 1663 | 49 |
1057448 | 1057448 | 2021-02-23 | Wayne | Illinois | 17191 | 1662 | 49 |
1054202 | 1054202 | 2021-02-22 | Wayne | Illinois | 17191 | 1662 | 49 |
1050955 | 1050955 | 2021-02-21 | Wayne | Illinois | 17191 | 1662 | 49 |
1047708 | 1047708 | 2021-02-20 | Wayne | Illinois | 17191 | 1662 | 48 |
1044463 | 1044463 | 2021-02-19 | Wayne | Illinois | 17191 | 1656 | 47 |
1041218 | 1041218 | 2021-02-18 | Wayne | Illinois | 17191 | 1656 | 46 |
1037973 | 1037973 | 2021-02-17 | Wayne | Illinois | 17191 | 1653 | 46 |
1034728 | 1034728 | 2021-02-16 | Wayne | Illinois | 17191 | 1654 | 46 |
1031482 | 1031482 | 2021-02-15 | Wayne | Illinois | 17191 | 1649 | 46 |
1028235 | 1028235 | 2021-02-14 | Wayne | Illinois | 17191 | 1647 | 46 |
1024990 | 1024990 | 2021-02-13 | Wayne | Illinois | 17191 | 1647 | 46 |
1021745 | 1021745 | 2021-02-12 | Wayne | Illinois | 17191 | 1645 | 45 |
1018500 | 1018500 | 2021-02-11 | Wayne | Illinois | 17191 | 1642 | 45 |
1015255 | 1015255 | 2021-02-10 | Wayne | Illinois | 17191 | 1637 | 45 |
1012010 | 1012010 | 2021-02-09 | Wayne | Illinois | 17191 | 1632 | 45 |
1008764 | 1008764 | 2021-02-08 | Wayne | Illinois | 17191 | 1631 | 45 |
1005518 | 1005518 | 2021-02-07 | Wayne | Illinois | 17191 | 1625 | 45 |
1002272 | 1002272 | 2021-02-06 | Wayne | Illinois | 17191 | 1620 | 45 |
999026 | 999026 | 2021-02-05 | Wayne | Illinois | 17191 | 1613 | 45 |
995780 | 995780 | 2021-02-04 | Wayne | Illinois | 17191 | 1605 | 45 |
992534 | 992534 | 2021-02-03 | Wayne | Illinois | 17191 | 1600 | 44 |
989288 | 989288 | 2021-02-02 | Wayne | Illinois | 17191 | 1589 | 44 |
986041 | 986041 | 2021-02-01 | Wayne | Illinois | 17191 | 1586 | 44 |
982794 | 982794 | 2021-01-31 | Wayne | Illinois | 17191 | 1577 | 44 |
979548 | 979548 | 2021-01-30 | Wayne | Illinois | 17191 | 1576 | 44 |
976302 | 976302 | 2021-01-29 | Wayne | Illinois | 17191 | 1569 | 44 |
973057 | 973057 | 2021-01-28 | Wayne | Illinois | 17191 | 1566 | 44 |
969812 | 969812 | 2021-01-27 | Wayne | Illinois | 17191 | 1563 | 44 |
966568 | 966568 | 2021-01-26 | Wayne | Illinois | 17191 | 1556 | 43 |
963323 | 963323 | 2021-01-25 | Wayne | Illinois | 17191 | 1548 | 43 |
960078 | 960078 | 2021-01-24 | Wayne | Illinois | 17191 | 1547 | 43 |
956832 | 956832 | 2021-01-23 | Wayne | Illinois | 17191 | 1546 | 43 |
953587 | 953587 | 2021-01-22 | Wayne | Illinois | 17191 | 1535 | 43 |
950342 | 950342 | 2021-01-21 | Wayne | Illinois | 17191 | 1528 | 43 |
947096 | 947096 | 2021-01-20 | Wayne | Illinois | 17191 | 1522 | 43 |
943849 | 943849 | 2021-01-19 | Wayne | Illinois | 17191 | 1520 | 43 |
940604 | 940604 | 2021-01-18 | Wayne | Illinois | 17191 | 1511 | 43 |
937359 | 937359 | 2021-01-17 | Wayne | Illinois | 17191 | 1503 | 43 |
934114 | 934114 | 2021-01-16 | Wayne | Illinois | 17191 | 1501 | 43 |
930869 | 930869 | 2021-01-15 | Wayne | Illinois | 17191 | 1487 | 43 |
927624 | 927624 | 2021-01-14 | Wayne | Illinois | 17191 | 1480 | 43 |
924378 | 924378 | 2021-01-13 | Wayne | Illinois | 17191 | 1471 | 43 |
921133 | 921133 | 2021-01-12 | Wayne | Illinois | 17191 | 1450 | 43 |
917888 | 917888 | 2021-01-11 | Wayne | Illinois | 17191 | 1450 | 42 |
914643 | 914643 | 2021-01-10 | Wayne | Illinois | 17191 | 1436 | 42 |
911398 | 911398 | 2021-01-09 | Wayne | Illinois | 17191 | 1434 | 42 |
908153 | 908153 | 2021-01-08 | Wayne | Illinois | 17191 | 1429 | 42 |
904907 | 904907 | 2021-01-07 | Wayne | Illinois | 17191 | 1411 | 42 |
901662 | 901662 | 2021-01-06 | Wayne | Illinois | 17191 | 1392 | 42 |
898417 | 898417 | 2021-01-05 | Wayne | Illinois | 17191 | 1382 | 42 |
895172 | 895172 | 2021-01-04 | Wayne | Illinois | 17191 | 1365 | 42 |
891925 | 891925 | 2021-01-03 | Wayne | Illinois | 17191 | 1358 | 41 |
888679 | 888679 | 2021-01-02 | Wayne | Illinois | 17191 | 1354 | 41 |
885433 | 885433 | 2021-01-01 | Wayne | Illinois | 17191 | 1336 | 41 |
882188 | 882188 | 2020-12-31 | Wayne | Illinois | 17191 | 1336 | 41 |
878943 | 878943 | 2020-12-30 | Wayne | Illinois | 17191 | 1319 | 41 |
875698 | 875698 | 2020-12-29 | Wayne | Illinois | 17191 | 1309 | 41 |
872453 | 872453 | 2020-12-28 | Wayne | Illinois | 17191 | 1300 | 41 |
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);