ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where county = "Medina", deaths = 31 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
285971 | 285971 | 2020-06-29 | Medina | Ohio | 39103 | 469 | 31 |
282826 | 282826 | 2020-06-28 | Medina | Ohio | 39103 | 464 | 31 |
279680 | 279680 | 2020-06-27 | Medina | Ohio | 39103 | 460 | 31 |
276532 | 276532 | 2020-06-26 | Medina | Ohio | 39103 | 451 | 31 |
273385 | 273385 | 2020-06-25 | Medina | Ohio | 39103 | 441 | 31 |
270246 | 270246 | 2020-06-24 | Medina | Ohio | 39103 | 434 | 31 |
267112 | 267112 | 2020-06-23 | Medina | Ohio | 39103 | 426 | 31 |
263984 | 263984 | 2020-06-22 | Medina | Ohio | 39103 | 416 | 31 |
260856 | 260856 | 2020-06-21 | Medina | Ohio | 39103 | 413 | 31 |
257729 | 257729 | 2020-06-20 | Medina | Ohio | 39103 | 407 | 31 |
254604 | 254604 | 2020-06-19 | Medina | Ohio | 39103 | 406 | 31 |
251489 | 251489 | 2020-06-18 | Medina | Ohio | 39103 | 404 | 31 |
248374 | 248374 | 2020-06-17 | Medina | Ohio | 39103 | 402 | 31 |
Advanced export
JSON shape: default, array, newline-delimited
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);