ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 27109 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 682 ✖
- 1 4
- 15101 4
- 24426 4
- 25067 4
- 29341 4
- 39231 4
- 13427 3
- 13447 3
- 13471 3
- 13503 3
- 13587 3
- 13761 3
- 13985 3
- 14358 3
- 14721 3
- 15388 3
- 15792 3
- 16269 3
- 16734 3
- 17275 3
- 17821 3
- 18144 3
- 18669 3
- 19396 3
- 20113 3
- 21013 3
- 21750 3
- 22677 3
- 23454 3
- 23986 3
- 26053 3
- 32449 3
- 35906 3
- 37640 3
- 38550 3
- 39596 3
- 39897 3
- 40215 3
- 40405 3
- 40602 3
- 40833 3
- 41058 3
- 41340 3
- 41717 3
- 42216 3
- 42844 3
- 3 2
- 6 2
- 143 2
- 378 2
- 778 2
- 1101 2
- 6261 2
- 8837 2
- 9309 2
- 12400 2
- 13349 2
- 13406 2
- 13467 2
- 21580 2
- 2 1
- 11 1
- 12 1
- 14 1
- 16 1
- 18 1
- 21 1
- 29 1
- 34 1
- 37 1
- 47 1
- 51 1
- 53 1
- 61 1
- 66 1
- 76 1
- 88 1
- 95 1
- 96 1
- 103 1
- 108 1
- 114 1
- 126 1
- 132 1
- 147 1
- 153 1
- 163 1
- 174 1
- 177 1
- 194 1
- 197 1
- 198 1
- 204 1
- 213 1
- 219 1
- 238 1
- 239 1
- 246 1
- 251 1
- 256 1
- 265 1
- 269 1
- 282 1
- 293 1
- 305 1
- 313 1
- 322 1
- 336 1
- 351 1
- 363 1
- 368 1
- 374 1
- 399 1
- 417 1
- 435 1
- 448 1
- 461 1
- 479 1
- 488 1
- 493 1
- 525 1
- 542 1
- 551 1
- 562 1
- 570 1
- 575 1
- 582 1
- 594 1
- 608 1
- 626 1
- 634 1
- 650 1
- 654 1
- 672 1
- 689 1
- 699 1
- 711 1
- 722 1
- 727 1
- 740 1
- 752 1
- 765 1
- 775 1
- 781 1
- 810 1
- 832 1
- 846 1
- 869 1
- 903 1
- 910 1
- 916 1
- 938 1
- 948 1
- 970 1
- 998 1
- 1020 1
- 1027 1
- 1047 1
- 1058 1
- 1076 1
- 1124 1
- 1129 1
- 1147 1
- 1168 1
- 1196 1
- 1235 1
- 1259 1
- 1276 1
- 1302 1
- 1319 1
- 1336 1
- 1353 1
- 1379 1
- 1388 1
- 1400 1
- 1403 1
- 1436 1
- 1448 1
- 1466 1
- 1487 1
- 1497 1
- 1515 1
- 1525 1
- 1531 1
- 1547 1
- 1567 1
- 1588 1
- 1608 1
- 1620 1
- 1629 1
- 1635 1
- 1649 1
- 1688 1
- 1700 1
- 1718 1
- 1732 1
- 1747 1
- 1767 1
- 1781 1
- 1791 1
- 1809 1
- 1825 1
- 1835 1
- 1843 1
- 1851 1
- 1866 1
- 1877 1
- 1890 1
- 1907 1
- 1915 1
- 1919 1
- 1928 1
- 1947 1
- 1958 1
- 1977 1
- 2008 1
- 2016 1
- 2036 1
- 2045 1
- 2058 1
- 2073 1
- 2080 1
- 2103 1
- 2110 1
- 2121 1
- 2124 1
- 2134 1
- 2147 1
- 2154 1
- 2160 1
- 2176 1
- 2187 1
- 2204 1
- 2217 1
- 2237 1
- 2253 1
- 2263 1
- 2287 1
- 2319 1
- 2329 1
- 2346 1
- 2367 1
- 2388 1
- 2446 1
- 2473 1
- 2519 1
- 2535 1
- 2544 1
- 2588 1
- 2601 1
- 2653 1
- 2667 1
- 2683 1
- 2707 1
- 2723 1
- 2751 1
- 2776 1
- 2817 1
- 2838 1
- 2848 1
- 2861 1
- 2884 1
- 2912 1
- 2979 1
- 3025 1
- 3050 1
- 3070 1
- 3089 1
- 3125 1
- 3159 1
- 3183 1
- 3232 1
- 3252 1
- 3277 1
- 3314 1
- 3359 1
- 3402 1
- 3449 1
- 3514 1
- 3623 1
- 3686 1
- 3735 1
- 3823 1
- 3930 1
- 4045 1
- 4147 1
- 4213 1
- 4231 1
- 4283 1
- 4333 1
- 4395 1
- 4438 1
- 4643 1
- 5141 1
- 5313 1
- 5428 1
- 5538 1
- 5698 1
- 5800 1
- 5889 1
- 6047 1
- 6101 1
- 6160 1
- 6399 1
- 6535 1
- 6656 1
- 6811 1
- 6905 1
- 7025 1
- 7146 1
- 7232 1
- 7340 1
- 7469 1
- 7547 1
- 7608 1
- 7714 1
- 7799 1
- 7888 1
- 7973 1
- 8082 1
- 8159 1
- 8209 1
- 8278 1
- 8359 1
- 8423 1
- 8537 1
- 8619 1
- 8692 1
- 8737 1
- 8786 1
- 8904 1
- 8975 1
- 9030 1
- 9084 1
- 9205 1
- 9419 1
- 9455 1
- 9587 1
- 9651 1
- 9781 1
- 9854 1
- 9905 1
- 9978 1
- 10004 1
- 10015 1
- 10089 1
- 10181 1
- 10248 1
- 10316 1
- 10357 1
- 10413 1
- 10450 1
- 10484 1
- 10547 1
- 10620 1
- 10683 1
- 10739 1
- 10780 1
- 10830 1
- 10851 1
- 10898 1
- 10937 1
- 10982 1
- 11042 1
- 11091 1
- 11109 1
- 11133 1
- 11171 1
- 11223 1
- 11258 1
- 11284 1
- 11309 1
- 11335 1
- 11363 1
- 11404 1
- 11437 1
- 11450 1
- 11470 1
- 11496 1
- 11517 1
- 11526 1
- 11556 1
- 11581 1
- 11612 1
- 11633 1
- 11660 1
- 11669 1
- 11679 1
- 11700 1
- 11720 1
- 11739 1
- 11761 1
- 11772 1
- 11779 1
- 11789 1
- 11817 1
- 11833 1
- 11848 1
- 11859 1
- 11878 1
- 11884 1
- 11924 1
- 11944 1
- 11965 1
- 11988 1
- 12013 1
- 12036 1
- 12049 1
- 12058 1
- 12079 1
- 12093 1
- 12126 1
- 12152 1
- 12169 1
- 12179 1
- 12190 1
- 12208 1
- 12232 1
- 12246 1
- 12267 1
- 12284 1
- 12306 1
- 12318 1
- 12344 1
- 12369 1
- 12382 1
- 12429 1
- 12458 1
- 12490 1
- 12512 1
- 12540 1
- 12569 1
- 12587 1
- 12604 1
- 12613 1
- 12647 1
- 12682 1
- 12703 1
- 12732 1
- 12762 1
- 12780 1
- 12793 1
- 12828 1
- 12844 1
- 12871 1
- 12896 1
- 12919 1
- 12931 1
- 12949 1
- 12962 1
- 13001 1
- 13024 1
- 13045 1
- 13067 1
- 13077 1
- 13082 1
- 13097 1
- 13121 1
- 13141 1
- 13150 1
- 13164 1
- 13184 1
- 13190 1
- 13216 1
- 13225 1
- 13242 1
- 13255 1
- 13265 1
- 13270 1
- 13276 1
- 13296 1
- 13307 1
- 13317 1
- 13319 1
- 13324 1
- 13328 1
- 13330 1
- 13332 1
- 13338 1
- 13346 1
- 13347 1
- 13350 1
- 13355 1
- 13362 1
- 13367 1
- 13368 1
- 13370 1
- 13373 1
- 13376 1
- 13380 1
- 13381 1
- 13383 1
- 13385 1
- 13386 1
- 13387 1
- 13388 1
- 13390 1
- 13391 1
- 13393 1
- 13397 1
- 13399 1
- 13401 1
- 13407 1
- 13411 1
- 13412 1
- 13416 1
- 13420 1
- 13421 1
- 13423 1
- 13424 1
- 13425 1
- 13433 1
- 13438 1
- 13443 1
- 13449 1
- 13466 1
- 13474 1
- 13485 1
- 13488 1
- 13495 1
- 13517 1
- 13549 1
- 13557 1
- 13567 1
- 13605 1
- 13678 1
- 13691 1
- 13721 1
- 13792 1
- 13853 1
- 13903 1
- 13941 1
- 14043 1
- 14168 1
- 14198 1
- 14252 1
- 14414 1
- 14548 1
- 14568 1
- 14632 1
- 14776 1
- 14921 1
- 14945 1
- 15036 1
- 15162 1
- 15304 1
- 15342 1
- 15445 1
- 15582 1
- 15650 1
- 15718 1
- 15877 1
- 16057 1
- 16101 1
- 16191 1
- 16347 1
- 16498 1
- 16546 1
- 16640 1
- 16823 1
- 17009 1
- 17093 1
- 17195 1
- 17346 1
- 17590 1
- 17646 1
- 17737 1
- 17894 1
- 18023 1
- 18060 1
- 18125 1
- 18209 1
- 18423 1
- 18469 1
- 18534 1
- 18841 1
- 19070 1
- 19151 1
- 19309 1
- 19492 1
- 19682 1
- 19815 1
- 19981 1
- 20266 1
- 20591 1
- 20657 1
- 20834 1
- 21150 1
- 21510 1
- 21874 1
- 22258 1
- 22339 1
- 22502 1
- 22837 1
- 23165 1
- 23233 1
- 23374 1
- 23539 1
- 23748 1
- 23793 1
- 23896 1
- 24057 1
- 24259 1
- 24317 1
- 24517 1
- 24788 1
- 24873 1
- 25152 1
- 25308 1
- 25375 1
- 25593 1
- 26503 1
- 27729 1
- 28251 1
- 28820 1
- 29675 1
- 31384 1
- 31772 1
- 32979 1
- 34274 1
- 34739 1
- 35467 1
- 36366 1
- 37031 1
- 37263 1
- 37455 1
- 37819 1
- 38136 1
- 38292 1
- 38434 1
- 38742 1
- 38970 1
- 39022 1
- 39103 1
- 39297 1
- 39451 1
- 39545 1
- 39638 1
- 39755 1
- 39779 1
- 39853 1
- 39950 1
- 40034 1
- 40045 1
- 40091 1
- 40253 1
- 40280 1
- 40341 1
- 40372 1
- 40437 1
- 40502 1
- 40507 1
- 40563 1
- 40649 1
- 40732 1
- 40749 1
- 40792 1
- 40870 1
- 40957 1
- 40966 1
- 41008 1
- 41095 1
- 41172 1
- 41203 1
- 41273 1
- 41410 1
- 41503 1
- 41557 1
- 41634 1
- 41803 1
- 41975 1
- 42017 1
- 42109 1
- 42313 1
- 42446 1
- 42561 1
- 42687 1
- 42992 1
- 43221 1
- 43279 1
- 43438 1
- 43593 1
state 1
- Minnesota 794
fips 1
- 27109 · 794 ✖
county 1
- Olmsted 794
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1264 | 1264 | 2020-03-11 | Olmsted | Minnesota | 27109 | 1 | 0 |
1489 | 1489 | 2020-03-12 | Olmsted | Minnesota | 27109 | 1 | 0 |
1772 | 1772 | 2020-03-13 | Olmsted | Minnesota | 27109 | 1 | 0 |
2116 | 2116 | 2020-03-14 | Olmsted | Minnesota | 27109 | 1 | 0 |
2520 | 2520 | 2020-03-15 | Olmsted | Minnesota | 27109 | 2 | 0 |
2972 | 2972 | 2020-03-16 | Olmsted | Minnesota | 27109 | 3 | 0 |
3477 | 3477 | 2020-03-17 | Olmsted | Minnesota | 27109 | 3 | 0 |
4060 | 4060 | 2020-03-18 | Olmsted | Minnesota | 27109 | 6 | 0 |
4771 | 4771 | 2020-03-19 | Olmsted | Minnesota | 27109 | 6 | 0 |
5593 | 5593 | 2020-03-20 | Olmsted | Minnesota | 27109 | 11 | 0 |
6563 | 6563 | 2020-03-21 | Olmsted | Minnesota | 27109 | 12 | 0 |
7645 | 7645 | 2020-03-22 | Olmsted | Minnesota | 27109 | 14 | 0 |
8824 | 8824 | 2020-03-23 | Olmsted | Minnesota | 27109 | 16 | 0 |
10119 | 10119 | 2020-03-24 | Olmsted | Minnesota | 27109 | 18 | 0 |
11537 | 11537 | 2020-03-25 | Olmsted | Minnesota | 27109 | 21 | 0 |
13126 | 13126 | 2020-03-26 | Olmsted | Minnesota | 27109 | 29 | 0 |
14842 | 14842 | 2020-03-27 | Olmsted | Minnesota | 27109 | 34 | 0 |
16664 | 16664 | 2020-03-28 | Olmsted | Minnesota | 27109 | 37 | 0 |
18583 | 18583 | 2020-03-29 | Olmsted | Minnesota | 27109 | 47 | 0 |
20605 | 20605 | 2020-03-30 | Olmsted | Minnesota | 27109 | 51 | 0 |
22720 | 22720 | 2020-03-31 | Olmsted | Minnesota | 27109 | 53 | 0 |
24902 | 24902 | 2020-04-01 | Olmsted | Minnesota | 27109 | 61 | 0 |
27156 | 27156 | 2020-04-02 | Olmsted | Minnesota | 27109 | 66 | 1 |
29475 | 29475 | 2020-04-03 | Olmsted | Minnesota | 27109 | 76 | 2 |
31854 | 31854 | 2020-04-04 | Olmsted | Minnesota | 27109 | 88 | 2 |
34280 | 34280 | 2020-04-05 | Olmsted | Minnesota | 27109 | 95 | 2 |
36741 | 36741 | 2020-04-06 | Olmsted | Minnesota | 27109 | 96 | 2 |
39250 | 39250 | 2020-04-07 | Olmsted | Minnesota | 27109 | 103 | 2 |
41803 | 41803 | 2020-04-08 | Olmsted | Minnesota | 27109 | 108 | 2 |
44379 | 44379 | 2020-04-09 | Olmsted | Minnesota | 27109 | 114 | 2 |
46989 | 46989 | 2020-04-10 | Olmsted | Minnesota | 27109 | 126 | 2 |
49634 | 49634 | 2020-04-11 | Olmsted | Minnesota | 27109 | 132 | 2 |
52304 | 52304 | 2020-04-12 | Olmsted | Minnesota | 27109 | 143 | 2 |
54986 | 54986 | 2020-04-13 | Olmsted | Minnesota | 27109 | 143 | 2 |
57684 | 57684 | 2020-04-14 | Olmsted | Minnesota | 27109 | 147 | 2 |
60395 | 60395 | 2020-04-15 | Olmsted | Minnesota | 27109 | 153 | 2 |
63118 | 63118 | 2020-04-16 | Olmsted | Minnesota | 27109 | 163 | 2 |
65857 | 65857 | 2020-04-17 | Olmsted | Minnesota | 27109 | 174 | 2 |
68609 | 68609 | 2020-04-18 | Olmsted | Minnesota | 27109 | 177 | 2 |
71375 | 71375 | 2020-04-19 | Olmsted | Minnesota | 27109 | 194 | 3 |
74148 | 74148 | 2020-04-20 | Olmsted | Minnesota | 27109 | 197 | 4 |
76928 | 76928 | 2020-04-21 | Olmsted | Minnesota | 27109 | 198 | 4 |
79713 | 79713 | 2020-04-22 | Olmsted | Minnesota | 27109 | 204 | 4 |
82509 | 82509 | 2020-04-23 | Olmsted | Minnesota | 27109 | 213 | 5 |
85313 | 85313 | 2020-04-24 | Olmsted | Minnesota | 27109 | 219 | 6 |
88123 | 88123 | 2020-04-25 | Olmsted | Minnesota | 27109 | 238 | 6 |
90939 | 90939 | 2020-04-26 | Olmsted | Minnesota | 27109 | 239 | 6 |
93760 | 93760 | 2020-04-27 | Olmsted | Minnesota | 27109 | 246 | 6 |
96595 | 96595 | 2020-04-28 | Olmsted | Minnesota | 27109 | 251 | 6 |
99441 | 99441 | 2020-04-29 | Olmsted | Minnesota | 27109 | 256 | 6 |
102293 | 102293 | 2020-04-30 | Olmsted | Minnesota | 27109 | 265 | 6 |
105154 | 105154 | 2020-05-01 | Olmsted | Minnesota | 27109 | 269 | 8 |
108019 | 108019 | 2020-05-02 | Olmsted | Minnesota | 27109 | 282 | 8 |
110890 | 110890 | 2020-05-03 | Olmsted | Minnesota | 27109 | 293 | 8 |
113769 | 113769 | 2020-05-04 | Olmsted | Minnesota | 27109 | 305 | 8 |
116650 | 116650 | 2020-05-05 | Olmsted | Minnesota | 27109 | 313 | 8 |
119610 | 119610 | 2020-05-06 | Olmsted | Minnesota | 27109 | 322 | 8 |
122584 | 122584 | 2020-05-07 | Olmsted | Minnesota | 27109 | 336 | 8 |
125566 | 125566 | 2020-05-08 | Olmsted | Minnesota | 27109 | 351 | 9 |
128553 | 128553 | 2020-05-09 | Olmsted | Minnesota | 27109 | 363 | 9 |
131543 | 131543 | 2020-05-10 | Olmsted | Minnesota | 27109 | 368 | 9 |
134534 | 134534 | 2020-05-11 | Olmsted | Minnesota | 27109 | 374 | 9 |
137524 | 137524 | 2020-05-12 | Olmsted | Minnesota | 27109 | 378 | 9 |
140518 | 140518 | 2020-05-13 | Olmsted | Minnesota | 27109 | 378 | 9 |
143513 | 143513 | 2020-05-14 | Olmsted | Minnesota | 27109 | 399 | 9 |
146513 | 146513 | 2020-05-15 | Olmsted | Minnesota | 27109 | 417 | 9 |
149518 | 149518 | 2020-05-16 | Olmsted | Minnesota | 27109 | 435 | 9 |
152529 | 152529 | 2020-05-17 | Olmsted | Minnesota | 27109 | 448 | 9 |
155543 | 155543 | 2020-05-18 | Olmsted | Minnesota | 27109 | 461 | 9 |
158561 | 158561 | 2020-05-19 | Olmsted | Minnesota | 27109 | 479 | 10 |
161587 | 161587 | 2020-05-20 | Olmsted | Minnesota | 27109 | 488 | 10 |
164616 | 164616 | 2020-05-21 | Olmsted | Minnesota | 27109 | 493 | 10 |
167652 | 167652 | 2020-05-22 | Olmsted | Minnesota | 27109 | 525 | 10 |
170690 | 170690 | 2020-05-23 | Olmsted | Minnesota | 27109 | 542 | 10 |
173732 | 173732 | 2020-05-24 | Olmsted | Minnesota | 27109 | 551 | 10 |
176775 | 176775 | 2020-05-25 | Olmsted | Minnesota | 27109 | 562 | 10 |
179819 | 179819 | 2020-05-26 | Olmsted | Minnesota | 27109 | 570 | 10 |
182865 | 182865 | 2020-05-27 | Olmsted | Minnesota | 27109 | 575 | 10 |
185920 | 185920 | 2020-05-28 | Olmsted | Minnesota | 27109 | 582 | 10 |
188978 | 188978 | 2020-05-29 | Olmsted | Minnesota | 27109 | 594 | 10 |
192042 | 192042 | 2020-05-30 | Olmsted | Minnesota | 27109 | 608 | 10 |
195110 | 195110 | 2020-05-31 | Olmsted | Minnesota | 27109 | 626 | 10 |
198181 | 198181 | 2020-06-01 | Olmsted | Minnesota | 27109 | 634 | 10 |
201254 | 201254 | 2020-06-02 | Olmsted | Minnesota | 27109 | 650 | 11 |
204331 | 204331 | 2020-06-03 | Olmsted | Minnesota | 27109 | 654 | 11 |
207412 | 207412 | 2020-06-04 | Olmsted | Minnesota | 27109 | 672 | 11 |
210493 | 210493 | 2020-06-05 | Olmsted | Minnesota | 27109 | 689 | 11 |
213577 | 213577 | 2020-06-06 | Olmsted | Minnesota | 27109 | 699 | 12 |
216665 | 216665 | 2020-06-07 | Olmsted | Minnesota | 27109 | 711 | 12 |
219757 | 219757 | 2020-06-08 | Olmsted | Minnesota | 27109 | 722 | 12 |
222852 | 222852 | 2020-06-09 | Olmsted | Minnesota | 27109 | 727 | 12 |
225950 | 225950 | 2020-06-10 | Olmsted | Minnesota | 27109 | 740 | 12 |
229052 | 229052 | 2020-06-11 | Olmsted | Minnesota | 27109 | 752 | 12 |
232156 | 232156 | 2020-06-12 | Olmsted | Minnesota | 27109 | 765 | 12 |
235262 | 235262 | 2020-06-13 | Olmsted | Minnesota | 27109 | 775 | 12 |
238369 | 238369 | 2020-06-14 | Olmsted | Minnesota | 27109 | 778 | 12 |
241478 | 241478 | 2020-06-15 | Olmsted | Minnesota | 27109 | 778 | 12 |
244589 | 244589 | 2020-06-16 | Olmsted | Minnesota | 27109 | 781 | 12 |
247702 | 247702 | 2020-06-17 | Olmsted | Minnesota | 27109 | 810 | 12 |
250814 | 250814 | 2020-06-18 | Olmsted | Minnesota | 27109 | 832 | 13 |
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);