ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 27037 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387277 | 387277 | 2020-07-31 | Dakota | Minnesota | 27037 | 3797 | 102 |
384059 | 384059 | 2020-07-30 | Dakota | Minnesota | 27037 | 3710 | 102 |
380842 | 380842 | 2020-07-29 | Dakota | Minnesota | 27037 | 3656 | 102 |
377625 | 377625 | 2020-07-28 | Dakota | Minnesota | 27037 | 3565 | 102 |
374410 | 374410 | 2020-07-27 | Dakota | Minnesota | 27037 | 3537 | 102 |
371198 | 371198 | 2020-07-26 | Dakota | Minnesota | 27037 | 3475 | 102 |
367988 | 367988 | 2020-07-25 | Dakota | Minnesota | 27037 | 3386 | 102 |
364781 | 364781 | 2020-07-24 | Dakota | Minnesota | 27037 | 3324 | 102 |
361574 | 361574 | 2020-07-23 | Dakota | Minnesota | 27037 | 3263 | 101 |
358369 | 358369 | 2020-07-22 | Dakota | Minnesota | 27037 | 3194 | 100 |
355166 | 355166 | 2020-07-21 | Dakota | Minnesota | 27037 | 3138 | 100 |
351964 | 351964 | 2020-07-20 | Dakota | Minnesota | 27037 | 3059 | 100 |
348764 | 348764 | 2020-07-19 | Dakota | Minnesota | 27037 | 3046 | 100 |
345563 | 345563 | 2020-07-18 | Dakota | Minnesota | 27037 | 2979 | 100 |
342363 | 342363 | 2020-07-17 | Dakota | Minnesota | 27037 | 2952 | 100 |
339167 | 339167 | 2020-07-16 | Dakota | Minnesota | 27037 | 2912 | 99 |
335971 | 335971 | 2020-07-15 | Dakota | Minnesota | 27037 | 2852 | 97 |
332778 | 332778 | 2020-07-14 | Dakota | Minnesota | 27037 | 2781 | 96 |
329591 | 329591 | 2020-07-13 | Dakota | Minnesota | 27037 | 2753 | 96 |
326405 | 326405 | 2020-07-12 | Dakota | Minnesota | 27037 | 2713 | 96 |
323222 | 323222 | 2020-07-11 | Dakota | Minnesota | 27037 | 2655 | 96 |
320043 | 320043 | 2020-07-10 | Dakota | Minnesota | 27037 | 2570 | 94 |
316868 | 316868 | 2020-07-09 | Dakota | Minnesota | 27037 | 2524 | 94 |
313694 | 313694 | 2020-07-08 | Dakota | Minnesota | 27037 | 2479 | 93 |
310524 | 310524 | 2020-07-07 | Dakota | Minnesota | 27037 | 2421 | 92 |
307356 | 307356 | 2020-07-06 | Dakota | Minnesota | 27037 | 2382 | 91 |
304189 | 304189 | 2020-07-05 | Dakota | Minnesota | 27037 | 2330 | 90 |
301025 | 301025 | 2020-07-04 | Dakota | Minnesota | 27037 | 2286 | 90 |
297862 | 297862 | 2020-07-03 | Dakota | Minnesota | 27037 | 2286 | 90 |
294704 | 294704 | 2020-07-02 | Dakota | Minnesota | 27037 | 2248 | 90 |
291550 | 291550 | 2020-07-01 | Dakota | Minnesota | 27037 | 2218 | 89 |
288399 | 288399 | 2020-06-30 | Dakota | Minnesota | 27037 | 2180 | 87 |
285249 | 285249 | 2020-06-29 | Dakota | Minnesota | 27037 | 2157 | 87 |
282104 | 282104 | 2020-06-28 | Dakota | Minnesota | 27037 | 2133 | 87 |
278956 | 278956 | 2020-06-27 | Dakota | Minnesota | 27037 | 2090 | 86 |
275808 | 275808 | 2020-06-26 | Dakota | Minnesota | 27037 | 2061 | 86 |
272665 | 272665 | 2020-06-25 | Dakota | Minnesota | 27037 | 2012 | 85 |
269528 | 269528 | 2020-06-24 | Dakota | Minnesota | 27037 | 1982 | 84 |
266395 | 266395 | 2020-06-23 | Dakota | Minnesota | 27037 | 1956 | 84 |
263269 | 263269 | 2020-06-22 | Dakota | Minnesota | 27037 | 1941 | 83 |
260140 | 260140 | 2020-06-21 | Dakota | Minnesota | 27037 | 1915 | 82 |
257014 | 257014 | 2020-06-20 | Dakota | Minnesota | 27037 | 1878 | 81 |
253894 | 253894 | 2020-06-19 | Dakota | Minnesota | 27037 | 1847 | 81 |
250779 | 250779 | 2020-06-18 | Dakota | Minnesota | 27037 | 1805 | 76 |
247667 | 247667 | 2020-06-17 | Dakota | Minnesota | 27037 | 1776 | 75 |
244554 | 244554 | 2020-06-16 | Dakota | Minnesota | 27037 | 1758 | 74 |
241443 | 241443 | 2020-06-15 | Dakota | Minnesota | 27037 | 1730 | 74 |
238334 | 238334 | 2020-06-14 | Dakota | Minnesota | 27037 | 1713 | 74 |
235227 | 235227 | 2020-06-13 | Dakota | Minnesota | 27037 | 1682 | 73 |
232121 | 232121 | 2020-06-12 | Dakota | Minnesota | 27037 | 1648 | 72 |
229017 | 229017 | 2020-06-11 | Dakota | Minnesota | 27037 | 1623 | 72 |
225915 | 225915 | 2020-06-10 | Dakota | Minnesota | 27037 | 1572 | 71 |
222817 | 222817 | 2020-06-09 | Dakota | Minnesota | 27037 | 1554 | 70 |
219722 | 219722 | 2020-06-08 | Dakota | Minnesota | 27037 | 1523 | 65 |
216630 | 216630 | 2020-06-07 | Dakota | Minnesota | 27037 | 1504 | 65 |
213542 | 213542 | 2020-06-06 | Dakota | Minnesota | 27037 | 1481 | 64 |
210458 | 210458 | 2020-06-05 | Dakota | Minnesota | 27037 | 1446 | 64 |
207377 | 207377 | 2020-06-04 | Dakota | Minnesota | 27037 | 1414 | 64 |
204296 | 204296 | 2020-06-03 | Dakota | Minnesota | 27037 | 1388 | 59 |
201219 | 201219 | 2020-06-02 | Dakota | Minnesota | 27037 | 1368 | 59 |
198146 | 198146 | 2020-06-01 | Dakota | Minnesota | 27037 | 1349 | 57 |
195075 | 195075 | 2020-05-31 | Dakota | Minnesota | 27037 | 1327 | 55 |
192007 | 192007 | 2020-05-30 | Dakota | Minnesota | 27037 | 1263 | 54 |
188943 | 188943 | 2020-05-29 | Dakota | Minnesota | 27037 | 1230 | 51 |
185885 | 185885 | 2020-05-28 | Dakota | Minnesota | 27037 | 1202 | 49 |
182830 | 182830 | 2020-05-27 | Dakota | Minnesota | 27037 | 1182 | 44 |
179784 | 179784 | 2020-05-26 | Dakota | Minnesota | 27037 | 1164 | 38 |
176740 | 176740 | 2020-05-25 | Dakota | Minnesota | 27037 | 1102 | 35 |
173697 | 173697 | 2020-05-24 | Dakota | Minnesota | 27037 | 1059 | 35 |
170655 | 170655 | 2020-05-23 | Dakota | Minnesota | 27037 | 999 | 33 |
167618 | 167618 | 2020-05-22 | Dakota | Minnesota | 27037 | 961 | 33 |
164582 | 164582 | 2020-05-21 | Dakota | Minnesota | 27037 | 929 | 32 |
161553 | 161553 | 2020-05-20 | Dakota | Minnesota | 27037 | 885 | 31 |
158527 | 158527 | 2020-05-19 | Dakota | Minnesota | 27037 | 841 | 25 |
155509 | 155509 | 2020-05-18 | Dakota | Minnesota | 27037 | 802 | 23 |
152495 | 152495 | 2020-05-17 | Dakota | Minnesota | 27037 | 742 | 23 |
149484 | 149484 | 2020-05-16 | Dakota | Minnesota | 27037 | 666 | 18 |
146479 | 146479 | 2020-05-15 | Dakota | Minnesota | 27037 | 623 | 17 |
143479 | 143479 | 2020-05-14 | Dakota | Minnesota | 27037 | 562 | 16 |
140484 | 140484 | 2020-05-13 | Dakota | Minnesota | 27037 | 508 | 15 |
137490 | 137490 | 2020-05-12 | Dakota | Minnesota | 27037 | 508 | 15 |
134500 | 134500 | 2020-05-11 | Dakota | Minnesota | 27037 | 471 | 15 |
131509 | 131509 | 2020-05-10 | Dakota | Minnesota | 27037 | 430 | 15 |
128519 | 128519 | 2020-05-09 | Dakota | Minnesota | 27037 | 408 | 15 |
125532 | 125532 | 2020-05-08 | Dakota | Minnesota | 27037 | 364 | 12 |
122550 | 122550 | 2020-05-07 | Dakota | Minnesota | 27037 | 322 | 12 |
119577 | 119577 | 2020-05-06 | Dakota | Minnesota | 27037 | 292 | 12 |
116617 | 116617 | 2020-05-05 | Dakota | Minnesota | 27037 | 241 | 11 |
113736 | 113736 | 2020-05-04 | Dakota | Minnesota | 27037 | 215 | 11 |
110857 | 110857 | 2020-05-03 | Dakota | Minnesota | 27037 | 202 | 11 |
107986 | 107986 | 2020-05-02 | Dakota | Minnesota | 27037 | 189 | 11 |
105122 | 105122 | 2020-05-01 | Dakota | Minnesota | 27037 | 171 | 11 |
102262 | 102262 | 2020-04-30 | Dakota | Minnesota | 27037 | 162 | 10 |
99410 | 99410 | 2020-04-29 | Dakota | Minnesota | 27037 | 157 | 9 |
96564 | 96564 | 2020-04-28 | Dakota | Minnesota | 27037 | 156 | 9 |
93729 | 93729 | 2020-04-27 | Dakota | Minnesota | 27037 | 144 | 7 |
90908 | 90908 | 2020-04-26 | Dakota | Minnesota | 27037 | 143 | 7 |
88092 | 88092 | 2020-04-25 | Dakota | Minnesota | 27037 | 138 | 6 |
85282 | 85282 | 2020-04-24 | Dakota | Minnesota | 27037 | 136 | 6 |
82478 | 82478 | 2020-04-23 | Dakota | Minnesota | 27037 | 131 | 6 |
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);