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 rowid
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 |
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 |
173689 | 173689 | 2020-05-24 | Carver | Minnesota | 27019 | 161 | 2 |
176732 | 176732 | 2020-05-25 | Carver | Minnesota | 27019 | 174 | 2 |
179776 | 179776 | 2020-05-26 | Carver | Minnesota | 27019 | 182 | 2 |
182822 | 182822 | 2020-05-27 | Carver | Minnesota | 27019 | 185 | 2 |
185877 | 185877 | 2020-05-28 | Carver | Minnesota | 27019 | 189 | 2 |
188935 | 188935 | 2020-05-29 | Carver | Minnesota | 27019 | 201 | 2 |
191999 | 191999 | 2020-05-30 | Carver | Minnesota | 27019 | 206 | 2 |
195067 | 195067 | 2020-05-31 | Carver | Minnesota | 27019 | 210 | 2 |
198138 | 198138 | 2020-06-01 | Carver | Minnesota | 27019 | 218 | 2 |
201211 | 201211 | 2020-06-02 | Carver | Minnesota | 27019 | 222 | 2 |
204288 | 204288 | 2020-06-03 | Carver | Minnesota | 27019 | 224 | 2 |
207369 | 207369 | 2020-06-04 | Carver | Minnesota | 27019 | 232 | 2 |
210450 | 210450 | 2020-06-05 | Carver | Minnesota | 27019 | 240 | 2 |
213534 | 213534 | 2020-06-06 | Carver | Minnesota | 27019 | 247 | 2 |
216622 | 216622 | 2020-06-07 | Carver | Minnesota | 27019 | 250 | 2 |
219714 | 219714 | 2020-06-08 | Carver | Minnesota | 27019 | 254 | 2 |
222809 | 222809 | 2020-06-09 | Carver | Minnesota | 27019 | 257 | 2 |
225907 | 225907 | 2020-06-10 | Carver | Minnesota | 27019 | 261 | 2 |
229009 | 229009 | 2020-06-11 | Carver | Minnesota | 27019 | 266 | 2 |
232113 | 232113 | 2020-06-12 | Carver | Minnesota | 27019 | 268 | 2 |
235218 | 235218 | 2020-06-13 | Carver | Minnesota | 27019 | 269 | 2 |
238325 | 238325 | 2020-06-14 | Carver | Minnesota | 27019 | 270 | 2 |
241434 | 241434 | 2020-06-15 | Carver | Minnesota | 27019 | 271 | 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);