ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 27021 and state = "Minnesota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
8811 | 8811 | 2020-03-23 | Cass | Minnesota | 27021 | 1 | 0 |
10106 | 10106 | 2020-03-24 | Cass | Minnesota | 27021 | 1 | 0 |
11523 | 11523 | 2020-03-25 | Cass | Minnesota | 27021 | 1 | 0 |
13111 | 13111 | 2020-03-26 | Cass | Minnesota | 27021 | 1 | 0 |
14824 | 14824 | 2020-03-27 | Cass | Minnesota | 27021 | 1 | 0 |
16645 | 16645 | 2020-03-28 | Cass | Minnesota | 27021 | 1 | 0 |
18561 | 18561 | 2020-03-29 | Cass | Minnesota | 27021 | 1 | 0 |
20581 | 20581 | 2020-03-30 | Cass | Minnesota | 27021 | 1 | 0 |
22695 | 22695 | 2020-03-31 | Cass | Minnesota | 27021 | 1 | 0 |
24875 | 24875 | 2020-04-01 | Cass | Minnesota | 27021 | 1 | 0 |
27128 | 27128 | 2020-04-02 | Cass | Minnesota | 27021 | 1 | 0 |
29447 | 29447 | 2020-04-03 | Cass | Minnesota | 27021 | 1 | 0 |
31825 | 31825 | 2020-04-04 | Cass | Minnesota | 27021 | 1 | 0 |
34250 | 34250 | 2020-04-05 | Cass | Minnesota | 27021 | 1 | 0 |
36710 | 36710 | 2020-04-06 | Cass | Minnesota | 27021 | 1 | 0 |
39219 | 39219 | 2020-04-07 | Cass | Minnesota | 27021 | 3 | 0 |
41772 | 41772 | 2020-04-08 | Cass | Minnesota | 27021 | 3 | 0 |
44348 | 44348 | 2020-04-09 | Cass | Minnesota | 27021 | 3 | 0 |
46957 | 46957 | 2020-04-10 | Cass | Minnesota | 27021 | 3 | 0 |
49602 | 49602 | 2020-04-11 | Cass | Minnesota | 27021 | 3 | 0 |
52272 | 52272 | 2020-04-12 | Cass | Minnesota | 27021 | 4 | 0 |
54954 | 54954 | 2020-04-13 | Cass | Minnesota | 27021 | 4 | 0 |
57652 | 57652 | 2020-04-14 | Cass | Minnesota | 27021 | 4 | 0 |
60362 | 60362 | 2020-04-15 | Cass | Minnesota | 27021 | 4 | 0 |
63084 | 63084 | 2020-04-16 | Cass | Minnesota | 27021 | 4 | 0 |
65823 | 65823 | 2020-04-17 | Cass | Minnesota | 27021 | 4 | 0 |
68574 | 68574 | 2020-04-18 | Cass | Minnesota | 27021 | 4 | 0 |
71338 | 71338 | 2020-04-19 | Cass | Minnesota | 27021 | 4 | 0 |
74110 | 74110 | 2020-04-20 | Cass | Minnesota | 27021 | 4 | 0 |
76890 | 76890 | 2020-04-21 | Cass | Minnesota | 27021 | 4 | 0 |
79675 | 79675 | 2020-04-22 | Cass | Minnesota | 27021 | 4 | 0 |
82471 | 82471 | 2020-04-23 | Cass | Minnesota | 27021 | 5 | 0 |
85275 | 85275 | 2020-04-24 | Cass | Minnesota | 27021 | 5 | 0 |
88085 | 88085 | 2020-04-25 | Cass | Minnesota | 27021 | 5 | 0 |
90901 | 90901 | 2020-04-26 | Cass | Minnesota | 27021 | 5 | 0 |
93722 | 93722 | 2020-04-27 | Cass | Minnesota | 27021 | 5 | 0 |
96557 | 96557 | 2020-04-28 | Cass | Minnesota | 27021 | 5 | 0 |
99403 | 99403 | 2020-04-29 | Cass | Minnesota | 27021 | 5 | 0 |
102255 | 102255 | 2020-04-30 | Cass | Minnesota | 27021 | 5 | 0 |
105115 | 105115 | 2020-05-01 | Cass | Minnesota | 27021 | 5 | 0 |
107979 | 107979 | 2020-05-02 | Cass | Minnesota | 27021 | 7 | 0 |
110850 | 110850 | 2020-05-03 | Cass | Minnesota | 27021 | 7 | 0 |
113729 | 113729 | 2020-05-04 | Cass | Minnesota | 27021 | 7 | 0 |
116610 | 116610 | 2020-05-05 | Cass | Minnesota | 27021 | 7 | 0 |
119570 | 119570 | 2020-05-06 | Cass | Minnesota | 27021 | 7 | 0 |
122543 | 122543 | 2020-05-07 | Cass | Minnesota | 27021 | 7 | 0 |
125525 | 125525 | 2020-05-08 | Cass | Minnesota | 27021 | 7 | 0 |
128512 | 128512 | 2020-05-09 | Cass | Minnesota | 27021 | 8 | 0 |
131502 | 131502 | 2020-05-10 | Cass | Minnesota | 27021 | 8 | 1 |
134493 | 134493 | 2020-05-11 | Cass | Minnesota | 27021 | 8 | 1 |
137483 | 137483 | 2020-05-12 | Cass | Minnesota | 27021 | 8 | 2 |
140477 | 140477 | 2020-05-13 | Cass | Minnesota | 27021 | 8 | 2 |
143472 | 143472 | 2020-05-14 | Cass | Minnesota | 27021 | 9 | 2 |
146472 | 146472 | 2020-05-15 | Cass | Minnesota | 27021 | 8 | 2 |
149477 | 149477 | 2020-05-16 | Cass | Minnesota | 27021 | 9 | 2 |
152488 | 152488 | 2020-05-17 | Cass | Minnesota | 27021 | 9 | 2 |
155502 | 155502 | 2020-05-18 | Cass | Minnesota | 27021 | 10 | 2 |
158520 | 158520 | 2020-05-19 | Cass | Minnesota | 27021 | 11 | 2 |
161546 | 161546 | 2020-05-20 | Cass | Minnesota | 27021 | 11 | 2 |
164575 | 164575 | 2020-05-21 | Cass | Minnesota | 27021 | 10 | 2 |
167611 | 167611 | 2020-05-22 | Cass | Minnesota | 27021 | 10 | 2 |
170648 | 170648 | 2020-05-23 | Cass | Minnesota | 27021 | 11 | 3 |
173690 | 173690 | 2020-05-24 | Cass | Minnesota | 27021 | 11 | 3 |
176733 | 176733 | 2020-05-25 | Cass | Minnesota | 27021 | 11 | 2 |
179777 | 179777 | 2020-05-26 | Cass | Minnesota | 27021 | 11 | 2 |
182823 | 182823 | 2020-05-27 | Cass | Minnesota | 27021 | 12 | 2 |
185878 | 185878 | 2020-05-28 | Cass | Minnesota | 27021 | 13 | 2 |
188936 | 188936 | 2020-05-29 | Cass | Minnesota | 27021 | 13 | 2 |
192000 | 192000 | 2020-05-30 | Cass | Minnesota | 27021 | 13 | 2 |
195068 | 195068 | 2020-05-31 | Cass | Minnesota | 27021 | 14 | 2 |
198139 | 198139 | 2020-06-01 | Cass | Minnesota | 27021 | 14 | 2 |
201212 | 201212 | 2020-06-02 | Cass | Minnesota | 27021 | 13 | 2 |
204289 | 204289 | 2020-06-03 | Cass | Minnesota | 27021 | 12 | 2 |
207370 | 207370 | 2020-06-04 | Cass | Minnesota | 27021 | 11 | 2 |
210451 | 210451 | 2020-06-05 | Cass | Minnesota | 27021 | 11 | 2 |
213535 | 213535 | 2020-06-06 | Cass | Minnesota | 27021 | 11 | 2 |
216623 | 216623 | 2020-06-07 | Cass | Minnesota | 27021 | 11 | 2 |
219715 | 219715 | 2020-06-08 | Cass | Minnesota | 27021 | 12 | 2 |
222810 | 222810 | 2020-06-09 | Cass | Minnesota | 27021 | 12 | 2 |
225908 | 225908 | 2020-06-10 | Cass | Minnesota | 27021 | 11 | 2 |
229010 | 229010 | 2020-06-11 | Cass | Minnesota | 27021 | 11 | 2 |
232114 | 232114 | 2020-06-12 | Cass | Minnesota | 27021 | 11 | 2 |
235219 | 235219 | 2020-06-13 | Cass | Minnesota | 27021 | 11 | 2 |
238326 | 238326 | 2020-06-14 | Cass | Minnesota | 27021 | 11 | 2 |
241435 | 241435 | 2020-06-15 | Cass | Minnesota | 27021 | 11 | 2 |
244546 | 244546 | 2020-06-16 | Cass | Minnesota | 27021 | 11 | 2 |
247659 | 247659 | 2020-06-17 | Cass | Minnesota | 27021 | 11 | 2 |
250771 | 250771 | 2020-06-18 | Cass | Minnesota | 27021 | 12 | 2 |
253886 | 253886 | 2020-06-19 | Cass | Minnesota | 27021 | 12 | 2 |
257006 | 257006 | 2020-06-20 | Cass | Minnesota | 27021 | 12 | 2 |
260132 | 260132 | 2020-06-21 | Cass | Minnesota | 27021 | 12 | 2 |
263261 | 263261 | 2020-06-22 | Cass | Minnesota | 27021 | 12 | 2 |
266387 | 266387 | 2020-06-23 | Cass | Minnesota | 27021 | 11 | 2 |
269520 | 269520 | 2020-06-24 | Cass | Minnesota | 27021 | 11 | 2 |
272657 | 272657 | 2020-06-25 | Cass | Minnesota | 27021 | 11 | 2 |
275800 | 275800 | 2020-06-26 | Cass | Minnesota | 27021 | 11 | 2 |
278948 | 278948 | 2020-06-27 | Cass | Minnesota | 27021 | 11 | 2 |
282096 | 282096 | 2020-06-28 | Cass | Minnesota | 27021 | 12 | 2 |
285241 | 285241 | 2020-06-29 | Cass | Minnesota | 27021 | 12 | 2 |
288391 | 288391 | 2020-06-30 | Cass | Minnesota | 27021 | 13 | 2 |
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);