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 county = "Belmont" and deaths = 179 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

county 1

  • Belmont · 18 ✖
Link rowid date ▲ county state fips cases deaths
1601021 1601021 2021-08-09 Belmont Ohio 39013 6311 179
1597773 1597773 2021-08-08 Belmont Ohio 39013 6305 179
1594524 1594524 2021-08-07 Belmont Ohio 39013 6298 179
1591275 1591275 2021-08-06 Belmont Ohio 39013 6291 179
1588026 1588026 2021-08-05 Belmont Ohio 39013 6278 179
1584776 1584776 2021-08-04 Belmont Ohio 39013 6272 179
1581526 1581526 2021-08-03 Belmont Ohio 39013 6261 179
1578277 1578277 2021-08-02 Belmont Ohio 39013 6252 179
1575029 1575029 2021-08-01 Belmont Ohio 39013 6243 179
1571781 1571781 2021-07-31 Belmont Ohio 39013 6241 179
1568533 1568533 2021-07-30 Belmont Ohio 39013 6236 179
1565285 1565285 2021-07-29 Belmont Ohio 39013 6232 179
1562037 1562037 2021-07-28 Belmont Ohio 39013 6224 179
1558789 1558789 2021-07-27 Belmont Ohio 39013 6222 179
1555542 1555542 2021-07-26 Belmont Ohio 39013 6210 179
1552295 1552295 2021-07-25 Belmont Ohio 39013 6207 179
1549048 1549048 2021-07-24 Belmont Ohio 39013 6206 179
1545801 1545801 2021-07-23 Belmont Ohio 39013 6203 179

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