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 = "Tolland" 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

county 1

  • Tolland · 786 ✖
Link rowid date ▲ county state fips cases deaths
2499890 2499890 2022-05-13 Tolland Connecticut 9013 21898 275
2496632 2496632 2022-05-12 Tolland Connecticut 9013 21840 274
2493374 2493374 2022-05-11 Tolland Connecticut 9013 21774 274
2490116 2490116 2022-05-10 Tolland Connecticut 9013 21691 274
2486859 2486859 2022-05-09 Tolland Connecticut 9013 21625 274
2483601 2483601 2022-05-08 Tolland Connecticut 9013 21484 274
2480343 2480343 2022-05-07 Tolland Connecticut 9013 21484 274
2477085 2477085 2022-05-06 Tolland Connecticut 9013 21484 274
2473827 2473827 2022-05-05 Tolland Connecticut 9013 21405 274
2470570 2470570 2022-05-04 Tolland Connecticut 9013 21361 274
2467314 2467314 2022-05-03 Tolland Connecticut 9013 21321 274
2464059 2464059 2022-05-02 Tolland Connecticut 9013 21248 274
2460803 2460803 2022-05-01 Tolland Connecticut 9013 21198 274
2457547 2457547 2022-04-30 Tolland Connecticut 9013 21198 274
2454291 2454291 2022-04-29 Tolland Connecticut 9013 21198 274
2451035 2451035 2022-04-28 Tolland Connecticut 9013 21167 274
2447779 2447779 2022-04-27 Tolland Connecticut 9013 21127 274
2444523 2444523 2022-04-26 Tolland Connecticut 9013 21087 274
2441267 2441267 2022-04-25 Tolland Connecticut 9013 21051 274
2438011 2438011 2022-04-24 Tolland Connecticut 9013 20979 274
2434755 2434755 2022-04-23 Tolland Connecticut 9013 20979 274
2431499 2431499 2022-04-22 Tolland Connecticut 9013 20979 274
2428243 2428243 2022-04-21 Tolland Connecticut 9013 20932 272
2424987 2424987 2022-04-20 Tolland Connecticut 9013 20911 272
2421731 2421731 2022-04-19 Tolland Connecticut 9013 20878 272
2418475 2418475 2022-04-18 Tolland Connecticut 9013 20831 272
2415219 2415219 2022-04-17 Tolland Connecticut 9013 20777 272
2411963 2411963 2022-04-16 Tolland Connecticut 9013 20777 272
2408707 2408707 2022-04-15 Tolland Connecticut 9013 20777 272
2405451 2405451 2022-04-14 Tolland Connecticut 9013 20720 272
2402196 2402196 2022-04-13 Tolland Connecticut 9013 20716 272
2398941 2398941 2022-04-12 Tolland Connecticut 9013 20699 272
2395686 2395686 2022-04-11 Tolland Connecticut 9013 20665 270
2392430 2392430 2022-04-10 Tolland Connecticut 9013 20608 269
2389174 2389174 2022-04-09 Tolland Connecticut 9013 20608 269
2385919 2385919 2022-04-08 Tolland Connecticut 9013 20608 269
2382664 2382664 2022-04-07 Tolland Connecticut 9013 20562 269
2379409 2379409 2022-04-06 Tolland Connecticut 9013 20535 269
2376155 2376155 2022-04-05 Tolland Connecticut 9013 20524 270
2372903 2372903 2022-04-04 Tolland Connecticut 9013 20507 270
2369650 2369650 2022-04-03 Tolland Connecticut 9013 20463 270
2366397 2366397 2022-04-02 Tolland Connecticut 9013 20463 270
2363144 2363144 2022-04-01 Tolland Connecticut 9013 20463 270
2359890 2359890 2022-03-31 Tolland Connecticut 9013 20439 270
2356636 2356636 2022-03-30 Tolland Connecticut 9013 20419 269
2353383 2353383 2022-03-29 Tolland Connecticut 9013 20402 269
2350131 2350131 2022-03-28 Tolland Connecticut 9013 20389 269
2346878 2346878 2022-03-27 Tolland Connecticut 9013 20353 269
2343625 2343625 2022-03-26 Tolland Connecticut 9013 20353 269
2340372 2340372 2022-03-25 Tolland Connecticut 9013 20353 269
2337119 2337119 2022-03-24 Tolland Connecticut 9013 20334 268
2333865 2333865 2022-03-23 Tolland Connecticut 9013 20323 268
2330611 2330611 2022-03-22 Tolland Connecticut 9013 20310 268
2327359 2327359 2022-03-21 Tolland Connecticut 9013 20294 268
2324106 2324106 2022-03-20 Tolland Connecticut 9013 20284 268
2320852 2320852 2022-03-19 Tolland Connecticut 9013 20284 268
2317598 2317598 2022-03-18 Tolland Connecticut 9013 20284 268
2314345 2314345 2022-03-17 Tolland Connecticut 9013 20270 266
2311092 2311092 2022-03-16 Tolland Connecticut 9013 20250 266
2307839 2307839 2022-03-15 Tolland Connecticut 9013 20244 266
2304588 2304588 2022-03-14 Tolland Connecticut 9013 20227 266
2301336 2301336 2022-03-13 Tolland Connecticut 9013 20209 266
2298084 2298084 2022-03-12 Tolland Connecticut 9013 20209 266
2294832 2294832 2022-03-11 Tolland Connecticut 9013 20209 266
2291580 2291580 2022-03-10 Tolland Connecticut 9013 20203 264
2288328 2288328 2022-03-09 Tolland Connecticut 9013 20196 264
2285077 2285077 2022-03-08 Tolland Connecticut 9013 20189 264
2281825 2281825 2022-03-07 Tolland Connecticut 9013 20175 263
2278572 2278572 2022-03-06 Tolland Connecticut 9013 20158 263
2275319 2275319 2022-03-05 Tolland Connecticut 9013 20158 263
2272066 2272066 2022-03-04 Tolland Connecticut 9013 20158 263
2268814 2268814 2022-03-03 Tolland Connecticut 9013 20145 263
2265561 2265561 2022-03-02 Tolland Connecticut 9013 20144 263
2262310 2262310 2022-03-01 Tolland Connecticut 9013 20131 260
2259059 2259059 2022-02-28 Tolland Connecticut 9013 20127 260
2255808 2255808 2022-02-27 Tolland Connecticut 9013 20103 260
2252557 2252557 2022-02-26 Tolland Connecticut 9013 20103 260
2249306 2249306 2022-02-25 Tolland Connecticut 9013 20103 260
2246055 2246055 2022-02-24 Tolland Connecticut 9013 20082 259
2242804 2242804 2022-02-23 Tolland Connecticut 9013 20060 259
2239553 2239553 2022-02-22 Tolland Connecticut 9013 20036 259
2236302 2236302 2022-02-21 Tolland Connecticut 9013 20019 259
2233051 2233051 2022-02-20 Tolland Connecticut 9013 19967 259
2229800 2229800 2022-02-19 Tolland Connecticut 9013 19967 259
2226549 2226549 2022-02-18 Tolland Connecticut 9013 19967 259
2223298 2223298 2022-02-17 Tolland Connecticut 9013 19914 259
2220047 2220047 2022-02-16 Tolland Connecticut 9013 19901 259
2216796 2216796 2022-02-15 Tolland Connecticut 9013 19863 258
2213545 2213545 2022-02-14 Tolland Connecticut 9013 19832 257
2210293 2210293 2022-02-13 Tolland Connecticut 9013 19770 257
2207040 2207040 2022-02-12 Tolland Connecticut 9013 19770 257
2203787 2203787 2022-02-11 Tolland Connecticut 9013 19770 257
2200534 2200534 2022-02-10 Tolland Connecticut 9013 19722 257
2197280 2197280 2022-02-09 Tolland Connecticut 9013 19690 257
2194026 2194026 2022-02-08 Tolland Connecticut 9013 19647 254
2190772 2190772 2022-02-07 Tolland Connecticut 9013 19591 254
2187519 2187519 2022-02-06 Tolland Connecticut 9013 19537 254
2184266 2184266 2022-02-05 Tolland Connecticut 9013 19537 254
2181014 2181014 2022-02-04 Tolland Connecticut 9013 19537 254
2177763 2177763 2022-02-03 Tolland Connecticut 9013 19485 250

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