ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Jo Daviess" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193751 | 1193751 | 2021-04-06 | Jo Daviess | Illinois | 17085 | 1699 | 26 |
1190501 | 1190501 | 2021-04-05 | Jo Daviess | Illinois | 17085 | 1697 | 26 |
1187254 | 1187254 | 2021-04-04 | Jo Daviess | Illinois | 17085 | 1696 | 26 |
1184007 | 1184007 | 2021-04-03 | Jo Daviess | Illinois | 17085 | 1692 | 26 |
1180760 | 1180760 | 2021-04-02 | Jo Daviess | Illinois | 17085 | 1691 | 25 |
1177513 | 1177513 | 2021-04-01 | Jo Daviess | Illinois | 17085 | 1688 | 25 |
1174266 | 1174266 | 2021-03-31 | Jo Daviess | Illinois | 17085 | 1682 | 25 |
1171019 | 1171019 | 2021-03-30 | Jo Daviess | Illinois | 17085 | 1678 | 25 |
1167771 | 1167771 | 2021-03-29 | Jo Daviess | Illinois | 17085 | 1677 | 25 |
1164523 | 1164523 | 2021-03-28 | Jo Daviess | Illinois | 17085 | 1673 | 25 |
1161275 | 1161275 | 2021-03-27 | Jo Daviess | Illinois | 17085 | 1664 | 25 |
1158027 | 1158027 | 2021-03-26 | Jo Daviess | Illinois | 17085 | 1654 | 25 |
1154780 | 1154780 | 2021-03-25 | Jo Daviess | Illinois | 17085 | 1651 | 25 |
1151533 | 1151533 | 2021-03-24 | Jo Daviess | Illinois | 17085 | 1649 | 25 |
1148286 | 1148286 | 2021-03-23 | Jo Daviess | Illinois | 17085 | 1643 | 25 |
1145039 | 1145039 | 2021-03-22 | Jo Daviess | Illinois | 17085 | 1639 | 25 |
1141792 | 1141792 | 2021-03-21 | Jo Daviess | Illinois | 17085 | 1636 | 25 |
1138546 | 1138546 | 2021-03-20 | Jo Daviess | Illinois | 17085 | 1634 | 25 |
1135300 | 1135300 | 2021-03-19 | Jo Daviess | Illinois | 17085 | 1631 | 25 |
1132053 | 1132053 | 2021-03-18 | Jo Daviess | Illinois | 17085 | 1631 | 25 |
1128805 | 1128805 | 2021-03-17 | Jo Daviess | Illinois | 17085 | 1631 | 25 |
1125559 | 1125559 | 2021-03-16 | Jo Daviess | Illinois | 17085 | 1629 | 25 |
1122313 | 1122313 | 2021-03-15 | Jo Daviess | Illinois | 17085 | 1629 | 25 |
1119066 | 1119066 | 2021-03-14 | Jo Daviess | Illinois | 17085 | 1628 | 25 |
1115819 | 1115819 | 2021-03-13 | Jo Daviess | Illinois | 17085 | 1627 | 25 |
1112573 | 1112573 | 2021-03-12 | Jo Daviess | Illinois | 17085 | 1626 | 25 |
1109327 | 1109327 | 2021-03-11 | Jo Daviess | Illinois | 17085 | 1621 | 25 |
1106081 | 1106081 | 2021-03-10 | Jo Daviess | Illinois | 17085 | 1620 | 25 |
1102835 | 1102835 | 2021-03-09 | Jo Daviess | Illinois | 17085 | 1618 | 25 |
1099589 | 1099589 | 2021-03-08 | Jo Daviess | Illinois | 17085 | 1616 | 25 |
1096341 | 1096341 | 2021-03-07 | Jo Daviess | Illinois | 17085 | 1616 | 25 |
1093095 | 1093095 | 2021-03-06 | Jo Daviess | Illinois | 17085 | 1615 | 25 |
1089849 | 1089849 | 2021-03-05 | Jo Daviess | Illinois | 17085 | 1614 | 25 |
1086604 | 1086604 | 2021-03-04 | Jo Daviess | Illinois | 17085 | 1609 | 25 |
1083358 | 1083358 | 2021-03-03 | Jo Daviess | Illinois | 17085 | 1608 | 25 |
1080112 | 1080112 | 2021-03-02 | Jo Daviess | Illinois | 17085 | 1606 | 25 |
1076867 | 1076867 | 2021-03-01 | Jo Daviess | Illinois | 17085 | 1605 | 25 |
1073621 | 1073621 | 2021-02-28 | Jo Daviess | Illinois | 17085 | 1605 | 25 |
1070375 | 1070375 | 2021-02-27 | Jo Daviess | Illinois | 17085 | 1605 | 25 |
1067130 | 1067130 | 2021-02-26 | Jo Daviess | Illinois | 17085 | 1605 | 25 |
1063885 | 1063885 | 2021-02-25 | Jo Daviess | Illinois | 17085 | 1605 | 25 |
1060640 | 1060640 | 2021-02-24 | Jo Daviess | Illinois | 17085 | 1602 | 25 |
1057394 | 1057394 | 2021-02-23 | Jo Daviess | Illinois | 17085 | 1598 | 25 |
1054148 | 1054148 | 2021-02-22 | Jo Daviess | Illinois | 17085 | 1595 | 25 |
1050901 | 1050901 | 2021-02-21 | Jo Daviess | Illinois | 17085 | 1593 | 25 |
1047654 | 1047654 | 2021-02-20 | Jo Daviess | Illinois | 17085 | 1593 | 25 |
1044409 | 1044409 | 2021-02-19 | Jo Daviess | Illinois | 17085 | 1593 | 25 |
1041164 | 1041164 | 2021-02-18 | Jo Daviess | Illinois | 17085 | 1591 | 25 |
1037919 | 1037919 | 2021-02-17 | Jo Daviess | Illinois | 17085 | 1589 | 25 |
1034674 | 1034674 | 2021-02-16 | Jo Daviess | Illinois | 17085 | 1583 | 25 |
1031428 | 1031428 | 2021-02-15 | Jo Daviess | Illinois | 17085 | 1582 | 25 |
1028181 | 1028181 | 2021-02-14 | Jo Daviess | Illinois | 17085 | 1583 | 25 |
1024936 | 1024936 | 2021-02-13 | Jo Daviess | Illinois | 17085 | 1581 | 25 |
1021691 | 1021691 | 2021-02-12 | Jo Daviess | Illinois | 17085 | 1581 | 25 |
1018446 | 1018446 | 2021-02-11 | Jo Daviess | Illinois | 17085 | 1578 | 25 |
1015201 | 1015201 | 2021-02-10 | Jo Daviess | Illinois | 17085 | 1575 | 25 |
1011956 | 1011956 | 2021-02-09 | Jo Daviess | Illinois | 17085 | 1572 | 25 |
1008710 | 1008710 | 2021-02-08 | Jo Daviess | Illinois | 17085 | 1571 | 25 |
1005464 | 1005464 | 2021-02-07 | Jo Daviess | Illinois | 17085 | 1571 | 25 |
1002218 | 1002218 | 2021-02-06 | Jo Daviess | Illinois | 17085 | 1570 | 25 |
998972 | 998972 | 2021-02-05 | Jo Daviess | Illinois | 17085 | 1568 | 25 |
995726 | 995726 | 2021-02-04 | Jo Daviess | Illinois | 17085 | 1567 | 25 |
992480 | 992480 | 2021-02-03 | Jo Daviess | Illinois | 17085 | 1560 | 25 |
989234 | 989234 | 2021-02-02 | Jo Daviess | Illinois | 17085 | 1552 | 25 |
985987 | 985987 | 2021-02-01 | Jo Daviess | Illinois | 17085 | 1552 | 25 |
982740 | 982740 | 2021-01-31 | Jo Daviess | Illinois | 17085 | 1551 | 25 |
979494 | 979494 | 2021-01-30 | Jo Daviess | Illinois | 17085 | 1549 | 25 |
976249 | 976249 | 2021-01-29 | Jo Daviess | Illinois | 17085 | 1547 | 25 |
973004 | 973004 | 2021-01-28 | Jo Daviess | Illinois | 17085 | 1544 | 25 |
969759 | 969759 | 2021-01-27 | Jo Daviess | Illinois | 17085 | 1541 | 25 |
966515 | 966515 | 2021-01-26 | Jo Daviess | Illinois | 17085 | 1534 | 25 |
963270 | 963270 | 2021-01-25 | Jo Daviess | Illinois | 17085 | 1527 | 25 |
960025 | 960025 | 2021-01-24 | Jo Daviess | Illinois | 17085 | 1523 | 25 |
956779 | 956779 | 2021-01-23 | Jo Daviess | Illinois | 17085 | 1519 | 25 |
953534 | 953534 | 2021-01-22 | Jo Daviess | Illinois | 17085 | 1513 | 24 |
950289 | 950289 | 2021-01-21 | Jo Daviess | Illinois | 17085 | 1505 | 24 |
947043 | 947043 | 2021-01-20 | Jo Daviess | Illinois | 17085 | 1499 | 24 |
943796 | 943796 | 2021-01-19 | Jo Daviess | Illinois | 17085 | 1485 | 24 |
940551 | 940551 | 2021-01-18 | Jo Daviess | Illinois | 17085 | 1482 | 24 |
937306 | 937306 | 2021-01-17 | Jo Daviess | Illinois | 17085 | 1481 | 24 |
934061 | 934061 | 2021-01-16 | Jo Daviess | Illinois | 17085 | 1478 | 24 |
930816 | 930816 | 2021-01-15 | Jo Daviess | Illinois | 17085 | 1474 | 24 |
927571 | 927571 | 2021-01-14 | Jo Daviess | Illinois | 17085 | 1467 | 24 |
924325 | 924325 | 2021-01-13 | Jo Daviess | Illinois | 17085 | 1459 | 24 |
921080 | 921080 | 2021-01-12 | Jo Daviess | Illinois | 17085 | 1450 | 24 |
917835 | 917835 | 2021-01-11 | Jo Daviess | Illinois | 17085 | 1432 | 24 |
914590 | 914590 | 2021-01-10 | Jo Daviess | Illinois | 17085 | 1430 | 24 |
911345 | 911345 | 2021-01-09 | Jo Daviess | Illinois | 17085 | 1429 | 24 |
908100 | 908100 | 2021-01-08 | Jo Daviess | Illinois | 17085 | 1420 | 24 |
904854 | 904854 | 2021-01-07 | Jo Daviess | Illinois | 17085 | 1412 | 24 |
901609 | 901609 | 2021-01-06 | Jo Daviess | Illinois | 17085 | 1405 | 24 |
898364 | 898364 | 2021-01-05 | Jo Daviess | Illinois | 17085 | 1398 | 24 |
895119 | 895119 | 2021-01-04 | Jo Daviess | Illinois | 17085 | 1394 | 24 |
891872 | 891872 | 2021-01-03 | Jo Daviess | Illinois | 17085 | 1392 | 24 |
888625 | 888625 | 2021-01-02 | Jo Daviess | Illinois | 17085 | 1390 | 24 |
885380 | 885380 | 2021-01-01 | Jo Daviess | Illinois | 17085 | 1388 | 24 |
882135 | 882135 | 2020-12-31 | Jo Daviess | Illinois | 17085 | 1388 | 24 |
878890 | 878890 | 2020-12-30 | Jo Daviess | Illinois | 17085 | 1382 | 24 |
875645 | 875645 | 2020-12-29 | Jo Daviess | Illinois | 17085 | 1376 | 24 |
872400 | 872400 | 2020-12-28 | Jo Daviess | Illinois | 17085 | 1371 | 24 |
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);