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

761 rows where county = "Lake" and fips = 47095 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

  • 47095 · 761 ✖

county 1

  • Lake · 761 ✖
Link rowid date ▲ county state fips cases deaths
2502158 2502158 2022-05-13 Lake Tennessee 47095 2749 43
2498900 2498900 2022-05-12 Lake Tennessee 47095 2749 43
2495642 2495642 2022-05-11 Lake Tennessee 47095 2749 43
2492384 2492384 2022-05-10 Lake Tennessee 47095 2749 43
2489126 2489126 2022-05-09 Lake Tennessee 47095 2749 43
2485869 2485869 2022-05-08 Lake Tennessee 47095 2749 43
2482611 2482611 2022-05-07 Lake Tennessee 47095 2749 43
2479353 2479353 2022-05-06 Lake Tennessee 47095 2749 43
2476095 2476095 2022-05-05 Lake Tennessee 47095 2749 43
2472838 2472838 2022-05-04 Lake Tennessee 47095 2749 43
2469582 2469582 2022-05-03 Lake Tennessee 47095 2748 43
2466326 2466326 2022-05-02 Lake Tennessee 47095 2748 43
2463071 2463071 2022-05-01 Lake Tennessee 47095 2748 43
2459815 2459815 2022-04-30 Lake Tennessee 47095 2748 43
2456559 2456559 2022-04-29 Lake Tennessee 47095 2748 43
2453303 2453303 2022-04-28 Lake Tennessee 47095 2748 43
2450047 2450047 2022-04-27 Lake Tennessee 47095 2748 43
2446790 2446790 2022-04-26 Lake Tennessee 47095 2747 43
2443535 2443535 2022-04-25 Lake Tennessee 47095 2747 43
2440279 2440279 2022-04-24 Lake Tennessee 47095 2747 43
2437023 2437023 2022-04-23 Lake Tennessee 47095 2747 43
2433767 2433767 2022-04-22 Lake Tennessee 47095 2747 43
2430511 2430511 2022-04-21 Lake Tennessee 47095 2747 43
2427255 2427255 2022-04-20 Lake Tennessee 47095 2747 43
2423999 2423999 2022-04-19 Lake Tennessee 47095 2746 43
2420743 2420743 2022-04-18 Lake Tennessee 47095 2746 43
2417487 2417487 2022-04-17 Lake Tennessee 47095 2746 43
2414231 2414231 2022-04-16 Lake Tennessee 47095 2746 43
2410975 2410975 2022-04-15 Lake Tennessee 47095 2746 43
2407719 2407719 2022-04-14 Lake Tennessee 47095 2746 43
2404463 2404463 2022-04-13 Lake Tennessee 47095 2746 43
2401208 2401208 2022-04-12 Lake Tennessee 47095 2740 41
2397953 2397953 2022-04-11 Lake Tennessee 47095 2740 41
2394698 2394698 2022-04-10 Lake Tennessee 47095 2740 41
2391442 2391442 2022-04-09 Lake Tennessee 47095 2740 41
2388186 2388186 2022-04-08 Lake Tennessee 47095 2740 41
2384931 2384931 2022-04-07 Lake Tennessee 47095 2740 41
2381676 2381676 2022-04-06 Lake Tennessee 47095 2740 41
2378421 2378421 2022-04-05 Lake Tennessee 47095 2738 40
2375167 2375167 2022-04-04 Lake Tennessee 47095 2738 40
2371915 2371915 2022-04-03 Lake Tennessee 47095 2738 40
2368662 2368662 2022-04-02 Lake Tennessee 47095 2738 40
2365409 2365409 2022-04-01 Lake Tennessee 47095 2738 40
2362156 2362156 2022-03-31 Lake Tennessee 47095 2738 40
2358902 2358902 2022-03-30 Lake Tennessee 47095 2738 40
2355648 2355648 2022-03-29 Lake Tennessee 47095 2737 40
2352395 2352395 2022-03-28 Lake Tennessee 47095 2737 40
2349143 2349143 2022-03-27 Lake Tennessee 47095 2737 40
2345890 2345890 2022-03-26 Lake Tennessee 47095 2737 40
2342637 2342637 2022-03-25 Lake Tennessee 47095 2737 40
2339384 2339384 2022-03-24 Lake Tennessee 47095 2737 40
2336130 2336130 2022-03-23 Lake Tennessee 47095 2737 40
2332876 2332876 2022-03-22 Lake Tennessee 47095 2736 40
2329623 2329623 2022-03-21 Lake Tennessee 47095 2736 40
2326371 2326371 2022-03-20 Lake Tennessee 47095 2736 40
2323118 2323118 2022-03-19 Lake Tennessee 47095 2736 40
2319864 2319864 2022-03-18 Lake Tennessee 47095 2736 40
2316610 2316610 2022-03-17 Lake Tennessee 47095 2736 40
2313357 2313357 2022-03-16 Lake Tennessee 47095 2736 40
2310104 2310104 2022-03-15 Lake Tennessee 47095 2733 40
2306851 2306851 2022-03-14 Lake Tennessee 47095 2733 40
2303600 2303600 2022-03-13 Lake Tennessee 47095 2733 40
2300348 2300348 2022-03-12 Lake Tennessee 47095 2733 40
2297096 2297096 2022-03-11 Lake Tennessee 47095 2733 40
2293844 2293844 2022-03-10 Lake Tennessee 47095 2733 40
2290592 2290592 2022-03-09 Lake Tennessee 47095 2733 40
2287340 2287340 2022-03-08 Lake Tennessee 47095 2705 40
2284088 2284088 2022-03-07 Lake Tennessee 47095 2705 40
2280836 2280836 2022-03-06 Lake Tennessee 47095 2705 40
2277583 2277583 2022-03-05 Lake Tennessee 47095 2705 40
2274330 2274330 2022-03-04 Lake Tennessee 47095 2705 40
2271077 2271077 2022-03-03 Lake Tennessee 47095 2705 40
2267825 2267825 2022-03-02 Lake Tennessee 47095 2705 40
2264572 2264572 2022-03-01 Lake Tennessee 47095 2670 38
2261322 2261322 2022-02-28 Lake Tennessee 47095 2670 38
2258071 2258071 2022-02-27 Lake Tennessee 47095 2670 38
2254820 2254820 2022-02-26 Lake Tennessee 47095 2670 38
2251569 2251569 2022-02-25 Lake Tennessee 47095 2670 38
2248318 2248318 2022-02-24 Lake Tennessee 47095 2670 38
2245067 2245067 2022-02-23 Lake Tennessee 47095 2670 38
2241816 2241816 2022-02-22 Lake Tennessee 47095 2636 37
2238565 2238565 2022-02-21 Lake Tennessee 47095 2636 37
2235314 2235314 2022-02-20 Lake Tennessee 47095 2636 37
2232063 2232063 2022-02-19 Lake Tennessee 47095 2636 37
2228812 2228812 2022-02-18 Lake Tennessee 47095 2636 37
2225561 2225561 2022-02-17 Lake Tennessee 47095 2636 37
2222310 2222310 2022-02-16 Lake Tennessee 47095 2636 37
2219059 2219059 2022-02-15 Lake Tennessee 47095 2612 36
2215808 2215808 2022-02-14 Lake Tennessee 47095 2612 36
2212557 2212557 2022-02-13 Lake Tennessee 47095 2612 36
2209304 2209304 2022-02-12 Lake Tennessee 47095 2612 36
2206051 2206051 2022-02-11 Lake Tennessee 47095 2612 36
2202798 2202798 2022-02-10 Lake Tennessee 47095 2612 36
2199544 2199544 2022-02-09 Lake Tennessee 47095 2612 36
2196290 2196290 2022-02-08 Lake Tennessee 47095 2581 34
2193036 2193036 2022-02-07 Lake Tennessee 47095 2581 34
2189782 2189782 2022-02-06 Lake Tennessee 47095 2581 34
2186529 2186529 2022-02-05 Lake Tennessee 47095 2581 34
2183277 2183277 2022-02-04 Lake Tennessee 47095 2581 34
2180025 2180025 2022-02-03 Lake Tennessee 47095 2581 34

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