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 = 31028 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
2393148 2393148 2022-04-10 Daviess Kentucky 21059 31028 381
2389892 2389892 2022-04-09 Daviess Kentucky 21059 31028 381
2386636 2386636 2022-04-08 Daviess Kentucky 21059 31028 381
2383381 2383381 2022-04-07 Daviess Kentucky 21059 31028 381
2380126 2380126 2022-04-06 Daviess Kentucky 21059 31028 381
2376871 2376871 2022-04-05 Daviess Kentucky 21059 31028 381
2373619 2373619 2022-04-04 Daviess Kentucky 21059 31028 381
2360289 2360289 2022-03-31 Clark Indiana 18019 31028 395
2357035 2357035 2022-03-30 Clark Indiana 18019 31028 395
2299669 2299669 2022-03-12 Ulster New York 36111 31028 360
2221865 2221865 2022-02-16 Richland Ohio 39139 31028 480
1773271 1773271 2021-10-01 Warren Ohio 39165 31028 345
1768078 1768078 2021-09-30 Kings California 6031 31028 299
1181385 1181385 2021-04-02 Genesee Michigan 26049 31028 783
819747 819747 2020-12-11 Dane Wisconsin 55025 31028 116

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