ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 27043 and state = "Minnesota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14829 | 14829 | 2020-03-27 | Faribault | Minnesota | 27043 | 1 | 0 |
16651 | 16651 | 2020-03-28 | Faribault | Minnesota | 27043 | 1 | 0 |
18569 | 18569 | 2020-03-29 | Faribault | Minnesota | 27043 | 1 | 0 |
20589 | 20589 | 2020-03-30 | Faribault | Minnesota | 27043 | 1 | 0 |
22703 | 22703 | 2020-03-31 | Faribault | Minnesota | 27043 | 2 | 0 |
24884 | 24884 | 2020-04-01 | Faribault | Minnesota | 27043 | 2 | 0 |
27137 | 27137 | 2020-04-02 | Faribault | Minnesota | 27043 | 2 | 0 |
29456 | 29456 | 2020-04-03 | Faribault | Minnesota | 27043 | 3 | 0 |
31834 | 31834 | 2020-04-04 | Faribault | Minnesota | 27043 | 3 | 0 |
34259 | 34259 | 2020-04-05 | Faribault | Minnesota | 27043 | 3 | 0 |
36719 | 36719 | 2020-04-06 | Faribault | Minnesota | 27043 | 3 | 0 |
39228 | 39228 | 2020-04-07 | Faribault | Minnesota | 27043 | 3 | 0 |
41781 | 41781 | 2020-04-08 | Faribault | Minnesota | 27043 | 3 | 0 |
44357 | 44357 | 2020-04-09 | Faribault | Minnesota | 27043 | 4 | 0 |
46966 | 46966 | 2020-04-10 | Faribault | Minnesota | 27043 | 4 | 0 |
49611 | 49611 | 2020-04-11 | Faribault | Minnesota | 27043 | 4 | 0 |
52281 | 52281 | 2020-04-12 | Faribault | Minnesota | 27043 | 4 | 0 |
54963 | 54963 | 2020-04-13 | Faribault | Minnesota | 27043 | 4 | 0 |
57661 | 57661 | 2020-04-14 | Faribault | Minnesota | 27043 | 4 | 0 |
60371 | 60371 | 2020-04-15 | Faribault | Minnesota | 27043 | 4 | 0 |
63093 | 63093 | 2020-04-16 | Faribault | Minnesota | 27043 | 4 | 0 |
65832 | 65832 | 2020-04-17 | Faribault | Minnesota | 27043 | 4 | 0 |
68583 | 68583 | 2020-04-18 | Faribault | Minnesota | 27043 | 4 | 0 |
71347 | 71347 | 2020-04-19 | Faribault | Minnesota | 27043 | 4 | 0 |
74120 | 74120 | 2020-04-20 | Faribault | Minnesota | 27043 | 4 | 0 |
76900 | 76900 | 2020-04-21 | Faribault | Minnesota | 27043 | 4 | 0 |
79685 | 79685 | 2020-04-22 | Faribault | Minnesota | 27043 | 4 | 0 |
82481 | 82481 | 2020-04-23 | Faribault | Minnesota | 27043 | 4 | 0 |
85285 | 85285 | 2020-04-24 | Faribault | Minnesota | 27043 | 4 | 0 |
88095 | 88095 | 2020-04-25 | Faribault | Minnesota | 27043 | 4 | 0 |
90911 | 90911 | 2020-04-26 | Faribault | Minnesota | 27043 | 4 | 0 |
93732 | 93732 | 2020-04-27 | Faribault | Minnesota | 27043 | 4 | 0 |
96567 | 96567 | 2020-04-28 | Faribault | Minnesota | 27043 | 4 | 0 |
99413 | 99413 | 2020-04-29 | Faribault | Minnesota | 27043 | 5 | 0 |
102265 | 102265 | 2020-04-30 | Faribault | Minnesota | 27043 | 5 | 0 |
105125 | 105125 | 2020-05-01 | Faribault | Minnesota | 27043 | 5 | 0 |
107989 | 107989 | 2020-05-02 | Faribault | Minnesota | 27043 | 6 | 0 |
110860 | 110860 | 2020-05-03 | Faribault | Minnesota | 27043 | 6 | 0 |
113739 | 113739 | 2020-05-04 | Faribault | Minnesota | 27043 | 7 | 0 |
116620 | 116620 | 2020-05-05 | Faribault | Minnesota | 27043 | 7 | 0 |
119580 | 119580 | 2020-05-06 | Faribault | Minnesota | 27043 | 8 | 0 |
122553 | 122553 | 2020-05-07 | Faribault | Minnesota | 27043 | 7 | 0 |
125535 | 125535 | 2020-05-08 | Faribault | Minnesota | 27043 | 7 | 0 |
128522 | 128522 | 2020-05-09 | Faribault | Minnesota | 27043 | 10 | 0 |
131512 | 131512 | 2020-05-10 | Faribault | Minnesota | 27043 | 12 | 0 |
134503 | 134503 | 2020-05-11 | Faribault | Minnesota | 27043 | 10 | 0 |
137493 | 137493 | 2020-05-12 | Faribault | Minnesota | 27043 | 10 | 0 |
140487 | 140487 | 2020-05-13 | Faribault | Minnesota | 27043 | 10 | 0 |
143482 | 143482 | 2020-05-14 | Faribault | Minnesota | 27043 | 9 | 0 |
146482 | 146482 | 2020-05-15 | Faribault | Minnesota | 27043 | 12 | 0 |
149487 | 149487 | 2020-05-16 | Faribault | Minnesota | 27043 | 9 | 0 |
152498 | 152498 | 2020-05-17 | Faribault | Minnesota | 27043 | 10 | 0 |
155512 | 155512 | 2020-05-18 | Faribault | Minnesota | 27043 | 10 | 0 |
158530 | 158530 | 2020-05-19 | Faribault | Minnesota | 27043 | 11 | 0 |
161556 | 161556 | 2020-05-20 | Faribault | Minnesota | 27043 | 10 | 0 |
164585 | 164585 | 2020-05-21 | Faribault | Minnesota | 27043 | 11 | 0 |
167621 | 167621 | 2020-05-22 | Faribault | Minnesota | 27043 | 11 | 0 |
170658 | 170658 | 2020-05-23 | Faribault | Minnesota | 27043 | 11 | 0 |
173700 | 173700 | 2020-05-24 | Faribault | Minnesota | 27043 | 11 | 0 |
176743 | 176743 | 2020-05-25 | Faribault | Minnesota | 27043 | 12 | 0 |
179787 | 179787 | 2020-05-26 | Faribault | Minnesota | 27043 | 13 | 0 |
182833 | 182833 | 2020-05-27 | Faribault | Minnesota | 27043 | 13 | 0 |
185888 | 185888 | 2020-05-28 | Faribault | Minnesota | 27043 | 13 | 0 |
188946 | 188946 | 2020-05-29 | Faribault | Minnesota | 27043 | 15 | 0 |
192010 | 192010 | 2020-05-30 | Faribault | Minnesota | 27043 | 18 | 0 |
195078 | 195078 | 2020-05-31 | Faribault | Minnesota | 27043 | 18 | 0 |
198149 | 198149 | 2020-06-01 | Faribault | Minnesota | 27043 | 19 | 0 |
201222 | 201222 | 2020-06-02 | Faribault | Minnesota | 27043 | 20 | 0 |
204299 | 204299 | 2020-06-03 | Faribault | Minnesota | 27043 | 20 | 0 |
207380 | 207380 | 2020-06-04 | Faribault | Minnesota | 27043 | 20 | 0 |
210461 | 210461 | 2020-06-05 | Faribault | Minnesota | 27043 | 22 | 0 |
213545 | 213545 | 2020-06-06 | Faribault | Minnesota | 27043 | 23 | 0 |
216633 | 216633 | 2020-06-07 | Faribault | Minnesota | 27043 | 23 | 0 |
219725 | 219725 | 2020-06-08 | Faribault | Minnesota | 27043 | 24 | 0 |
222820 | 222820 | 2020-06-09 | Faribault | Minnesota | 27043 | 25 | 0 |
225918 | 225918 | 2020-06-10 | Faribault | Minnesota | 27043 | 25 | 0 |
229020 | 229020 | 2020-06-11 | Faribault | Minnesota | 27043 | 25 | 0 |
232124 | 232124 | 2020-06-12 | Faribault | Minnesota | 27043 | 25 | 0 |
235230 | 235230 | 2020-06-13 | Faribault | Minnesota | 27043 | 26 | 0 |
238337 | 238337 | 2020-06-14 | Faribault | Minnesota | 27043 | 27 | 0 |
241446 | 241446 | 2020-06-15 | Faribault | Minnesota | 27043 | 27 | 0 |
244557 | 244557 | 2020-06-16 | Faribault | Minnesota | 27043 | 28 | 0 |
247670 | 247670 | 2020-06-17 | Faribault | Minnesota | 27043 | 30 | 0 |
250782 | 250782 | 2020-06-18 | Faribault | Minnesota | 27043 | 32 | 0 |
253897 | 253897 | 2020-06-19 | Faribault | Minnesota | 27043 | 30 | 0 |
257017 | 257017 | 2020-06-20 | Faribault | Minnesota | 27043 | 31 | 0 |
260143 | 260143 | 2020-06-21 | Faribault | Minnesota | 27043 | 33 | 0 |
263272 | 263272 | 2020-06-22 | Faribault | Minnesota | 27043 | 33 | 0 |
266398 | 266398 | 2020-06-23 | Faribault | Minnesota | 27043 | 35 | 0 |
269531 | 269531 | 2020-06-24 | Faribault | Minnesota | 27043 | 35 | 0 |
272668 | 272668 | 2020-06-25 | Faribault | Minnesota | 27043 | 41 | 0 |
275811 | 275811 | 2020-06-26 | Faribault | Minnesota | 27043 | 44 | 0 |
278959 | 278959 | 2020-06-27 | Faribault | Minnesota | 27043 | 45 | 0 |
282107 | 282107 | 2020-06-28 | Faribault | Minnesota | 27043 | 48 | 0 |
285252 | 285252 | 2020-06-29 | Faribault | Minnesota | 27043 | 53 | 0 |
288402 | 288402 | 2020-06-30 | Faribault | Minnesota | 27043 | 53 | 0 |
291553 | 291553 | 2020-07-01 | Faribault | Minnesota | 27043 | 53 | 0 |
294707 | 294707 | 2020-07-02 | Faribault | Minnesota | 27043 | 54 | 0 |
297865 | 297865 | 2020-07-03 | Faribault | Minnesota | 27043 | 55 | 0 |
301028 | 301028 | 2020-07-04 | Faribault | Minnesota | 27043 | 55 | 0 |
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);