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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
253929 | 253929 | 2020-06-19 | Olmsted | Minnesota | 27109 | 846 | 14 |
257049 | 257049 | 2020-06-20 | Olmsted | Minnesota | 27109 | 869 | 14 |
260175 | 260175 | 2020-06-21 | Olmsted | Minnesota | 27109 | 903 | 14 |
263304 | 263304 | 2020-06-22 | Olmsted | Minnesota | 27109 | 910 | 15 |
266430 | 266430 | 2020-06-23 | Olmsted | Minnesota | 27109 | 916 | 15 |
269563 | 269563 | 2020-06-24 | Olmsted | Minnesota | 27109 | 938 | 15 |
272700 | 272700 | 2020-06-25 | Olmsted | Minnesota | 27109 | 948 | 15 |
275843 | 275843 | 2020-06-26 | Olmsted | Minnesota | 27109 | 970 | 15 |
278991 | 278991 | 2020-06-27 | Olmsted | Minnesota | 27109 | 998 | 15 |
282139 | 282139 | 2020-06-28 | Olmsted | Minnesota | 27109 | 1020 | 15 |
285284 | 285284 | 2020-06-29 | Olmsted | Minnesota | 27109 | 1027 | 15 |
288434 | 288434 | 2020-06-30 | Olmsted | Minnesota | 27109 | 1047 | 15 |
291585 | 291585 | 2020-07-01 | Olmsted | Minnesota | 27109 | 1058 | 15 |
294739 | 294739 | 2020-07-02 | Olmsted | Minnesota | 27109 | 1076 | 15 |
297897 | 297897 | 2020-07-03 | Olmsted | Minnesota | 27109 | 1101 | 15 |
301060 | 301060 | 2020-07-04 | Olmsted | Minnesota | 27109 | 1101 | 15 |
304224 | 304224 | 2020-07-05 | Olmsted | Minnesota | 27109 | 1124 | 15 |
307391 | 307391 | 2020-07-06 | Olmsted | Minnesota | 27109 | 1129 | 15 |
310559 | 310559 | 2020-07-07 | Olmsted | Minnesota | 27109 | 1147 | 15 |
313729 | 313729 | 2020-07-08 | Olmsted | Minnesota | 27109 | 1168 | 17 |
316903 | 316903 | 2020-07-09 | Olmsted | Minnesota | 27109 | 1196 | 17 |
320078 | 320078 | 2020-07-10 | Olmsted | Minnesota | 27109 | 1235 | 18 |
323257 | 323257 | 2020-07-11 | Olmsted | Minnesota | 27109 | 1259 | 20 |
326440 | 326440 | 2020-07-12 | Olmsted | Minnesota | 27109 | 1276 | 20 |
329626 | 329626 | 2020-07-13 | Olmsted | Minnesota | 27109 | 1302 | 20 |
332813 | 332813 | 2020-07-14 | Olmsted | Minnesota | 27109 | 1319 | 20 |
336006 | 336006 | 2020-07-15 | Olmsted | Minnesota | 27109 | 1336 | 20 |
339202 | 339202 | 2020-07-16 | Olmsted | Minnesota | 27109 | 1353 | 20 |
342398 | 342398 | 2020-07-17 | Olmsted | Minnesota | 27109 | 1379 | 20 |
345598 | 345598 | 2020-07-18 | Olmsted | Minnesota | 27109 | 1388 | 20 |
348799 | 348799 | 2020-07-19 | Olmsted | Minnesota | 27109 | 1400 | 20 |
351999 | 351999 | 2020-07-20 | Olmsted | Minnesota | 27109 | 1403 | 21 |
355201 | 355201 | 2020-07-21 | Olmsted | Minnesota | 27109 | 1436 | 21 |
358404 | 358404 | 2020-07-22 | Olmsted | Minnesota | 27109 | 1448 | 21 |
361609 | 361609 | 2020-07-23 | Olmsted | Minnesota | 27109 | 1466 | 21 |
364816 | 364816 | 2020-07-24 | Olmsted | Minnesota | 27109 | 1487 | 21 |
368024 | 368024 | 2020-07-25 | Olmsted | Minnesota | 27109 | 1497 | 21 |
371234 | 371234 | 2020-07-26 | Olmsted | Minnesota | 27109 | 1515 | 21 |
374446 | 374446 | 2020-07-27 | Olmsted | Minnesota | 27109 | 1525 | 21 |
377661 | 377661 | 2020-07-28 | Olmsted | Minnesota | 27109 | 1531 | 21 |
380878 | 380878 | 2020-07-29 | Olmsted | Minnesota | 27109 | 1547 | 21 |
384095 | 384095 | 2020-07-30 | Olmsted | Minnesota | 27109 | 1567 | 22 |
387313 | 387313 | 2020-07-31 | Olmsted | Minnesota | 27109 | 1588 | 23 |
390530 | 390530 | 2020-08-01 | Olmsted | Minnesota | 27109 | 1608 | 23 |
393747 | 393747 | 2020-08-02 | Olmsted | Minnesota | 27109 | 1620 | 23 |
396963 | 396963 | 2020-08-03 | Olmsted | Minnesota | 27109 | 1629 | 23 |
400177 | 400177 | 2020-08-04 | Olmsted | Minnesota | 27109 | 1635 | 23 |
403394 | 403394 | 2020-08-05 | Olmsted | Minnesota | 27109 | 1649 | 23 |
406612 | 406612 | 2020-08-06 | Olmsted | Minnesota | 27109 | 1688 | 23 |
409832 | 409832 | 2020-08-07 | Olmsted | Minnesota | 27109 | 1700 | 23 |
413052 | 413052 | 2020-08-08 | Olmsted | Minnesota | 27109 | 1718 | 23 |
416272 | 416272 | 2020-08-09 | Olmsted | Minnesota | 27109 | 1732 | 23 |
419493 | 419493 | 2020-08-10 | Olmsted | Minnesota | 27109 | 1747 | 23 |
422715 | 422715 | 2020-08-11 | Olmsted | Minnesota | 27109 | 1767 | 23 |
425937 | 425937 | 2020-08-12 | Olmsted | Minnesota | 27109 | 1781 | 23 |
429161 | 429161 | 2020-08-13 | Olmsted | Minnesota | 27109 | 1791 | 23 |
432388 | 432388 | 2020-08-14 | Olmsted | Minnesota | 27109 | 1809 | 23 |
435614 | 435614 | 2020-08-15 | Olmsted | Minnesota | 27109 | 1825 | 23 |
438839 | 438839 | 2020-08-16 | Olmsted | Minnesota | 27109 | 1835 | 23 |
442066 | 442066 | 2020-08-17 | Olmsted | Minnesota | 27109 | 1843 | 23 |
445292 | 445292 | 2020-08-18 | Olmsted | Minnesota | 27109 | 1851 | 23 |
448518 | 448518 | 2020-08-19 | Olmsted | Minnesota | 27109 | 1866 | 24 |
451746 | 451746 | 2020-08-20 | Olmsted | Minnesota | 27109 | 1877 | 24 |
454974 | 454974 | 2020-08-21 | Olmsted | Minnesota | 27109 | 1890 | 24 |
458202 | 458202 | 2020-08-22 | Olmsted | Minnesota | 27109 | 1907 | 24 |
461429 | 461429 | 2020-08-23 | Olmsted | Minnesota | 27109 | 1915 | 24 |
464660 | 464660 | 2020-08-24 | Olmsted | Minnesota | 27109 | 1919 | 24 |
467889 | 467889 | 2020-08-25 | Olmsted | Minnesota | 27109 | 1928 | 24 |
471119 | 471119 | 2020-08-26 | Olmsted | Minnesota | 27109 | 1947 | 24 |
474351 | 474351 | 2020-08-27 | Olmsted | Minnesota | 27109 | 1958 | 24 |
477584 | 477584 | 2020-08-28 | Olmsted | Minnesota | 27109 | 1977 | 24 |
480816 | 480816 | 2020-08-29 | Olmsted | Minnesota | 27109 | 2008 | 24 |
484051 | 484051 | 2020-08-30 | Olmsted | Minnesota | 27109 | 2016 | 24 |
487285 | 487285 | 2020-08-31 | Olmsted | Minnesota | 27109 | 2036 | 24 |
490518 | 490518 | 2020-09-01 | Olmsted | Minnesota | 27109 | 2045 | 24 |
493752 | 493752 | 2020-09-02 | Olmsted | Minnesota | 27109 | 2058 | 24 |
496985 | 496985 | 2020-09-03 | Olmsted | Minnesota | 27109 | 2073 | 25 |
500219 | 500219 | 2020-09-04 | Olmsted | Minnesota | 27109 | 2080 | 25 |
503453 | 503453 | 2020-09-05 | Olmsted | Minnesota | 27109 | 2103 | 25 |
506686 | 506686 | 2020-09-06 | Olmsted | Minnesota | 27109 | 2110 | 25 |
509919 | 509919 | 2020-09-07 | Olmsted | Minnesota | 27109 | 2121 | 25 |
513151 | 513151 | 2020-09-08 | Olmsted | Minnesota | 27109 | 2124 | 25 |
516385 | 516385 | 2020-09-09 | Olmsted | Minnesota | 27109 | 2134 | 25 |
519620 | 519620 | 2020-09-10 | Olmsted | Minnesota | 27109 | 2147 | 26 |
522857 | 522857 | 2020-09-11 | Olmsted | Minnesota | 27109 | 2154 | 26 |
526093 | 526093 | 2020-09-12 | Olmsted | Minnesota | 27109 | 2160 | 26 |
529329 | 529329 | 2020-09-13 | Olmsted | Minnesota | 27109 | 2176 | 26 |
532565 | 532565 | 2020-09-14 | Olmsted | Minnesota | 27109 | 2187 | 26 |
535800 | 535800 | 2020-09-15 | Olmsted | Minnesota | 27109 | 2204 | 26 |
539037 | 539037 | 2020-09-16 | Olmsted | Minnesota | 27109 | 2217 | 26 |
542273 | 542273 | 2020-09-17 | Olmsted | Minnesota | 27109 | 2237 | 26 |
545510 | 545510 | 2020-09-18 | Olmsted | Minnesota | 27109 | 2253 | 27 |
548748 | 548748 | 2020-09-19 | Olmsted | Minnesota | 27109 | 2263 | 27 |
551987 | 551987 | 2020-09-20 | Olmsted | Minnesota | 27109 | 2287 | 27 |
555225 | 555225 | 2020-09-21 | Olmsted | Minnesota | 27109 | 2319 | 27 |
558462 | 558462 | 2020-09-22 | Olmsted | Minnesota | 27109 | 2329 | 27 |
561699 | 561699 | 2020-09-23 | Olmsted | Minnesota | 27109 | 2346 | 27 |
564939 | 564939 | 2020-09-24 | Olmsted | Minnesota | 27109 | 2367 | 28 |
568179 | 568179 | 2020-09-25 | Olmsted | Minnesota | 27109 | 2388 | 28 |
571421 | 571421 | 2020-09-26 | Olmsted | Minnesota | 27109 | 2446 | 28 |
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);