ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 36029 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1513119 | 1513119 | 2021-07-13 | Erie | New York | 36029 | 89827 | 1813 |
1509873 | 1509873 | 2021-07-12 | Erie | New York | 36029 | 89806 | 1812 |
1506626 | 1506626 | 2021-07-11 | Erie | New York | 36029 | 89795 | 1812 |
1503380 | 1503380 | 2021-07-10 | Erie | New York | 36029 | 89785 | 1812 |
1500134 | 1500134 | 2021-07-09 | Erie | New York | 36029 | 89775 | 1812 |
1496888 | 1496888 | 2021-07-08 | Erie | New York | 36029 | 89755 | 1812 |
1493641 | 1493641 | 2021-07-07 | Erie | New York | 36029 | 89749 | 1812 |
1490394 | 1490394 | 2021-07-06 | Erie | New York | 36029 | 89737 | 1812 |
1487147 | 1487147 | 2021-07-05 | Erie | New York | 36029 | 89729 | 1812 |
1483901 | 1483901 | 2021-07-04 | Erie | New York | 36029 | 89717 | 1812 |
1480655 | 1480655 | 2021-07-03 | Erie | New York | 36029 | 89704 | 1812 |
1477408 | 1477408 | 2021-07-02 | Erie | New York | 36029 | 89695 | 1812 |
1474162 | 1474162 | 2021-07-01 | Erie | New York | 36029 | 89678 | 1812 |
1470916 | 1470916 | 2021-06-30 | Erie | New York | 36029 | 89668 | 1812 |
1467671 | 1467671 | 2021-06-29 | Erie | New York | 36029 | 89665 | 1812 |
1464426 | 1464426 | 2021-06-28 | Erie | New York | 36029 | 89660 | 1812 |
1461181 | 1461181 | 2021-06-27 | Erie | New York | 36029 | 89651 | 1812 |
1457936 | 1457936 | 2021-06-26 | Erie | New York | 36029 | 89638 | 1812 |
1454691 | 1454691 | 2021-06-25 | Erie | New York | 36029 | 89632 | 1811 |
1451446 | 1451446 | 2021-06-24 | Erie | New York | 36029 | 89626 | 1811 |
1448200 | 1448200 | 2021-06-23 | Erie | New York | 36029 | 89620 | 1811 |
1444955 | 1444955 | 2021-06-22 | Erie | New York | 36029 | 89617 | 1810 |
1441710 | 1441710 | 2021-06-21 | Erie | New York | 36029 | 89614 | 1809 |
1438465 | 1438465 | 2021-06-20 | Erie | New York | 36029 | 89607 | 1809 |
1435218 | 1435218 | 2021-06-19 | Erie | New York | 36029 | 89604 | 1809 |
1431971 | 1431971 | 2021-06-18 | Erie | New York | 36029 | 89603 | 1809 |
1428725 | 1428725 | 2021-06-17 | Erie | New York | 36029 | 89595 | 1808 |
1425480 | 1425480 | 2021-06-16 | Erie | New York | 36029 | 89583 | 1808 |
1422233 | 1422233 | 2021-06-15 | Erie | New York | 36029 | 89579 | 1807 |
1418987 | 1418987 | 2021-06-14 | Erie | New York | 36029 | 89572 | 1806 |
1415742 | 1415742 | 2021-06-13 | Erie | New York | 36029 | 89564 | 1806 |
1412496 | 1412496 | 2021-06-12 | Erie | New York | 36029 | 89557 | 1805 |
1409251 | 1409251 | 2021-06-11 | Erie | New York | 36029 | 89541 | 1803 |
1406006 | 1406006 | 2021-06-10 | Erie | New York | 36029 | 89520 | 1802 |
1402760 | 1402760 | 2021-06-09 | Erie | New York | 36029 | 89501 | 1801 |
1399515 | 1399515 | 2021-06-08 | Erie | New York | 36029 | 89488 | 1800 |
1396270 | 1396270 | 2021-06-07 | Erie | New York | 36029 | 89472 | 1800 |
1393023 | 1393023 | 2021-06-06 | Erie | New York | 36029 | 89446 | 1798 |
1389778 | 1389778 | 2021-06-05 | Erie | New York | 36029 | 89422 | 1798 |
1386533 | 1386533 | 2021-06-04 | Erie | New York | 36029 | 89386 | 1798 |
1383288 | 1383288 | 2021-06-03 | Erie | New York | 36029 | 89353 | 1796 |
1380042 | 1380042 | 2021-06-02 | Erie | New York | 36029 | 89335 | 1795 |
1376797 | 1376797 | 2021-06-01 | Erie | New York | 36029 | 89314 | 1794 |
1373551 | 1373551 | 2021-05-31 | Erie | New York | 36029 | 89289 | 1793 |
1370306 | 1370306 | 2021-05-30 | Erie | New York | 36029 | 89270 | 1789 |
1367060 | 1367060 | 2021-05-29 | Erie | New York | 36029 | 89219 | 1789 |
1363814 | 1363814 | 2021-05-28 | Erie | New York | 36029 | 89180 | 1789 |
1360568 | 1360568 | 2021-05-27 | Erie | New York | 36029 | 89142 | 1788 |
1357322 | 1357322 | 2021-05-26 | Erie | New York | 36029 | 89087 | 1788 |
1354076 | 1354076 | 2021-05-25 | Erie | New York | 36029 | 89031 | 1788 |
1350830 | 1350830 | 2021-05-24 | Erie | New York | 36029 | 88998 | 1786 |
1347584 | 1347584 | 2021-05-23 | Erie | New York | 36029 | 88925 | 1783 |
1344336 | 1344336 | 2021-05-22 | Erie | New York | 36029 | 88885 | 1782 |
1341088 | 1341088 | 2021-05-21 | Erie | New York | 36029 | 88807 | 1781 |
1337840 | 1337840 | 2021-05-20 | Erie | New York | 36029 | 88726 | 1781 |
1334593 | 1334593 | 2021-05-19 | Erie | New York | 36029 | 88638 | 1780 |
1331346 | 1331346 | 2021-05-18 | Erie | New York | 36029 | 88560 | 1779 |
1328099 | 1328099 | 2021-05-17 | Erie | New York | 36029 | 88507 | 1778 |
1324853 | 1324853 | 2021-05-16 | Erie | New York | 36029 | 88434 | 1778 |
1321607 | 1321607 | 2021-05-15 | Erie | New York | 36029 | 88350 | 1776 |
1318361 | 1318361 | 2021-05-14 | Erie | New York | 36029 | 88228 | 1775 |
1315113 | 1315113 | 2021-05-13 | Erie | New York | 36029 | 88115 | 1775 |
1311867 | 1311867 | 2021-05-12 | Erie | New York | 36029 | 87972 | 1775 |
1308620 | 1308620 | 2021-05-11 | Erie | New York | 36029 | 87877 | 1773 |
1305374 | 1305374 | 2021-05-10 | Erie | New York | 36029 | 87790 | 1770 |
1302128 | 1302128 | 2021-05-09 | Erie | New York | 36029 | 87702 | 1769 |
1298880 | 1298880 | 2021-05-08 | Erie | New York | 36029 | 87569 | 1767 |
1295634 | 1295634 | 2021-05-07 | Erie | New York | 36029 | 87297 | 1765 |
1292388 | 1292388 | 2021-05-06 | Erie | New York | 36029 | 87153 | 1763 |
1289142 | 1289142 | 2021-05-05 | Erie | New York | 36029 | 87017 | 1761 |
1285896 | 1285896 | 2021-05-04 | Erie | New York | 36029 | 86897 | 1760 |
1282650 | 1282650 | 2021-05-03 | Erie | New York | 36029 | 86742 | 1755 |
1279403 | 1279403 | 2021-05-02 | Erie | New York | 36029 | 86606 | 1752 |
1276156 | 1276156 | 2021-05-01 | Erie | New York | 36029 | 86439 | 1750 |
1272909 | 1272909 | 2021-04-30 | Erie | New York | 36029 | 86167 | 1749 |
1269662 | 1269662 | 2021-04-29 | Erie | New York | 36029 | 85879 | 1745 |
1266415 | 1266415 | 2021-04-28 | Erie | New York | 36029 | 85537 | 1741 |
1263168 | 1263168 | 2021-04-27 | Erie | New York | 36029 | 85314 | 1735 |
1259921 | 1259921 | 2021-04-26 | Erie | New York | 36029 | 85081 | 1732 |
1256674 | 1256674 | 2021-04-25 | Erie | New York | 36029 | 84866 | 1729 |
1253427 | 1253427 | 2021-04-24 | Erie | New York | 36029 | 84625 | 1724 |
1250180 | 1250180 | 2021-04-23 | Erie | New York | 36029 | 84353 | 1723 |
1246933 | 1246933 | 2021-04-22 | Erie | New York | 36029 | 83918 | 1721 |
1243686 | 1243686 | 2021-04-21 | Erie | New York | 36029 | 83524 | 1718 |
1240439 | 1240439 | 2021-04-20 | Erie | New York | 36029 | 83198 | 1712 |
1237192 | 1237192 | 2021-04-19 | Erie | New York | 36029 | 82901 | 1710 |
1233945 | 1233945 | 2021-04-18 | Erie | New York | 36029 | 82588 | 1706 |
1230697 | 1230697 | 2021-04-17 | Erie | New York | 36029 | 82158 | 1703 |
1227449 | 1227449 | 2021-04-16 | Erie | New York | 36029 | 81531 | 1697 |
1224201 | 1224201 | 2021-04-15 | Erie | New York | 36029 | 81141 | 1694 |
1220954 | 1220954 | 2021-04-14 | Erie | New York | 36029 | 80556 | 1689 |
1217706 | 1217706 | 2021-04-13 | Erie | New York | 36029 | 79959 | 1683 |
1214458 | 1214458 | 2021-04-12 | Erie | New York | 36029 | 79580 | 1681 |
1211211 | 1211211 | 2021-04-11 | Erie | New York | 36029 | 79217 | 1677 |
1207962 | 1207962 | 2021-04-10 | Erie | New York | 36029 | 78727 | 1673 |
1204714 | 1204714 | 2021-04-09 | Erie | New York | 36029 | 78193 | 1671 |
1201466 | 1201466 | 2021-04-08 | Erie | New York | 36029 | 77615 | 1670 |
1198217 | 1198217 | 2021-04-07 | Erie | New York | 36029 | 77089 | 1669 |
1194968 | 1194968 | 2021-04-06 | Erie | New York | 36029 | 76665 | 1666 |
1191720 | 1191720 | 2021-04-05 | Erie | New York | 36029 | 76365 | 1666 |
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);