ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 27143 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 |
---|---|---|---|---|---|---|---|
2500975 | 2500975 | 2022-05-13 | Sibley | Minnesota | 27143 | 3596 | 24 |
2497717 | 2497717 | 2022-05-12 | Sibley | Minnesota | 27143 | 3589 | 24 |
2494459 | 2494459 | 2022-05-11 | Sibley | Minnesota | 27143 | 3584 | 24 |
2491201 | 2491201 | 2022-05-10 | Sibley | Minnesota | 27143 | 3579 | 24 |
2487944 | 2487944 | 2022-05-09 | Sibley | Minnesota | 27143 | 3572 | 24 |
2484686 | 2484686 | 2022-05-08 | Sibley | Minnesota | 27143 | 3568 | 24 |
2481428 | 2481428 | 2022-05-07 | Sibley | Minnesota | 27143 | 3568 | 24 |
2478170 | 2478170 | 2022-05-06 | Sibley | Minnesota | 27143 | 3568 | 24 |
2474912 | 2474912 | 2022-05-05 | Sibley | Minnesota | 27143 | 3564 | 24 |
2471655 | 2471655 | 2022-05-04 | Sibley | Minnesota | 27143 | 3561 | 24 |
2468399 | 2468399 | 2022-05-03 | Sibley | Minnesota | 27143 | 3556 | 24 |
2465144 | 2465144 | 2022-05-02 | Sibley | Minnesota | 27143 | 3550 | 24 |
2461888 | 2461888 | 2022-05-01 | Sibley | Minnesota | 27143 | 3548 | 24 |
2458632 | 2458632 | 2022-04-30 | Sibley | Minnesota | 27143 | 3548 | 24 |
2455376 | 2455376 | 2022-04-29 | Sibley | Minnesota | 27143 | 3548 | 24 |
2452120 | 2452120 | 2022-04-28 | Sibley | Minnesota | 27143 | 3547 | 24 |
2448864 | 2448864 | 2022-04-27 | Sibley | Minnesota | 27143 | 3545 | 24 |
2445608 | 2445608 | 2022-04-26 | Sibley | Minnesota | 27143 | 3541 | 24 |
2442352 | 2442352 | 2022-04-25 | Sibley | Minnesota | 27143 | 3535 | 24 |
2439096 | 2439096 | 2022-04-24 | Sibley | Minnesota | 27143 | 3534 | 24 |
2435840 | 2435840 | 2022-04-23 | Sibley | Minnesota | 27143 | 3534 | 24 |
2432584 | 2432584 | 2022-04-22 | Sibley | Minnesota | 27143 | 3534 | 24 |
2429328 | 2429328 | 2022-04-21 | Sibley | Minnesota | 27143 | 3529 | 24 |
2426072 | 2426072 | 2022-04-20 | Sibley | Minnesota | 27143 | 3525 | 24 |
2422816 | 2422816 | 2022-04-19 | Sibley | Minnesota | 27143 | 3522 | 24 |
2419560 | 2419560 | 2022-04-18 | Sibley | Minnesota | 27143 | 3520 | 24 |
2416304 | 2416304 | 2022-04-17 | Sibley | Minnesota | 27143 | 3519 | 24 |
2413048 | 2413048 | 2022-04-16 | Sibley | Minnesota | 27143 | 3519 | 24 |
2409792 | 2409792 | 2022-04-15 | Sibley | Minnesota | 27143 | 3519 | 24 |
2406536 | 2406536 | 2022-04-14 | Sibley | Minnesota | 27143 | 3518 | 24 |
2403280 | 2403280 | 2022-04-13 | Sibley | Minnesota | 27143 | 3517 | 24 |
2400026 | 2400026 | 2022-04-12 | Sibley | Minnesota | 27143 | 3514 | 24 |
2396770 | 2396770 | 2022-04-11 | Sibley | Minnesota | 27143 | 3513 | 24 |
2393515 | 2393515 | 2022-04-10 | Sibley | Minnesota | 27143 | 3512 | 24 |
2390259 | 2390259 | 2022-04-09 | Sibley | Minnesota | 27143 | 3512 | 24 |
2387003 | 2387003 | 2022-04-08 | Sibley | Minnesota | 27143 | 3512 | 24 |
2383748 | 2383748 | 2022-04-07 | Sibley | Minnesota | 27143 | 3510 | 24 |
2380493 | 2380493 | 2022-04-06 | Sibley | Minnesota | 27143 | 3509 | 24 |
2377238 | 2377238 | 2022-04-05 | Sibley | Minnesota | 27143 | 3509 | 24 |
2373986 | 2373986 | 2022-04-04 | Sibley | Minnesota | 27143 | 3504 | 24 |
2370733 | 2370733 | 2022-04-03 | Sibley | Minnesota | 27143 | 3503 | 24 |
2367480 | 2367480 | 2022-04-02 | Sibley | Minnesota | 27143 | 3503 | 24 |
2364227 | 2364227 | 2022-04-01 | Sibley | Minnesota | 27143 | 3503 | 24 |
2360973 | 2360973 | 2022-03-31 | Sibley | Minnesota | 27143 | 3502 | 24 |
2357719 | 2357719 | 2022-03-30 | Sibley | Minnesota | 27143 | 3499 | 24 |
2354466 | 2354466 | 2022-03-29 | Sibley | Minnesota | 27143 | 3498 | 23 |
2351214 | 2351214 | 2022-03-28 | Sibley | Minnesota | 27143 | 3494 | 23 |
2347961 | 2347961 | 2022-03-27 | Sibley | Minnesota | 27143 | 3493 | 23 |
2344708 | 2344708 | 2022-03-26 | Sibley | Minnesota | 27143 | 3493 | 23 |
2341455 | 2341455 | 2022-03-25 | Sibley | Minnesota | 27143 | 3493 | 23 |
2338202 | 2338202 | 2022-03-24 | Sibley | Minnesota | 27143 | 3490 | 23 |
2334948 | 2334948 | 2022-03-23 | Sibley | Minnesota | 27143 | 3490 | 23 |
2331694 | 2331694 | 2022-03-22 | Sibley | Minnesota | 27143 | 3488 | 23 |
2328442 | 2328442 | 2022-03-21 | Sibley | Minnesota | 27143 | 3485 | 23 |
2325189 | 2325189 | 2022-03-20 | Sibley | Minnesota | 27143 | 3481 | 23 |
2321935 | 2321935 | 2022-03-19 | Sibley | Minnesota | 27143 | 3481 | 23 |
2318681 | 2318681 | 2022-03-18 | Sibley | Minnesota | 27143 | 3481 | 23 |
2315428 | 2315428 | 2022-03-17 | Sibley | Minnesota | 27143 | 3480 | 23 |
2312175 | 2312175 | 2022-03-16 | Sibley | Minnesota | 27143 | 3480 | 23 |
2308922 | 2308922 | 2022-03-15 | Sibley | Minnesota | 27143 | 3475 | 23 |
2305671 | 2305671 | 2022-03-14 | Sibley | Minnesota | 27143 | 3473 | 23 |
2302419 | 2302419 | 2022-03-13 | Sibley | Minnesota | 27143 | 3473 | 23 |
2299167 | 2299167 | 2022-03-12 | Sibley | Minnesota | 27143 | 3473 | 23 |
2295915 | 2295915 | 2022-03-11 | Sibley | Minnesota | 27143 | 3473 | 23 |
2292663 | 2292663 | 2022-03-10 | Sibley | Minnesota | 27143 | 3457 | 23 |
2289411 | 2289411 | 2022-03-09 | Sibley | Minnesota | 27143 | 3457 | 23 |
2286160 | 2286160 | 2022-03-08 | Sibley | Minnesota | 27143 | 3456 | 23 |
2282908 | 2282908 | 2022-03-07 | Sibley | Minnesota | 27143 | 3456 | 23 |
2279655 | 2279655 | 2022-03-06 | Sibley | Minnesota | 27143 | 3453 | 23 |
2276402 | 2276402 | 2022-03-05 | Sibley | Minnesota | 27143 | 3453 | 23 |
2273149 | 2273149 | 2022-03-04 | Sibley | Minnesota | 27143 | 3453 | 23 |
2269897 | 2269897 | 2022-03-03 | Sibley | Minnesota | 27143 | 3451 | 23 |
2266644 | 2266644 | 2022-03-02 | Sibley | Minnesota | 27143 | 3446 | 23 |
2263393 | 2263393 | 2022-03-01 | Sibley | Minnesota | 27143 | 3443 | 23 |
2260142 | 2260142 | 2022-02-28 | Sibley | Minnesota | 27143 | 3441 | 23 |
2256891 | 2256891 | 2022-02-27 | Sibley | Minnesota | 27143 | 3438 | 23 |
2253640 | 2253640 | 2022-02-26 | Sibley | Minnesota | 27143 | 3438 | 23 |
2250389 | 2250389 | 2022-02-25 | Sibley | Minnesota | 27143 | 3438 | 23 |
2247138 | 2247138 | 2022-02-24 | Sibley | Minnesota | 27143 | 3435 | 23 |
2243887 | 2243887 | 2022-02-23 | Sibley | Minnesota | 27143 | 3426 | 23 |
2240636 | 2240636 | 2022-02-22 | Sibley | Minnesota | 27143 | 3413 | 23 |
2237385 | 2237385 | 2022-02-21 | Sibley | Minnesota | 27143 | 3401 | 23 |
2234134 | 2234134 | 2022-02-20 | Sibley | Minnesota | 27143 | 3401 | 23 |
2230883 | 2230883 | 2022-02-19 | Sibley | Minnesota | 27143 | 3401 | 23 |
2227632 | 2227632 | 2022-02-18 | Sibley | Minnesota | 27143 | 3401 | 23 |
2224381 | 2224381 | 2022-02-17 | Sibley | Minnesota | 27143 | 3386 | 23 |
2221130 | 2221130 | 2022-02-16 | Sibley | Minnesota | 27143 | 3384 | 23 |
2217879 | 2217879 | 2022-02-15 | Sibley | Minnesota | 27143 | 3381 | 23 |
2214628 | 2214628 | 2022-02-14 | Sibley | Minnesota | 27143 | 3367 | 23 |
2211376 | 2211376 | 2022-02-13 | Sibley | Minnesota | 27143 | 3357 | 23 |
2208123 | 2208123 | 2022-02-12 | Sibley | Minnesota | 27143 | 3357 | 23 |
2204870 | 2204870 | 2022-02-11 | Sibley | Minnesota | 27143 | 3357 | 23 |
2201617 | 2201617 | 2022-02-10 | Sibley | Minnesota | 27143 | 3342 | 23 |
2198363 | 2198363 | 2022-02-09 | Sibley | Minnesota | 27143 | 3334 | 23 |
2195109 | 2195109 | 2022-02-08 | Sibley | Minnesota | 27143 | 3329 | 23 |
2191855 | 2191855 | 2022-02-07 | Sibley | Minnesota | 27143 | 3318 | 23 |
2188602 | 2188602 | 2022-02-06 | Sibley | Minnesota | 27143 | 3293 | 23 |
2185349 | 2185349 | 2022-02-05 | Sibley | Minnesota | 27143 | 3293 | 23 |
2182097 | 2182097 | 2022-02-04 | Sibley | Minnesota | 27143 | 3293 | 23 |
2178845 | 2178845 | 2022-02-03 | Sibley | Minnesota | 27143 | 3288 | 23 |
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);