ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where county = "Ottawa" and deaths = 78 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1627146 | 1627146 | 2021-08-17 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1623899 | 1623899 | 2021-08-16 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1620652 | 1620652 | 2021-08-15 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1617404 | 1617404 | 2021-08-14 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1614156 | 1614156 | 2021-08-13 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1610907 | 1610907 | 2021-08-12 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1607659 | 1607659 | 2021-08-11 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1282912 | 1282912 | 2021-05-03 | Ottawa | Ohio | 39123 | 3652 | 78 |
1279665 | 1279665 | 2021-05-02 | Ottawa | Ohio | 39123 | 3651 | 78 |
1276418 | 1276418 | 2021-05-01 | Ottawa | Ohio | 39123 | 3651 | 78 |
1273171 | 1273171 | 2021-04-30 | Ottawa | Ohio | 39123 | 3648 | 78 |
1269924 | 1269924 | 2021-04-29 | Ottawa | Ohio | 39123 | 3646 | 78 |
1266677 | 1266677 | 2021-04-28 | Ottawa | Ohio | 39123 | 3637 | 78 |
1263430 | 1263430 | 2021-04-27 | Ottawa | Ohio | 39123 | 3627 | 78 |
1260183 | 1260183 | 2021-04-26 | Ottawa | Ohio | 39123 | 3621 | 78 |
1256936 | 1256936 | 2021-04-25 | Ottawa | Ohio | 39123 | 3614 | 78 |
1253689 | 1253689 | 2021-04-24 | Ottawa | Ohio | 39123 | 3612 | 78 |
1250442 | 1250442 | 2021-04-23 | Ottawa | Ohio | 39123 | 3605 | 78 |
1247195 | 1247195 | 2021-04-22 | Ottawa | Ohio | 39123 | 3599 | 78 |
1243948 | 1243948 | 2021-04-21 | Ottawa | Ohio | 39123 | 3595 | 78 |
1240701 | 1240701 | 2021-04-20 | Ottawa | Ohio | 39123 | 3590 | 78 |
1237454 | 1237454 | 2021-04-19 | Ottawa | Ohio | 39123 | 3579 | 78 |
1234207 | 1234207 | 2021-04-18 | Ottawa | Ohio | 39123 | 3573 | 78 |
1230959 | 1230959 | 2021-04-17 | Ottawa | Ohio | 39123 | 3569 | 78 |
1227711 | 1227711 | 2021-04-16 | Ottawa | Ohio | 39123 | 3565 | 78 |
1224463 | 1224463 | 2021-04-15 | Ottawa | Ohio | 39123 | 3554 | 78 |
1221216 | 1221216 | 2021-04-14 | Ottawa | Ohio | 39123 | 3542 | 78 |
1217968 | 1217968 | 2021-04-13 | Ottawa | Ohio | 39123 | 3536 | 78 |
1214720 | 1214720 | 2021-04-12 | Ottawa | Ohio | 39123 | 3531 | 78 |
1211473 | 1211473 | 2021-04-11 | Ottawa | Ohio | 39123 | 3522 | 78 |
1208224 | 1208224 | 2021-04-10 | Ottawa | Ohio | 39123 | 3519 | 78 |
1204976 | 1204976 | 2021-04-09 | Ottawa | Ohio | 39123 | 3512 | 78 |
684862 | 684862 | 2020-10-31 | Ottawa | Michigan | 26139 | 5779 | 78 |
681619 | 681619 | 2020-10-30 | Ottawa | Michigan | 26139 | 5569 | 78 |
678375 | 678375 | 2020-10-29 | Ottawa | Michigan | 26139 | 5418 | 78 |
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);