ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Franklin" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193835 | 1193835 | 2021-04-06 | Franklin | Indiana | 18047 | 1655 | 36 |
1190585 | 1190585 | 2021-04-05 | Franklin | Indiana | 18047 | 1653 | 36 |
1187338 | 1187338 | 2021-04-04 | Franklin | Indiana | 18047 | 1653 | 36 |
1184091 | 1184091 | 2021-04-03 | Franklin | Indiana | 18047 | 1653 | 36 |
1180844 | 1180844 | 2021-04-02 | Franklin | Indiana | 18047 | 1653 | 36 |
1177597 | 1177597 | 2021-04-01 | Franklin | Indiana | 18047 | 1651 | 36 |
1174350 | 1174350 | 2021-03-31 | Franklin | Indiana | 18047 | 1649 | 36 |
1171103 | 1171103 | 2021-03-30 | Franklin | Indiana | 18047 | 1649 | 36 |
1167855 | 1167855 | 2021-03-29 | Franklin | Indiana | 18047 | 1648 | 36 |
1164607 | 1164607 | 2021-03-28 | Franklin | Indiana | 18047 | 1648 | 36 |
1161359 | 1161359 | 2021-03-27 | Franklin | Indiana | 18047 | 1648 | 36 |
1158111 | 1158111 | 2021-03-26 | Franklin | Indiana | 18047 | 1645 | 36 |
1154864 | 1154864 | 2021-03-25 | Franklin | Indiana | 18047 | 1645 | 36 |
1151617 | 1151617 | 2021-03-24 | Franklin | Indiana | 18047 | 1644 | 36 |
1148370 | 1148370 | 2021-03-23 | Franklin | Indiana | 18047 | 1642 | 36 |
1145123 | 1145123 | 2021-03-22 | Franklin | Indiana | 18047 | 1638 | 36 |
1141876 | 1141876 | 2021-03-21 | Franklin | Indiana | 18047 | 1638 | 36 |
1138630 | 1138630 | 2021-03-20 | Franklin | Indiana | 18047 | 1637 | 36 |
1135384 | 1135384 | 2021-03-19 | Franklin | Indiana | 18047 | 1635 | 36 |
1132137 | 1132137 | 2021-03-18 | Franklin | Indiana | 18047 | 1632 | 36 |
1128889 | 1128889 | 2021-03-17 | Franklin | Indiana | 18047 | 1629 | 36 |
1125643 | 1125643 | 2021-03-16 | Franklin | Indiana | 18047 | 1629 | 36 |
1122397 | 1122397 | 2021-03-15 | Franklin | Indiana | 18047 | 1629 | 36 |
1119150 | 1119150 | 2021-03-14 | Franklin | Indiana | 18047 | 1628 | 36 |
1115903 | 1115903 | 2021-03-13 | Franklin | Indiana | 18047 | 1626 | 36 |
1112657 | 1112657 | 2021-03-12 | Franklin | Indiana | 18047 | 1625 | 36 |
1109411 | 1109411 | 2021-03-11 | Franklin | Indiana | 18047 | 1625 | 36 |
1106165 | 1106165 | 2021-03-10 | Franklin | Indiana | 18047 | 1622 | 36 |
1102919 | 1102919 | 2021-03-09 | Franklin | Indiana | 18047 | 1621 | 36 |
1099673 | 1099673 | 2021-03-08 | Franklin | Indiana | 18047 | 1620 | 36 |
1096425 | 1096425 | 2021-03-07 | Franklin | Indiana | 18047 | 1619 | 36 |
1093179 | 1093179 | 2021-03-06 | Franklin | Indiana | 18047 | 1617 | 36 |
1089933 | 1089933 | 2021-03-05 | Franklin | Indiana | 18047 | 1615 | 36 |
1086688 | 1086688 | 2021-03-04 | Franklin | Indiana | 18047 | 1614 | 36 |
1083442 | 1083442 | 2021-03-03 | Franklin | Indiana | 18047 | 1613 | 36 |
1080196 | 1080196 | 2021-03-02 | Franklin | Indiana | 18047 | 1612 | 36 |
1076951 | 1076951 | 2021-03-01 | Franklin | Indiana | 18047 | 1612 | 36 |
1073705 | 1073705 | 2021-02-28 | Franklin | Indiana | 18047 | 1612 | 36 |
1070459 | 1070459 | 2021-02-27 | Franklin | Indiana | 18047 | 1611 | 36 |
1067214 | 1067214 | 2021-02-26 | Franklin | Indiana | 18047 | 1609 | 36 |
1063969 | 1063969 | 2021-02-25 | Franklin | Indiana | 18047 | 1606 | 36 |
1060724 | 1060724 | 2021-02-24 | Franklin | Indiana | 18047 | 1602 | 36 |
1057478 | 1057478 | 2021-02-23 | Franklin | Indiana | 18047 | 1601 | 36 |
1054232 | 1054232 | 2021-02-22 | Franklin | Indiana | 18047 | 1601 | 36 |
1050985 | 1050985 | 2021-02-21 | Franklin | Indiana | 18047 | 1601 | 36 |
1047738 | 1047738 | 2021-02-20 | Franklin | Indiana | 18047 | 1601 | 36 |
1044493 | 1044493 | 2021-02-19 | Franklin | Indiana | 18047 | 1600 | 36 |
1041248 | 1041248 | 2021-02-18 | Franklin | Indiana | 18047 | 1598 | 36 |
1038003 | 1038003 | 2021-02-17 | Franklin | Indiana | 18047 | 1597 | 36 |
1034758 | 1034758 | 2021-02-16 | Franklin | Indiana | 18047 | 1596 | 36 |
1031512 | 1031512 | 2021-02-15 | Franklin | Indiana | 18047 | 1593 | 36 |
1028265 | 1028265 | 2021-02-14 | Franklin | Indiana | 18047 | 1592 | 36 |
1025020 | 1025020 | 2021-02-13 | Franklin | Indiana | 18047 | 1588 | 36 |
1021775 | 1021775 | 2021-02-12 | Franklin | Indiana | 18047 | 1587 | 36 |
1018530 | 1018530 | 2021-02-11 | Franklin | Indiana | 18047 | 1586 | 36 |
1015285 | 1015285 | 2021-02-10 | Franklin | Indiana | 18047 | 1584 | 36 |
1012040 | 1012040 | 2021-02-09 | Franklin | Indiana | 18047 | 1582 | 36 |
1008794 | 1008794 | 2021-02-08 | Franklin | Indiana | 18047 | 1580 | 36 |
1005548 | 1005548 | 2021-02-07 | Franklin | Indiana | 18047 | 1578 | 36 |
1002302 | 1002302 | 2021-02-06 | Franklin | Indiana | 18047 | 1574 | 36 |
999056 | 999056 | 2021-02-05 | Franklin | Indiana | 18047 | 1566 | 36 |
995810 | 995810 | 2021-02-04 | Franklin | Indiana | 18047 | 1562 | 35 |
992564 | 992564 | 2021-02-03 | Franklin | Indiana | 18047 | 1560 | 34 |
989318 | 989318 | 2021-02-02 | Franklin | Indiana | 18047 | 1559 | 34 |
986071 | 986071 | 2021-02-01 | Franklin | Indiana | 18047 | 1555 | 34 |
982824 | 982824 | 2021-01-31 | Franklin | Indiana | 18047 | 1551 | 34 |
979578 | 979578 | 2021-01-30 | Franklin | Indiana | 18047 | 1549 | 33 |
976332 | 976332 | 2021-01-29 | Franklin | Indiana | 18047 | 1543 | 33 |
973087 | 973087 | 2021-01-28 | Franklin | Indiana | 18047 | 1535 | 34 |
969842 | 969842 | 2021-01-27 | Franklin | Indiana | 18047 | 1533 | 34 |
966598 | 966598 | 2021-01-26 | Franklin | Indiana | 18047 | 1516 | 34 |
963353 | 963353 | 2021-01-25 | Franklin | Indiana | 18047 | 1510 | 34 |
960108 | 960108 | 2021-01-24 | Franklin | Indiana | 18047 | 1507 | 34 |
956862 | 956862 | 2021-01-23 | Franklin | Indiana | 18047 | 1500 | 34 |
953617 | 953617 | 2021-01-22 | Franklin | Indiana | 18047 | 1495 | 34 |
950372 | 950372 | 2021-01-21 | Franklin | Indiana | 18047 | 1486 | 34 |
947126 | 947126 | 2021-01-20 | Franklin | Indiana | 18047 | 1472 | 34 |
943879 | 943879 | 2021-01-19 | Franklin | Indiana | 18047 | 1461 | 34 |
940634 | 940634 | 2021-01-18 | Franklin | Indiana | 18047 | 1455 | 34 |
937389 | 937389 | 2021-01-17 | Franklin | Indiana | 18047 | 1451 | 34 |
934144 | 934144 | 2021-01-16 | Franklin | Indiana | 18047 | 1442 | 34 |
930899 | 930899 | 2021-01-15 | Franklin | Indiana | 18047 | 1434 | 34 |
927654 | 927654 | 2021-01-14 | Franklin | Indiana | 18047 | 1410 | 34 |
924408 | 924408 | 2021-01-13 | Franklin | Indiana | 18047 | 1403 | 34 |
921163 | 921163 | 2021-01-12 | Franklin | Indiana | 18047 | 1391 | 33 |
917918 | 917918 | 2021-01-11 | Franklin | Indiana | 18047 | 1384 | 31 |
914673 | 914673 | 2021-01-10 | Franklin | Indiana | 18047 | 1376 | 31 |
911428 | 911428 | 2021-01-09 | Franklin | Indiana | 18047 | 1363 | 31 |
908183 | 908183 | 2021-01-08 | Franklin | Indiana | 18047 | 1356 | 31 |
904937 | 904937 | 2021-01-07 | Franklin | Indiana | 18047 | 1334 | 31 |
901692 | 901692 | 2021-01-06 | Franklin | Indiana | 18047 | 1316 | 31 |
898447 | 898447 | 2021-01-05 | Franklin | Indiana | 18047 | 1296 | 30 |
895202 | 895202 | 2021-01-04 | Franklin | Indiana | 18047 | 1285 | 30 |
891955 | 891955 | 2021-01-03 | Franklin | Indiana | 18047 | 1276 | 30 |
888709 | 888709 | 2021-01-02 | Franklin | Indiana | 18047 | 1265 | 30 |
885463 | 885463 | 2021-01-01 | Franklin | Indiana | 18047 | 1261 | 30 |
882218 | 882218 | 2020-12-31 | Franklin | Indiana | 18047 | 1229 | 29 |
878973 | 878973 | 2020-12-30 | Franklin | Indiana | 18047 | 1215 | 29 |
875728 | 875728 | 2020-12-29 | Franklin | Indiana | 18047 | 1197 | 29 |
872483 | 872483 | 2020-12-28 | Franklin | Indiana | 18047 | 1173 | 29 |
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);