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

17 rows where county = "Belmont" and deaths = 7 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 · 17 ✖
Link rowid date ▲ county state fips cases deaths
141111 141111 2020-05-13 Belmont Ohio 39013 276 7
138115 138115 2020-05-12 Belmont Ohio 39013 266 7
135125 135125 2020-05-11 Belmont Ohio 39013 258 7
132134 132134 2020-05-10 Belmont Ohio 39013 234 7
129145 129145 2020-05-09 Belmont Ohio 39013 229 7
126156 126156 2020-05-08 Belmont Ohio 39013 216 7
123173 123173 2020-05-07 Belmont Ohio 39013 205 7
120196 120196 2020-05-06 Belmont Ohio 39013 201 7
117235 117235 2020-05-05 Belmont Ohio 39013 181 7
114354 114354 2020-05-04 Belmont Ohio 39013 174 7
111473 111473 2020-05-03 Belmont Ohio 39013 163 7
108599 108599 2020-05-02 Belmont Ohio 39013 156 7
105732 105732 2020-05-01 Belmont Ohio 39013 153 7
102869 102869 2020-04-30 Belmont Ohio 39013 144 7
100016 100016 2020-04-29 Belmont Ohio 39013 128 7
97167 97167 2020-04-28 Belmont Ohio 39013 118 7
94330 94330 2020-04-27 Belmont Ohio 39013 114 7

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