ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Olmsted" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387313 | 387313 | 2020-07-31 | Olmsted | Minnesota | 27109 | 1588 | 23 |
384095 | 384095 | 2020-07-30 | Olmsted | Minnesota | 27109 | 1567 | 22 |
380878 | 380878 | 2020-07-29 | Olmsted | Minnesota | 27109 | 1547 | 21 |
377661 | 377661 | 2020-07-28 | Olmsted | Minnesota | 27109 | 1531 | 21 |
374446 | 374446 | 2020-07-27 | Olmsted | Minnesota | 27109 | 1525 | 21 |
371234 | 371234 | 2020-07-26 | Olmsted | Minnesota | 27109 | 1515 | 21 |
368024 | 368024 | 2020-07-25 | Olmsted | Minnesota | 27109 | 1497 | 21 |
364816 | 364816 | 2020-07-24 | Olmsted | Minnesota | 27109 | 1487 | 21 |
361609 | 361609 | 2020-07-23 | Olmsted | Minnesota | 27109 | 1466 | 21 |
358404 | 358404 | 2020-07-22 | Olmsted | Minnesota | 27109 | 1448 | 21 |
355201 | 355201 | 2020-07-21 | Olmsted | Minnesota | 27109 | 1436 | 21 |
351999 | 351999 | 2020-07-20 | Olmsted | Minnesota | 27109 | 1403 | 21 |
348799 | 348799 | 2020-07-19 | Olmsted | Minnesota | 27109 | 1400 | 20 |
345598 | 345598 | 2020-07-18 | Olmsted | Minnesota | 27109 | 1388 | 20 |
342398 | 342398 | 2020-07-17 | Olmsted | Minnesota | 27109 | 1379 | 20 |
339202 | 339202 | 2020-07-16 | Olmsted | Minnesota | 27109 | 1353 | 20 |
336006 | 336006 | 2020-07-15 | Olmsted | Minnesota | 27109 | 1336 | 20 |
332813 | 332813 | 2020-07-14 | Olmsted | Minnesota | 27109 | 1319 | 20 |
329626 | 329626 | 2020-07-13 | Olmsted | Minnesota | 27109 | 1302 | 20 |
326440 | 326440 | 2020-07-12 | Olmsted | Minnesota | 27109 | 1276 | 20 |
323257 | 323257 | 2020-07-11 | Olmsted | Minnesota | 27109 | 1259 | 20 |
320078 | 320078 | 2020-07-10 | Olmsted | Minnesota | 27109 | 1235 | 18 |
316903 | 316903 | 2020-07-09 | Olmsted | Minnesota | 27109 | 1196 | 17 |
313729 | 313729 | 2020-07-08 | Olmsted | Minnesota | 27109 | 1168 | 17 |
310559 | 310559 | 2020-07-07 | Olmsted | Minnesota | 27109 | 1147 | 15 |
307391 | 307391 | 2020-07-06 | Olmsted | Minnesota | 27109 | 1129 | 15 |
304224 | 304224 | 2020-07-05 | Olmsted | Minnesota | 27109 | 1124 | 15 |
301060 | 301060 | 2020-07-04 | Olmsted | Minnesota | 27109 | 1101 | 15 |
297897 | 297897 | 2020-07-03 | Olmsted | Minnesota | 27109 | 1101 | 15 |
294739 | 294739 | 2020-07-02 | Olmsted | Minnesota | 27109 | 1076 | 15 |
291585 | 291585 | 2020-07-01 | Olmsted | Minnesota | 27109 | 1058 | 15 |
288434 | 288434 | 2020-06-30 | Olmsted | Minnesota | 27109 | 1047 | 15 |
285284 | 285284 | 2020-06-29 | Olmsted | Minnesota | 27109 | 1027 | 15 |
282139 | 282139 | 2020-06-28 | Olmsted | Minnesota | 27109 | 1020 | 15 |
278991 | 278991 | 2020-06-27 | Olmsted | Minnesota | 27109 | 998 | 15 |
275843 | 275843 | 2020-06-26 | Olmsted | Minnesota | 27109 | 970 | 15 |
272700 | 272700 | 2020-06-25 | Olmsted | Minnesota | 27109 | 948 | 15 |
269563 | 269563 | 2020-06-24 | Olmsted | Minnesota | 27109 | 938 | 15 |
266430 | 266430 | 2020-06-23 | Olmsted | Minnesota | 27109 | 916 | 15 |
263304 | 263304 | 2020-06-22 | Olmsted | Minnesota | 27109 | 910 | 15 |
260175 | 260175 | 2020-06-21 | Olmsted | Minnesota | 27109 | 903 | 14 |
257049 | 257049 | 2020-06-20 | Olmsted | Minnesota | 27109 | 869 | 14 |
253929 | 253929 | 2020-06-19 | Olmsted | Minnesota | 27109 | 846 | 14 |
250814 | 250814 | 2020-06-18 | Olmsted | Minnesota | 27109 | 832 | 13 |
247702 | 247702 | 2020-06-17 | Olmsted | Minnesota | 27109 | 810 | 12 |
244589 | 244589 | 2020-06-16 | Olmsted | Minnesota | 27109 | 781 | 12 |
241478 | 241478 | 2020-06-15 | Olmsted | Minnesota | 27109 | 778 | 12 |
238369 | 238369 | 2020-06-14 | Olmsted | Minnesota | 27109 | 778 | 12 |
235262 | 235262 | 2020-06-13 | Olmsted | Minnesota | 27109 | 775 | 12 |
232156 | 232156 | 2020-06-12 | Olmsted | Minnesota | 27109 | 765 | 12 |
229052 | 229052 | 2020-06-11 | Olmsted | Minnesota | 27109 | 752 | 12 |
225950 | 225950 | 2020-06-10 | Olmsted | Minnesota | 27109 | 740 | 12 |
222852 | 222852 | 2020-06-09 | Olmsted | Minnesota | 27109 | 727 | 12 |
219757 | 219757 | 2020-06-08 | Olmsted | Minnesota | 27109 | 722 | 12 |
216665 | 216665 | 2020-06-07 | Olmsted | Minnesota | 27109 | 711 | 12 |
213577 | 213577 | 2020-06-06 | Olmsted | Minnesota | 27109 | 699 | 12 |
210493 | 210493 | 2020-06-05 | Olmsted | Minnesota | 27109 | 689 | 11 |
207412 | 207412 | 2020-06-04 | Olmsted | Minnesota | 27109 | 672 | 11 |
204331 | 204331 | 2020-06-03 | Olmsted | Minnesota | 27109 | 654 | 11 |
201254 | 201254 | 2020-06-02 | Olmsted | Minnesota | 27109 | 650 | 11 |
198181 | 198181 | 2020-06-01 | Olmsted | Minnesota | 27109 | 634 | 10 |
195110 | 195110 | 2020-05-31 | Olmsted | Minnesota | 27109 | 626 | 10 |
192042 | 192042 | 2020-05-30 | Olmsted | Minnesota | 27109 | 608 | 10 |
188978 | 188978 | 2020-05-29 | Olmsted | Minnesota | 27109 | 594 | 10 |
185920 | 185920 | 2020-05-28 | Olmsted | Minnesota | 27109 | 582 | 10 |
182865 | 182865 | 2020-05-27 | Olmsted | Minnesota | 27109 | 575 | 10 |
179819 | 179819 | 2020-05-26 | Olmsted | Minnesota | 27109 | 570 | 10 |
176775 | 176775 | 2020-05-25 | Olmsted | Minnesota | 27109 | 562 | 10 |
173732 | 173732 | 2020-05-24 | Olmsted | Minnesota | 27109 | 551 | 10 |
170690 | 170690 | 2020-05-23 | Olmsted | Minnesota | 27109 | 542 | 10 |
167652 | 167652 | 2020-05-22 | Olmsted | Minnesota | 27109 | 525 | 10 |
164616 | 164616 | 2020-05-21 | Olmsted | Minnesota | 27109 | 493 | 10 |
161587 | 161587 | 2020-05-20 | Olmsted | Minnesota | 27109 | 488 | 10 |
158561 | 158561 | 2020-05-19 | Olmsted | Minnesota | 27109 | 479 | 10 |
155543 | 155543 | 2020-05-18 | Olmsted | Minnesota | 27109 | 461 | 9 |
152529 | 152529 | 2020-05-17 | Olmsted | Minnesota | 27109 | 448 | 9 |
149518 | 149518 | 2020-05-16 | Olmsted | Minnesota | 27109 | 435 | 9 |
146513 | 146513 | 2020-05-15 | Olmsted | Minnesota | 27109 | 417 | 9 |
143513 | 143513 | 2020-05-14 | Olmsted | Minnesota | 27109 | 399 | 9 |
140518 | 140518 | 2020-05-13 | Olmsted | Minnesota | 27109 | 378 | 9 |
137524 | 137524 | 2020-05-12 | Olmsted | Minnesota | 27109 | 378 | 9 |
134534 | 134534 | 2020-05-11 | Olmsted | Minnesota | 27109 | 374 | 9 |
131543 | 131543 | 2020-05-10 | Olmsted | Minnesota | 27109 | 368 | 9 |
128553 | 128553 | 2020-05-09 | Olmsted | Minnesota | 27109 | 363 | 9 |
125566 | 125566 | 2020-05-08 | Olmsted | Minnesota | 27109 | 351 | 9 |
122584 | 122584 | 2020-05-07 | Olmsted | Minnesota | 27109 | 336 | 8 |
119610 | 119610 | 2020-05-06 | Olmsted | Minnesota | 27109 | 322 | 8 |
116650 | 116650 | 2020-05-05 | Olmsted | Minnesota | 27109 | 313 | 8 |
113769 | 113769 | 2020-05-04 | Olmsted | Minnesota | 27109 | 305 | 8 |
110890 | 110890 | 2020-05-03 | Olmsted | Minnesota | 27109 | 293 | 8 |
108019 | 108019 | 2020-05-02 | Olmsted | Minnesota | 27109 | 282 | 8 |
105154 | 105154 | 2020-05-01 | Olmsted | Minnesota | 27109 | 269 | 8 |
102293 | 102293 | 2020-04-30 | Olmsted | Minnesota | 27109 | 265 | 6 |
99441 | 99441 | 2020-04-29 | Olmsted | Minnesota | 27109 | 256 | 6 |
96595 | 96595 | 2020-04-28 | Olmsted | Minnesota | 27109 | 251 | 6 |
93760 | 93760 | 2020-04-27 | Olmsted | Minnesota | 27109 | 246 | 6 |
90939 | 90939 | 2020-04-26 | Olmsted | Minnesota | 27109 | 239 | 6 |
88123 | 88123 | 2020-04-25 | Olmsted | Minnesota | 27109 | 238 | 6 |
85313 | 85313 | 2020-04-24 | Olmsted | Minnesota | 27109 | 219 | 6 |
82509 | 82509 | 2020-04-23 | Olmsted | Minnesota | 27109 | 213 | 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);