ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

210 rows where deaths = 16 and state = "New York" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

state 1

  • New York · 210 ✖
Link rowid date ▲ county state fips cases deaths
1821754 1821754 2021-10-16 Schuyler New York 36097 1493 16
1818505 1818505 2021-10-15 Schuyler New York 36097 1486 16
1815256 1815256 2021-10-14 Schuyler New York 36097 1473 16
1812008 1812008 2021-10-13 Schuyler New York 36097 1455 16
1808759 1808759 2021-10-12 Schuyler New York 36097 1443 16
1805508 1805508 2021-10-11 Schuyler New York 36097 1440 16
1802259 1802259 2021-10-10 Schuyler New York 36097 1435 16
1799010 1799010 2021-10-09 Schuyler New York 36097 1422 16
1795761 1795761 2021-10-08 Schuyler New York 36097 1416 16
1792512 1792512 2021-10-07 Schuyler New York 36097 1403 16
1789263 1789263 2021-10-06 Schuyler New York 36097 1396 16
1786015 1786015 2021-10-05 Schuyler New York 36097 1387 16
1782766 1782766 2021-10-04 Schuyler New York 36097 1376 16
1779517 1779517 2021-10-03 Schuyler New York 36097 1374 16
1776267 1776267 2021-10-02 Schuyler New York 36097 1367 16
1773017 1773017 2021-10-01 Schuyler New York 36097 1361 16
1769767 1769767 2021-09-30 Schuyler New York 36097 1351 16
1766518 1766518 2021-09-29 Schuyler New York 36097 1343 16
1763241 1763241 2021-09-28 Franklin New York 36033 3705 16
1763269 1763269 2021-09-28 Schuyler New York 36097 1333 16
1759992 1759992 2021-09-27 Franklin New York 36033 3689 16
1760020 1760020 2021-09-27 Schuyler New York 36097 1331 16
1756744 1756744 2021-09-26 Franklin New York 36033 3670 16
1756772 1756772 2021-09-26 Schuyler New York 36097 1321 16
1753496 1753496 2021-09-25 Franklin New York 36033 3647 16
1753524 1753524 2021-09-25 Schuyler New York 36097 1311 16
1750248 1750248 2021-09-24 Franklin New York 36033 3599 16
1750276 1750276 2021-09-24 Schuyler New York 36097 1301 16
1746998 1746998 2021-09-23 Franklin New York 36033 3564 16
1747026 1747026 2021-09-23 Schuyler New York 36097 1289 16
1743749 1743749 2021-09-22 Franklin New York 36033 3532 16
1743777 1743777 2021-09-22 Schuyler New York 36097 1284 16
1740500 1740500 2021-09-21 Franklin New York 36033 3512 16
1740528 1740528 2021-09-21 Schuyler New York 36097 1277 16
1737251 1737251 2021-09-20 Franklin New York 36033 3475 16
1737279 1737279 2021-09-20 Schuyler New York 36097 1272 16
1734029 1734029 2021-09-19 Schuyler New York 36097 1264 16
1730779 1730779 2021-09-18 Schuyler New York 36097 1255 16
1727529 1727529 2021-09-17 Schuyler New York 36097 1253 16
1724280 1724280 2021-09-16 Schuyler New York 36097 1246 16
1721031 1721031 2021-09-15 Schuyler New York 36097 1232 16
1717783 1717783 2021-09-14 Schuyler New York 36097 1227 16
1714535 1714535 2021-09-13 Schuyler New York 36097 1223 16
1711289 1711289 2021-09-12 Schuyler New York 36097 1220 16
1708042 1708042 2021-09-11 Schuyler New York 36097 1212 16
1321636 1321636 2021-05-15 Schoharie New York 36095 1662 16
1318390 1318390 2021-05-14 Schoharie New York 36095 1660 16
1315142 1315142 2021-05-13 Schoharie New York 36095 1655 16
1311896 1311896 2021-05-12 Schoharie New York 36095 1652 16
1308649 1308649 2021-05-11 Schoharie New York 36095 1648 16
1305403 1305403 2021-05-10 Schoharie New York 36095 1645 16
1302157 1302157 2021-05-09 Schoharie New York 36095 1643 16
1298909 1298909 2021-05-08 Schoharie New York 36095 1640 16
1295663 1295663 2021-05-07 Schoharie New York 36095 1632 16
1292417 1292417 2021-05-06 Schoharie New York 36095 1625 16
1289171 1289171 2021-05-05 Schoharie New York 36095 1623 16
1285925 1285925 2021-05-04 Schoharie New York 36095 1616 16
1282679 1282679 2021-05-03 Schoharie New York 36095 1615 16
1279432 1279432 2021-05-02 Schoharie New York 36095 1614 16
1276185 1276185 2021-05-01 Schoharie New York 36095 1609 16
1272938 1272938 2021-04-30 Schoharie New York 36095 1600 16
1269691 1269691 2021-04-29 Schoharie New York 36095 1591 16
1266444 1266444 2021-04-28 Schoharie New York 36095 1588 16
1263197 1263197 2021-04-27 Schoharie New York 36095 1585 16
1259950 1259950 2021-04-26 Schoharie New York 36095 1585 16
1256703 1256703 2021-04-25 Schoharie New York 36095 1583 16
1253456 1253456 2021-04-24 Schoharie New York 36095 1581 16
1250209 1250209 2021-04-23 Schoharie New York 36095 1579 16
1246962 1246962 2021-04-22 Schoharie New York 36095 1573 16
1243715 1243715 2021-04-21 Schoharie New York 36095 1568 16
1240468 1240468 2021-04-20 Schoharie New York 36095 1562 16
1237221 1237221 2021-04-19 Schoharie New York 36095 1555 16
941811 941811 2021-01-18 Yates New York 36123 813 16
938523 938523 2021-01-17 Essex New York 36031 967 16
938566 938566 2021-01-17 Yates New York 36123 795 16
935272 935272 2021-01-16 Clinton New York 36019 2040 16
935275 935275 2021-01-16 Delaware New York 36025 983 16
935278 935278 2021-01-16 Essex New York 36031 960 16
935321 935321 2021-01-16 Yates New York 36123 783 16
932030 932030 2021-01-15 Delaware New York 36025 965 16
932033 932033 2021-01-15 Essex New York 36031 937 16
932076 932076 2021-01-15 Yates New York 36123 758 16
928785 928785 2021-01-14 Delaware New York 36025 951 16
928788 928788 2021-01-14 Essex New York 36031 908 16
928831 928831 2021-01-14 Yates New York 36123 745 16
925543 925543 2021-01-13 Essex New York 36031 894 16
922297 922297 2021-01-12 Essex New York 36031 876 16
922304 922304 2021-01-12 Jefferson New York 36045 2652 16
919052 919052 2021-01-11 Essex New York 36031 861 16
919059 919059 2021-01-11 Jefferson New York 36045 2572 16
915807 915807 2021-01-10 Essex New York 36031 855 16
915814 915814 2021-01-10 Jefferson New York 36045 2493 16
912562 912562 2021-01-09 Essex New York 36031 840 16
912569 912569 2021-01-09 Jefferson New York 36045 2423 16
909317 909317 2021-01-08 Essex New York 36031 786 16
906072 906072 2021-01-07 Essex New York 36031 724 16
902826 902826 2021-01-06 Essex New York 36031 687 16
902862 902862 2021-01-06 Tompkins New York 36109 2225 16
899581 899581 2021-01-05 Essex New York 36031 671 16
899603 899603 2021-01-05 Otsego New York 36077 1294 16

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);