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

20 rows where cases = 2019 and state = "Missouri" sorted by date descending

✎ View and edit SQL

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

fips 12

state 1

  • Missouri · 20 ✖
Link rowid date ▲ county state fips cases deaths
2338379 2338379 2022-03-24 Oregon Missouri 29149 2019 33
2335125 2335125 2022-03-23 Oregon Missouri 29149 2019 33
2331871 2331871 2022-03-22 Oregon Missouri 29149 2019 33
2328618 2328618 2022-03-21 Oregon Missouri 29149 2019 32
2130179 2130179 2022-01-19 Grundy Missouri 29079 2019 61
1704438 1704438 2021-09-10 Gasconade Missouri 29073 2019 48
1480403 1480403 2021-07-03 Vernon Missouri 29217 2019 46
1431698 1431698 2021-06-18 Ray Missouri 29177 2019 27
1223879 1223879 2021-04-15 Henry Missouri 29083 2019 38
1220632 1220632 2021-04-14 Henry Missouri 29083 2019 38
1217384 1217384 2021-04-13 Henry Missouri 29083 2019 38
1103713 1103713 2021-03-09 Clinton Missouri 29049 2019 65
1100467 1100467 2021-03-08 Clinton Missouri 29049 2019 65
1025870 1025870 2021-02-13 Perry Missouri 29157 2019 23
1022625 1022625 2021-02-12 Perry Missouri 29157 2019 23
1019327 1019327 2021-02-11 Crawford Missouri 29055 2019 29
1019380 1019380 2021-02-11 Perry Missouri 29157 2019 23
993338 993338 2021-02-03 Audrain Missouri 29007 2019 50
801910 801910 2020-12-06 Lawrence Missouri 29109 2019 39
668907 668907 2020-10-26 Newton Missouri 29145 2019 21

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