ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,245 rows where county = "Oneida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Oneida · 2,145 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393998 | 2393998 | 2022-04-10 | Oneida | New York | 36065 | 53999 | 782 |
2395319 | 2395319 | 2022-04-10 | Oneida | Wisconsin | 55085 | 8480 | 136 |
2389452 | 2389452 | 2022-04-09 | Oneida | Idaho | 16071 | 805 | 11 |
2390742 | 2390742 | 2022-04-09 | Oneida | New York | 36065 | 53884 | 782 |
2392063 | 2392063 | 2022-04-09 | Oneida | Wisconsin | 55085 | 8480 | 136 |
2386197 | 2386197 | 2022-04-08 | Oneida | Idaho | 16071 | 805 | 11 |
2387486 | 2387486 | 2022-04-08 | Oneida | New York | 36065 | 53756 | 782 |
2388807 | 2388807 | 2022-04-08 | Oneida | Wisconsin | 55085 | 8480 | 136 |
2382942 | 2382942 | 2022-04-07 | Oneida | Idaho | 16071 | 805 | 11 |
2384231 | 2384231 | 2022-04-07 | Oneida | New York | 36065 | 53644 | 782 |
2385552 | 2385552 | 2022-04-07 | Oneida | Wisconsin | 55085 | 8479 | 136 |
2379687 | 2379687 | 2022-04-06 | Oneida | Idaho | 16071 | 806 | 11 |
2380976 | 2380976 | 2022-04-06 | Oneida | New York | 36065 | 53521 | 782 |
2382297 | 2382297 | 2022-04-06 | Oneida | Wisconsin | 55085 | 8476 | 136 |
2376433 | 2376433 | 2022-04-05 | Oneida | Idaho | 16071 | 806 | 11 |
2377721 | 2377721 | 2022-04-05 | Oneida | New York | 36065 | 53408 | 782 |
2379042 | 2379042 | 2022-04-05 | Oneida | Wisconsin | 55085 | 8476 | 136 |
2373181 | 2373181 | 2022-04-04 | Oneida | Idaho | 16071 | 806 | 11 |
2374468 | 2374468 | 2022-04-04 | Oneida | New York | 36065 | 53357 | 782 |
2375788 | 2375788 | 2022-04-04 | Oneida | Wisconsin | 55085 | 8475 | 136 |
2369928 | 2369928 | 2022-04-03 | Oneida | Idaho | 16071 | 806 | 11 |
2371216 | 2371216 | 2022-04-03 | Oneida | New York | 36065 | 53319 | 782 |
2372536 | 2372536 | 2022-04-03 | Oneida | Wisconsin | 55085 | 8472 | 136 |
2366675 | 2366675 | 2022-04-02 | Oneida | Idaho | 16071 | 806 | 11 |
2367963 | 2367963 | 2022-04-02 | Oneida | New York | 36065 | 53275 | 781 |
2369283 | 2369283 | 2022-04-02 | Oneida | Wisconsin | 55085 | 8472 | 136 |
2363422 | 2363422 | 2022-04-01 | Oneida | Idaho | 16071 | 806 | 11 |
2364710 | 2364710 | 2022-04-01 | Oneida | New York | 36065 | 53192 | 781 |
2366030 | 2366030 | 2022-04-01 | Oneida | Wisconsin | 55085 | 8472 | 136 |
2360168 | 2360168 | 2022-03-31 | Oneida | Idaho | 16071 | 806 | 11 |
2361456 | 2361456 | 2022-03-31 | Oneida | New York | 36065 | 53137 | 781 |
2362777 | 2362777 | 2022-03-31 | Oneida | Wisconsin | 55085 | 8471 | 135 |
2356914 | 2356914 | 2022-03-30 | Oneida | Idaho | 16071 | 806 | 11 |
2358202 | 2358202 | 2022-03-30 | Oneida | New York | 36065 | 53070 | 781 |
2359523 | 2359523 | 2022-03-30 | Oneida | Wisconsin | 55085 | 8468 | 135 |
2353661 | 2353661 | 2022-03-29 | Oneida | Idaho | 16071 | 806 | 11 |
2354948 | 2354948 | 2022-03-29 | Oneida | New York | 36065 | 52985 | 781 |
2356269 | 2356269 | 2022-03-29 | Oneida | Wisconsin | 55085 | 8467 | 135 |
2350409 | 2350409 | 2022-03-28 | Oneida | Idaho | 16071 | 806 | 11 |
2351695 | 2351695 | 2022-03-28 | Oneida | New York | 36065 | 52951 | 781 |
2353016 | 2353016 | 2022-03-28 | Oneida | Wisconsin | 55085 | 8466 | 135 |
2347156 | 2347156 | 2022-03-27 | Oneida | Idaho | 16071 | 806 | 11 |
2348443 | 2348443 | 2022-03-27 | Oneida | New York | 36065 | 52915 | 781 |
2349764 | 2349764 | 2022-03-27 | Oneida | Wisconsin | 55085 | 8461 | 135 |
2343903 | 2343903 | 2022-03-26 | Oneida | Idaho | 16071 | 806 | 11 |
2345190 | 2345190 | 2022-03-26 | Oneida | New York | 36065 | 52876 | 781 |
2346511 | 2346511 | 2022-03-26 | Oneida | Wisconsin | 55085 | 8461 | 135 |
2340650 | 2340650 | 2022-03-25 | Oneida | Idaho | 16071 | 806 | 11 |
2341937 | 2341937 | 2022-03-25 | Oneida | New York | 36065 | 52827 | 781 |
2343258 | 2343258 | 2022-03-25 | Oneida | Wisconsin | 55085 | 8461 | 135 |
2337397 | 2337397 | 2022-03-24 | Oneida | Idaho | 16071 | 806 | 11 |
2338684 | 2338684 | 2022-03-24 | Oneida | New York | 36065 | 52777 | 781 |
2340005 | 2340005 | 2022-03-24 | Oneida | Wisconsin | 55085 | 8461 | 135 |
2334143 | 2334143 | 2022-03-23 | Oneida | Idaho | 16071 | 806 | 11 |
2335430 | 2335430 | 2022-03-23 | Oneida | New York | 36065 | 52730 | 781 |
2336752 | 2336752 | 2022-03-23 | Oneida | Wisconsin | 55085 | 8457 | 135 |
2330889 | 2330889 | 2022-03-22 | Oneida | Idaho | 16071 | 806 | 11 |
2332176 | 2332176 | 2022-03-22 | Oneida | New York | 36065 | 52661 | 781 |
2333498 | 2333498 | 2022-03-22 | Oneida | Wisconsin | 55085 | 8457 | 135 |
2327637 | 2327637 | 2022-03-21 | Oneida | Idaho | 16071 | 806 | 11 |
2328923 | 2328923 | 2022-03-21 | Oneida | New York | 36065 | 52648 | 781 |
2330244 | 2330244 | 2022-03-21 | Oneida | Wisconsin | 55085 | 8456 | 135 |
2324384 | 2324384 | 2022-03-20 | Oneida | Idaho | 16071 | 806 | 11 |
2325671 | 2325671 | 2022-03-20 | Oneida | New York | 36065 | 52645 | 781 |
2326992 | 2326992 | 2022-03-20 | Oneida | Wisconsin | 55085 | 8456 | 135 |
2321130 | 2321130 | 2022-03-19 | Oneida | Idaho | 16071 | 806 | 11 |
2322418 | 2322418 | 2022-03-19 | Oneida | New York | 36065 | 52628 | 781 |
2323739 | 2323739 | 2022-03-19 | Oneida | Wisconsin | 55085 | 8456 | 135 |
2317876 | 2317876 | 2022-03-18 | Oneida | Idaho | 16071 | 806 | 11 |
2319164 | 2319164 | 2022-03-18 | Oneida | New York | 36065 | 52605 | 781 |
2320485 | 2320485 | 2022-03-18 | Oneida | Wisconsin | 55085 | 8456 | 135 |
2314623 | 2314623 | 2022-03-17 | Oneida | Idaho | 16071 | 806 | 11 |
2315910 | 2315910 | 2022-03-17 | Oneida | New York | 36065 | 52568 | 781 |
2317231 | 2317231 | 2022-03-17 | Oneida | Wisconsin | 55085 | 8453 | 135 |
2311370 | 2311370 | 2022-03-16 | Oneida | Idaho | 16071 | 805 | 11 |
2312657 | 2312657 | 2022-03-16 | Oneida | New York | 36065 | 52529 | 781 |
2313978 | 2313978 | 2022-03-16 | Oneida | Wisconsin | 55085 | 8450 | 135 |
2308117 | 2308117 | 2022-03-15 | Oneida | Idaho | 16071 | 805 | 11 |
2309404 | 2309404 | 2022-03-15 | Oneida | New York | 36065 | 52505 | 781 |
2310725 | 2310725 | 2022-03-15 | Oneida | Wisconsin | 55085 | 8449 | 134 |
2304866 | 2304866 | 2022-03-14 | Oneida | Idaho | 16071 | 805 | 11 |
2306151 | 2306151 | 2022-03-14 | Oneida | New York | 36065 | 52490 | 781 |
2307472 | 2307472 | 2022-03-14 | Oneida | Wisconsin | 55085 | 8444 | 134 |
2301614 | 2301614 | 2022-03-13 | Oneida | Idaho | 16071 | 805 | 11 |
2302900 | 2302900 | 2022-03-13 | Oneida | New York | 36065 | 52478 | 781 |
2304221 | 2304221 | 2022-03-13 | Oneida | Wisconsin | 55085 | 8441 | 133 |
2298362 | 2298362 | 2022-03-12 | Oneida | Idaho | 16071 | 805 | 11 |
2299648 | 2299648 | 2022-03-12 | Oneida | New York | 36065 | 52458 | 780 |
2300969 | 2300969 | 2022-03-12 | Oneida | Wisconsin | 55085 | 8441 | 133 |
2295110 | 2295110 | 2022-03-11 | Oneida | Idaho | 16071 | 805 | 11 |
2296396 | 2296396 | 2022-03-11 | Oneida | New York | 36065 | 52426 | 780 |
2297717 | 2297717 | 2022-03-11 | Oneida | Wisconsin | 55085 | 8441 | 133 |
2291858 | 2291858 | 2022-03-10 | Oneida | Idaho | 16071 | 804 | 11 |
2293144 | 2293144 | 2022-03-10 | Oneida | New York | 36065 | 52383 | 780 |
2294465 | 2294465 | 2022-03-10 | Oneida | Wisconsin | 55085 | 8439 | 132 |
2288606 | 2288606 | 2022-03-09 | Oneida | Idaho | 16071 | 803 | 11 |
2289892 | 2289892 | 2022-03-09 | Oneida | New York | 36065 | 52367 | 780 |
2291213 | 2291213 | 2022-03-09 | Oneida | Wisconsin | 55085 | 8439 | 132 |
2285355 | 2285355 | 2022-03-08 | Oneida | Idaho | 16071 | 802 | 11 |
2286640 | 2286640 | 2022-03-08 | Oneida | New York | 36065 | 52335 | 778 |
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);