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

791 rows where fips = 50027 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 · 791 ✖

fips 1

  • 50027 · 791 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502506 2502506 2022-05-13 Windsor Vermont 50027 9638 52
2499248 2499248 2022-05-12 Windsor Vermont 50027 9619 52
2495990 2495990 2022-05-11 Windsor Vermont 50027 9564 52
2492732 2492732 2022-05-10 Windsor Vermont 50027 9542 52
2489474 2489474 2022-05-09 Windsor Vermont 50027 9531 51
2486216 2486216 2022-05-08 Windsor Vermont 50027 9471 51
2482958 2482958 2022-05-07 Windsor Vermont 50027 9471 51
2479700 2479700 2022-05-06 Windsor Vermont 50027 9471 51
2476442 2476442 2022-05-05 Windsor Vermont 50027 9442 51
2473185 2473185 2022-05-04 Windsor Vermont 50027 9419 51
2469929 2469929 2022-05-03 Windsor Vermont 50027 9376 51
2466673 2466673 2022-05-02 Windsor Vermont 50027 9354 51
2463418 2463418 2022-05-01 Windsor Vermont 50027 9278 51
2460162 2460162 2022-04-30 Windsor Vermont 50027 9278 51
2456906 2456906 2022-04-29 Windsor Vermont 50027 9278 51
2453650 2453650 2022-04-28 Windsor Vermont 50027 9252 51
2450394 2450394 2022-04-27 Windsor Vermont 50027 9035 51
2447137 2447137 2022-04-26 Windsor Vermont 50027 9035 51
2443882 2443882 2022-04-25 Windsor Vermont 50027 9035 51
2440626 2440626 2022-04-24 Windsor Vermont 50027 8988 51
2437370 2437370 2022-04-23 Windsor Vermont 50027 8988 51
2434114 2434114 2022-04-22 Windsor Vermont 50027 8988 51
2430858 2430858 2022-04-21 Windsor Vermont 50027 8970 51
2427602 2427602 2022-04-20 Windsor Vermont 50027 8943 51
2424346 2424346 2022-04-19 Windsor Vermont 50027 8932 51
2421090 2421090 2022-04-18 Windsor Vermont 50027 8928 50
2417834 2417834 2022-04-17 Windsor Vermont 50027 8871 50
2414578 2414578 2022-04-16 Windsor Vermont 50027 8871 50
2411322 2411322 2022-04-15 Windsor Vermont 50027 8871 50
2408066 2408066 2022-04-14 Windsor Vermont 50027 8856 50
2404810 2404810 2022-04-13 Windsor Vermont 50027 8834 50
2401555 2401555 2022-04-12 Windsor Vermont 50027 8824 50
2398300 2398300 2022-04-11 Windsor Vermont 50027 8816 50
2395045 2395045 2022-04-10 Windsor Vermont 50027 8792 50
2391789 2391789 2022-04-09 Windsor Vermont 50027 8792 50
2388533 2388533 2022-04-08 Windsor Vermont 50027 8792 50
2385278 2385278 2022-04-07 Windsor Vermont 50027 8779 50
2382023 2382023 2022-04-06 Windsor Vermont 50027 8762 50
2378768 2378768 2022-04-05 Windsor Vermont 50027 8755 50
2375514 2375514 2022-04-04 Windsor Vermont 50027 8752 50
2372262 2372262 2022-04-03 Windsor Vermont 50027 8726 50
2369009 2369009 2022-04-02 Windsor Vermont 50027 8726 50
2365756 2365756 2022-04-01 Windsor Vermont 50027 8726 50
2362503 2362503 2022-03-31 Windsor Vermont 50027 8721 50
2359249 2359249 2022-03-30 Windsor Vermont 50027 8710 50
2355995 2355995 2022-03-29 Windsor Vermont 50027 8695 50
2352742 2352742 2022-03-28 Windsor Vermont 50027 8690 50
2349490 2349490 2022-03-27 Windsor Vermont 50027 8656 50
2346237 2346237 2022-03-26 Windsor Vermont 50027 8656 50
2342984 2342984 2022-03-25 Windsor Vermont 50027 8656 50
2339731 2339731 2022-03-24 Windsor Vermont 50027 8639 50
2336477 2336477 2022-03-23 Windsor Vermont 50027 8631 50
2333223 2333223 2022-03-22 Windsor Vermont 50027 8621 50
2329970 2329970 2022-03-21 Windsor Vermont 50027 8618 50
2326718 2326718 2022-03-20 Windsor Vermont 50027 8580 50
2323465 2323465 2022-03-19 Windsor Vermont 50027 8580 50
2320211 2320211 2022-03-18 Windsor Vermont 50027 8580 50
2316957 2316957 2022-03-17 Windsor Vermont 50027 8548 50
2313704 2313704 2022-03-16 Windsor Vermont 50027 8520 50
2310451 2310451 2022-03-15 Windsor Vermont 50027 8470 50
2307198 2307198 2022-03-14 Windsor Vermont 50027 8467 50
2303947 2303947 2022-03-13 Windsor Vermont 50027 8448 50
2300695 2300695 2022-03-12 Windsor Vermont 50027 8448 50
2297443 2297443 2022-03-11 Windsor Vermont 50027 8448 50
2294191 2294191 2022-03-10 Windsor Vermont 50027 8413 50
2290939 2290939 2022-03-09 Windsor Vermont 50027 8403 50
2287687 2287687 2022-03-08 Windsor Vermont 50027 8396 50
2284435 2284435 2022-03-07 Windsor Vermont 50027 8393 50
2281183 2281183 2022-03-06 Windsor Vermont 50027 8369 50
2277930 2277930 2022-03-05 Windsor Vermont 50027 8369 50
2274677 2274677 2022-03-04 Windsor Vermont 50027 8369 50
2271424 2271424 2022-03-03 Windsor Vermont 50027 8357 49
2268172 2268172 2022-03-02 Windsor Vermont 50027 8346 49
2264919 2264919 2022-03-01 Windsor Vermont 50027 7385 49
2261669 2261669 2022-02-28 Windsor Vermont 50027 7385 49
2258418 2258418 2022-02-27 Windsor Vermont 50027 7242 49
2255167 2255167 2022-02-26 Windsor Vermont 50027 7242 49
2251916 2251916 2022-02-25 Windsor Vermont 50027 7242 49
2248665 2248665 2022-02-24 Windsor Vermont 50027 7206 49
2245414 2245414 2022-02-23 Windsor Vermont 50027 7190 49
2242163 2242163 2022-02-22 Windsor Vermont 50027 7183 47
2238912 2238912 2022-02-21 Windsor Vermont 50027 7149 47
2235661 2235661 2022-02-20 Windsor Vermont 50027 7149 47
2232410 2232410 2022-02-19 Windsor Vermont 50027 7149 47
2229159 2229159 2022-02-18 Windsor Vermont 50027 7149 47
2225908 2225908 2022-02-17 Windsor Vermont 50027 7134 47
2222657 2222657 2022-02-16 Windsor Vermont 50027 7104 47
2219406 2219406 2022-02-15 Windsor Vermont 50027 7093 47
2216155 2216155 2022-02-14 Windsor Vermont 50027 7090 47
2212904 2212904 2022-02-13 Windsor Vermont 50027 7059 47
2209651 2209651 2022-02-12 Windsor Vermont 50027 7059 47
2206398 2206398 2022-02-11 Windsor Vermont 50027 7059 47
2203145 2203145 2022-02-10 Windsor Vermont 50027 7048 47
2199891 2199891 2022-02-09 Windsor Vermont 50027 7035 47
2196637 2196637 2022-02-08 Windsor Vermont 50027 7017 47
2193383 2193383 2022-02-07 Windsor Vermont 50027 7010 47
2190130 2190130 2022-02-06 Windsor Vermont 50027 6979 47
2186877 2186877 2022-02-05 Windsor Vermont 50027 6979 47
2183624 2183624 2022-02-04 Windsor Vermont 50027 6979 47
2180372 2180372 2022-02-03 Windsor Vermont 50027 6958 47

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