ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 27091 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387303 | 387303 | 2020-07-31 | Martin | Minnesota | 27091 | 202 | 5 |
384085 | 384085 | 2020-07-30 | Martin | Minnesota | 27091 | 198 | 5 |
380868 | 380868 | 2020-07-29 | Martin | Minnesota | 27091 | 199 | 5 |
377651 | 377651 | 2020-07-28 | Martin | Minnesota | 27091 | 196 | 5 |
374436 | 374436 | 2020-07-27 | Martin | Minnesota | 27091 | 193 | 5 |
371224 | 371224 | 2020-07-26 | Martin | Minnesota | 27091 | 192 | 5 |
368014 | 368014 | 2020-07-25 | Martin | Minnesota | 27091 | 192 | 5 |
364806 | 364806 | 2020-07-24 | Martin | Minnesota | 27091 | 192 | 5 |
361599 | 361599 | 2020-07-23 | Martin | Minnesota | 27091 | 190 | 5 |
358394 | 358394 | 2020-07-22 | Martin | Minnesota | 27091 | 190 | 5 |
355191 | 355191 | 2020-07-21 | Martin | Minnesota | 27091 | 190 | 5 |
351989 | 351989 | 2020-07-20 | Martin | Minnesota | 27091 | 186 | 5 |
348789 | 348789 | 2020-07-19 | Martin | Minnesota | 27091 | 184 | 5 |
345588 | 345588 | 2020-07-18 | Martin | Minnesota | 27091 | 181 | 5 |
342388 | 342388 | 2020-07-17 | Martin | Minnesota | 27091 | 181 | 5 |
339192 | 339192 | 2020-07-16 | Martin | Minnesota | 27091 | 179 | 5 |
335996 | 335996 | 2020-07-15 | Martin | Minnesota | 27091 | 180 | 5 |
332803 | 332803 | 2020-07-14 | Martin | Minnesota | 27091 | 176 | 5 |
329616 | 329616 | 2020-07-13 | Martin | Minnesota | 27091 | 175 | 5 |
326430 | 326430 | 2020-07-12 | Martin | Minnesota | 27091 | 175 | 5 |
323247 | 323247 | 2020-07-11 | Martin | Minnesota | 27091 | 175 | 5 |
320068 | 320068 | 2020-07-10 | Martin | Minnesota | 27091 | 172 | 5 |
316893 | 316893 | 2020-07-09 | Martin | Minnesota | 27091 | 171 | 5 |
313719 | 313719 | 2020-07-08 | Martin | Minnesota | 27091 | 171 | 5 |
310549 | 310549 | 2020-07-07 | Martin | Minnesota | 27091 | 171 | 5 |
307381 | 307381 | 2020-07-06 | Martin | Minnesota | 27091 | 169 | 5 |
304214 | 304214 | 2020-07-05 | Martin | Minnesota | 27091 | 168 | 5 |
301050 | 301050 | 2020-07-04 | Martin | Minnesota | 27091 | 163 | 5 |
297887 | 297887 | 2020-07-03 | Martin | Minnesota | 27091 | 163 | 5 |
294729 | 294729 | 2020-07-02 | Martin | Minnesota | 27091 | 161 | 5 |
291575 | 291575 | 2020-07-01 | Martin | Minnesota | 27091 | 161 | 5 |
288424 | 288424 | 2020-06-30 | Martin | Minnesota | 27091 | 156 | 5 |
285274 | 285274 | 2020-06-29 | Martin | Minnesota | 27091 | 155 | 5 |
282129 | 282129 | 2020-06-28 | Martin | Minnesota | 27091 | 154 | 5 |
278981 | 278981 | 2020-06-27 | Martin | Minnesota | 27091 | 152 | 5 |
275833 | 275833 | 2020-06-26 | Martin | Minnesota | 27091 | 151 | 5 |
272690 | 272690 | 2020-06-25 | Martin | Minnesota | 27091 | 148 | 5 |
269553 | 269553 | 2020-06-24 | Martin | Minnesota | 27091 | 149 | 5 |
266420 | 266420 | 2020-06-23 | Martin | Minnesota | 27091 | 148 | 5 |
263294 | 263294 | 2020-06-22 | Martin | Minnesota | 27091 | 148 | 5 |
260165 | 260165 | 2020-06-21 | Martin | Minnesota | 27091 | 148 | 5 |
257039 | 257039 | 2020-06-20 | Martin | Minnesota | 27091 | 147 | 5 |
253919 | 253919 | 2020-06-19 | Martin | Minnesota | 27091 | 147 | 5 |
250804 | 250804 | 2020-06-18 | Martin | Minnesota | 27091 | 147 | 5 |
247692 | 247692 | 2020-06-17 | Martin | Minnesota | 27091 | 147 | 5 |
244579 | 244579 | 2020-06-16 | Martin | Minnesota | 27091 | 147 | 5 |
241468 | 241468 | 2020-06-15 | Martin | Minnesota | 27091 | 143 | 5 |
238359 | 238359 | 2020-06-14 | Martin | Minnesota | 27091 | 143 | 5 |
235252 | 235252 | 2020-06-13 | Martin | Minnesota | 27091 | 143 | 5 |
232146 | 232146 | 2020-06-12 | Martin | Minnesota | 27091 | 143 | 5 |
229042 | 229042 | 2020-06-11 | Martin | Minnesota | 27091 | 143 | 5 |
225940 | 225940 | 2020-06-10 | Martin | Minnesota | 27091 | 143 | 5 |
222842 | 222842 | 2020-06-09 | Martin | Minnesota | 27091 | 142 | 5 |
219747 | 219747 | 2020-06-08 | Martin | Minnesota | 27091 | 140 | 5 |
216655 | 216655 | 2020-06-07 | Martin | Minnesota | 27091 | 137 | 5 |
213567 | 213567 | 2020-06-06 | Martin | Minnesota | 27091 | 137 | 5 |
210483 | 210483 | 2020-06-05 | Martin | Minnesota | 27091 | 135 | 5 |
207402 | 207402 | 2020-06-04 | Martin | Minnesota | 27091 | 132 | 5 |
204321 | 204321 | 2020-06-03 | Martin | Minnesota | 27091 | 132 | 5 |
201244 | 201244 | 2020-06-02 | Martin | Minnesota | 27091 | 132 | 5 |
198171 | 198171 | 2020-06-01 | Martin | Minnesota | 27091 | 132 | 5 |
195100 | 195100 | 2020-05-31 | Martin | Minnesota | 27091 | 130 | 5 |
192032 | 192032 | 2020-05-30 | Martin | Minnesota | 27091 | 129 | 5 |
188968 | 188968 | 2020-05-29 | Martin | Minnesota | 27091 | 129 | 5 |
185910 | 185910 | 2020-05-28 | Martin | Minnesota | 27091 | 126 | 5 |
182855 | 182855 | 2020-05-27 | Martin | Minnesota | 27091 | 126 | 5 |
179809 | 179809 | 2020-05-26 | Martin | Minnesota | 27091 | 126 | 5 |
176765 | 176765 | 2020-05-25 | Martin | Minnesota | 27091 | 125 | 5 |
173722 | 173722 | 2020-05-24 | Martin | Minnesota | 27091 | 124 | 5 |
170680 | 170680 | 2020-05-23 | Martin | Minnesota | 27091 | 124 | 5 |
167642 | 167642 | 2020-05-22 | Martin | Minnesota | 27091 | 124 | 5 |
164606 | 164606 | 2020-05-21 | Martin | Minnesota | 27091 | 124 | 5 |
161577 | 161577 | 2020-05-20 | Martin | Minnesota | 27091 | 123 | 5 |
158551 | 158551 | 2020-05-19 | Martin | Minnesota | 27091 | 123 | 5 |
155533 | 155533 | 2020-05-18 | Martin | Minnesota | 27091 | 120 | 5 |
152519 | 152519 | 2020-05-17 | Martin | Minnesota | 27091 | 118 | 5 |
149508 | 149508 | 2020-05-16 | Martin | Minnesota | 27091 | 117 | 5 |
146503 | 146503 | 2020-05-15 | Martin | Minnesota | 27091 | 114 | 4 |
143503 | 143503 | 2020-05-14 | Martin | Minnesota | 27091 | 113 | 4 |
140508 | 140508 | 2020-05-13 | Martin | Minnesota | 27091 | 112 | 4 |
137514 | 137514 | 2020-05-12 | Martin | Minnesota | 27091 | 112 | 4 |
134524 | 134524 | 2020-05-11 | Martin | Minnesota | 27091 | 112 | 4 |
131533 | 131533 | 2020-05-10 | Martin | Minnesota | 27091 | 112 | 4 |
128543 | 128543 | 2020-05-09 | Martin | Minnesota | 27091 | 112 | 4 |
125556 | 125556 | 2020-05-08 | Martin | Minnesota | 27091 | 111 | 4 |
122574 | 122574 | 2020-05-07 | Martin | Minnesota | 27091 | 111 | 4 |
119600 | 119600 | 2020-05-06 | Martin | Minnesota | 27091 | 111 | 4 |
116640 | 116640 | 2020-05-05 | Martin | Minnesota | 27091 | 111 | 4 |
113759 | 113759 | 2020-05-04 | Martin | Minnesota | 27091 | 111 | 4 |
110880 | 110880 | 2020-05-03 | Martin | Minnesota | 27091 | 111 | 4 |
108009 | 108009 | 2020-05-02 | Martin | Minnesota | 27091 | 111 | 4 |
105144 | 105144 | 2020-05-01 | Martin | Minnesota | 27091 | 111 | 4 |
102283 | 102283 | 2020-04-30 | Martin | Minnesota | 27091 | 88 | 4 |
99431 | 99431 | 2020-04-29 | Martin | Minnesota | 27091 | 70 | 4 |
96585 | 96585 | 2020-04-28 | Martin | Minnesota | 27091 | 52 | 4 |
93750 | 93750 | 2020-04-27 | Martin | Minnesota | 27091 | 43 | 4 |
90929 | 90929 | 2020-04-26 | Martin | Minnesota | 27091 | 43 | 4 |
88113 | 88113 | 2020-04-25 | Martin | Minnesota | 27091 | 42 | 4 |
85303 | 85303 | 2020-04-24 | Martin | Minnesota | 27091 | 41 | 4 |
82499 | 82499 | 2020-04-23 | Martin | Minnesota | 27091 | 41 | 4 |
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);