ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
264 rows where cases = 1901 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 25
- Kentucky 20
- Texas 17
- Arkansas 14
- Virginia 14
- Wisconsin 14
- Nebraska 11
- North Carolina 11
- Louisiana 9
- Michigan 9
- Missouri 9
- Illinois 7
- Indiana 7
- Iowa 7
- Ohio 7
- Wyoming 7
- Mississippi 6
- Oregon 6
- Puerto Rico 6
- South Carolina 6
- Tennessee 6
- West Virginia 6
- South Dakota 5
- Alabama 4
- New York 4
- Florida 3
- Idaho 3
- New Hampshire 3
- Colorado 2
- Kansas 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444152 | 2444152 | 2022-04-25 | Menominee | Wisconsin | 55078 | 1901 | 14 |
2440896 | 2440896 | 2022-04-24 | Menominee | Wisconsin | 55078 | 1901 | 14 |
2437640 | 2437640 | 2022-04-23 | Menominee | Wisconsin | 55078 | 1901 | 14 |
2434384 | 2434384 | 2022-04-22 | Menominee | Wisconsin | 55078 | 1901 | 14 |
2421883 | 2421883 | 2022-04-19 | Irwin | Georgia | 13155 | 1901 | 49 |
2418627 | 2418627 | 2022-04-18 | Irwin | Georgia | 13155 | 1901 | 49 |
2415371 | 2415371 | 2022-04-17 | Irwin | Georgia | 13155 | 1901 | 49 |
2412115 | 2412115 | 2022-04-16 | Irwin | Georgia | 13155 | 1901 | 49 |
2408859 | 2408859 | 2022-04-15 | Irwin | Georgia | 13155 | 1901 | 49 |
2405603 | 2405603 | 2022-04-14 | Irwin | Georgia | 13155 | 1901 | 49 |
2408336 | 2408336 | 2022-04-14 | Menominee | Wisconsin | 55078 | 1901 | 14 |
2402348 | 2402348 | 2022-04-13 | Irwin | Georgia | 13155 | 1901 | 49 |
2405080 | 2405080 | 2022-04-13 | Menominee | Wisconsin | 55078 | 1901 | 14 |
2399093 | 2399093 | 2022-04-12 | Irwin | Georgia | 13155 | 1901 | 49 |
2401825 | 2401825 | 2022-04-12 | Menominee | Wisconsin | 55078 | 1901 | 14 |
2395838 | 2395838 | 2022-04-11 | Irwin | Georgia | 13155 | 1901 | 49 |
2398570 | 2398570 | 2022-04-11 | Menominee | Wisconsin | 55078 | 1901 | 14 |
2382293 | 2382293 | 2022-04-06 | Menominee | Wisconsin | 55078 | 1901 | 14 |
2353060 | 2353060 | 2022-03-28 | Platte | Wyoming | 56031 | 1901 | 39 |
2349808 | 2349808 | 2022-03-27 | Platte | Wyoming | 56031 | 1901 | 39 |
2346555 | 2346555 | 2022-03-26 | Platte | Wyoming | 56031 | 1901 | 39 |
2343302 | 2343302 | 2022-03-25 | Platte | Wyoming | 56031 | 1901 | 39 |
2340049 | 2340049 | 2022-03-24 | Platte | Wyoming | 56031 | 1901 | 39 |
2336796 | 2336796 | 2022-03-23 | Platte | Wyoming | 56031 | 1901 | 39 |
2333542 | 2333542 | 2022-03-22 | Platte | Wyoming | 56031 | 1901 | 39 |
2274455 | 2274455 | 2022-03-04 | Floyd | Texas | 48153 | 1901 | 47 |
2274476 | 2274476 | 2022-03-04 | Hansford | Texas | 48195 | 1901 | 29 |
2235883 | 2235883 | 2022-02-20 | Tucker | West Virginia | 54093 | 1901 | 33 |
2232632 | 2232632 | 2022-02-19 | Tucker | West Virginia | 54093 | 1901 | 33 |
2229381 | 2229381 | 2022-02-18 | Tucker | West Virginia | 54093 | 1901 | 33 |
2223141 | 2223141 | 2022-02-17 | Monroe | Arkansas | 5095 | 1901 | 30 |
2208734 | 2208734 | 2022-02-12 | Benson | North Dakota | 38005 | 1901 | 22 |
2203167 | 2203167 | 2022-02-10 | Buena Vista city | Virginia | 51530 | 1901 | 38 |
2174718 | 2174718 | 2022-02-02 | Taylor | Georgia | 13269 | 1901 | 48 |
2171510 | 2171510 | 2022-02-01 | Boundary | Idaho | 16021 | 1901 | 54 |
2174054 | 2174054 | 2022-02-01 | Gilmer | West Virginia | 54021 | 1901 | 17 |
2166962 | 2166962 | 2022-01-30 | Turner | South Dakota | 46125 | 1901 | 62 |
2163707 | 2163707 | 2022-01-29 | Turner | South Dakota | 46125 | 1901 | 62 |
2160452 | 2160452 | 2022-01-28 | Turner | South Dakota | 46125 | 1901 | 62 |
2130177 | 2130177 | 2022-01-19 | Gentry | Missouri | 29075 | 1901 | 28 |
2128153 | 2128153 | 2022-01-18 | La Salle | Texas | 48283 | 1901 | 41 |
2125088 | 2125088 | 2022-01-17 | Charlotte | Virginia | 51037 | 1901 | 32 |
2108767 | 2108767 | 2022-01-12 | Grand | Utah | 49019 | 1901 | 6 |
2102631 | 2102631 | 2022-01-11 | Bullock | Alabama | 1011 | 1901 | 46 |
2101894 | 2101894 | 2022-01-10 | Roberts | South Dakota | 46109 | 1901 | 45 |
2102351 | 2102351 | 2022-01-10 | Galax city | Virginia | 51640 | 1901 | 69 |
2098503 | 2098503 | 2022-01-09 | Luquillo | Puerto Rico | 72089 | 1901 | |
2056803 | 2056803 | 2021-12-27 | Brunswick | Virginia | 51025 | 1901 | 35 |
2044130 | 2044130 | 2021-12-24 | Coosa | Alabama | 1037 | 1901 | 48 |
2031824 | 2031824 | 2021-12-20 | Brown | Indiana | 18013 | 1901 | 51 |
2013427 | 2013427 | 2021-12-14 | Colfax | New Mexico | 35007 | 1901 | 53 |
2006864 | 2006864 | 2021-12-12 | Unknown | Nebraska | 1901 | 276 | |
2003613 | 2003613 | 2021-12-11 | Unknown | Nebraska | 1901 | 276 | |
2000363 | 2000363 | 2021-12-10 | Unknown | Nebraska | 1901 | 273 | |
1980619 | 1980619 | 2021-12-04 | Cedar | Missouri | 29039 | 1901 | 42 |
1973042 | 1973042 | 2021-12-02 | Early | Georgia | 13099 | 1901 | 58 |
1969792 | 1969792 | 2021-12-01 | Early | Georgia | 13099 | 1901 | 58 |
1966542 | 1966542 | 2021-11-30 | Early | Georgia | 13099 | 1901 | 57 |
1961837 | 1961837 | 2021-11-28 | Curry | Oregon | 41015 | 1901 | 36 |
1958586 | 1958586 | 2021-11-27 | Curry | Oregon | 41015 | 1901 | 36 |
1955335 | 1955335 | 2021-11-26 | Curry | Oregon | 41015 | 1901 | 36 |
1952084 | 1952084 | 2021-11-25 | Curry | Oregon | 41015 | 1901 | 36 |
1948833 | 1948833 | 2021-11-24 | Curry | Oregon | 41015 | 1901 | 36 |
1945034 | 1945034 | 2021-11-23 | Colfax | Nebraska | 31037 | 1901 | 22 |
1941417 | 1941417 | 2021-11-22 | Unknown | Michigan | 1901 | 18 | |
1928599 | 1928599 | 2021-11-18 | Bollinger | Missouri | 29017 | 1901 | 27 |
1896629 | 1896629 | 2021-11-08 | McLean | North Dakota | 38055 | 1901 | 40 |
1884752 | 1884752 | 2021-11-04 | Ashland | Wisconsin | 55003 | 1901 | 17 |
1875538 | 1875538 | 2021-11-02 | Early | Georgia | 13099 | 1901 | 57 |
1877440 | 1877440 | 2021-11-02 | Barranquitas | Puerto Rico | 72019 | 1901 | |
1874191 | 1874191 | 2021-11-01 | Barranquitas | Puerto Rico | 72019 | 1901 | |
1869623 | 1869623 | 2021-10-31 | Carroll | Kentucky | 21041 | 1901 | 27 |
1866374 | 1866374 | 2021-10-30 | Carroll | Kentucky | 21041 | 1901 | 27 |
1863125 | 1863125 | 2021-10-29 | Carroll | Kentucky | 21041 | 1901 | 27 |
1864965 | 1864965 | 2021-10-29 | Ward | Texas | 48475 | 1901 | 30 |
1861716 | 1861716 | 2021-10-28 | Ward | Texas | 48475 | 1901 | 30 |
1858467 | 1858467 | 2021-10-27 | Ward | Texas | 48475 | 1901 | 30 |
1846476 | 1846476 | 2021-10-24 | Cumberland | Illinois | 17035 | 1901 | 38 |
1843226 | 1843226 | 2021-10-23 | Cumberland | Illinois | 17035 | 1901 | 38 |
1839976 | 1839976 | 2021-10-22 | Cumberland | Illinois | 17035 | 1901 | 38 |
1828603 | 1828603 | 2021-10-18 | Hood River | Oregon | 41027 | 1901 | 37 |
1821982 | 1821982 | 2021-10-16 | Morgan | Ohio | 39115 | 1901 | 32 |
1803697 | 1803697 | 2021-10-11 | Kusilvak Census Area | Alaska | 2158 | 1901 | 6 |
1793598 | 1793598 | 2021-10-07 | Goochland | Virginia | 51075 | 1901 | 28 |
1785314 | 1785314 | 2021-10-05 | Franklin | Maine | 23007 | 1901 | 18 |
1776724 | 1776724 | 2021-10-02 | Catano | Puerto Rico | 72033 | 1901 | |
1770978 | 1770978 | 2021-09-30 | Braxton | West Virginia | 54007 | 1901 | 12 |
1739312 | 1739312 | 2021-09-21 | Piatt | Illinois | 17147 | 1901 | 20 |
1741209 | 1741209 | 2021-09-21 | Jackson | Tennessee | 47087 | 1901 | 37 |
1737960 | 1737960 | 2021-09-20 | Jackson | Tennessee | 47087 | 1901 | 37 |
1732719 | 1732719 | 2021-09-19 | Gooding | Idaho | 16047 | 1901 | 28 |
1694226 | 1694226 | 2021-09-07 | Lewis | Kentucky | 21135 | 1901 | 48 |
1695137 | 1695137 | 2021-09-07 | Polk | North Carolina | 37149 | 1901 | 36 |
1674333 | 1674333 | 2021-09-01 | Moultrie | Illinois | 17139 | 1901 | 37 |
1671721 | 1671721 | 2021-08-31 | Ogemaw | Michigan | 26129 | 1901 | 44 |
1668474 | 1668474 | 2021-08-30 | Ogemaw | Michigan | 26129 | 1901 | 44 |
1665851 | 1665851 | 2021-08-29 | Currituck | North Carolina | 37053 | 1901 | 17 |
1662205 | 1662205 | 2021-08-28 | Gasconade | Missouri | 29073 | 1901 | 47 |
1662603 | 1662603 | 2021-08-28 | Currituck | North Carolina | 37053 | 1901 | 17 |
1659355 | 1659355 | 2021-08-27 | Currituck | North Carolina | 37053 | 1901 | 17 |
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);