ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
304 rows where cases = 1866 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 40
- Iowa 22
- Georgia 20
- Kentucky 18
- Virginia 15
- Alabama 13
- Michigan 13
- Arkansas 11
- Montana 10
- Missouri 9
- Oklahoma 9
- Colorado 8
- Illinois 7
- Massachusetts 7
- North Carolina 7
- Puerto Rico 7
- Idaho 6
- Indiana 6
- Kansas 6
- Nebraska 6
- Alaska 5
- Utah 5
- Mississippi 4
- New York 4
- Ohio 4
- Pennsylvania 4
- West Virginia 4
- Wisconsin 4
- Wyoming 4
- Minnesota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2403536 | 2403536 | 2022-04-13 | Powell | Montana | 30077 | 1866 | 28 |
2377085 | 2377085 | 2022-04-05 | Alger | Michigan | 26003 | 1866 | 13 |
2372896 | 2372896 | 2022-04-04 | Yuma | Colorado | 8125 | 1866 | 23 |
2373833 | 2373833 | 2022-04-04 | Alger | Michigan | 26003 | 1866 | 13 |
2370580 | 2370580 | 2022-04-03 | Alger | Michigan | 26003 | 1866 | 13 |
2367327 | 2367327 | 2022-04-02 | Alger | Michigan | 26003 | 1866 | 13 |
2364074 | 2364074 | 2022-04-01 | Alger | Michigan | 26003 | 1866 | 13 |
2360820 | 2360820 | 2022-03-31 | Alger | Michigan | 26003 | 1866 | 13 |
2357566 | 2357566 | 2022-03-30 | Alger | Michigan | 26003 | 1866 | 13 |
2349847 | 2349847 | 2022-03-28 | Greene | Alabama | 1063 | 1866 | 48 |
2346594 | 2346594 | 2022-03-27 | Greene | Alabama | 1063 | 1866 | 48 |
2343341 | 2343341 | 2022-03-26 | Greene | Alabama | 1063 | 1866 | 48 |
2340088 | 2340088 | 2022-03-25 | Greene | Alabama | 1063 | 1866 | 48 |
2319966 | 2319966 | 2022-03-18 | Crosby | Texas | 48107 | 1866 | 45 |
2246720 | 2246720 | 2022-02-24 | Russell | Kansas | 20167 | 1866 | 36 |
2243469 | 2243469 | 2022-02-23 | Russell | Kansas | 20167 | 1866 | 36 |
2233203 | 2233203 | 2022-02-20 | Irwin | Georgia | 13155 | 1866 | 42 |
2229952 | 2229952 | 2022-02-19 | Irwin | Georgia | 13155 | 1866 | 42 |
2226701 | 2226701 | 2022-02-18 | Irwin | Georgia | 13155 | 1866 | 42 |
2219676 | 2219676 | 2022-02-15 | Menominee | Wisconsin | 55078 | 1866 | 13 |
2215954 | 2215954 | 2022-02-14 | Hansford | Texas | 48195 | 1866 | 28 |
2212703 | 2212703 | 2022-02-13 | Hansford | Texas | 48195 | 1866 | 28 |
2209450 | 2209450 | 2022-02-12 | Hansford | Texas | 48195 | 1866 | 28 |
2193798 | 2193798 | 2022-02-08 | Southeast Fairbanks Census Area | Alaska | 2240 | 1866 | 16 |
2190545 | 2190545 | 2022-02-07 | Southeast Fairbanks Census Area | Alaska | 2240 | 1866 | 16 |
2193303 | 2193303 | 2022-02-07 | Swisher | Texas | 48437 | 1866 | 30 |
2188891 | 2188891 | 2022-02-06 | Cheyenne | Nebraska | 31033 | 1866 | 23 |
2185638 | 2185638 | 2022-02-05 | Cheyenne | Nebraska | 31033 | 1866 | 23 |
2182386 | 2182386 | 2022-02-04 | Cheyenne | Nebraska | 31033 | 1866 | 23 |
2174353 | 2174353 | 2022-02-02 | Monroe | Arkansas | 5095 | 1866 | 28 |
2169131 | 2169131 | 2022-01-31 | Humphreys | Mississippi | 28053 | 1866 | 40 |
2164716 | 2164716 | 2022-01-30 | Lincoln | Colorado | 8073 | 1866 | 9 |
2164996 | 2164996 | 2022-01-30 | Benewah | Idaho | 16009 | 1866 | 33 |
2167441 | 2167441 | 2022-01-30 | Madison | Virginia | 51113 | 1866 | 27 |
2161741 | 2161741 | 2022-01-29 | Benewah | Idaho | 16009 | 1866 | 33 |
2164186 | 2164186 | 2022-01-29 | Madison | Virginia | 51113 | 1866 | 27 |
2158205 | 2158205 | 2022-01-28 | Lincoln | Colorado | 8073 | 1866 | 9 |
2160931 | 2160931 | 2022-01-28 | Madison | Virginia | 51113 | 1866 | 27 |
2157781 | 2157781 | 2022-01-27 | Doddridge | West Virginia | 54017 | 1866 | 16 |
2153108 | 2153108 | 2022-01-26 | Custer | Nebraska | 31041 | 1866 | 26 |
2142050 | 2142050 | 2022-01-23 | Atkinson | Georgia | 13003 | 1866 | 39 |
2143316 | 2143316 | 2022-01-23 | Rosebud | Montana | 30087 | 1866 | 58 |
2138795 | 2138795 | 2022-01-22 | Atkinson | Georgia | 13003 | 1866 | 39 |
2140061 | 2140061 | 2022-01-22 | Rosebud | Montana | 30087 | 1866 | 58 |
2135539 | 2135539 | 2022-01-21 | Atkinson | Georgia | 13003 | 1866 | 39 |
2136805 | 2136805 | 2022-01-21 | Rosebud | Montana | 30087 | 1866 | 58 |
2132489 | 2132489 | 2022-01-20 | Owyhee | Idaho | 16073 | 1866 | 43 |
2124531 | 2124531 | 2022-01-17 | Sabana Grande | Puerto Rico | 72121 | 1866 | |
2121566 | 2121566 | 2022-01-16 | Dallam | Texas | 48111 | 1866 | 33 |
2106322 | 2106322 | 2022-01-12 | Evans | Georgia | 13109 | 1866 | 58 |
2095670 | 2095670 | 2022-01-08 | Morris | Texas | 48343 | 1866 | 58 |
2061946 | 2061946 | 2021-12-29 | Ralls | Missouri | 29173 | 1866 | 19 |
2055487 | 2055487 | 2021-12-27 | Dawson | Montana | 30021 | 1866 | 51 |
2053860 | 2053860 | 2021-12-26 | Washakie | Wyoming | 56043 | 1866 | 37 |
2050610 | 2050610 | 2021-12-25 | Washakie | Wyoming | 56043 | 1866 | 37 |
2047360 | 2047360 | 2021-12-24 | Washakie | Wyoming | 56043 | 1866 | 37 |
2044110 | 2044110 | 2021-12-23 | Washakie | Wyoming | 56043 | 1866 | 37 |
2036578 | 2036578 | 2021-12-21 | Pushmataha | Oklahoma | 40127 | 1866 | 40 |
2033328 | 2033328 | 2021-12-20 | Pushmataha | Oklahoma | 40127 | 1866 | 40 |
2030078 | 2030078 | 2021-12-19 | Pushmataha | Oklahoma | 40127 | 1866 | 40 |
2026827 | 2026827 | 2021-12-18 | Pushmataha | Oklahoma | 40127 | 1866 | 40 |
2023576 | 2023576 | 2021-12-17 | Pushmataha | Oklahoma | 40127 | 1866 | 40 |
2020325 | 2020325 | 2021-12-16 | Pushmataha | Oklahoma | 40127 | 1866 | 40 |
2017074 | 2017074 | 2021-12-15 | Pushmataha | Oklahoma | 40127 | 1866 | 40 |
1995247 | 1995247 | 2021-12-08 | Roane | West Virginia | 54087 | 1866 | 27 |
1989686 | 1989686 | 2021-12-07 | Grundy | Iowa | 19075 | 1866 | 37 |
1986436 | 1986436 | 2021-12-06 | Grundy | Iowa | 19075 | 1866 | 37 |
1983186 | 1983186 | 2021-12-05 | Grundy | Iowa | 19075 | 1866 | 37 |
1979936 | 1979936 | 2021-12-04 | Grundy | Iowa | 19075 | 1866 | 37 |
1976686 | 1976686 | 2021-12-03 | Grundy | Iowa | 19075 | 1866 | 37 |
1973437 | 1973437 | 2021-12-02 | Grundy | Iowa | 19075 | 1866 | 37 |
1970187 | 1970187 | 2021-12-01 | Grundy | Iowa | 19075 | 1866 | 37 |
1971172 | 1971172 | 2021-12-01 | Colfax | New Mexico | 35007 | 1866 | 52 |
1949938 | 1949938 | 2021-11-25 | Valdez-Cordova Census Area | Alaska | 2261 | 1866 | 9 |
1946687 | 1946687 | 2021-11-24 | Valdez-Cordova Census Area | Alaska | 2261 | 1866 | 9 |
1930522 | 1930522 | 2021-11-19 | Stone | Arkansas | 5137 | 1866 | 44 |
1925748 | 1925748 | 2021-11-17 | Yates | New York | 36123 | 1866 | 31 |
1921847 | 1921847 | 2021-11-16 | Benzie | Michigan | 26019 | 1866 | 41 |
1923678 | 1923678 | 2021-11-16 | Pacific | Washington | 53049 | 1866 | 34 |
1917422 | 1917422 | 2021-11-15 | Ketchikan Gateway Borough | Alaska | 2130 | 1866 | 11 |
1918597 | 1918597 | 2021-11-15 | Benzie | Michigan | 26019 | 1866 | 41 |
1909151 | 1909151 | 2021-11-12 | Linn | Missouri | 29115 | 1866 | 27 |
1905902 | 1905902 | 2021-11-11 | Linn | Missouri | 29115 | 1866 | 27 |
1902653 | 1902653 | 2021-11-10 | Linn | Missouri | 29115 | 1866 | 27 |
1892578 | 1892578 | 2021-11-07 | Dukes | Massachusetts | 25007 | 1866 | 0 |
1889328 | 1889328 | 2021-11-06 | Dukes | Massachusetts | 25007 | 1866 | 0 |
1886078 | 1886078 | 2021-11-05 | Dukes | Massachusetts | 25007 | 1866 | 0 |
1874743 | 1874743 | 2021-11-01 | Morgan | Utah | 49029 | 1866 | 12 |
1871494 | 1871494 | 2021-10-31 | Morgan | Utah | 49029 | 1866 | 12 |
1868245 | 1868245 | 2021-10-30 | Morgan | Utah | 49029 | 1866 | 12 |
1864996 | 1864996 | 2021-10-29 | Morgan | Utah | 49029 | 1866 | 12 |
1859455 | 1859455 | 2021-10-28 | Washington | Idaho | 16087 | 1866 | 46 |
1861908 | 1861908 | 2021-10-28 | Westmoreland | Virginia | 51193 | 1866 | 33 |
1857922 | 1857922 | 2021-10-27 | Potter | Pennsylvania | 42105 | 1866 | 45 |
1852373 | 1852373 | 2021-10-26 | Conecuh | Alabama | 1035 | 1866 | 54 |
1854609 | 1854609 | 2021-10-26 | Morrow | Oregon | 41049 | 1866 | 23 |
1837575 | 1837575 | 2021-10-21 | Noxubee | Mississippi | 28103 | 1866 | 40 |
1810826 | 1810826 | 2021-10-13 | Blackford | Indiana | 18009 | 1866 | 39 |
1808398 | 1808398 | 2021-10-12 | Dent | Missouri | 29065 | 1866 | 39 |
1808458 | 1808458 | 2021-10-12 | Ripley | Missouri | 29181 | 1866 | 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);