ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where county = "Stearns", deaths = 19 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 |
---|---|---|---|---|---|---|---|
377679 | 377679 | 2020-07-28 | Stearns | Minnesota | 27145 | 2742 | 19 |
374464 | 374464 | 2020-07-27 | Stearns | Minnesota | 27145 | 2734 | 19 |
371252 | 371252 | 2020-07-26 | Stearns | Minnesota | 27145 | 2721 | 19 |
368042 | 368042 | 2020-07-25 | Stearns | Minnesota | 27145 | 2712 | 19 |
364834 | 364834 | 2020-07-24 | Stearns | Minnesota | 27145 | 2695 | 19 |
361627 | 361627 | 2020-07-23 | Stearns | Minnesota | 27145 | 2678 | 19 |
358422 | 358422 | 2020-07-22 | Stearns | Minnesota | 27145 | 2666 | 19 |
355219 | 355219 | 2020-07-21 | Stearns | Minnesota | 27145 | 2659 | 19 |
352017 | 352017 | 2020-07-20 | Stearns | Minnesota | 27145 | 2643 | 19 |
348817 | 348817 | 2020-07-19 | Stearns | Minnesota | 27145 | 2643 | 19 |
345616 | 345616 | 2020-07-18 | Stearns | Minnesota | 27145 | 2631 | 19 |
342416 | 342416 | 2020-07-17 | Stearns | Minnesota | 27145 | 2615 | 19 |
339220 | 339220 | 2020-07-16 | Stearns | Minnesota | 27145 | 2596 | 19 |
336024 | 336024 | 2020-07-15 | Stearns | Minnesota | 27145 | 2575 | 19 |
332831 | 332831 | 2020-07-14 | Stearns | Minnesota | 27145 | 2549 | 19 |
329644 | 329644 | 2020-07-13 | Stearns | Minnesota | 27145 | 2536 | 19 |
326458 | 326458 | 2020-07-12 | Stearns | Minnesota | 27145 | 2523 | 19 |
323275 | 323275 | 2020-07-11 | Stearns | Minnesota | 27145 | 2496 | 19 |
320096 | 320096 | 2020-07-10 | Stearns | Minnesota | 27145 | 2481 | 19 |
316921 | 316921 | 2020-07-09 | Stearns | Minnesota | 27145 | 2448 | 19 |
313747 | 313747 | 2020-07-08 | Stearns | Minnesota | 27145 | 2429 | 19 |
310577 | 310577 | 2020-07-07 | Stearns | Minnesota | 27145 | 2414 | 19 |
307409 | 307409 | 2020-07-06 | Stearns | Minnesota | 27145 | 2371 | 19 |
304242 | 304242 | 2020-07-05 | Stearns | Minnesota | 27145 | 2361 | 19 |
301078 | 301078 | 2020-07-04 | Stearns | Minnesota | 27145 | 2345 | 19 |
297915 | 297915 | 2020-07-03 | Stearns | Minnesota | 27145 | 2345 | 19 |
294757 | 294757 | 2020-07-02 | Stearns | Minnesota | 27145 | 2312 | 19 |
291603 | 291603 | 2020-07-01 | Stearns | Minnesota | 27145 | 2287 | 19 |
288452 | 288452 | 2020-06-30 | Stearns | Minnesota | 27145 | 2265 | 19 |
285302 | 285302 | 2020-06-29 | Stearns | Minnesota | 27145 | 2228 | 19 |
282157 | 282157 | 2020-06-28 | Stearns | Minnesota | 27145 | 2200 | 19 |
279009 | 279009 | 2020-06-27 | Stearns | Minnesota | 27145 | 2166 | 19 |
275861 | 275861 | 2020-06-26 | Stearns | Minnesota | 27145 | 2156 | 19 |
272718 | 272718 | 2020-06-25 | Stearns | Minnesota | 27145 | 2141 | 19 |
269581 | 269581 | 2020-06-24 | Stearns | Minnesota | 27145 | 2140 | 19 |
266448 | 266448 | 2020-06-23 | Stearns | Minnesota | 27145 | 2139 | 19 |
263322 | 263322 | 2020-06-22 | Stearns | Minnesota | 27145 | 2137 | 19 |
260193 | 260193 | 2020-06-21 | Stearns | Minnesota | 27145 | 2134 | 19 |
257067 | 257067 | 2020-06-20 | Stearns | Minnesota | 27145 | 2131 | 19 |
253947 | 253947 | 2020-06-19 | Stearns | Minnesota | 27145 | 2126 | 19 |
250832 | 250832 | 2020-06-18 | Stearns | Minnesota | 27145 | 2122 | 19 |
247720 | 247720 | 2020-06-17 | Stearns | Minnesota | 27145 | 2111 | 19 |
244607 | 244607 | 2020-06-16 | Stearns | Minnesota | 27145 | 2109 | 19 |
241496 | 241496 | 2020-06-15 | Stearns | Minnesota | 27145 | 2108 | 19 |
238387 | 238387 | 2020-06-14 | Stearns | Minnesota | 27145 | 2107 | 19 |
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);