ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where county = "Goodhue", deaths = 8 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
409802 | 409802 | 2020-08-07 | Goodhue | Minnesota | 27049 | 192 | 8 |
406582 | 406582 | 2020-08-06 | Goodhue | Minnesota | 27049 | 187 | 8 |
403364 | 403364 | 2020-08-05 | Goodhue | Minnesota | 27049 | 183 | 8 |
400147 | 400147 | 2020-08-04 | Goodhue | Minnesota | 27049 | 177 | 8 |
396933 | 396933 | 2020-08-03 | Goodhue | Minnesota | 27049 | 176 | 8 |
393717 | 393717 | 2020-08-02 | Goodhue | Minnesota | 27049 | 175 | 8 |
390500 | 390500 | 2020-08-01 | Goodhue | Minnesota | 27049 | 173 | 8 |
387283 | 387283 | 2020-07-31 | Goodhue | Minnesota | 27049 | 169 | 8 |
384065 | 384065 | 2020-07-30 | Goodhue | Minnesota | 27049 | 163 | 8 |
380848 | 380848 | 2020-07-29 | Goodhue | Minnesota | 27049 | 161 | 8 |
377631 | 377631 | 2020-07-28 | Goodhue | Minnesota | 27049 | 159 | 8 |
374416 | 374416 | 2020-07-27 | Goodhue | Minnesota | 27049 | 159 | 8 |
371204 | 371204 | 2020-07-26 | Goodhue | Minnesota | 27049 | 159 | 8 |
367994 | 367994 | 2020-07-25 | Goodhue | Minnesota | 27049 | 157 | 8 |
364787 | 364787 | 2020-07-24 | Goodhue | Minnesota | 27049 | 155 | 8 |
361580 | 361580 | 2020-07-23 | Goodhue | Minnesota | 27049 | 154 | 8 |
358375 | 358375 | 2020-07-22 | Goodhue | Minnesota | 27049 | 153 | 8 |
355172 | 355172 | 2020-07-21 | Goodhue | Minnesota | 27049 | 151 | 8 |
351970 | 351970 | 2020-07-20 | Goodhue | Minnesota | 27049 | 148 | 8 |
348770 | 348770 | 2020-07-19 | Goodhue | Minnesota | 27049 | 147 | 8 |
345569 | 345569 | 2020-07-18 | Goodhue | Minnesota | 27049 | 147 | 8 |
342369 | 342369 | 2020-07-17 | Goodhue | Minnesota | 27049 | 146 | 8 |
339173 | 339173 | 2020-07-16 | Goodhue | Minnesota | 27049 | 146 | 8 |
335977 | 335977 | 2020-07-15 | Goodhue | Minnesota | 27049 | 146 | 8 |
332784 | 332784 | 2020-07-14 | Goodhue | Minnesota | 27049 | 142 | 8 |
329597 | 329597 | 2020-07-13 | Goodhue | Minnesota | 27049 | 142 | 8 |
326411 | 326411 | 2020-07-12 | Goodhue | Minnesota | 27049 | 142 | 8 |
323228 | 323228 | 2020-07-11 | Goodhue | Minnesota | 27049 | 140 | 8 |
320049 | 320049 | 2020-07-10 | Goodhue | Minnesota | 27049 | 138 | 8 |
316874 | 316874 | 2020-07-09 | Goodhue | Minnesota | 27049 | 137 | 8 |
313700 | 313700 | 2020-07-08 | Goodhue | Minnesota | 27049 | 132 | 8 |
310530 | 310530 | 2020-07-07 | Goodhue | Minnesota | 27049 | 131 | 8 |
307362 | 307362 | 2020-07-06 | Goodhue | Minnesota | 27049 | 131 | 8 |
304195 | 304195 | 2020-07-05 | Goodhue | Minnesota | 27049 | 130 | 8 |
301031 | 301031 | 2020-07-04 | Goodhue | Minnesota | 27049 | 129 | 8 |
297868 | 297868 | 2020-07-03 | Goodhue | Minnesota | 27049 | 129 | 8 |
294710 | 294710 | 2020-07-02 | Goodhue | Minnesota | 27049 | 127 | 8 |
291556 | 291556 | 2020-07-01 | Goodhue | Minnesota | 27049 | 124 | 8 |
288405 | 288405 | 2020-06-30 | Goodhue | Minnesota | 27049 | 119 | 8 |
285255 | 285255 | 2020-06-29 | Goodhue | Minnesota | 27049 | 117 | 8 |
282110 | 282110 | 2020-06-28 | Goodhue | Minnesota | 27049 | 117 | 8 |
278962 | 278962 | 2020-06-27 | Goodhue | Minnesota | 27049 | 113 | 8 |
275814 | 275814 | 2020-06-26 | Goodhue | Minnesota | 27049 | 111 | 8 |
272671 | 272671 | 2020-06-25 | Goodhue | Minnesota | 27049 | 109 | 8 |
269534 | 269534 | 2020-06-24 | Goodhue | Minnesota | 27049 | 109 | 8 |
266401 | 266401 | 2020-06-23 | Goodhue | Minnesota | 27049 | 108 | 8 |
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);