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

15 rows where "date" is on date 2020-08-19 and state = "Massachusetts" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 15

state 1

  • Massachusetts · 15 ✖
Link rowid date ▲ county state fips cases deaths
448365 448365 2020-08-19 Barnstable Massachusetts 25001 1812 164
448366 448366 2020-08-19 Berkshire Massachusetts 25003 673 46
448367 448367 2020-08-19 Bristol Massachusetts 25005 9513 644
448368 448368 2020-08-19 Dukes Massachusetts 25007 68 0
448369 448369 2020-08-19 Essex Massachusetts 25009 18291 1205
448370 448370 2020-08-19 Franklin Massachusetts 25011 414 61
448371 448371 2020-08-19 Hampden Massachusetts 25013 7752 729
448372 448372 2020-08-19 Hampshire Massachusetts 25015 1221 131
448373 448373 2020-08-19 Middlesex Massachusetts 25017 26896 2034
448374 448374 2020-08-19 Nantucket Massachusetts 25019 37 1
448375 448375 2020-08-19 Norfolk Massachusetts 25021 10796 1004
448376 448376 2020-08-19 Plymouth Massachusetts 25023 9409 730
448377 448377 2020-08-19 Suffolk Massachusetts 25025 22511 1090
448378 448378 2020-08-19 Unknown Massachusetts   1156 5
448379 448379 2020-08-19 Worcester Massachusetts 25027 13866 1032

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