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

19 rows where cases = 314 and state = "New York" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date

fips 15

state 1

  • New York · 19 ✖
Link rowid date ▲ county state fips cases deaths
779531 779531 2020-11-29 Schuyler New York 36097 314 3
760028 760028 2020-11-23 Delaware New York 36025 314 6
678910 678910 2020-10-29 Allegany New York 36003 314 12
610838 610838 2020-10-08 Washington New York 36115 314 14
565455 565455 2020-09-24 Wayne New York 36117 314 3
552466 552466 2020-09-20 Genesee New York 36037 314 6
549227 549227 2020-09-19 Genesee New York 36037 314 6
546016 546016 2020-09-18 St. Lawrence New York 36089 314 4
539518 539518 2020-09-16 Herkimer New York 36043 314 10
533061 533061 2020-09-14 Otsego New York 36077 314 4
529826 529826 2020-09-13 Otsego New York 36077 314 4
510395 510395 2020-09-07 Greene New York 36039 314 14
507162 507162 2020-09-06 Greene New York 36039 314 14
507178 507178 2020-09-06 Orleans New York 36073 314 55
500713 500713 2020-09-04 Oswego New York 36075 314 3
455483 455483 2020-08-21 Warren New York 36113 314 30
137921 137921 2020-05-12 Columbia New York 36021 314 26
134931 134931 2020-05-11 Columbia New York 36021 314 23
34617 34617 2020-04-05 Putnam New York 36079 314 9

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