ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
716 rows where fips = 27149 and state = "Minnesota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
185940 | 185940 | 2020-05-28 | Stevens | Minnesota | 27149 | 1 | 0 |
188998 | 188998 | 2020-05-29 | Stevens | Minnesota | 27149 | 2 | 0 |
192062 | 192062 | 2020-05-30 | Stevens | Minnesota | 27149 | 1 | 0 |
195130 | 195130 | 2020-05-31 | Stevens | Minnesota | 27149 | 1 | 0 |
198201 | 198201 | 2020-06-01 | Stevens | Minnesota | 27149 | 1 | 0 |
201274 | 201274 | 2020-06-02 | Stevens | Minnesota | 27149 | 1 | 0 |
204351 | 204351 | 2020-06-03 | Stevens | Minnesota | 27149 | 1 | 0 |
207432 | 207432 | 2020-06-04 | Stevens | Minnesota | 27149 | 1 | 0 |
210513 | 210513 | 2020-06-05 | Stevens | Minnesota | 27149 | 1 | 0 |
213597 | 213597 | 2020-06-06 | Stevens | Minnesota | 27149 | 1 | 0 |
216685 | 216685 | 2020-06-07 | Stevens | Minnesota | 27149 | 1 | 0 |
219777 | 219777 | 2020-06-08 | Stevens | Minnesota | 27149 | 1 | 0 |
222872 | 222872 | 2020-06-09 | Stevens | Minnesota | 27149 | 1 | 0 |
225970 | 225970 | 2020-06-10 | Stevens | Minnesota | 27149 | 1 | 0 |
229072 | 229072 | 2020-06-11 | Stevens | Minnesota | 27149 | 1 | 0 |
232176 | 232176 | 2020-06-12 | Stevens | Minnesota | 27149 | 1 | 0 |
235282 | 235282 | 2020-06-13 | Stevens | Minnesota | 27149 | 1 | 0 |
238389 | 238389 | 2020-06-14 | Stevens | Minnesota | 27149 | 1 | 0 |
241498 | 241498 | 2020-06-15 | Stevens | Minnesota | 27149 | 1 | 0 |
244609 | 244609 | 2020-06-16 | Stevens | Minnesota | 27149 | 1 | 0 |
247722 | 247722 | 2020-06-17 | Stevens | Minnesota | 27149 | 1 | 0 |
250834 | 250834 | 2020-06-18 | Stevens | Minnesota | 27149 | 1 | 0 |
253949 | 253949 | 2020-06-19 | Stevens | Minnesota | 27149 | 2 | 0 |
257069 | 257069 | 2020-06-20 | Stevens | Minnesota | 27149 | 2 | 0 |
260195 | 260195 | 2020-06-21 | Stevens | Minnesota | 27149 | 2 | 0 |
263324 | 263324 | 2020-06-22 | Stevens | Minnesota | 27149 | 2 | 0 |
266450 | 266450 | 2020-06-23 | Stevens | Minnesota | 27149 | 3 | 0 |
269583 | 269583 | 2020-06-24 | Stevens | Minnesota | 27149 | 3 | 0 |
272720 | 272720 | 2020-06-25 | Stevens | Minnesota | 27149 | 3 | 0 |
275863 | 275863 | 2020-06-26 | Stevens | Minnesota | 27149 | 3 | 0 |
279011 | 279011 | 2020-06-27 | Stevens | Minnesota | 27149 | 3 | 0 |
282159 | 282159 | 2020-06-28 | Stevens | Minnesota | 27149 | 3 | 0 |
285304 | 285304 | 2020-06-29 | Stevens | Minnesota | 27149 | 3 | 0 |
288454 | 288454 | 2020-06-30 | Stevens | Minnesota | 27149 | 4 | 0 |
291605 | 291605 | 2020-07-01 | Stevens | Minnesota | 27149 | 4 | 0 |
294759 | 294759 | 2020-07-02 | Stevens | Minnesota | 27149 | 4 | 0 |
297917 | 297917 | 2020-07-03 | Stevens | Minnesota | 27149 | 4 | 0 |
301080 | 301080 | 2020-07-04 | Stevens | Minnesota | 27149 | 4 | 0 |
304244 | 304244 | 2020-07-05 | Stevens | Minnesota | 27149 | 4 | 0 |
307411 | 307411 | 2020-07-06 | Stevens | Minnesota | 27149 | 4 | 0 |
310579 | 310579 | 2020-07-07 | Stevens | Minnesota | 27149 | 5 | 0 |
313749 | 313749 | 2020-07-08 | Stevens | Minnesota | 27149 | 6 | 0 |
316923 | 316923 | 2020-07-09 | Stevens | Minnesota | 27149 | 8 | 0 |
320098 | 320098 | 2020-07-10 | Stevens | Minnesota | 27149 | 10 | 0 |
323277 | 323277 | 2020-07-11 | Stevens | Minnesota | 27149 | 11 | 0 |
326460 | 326460 | 2020-07-12 | Stevens | Minnesota | 27149 | 11 | 0 |
329646 | 329646 | 2020-07-13 | Stevens | Minnesota | 27149 | 11 | 0 |
332833 | 332833 | 2020-07-14 | Stevens | Minnesota | 27149 | 11 | 0 |
336026 | 336026 | 2020-07-15 | Stevens | Minnesota | 27149 | 11 | 0 |
339222 | 339222 | 2020-07-16 | Stevens | Minnesota | 27149 | 13 | 0 |
342418 | 342418 | 2020-07-17 | Stevens | Minnesota | 27149 | 13 | 0 |
345618 | 345618 | 2020-07-18 | Stevens | Minnesota | 27149 | 13 | 0 |
348819 | 348819 | 2020-07-19 | Stevens | Minnesota | 27149 | 13 | 0 |
352019 | 352019 | 2020-07-20 | Stevens | Minnesota | 27149 | 13 | 0 |
355221 | 355221 | 2020-07-21 | Stevens | Minnesota | 27149 | 14 | 0 |
358424 | 358424 | 2020-07-22 | Stevens | Minnesota | 27149 | 14 | 0 |
361629 | 361629 | 2020-07-23 | Stevens | Minnesota | 27149 | 14 | 0 |
364836 | 364836 | 2020-07-24 | Stevens | Minnesota | 27149 | 15 | 0 |
368044 | 368044 | 2020-07-25 | Stevens | Minnesota | 27149 | 15 | 0 |
371254 | 371254 | 2020-07-26 | Stevens | Minnesota | 27149 | 15 | 0 |
374466 | 374466 | 2020-07-27 | Stevens | Minnesota | 27149 | 15 | 0 |
377681 | 377681 | 2020-07-28 | Stevens | Minnesota | 27149 | 15 | 0 |
380898 | 380898 | 2020-07-29 | Stevens | Minnesota | 27149 | 15 | 0 |
384115 | 384115 | 2020-07-30 | Stevens | Minnesota | 27149 | 15 | 0 |
387333 | 387333 | 2020-07-31 | Stevens | Minnesota | 27149 | 15 | 0 |
390550 | 390550 | 2020-08-01 | Stevens | Minnesota | 27149 | 15 | 0 |
393767 | 393767 | 2020-08-02 | Stevens | Minnesota | 27149 | 15 | 0 |
396983 | 396983 | 2020-08-03 | Stevens | Minnesota | 27149 | 15 | 0 |
400197 | 400197 | 2020-08-04 | Stevens | Minnesota | 27149 | 16 | 0 |
403414 | 403414 | 2020-08-05 | Stevens | Minnesota | 27149 | 16 | 0 |
406632 | 406632 | 2020-08-06 | Stevens | Minnesota | 27149 | 17 | 0 |
409852 | 409852 | 2020-08-07 | Stevens | Minnesota | 27149 | 17 | 0 |
413072 | 413072 | 2020-08-08 | Stevens | Minnesota | 27149 | 18 | 0 |
416292 | 416292 | 2020-08-09 | Stevens | Minnesota | 27149 | 18 | 0 |
419513 | 419513 | 2020-08-10 | Stevens | Minnesota | 27149 | 18 | 0 |
422735 | 422735 | 2020-08-11 | Stevens | Minnesota | 27149 | 18 | 0 |
425957 | 425957 | 2020-08-12 | Stevens | Minnesota | 27149 | 18 | 0 |
429181 | 429181 | 2020-08-13 | Stevens | Minnesota | 27149 | 18 | 0 |
432408 | 432408 | 2020-08-14 | Stevens | Minnesota | 27149 | 22 | 0 |
435634 | 435634 | 2020-08-15 | Stevens | Minnesota | 27149 | 22 | 0 |
438859 | 438859 | 2020-08-16 | Stevens | Minnesota | 27149 | 22 | 0 |
442086 | 442086 | 2020-08-17 | Stevens | Minnesota | 27149 | 22 | 0 |
445312 | 445312 | 2020-08-18 | Stevens | Minnesota | 27149 | 22 | 0 |
448538 | 448538 | 2020-08-19 | Stevens | Minnesota | 27149 | 22 | 0 |
451766 | 451766 | 2020-08-20 | Stevens | Minnesota | 27149 | 22 | 0 |
454994 | 454994 | 2020-08-21 | Stevens | Minnesota | 27149 | 23 | 0 |
458222 | 458222 | 2020-08-22 | Stevens | Minnesota | 27149 | 25 | 0 |
461449 | 461449 | 2020-08-23 | Stevens | Minnesota | 27149 | 25 | 0 |
464680 | 464680 | 2020-08-24 | Stevens | Minnesota | 27149 | 28 | 0 |
467909 | 467909 | 2020-08-25 | Stevens | Minnesota | 27149 | 27 | 0 |
471139 | 471139 | 2020-08-26 | Stevens | Minnesota | 27149 | 27 | 0 |
474371 | 474371 | 2020-08-27 | Stevens | Minnesota | 27149 | 31 | 0 |
477604 | 477604 | 2020-08-28 | Stevens | Minnesota | 27149 | 33 | 0 |
480836 | 480836 | 2020-08-29 | Stevens | Minnesota | 27149 | 38 | 0 |
484071 | 484071 | 2020-08-30 | Stevens | Minnesota | 27149 | 45 | 0 |
487305 | 487305 | 2020-08-31 | Stevens | Minnesota | 27149 | 47 | 0 |
490538 | 490538 | 2020-09-01 | Stevens | Minnesota | 27149 | 52 | 1 |
493772 | 493772 | 2020-09-02 | Stevens | Minnesota | 27149 | 54 | 1 |
497005 | 497005 | 2020-09-03 | Stevens | Minnesota | 27149 | 57 | 1 |
500239 | 500239 | 2020-09-04 | Stevens | Minnesota | 27149 | 64 | 1 |
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);