ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 27013 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387265 | 387265 | 2020-07-31 | Blue Earth | Minnesota | 27013 | 824 | 4 |
384047 | 384047 | 2020-07-30 | Blue Earth | Minnesota | 27013 | 801 | 4 |
380830 | 380830 | 2020-07-29 | Blue Earth | Minnesota | 27013 | 794 | 4 |
377613 | 377613 | 2020-07-28 | Blue Earth | Minnesota | 27013 | 783 | 4 |
374398 | 374398 | 2020-07-27 | Blue Earth | Minnesota | 27013 | 774 | 4 |
371186 | 371186 | 2020-07-26 | Blue Earth | Minnesota | 27013 | 767 | 3 |
367976 | 367976 | 2020-07-25 | Blue Earth | Minnesota | 27013 | 750 | 3 |
364769 | 364769 | 2020-07-24 | Blue Earth | Minnesota | 27013 | 735 | 3 |
361562 | 361562 | 2020-07-23 | Blue Earth | Minnesota | 27013 | 726 | 3 |
358357 | 358357 | 2020-07-22 | Blue Earth | Minnesota | 27013 | 710 | 3 |
355154 | 355154 | 2020-07-21 | Blue Earth | Minnesota | 27013 | 701 | 2 |
351952 | 351952 | 2020-07-20 | Blue Earth | Minnesota | 27013 | 679 | 2 |
348752 | 348752 | 2020-07-19 | Blue Earth | Minnesota | 27013 | 669 | 2 |
345551 | 345551 | 2020-07-18 | Blue Earth | Minnesota | 27013 | 658 | 2 |
342351 | 342351 | 2020-07-17 | Blue Earth | Minnesota | 27013 | 653 | 2 |
339155 | 339155 | 2020-07-16 | Blue Earth | Minnesota | 27013 | 639 | 2 |
335959 | 335959 | 2020-07-15 | Blue Earth | Minnesota | 27013 | 629 | 2 |
332766 | 332766 | 2020-07-14 | Blue Earth | Minnesota | 27013 | 600 | 2 |
329579 | 329579 | 2020-07-13 | Blue Earth | Minnesota | 27013 | 586 | 2 |
326393 | 326393 | 2020-07-12 | Blue Earth | Minnesota | 27013 | 575 | 2 |
323210 | 323210 | 2020-07-11 | Blue Earth | Minnesota | 27013 | 563 | 2 |
320031 | 320031 | 2020-07-10 | Blue Earth | Minnesota | 27013 | 544 | 2 |
316856 | 316856 | 2020-07-09 | Blue Earth | Minnesota | 27013 | 535 | 2 |
313682 | 313682 | 2020-07-08 | Blue Earth | Minnesota | 27013 | 510 | 2 |
310512 | 310512 | 2020-07-07 | Blue Earth | Minnesota | 27013 | 494 | 2 |
307344 | 307344 | 2020-07-06 | Blue Earth | Minnesota | 27013 | 479 | 2 |
304177 | 304177 | 2020-07-05 | Blue Earth | Minnesota | 27013 | 470 | 2 |
301013 | 301013 | 2020-07-04 | Blue Earth | Minnesota | 27013 | 453 | 2 |
297850 | 297850 | 2020-07-03 | Blue Earth | Minnesota | 27013 | 453 | 2 |
294692 | 294692 | 2020-07-02 | Blue Earth | Minnesota | 27013 | 442 | 2 |
291538 | 291538 | 2020-07-01 | Blue Earth | Minnesota | 27013 | 422 | 2 |
288387 | 288387 | 2020-06-30 | Blue Earth | Minnesota | 27013 | 403 | 2 |
285237 | 285237 | 2020-06-29 | Blue Earth | Minnesota | 27013 | 377 | 2 |
282092 | 282092 | 2020-06-28 | Blue Earth | Minnesota | 27013 | 368 | 2 |
278944 | 278944 | 2020-06-27 | Blue Earth | Minnesota | 27013 | 335 | 2 |
275796 | 275796 | 2020-06-26 | Blue Earth | Minnesota | 27013 | 317 | 2 |
272653 | 272653 | 2020-06-25 | Blue Earth | Minnesota | 27013 | 281 | 2 |
269516 | 269516 | 2020-06-24 | Blue Earth | Minnesota | 27013 | 265 | 2 |
266383 | 266383 | 2020-06-23 | Blue Earth | Minnesota | 27013 | 243 | 2 |
263257 | 263257 | 2020-06-22 | Blue Earth | Minnesota | 27013 | 227 | 2 |
260128 | 260128 | 2020-06-21 | Blue Earth | Minnesota | 27013 | 214 | 2 |
257002 | 257002 | 2020-06-20 | Blue Earth | Minnesota | 27013 | 191 | 2 |
253882 | 253882 | 2020-06-19 | Blue Earth | Minnesota | 27013 | 174 | 2 |
250767 | 250767 | 2020-06-18 | Blue Earth | Minnesota | 27013 | 172 | 2 |
247655 | 247655 | 2020-06-17 | Blue Earth | Minnesota | 27013 | 169 | 2 |
244542 | 244542 | 2020-06-16 | Blue Earth | Minnesota | 27013 | 164 | 2 |
241431 | 241431 | 2020-06-15 | Blue Earth | Minnesota | 27013 | 163 | 2 |
238322 | 238322 | 2020-06-14 | Blue Earth | Minnesota | 27013 | 163 | 2 |
235215 | 235215 | 2020-06-13 | Blue Earth | Minnesota | 27013 | 161 | 1 |
232110 | 232110 | 2020-06-12 | Blue Earth | Minnesota | 27013 | 159 | 1 |
229006 | 229006 | 2020-06-11 | Blue Earth | Minnesota | 27013 | 157 | 1 |
225904 | 225904 | 2020-06-10 | Blue Earth | Minnesota | 27013 | 154 | 1 |
222806 | 222806 | 2020-06-09 | Blue Earth | Minnesota | 27013 | 153 | 1 |
219711 | 219711 | 2020-06-08 | Blue Earth | Minnesota | 27013 | 152 | 0 |
216619 | 216619 | 2020-06-07 | Blue Earth | Minnesota | 27013 | 152 | 0 |
213531 | 213531 | 2020-06-06 | Blue Earth | Minnesota | 27013 | 151 | 0 |
210447 | 210447 | 2020-06-05 | Blue Earth | Minnesota | 27013 | 149 | 0 |
207366 | 207366 | 2020-06-04 | Blue Earth | Minnesota | 27013 | 148 | 0 |
204285 | 204285 | 2020-06-03 | Blue Earth | Minnesota | 27013 | 148 | 0 |
201208 | 201208 | 2020-06-02 | Blue Earth | Minnesota | 27013 | 145 | 0 |
198135 | 198135 | 2020-06-01 | Blue Earth | Minnesota | 27013 | 142 | 0 |
195064 | 195064 | 2020-05-31 | Blue Earth | Minnesota | 27013 | 140 | 0 |
191996 | 191996 | 2020-05-30 | Blue Earth | Minnesota | 27013 | 138 | 0 |
188932 | 188932 | 2020-05-29 | Blue Earth | Minnesota | 27013 | 137 | 1 |
185874 | 185874 | 2020-05-28 | Blue Earth | Minnesota | 27013 | 126 | 1 |
182819 | 182819 | 2020-05-27 | Blue Earth | Minnesota | 27013 | 122 | 1 |
179773 | 179773 | 2020-05-26 | Blue Earth | Minnesota | 27013 | 119 | 1 |
176729 | 176729 | 2020-05-25 | Blue Earth | Minnesota | 27013 | 115 | 1 |
173686 | 173686 | 2020-05-24 | Blue Earth | Minnesota | 27013 | 112 | 1 |
170644 | 170644 | 2020-05-23 | Blue Earth | Minnesota | 27013 | 110 | 1 |
167607 | 167607 | 2020-05-22 | Blue Earth | Minnesota | 27013 | 108 | 1 |
164571 | 164571 | 2020-05-21 | Blue Earth | Minnesota | 27013 | 104 | 1 |
161542 | 161542 | 2020-05-20 | Blue Earth | Minnesota | 27013 | 98 | 1 |
158516 | 158516 | 2020-05-19 | Blue Earth | Minnesota | 27013 | 93 | 0 |
155498 | 155498 | 2020-05-18 | Blue Earth | Minnesota | 27013 | 87 | 0 |
152484 | 152484 | 2020-05-17 | Blue Earth | Minnesota | 27013 | 83 | 0 |
149473 | 149473 | 2020-05-16 | Blue Earth | Minnesota | 27013 | 79 | 0 |
146468 | 146468 | 2020-05-15 | Blue Earth | Minnesota | 27013 | 76 | 0 |
143468 | 143468 | 2020-05-14 | Blue Earth | Minnesota | 27013 | 71 | 0 |
140473 | 140473 | 2020-05-13 | Blue Earth | Minnesota | 27013 | 67 | 0 |
137479 | 137479 | 2020-05-12 | Blue Earth | Minnesota | 27013 | 67 | 0 |
134489 | 134489 | 2020-05-11 | Blue Earth | Minnesota | 27013 | 67 | 0 |
131498 | 131498 | 2020-05-10 | Blue Earth | Minnesota | 27013 | 65 | 0 |
128508 | 128508 | 2020-05-09 | Blue Earth | Minnesota | 27013 | 64 | 0 |
125521 | 125521 | 2020-05-08 | Blue Earth | Minnesota | 27013 | 55 | 0 |
122539 | 122539 | 2020-05-07 | Blue Earth | Minnesota | 27013 | 55 | 0 |
119566 | 119566 | 2020-05-06 | Blue Earth | Minnesota | 27013 | 53 | 0 |
116606 | 116606 | 2020-05-05 | Blue Earth | Minnesota | 27013 | 51 | 0 |
113725 | 113725 | 2020-05-04 | Blue Earth | Minnesota | 27013 | 50 | 0 |
110846 | 110846 | 2020-05-03 | Blue Earth | Minnesota | 27013 | 46 | 0 |
107975 | 107975 | 2020-05-02 | Blue Earth | Minnesota | 27013 | 41 | 0 |
105111 | 105111 | 2020-05-01 | Blue Earth | Minnesota | 27013 | 38 | 0 |
102251 | 102251 | 2020-04-30 | Blue Earth | Minnesota | 27013 | 38 | 0 |
99399 | 99399 | 2020-04-29 | Blue Earth | Minnesota | 27013 | 34 | 0 |
96553 | 96553 | 2020-04-28 | Blue Earth | Minnesota | 27013 | 33 | 0 |
93718 | 93718 | 2020-04-27 | Blue Earth | Minnesota | 27013 | 30 | 0 |
90897 | 90897 | 2020-04-26 | Blue Earth | Minnesota | 27013 | 29 | 0 |
88081 | 88081 | 2020-04-25 | Blue Earth | Minnesota | 27013 | 27 | 0 |
85271 | 85271 | 2020-04-24 | Blue Earth | Minnesota | 27013 | 27 | 0 |
82467 | 82467 | 2020-04-23 | Blue Earth | Minnesota | 27013 | 26 | 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);