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

737 rows where county = "Lake" and fips = 27075 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 27075 · 737 ✖

county 1

  • Lake · 737 ✖
Link rowid date ▲ county state fips cases deaths
2500942 2500942 2022-05-13 Lake Minnesota 27075 2138 28
2497684 2497684 2022-05-12 Lake Minnesota 27075 2135 28
2494426 2494426 2022-05-11 Lake Minnesota 27075 2127 28
2491168 2491168 2022-05-10 Lake Minnesota 27075 2123 28
2487911 2487911 2022-05-09 Lake Minnesota 27075 2108 28
2484653 2484653 2022-05-08 Lake Minnesota 27075 2101 28
2481395 2481395 2022-05-07 Lake Minnesota 27075 2101 28
2478137 2478137 2022-05-06 Lake Minnesota 27075 2101 28
2474879 2474879 2022-05-05 Lake Minnesota 27075 2101 28
2471622 2471622 2022-05-04 Lake Minnesota 27075 2096 28
2468366 2468366 2022-05-03 Lake Minnesota 27075 2092 28
2465111 2465111 2022-05-02 Lake Minnesota 27075 2089 28
2461855 2461855 2022-05-01 Lake Minnesota 27075 2087 28
2458599 2458599 2022-04-30 Lake Minnesota 27075 2087 28
2455343 2455343 2022-04-29 Lake Minnesota 27075 2087 28
2452087 2452087 2022-04-28 Lake Minnesota 27075 2086 28
2448831 2448831 2022-04-27 Lake Minnesota 27075 2084 28
2445575 2445575 2022-04-26 Lake Minnesota 27075 2083 28
2442319 2442319 2022-04-25 Lake Minnesota 27075 2083 28
2439063 2439063 2022-04-24 Lake Minnesota 27075 2082 28
2435807 2435807 2022-04-23 Lake Minnesota 27075 2082 28
2432551 2432551 2022-04-22 Lake Minnesota 27075 2082 28
2429295 2429295 2022-04-21 Lake Minnesota 27075 2080 28
2426039 2426039 2022-04-20 Lake Minnesota 27075 2080 28
2422783 2422783 2022-04-19 Lake Minnesota 27075 2079 28
2419527 2419527 2022-04-18 Lake Minnesota 27075 2076 28
2416271 2416271 2022-04-17 Lake Minnesota 27075 2072 28
2413015 2413015 2022-04-16 Lake Minnesota 27075 2072 28
2409759 2409759 2022-04-15 Lake Minnesota 27075 2072 28
2406503 2406503 2022-04-14 Lake Minnesota 27075 2069 28
2403247 2403247 2022-04-13 Lake Minnesota 27075 2068 28
2399993 2399993 2022-04-12 Lake Minnesota 27075 2068 28
2396737 2396737 2022-04-11 Lake Minnesota 27075 2067 28
2393482 2393482 2022-04-10 Lake Minnesota 27075 2067 28
2390226 2390226 2022-04-09 Lake Minnesota 27075 2067 28
2386970 2386970 2022-04-08 Lake Minnesota 27075 2067 28
2383715 2383715 2022-04-07 Lake Minnesota 27075 2067 28
2380460 2380460 2022-04-06 Lake Minnesota 27075 2066 28
2377205 2377205 2022-04-05 Lake Minnesota 27075 2066 28
2373953 2373953 2022-04-04 Lake Minnesota 27075 2065 28
2370700 2370700 2022-04-03 Lake Minnesota 27075 2065 28
2367447 2367447 2022-04-02 Lake Minnesota 27075 2065 28
2364194 2364194 2022-04-01 Lake Minnesota 27075 2065 28
2360940 2360940 2022-03-31 Lake Minnesota 27075 2064 28
2357686 2357686 2022-03-30 Lake Minnesota 27075 2064 28
2354433 2354433 2022-03-29 Lake Minnesota 27075 2064 28
2351181 2351181 2022-03-28 Lake Minnesota 27075 2064 28
2347928 2347928 2022-03-27 Lake Minnesota 27075 2063 28
2344675 2344675 2022-03-26 Lake Minnesota 27075 2063 28
2341422 2341422 2022-03-25 Lake Minnesota 27075 2063 28
2338169 2338169 2022-03-24 Lake Minnesota 27075 2063 28
2334915 2334915 2022-03-23 Lake Minnesota 27075 2062 28
2331661 2331661 2022-03-22 Lake Minnesota 27075 2062 28
2328409 2328409 2022-03-21 Lake Minnesota 27075 2060 28
2325156 2325156 2022-03-20 Lake Minnesota 27075 2059 28
2321902 2321902 2022-03-19 Lake Minnesota 27075 2059 28
2318648 2318648 2022-03-18 Lake Minnesota 27075 2059 28
2315395 2315395 2022-03-17 Lake Minnesota 27075 2059 28
2312142 2312142 2022-03-16 Lake Minnesota 27075 2060 28
2308889 2308889 2022-03-15 Lake Minnesota 27075 2058 28
2305638 2305638 2022-03-14 Lake Minnesota 27075 2054 28
2302386 2302386 2022-03-13 Lake Minnesota 27075 2050 28
2299134 2299134 2022-03-12 Lake Minnesota 27075 2050 28
2295882 2295882 2022-03-11 Lake Minnesota 27075 2050 28
2292630 2292630 2022-03-10 Lake Minnesota 27075 2033 28
2289378 2289378 2022-03-09 Lake Minnesota 27075 2032 28
2286127 2286127 2022-03-08 Lake Minnesota 27075 2030 28
2282875 2282875 2022-03-07 Lake Minnesota 27075 2027 28
2279622 2279622 2022-03-06 Lake Minnesota 27075 2025 28
2276369 2276369 2022-03-05 Lake Minnesota 27075 2025 28
2273116 2273116 2022-03-04 Lake Minnesota 27075 2025 28
2269864 2269864 2022-03-03 Lake Minnesota 27075 2021 28
2266611 2266611 2022-03-02 Lake Minnesota 27075 2019 28
2263360 2263360 2022-03-01 Lake Minnesota 27075 2010 28
2260109 2260109 2022-02-28 Lake Minnesota 27075 2004 28
2256858 2256858 2022-02-27 Lake Minnesota 27075 1995 28
2253607 2253607 2022-02-26 Lake Minnesota 27075 1995 28
2250356 2250356 2022-02-25 Lake Minnesota 27075 1995 28
2247105 2247105 2022-02-24 Lake Minnesota 27075 1994 28
2243854 2243854 2022-02-23 Lake Minnesota 27075 1999 28
2240603 2240603 2022-02-22 Lake Minnesota 27075 1996 28
2237352 2237352 2022-02-21 Lake Minnesota 27075 1995 28
2234101 2234101 2022-02-20 Lake Minnesota 27075 1995 28
2230850 2230850 2022-02-19 Lake Minnesota 27075 1995 28
2227599 2227599 2022-02-18 Lake Minnesota 27075 1995 28
2224348 2224348 2022-02-17 Lake Minnesota 27075 1980 27
2221097 2221097 2022-02-16 Lake Minnesota 27075 1979 27
2217846 2217846 2022-02-15 Lake Minnesota 27075 1978 27
2214595 2214595 2022-02-14 Lake Minnesota 27075 1972 27
2211343 2211343 2022-02-13 Lake Minnesota 27075 1956 27
2208090 2208090 2022-02-12 Lake Minnesota 27075 1956 27
2204837 2204837 2022-02-11 Lake Minnesota 27075 1956 27
2201584 2201584 2022-02-10 Lake Minnesota 27075 1951 27
2198330 2198330 2022-02-09 Lake Minnesota 27075 1953 27
2195076 2195076 2022-02-08 Lake Minnesota 27075 1940 27
2191822 2191822 2022-02-07 Lake Minnesota 27075 1920 27
2188569 2188569 2022-02-06 Lake Minnesota 27075 1916 27
2185316 2185316 2022-02-05 Lake Minnesota 27075 1916 27
2182064 2182064 2022-02-04 Lake Minnesota 27075 1916 27
2178812 2178812 2022-02-03 Lake Minnesota 27075 1905 26

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