ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
341 rows where cases = 1598 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 33
- Missouri 23
- Georgia 21
- Texas 19
- Oklahoma 18
- South Carolina 17
- Kentucky 14
- Puerto Rico 14
- Montana 12
- Wyoming 11
- Mississippi 10
- North Carolina 10
- Wisconsin 10
- Minnesota 9
- Illinois 8
- Louisiana 8
- Colorado 7
- Kansas 7
- Michigan 6
- Nebraska 6
- Tennessee 6
- Utah 6
- Vermont 6
- Virginia 6
- West Virginia 6
- California 5
- Florida 5
- Indiana 5
- New York 5
- Ohio 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501590 | 2501590 | 2022-05-13 | Bottineau | North Dakota | 38009 | 1598 | 26 |
2497916 | 2497916 | 2022-05-12 | Shelby | Missouri | 29205 | 1598 | 15 |
2494658 | 2494658 | 2022-05-11 | Shelby | Missouri | 29205 | 1598 | 15 |
2491400 | 2491400 | 2022-05-10 | Shelby | Missouri | 29205 | 1598 | 15 |
2488142 | 2488142 | 2022-05-09 | Shelby | Missouri | 29205 | 1598 | 15 |
2488930 | 2488930 | 2022-05-09 | Maunabo | Puerto Rico | 72095 | 1598 | |
2484885 | 2484885 | 2022-05-08 | Shelby | Missouri | 29205 | 1598 | 15 |
2481627 | 2481627 | 2022-05-07 | Shelby | Missouri | 29205 | 1598 | 15 |
2478369 | 2478369 | 2022-05-06 | Shelby | Missouri | 29205 | 1598 | 15 |
2399499 | 2399499 | 2022-04-12 | Pocahontas | Iowa | 19151 | 1598 | 27 |
2396243 | 2396243 | 2022-04-11 | Pocahontas | Iowa | 19151 | 1598 | 27 |
2392988 | 2392988 | 2022-04-10 | Pocahontas | Iowa | 19151 | 1598 | 27 |
2389732 | 2389732 | 2022-04-09 | Pocahontas | Iowa | 19151 | 1598 | 27 |
2386476 | 2386476 | 2022-04-08 | Pocahontas | Iowa | 19151 | 1598 | 27 |
2383222 | 2383222 | 2022-04-07 | Pocahontas | Iowa | 19151 | 1598 | 27 |
2379967 | 2379967 | 2022-04-06 | Pocahontas | Iowa | 19151 | 1598 | 27 |
2369612 | 2369612 | 2022-04-03 | Kit Carson | Colorado | 8063 | 1598 | 31 |
2366359 | 2366359 | 2022-04-02 | Kit Carson | Colorado | 8063 | 1598 | 31 |
2363106 | 2363106 | 2022-04-01 | Kit Carson | Colorado | 8063 | 1598 | 31 |
2359852 | 2359852 | 2022-03-31 | Kit Carson | Colorado | 8063 | 1598 | 31 |
2356598 | 2356598 | 2022-03-30 | Kit Carson | Colorado | 8063 | 1598 | 31 |
2357883 | 2357883 | 2022-03-30 | Maries | Missouri | 29125 | 1598 | 37 |
2353345 | 2353345 | 2022-03-29 | Kit Carson | Colorado | 8063 | 1598 | 31 |
2354630 | 2354630 | 2022-03-29 | Maries | Missouri | 29125 | 1598 | 37 |
2351377 | 2351377 | 2022-03-28 | Maries | Missouri | 29125 | 1598 | 36 |
2338366 | 2338366 | 2022-03-24 | Maries | Missouri | 29125 | 1598 | 36 |
2335112 | 2335112 | 2022-03-23 | Maries | Missouri | 29125 | 1598 | 36 |
2330776 | 2330776 | 2022-03-22 | Lincoln | Georgia | 13181 | 1598 | 35 |
2331858 | 2331858 | 2022-03-22 | Maries | Missouri | 29125 | 1598 | 36 |
2327524 | 2327524 | 2022-03-21 | Lincoln | Georgia | 13181 | 1598 | 35 |
2324271 | 2324271 | 2022-03-20 | Lincoln | Georgia | 13181 | 1598 | 35 |
2321017 | 2321017 | 2022-03-19 | Lincoln | Georgia | 13181 | 1598 | 35 |
2317763 | 2317763 | 2022-03-18 | Lincoln | Georgia | 13181 | 1598 | 35 |
2314510 | 2314510 | 2022-03-17 | Lincoln | Georgia | 13181 | 1598 | 35 |
2240650 | 2240650 | 2022-02-22 | Wilkin | Minnesota | 27167 | 1598 | 22 |
2238868 | 2238868 | 2022-02-21 | Beaver | Utah | 49001 | 1598 | 15 |
2235617 | 2235617 | 2022-02-20 | Beaver | Utah | 49001 | 1598 | 15 |
2232366 | 2232366 | 2022-02-19 | Beaver | Utah | 49001 | 1598 | 15 |
2229115 | 2229115 | 2022-02-18 | Beaver | Utah | 49001 | 1598 | 15 |
2225864 | 2225864 | 2022-02-17 | Beaver | Utah | 49001 | 1598 | 15 |
2222613 | 2222613 | 2022-02-16 | Beaver | Utah | 49001 | 1598 | 15 |
2216011 | 2216011 | 2022-02-14 | Marion | Texas | 48315 | 1598 | 56 |
2189928 | 2189928 | 2022-02-06 | Hansford | Texas | 48195 | 1598 | 27 |
2186675 | 2186675 | 2022-02-05 | Hansford | Texas | 48195 | 1598 | 27 |
2183423 | 2183423 | 2022-02-04 | Hansford | Texas | 48195 | 1598 | 27 |
2178965 | 2178965 | 2022-02-03 | Chariton | Missouri | 29041 | 1598 | 33 |
2145946 | 2145946 | 2022-01-24 | Elliott | Kentucky | 21063 | 1598 | 14 |
2134603 | 2134603 | 2022-01-20 | Gaines | Texas | 48165 | 1598 | 73 |
2125382 | 2125382 | 2022-01-17 | Sublette | Wyoming | 56035 | 1598 | 24 |
2122130 | 2122130 | 2022-01-16 | Sublette | Wyoming | 56035 | 1598 | 24 |
2118878 | 2118878 | 2022-01-15 | Sublette | Wyoming | 56035 | 1598 | 24 |
2115626 | 2115626 | 2022-01-14 | Sublette | Wyoming | 56035 | 1598 | 24 |
2107835 | 2107835 | 2022-01-12 | Jones | North Carolina | 37103 | 1598 | 38 |
2108298 | 2108298 | 2022-01-12 | Allendale | South Carolina | 45005 | 1598 | 22 |
2105471 | 2105471 | 2022-01-11 | Swisher | Texas | 48437 | 1598 | 27 |
2097155 | 2097155 | 2022-01-09 | Cumberland | Kentucky | 21057 | 1598 | 23 |
2099367 | 2099367 | 2022-01-09 | Platte | Wyoming | 56031 | 1598 | 37 |
2093903 | 2093903 | 2022-01-08 | Cumberland | Kentucky | 21057 | 1598 | 23 |
2096116 | 2096116 | 2022-01-08 | Platte | Wyoming | 56031 | 1598 | 37 |
2090651 | 2090651 | 2022-01-07 | Cumberland | Kentucky | 21057 | 1598 | 23 |
2091981 | 2091981 | 2022-01-07 | Florida | Puerto Rico | 72054 | 1598 | |
2092864 | 2092864 | 2022-01-07 | Platte | Wyoming | 56031 | 1598 | 37 |
2058730 | 2058730 | 2021-12-28 | Carbon | Montana | 30009 | 1598 | 23 |
2055481 | 2055481 | 2021-12-27 | Carbon | Montana | 30009 | 1598 | 23 |
2052231 | 2052231 | 2021-12-26 | Carbon | Montana | 30009 | 1598 | 23 |
2048981 | 2048981 | 2021-12-25 | Carbon | Montana | 30009 | 1598 | 23 |
2045731 | 2045731 | 2021-12-24 | Carbon | Montana | 30009 | 1598 | 23 |
2042481 | 2042481 | 2021-12-23 | Carbon | Montana | 30009 | 1598 | 23 |
2034123 | 2034123 | 2021-12-20 | Nelson | Virginia | 51125 | 1598 | 22 |
2017402 | 2017402 | 2021-12-15 | Clay | Tennessee | 47027 | 1598 | 37 |
2012156 | 2012156 | 2021-12-14 | Wilkes | Georgia | 13317 | 1598 | 38 |
1995916 | 1995916 | 2021-12-09 | Benewah | Idaho | 16009 | 1598 | 29 |
1992703 | 1992703 | 2021-12-08 | Valley | Idaho | 16085 | 1598 | 13 |
1995246 | 1995246 | 2021-12-08 | Ritchie | West Virginia | 54085 | 1598 | 22 |
1986944 | 1986944 | 2021-12-06 | Clearwater | Minnesota | 27029 | 1598 | 21 |
1978516 | 1978516 | 2021-12-03 | Clay | Texas | 48077 | 1598 | 25 |
1973685 | 1973685 | 2021-12-02 | McLean | Kentucky | 21149 | 1598 | 40 |
1963059 | 1963059 | 2021-11-29 | Mariposa | California | 6043 | 1598 | 18 |
1963243 | 1963243 | 2021-11-29 | Atkinson | Georgia | 13003 | 1598 | 37 |
1965656 | 1965656 | 2021-11-29 | Ochiltree | Texas | 48357 | 1598 | 38 |
1960511 | 1960511 | 2021-11-28 | Cloud | Kansas | 20029 | 1598 | 30 |
1962517 | 1962517 | 2021-11-28 | Lamoille | Vermont | 50015 | 1598 | 9 |
1957260 | 1957260 | 2021-11-27 | Cloud | Kansas | 20029 | 1598 | 30 |
1959266 | 1959266 | 2021-11-27 | Lamoille | Vermont | 50015 | 1598 | 9 |
1954009 | 1954009 | 2021-11-26 | Cloud | Kansas | 20029 | 1598 | 30 |
1956015 | 1956015 | 2021-11-26 | Lamoille | Vermont | 50015 | 1598 | 9 |
1950758 | 1950758 | 2021-11-25 | Cloud | Kansas | 20029 | 1598 | 30 |
1952764 | 1952764 | 2021-11-25 | Lamoille | Vermont | 50015 | 1598 | 9 |
1947507 | 1947507 | 2021-11-24 | Cloud | Kansas | 20029 | 1598 | 30 |
1949513 | 1949513 | 2021-11-24 | Lamoille | Vermont | 50015 | 1598 | 9 |
1944210 | 1944210 | 2021-11-23 | Montgomery | Iowa | 19137 | 1598 | 45 |
1944338 | 1944338 | 2021-11-23 | Thomas | Kansas | 20193 | 1598 | 22 |
1940960 | 1940960 | 2021-11-22 | Montgomery | Iowa | 19137 | 1598 | 45 |
1941088 | 1941088 | 2021-11-22 | Thomas | Kansas | 20193 | 1598 | 22 |
1937710 | 1937710 | 2021-11-21 | Montgomery | Iowa | 19137 | 1598 | 45 |
1934460 | 1934460 | 2021-11-20 | Montgomery | Iowa | 19137 | 1598 | 45 |
1931209 | 1931209 | 2021-11-19 | Montgomery | Iowa | 19137 | 1598 | 45 |
1927958 | 1927958 | 2021-11-18 | Montgomery | Iowa | 19137 | 1598 | 45 |
1924708 | 1924708 | 2021-11-17 | Montgomery | Iowa | 19137 | 1598 | 45 |
1894894 | 1894894 | 2021-11-08 | Rio Grande | Colorado | 8105 | 1598 | 23 |
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);