ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 27003 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 ▼ |
---|---|---|---|---|---|---|---|
1082 | 1082 | 2020-03-10 | Anoka | Minnesota | 27003 | 1 | 0 |
1262 | 1262 | 2020-03-11 | Anoka | Minnesota | 27003 | 1 | 0 |
1485 | 1485 | 2020-03-12 | Anoka | Minnesota | 27003 | 1 | 0 |
1768 | 1768 | 2020-03-13 | Anoka | Minnesota | 27003 | 1 | 0 |
2112 | 2112 | 2020-03-14 | Anoka | Minnesota | 27003 | 2 | 0 |
2516 | 2516 | 2020-03-15 | Anoka | Minnesota | 27003 | 2 | 0 |
2966 | 2966 | 2020-03-16 | Anoka | Minnesota | 27003 | 3 | 0 |
3469 | 3469 | 2020-03-17 | Anoka | Minnesota | 27003 | 3 | 0 |
4052 | 4052 | 2020-03-18 | Anoka | Minnesota | 27003 | 3 | 0 |
4762 | 4762 | 2020-03-19 | Anoka | Minnesota | 27003 | 5 | 0 |
5581 | 5581 | 2020-03-20 | Anoka | Minnesota | 27003 | 5 | 0 |
6549 | 6549 | 2020-03-21 | Anoka | Minnesota | 27003 | 5 | 0 |
7630 | 7630 | 2020-03-22 | Anoka | Minnesota | 27003 | 5 | 0 |
8806 | 8806 | 2020-03-23 | Anoka | Minnesota | 27003 | 7 | 0 |
10101 | 10101 | 2020-03-24 | Anoka | Minnesota | 27003 | 7 | 0 |
11518 | 11518 | 2020-03-25 | Anoka | Minnesota | 27003 | 7 | 0 |
13106 | 13106 | 2020-03-26 | Anoka | Minnesota | 27003 | 8 | 0 |
14818 | 14818 | 2020-03-27 | Anoka | Minnesota | 27003 | 10 | 0 |
16639 | 16639 | 2020-03-28 | Anoka | Minnesota | 27003 | 12 | 0 |
18555 | 18555 | 2020-03-29 | Anoka | Minnesota | 27003 | 17 | 0 |
20575 | 20575 | 2020-03-30 | Anoka | Minnesota | 27003 | 22 | 0 |
22687 | 22687 | 2020-03-31 | Anoka | Minnesota | 27003 | 23 | 0 |
24867 | 24867 | 2020-04-01 | Anoka | Minnesota | 27003 | 26 | 0 |
27120 | 27120 | 2020-04-02 | Anoka | Minnesota | 27003 | 30 | 0 |
29439 | 29439 | 2020-04-03 | Anoka | Minnesota | 27003 | 34 | 0 |
31817 | 31817 | 2020-04-04 | Anoka | Minnesota | 27003 | 36 | 0 |
34242 | 34242 | 2020-04-05 | Anoka | Minnesota | 27003 | 36 | 0 |
36702 | 36702 | 2020-04-06 | Anoka | Minnesota | 27003 | 40 | 0 |
39211 | 39211 | 2020-04-07 | Anoka | Minnesota | 27003 | 42 | 0 |
41764 | 41764 | 2020-04-08 | Anoka | Minnesota | 27003 | 46 | 0 |
44340 | 44340 | 2020-04-09 | Anoka | Minnesota | 27003 | 53 | 0 |
46949 | 46949 | 2020-04-10 | Anoka | Minnesota | 27003 | 55 | 0 |
49593 | 49593 | 2020-04-11 | Anoka | Minnesota | 27003 | 58 | 0 |
52263 | 52263 | 2020-04-12 | Anoka | Minnesota | 27003 | 68 | 0 |
54945 | 54945 | 2020-04-13 | Anoka | Minnesota | 27003 | 68 | 0 |
57643 | 57643 | 2020-04-14 | Anoka | Minnesota | 27003 | 72 | 0 |
60353 | 60353 | 2020-04-15 | Anoka | Minnesota | 27003 | 76 | 0 |
63075 | 63075 | 2020-04-16 | Anoka | Minnesota | 27003 | 79 | 0 |
65814 | 65814 | 2020-04-17 | Anoka | Minnesota | 27003 | 83 | 1 |
68565 | 68565 | 2020-04-18 | Anoka | Minnesota | 27003 | 85 | 2 |
71329 | 71329 | 2020-04-19 | Anoka | Minnesota | 27003 | 93 | 2 |
74101 | 74101 | 2020-04-20 | Anoka | Minnesota | 27003 | 95 | 2 |
76881 | 76881 | 2020-04-21 | Anoka | Minnesota | 27003 | 97 | 2 |
79666 | 79666 | 2020-04-22 | Anoka | Minnesota | 27003 | 105 | 2 |
82462 | 82462 | 2020-04-23 | Anoka | Minnesota | 27003 | 131 | 2 |
85266 | 85266 | 2020-04-24 | Anoka | Minnesota | 27003 | 142 | 3 |
88076 | 88076 | 2020-04-25 | Anoka | Minnesota | 27003 | 150 | 3 |
90892 | 90892 | 2020-04-26 | Anoka | Minnesota | 27003 | 165 | 5 |
93713 | 93713 | 2020-04-27 | Anoka | Minnesota | 27003 | 168 | 5 |
96548 | 96548 | 2020-04-28 | Anoka | Minnesota | 27003 | 186 | 8 |
99394 | 99394 | 2020-04-29 | Anoka | Minnesota | 27003 | 196 | 8 |
102246 | 102246 | 2020-04-30 | Anoka | Minnesota | 27003 | 212 | 10 |
105106 | 105106 | 2020-05-01 | Anoka | Minnesota | 27003 | 231 | 11 |
107970 | 107970 | 2020-05-02 | Anoka | Minnesota | 27003 | 260 | 14 |
110841 | 110841 | 2020-05-03 | Anoka | Minnesota | 27003 | 281 | 17 |
113720 | 113720 | 2020-05-04 | Anoka | Minnesota | 27003 | 299 | 17 |
116601 | 116601 | 2020-05-05 | Anoka | Minnesota | 27003 | 344 | 20 |
119561 | 119561 | 2020-05-06 | Anoka | Minnesota | 27003 | 382 | 24 |
122534 | 122534 | 2020-05-07 | Anoka | Minnesota | 27003 | 426 | 27 |
125516 | 125516 | 2020-05-08 | Anoka | Minnesota | 27003 | 477 | 27 |
128503 | 128503 | 2020-05-09 | Anoka | Minnesota | 27003 | 518 | 29 |
131493 | 131493 | 2020-05-10 | Anoka | Minnesota | 27003 | 549 | 29 |
134484 | 134484 | 2020-05-11 | Anoka | Minnesota | 27003 | 571 | 29 |
137474 | 137474 | 2020-05-12 | Anoka | Minnesota | 27003 | 613 | 31 |
140468 | 140468 | 2020-05-13 | Anoka | Minnesota | 27003 | 613 | 31 |
143463 | 143463 | 2020-05-14 | Anoka | Minnesota | 27003 | 678 | 35 |
146463 | 146463 | 2020-05-15 | Anoka | Minnesota | 27003 | 726 | 38 |
149468 | 149468 | 2020-05-16 | Anoka | Minnesota | 27003 | 770 | 40 |
152479 | 152479 | 2020-05-17 | Anoka | Minnesota | 27003 | 821 | 40 |
155493 | 155493 | 2020-05-18 | Anoka | Minnesota | 27003 | 869 | 42 |
158511 | 158511 | 2020-05-19 | Anoka | Minnesota | 27003 | 919 | 42 |
161537 | 161537 | 2020-05-20 | Anoka | Minnesota | 27003 | 955 | 45 |
164566 | 164566 | 2020-05-21 | Anoka | Minnesota | 27003 | 995 | 49 |
167602 | 167602 | 2020-05-22 | Anoka | Minnesota | 27003 | 1044 | 53 |
170639 | 170639 | 2020-05-23 | Anoka | Minnesota | 27003 | 1092 | 55 |
173681 | 173681 | 2020-05-24 | Anoka | Minnesota | 27003 | 1164 | 55 |
176724 | 176724 | 2020-05-25 | Anoka | Minnesota | 27003 | 1210 | 56 |
179768 | 179768 | 2020-05-26 | Anoka | Minnesota | 27003 | 1241 | 56 |
182814 | 182814 | 2020-05-27 | Anoka | Minnesota | 27003 | 1262 | 59 |
185869 | 185869 | 2020-05-28 | Anoka | Minnesota | 27003 | 1289 | 63 |
188927 | 188927 | 2020-05-29 | Anoka | Minnesota | 27003 | 1324 | 67 |
191991 | 191991 | 2020-05-30 | Anoka | Minnesota | 27003 | 1363 | 70 |
195059 | 195059 | 2020-05-31 | Anoka | Minnesota | 27003 | 1399 | 70 |
198130 | 198130 | 2020-06-01 | Anoka | Minnesota | 27003 | 1429 | 70 |
201203 | 201203 | 2020-06-02 | Anoka | Minnesota | 27003 | 1441 | 71 |
204280 | 204280 | 2020-06-03 | Anoka | Minnesota | 27003 | 1470 | 73 |
207361 | 207361 | 2020-06-04 | Anoka | Minnesota | 27003 | 1488 | 78 |
210442 | 210442 | 2020-06-05 | Anoka | Minnesota | 27003 | 1527 | 79 |
213526 | 213526 | 2020-06-06 | Anoka | Minnesota | 27003 | 1555 | 81 |
216614 | 216614 | 2020-06-07 | Anoka | Minnesota | 27003 | 1585 | 82 |
219706 | 219706 | 2020-06-08 | Anoka | Minnesota | 27003 | 1616 | 84 |
222801 | 222801 | 2020-06-09 | Anoka | Minnesota | 27003 | 1627 | 85 |
225899 | 225899 | 2020-06-10 | Anoka | Minnesota | 27003 | 1654 | 87 |
229001 | 229001 | 2020-06-11 | Anoka | Minnesota | 27003 | 1674 | 88 |
232105 | 232105 | 2020-06-12 | Anoka | Minnesota | 27003 | 1691 | 88 |
235210 | 235210 | 2020-06-13 | Anoka | Minnesota | 27003 | 1716 | 88 |
238317 | 238317 | 2020-06-14 | Anoka | Minnesota | 27003 | 1742 | 88 |
241426 | 241426 | 2020-06-15 | Anoka | Minnesota | 27003 | 1760 | 90 |
244537 | 244537 | 2020-06-16 | Anoka | Minnesota | 27003 | 1770 | 90 |
247650 | 247650 | 2020-06-17 | Anoka | Minnesota | 27003 | 1786 | 91 |
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);