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

781 rows where county = "Orleans" and fips = 50019 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 50019 · 781 ✖

county 1

  • Orleans · 781 ✖
Link rowid date ▲ county state fips cases deaths
2502501 2502501 2022-05-13 Orleans Vermont 50019 6610 38
2499243 2499243 2022-05-12 Orleans Vermont 50019 6599 38
2495985 2495985 2022-05-11 Orleans Vermont 50019 6566 38
2492727 2492727 2022-05-10 Orleans Vermont 50019 6559 38
2489469 2489469 2022-05-09 Orleans Vermont 50019 6556 38
2486211 2486211 2022-05-08 Orleans Vermont 50019 6533 38
2482953 2482953 2022-05-07 Orleans Vermont 50019 6533 38
2479695 2479695 2022-05-06 Orleans Vermont 50019 6533 38
2476437 2476437 2022-05-05 Orleans Vermont 50019 6525 38
2473180 2473180 2022-05-04 Orleans Vermont 50019 6512 38
2469924 2469924 2022-05-03 Orleans Vermont 50019 6499 38
2466668 2466668 2022-05-02 Orleans Vermont 50019 6494 38
2463413 2463413 2022-05-01 Orleans Vermont 50019 6477 38
2460157 2460157 2022-04-30 Orleans Vermont 50019 6477 38
2456901 2456901 2022-04-29 Orleans Vermont 50019 6477 38
2453645 2453645 2022-04-28 Orleans Vermont 50019 6471 38
2450389 2450389 2022-04-27 Orleans Vermont 50019 6422 37
2447132 2447132 2022-04-26 Orleans Vermont 50019 6422 37
2443877 2443877 2022-04-25 Orleans Vermont 50019 6422 37
2440621 2440621 2022-04-24 Orleans Vermont 50019 6400 37
2437365 2437365 2022-04-23 Orleans Vermont 50019 6400 37
2434109 2434109 2022-04-22 Orleans Vermont 50019 6400 37
2430853 2430853 2022-04-21 Orleans Vermont 50019 6386 37
2427597 2427597 2022-04-20 Orleans Vermont 50019 6372 37
2424341 2424341 2022-04-19 Orleans Vermont 50019 6361 37
2421085 2421085 2022-04-18 Orleans Vermont 50019 6354 37
2417829 2417829 2022-04-17 Orleans Vermont 50019 6328 37
2414573 2414573 2022-04-16 Orleans Vermont 50019 6328 37
2411317 2411317 2022-04-15 Orleans Vermont 50019 6328 37
2408061 2408061 2022-04-14 Orleans Vermont 50019 6316 37
2404805 2404805 2022-04-13 Orleans Vermont 50019 6294 37
2401550 2401550 2022-04-12 Orleans Vermont 50019 6287 37
2398295 2398295 2022-04-11 Orleans Vermont 50019 6284 37
2395040 2395040 2022-04-10 Orleans Vermont 50019 6277 37
2391784 2391784 2022-04-09 Orleans Vermont 50019 6277 37
2388528 2388528 2022-04-08 Orleans Vermont 50019 6277 37
2385273 2385273 2022-04-07 Orleans Vermont 50019 6273 37
2382018 2382018 2022-04-06 Orleans Vermont 50019 6264 37
2378763 2378763 2022-04-05 Orleans Vermont 50019 6250 37
2375509 2375509 2022-04-04 Orleans Vermont 50019 6245 37
2372257 2372257 2022-04-03 Orleans Vermont 50019 6230 37
2369004 2369004 2022-04-02 Orleans Vermont 50019 6230 37
2365751 2365751 2022-04-01 Orleans Vermont 50019 6230 37
2362498 2362498 2022-03-31 Orleans Vermont 50019 6215 37
2359244 2359244 2022-03-30 Orleans Vermont 50019 6209 37
2355990 2355990 2022-03-29 Orleans Vermont 50019 6199 37
2352737 2352737 2022-03-28 Orleans Vermont 50019 6197 37
2349485 2349485 2022-03-27 Orleans Vermont 50019 6185 37
2346232 2346232 2022-03-26 Orleans Vermont 50019 6185 37
2342979 2342979 2022-03-25 Orleans Vermont 50019 6185 37
2339726 2339726 2022-03-24 Orleans Vermont 50019 6176 37
2336472 2336472 2022-03-23 Orleans Vermont 50019 6168 37
2333218 2333218 2022-03-22 Orleans Vermont 50019 6151 37
2329965 2329965 2022-03-21 Orleans Vermont 50019 6149 37
2326713 2326713 2022-03-20 Orleans Vermont 50019 6122 37
2323460 2323460 2022-03-19 Orleans Vermont 50019 6122 37
2320206 2320206 2022-03-18 Orleans Vermont 50019 6122 37
2316952 2316952 2022-03-17 Orleans Vermont 50019 6122 37
2313699 2313699 2022-03-16 Orleans Vermont 50019 6111 37
2310446 2310446 2022-03-15 Orleans Vermont 50019 6088 37
2307193 2307193 2022-03-14 Orleans Vermont 50019 6087 37
2303942 2303942 2022-03-13 Orleans Vermont 50019 6073 37
2300690 2300690 2022-03-12 Orleans Vermont 50019 6073 37
2297438 2297438 2022-03-11 Orleans Vermont 50019 6073 37
2294186 2294186 2022-03-10 Orleans Vermont 50019 6064 37
2290934 2290934 2022-03-09 Orleans Vermont 50019 6060 37
2287682 2287682 2022-03-08 Orleans Vermont 50019 6044 37
2284430 2284430 2022-03-07 Orleans Vermont 50019 6044 37
2281178 2281178 2022-03-06 Orleans Vermont 50019 6025 37
2277925 2277925 2022-03-05 Orleans Vermont 50019 6025 37
2274672 2274672 2022-03-04 Orleans Vermont 50019 6025 37
2271419 2271419 2022-03-03 Orleans Vermont 50019 6019 37
2268167 2268167 2022-03-02 Orleans Vermont 50019 6011 37
2264914 2264914 2022-03-01 Orleans Vermont 50019 5092 33
2261664 2261664 2022-02-28 Orleans Vermont 50019 5092 33
2258413 2258413 2022-02-27 Orleans Vermont 50019 5060 33
2255162 2255162 2022-02-26 Orleans Vermont 50019 5060 33
2251911 2251911 2022-02-25 Orleans Vermont 50019 5060 33
2248660 2248660 2022-02-24 Orleans Vermont 50019 5032 33
2245409 2245409 2022-02-23 Orleans Vermont 50019 5014 33
2242158 2242158 2022-02-22 Orleans Vermont 50019 5004 33
2238907 2238907 2022-02-21 Orleans Vermont 50019 4975 33
2235656 2235656 2022-02-20 Orleans Vermont 50019 4975 33
2232405 2232405 2022-02-19 Orleans Vermont 50019 4975 33
2229154 2229154 2022-02-18 Orleans Vermont 50019 4975 33
2225903 2225903 2022-02-17 Orleans Vermont 50019 4971 33
2222652 2222652 2022-02-16 Orleans Vermont 50019 4948 33
2219401 2219401 2022-02-15 Orleans Vermont 50019 4940 33
2216150 2216150 2022-02-14 Orleans Vermont 50019 4938 33
2212899 2212899 2022-02-13 Orleans Vermont 50019 4909 33
2209646 2209646 2022-02-12 Orleans Vermont 50019 4909 33
2206393 2206393 2022-02-11 Orleans Vermont 50019 4909 33
2203140 2203140 2022-02-10 Orleans Vermont 50019 4902 33
2199886 2199886 2022-02-09 Orleans Vermont 50019 4885 33
2196632 2196632 2022-02-08 Orleans Vermont 50019 4871 32
2193378 2193378 2022-02-07 Orleans Vermont 50019 4865 31
2190125 2190125 2022-02-06 Orleans Vermont 50019 4824 31
2186872 2186872 2022-02-05 Orleans Vermont 50019 4824 31
2183619 2183619 2022-02-04 Orleans Vermont 50019 4824 31
2180367 2180367 2022-02-03 Orleans Vermont 50019 4819 31

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