ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 27049 and state = "Minnesota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11529 | 11529 | 2020-03-25 | Goodhue | Minnesota | 27049 | 1 | 0 |
13117 | 13117 | 2020-03-26 | Goodhue | Minnesota | 27049 | 1 | 0 |
14831 | 14831 | 2020-03-27 | Goodhue | Minnesota | 27049 | 2 | 0 |
16653 | 16653 | 2020-03-28 | Goodhue | Minnesota | 27049 | 2 | 0 |
18571 | 18571 | 2020-03-29 | Goodhue | Minnesota | 27049 | 2 | 0 |
20591 | 20591 | 2020-03-30 | Goodhue | Minnesota | 27049 | 3 | 0 |
22705 | 22705 | 2020-03-31 | Goodhue | Minnesota | 27049 | 3 | 0 |
24887 | 24887 | 2020-04-01 | Goodhue | Minnesota | 27049 | 4 | 0 |
27140 | 27140 | 2020-04-02 | Goodhue | Minnesota | 27049 | 4 | 0 |
29459 | 29459 | 2020-04-03 | Goodhue | Minnesota | 27049 | 5 | 0 |
31837 | 31837 | 2020-04-04 | Goodhue | Minnesota | 27049 | 8 | 0 |
34262 | 34262 | 2020-04-05 | Goodhue | Minnesota | 27049 | 10 | 0 |
36722 | 36722 | 2020-04-06 | Goodhue | Minnesota | 27049 | 10 | 0 |
39231 | 39231 | 2020-04-07 | Goodhue | Minnesota | 27049 | 12 | 0 |
41784 | 41784 | 2020-04-08 | Goodhue | Minnesota | 27049 | 13 | 0 |
44360 | 44360 | 2020-04-09 | Goodhue | Minnesota | 27049 | 14 | 0 |
46969 | 46969 | 2020-04-10 | Goodhue | Minnesota | 27049 | 14 | 0 |
49614 | 49614 | 2020-04-11 | Goodhue | Minnesota | 27049 | 16 | 0 |
52284 | 52284 | 2020-04-12 | Goodhue | Minnesota | 27049 | 17 | 0 |
54966 | 54966 | 2020-04-13 | Goodhue | Minnesota | 27049 | 17 | 0 |
57664 | 57664 | 2020-04-14 | Goodhue | Minnesota | 27049 | 17 | 0 |
60374 | 60374 | 2020-04-15 | Goodhue | Minnesota | 27049 | 17 | 0 |
63096 | 63096 | 2020-04-16 | Goodhue | Minnesota | 27049 | 17 | 0 |
65835 | 65835 | 2020-04-17 | Goodhue | Minnesota | 27049 | 18 | 0 |
68586 | 68586 | 2020-04-18 | Goodhue | Minnesota | 27049 | 19 | 0 |
71350 | 71350 | 2020-04-19 | Goodhue | Minnesota | 27049 | 19 | 0 |
74123 | 74123 | 2020-04-20 | Goodhue | Minnesota | 27049 | 19 | 0 |
76903 | 76903 | 2020-04-21 | Goodhue | Minnesota | 27049 | 19 | 0 |
79688 | 79688 | 2020-04-22 | Goodhue | Minnesota | 27049 | 19 | 0 |
82484 | 82484 | 2020-04-23 | Goodhue | Minnesota | 27049 | 19 | 0 |
85288 | 85288 | 2020-04-24 | Goodhue | Minnesota | 27049 | 19 | 0 |
88098 | 88098 | 2020-04-25 | Goodhue | Minnesota | 27049 | 19 | 0 |
90914 | 90914 | 2020-04-26 | Goodhue | Minnesota | 27049 | 19 | 0 |
93735 | 93735 | 2020-04-27 | Goodhue | Minnesota | 27049 | 19 | 0 |
96570 | 96570 | 2020-04-28 | Goodhue | Minnesota | 27049 | 19 | 0 |
99416 | 99416 | 2020-04-29 | Goodhue | Minnesota | 27049 | 19 | 0 |
102268 | 102268 | 2020-04-30 | Goodhue | Minnesota | 27049 | 19 | 0 |
105128 | 105128 | 2020-05-01 | Goodhue | Minnesota | 27049 | 19 | 0 |
107992 | 107992 | 2020-05-02 | Goodhue | Minnesota | 27049 | 21 | 0 |
110863 | 110863 | 2020-05-03 | Goodhue | Minnesota | 27049 | 21 | 0 |
113742 | 113742 | 2020-05-04 | Goodhue | Minnesota | 27049 | 23 | 0 |
116623 | 116623 | 2020-05-05 | Goodhue | Minnesota | 27049 | 23 | 0 |
119583 | 119583 | 2020-05-06 | Goodhue | Minnesota | 27049 | 23 | 0 |
122556 | 122556 | 2020-05-07 | Goodhue | Minnesota | 27049 | 25 | 0 |
125538 | 125538 | 2020-05-08 | Goodhue | Minnesota | 27049 | 25 | 0 |
128525 | 128525 | 2020-05-09 | Goodhue | Minnesota | 27049 | 25 | 0 |
131515 | 131515 | 2020-05-10 | Goodhue | Minnesota | 27049 | 25 | 0 |
134506 | 134506 | 2020-05-11 | Goodhue | Minnesota | 27049 | 25 | 0 |
137496 | 137496 | 2020-05-12 | Goodhue | Minnesota | 27049 | 26 | 0 |
140490 | 140490 | 2020-05-13 | Goodhue | Minnesota | 27049 | 26 | 0 |
143485 | 143485 | 2020-05-14 | Goodhue | Minnesota | 27049 | 29 | 0 |
146485 | 146485 | 2020-05-15 | Goodhue | Minnesota | 27049 | 29 | 0 |
149490 | 149490 | 2020-05-16 | Goodhue | Minnesota | 27049 | 32 | 0 |
152501 | 152501 | 2020-05-17 | Goodhue | Minnesota | 27049 | 33 | 0 |
155515 | 155515 | 2020-05-18 | Goodhue | Minnesota | 27049 | 34 | 0 |
158533 | 158533 | 2020-05-19 | Goodhue | Minnesota | 27049 | 36 | 0 |
161559 | 161559 | 2020-05-20 | Goodhue | Minnesota | 27049 | 38 | 0 |
164588 | 164588 | 2020-05-21 | Goodhue | Minnesota | 27049 | 40 | 1 |
167624 | 167624 | 2020-05-22 | Goodhue | Minnesota | 27049 | 43 | 2 |
170661 | 170661 | 2020-05-23 | Goodhue | Minnesota | 27049 | 50 | 2 |
173703 | 173703 | 2020-05-24 | Goodhue | Minnesota | 27049 | 52 | 2 |
176746 | 176746 | 2020-05-25 | Goodhue | Minnesota | 27049 | 55 | 2 |
179790 | 179790 | 2020-05-26 | Goodhue | Minnesota | 27049 | 58 | 3 |
182836 | 182836 | 2020-05-27 | Goodhue | Minnesota | 27049 | 60 | 3 |
185891 | 185891 | 2020-05-28 | Goodhue | Minnesota | 27049 | 60 | 3 |
188949 | 188949 | 2020-05-29 | Goodhue | Minnesota | 27049 | 62 | 3 |
192013 | 192013 | 2020-05-30 | Goodhue | Minnesota | 27049 | 66 | 3 |
195081 | 195081 | 2020-05-31 | Goodhue | Minnesota | 27049 | 66 | 3 |
198152 | 198152 | 2020-06-01 | Goodhue | Minnesota | 27049 | 68 | 3 |
201225 | 201225 | 2020-06-02 | Goodhue | Minnesota | 27049 | 69 | 3 |
204302 | 204302 | 2020-06-03 | Goodhue | Minnesota | 27049 | 70 | 4 |
207383 | 207383 | 2020-06-04 | Goodhue | Minnesota | 27049 | 71 | 5 |
210464 | 210464 | 2020-06-05 | Goodhue | Minnesota | 27049 | 73 | 6 |
213548 | 213548 | 2020-06-06 | Goodhue | Minnesota | 27049 | 76 | 7 |
216636 | 216636 | 2020-06-07 | Goodhue | Minnesota | 27049 | 77 | 7 |
219728 | 219728 | 2020-06-08 | Goodhue | Minnesota | 27049 | 79 | 7 |
222823 | 222823 | 2020-06-09 | Goodhue | Minnesota | 27049 | 83 | 7 |
225921 | 225921 | 2020-06-10 | Goodhue | Minnesota | 27049 | 86 | 7 |
229023 | 229023 | 2020-06-11 | Goodhue | Minnesota | 27049 | 86 | 7 |
232127 | 232127 | 2020-06-12 | Goodhue | Minnesota | 27049 | 92 | 7 |
235233 | 235233 | 2020-06-13 | Goodhue | Minnesota | 27049 | 93 | 7 |
238340 | 238340 | 2020-06-14 | Goodhue | Minnesota | 27049 | 94 | 7 |
241449 | 241449 | 2020-06-15 | Goodhue | Minnesota | 27049 | 94 | 7 |
244560 | 244560 | 2020-06-16 | Goodhue | Minnesota | 27049 | 94 | 7 |
247673 | 247673 | 2020-06-17 | Goodhue | Minnesota | 27049 | 97 | 7 |
250785 | 250785 | 2020-06-18 | Goodhue | Minnesota | 27049 | 98 | 7 |
253900 | 253900 | 2020-06-19 | Goodhue | Minnesota | 27049 | 101 | 7 |
257020 | 257020 | 2020-06-20 | Goodhue | Minnesota | 27049 | 102 | 7 |
260146 | 260146 | 2020-06-21 | Goodhue | Minnesota | 27049 | 105 | 7 |
263275 | 263275 | 2020-06-22 | Goodhue | Minnesota | 27049 | 107 | 7 |
266401 | 266401 | 2020-06-23 | Goodhue | Minnesota | 27049 | 108 | 8 |
269534 | 269534 | 2020-06-24 | Goodhue | Minnesota | 27049 | 109 | 8 |
272671 | 272671 | 2020-06-25 | Goodhue | Minnesota | 27049 | 109 | 8 |
275814 | 275814 | 2020-06-26 | Goodhue | Minnesota | 27049 | 111 | 8 |
278962 | 278962 | 2020-06-27 | Goodhue | Minnesota | 27049 | 113 | 8 |
282110 | 282110 | 2020-06-28 | Goodhue | Minnesota | 27049 | 117 | 8 |
285255 | 285255 | 2020-06-29 | Goodhue | Minnesota | 27049 | 117 | 8 |
288405 | 288405 | 2020-06-30 | Goodhue | Minnesota | 27049 | 119 | 8 |
291556 | 291556 | 2020-07-01 | Goodhue | Minnesota | 27049 | 124 | 8 |
294710 | 294710 | 2020-07-02 | Goodhue | Minnesota | 27049 | 127 | 8 |
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);