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 "date" is on date 2022-03-25 and state = "Vermont" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

fips 15

state 1

  • Vermont · 15 ✖
Link rowid date ▲ county state fips cases deaths
2342970 2342970 2022-03-25 Addison Vermont 50001 5418 15
2342971 2342971 2022-03-25 Bennington Vermont 50003 9400 66
2342972 2342972 2022-03-25 Caledonia Vermont 50005 5618 24
2342973 2342973 2022-03-25 Chittenden Vermont 50007 30621 163
2342974 2342974 2022-03-25 Essex Vermont 50009 1274 3
2342975 2342975 2022-03-25 Franklin Vermont 50011 9409 66
2342976 2342976 2022-03-25 Grand Isle Vermont 50013 1013 5
2342977 2342977 2022-03-25 Lamoille Vermont 50015 3813 17
2342978 2342978 2022-03-25 Orange Vermont 50017 4889 14
2342979 2342979 2022-03-25 Orleans Vermont 50019 6185 37
2342980 2342980 2022-03-25 Rutland Vermont 50021 12365 71
2342981 2342981 2022-03-25 Unknown Vermont   1003 2
2342982 2342982 2022-03-25 Washington Vermont 50023 9573 47
2342983 2342983 2022-03-25 Windham Vermont 50025 6612 35
2342984 2342984 2022-03-25 Windsor Vermont 50027 8656 50

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