ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 27109 and state = "Minnesota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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);