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

785 rows where county = "Rutland" 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 · 785 ✖

fips 1

county 1

  • Rutland · 785 ✖
Link rowid date ▲ county state fips cases deaths
2502502 2502502 2022-05-13 Rutland Vermont 50021 13586 74
2499244 2499244 2022-05-12 Rutland Vermont 50021 13516 74
2495986 2495986 2022-05-11 Rutland Vermont 50021 13455 74
2492728 2492728 2022-05-10 Rutland Vermont 50021 13404 74
2489470 2489470 2022-05-09 Rutland Vermont 50021 13340 74
2486212 2486212 2022-05-08 Rutland Vermont 50021 13244 74
2482954 2482954 2022-05-07 Rutland Vermont 50021 13244 74
2479696 2479696 2022-05-06 Rutland Vermont 50021 13244 74
2476438 2476438 2022-05-05 Rutland Vermont 50021 13206 74
2473181 2473181 2022-05-04 Rutland Vermont 50021 13155 74
2469925 2469925 2022-05-03 Rutland Vermont 50021 13108 74
2466669 2466669 2022-05-02 Rutland Vermont 50021 13045 74
2463414 2463414 2022-05-01 Rutland Vermont 50021 12987 74
2460158 2460158 2022-04-30 Rutland Vermont 50021 12987 74
2456902 2456902 2022-04-29 Rutland Vermont 50021 12987 74
2453646 2453646 2022-04-28 Rutland Vermont 50021 12932 74
2450390 2450390 2022-04-27 Rutland Vermont 50021 12808 74
2447133 2447133 2022-04-26 Rutland Vermont 50021 12808 74
2443878 2443878 2022-04-25 Rutland Vermont 50021 12808 74
2440622 2440622 2022-04-24 Rutland Vermont 50021 12765 74
2437366 2437366 2022-04-23 Rutland Vermont 50021 12765 74
2434110 2434110 2022-04-22 Rutland Vermont 50021 12765 74
2430854 2430854 2022-04-21 Rutland Vermont 50021 12747 73
2427598 2427598 2022-04-20 Rutland Vermont 50021 12702 73
2424342 2424342 2022-04-19 Rutland Vermont 50021 12691 73
2421086 2421086 2022-04-18 Rutland Vermont 50021 12676 73
2417830 2417830 2022-04-17 Rutland Vermont 50021 12632 73
2414574 2414574 2022-04-16 Rutland Vermont 50021 12632 73
2411318 2411318 2022-04-15 Rutland Vermont 50021 12632 73
2408062 2408062 2022-04-14 Rutland Vermont 50021 12626 73
2404806 2404806 2022-04-13 Rutland Vermont 50021 12601 73
2401551 2401551 2022-04-12 Rutland Vermont 50021 12589 73
2398296 2398296 2022-04-11 Rutland Vermont 50021 12577 73
2395041 2395041 2022-04-10 Rutland Vermont 50021 12524 72
2391785 2391785 2022-04-09 Rutland Vermont 50021 12524 72
2388529 2388529 2022-04-08 Rutland Vermont 50021 12524 72
2385274 2385274 2022-04-07 Rutland Vermont 50021 12509 72
2382019 2382019 2022-04-06 Rutland Vermont 50021 12495 72
2378764 2378764 2022-04-05 Rutland Vermont 50021 12477 72
2375510 2375510 2022-04-04 Rutland Vermont 50021 12472 72
2372258 2372258 2022-04-03 Rutland Vermont 50021 12439 72
2369005 2369005 2022-04-02 Rutland Vermont 50021 12439 72
2365752 2365752 2022-04-01 Rutland Vermont 50021 12439 72
2362499 2362499 2022-03-31 Rutland Vermont 50021 12428 72
2359245 2359245 2022-03-30 Rutland Vermont 50021 12405 72
2355991 2355991 2022-03-29 Rutland Vermont 50021 12395 72
2352738 2352738 2022-03-28 Rutland Vermont 50021 12387 71
2349486 2349486 2022-03-27 Rutland Vermont 50021 12365 71
2346233 2346233 2022-03-26 Rutland Vermont 50021 12365 71
2342980 2342980 2022-03-25 Rutland Vermont 50021 12365 71
2339727 2339727 2022-03-24 Rutland Vermont 50021 12352 71
2336473 2336473 2022-03-23 Rutland Vermont 50021 12338 71
2333219 2333219 2022-03-22 Rutland Vermont 50021 12327 71
2329966 2329966 2022-03-21 Rutland Vermont 50021 12320 71
2326714 2326714 2022-03-20 Rutland Vermont 50021 12303 71
2323461 2323461 2022-03-19 Rutland Vermont 50021 12303 71
2320207 2320207 2022-03-18 Rutland Vermont 50021 12303 71
2316953 2316953 2022-03-17 Rutland Vermont 50021 12285 71
2313700 2313700 2022-03-16 Rutland Vermont 50021 12279 71
2310447 2310447 2022-03-15 Rutland Vermont 50021 12270 71
2307194 2307194 2022-03-14 Rutland Vermont 50021 12260 71
2303943 2303943 2022-03-13 Rutland Vermont 50021 12239 71
2300691 2300691 2022-03-12 Rutland Vermont 50021 12239 71
2297439 2297439 2022-03-11 Rutland Vermont 50021 12239 71
2294187 2294187 2022-03-10 Rutland Vermont 50021 12232 71
2290935 2290935 2022-03-09 Rutland Vermont 50021 12219 71
2287683 2287683 2022-03-08 Rutland Vermont 50021 12208 71
2284431 2284431 2022-03-07 Rutland Vermont 50021 12197 71
2281179 2281179 2022-03-06 Rutland Vermont 50021 12176 71
2277926 2277926 2022-03-05 Rutland Vermont 50021 12176 71
2274673 2274673 2022-03-04 Rutland Vermont 50021 12176 71
2271420 2271420 2022-03-03 Rutland Vermont 50021 12160 70
2268168 2268168 2022-03-02 Rutland Vermont 50021 12143 69
2264915 2264915 2022-03-01 Rutland Vermont 50021 11357 66
2261665 2261665 2022-02-28 Rutland Vermont 50021 11357 66
2258414 2258414 2022-02-27 Rutland Vermont 50021 11151 66
2255163 2255163 2022-02-26 Rutland Vermont 50021 11151 66
2251912 2251912 2022-02-25 Rutland Vermont 50021 11151 66
2248661 2248661 2022-02-24 Rutland Vermont 50021 11138 66
2245410 2245410 2022-02-23 Rutland Vermont 50021 11113 66
2242159 2242159 2022-02-22 Rutland Vermont 50021 11087 63
2238908 2238908 2022-02-21 Rutland Vermont 50021 11034 61
2235657 2235657 2022-02-20 Rutland Vermont 50021 11034 61
2232406 2232406 2022-02-19 Rutland Vermont 50021 11034 61
2229155 2229155 2022-02-18 Rutland Vermont 50021 11034 61
2225904 2225904 2022-02-17 Rutland Vermont 50021 11005 60
2222653 2222653 2022-02-16 Rutland Vermont 50021 10979 58
2219402 2219402 2022-02-15 Rutland Vermont 50021 10955 58
2216151 2216151 2022-02-14 Rutland Vermont 50021 10940 58
2212900 2212900 2022-02-13 Rutland Vermont 50021 10887 58
2209647 2209647 2022-02-12 Rutland Vermont 50021 10887 58
2206394 2206394 2022-02-11 Rutland Vermont 50021 10887 58
2203141 2203141 2022-02-10 Rutland Vermont 50021 10855 58
2199887 2199887 2022-02-09 Rutland Vermont 50021 10814 58
2196633 2196633 2022-02-08 Rutland Vermont 50021 10777 57
2193379 2193379 2022-02-07 Rutland Vermont 50021 10753 56
2190126 2190126 2022-02-06 Rutland Vermont 50021 10691 56
2186873 2186873 2022-02-05 Rutland Vermont 50021 10691 56
2183620 2183620 2022-02-04 Rutland Vermont 50021 10691 56
2180368 2180368 2022-02-03 Rutland Vermont 50021 10653 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);