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

13 rows where deaths = 1, fips = 28121 and state = "Mississippi" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi · 13 ✖

fips 1

  • 28121 · 13 ✖

county 1

Link rowid date ▲ county state fips cases deaths
39334 39334 2020-04-07 Rankin Mississippi 28121 78 1
36823 36823 2020-04-06 Rankin Mississippi 28121 74 1
34360 34360 2020-04-05 Rankin Mississippi 28121 72 1
31933 31933 2020-04-04 Rankin Mississippi 28121 66 1
29553 29553 2020-04-03 Rankin Mississippi 28121 64 1
27234 27234 2020-04-02 Rankin Mississippi 28121 50 1
24980 24980 2020-04-01 Rankin Mississippi 28121 48 1
22796 22796 2020-03-31 Rankin Mississippi 28121 40 1
20679 20679 2020-03-30 Rankin Mississippi 28121 37 1
18655 18655 2020-03-29 Rankin Mississippi 28121 35 1
16733 16733 2020-03-28 Rankin Mississippi 28121 31 1
14909 14909 2020-03-27 Rankin Mississippi 28121 29 1
13190 13190 2020-03-26 Rankin Mississippi 28121 23 1

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