ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where deaths = 650 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 18
- Delaware 13
- Pennsylvania 10
- Texas 10
- California 8
- New Hampshire 8
- New York 7
- Ohio 7
- Alabama 6
- Missouri 6
- Washington 6
- Illinois 5
- Indiana 5
- Michigan 5
- Tennessee 5
- Massachusetts 4
- New Jersey 4
- Colorado 3
- Louisiana 3
- Nebraska 3
- New Mexico 3
- South Carolina 3
- Arkansas 2
- Maryland 2
- Virginia 2
- Wisconsin 2
- Arizona 1
- District of Columbia 1
- Georgia 1
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499893 | 2499893 | 2022-05-13 | Kent | Delaware | 10001 | 51836 | 650 |
2500881 | 2500881 | 2022-05-13 | Muskegon | Michigan | 26121 | 42498 | 650 |
2496635 | 2496635 | 2022-05-12 | Kent | Delaware | 10001 | 51721 | 650 |
2497623 | 2497623 | 2022-05-12 | Muskegon | Michigan | 26121 | 42498 | 650 |
2493377 | 2493377 | 2022-05-11 | Kent | Delaware | 10001 | 51498 | 650 |
2494365 | 2494365 | 2022-05-11 | Muskegon | Michigan | 26121 | 42498 | 650 |
2490119 | 2490119 | 2022-05-10 | Kent | Delaware | 10001 | 51498 | 650 |
2486862 | 2486862 | 2022-05-09 | Kent | Delaware | 10001 | 51471 | 650 |
2483604 | 2483604 | 2022-05-08 | Kent | Delaware | 10001 | 51306 | 650 |
2480346 | 2480346 | 2022-05-07 | Kent | Delaware | 10001 | 51306 | 650 |
2477088 | 2477088 | 2022-05-06 | Kent | Delaware | 10001 | 51306 | 650 |
2473539 | 2473539 | 2022-05-05 | Etowah | Alabama | 1055 | 28773 | 650 |
2470282 | 2470282 | 2022-05-04 | Etowah | Alabama | 1055 | 28769 | 650 |
2467026 | 2467026 | 2022-05-03 | Etowah | Alabama | 1055 | 28767 | 650 |
2398984 | 2398984 | 2022-04-12 | Leon | Florida | 12073 | 84927 | 650 |
2395729 | 2395729 | 2022-04-11 | Leon | Florida | 12073 | 84927 | 650 |
2392473 | 2392473 | 2022-04-10 | Leon | Florida | 12073 | 84927 | 650 |
2389217 | 2389217 | 2022-04-09 | Leon | Florida | 12073 | 84927 | 650 |
2385962 | 2385962 | 2022-04-08 | Leon | Florida | 12073 | 84927 | 650 |
2382707 | 2382707 | 2022-04-07 | Leon | Florida | 12073 | 84804 | 650 |
2379452 | 2379452 | 2022-04-06 | Leon | Florida | 12073 | 84804 | 650 |
2301754 | 2301754 | 2022-03-13 | Hamilton | Indiana | 18057 | 81531 | 650 |
2298502 | 2298502 | 2022-03-12 | Hamilton | Indiana | 18057 | 81531 | 650 |
2295250 | 2295250 | 2022-03-11 | Hamilton | Indiana | 18057 | 81531 | 650 |
2293126 | 2293126 | 2022-03-10 | Dutchess | New York | 36027 | 63377 | 650 |
2289874 | 2289874 | 2022-03-09 | Dutchess | New York | 36027 | 63357 | 650 |
2286622 | 2286622 | 2022-03-08 | Dutchess | New York | 36027 | 63340 | 650 |
2282949 | 2282949 | 2022-03-07 | Harrison | Mississippi | 28047 | 53328 | 650 |
2283370 | 2283370 | 2022-03-07 | Dutchess | New York | 36027 | 63329 | 650 |
2284379 | 2284379 | 2022-03-07 | Wichita | Texas | 48485 | 33955 | 650 |
2278257 | 2278257 | 2022-03-06 | Baldwin | Alabama | 1003 | 55079 | 650 |
2280118 | 2280118 | 2022-03-06 | Dutchess | New York | 36027 | 63317 | 650 |
2281127 | 2281127 | 2022-03-06 | Wichita | Texas | 48485 | 33955 | 650 |
2275004 | 2275004 | 2022-03-05 | Baldwin | Alabama | 1003 | 55079 | 650 |
2276865 | 2276865 | 2022-03-05 | Dutchess | New York | 36027 | 63297 | 650 |
2277874 | 2277874 | 2022-03-05 | Wichita | Texas | 48485 | 33955 | 650 |
2271751 | 2271751 | 2022-03-04 | Baldwin | Alabama | 1003 | 55079 | 650 |
2274621 | 2274621 | 2022-03-04 | Wichita | Texas | 48485 | 33955 | 650 |
2261462 | 2261462 | 2022-02-28 | Gregg | Texas | 48183 | 23000 | 650 |
2258211 | 2258211 | 2022-02-27 | Gregg | Texas | 48183 | 22985 | 650 |
2242717 | 2242717 | 2022-02-23 | Santa Barbara | California | 6083 | 89345 | 650 |
2239466 | 2239466 | 2022-02-22 | Santa Barbara | California | 6083 | 89270 | 650 |
2194018 | 2194018 | 2022-02-08 | Weld | Colorado | 8123 | 78598 | 650 |
2173789 | 2173789 | 2022-02-01 | Taylor | Texas | 48441 | 31375 | 650 |
2154471 | 2154471 | 2022-01-26 | Virginia Beach city | Virginia | 51810 | 83072 | 650 |
2150466 | 2150466 | 2022-01-25 | Lackawanna | Pennsylvania | 42069 | 39048 | 650 |
2143480 | 2143480 | 2022-01-23 | Doña Ana | New Mexico | 35013 | 52476 | 650 |
2140225 | 2140225 | 2022-01-22 | Doña Ana | New Mexico | 35013 | 52476 | 650 |
2136969 | 2136969 | 2022-01-21 | Doña Ana | New Mexico | 35013 | 52476 | 650 |
2134963 | 2134963 | 2022-01-20 | Clark | Washington | 53011 | 66692 | 650 |
2096338 | 2096338 | 2022-01-09 | Monterey | California | 6053 | 57607 | 650 |
2093086 | 2093086 | 2022-01-08 | Monterey | California | 6053 | 57607 | 650 |
2089834 | 2089834 | 2022-01-07 | Monterey | California | 6053 | 57607 | 650 |
2086583 | 2086583 | 2022-01-06 | Monterey | California | 6053 | 57127 | 650 |
2081467 | 2081467 | 2022-01-04 | St. Louis city | Missouri | 29510 | 41645 | 650 |
2076827 | 2076827 | 2022-01-03 | Monterey | California | 6053 | 55161 | 650 |
2041159 | 2041159 | 2021-12-23 | Pueblo | Colorado | 8101 | 30920 | 650 |
2040518 | 2040518 | 2021-12-22 | Utah | Utah | 49049 | 142085 | 650 |
2034212 | 2034212 | 2021-12-20 | Yakima | Washington | 53077 | 47607 | 650 |
2030962 | 2030962 | 2021-12-19 | Yakima | Washington | 53077 | 47559 | 650 |
2027711 | 2027711 | 2021-12-18 | Yakima | Washington | 53077 | 47559 | 650 |
2024460 | 2024460 | 2021-12-17 | Yakima | Washington | 53077 | 47559 | 650 |
2015562 | 2015562 | 2021-12-15 | Winnebago | Illinois | 17201 | 50656 | 650 |
2001969 | 2001969 | 2021-12-11 | Benton | Arkansas | 5007 | 44726 | 650 |
1997464 | 1997464 | 2021-12-09 | Lorain | Ohio | 39093 | 43792 | 650 |
1994213 | 1994213 | 2021-12-08 | Lorain | Ohio | 39093 | 43467 | 650 |
1990962 | 1990962 | 2021-12-07 | Lorain | Ohio | 39093 | 43171 | 650 |
1963171 | 1963171 | 2021-11-29 | Sussex | Delaware | 10005 | 37457 | 650 |
1965138 | 1965138 | 2021-11-29 | Cumberland | Pennsylvania | 42041 | 31458 | 650 |
1959920 | 1959920 | 2021-11-28 | Sussex | Delaware | 10005 | 37407 | 650 |
1961886 | 1961886 | 2021-11-28 | Cumberland | Pennsylvania | 42041 | 31357 | 650 |
1956669 | 1956669 | 2021-11-27 | Sussex | Delaware | 10005 | 37349 | 650 |
1958635 | 1958635 | 2021-11-27 | Cumberland | Pennsylvania | 42041 | 31260 | 650 |
1953418 | 1953418 | 2021-11-26 | Sussex | Delaware | 10005 | 37297 | 650 |
1955384 | 1955384 | 2021-11-26 | Cumberland | Pennsylvania | 42041 | 31109 | 650 |
1950167 | 1950167 | 2021-11-25 | Sussex | Delaware | 10005 | 37202 | 650 |
1952133 | 1952133 | 2021-11-25 | Cumberland | Pennsylvania | 42041 | 31017 | 650 |
1918122 | 1918122 | 2021-11-15 | St. Joseph | Indiana | 18141 | 46764 | 650 |
1882285 | 1882285 | 2021-11-04 | St. Clair | Illinois | 17163 | 40747 | 650 |
1879036 | 1879036 | 2021-11-03 | St. Clair | Illinois | 17163 | 40690 | 650 |
1867638 | 1867638 | 2021-10-30 | Dauphin | Pennsylvania | 42043 | 34903 | 650 |
1864389 | 1864389 | 2021-10-29 | Dauphin | Pennsylvania | 42043 | 34800 | 650 |
1820416 | 1820416 | 2021-10-16 | Honolulu | Hawaii | 15003 | 56872 | 650 |
1813781 | 1813781 | 2021-10-14 | Chatham | Georgia | 13051 | 38330 | 650 |
1773834 | 1773834 | 2021-10-01 | Galveston | Texas | 48167 | 62091 | 650 |
1773911 | 1773911 | 2021-10-01 | McLennan | Texas | 48309 | 40670 | 650 |
1769987 | 1769987 | 2021-09-30 | Mahoning | Ohio | 39099 | 28083 | 650 |
1770130 | 1770130 | 2021-09-30 | Multnomah | Oregon | 41051 | 53026 | 650 |
1766738 | 1766738 | 2021-09-29 | Mahoning | Ohio | 39099 | 27932 | 650 |
1762071 | 1762071 | 2021-09-28 | Unknown | Illinois | 0 | 650 | |
1763489 | 1763489 | 2021-09-28 | Mahoning | Ohio | 39099 | 27797 | 650 |
1746671 | 1746671 | 2021-09-23 | Greene | Missouri | 29077 | 43291 | 650 |
1670151 | 1670151 | 2021-08-30 | Henrico | Virginia | 51087 | 29357 | 650 |
1666361 | 1666361 | 2021-08-29 | Horry | South Carolina | 45051 | 49576 | 650 |
1663113 | 1663113 | 2021-08-28 | Horry | South Carolina | 45051 | 49576 | 650 |
1659865 | 1659865 | 2021-08-27 | Horry | South Carolina | 45051 | 49576 | 650 |
1603988 | 1603988 | 2021-08-10 | Hillsborough | New Hampshire | 33011 | 37226 | 650 |
1600739 | 1600739 | 2021-08-09 | Hillsborough | New Hampshire | 33011 | 37188 | 650 |
1597491 | 1597491 | 2021-08-08 | Hillsborough | New Hampshire | 33011 | 37051 | 650 |
1594242 | 1594242 | 2021-08-07 | Hillsborough | New Hampshire | 33011 | 37051 | 650 |
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);