ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
322 rows where cases = 1796 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Mississippi 22
- Iowa 20
- Missouri 20
- Georgia 17
- Michigan 15
- Virginia 14
- Nebraska 13
- Puerto Rico 12
- Wisconsin 11
- Arkansas 10
- California 10
- Illinois 10
- North Carolina 10
- Louisiana 8
- South Dakota 8
- Oregon 7
- Rhode Island 7
- Idaho 6
- Kansas 6
- Minnesota 6
- West Virginia 6
- Indiana 5
- Montana 5
- North Dakota 5
- Pennsylvania 5
- Kentucky 4
- Ohio 4
- Tennessee 4
- Alabama 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2465503 | 2465503 | 2022-05-02 | Thurston | Nebraska | 31173 | 1796 | 23 |
2396867 | 2396867 | 2022-04-11 | Wilkinson | Mississippi | 28157 | 1796 | 46 |
2393612 | 2393612 | 2022-04-10 | Wilkinson | Mississippi | 28157 | 1796 | 46 |
2390356 | 2390356 | 2022-04-09 | Wilkinson | Mississippi | 28157 | 1796 | 46 |
2387100 | 2387100 | 2022-04-08 | Wilkinson | Mississippi | 28157 | 1796 | 46 |
2383845 | 2383845 | 2022-04-07 | Wilkinson | Mississippi | 28157 | 1796 | 46 |
2380590 | 2380590 | 2022-04-06 | Wilkinson | Mississippi | 28157 | 1796 | 46 |
2377335 | 2377335 | 2022-04-05 | Wilkinson | Mississippi | 28157 | 1796 | 46 |
2374082 | 2374082 | 2022-04-04 | Wilkinson | Mississippi | 28157 | 1796 | 46 |
2319654 | 2319654 | 2022-03-18 | Hormigueros | Puerto Rico | 72067 | 1796 | |
2308367 | 2308367 | 2022-03-15 | Ida | Iowa | 19093 | 1796 | 48 |
2305116 | 2305116 | 2022-03-14 | Ida | Iowa | 19093 | 1796 | 48 |
2301864 | 2301864 | 2022-03-13 | Ida | Iowa | 19093 | 1796 | 48 |
2304031 | 2304031 | 2022-03-13 | Middlesex | Virginia | 51119 | 1796 | 45 |
2298612 | 2298612 | 2022-03-12 | Ida | Iowa | 19093 | 1796 | 48 |
2300779 | 2300779 | 2022-03-12 | Middlesex | Virginia | 51119 | 1796 | 45 |
2295360 | 2295360 | 2022-03-11 | Ida | Iowa | 19093 | 1796 | 48 |
2297205 | 2297205 | 2022-03-11 | Delta | Texas | 48119 | 1796 | 25 |
2297527 | 2297527 | 2022-03-11 | Middlesex | Virginia | 51119 | 1796 | 45 |
2292108 | 2292108 | 2022-03-10 | Ida | Iowa | 19093 | 1796 | 48 |
2293953 | 2293953 | 2022-03-10 | Delta | Texas | 48119 | 1796 | 24 |
2294275 | 2294275 | 2022-03-10 | Middlesex | Virginia | 51119 | 1796 | 45 |
2288856 | 2288856 | 2022-03-09 | Ida | Iowa | 19093 | 1796 | 48 |
2290701 | 2290701 | 2022-03-09 | Delta | Texas | 48119 | 1796 | 24 |
2291023 | 2291023 | 2022-03-09 | Middlesex | Virginia | 51119 | 1796 | 45 |
2287449 | 2287449 | 2022-03-08 | Delta | Texas | 48119 | 1796 | 24 |
2284197 | 2284197 | 2022-03-07 | Delta | Texas | 48119 | 1796 | 24 |
2280018 | 2280018 | 2022-03-06 | Wayne | Nebraska | 31179 | 1796 | 11 |
2276765 | 2276765 | 2022-03-05 | Wayne | Nebraska | 31179 | 1796 | 11 |
2273512 | 2273512 | 2022-03-04 | Wayne | Nebraska | 31179 | 1796 | 11 |
2267734 | 2267734 | 2022-03-02 | Fall River | South Dakota | 46047 | 1796 | 39 |
2264481 | 2264481 | 2022-03-01 | Fall River | South Dakota | 46047 | 1796 | 39 |
2261231 | 2261231 | 2022-02-28 | Fall River | South Dakota | 46047 | 1796 | 39 |
2257980 | 2257980 | 2022-02-27 | Fall River | South Dakota | 46047 | 1796 | 39 |
2254729 | 2254729 | 2022-02-26 | Fall River | South Dakota | 46047 | 1796 | 39 |
2251478 | 2251478 | 2022-02-25 | Fall River | South Dakota | 46047 | 1796 | 39 |
2244431 | 2244431 | 2022-02-23 | Gates | North Carolina | 37073 | 1796 | 19 |
2235077 | 2235077 | 2022-02-20 | Arroyo | Puerto Rico | 72015 | 1796 | |
2218021 | 2218021 | 2022-02-15 | Hickory | Missouri | 29085 | 1796 | 50 |
2206182 | 2206182 | 2022-02-11 | Gaines | Texas | 48165 | 1796 | 78 |
2183846 | 2183846 | 2022-02-04 | Tucker | West Virginia | 54093 | 1796 | 33 |
2174081 | 2174081 | 2022-02-01 | Pocahontas | West Virginia | 54075 | 1796 | 25 |
2166215 | 2166215 | 2022-01-30 | White Pine | Nevada | 32033 | 1796 | 18 |
2162960 | 2162960 | 2022-01-29 | White Pine | Nevada | 32033 | 1796 | 18 |
2159705 | 2159705 | 2022-01-28 | White Pine | Nevada | 32033 | 1796 | 18 |
2156035 | 2156035 | 2022-01-27 | Lake | Minnesota | 27075 | 1796 | 26 |
2153456 | 2153456 | 2022-01-26 | Pembina | North Dakota | 38067 | 1796 | 16 |
2149536 | 2149536 | 2022-01-25 | Marshall | Minnesota | 27089 | 1796 | 23 |
2137871 | 2137871 | 2022-01-21 | Hamilton | Texas | 48193 | 1796 | 29 |
2132463 | 2132463 | 2022-01-20 | Boundary | Idaho | 16021 | 1796 | 53 |
2130333 | 2130333 | 2022-01-19 | Custer | Nebraska | 31041 | 1796 | 26 |
2126253 | 2126253 | 2022-01-18 | Montgomery | Iowa | 19137 | 1796 | 48 |
2123001 | 2123001 | 2022-01-17 | Montgomery | Iowa | 19137 | 1796 | 48 |
2119749 | 2119749 | 2022-01-16 | Montgomery | Iowa | 19137 | 1796 | 48 |
2116497 | 2116497 | 2022-01-15 | Montgomery | Iowa | 19137 | 1796 | 48 |
2113246 | 2113246 | 2022-01-14 | Montgomery | Iowa | 19137 | 1796 | 48 |
2109994 | 2109994 | 2022-01-13 | Montgomery | Iowa | 19137 | 1796 | 48 |
2106478 | 2106478 | 2022-01-12 | Valley | Idaho | 16085 | 1796 | 13 |
2106743 | 2106743 | 2022-01-12 | Montgomery | Iowa | 19137 | 1796 | 48 |
2101034 | 2101034 | 2022-01-10 | Rosebud | Montana | 30087 | 1796 | 58 |
2097417 | 2097417 | 2022-01-09 | Mackinac | Michigan | 26097 | 1796 | 23 |
2097439 | 2097439 | 2022-01-09 | Presque Isle | Michigan | 26141 | 1796 | 52 |
2094165 | 2094165 | 2022-01-08 | Mackinac | Michigan | 26097 | 1796 | 23 |
2094187 | 2094187 | 2022-01-08 | Presque Isle | Michigan | 26141 | 1796 | 52 |
2090913 | 2090913 | 2022-01-07 | Mackinac | Michigan | 26097 | 1796 | 23 |
2090935 | 2090935 | 2022-01-07 | Presque Isle | Michigan | 26141 | 1796 | 52 |
2088109 | 2088109 | 2022-01-06 | Phelps | Nebraska | 31137 | 1796 | 11 |
2082719 | 2082719 | 2022-01-04 | Trinity | Texas | 48455 | 1796 | 64 |
2055310 | 2055310 | 2021-12-27 | Jefferson Davis | Mississippi | 28065 | 1796 | 43 |
2034961 | 2034961 | 2021-12-21 | Teton | Idaho | 16081 | 1796 | 8 |
2031286 | 2031286 | 2021-12-20 | Scott | Arkansas | 5127 | 1796 | 32 |
2028035 | 2028035 | 2021-12-19 | Scott | Arkansas | 5127 | 1796 | 32 |
2026197 | 2026197 | 2021-12-18 | Ralls | Missouri | 29173 | 1796 | 19 |
2010729 | 2010729 | 2021-12-13 | Juana Diaz | Puerto Rico | 72075 | 1796 | |
2005587 | 2005587 | 2021-12-12 | Long | Georgia | 13183 | 1796 | 28 |
2007478 | 2007478 | 2021-12-12 | Juana Diaz | Puerto Rico | 72075 | 1796 | |
2002336 | 2002336 | 2021-12-11 | Long | Georgia | 13183 | 1796 | 28 |
2004227 | 2004227 | 2021-12-11 | Juana Diaz | Puerto Rico | 72075 | 1796 | |
1999086 | 1999086 | 2021-12-10 | Long | Georgia | 13183 | 1796 | 28 |
2000976 | 2000976 | 2021-12-10 | Juana Diaz | Puerto Rico | 72075 | 1796 | |
1961358 | 1961358 | 2021-11-28 | Unknown | Nebraska | 1796 | 238 | |
1958107 | 1958107 | 2021-11-27 | Unknown | Nebraska | 1796 | 224 | |
1954856 | 1954856 | 2021-11-26 | Unknown | Nebraska | 1796 | 224 | |
1951605 | 1951605 | 2021-11-25 | Unknown | Nebraska | 1796 | 230 | |
1948354 | 1948354 | 2021-11-24 | Unknown | Nebraska | 1796 | 230 | |
1942239 | 1942239 | 2021-11-22 | Vinton | Ohio | 39163 | 1796 | 34 |
1919378 | 1919378 | 2021-11-15 | Mercer | North Dakota | 38057 | 1796 | 17 |
1916128 | 1916128 | 2021-11-14 | Mercer | North Dakota | 38057 | 1796 | 17 |
1891564 | 1891564 | 2021-11-07 | Plumas | California | 6063 | 1796 | 7 |
1888314 | 1888314 | 2021-11-06 | Plumas | California | 6063 | 1796 | 7 |
1885064 | 1885064 | 2021-11-05 | Plumas | California | 6063 | 1796 | 7 |
1883942 | 1883942 | 2021-11-04 | Camuy | Puerto Rico | 72027 | 1796 | |
1880004 | 1880004 | 2021-11-03 | Richland | Montana | 30083 | 1796 | 21 |
1880693 | 1880693 | 2021-11-03 | Camuy | Puerto Rico | 72027 | 1796 | |
1857108 | 1857108 | 2021-10-27 | Barton | Missouri | 29011 | 1796 | 27 |
1853859 | 1853859 | 2021-10-26 | Barton | Missouri | 29011 | 1796 | 27 |
1849621 | 1849621 | 2021-10-25 | Screven | Georgia | 13251 | 1796 | 58 |
1850571 | 1850571 | 2021-10-25 | Montgomery | Mississippi | 28097 | 1796 | 57 |
1850610 | 1850610 | 2021-10-25 | Barton | Missouri | 29011 | 1796 | 27 |
1846371 | 1846371 | 2021-10-24 | Screven | Georgia | 13251 | 1796 | 57 |
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);