ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
921 rows where cases = 189 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 90
- Georgia 65
- Nebraska 48
- Colorado 41
- Virginia 39
- Kansas 38
- Montana 36
- Indiana 32
- Kentucky 30
- Ohio 28
- Missouri 25
- Iowa 24
- Minnesota 24
- Illinois 22
- Louisiana 22
- North Carolina 22
- Puerto Rico 22
- Alabama 21
- Michigan 21
- Mississippi 21
- North Dakota 19
- Arkansas 17
- South Carolina 16
- Tennessee 16
- New Mexico 14
- New York 14
- Alaska 13
- South Dakota 13
- Oklahoma 12
- Wisconsin 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469781 | 2469781 | 2022-05-03 | Loving | Texas | 48301 | 189 | 1 |
2453083 | 2453083 | 2022-04-28 | Culebra | Puerto Rico | 72049 | 189 | |
2173655 | 2173655 | 2022-02-01 | Glasscock | Texas | 48173 | 189 | 3 |
2170403 | 2170403 | 2022-01-31 | Glasscock | Texas | 48173 | 189 | 3 |
2167149 | 2167149 | 2022-01-30 | Glasscock | Texas | 48173 | 189 | 3 |
2154121 | 2154121 | 2022-01-26 | Foard | Texas | 48155 | 189 | 10 |
2150923 | 2150923 | 2022-01-25 | Kent | Texas | 48263 | 189 | 3 |
2147671 | 2147671 | 2022-01-24 | Kent | Texas | 48263 | 189 | 3 |
2143327 | 2143327 | 2022-01-23 | Wibaux | Montana | 30109 | 189 | 8 |
2140072 | 2140072 | 2022-01-22 | Wibaux | Montana | 30109 | 189 | 8 |
2136816 | 2136816 | 2022-01-21 | Wibaux | Montana | 30109 | 189 | 8 |
2103148 | 2103148 | 2022-01-11 | Taliaferro | Georgia | 13265 | 189 | 3 |
2085916 | 2085916 | 2022-01-05 | Motley | Texas | 48345 | 189 | 9 |
2076066 | 2076066 | 2022-01-02 | Foard | Texas | 48155 | 189 | 10 |
2072815 | 2072815 | 2022-01-01 | Foard | Texas | 48155 | 189 | 10 |
2069564 | 2069564 | 2021-12-31 | Foard | Texas | 48155 | 189 | 10 |
2066313 | 2066313 | 2021-12-30 | Foard | Texas | 48155 | 189 | 10 |
2063063 | 2063063 | 2021-12-29 | Foard | Texas | 48155 | 189 | 10 |
2059813 | 2059813 | 2021-12-28 | Foard | Texas | 48155 | 189 | 10 |
2056564 | 2056564 | 2021-12-27 | Foard | Texas | 48155 | 189 | 10 |
2053315 | 2053315 | 2021-12-26 | Foard | Texas | 48155 | 189 | 10 |
2050065 | 2050065 | 2021-12-25 | Foard | Texas | 48155 | 189 | 10 |
2046815 | 2046815 | 2021-12-24 | Foard | Texas | 48155 | 189 | 10 |
2043565 | 2043565 | 2021-12-23 | Foard | Texas | 48155 | 189 | 10 |
2019763 | 2019763 | 2021-12-16 | Prairie | Montana | 30079 | 189 | 2 |
2021031 | 2021031 | 2021-12-16 | Unknown | Vermont | 189 | 0 | |
2010011 | 2010011 | 2021-12-13 | Prairie | Montana | 30079 | 189 | 2 |
2006760 | 2006760 | 2021-12-12 | Prairie | Montana | 30079 | 189 | 2 |
2003509 | 2003509 | 2021-12-11 | Prairie | Montana | 30079 | 189 | 2 |
2000259 | 2000259 | 2021-12-10 | Prairie | Montana | 30079 | 189 | 2 |
1997008 | 1997008 | 2021-12-09 | Prairie | Montana | 30079 | 189 | 2 |
1993757 | 1993757 | 2021-12-08 | Prairie | Montana | 30079 | 189 | 2 |
1990506 | 1990506 | 2021-12-07 | Prairie | Montana | 30079 | 189 | 2 |
1967035 | 1967035 | 2021-11-30 | Greeley | Kansas | 20071 | 189 | 3 |
1968625 | 1968625 | 2021-11-30 | Sully | South Dakota | 46119 | 189 | 3 |
1963783 | 1963783 | 2021-11-29 | Greeley | Kansas | 20071 | 189 | 3 |
1939833 | 1939833 | 2021-11-21 | Highland | Virginia | 51091 | 189 | 4 |
1936583 | 1936583 | 2021-11-20 | Highland | Virginia | 51091 | 189 | 4 |
1933333 | 1933333 | 2021-11-19 | Highland | Virginia | 51091 | 189 | 4 |
1930081 | 1930081 | 2021-11-18 | Highland | Virginia | 51091 | 189 | 4 |
1891600 | 1891600 | 2021-11-07 | Cheyenne | Colorado | 8017 | 189 | 7 |
1888350 | 1888350 | 2021-11-06 | Cheyenne | Colorado | 8017 | 189 | 7 |
1885100 | 1885100 | 2021-11-05 | Cheyenne | Colorado | 8017 | 189 | 7 |
1884339 | 1884339 | 2021-11-04 | Irion | Texas | 48235 | 189 | 2 |
1884491 | 1884491 | 2021-11-04 | Piute | Utah | 49031 | 189 | 2 |
1881090 | 1881090 | 2021-11-03 | Irion | Texas | 48235 | 189 | 2 |
1881242 | 1881242 | 2021-11-03 | Piute | Utah | 49031 | 189 | 2 |
1860901 | 1860901 | 2021-10-28 | Sheridan | North Dakota | 38083 | 189 | 3 |
1855837 | 1855837 | 2021-10-27 | Sierra | California | 6091 | 189 | 0 |
1858101 | 1858101 | 2021-10-27 | Hyde | South Dakota | 46069 | 189 | 2 |
1854852 | 1854852 | 2021-10-26 | Hyde | South Dakota | 46069 | 189 | 2 |
1717335 | 1717335 | 2021-09-14 | Issaquena | Mississippi | 28055 | 189 | 6 |
1709472 | 1709472 | 2021-09-12 | Denali Borough | Alaska | 2068 | 189 | 0 |
1706225 | 1706225 | 2021-09-11 | Denali Borough | Alaska | 2068 | 189 | 0 |
1702977 | 1702977 | 2021-09-10 | Denali Borough | Alaska | 2068 | 189 | 0 |
1699727 | 1699727 | 2021-09-09 | Denali Borough | Alaska | 2068 | 189 | 0 |
1694442 | 1694442 | 2021-09-07 | Keweenaw | Michigan | 26083 | 189 | 2 |
1667710 | 1667710 | 2021-08-30 | Webster | Georgia | 13307 | 189 | 4 |
1634672 | 1634672 | 2021-08-19 | Niobrara | Wyoming | 56027 | 189 | 3 |
1628694 | 1628694 | 2021-08-18 | Quitman | Georgia | 13239 | 189 | 3 |
1625851 | 1625851 | 2021-08-17 | Comanche | Kansas | 20033 | 189 | 10 |
1626580 | 1626580 | 2021-08-17 | McCone | Montana | 30055 | 189 | 2 |
1626605 | 1626605 | 2021-08-17 | Wheatland | Montana | 30107 | 189 | 9 |
1622604 | 1622604 | 2021-08-16 | Comanche | Kansas | 20033 | 189 | 10 |
1623358 | 1623358 | 2021-08-16 | Wheatland | Montana | 30107 | 189 | 9 |
1623523 | 1623523 | 2021-08-16 | Mora | New Mexico | 35033 | 189 | 8 |
1620111 | 1620111 | 2021-08-15 | Wheatland | Montana | 30107 | 189 | 9 |
1616863 | 1616863 | 2021-08-14 | Wheatland | Montana | 30107 | 189 | 9 |
1613615 | 1613615 | 2021-08-13 | Wheatland | Montana | 30107 | 189 | 9 |
1610366 | 1610366 | 2021-08-12 | Wheatland | Montana | 30107 | 189 | 8 |
1605537 | 1605537 | 2021-08-11 | Petersburg Borough | Alaska | 2195 | 189 | 1 |
1600773 | 1600773 | 2021-08-09 | De Baca | New Mexico | 35011 | 189 | 2 |
1597525 | 1597525 | 2021-08-08 | De Baca | New Mexico | 35011 | 189 | 2 |
1594276 | 1594276 | 2021-08-07 | De Baca | New Mexico | 35011 | 189 | 2 |
1591027 | 1591027 | 2021-08-06 | De Baca | New Mexico | 35011 | 189 | 2 |
1586878 | 1586878 | 2021-08-05 | Elk | Kansas | 20049 | 189 | 5 |
1583628 | 1583628 | 2021-08-04 | Elk | Kansas | 20049 | 189 | 5 |
1580453 | 1580453 | 2021-08-03 | Wallace | Kansas | 20199 | 189 | 4 |
1577204 | 1577204 | 2021-08-02 | Wallace | Kansas | 20199 | 189 | 4 |
1557711 | 1557711 | 2021-07-27 | Stanton | Kansas | 20187 | 189 | 6 |
1554464 | 1554464 | 2021-07-26 | Stanton | Kansas | 20187 | 189 | 6 |
1553314 | 1553314 | 2021-07-25 | San Juan | Washington | 53055 | 189 | 0 |
1550067 | 1550067 | 2021-07-24 | San Juan | Washington | 53055 | 189 | 0 |
1546820 | 1546820 | 2021-07-23 | San Juan | Washington | 53055 | 189 | 0 |
1539254 | 1539254 | 2021-07-21 | Divide | North Dakota | 38023 | 189 | 2 |
1536007 | 1536007 | 2021-07-20 | Divide | North Dakota | 38023 | 189 | 2 |
1532759 | 1532759 | 2021-07-19 | Divide | North Dakota | 38023 | 189 | 2 |
1529512 | 1529512 | 2021-07-18 | Divide | North Dakota | 38023 | 189 | 2 |
1526265 | 1526265 | 2021-07-17 | Divide | North Dakota | 38023 | 189 | 2 |
1523018 | 1523018 | 2021-07-16 | Divide | North Dakota | 38023 | 189 | 2 |
1483654 | 1483654 | 2021-07-04 | Worth | Missouri | 29227 | 189 | 2 |
1480408 | 1480408 | 2021-07-03 | Worth | Missouri | 29227 | 189 | 2 |
1477161 | 1477161 | 2021-07-02 | Worth | Missouri | 29227 | 189 | 2 |
1471742 | 1471742 | 2021-06-30 | Dickens | Texas | 48125 | 189 | 10 |
1383687 | 1383687 | 2021-06-03 | Wallowa | Oregon | 41063 | 189 | 5 |
1380441 | 1380441 | 2021-06-02 | Wallowa | Oregon | 41063 | 189 | 5 |
1341914 | 1341914 | 2021-05-21 | Dickens | Texas | 48125 | 189 | 10 |
1338666 | 1338666 | 2021-05-20 | Dickens | Texas | 48125 | 189 | 10 |
1268061 | 1268061 | 2021-04-29 | Custer | Colorado | 8027 | 189 | 1 |
1264814 | 1264814 | 2021-04-28 | Custer | Colorado | 8027 | 189 | 1 |
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);