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 county = "Washington" 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

county 1

  • Washington · 791 ✖
Link rowid date ▲ county state fips cases deaths
2502504 2502504 2022-05-13 Washington Vermont 50023 12430 51
2499246 2499246 2022-05-12 Washington Vermont 50023 12401 51
2495988 2495988 2022-05-11 Washington Vermont 50023 12309 51
2492730 2492730 2022-05-10 Washington Vermont 50023 12297 51
2489472 2489472 2022-05-09 Washington Vermont 50023 12270 51
2486214 2486214 2022-05-08 Washington Vermont 50023 12148 51
2482956 2482956 2022-05-07 Washington Vermont 50023 12148 51
2479698 2479698 2022-05-06 Washington Vermont 50023 12148 51
2476440 2476440 2022-05-05 Washington Vermont 50023 12114 51
2473183 2473183 2022-05-04 Washington Vermont 50023 12078 50
2469927 2469927 2022-05-03 Washington Vermont 50023 12005 50
2466671 2466671 2022-05-02 Washington Vermont 50023 11972 50
2463416 2463416 2022-05-01 Washington Vermont 50023 11893 50
2460160 2460160 2022-04-30 Washington Vermont 50023 11893 50
2456904 2456904 2022-04-29 Washington Vermont 50023 11893 50
2453648 2453648 2022-04-28 Washington Vermont 50023 11862 49
2450392 2450392 2022-04-27 Washington Vermont 50023 10580 47
2447135 2447135 2022-04-26 Washington Vermont 50023 10580 47
2443880 2443880 2022-04-25 Washington Vermont 50023 10580 47
2440624 2440624 2022-04-24 Washington Vermont 50023 10452 47
2437368 2437368 2022-04-23 Washington Vermont 50023 10452 47
2434112 2434112 2022-04-22 Washington Vermont 50023 10452 47
2430856 2430856 2022-04-21 Washington Vermont 50023 10408 47
2427600 2427600 2022-04-20 Washington Vermont 50023 10359 47
2424344 2424344 2022-04-19 Washington Vermont 50023 10286 47
2421088 2421088 2022-04-18 Washington Vermont 50023 10276 47
2417832 2417832 2022-04-17 Washington Vermont 50023 10176 47
2414576 2414576 2022-04-16 Washington Vermont 50023 10176 47
2411320 2411320 2022-04-15 Washington Vermont 50023 10176 47
2408064 2408064 2022-04-14 Washington Vermont 50023 10139 47
2404808 2404808 2022-04-13 Washington Vermont 50023 10105 47
2401553 2401553 2022-04-12 Washington Vermont 50023 10049 47
2398298 2398298 2022-04-11 Washington Vermont 50023 10015 47
2395043 2395043 2022-04-10 Washington Vermont 50023 9957 47
2391787 2391787 2022-04-09 Washington Vermont 50023 9957 47
2388531 2388531 2022-04-08 Washington Vermont 50023 9957 47
2385276 2385276 2022-04-07 Washington Vermont 50023 9930 47
2382021 2382021 2022-04-06 Washington Vermont 50023 9899 47
2378766 2378766 2022-04-05 Washington Vermont 50023 9857 47
2375512 2375512 2022-04-04 Washington Vermont 50023 9814 47
2372260 2372260 2022-04-03 Washington Vermont 50023 9750 47
2369007 2369007 2022-04-02 Washington Vermont 50023 9750 47
2365754 2365754 2022-04-01 Washington Vermont 50023 9750 47
2362501 2362501 2022-03-31 Washington Vermont 50023 9708 47
2359247 2359247 2022-03-30 Washington Vermont 50023 9689 47
2355993 2355993 2022-03-29 Washington Vermont 50023 9648 47
2352740 2352740 2022-03-28 Washington Vermont 50023 9618 47
2349488 2349488 2022-03-27 Washington Vermont 50023 9573 47
2346235 2346235 2022-03-26 Washington Vermont 50023 9573 47
2342982 2342982 2022-03-25 Washington Vermont 50023 9573 47
2339729 2339729 2022-03-24 Washington Vermont 50023 9555 47
2336475 2336475 2022-03-23 Washington Vermont 50023 9537 47
2333221 2333221 2022-03-22 Washington Vermont 50023 9516 47
2329968 2329968 2022-03-21 Washington Vermont 50023 9496 47
2326716 2326716 2022-03-20 Washington Vermont 50023 9445 47
2323463 2323463 2022-03-19 Washington Vermont 50023 9445 47
2320209 2320209 2022-03-18 Washington Vermont 50023 9445 47
2316955 2316955 2022-03-17 Washington Vermont 50023 9425 47
2313702 2313702 2022-03-16 Washington Vermont 50023 9406 46
2310449 2310449 2022-03-15 Washington Vermont 50023 9395 46
2307196 2307196 2022-03-14 Washington Vermont 50023 9385 46
2303945 2303945 2022-03-13 Washington Vermont 50023 9370 46
2300693 2300693 2022-03-12 Washington Vermont 50023 9370 46
2297441 2297441 2022-03-11 Washington Vermont 50023 9370 46
2294189 2294189 2022-03-10 Washington Vermont 50023 9359 46
2290937 2290937 2022-03-09 Washington Vermont 50023 9353 46
2287685 2287685 2022-03-08 Washington Vermont 50023 9345 46
2284433 2284433 2022-03-07 Washington Vermont 50023 9339 46
2281181 2281181 2022-03-06 Washington Vermont 50023 9308 46
2277928 2277928 2022-03-05 Washington Vermont 50023 9308 46
2274675 2274675 2022-03-04 Washington Vermont 50023 9308 46
2271422 2271422 2022-03-03 Washington Vermont 50023 9292 46
2268170 2268170 2022-03-02 Washington Vermont 50023 9281 46
2264917 2264917 2022-03-01 Washington Vermont 50023 8570 44
2261667 2261667 2022-02-28 Washington Vermont 50023 8570 44
2258416 2258416 2022-02-27 Washington Vermont 50023 8484 44
2255165 2255165 2022-02-26 Washington Vermont 50023 8484 44
2251914 2251914 2022-02-25 Washington Vermont 50023 8484 44
2248663 2248663 2022-02-24 Washington Vermont 50023 8472 44
2245412 2245412 2022-02-23 Washington Vermont 50023 8449 44
2242161 2242161 2022-02-22 Washington Vermont 50023 8427 44
2238910 2238910 2022-02-21 Washington Vermont 50023 8342 44
2235659 2235659 2022-02-20 Washington Vermont 50023 8342 44
2232408 2232408 2022-02-19 Washington Vermont 50023 8342 44
2229157 2229157 2022-02-18 Washington Vermont 50023 8342 44
2225906 2225906 2022-02-17 Washington Vermont 50023 8315 44
2222655 2222655 2022-02-16 Washington Vermont 50023 8262 44
2219404 2219404 2022-02-15 Washington Vermont 50023 8229 44
2216153 2216153 2022-02-14 Washington Vermont 50023 8208 44
2212902 2212902 2022-02-13 Washington Vermont 50023 8170 44
2209649 2209649 2022-02-12 Washington Vermont 50023 8170 44
2206396 2206396 2022-02-11 Washington Vermont 50023 8170 44
2203143 2203143 2022-02-10 Washington Vermont 50023 8150 44
2199889 2199889 2022-02-09 Washington Vermont 50023 8131 44
2196635 2196635 2022-02-08 Washington Vermont 50023 8114 44
2193381 2193381 2022-02-07 Washington Vermont 50023 8088 44
2190128 2190128 2022-02-06 Washington Vermont 50023 8023 44
2186875 2186875 2022-02-05 Washington Vermont 50023 8023 44
2183622 2183622 2022-02-04 Washington Vermont 50023 8023 44
2180370 2180370 2022-02-03 Washington Vermont 50023 8009 43

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