ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
412 rows where cases = 918 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 61
- Texas 27
- South Dakota 24
- Iowa 23
- Kentucky 20
- Missouri 15
- Utah 15
- Virginia 15
- Nebraska 14
- Arkansas 13
- Montana 13
- Colorado 11
- Michigan 11
- Minnesota 11
- Puerto Rico 11
- Indiana 10
- Alaska 8
- Washington 8
- Kansas 7
- Mississippi 7
- Tennessee 7
- Illinois 6
- North Carolina 6
- Ohio 6
- South Carolina 6
- West Virginia 6
- Alabama 5
- Florida 5
- Idaho 5
- Oregon 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2317064 | 2317064 | 2022-03-17 | Rappahannock | Virginia | 51157 | 918 | 9 |
2290903 | 2290903 | 2022-03-09 | Garfield | Utah | 49017 | 918 | 14 |
2242758 | 2242758 | 2022-02-23 | Gilpin | Colorado | 8047 | 918 | 4 |
2220321 | 2220321 | 2022-02-16 | Lincoln | Idaho | 16063 | 918 | 14 |
2221122 | 2221122 | 2022-02-16 | Red Lake | Minnesota | 27125 | 918 | 11 |
2199452 | 2199452 | 2022-02-09 | Edmunds | South Dakota | 46045 | 918 | 16 |
2194151 | 2194151 | 2022-02-08 | Echols | Georgia | 13101 | 918 | 11 |
2190897 | 2190897 | 2022-02-07 | Echols | Georgia | 13101 | 918 | 11 |
2127091 | 2127091 | 2022-01-18 | Furnas | Nebraska | 31065 | 918 | 6 |
2128407 | 2128407 | 2022-01-18 | Norton city | Virginia | 51720 | 918 | 20 |
2109808 | 2109808 | 2022-01-13 | Putnam | Illinois | 17155 | 918 | 8 |
2105862 | 2105862 | 2022-01-11 | Hot Springs | Wyoming | 56017 | 918 | 12 |
2101072 | 2101072 | 2022-01-10 | Dixon | Nebraska | 31051 | 918 | 11 |
2063450 | 2063450 | 2021-12-29 | Skamania | Washington | 53059 | 918 | 9 |
2053682 | 2053682 | 2021-12-26 | Ferry | Washington | 53019 | 918 | 18 |
2050432 | 2050432 | 2021-12-25 | Ferry | Washington | 53019 | 918 | 18 |
2047182 | 2047182 | 2021-12-24 | Ferry | Washington | 53019 | 918 | 18 |
2043932 | 2043932 | 2021-12-23 | Ferry | Washington | 53019 | 918 | 18 |
2040683 | 2040683 | 2021-12-22 | Ferry | Washington | 53019 | 918 | 18 |
2034971 | 2034971 | 2021-12-21 | Calhoun | Illinois | 17013 | 918 | 7 |
1996332 | 1996332 | 2021-12-09 | Rooks | Kansas | 20163 | 918 | 15 |
1993081 | 1993081 | 2021-12-08 | Rooks | Kansas | 20163 | 918 | 15 |
1980628 | 1980628 | 2021-12-04 | Dade | Missouri | 29057 | 918 | 38 |
1966865 | 1966865 | 2021-11-30 | Ohio | Indiana | 18115 | 918 | 13 |
1938177 | 1938177 | 2021-11-21 | Big Stone | Minnesota | 27011 | 918 | 5 |
1934927 | 1934927 | 2021-11-20 | Big Stone | Minnesota | 27011 | 918 | 5 |
1931677 | 1931677 | 2021-11-19 | Big Stone | Minnesota | 27011 | 918 | 5 |
1929563 | 1929563 | 2021-11-18 | Brule | South Dakota | 46015 | 918 | 12 |
1914167 | 1914167 | 2021-11-14 | Dillingham Census Area | Alaska | 2070 | 918 | 7 |
1910917 | 1910917 | 2021-11-13 | Dillingham Census Area | Alaska | 2070 | 918 | 7 |
1907668 | 1907668 | 2021-11-12 | Dillingham Census Area | Alaska | 2070 | 918 | 7 |
1893394 | 1893394 | 2021-11-07 | Sioux | North Dakota | 38085 | 918 | 16 |
1858105 | 1858105 | 2021-10-27 | Kingsbury | South Dakota | 46077 | 918 | 18 |
1854856 | 1854856 | 2021-10-26 | Kingsbury | South Dakota | 46077 | 918 | 18 |
1851607 | 1851607 | 2021-10-25 | Kingsbury | South Dakota | 46077 | 918 | 18 |
1852212 | 1852212 | 2021-10-25 | Calhoun | West Virginia | 54013 | 918 | 4 |
1835106 | 1835106 | 2021-10-20 | Lake | Oregon | 41037 | 918 | 12 |
1832394 | 1832394 | 2021-10-19 | McCulloch | Texas | 48307 | 918 | 36 |
1809353 | 1809353 | 2021-10-12 | Fall River | South Dakota | 46047 | 918 | 22 |
1764178 | 1764178 | 2021-09-28 | Newton | Texas | 48351 | 918 | 46 |
1761274 | 1761274 | 2021-09-27 | Tucker | West Virginia | 54093 | 918 | 15 |
1723322 | 1723322 | 2021-09-16 | Greenwood | Kansas | 20073 | 918 | 11 |
1725496 | 1725496 | 2021-09-16 | Doddridge | West Virginia | 54017 | 918 | 6 |
1720073 | 1720073 | 2021-09-15 | Greenwood | Kansas | 20073 | 918 | 11 |
1716436 | 1716436 | 2021-09-14 | Wheeler | Georgia | 13309 | 918 | 28 |
1709484 | 1709484 | 2021-09-12 | Northwest Arctic Borough | Alaska | 2188 | 918 | 3 |
1711917 | 1711917 | 2021-09-12 | Spink | South Dakota | 46115 | 918 | 26 |
1706237 | 1706237 | 2021-09-11 | Northwest Arctic Borough | Alaska | 2188 | 918 | 3 |
1708670 | 1708670 | 2021-09-11 | Spink | South Dakota | 46115 | 918 | 26 |
1702989 | 1702989 | 2021-09-10 | Northwest Arctic Borough | Alaska | 2188 | 918 | 3 |
1705423 | 1705423 | 2021-09-10 | Spink | South Dakota | 46115 | 918 | 26 |
1678437 | 1678437 | 2021-09-02 | Daviess | Missouri | 29061 | 918 | 12 |
1671210 | 1671210 | 2021-08-31 | Adair | Iowa | 19001 | 918 | 32 |
1673331 | 1673331 | 2021-08-31 | Orange | Vermont | 50017 | 918 | 3 |
1667963 | 1667963 | 2021-08-30 | Adair | Iowa | 19001 | 918 | 32 |
1664716 | 1664716 | 2021-08-29 | Adair | Iowa | 19001 | 918 | 32 |
1661468 | 1661468 | 2021-08-28 | Adair | Iowa | 19001 | 918 | 32 |
1658220 | 1658220 | 2021-08-27 | Adair | Iowa | 19001 | 918 | 32 |
1654972 | 1654972 | 2021-08-26 | Adair | Iowa | 19001 | 918 | 32 |
1651725 | 1651725 | 2021-08-25 | Adair | Iowa | 19001 | 918 | 32 |
1630329 | 1630329 | 2021-08-18 | Vinton | Ohio | 39163 | 918 | 17 |
1626604 | 1626604 | 2021-08-17 | Valley | Montana | 30105 | 918 | 18 |
1623061 | 1623061 | 2021-08-16 | Marshall | Minnesota | 27089 | 918 | 18 |
1623266 | 1623266 | 2021-08-16 | Ozark | Missouri | 29153 | 918 | 24 |
1608367 | 1608367 | 2021-08-11 | Lamoille | Vermont | 50015 | 918 | 3 |
1602153 | 1602153 | 2021-08-09 | Pepin | Wisconsin | 55091 | 918 | 7 |
1583195 | 1583195 | 2021-08-04 | McIntosh | Georgia | 13191 | 918 | 16 |
1585551 | 1585551 | 2021-08-04 | Swisher | Texas | 48437 | 918 | 18 |
1579941 | 1579941 | 2021-08-03 | Macon | Georgia | 13193 | 918 | 37 |
1582301 | 1582301 | 2021-08-03 | Swisher | Texas | 48437 | 918 | 18 |
1576776 | 1576776 | 2021-08-02 | Boundary | Idaho | 16021 | 918 | 14 |
1573491 | 1573491 | 2021-08-01 | Treutlen | Georgia | 13283 | 918 | 34 |
1570243 | 1570243 | 2021-07-31 | Treutlen | Georgia | 13283 | 918 | 34 |
1566995 | 1566995 | 2021-07-30 | Treutlen | Georgia | 13283 | 918 | 34 |
1569166 | 1569166 | 2021-07-30 | Floyd | Texas | 48153 | 918 | 30 |
1566239 | 1566239 | 2021-07-29 | Poquoson city | Virginia | 51735 | 918 | 18 |
1562991 | 1562991 | 2021-07-28 | Poquoson city | Virginia | 51735 | 918 | 18 |
1559743 | 1559743 | 2021-07-27 | Poquoson city | Virginia | 51735 | 918 | 18 |
1538775 | 1538775 | 2021-07-21 | Harrison | Missouri | 29081 | 918 | 14 |
1532669 | 1532669 | 2021-07-19 | Clay | North Carolina | 37043 | 918 | 18 |
1527657 | 1527657 | 2021-07-18 | Nevada | Arkansas | 5099 | 918 | 25 |
1527990 | 1527990 | 2021-07-18 | Montgomery | Georgia | 13209 | 918 | 23 |
1529114 | 1529114 | 2021-07-18 | Carbon | Montana | 30009 | 918 | 17 |
1524410 | 1524410 | 2021-07-17 | Nevada | Arkansas | 5099 | 918 | 25 |
1524743 | 1524743 | 2021-07-17 | Montgomery | Georgia | 13209 | 918 | 23 |
1525867 | 1525867 | 2021-07-17 | Carbon | Montana | 30009 | 918 | 17 |
1521162 | 1521162 | 2021-07-16 | Nevada | Arkansas | 5099 | 918 | 25 |
1521495 | 1521495 | 2021-07-16 | Montgomery | Georgia | 13209 | 918 | 23 |
1522620 | 1522620 | 2021-07-16 | Carbon | Montana | 30009 | 918 | 17 |
1519371 | 1519371 | 2021-07-15 | Carbon | Montana | 30009 | 918 | 17 |
1506385 | 1506385 | 2021-07-11 | Carbon | Montana | 30009 | 918 | 17 |
1503139 | 1503139 | 2021-07-10 | Carbon | Montana | 30009 | 918 | 17 |
1499893 | 1499893 | 2021-07-09 | Carbon | Montana | 30009 | 918 | 17 |
1495327 | 1495327 | 2021-07-08 | Rio Grande | Colorado | 8105 | 918 | 16 |
1489378 | 1489378 | 2021-07-06 | Ida | Iowa | 19093 | 918 | 35 |
1486131 | 1486131 | 2021-07-05 | Ida | Iowa | 19093 | 918 | 35 |
1482211 | 1482211 | 2021-07-04 | Prairie | Arkansas | 5117 | 918 | 22 |
1482885 | 1482885 | 2021-07-04 | Ida | Iowa | 19093 | 918 | 35 |
1478964 | 1478964 | 2021-07-03 | Prairie | Arkansas | 5117 | 918 | 22 |
1479638 | 1479638 | 2021-07-03 | Ida | Iowa | 19093 | 918 | 35 |
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);