ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,297 rows where cases = 116 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 159
- Nebraska 52
- Georgia 50
- Missouri 50
- Montana 50
- Indiana 46
- Kentucky 45
- Virginia 42
- Iowa 40
- Ohio 39
- Minnesota 38
- Puerto Rico 38
- Colorado 36
- Michigan 35
- Illinois 34
- Mississippi 31
- North Carolina 31
- South Dakota 31
- Pennsylvania 29
- Washington 29
- Oklahoma 28
- Tennessee 26
- Kansas 25
- West Virginia 23
- North Dakota 22
- Oregon 22
- Wisconsin 21
- Alabama 20
- Arkansas 18
- New York 18
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2403371 | 2403371 | 2022-04-13 | Unknown | Mississippi | 116 | 6 | |
2322386 | 2322386 | 2022-03-19 | Unknown | New Mexico | 116 | 15 | |
2319132 | 2319132 | 2022-03-18 | Unknown | New Mexico | 116 | 15 | |
2251839 | 2251839 | 2022-02-25 | Terrell | Texas | 48443 | 116 | 3 |
2248588 | 2248588 | 2022-02-24 | Terrell | Texas | 48443 | 116 | 3 |
2245337 | 2245337 | 2022-02-23 | Terrell | Texas | 48443 | 116 | 3 |
2242086 | 2242086 | 2022-02-22 | Terrell | Texas | 48443 | 116 | 3 |
2238835 | 2238835 | 2022-02-21 | Terrell | Texas | 48443 | 116 | 3 |
2235584 | 2235584 | 2022-02-20 | Terrell | Texas | 48443 | 116 | 3 |
2232333 | 2232333 | 2022-02-19 | Terrell | Texas | 48443 | 116 | 3 |
2153180 | 2153180 | 2022-01-26 | Wheeler | Nebraska | 31183 | 116 | 0 |
2149928 | 2149928 | 2022-01-25 | Wheeler | Nebraska | 31183 | 116 | 0 |
2130308 | 2130308 | 2022-01-19 | Treasure | Montana | 30103 | 116 | 1 |
2127054 | 2127054 | 2022-01-18 | Treasure | Montana | 30103 | 116 | 1 |
2106066 | 2106066 | 2022-01-12 | Alpine | California | 6003 | 116 | 0 |
2102815 | 2102815 | 2022-01-11 | Alpine | California | 6003 | 116 | 0 |
2099564 | 2099564 | 2022-01-10 | Alpine | California | 6003 | 116 | 0 |
2055871 | 2055871 | 2021-12-27 | Billings | North Dakota | 38007 | 116 | 1 |
2052621 | 2052621 | 2021-12-26 | Billings | North Dakota | 38007 | 116 | 1 |
2053434 | 2053434 | 2021-12-26 | Roberts | Texas | 48393 | 116 | 1 |
2049371 | 2049371 | 2021-12-25 | Billings | North Dakota | 38007 | 116 | 1 |
2050184 | 2050184 | 2021-12-25 | Roberts | Texas | 48393 | 116 | 1 |
2046121 | 2046121 | 2021-12-24 | Billings | North Dakota | 38007 | 116 | 1 |
2046934 | 2046934 | 2021-12-24 | Roberts | Texas | 48393 | 116 | 1 |
2042871 | 2042871 | 2021-12-23 | Billings | North Dakota | 38007 | 116 | 1 |
2043684 | 2043684 | 2021-12-23 | Roberts | Texas | 48393 | 116 | 1 |
2040435 | 2040435 | 2021-12-22 | Roberts | Texas | 48393 | 116 | 1 |
2037185 | 2037185 | 2021-12-21 | Roberts | Texas | 48393 | 116 | 1 |
2037247 | 2037247 | 2021-12-21 | Daggett | Utah | 49009 | 116 | 0 |
2033935 | 2033935 | 2021-12-20 | Roberts | Texas | 48393 | 116 | 1 |
2030685 | 2030685 | 2021-12-19 | Roberts | Texas | 48393 | 116 | 1 |
2026621 | 2026621 | 2021-12-18 | Billings | North Dakota | 38007 | 116 | 1 |
2027434 | 2027434 | 2021-12-18 | Roberts | Texas | 48393 | 116 | 1 |
2023370 | 2023370 | 2021-12-17 | Billings | North Dakota | 38007 | 116 | 1 |
2024183 | 2024183 | 2021-12-17 | Roberts | Texas | 48393 | 116 | 1 |
2020119 | 2020119 | 2021-12-16 | Billings | North Dakota | 38007 | 116 | 1 |
2016868 | 2016868 | 2021-12-15 | Billings | North Dakota | 38007 | 116 | 1 |
2006833 | 2006833 | 2021-12-12 | Logan | Nebraska | 31113 | 116 | 0 |
2003582 | 2003582 | 2021-12-11 | Logan | Nebraska | 31113 | 116 | 0 |
2000332 | 2000332 | 2021-12-10 | Logan | Nebraska | 31113 | 116 | 0 |
1991117 | 1991117 | 2021-12-07 | Wheeler | Oregon | 41069 | 116 | 1 |
1987866 | 1987866 | 2021-12-06 | Wheeler | Oregon | 41069 | 116 | 1 |
1925476 | 1925476 | 2021-11-17 | Golden Valley | Montana | 30037 | 116 | 4 |
1922227 | 1922227 | 2021-11-16 | Golden Valley | Montana | 30037 | 116 | 4 |
1914368 | 1914368 | 2021-11-14 | Jackson | Colorado | 8057 | 116 | 0 |
1911118 | 1911118 | 2021-11-13 | Jackson | Colorado | 8057 | 116 | 0 |
1907869 | 1907869 | 2021-11-12 | Jackson | Colorado | 8057 | 116 | 0 |
1904620 | 1904620 | 2021-11-11 | Jackson | Colorado | 8057 | 116 | 0 |
1901370 | 1901370 | 2021-11-10 | Jackson | Colorado | 8057 | 116 | 0 |
1898120 | 1898120 | 2021-11-09 | Jackson | Colorado | 8057 | 116 | 0 |
1894870 | 1894870 | 2021-11-08 | Jackson | Colorado | 8057 | 116 | 0 |
1864889 | 1864889 | 2021-10-29 | McMullen | Texas | 48311 | 116 | 8 |
1861640 | 1861640 | 2021-10-28 | McMullen | Texas | 48311 | 116 | 8 |
1858391 | 1858391 | 2021-10-27 | McMullen | Texas | 48311 | 116 | 8 |
1855142 | 1855142 | 2021-10-26 | McMullen | Texas | 48311 | 116 | 8 |
1851893 | 1851893 | 2021-10-25 | McMullen | Texas | 48311 | 116 | 8 |
1848643 | 1848643 | 2021-10-24 | McMullen | Texas | 48311 | 116 | 8 |
1845393 | 1845393 | 2021-10-23 | McMullen | Texas | 48311 | 116 | 8 |
1842143 | 1842143 | 2021-10-22 | McMullen | Texas | 48311 | 116 | 8 |
1838894 | 1838894 | 2021-10-21 | McMullen | Texas | 48311 | 116 | 8 |
1835645 | 1835645 | 2021-10-20 | McMullen | Texas | 48311 | 116 | 8 |
1811748 | 1811748 | 2021-10-13 | Garfield | Montana | 30033 | 116 | 3 |
1808499 | 1808499 | 2021-10-12 | Garfield | Montana | 30033 | 116 | 3 |
1805248 | 1805248 | 2021-10-11 | Garfield | Montana | 30033 | 116 | 3 |
1801999 | 1801999 | 2021-10-10 | Garfield | Montana | 30033 | 116 | 3 |
1798750 | 1798750 | 2021-10-09 | Garfield | Montana | 30033 | 116 | 3 |
1795501 | 1795501 | 2021-10-08 | Garfield | Montana | 30033 | 116 | 3 |
1796718 | 1796718 | 2021-10-08 | Throckmorton | Texas | 48447 | 116 | 5 |
1792252 | 1792252 | 2021-10-07 | Garfield | Montana | 30033 | 116 | 3 |
1793469 | 1793469 | 2021-10-07 | Throckmorton | Texas | 48447 | 116 | 5 |
1789003 | 1789003 | 2021-10-06 | Garfield | Montana | 30033 | 116 | 3 |
1785755 | 1785755 | 2021-10-05 | Garfield | Montana | 30033 | 116 | 3 |
1777910 | 1777910 | 2021-10-03 | Mineral | Colorado | 8079 | 116 | 1 |
1774660 | 1774660 | 2021-10-02 | Mineral | Colorado | 8079 | 116 | 1 |
1771410 | 1771410 | 2021-10-01 | Mineral | Colorado | 8079 | 116 | 1 |
1763123 | 1763123 | 2021-09-28 | Rock | Nebraska | 31149 | 116 | 2 |
1745411 | 1745411 | 2021-09-23 | Kiowa | Colorado | 8061 | 116 | 4 |
1743657 | 1743657 | 2021-09-22 | Eureka | Nevada | 32011 | 116 | 0 |
1735481 | 1735481 | 2021-09-20 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 116 | 2 |
1738144 | 1738144 | 2021-09-20 | Kent | Texas | 48263 | 116 | 3 |
1734894 | 1734894 | 2021-09-19 | Kent | Texas | 48263 | 116 | 3 |
1731644 | 1731644 | 2021-09-18 | Kent | Texas | 48263 | 116 | 3 |
1728394 | 1728394 | 2021-09-17 | Kent | Texas | 48263 | 116 | 3 |
1725145 | 1725145 | 2021-09-16 | Kent | Texas | 48263 | 116 | 3 |
1721896 | 1721896 | 2021-09-15 | Kent | Texas | 48263 | 116 | 3 |
1718648 | 1718648 | 2021-09-14 | Kent | Texas | 48263 | 116 | 3 |
1715143 | 1715143 | 2021-09-13 | Jones | South Dakota | 46075 | 116 | 0 |
1715400 | 1715400 | 2021-09-13 | Kent | Texas | 48263 | 116 | 3 |
1711897 | 1711897 | 2021-09-12 | Jones | South Dakota | 46075 | 116 | 0 |
1712154 | 1712154 | 2021-09-12 | Kent | Texas | 48263 | 116 | 3 |
1708650 | 1708650 | 2021-09-11 | Jones | South Dakota | 46075 | 116 | 0 |
1708907 | 1708907 | 2021-09-11 | Kent | Texas | 48263 | 116 | 3 |
1705403 | 1705403 | 2021-09-10 | Jones | South Dakota | 46075 | 116 | 0 |
1705660 | 1705660 | 2021-09-10 | Kent | Texas | 48263 | 116 | 3 |
1702410 | 1702410 | 2021-09-09 | Kent | Texas | 48263 | 116 | 3 |
1699161 | 1699161 | 2021-09-08 | Kent | Texas | 48263 | 116 | 3 |
1646670 | 1646670 | 2021-08-23 | Gilliam | Oregon | 41021 | 116 | 2 |
1630896 | 1630896 | 2021-08-18 | Glasscock | Texas | 48173 | 116 | 2 |
1625870 | 1625870 | 2021-08-17 | Greeley | Kansas | 20071 | 116 | 1 |
1622623 | 1622623 | 2021-08-16 | Greeley | Kansas | 20071 | 116 | 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);