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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
809 | 809 | 2020-03-08 | Carver | Minnesota | 27019 | 1 | 0 |
933 | 933 | 2020-03-09 | Carver | Minnesota | 27019 | 1 | 0 |
1083 | 1083 | 2020-03-10 | Carver | Minnesota | 27019 | 1 | 0 |
1263 | 1263 | 2020-03-11 | Carver | Minnesota | 27019 | 1 | 0 |
1486 | 1486 | 2020-03-12 | Carver | Minnesota | 27019 | 1 | 0 |
1769 | 1769 | 2020-03-13 | Carver | Minnesota | 27019 | 1 | 0 |
2113 | 2113 | 2020-03-14 | Carver | Minnesota | 27019 | 1 | 0 |
2517 | 2517 | 2020-03-15 | Carver | Minnesota | 27019 | 1 | 0 |
2969 | 2969 | 2020-03-16 | Carver | Minnesota | 27019 | 1 | 0 |
3472 | 3472 | 2020-03-17 | Carver | Minnesota | 27019 | 1 | 0 |
4055 | 4055 | 2020-03-18 | Carver | Minnesota | 27019 | 2 | 0 |
4765 | 4765 | 2020-03-19 | Carver | Minnesota | 27019 | 3 | 0 |
5584 | 5584 | 2020-03-20 | Carver | Minnesota | 27019 | 3 | 0 |
6552 | 6552 | 2020-03-21 | Carver | Minnesota | 27019 | 3 | 0 |
7633 | 7633 | 2020-03-22 | Carver | Minnesota | 27019 | 8 | 0 |
8810 | 8810 | 2020-03-23 | Carver | Minnesota | 27019 | 8 | 0 |
10105 | 10105 | 2020-03-24 | Carver | Minnesota | 27019 | 8 | 0 |
11522 | 11522 | 2020-03-25 | Carver | Minnesota | 27019 | 8 | 0 |
13110 | 13110 | 2020-03-26 | Carver | Minnesota | 27019 | 8 | 0 |
14823 | 14823 | 2020-03-27 | Carver | Minnesota | 27019 | 8 | 0 |
16644 | 16644 | 2020-03-28 | Carver | Minnesota | 27019 | 9 | 0 |
18560 | 18560 | 2020-03-29 | Carver | Minnesota | 27019 | 9 | 0 |
20580 | 20580 | 2020-03-30 | Carver | Minnesota | 27019 | 10 | 0 |
22694 | 22694 | 2020-03-31 | Carver | Minnesota | 27019 | 10 | 0 |
24874 | 24874 | 2020-04-01 | Carver | Minnesota | 27019 | 10 | 0 |
27127 | 27127 | 2020-04-02 | Carver | Minnesota | 27019 | 10 | 0 |
29446 | 29446 | 2020-04-03 | Carver | Minnesota | 27019 | 11 | 0 |
31824 | 31824 | 2020-04-04 | Carver | Minnesota | 27019 | 10 | 0 |
34249 | 34249 | 2020-04-05 | Carver | Minnesota | 27019 | 10 | 0 |
36709 | 36709 | 2020-04-06 | Carver | Minnesota | 27019 | 10 | 0 |
39218 | 39218 | 2020-04-07 | Carver | Minnesota | 27019 | 10 | 0 |
41771 | 41771 | 2020-04-08 | Carver | Minnesota | 27019 | 10 | 0 |
44347 | 44347 | 2020-04-09 | Carver | Minnesota | 27019 | 10 | 0 |
46956 | 46956 | 2020-04-10 | Carver | Minnesota | 27019 | 12 | 0 |
49601 | 49601 | 2020-04-11 | Carver | Minnesota | 27019 | 12 | 0 |
52271 | 52271 | 2020-04-12 | Carver | Minnesota | 27019 | 13 | 0 |
54953 | 54953 | 2020-04-13 | Carver | Minnesota | 27019 | 13 | 0 |
57651 | 57651 | 2020-04-14 | Carver | Minnesota | 27019 | 13 | 0 |
60361 | 60361 | 2020-04-15 | Carver | Minnesota | 27019 | 14 | 0 |
63083 | 63083 | 2020-04-16 | Carver | Minnesota | 27019 | 14 | 0 |
65822 | 65822 | 2020-04-17 | Carver | Minnesota | 27019 | 14 | 0 |
68573 | 68573 | 2020-04-18 | Carver | Minnesota | 27019 | 14 | 0 |
71337 | 71337 | 2020-04-19 | Carver | Minnesota | 27019 | 14 | 0 |
74109 | 74109 | 2020-04-20 | Carver | Minnesota | 27019 | 14 | 0 |
76889 | 76889 | 2020-04-21 | Carver | Minnesota | 27019 | 14 | 0 |
79674 | 79674 | 2020-04-22 | Carver | Minnesota | 27019 | 15 | 0 |
82470 | 82470 | 2020-04-23 | Carver | Minnesota | 27019 | 15 | 0 |
85274 | 85274 | 2020-04-24 | Carver | Minnesota | 27019 | 15 | 0 |
88084 | 88084 | 2020-04-25 | Carver | Minnesota | 27019 | 16 | 0 |
90900 | 90900 | 2020-04-26 | Carver | Minnesota | 27019 | 17 | 0 |
93721 | 93721 | 2020-04-27 | Carver | Minnesota | 27019 | 17 | 0 |
96556 | 96556 | 2020-04-28 | Carver | Minnesota | 27019 | 19 | 0 |
99402 | 99402 | 2020-04-29 | Carver | Minnesota | 27019 | 20 | 0 |
102254 | 102254 | 2020-04-30 | Carver | Minnesota | 27019 | 21 | 0 |
105114 | 105114 | 2020-05-01 | Carver | Minnesota | 27019 | 21 | 0 |
107978 | 107978 | 2020-05-02 | Carver | Minnesota | 27019 | 25 | 0 |
110849 | 110849 | 2020-05-03 | Carver | Minnesota | 27019 | 26 | 0 |
113728 | 113728 | 2020-05-04 | Carver | Minnesota | 27019 | 27 | 0 |
116609 | 116609 | 2020-05-05 | Carver | Minnesota | 27019 | 39 | 0 |
119569 | 119569 | 2020-05-06 | Carver | Minnesota | 27019 | 51 | 0 |
122542 | 122542 | 2020-05-07 | Carver | Minnesota | 27019 | 58 | 0 |
125524 | 125524 | 2020-05-08 | Carver | Minnesota | 27019 | 69 | 0 |
128511 | 128511 | 2020-05-09 | Carver | Minnesota | 27019 | 78 | 1 |
131501 | 131501 | 2020-05-10 | Carver | Minnesota | 27019 | 82 | 1 |
134492 | 134492 | 2020-05-11 | Carver | Minnesota | 27019 | 92 | 1 |
137482 | 137482 | 2020-05-12 | Carver | Minnesota | 27019 | 95 | 1 |
140476 | 140476 | 2020-05-13 | Carver | Minnesota | 27019 | 95 | 1 |
143471 | 143471 | 2020-05-14 | Carver | Minnesota | 27019 | 103 | 1 |
253885 | 253885 | 2020-06-19 | Carver | Minnesota | 27019 | 287 | 1 |
257005 | 257005 | 2020-06-20 | Carver | Minnesota | 27019 | 293 | 1 |
260131 | 260131 | 2020-06-21 | Carver | Minnesota | 27019 | 294 | 1 |
263260 | 263260 | 2020-06-22 | Carver | Minnesota | 27019 | 297 | 1 |
266386 | 266386 | 2020-06-23 | Carver | Minnesota | 27019 | 299 | 1 |
269519 | 269519 | 2020-06-24 | Carver | Minnesota | 27019 | 305 | 1 |
272656 | 272656 | 2020-06-25 | Carver | Minnesota | 27019 | 308 | 1 |
275799 | 275799 | 2020-06-26 | Carver | Minnesota | 27019 | 316 | 1 |
278947 | 278947 | 2020-06-27 | Carver | Minnesota | 27019 | 323 | 1 |
282095 | 282095 | 2020-06-28 | Carver | Minnesota | 27019 | 333 | 1 |
285240 | 285240 | 2020-06-29 | Carver | Minnesota | 27019 | 338 | 1 |
288390 | 288390 | 2020-06-30 | Carver | Minnesota | 27019 | 340 | 1 |
291541 | 291541 | 2020-07-01 | Carver | Minnesota | 27019 | 348 | 1 |
294695 | 294695 | 2020-07-02 | Carver | Minnesota | 27019 | 361 | 1 |
297853 | 297853 | 2020-07-03 | Carver | Minnesota | 27019 | 364 | 1 |
301016 | 301016 | 2020-07-04 | Carver | Minnesota | 27019 | 364 | 1 |
304180 | 304180 | 2020-07-05 | Carver | Minnesota | 27019 | 376 | 1 |
307347 | 307347 | 2020-07-06 | Carver | Minnesota | 27019 | 381 | 1 |
310515 | 310515 | 2020-07-07 | Carver | Minnesota | 27019 | 395 | 1 |
313685 | 313685 | 2020-07-08 | Carver | Minnesota | 27019 | 417 | 1 |
316859 | 316859 | 2020-07-09 | Carver | Minnesota | 27019 | 433 | 1 |
320034 | 320034 | 2020-07-10 | Carver | Minnesota | 27019 | 442 | 1 |
323213 | 323213 | 2020-07-11 | Carver | Minnesota | 27019 | 469 | 1 |
146471 | 146471 | 2020-05-15 | Carver | Minnesota | 27019 | 105 | 2 |
149476 | 149476 | 2020-05-16 | Carver | Minnesota | 27019 | 111 | 2 |
152487 | 152487 | 2020-05-17 | Carver | Minnesota | 27019 | 113 | 2 |
155501 | 155501 | 2020-05-18 | Carver | Minnesota | 27019 | 117 | 2 |
158519 | 158519 | 2020-05-19 | Carver | Minnesota | 27019 | 128 | 2 |
161545 | 161545 | 2020-05-20 | Carver | Minnesota | 27019 | 131 | 2 |
164574 | 164574 | 2020-05-21 | Carver | Minnesota | 27019 | 138 | 2 |
167610 | 167610 | 2020-05-22 | Carver | Minnesota | 27019 | 146 | 2 |
170647 | 170647 | 2020-05-23 | Carver | Minnesota | 27019 | 154 | 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);