ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
501 rows where cases = 1123 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 43
- Texas 39
- Iowa 32
- Kansas 23
- Missouri 21
- Tennessee 21
- Nebraska 20
- Puerto Rico 18
- Georgia 17
- Kentucky 16
- Mississippi 16
- Alabama 15
- Louisiana 15
- Michigan 15
- North Dakota 15
- North Carolina 14
- Montana 13
- Oklahoma 13
- Alaska 11
- Arkansas 10
- Florida 10
- Illinois 10
- Minnesota 9
- Ohio 9
- South Carolina 7
- West Virginia 7
- Indiana 6
- Utah 6
- Colorado 5
- Guam 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489466 | 2489466 | 2022-05-09 | Grand Isle | Vermont | 50013 | 1123 | 5 |
2465449 | 2465449 | 2022-05-02 | Furnas | Nebraska | 31065 | 1123 | 8 |
2462194 | 2462194 | 2022-05-01 | Furnas | Nebraska | 31065 | 1123 | 8 |
2463451 | 2463451 | 2022-05-01 | Craig | Virginia | 51045 | 1123 | 18 |
2458938 | 2458938 | 2022-04-30 | Furnas | Nebraska | 31065 | 1123 | 8 |
2460195 | 2460195 | 2022-04-30 | Craig | Virginia | 51045 | 1123 | 18 |
2455682 | 2455682 | 2022-04-29 | Furnas | Nebraska | 31065 | 1123 | 8 |
2456939 | 2456939 | 2022-04-29 | Craig | Virginia | 51045 | 1123 | 18 |
2453683 | 2453683 | 2022-04-28 | Craig | Virginia | 51045 | 1123 | 18 |
2450427 | 2450427 | 2022-04-27 | Craig | Virginia | 51045 | 1123 | 18 |
2447170 | 2447170 | 2022-04-26 | Craig | Virginia | 51045 | 1123 | 18 |
2436821 | 2436821 | 2022-04-23 | Las Marias | Puerto Rico | 72083 | 1123 | |
2427672 | 2427672 | 2022-04-20 | King and Queen | Virginia | 51097 | 1123 | 12 |
2404880 | 2404880 | 2022-04-13 | King and Queen | Virginia | 51097 | 1123 | 12 |
2401625 | 2401625 | 2022-04-12 | King and Queen | Virginia | 51097 | 1123 | 12 |
2398370 | 2398370 | 2022-04-11 | King and Queen | Virginia | 51097 | 1123 | 12 |
2378838 | 2378838 | 2022-04-05 | King and Queen | Virginia | 51097 | 1123 | 12 |
2375584 | 2375584 | 2022-04-04 | King and Queen | Virginia | 51097 | 1123 | 12 |
2372332 | 2372332 | 2022-04-03 | King and Queen | Virginia | 51097 | 1123 | 12 |
2369079 | 2369079 | 2022-04-02 | King and Queen | Virginia | 51097 | 1123 | 12 |
2365826 | 2365826 | 2022-04-01 | King and Queen | Virginia | 51097 | 1123 | 12 |
2362573 | 2362573 | 2022-03-31 | King and Queen | Virginia | 51097 | 1123 | 12 |
2292969 | 2292969 | 2022-03-10 | Furnas | Nebraska | 31065 | 1123 | 6 |
2289717 | 2289717 | 2022-03-09 | Furnas | Nebraska | 31065 | 1123 | 6 |
2266949 | 2266949 | 2022-03-02 | Furnas | Nebraska | 31065 | 1123 | 6 |
2263698 | 2263698 | 2022-03-01 | Furnas | Nebraska | 31065 | 1123 | 6 |
2264958 | 2264958 | 2022-03-01 | Emporia city | Virginia | 51595 | 1123 | 53 |
2260447 | 2260447 | 2022-02-28 | Furnas | Nebraska | 31065 | 1123 | 6 |
2261708 | 2261708 | 2022-02-28 | Emporia city | Virginia | 51595 | 1123 | 53 |
2246328 | 2246328 | 2022-02-24 | Lewis | Idaho | 16061 | 1123 | 26 |
2216467 | 2216467 | 2022-02-14 | Hot Springs | Wyoming | 56017 | 1123 | 14 |
2212930 | 2212930 | 2022-02-13 | Charles City | Virginia | 51036 | 1123 | 26 |
2209677 | 2209677 | 2022-02-12 | Charles City | Virginia | 51036 | 1123 | 26 |
2206424 | 2206424 | 2022-02-11 | Charles City | Virginia | 51036 | 1123 | 26 |
2200732 | 2200732 | 2022-02-10 | Schley | Georgia | 13249 | 1123 | 8 |
2133720 | 2133720 | 2022-01-20 | Guadalupe | New Mexico | 35019 | 1123 | 15 |
2126484 | 2126484 | 2022-01-18 | Owsley | Kentucky | 21189 | 1123 | 23 |
2124915 | 2124915 | 2022-01-17 | Lynn | Texas | 48305 | 1123 | 29 |
2120933 | 2120933 | 2022-01-16 | Sioux | North Dakota | 38085 | 1123 | 18 |
2114412 | 2114412 | 2022-01-14 | McHenry | North Dakota | 38049 | 1123 | 28 |
2082373 | 2082373 | 2022-01-04 | McCook | South Dakota | 46087 | 1123 | 30 |
2075997 | 2075997 | 2022-01-02 | Bailey | Texas | 48017 | 1123 | 30 |
2072746 | 2072746 | 2022-01-01 | Bailey | Texas | 48017 | 1123 | 30 |
2069495 | 2069495 | 2021-12-31 | Bailey | Texas | 48017 | 1123 | 30 |
2066244 | 2066244 | 2021-12-30 | Bailey | Texas | 48017 | 1123 | 30 |
2058795 | 2058795 | 2021-12-28 | Cedar | Nebraska | 31027 | 1123 | 11 |
2038209 | 2038209 | 2021-12-22 | Power | Idaho | 16077 | 1123 | 17 |
2030858 | 2030858 | 2021-12-19 | Lancaster | Virginia | 51103 | 1123 | 24 |
2027607 | 2027607 | 2021-12-18 | Lancaster | Virginia | 51103 | 1123 | 24 |
2024356 | 2024356 | 2021-12-17 | Lancaster | Virginia | 51103 | 1123 | 24 |
2012978 | 2012978 | 2021-12-14 | Mahnomen | Minnesota | 27087 | 1123 | 15 |
1987117 | 1987117 | 2021-12-06 | Carter | Missouri | 29035 | 1123 | 18 |
1974359 | 1974359 | 2021-12-02 | Thurston | Nebraska | 31173 | 1123 | 16 |
1968701 | 1968701 | 2021-11-30 | Pickett | Tennessee | 47137 | 1123 | 26 |
1955114 | 1955114 | 2021-11-26 | Dickey | North Dakota | 38021 | 1123 | 36 |
1951863 | 1951863 | 2021-11-25 | Dickey | North Dakota | 38021 | 1123 | 36 |
1946852 | 1946852 | 2021-11-24 | Conejos | Colorado | 8021 | 1123 | 42 |
1935604 | 1935604 | 2021-11-20 | Bottineau | North Dakota | 38009 | 1123 | 21 |
1915397 | 1915397 | 2021-11-14 | Montmorency | Michigan | 26119 | 1123 | 32 |
1915818 | 1915818 | 2021-11-14 | Knox | Nebraska | 31107 | 1123 | 13 |
1912147 | 1912147 | 2021-11-13 | Montmorency | Michigan | 26119 | 1123 | 32 |
1912568 | 1912568 | 2021-11-13 | Knox | Nebraska | 31107 | 1123 | 13 |
1908897 | 1908897 | 2021-11-12 | Montmorency | Michigan | 26119 | 1123 | 32 |
1909318 | 1909318 | 2021-11-12 | Knox | Nebraska | 31107 | 1123 | 13 |
1904531 | 1904531 | 2021-11-11 | Woodruff | Arkansas | 5147 | 1123 | 24 |
1865453 | 1865453 | 2021-10-30 | Greenlee | Arizona | 4011 | 1123 | 16 |
1830465 | 1830465 | 2021-10-19 | Lucas | Iowa | 19117 | 1123 | 24 |
1826790 | 1826790 | 2021-10-18 | Crawford | Georgia | 13079 | 1123 | 41 |
1827216 | 1827216 | 2021-10-18 | Lucas | Iowa | 19117 | 1123 | 24 |
1823271 | 1823271 | 2021-10-17 | Montgomery | Arkansas | 5097 | 1123 | 44 |
1823967 | 1823967 | 2021-10-17 | Lucas | Iowa | 19117 | 1123 | 24 |
1820718 | 1820718 | 2021-10-16 | Lucas | Iowa | 19117 | 1123 | 24 |
1821373 | 1821373 | 2021-10-16 | Caldwell | Missouri | 29025 | 1123 | 20 |
1817469 | 1817469 | 2021-10-15 | Lucas | Iowa | 19117 | 1123 | 24 |
1819009 | 1819009 | 2021-10-15 | San German | Puerto Rico | 72125 | 1123 | |
1814221 | 1814221 | 2021-10-14 | Lucas | Iowa | 19117 | 1123 | 24 |
1810972 | 1810972 | 2021-10-13 | Lucas | Iowa | 19117 | 1123 | 24 |
1807690 | 1807690 | 2021-10-12 | Davis | Iowa | 19051 | 1123 | 25 |
1804439 | 1804439 | 2021-10-11 | Davis | Iowa | 19051 | 1123 | 25 |
1805656 | 1805656 | 2021-10-11 | Pembina | North Dakota | 38067 | 1123 | 11 |
1806457 | 1806457 | 2021-10-11 | Stephens | Texas | 48429 | 1123 | 33 |
1806725 | 1806725 | 2021-10-11 | Clay | West Virginia | 54015 | 1123 | 17 |
1806854 | 1806854 | 2021-10-11 | Johnson | Wyoming | 56019 | 1123 | 15 |
1801190 | 1801190 | 2021-10-10 | Davis | Iowa | 19051 | 1123 | 25 |
1802407 | 1802407 | 2021-10-10 | Pembina | North Dakota | 38067 | 1123 | 11 |
1803207 | 1803207 | 2021-10-10 | Stephens | Texas | 48429 | 1123 | 33 |
1797941 | 1797941 | 2021-10-09 | Davis | Iowa | 19051 | 1123 | 25 |
1799958 | 1799958 | 2021-10-09 | Stephens | Texas | 48429 | 1123 | 33 |
1794692 | 1794692 | 2021-10-08 | Davis | Iowa | 19051 | 1123 | 25 |
1796709 | 1796709 | 2021-10-08 | Stephens | Texas | 48429 | 1123 | 33 |
1790752 | 1790752 | 2021-10-07 | Dallas | Arkansas | 5039 | 1123 | 19 |
1791444 | 1791444 | 2021-10-07 | Davis | Iowa | 19051 | 1123 | 25 |
1787455 | 1787455 | 2021-10-06 | Nome Census Area | Alaska | 2180 | 1123 | 0 |
1787503 | 1787503 | 2021-10-06 | Dallas | Arkansas | 5039 | 1123 | 18 |
1788195 | 1788195 | 2021-10-06 | Davis | Iowa | 19051 | 1123 | 25 |
1778537 | 1778537 | 2021-10-03 | Coffey | Kansas | 20031 | 1123 | 25 |
1775287 | 1775287 | 2021-10-02 | Coffey | Kansas | 20031 | 1123 | 25 |
1772037 | 1772037 | 2021-10-01 | Coffey | Kansas | 20031 | 1123 | 25 |
1768178 | 1768178 | 2021-09-30 | San Miguel | Colorado | 8113 | 1123 | 3 |
1741317 | 1741317 | 2021-09-21 | Dallam | Texas | 48111 | 1123 | 26 |
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);