ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
200 rows where cases = 2877 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 17
- Missouri 12
- Tennessee 12
- Minnesota 10
- Colorado 8
- Florida 8
- Georgia 8
- Mississippi 8
- Kentucky 7
- North Carolina 7
- Texas 7
- Utah 7
- Alabama 6
- Arkansas 6
- Virginia 6
- Illinois 5
- Ohio 5
- Pennsylvania 5
- Wisconsin 5
- Alaska 4
- California 4
- Louisiana 4
- Puerto Rico 4
- Washington 4
- Idaho 3
- Iowa 3
- Michigan 3
- Oregon 3
- West Virginia 3
- Arizona 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2359666 | 2359666 | 2022-03-31 | Valdez-Cordova Census Area | Alaska | 2261 | 2877 | 17 |
2356412 | 2356412 | 2022-03-30 | Valdez-Cordova Census Area | Alaska | 2261 | 2877 | 17 |
2287839 | 2287839 | 2022-03-08 | Jefferson | Washington | 53031 | 2877 | 28 |
2284402 | 2284402 | 2022-03-07 | Juab | Utah | 49023 | 2877 | 23 |
2284587 | 2284587 | 2022-03-07 | Jefferson | Washington | 53031 | 2877 | 28 |
2281150 | 2281150 | 2022-03-06 | Juab | Utah | 49023 | 2877 | 23 |
2277897 | 2277897 | 2022-03-05 | Juab | Utah | 49023 | 2877 | 23 |
2274644 | 2274644 | 2022-03-04 | Juab | Utah | 49023 | 2877 | 23 |
2268648 | 2268648 | 2022-03-03 | Lee | Arkansas | 5077 | 2877 | 58 |
2271391 | 2271391 | 2022-03-03 | Juab | Utah | 49023 | 2877 | 23 |
2268139 | 2268139 | 2022-03-02 | Juab | Utah | 49023 | 2877 | 23 |
2244635 | 2244635 | 2022-02-23 | Vinton | Ohio | 39163 | 2877 | 53 |
2210186 | 2210186 | 2022-02-13 | Mariposa | California | 6043 | 2877 | 20 |
2206933 | 2206933 | 2022-02-12 | Mariposa | California | 6043 | 2877 | 20 |
2203680 | 2203680 | 2022-02-11 | Mariposa | California | 6043 | 2877 | 20 |
2200801 | 2200801 | 2022-02-10 | Idaho | Idaho | 16049 | 2877 | 44 |
2192034 | 2192034 | 2022-02-07 | Pemiscot | Missouri | 29155 | 2877 | 63 |
2164692 | 2164692 | 2022-01-30 | Crowley | Colorado | 8025 | 2877 | 28 |
2158181 | 2158181 | 2022-01-28 | Crowley | Colorado | 8025 | 2877 | 28 |
2084864 | 2084864 | 2022-01-05 | Saline | Nebraska | 31151 | 2877 | 7 |
2085031 | 2085031 | 2022-01-05 | Bertie | North Carolina | 37015 | 2877 | 54 |
2074755 | 2074755 | 2022-01-02 | Renville | Minnesota | 27129 | 2877 | 52 |
2071504 | 2071504 | 2022-01-01 | Renville | Minnesota | 27129 | 2877 | 52 |
2068253 | 2068253 | 2021-12-31 | Renville | Minnesota | 27129 | 2877 | 52 |
2065002 | 2065002 | 2021-12-30 | Renville | Minnesota | 27129 | 2877 | 52 |
2057731 | 2057731 | 2021-12-28 | De Witt | Illinois | 17039 | 2877 | 39 |
2040997 | 2040997 | 2021-12-23 | Franklin | Arkansas | 5047 | 2877 | 58 |
2008967 | 2008967 | 2021-12-13 | Cass | Illinois | 17017 | 2877 | 40 |
1972091 | 1972091 | 2021-12-01 | Houston | Texas | 48225 | 2877 | 87 |
1968841 | 1968841 | 2021-11-30 | Houston | Texas | 48225 | 2877 | 87 |
1959846 | 1959846 | 2021-11-28 | Alamosa | Colorado | 8003 | 2877 | 48 |
1956595 | 1956595 | 2021-11-27 | Alamosa | Colorado | 8003 | 2877 | 47 |
1953344 | 1953344 | 2021-11-26 | Alamosa | Colorado | 8003 | 2877 | 47 |
1950093 | 1950093 | 2021-11-25 | Alamosa | Colorado | 8003 | 2877 | 47 |
1940675 | 1940675 | 2021-11-22 | Gem | Idaho | 16045 | 2877 | 68 |
1938806 | 1938806 | 2021-11-21 | Madison | North Carolina | 37115 | 2877 | 64 |
1935556 | 1935556 | 2021-11-20 | Madison | North Carolina | 37115 | 2877 | 64 |
1932306 | 1932306 | 2021-11-19 | Madison | North Carolina | 37115 | 2877 | 64 |
1924884 | 1924884 | 2021-11-17 | Garrard | Kentucky | 21079 | 2877 | 51 |
1914868 | 1914868 | 2021-11-14 | Rush | Indiana | 18139 | 2877 | 32 |
1911618 | 1911618 | 2021-11-13 | Rush | Indiana | 18139 | 2877 | 32 |
1908369 | 1908369 | 2021-11-12 | Rush | Indiana | 18139 | 2877 | 32 |
1884658 | 1884658 | 2021-11-04 | Asotin | Washington | 53003 | 2877 | 50 |
1879695 | 1879695 | 2021-11-03 | Dodge | Minnesota | 27039 | 2877 | 10 |
1879870 | 1879870 | 2021-11-03 | Clinton | Missouri | 29049 | 2877 | 77 |
1847902 | 1847902 | 2021-10-24 | Rolette | North Dakota | 38079 | 2877 | 32 |
1806896 | 1806896 | 2021-10-12 | Fayette | Alabama | 1057 | 2877 | 78 |
1809636 | 1809636 | 2021-10-12 | Lee | Texas | 48287 | 2877 | 49 |
1803645 | 1803645 | 2021-10-11 | Fayette | Alabama | 1057 | 2877 | 78 |
1804380 | 1804380 | 2021-10-11 | Orange | Indiana | 18117 | 2877 | 65 |
1802439 | 1802439 | 2021-10-10 | Carroll | Ohio | 39019 | 2877 | 57 |
1790958 | 1790958 | 2021-10-07 | Dixie | Florida | 12029 | 2877 | 32 |
1793733 | 1793733 | 2021-10-07 | Hampshire | West Virginia | 54027 | 2877 | 46 |
1787709 | 1787709 | 2021-10-06 | Dixie | Florida | 12029 | 2877 | 32 |
1784460 | 1784460 | 2021-10-05 | Dixie | Florida | 12029 | 2877 | 32 |
1781042 | 1781042 | 2021-10-04 | Polk | Arkansas | 5113 | 2877 | 101 |
1781211 | 1781211 | 2021-10-04 | Dixie | Florida | 12029 | 2877 | 32 |
1777961 | 1777961 | 2021-10-03 | Dixie | Florida | 12029 | 2877 | 32 |
1780599 | 1780599 | 2021-10-03 | Fredericksburg city | Virginia | 51630 | 2877 | 25 |
1774711 | 1774711 | 2021-10-02 | Dixie | Florida | 12029 | 2877 | 30 |
1777349 | 1777349 | 2021-10-02 | Fredericksburg city | Virginia | 51630 | 2877 | 25 |
1771461 | 1771461 | 2021-10-01 | Dixie | Florida | 12029 | 2877 | 30 |
1774099 | 1774099 | 2021-10-01 | Fredericksburg city | Virginia | 51630 | 2877 | 25 |
1760388 | 1760388 | 2021-09-27 | Union | Oregon | 41061 | 2877 | 38 |
1738669 | 1738669 | 2021-09-21 | Hale | Alabama | 1065 | 2877 | 81 |
1741042 | 1741042 | 2021-09-21 | Vega Alta | Puerto Rico | 72143 | 2877 | |
1734543 | 1734543 | 2021-09-19 | Vega Alta | Puerto Rico | 72143 | 2877 | |
1725740 | 1725740 | 2021-09-17 | La Paz | Arizona | 4012 | 2877 | 86 |
1728557 | 1728557 | 2021-09-17 | Rutland | Vermont | 50021 | 2877 | 22 |
1721581 | 1721581 | 2021-09-15 | Hampton | South Carolina | 45049 | 2877 | 66 |
1719016 | 1719016 | 2021-09-14 | Mason | West Virginia | 54053 | 2877 | 43 |
1712011 | 1712011 | 2021-09-12 | Trousdale | Tennessee | 47169 | 2877 | 23 |
1708764 | 1708764 | 2021-09-11 | Trousdale | Tennessee | 47169 | 2877 | 23 |
1705517 | 1705517 | 2021-09-10 | Trousdale | Tennessee | 47169 | 2877 | 23 |
1699948 | 1699948 | 2021-09-09 | Pitkin | Colorado | 8097 | 2877 | 4 |
1700705 | 1700705 | 2021-09-09 | Hart | Kentucky | 21099 | 2877 | 56 |
1700775 | 1700775 | 2021-09-09 | Woodford | Kentucky | 21239 | 2877 | 23 |
1698776 | 1698776 | 2021-09-08 | Juncos | Puerto Rico | 72077 | 2877 | |
1685732 | 1685732 | 2021-09-04 | Susquehanna | Pennsylvania | 42115 | 2877 | 62 |
1682493 | 1682493 | 2021-09-03 | Aguadilla | Puerto Rico | 72005 | 2877 | |
1679449 | 1679449 | 2021-09-02 | Chester | Tennessee | 47023 | 2877 | 55 |
1675606 | 1675606 | 2021-09-01 | Greene | North Carolina | 37079 | 2877 | 50 |
1672658 | 1672658 | 2021-08-31 | Jefferson | Oregon | 41031 | 2877 | 45 |
1667566 | 1667566 | 2021-08-30 | Ben Hill | Georgia | 13017 | 2877 | 85 |
1665782 | 1665782 | 2021-08-29 | Franklin | New York | 36033 | 2877 | 12 |
1667103 | 1667103 | 2021-08-29 | Kewaunee | Wisconsin | 55061 | 2877 | 37 |
1663855 | 1663855 | 2021-08-28 | Kewaunee | Wisconsin | 55061 | 2877 | 37 |
1660607 | 1660607 | 2021-08-27 | Kewaunee | Wisconsin | 55061 | 2877 | 37 |
1650773 | 1650773 | 2021-08-24 | Stevens | Washington | 53065 | 2877 | 33 |
1644584 | 1644584 | 2021-08-23 | Logan | Arkansas | 5083 | 2877 | 28 |
1621001 | 1621001 | 2021-08-15 | Grainger | Tennessee | 47057 | 2877 | 51 |
1617753 | 1617753 | 2021-08-14 | Grainger | Tennessee | 47057 | 2877 | 51 |
1614505 | 1614505 | 2021-08-13 | Grainger | Tennessee | 47057 | 2877 | 51 |
1608580 | 1608580 | 2021-08-11 | Mingo | West Virginia | 54059 | 2877 | 45 |
1588671 | 1588671 | 2021-08-05 | Gonzales | Texas | 48177 | 2877 | 59 |
1583870 | 1583870 | 2021-08-04 | Richland | Louisiana | 22083 | 2877 | 58 |
1564375 | 1564375 | 2021-07-29 | Plaquemines | Louisiana | 22075 | 2877 | 27 |
1554501 | 1554501 | 2021-07-26 | Clay | Kentucky | 21051 | 2877 | 46 |
1546021 | 1546021 | 2021-07-23 | Elk | Pennsylvania | 42047 | 2877 | 41 |
1542571 | 1542571 | 2021-07-22 | Fayette | Ohio | 39047 | 2877 | 50 |
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);