ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
411 rows where cases = 968 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 39
- Georgia 25
- Mississippi 21
- Texas 21
- Minnesota 19
- Nebraska 18
- Iowa 17
- Kansas 17
- Missouri 15
- Puerto Rico 15
- Arkansas 13
- Kentucky 13
- Michigan 13
- North Carolina 13
- Alabama 12
- Indiana 12
- Virginia 12
- Wisconsin 11
- Illinois 10
- North Dakota 9
- Montana 8
- Tennessee 8
- South Dakota 7
- Idaho 6
- Pennsylvania 6
- Florida 5
- Louisiana 5
- Oregon 5
- Vermont 5
- West Virginia 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498071 | 2498071 | 2022-05-12 | Sheridan | Nebraska | 31161 | 968 | 23 |
2494813 | 2494813 | 2022-05-11 | Sheridan | Nebraska | 31161 | 968 | 23 |
2495220 | 2495220 | 2022-05-11 | Beaver | Oklahoma | 40007 | 968 | 11 |
2491962 | 2491962 | 2022-05-10 | Beaver | Oklahoma | 40007 | 968 | 11 |
2488704 | 2488704 | 2022-05-09 | Beaver | Oklahoma | 40007 | 968 | 11 |
2485447 | 2485447 | 2022-05-08 | Beaver | Oklahoma | 40007 | 968 | 11 |
2482189 | 2482189 | 2022-05-07 | Beaver | Oklahoma | 40007 | 968 | 11 |
2478931 | 2478931 | 2022-05-06 | Beaver | Oklahoma | 40007 | 968 | 11 |
2475673 | 2475673 | 2022-05-05 | Beaver | Oklahoma | 40007 | 968 | 11 |
2472416 | 2472416 | 2022-05-04 | Beaver | Oklahoma | 40007 | 968 | 11 |
2469160 | 2469160 | 2022-05-03 | Beaver | Oklahoma | 40007 | 968 | 11 |
2465904 | 2465904 | 2022-05-02 | Beaver | Oklahoma | 40007 | 968 | 11 |
2462649 | 2462649 | 2022-05-01 | Beaver | Oklahoma | 40007 | 968 | 11 |
2459393 | 2459393 | 2022-04-30 | Beaver | Oklahoma | 40007 | 968 | 11 |
2456137 | 2456137 | 2022-04-29 | Beaver | Oklahoma | 40007 | 968 | 11 |
2452881 | 2452881 | 2022-04-28 | Beaver | Oklahoma | 40007 | 968 | 11 |
2449625 | 2449625 | 2022-04-27 | Beaver | Oklahoma | 40007 | 968 | 11 |
2446368 | 2446368 | 2022-04-26 | Beaver | Oklahoma | 40007 | 968 | 11 |
2443113 | 2443113 | 2022-04-25 | Beaver | Oklahoma | 40007 | 968 | 11 |
2439857 | 2439857 | 2022-04-24 | Beaver | Oklahoma | 40007 | 968 | 11 |
2436601 | 2436601 | 2022-04-23 | Beaver | Oklahoma | 40007 | 968 | 11 |
2433345 | 2433345 | 2022-04-22 | Beaver | Oklahoma | 40007 | 968 | 11 |
2430089 | 2430089 | 2022-04-21 | Beaver | Oklahoma | 40007 | 968 | 11 |
2382130 | 2382130 | 2022-04-06 | Rappahannock | Virginia | 51157 | 968 | 9 |
2313701 | 2313701 | 2022-03-16 | Unknown | Vermont | 968 | 2 | |
2246918 | 2246918 | 2022-02-24 | Unknown | Louisiana | 968 | 0 | |
2240989 | 2240989 | 2022-02-22 | Sheridan | Nebraska | 31161 | 968 | 23 |
2237738 | 2237738 | 2022-02-21 | Sheridan | Nebraska | 31161 | 968 | 23 |
2212007 | 2212007 | 2022-02-13 | LaMoure | North Dakota | 38045 | 968 | 19 |
2208754 | 2208754 | 2022-02-12 | LaMoure | North Dakota | 38045 | 968 | 19 |
2181264 | 2181264 | 2022-02-04 | Boise | Idaho | 16015 | 968 | 13 |
2178013 | 2178013 | 2022-02-03 | Boise | Idaho | 16015 | 968 | 13 |
2174760 | 2174760 | 2022-02-02 | Boise | Idaho | 16015 | 968 | 13 |
2166915 | 2166915 | 2022-01-30 | Corson | South Dakota | 46031 | 968 | 15 |
2163660 | 2163660 | 2022-01-29 | Corson | South Dakota | 46031 | 968 | 15 |
2160405 | 2160405 | 2022-01-28 | Corson | South Dakota | 46031 | 968 | 15 |
2150839 | 2150839 | 2022-01-25 | Concho | Texas | 48095 | 968 | 10 |
2144338 | 2144338 | 2022-01-23 | Crockett | Texas | 48105 | 968 | 17 |
2132408 | 2132408 | 2022-01-20 | Schley | Georgia | 13249 | 968 | 8 |
2132435 | 2132435 | 2022-01-20 | Warren | Georgia | 13301 | 968 | 26 |
2121532 | 2121532 | 2022-01-16 | Brewster | Texas | 48043 | 968 | 24 |
2102204 | 2102204 | 2022-01-10 | San Augustine | Texas | 48405 | 968 | 38 |
2102446 | 2102446 | 2022-01-10 | Ferry | Washington | 53019 | 968 | 18 |
2092402 | 2092402 | 2022-01-07 | Martin | Texas | 48317 | 968 | 24 |
2062754 | 2062754 | 2021-12-29 | Sabana Grande | Puerto Rico | 72121 | 968 | |
2059499 | 2059499 | 2021-12-28 | Penuelas | Puerto Rico | 72111 | 968 | |
2040874 | 2040874 | 2021-12-23 | Choctaw | Alabama | 1023 | 968 | 30 |
2043868 | 2043868 | 2021-12-23 | Mathews | Virginia | 51115 | 968 | 24 |
2035889 | 2035889 | 2021-12-21 | Dade | Missouri | 29057 | 968 | 38 |
2028624 | 2028624 | 2021-12-19 | Ohio | Indiana | 18115 | 968 | 14 |
2028805 | 2028805 | 2021-12-19 | Kearny | Kansas | 20093 | 968 | 17 |
2025373 | 2025373 | 2021-12-18 | Ohio | Indiana | 18115 | 968 | 14 |
2025554 | 2025554 | 2021-12-18 | Kearny | Kansas | 20093 | 968 | 17 |
2022122 | 2022122 | 2021-12-17 | Ohio | Indiana | 18115 | 968 | 14 |
2022303 | 2022303 | 2021-12-17 | Kearny | Kansas | 20093 | 968 | 17 |
2019052 | 2019052 | 2021-12-16 | Kearny | Kansas | 20093 | 968 | 17 |
2015802 | 2015802 | 2021-12-15 | Kearny | Kansas | 20093 | 968 | 17 |
2014337 | 2014337 | 2021-12-14 | Hartley | Texas | 48205 | 968 | 2 |
1994152 | 1994152 | 2021-12-08 | Sioux | North Dakota | 38085 | 968 | 18 |
1994631 | 1994631 | 2021-12-08 | Walworth | South Dakota | 46129 | 968 | 19 |
1990185 | 1990185 | 2021-12-07 | Big Stone | Minnesota | 27011 | 968 | 6 |
1990901 | 1990901 | 2021-12-07 | Sioux | North Dakota | 38085 | 968 | 18 |
1991380 | 1991380 | 2021-12-07 | Walworth | South Dakota | 46129 | 968 | 19 |
1982939 | 1982939 | 2021-12-05 | Lemhi | Idaho | 16059 | 968 | 21 |
1979689 | 1979689 | 2021-12-04 | Lemhi | Idaho | 16059 | 968 | 21 |
1961047 | 1961047 | 2021-11-28 | Jefferson | Mississippi | 28063 | 968 | 34 |
1957796 | 1957796 | 2021-11-27 | Jefferson | Mississippi | 28063 | 968 | 34 |
1954545 | 1954545 | 2021-11-26 | Jefferson | Mississippi | 28063 | 968 | 34 |
1951294 | 1951294 | 2021-11-25 | Jefferson | Mississippi | 28063 | 968 | 34 |
1948043 | 1948043 | 2021-11-24 | Jefferson | Mississippi | 28063 | 968 | 34 |
1948638 | 1948638 | 2021-11-24 | Ransom | North Dakota | 38073 | 968 | 20 |
1944168 | 1944168 | 2021-11-23 | Decatur | Iowa | 19053 | 968 | 13 |
1944663 | 1944663 | 2021-11-23 | Schoolcraft | Michigan | 26153 | 968 | 6 |
1944792 | 1944792 | 2021-11-23 | Jefferson | Mississippi | 28063 | 968 | 34 |
1940918 | 1940918 | 2021-11-22 | Decatur | Iowa | 19053 | 968 | 13 |
1941412 | 1941412 | 2021-11-22 | Schoolcraft | Michigan | 26153 | 968 | 6 |
1941541 | 1941541 | 2021-11-22 | Jefferson | Mississippi | 28063 | 968 | 34 |
1937668 | 1937668 | 2021-11-21 | Decatur | Iowa | 19053 | 968 | 13 |
1934418 | 1934418 | 2021-11-20 | Decatur | Iowa | 19053 | 968 | 13 |
1931167 | 1931167 | 2021-11-19 | Decatur | Iowa | 19053 | 968 | 13 |
1927916 | 1927916 | 2021-11-18 | Decatur | Iowa | 19053 | 968 | 13 |
1924666 | 1924666 | 2021-11-17 | Decatur | Iowa | 19053 | 968 | 13 |
1927075 | 1927075 | 2021-11-17 | Crook | Wyoming | 56011 | 968 | 20 |
1915838 | 1915838 | 2021-11-14 | Richardson | Nebraska | 31147 | 968 | 24 |
1912588 | 1912588 | 2021-11-13 | Richardson | Nebraska | 31147 | 968 | 24 |
1909338 | 1909338 | 2021-11-12 | Richardson | Nebraska | 31147 | 968 | 24 |
1907539 | 1907539 | 2021-11-11 | Menominee | Wisconsin | 55078 | 968 | 11 |
1884702 | 1884702 | 2021-11-04 | Calhoun | West Virginia | 54013 | 968 | 5 |
1870848 | 1870848 | 2021-10-31 | Lake | Oregon | 41037 | 968 | 12 |
1867599 | 1867599 | 2021-10-30 | Lake | Oregon | 41037 | 968 | 12 |
1864350 | 1864350 | 2021-10-29 | Lake | Oregon | 41037 | 968 | 12 |
1841367 | 1841367 | 2021-10-22 | Bottineau | North Dakota | 38009 | 968 | 21 |
1836385 | 1836385 | 2021-10-21 | Kit Carson | Colorado | 8063 | 968 | 15 |
1768386 | 1768386 | 2021-09-30 | Randolph | Georgia | 13243 | 968 | 39 |
1770755 | 1770755 | 2021-09-30 | Beaver | Utah | 49001 | 968 | 11 |
1770951 | 1770951 | 2021-09-30 | Jefferson | Washington | 53031 | 968 | 13 |
1765137 | 1765137 | 2021-09-29 | Randolph | Georgia | 13243 | 968 | 39 |
1767506 | 1767506 | 2021-09-29 | Beaver | Utah | 49001 | 968 | 11 |
1763135 | 1763135 | 2021-09-28 | Thurston | Nebraska | 31173 | 968 | 11 |
1755507 | 1755507 | 2021-09-26 | Edwards | Illinois | 17047 | 968 | 16 |
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);