ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
224 rows where deaths = 589 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 24
- Louisiana 24
- Texas 20
- New Mexico 19
- Pennsylvania 15
- Tennessee 12
- California 11
- Georgia 9
- Illinois 9
- Mississippi 8
- Florida 7
- Indiana 6
- Michigan 6
- South Carolina 6
- New Jersey 5
- Ohio 5
- Minnesota 4
- New York 4
- Arkansas 3
- Colorado 3
- Idaho 3
- Missouri 3
- Oregon 3
- Wisconsin 3
- Delaware 2
- Kansas 2
- Oklahoma 2
- Washington 2
- District of Columbia 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501411 | 2501411 | 2022-05-13 | McKinley | New Mexico | 35031 | 26007 | 589 |
2498153 | 2498153 | 2022-05-12 | McKinley | New Mexico | 35031 | 26001 | 589 |
2494895 | 2494895 | 2022-05-11 | McKinley | New Mexico | 35031 | 25986 | 589 |
2491637 | 2491637 | 2022-05-10 | McKinley | New Mexico | 35031 | 25983 | 589 |
2488379 | 2488379 | 2022-05-09 | McKinley | New Mexico | 35031 | 25980 | 589 |
2485122 | 2485122 | 2022-05-08 | McKinley | New Mexico | 35031 | 25965 | 589 |
2481864 | 2481864 | 2022-05-07 | McKinley | New Mexico | 35031 | 25965 | 589 |
2478606 | 2478606 | 2022-05-06 | McKinley | New Mexico | 35031 | 25965 | 589 |
2475348 | 2475348 | 2022-05-05 | McKinley | New Mexico | 35031 | 25954 | 589 |
2472091 | 2472091 | 2022-05-04 | McKinley | New Mexico | 35031 | 25954 | 589 |
2468835 | 2468835 | 2022-05-03 | McKinley | New Mexico | 35031 | 25948 | 589 |
2469268 | 2469268 | 2022-05-03 | Washington | Oregon | 41067 | 88522 | 589 |
2465579 | 2465579 | 2022-05-02 | McKinley | New Mexico | 35031 | 25946 | 589 |
2462324 | 2462324 | 2022-05-01 | McKinley | New Mexico | 35031 | 25940 | 589 |
2459068 | 2459068 | 2022-04-30 | McKinley | New Mexico | 35031 | 25940 | 589 |
2455812 | 2455812 | 2022-04-29 | McKinley | New Mexico | 35031 | 25940 | 589 |
2391482 | 2391482 | 2022-04-09 | Unknown | Tennessee | 19032 | 589 | |
2376425 | 2376425 | 2022-04-05 | Kootenai | Idaho | 16055 | 41885 | 589 |
2378076 | 2378076 | 2022-04-05 | Clackamas | Oregon | 41005 | 60076 | 589 |
2374822 | 2374822 | 2022-04-04 | Clackamas | Oregon | 41005 | 60034 | 589 |
2337789 | 2337789 | 2022-03-24 | Shawnee | Kansas | 20177 | 48060 | 589 |
2334535 | 2334535 | 2022-03-23 | Shawnee | Kansas | 20177 | 48060 | 589 |
2309324 | 2309324 | 2022-03-15 | Cumberland | New Jersey | 34011 | 39257 | 589 |
2306071 | 2306071 | 2022-03-14 | Cumberland | New Jersey | 34011 | 39257 | 589 |
2302820 | 2302820 | 2022-03-13 | Cumberland | New Jersey | 34011 | 39256 | 589 |
2278675 | 2278675 | 2022-03-06 | Cherokee | Georgia | 13057 | 62989 | 589 |
2275422 | 2275422 | 2022-03-05 | Cherokee | Georgia | 13057 | 62989 | 589 |
2272169 | 2272169 | 2022-03-04 | Cherokee | Georgia | 13057 | 62989 | 589 |
2268505 | 2268505 | 2022-03-03 | Calhoun | Alabama | 1015 | 31871 | 589 |
2268716 | 2268716 | 2022-03-03 | Placer | California | 6061 | 69344 | 589 |
2268917 | 2268917 | 2022-03-03 | Cherokee | Georgia | 13057 | 62970 | 589 |
2265252 | 2265252 | 2022-03-02 | Calhoun | Alabama | 1015 | 31802 | 589 |
2265429 | 2265429 | 2022-03-02 | Washington | Arkansas | 5143 | 67454 | 589 |
2257950 | 2257950 | 2022-02-27 | Pickens | South Carolina | 45077 | 45556 | 589 |
2254699 | 2254699 | 2022-02-26 | Pickens | South Carolina | 45077 | 45556 | 589 |
2251448 | 2251448 | 2022-02-25 | Pickens | South Carolina | 45077 | 45556 | 589 |
2245767 | 2245767 | 2022-02-24 | Etowah | Alabama | 1055 | 28640 | 589 |
2233481 | 2233481 | 2022-02-20 | Johnson | Indiana | 18081 | 42035 | 589 |
2230230 | 2230230 | 2022-02-19 | Johnson | Indiana | 18081 | 42035 | 589 |
2231758 | 2231758 | 2022-02-19 | Blair | Pennsylvania | 42013 | 29177 | 589 |
2226979 | 2226979 | 2022-02-18 | Johnson | Indiana | 18081 | 42035 | 589 |
2228507 | 2228507 | 2022-02-18 | Blair | Pennsylvania | 42013 | 29142 | 589 |
2223301 | 2223301 | 2022-02-17 | Kent | Delaware | 10001 | 49165 | 589 |
2225256 | 2225256 | 2022-02-17 | Blair | Pennsylvania | 42013 | 29107 | 589 |
2220050 | 2220050 | 2022-02-16 | Kent | Delaware | 10001 | 49092 | 589 |
2222005 | 2222005 | 2022-02-16 | Blair | Pennsylvania | 42013 | 29050 | 589 |
2222449 | 2222449 | 2022-02-16 | Grayson | Texas | 48181 | 26887 | 589 |
2219198 | 2219198 | 2022-02-15 | Grayson | Texas | 48181 | 26879 | 589 |
2195015 | 2195015 | 2022-02-08 | Muskegon | Michigan | 26121 | 40366 | 589 |
2191761 | 2191761 | 2022-02-07 | Muskegon | Michigan | 26121 | 40366 | 589 |
2169128 | 2169128 | 2022-01-31 | Harrison | Mississippi | 28047 | 47331 | 589 |
2165873 | 2165873 | 2022-01-30 | Harrison | Mississippi | 28047 | 46620 | 589 |
2162618 | 2162618 | 2022-01-29 | Harrison | Mississippi | 28047 | 46620 | 589 |
2159363 | 2159363 | 2022-01-28 | Harrison | Mississippi | 28047 | 46620 | 589 |
2148898 | 2148898 | 2022-01-25 | Hamilton | Indiana | 18057 | 76119 | 589 |
2141886 | 2141886 | 2022-01-23 | Santa Barbara | California | 6083 | 72722 | 589 |
2138631 | 2138631 | 2022-01-22 | Santa Barbara | California | 6083 | 72722 | 589 |
2135375 | 2135375 | 2022-01-21 | Santa Barbara | California | 6083 | 72722 | 589 |
2131336 | 2131336 | 2022-01-19 | Ector | Texas | 48135 | 33221 | 589 |
2128001 | 2128001 | 2022-01-18 | Sumner | Tennessee | 47165 | 41555 | 589 |
2124430 | 2124430 | 2022-01-17 | Franklin | Pennsylvania | 42055 | 35232 | 589 |
2124749 | 2124749 | 2022-01-17 | Sumner | Tennessee | 47165 | 41555 | 589 |
2121178 | 2121178 | 2022-01-16 | Franklin | Pennsylvania | 42055 | 34980 | 589 |
2121497 | 2121497 | 2022-01-16 | Sumner | Tennessee | 47165 | 41555 | 589 |
2117926 | 2117926 | 2022-01-15 | Franklin | Pennsylvania | 42055 | 34399 | 589 |
2118245 | 2118245 | 2022-01-15 | Sumner | Tennessee | 47165 | 41555 | 589 |
2114701 | 2114701 | 2022-01-14 | Schuylkill | Pennsylvania | 42107 | 29600 | 589 |
2114994 | 2114994 | 2022-01-14 | Sumner | Tennessee | 47165 | 41555 | 589 |
2111742 | 2111742 | 2022-01-13 | Sumner | Tennessee | 47165 | 41555 | 589 |
2108490 | 2108490 | 2022-01-12 | Sumner | Tennessee | 47165 | 41555 | 589 |
2080173 | 2080173 | 2022-01-04 | Weld | Colorado | 8123 | 59480 | 589 |
2059861 | 2059861 | 2021-12-28 | Johnson | Texas | 48251 | 30462 | 589 |
2056130 | 2056130 | 2021-12-27 | Beaver | Pennsylvania | 42007 | 29135 | 589 |
2037176 | 2037176 | 2021-12-21 | Potter | Texas | 48375 | 26550 | 589 |
2026887 | 2026887 | 2021-12-18 | Butler | Pennsylvania | 42019 | 31163 | 589 |
2015583 | 2015583 | 2021-12-15 | Elkhart | Indiana | 18039 | 41884 | 589 |
2006426 | 2006426 | 2021-12-12 | St. Clair | Michigan | 26147 | 28465 | 589 |
2003175 | 2003175 | 2021-12-11 | St. Clair | Michigan | 26147 | 28237 | 589 |
1999925 | 1999925 | 2021-12-10 | St. Clair | Michigan | 26147 | 28237 | 589 |
1995925 | 1995925 | 2021-12-09 | Canyon | Idaho | 16027 | 43952 | 589 |
1985603 | 1985603 | 2021-12-06 | Baldwin | Alabama | 1003 | 38215 | 589 |
1982353 | 1982353 | 2021-12-05 | Baldwin | Alabama | 1003 | 38207 | 589 |
1983681 | 1983681 | 2021-12-05 | Anoka | Minnesota | 27003 | 64961 | 589 |
1979103 | 1979103 | 2021-12-04 | Baldwin | Alabama | 1003 | 38195 | 589 |
1980431 | 1980431 | 2021-12-04 | Anoka | Minnesota | 27003 | 64961 | 589 |
1975853 | 1975853 | 2021-12-03 | Baldwin | Alabama | 1003 | 38171 | 589 |
1977181 | 1977181 | 2021-12-03 | Anoka | Minnesota | 27003 | 64961 | 589 |
1972604 | 1972604 | 2021-12-02 | Baldwin | Alabama | 1003 | 38140 | 589 |
1973948 | 1973948 | 2021-12-02 | Dakota | Minnesota | 27037 | 68081 | 589 |
1975448 | 1975448 | 2021-12-02 | Taylor | Texas | 48441 | 23743 | 589 |
1969354 | 1969354 | 2021-12-01 | Baldwin | Alabama | 1003 | 38123 | 589 |
1969649 | 1969649 | 2021-12-01 | Pueblo | Colorado | 8101 | 29596 | 589 |
1966104 | 1966104 | 2021-11-30 | Baldwin | Alabama | 1003 | 38104 | 589 |
1962852 | 1962852 | 2021-11-29 | Baldwin | Alabama | 1003 | 38085 | 589 |
1959601 | 1959601 | 2021-11-28 | Baldwin | Alabama | 1003 | 38074 | 589 |
1956350 | 1956350 | 2021-11-27 | Baldwin | Alabama | 1003 | 38068 | 589 |
1953099 | 1953099 | 2021-11-26 | Baldwin | Alabama | 1003 | 38061 | 589 |
1949848 | 1949848 | 2021-11-25 | Baldwin | Alabama | 1003 | 38061 | 589 |
1946597 | 1946597 | 2021-11-24 | Baldwin | Alabama | 1003 | 38042 | 589 |
1938682 | 1938682 | 2021-11-21 | San Juan | New Mexico | 35045 | 25643 | 589 |
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);