ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
480 rows where cases = 879 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 35
- Puerto Rico 34
- Virginia 33
- Georgia 31
- Kentucky 24
- Montana 23
- Missouri 22
- Nebraska 21
- Kansas 17
- Minnesota 17
- Iowa 16
- Colorado 15
- Arkansas 13
- Mississippi 12
- North Carolina 12
- Illinois 11
- Louisiana 11
- West Virginia 10
- Idaho 8
- Alabama 7
- Florida 7
- Indiana 7
- New Mexico 7
- South Carolina 7
- South Dakota 7
- Tennessee 7
- Vermont 7
- Wyoming 7
- Oregon 6
- Michigan 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500631 | 2500631 | 2022-05-13 | Hickman | Kentucky | 21105 | 879 | 27 |
2497373 | 2497373 | 2022-05-12 | Hickman | Kentucky | 21105 | 879 | 27 |
2494115 | 2494115 | 2022-05-11 | Hickman | Kentucky | 21105 | 879 | 27 |
2490857 | 2490857 | 2022-05-10 | Hickman | Kentucky | 21105 | 879 | 27 |
2487600 | 2487600 | 2022-05-09 | Hickman | Kentucky | 21105 | 879 | 27 |
2403752 | 2403752 | 2022-04-13 | Hamilton | New York | 36041 | 879 | 5 |
2352483 | 2352483 | 2022-03-28 | Cochran | Texas | 48079 | 879 | 23 |
2349231 | 2349231 | 2022-03-27 | Cochran | Texas | 48079 | 879 | 23 |
2345978 | 2345978 | 2022-03-26 | Cochran | Texas | 48079 | 879 | 23 |
2281196 | 2281196 | 2022-03-06 | Bath | Virginia | 51017 | 879 | 19 |
2277943 | 2277943 | 2022-03-05 | Bath | Virginia | 51017 | 879 | 19 |
2274690 | 2274690 | 2022-03-04 | Bath | Virginia | 51017 | 879 | 19 |
2183429 | 2183429 | 2022-02-04 | Haskell | Texas | 48207 | 879 | 37 |
2161448 | 2161448 | 2022-01-29 | Gilpin | Colorado | 8047 | 879 | 4 |
2154939 | 2154939 | 2022-01-27 | Gilpin | Colorado | 8047 | 879 | 4 |
2148486 | 2148486 | 2022-01-25 | Unknown | Delaware | 879 | 0 | |
2148605 | 2148605 | 2022-01-25 | Echols | Georgia | 13101 | 879 | 11 |
2149750 | 2149750 | 2022-01-25 | Putnam | Missouri | 29171 | 879 | 20 |
2150906 | 2150906 | 2022-01-25 | Hudspeth | Texas | 48229 | 879 | 16 |
2141744 | 2141744 | 2022-01-23 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 879 | 6 |
2144618 | 2144618 | 2022-01-23 | Covington city | Virginia | 51580 | 879 | 20 |
2138488 | 2138488 | 2022-01-22 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 879 | 6 |
2141363 | 2141363 | 2022-01-22 | Covington city | Virginia | 51580 | 879 | 20 |
2135233 | 2135233 | 2022-01-21 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 879 | 6 |
2138107 | 2138107 | 2022-01-21 | Covington city | Virginia | 51580 | 879 | 20 |
2134373 | 2134373 | 2022-01-20 | Corson | South Dakota | 46031 | 879 | 15 |
2134616 | 2134616 | 2022-01-20 | Hall | Texas | 48191 | 879 | 18 |
2123677 | 2123677 | 2022-01-17 | Holt | Missouri | 29087 | 879 | 25 |
2124398 | 2124398 | 2022-01-17 | Wallowa | Oregon | 41063 | 879 | 13 |
2120425 | 2120425 | 2022-01-16 | Holt | Missouri | 29087 | 879 | 25 |
2121146 | 2121146 | 2022-01-16 | Wallowa | Oregon | 41063 | 879 | 13 |
2121260 | 2121260 | 2022-01-16 | Las Marias | Puerto Rico | 72083 | 879 | |
2117173 | 2117173 | 2022-01-15 | Holt | Missouri | 29087 | 879 | 25 |
2117894 | 2117894 | 2022-01-15 | Wallowa | Oregon | 41063 | 879 | 13 |
2114643 | 2114643 | 2022-01-14 | Wallowa | Oregon | 41063 | 879 | 13 |
2115095 | 2115095 | 2022-01-14 | Goliad | Texas | 48175 | 879 | 28 |
2110780 | 2110780 | 2022-01-13 | Pondera | Montana | 30073 | 879 | 6 |
2101052 | 2101052 | 2022-01-10 | Boone | Nebraska | 31011 | 879 | 4 |
2101127 | 2101127 | 2022-01-10 | Sheridan | Nebraska | 31161 | 879 | 23 |
2077653 | 2077653 | 2022-01-03 | Fulton | Kentucky | 21075 | 879 | 23 |
2079481 | 2079481 | 2022-01-03 | Wheeler | Texas | 48483 | 879 | 15 |
2060997 | 2060997 | 2021-12-29 | Henderson | Illinois | 17071 | 879 | 24 |
2057714 | 2057714 | 2021-12-28 | Alexander | Illinois | 17003 | 879 | 13 |
2058761 | 2058761 | 2021-12-28 | Phillips | Montana | 30071 | 879 | 27 |
2055512 | 2055512 | 2021-12-27 | Phillips | Montana | 30071 | 879 | 27 |
2056828 | 2056828 | 2021-12-27 | Falls Church city | Virginia | 51610 | 879 | 14 |
2052262 | 2052262 | 2021-12-26 | Phillips | Montana | 30071 | 879 | 27 |
2049012 | 2049012 | 2021-12-25 | Phillips | Montana | 30071 | 879 | 27 |
2045762 | 2045762 | 2021-12-24 | Phillips | Montana | 30071 | 879 | 27 |
2042512 | 2042512 | 2021-12-23 | Phillips | Montana | 30071 | 879 | 27 |
2039309 | 2039309 | 2021-12-22 | Dixon | Nebraska | 31051 | 879 | 11 |
2036316 | 2036316 | 2021-12-21 | Hyde | North Carolina | 37095 | 879 | 12 |
2029512 | 2029512 | 2021-12-19 | Phillips | Montana | 30071 | 879 | 27 |
2026261 | 2026261 | 2021-12-18 | Phillips | Montana | 30071 | 879 | 27 |
2023010 | 2023010 | 2021-12-17 | Phillips | Montana | 30071 | 879 | 27 |
2019759 | 2019759 | 2021-12-16 | Phillips | Montana | 30071 | 879 | 27 |
2016509 | 2016509 | 2021-12-15 | Phillips | Montana | 30071 | 879 | 27 |
2017949 | 2017949 | 2021-12-15 | Skamania | Washington | 53059 | 879 | 7 |
2014267 | 2014267 | 2021-12-14 | Carson | Texas | 48065 | 879 | 28 |
2001386 | 2001386 | 2021-12-10 | Martin | Texas | 48317 | 879 | 24 |
1998136 | 1998136 | 2021-12-09 | Martin | Texas | 48317 | 879 | 24 |
1994882 | 1994882 | 2021-12-08 | Lynn | Texas | 48305 | 879 | 27 |
1995174 | 1995174 | 2021-12-08 | Ferry | Washington | 53019 | 879 | 17 |
1971753 | 1971753 | 2021-12-01 | Santa Isabel | Puerto Rico | 72133 | 879 | |
1967061 | 1967061 | 2021-11-30 | Mitchell | Kansas | 20123 | 879 | 17 |
1963809 | 1963809 | 2021-11-29 | Mitchell | Kansas | 20123 | 879 | 17 |
1960582 | 1960582 | 2021-11-28 | Scott | Kansas | 20171 | 879 | 31 |
1957331 | 1957331 | 2021-11-27 | Scott | Kansas | 20171 | 879 | 31 |
1954080 | 1954080 | 2021-11-26 | Scott | Kansas | 20171 | 879 | 31 |
1950829 | 1950829 | 2021-11-25 | Scott | Kansas | 20171 | 879 | 31 |
1947578 | 1947578 | 2021-11-24 | Scott | Kansas | 20171 | 879 | 31 |
1941775 | 1941775 | 2021-11-22 | Burt | Nebraska | 31021 | 879 | 13 |
1923745 | 1923745 | 2021-11-16 | Wirt | West Virginia | 54105 | 879 | 14 |
1919062 | 1919062 | 2021-11-15 | Jefferson | Nebraska | 31095 | 879 | 3 |
1912370 | 1912370 | 2021-11-13 | Dade | Missouri | 29057 | 879 | 17 |
1909120 | 1909120 | 2021-11-12 | Dade | Missouri | 29057 | 879 | 17 |
1906009 | 1906009 | 2021-11-11 | Teton | Montana | 30099 | 879 | 13 |
1902760 | 1902760 | 2021-11-10 | Teton | Montana | 30099 | 879 | 13 |
1884831 | 1884831 | 2021-11-04 | Hot Springs | Wyoming | 56017 | 879 | 9 |
1881582 | 1881582 | 2021-11-03 | Hot Springs | Wyoming | 56017 | 879 | 9 |
1855678 | 1855678 | 2021-10-27 | Dillingham Census Area | Alaska | 2070 | 879 | 5 |
1846827 | 1846827 | 2021-10-24 | Phillips | Kansas | 20147 | 879 | 26 |
1843577 | 1843577 | 2021-10-23 | Phillips | Kansas | 20147 | 879 | 26 |
1840327 | 1840327 | 2021-10-22 | Phillips | Kansas | 20147 | 879 | 26 |
1837083 | 1837083 | 2021-10-21 | Republic | Kansas | 20157 | 879 | 15 |
1839113 | 1839113 | 2021-10-21 | Mathews | Virginia | 51115 | 879 | 21 |
1833834 | 1833834 | 2021-10-20 | Republic | Kansas | 20157 | 879 | 15 |
1835864 | 1835864 | 2021-10-20 | Mathews | Virginia | 51115 | 879 | 21 |
1832615 | 1832615 | 2021-10-19 | Mathews | Virginia | 51115 | 879 | 21 |
1829366 | 1829366 | 2021-10-18 | Mathews | Virginia | 51115 | 879 | 21 |
1826217 | 1826217 | 2021-10-17 | Calhoun | West Virginia | 54013 | 879 | 4 |
1790919 | 1790919 | 2021-10-07 | Rio Blanco | Colorado | 8103 | 879 | 8 |
1791617 | 1791617 | 2021-10-07 | Wabaunsee | Kansas | 20197 | 879 | 18 |
1787650 | 1787650 | 2021-10-06 | Kit Carson | Colorado | 8063 | 879 | 14 |
1788368 | 1788368 | 2021-10-06 | Wabaunsee | Kansas | 20197 | 879 | 18 |
1786916 | 1786916 | 2021-10-05 | Mitchell | Texas | 48335 | 879 | 36 |
1779346 | 1779346 | 2021-10-03 | Keith | Nebraska | 31101 | 879 | 10 |
1779369 | 1779369 | 2021-10-03 | Richardson | Nebraska | 31147 | 879 | 24 |
1776096 | 1776096 | 2021-10-02 | Keith | Nebraska | 31101 | 879 | 10 |
1776119 | 1776119 | 2021-10-02 | Richardson | Nebraska | 31147 | 879 | 24 |
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);