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 cases = 18820 sorted by date descending

✎ View and edit SQL

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

These facets timed out: county, fips

Link rowid date ▲ county state fips cases deaths
2360368 2360368 2022-03-31 Wayne Indiana 18177 18820 334
2357114 2357114 2022-03-30 Wayne Indiana 18177 18820 334
2132597 2132597 2022-01-20 Williamson Illinois 17199 18820 229
1642580 1642580 2021-08-22 St. Louis Minnesota 27137 18820 324
1639330 1639330 2021-08-21 St. Louis Minnesota 27137 18820 324
1636080 1636080 2021-08-20 St. Louis Minnesota 27137 18820 324
1460828 1460828 2021-06-27 Boone Missouri 29019 18820 117
1457583 1457583 2021-06-26 Boone Missouri 29019 18820 117
1454338 1454338 2021-06-25 Boone Missouri 29019 18820 117
1324946 1324946 2021-05-16 Iredell North Carolina 37097 18820 208
1321700 1321700 2021-05-15 Iredell North Carolina 37097 18820 208
1318454 1318454 2021-05-14 Iredell North Carolina 37097 18820 208
999111 999111 2021-02-05 Tippecanoe Indiana 18157 18820 176
924831 924831 2021-01-13 Lafayette Louisiana 22055 18820 208
805326 805326 2020-12-07 Lancaster Nebraska 31109 18820 97

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