ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where deaths = 5, fips = 27091 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 |
---|---|---|---|---|---|---|---|
432378 | 432378 | 2020-08-14 | Martin | Minnesota | 27091 | 212 | 5 |
429151 | 429151 | 2020-08-13 | Martin | Minnesota | 27091 | 210 | 5 |
425927 | 425927 | 2020-08-12 | Martin | Minnesota | 27091 | 209 | 5 |
422705 | 422705 | 2020-08-11 | Martin | Minnesota | 27091 | 209 | 5 |
419483 | 419483 | 2020-08-10 | Martin | Minnesota | 27091 | 207 | 5 |
416262 | 416262 | 2020-08-09 | Martin | Minnesota | 27091 | 207 | 5 |
413042 | 413042 | 2020-08-08 | Martin | Minnesota | 27091 | 207 | 5 |
409822 | 409822 | 2020-08-07 | Martin | Minnesota | 27091 | 206 | 5 |
406602 | 406602 | 2020-08-06 | Martin | Minnesota | 27091 | 204 | 5 |
403384 | 403384 | 2020-08-05 | Martin | Minnesota | 27091 | 204 | 5 |
400167 | 400167 | 2020-08-04 | Martin | Minnesota | 27091 | 204 | 5 |
396953 | 396953 | 2020-08-03 | Martin | Minnesota | 27091 | 204 | 5 |
393737 | 393737 | 2020-08-02 | Martin | Minnesota | 27091 | 203 | 5 |
390520 | 390520 | 2020-08-01 | Martin | Minnesota | 27091 | 201 | 5 |
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 |
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);