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

28 rows where county = "Belmont" and deaths = 181 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 · 28 ✖
Link rowid date ▲ county state fips cases deaths
1701722 1701722 2021-09-09 Belmont Ohio 39013 7424 181
1698473 1698473 2021-09-08 Belmont Ohio 39013 7363 181
1695225 1695225 2021-09-07 Belmont Ohio 39013 7284 181
1691977 1691977 2021-09-06 Belmont Ohio 39013 7252 181
1688728 1688728 2021-09-05 Belmont Ohio 39013 7206 181
1685478 1685478 2021-09-04 Belmont Ohio 39013 7167 181
1682227 1682227 2021-09-03 Belmont Ohio 39013 7104 181
1678977 1678977 2021-09-02 Belmont Ohio 39013 7070 181
1675729 1675729 2021-09-01 Belmont Ohio 39013 7019 181
1672482 1672482 2021-08-31 Belmont Ohio 39013 6957 181
1669234 1669234 2021-08-30 Belmont Ohio 39013 6903 181
1665987 1665987 2021-08-29 Belmont Ohio 39013 6868 181
1662739 1662739 2021-08-28 Belmont Ohio 39013 6850 181
1659491 1659491 2021-08-27 Belmont Ohio 39013 6800 181
1656242 1656242 2021-08-26 Belmont Ohio 39013 6769 181
1652995 1652995 2021-08-25 Belmont Ohio 39013 6729 181
1649748 1649748 2021-08-24 Belmont Ohio 39013 6693 181
1646499 1646499 2021-08-23 Belmont Ohio 39013 6651 181
1643250 1643250 2021-08-22 Belmont Ohio 39013 6621 181
1640000 1640000 2021-08-21 Belmont Ohio 39013 6607 181
1636750 1636750 2021-08-20 Belmont Ohio 39013 6584 181
1633500 1633500 2021-08-19 Belmont Ohio 39013 6556 181
1630253 1630253 2021-08-18 Belmont Ohio 39013 6530 181
1627006 1627006 2021-08-17 Belmont Ohio 39013 6484 181
1623759 1623759 2021-08-16 Belmont Ohio 39013 6467 181
1620512 1620512 2021-08-15 Belmont Ohio 39013 6438 181
1617264 1617264 2021-08-14 Belmont Ohio 39013 6428 181
1614016 1614016 2021-08-13 Belmont Ohio 39013 6410 181

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