ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 27085 and state = "Minnesota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
31850 | 31850 | 2020-04-04 | McLeod | Minnesota | 27085 | 1 | 0 |
34276 | 34276 | 2020-04-05 | McLeod | Minnesota | 27085 | 1 | 0 |
36736 | 36736 | 2020-04-06 | McLeod | Minnesota | 27085 | 1 | 0 |
39245 | 39245 | 2020-04-07 | McLeod | Minnesota | 27085 | 1 | 0 |
41798 | 41798 | 2020-04-08 | McLeod | Minnesota | 27085 | 1 | 0 |
44374 | 44374 | 2020-04-09 | McLeod | Minnesota | 27085 | 2 | 0 |
46983 | 46983 | 2020-04-10 | McLeod | Minnesota | 27085 | 2 | 0 |
49628 | 49628 | 2020-04-11 | McLeod | Minnesota | 27085 | 2 | 0 |
52298 | 52298 | 2020-04-12 | McLeod | Minnesota | 27085 | 2 | 0 |
54980 | 54980 | 2020-04-13 | McLeod | Minnesota | 27085 | 2 | 0 |
57678 | 57678 | 2020-04-14 | McLeod | Minnesota | 27085 | 2 | 0 |
60388 | 60388 | 2020-04-15 | McLeod | Minnesota | 27085 | 2 | 0 |
63110 | 63110 | 2020-04-16 | McLeod | Minnesota | 27085 | 2 | 0 |
65849 | 65849 | 2020-04-17 | McLeod | Minnesota | 27085 | 2 | 0 |
68601 | 68601 | 2020-04-18 | McLeod | Minnesota | 27085 | 3 | 0 |
71366 | 71366 | 2020-04-19 | McLeod | Minnesota | 27085 | 3 | 0 |
74139 | 74139 | 2020-04-20 | McLeod | Minnesota | 27085 | 3 | 0 |
76919 | 76919 | 2020-04-21 | McLeod | Minnesota | 27085 | 3 | 0 |
79704 | 79704 | 2020-04-22 | McLeod | Minnesota | 27085 | 3 | 0 |
82500 | 82500 | 2020-04-23 | McLeod | Minnesota | 27085 | 3 | 0 |
85304 | 85304 | 2020-04-24 | McLeod | Minnesota | 27085 | 3 | 0 |
88114 | 88114 | 2020-04-25 | McLeod | Minnesota | 27085 | 3 | 0 |
90930 | 90930 | 2020-04-26 | McLeod | Minnesota | 27085 | 3 | 0 |
93751 | 93751 | 2020-04-27 | McLeod | Minnesota | 27085 | 4 | 0 |
96586 | 96586 | 2020-04-28 | McLeod | Minnesota | 27085 | 4 | 0 |
99432 | 99432 | 2020-04-29 | McLeod | Minnesota | 27085 | 4 | 0 |
102284 | 102284 | 2020-04-30 | McLeod | Minnesota | 27085 | 4 | 0 |
105145 | 105145 | 2020-05-01 | McLeod | Minnesota | 27085 | 4 | 0 |
108010 | 108010 | 2020-05-02 | McLeod | Minnesota | 27085 | 4 | 0 |
110881 | 110881 | 2020-05-03 | McLeod | Minnesota | 27085 | 4 | 0 |
113760 | 113760 | 2020-05-04 | McLeod | Minnesota | 27085 | 4 | 0 |
116641 | 116641 | 2020-05-05 | McLeod | Minnesota | 27085 | 4 | 0 |
119601 | 119601 | 2020-05-06 | McLeod | Minnesota | 27085 | 6 | 0 |
122575 | 122575 | 2020-05-07 | McLeod | Minnesota | 27085 | 6 | 0 |
125557 | 125557 | 2020-05-08 | McLeod | Minnesota | 27085 | 8 | 0 |
128544 | 128544 | 2020-05-09 | McLeod | Minnesota | 27085 | 8 | 0 |
131534 | 131534 | 2020-05-10 | McLeod | Minnesota | 27085 | 12 | 0 |
134525 | 134525 | 2020-05-11 | McLeod | Minnesota | 27085 | 13 | 0 |
137515 | 137515 | 2020-05-12 | McLeod | Minnesota | 27085 | 14 | 0 |
140509 | 140509 | 2020-05-13 | McLeod | Minnesota | 27085 | 14 | 0 |
143504 | 143504 | 2020-05-14 | McLeod | Minnesota | 27085 | 15 | 0 |
146504 | 146504 | 2020-05-15 | McLeod | Minnesota | 27085 | 15 | 0 |
149509 | 149509 | 2020-05-16 | McLeod | Minnesota | 27085 | 16 | 0 |
152520 | 152520 | 2020-05-17 | McLeod | Minnesota | 27085 | 18 | 0 |
155534 | 155534 | 2020-05-18 | McLeod | Minnesota | 27085 | 18 | 0 |
158552 | 158552 | 2020-05-19 | McLeod | Minnesota | 27085 | 18 | 0 |
161578 | 161578 | 2020-05-20 | McLeod | Minnesota | 27085 | 19 | 0 |
164607 | 164607 | 2020-05-21 | McLeod | Minnesota | 27085 | 21 | 0 |
167643 | 167643 | 2020-05-22 | McLeod | Minnesota | 27085 | 24 | 0 |
170681 | 170681 | 2020-05-23 | McLeod | Minnesota | 27085 | 26 | 0 |
173723 | 173723 | 2020-05-24 | McLeod | Minnesota | 27085 | 26 | 0 |
176766 | 176766 | 2020-05-25 | McLeod | Minnesota | 27085 | 27 | 0 |
179810 | 179810 | 2020-05-26 | McLeod | Minnesota | 27085 | 28 | 0 |
182856 | 182856 | 2020-05-27 | McLeod | Minnesota | 27085 | 29 | 0 |
185911 | 185911 | 2020-05-28 | McLeod | Minnesota | 27085 | 30 | 0 |
188969 | 188969 | 2020-05-29 | McLeod | Minnesota | 27085 | 33 | 0 |
192033 | 192033 | 2020-05-30 | McLeod | Minnesota | 27085 | 34 | 0 |
195101 | 195101 | 2020-05-31 | McLeod | Minnesota | 27085 | 37 | 0 |
198172 | 198172 | 2020-06-01 | McLeod | Minnesota | 27085 | 37 | 0 |
201245 | 201245 | 2020-06-02 | McLeod | Minnesota | 27085 | 37 | 0 |
204322 | 204322 | 2020-06-03 | McLeod | Minnesota | 27085 | 37 | 0 |
207403 | 207403 | 2020-06-04 | McLeod | Minnesota | 27085 | 39 | 0 |
210484 | 210484 | 2020-06-05 | McLeod | Minnesota | 27085 | 41 | 0 |
213568 | 213568 | 2020-06-06 | McLeod | Minnesota | 27085 | 43 | 0 |
216656 | 216656 | 2020-06-07 | McLeod | Minnesota | 27085 | 43 | 0 |
219748 | 219748 | 2020-06-08 | McLeod | Minnesota | 27085 | 44 | 0 |
222843 | 222843 | 2020-06-09 | McLeod | Minnesota | 27085 | 45 | 0 |
225941 | 225941 | 2020-06-10 | McLeod | Minnesota | 27085 | 46 | 0 |
229043 | 229043 | 2020-06-11 | McLeod | Minnesota | 27085 | 52 | 0 |
232147 | 232147 | 2020-06-12 | McLeod | Minnesota | 27085 | 52 | 0 |
235253 | 235253 | 2020-06-13 | McLeod | Minnesota | 27085 | 54 | 0 |
238360 | 238360 | 2020-06-14 | McLeod | Minnesota | 27085 | 54 | 0 |
241469 | 241469 | 2020-06-15 | McLeod | Minnesota | 27085 | 54 | 0 |
244580 | 244580 | 2020-06-16 | McLeod | Minnesota | 27085 | 54 | 0 |
247693 | 247693 | 2020-06-17 | McLeod | Minnesota | 27085 | 56 | 0 |
250805 | 250805 | 2020-06-18 | McLeod | Minnesota | 27085 | 58 | 0 |
253920 | 253920 | 2020-06-19 | McLeod | Minnesota | 27085 | 64 | 0 |
257040 | 257040 | 2020-06-20 | McLeod | Minnesota | 27085 | 66 | 0 |
260166 | 260166 | 2020-06-21 | McLeod | Minnesota | 27085 | 67 | 0 |
263295 | 263295 | 2020-06-22 | McLeod | Minnesota | 27085 | 68 | 0 |
266421 | 266421 | 2020-06-23 | McLeod | Minnesota | 27085 | 69 | 0 |
269554 | 269554 | 2020-06-24 | McLeod | Minnesota | 27085 | 71 | 0 |
272691 | 272691 | 2020-06-25 | McLeod | Minnesota | 27085 | 75 | 0 |
275834 | 275834 | 2020-06-26 | McLeod | Minnesota | 27085 | 80 | 0 |
278982 | 278982 | 2020-06-27 | McLeod | Minnesota | 27085 | 80 | 0 |
282130 | 282130 | 2020-06-28 | McLeod | Minnesota | 27085 | 79 | 0 |
285275 | 285275 | 2020-06-29 | McLeod | Minnesota | 27085 | 81 | 0 |
288425 | 288425 | 2020-06-30 | McLeod | Minnesota | 27085 | 81 | 0 |
291576 | 291576 | 2020-07-01 | McLeod | Minnesota | 27085 | 85 | 0 |
294730 | 294730 | 2020-07-02 | McLeod | Minnesota | 27085 | 85 | 0 |
297888 | 297888 | 2020-07-03 | McLeod | Minnesota | 27085 | 88 | 0 |
301051 | 301051 | 2020-07-04 | McLeod | Minnesota | 27085 | 88 | 0 |
304215 | 304215 | 2020-07-05 | McLeod | Minnesota | 27085 | 91 | 0 |
307382 | 307382 | 2020-07-06 | McLeod | Minnesota | 27085 | 92 | 0 |
310550 | 310550 | 2020-07-07 | McLeod | Minnesota | 27085 | 92 | 0 |
313720 | 313720 | 2020-07-08 | McLeod | Minnesota | 27085 | 94 | 0 |
316894 | 316894 | 2020-07-09 | McLeod | Minnesota | 27085 | 96 | 0 |
320069 | 320069 | 2020-07-10 | McLeod | Minnesota | 27085 | 99 | 0 |
323248 | 323248 | 2020-07-11 | McLeod | Minnesota | 27085 | 100 | 0 |
326431 | 326431 | 2020-07-12 | McLeod | Minnesota | 27085 | 103 | 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);