ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where cases = 232 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 95
- Georgia 77
- Virginia 44
- Alaska 35
- Kentucky 35
- Puerto Rico 30
- Nebraska 29
- Indiana 24
- Kansas 24
- Missouri 23
- Colorado 22
- New York 21
- South Dakota 21
- Michigan 20
- North Carolina 19
- Mississippi 18
- Ohio 18
- Iowa 17
- North Dakota 17
- Minnesota 16
- Tennessee 16
- Idaho 15
- Pennsylvania 15
- West Virginia 15
- Arkansas 13
- Montana 12
- Illinois 11
- Wisconsin 9
- South Carolina 8
- Louisiana 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2188824 | 2188824 | 2022-02-06 | Carter | Montana | 30011 | 232 | 5 |
2185571 | 2185571 | 2022-02-05 | Carter | Montana | 30011 | 232 | 5 |
2182319 | 2182319 | 2022-02-04 | Carter | Montana | 30011 | 232 | 5 |
2150688 | 2150688 | 2022-01-25 | Sully | South Dakota | 46119 | 232 | 3 |
2146356 | 2146356 | 2022-01-24 | Issaquena | Mississippi | 28055 | 232 | 7 |
2147436 | 2147436 | 2022-01-24 | Sully | South Dakota | 46119 | 232 | 3 |
2131484 | 2131484 | 2022-01-19 | Sterling | Texas | 48431 | 232 | 5 |
2086461 | 2086461 | 2022-01-06 | Wrangell City and Borough | Alaska | 2275 | 232 | 1 |
2082609 | 2082609 | 2022-01-04 | Irion | Texas | 48235 | 232 | 2 |
2059607 | 2059607 | 2021-12-28 | Hyde | South Dakota | 46069 | 232 | 5 |
2033160 | 2033160 | 2021-12-20 | Sheridan | North Dakota | 38083 | 232 | 5 |
2029910 | 2029910 | 2021-12-19 | Sheridan | North Dakota | 38083 | 232 | 5 |
1971132 | 1971132 | 2021-12-01 | Storey | Nevada | 32029 | 232 | 6 |
1967798 | 1967798 | 2021-11-30 | Deuel | Nebraska | 31049 | 232 | 2 |
1964546 | 1964546 | 2021-11-29 | Deuel | Nebraska | 31049 | 232 | 2 |
1959675 | 1959675 | 2021-11-28 | Haines Borough | Alaska | 2100 | 232 | 1 |
1956424 | 1956424 | 2021-11-27 | Haines Borough | Alaska | 2100 | 232 | 1 |
1956603 | 1956603 | 2021-11-27 | Cheyenne | Colorado | 8017 | 232 | 7 |
1953173 | 1953173 | 2021-11-26 | Haines Borough | Alaska | 2100 | 232 | 1 |
1953352 | 1953352 | 2021-11-26 | Cheyenne | Colorado | 8017 | 232 | 7 |
1949922 | 1949922 | 2021-11-25 | Haines Borough | Alaska | 2100 | 232 | 1 |
1950101 | 1950101 | 2021-11-25 | Cheyenne | Colorado | 8017 | 232 | 7 |
1946671 | 1946671 | 2021-11-24 | Haines Borough | Alaska | 2100 | 232 | 1 |
1943420 | 1943420 | 2021-11-23 | Haines Borough | Alaska | 2100 | 232 | 1 |
1946187 | 1946187 | 2021-11-23 | Stonewall | Texas | 48433 | 232 | 6 |
1940170 | 1940170 | 2021-11-22 | Haines Borough | Alaska | 2100 | 232 | 1 |
1942936 | 1942936 | 2021-11-22 | Stonewall | Texas | 48433 | 232 | 6 |
1936920 | 1936920 | 2021-11-21 | Haines Borough | Alaska | 2100 | 232 | 1 |
1939686 | 1939686 | 2021-11-21 | Stonewall | Texas | 48433 | 232 | 6 |
1933670 | 1933670 | 2021-11-20 | Haines Borough | Alaska | 2100 | 232 | 1 |
1936436 | 1936436 | 2021-11-20 | Stonewall | Texas | 48433 | 232 | 6 |
1930418 | 1930418 | 2021-11-19 | Haines Borough | Alaska | 2100 | 232 | 1 |
1933186 | 1933186 | 2021-11-19 | Stonewall | Texas | 48433 | 232 | 6 |
1927168 | 1927168 | 2021-11-18 | Haines Borough | Alaska | 2100 | 232 | 1 |
1929935 | 1929935 | 2021-11-18 | Stonewall | Texas | 48433 | 232 | 6 |
1923918 | 1923918 | 2021-11-17 | Haines Borough | Alaska | 2100 | 232 | 1 |
1926685 | 1926685 | 2021-11-17 | Stonewall | Texas | 48433 | 232 | 6 |
1920669 | 1920669 | 2021-11-16 | Haines Borough | Alaska | 2100 | 232 | 1 |
1923435 | 1923435 | 2021-11-16 | Stonewall | Texas | 48433 | 232 | 6 |
1920186 | 1920186 | 2021-11-15 | Stonewall | Texas | 48433 | 232 | 6 |
1916936 | 1916936 | 2021-11-14 | Stonewall | Texas | 48433 | 232 | 6 |
1913686 | 1913686 | 2021-11-13 | Stonewall | Texas | 48433 | 232 | 6 |
1910436 | 1910436 | 2021-11-12 | Stonewall | Texas | 48433 | 232 | 6 |
1907187 | 1907187 | 2021-11-11 | Stonewall | Texas | 48433 | 232 | 6 |
1903938 | 1903938 | 2021-11-10 | Stonewall | Texas | 48433 | 232 | 6 |
1900688 | 1900688 | 2021-11-09 | Stonewall | Texas | 48433 | 232 | 6 |
1897438 | 1897438 | 2021-11-08 | Stonewall | Texas | 48433 | 232 | 6 |
1893162 | 1893162 | 2021-11-07 | Catron | New Mexico | 35003 | 232 | 7 |
1894188 | 1894188 | 2021-11-07 | Stonewall | Texas | 48433 | 232 | 6 |
1889912 | 1889912 | 2021-11-06 | Catron | New Mexico | 35003 | 232 | 7 |
1890938 | 1890938 | 2021-11-06 | Stonewall | Texas | 48433 | 232 | 6 |
1886662 | 1886662 | 2021-11-05 | Catron | New Mexico | 35003 | 232 | 7 |
1887494 | 1887494 | 2021-11-05 | Briscoe | Texas | 48045 | 232 | 7 |
1887688 | 1887688 | 2021-11-05 | Stonewall | Texas | 48433 | 232 | 6 |
1884244 | 1884244 | 2021-11-04 | Briscoe | Texas | 48045 | 232 | 7 |
1884438 | 1884438 | 2021-11-04 | Stonewall | Texas | 48433 | 232 | 6 |
1880995 | 1880995 | 2021-11-03 | Briscoe | Texas | 48045 | 232 | 7 |
1833121 | 1833121 | 2021-10-20 | Dolores | Colorado | 8033 | 232 | 2 |
1814279 | 1814279 | 2021-10-14 | Comanche | Kansas | 20033 | 232 | 11 |
1815064 | 1815064 | 2021-10-14 | Dundy | Nebraska | 31057 | 232 | 4 |
1811030 | 1811030 | 2021-10-13 | Comanche | Kansas | 20033 | 232 | 11 |
1785776 | 1785776 | 2021-10-05 | Powder River | Montana | 30075 | 232 | 9 |
1710320 | 1710320 | 2021-09-12 | Elk | Kansas | 20049 | 232 | 5 |
1707073 | 1707073 | 2021-09-11 | Elk | Kansas | 20049 | 232 | 5 |
1703825 | 1703825 | 2021-09-10 | Elk | Kansas | 20049 | 232 | 5 |
1700588 | 1700588 | 2021-09-09 | Hamilton | Kansas | 20075 | 232 | 1 |
1701487 | 1701487 | 2021-09-09 | Mora | New Mexico | 35033 | 232 | 9 |
1697339 | 1697339 | 2021-09-08 | Hamilton | Kansas | 20075 | 232 | 1 |
1656804 | 1656804 | 2021-08-26 | Armstrong | Texas | 48011 | 232 | 7 |
1653557 | 1653557 | 2021-08-25 | Armstrong | Texas | 48011 | 232 | 7 |
1650310 | 1650310 | 2021-08-24 | Armstrong | Texas | 48011 | 232 | 7 |
1647061 | 1647061 | 2021-08-23 | Armstrong | Texas | 48011 | 232 | 7 |
1643812 | 1643812 | 2021-08-22 | Armstrong | Texas | 48011 | 232 | 7 |
1640562 | 1640562 | 2021-08-21 | Armstrong | Texas | 48011 | 232 | 7 |
1635003 | 1635003 | 2021-08-20 | Unknown | Delaware | 232 | 0 | |
1634062 | 1634062 | 2021-08-19 | Armstrong | Texas | 48011 | 232 | 7 |
1631100 | 1631100 | 2021-08-18 | Grand Isle | Vermont | 50013 | 232 | 2 |
1625260 | 1625260 | 2021-08-17 | Unknown | Delaware | 232 | 0 | |
1618766 | 1618766 | 2021-08-15 | Unknown | Delaware | 232 | 0 | |
1615518 | 1615518 | 2021-08-14 | Unknown | Delaware | 232 | 0 | |
1505027 | 1505027 | 2021-07-11 | Custer | Colorado | 8027 | 232 | 3 |
1501781 | 1501781 | 2021-07-10 | Custer | Colorado | 8027 | 232 | 3 |
1485683 | 1485683 | 2021-07-05 | Baker | Georgia | 13007 | 232 | 10 |
1482437 | 1482437 | 2021-07-04 | Baker | Georgia | 13007 | 232 | 10 |
1479190 | 1479190 | 2021-07-03 | Baker | Georgia | 13007 | 232 | 10 |
1475944 | 1475944 | 2021-07-02 | Baker | Georgia | 13007 | 232 | 10 |
1449661 | 1449661 | 2021-06-24 | Dillingham Census Area | Alaska | 2070 | 232 | 2 |
1446416 | 1446416 | 2021-06-23 | Dillingham Census Area | Alaska | 2070 | 232 | 2 |
1443171 | 1443171 | 2021-06-22 | Dillingham Census Area | Alaska | 2070 | 232 | 2 |
1439926 | 1439926 | 2021-06-21 | Dillingham Census Area | Alaska | 2070 | 232 | 2 |
1436679 | 1436679 | 2021-06-20 | Dillingham Census Area | Alaska | 2070 | 232 | 2 |
1433432 | 1433432 | 2021-06-19 | Dillingham Census Area | Alaska | 2070 | 232 | 2 |
1430186 | 1430186 | 2021-06-18 | Dillingham Census Area | Alaska | 2070 | 232 | 2 |
1426941 | 1426941 | 2021-06-17 | Dillingham Census Area | Alaska | 2070 | 232 | 2 |
1423695 | 1423695 | 2021-06-16 | Dillingham Census Area | Alaska | 2070 | 232 | 2 |
1420448 | 1420448 | 2021-06-15 | Dillingham Census Area | Alaska | 2070 | 232 | 2 |
1417203 | 1417203 | 2021-06-14 | Dillingham Census Area | Alaska | 2070 | 232 | 2 |
1353318 | 1353318 | 2021-05-25 | Robertson | Kentucky | 21201 | 232 | 14 |
1350072 | 1350072 | 2021-05-24 | Robertson | Kentucky | 21201 | 232 | 14 |
1339622 | 1339622 | 2021-05-21 | Baker | Georgia | 13007 | 232 | 9 |
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);