ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 27019 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
320034 | 320034 | 2020-07-10 | Carver | Minnesota | 27019 | 442 | 1 |
316859 | 316859 | 2020-07-09 | Carver | Minnesota | 27019 | 433 | 1 |
313685 | 313685 | 2020-07-08 | Carver | Minnesota | 27019 | 417 | 1 |
310515 | 310515 | 2020-07-07 | Carver | Minnesota | 27019 | 395 | 1 |
307347 | 307347 | 2020-07-06 | Carver | Minnesota | 27019 | 381 | 1 |
304180 | 304180 | 2020-07-05 | Carver | Minnesota | 27019 | 376 | 1 |
301016 | 301016 | 2020-07-04 | Carver | Minnesota | 27019 | 364 | 1 |
297853 | 297853 | 2020-07-03 | Carver | Minnesota | 27019 | 364 | 1 |
294695 | 294695 | 2020-07-02 | Carver | Minnesota | 27019 | 361 | 1 |
291541 | 291541 | 2020-07-01 | Carver | Minnesota | 27019 | 348 | 1 |
288390 | 288390 | 2020-06-30 | Carver | Minnesota | 27019 | 340 | 1 |
285240 | 285240 | 2020-06-29 | Carver | Minnesota | 27019 | 338 | 1 |
282095 | 282095 | 2020-06-28 | Carver | Minnesota | 27019 | 333 | 1 |
278947 | 278947 | 2020-06-27 | Carver | Minnesota | 27019 | 323 | 1 |
275799 | 275799 | 2020-06-26 | Carver | Minnesota | 27019 | 316 | 1 |
272656 | 272656 | 2020-06-25 | Carver | Minnesota | 27019 | 308 | 1 |
269519 | 269519 | 2020-06-24 | Carver | Minnesota | 27019 | 305 | 1 |
266386 | 266386 | 2020-06-23 | Carver | Minnesota | 27019 | 299 | 1 |
263260 | 263260 | 2020-06-22 | Carver | Minnesota | 27019 | 297 | 1 |
260131 | 260131 | 2020-06-21 | Carver | Minnesota | 27019 | 294 | 1 |
257005 | 257005 | 2020-06-20 | Carver | Minnesota | 27019 | 293 | 1 |
253885 | 253885 | 2020-06-19 | Carver | Minnesota | 27019 | 287 | 1 |
250770 | 250770 | 2020-06-18 | Carver | Minnesota | 27019 | 285 | 2 |
247658 | 247658 | 2020-06-17 | Carver | Minnesota | 27019 | 278 | 2 |
244545 | 244545 | 2020-06-16 | Carver | Minnesota | 27019 | 276 | 2 |
241434 | 241434 | 2020-06-15 | Carver | Minnesota | 27019 | 271 | 2 |
238325 | 238325 | 2020-06-14 | Carver | Minnesota | 27019 | 270 | 2 |
235218 | 235218 | 2020-06-13 | Carver | Minnesota | 27019 | 269 | 2 |
232113 | 232113 | 2020-06-12 | Carver | Minnesota | 27019 | 268 | 2 |
229009 | 229009 | 2020-06-11 | Carver | Minnesota | 27019 | 266 | 2 |
225907 | 225907 | 2020-06-10 | Carver | Minnesota | 27019 | 261 | 2 |
222809 | 222809 | 2020-06-09 | Carver | Minnesota | 27019 | 257 | 2 |
219714 | 219714 | 2020-06-08 | Carver | Minnesota | 27019 | 254 | 2 |
216622 | 216622 | 2020-06-07 | Carver | Minnesota | 27019 | 250 | 2 |
213534 | 213534 | 2020-06-06 | Carver | Minnesota | 27019 | 247 | 2 |
210450 | 210450 | 2020-06-05 | Carver | Minnesota | 27019 | 240 | 2 |
207369 | 207369 | 2020-06-04 | Carver | Minnesota | 27019 | 232 | 2 |
204288 | 204288 | 2020-06-03 | Carver | Minnesota | 27019 | 224 | 2 |
201211 | 201211 | 2020-06-02 | Carver | Minnesota | 27019 | 222 | 2 |
198138 | 198138 | 2020-06-01 | Carver | Minnesota | 27019 | 218 | 2 |
195067 | 195067 | 2020-05-31 | Carver | Minnesota | 27019 | 210 | 2 |
191999 | 191999 | 2020-05-30 | Carver | Minnesota | 27019 | 206 | 2 |
188935 | 188935 | 2020-05-29 | Carver | Minnesota | 27019 | 201 | 2 |
185877 | 185877 | 2020-05-28 | Carver | Minnesota | 27019 | 189 | 2 |
182822 | 182822 | 2020-05-27 | Carver | Minnesota | 27019 | 185 | 2 |
179776 | 179776 | 2020-05-26 | Carver | Minnesota | 27019 | 182 | 2 |
176732 | 176732 | 2020-05-25 | Carver | Minnesota | 27019 | 174 | 2 |
173689 | 173689 | 2020-05-24 | Carver | Minnesota | 27019 | 161 | 2 |
170647 | 170647 | 2020-05-23 | Carver | Minnesota | 27019 | 154 | 2 |
167610 | 167610 | 2020-05-22 | Carver | Minnesota | 27019 | 146 | 2 |
164574 | 164574 | 2020-05-21 | Carver | Minnesota | 27019 | 138 | 2 |
161545 | 161545 | 2020-05-20 | Carver | Minnesota | 27019 | 131 | 2 |
158519 | 158519 | 2020-05-19 | Carver | Minnesota | 27019 | 128 | 2 |
155501 | 155501 | 2020-05-18 | Carver | Minnesota | 27019 | 117 | 2 |
152487 | 152487 | 2020-05-17 | Carver | Minnesota | 27019 | 113 | 2 |
149476 | 149476 | 2020-05-16 | Carver | Minnesota | 27019 | 111 | 2 |
146471 | 146471 | 2020-05-15 | Carver | Minnesota | 27019 | 105 | 2 |
143471 | 143471 | 2020-05-14 | Carver | Minnesota | 27019 | 103 | 1 |
140476 | 140476 | 2020-05-13 | Carver | Minnesota | 27019 | 95 | 1 |
137482 | 137482 | 2020-05-12 | Carver | Minnesota | 27019 | 95 | 1 |
134492 | 134492 | 2020-05-11 | Carver | Minnesota | 27019 | 92 | 1 |
131501 | 131501 | 2020-05-10 | Carver | Minnesota | 27019 | 82 | 1 |
128511 | 128511 | 2020-05-09 | Carver | Minnesota | 27019 | 78 | 1 |
125524 | 125524 | 2020-05-08 | Carver | Minnesota | 27019 | 69 | 0 |
122542 | 122542 | 2020-05-07 | Carver | Minnesota | 27019 | 58 | 0 |
119569 | 119569 | 2020-05-06 | Carver | Minnesota | 27019 | 51 | 0 |
116609 | 116609 | 2020-05-05 | Carver | Minnesota | 27019 | 39 | 0 |
113728 | 113728 | 2020-05-04 | Carver | Minnesota | 27019 | 27 | 0 |
110849 | 110849 | 2020-05-03 | Carver | Minnesota | 27019 | 26 | 0 |
107978 | 107978 | 2020-05-02 | Carver | Minnesota | 27019 | 25 | 0 |
105114 | 105114 | 2020-05-01 | Carver | Minnesota | 27019 | 21 | 0 |
102254 | 102254 | 2020-04-30 | Carver | Minnesota | 27019 | 21 | 0 |
99402 | 99402 | 2020-04-29 | Carver | Minnesota | 27019 | 20 | 0 |
96556 | 96556 | 2020-04-28 | Carver | Minnesota | 27019 | 19 | 0 |
93721 | 93721 | 2020-04-27 | Carver | Minnesota | 27019 | 17 | 0 |
90900 | 90900 | 2020-04-26 | Carver | Minnesota | 27019 | 17 | 0 |
88084 | 88084 | 2020-04-25 | Carver | Minnesota | 27019 | 16 | 0 |
85274 | 85274 | 2020-04-24 | Carver | Minnesota | 27019 | 15 | 0 |
82470 | 82470 | 2020-04-23 | Carver | Minnesota | 27019 | 15 | 0 |
79674 | 79674 | 2020-04-22 | Carver | Minnesota | 27019 | 15 | 0 |
76889 | 76889 | 2020-04-21 | Carver | Minnesota | 27019 | 14 | 0 |
74109 | 74109 | 2020-04-20 | Carver | Minnesota | 27019 | 14 | 0 |
71337 | 71337 | 2020-04-19 | Carver | Minnesota | 27019 | 14 | 0 |
68573 | 68573 | 2020-04-18 | Carver | Minnesota | 27019 | 14 | 0 |
65822 | 65822 | 2020-04-17 | Carver | Minnesota | 27019 | 14 | 0 |
63083 | 63083 | 2020-04-16 | Carver | Minnesota | 27019 | 14 | 0 |
60361 | 60361 | 2020-04-15 | Carver | Minnesota | 27019 | 14 | 0 |
57651 | 57651 | 2020-04-14 | Carver | Minnesota | 27019 | 13 | 0 |
54953 | 54953 | 2020-04-13 | Carver | Minnesota | 27019 | 13 | 0 |
52271 | 52271 | 2020-04-12 | Carver | Minnesota | 27019 | 13 | 0 |
49601 | 49601 | 2020-04-11 | Carver | Minnesota | 27019 | 12 | 0 |
46956 | 46956 | 2020-04-10 | Carver | Minnesota | 27019 | 12 | 0 |
44347 | 44347 | 2020-04-09 | Carver | Minnesota | 27019 | 10 | 0 |
41771 | 41771 | 2020-04-08 | Carver | Minnesota | 27019 | 10 | 0 |
39218 | 39218 | 2020-04-07 | Carver | Minnesota | 27019 | 10 | 0 |
36709 | 36709 | 2020-04-06 | Carver | Minnesota | 27019 | 10 | 0 |
34249 | 34249 | 2020-04-05 | Carver | Minnesota | 27019 | 10 | 0 |
31824 | 31824 | 2020-04-04 | Carver | Minnesota | 27019 | 10 | 0 |
29446 | 29446 | 2020-04-03 | Carver | Minnesota | 27019 | 11 | 0 |
27127 | 27127 | 2020-04-02 | Carver | Minnesota | 27019 | 10 | 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);