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

784 rows where county = "Windham" and state = "Vermont" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Vermont · 784 ✖

fips 1

county 1

  • Windham · 784 ✖
Link rowid date ▲ county state fips cases deaths
2502505 2502505 2022-05-13 Windham Vermont 50025 6994 36
2499247 2499247 2022-05-12 Windham Vermont 50025 6974 36
2495989 2495989 2022-05-11 Windham Vermont 50025 6942 36
2492731 2492731 2022-05-10 Windham Vermont 50025 6921 36
2489473 2489473 2022-05-09 Windham Vermont 50025 6907 36
2486215 2486215 2022-05-08 Windham Vermont 50025 6847 36
2482957 2482957 2022-05-07 Windham Vermont 50025 6847 36
2479699 2479699 2022-05-06 Windham Vermont 50025 6847 36
2476441 2476441 2022-05-05 Windham Vermont 50025 6826 36
2473184 2473184 2022-05-04 Windham Vermont 50025 6800 36
2469928 2469928 2022-05-03 Windham Vermont 50025 6774 36
2466672 2466672 2022-05-02 Windham Vermont 50025 6762 36
2463417 2463417 2022-05-01 Windham Vermont 50025 6737 36
2460161 2460161 2022-04-30 Windham Vermont 50025 6737 36
2456905 2456905 2022-04-29 Windham Vermont 50025 6737 36
2453649 2453649 2022-04-28 Windham Vermont 50025 6731 36
2450393 2450393 2022-04-27 Windham Vermont 50025 6839 35
2447136 2447136 2022-04-26 Windham Vermont 50025 6839 35
2443881 2443881 2022-04-25 Windham Vermont 50025 6839 35
2440625 2440625 2022-04-24 Windham Vermont 50025 6795 35
2437369 2437369 2022-04-23 Windham Vermont 50025 6795 35
2434113 2434113 2022-04-22 Windham Vermont 50025 6795 35
2430857 2430857 2022-04-21 Windham Vermont 50025 6787 35
2427601 2427601 2022-04-20 Windham Vermont 50025 6770 35
2424345 2424345 2022-04-19 Windham Vermont 50025 6762 35
2421089 2421089 2022-04-18 Windham Vermont 50025 6759 35
2417833 2417833 2022-04-17 Windham Vermont 50025 6730 35
2414577 2414577 2022-04-16 Windham Vermont 50025 6730 35
2411321 2411321 2022-04-15 Windham Vermont 50025 6730 35
2408065 2408065 2022-04-14 Windham Vermont 50025 6721 35
2404809 2404809 2022-04-13 Windham Vermont 50025 6699 35
2401554 2401554 2022-04-12 Windham Vermont 50025 6691 35
2398299 2398299 2022-04-11 Windham Vermont 50025 6687 35
2395044 2395044 2022-04-10 Windham Vermont 50025 6673 35
2391788 2391788 2022-04-09 Windham Vermont 50025 6673 35
2388532 2388532 2022-04-08 Windham Vermont 50025 6673 35
2385277 2385277 2022-04-07 Windham Vermont 50025 6663 35
2382022 2382022 2022-04-06 Windham Vermont 50025 6652 35
2378767 2378767 2022-04-05 Windham Vermont 50025 6643 35
2375513 2375513 2022-04-04 Windham Vermont 50025 6639 35
2372261 2372261 2022-04-03 Windham Vermont 50025 6633 35
2369008 2369008 2022-04-02 Windham Vermont 50025 6633 35
2365755 2365755 2022-04-01 Windham Vermont 50025 6633 35
2362502 2362502 2022-03-31 Windham Vermont 50025 6630 35
2359248 2359248 2022-03-30 Windham Vermont 50025 6624 35
2355994 2355994 2022-03-29 Windham Vermont 50025 6619 35
2352741 2352741 2022-03-28 Windham Vermont 50025 6617 35
2349489 2349489 2022-03-27 Windham Vermont 50025 6612 35
2346236 2346236 2022-03-26 Windham Vermont 50025 6612 35
2342983 2342983 2022-03-25 Windham Vermont 50025 6612 35
2339730 2339730 2022-03-24 Windham Vermont 50025 6607 35
2336476 2336476 2022-03-23 Windham Vermont 50025 6597 35
2333222 2333222 2022-03-22 Windham Vermont 50025 6588 35
2329969 2329969 2022-03-21 Windham Vermont 50025 6583 35
2326717 2326717 2022-03-20 Windham Vermont 50025 6566 35
2323464 2323464 2022-03-19 Windham Vermont 50025 6566 35
2320210 2320210 2022-03-18 Windham Vermont 50025 6566 35
2316956 2316956 2022-03-17 Windham Vermont 50025 6562 35
2313703 2313703 2022-03-16 Windham Vermont 50025 6556 35
2310450 2310450 2022-03-15 Windham Vermont 50025 6549 34
2307197 2307197 2022-03-14 Windham Vermont 50025 6542 34
2303946 2303946 2022-03-13 Windham Vermont 50025 6530 34
2300694 2300694 2022-03-12 Windham Vermont 50025 6530 34
2297442 2297442 2022-03-11 Windham Vermont 50025 6530 34
2294190 2294190 2022-03-10 Windham Vermont 50025 6523 34
2290938 2290938 2022-03-09 Windham Vermont 50025 6518 34
2287686 2287686 2022-03-08 Windham Vermont 50025 6503 34
2284434 2284434 2022-03-07 Windham Vermont 50025 6501 34
2281182 2281182 2022-03-06 Windham Vermont 50025 6487 34
2277929 2277929 2022-03-05 Windham Vermont 50025 6487 34
2274676 2274676 2022-03-04 Windham Vermont 50025 6487 34
2271423 2271423 2022-03-03 Windham Vermont 50025 6484 34
2268171 2268171 2022-03-02 Windham Vermont 50025 6478 34
2264918 2264918 2022-03-01 Windham Vermont 50025 5560 34
2261668 2261668 2022-02-28 Windham Vermont 50025 5560 34
2258417 2258417 2022-02-27 Windham Vermont 50025 5449 34
2255166 2255166 2022-02-26 Windham Vermont 50025 5449 34
2251915 2251915 2022-02-25 Windham Vermont 50025 5449 34
2248664 2248664 2022-02-24 Windham Vermont 50025 5446 34
2245413 2245413 2022-02-23 Windham Vermont 50025 5438 34
2242162 2242162 2022-02-22 Windham Vermont 50025 5433 33
2238911 2238911 2022-02-21 Windham Vermont 50025 5419 33
2235660 2235660 2022-02-20 Windham Vermont 50025 5419 33
2232409 2232409 2022-02-19 Windham Vermont 50025 5419 33
2229158 2229158 2022-02-18 Windham Vermont 50025 5419 33
2225907 2225907 2022-02-17 Windham Vermont 50025 5412 33
2222656 2222656 2022-02-16 Windham Vermont 50025 5405 33
2219405 2219405 2022-02-15 Windham Vermont 50025 5401 33
2216154 2216154 2022-02-14 Windham Vermont 50025 5400 33
2212903 2212903 2022-02-13 Windham Vermont 50025 5380 33
2209650 2209650 2022-02-12 Windham Vermont 50025 5380 33
2206397 2206397 2022-02-11 Windham Vermont 50025 5380 33
2203144 2203144 2022-02-10 Windham Vermont 50025 5375 33
2199890 2199890 2022-02-09 Windham Vermont 50025 5361 33
2196636 2196636 2022-02-08 Windham Vermont 50025 5356 33
2193382 2193382 2022-02-07 Windham Vermont 50025 5351 33
2190129 2190129 2022-02-06 Windham Vermont 50025 5324 33
2186876 2186876 2022-02-05 Windham Vermont 50025 5324 33
2183623 2183623 2022-02-04 Windham Vermont 50025 5324 33
2180371 2180371 2022-02-03 Windham Vermont 50025 5307 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);