ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where county = "Wexford", deaths = 3, fips = 26165 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
285230 | 285230 | 2020-06-29 | Wexford | Michigan | 26165 | 25 | 3 |
282085 | 282085 | 2020-06-28 | Wexford | Michigan | 26165 | 25 | 3 |
278937 | 278937 | 2020-06-27 | Wexford | Michigan | 26165 | 24 | 3 |
275789 | 275789 | 2020-06-26 | Wexford | Michigan | 26165 | 23 | 3 |
272646 | 272646 | 2020-06-25 | Wexford | Michigan | 26165 | 23 | 3 |
269509 | 269509 | 2020-06-24 | Wexford | Michigan | 26165 | 22 | 3 |
266376 | 266376 | 2020-06-23 | Wexford | Michigan | 26165 | 22 | 3 |
263250 | 263250 | 2020-06-22 | Wexford | Michigan | 26165 | 22 | 3 |
260121 | 260121 | 2020-06-21 | Wexford | Michigan | 26165 | 22 | 3 |
256995 | 256995 | 2020-06-20 | Wexford | Michigan | 26165 | 22 | 3 |
253875 | 253875 | 2020-06-19 | Wexford | Michigan | 26165 | 22 | 3 |
250760 | 250760 | 2020-06-18 | Wexford | Michigan | 26165 | 21 | 3 |
247648 | 247648 | 2020-06-17 | Wexford | Michigan | 26165 | 21 | 3 |
244535 | 244535 | 2020-06-16 | Wexford | Michigan | 26165 | 21 | 3 |
241424 | 241424 | 2020-06-15 | Wexford | Michigan | 26165 | 21 | 3 |
238315 | 238315 | 2020-06-14 | Wexford | Michigan | 26165 | 20 | 3 |
235208 | 235208 | 2020-06-13 | Wexford | Michigan | 26165 | 19 | 3 |
232103 | 232103 | 2020-06-12 | Wexford | Michigan | 26165 | 19 | 3 |
228999 | 228999 | 2020-06-11 | Wexford | Michigan | 26165 | 18 | 3 |
225897 | 225897 | 2020-06-10 | Wexford | Michigan | 26165 | 18 | 3 |
222799 | 222799 | 2020-06-09 | Wexford | Michigan | 26165 | 18 | 3 |
219704 | 219704 | 2020-06-08 | Wexford | Michigan | 26165 | 18 | 3 |
216612 | 216612 | 2020-06-07 | Wexford | Michigan | 26165 | 18 | 3 |
213524 | 213524 | 2020-06-06 | Wexford | Michigan | 26165 | 18 | 3 |
210440 | 210440 | 2020-06-05 | Wexford | Michigan | 26165 | 18 | 3 |
207359 | 207359 | 2020-06-04 | Wexford | Michigan | 26165 | 18 | 3 |
204278 | 204278 | 2020-06-03 | Wexford | Michigan | 26165 | 18 | 3 |
201201 | 201201 | 2020-06-02 | Wexford | Michigan | 26165 | 18 | 3 |
198128 | 198128 | 2020-06-01 | Wexford | Michigan | 26165 | 18 | 3 |
195057 | 195057 | 2020-05-31 | Wexford | Michigan | 26165 | 11 | 3 |
191989 | 191989 | 2020-05-30 | Wexford | Michigan | 26165 | 11 | 3 |
188925 | 188925 | 2020-05-29 | Wexford | Michigan | 26165 | 11 | 3 |
185867 | 185867 | 2020-05-28 | Wexford | Michigan | 26165 | 11 | 3 |
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);