ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
353 rows where cases = 1277 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 28
- Kentucky 21
- Kansas 18
- Mississippi 15
- North Dakota 15
- Georgia 14
- Colorado 12
- Tennessee 12
- Alabama 10
- Illinois 10
- Iowa 10
- Minnesota 10
- Missouri 9
- Puerto Rico 9
- South Carolina 9
- Virginia 9
- Arkansas 8
- Louisiana 8
- West Virginia 8
- Wisconsin 8
- Michigan 7
- North Carolina 7
- Utah 7
- Alaska 6
- Indiana 6
- Ohio 6
- Oregon 6
- South Dakota 6
- Florida 5
- New Mexico 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500558 | 2500558 | 2022-05-13 | Scott | Kansas | 20171 | 1277 | 34 |
2495775 | 2495775 | 2022-05-11 | Garza | Texas | 48169 | 1277 | 28 |
2492517 | 2492517 | 2022-05-10 | Garza | Texas | 48169 | 1277 | 28 |
2449085 | 2449085 | 2022-04-27 | Broadwater | Montana | 30007 | 1277 | 20 |
2450147 | 2450147 | 2022-04-27 | Crane | Texas | 48103 | 1277 | 24 |
2397037 | 2397037 | 2022-04-11 | Teton | Montana | 30099 | 1277 | 22 |
2360178 | 2360178 | 2022-03-31 | Alexander | Illinois | 17003 | 1277 | 15 |
2347545 | 2347545 | 2022-03-27 | Scott | Kansas | 20171 | 1277 | 34 |
2344292 | 2344292 | 2022-03-26 | Scott | Kansas | 20171 | 1277 | 34 |
2341039 | 2341039 | 2022-03-25 | Scott | Kansas | 20171 | 1277 | 34 |
2294664 | 2294664 | 2022-03-11 | Lafayette | Arkansas | 5073 | 1277 | 30 |
2291412 | 2291412 | 2022-03-10 | Lafayette | Arkansas | 5073 | 1277 | 30 |
2292247 | 2292247 | 2022-03-10 | Scott | Kansas | 20171 | 1277 | 34 |
2288160 | 2288160 | 2022-03-09 | Lafayette | Arkansas | 5073 | 1277 | 30 |
2288995 | 2288995 | 2022-03-09 | Scott | Kansas | 20171 | 1277 | 34 |
2285744 | 2285744 | 2022-03-08 | Scott | Kansas | 20171 | 1277 | 34 |
2282492 | 2282492 | 2022-03-07 | Scott | Kansas | 20171 | 1277 | 34 |
2218434 | 2218434 | 2022-02-15 | Hyde | North Carolina | 37095 | 1277 | 13 |
2202949 | 2202949 | 2022-02-10 | Hartley | Texas | 48205 | 1277 | 3 |
2203292 | 2203292 | 2022-02-10 | Ferry | Washington | 53019 | 1277 | 23 |
2199859 | 2199859 | 2022-02-09 | Kane | Utah | 49025 | 1277 | 13 |
2200038 | 2200038 | 2022-02-09 | Ferry | Washington | 53019 | 1277 | 23 |
2189706 | 2189706 | 2022-02-06 | Kingsbury | South Dakota | 46077 | 1277 | 20 |
2186453 | 2186453 | 2022-02-05 | Kingsbury | South Dakota | 46077 | 1277 | 20 |
2183201 | 2183201 | 2022-02-04 | Kingsbury | South Dakota | 46077 | 1277 | 20 |
2179949 | 2179949 | 2022-02-03 | Kingsbury | South Dakota | 46077 | 1277 | 20 |
2149858 | 2149858 | 2022-01-25 | Dawes | Nebraska | 31045 | 1277 | 21 |
2151319 | 2151319 | 2022-01-25 | Wirt | West Virginia | 54105 | 1277 | 19 |
2122391 | 2122391 | 2022-01-17 | Clear Creek | Colorado | 8019 | 1277 | 10 |
2108120 | 2108120 | 2022-01-12 | Harney | Oregon | 41025 | 1277 | 34 |
2097443 | 2097443 | 2022-01-09 | Schoolcraft | Michigan | 26153 | 1277 | 9 |
2094191 | 2094191 | 2022-01-08 | Schoolcraft | Michigan | 26153 | 1277 | 9 |
2095980 | 2095980 | 2022-01-08 | Calhoun | West Virginia | 54013 | 1277 | 9 |
2090939 | 2090939 | 2022-01-07 | Schoolcraft | Michigan | 26153 | 1277 | 9 |
2085060 | 2085060 | 2022-01-05 | Gates | North Carolina | 37073 | 1277 | 18 |
2077239 | 2077239 | 2022-01-03 | Edwards | Illinois | 17047 | 1277 | 22 |
2073640 | 2073640 | 2022-01-02 | Kit Carson | Colorado | 8063 | 1277 | 25 |
2076086 | 2076086 | 2022-01-02 | Hansford | Texas | 48195 | 1277 | 27 |
2070389 | 2070389 | 2022-01-01 | Kit Carson | Colorado | 8063 | 1277 | 25 |
2072835 | 2072835 | 2022-01-01 | Hansford | Texas | 48195 | 1277 | 27 |
2067138 | 2067138 | 2021-12-31 | Kit Carson | Colorado | 8063 | 1277 | 25 |
2069584 | 2069584 | 2021-12-31 | Hansford | Texas | 48195 | 1277 | 27 |
2066333 | 2066333 | 2021-12-30 | Hansford | Texas | 48195 | 1277 | 27 |
2059465 | 2059465 | 2021-12-28 | Comerio | Puerto Rico | 72045 | 1277 | |
2050699 | 2050699 | 2021-12-26 | Sitka City and Borough | Alaska | 2220 | 1277 | 5 |
2047449 | 2047449 | 2021-12-25 | Sitka City and Borough | Alaska | 2220 | 1277 | 5 |
2044199 | 2044199 | 2021-12-24 | Sitka City and Borough | Alaska | 2220 | 1277 | 5 |
2040950 | 2040950 | 2021-12-23 | Sitka City and Borough | Alaska | 2220 | 1277 | 5 |
2037700 | 2037700 | 2021-12-22 | Sitka City and Borough | Alaska | 2220 | 1277 | 5 |
2035775 | 2035775 | 2021-12-21 | Wilkin | Minnesota | 27167 | 1277 | 17 |
2024507 | 2024507 | 2021-12-17 | Tucker | West Virginia | 54093 | 1277 | 31 |
2020030 | 2020030 | 2021-12-16 | Camden | North Carolina | 37029 | 1277 | 9 |
2001740 | 2001740 | 2021-12-10 | Pendleton | West Virginia | 54071 | 1277 | 16 |
1996864 | 1996864 | 2021-12-09 | Caldwell | Missouri | 29025 | 1277 | 26 |
1998370 | 1998370 | 2021-12-09 | Northumberland | Virginia | 51133 | 1277 | 37 |
1945963 | 1945963 | 2021-11-23 | Van Buren | Tennessee | 47175 | 1277 | 29 |
1942712 | 1942712 | 2021-11-22 | Van Buren | Tennessee | 47175 | 1277 | 29 |
1920580 | 1920580 | 2021-11-15 | Johnson | Wyoming | 56019 | 1277 | 16 |
1905256 | 1905256 | 2021-11-11 | Clay | Kansas | 20027 | 1277 | 31 |
1902006 | 1902006 | 2021-11-10 | Clay | Kansas | 20027 | 1277 | 31 |
1898818 | 1898818 | 2021-11-09 | Pratt | Kansas | 20151 | 1277 | 27 |
1899444 | 1899444 | 2021-11-09 | St. Clair | Missouri | 29185 | 1277 | 14 |
1895568 | 1895568 | 2021-11-08 | Pratt | Kansas | 20151 | 1277 | 27 |
1896357 | 1896357 | 2021-11-08 | Wayne | Nebraska | 31179 | 1277 | 8 |
1887487 | 1887487 | 2021-11-05 | Blanco | Texas | 48031 | 1277 | 28 |
1884237 | 1884237 | 2021-11-04 | Blanco | Texas | 48031 | 1277 | 28 |
1868632 | 1868632 | 2021-10-31 | Greene | Alabama | 1063 | 1277 | 44 |
1865383 | 1865383 | 2021-10-30 | Greene | Alabama | 1063 | 1277 | 44 |
1862134 | 1862134 | 2021-10-29 | Greene | Alabama | 1063 | 1277 | 44 |
1858885 | 1858885 | 2021-10-28 | Greene | Alabama | 1063 | 1277 | 44 |
1818149 | 1818149 | 2021-10-15 | Gentry | Missouri | 29075 | 1277 | 26 |
1816606 | 1816606 | 2021-10-14 | Platte | Wyoming | 56031 | 1277 | 24 |
1788775 | 1788775 | 2021-10-06 | Swift | Minnesota | 27151 | 1277 | 19 |
1769302 | 1769302 | 2021-09-30 | Claiborne | Mississippi | 28021 | 1277 | 35 |
1770762 | 1770762 | 2021-09-30 | Emery | Utah | 49015 | 1277 | 16 |
1761017 | 1761017 | 2021-09-27 | Grand | Utah | 49019 | 1277 | 4 |
1746550 | 1746550 | 2021-09-23 | Yellow Medicine | Minnesota | 27173 | 1277 | 20 |
1743460 | 1743460 | 2021-09-22 | Oregon | Missouri | 29149 | 1277 | 10 |
1740528 | 1740528 | 2021-09-21 | Schuyler | New York | 36097 | 1277 | 16 |
1715063 | 1715063 | 2021-09-13 | Allendale | South Carolina | 45005 | 1277 | 17 |
1710561 | 1710561 | 2021-09-12 | Red River | Louisiana | 22081 | 1277 | 42 |
1707314 | 1707314 | 2021-09-11 | Red River | Louisiana | 22081 | 1277 | 42 |
1709060 | 1709060 | 2021-09-11 | Addison | Vermont | 50001 | 1277 | 8 |
1704066 | 1704066 | 2021-09-10 | Red River | Louisiana | 22081 | 1277 | 42 |
1683461 | 1683461 | 2021-09-04 | Perry | Alabama | 1105 | 1277 | 30 |
1677916 | 1677916 | 2021-09-02 | Bath | Kentucky | 21011 | 1277 | 24 |
1679746 | 1679746 | 2021-09-02 | Somervell | Texas | 48425 | 1277 | 17 |
1680011 | 1680011 | 2021-09-02 | Braxton | West Virginia | 54007 | 1277 | 6 |
1667722 | 1667722 | 2021-08-30 | Kauai | Hawaii | 15007 | 1277 | 3 |
1664842 | 1664842 | 2021-08-29 | Ellsworth | Kansas | 20053 | 1277 | 25 |
1661594 | 1661594 | 2021-08-28 | Ellsworth | Kansas | 20053 | 1277 | 25 |
1658346 | 1658346 | 2021-08-27 | Ellsworth | Kansas | 20053 | 1277 | 25 |
1651688 | 1651688 | 2021-08-25 | Newton | Indiana | 18111 | 1277 | 42 |
1629260 | 1629260 | 2021-08-18 | Magoffin | Kentucky | 21153 | 1277 | 18 |
1627167 | 1627167 | 2021-08-17 | Baker | Oregon | 41001 | 1277 | 18 |
1613537 | 1613537 | 2021-08-13 | Ripley | Missouri | 29181 | 1277 | 17 |
1606048 | 1606048 | 2021-08-11 | Teton | Idaho | 16081 | 1277 | 4 |
1602779 | 1602779 | 2021-08-10 | Franklin | Idaho | 16041 | 1277 | 17 |
1603340 | 1603340 | 2021-08-10 | East Carroll | Louisiana | 22035 | 1277 | 28 |
1600538 | 1600538 | 2021-08-09 | Ralls | Missouri | 29173 | 1277 | 13 |
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);