ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
814 rows where fips = "" 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 |
---|---|---|---|---|---|---|---|
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 | |
1461196 | 1461196 | 2021-06-27 | New York City | New York | 955180 | 33406 | |
1457951 | 1457951 | 2021-06-26 | New York City | New York | 954954 | 33394 | |
1454706 | 1454706 | 2021-06-25 | New York City | New York | 954769 | 33391 | |
1451461 | 1451461 | 2021-06-24 | New York City | New York | 954567 | 33386 | |
1448215 | 1448215 | 2021-06-23 | New York City | New York | 954353 | 33390 | |
1444970 | 1444970 | 2021-06-22 | New York City | New York | 954235 | 33388 | |
1441725 | 1441725 | 2021-06-21 | New York City | New York | 954096 | 33378 | |
1438480 | 1438480 | 2021-06-20 | New York City | New York | 953928 | 33374 | |
1435233 | 1435233 | 2021-06-19 | New York City | New York | 953749 | 33374 | |
1431986 | 1431986 | 2021-06-18 | New York City | New York | 953551 | 33371 | |
1428740 | 1428740 | 2021-06-17 | New York City | New York | 953310 | 33370 | |
1425495 | 1425495 | 2021-06-16 | New York City | New York | 953079 | 33358 | |
1422248 | 1422248 | 2021-06-15 | New York City | New York | 952963 | 33359 | |
1419002 | 1419002 | 2021-06-14 | New York City | New York | 952772 | 33348 | |
1415757 | 1415757 | 2021-06-13 | New York City | New York | 952559 | 33344 | |
1412511 | 1412511 | 2021-06-12 | New York City | New York | 952396 | 33339 | |
1409266 | 1409266 | 2021-06-11 | New York City | New York | 952238 | 33331 | |
1406021 | 1406021 | 2021-06-10 | New York City | New York | 951817 | 33322 | |
1402775 | 1402775 | 2021-06-09 | New York City | New York | 951532 | 33313 | |
1399530 | 1399530 | 2021-06-08 | New York City | New York | 951322 | 33309 | |
1396285 | 1396285 | 2021-06-07 | New York City | New York | 951084 | 33307 |
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);