ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,357 rows where county = "Orleans" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Orleans · 2,257 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2394002 | 2394002 | 2022-04-10 | Orleans | New York | 36073 | 8636 | 113 |
2395040 | 2395040 | 2022-04-10 | Orleans | Vermont | 50019 | 6277 | 37 |
2390018 | 2390018 | 2022-04-09 | Orleans | Louisiana | 22071 | 87521 | 1108 |
2390746 | 2390746 | 2022-04-09 | Orleans | New York | 36073 | 8633 | 113 |
2391784 | 2391784 | 2022-04-09 | Orleans | Vermont | 50019 | 6277 | 37 |
2386762 | 2386762 | 2022-04-08 | Orleans | Louisiana | 22071 | 87521 | 1108 |
2387490 | 2387490 | 2022-04-08 | Orleans | New York | 36073 | 8624 | 113 |
2388528 | 2388528 | 2022-04-08 | Orleans | Vermont | 50019 | 6277 | 37 |
2383507 | 2383507 | 2022-04-07 | Orleans | Louisiana | 22071 | 87500 | 1107 |
2384235 | 2384235 | 2022-04-07 | Orleans | New York | 36073 | 8617 | 113 |
2385273 | 2385273 | 2022-04-07 | Orleans | Vermont | 50019 | 6273 | 37 |
2380252 | 2380252 | 2022-04-06 | Orleans | Louisiana | 22071 | 87486 | 1107 |
2380980 | 2380980 | 2022-04-06 | Orleans | New York | 36073 | 8615 | 113 |
2382018 | 2382018 | 2022-04-06 | Orleans | Vermont | 50019 | 6264 | 37 |
2376997 | 2376997 | 2022-04-05 | Orleans | Louisiana | 22071 | 87454 | 1108 |
2377725 | 2377725 | 2022-04-05 | Orleans | New York | 36073 | 8609 | 113 |
2378763 | 2378763 | 2022-04-05 | Orleans | Vermont | 50019 | 6250 | 37 |
2373745 | 2373745 | 2022-04-04 | Orleans | Louisiana | 22071 | 87435 | 1108 |
2374472 | 2374472 | 2022-04-04 | Orleans | New York | 36073 | 8606 | 113 |
2375509 | 2375509 | 2022-04-04 | Orleans | Vermont | 50019 | 6245 | 37 |
2370492 | 2370492 | 2022-04-03 | Orleans | Louisiana | 22071 | 87394 | 1108 |
2371220 | 2371220 | 2022-04-03 | Orleans | New York | 36073 | 8603 | 113 |
2372257 | 2372257 | 2022-04-03 | Orleans | Vermont | 50019 | 6230 | 37 |
2367239 | 2367239 | 2022-04-02 | Orleans | Louisiana | 22071 | 87394 | 1108 |
2367967 | 2367967 | 2022-04-02 | Orleans | New York | 36073 | 8598 | 113 |
2369004 | 2369004 | 2022-04-02 | Orleans | Vermont | 50019 | 6230 | 37 |
2363986 | 2363986 | 2022-04-01 | Orleans | Louisiana | 22071 | 87394 | 1108 |
2364714 | 2364714 | 2022-04-01 | Orleans | New York | 36073 | 8595 | 113 |
2365751 | 2365751 | 2022-04-01 | Orleans | Vermont | 50019 | 6230 | 37 |
2360732 | 2360732 | 2022-03-31 | Orleans | Louisiana | 22071 | 87377 | 1107 |
2361460 | 2361460 | 2022-03-31 | Orleans | New York | 36073 | 8586 | 113 |
2362498 | 2362498 | 2022-03-31 | Orleans | Vermont | 50019 | 6215 | 37 |
2357478 | 2357478 | 2022-03-30 | Orleans | Louisiana | 22071 | 87343 | 1107 |
2358206 | 2358206 | 2022-03-30 | Orleans | New York | 36073 | 8581 | 113 |
2359244 | 2359244 | 2022-03-30 | Orleans | Vermont | 50019 | 6209 | 37 |
2354225 | 2354225 | 2022-03-29 | Orleans | Louisiana | 22071 | 87313 | 1105 |
2354952 | 2354952 | 2022-03-29 | Orleans | New York | 36073 | 8578 | 113 |
2355990 | 2355990 | 2022-03-29 | Orleans | Vermont | 50019 | 6199 | 37 |
2350973 | 2350973 | 2022-03-28 | Orleans | Louisiana | 22071 | 87298 | 1105 |
2351699 | 2351699 | 2022-03-28 | Orleans | New York | 36073 | 8575 | 113 |
2352737 | 2352737 | 2022-03-28 | Orleans | Vermont | 50019 | 6197 | 37 |
2347720 | 2347720 | 2022-03-27 | Orleans | Louisiana | 22071 | 87265 | 1105 |
2348447 | 2348447 | 2022-03-27 | Orleans | New York | 36073 | 8573 | 113 |
2349485 | 2349485 | 2022-03-27 | Orleans | Vermont | 50019 | 6185 | 37 |
2344467 | 2344467 | 2022-03-26 | Orleans | Louisiana | 22071 | 87265 | 1105 |
2345194 | 2345194 | 2022-03-26 | Orleans | New York | 36073 | 8572 | 113 |
2346232 | 2346232 | 2022-03-26 | Orleans | Vermont | 50019 | 6185 | 37 |
2341214 | 2341214 | 2022-03-25 | Orleans | Louisiana | 22071 | 87265 | 1105 |
2341941 | 2341941 | 2022-03-25 | Orleans | New York | 36073 | 8570 | 113 |
2342979 | 2342979 | 2022-03-25 | Orleans | Vermont | 50019 | 6185 | 37 |
2337961 | 2337961 | 2022-03-24 | Orleans | Louisiana | 22071 | 87238 | 1105 |
2338688 | 2338688 | 2022-03-24 | Orleans | New York | 36073 | 8566 | 113 |
2339726 | 2339726 | 2022-03-24 | Orleans | Vermont | 50019 | 6176 | 37 |
2334707 | 2334707 | 2022-03-23 | Orleans | Louisiana | 22071 | 87226 | 1105 |
2335434 | 2335434 | 2022-03-23 | Orleans | New York | 36073 | 8564 | 113 |
2336472 | 2336472 | 2022-03-23 | Orleans | Vermont | 50019 | 6168 | 37 |
2331453 | 2331453 | 2022-03-22 | Orleans | Louisiana | 22071 | 87196 | 1105 |
2332180 | 2332180 | 2022-03-22 | Orleans | New York | 36073 | 8558 | 113 |
2333218 | 2333218 | 2022-03-22 | Orleans | Vermont | 50019 | 6151 | 37 |
2328201 | 2328201 | 2022-03-21 | Orleans | Louisiana | 22071 | 87165 | 1105 |
2328927 | 2328927 | 2022-03-21 | Orleans | New York | 36073 | 8555 | 113 |
2329965 | 2329965 | 2022-03-21 | Orleans | Vermont | 50019 | 6149 | 37 |
2324948 | 2324948 | 2022-03-20 | Orleans | Louisiana | 22071 | 87129 | 1103 |
2325675 | 2325675 | 2022-03-20 | Orleans | New York | 36073 | 8554 | 113 |
2326713 | 2326713 | 2022-03-20 | Orleans | Vermont | 50019 | 6122 | 37 |
2321694 | 2321694 | 2022-03-19 | Orleans | Louisiana | 22071 | 87129 | 1103 |
2322422 | 2322422 | 2022-03-19 | Orleans | New York | 36073 | 8553 | 113 |
2323460 | 2323460 | 2022-03-19 | Orleans | Vermont | 50019 | 6122 | 37 |
2318440 | 2318440 | 2022-03-18 | Orleans | Louisiana | 22071 | 87129 | 1103 |
2319168 | 2319168 | 2022-03-18 | Orleans | New York | 36073 | 8551 | 113 |
2320206 | 2320206 | 2022-03-18 | Orleans | Vermont | 50019 | 6122 | 37 |
2315187 | 2315187 | 2022-03-17 | Orleans | Louisiana | 22071 | 87079 | 1102 |
2315914 | 2315914 | 2022-03-17 | Orleans | New York | 36073 | 8550 | 113 |
2316952 | 2316952 | 2022-03-17 | Orleans | Vermont | 50019 | 6122 | 37 |
2311934 | 2311934 | 2022-03-16 | Orleans | Louisiana | 22071 | 87051 | 1102 |
2312661 | 2312661 | 2022-03-16 | Orleans | New York | 36073 | 8546 | 113 |
2313699 | 2313699 | 2022-03-16 | Orleans | Vermont | 50019 | 6111 | 37 |
2308681 | 2308681 | 2022-03-15 | Orleans | Louisiana | 22071 | 87004 | 1102 |
2309408 | 2309408 | 2022-03-15 | Orleans | New York | 36073 | 8546 | 113 |
2310446 | 2310446 | 2022-03-15 | Orleans | Vermont | 50019 | 6088 | 37 |
2305430 | 2305430 | 2022-03-14 | Orleans | Louisiana | 22071 | 86952 | 1101 |
2306155 | 2306155 | 2022-03-14 | Orleans | New York | 36073 | 8546 | 113 |
2307193 | 2307193 | 2022-03-14 | Orleans | Vermont | 50019 | 6087 | 37 |
2302178 | 2302178 | 2022-03-13 | Orleans | Louisiana | 22071 | 86843 | 1101 |
2302904 | 2302904 | 2022-03-13 | Orleans | New York | 36073 | 8544 | 113 |
2303942 | 2303942 | 2022-03-13 | Orleans | Vermont | 50019 | 6073 | 37 |
2298926 | 2298926 | 2022-03-12 | Orleans | Louisiana | 22071 | 86843 | 1101 |
2299652 | 2299652 | 2022-03-12 | Orleans | New York | 36073 | 8543 | 113 |
2300690 | 2300690 | 2022-03-12 | Orleans | Vermont | 50019 | 6073 | 37 |
2295674 | 2295674 | 2022-03-11 | Orleans | Louisiana | 22071 | 86843 | 1101 |
2296400 | 2296400 | 2022-03-11 | Orleans | New York | 36073 | 8542 | 113 |
2297438 | 2297438 | 2022-03-11 | Orleans | Vermont | 50019 | 6073 | 37 |
2292422 | 2292422 | 2022-03-10 | Orleans | Louisiana | 22071 | 86793 | 1101 |
2293148 | 2293148 | 2022-03-10 | Orleans | New York | 36073 | 8540 | 112 |
2294186 | 2294186 | 2022-03-10 | Orleans | Vermont | 50019 | 6064 | 37 |
2289170 | 2289170 | 2022-03-09 | Orleans | Louisiana | 22071 | 86755 | 1101 |
2289896 | 2289896 | 2022-03-09 | Orleans | New York | 36073 | 8539 | 112 |
2290934 | 2290934 | 2022-03-09 | Orleans | Vermont | 50019 | 6060 | 37 |
2285919 | 2285919 | 2022-03-08 | Orleans | Louisiana | 22071 | 86677 | 1100 |
2286644 | 2286644 | 2022-03-08 | Orleans | New York | 36073 | 8535 | 112 |
Advanced export
JSON shape: default, array, newline-delimited
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);