ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 27135 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500972 | 2500972 | 2022-05-13 | Roseau | Minnesota | 27135 | 4524 | 44 |
2497714 | 2497714 | 2022-05-12 | Roseau | Minnesota | 27135 | 4520 | 44 |
2494456 | 2494456 | 2022-05-11 | Roseau | Minnesota | 27135 | 4506 | 44 |
2491198 | 2491198 | 2022-05-10 | Roseau | Minnesota | 27135 | 4506 | 44 |
2487941 | 2487941 | 2022-05-09 | Roseau | Minnesota | 27135 | 4497 | 44 |
2484683 | 2484683 | 2022-05-08 | Roseau | Minnesota | 27135 | 4493 | 44 |
2481425 | 2481425 | 2022-05-07 | Roseau | Minnesota | 27135 | 4493 | 44 |
2478167 | 2478167 | 2022-05-06 | Roseau | Minnesota | 27135 | 4493 | 44 |
2474909 | 2474909 | 2022-05-05 | Roseau | Minnesota | 27135 | 4487 | 44 |
2471652 | 2471652 | 2022-05-04 | Roseau | Minnesota | 27135 | 4486 | 44 |
2468396 | 2468396 | 2022-05-03 | Roseau | Minnesota | 27135 | 4483 | 44 |
2465141 | 2465141 | 2022-05-02 | Roseau | Minnesota | 27135 | 4481 | 44 |
2461885 | 2461885 | 2022-05-01 | Roseau | Minnesota | 27135 | 4481 | 44 |
2458629 | 2458629 | 2022-04-30 | Roseau | Minnesota | 27135 | 4481 | 44 |
2455373 | 2455373 | 2022-04-29 | Roseau | Minnesota | 27135 | 4481 | 44 |
2452117 | 2452117 | 2022-04-28 | Roseau | Minnesota | 27135 | 4478 | 44 |
2448861 | 2448861 | 2022-04-27 | Roseau | Minnesota | 27135 | 4477 | 44 |
2445605 | 2445605 | 2022-04-26 | Roseau | Minnesota | 27135 | 4476 | 44 |
2442349 | 2442349 | 2022-04-25 | Roseau | Minnesota | 27135 | 4473 | 44 |
2439093 | 2439093 | 2022-04-24 | Roseau | Minnesota | 27135 | 4471 | 44 |
2435837 | 2435837 | 2022-04-23 | Roseau | Minnesota | 27135 | 4471 | 44 |
2432581 | 2432581 | 2022-04-22 | Roseau | Minnesota | 27135 | 4471 | 44 |
2429325 | 2429325 | 2022-04-21 | Roseau | Minnesota | 27135 | 4469 | 44 |
2426069 | 2426069 | 2022-04-20 | Roseau | Minnesota | 27135 | 4469 | 44 |
2422813 | 2422813 | 2022-04-19 | Roseau | Minnesota | 27135 | 4468 | 44 |
2419557 | 2419557 | 2022-04-18 | Roseau | Minnesota | 27135 | 4468 | 44 |
2416301 | 2416301 | 2022-04-17 | Roseau | Minnesota | 27135 | 4468 | 44 |
2413045 | 2413045 | 2022-04-16 | Roseau | Minnesota | 27135 | 4468 | 44 |
2409789 | 2409789 | 2022-04-15 | Roseau | Minnesota | 27135 | 4468 | 44 |
2406533 | 2406533 | 2022-04-14 | Roseau | Minnesota | 27135 | 4468 | 44 |
2403277 | 2403277 | 2022-04-13 | Roseau | Minnesota | 27135 | 4468 | 44 |
2400023 | 2400023 | 2022-04-12 | Roseau | Minnesota | 27135 | 4467 | 44 |
2396767 | 2396767 | 2022-04-11 | Roseau | Minnesota | 27135 | 4467 | 44 |
2393512 | 2393512 | 2022-04-10 | Roseau | Minnesota | 27135 | 4467 | 44 |
2390256 | 2390256 | 2022-04-09 | Roseau | Minnesota | 27135 | 4467 | 44 |
2387000 | 2387000 | 2022-04-08 | Roseau | Minnesota | 27135 | 4467 | 44 |
2383745 | 2383745 | 2022-04-07 | Roseau | Minnesota | 27135 | 4466 | 44 |
2380490 | 2380490 | 2022-04-06 | Roseau | Minnesota | 27135 | 4465 | 44 |
2377235 | 2377235 | 2022-04-05 | Roseau | Minnesota | 27135 | 4465 | 44 |
2373983 | 2373983 | 2022-04-04 | Roseau | Minnesota | 27135 | 4463 | 44 |
2370730 | 2370730 | 2022-04-03 | Roseau | Minnesota | 27135 | 4463 | 44 |
2367477 | 2367477 | 2022-04-02 | Roseau | Minnesota | 27135 | 4463 | 44 |
2364224 | 2364224 | 2022-04-01 | Roseau | Minnesota | 27135 | 4463 | 44 |
2360970 | 2360970 | 2022-03-31 | Roseau | Minnesota | 27135 | 4461 | 44 |
2357716 | 2357716 | 2022-03-30 | Roseau | Minnesota | 27135 | 4461 | 44 |
2354463 | 2354463 | 2022-03-29 | Roseau | Minnesota | 27135 | 4461 | 44 |
2351211 | 2351211 | 2022-03-28 | Roseau | Minnesota | 27135 | 4461 | 44 |
2347958 | 2347958 | 2022-03-27 | Roseau | Minnesota | 27135 | 4460 | 44 |
2344705 | 2344705 | 2022-03-26 | Roseau | Minnesota | 27135 | 4460 | 44 |
2341452 | 2341452 | 2022-03-25 | Roseau | Minnesota | 27135 | 4460 | 44 |
2338199 | 2338199 | 2022-03-24 | Roseau | Minnesota | 27135 | 4460 | 44 |
2334945 | 2334945 | 2022-03-23 | Roseau | Minnesota | 27135 | 4460 | 44 |
2331691 | 2331691 | 2022-03-22 | Roseau | Minnesota | 27135 | 4460 | 44 |
2328439 | 2328439 | 2022-03-21 | Roseau | Minnesota | 27135 | 4458 | 44 |
2325186 | 2325186 | 2022-03-20 | Roseau | Minnesota | 27135 | 4457 | 44 |
2321932 | 2321932 | 2022-03-19 | Roseau | Minnesota | 27135 | 4457 | 44 |
2318678 | 2318678 | 2022-03-18 | Roseau | Minnesota | 27135 | 4457 | 44 |
2315425 | 2315425 | 2022-03-17 | Roseau | Minnesota | 27135 | 4457 | 44 |
2312172 | 2312172 | 2022-03-16 | Roseau | Minnesota | 27135 | 4454 | 44 |
2308919 | 2308919 | 2022-03-15 | Roseau | Minnesota | 27135 | 4453 | 44 |
2305668 | 2305668 | 2022-03-14 | Roseau | Minnesota | 27135 | 4444 | 44 |
2302416 | 2302416 | 2022-03-13 | Roseau | Minnesota | 27135 | 4442 | 44 |
2299164 | 2299164 | 2022-03-12 | Roseau | Minnesota | 27135 | 4442 | 44 |
2295912 | 2295912 | 2022-03-11 | Roseau | Minnesota | 27135 | 4442 | 44 |
2292660 | 2292660 | 2022-03-10 | Roseau | Minnesota | 27135 | 4388 | 44 |
2289408 | 2289408 | 2022-03-09 | Roseau | Minnesota | 27135 | 4387 | 44 |
2286157 | 2286157 | 2022-03-08 | Roseau | Minnesota | 27135 | 4385 | 44 |
2282905 | 2282905 | 2022-03-07 | Roseau | Minnesota | 27135 | 4384 | 44 |
2279652 | 2279652 | 2022-03-06 | Roseau | Minnesota | 27135 | 4384 | 44 |
2276399 | 2276399 | 2022-03-05 | Roseau | Minnesota | 27135 | 4384 | 44 |
2273146 | 2273146 | 2022-03-04 | Roseau | Minnesota | 27135 | 4384 | 44 |
2269894 | 2269894 | 2022-03-03 | Roseau | Minnesota | 27135 | 4375 | 44 |
2266641 | 2266641 | 2022-03-02 | Roseau | Minnesota | 27135 | 4370 | 44 |
2263390 | 2263390 | 2022-03-01 | Roseau | Minnesota | 27135 | 4366 | 44 |
2260139 | 2260139 | 2022-02-28 | Roseau | Minnesota | 27135 | 4363 | 44 |
2256888 | 2256888 | 2022-02-27 | Roseau | Minnesota | 27135 | 4360 | 44 |
2253637 | 2253637 | 2022-02-26 | Roseau | Minnesota | 27135 | 4360 | 44 |
2250386 | 2250386 | 2022-02-25 | Roseau | Minnesota | 27135 | 4360 | 44 |
2247135 | 2247135 | 2022-02-24 | Roseau | Minnesota | 27135 | 4357 | 43 |
2243884 | 2243884 | 2022-02-23 | Roseau | Minnesota | 27135 | 4357 | 43 |
2240633 | 2240633 | 2022-02-22 | Roseau | Minnesota | 27135 | 4351 | 43 |
2237382 | 2237382 | 2022-02-21 | Roseau | Minnesota | 27135 | 4345 | 43 |
2234131 | 2234131 | 2022-02-20 | Roseau | Minnesota | 27135 | 4345 | 43 |
2230880 | 2230880 | 2022-02-19 | Roseau | Minnesota | 27135 | 4345 | 43 |
2227629 | 2227629 | 2022-02-18 | Roseau | Minnesota | 27135 | 4345 | 43 |
2224378 | 2224378 | 2022-02-17 | Roseau | Minnesota | 27135 | 4328 | 43 |
2221127 | 2221127 | 2022-02-16 | Roseau | Minnesota | 27135 | 4327 | 43 |
2217876 | 2217876 | 2022-02-15 | Roseau | Minnesota | 27135 | 4324 | 43 |
2214625 | 2214625 | 2022-02-14 | Roseau | Minnesota | 27135 | 4315 | 43 |
2211373 | 2211373 | 2022-02-13 | Roseau | Minnesota | 27135 | 4304 | 43 |
2208120 | 2208120 | 2022-02-12 | Roseau | Minnesota | 27135 | 4304 | 43 |
2204867 | 2204867 | 2022-02-11 | Roseau | Minnesota | 27135 | 4304 | 43 |
2201614 | 2201614 | 2022-02-10 | Roseau | Minnesota | 27135 | 4298 | 43 |
2198360 | 2198360 | 2022-02-09 | Roseau | Minnesota | 27135 | 4292 | 42 |
2195106 | 2195106 | 2022-02-08 | Roseau | Minnesota | 27135 | 4277 | 42 |
2191852 | 2191852 | 2022-02-07 | Roseau | Minnesota | 27135 | 4258 | 41 |
2188599 | 2188599 | 2022-02-06 | Roseau | Minnesota | 27135 | 4240 | 41 |
2185346 | 2185346 | 2022-02-05 | Roseau | Minnesota | 27135 | 4240 | 41 |
2182094 | 2182094 | 2022-02-04 | Roseau | Minnesota | 27135 | 4240 | 41 |
2178842 | 2178842 | 2022-02-03 | Roseau | Minnesota | 27135 | 4228 | 41 |
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);