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

763 rows where county = "Lake" and fips = 26085 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 26085 · 763 ✖

county 1

  • Lake · 763 ✖
Link rowid date ▲ county state fips cases deaths
2500863 2500863 2022-05-13 Lake Michigan 26085 1893 37
2497605 2497605 2022-05-12 Lake Michigan 26085 1893 37
2494347 2494347 2022-05-11 Lake Michigan 26085 1893 37
2491089 2491089 2022-05-10 Lake Michigan 26085 1870 37
2487832 2487832 2022-05-09 Lake Michigan 26085 1870 37
2484574 2484574 2022-05-08 Lake Michigan 26085 1870 37
2481316 2481316 2022-05-07 Lake Michigan 26085 1870 37
2478058 2478058 2022-05-06 Lake Michigan 26085 1870 37
2474800 2474800 2022-05-05 Lake Michigan 26085 1870 37
2471543 2471543 2022-05-04 Lake Michigan 26085 1870 37
2468287 2468287 2022-05-03 Lake Michigan 26085 1850 37
2465032 2465032 2022-05-02 Lake Michigan 26085 1850 37
2461776 2461776 2022-05-01 Lake Michigan 26085 1850 37
2458520 2458520 2022-04-30 Lake Michigan 26085 1850 37
2455264 2455264 2022-04-29 Lake Michigan 26085 1850 37
2452008 2452008 2022-04-28 Lake Michigan 26085 1850 37
2448752 2448752 2022-04-27 Lake Michigan 26085 1850 37
2445496 2445496 2022-04-26 Lake Michigan 26085 1842 37
2442240 2442240 2022-04-25 Lake Michigan 26085 1842 37
2438984 2438984 2022-04-24 Lake Michigan 26085 1842 37
2435728 2435728 2022-04-23 Lake Michigan 26085 1842 37
2432472 2432472 2022-04-22 Lake Michigan 26085 1842 37
2429216 2429216 2022-04-21 Lake Michigan 26085 1842 37
2425960 2425960 2022-04-20 Lake Michigan 26085 1842 37
2422704 2422704 2022-04-19 Lake Michigan 26085 1841 37
2419448 2419448 2022-04-18 Lake Michigan 26085 1841 37
2416192 2416192 2022-04-17 Lake Michigan 26085 1841 37
2412936 2412936 2022-04-16 Lake Michigan 26085 1841 37
2409680 2409680 2022-04-15 Lake Michigan 26085 1841 37
2406424 2406424 2022-04-14 Lake Michigan 26085 1841 37
2403168 2403168 2022-04-13 Lake Michigan 26085 1841 37
2399914 2399914 2022-04-12 Lake Michigan 26085 1840 37
2396658 2396658 2022-04-11 Lake Michigan 26085 1840 37
2393403 2393403 2022-04-10 Lake Michigan 26085 1840 37
2390147 2390147 2022-04-09 Lake Michigan 26085 1840 37
2386891 2386891 2022-04-08 Lake Michigan 26085 1840 37
2383636 2383636 2022-04-07 Lake Michigan 26085 1840 37
2380381 2380381 2022-04-06 Lake Michigan 26085 1840 37
2377126 2377126 2022-04-05 Lake Michigan 26085 1839 37
2373874 2373874 2022-04-04 Lake Michigan 26085 1839 37
2370621 2370621 2022-04-03 Lake Michigan 26085 1839 37
2367368 2367368 2022-04-02 Lake Michigan 26085 1839 37
2364115 2364115 2022-04-01 Lake Michigan 26085 1839 37
2360861 2360861 2022-03-31 Lake Michigan 26085 1839 37
2357607 2357607 2022-03-30 Lake Michigan 26085 1839 37
2354354 2354354 2022-03-29 Lake Michigan 26085 1838 37
2351102 2351102 2022-03-28 Lake Michigan 26085 1838 37
2347849 2347849 2022-03-27 Lake Michigan 26085 1838 37
2344596 2344596 2022-03-26 Lake Michigan 26085 1838 37
2341343 2341343 2022-03-25 Lake Michigan 26085 1838 37
2338090 2338090 2022-03-24 Lake Michigan 26085 1838 37
2334836 2334836 2022-03-23 Lake Michigan 26085 1838 37
2331582 2331582 2022-03-22 Lake Michigan 26085 1836 37
2328330 2328330 2022-03-21 Lake Michigan 26085 1836 37
2325077 2325077 2022-03-20 Lake Michigan 26085 1833 37
2321823 2321823 2022-03-19 Lake Michigan 26085 1833 37
2318569 2318569 2022-03-18 Lake Michigan 26085 1833 37
2315316 2315316 2022-03-17 Lake Michigan 26085 1833 37
2312063 2312063 2022-03-16 Lake Michigan 26085 1833 37
2308810 2308810 2022-03-15 Lake Michigan 26085 1832 36
2305559 2305559 2022-03-14 Lake Michigan 26085 1832 36
2302307 2302307 2022-03-13 Lake Michigan 26085 1832 36
2299055 2299055 2022-03-12 Lake Michigan 26085 1832 36
2295803 2295803 2022-03-11 Lake Michigan 26085 1832 36
2292551 2292551 2022-03-10 Lake Michigan 26085 1832 36
2289299 2289299 2022-03-09 Lake Michigan 26085 1832 36
2286048 2286048 2022-03-08 Lake Michigan 26085 1831 35
2282796 2282796 2022-03-07 Lake Michigan 26085 1831 35
2279543 2279543 2022-03-06 Lake Michigan 26085 1826 35
2276290 2276290 2022-03-05 Lake Michigan 26085 1826 35
2273037 2273037 2022-03-04 Lake Michigan 26085 1826 35
2269785 2269785 2022-03-03 Lake Michigan 26085 1824 35
2266532 2266532 2022-03-02 Lake Michigan 26085 1824 35
2263281 2263281 2022-03-01 Lake Michigan 26085 1821 35
2260030 2260030 2022-02-28 Lake Michigan 26085 1821 35
2256779 2256779 2022-02-27 Lake Michigan 26085 1816 35
2253528 2253528 2022-02-26 Lake Michigan 26085 1816 35
2250277 2250277 2022-02-25 Lake Michigan 26085 1816 35
2247026 2247026 2022-02-24 Lake Michigan 26085 1813 35
2243775 2243775 2022-02-23 Lake Michigan 26085 1813 35
2240524 2240524 2022-02-22 Lake Michigan 26085 1802 34
2237273 2237273 2022-02-21 Lake Michigan 26085 1802 34
2234022 2234022 2022-02-20 Lake Michigan 26085 1802 34
2230771 2230771 2022-02-19 Lake Michigan 26085 1791 34
2227520 2227520 2022-02-18 Lake Michigan 26085 1791 34
2224269 2224269 2022-02-17 Lake Michigan 26085 1791 34
2221018 2221018 2022-02-16 Lake Michigan 26085 1791 34
2217767 2217767 2022-02-15 Lake Michigan 26085 1788 34
2214516 2214516 2022-02-14 Lake Michigan 26085 1788 34
2211264 2211264 2022-02-13 Lake Michigan 26085 1778 34
2208011 2208011 2022-02-12 Lake Michigan 26085 1778 34
2204758 2204758 2022-02-11 Lake Michigan 26085 1778 34
2201505 2201505 2022-02-10 Lake Michigan 26085 1755 33
2198251 2198251 2022-02-09 Lake Michigan 26085 1755 33
2194997 2194997 2022-02-08 Lake Michigan 26085 1745 33
2191743 2191743 2022-02-07 Lake Michigan 26085 1745 33
2188490 2188490 2022-02-06 Lake Michigan 26085 1735 33
2185237 2185237 2022-02-05 Lake Michigan 26085 1735 33
2181985 2181985 2022-02-04 Lake Michigan 26085 1735 33
2178733 2178733 2022-02-03 Lake Michigan 26085 1718 33

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