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

1,570 rows where county = "Windham" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 2

fips 2

county 1

  • Windham · 1,570 ✖
Link rowid date ▲ county state fips cases deaths
2499892 2499892 2022-05-13 Windham Connecticut 9015 26643 305
2502505 2502505 2022-05-13 Windham Vermont 50025 6994 36
2496634 2496634 2022-05-12 Windham Connecticut 9015 26594 305
2499247 2499247 2022-05-12 Windham Vermont 50025 6974 36
2493376 2493376 2022-05-11 Windham Connecticut 9015 26526 305
2495989 2495989 2022-05-11 Windham Vermont 50025 6942 36
2490118 2490118 2022-05-10 Windham Connecticut 9015 26461 305
2492731 2492731 2022-05-10 Windham Vermont 50025 6921 36
2486861 2486861 2022-05-09 Windham Connecticut 9015 26410 304
2489473 2489473 2022-05-09 Windham Vermont 50025 6907 36
2483603 2483603 2022-05-08 Windham Connecticut 9015 26298 304
2486215 2486215 2022-05-08 Windham Vermont 50025 6847 36
2480345 2480345 2022-05-07 Windham Connecticut 9015 26298 304
2482957 2482957 2022-05-07 Windham Vermont 50025 6847 36
2477087 2477087 2022-05-06 Windham Connecticut 9015 26298 304
2479699 2479699 2022-05-06 Windham Vermont 50025 6847 36
2473829 2473829 2022-05-05 Windham Connecticut 9015 26269 304
2476441 2476441 2022-05-05 Windham Vermont 50025 6826 36
2470572 2470572 2022-05-04 Windham Connecticut 9015 26234 304
2473184 2473184 2022-05-04 Windham Vermont 50025 6800 36
2467316 2467316 2022-05-03 Windham Connecticut 9015 26195 304
2469928 2469928 2022-05-03 Windham Vermont 50025 6774 36
2464061 2464061 2022-05-02 Windham Connecticut 9015 26157 303
2466672 2466672 2022-05-02 Windham Vermont 50025 6762 36
2460805 2460805 2022-05-01 Windham Connecticut 9015 26099 303
2463417 2463417 2022-05-01 Windham Vermont 50025 6737 36
2457549 2457549 2022-04-30 Windham Connecticut 9015 26099 303
2460161 2460161 2022-04-30 Windham Vermont 50025 6737 36
2454293 2454293 2022-04-29 Windham Connecticut 9015 26099 303
2456905 2456905 2022-04-29 Windham Vermont 50025 6737 36
2451037 2451037 2022-04-28 Windham Connecticut 9015 26072 302
2453649 2453649 2022-04-28 Windham Vermont 50025 6731 36
2447781 2447781 2022-04-27 Windham Connecticut 9015 26039 302
2450393 2450393 2022-04-27 Windham Vermont 50025 6839 35
2444525 2444525 2022-04-26 Windham Connecticut 9015 26009 302
2447136 2447136 2022-04-26 Windham Vermont 50025 6839 35
2441269 2441269 2022-04-25 Windham Connecticut 9015 25976 302
2443881 2443881 2022-04-25 Windham Vermont 50025 6839 35
2438013 2438013 2022-04-24 Windham Connecticut 9015 25934 302
2440625 2440625 2022-04-24 Windham Vermont 50025 6795 35
2434757 2434757 2022-04-23 Windham Connecticut 9015 25934 302
2437369 2437369 2022-04-23 Windham Vermont 50025 6795 35
2431501 2431501 2022-04-22 Windham Connecticut 9015 25934 302
2434113 2434113 2022-04-22 Windham Vermont 50025 6795 35
2428245 2428245 2022-04-21 Windham Connecticut 9015 25903 302
2430857 2430857 2022-04-21 Windham Vermont 50025 6787 35
2424989 2424989 2022-04-20 Windham Connecticut 9015 25885 301
2427601 2427601 2022-04-20 Windham Vermont 50025 6770 35
2421733 2421733 2022-04-19 Windham Connecticut 9015 25870 301
2424345 2424345 2022-04-19 Windham Vermont 50025 6762 35
2418477 2418477 2022-04-18 Windham Connecticut 9015 25858 301
2421089 2421089 2022-04-18 Windham Vermont 50025 6759 35
2415221 2415221 2022-04-17 Windham Connecticut 9015 25813 301
2417833 2417833 2022-04-17 Windham Vermont 50025 6730 35
2411965 2411965 2022-04-16 Windham Connecticut 9015 25813 301
2414577 2414577 2022-04-16 Windham Vermont 50025 6730 35
2408709 2408709 2022-04-15 Windham Connecticut 9015 25813 301
2411321 2411321 2022-04-15 Windham Vermont 50025 6730 35
2405453 2405453 2022-04-14 Windham Connecticut 9015 25784 301
2408065 2408065 2022-04-14 Windham Vermont 50025 6721 35
2402198 2402198 2022-04-13 Windham Connecticut 9015 25777 301
2404809 2404809 2022-04-13 Windham Vermont 50025 6699 35
2398943 2398943 2022-04-12 Windham Connecticut 9015 25771 301
2401554 2401554 2022-04-12 Windham Vermont 50025 6691 35
2395688 2395688 2022-04-11 Windham Connecticut 9015 25753 301
2398299 2398299 2022-04-11 Windham Vermont 50025 6687 35
2392432 2392432 2022-04-10 Windham Connecticut 9015 25707 301
2395044 2395044 2022-04-10 Windham Vermont 50025 6673 35
2389176 2389176 2022-04-09 Windham Connecticut 9015 25707 301
2391788 2391788 2022-04-09 Windham Vermont 50025 6673 35
2385921 2385921 2022-04-08 Windham Connecticut 9015 25707 301
2388532 2388532 2022-04-08 Windham Vermont 50025 6673 35
2382666 2382666 2022-04-07 Windham Connecticut 9015 25691 301
2385277 2385277 2022-04-07 Windham Vermont 50025 6663 35
2379411 2379411 2022-04-06 Windham Connecticut 9015 25674 301
2382022 2382022 2022-04-06 Windham Vermont 50025 6652 35
2376157 2376157 2022-04-05 Windham Connecticut 9015 25664 301
2378767 2378767 2022-04-05 Windham Vermont 50025 6643 35
2372905 2372905 2022-04-04 Windham Connecticut 9015 25654 301
2375513 2375513 2022-04-04 Windham Vermont 50025 6639 35
2369652 2369652 2022-04-03 Windham Connecticut 9015 25619 301
2372261 2372261 2022-04-03 Windham Vermont 50025 6633 35
2366399 2366399 2022-04-02 Windham Connecticut 9015 25619 301
2369008 2369008 2022-04-02 Windham Vermont 50025 6633 35
2363146 2363146 2022-04-01 Windham Connecticut 9015 25619 301
2365755 2365755 2022-04-01 Windham Vermont 50025 6633 35
2359892 2359892 2022-03-31 Windham Connecticut 9015 25602 300
2362502 2362502 2022-03-31 Windham Vermont 50025 6630 35
2356638 2356638 2022-03-30 Windham Connecticut 9015 25584 300
2359248 2359248 2022-03-30 Windham Vermont 50025 6624 35
2353385 2353385 2022-03-29 Windham Connecticut 9015 25577 300
2355994 2355994 2022-03-29 Windham Vermont 50025 6619 35
2350133 2350133 2022-03-28 Windham Connecticut 9015 25572 298
2352741 2352741 2022-03-28 Windham Vermont 50025 6617 35
2346880 2346880 2022-03-27 Windham Connecticut 9015 25552 298
2349489 2349489 2022-03-27 Windham Vermont 50025 6612 35
2343627 2343627 2022-03-26 Windham Connecticut 9015 25552 298
2346236 2346236 2022-03-26 Windham Vermont 50025 6612 35
2340374 2340374 2022-03-25 Windham Connecticut 9015 25552 298
2342983 2342983 2022-03-25 Windham Vermont 50025 6612 35

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