ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,825 rows where county = "Allen" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Allen · 3,625 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2370041 | 2370041 | 2022-04-03 | Allen | Indiana | 18003 | 103678 | 1174 |
2370232 | 2370232 | 2022-04-03 | Allen | Kansas | 20001 | 3952 | 53 |
2370338 | 2370338 | 2022-04-03 | Allen | Kentucky | 21003 | 6577 | 97 |
2370458 | 2370458 | 2022-04-03 | Allen | Louisiana | 22003 | 7863 | 137 |
2371402 | 2371402 | 2022-04-03 | Allen | Ohio | 39003 | 27412 | 476 |
2366788 | 2366788 | 2022-04-02 | Allen | Indiana | 18003 | 103678 | 1174 |
2366979 | 2366979 | 2022-04-02 | Allen | Kansas | 20001 | 3952 | 53 |
2367085 | 2367085 | 2022-04-02 | Allen | Kentucky | 21003 | 6577 | 97 |
2367205 | 2367205 | 2022-04-02 | Allen | Louisiana | 22003 | 7863 | 137 |
2368149 | 2368149 | 2022-04-02 | Allen | Ohio | 39003 | 27412 | 476 |
2363535 | 2363535 | 2022-04-01 | Allen | Indiana | 18003 | 103678 | 1174 |
2363726 | 2363726 | 2022-04-01 | Allen | Kansas | 20001 | 3952 | 53 |
2363832 | 2363832 | 2022-04-01 | Allen | Kentucky | 21003 | 6577 | 97 |
2363952 | 2363952 | 2022-04-01 | Allen | Louisiana | 22003 | 7863 | 137 |
2364896 | 2364896 | 2022-04-01 | Allen | Ohio | 39003 | 27412 | 476 |
2360281 | 2360281 | 2022-03-31 | Allen | Indiana | 18003 | 103641 | 1173 |
2360472 | 2360472 | 2022-03-31 | Allen | Kansas | 20001 | 3952 | 51 |
2360578 | 2360578 | 2022-03-31 | Allen | Kentucky | 21003 | 6577 | 97 |
2360698 | 2360698 | 2022-03-31 | Allen | Louisiana | 22003 | 7862 | 137 |
2361643 | 2361643 | 2022-03-31 | Allen | Ohio | 39003 | 27412 | 476 |
2357027 | 2357027 | 2022-03-30 | Allen | Indiana | 18003 | 103641 | 1173 |
2357218 | 2357218 | 2022-03-30 | Allen | Kansas | 20001 | 3952 | 51 |
2357324 | 2357324 | 2022-03-30 | Allen | Kentucky | 21003 | 6577 | 97 |
2357444 | 2357444 | 2022-03-30 | Allen | Louisiana | 22003 | 7862 | 137 |
2358389 | 2358389 | 2022-03-30 | Allen | Ohio | 39003 | 27399 | 475 |
2353774 | 2353774 | 2022-03-29 | Allen | Indiana | 18003 | 103712 | 1173 |
2353965 | 2353965 | 2022-03-29 | Allen | Kansas | 20001 | 3955 | 49 |
2354071 | 2354071 | 2022-03-29 | Allen | Kentucky | 21003 | 6577 | 97 |
2354191 | 2354191 | 2022-03-29 | Allen | Louisiana | 22003 | 7861 | 137 |
2355135 | 2355135 | 2022-03-29 | Allen | Ohio | 39003 | 27399 | 475 |
2350522 | 2350522 | 2022-03-28 | Allen | Indiana | 18003 | 103699 | 1173 |
2350713 | 2350713 | 2022-03-28 | Allen | Kansas | 20001 | 3955 | 49 |
2350819 | 2350819 | 2022-03-28 | Allen | Kentucky | 21003 | 6577 | 97 |
2350939 | 2350939 | 2022-03-28 | Allen | Louisiana | 22003 | 7861 | 137 |
2351882 | 2351882 | 2022-03-28 | Allen | Ohio | 39003 | 27399 | 475 |
2347269 | 2347269 | 2022-03-27 | Allen | Indiana | 18003 | 103671 | 1173 |
2347460 | 2347460 | 2022-03-27 | Allen | Kansas | 20001 | 3952 | 49 |
2347566 | 2347566 | 2022-03-27 | Allen | Kentucky | 21003 | 6572 | 96 |
2347686 | 2347686 | 2022-03-27 | Allen | Louisiana | 22003 | 7861 | 137 |
2348630 | 2348630 | 2022-03-27 | Allen | Ohio | 39003 | 27399 | 475 |
2344016 | 2344016 | 2022-03-26 | Allen | Indiana | 18003 | 103671 | 1173 |
2344207 | 2344207 | 2022-03-26 | Allen | Kansas | 20001 | 3952 | 49 |
2344313 | 2344313 | 2022-03-26 | Allen | Kentucky | 21003 | 6572 | 96 |
2344433 | 2344433 | 2022-03-26 | Allen | Louisiana | 22003 | 7861 | 137 |
2345377 | 2345377 | 2022-03-26 | Allen | Ohio | 39003 | 27399 | 475 |
2340763 | 2340763 | 2022-03-25 | Allen | Indiana | 18003 | 103671 | 1173 |
2340954 | 2340954 | 2022-03-25 | Allen | Kansas | 20001 | 3952 | 49 |
2341060 | 2341060 | 2022-03-25 | Allen | Kentucky | 21003 | 6572 | 96 |
2341180 | 2341180 | 2022-03-25 | Allen | Louisiana | 22003 | 7861 | 137 |
2342124 | 2342124 | 2022-03-25 | Allen | Ohio | 39003 | 27399 | 475 |
2337510 | 2337510 | 2022-03-24 | Allen | Indiana | 18003 | 103659 | 1173 |
2337701 | 2337701 | 2022-03-24 | Allen | Kansas | 20001 | 3953 | 48 |
2337807 | 2337807 | 2022-03-24 | Allen | Kentucky | 21003 | 6572 | 96 |
2337927 | 2337927 | 2022-03-24 | Allen | Louisiana | 22003 | 7861 | 137 |
2338871 | 2338871 | 2022-03-24 | Allen | Ohio | 39003 | 27399 | 475 |
2334256 | 2334256 | 2022-03-23 | Allen | Indiana | 18003 | 103656 | 1173 |
2334447 | 2334447 | 2022-03-23 | Allen | Kansas | 20001 | 3953 | 48 |
2334553 | 2334553 | 2022-03-23 | Allen | Kentucky | 21003 | 6572 | 96 |
2334673 | 2334673 | 2022-03-23 | Allen | Louisiana | 22003 | 7861 | 136 |
2335617 | 2335617 | 2022-03-23 | Allen | Ohio | 39003 | 27379 | 476 |
2331002 | 2331002 | 2022-03-22 | Allen | Indiana | 18003 | 103639 | 1172 |
2331193 | 2331193 | 2022-03-22 | Allen | Kansas | 20001 | 3953 | 48 |
2331299 | 2331299 | 2022-03-22 | Allen | Kentucky | 21003 | 6572 | 96 |
2331419 | 2331419 | 2022-03-22 | Allen | Louisiana | 22003 | 7861 | 134 |
2332363 | 2332363 | 2022-03-22 | Allen | Ohio | 39003 | 27379 | 476 |
2327750 | 2327750 | 2022-03-21 | Allen | Indiana | 18003 | 103623 | 1172 |
2327941 | 2327941 | 2022-03-21 | Allen | Kansas | 20001 | 3953 | 48 |
2328047 | 2328047 | 2022-03-21 | Allen | Kentucky | 21003 | 6572 | 96 |
2328167 | 2328167 | 2022-03-21 | Allen | Louisiana | 22003 | 7861 | 134 |
2329110 | 2329110 | 2022-03-21 | Allen | Ohio | 39003 | 27379 | 476 |
2324497 | 2324497 | 2022-03-20 | Allen | Indiana | 18003 | 103599 | 1172 |
2324688 | 2324688 | 2022-03-20 | Allen | Kansas | 20001 | 3952 | 48 |
2324794 | 2324794 | 2022-03-20 | Allen | Kentucky | 21003 | 6560 | 96 |
2324914 | 2324914 | 2022-03-20 | Allen | Louisiana | 22003 | 7861 | 134 |
2325858 | 2325858 | 2022-03-20 | Allen | Ohio | 39003 | 27379 | 476 |
2321243 | 2321243 | 2022-03-19 | Allen | Indiana | 18003 | 103599 | 1172 |
2321434 | 2321434 | 2022-03-19 | Allen | Kansas | 20001 | 3952 | 48 |
2321540 | 2321540 | 2022-03-19 | Allen | Kentucky | 21003 | 6560 | 96 |
2321660 | 2321660 | 2022-03-19 | Allen | Louisiana | 22003 | 7861 | 134 |
2322605 | 2322605 | 2022-03-19 | Allen | Ohio | 39003 | 27379 | 476 |
2317989 | 2317989 | 2022-03-18 | Allen | Indiana | 18003 | 103599 | 1172 |
2318180 | 2318180 | 2022-03-18 | Allen | Kansas | 20001 | 3952 | 48 |
2318286 | 2318286 | 2022-03-18 | Allen | Kentucky | 21003 | 6560 | 96 |
2318406 | 2318406 | 2022-03-18 | Allen | Louisiana | 22003 | 7861 | 134 |
2319351 | 2319351 | 2022-03-18 | Allen | Ohio | 39003 | 27379 | 476 |
2314736 | 2314736 | 2022-03-17 | Allen | Indiana | 18003 | 103587 | 1171 |
2314927 | 2314927 | 2022-03-17 | Allen | Kansas | 20001 | 3953 | 47 |
2315033 | 2315033 | 2022-03-17 | Allen | Kentucky | 21003 | 6560 | 96 |
2315153 | 2315153 | 2022-03-17 | Allen | Louisiana | 22003 | 7861 | 134 |
2316097 | 2316097 | 2022-03-17 | Allen | Ohio | 39003 | 27379 | 476 |
2311483 | 2311483 | 2022-03-16 | Allen | Indiana | 18003 | 103579 | 1170 |
2311674 | 2311674 | 2022-03-16 | Allen | Kansas | 20001 | 3953 | 47 |
2311780 | 2311780 | 2022-03-16 | Allen | Kentucky | 21003 | 6560 | 96 |
2311900 | 2311900 | 2022-03-16 | Allen | Louisiana | 22003 | 7860 | 133 |
2312844 | 2312844 | 2022-03-16 | Allen | Ohio | 39003 | 27363 | 469 |
2308230 | 2308230 | 2022-03-15 | Allen | Indiana | 18003 | 103563 | 1170 |
2308421 | 2308421 | 2022-03-15 | Allen | Kansas | 20001 | 3954 | 47 |
2308527 | 2308527 | 2022-03-15 | Allen | Kentucky | 21003 | 6560 | 96 |
2308647 | 2308647 | 2022-03-15 | Allen | Louisiana | 22003 | 7859 | 133 |
2309591 | 2309591 | 2022-03-15 | Allen | Ohio | 39003 | 27363 | 469 |
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);