ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
314 rows where cases = 1799 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 26
- Mississippi 21
- Missouri 19
- Iowa 18
- North Carolina 17
- Georgia 15
- Virginia 15
- Kentucky 14
- South Dakota 14
- Louisiana 12
- Florida 11
- Illinois 11
- Indiana 11
- Michigan 11
- Minnesota 9
- Tennessee 9
- Kansas 7
- Alabama 6
- Ohio 6
- Wisconsin 6
- California 5
- Colorado 5
- Puerto Rico 5
- Arkansas 4
- Idaho 4
- Montana 4
- Utah 4
- Maryland 3
- Rhode Island 3
- West Virginia 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494431 | 2494431 | 2022-05-11 | Mahnomen | Minnesota | 27087 | 1799 | 17 |
2491173 | 2491173 | 2022-05-10 | Mahnomen | Minnesota | 27087 | 1799 | 17 |
2484783 | 2484783 | 2022-05-08 | Wilkinson | Mississippi | 28157 | 1799 | 46 |
2481525 | 2481525 | 2022-05-07 | Wilkinson | Mississippi | 28157 | 1799 | 46 |
2478267 | 2478267 | 2022-05-06 | Wilkinson | Mississippi | 28157 | 1799 | 46 |
2475009 | 2475009 | 2022-05-05 | Wilkinson | Mississippi | 28157 | 1799 | 46 |
2471752 | 2471752 | 2022-05-04 | Wilkinson | Mississippi | 28157 | 1799 | 46 |
2468496 | 2468496 | 2022-05-03 | Wilkinson | Mississippi | 28157 | 1799 | 46 |
2465240 | 2465240 | 2022-05-02 | Wilkinson | Mississippi | 28157 | 1799 | 46 |
2421695 | 2421695 | 2022-04-19 | Lake | Colorado | 8065 | 1799 | 2 |
2401626 | 2401626 | 2022-04-12 | Lancaster | Virginia | 51103 | 1799 | 31 |
2398371 | 2398371 | 2022-04-11 | Lancaster | Virginia | 51103 | 1799 | 31 |
2395116 | 2395116 | 2022-04-10 | Lancaster | Virginia | 51103 | 1799 | 31 |
2391860 | 2391860 | 2022-04-09 | Lancaster | Virginia | 51103 | 1799 | 31 |
2388604 | 2388604 | 2022-04-08 | Lancaster | Virginia | 51103 | 1799 | 31 |
2385349 | 2385349 | 2022-04-07 | Lancaster | Virginia | 51103 | 1799 | 31 |
2382094 | 2382094 | 2022-04-06 | Lancaster | Virginia | 51103 | 1799 | 31 |
2378839 | 2378839 | 2022-04-05 | Lancaster | Virginia | 51103 | 1799 | 31 |
2375585 | 2375585 | 2022-04-04 | Lancaster | Virginia | 51103 | 1799 | 31 |
2353911 | 2353911 | 2022-03-29 | Ida | Iowa | 19093 | 1799 | 48 |
2350659 | 2350659 | 2022-03-28 | Ida | Iowa | 19093 | 1799 | 48 |
2347406 | 2347406 | 2022-03-27 | Ida | Iowa | 19093 | 1799 | 48 |
2344153 | 2344153 | 2022-03-26 | Ida | Iowa | 19093 | 1799 | 48 |
2340900 | 2340900 | 2022-03-25 | Ida | Iowa | 19093 | 1799 | 48 |
2337647 | 2337647 | 2022-03-24 | Ida | Iowa | 19093 | 1799 | 48 |
2334393 | 2334393 | 2022-03-23 | Ida | Iowa | 19093 | 1799 | 48 |
2313466 | 2313466 | 2022-03-16 | Delta | Texas | 48119 | 1799 | 25 |
2310013 | 2310013 | 2022-03-15 | Fall River | South Dakota | 46047 | 1799 | 39 |
2310213 | 2310213 | 2022-03-15 | Delta | Texas | 48119 | 1799 | 25 |
2306760 | 2306760 | 2022-03-14 | Fall River | South Dakota | 46047 | 1799 | 39 |
2303509 | 2303509 | 2022-03-13 | Fall River | South Dakota | 46047 | 1799 | 39 |
2300257 | 2300257 | 2022-03-12 | Fall River | South Dakota | 46047 | 1799 | 39 |
2297005 | 2297005 | 2022-03-11 | Fall River | South Dakota | 46047 | 1799 | 39 |
2293753 | 2293753 | 2022-03-10 | Fall River | South Dakota | 46047 | 1799 | 39 |
2290501 | 2290501 | 2022-03-09 | Fall River | South Dakota | 46047 | 1799 | 39 |
2283997 | 2283997 | 2022-03-07 | Fall River | South Dakota | 46047 | 1799 | 39 |
2280745 | 2280745 | 2022-03-06 | Fall River | South Dakota | 46047 | 1799 | 39 |
2277492 | 2277492 | 2022-03-05 | Fall River | South Dakota | 46047 | 1799 | 39 |
2274239 | 2274239 | 2022-03-04 | Fall River | South Dakota | 46047 | 1799 | 39 |
2270037 | 2270037 | 2022-03-03 | Harrison | Missouri | 29081 | 1799 | 30 |
2268354 | 2268354 | 2022-03-02 | Calhoun | West Virginia | 54013 | 1799 | 13 |
2244830 | 2244830 | 2022-02-23 | Arroyo | Puerto Rico | 72015 | 1799 | |
2241579 | 2241579 | 2022-02-22 | Arroyo | Puerto Rico | 72015 | 1799 | |
2212688 | 2212688 | 2022-02-13 | Gaines | Texas | 48165 | 1799 | 78 |
2209435 | 2209435 | 2022-02-12 | Gaines | Texas | 48165 | 1799 | 78 |
2164981 | 2164981 | 2022-01-30 | Wilcox | Georgia | 13315 | 1799 | 61 |
2165414 | 2165414 | 2022-01-30 | Russell | Kansas | 20167 | 1799 | 35 |
2161726 | 2161726 | 2022-01-29 | Wilcox | Georgia | 13315 | 1799 | 61 |
2162159 | 2162159 | 2022-01-29 | Russell | Kansas | 20167 | 1799 | 35 |
2158470 | 2158470 | 2022-01-28 | Wilcox | Georgia | 13315 | 1799 | 61 |
2158904 | 2158904 | 2022-01-28 | Russell | Kansas | 20167 | 1799 | 35 |
2155013 | 2155013 | 2022-01-27 | Glades | Florida | 12043 | 1799 | 34 |
2151760 | 2151760 | 2022-01-26 | Glades | Florida | 12043 | 1799 | 34 |
2148508 | 2148508 | 2022-01-25 | Glades | Florida | 12043 | 1799 | 34 |
2145256 | 2145256 | 2022-01-24 | Glades | Florida | 12043 | 1799 | 34 |
2142001 | 2142001 | 2022-01-23 | Glades | Florida | 12043 | 1799 | 34 |
2143277 | 2143277 | 2022-01-23 | Carbon | Montana | 30009 | 1799 | 27 |
2144139 | 2144139 | 2022-01-23 | Custer | South Dakota | 46033 | 1799 | 21 |
2138746 | 2138746 | 2022-01-22 | Glades | Florida | 12043 | 1799 | 34 |
2140022 | 2140022 | 2022-01-22 | Carbon | Montana | 30009 | 1799 | 27 |
2140884 | 2140884 | 2022-01-22 | Custer | South Dakota | 46033 | 1799 | 21 |
2135490 | 2135490 | 2022-01-21 | Glades | Florida | 12043 | 1799 | 34 |
2136766 | 2136766 | 2022-01-21 | Carbon | Montana | 30009 | 1799 | 27 |
2137628 | 2137628 | 2022-01-21 | Custer | South Dakota | 46033 | 1799 | 21 |
2133273 | 2133273 | 2022-01-20 | Murray | Minnesota | 27101 | 1799 | 15 |
2134739 | 2134739 | 2022-01-20 | Swisher | Texas | 48437 | 1799 | 28 |
2127047 | 2127047 | 2022-01-18 | Sanders | Montana | 30089 | 1799 | 40 |
2122698 | 2122698 | 2022-01-17 | Benewah | Idaho | 16009 | 1799 | 31 |
2119446 | 2119446 | 2022-01-16 | Benewah | Idaho | 16009 | 1799 | 31 |
2116194 | 2116194 | 2022-01-15 | Benewah | Idaho | 16009 | 1799 | 31 |
2112943 | 2112943 | 2022-01-14 | Benewah | Idaho | 16009 | 1799 | 31 |
2103986 | 2103986 | 2022-01-11 | Jackson | Minnesota | 27063 | 1799 | 16 |
2089514 | 2089514 | 2022-01-06 | Summers | West Virginia | 54089 | 1799 | 39 |
2078541 | 2078541 | 2022-01-03 | Clay | North Carolina | 37043 | 1799 | 38 |
2062337 | 2062337 | 2021-12-29 | Perquimans | North Carolina | 37143 | 1799 | 16 |
2034428 | 2034428 | 2021-12-21 | Wilcox | Alabama | 1131 | 1799 | 38 |
2032699 | 2032699 | 2021-12-20 | Ralls | Missouri | 29173 | 1799 | 19 |
2019720 | 2019720 | 2021-12-16 | Wayne | Missouri | 29223 | 1799 | 37 |
2014272 | 2014272 | 2021-12-14 | Childress | Texas | 48075 | 1799 | 22 |
1983615 | 1983615 | 2021-12-05 | Crawford | Michigan | 26039 | 1799 | 19 |
1980365 | 1980365 | 2021-12-04 | Crawford | Michigan | 26039 | 1799 | 19 |
1977115 | 1977115 | 2021-12-03 | Crawford | Michigan | 26039 | 1799 | 19 |
1972496 | 1972496 | 2021-12-01 | Roane | West Virginia | 54087 | 1799 | 25 |
1966863 | 1966863 | 2021-11-30 | Newton | Indiana | 18111 | 1799 | 54 |
1963917 | 1963917 | 2021-11-29 | Lee | Kentucky | 21129 | 1799 | 37 |
1964760 | 1964760 | 2021-11-29 | Alleghany | North Carolina | 37005 | 1799 | 6 |
1931861 | 1931861 | 2021-11-19 | Cedar | Missouri | 29039 | 1799 | 42 |
1915600 | 1915600 | 2021-11-14 | Bollinger | Missouri | 29017 | 1799 | 21 |
1869884 | 1869884 | 2021-10-31 | Kalkaska | Michigan | 26079 | 1799 | 38 |
1866635 | 1866635 | 2021-10-30 | Kalkaska | Michigan | 26079 | 1799 | 38 |
1863386 | 1863386 | 2021-10-29 | Kalkaska | Michigan | 26079 | 1799 | 38 |
1854389 | 1854389 | 2021-10-26 | McLean | North Dakota | 38055 | 1799 | 39 |
1855297 | 1855297 | 2021-10-26 | Brunswick | Virginia | 51025 | 1799 | 32 |
1848750 | 1848750 | 2021-10-24 | Morgan | Utah | 49029 | 1799 | 11 |
1845500 | 1845500 | 2021-10-23 | Morgan | Utah | 49029 | 1799 | 11 |
1842250 | 1842250 | 2021-10-22 | Morgan | Utah | 49029 | 1799 | 11 |
1813637 | 1813637 | 2021-10-14 | Gunnison | Colorado | 8051 | 1799 | 10 |
1810887 | 1810887 | 2021-10-13 | Pulaski | Indiana | 18131 | 1799 | 53 |
1801707 | 1801707 | 2021-10-10 | Chippewa | Minnesota | 27023 | 1799 | 39 |
1798458 | 1798458 | 2021-10-09 | Chippewa | Minnesota | 27023 | 1799 | 39 |
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);