ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
406 rows where cases = 1290 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 43
- Kentucky 29
- Oklahoma 26
- Texas 24
- Virginia 22
- Michigan 20
- Mississippi 19
- Minnesota 17
- Wisconsin 16
- Illinois 14
- West Virginia 14
- Nebraska 13
- Kansas 12
- Tennessee 12
- Indiana 10
- Arkansas 9
- Puerto Rico 9
- Georgia 8
- Missouri 8
- Montana 8
- North Carolina 7
- North Dakota 6
- South Dakota 6
- Florida 4
- Maine 4
- Utah 4
- Vermont 4
- Alabama 3
- California 3
- Colorado 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501242 | 2501242 | 2022-05-13 | Teton | Montana | 30099 | 1290 | 24 |
2489464 | 2489464 | 2022-05-09 | Essex | Vermont | 50009 | 1290 | 3 |
2476475 | 2476475 | 2022-05-05 | Covington city | Virginia | 51580 | 1290 | 26 |
2466670 | 2466670 | 2022-05-02 | Unknown | Vermont | 1290 | 1 | |
2358504 | 2358504 | 2022-03-30 | Greer | Oklahoma | 40055 | 1290 | 34 |
2355250 | 2355250 | 2022-03-29 | Greer | Oklahoma | 40055 | 1290 | 34 |
2351997 | 2351997 | 2022-03-28 | Greer | Oklahoma | 40055 | 1290 | 34 |
2348745 | 2348745 | 2022-03-27 | Greer | Oklahoma | 40055 | 1290 | 34 |
2345492 | 2345492 | 2022-03-26 | Greer | Oklahoma | 40055 | 1290 | 34 |
2342239 | 2342239 | 2022-03-25 | Greer | Oklahoma | 40055 | 1290 | 34 |
2338986 | 2338986 | 2022-03-24 | Greer | Oklahoma | 40055 | 1290 | 34 |
2335738 | 2335738 | 2022-03-23 | Jefferson | Oklahoma | 40067 | 1290 | 26 |
2332484 | 2332484 | 2022-03-22 | Jefferson | Oklahoma | 40067 | 1290 | 26 |
2329231 | 2329231 | 2022-03-21 | Jefferson | Oklahoma | 40067 | 1290 | 26 |
2325979 | 2325979 | 2022-03-20 | Jefferson | Oklahoma | 40067 | 1290 | 26 |
2320684 | 2320684 | 2022-03-19 | Lafayette | Arkansas | 5073 | 1290 | 31 |
2322726 | 2322726 | 2022-03-19 | Jefferson | Oklahoma | 40067 | 1290 | 26 |
2319472 | 2319472 | 2022-03-18 | Jefferson | Oklahoma | 40067 | 1290 | 26 |
2316218 | 2316218 | 2022-03-17 | Jefferson | Oklahoma | 40067 | 1290 | 26 |
2281275 | 2281275 | 2022-03-06 | Norton city | Virginia | 51720 | 1290 | 22 |
2278022 | 2278022 | 2022-03-05 | Norton city | Virginia | 51720 | 1290 | 22 |
2274769 | 2274769 | 2022-03-04 | Norton city | Virginia | 51720 | 1290 | 22 |
2254272 | 2254272 | 2022-02-26 | McHenry | North Dakota | 38049 | 1290 | 30 |
2212481 | 2212481 | 2022-02-13 | Kingsbury | South Dakota | 46077 | 1290 | 20 |
2209228 | 2209228 | 2022-02-12 | Kingsbury | South Dakota | 46077 | 1290 | 20 |
2205975 | 2205975 | 2022-02-11 | Kingsbury | South Dakota | 46077 | 1290 | 20 |
2186753 | 2186753 | 2022-02-05 | Newton | Texas | 48351 | 1290 | 56 |
2168785 | 2168785 | 2022-01-31 | Owsley | Kentucky | 21189 | 1290 | 23 |
2166127 | 2166127 | 2022-01-30 | Dawes | Nebraska | 31045 | 1290 | 21 |
2162872 | 2162872 | 2022-01-29 | Dawes | Nebraska | 31045 | 1290 | 21 |
2159617 | 2159617 | 2022-01-28 | Dawes | Nebraska | 31045 | 1290 | 21 |
2143028 | 2143028 | 2022-01-23 | Mahnomen | Minnesota | 27087 | 1290 | 17 |
2139773 | 2139773 | 2022-01-22 | Mahnomen | Minnesota | 27087 | 1290 | 17 |
2136517 | 2136517 | 2022-01-21 | Mahnomen | Minnesota | 27087 | 1290 | 17 |
2132886 | 2132886 | 2022-01-20 | Stevens | Kansas | 20189 | 1290 | 17 |
2129331 | 2129331 | 2022-01-19 | Stark | Illinois | 17175 | 1290 | 30 |
2129633 | 2129633 | 2022-01-19 | Stevens | Kansas | 20189 | 1290 | 17 |
2120641 | 2120641 | 2022-01-16 | Thurston | Nebraska | 31173 | 1290 | 19 |
2117389 | 2117389 | 2022-01-15 | Thurston | Nebraska | 31173 | 1290 | 19 |
2114138 | 2114138 | 2022-01-14 | Thurston | Nebraska | 31173 | 1290 | 19 |
2111621 | 2111621 | 2022-01-13 | Hamlin | South Dakota | 46057 | 1290 | 40 |
2096255 | 2096255 | 2022-01-09 | Dallas | Arkansas | 5039 | 1290 | 21 |
2097058 | 2097058 | 2022-01-09 | Greenwood | Kansas | 20073 | 1290 | 18 |
2097120 | 2097120 | 2022-01-09 | Wabaunsee | Kansas | 20197 | 1290 | 19 |
2093003 | 2093003 | 2022-01-08 | Dallas | Arkansas | 5039 | 1290 | 21 |
2093806 | 2093806 | 2022-01-08 | Greenwood | Kansas | 20073 | 1290 | 18 |
2093868 | 2093868 | 2022-01-08 | Wabaunsee | Kansas | 20197 | 1290 | 19 |
2090554 | 2090554 | 2022-01-07 | Greenwood | Kansas | 20073 | 1290 | 18 |
2090616 | 2090616 | 2022-01-07 | Wabaunsee | Kansas | 20197 | 1290 | 19 |
2089092 | 2089092 | 2022-01-06 | Hansford | Texas | 48195 | 1290 | 27 |
2086114 | 2086114 | 2022-01-05 | Lancaster | Virginia | 51103 | 1290 | 24 |
2074775 | 2074775 | 2022-01-02 | Wilkin | Minnesota | 27167 | 1290 | 17 |
2075107 | 2075107 | 2022-01-02 | Richardson | Nebraska | 31147 | 1290 | 24 |
2071524 | 2071524 | 2022-01-01 | Wilkin | Minnesota | 27167 | 1290 | 17 |
2071856 | 2071856 | 2022-01-01 | Richardson | Nebraska | 31147 | 1290 | 24 |
2068273 | 2068273 | 2021-12-31 | Wilkin | Minnesota | 27167 | 1290 | 17 |
2068605 | 2068605 | 2021-12-31 | Richardson | Nebraska | 31147 | 1290 | 24 |
2065022 | 2065022 | 2021-12-30 | Wilkin | Minnesota | 27167 | 1290 | 17 |
2065354 | 2065354 | 2021-12-30 | Richardson | Nebraska | 31147 | 1290 | 24 |
2066610 | 2066610 | 2021-12-30 | Lunenburg | Virginia | 51111 | 1290 | 23 |
2060112 | 2060112 | 2021-12-28 | Madison | Virginia | 51113 | 1290 | 25 |
2037509 | 2037509 | 2021-12-21 | Tucker | West Virginia | 54093 | 1290 | 31 |
2030565 | 2030565 | 2021-12-19 | Floyd | Texas | 48153 | 1290 | 40 |
2021125 | 2021125 | 2021-12-16 | Northumberland | Virginia | 51133 | 1290 | 37 |
2007947 | 2007947 | 2021-12-12 | Stephens | Texas | 48429 | 1290 | 37 |
2004696 | 2004696 | 2021-12-11 | Stephens | Texas | 48429 | 1290 | 37 |
2001445 | 2001445 | 2021-12-10 | Stephens | Texas | 48429 | 1290 | 37 |
1996446 | 1996446 | 2021-12-09 | Nicholas | Kentucky | 21181 | 1290 | 26 |
1989685 | 1989685 | 2021-12-07 | Greene | Iowa | 19073 | 1290 | 18 |
1990155 | 1990155 | 2021-12-07 | Montmorency | Michigan | 26119 | 1290 | 37 |
1986435 | 1986435 | 2021-12-06 | Greene | Iowa | 19073 | 1290 | 18 |
1986905 | 1986905 | 2021-12-06 | Montmorency | Michigan | 26119 | 1290 | 37 |
1987207 | 1987207 | 2021-12-06 | Sullivan | Missouri | 29211 | 1290 | 17 |
1983185 | 1983185 | 2021-12-05 | Greene | Iowa | 19073 | 1290 | 18 |
1985355 | 1985355 | 2021-12-05 | Manassas Park city | Virginia | 51685 | 1290 | 14 |
1979935 | 1979935 | 2021-12-04 | Greene | Iowa | 19073 | 1290 | 18 |
1982105 | 1982105 | 2021-12-04 | Manassas Park city | Virginia | 51685 | 1290 | 14 |
1976021 | 1976021 | 2021-12-03 | Prairie | Arkansas | 5117 | 1290 | 29 |
1976685 | 1976685 | 2021-12-03 | Greene | Iowa | 19073 | 1290 | 18 |
1978855 | 1978855 | 2021-12-03 | Manassas Park city | Virginia | 51685 | 1290 | 14 |
1973436 | 1973436 | 2021-12-02 | Greene | Iowa | 19073 | 1290 | 18 |
1974284 | 1974284 | 2021-12-02 | Butler | Nebraska | 31023 | 1290 | 12 |
1970186 | 1970186 | 2021-12-01 | Greene | Iowa | 19073 | 1290 | 18 |
1960844 | 1960844 | 2021-11-28 | Alcona | Michigan | 26001 | 1290 | 49 |
1957593 | 1957593 | 2021-11-27 | Alcona | Michigan | 26001 | 1290 | 49 |
1954342 | 1954342 | 2021-11-26 | Alcona | Michigan | 26001 | 1290 | 49 |
1951091 | 1951091 | 2021-11-25 | Alcona | Michigan | 26001 | 1290 | 49 |
1947840 | 1947840 | 2021-11-24 | Alcona | Michigan | 26001 | 1290 | 49 |
1903969 | 1903969 | 2021-11-10 | Winkler | Texas | 48495 | 1290 | 29 |
1898876 | 1898876 | 2021-11-09 | Cumberland | Kentucky | 21057 | 1290 | 19 |
1900719 | 1900719 | 2021-11-09 | Winkler | Texas | 48495 | 1290 | 29 |
1837305 | 1837305 | 2021-10-21 | Piscataquis | Maine | 23021 | 1290 | 11 |
1834512 | 1834512 | 2021-10-20 | Powell | Montana | 30077 | 1290 | 14 |
1831762 | 1831762 | 2021-10-19 | Alfalfa | Oklahoma | 40003 | 1290 | 7 |
1827803 | 1827803 | 2021-10-18 | Humphreys | Mississippi | 28053 | 1290 | 38 |
1828513 | 1828513 | 2021-10-18 | Alfalfa | Oklahoma | 40003 | 1290 | 7 |
1824554 | 1824554 | 2021-10-17 | Humphreys | Mississippi | 28053 | 1290 | 38 |
1824771 | 1824771 | 2021-10-17 | Sanders | Montana | 30089 | 1290 | 18 |
1825264 | 1825264 | 2021-10-17 | Alfalfa | Oklahoma | 40003 | 1290 | 7 |
1821305 | 1821305 | 2021-10-16 | Humphreys | Mississippi | 28053 | 1290 | 38 |
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);