ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where county = "New York City" 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 |
---|---|---|---|---|---|---|---|
1786000 | 1786000 | 2021-10-05 | New York City | New York | 1091216 | 34316 | |
1782751 | 1782751 | 2021-10-04 | New York City | New York | 1090016 | 34311 | |
1779502 | 1779502 | 2021-10-03 | New York City | New York | 1085590 | 34284 | |
1776252 | 1776252 | 2021-10-02 | New York City | New York | 1085590 | 34284 | |
1773002 | 1773002 | 2021-10-01 | New York City | New York | 1085590 | 34284 | |
1769752 | 1769752 | 2021-09-30 | New York City | New York | 1083700 | 34264 | |
1766503 | 1766503 | 2021-09-29 | New York City | New York | 1082099 | 34245 | |
1763254 | 1763254 | 2021-09-28 | New York City | New York | 1080909 | 34208 | |
1760005 | 1760005 | 2021-09-27 | New York City | New York | 1078382 | 34186 | |
1756757 | 1756757 | 2021-09-26 | New York City | New York | 1078382 | 34186 | |
1753509 | 1753509 | 2021-09-25 | New York City | New York | 1074557 | 34156 | |
1750261 | 1750261 | 2021-09-24 | New York City | New York | 1074557 | 34156 | |
1747011 | 1747011 | 2021-09-23 | New York City | New York | 1072875 | 34133 | |
1743762 | 1743762 | 2021-09-22 | New York City | New York | 1071132 | 34122 | |
1740513 | 1740513 | 2021-09-21 | New York City | New York | 1069567 | 34102 | |
1737264 | 1737264 | 2021-09-20 | New York City | New York | 1067847 | 34074 | |
1734014 | 1734014 | 2021-09-19 | New York City | New York | 1066253 | 34072 | |
1730764 | 1730764 | 2021-09-18 | New York City | New York | 1062049 | 34058 | |
1727514 | 1727514 | 2021-09-17 | New York City | New York | 1062049 | 34058 | |
1724265 | 1724265 | 2021-09-16 | New York City | New York | 1059884 | 34052 | |
1721016 | 1721016 | 2021-09-15 | New York City | New York | 1057892 | 34034 | |
1717768 | 1717768 | 2021-09-14 | New York City | New York | 1056265 | 34026 | |
1714520 | 1714520 | 2021-09-13 | New York City | New York | 1054705 | 34001 | |
1711274 | 1711274 | 2021-09-12 | New York City | New York | 1051595 | 33977 | |
1708027 | 1708027 | 2021-09-11 | New York City | New York | 1051595 | 33977 | |
1704780 | 1704780 | 2021-09-10 | New York City | New York | 1049126 | 33959 | |
1701530 | 1701530 | 2021-09-09 | New York City | New York | 1047307 | 33968 | |
1698281 | 1698281 | 2021-09-08 | New York City | New York | 1044283 | 33914 | |
1695033 | 1695033 | 2021-09-07 | New York City | New York | 1044283 | 33914 | |
1691785 | 1691785 | 2021-09-06 | New York City | New York | 1043289 | 33907 | |
1688535 | 1688535 | 2021-09-05 | New York City | New York | 1042059 | 33895 | |
1685285 | 1685285 | 2021-09-04 | New York City | New York | 1038427 | 33875 | |
1682034 | 1682034 | 2021-09-03 | New York City | New York | 1038427 | 33875 | |
1678785 | 1678785 | 2021-09-02 | New York City | New York | 1036299 | 33867 | |
1675537 | 1675537 | 2021-09-01 | New York City | New York | 1034266 | 33840 | |
1672290 | 1672290 | 2021-08-31 | New York City | New York | 1032969 | 33830 | |
1669042 | 1669042 | 2021-08-30 | New York City | New York | 1031455 | 33818 | |
1665795 | 1665795 | 2021-08-29 | New York City | New York | 1028125 | 33795 | |
1662547 | 1662547 | 2021-08-28 | New York City | New York | 1028125 | 33795 | |
1659299 | 1659299 | 2021-08-27 | New York City | New York | 1025740 | 33788 | |
1656050 | 1656050 | 2021-08-26 | New York City | New York | 1023599 | 33779 | |
1652803 | 1652803 | 2021-08-25 | New York City | New York | 1021400 | 33763 | |
1649555 | 1649555 | 2021-08-24 | New York City | New York | 1020062 | 33744 | |
1646306 | 1646306 | 2021-08-23 | New York City | New York | 1018334 | 33736 | |
1643057 | 1643057 | 2021-08-22 | New York City | New York | 1016792 | 33723 | |
1639807 | 1639807 | 2021-08-21 | New York City | New York | 1014697 | 33720 | |
1636557 | 1636557 | 2021-08-20 | New York City | New York | 1011428 | 33694 | |
1633307 | 1633307 | 2021-08-19 | New York City | New York | 1010304 | 33690 | |
1630060 | 1630060 | 2021-08-18 | New York City | New York | 1007992 | 33684 | |
1626813 | 1626813 | 2021-08-17 | New York City | New York | 1006142 | 33684 | |
1623566 | 1623566 | 2021-08-16 | New York City | New York | 1004659 | 33661 | |
1620319 | 1620319 | 2021-08-15 | New York City | New York | 1002520 | 33657 | |
1617071 | 1617071 | 2021-08-14 | New York City | New York | 1000703 | 33645 | |
1613823 | 1613823 | 2021-08-13 | New York City | New York | 998350 | 33639 | |
1610574 | 1610574 | 2021-08-12 | New York City | New York | 996290 | 33636 | |
1607326 | 1607326 | 2021-08-11 | New York City | New York | 993864 | 33618 | |
1604077 | 1604077 | 2021-08-10 | New York City | New York | 988831 | 33588 | |
1600828 | 1600828 | 2021-08-09 | New York City | New York | 988831 | 33588 | |
1597580 | 1597580 | 2021-08-08 | New York City | New York | 988831 | 33588 | |
1594331 | 1594331 | 2021-08-07 | New York City | New York | 986967 | 33578 | |
1591082 | 1591082 | 2021-08-06 | New York City | New York | 984871 | 33571 | |
1587833 | 1587833 | 2021-08-05 | New York City | New York | 982876 | 33570 | |
1584583 | 1584583 | 2021-08-04 | New York City | New York | 981123 | 33559 | |
1581333 | 1581333 | 2021-08-03 | New York City | New York | 979815 | 33557 | |
1578084 | 1578084 | 2021-08-02 | New York City | New York | 978241 | 33545 | |
1574836 | 1574836 | 2021-08-01 | New York City | New York | 976974 | 33538 | |
1571588 | 1571588 | 2021-07-31 | New York City | New York | 975638 | 33534 | |
1568340 | 1568340 | 2021-07-30 | New York City | New York | 973870 | 33527 | |
1565092 | 1565092 | 2021-07-29 | New York City | New York | 972514 | 33521 | |
1561844 | 1561844 | 2021-07-28 | New York City | New York | 971044 | 33519 | |
1558596 | 1558596 | 2021-07-27 | New York City | New York | 970189 | 33512 | |
1555349 | 1555349 | 2021-07-26 | New York City | New York | 969316 | 33512 | |
1552102 | 1552102 | 2021-07-25 | New York City | New York | 968343 | 33507 | |
1548855 | 1548855 | 2021-07-24 | New York City | New York | 967223 | 33505 | |
1545608 | 1545608 | 2021-07-23 | New York City | New York | 966095 | 33502 | |
1542361 | 1542361 | 2021-07-22 | New York City | New York | 965171 | 33501 | |
1539113 | 1539113 | 2021-07-21 | New York City | New York | 964210 | 33495 | |
1535866 | 1535866 | 2021-07-20 | New York City | New York | 963700 | 33491 | |
1532618 | 1532618 | 2021-07-19 | New York City | New York | 963063 | 33487 | |
1529371 | 1529371 | 2021-07-18 | New York City | New York | 962484 | 33484 | |
1526124 | 1526124 | 2021-07-17 | New York City | New York | 961832 | 33475 | |
1522877 | 1522877 | 2021-07-16 | New York City | New York | 960813 | 33471 | |
1519629 | 1519629 | 2021-07-15 | New York City | New York | 960561 | 33471 | |
1516381 | 1516381 | 2021-07-14 | New York City | New York | 960038 | 33467 | |
1513134 | 1513134 | 2021-07-13 | New York City | New York | 959649 | 33458 | |
1509888 | 1509888 | 2021-07-12 | New York City | New York | 959266 | 33457 | |
1506641 | 1506641 | 2021-07-11 | New York City | New York | 958847 | 33455 | |
1503395 | 1503395 | 2021-07-10 | New York City | New York | 958290 | 33453 | |
1500149 | 1500149 | 2021-07-09 | New York City | New York | 957815 | 33446 | |
1496903 | 1496903 | 2021-07-08 | New York City | New York | 957382 | 33444 | |
1493656 | 1493656 | 2021-07-07 | New York City | New York | 956963 | 33442 | |
1490409 | 1490409 | 2021-07-06 | New York City | New York | 956795 | 33438 | |
1487162 | 1487162 | 2021-07-05 | New York City | New York | 956616 | 33436 | |
1483916 | 1483916 | 2021-07-04 | New York City | New York | 956381 | 33433 | |
1480670 | 1480670 | 2021-07-03 | New York City | New York | 956230 | 33426 | |
1477423 | 1477423 | 2021-07-02 | New York City | New York | 956102 | 33426 | |
1474177 | 1474177 | 2021-07-01 | New York City | New York | 955871 | 33425 | |
1470931 | 1470931 | 2021-06-30 | New York City | New York | 955649 | 33415 | |
1467686 | 1467686 | 2021-06-29 | New York City | New York | 955505 | 33415 | |
1464441 | 1464441 | 2021-06-28 | New York City | New York | 955367 | 33412 |
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);