ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Stearns" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387331 | 387331 | 2020-07-31 | Stearns | Minnesota | 27145 | 2791 | 20 |
384113 | 384113 | 2020-07-30 | Stearns | Minnesota | 27145 | 2763 | 20 |
380896 | 380896 | 2020-07-29 | Stearns | Minnesota | 27145 | 2758 | 20 |
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 |
235280 | 235280 | 2020-06-13 | Stearns | Minnesota | 27145 | 2100 | 18 |
232174 | 232174 | 2020-06-12 | Stearns | Minnesota | 27145 | 2096 | 17 |
229070 | 229070 | 2020-06-11 | Stearns | Minnesota | 27145 | 2088 | 17 |
225968 | 225968 | 2020-06-10 | Stearns | Minnesota | 27145 | 2081 | 17 |
222870 | 222870 | 2020-06-09 | Stearns | Minnesota | 27145 | 2076 | 17 |
219775 | 219775 | 2020-06-08 | Stearns | Minnesota | 27145 | 2071 | 16 |
216683 | 216683 | 2020-06-07 | Stearns | Minnesota | 27145 | 2070 | 16 |
213595 | 213595 | 2020-06-06 | Stearns | Minnesota | 27145 | 2063 | 15 |
210511 | 210511 | 2020-06-05 | Stearns | Minnesota | 27145 | 2056 | 14 |
207430 | 207430 | 2020-06-04 | Stearns | Minnesota | 27145 | 2050 | 14 |
204349 | 204349 | 2020-06-03 | Stearns | Minnesota | 27145 | 2047 | 14 |
201272 | 201272 | 2020-06-02 | Stearns | Minnesota | 27145 | 2042 | 13 |
198199 | 198199 | 2020-06-01 | Stearns | Minnesota | 27145 | 2030 | 13 |
195128 | 195128 | 2020-05-31 | Stearns | Minnesota | 27145 | 2021 | 13 |
192060 | 192060 | 2020-05-30 | Stearns | Minnesota | 27145 | 2014 | 13 |
188996 | 188996 | 2020-05-29 | Stearns | Minnesota | 27145 | 2001 | 13 |
185938 | 185938 | 2020-05-28 | Stearns | Minnesota | 27145 | 1995 | 12 |
182883 | 182883 | 2020-05-27 | Stearns | Minnesota | 27145 | 1984 | 12 |
179837 | 179837 | 2020-05-26 | Stearns | Minnesota | 27145 | 1959 | 12 |
176793 | 176793 | 2020-05-25 | Stearns | Minnesota | 27145 | 1950 | 12 |
173750 | 173750 | 2020-05-24 | Stearns | Minnesota | 27145 | 1923 | 12 |
170708 | 170708 | 2020-05-23 | Stearns | Minnesota | 27145 | 1918 | 12 |
167670 | 167670 | 2020-05-22 | Stearns | Minnesota | 27145 | 1881 | 12 |
164634 | 164634 | 2020-05-21 | Stearns | Minnesota | 27145 | 1853 | 11 |
161605 | 161605 | 2020-05-20 | Stearns | Minnesota | 27145 | 1831 | 11 |
158579 | 158579 | 2020-05-19 | Stearns | Minnesota | 27145 | 1782 | 10 |
155561 | 155561 | 2020-05-18 | Stearns | Minnesota | 27145 | 1740 | 10 |
152547 | 152547 | 2020-05-17 | Stearns | Minnesota | 27145 | 1713 | 10 |
149536 | 149536 | 2020-05-16 | Stearns | Minnesota | 27145 | 1675 | 10 |
146531 | 146531 | 2020-05-15 | Stearns | Minnesota | 27145 | 1641 | 9 |
143531 | 143531 | 2020-05-14 | Stearns | Minnesota | 27145 | 1609 | 9 |
140536 | 140536 | 2020-05-13 | Stearns | Minnesota | 27145 | 1512 | 6 |
137542 | 137542 | 2020-05-12 | Stearns | Minnesota | 27145 | 1512 | 6 |
134552 | 134552 | 2020-05-11 | Stearns | Minnesota | 27145 | 1443 | 6 |
131561 | 131561 | 2020-05-10 | Stearns | Minnesota | 27145 | 1405 | 5 |
128571 | 128571 | 2020-05-09 | Stearns | Minnesota | 27145 | 1348 | 5 |
125584 | 125584 | 2020-05-08 | Stearns | Minnesota | 27145 | 1274 | 4 |
122602 | 122602 | 2020-05-07 | Stearns | Minnesota | 27145 | 1161 | 4 |
119628 | 119628 | 2020-05-06 | Stearns | Minnesota | 27145 | 975 | 3 |
116668 | 116668 | 2020-05-05 | Stearns | Minnesota | 27145 | 815 | 2 |
113786 | 113786 | 2020-05-04 | Stearns | Minnesota | 27145 | 728 | 2 |
110907 | 110907 | 2020-05-03 | Stearns | Minnesota | 27145 | 589 | 0 |
108036 | 108036 | 2020-05-02 | Stearns | Minnesota | 27145 | 531 | 0 |
105171 | 105171 | 2020-05-01 | Stearns | Minnesota | 27145 | 435 | 0 |
102310 | 102310 | 2020-04-30 | Stearns | Minnesota | 27145 | 267 | 0 |
99458 | 99458 | 2020-04-29 | Stearns | Minnesota | 27145 | 166 | 0 |
96612 | 96612 | 2020-04-28 | Stearns | Minnesota | 27145 | 86 | 0 |
93777 | 93777 | 2020-04-27 | Stearns | Minnesota | 27145 | 55 | 0 |
90956 | 90956 | 2020-04-26 | Stearns | Minnesota | 27145 | 38 | 0 |
88140 | 88140 | 2020-04-25 | Stearns | Minnesota | 27145 | 38 | 0 |
85330 | 85330 | 2020-04-24 | Stearns | Minnesota | 27145 | 33 | 0 |
82526 | 82526 | 2020-04-23 | Stearns | Minnesota | 27145 | 25 | 0 |
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);