ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 27121 and state = "Minnesota" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
116656 | 116656 | 2020-05-05 | Pope | Minnesota | 27121 | 1 | 0 |
119616 | 119616 | 2020-05-06 | Pope | Minnesota | 27121 | 1 | 0 |
122590 | 122590 | 2020-05-07 | Pope | Minnesota | 27121 | 3 | 0 |
125572 | 125572 | 2020-05-08 | Pope | Minnesota | 27121 | 5 | 0 |
128559 | 128559 | 2020-05-09 | Pope | Minnesota | 27121 | 5 | 0 |
131549 | 131549 | 2020-05-10 | Pope | Minnesota | 27121 | 5 | 0 |
134540 | 134540 | 2020-05-11 | Pope | Minnesota | 27121 | 5 | 0 |
137530 | 137530 | 2020-05-12 | Pope | Minnesota | 27121 | 5 | 0 |
140524 | 140524 | 2020-05-13 | Pope | Minnesota | 27121 | 5 | 0 |
143519 | 143519 | 2020-05-14 | Pope | Minnesota | 27121 | 5 | 0 |
146519 | 146519 | 2020-05-15 | Pope | Minnesota | 27121 | 5 | 0 |
149524 | 149524 | 2020-05-16 | Pope | Minnesota | 27121 | 5 | 0 |
152535 | 152535 | 2020-05-17 | Pope | Minnesota | 27121 | 5 | 0 |
155549 | 155549 | 2020-05-18 | Pope | Minnesota | 27121 | 5 | 0 |
158567 | 158567 | 2020-05-19 | Pope | Minnesota | 27121 | 5 | 0 |
161593 | 161593 | 2020-05-20 | Pope | Minnesota | 27121 | 6 | 0 |
164622 | 164622 | 2020-05-21 | Pope | Minnesota | 27121 | 6 | 0 |
167658 | 167658 | 2020-05-22 | Pope | Minnesota | 27121 | 6 | 0 |
170696 | 170696 | 2020-05-23 | Pope | Minnesota | 27121 | 6 | 0 |
173738 | 173738 | 2020-05-24 | Pope | Minnesota | 27121 | 7 | 0 |
176781 | 176781 | 2020-05-25 | Pope | Minnesota | 27121 | 8 | 0 |
179825 | 179825 | 2020-05-26 | Pope | Minnesota | 27121 | 8 | 0 |
182871 | 182871 | 2020-05-27 | Pope | Minnesota | 27121 | 8 | 0 |
185926 | 185926 | 2020-05-28 | Pope | Minnesota | 27121 | 8 | 0 |
188984 | 188984 | 2020-05-29 | Pope | Minnesota | 27121 | 9 | 0 |
192048 | 192048 | 2020-05-30 | Pope | Minnesota | 27121 | 9 | 0 |
195116 | 195116 | 2020-05-31 | Pope | Minnesota | 27121 | 9 | 0 |
198187 | 198187 | 2020-06-01 | Pope | Minnesota | 27121 | 9 | 0 |
201260 | 201260 | 2020-06-02 | Pope | Minnesota | 27121 | 9 | 0 |
204337 | 204337 | 2020-06-03 | Pope | Minnesota | 27121 | 9 | 0 |
207418 | 207418 | 2020-06-04 | Pope | Minnesota | 27121 | 10 | 0 |
210499 | 210499 | 2020-06-05 | Pope | Minnesota | 27121 | 10 | 0 |
213583 | 213583 | 2020-06-06 | Pope | Minnesota | 27121 | 10 | 0 |
216671 | 216671 | 2020-06-07 | Pope | Minnesota | 27121 | 10 | 0 |
219763 | 219763 | 2020-06-08 | Pope | Minnesota | 27121 | 10 | 0 |
222858 | 222858 | 2020-06-09 | Pope | Minnesota | 27121 | 10 | 0 |
225956 | 225956 | 2020-06-10 | Pope | Minnesota | 27121 | 10 | 0 |
229058 | 229058 | 2020-06-11 | Pope | Minnesota | 27121 | 10 | 0 |
232162 | 232162 | 2020-06-12 | Pope | Minnesota | 27121 | 10 | 0 |
235268 | 235268 | 2020-06-13 | Pope | Minnesota | 27121 | 10 | 0 |
238375 | 238375 | 2020-06-14 | Pope | Minnesota | 27121 | 10 | 0 |
241484 | 241484 | 2020-06-15 | Pope | Minnesota | 27121 | 10 | 0 |
244595 | 244595 | 2020-06-16 | Pope | Minnesota | 27121 | 10 | 0 |
247708 | 247708 | 2020-06-17 | Pope | Minnesota | 27121 | 10 | 0 |
250820 | 250820 | 2020-06-18 | Pope | Minnesota | 27121 | 10 | 0 |
253935 | 253935 | 2020-06-19 | Pope | Minnesota | 27121 | 10 | 0 |
257055 | 257055 | 2020-06-20 | Pope | Minnesota | 27121 | 10 | 0 |
260181 | 260181 | 2020-06-21 | Pope | Minnesota | 27121 | 10 | 0 |
263310 | 263310 | 2020-06-22 | Pope | Minnesota | 27121 | 10 | 0 |
266436 | 266436 | 2020-06-23 | Pope | Minnesota | 27121 | 10 | 0 |
269569 | 269569 | 2020-06-24 | Pope | Minnesota | 27121 | 10 | 0 |
272706 | 272706 | 2020-06-25 | Pope | Minnesota | 27121 | 10 | 0 |
275849 | 275849 | 2020-06-26 | Pope | Minnesota | 27121 | 10 | 0 |
278997 | 278997 | 2020-06-27 | Pope | Minnesota | 27121 | 10 | 0 |
282145 | 282145 | 2020-06-28 | Pope | Minnesota | 27121 | 10 | 0 |
285290 | 285290 | 2020-06-29 | Pope | Minnesota | 27121 | 10 | 0 |
288440 | 288440 | 2020-06-30 | Pope | Minnesota | 27121 | 10 | 0 |
291591 | 291591 | 2020-07-01 | Pope | Minnesota | 27121 | 10 | 0 |
294745 | 294745 | 2020-07-02 | Pope | Minnesota | 27121 | 10 | 0 |
297903 | 297903 | 2020-07-03 | Pope | Minnesota | 27121 | 10 | 0 |
301066 | 301066 | 2020-07-04 | Pope | Minnesota | 27121 | 10 | 0 |
304230 | 304230 | 2020-07-05 | Pope | Minnesota | 27121 | 10 | 0 |
307397 | 307397 | 2020-07-06 | Pope | Minnesota | 27121 | 10 | 0 |
310565 | 310565 | 2020-07-07 | Pope | Minnesota | 27121 | 12 | 0 |
313735 | 313735 | 2020-07-08 | Pope | Minnesota | 27121 | 12 | 0 |
316909 | 316909 | 2020-07-09 | Pope | Minnesota | 27121 | 12 | 0 |
320084 | 320084 | 2020-07-10 | Pope | Minnesota | 27121 | 12 | 0 |
323263 | 323263 | 2020-07-11 | Pope | Minnesota | 27121 | 13 | 0 |
326446 | 326446 | 2020-07-12 | Pope | Minnesota | 27121 | 13 | 0 |
329632 | 329632 | 2020-07-13 | Pope | Minnesota | 27121 | 13 | 0 |
332819 | 332819 | 2020-07-14 | Pope | Minnesota | 27121 | 14 | 0 |
336012 | 336012 | 2020-07-15 | Pope | Minnesota | 27121 | 19 | 0 |
339208 | 339208 | 2020-07-16 | Pope | Minnesota | 27121 | 19 | 0 |
342404 | 342404 | 2020-07-17 | Pope | Minnesota | 27121 | 24 | 0 |
345604 | 345604 | 2020-07-18 | Pope | Minnesota | 27121 | 24 | 0 |
348805 | 348805 | 2020-07-19 | Pope | Minnesota | 27121 | 24 | 0 |
352005 | 352005 | 2020-07-20 | Pope | Minnesota | 27121 | 24 | 0 |
355207 | 355207 | 2020-07-21 | Pope | Minnesota | 27121 | 27 | 0 |
358410 | 358410 | 2020-07-22 | Pope | Minnesota | 27121 | 28 | 0 |
361615 | 361615 | 2020-07-23 | Pope | Minnesota | 27121 | 30 | 0 |
364822 | 364822 | 2020-07-24 | Pope | Minnesota | 27121 | 31 | 0 |
368030 | 368030 | 2020-07-25 | Pope | Minnesota | 27121 | 31 | 0 |
371240 | 371240 | 2020-07-26 | Pope | Minnesota | 27121 | 34 | 0 |
374452 | 374452 | 2020-07-27 | Pope | Minnesota | 27121 | 35 | 0 |
377667 | 377667 | 2020-07-28 | Pope | Minnesota | 27121 | 35 | 0 |
380884 | 380884 | 2020-07-29 | Pope | Minnesota | 27121 | 35 | 0 |
384101 | 384101 | 2020-07-30 | Pope | Minnesota | 27121 | 35 | 0 |
387319 | 387319 | 2020-07-31 | Pope | Minnesota | 27121 | 38 | 0 |
390536 | 390536 | 2020-08-01 | Pope | Minnesota | 27121 | 39 | 0 |
393753 | 393753 | 2020-08-02 | Pope | Minnesota | 27121 | 39 | 0 |
396969 | 396969 | 2020-08-03 | Pope | Minnesota | 27121 | 43 | 0 |
400183 | 400183 | 2020-08-04 | Pope | Minnesota | 27121 | 45 | 0 |
403400 | 403400 | 2020-08-05 | Pope | Minnesota | 27121 | 46 | 0 |
406618 | 406618 | 2020-08-06 | Pope | Minnesota | 27121 | 46 | 0 |
409838 | 409838 | 2020-08-07 | Pope | Minnesota | 27121 | 46 | 0 |
413058 | 413058 | 2020-08-08 | Pope | Minnesota | 27121 | 46 | 0 |
416278 | 416278 | 2020-08-09 | Pope | Minnesota | 27121 | 48 | 0 |
419499 | 419499 | 2020-08-10 | Pope | Minnesota | 27121 | 48 | 0 |
422721 | 422721 | 2020-08-11 | Pope | Minnesota | 27121 | 48 | 0 |
425943 | 425943 | 2020-08-12 | Pope | Minnesota | 27121 | 48 | 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);