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

18 rows where deaths = 1326 and state = "Florida" sorted by date descending

✎ View and edit SQL

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

state 1

  • Florida · 18 ✖

fips 1

county 1

Link rowid date ▲ county state fips cases deaths
1989230 1989230 2021-12-07 Sarasota Florida 12115 56202 1326
1985980 1985980 2021-12-06 Sarasota Florida 12115 56202 1326
1982730 1982730 2021-12-05 Sarasota Florida 12115 56202 1326
1979480 1979480 2021-12-04 Sarasota Florida 12115 56202 1326
1976230 1976230 2021-12-03 Sarasota Florida 12115 56202 1326
1972981 1972981 2021-12-02 Sarasota Florida 12115 55941 1326
1969731 1969731 2021-12-01 Sarasota Florida 12115 55941 1326
1966481 1966481 2021-11-30 Sarasota Florida 12115 55941 1326
1963229 1963229 2021-11-29 Sarasota Florida 12115 55720 1326
1959978 1959978 2021-11-28 Sarasota Florida 12115 55720 1326
1956727 1956727 2021-11-27 Sarasota Florida 12115 55720 1326
1953476 1953476 2021-11-26 Sarasota Florida 12115 55720 1326
1950225 1950225 2021-11-25 Sarasota Florida 12115 55720 1326
1946974 1946974 2021-11-24 Sarasota Florida 12115 55720 1326
1943723 1943723 2021-11-23 Sarasota Florida 12115 55720 1326
1940473 1940473 2021-11-22 Sarasota Florida 12115 55720 1326
1937223 1937223 2021-11-21 Sarasota Florida 12115 55720 1326
1933973 1933973 2021-11-20 Sarasota Florida 12115 55720 1326

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