ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

774 rows where fips = 27083 and state = "Minnesota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Minnesota · 774 ✖

fips 1

  • 27083 · 774 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500946 2500946 2022-05-13 Lyon Minnesota 27083 7131 73
2497688 2497688 2022-05-12 Lyon Minnesota 27083 7123 73
2494430 2494430 2022-05-11 Lyon Minnesota 27083 7120 73
2491172 2491172 2022-05-10 Lyon Minnesota 27083 7117 73
2487915 2487915 2022-05-09 Lyon Minnesota 27083 7114 73
2484657 2484657 2022-05-08 Lyon Minnesota 27083 7110 73
2481399 2481399 2022-05-07 Lyon Minnesota 27083 7110 73
2478141 2478141 2022-05-06 Lyon Minnesota 27083 7110 73
2474883 2474883 2022-05-05 Lyon Minnesota 27083 7107 73
2471626 2471626 2022-05-04 Lyon Minnesota 27083 7105 73
2468370 2468370 2022-05-03 Lyon Minnesota 27083 7100 73
2465115 2465115 2022-05-02 Lyon Minnesota 27083 7091 73
2461859 2461859 2022-05-01 Lyon Minnesota 27083 7087 72
2458603 2458603 2022-04-30 Lyon Minnesota 27083 7087 72
2455347 2455347 2022-04-29 Lyon Minnesota 27083 7087 72
2452091 2452091 2022-04-28 Lyon Minnesota 27083 7081 72
2448835 2448835 2022-04-27 Lyon Minnesota 27083 7079 72
2445579 2445579 2022-04-26 Lyon Minnesota 27083 7071 72
2442323 2442323 2022-04-25 Lyon Minnesota 27083 7067 72
2439067 2439067 2022-04-24 Lyon Minnesota 27083 7066 72
2435811 2435811 2022-04-23 Lyon Minnesota 27083 7066 72
2432555 2432555 2022-04-22 Lyon Minnesota 27083 7066 72
2429299 2429299 2022-04-21 Lyon Minnesota 27083 7062 72
2426043 2426043 2022-04-20 Lyon Minnesota 27083 7055 72
2422787 2422787 2022-04-19 Lyon Minnesota 27083 7051 72
2419531 2419531 2022-04-18 Lyon Minnesota 27083 7048 72
2416275 2416275 2022-04-17 Lyon Minnesota 27083 7045 72
2413019 2413019 2022-04-16 Lyon Minnesota 27083 7045 72
2409763 2409763 2022-04-15 Lyon Minnesota 27083 7045 72
2406507 2406507 2022-04-14 Lyon Minnesota 27083 7043 72
2403251 2403251 2022-04-13 Lyon Minnesota 27083 7043 72
2399997 2399997 2022-04-12 Lyon Minnesota 27083 7042 72
2396741 2396741 2022-04-11 Lyon Minnesota 27083 7041 72
2393486 2393486 2022-04-10 Lyon Minnesota 27083 7040 72
2390230 2390230 2022-04-09 Lyon Minnesota 27083 7040 72
2386974 2386974 2022-04-08 Lyon Minnesota 27083 7040 72
2383719 2383719 2022-04-07 Lyon Minnesota 27083 7040 72
2380464 2380464 2022-04-06 Lyon Minnesota 27083 7039 72
2377209 2377209 2022-04-05 Lyon Minnesota 27083 7038 72
2373957 2373957 2022-04-04 Lyon Minnesota 27083 7038 72
2370704 2370704 2022-04-03 Lyon Minnesota 27083 7037 72
2367451 2367451 2022-04-02 Lyon Minnesota 27083 7037 72
2364198 2364198 2022-04-01 Lyon Minnesota 27083 7037 72
2360944 2360944 2022-03-31 Lyon Minnesota 27083 7037 72
2357690 2357690 2022-03-30 Lyon Minnesota 27083 7037 72
2354437 2354437 2022-03-29 Lyon Minnesota 27083 7035 72
2351185 2351185 2022-03-28 Lyon Minnesota 27083 7033 72
2347932 2347932 2022-03-27 Lyon Minnesota 27083 7033 72
2344679 2344679 2022-03-26 Lyon Minnesota 27083 7033 72
2341426 2341426 2022-03-25 Lyon Minnesota 27083 7033 72
2338173 2338173 2022-03-24 Lyon Minnesota 27083 7031 72
2334919 2334919 2022-03-23 Lyon Minnesota 27083 7030 72
2331665 2331665 2022-03-22 Lyon Minnesota 27083 7031 72
2328413 2328413 2022-03-21 Lyon Minnesota 27083 7031 72
2325160 2325160 2022-03-20 Lyon Minnesota 27083 7030 72
2321906 2321906 2022-03-19 Lyon Minnesota 27083 7030 72
2318652 2318652 2022-03-18 Lyon Minnesota 27083 7030 72
2315399 2315399 2022-03-17 Lyon Minnesota 27083 7028 72
2312146 2312146 2022-03-16 Lyon Minnesota 27083 7027 72
2308893 2308893 2022-03-15 Lyon Minnesota 27083 7025 72
2305642 2305642 2022-03-14 Lyon Minnesota 27083 7025 72
2302390 2302390 2022-03-13 Lyon Minnesota 27083 7026 72
2299138 2299138 2022-03-12 Lyon Minnesota 27083 7026 72
2295886 2295886 2022-03-11 Lyon Minnesota 27083 7026 72
2292634 2292634 2022-03-10 Lyon Minnesota 27083 7024 72
2289382 2289382 2022-03-09 Lyon Minnesota 27083 7022 72
2286131 2286131 2022-03-08 Lyon Minnesota 27083 7021 72
2282879 2282879 2022-03-07 Lyon Minnesota 27083 7018 72
2279626 2279626 2022-03-06 Lyon Minnesota 27083 7016 72
2276373 2276373 2022-03-05 Lyon Minnesota 27083 7016 72
2273120 2273120 2022-03-04 Lyon Minnesota 27083 7016 72
2269868 2269868 2022-03-03 Lyon Minnesota 27083 7015 72
2266615 2266615 2022-03-02 Lyon Minnesota 27083 7013 72
2263364 2263364 2022-03-01 Lyon Minnesota 27083 7006 72
2260113 2260113 2022-02-28 Lyon Minnesota 27083 7000 72
2256862 2256862 2022-02-27 Lyon Minnesota 27083 6995 72
2253611 2253611 2022-02-26 Lyon Minnesota 27083 6995 72
2250360 2250360 2022-02-25 Lyon Minnesota 27083 6995 72
2247109 2247109 2022-02-24 Lyon Minnesota 27083 6992 72
2243858 2243858 2022-02-23 Lyon Minnesota 27083 6991 72
2240607 2240607 2022-02-22 Lyon Minnesota 27083 6984 71
2237356 2237356 2022-02-21 Lyon Minnesota 27083 6973 71
2234105 2234105 2022-02-20 Lyon Minnesota 27083 6973 71
2230854 2230854 2022-02-19 Lyon Minnesota 27083 6973 71
2227603 2227603 2022-02-18 Lyon Minnesota 27083 6973 71
2224352 2224352 2022-02-17 Lyon Minnesota 27083 6959 70
2221101 2221101 2022-02-16 Lyon Minnesota 27083 6952 70
2217850 2217850 2022-02-15 Lyon Minnesota 27083 6949 70
2214599 2214599 2022-02-14 Lyon Minnesota 27083 6944 70
2211347 2211347 2022-02-13 Lyon Minnesota 27083 6925 70
2208094 2208094 2022-02-12 Lyon Minnesota 27083 6925 70
2204841 2204841 2022-02-11 Lyon Minnesota 27083 6925 70
2201588 2201588 2022-02-10 Lyon Minnesota 27083 6913 70
2198334 2198334 2022-02-09 Lyon Minnesota 27083 6889 70
2195080 2195080 2022-02-08 Lyon Minnesota 27083 6876 70
2191826 2191826 2022-02-07 Lyon Minnesota 27083 6844 70
2188573 2188573 2022-02-06 Lyon Minnesota 27083 6821 70
2185320 2185320 2022-02-05 Lyon Minnesota 27083 6821 70
2182068 2182068 2022-02-04 Lyon Minnesota 27083 6821 70
2178816 2178816 2022-02-03 Lyon Minnesota 27083 6805 70

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);