ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where fips = 27133 and state = "Minnesota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
52314 | 52314 | 2020-04-12 | Rock | Minnesota | 27133 | 2 | 0 |
54996 | 54996 | 2020-04-13 | Rock | Minnesota | 27133 | 2 | 0 |
57694 | 57694 | 2020-04-14 | Rock | Minnesota | 27133 | 2 | 0 |
60405 | 60405 | 2020-04-15 | Rock | Minnesota | 27133 | 2 | 0 |
63128 | 63128 | 2020-04-16 | Rock | Minnesota | 27133 | 3 | 0 |
65867 | 65867 | 2020-04-17 | Rock | Minnesota | 27133 | 3 | 0 |
68619 | 68619 | 2020-04-18 | Rock | Minnesota | 27133 | 3 | 0 |
71385 | 71385 | 2020-04-19 | Rock | Minnesota | 27133 | 3 | 0 |
74158 | 74158 | 2020-04-20 | Rock | Minnesota | 27133 | 4 | 0 |
76939 | 76939 | 2020-04-21 | Rock | Minnesota | 27133 | 5 | 0 |
79724 | 79724 | 2020-04-22 | Rock | Minnesota | 27133 | 5 | 0 |
82520 | 82520 | 2020-04-23 | Rock | Minnesota | 27133 | 5 | 0 |
85324 | 85324 | 2020-04-24 | Rock | Minnesota | 27133 | 5 | 0 |
88134 | 88134 | 2020-04-25 | Rock | Minnesota | 27133 | 5 | 0 |
90950 | 90950 | 2020-04-26 | Rock | Minnesota | 27133 | 5 | 0 |
93771 | 93771 | 2020-04-27 | Rock | Minnesota | 27133 | 6 | 0 |
96606 | 96606 | 2020-04-28 | Rock | Minnesota | 27133 | 8 | 0 |
99452 | 99452 | 2020-04-29 | Rock | Minnesota | 27133 | 9 | 0 |
102304 | 102304 | 2020-04-30 | Rock | Minnesota | 27133 | 11 | 0 |
105165 | 105165 | 2020-05-01 | Rock | Minnesota | 27133 | 12 | 0 |
108030 | 108030 | 2020-05-02 | Rock | Minnesota | 27133 | 16 | 0 |
110901 | 110901 | 2020-05-03 | Rock | Minnesota | 27133 | 16 | 0 |
113780 | 113780 | 2020-05-04 | Rock | Minnesota | 27133 | 16 | 0 |
116662 | 116662 | 2020-05-05 | Rock | Minnesota | 27133 | 18 | 0 |
119622 | 119622 | 2020-05-06 | Rock | Minnesota | 27133 | 18 | 0 |
122596 | 122596 | 2020-05-07 | Rock | Minnesota | 27133 | 19 | 0 |
125578 | 125578 | 2020-05-08 | Rock | Minnesota | 27133 | 19 | 0 |
128565 | 128565 | 2020-05-09 | Rock | Minnesota | 27133 | 19 | 0 |
131555 | 131555 | 2020-05-10 | Rock | Minnesota | 27133 | 19 | 0 |
134546 | 134546 | 2020-05-11 | Rock | Minnesota | 27133 | 19 | 0 |
137536 | 137536 | 2020-05-12 | Rock | Minnesota | 27133 | 19 | 0 |
140530 | 140530 | 2020-05-13 | Rock | Minnesota | 27133 | 19 | 0 |
143525 | 143525 | 2020-05-14 | Rock | Minnesota | 27133 | 19 | 0 |
146525 | 146525 | 2020-05-15 | Rock | Minnesota | 27133 | 19 | 0 |
149530 | 149530 | 2020-05-16 | Rock | Minnesota | 27133 | 20 | 0 |
152541 | 152541 | 2020-05-17 | Rock | Minnesota | 27133 | 20 | 0 |
155555 | 155555 | 2020-05-18 | Rock | Minnesota | 27133 | 20 | 0 |
158573 | 158573 | 2020-05-19 | Rock | Minnesota | 27133 | 20 | 0 |
161599 | 161599 | 2020-05-20 | Rock | Minnesota | 27133 | 20 | 0 |
164628 | 164628 | 2020-05-21 | Rock | Minnesota | 27133 | 20 | 0 |
167664 | 167664 | 2020-05-22 | Rock | Minnesota | 27133 | 20 | 0 |
170702 | 170702 | 2020-05-23 | Rock | Minnesota | 27133 | 20 | 0 |
173744 | 173744 | 2020-05-24 | Rock | Minnesota | 27133 | 21 | 0 |
176787 | 176787 | 2020-05-25 | Rock | Minnesota | 27133 | 21 | 0 |
179831 | 179831 | 2020-05-26 | Rock | Minnesota | 27133 | 21 | 0 |
182877 | 182877 | 2020-05-27 | Rock | Minnesota | 27133 | 21 | 0 |
185932 | 185932 | 2020-05-28 | Rock | Minnesota | 27133 | 22 | 0 |
188990 | 188990 | 2020-05-29 | Rock | Minnesota | 27133 | 22 | 0 |
192054 | 192054 | 2020-05-30 | Rock | Minnesota | 27133 | 22 | 0 |
195122 | 195122 | 2020-05-31 | Rock | Minnesota | 27133 | 22 | 0 |
198193 | 198193 | 2020-06-01 | Rock | Minnesota | 27133 | 22 | 0 |
201266 | 201266 | 2020-06-02 | Rock | Minnesota | 27133 | 22 | 0 |
204343 | 204343 | 2020-06-03 | Rock | Minnesota | 27133 | 23 | 0 |
207424 | 207424 | 2020-06-04 | Rock | Minnesota | 27133 | 23 | 0 |
210505 | 210505 | 2020-06-05 | Rock | Minnesota | 27133 | 23 | 0 |
213589 | 213589 | 2020-06-06 | Rock | Minnesota | 27133 | 23 | 0 |
216677 | 216677 | 2020-06-07 | Rock | Minnesota | 27133 | 23 | 0 |
219769 | 219769 | 2020-06-08 | Rock | Minnesota | 27133 | 23 | 0 |
222864 | 222864 | 2020-06-09 | Rock | Minnesota | 27133 | 23 | 0 |
225962 | 225962 | 2020-06-10 | Rock | Minnesota | 27133 | 23 | 0 |
229064 | 229064 | 2020-06-11 | Rock | Minnesota | 27133 | 23 | 0 |
232168 | 232168 | 2020-06-12 | Rock | Minnesota | 27133 | 23 | 0 |
235274 | 235274 | 2020-06-13 | Rock | Minnesota | 27133 | 23 | 0 |
238381 | 238381 | 2020-06-14 | Rock | Minnesota | 27133 | 25 | 0 |
241490 | 241490 | 2020-06-15 | Rock | Minnesota | 27133 | 25 | 0 |
244601 | 244601 | 2020-06-16 | Rock | Minnesota | 27133 | 25 | 0 |
247714 | 247714 | 2020-06-17 | Rock | Minnesota | 27133 | 25 | 0 |
250826 | 250826 | 2020-06-18 | Rock | Minnesota | 27133 | 26 | 0 |
253941 | 253941 | 2020-06-19 | Rock | Minnesota | 27133 | 26 | 0 |
257061 | 257061 | 2020-06-20 | Rock | Minnesota | 27133 | 26 | 0 |
260187 | 260187 | 2020-06-21 | Rock | Minnesota | 27133 | 28 | 0 |
263316 | 263316 | 2020-06-22 | Rock | Minnesota | 27133 | 28 | 0 |
266442 | 266442 | 2020-06-23 | Rock | Minnesota | 27133 | 28 | 0 |
269575 | 269575 | 2020-06-24 | Rock | Minnesota | 27133 | 28 | 0 |
272712 | 272712 | 2020-06-25 | Rock | Minnesota | 27133 | 28 | 0 |
275855 | 275855 | 2020-06-26 | Rock | Minnesota | 27133 | 29 | 0 |
279003 | 279003 | 2020-06-27 | Rock | Minnesota | 27133 | 29 | 0 |
282151 | 282151 | 2020-06-28 | Rock | Minnesota | 27133 | 29 | 0 |
285296 | 285296 | 2020-06-29 | Rock | Minnesota | 27133 | 30 | 0 |
288446 | 288446 | 2020-06-30 | Rock | Minnesota | 27133 | 30 | 0 |
291597 | 291597 | 2020-07-01 | Rock | Minnesota | 27133 | 29 | 0 |
294751 | 294751 | 2020-07-02 | Rock | Minnesota | 27133 | 29 | 0 |
297909 | 297909 | 2020-07-03 | Rock | Minnesota | 27133 | 30 | 0 |
301072 | 301072 | 2020-07-04 | Rock | Minnesota | 27133 | 30 | 0 |
304236 | 304236 | 2020-07-05 | Rock | Minnesota | 27133 | 31 | 0 |
307403 | 307403 | 2020-07-06 | Rock | Minnesota | 27133 | 31 | 0 |
310571 | 310571 | 2020-07-07 | Rock | Minnesota | 27133 | 31 | 0 |
313741 | 313741 | 2020-07-08 | Rock | Minnesota | 27133 | 31 | 0 |
316915 | 316915 | 2020-07-09 | Rock | Minnesota | 27133 | 31 | 0 |
320090 | 320090 | 2020-07-10 | Rock | Minnesota | 27133 | 31 | 0 |
323269 | 323269 | 2020-07-11 | Rock | Minnesota | 27133 | 34 | 0 |
326452 | 326452 | 2020-07-12 | Rock | Minnesota | 27133 | 34 | 0 |
329638 | 329638 | 2020-07-13 | Rock | Minnesota | 27133 | 35 | 0 |
332825 | 332825 | 2020-07-14 | Rock | Minnesota | 27133 | 35 | 0 |
336018 | 336018 | 2020-07-15 | Rock | Minnesota | 27133 | 35 | 0 |
339214 | 339214 | 2020-07-16 | Rock | Minnesota | 27133 | 36 | 0 |
342410 | 342410 | 2020-07-17 | Rock | Minnesota | 27133 | 37 | 0 |
345610 | 345610 | 2020-07-18 | Rock | Minnesota | 27133 | 40 | 0 |
348811 | 348811 | 2020-07-19 | Rock | Minnesota | 27133 | 42 | 0 |
352011 | 352011 | 2020-07-20 | Rock | Minnesota | 27133 | 42 | 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);