ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
179 rows where deaths = 639 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 15
- Indiana 13
- New Jersey 13
- Pennsylvania 13
- Alabama 11
- Colorado 11
- Florida 11
- Mississippi 9
- Ohio 8
- Oregon 8
- Virginia 7
- Washington 7
- Georgia 6
- Louisiana 6
- Michigan 6
- New York 5
- Texas 5
- Delaware 4
- Illinois 4
- Kansas 2
- Wisconsin 2
- Arizona 1
- Arkansas 1
- Iowa 1
- Kentucky 1
- Maryland 1
- Massachusetts 1
- Missouri 1
- Nebraska 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490588 | 2490588 | 2022-05-10 | Vanderburgh | Indiana | 18163 | 57701 | 639 |
2487331 | 2487331 | 2022-05-09 | Vanderburgh | Indiana | 18163 | 57701 | 639 |
2306602 | 2306602 | 2022-03-14 | Washington | Pennsylvania | 42125 | 50563 | 639 |
2303351 | 2303351 | 2022-03-13 | Washington | Pennsylvania | 42125 | 50560 | 639 |
2300099 | 2300099 | 2022-03-12 | Washington | Pennsylvania | 42125 | 50546 | 639 |
2296847 | 2296847 | 2022-03-11 | Washington | Pennsylvania | 42125 | 50525 | 639 |
2292017 | 2292017 | 2022-03-10 | Madison | Indiana | 18095 | 32586 | 639 |
2288765 | 2288765 | 2022-03-09 | Madison | Indiana | 18095 | 32576 | 639 |
2256226 | 2256226 | 2022-02-27 | Hamilton | Indiana | 18057 | 81221 | 639 |
2252975 | 2252975 | 2022-02-26 | Hamilton | Indiana | 18057 | 81221 | 639 |
2249724 | 2249724 | 2022-02-25 | Hamilton | Indiana | 18057 | 81221 | 639 |
2246473 | 2246473 | 2022-02-24 | Hamilton | Indiana | 18057 | 81194 | 639 |
2242954 | 2242954 | 2022-02-23 | Henry | Georgia | 13151 | 57148 | 639 |
2243222 | 2243222 | 2022-02-23 | Hamilton | Indiana | 18057 | 81161 | 639 |
2219601 | 2219601 | 2022-02-15 | Kanawha | West Virginia | 54039 | 45592 | 639 |
2194940 | 2194940 | 2022-02-08 | Barnstable | Massachusetts | 25001 | 33673 | 639 |
2180476 | 2180476 | 2022-02-03 | Prince William | Virginia | 51153 | 91673 | 639 |
2160678 | 2160678 | 2022-01-28 | Johnson | Texas | 48251 | 39334 | 639 |
2141251 | 2141251 | 2022-01-22 | Taylor | Texas | 48441 | 28952 | 639 |
2133171 | 2133171 | 2022-01-20 | Ingham | Michigan | 26065 | 53823 | 639 |
2129918 | 2129918 | 2022-01-19 | Ingham | Michigan | 26065 | 53823 | 639 |
2131711 | 2131711 | 2022-01-19 | Clark | Washington | 53011 | 67437 | 639 |
2128457 | 2128457 | 2022-01-18 | Clark | Washington | 53011 | 66518 | 639 |
2111406 | 2111406 | 2022-01-13 | Cambria | Pennsylvania | 42021 | 28286 | 639 |
2108154 | 2108154 | 2022-01-12 | Cambria | Pennsylvania | 42021 | 28075 | 639 |
2104903 | 2104903 | 2022-01-11 | Cambria | Pennsylvania | 42021 | 27731 | 639 |
2087501 | 2087501 | 2022-01-06 | Calcasieu | Louisiana | 22019 | 39312 | 639 |
2088659 | 2088659 | 2022-01-06 | Erie | Pennsylvania | 42049 | 44352 | 639 |
2084249 | 2084249 | 2022-01-05 | Calcasieu | Louisiana | 22019 | 38741 | 639 |
2080997 | 2080997 | 2022-01-04 | Calcasieu | Louisiana | 22019 | 38363 | 639 |
2077745 | 2077745 | 2022-01-03 | Calcasieu | Louisiana | 22019 | 37985 | 639 |
2028158 | 2028158 | 2021-12-19 | Pueblo | Colorado | 8101 | 30667 | 639 |
2024907 | 2024907 | 2021-12-18 | Pueblo | Colorado | 8101 | 30667 | 639 |
2021656 | 2021656 | 2021-12-17 | Pueblo | Colorado | 8101 | 30667 | 639 |
2010299 | 2010299 | 2021-12-13 | Gaston | North Carolina | 37071 | 42927 | 639 |
2005809 | 2005809 | 2021-12-12 | Winnebago | Illinois | 17201 | 49661 | 639 |
2002558 | 2002558 | 2021-12-11 | Winnebago | Illinois | 17201 | 49661 | 639 |
1999308 | 1999308 | 2021-12-10 | Winnebago | Illinois | 17201 | 49661 | 639 |
1964730 | 1964730 | 2021-11-29 | Oneida | New York | 36065 | 33056 | 639 |
1964961 | 1964961 | 2021-11-29 | Lorain | Ohio | 39093 | 41058 | 639 |
1961709 | 1961709 | 2021-11-28 | Lorain | Ohio | 39093 | 40812 | 639 |
1958458 | 1958458 | 2021-11-27 | Lorain | Ohio | 39093 | 40661 | 639 |
1955207 | 1955207 | 2021-11-26 | Lorain | Ohio | 39093 | 40514 | 639 |
1946658 | 1946658 | 2021-11-24 | Tuscaloosa | Alabama | 1125 | 35953 | 639 |
1944785 | 1944785 | 2021-11-23 | Hinds | Mississippi | 28049 | 32537 | 639 |
1941534 | 1941534 | 2021-11-22 | Hinds | Mississippi | 28049 | 32527 | 639 |
1938284 | 1938284 | 2021-11-21 | Hinds | Mississippi | 28049 | 32489 | 639 |
1935034 | 1935034 | 2021-11-20 | Hinds | Mississippi | 28049 | 32489 | 639 |
1931784 | 1931784 | 2021-11-19 | Hinds | Mississippi | 28049 | 32489 | 639 |
1928533 | 1928533 | 2021-11-18 | Hinds | Mississippi | 28049 | 32470 | 639 |
1925283 | 1925283 | 2021-11-17 | Hinds | Mississippi | 28049 | 32454 | 639 |
1922034 | 1922034 | 2021-11-16 | Hinds | Mississippi | 28049 | 32433 | 639 |
1918784 | 1918784 | 2021-11-15 | Hinds | Mississippi | 28049 | 32411 | 639 |
1913130 | 1913130 | 2021-11-13 | Cumberland | Pennsylvania | 42041 | 29712 | 639 |
1907915 | 1907915 | 2021-11-12 | Sussex | Delaware | 10005 | 36186 | 639 |
1904666 | 1904666 | 2021-11-11 | Sussex | Delaware | 10005 | 36103 | 639 |
1901416 | 1901416 | 2021-11-10 | Sussex | Delaware | 10005 | 36056 | 639 |
1898166 | 1898166 | 2021-11-09 | Sussex | Delaware | 10005 | 36009 | 639 |
1878844 | 1878844 | 2021-11-03 | Muscogee | Georgia | 13215 | 24254 | 639 |
1869060 | 1869060 | 2021-10-31 | Hall | Georgia | 13139 | 38271 | 639 |
1865811 | 1865811 | 2021-10-30 | Hall | Georgia | 13139 | 38271 | 639 |
1862562 | 1862562 | 2021-10-29 | Hall | Georgia | 13139 | 38271 | 639 |
1856383 | 1856383 | 2021-10-27 | St. Joseph | Indiana | 18141 | 44742 | 639 |
1854642 | 1854642 | 2021-10-26 | Dauphin | Pennsylvania | 42043 | 34571 | 639 |
1827049 | 1827049 | 2021-10-18 | St. Clair | Illinois | 17163 | 40154 | 639 |
1815926 | 1815926 | 2021-10-14 | Hamilton | Tennessee | 47065 | 63084 | 639 |
1774700 | 1774700 | 2021-10-02 | Bay | Florida | 12005 | 31272 | 639 |
1771450 | 1771450 | 2021-10-01 | Bay | Florida | 12005 | 31272 | 639 |
1768201 | 1768201 | 2021-09-30 | Bay | Florida | 12005 | 30947 | 639 |
1764952 | 1764952 | 2021-09-29 | Bay | Florida | 12005 | 30947 | 639 |
1767497 | 1767497 | 2021-09-29 | Williamson | Texas | 48491 | 72387 | 639 |
1761703 | 1761703 | 2021-09-28 | Bay | Florida | 12005 | 30947 | 639 |
1758455 | 1758455 | 2021-09-27 | Bay | Florida | 12005 | 30947 | 639 |
1755207 | 1755207 | 2021-09-26 | Bay | Florida | 12005 | 30947 | 639 |
1751959 | 1751959 | 2021-09-25 | Bay | Florida | 12005 | 30947 | 639 |
1747246 | 1747246 | 2021-09-23 | Mahoning | Ohio | 39099 | 27127 | 639 |
1743997 | 1743997 | 2021-09-22 | Mahoning | Ohio | 39099 | 26963 | 639 |
1740748 | 1740748 | 2021-09-21 | Mahoning | Ohio | 39099 | 26831 | 639 |
1696456 | 1696456 | 2021-09-08 | Montgomery | Alabama | 1101 | 31461 | 639 |
1693208 | 1693208 | 2021-09-07 | Montgomery | Alabama | 1101 | 31331 | 639 |
1689959 | 1689959 | 2021-09-06 | Montgomery | Alabama | 1101 | 31257 | 639 |
1686709 | 1686709 | 2021-09-05 | Montgomery | Alabama | 1101 | 31131 | 639 |
1683459 | 1683459 | 2021-09-04 | Montgomery | Alabama | 1101 | 31017 | 639 |
1680208 | 1680208 | 2021-09-03 | Montgomery | Alabama | 1101 | 30877 | 639 |
1676960 | 1676960 | 2021-09-02 | Montgomery | Alabama | 1101 | 30714 | 639 |
1673713 | 1673713 | 2021-09-01 | Montgomery | Alabama | 1101 | 30491 | 639 |
1675258 | 1675258 | 2021-09-01 | St. Charles | Missouri | 29183 | 55663 | 639 |
1670465 | 1670465 | 2021-08-31 | Montgomery | Alabama | 1101 | 30330 | 639 |
1647522 | 1647522 | 2021-08-23 | Snohomish | Washington | 53061 | 48672 | 639 |
1541800 | 1541800 | 2021-07-22 | Saginaw | Michigan | 26145 | 22625 | 639 |
1538553 | 1538553 | 2021-07-21 | Saginaw | Michigan | 26145 | 22625 | 639 |
1535306 | 1535306 | 2021-07-20 | Saginaw | Michigan | 26145 | 22625 | 639 |
1530481 | 1530481 | 2021-07-18 | Henrico | Virginia | 51087 | 26110 | 639 |
1527234 | 1527234 | 2021-07-17 | Henrico | Virginia | 51087 | 26110 | 639 |
1523987 | 1523987 | 2021-07-16 | Henrico | Virginia | 51087 | 26110 | 639 |
1520739 | 1520739 | 2021-07-15 | Henrico | Virginia | 51087 | 26087 | 639 |
1520975 | 1520975 | 2021-07-15 | Waukesha | Wisconsin | 55133 | 49345 | 639 |
1517491 | 1517491 | 2021-07-14 | Henrico | Virginia | 51087 | 26070 | 639 |
1514244 | 1514244 | 2021-07-13 | Henrico | Virginia | 51087 | 26046 | 639 |
1497282 | 1497282 | 2021-07-08 | Multnomah | Oregon | 41051 | 40798 | 639 |
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);