ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
556 rows where cases = 485 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 36
- Nebraska 35
- Texas 35
- Georgia 34
- Illinois 28
- Colorado 22
- Virginia 22
- Indiana 20
- Kansas 20
- Missouri 20
- Puerto Rico 19
- Idaho 15
- North Dakota 15
- Michigan 14
- Oklahoma 14
- Iowa 13
- Nevada 13
- Alabama 11
- Montana 11
- New Mexico 11
- Arkansas 10
- North Carolina 10
- South Dakota 10
- Ohio 8
- California 7
- Minnesota 7
- Oregon 7
- Pennsylvania 7
- South Carolina 7
- Utah 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2460791 | 2460791 | 2022-05-01 | Sedgwick | Colorado | 8115 | 485 | 10 |
2457535 | 2457535 | 2022-04-30 | Sedgwick | Colorado | 8115 | 485 | 10 |
2454279 | 2454279 | 2022-04-29 | Sedgwick | Colorado | 8115 | 485 | 10 |
2451023 | 2451023 | 2022-04-28 | Sedgwick | Colorado | 8115 | 485 | 10 |
2447767 | 2447767 | 2022-04-27 | Sedgwick | Colorado | 8115 | 485 | 10 |
2251755 | 2251755 | 2022-02-25 | Knox | Texas | 48275 | 485 | 23 |
2248504 | 2248504 | 2022-02-24 | Knox | Texas | 48275 | 485 | 23 |
2245253 | 2245253 | 2022-02-23 | Knox | Texas | 48275 | 485 | 23 |
2232322 | 2232322 | 2022-02-19 | Sherman | Texas | 48421 | 485 | 16 |
2229071 | 2229071 | 2022-02-18 | Sherman | Texas | 48421 | 485 | 16 |
2225820 | 2225820 | 2022-02-17 | Sherman | Texas | 48421 | 485 | 16 |
2175874 | 2175874 | 2022-02-02 | Brown | Nebraska | 31017 | 485 | 4 |
2117676 | 2117676 | 2022-01-15 | Renville | North Dakota | 38075 | 485 | 15 |
2115187 | 2115187 | 2022-01-14 | Oldham | Texas | 48359 | 485 | 6 |
2108365 | 2108365 | 2022-01-12 | Faulk | South Dakota | 46049 | 485 | 16 |
2078447 | 2078447 | 2022-01-03 | Mora | New Mexico | 35033 | 485 | 14 |
2029455 | 2029455 | 2021-12-19 | Scotland | Missouri | 29199 | 485 | 15 |
1901387 | 1901387 | 2021-11-10 | Ouray | Colorado | 8091 | 485 | 5 |
1903930 | 1903930 | 2021-11-10 | Shackelford | Texas | 48417 | 485 | 6 |
1900680 | 1900680 | 2021-11-09 | Shackelford | Texas | 48417 | 485 | 6 |
1867378 | 1867378 | 2021-10-30 | Hettinger | North Dakota | 38041 | 485 | 6 |
1858925 | 1858925 | 2021-10-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 485 | 0 |
1858541 | 1858541 | 2021-10-27 | Bath | Virginia | 51017 | 485 | 14 |
1855292 | 1855292 | 2021-10-26 | Bath | Virginia | 51017 | 485 | 14 |
1839021 | 1839021 | 2021-10-21 | Essex | Vermont | 50009 | 485 | 2 |
1834621 | 1834621 | 2021-10-20 | Webster | Nebraska | 31181 | 485 | 8 |
1830574 | 1830574 | 2021-10-19 | Ness | Kansas | 20135 | 485 | 17 |
1827325 | 1827325 | 2021-10-18 | Ness | Kansas | 20135 | 485 | 17 |
1814272 | 1814272 | 2021-10-14 | Chautauqua | Kansas | 20019 | 485 | 8 |
1810676 | 1810676 | 2021-10-13 | Adams | Idaho | 16003 | 485 | 9 |
1811023 | 1811023 | 2021-10-13 | Chautauqua | Kansas | 20019 | 485 | 8 |
1804210 | 1804210 | 2021-10-11 | Oneida | Idaho | 16071 | 485 | 6 |
1800661 | 1800661 | 2021-10-10 | Phillips | Colorado | 8095 | 485 | 14 |
1800961 | 1800961 | 2021-10-10 | Oneida | Idaho | 16071 | 485 | 6 |
1797412 | 1797412 | 2021-10-09 | Phillips | Colorado | 8095 | 485 | 14 |
1797712 | 1797712 | 2021-10-09 | Oneida | Idaho | 16071 | 485 | 6 |
1794163 | 1794163 | 2021-10-08 | Phillips | Colorado | 8095 | 485 | 14 |
1794463 | 1794463 | 2021-10-08 | Oneida | Idaho | 16071 | 485 | 6 |
1779358 | 1779358 | 2021-10-03 | Nance | Nebraska | 31125 | 485 | 10 |
1776108 | 1776108 | 2021-10-02 | Nance | Nebraska | 31125 | 485 | 10 |
1772858 | 1772858 | 2021-10-01 | Nance | Nebraska | 31125 | 485 | 10 |
1769523 | 1769523 | 2021-09-30 | Musselshell | Montana | 30065 | 485 | 15 |
1769609 | 1769609 | 2021-09-30 | Nance | Nebraska | 31125 | 485 | 10 |
1756566 | 1756566 | 2021-09-26 | Chase | Nebraska | 31029 | 485 | 5 |
1753318 | 1753318 | 2021-09-25 | Chase | Nebraska | 31029 | 485 | 5 |
1750070 | 1750070 | 2021-09-24 | Chase | Nebraska | 31029 | 485 | 5 |
1746114 | 1746114 | 2021-09-23 | Rush | Kansas | 20165 | 485 | 15 |
1746820 | 1746820 | 2021-09-23 | Chase | Nebraska | 31029 | 485 | 5 |
1746981 | 1746981 | 2021-09-23 | Union | New Mexico | 35059 | 485 | 10 |
1742865 | 1742865 | 2021-09-22 | Rush | Kansas | 20165 | 485 | 15 |
1740372 | 1740372 | 2021-09-21 | Nuckolls | Nebraska | 31129 | 485 | 12 |
1737123 | 1737123 | 2021-09-20 | Nuckolls | Nebraska | 31129 | 485 | 12 |
1722483 | 1722483 | 2021-09-16 | Yukon-Koyukuk Census Area | Alaska | 2290 | 485 | 4 |
1714702 | 1714702 | 2021-09-13 | Wells | North Dakota | 38103 | 485 | 8 |
1711456 | 1711456 | 2021-09-12 | Wells | North Dakota | 38103 | 485 | 8 |
1698424 | 1698424 | 2021-09-08 | Eddy | North Dakota | 38027 | 485 | 6 |
1695175 | 1695175 | 2021-09-07 | Dunn | North Dakota | 38025 | 485 | 7 |
1692594 | 1692594 | 2021-09-06 | Delta | Texas | 48119 | 485 | 15 |
1685429 | 1685429 | 2021-09-04 | Emmons | North Dakota | 38029 | 485 | 14 |
1682178 | 1682178 | 2021-09-03 | Emmons | North Dakota | 38029 | 485 | 14 |
1678929 | 1678929 | 2021-09-02 | Emmons | North Dakota | 38029 | 485 | 14 |
1671731 | 1671731 | 2021-08-31 | Schoolcraft | Michigan | 26153 | 485 | 5 |
1672568 | 1672568 | 2021-08-31 | Beaver | Oklahoma | 40007 | 485 | 6 |
1673483 | 1673483 | 2021-08-31 | Ferry | Washington | 53019 | 485 | 9 |
1667473 | 1667473 | 2021-08-30 | Washington | Colorado | 8121 | 485 | 13 |
1668484 | 1668484 | 2021-08-30 | Schoolcraft | Michigan | 26153 | 485 | 5 |
1669320 | 1669320 | 2021-08-30 | Beaver | Oklahoma | 40007 | 485 | 6 |
1669894 | 1669894 | 2021-08-30 | Haskell | Texas | 48207 | 485 | 28 |
1664226 | 1664226 | 2021-08-29 | Washington | Colorado | 8121 | 485 | 13 |
1666073 | 1666073 | 2021-08-29 | Beaver | Oklahoma | 40007 | 485 | 6 |
1666647 | 1666647 | 2021-08-29 | Haskell | Texas | 48207 | 485 | 28 |
1660978 | 1660978 | 2021-08-28 | Washington | Colorado | 8121 | 485 | 13 |
1662825 | 1662825 | 2021-08-28 | Beaver | Oklahoma | 40007 | 485 | 6 |
1663399 | 1663399 | 2021-08-28 | Haskell | Texas | 48207 | 485 | 28 |
1657730 | 1657730 | 2021-08-27 | Washington | Colorado | 8121 | 485 | 13 |
1659577 | 1659577 | 2021-08-27 | Beaver | Oklahoma | 40007 | 485 | 6 |
1660151 | 1660151 | 2021-08-27 | Haskell | Texas | 48207 | 485 | 28 |
1656328 | 1656328 | 2021-08-26 | Beaver | Oklahoma | 40007 | 485 | 6 |
1656902 | 1656902 | 2021-08-26 | Haskell | Texas | 48207 | 485 | 28 |
1653081 | 1653081 | 2021-08-25 | Beaver | Oklahoma | 40007 | 485 | 6 |
1633258 | 1633258 | 2021-08-19 | Hidalgo | New Mexico | 35023 | 485 | 9 |
1633468 | 1633468 | 2021-08-19 | Nelson | North Dakota | 38063 | 485 | 15 |
1628486 | 1628486 | 2021-08-18 | Saguache | Colorado | 8109 | 485 | 8 |
1625526 | 1625526 | 2021-08-17 | Lewis | Idaho | 16061 | 485 | 12 |
1610940 | 1610940 | 2021-08-12 | Harney | Oregon | 41025 | 485 | 11 |
1600725 | 1600725 | 2021-08-09 | Lander | Nevada | 32015 | 485 | 9 |
1601292 | 1601292 | 2021-08-09 | Arroyo | Puerto Rico | 72015 | 485 | |
1602184 | 1602184 | 2021-08-09 | Crook | Wyoming | 56011 | 485 | 13 |
1597477 | 1597477 | 2021-08-08 | Lander | Nevada | 32015 | 485 | 9 |
1598370 | 1598370 | 2021-08-08 | Coke | Texas | 48081 | 485 | 13 |
1594228 | 1594228 | 2021-08-07 | Lander | Nevada | 32015 | 485 | 9 |
1595121 | 1595121 | 2021-08-07 | Coke | Texas | 48081 | 485 | 13 |
1590979 | 1590979 | 2021-08-06 | Lander | Nevada | 32015 | 485 | 9 |
1587730 | 1587730 | 2021-08-05 | Lander | Nevada | 32015 | 485 | 9 |
1584479 | 1584479 | 2021-08-04 | Lander | Nevada | 32015 | 485 | 9 |
1581230 | 1581230 | 2021-08-03 | Lander | Nevada | 32015 | 485 | 9 |
1577981 | 1577981 | 2021-08-02 | Lander | Nevada | 32015 | 485 | 9 |
1574733 | 1574733 | 2021-08-01 | Lander | Nevada | 32015 | 485 | 9 |
1571485 | 1571485 | 2021-07-31 | Lander | Nevada | 32015 | 485 | 9 |
1572555 | 1572555 | 2021-07-31 | Sutton | Texas | 48435 | 485 | 8 |
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);