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

798 rows where county = "Bennington" 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 · 798 ✖

fips 1

county 1

  • Bennington · 798 ✖
Link rowid date ▲ county state fips cases deaths
2502493 2502493 2022-05-13 Bennington Vermont 50003 10153 71
2499235 2499235 2022-05-12 Bennington Vermont 50003 10107 71
2495977 2495977 2022-05-11 Bennington Vermont 50003 10078 71
2492719 2492719 2022-05-10 Bennington Vermont 50003 10038 71
2489461 2489461 2022-05-09 Bennington Vermont 50003 10015 70
2486203 2486203 2022-05-08 Bennington Vermont 50003 9954 70
2482945 2482945 2022-05-07 Bennington Vermont 50003 9954 70
2479687 2479687 2022-05-06 Bennington Vermont 50003 9954 70
2476429 2476429 2022-05-05 Bennington Vermont 50003 9931 70
2473172 2473172 2022-05-04 Bennington Vermont 50003 9906 70
2469916 2469916 2022-05-03 Bennington Vermont 50003 9869 70
2466660 2466660 2022-05-02 Bennington Vermont 50003 9840 70
2463405 2463405 2022-05-01 Bennington Vermont 50003 9798 70
2460149 2460149 2022-04-30 Bennington Vermont 50003 9798 70
2456893 2456893 2022-04-29 Bennington Vermont 50003 9798 70
2453637 2453637 2022-04-28 Bennington Vermont 50003 9774 70
2450381 2450381 2022-04-27 Bennington Vermont 50003 9700 69
2447124 2447124 2022-04-26 Bennington Vermont 50003 9700 69
2443869 2443869 2022-04-25 Bennington Vermont 50003 9700 69
2440613 2440613 2022-04-24 Bennington Vermont 50003 9644 69
2437357 2437357 2022-04-23 Bennington Vermont 50003 9644 69
2434101 2434101 2022-04-22 Bennington Vermont 50003 9644 69
2430845 2430845 2022-04-21 Bennington Vermont 50003 9603 69
2427589 2427589 2022-04-20 Bennington Vermont 50003 9589 69
2424333 2424333 2022-04-19 Bennington Vermont 50003 9568 69
2421077 2421077 2022-04-18 Bennington Vermont 50003 9551 69
2417821 2417821 2022-04-17 Bennington Vermont 50003 9524 69
2414565 2414565 2022-04-16 Bennington Vermont 50003 9524 69
2411309 2411309 2022-04-15 Bennington Vermont 50003 9524 69
2408053 2408053 2022-04-14 Bennington Vermont 50003 9512 69
2404797 2404797 2022-04-13 Bennington Vermont 50003 9500 69
2401542 2401542 2022-04-12 Bennington Vermont 50003 9488 69
2398287 2398287 2022-04-11 Bennington Vermont 50003 9480 69
2395032 2395032 2022-04-10 Bennington Vermont 50003 9468 68
2391776 2391776 2022-04-09 Bennington Vermont 50003 9468 68
2388520 2388520 2022-04-08 Bennington Vermont 50003 9468 68
2385265 2385265 2022-04-07 Bennington Vermont 50003 9459 68
2382010 2382010 2022-04-06 Bennington Vermont 50003 9451 67
2378755 2378755 2022-04-05 Bennington Vermont 50003 9444 67
2375501 2375501 2022-04-04 Bennington Vermont 50003 9440 66
2372249 2372249 2022-04-03 Bennington Vermont 50003 9430 66
2368996 2368996 2022-04-02 Bennington Vermont 50003 9430 66
2365743 2365743 2022-04-01 Bennington Vermont 50003 9430 66
2362490 2362490 2022-03-31 Bennington Vermont 50003 9424 66
2359236 2359236 2022-03-30 Bennington Vermont 50003 9416 66
2355982 2355982 2022-03-29 Bennington Vermont 50003 9410 66
2352729 2352729 2022-03-28 Bennington Vermont 50003 9408 66
2349477 2349477 2022-03-27 Bennington Vermont 50003 9400 66
2346224 2346224 2022-03-26 Bennington Vermont 50003 9400 66
2342971 2342971 2022-03-25 Bennington Vermont 50003 9400 66
2339718 2339718 2022-03-24 Bennington Vermont 50003 9396 66
2336464 2336464 2022-03-23 Bennington Vermont 50003 9395 66
2333210 2333210 2022-03-22 Bennington Vermont 50003 9391 65
2329957 2329957 2022-03-21 Bennington Vermont 50003 9388 65
2326705 2326705 2022-03-20 Bennington Vermont 50003 9382 65
2323452 2323452 2022-03-19 Bennington Vermont 50003 9382 65
2320198 2320198 2022-03-18 Bennington Vermont 50003 9382 65
2316944 2316944 2022-03-17 Bennington Vermont 50003 9379 65
2313691 2313691 2022-03-16 Bennington Vermont 50003 9377 65
2310438 2310438 2022-03-15 Bennington Vermont 50003 9376 65
2307185 2307185 2022-03-14 Bennington Vermont 50003 9370 65
2303934 2303934 2022-03-13 Bennington Vermont 50003 9365 65
2300682 2300682 2022-03-12 Bennington Vermont 50003 9365 65
2297430 2297430 2022-03-11 Bennington Vermont 50003 9365 65
2294178 2294178 2022-03-10 Bennington Vermont 50003 9362 65
2290926 2290926 2022-03-09 Bennington Vermont 50003 9355 65
2287674 2287674 2022-03-08 Bennington Vermont 50003 9348 65
2284422 2284422 2022-03-07 Bennington Vermont 50003 9341 65
2281170 2281170 2022-03-06 Bennington Vermont 50003 9328 65
2277917 2277917 2022-03-05 Bennington Vermont 50003 9328 65
2274664 2274664 2022-03-04 Bennington Vermont 50003 9328 65
2271411 2271411 2022-03-03 Bennington Vermont 50003 9326 65
2268159 2268159 2022-03-02 Bennington Vermont 50003 9318 65
2264906 2264906 2022-03-01 Bennington Vermont 50003 8953 64
2261656 2261656 2022-02-28 Bennington Vermont 50003 8953 64
2258405 2258405 2022-02-27 Bennington Vermont 50003 8456 62
2255154 2255154 2022-02-26 Bennington Vermont 50003 8456 62
2251903 2251903 2022-02-25 Bennington Vermont 50003 8456 62
2248652 2248652 2022-02-24 Bennington Vermont 50003 8448 60
2245401 2245401 2022-02-23 Bennington Vermont 50003 8427 60
2242150 2242150 2022-02-22 Bennington Vermont 50003 8410 60
2238899 2238899 2022-02-21 Bennington Vermont 50003 8381 60
2235648 2235648 2022-02-20 Bennington Vermont 50003 8381 60
2232397 2232397 2022-02-19 Bennington Vermont 50003 8381 60
2229146 2229146 2022-02-18 Bennington Vermont 50003 8381 60
2225895 2225895 2022-02-17 Bennington Vermont 50003 8362 60
2222644 2222644 2022-02-16 Bennington Vermont 50003 8351 60
2219393 2219393 2022-02-15 Bennington Vermont 50003 8339 60
2216142 2216142 2022-02-14 Bennington Vermont 50003 8329 59
2212891 2212891 2022-02-13 Bennington Vermont 50003 8296 57
2209638 2209638 2022-02-12 Bennington Vermont 50003 8296 57
2206385 2206385 2022-02-11 Bennington Vermont 50003 8296 57
2203132 2203132 2022-02-10 Bennington Vermont 50003 8284 57
2199878 2199878 2022-02-09 Bennington Vermont 50003 8262 57
2196624 2196624 2022-02-08 Bennington Vermont 50003 8233 57
2193370 2193370 2022-02-07 Bennington Vermont 50003 8202 57
2190117 2190117 2022-02-06 Bennington Vermont 50003 8169 57
2186864 2186864 2022-02-05 Bennington Vermont 50003 8169 57
2183611 2183611 2022-02-04 Bennington Vermont 50003 8169 57
2180359 2180359 2022-02-03 Bennington Vermont 50003 8128 56

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