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

27 rows where deaths = 16, fips = 36095 and state = "New York" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

  • New York · 27 ✖

fips 1

  • 36095 · 27 ✖

county 1

Link rowid date ▲ county state fips cases deaths
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

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