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

786 rows where county = "Windham", fips = 9015 and state = "Connecticut" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Connecticut · 786 ✖

fips 1

  • 9015 · 786 ✖

county 1

  • Windham · 786 ✖
Link rowid date ▲ county state fips cases deaths
2499892 2499892 2022-05-13 Windham Connecticut 9015 26643 305
2496634 2496634 2022-05-12 Windham Connecticut 9015 26594 305
2493376 2493376 2022-05-11 Windham Connecticut 9015 26526 305
2490118 2490118 2022-05-10 Windham Connecticut 9015 26461 305
2486861 2486861 2022-05-09 Windham Connecticut 9015 26410 304
2483603 2483603 2022-05-08 Windham Connecticut 9015 26298 304
2480345 2480345 2022-05-07 Windham Connecticut 9015 26298 304
2477087 2477087 2022-05-06 Windham Connecticut 9015 26298 304
2473829 2473829 2022-05-05 Windham Connecticut 9015 26269 304
2470572 2470572 2022-05-04 Windham Connecticut 9015 26234 304
2467316 2467316 2022-05-03 Windham Connecticut 9015 26195 304
2464061 2464061 2022-05-02 Windham Connecticut 9015 26157 303
2460805 2460805 2022-05-01 Windham Connecticut 9015 26099 303
2457549 2457549 2022-04-30 Windham Connecticut 9015 26099 303
2454293 2454293 2022-04-29 Windham Connecticut 9015 26099 303
2451037 2451037 2022-04-28 Windham Connecticut 9015 26072 302
2447781 2447781 2022-04-27 Windham Connecticut 9015 26039 302
2444525 2444525 2022-04-26 Windham Connecticut 9015 26009 302
2441269 2441269 2022-04-25 Windham Connecticut 9015 25976 302
2438013 2438013 2022-04-24 Windham Connecticut 9015 25934 302
2434757 2434757 2022-04-23 Windham Connecticut 9015 25934 302
2431501 2431501 2022-04-22 Windham Connecticut 9015 25934 302
2428245 2428245 2022-04-21 Windham Connecticut 9015 25903 302
2424989 2424989 2022-04-20 Windham Connecticut 9015 25885 301
2421733 2421733 2022-04-19 Windham Connecticut 9015 25870 301
2418477 2418477 2022-04-18 Windham Connecticut 9015 25858 301
2415221 2415221 2022-04-17 Windham Connecticut 9015 25813 301
2411965 2411965 2022-04-16 Windham Connecticut 9015 25813 301
2408709 2408709 2022-04-15 Windham Connecticut 9015 25813 301
2405453 2405453 2022-04-14 Windham Connecticut 9015 25784 301
2402198 2402198 2022-04-13 Windham Connecticut 9015 25777 301
2398943 2398943 2022-04-12 Windham Connecticut 9015 25771 301
2395688 2395688 2022-04-11 Windham Connecticut 9015 25753 301
2392432 2392432 2022-04-10 Windham Connecticut 9015 25707 301
2389176 2389176 2022-04-09 Windham Connecticut 9015 25707 301
2385921 2385921 2022-04-08 Windham Connecticut 9015 25707 301
2382666 2382666 2022-04-07 Windham Connecticut 9015 25691 301
2379411 2379411 2022-04-06 Windham Connecticut 9015 25674 301
2376157 2376157 2022-04-05 Windham Connecticut 9015 25664 301
2372905 2372905 2022-04-04 Windham Connecticut 9015 25654 301
2369652 2369652 2022-04-03 Windham Connecticut 9015 25619 301
2366399 2366399 2022-04-02 Windham Connecticut 9015 25619 301
2363146 2363146 2022-04-01 Windham Connecticut 9015 25619 301
2359892 2359892 2022-03-31 Windham Connecticut 9015 25602 300
2356638 2356638 2022-03-30 Windham Connecticut 9015 25584 300
2353385 2353385 2022-03-29 Windham Connecticut 9015 25577 300
2350133 2350133 2022-03-28 Windham Connecticut 9015 25572 298
2346880 2346880 2022-03-27 Windham Connecticut 9015 25552 298
2343627 2343627 2022-03-26 Windham Connecticut 9015 25552 298
2340374 2340374 2022-03-25 Windham Connecticut 9015 25552 298
2337121 2337121 2022-03-24 Windham Connecticut 9015 25543 297
2333867 2333867 2022-03-23 Windham Connecticut 9015 25535 297
2330613 2330613 2022-03-22 Windham Connecticut 9015 25520 297
2327361 2327361 2022-03-21 Windham Connecticut 9015 25511 296
2324108 2324108 2022-03-20 Windham Connecticut 9015 25496 296
2320854 2320854 2022-03-19 Windham Connecticut 9015 25496 296
2317600 2317600 2022-03-18 Windham Connecticut 9015 25496 296
2314347 2314347 2022-03-17 Windham Connecticut 9015 25492 296
2311094 2311094 2022-03-16 Windham Connecticut 9015 25484 296
2307841 2307841 2022-03-15 Windham Connecticut 9015 25479 296
2304590 2304590 2022-03-14 Windham Connecticut 9015 25476 295
2301338 2301338 2022-03-13 Windham Connecticut 9015 25458 295
2298086 2298086 2022-03-12 Windham Connecticut 9015 25458 295
2294834 2294834 2022-03-11 Windham Connecticut 9015 25458 295
2291582 2291582 2022-03-10 Windham Connecticut 9015 25456 294
2288330 2288330 2022-03-09 Windham Connecticut 9015 25443 294
2285079 2285079 2022-03-08 Windham Connecticut 9015 25443 294
2281827 2281827 2022-03-07 Windham Connecticut 9015 25430 292
2278574 2278574 2022-03-06 Windham Connecticut 9015 25407 292
2275321 2275321 2022-03-05 Windham Connecticut 9015 25407 292
2272068 2272068 2022-03-04 Windham Connecticut 9015 25407 292
2268816 2268816 2022-03-03 Windham Connecticut 9015 25393 292
2265563 2265563 2022-03-02 Windham Connecticut 9015 25387 292
2262312 2262312 2022-03-01 Windham Connecticut 9015 25383 290
2259061 2259061 2022-02-28 Windham Connecticut 9015 25377 290
2255810 2255810 2022-02-27 Windham Connecticut 9015 25349 290
2252559 2252559 2022-02-26 Windham Connecticut 9015 25349 290
2249308 2249308 2022-02-25 Windham Connecticut 9015 25349 290
2246057 2246057 2022-02-24 Windham Connecticut 9015 25329 290
2242806 2242806 2022-02-23 Windham Connecticut 9015 25319 290
2239555 2239555 2022-02-22 Windham Connecticut 9015 25302 287
2236304 2236304 2022-02-21 Windham Connecticut 9015 25289 287
2233053 2233053 2022-02-20 Windham Connecticut 9015 25254 287
2229802 2229802 2022-02-19 Windham Connecticut 9015 25254 287
2226551 2226551 2022-02-18 Windham Connecticut 9015 25254 287
2223300 2223300 2022-02-17 Windham Connecticut 9015 25213 286
2220049 2220049 2022-02-16 Windham Connecticut 9015 25206 286
2216798 2216798 2022-02-15 Windham Connecticut 9015 25179 285
2213547 2213547 2022-02-14 Windham Connecticut 9015 25147 283
2210295 2210295 2022-02-13 Windham Connecticut 9015 25070 283
2207042 2207042 2022-02-12 Windham Connecticut 9015 25070 283
2203789 2203789 2022-02-11 Windham Connecticut 9015 25070 283
2200536 2200536 2022-02-10 Windham Connecticut 9015 25026 282
2197282 2197282 2022-02-09 Windham Connecticut 9015 24974 281
2194028 2194028 2022-02-08 Windham Connecticut 9015 24943 280
2190774 2190774 2022-02-07 Windham Connecticut 9015 24880 280
2187521 2187521 2022-02-06 Windham Connecticut 9015 24790 280
2184268 2184268 2022-02-05 Windham Connecticut 9015 24790 280
2181016 2181016 2022-02-04 Windham Connecticut 9015 24790 280
2177765 2177765 2022-02-03 Windham Connecticut 9015 24740 276

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