ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
833 rows where fips = 25025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194348 | 1194348 | 2021-04-06 | Suffolk | Massachusetts | 25025 | 86365 | 1801 |
1191099 | 1191099 | 2021-04-05 | Suffolk | Massachusetts | 25025 | 86144 | 1799 |
1187851 | 1187851 | 2021-04-04 | Suffolk | Massachusetts | 25025 | 85736 | 1795 |
1184604 | 1184604 | 2021-04-03 | Suffolk | Massachusetts | 25025 | 85736 | 1795 |
1181358 | 1181358 | 2021-04-02 | Suffolk | Massachusetts | 25025 | 85406 | 1794 |
1178111 | 1178111 | 2021-04-01 | Suffolk | Massachusetts | 25025 | 85036 | 1791 |
1174864 | 1174864 | 2021-03-31 | Suffolk | Massachusetts | 25025 | 84646 | 1788 |
1171617 | 1171617 | 2021-03-30 | Suffolk | Massachusetts | 25025 | 84399 | 1784 |
1168369 | 1168369 | 2021-03-29 | Suffolk | Massachusetts | 25025 | 84188 | 1784 |
1165121 | 1165121 | 2021-03-28 | Suffolk | Massachusetts | 25025 | 83962 | 1783 |
1161873 | 1161873 | 2021-03-27 | Suffolk | Massachusetts | 25025 | 83704 | 1781 |
1158625 | 1158625 | 2021-03-26 | Suffolk | Massachusetts | 25025 | 83361 | 1776 |
1155378 | 1155378 | 2021-03-25 | Suffolk | Massachusetts | 25025 | 83023 | 1773 |
1152131 | 1152131 | 2021-03-24 | Suffolk | Massachusetts | 25025 | 82690 | 1773 |
1148884 | 1148884 | 2021-03-23 | Suffolk | Massachusetts | 25025 | 82474 | 1771 |
1145637 | 1145637 | 2021-03-22 | Suffolk | Massachusetts | 25025 | 82359 | 1769 |
1142390 | 1142390 | 2021-03-21 | Suffolk | Massachusetts | 25025 | 82205 | 1768 |
1139143 | 1139143 | 2021-03-20 | Suffolk | Massachusetts | 25025 | 81994 | 1763 |
1135897 | 1135897 | 2021-03-19 | Suffolk | Massachusetts | 25025 | 81757 | 1762 |
1132651 | 1132651 | 2021-03-18 | Suffolk | Massachusetts | 25025 | 81519 | 1760 |
1129403 | 1129403 | 2021-03-17 | Suffolk | Massachusetts | 25025 | 81293 | 1758 |
1126156 | 1126156 | 2021-03-16 | Suffolk | Massachusetts | 25025 | 81092 | 1752 |
1122910 | 1122910 | 2021-03-15 | Suffolk | Massachusetts | 25025 | 81002 | 1752 |
1119663 | 1119663 | 2021-03-14 | Suffolk | Massachusetts | 25025 | 80886 | 1749 |
1116416 | 1116416 | 2021-03-13 | Suffolk | Massachusetts | 25025 | 80655 | 1747 |
1113170 | 1113170 | 2021-03-12 | Suffolk | Massachusetts | 25025 | 80450 | 1741 |
1109924 | 1109924 | 2021-03-11 | Suffolk | Massachusetts | 25025 | 80231 | 1738 |
1106678 | 1106678 | 2021-03-10 | Suffolk | Massachusetts | 25025 | 80026 | 1729 |
1103432 | 1103432 | 2021-03-09 | Suffolk | Massachusetts | 25025 | 79835 | 1721 |
1100186 | 1100186 | 2021-03-08 | Suffolk | Massachusetts | 25025 | 79724 | 1720 |
1096939 | 1096939 | 2021-03-07 | Suffolk | Massachusetts | 25025 | 79597 | 1720 |
1093692 | 1093692 | 2021-03-06 | Suffolk | Massachusetts | 25025 | 79420 | 1718 |
1090446 | 1090446 | 2021-03-05 | Suffolk | Massachusetts | 25025 | 79200 | 1712 |
1087201 | 1087201 | 2021-03-04 | Suffolk | Massachusetts | 25025 | 78922 | 1713 |
1083956 | 1083956 | 2021-03-03 | Suffolk | Massachusetts | 25025 | 78705 | 1707 |
1080710 | 1080710 | 2021-03-02 | Suffolk | Massachusetts | 25025 | 78468 | 1701 |
1077464 | 1077464 | 2021-03-01 | Suffolk | Massachusetts | 25025 | 78485 | 1700 |
1074218 | 1074218 | 2021-02-28 | Suffolk | Massachusetts | 25025 | 78277 | 1697 |
1070972 | 1070972 | 2021-02-27 | Suffolk | Massachusetts | 25025 | 78064 | 1693 |
1067727 | 1067727 | 2021-02-26 | Suffolk | Massachusetts | 25025 | 77831 | 1687 |
1064482 | 1064482 | 2021-02-25 | Suffolk | Massachusetts | 25025 | 77569 | 1685 |
1061238 | 1061238 | 2021-02-24 | Suffolk | Massachusetts | 25025 | 77316 | 1681 |
1057992 | 1057992 | 2021-02-23 | Suffolk | Massachusetts | 25025 | 77071 | 1677 |
1054746 | 1054746 | 2021-02-22 | Suffolk | Massachusetts | 25025 | 76944 | 1674 |
1051499 | 1051499 | 2021-02-21 | Suffolk | Massachusetts | 25025 | 76787 | 1673 |
1048252 | 1048252 | 2021-02-20 | Suffolk | Massachusetts | 25025 | 76620 | 1668 |
1045006 | 1045006 | 2021-02-19 | Suffolk | Massachusetts | 25025 | 76367 | 1666 |
1041761 | 1041761 | 2021-02-18 | Suffolk | Massachusetts | 25025 | 76135 | 1666 |
1038516 | 1038516 | 2021-02-17 | Suffolk | Massachusetts | 25025 | 75876 | 1659 |
1035271 | 1035271 | 2021-02-16 | Suffolk | Massachusetts | 25025 | 75743 | 1654 |
1032026 | 1032026 | 2021-02-15 | Suffolk | Massachusetts | 25025 | 75637 | 1651 |
1028779 | 1028779 | 2021-02-14 | Suffolk | Massachusetts | 25025 | 75435 | 1646 |
1025533 | 1025533 | 2021-02-13 | Suffolk | Massachusetts | 25025 | 75190 | 1642 |
1022288 | 1022288 | 2021-02-12 | Suffolk | Massachusetts | 25025 | 74944 | 1633 |
1019043 | 1019043 | 2021-02-11 | Suffolk | Massachusetts | 25025 | 74668 | 1627 |
1015798 | 1015798 | 2021-02-10 | Suffolk | Massachusetts | 25025 | 74329 | 1617 |
1012553 | 1012553 | 2021-02-09 | Suffolk | Massachusetts | 25025 | 74098 | 1606 |
1009308 | 1009308 | 2021-02-08 | Suffolk | Massachusetts | 25025 | 73952 | 1603 |
1006061 | 1006061 | 2021-02-07 | Suffolk | Massachusetts | 25025 | 73788 | 1597 |
1002815 | 1002815 | 2021-02-06 | Suffolk | Massachusetts | 25025 | 73393 | 1592 |
999570 | 999570 | 2021-02-05 | Suffolk | Massachusetts | 25025 | 73016 | 1588 |
996324 | 996324 | 2021-02-04 | Suffolk | Massachusetts | 25025 | 72628 | 1581 |
993078 | 993078 | 2021-02-03 | Suffolk | Massachusetts | 25025 | 72287 | 1572 |
989832 | 989832 | 2021-02-02 | Suffolk | Massachusetts | 25025 | 72062 | 1568 |
986585 | 986585 | 2021-02-01 | Suffolk | Massachusetts | 25025 | 71869 | 1566 |
983338 | 983338 | 2021-01-31 | Suffolk | Massachusetts | 25025 | 71597 | 1563 |
980092 | 980092 | 2021-01-30 | Suffolk | Massachusetts | 25025 | 71259 | 1561 |
976846 | 976846 | 2021-01-29 | Suffolk | Massachusetts | 25025 | 70712 | 1556 |
973601 | 973601 | 2021-01-28 | Suffolk | Massachusetts | 25025 | 70398 | 1548 |
970356 | 970356 | 2021-01-27 | Suffolk | Massachusetts | 25025 | 69882 | 1541 |
967111 | 967111 | 2021-01-26 | Suffolk | Massachusetts | 25025 | 69480 | 1535 |
963867 | 963867 | 2021-01-25 | Suffolk | Massachusetts | 25025 | 69263 | 1530 |
960622 | 960622 | 2021-01-24 | Suffolk | Massachusetts | 25025 | 68799 | 1525 |
957376 | 957376 | 2021-01-23 | Suffolk | Massachusetts | 25025 | 68226 | 1519 |
954131 | 954131 | 2021-01-22 | Suffolk | Massachusetts | 25025 | 67729 | 1508 |
950886 | 950886 | 2021-01-21 | Suffolk | Massachusetts | 25025 | 67004 | 1506 |
947640 | 947640 | 2021-01-20 | Suffolk | Massachusetts | 25025 | 66466 | 1498 |
944393 | 944393 | 2021-01-19 | Suffolk | Massachusetts | 25025 | 66066 | 1490 |
941148 | 941148 | 2021-01-18 | Suffolk | Massachusetts | 25025 | 65804 | 1487 |
937903 | 937903 | 2021-01-17 | Suffolk | Massachusetts | 25025 | 65398 | 1481 |
934658 | 934658 | 2021-01-16 | Suffolk | Massachusetts | 25025 | 64867 | 1478 |
931413 | 931413 | 2021-01-15 | Suffolk | Massachusetts | 25025 | 64158 | 1465 |
928168 | 928168 | 2021-01-14 | Suffolk | Massachusetts | 25025 | 63472 | 1459 |
924922 | 924922 | 2021-01-13 | Suffolk | Massachusetts | 25025 | 62816 | 1448 |
921677 | 921677 | 2021-01-12 | Suffolk | Massachusetts | 25025 | 62241 | 1439 |
918432 | 918432 | 2021-01-11 | Suffolk | Massachusetts | 25025 | 61722 | 1430 |
915187 | 915187 | 2021-01-10 | Suffolk | Massachusetts | 25025 | 61178 | 1426 |
911942 | 911942 | 2021-01-09 | Suffolk | Massachusetts | 25025 | 60502 | 1415 |
908697 | 908697 | 2021-01-08 | Suffolk | Massachusetts | 25025 | 59640 | 1412 |
905451 | 905451 | 2021-01-07 | Suffolk | Massachusetts | 25025 | 58671 | 1406 |
902206 | 902206 | 2021-01-06 | Suffolk | Massachusetts | 25025 | 57742 | 1401 |
898961 | 898961 | 2021-01-05 | Suffolk | Massachusetts | 25025 | 56911 | 1395 |
895716 | 895716 | 2021-01-04 | Suffolk | Massachusetts | 25025 | 56431 | 1387 |
892469 | 892469 | 2021-01-03 | Suffolk | Massachusetts | 25025 | 55925 | 1382 |
889223 | 889223 | 2021-01-02 | Suffolk | Massachusetts | 25025 | 55575 | 1377 |
885977 | 885977 | 2021-01-01 | Suffolk | Massachusetts | 25025 | 54556 | 1374 |
882732 | 882732 | 2020-12-31 | Suffolk | Massachusetts | 25025 | 54556 | 1374 |
879487 | 879487 | 2020-12-30 | Suffolk | Massachusetts | 25025 | 53695 | 1369 |
876242 | 876242 | 2020-12-29 | Suffolk | Massachusetts | 25025 | 53046 | 1361 |
872997 | 872997 | 2020-12-28 | Suffolk | Massachusetts | 25025 | 52598 | 1357 |
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);