ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
384 rows where cases = 1143 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Kentucky 22
- Kansas 21
- North Carolina 20
- Virginia 19
- Idaho 18
- Illinois 18
- Georgia 17
- Arkansas 14
- Mississippi 14
- Missouri 13
- Ohio 13
- Nebraska 12
- Indiana 11
- Louisiana 11
- Minnesota 11
- West Virginia 11
- Montana 9
- Alabama 8
- Iowa 7
- New Mexico 7
- New York 7
- Oklahoma 7
- Puerto Rico 7
- Utah 7
- Michigan 6
- Tennessee 6
- Wyoming 5
- Florida 4
- North Dakota 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2375280 | 2375280 | 2022-04-04 | Donley | Texas | 48129 | 1143 | 26 |
2372028 | 2372028 | 2022-04-03 | Donley | Texas | 48129 | 1143 | 26 |
2368775 | 2368775 | 2022-04-02 | Donley | Texas | 48129 | 1143 | 26 |
2365522 | 2365522 | 2022-04-01 | Donley | Texas | 48129 | 1143 | 26 |
2307223 | 2307223 | 2022-03-14 | Charles City | Virginia | 51036 | 1143 | 27 |
2303972 | 2303972 | 2022-03-13 | Charles City | Virginia | 51036 | 1143 | 27 |
2300720 | 2300720 | 2022-03-12 | Charles City | Virginia | 51036 | 1143 | 27 |
2297468 | 2297468 | 2022-03-11 | Charles City | Virginia | 51036 | 1143 | 27 |
2294216 | 2294216 | 2022-03-10 | Charles City | Virginia | 51036 | 1143 | 27 |
2287726 | 2287726 | 2022-03-08 | Emporia city | Virginia | 51595 | 1143 | 53 |
2258729 | 2258729 | 2022-02-27 | Hot Springs | Wyoming | 56017 | 1143 | 15 |
2255478 | 2255478 | 2022-02-26 | Hot Springs | Wyoming | 56017 | 1143 | 15 |
2252227 | 2252227 | 2022-02-25 | Hot Springs | Wyoming | 56017 | 1143 | 15 |
2246779 | 2246779 | 2022-02-24 | Fulton | Kentucky | 21075 | 1143 | 23 |
2243528 | 2243528 | 2022-02-23 | Fulton | Kentucky | 21075 | 1143 | 23 |
2245357 | 2245357 | 2022-02-23 | Wheeler | Texas | 48483 | 1143 | 20 |
2240277 | 2240277 | 2022-02-22 | Fulton | Kentucky | 21075 | 1143 | 23 |
2236500 | 2236500 | 2022-02-21 | Schley | Georgia | 13249 | 1143 | 8 |
2233249 | 2233249 | 2022-02-20 | Schley | Georgia | 13249 | 1143 | 8 |
2229998 | 2229998 | 2022-02-19 | Schley | Georgia | 13249 | 1143 | 8 |
2226747 | 2226747 | 2022-02-18 | Schley | Georgia | 13249 | 1143 | 8 |
2225765 | 2225765 | 2022-02-17 | Martin | Texas | 48317 | 1143 | 26 |
2175328 | 2175328 | 2022-02-02 | Cameron | Louisiana | 22023 | 1143 | 8 |
2172560 | 2172560 | 2022-02-01 | Broadwater | Montana | 30007 | 1143 | 18 |
2142589 | 2142589 | 2022-01-23 | Gray | Kansas | 20069 | 1143 | 23 |
2142991 | 2142991 | 2022-01-23 | Big Stone | Minnesota | 27011 | 1143 | 7 |
2143483 | 2143483 | 2022-01-23 | Guadalupe | New Mexico | 35019 | 1143 | 15 |
2139334 | 2139334 | 2022-01-22 | Gray | Kansas | 20069 | 1143 | 23 |
2139736 | 2139736 | 2022-01-22 | Big Stone | Minnesota | 27011 | 1143 | 7 |
2140228 | 2140228 | 2022-01-22 | Guadalupe | New Mexico | 35019 | 1143 | 15 |
2136078 | 2136078 | 2022-01-21 | Gray | Kansas | 20069 | 1143 | 23 |
2136480 | 2136480 | 2022-01-21 | Big Stone | Minnesota | 27011 | 1143 | 7 |
2136972 | 2136972 | 2022-01-21 | Guadalupe | New Mexico | 35019 | 1143 | 15 |
2129726 | 2129726 | 2022-01-19 | Menifee | Kentucky | 21165 | 1143 | 28 |
2095507 | 2095507 | 2022-01-08 | Bailey | Texas | 48017 | 1143 | 31 |
2088732 | 2088732 | 2022-01-06 | Guayanilla | Puerto Rico | 72059 | 1143 | |
2073959 | 2073959 | 2022-01-02 | Power | Idaho | 16077 | 1143 | 17 |
2075097 | 2075097 | 2022-01-02 | Nemaha | Nebraska | 31127 | 1143 | 16 |
2070708 | 2070708 | 2022-01-01 | Power | Idaho | 16077 | 1143 | 17 |
2071846 | 2071846 | 2022-01-01 | Nemaha | Nebraska | 31127 | 1143 | 16 |
2067457 | 2067457 | 2021-12-31 | Power | Idaho | 16077 | 1143 | 17 |
2068595 | 2068595 | 2021-12-31 | Nemaha | Nebraska | 31127 | 1143 | 16 |
2064206 | 2064206 | 2021-12-30 | Power | Idaho | 16077 | 1143 | 17 |
2065344 | 2065344 | 2021-12-30 | Nemaha | Nebraska | 31127 | 1143 | 16 |
2062048 | 2062048 | 2021-12-29 | Clay | Nebraska | 31035 | 1143 | 17 |
2033762 | 2033762 | 2021-12-20 | Brooks | Texas | 48047 | 1143 | 47 |
2019802 | 2019802 | 2021-12-16 | Dawes | Nebraska | 31045 | 1143 | 21 |
2013123 | 2013123 | 2021-12-14 | Carter | Missouri | 29035 | 1143 | 18 |
1992709 | 1992709 | 2021-12-08 | Brown | Illinois | 17009 | 1143 | 18 |
1983947 | 1983947 | 2021-12-05 | Shannon | Missouri | 29203 | 1143 | 27 |
1943475 | 1943475 | 2021-11-23 | Dallas | Arkansas | 5039 | 1143 | 19 |
1924628 | 1924628 | 2021-11-17 | Union | Indiana | 18161 | 1143 | 17 |
1925567 | 1925567 | 2021-11-17 | Knox | Nebraska | 31107 | 1143 | 13 |
1918708 | 1918708 | 2021-11-15 | Lac qui Parle | Minnesota | 27073 | 1143 | 25 |
1920479 | 1920479 | 2021-11-15 | Pendleton | West Virginia | 54071 | 1143 | 15 |
1907754 | 1907754 | 2021-11-12 | Montgomery | Arkansas | 5097 | 1143 | 46 |
1904775 | 1904775 | 2021-11-11 | Crawford | Georgia | 13079 | 1143 | 43 |
1901525 | 1901525 | 2021-11-10 | Crawford | Georgia | 13079 | 1143 | 43 |
1879858 | 1879858 | 2021-11-03 | Caldwell | Missouri | 29025 | 1143 | 20 |
1873360 | 1873360 | 2021-11-01 | Caldwell | Missouri | 29025 | 1143 | 20 |
1874516 | 1874516 | 2021-11-01 | Coleman | Texas | 48083 | 1143 | 53 |
1871267 | 1871267 | 2021-10-31 | Coleman | Texas | 48083 | 1143 | 53 |
1868018 | 1868018 | 2021-10-30 | Coleman | Texas | 48083 | 1143 | 53 |
1800226 | 1800226 | 2021-10-09 | Doddridge | West Virginia | 54017 | 1143 | 9 |
1785811 | 1785811 | 2021-10-05 | Cheyenne | Nebraska | 31033 | 1143 | 19 |
1768916 | 1768916 | 2021-09-30 | Gallatin | Kentucky | 21077 | 1143 | 37 |
1762983 | 1762983 | 2021-09-28 | Sullivan | Missouri | 29211 | 1143 | 14 |
1742184 | 1742184 | 2021-09-22 | Rio Grande | Colorado | 8105 | 1143 | 21 |
1737041 | 1737041 | 2021-09-20 | Powell | Montana | 30077 | 1143 | 14 |
1725796 | 1725796 | 2021-09-17 | Monroe | Arkansas | 5095 | 1143 | 21 |
1723752 | 1723752 | 2021-09-16 | Koochiching | Minnesota | 27071 | 1143 | 19 |
1723823 | 1723823 | 2021-09-16 | Franklin | Mississippi | 28037 | 1143 | 27 |
1710933 | 1710933 | 2021-09-12 | Gentry | Missouri | 29075 | 1143 | 23 |
1677393 | 1677393 | 2021-09-02 | Macon | Georgia | 13193 | 1143 | 38 |
1678334 | 1678334 | 2021-09-02 | Choctaw | Mississippi | 28019 | 1143 | 21 |
1671816 | 1671816 | 2021-08-31 | Swift | Minnesota | 27151 | 1143 | 18 |
1669174 | 1669174 | 2021-08-30 | Benson | North Dakota | 38005 | 1143 | 20 |
1665927 | 1665927 | 2021-08-29 | Benson | North Dakota | 38005 | 1143 | 20 |
1662679 | 1662679 | 2021-08-28 | Benson | North Dakota | 38005 | 1143 | 20 |
1641351 | 1641351 | 2021-08-22 | Prairie | Arkansas | 5117 | 1143 | 26 |
1641899 | 1641899 | 2021-08-22 | Crawford | Indiana | 18025 | 1143 | 19 |
1638101 | 1638101 | 2021-08-21 | Prairie | Arkansas | 5117 | 1143 | 26 |
1638649 | 1638649 | 2021-08-21 | Crawford | Indiana | 18025 | 1143 | 19 |
1635399 | 1635399 | 2021-08-20 | Crawford | Indiana | 18025 | 1143 | 19 |
1623598 | 1623598 | 2021-08-16 | Alleghany | North Carolina | 37005 | 1143 | 5 |
1620068 | 1620068 | 2021-08-15 | Dawson | Montana | 30021 | 1143 | 32 |
1616820 | 1616820 | 2021-08-14 | Dawson | Montana | 30021 | 1143 | 32 |
1617600 | 1617600 | 2021-08-14 | Utuado | Puerto Rico | 72141 | 1143 | |
1613572 | 1613572 | 2021-08-13 | Dawson | Montana | 30021 | 1143 | 32 |
1608047 | 1608047 | 2021-08-11 | Perry | Tennessee | 47135 | 1143 | 29 |
1585545 | 1585545 | 2021-08-04 | Somervell | Texas | 48425 | 1143 | 14 |
1574934 | 1574934 | 2021-08-01 | Pamlico | North Carolina | 37137 | 1143 | 13 |
1571686 | 1571686 | 2021-07-31 | Pamlico | North Carolina | 37137 | 1143 | 13 |
1568438 | 1568438 | 2021-07-30 | Pamlico | North Carolina | 37137 | 1143 | 13 |
1565061 | 1565061 | 2021-07-29 | Torrance | New Mexico | 35057 | 1143 | 16 |
1562539 | 1562539 | 2021-07-28 | Houston | Tennessee | 47083 | 1143 | 34 |
1553198 | 1553198 | 2021-07-25 | Franklin city | Virginia | 51620 | 1143 | 33 |
1549353 | 1549353 | 2021-07-24 | Lares | Puerto Rico | 72081 | 1143 | |
1549951 | 1549951 | 2021-07-24 | Franklin city | Virginia | 51620 | 1143 | 33 |
1546704 | 1546704 | 2021-07-23 | Franklin city | Virginia | 51620 | 1143 | 33 |
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);