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 = 1491 and state = "Missouri" sorted by date descending

✎ View and edit SQL

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

fips 13

county 13

state 1

  • Missouri · 20 ✖
Link rowid date ▲ county state fips cases deaths
2302537 2302537 2022-03-13 Carter Missouri 29035 1491 21
2299285 2299285 2022-03-12 Carter Missouri 29035 1491 21
2296033 2296033 2022-03-11 Carter Missouri 29035 1491 21
2292781 2292781 2022-03-10 Carter Missouri 29035 1491 21
2289529 2289529 2022-03-09 Carter Missouri 29035 1491 21
2286277 2286277 2022-03-08 Carter Missouri 29035 1491 21
2283025 2283025 2022-03-07 Carter Missouri 29035 1491 21
2133471 2133471 2022-01-20 Ozark Missouri 29153 1491 48
2078152 2078152 2022-01-03 Harrison Missouri 29081 1491 23
2006680 2006680 2021-12-12 Oregon Missouri 29149 1491 26
1983896 1983896 2021-12-05 Iron Missouri 29093 1491 27
1704459 1704459 2021-09-10 Lewis Missouri 29111 1491 21
1616712 1616712 2021-08-14 Cedar Missouri 29039 1491 22
1606953 1606953 2021-08-11 Barton Missouri 29011 1491 18
1106996 1106996 2021-03-10 Macon Missouri 29121 1491 15
1097279 1097279 2021-03-07 Pike Missouri 29163 1491 22
1094032 1094032 2021-03-06 Pike Missouri 29163 1491 22
831065 831065 2020-12-15 Adair Missouri 29001 1491 4
772704 772704 2020-11-27 Lafayette Missouri 29107 1491 29
746728 746728 2020-11-19 Howell Missouri 29091 1491 25

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