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,725 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2435146 | 2435146 | 2022-04-23 | Allen | Indiana | 18003 | 103982 | 1185 |
2435338 | 2435338 | 2022-04-23 | Allen | Kansas | 20001 | 3959 | 53 |
2435445 | 2435445 | 2022-04-23 | Allen | Kentucky | 21003 | 6593 | 103 |
2435565 | 2435565 | 2022-04-23 | Allen | Louisiana | 22003 | 7874 | 137 |
2436510 | 2436510 | 2022-04-23 | Allen | Ohio | 39003 | 27471 | 477 |
2431890 | 2431890 | 2022-04-22 | Allen | Indiana | 18003 | 103982 | 1185 |
2432082 | 2432082 | 2022-04-22 | Allen | Kansas | 20001 | 3959 | 53 |
2432189 | 2432189 | 2022-04-22 | Allen | Kentucky | 21003 | 6593 | 103 |
2432309 | 2432309 | 2022-04-22 | Allen | Louisiana | 22003 | 7874 | 137 |
2433254 | 2433254 | 2022-04-22 | Allen | Ohio | 39003 | 27471 | 477 |
2428634 | 2428634 | 2022-04-21 | Allen | Indiana | 18003 | 103936 | 1184 |
2428826 | 2428826 | 2022-04-21 | Allen | Kansas | 20001 | 3957 | 53 |
2428933 | 2428933 | 2022-04-21 | Allen | Kentucky | 21003 | 6593 | 103 |
2429053 | 2429053 | 2022-04-21 | Allen | Louisiana | 22003 | 7874 | 137 |
2429998 | 2429998 | 2022-04-21 | Allen | Ohio | 39003 | 27471 | 477 |
2425378 | 2425378 | 2022-04-20 | Allen | Indiana | 18003 | 103936 | 1184 |
2425570 | 2425570 | 2022-04-20 | Allen | Kansas | 20001 | 3957 | 53 |
2425677 | 2425677 | 2022-04-20 | Allen | Kentucky | 21003 | 6593 | 103 |
2425797 | 2425797 | 2022-04-20 | Allen | Louisiana | 22003 | 7874 | 137 |
2426742 | 2426742 | 2022-04-20 | Allen | Ohio | 39003 | 27449 | 477 |
2422122 | 2422122 | 2022-04-19 | Allen | Indiana | 18003 | 103883 | 1183 |
2422314 | 2422314 | 2022-04-19 | Allen | Kansas | 20001 | 3957 | 53 |
2422421 | 2422421 | 2022-04-19 | Allen | Kentucky | 21003 | 6593 | 103 |
2422541 | 2422541 | 2022-04-19 | Allen | Louisiana | 22003 | 7872 | 137 |
2423486 | 2423486 | 2022-04-19 | Allen | Ohio | 39003 | 27449 | 477 |
2418866 | 2418866 | 2022-04-18 | Allen | Indiana | 18003 | 103883 | 1183 |
2419058 | 2419058 | 2022-04-18 | Allen | Kansas | 20001 | 3957 | 53 |
2419165 | 2419165 | 2022-04-18 | Allen | Kentucky | 21003 | 6593 | 103 |
2419285 | 2419285 | 2022-04-18 | Allen | Louisiana | 22003 | 7871 | 137 |
2420229 | 2420229 | 2022-04-18 | Allen | Ohio | 39003 | 27449 | 477 |
2415610 | 2415610 | 2022-04-17 | Allen | Indiana | 18003 | 103808 | 1181 |
2415802 | 2415802 | 2022-04-17 | Allen | Kansas | 20001 | 3957 | 53 |
2415909 | 2415909 | 2022-04-17 | Allen | Kentucky | 21003 | 6582 | 103 |
2416029 | 2416029 | 2022-04-17 | Allen | Louisiana | 22003 | 7871 | 137 |
2416974 | 2416974 | 2022-04-17 | Allen | Ohio | 39003 | 27449 | 477 |
2412354 | 2412354 | 2022-04-16 | Allen | Indiana | 18003 | 103808 | 1181 |
2412546 | 2412546 | 2022-04-16 | Allen | Kansas | 20001 | 3957 | 53 |
2412653 | 2412653 | 2022-04-16 | Allen | Kentucky | 21003 | 6582 | 103 |
2412773 | 2412773 | 2022-04-16 | Allen | Louisiana | 22003 | 7871 | 137 |
2413718 | 2413718 | 2022-04-16 | Allen | Ohio | 39003 | 27449 | 477 |
2409098 | 2409098 | 2022-04-15 | Allen | Indiana | 18003 | 103808 | 1181 |
2409290 | 2409290 | 2022-04-15 | Allen | Kansas | 20001 | 3957 | 53 |
2409397 | 2409397 | 2022-04-15 | Allen | Kentucky | 21003 | 6582 | 103 |
2409517 | 2409517 | 2022-04-15 | Allen | Louisiana | 22003 | 7871 | 137 |
2410462 | 2410462 | 2022-04-15 | Allen | Ohio | 39003 | 27449 | 477 |
2405842 | 2405842 | 2022-04-14 | Allen | Indiana | 18003 | 103808 | 1181 |
2406034 | 2406034 | 2022-04-14 | Allen | Kansas | 20001 | 3954 | 53 |
2406141 | 2406141 | 2022-04-14 | Allen | Kentucky | 21003 | 6582 | 103 |
2406261 | 2406261 | 2022-04-14 | Allen | Louisiana | 22003 | 7871 | 137 |
2407206 | 2407206 | 2022-04-14 | Allen | Ohio | 39003 | 27449 | 477 |
2402587 | 2402587 | 2022-04-13 | Allen | Indiana | 18003 | 103808 | 1181 |
2402778 | 2402778 | 2022-04-13 | Allen | Kansas | 20001 | 3954 | 53 |
2402885 | 2402885 | 2022-04-13 | Allen | Kentucky | 21003 | 6582 | 103 |
2403005 | 2403005 | 2022-04-13 | Allen | Louisiana | 22003 | 7870 | 137 |
2403950 | 2403950 | 2022-04-13 | Allen | Ohio | 39003 | 27433 | 476 |
2399332 | 2399332 | 2022-04-12 | Allen | Indiana | 18003 | 103767 | 1178 |
2399524 | 2399524 | 2022-04-12 | Allen | Kansas | 20001 | 3954 | 53 |
2399631 | 2399631 | 2022-04-12 | Allen | Kentucky | 21003 | 6582 | 103 |
2399751 | 2399751 | 2022-04-12 | Allen | Louisiana | 22003 | 7870 | 137 |
2400695 | 2400695 | 2022-04-12 | Allen | Ohio | 39003 | 27433 | 476 |
2396077 | 2396077 | 2022-04-11 | Allen | Indiana | 18003 | 103767 | 1178 |
2396268 | 2396268 | 2022-04-11 | Allen | Kansas | 20001 | 3954 | 53 |
2396375 | 2396375 | 2022-04-11 | Allen | Kentucky | 21003 | 6582 | 103 |
2396495 | 2396495 | 2022-04-11 | Allen | Louisiana | 22003 | 7870 | 137 |
2397440 | 2397440 | 2022-04-11 | Allen | Ohio | 39003 | 27433 | 476 |
2392821 | 2392821 | 2022-04-10 | Allen | Indiana | 18003 | 103743 | 1178 |
2393013 | 2393013 | 2022-04-10 | Allen | Kansas | 20001 | 3954 | 53 |
2393120 | 2393120 | 2022-04-10 | Allen | Kentucky | 21003 | 6577 | 97 |
2393240 | 2393240 | 2022-04-10 | Allen | Louisiana | 22003 | 7869 | 137 |
2394185 | 2394185 | 2022-04-10 | Allen | Ohio | 39003 | 27433 | 476 |
2389565 | 2389565 | 2022-04-09 | Allen | Indiana | 18003 | 103743 | 1178 |
2389757 | 2389757 | 2022-04-09 | Allen | Kansas | 20001 | 3954 | 53 |
2389864 | 2389864 | 2022-04-09 | Allen | Kentucky | 21003 | 6577 | 97 |
2389984 | 2389984 | 2022-04-09 | Allen | Louisiana | 22003 | 7869 | 137 |
2390929 | 2390929 | 2022-04-09 | Allen | Ohio | 39003 | 27433 | 476 |
2386310 | 2386310 | 2022-04-08 | Allen | Indiana | 18003 | 103743 | 1178 |
2386501 | 2386501 | 2022-04-08 | Allen | Kansas | 20001 | 3954 | 53 |
2386608 | 2386608 | 2022-04-08 | Allen | Kentucky | 21003 | 6577 | 97 |
2386728 | 2386728 | 2022-04-08 | Allen | Louisiana | 22003 | 7869 | 137 |
2387673 | 2387673 | 2022-04-08 | Allen | Ohio | 39003 | 27433 | 476 |
2383055 | 2383055 | 2022-04-07 | Allen | Indiana | 18003 | 103712 | 1175 |
2383247 | 2383247 | 2022-04-07 | Allen | Kansas | 20001 | 3952 | 53 |
2383353 | 2383353 | 2022-04-07 | Allen | Kentucky | 21003 | 6577 | 97 |
2383473 | 2383473 | 2022-04-07 | Allen | Louisiana | 22003 | 7868 | 137 |
2384418 | 2384418 | 2022-04-07 | Allen | Ohio | 39003 | 27433 | 476 |
2379800 | 2379800 | 2022-04-06 | Allen | Indiana | 18003 | 103712 | 1175 |
2379992 | 2379992 | 2022-04-06 | Allen | Kansas | 20001 | 3952 | 53 |
2380098 | 2380098 | 2022-04-06 | Allen | Kentucky | 21003 | 6577 | 97 |
2380218 | 2380218 | 2022-04-06 | Allen | Louisiana | 22003 | 7867 | 137 |
2381163 | 2381163 | 2022-04-06 | Allen | Ohio | 39003 | 27412 | 476 |
2376546 | 2376546 | 2022-04-05 | Allen | Indiana | 18003 | 103696 | 1174 |
2376737 | 2376737 | 2022-04-05 | Allen | Kansas | 20001 | 3952 | 53 |
2376843 | 2376843 | 2022-04-05 | Allen | Kentucky | 21003 | 6577 | 97 |
2376963 | 2376963 | 2022-04-05 | Allen | Louisiana | 22003 | 7866 | 137 |
2377908 | 2377908 | 2022-04-05 | Allen | Ohio | 39003 | 27412 | 476 |
2373294 | 2373294 | 2022-04-04 | Allen | Indiana | 18003 | 103696 | 1174 |
2373485 | 2373485 | 2022-04-04 | Allen | Kansas | 20001 | 3952 | 53 |
2373591 | 2373591 | 2022-04-04 | Allen | Kentucky | 21003 | 6577 | 97 |
2373711 | 2373711 | 2022-04-04 | Allen | Louisiana | 22003 | 7864 | 137 |
2374654 | 2374654 | 2022-04-04 | Allen | Ohio | 39003 | 27412 | 476 |
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);