ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
348 rows where cases = 1620 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 25
- Iowa 20
- Minnesota 20
- Kansas 19
- Michigan 18
- Tennessee 18
- Georgia 16
- Missouri 16
- Arkansas 15
- Virginia 14
- Florida 12
- North Carolina 12
- Indiana 11
- Kentucky 11
- Puerto Rico 11
- Louisiana 9
- Texas 9
- Illinois 8
- Idaho 7
- Nebraska 7
- West Virginia 7
- Montana 6
- Ohio 6
- Utah 6
- Connecticut 5
- Mississippi 5
- Wisconsin 5
- Alabama 4
- Pennsylvania 4
- New Jersey 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2269911 | 2269911 | 2022-03-03 | Wilkin | Minnesota | 27167 | 1620 | 22 |
2266658 | 2266658 | 2022-03-02 | Wilkin | Minnesota | 27167 | 1620 | 22 |
2263407 | 2263407 | 2022-03-01 | Wilkin | Minnesota | 27167 | 1620 | 22 |
2224707 | 2224707 | 2022-02-17 | Knox | Nebraska | 31107 | 1620 | 13 |
2221456 | 2221456 | 2022-02-16 | Knox | Nebraska | 31107 | 1620 | 13 |
2188935 | 2188935 | 2022-02-06 | Merrick | Nebraska | 31121 | 1620 | 15 |
2185682 | 2185682 | 2022-02-05 | Merrick | Nebraska | 31121 | 1620 | 15 |
2182430 | 2182430 | 2022-02-04 | Merrick | Nebraska | 31121 | 1620 | 15 |
2171797 | 2171797 | 2022-02-01 | Lucas | Iowa | 19117 | 1620 | 29 |
2168544 | 2168544 | 2022-01-31 | Lucas | Iowa | 19117 | 1620 | 29 |
2165289 | 2165289 | 2022-01-30 | Lucas | Iowa | 19117 | 1620 | 29 |
2162034 | 2162034 | 2022-01-29 | Lucas | Iowa | 19117 | 1620 | 29 |
2158779 | 2158779 | 2022-01-28 | Lucas | Iowa | 19117 | 1620 | 29 |
2155525 | 2155525 | 2022-01-27 | Lucas | Iowa | 19117 | 1620 | 29 |
2152272 | 2152272 | 2022-01-26 | Lucas | Iowa | 19117 | 1620 | 29 |
2154428 | 2154428 | 2022-01-26 | Middlesex | Virginia | 51119 | 1620 | 36 |
2149257 | 2149257 | 2022-01-25 | Nicholas | Kentucky | 21181 | 1620 | 29 |
2147788 | 2147788 | 2022-01-24 | Winkler | Texas | 48495 | 1620 | 33 |
2133140 | 2133140 | 2022-01-20 | Alger | Michigan | 26003 | 1620 | 11 |
2129887 | 2129887 | 2022-01-19 | Alger | Michigan | 26003 | 1620 | 11 |
2126298 | 2126298 | 2022-01-18 | Clay | Kansas | 20027 | 1620 | 32 |
2122603 | 2122603 | 2022-01-17 | Irwin | Georgia | 13155 | 1620 | 42 |
2123046 | 2123046 | 2022-01-17 | Clay | Kansas | 20027 | 1620 | 32 |
2119794 | 2119794 | 2022-01-16 | Clay | Kansas | 20027 | 1620 | 32 |
2116542 | 2116542 | 2022-01-15 | Clay | Kansas | 20027 | 1620 | 32 |
2113291 | 2113291 | 2022-01-14 | Clay | Kansas | 20027 | 1620 | 32 |
2114421 | 2114421 | 2022-01-14 | Pembina | North Dakota | 38067 | 1620 | 16 |
2111087 | 2111087 | 2022-01-13 | Jones | North Carolina | 37103 | 1620 | 38 |
2059300 | 2059300 | 2021-12-28 | Latimer | Oklahoma | 40077 | 1620 | 28 |
2056051 | 2056051 | 2021-12-27 | Latimer | Oklahoma | 40077 | 1620 | 28 |
2056235 | 2056235 | 2021-12-27 | Lares | Puerto Rico | 72081 | 1620 | |
2051130 | 2051130 | 2021-12-26 | Stewart | Georgia | 13259 | 1620 | 30 |
2052802 | 2052802 | 2021-12-26 | Latimer | Oklahoma | 40077 | 1620 | 28 |
2047880 | 2047880 | 2021-12-25 | Stewart | Georgia | 13259 | 1620 | 30 |
2049552 | 2049552 | 2021-12-25 | Latimer | Oklahoma | 40077 | 1620 | 28 |
2049747 | 2049747 | 2021-12-25 | Naguabo | Puerto Rico | 72103 | 1620 | |
2044630 | 2044630 | 2021-12-24 | Stewart | Georgia | 13259 | 1620 | 30 |
2046302 | 2046302 | 2021-12-24 | Latimer | Oklahoma | 40077 | 1620 | 28 |
2041381 | 2041381 | 2021-12-23 | Stewart | Georgia | 13259 | 1620 | 30 |
2043052 | 2043052 | 2021-12-23 | Latimer | Oklahoma | 40077 | 1620 | 28 |
2038131 | 2038131 | 2021-12-22 | Stewart | Georgia | 13259 | 1620 | 30 |
2039803 | 2039803 | 2021-12-22 | Latimer | Oklahoma | 40077 | 1620 | 28 |
2040623 | 2040623 | 2021-12-22 | Nelson | Virginia | 51125 | 1620 | 22 |
2040662 | 2040662 | 2021-12-22 | Sussex | Virginia | 51183 | 1620 | 30 |
2034963 | 2034963 | 2021-12-21 | Valley | Idaho | 16085 | 1620 | 13 |
2031713 | 2031713 | 2021-12-20 | Valley | Idaho | 16085 | 1620 | 13 |
2032627 | 2032627 | 2021-12-20 | Carroll | Missouri | 29033 | 1620 | 39 |
2028831 | 2028831 | 2021-12-19 | Pawnee | Kansas | 20145 | 1620 | 21 |
2025580 | 2025580 | 2021-12-18 | Pawnee | Kansas | 20145 | 1620 | 21 |
2022329 | 2022329 | 2021-12-17 | Pawnee | Kansas | 20145 | 1620 | 21 |
2019359 | 2019359 | 2021-12-16 | Baraga | Michigan | 26013 | 1620 | 48 |
2016109 | 2016109 | 2021-12-15 | Baraga | Michigan | 26013 | 1620 | 48 |
2008919 | 2008919 | 2021-12-13 | Benewah | Idaho | 16009 | 1620 | 29 |
1996272 | 1996272 | 2021-12-09 | Doniphan | Kansas | 20043 | 1620 | 29 |
1998244 | 1998244 | 2021-12-09 | Grand | Utah | 49019 | 1620 | 5 |
1993021 | 1993021 | 2021-12-08 | Doniphan | Kansas | 20043 | 1620 | 29 |
1991657 | 1991657 | 2021-12-07 | Ochiltree | Texas | 48357 | 1620 | 38 |
1988406 | 1988406 | 2021-12-06 | Ochiltree | Texas | 48357 | 1620 | 38 |
1983711 | 1983711 | 2021-12-05 | Jackson | Minnesota | 27063 | 1620 | 16 |
1985156 | 1985156 | 2021-12-05 | Ochiltree | Texas | 48357 | 1620 | 38 |
1980461 | 1980461 | 2021-12-04 | Jackson | Minnesota | 27063 | 1620 | 16 |
1981906 | 1981906 | 2021-12-04 | Ochiltree | Texas | 48357 | 1620 | 38 |
1977211 | 1977211 | 2021-12-03 | Jackson | Minnesota | 27063 | 1620 | 16 |
1966968 | 1966968 | 2021-11-30 | Montgomery | Iowa | 19137 | 1620 | 45 |
1967014 | 1967014 | 2021-11-30 | Cloud | Kansas | 20029 | 1620 | 30 |
1963716 | 1963716 | 2021-11-29 | Montgomery | Iowa | 19137 | 1620 | 45 |
1963762 | 1963762 | 2021-11-29 | Cloud | Kansas | 20029 | 1620 | 30 |
1960465 | 1960465 | 2021-11-28 | Montgomery | Iowa | 19137 | 1620 | 45 |
1957214 | 1957214 | 2021-11-27 | Montgomery | Iowa | 19137 | 1620 | 45 |
1953963 | 1953963 | 2021-11-26 | Montgomery | Iowa | 19137 | 1620 | 45 |
1950712 | 1950712 | 2021-11-25 | Montgomery | Iowa | 19137 | 1620 | 45 |
1947461 | 1947461 | 2021-11-24 | Montgomery | Iowa | 19137 | 1620 | 45 |
1938107 | 1938107 | 2021-11-21 | Crawford | Michigan | 26039 | 1620 | 17 |
1934857 | 1934857 | 2021-11-20 | Crawford | Michigan | 26039 | 1620 | 17 |
1931607 | 1931607 | 2021-11-19 | Crawford | Michigan | 26039 | 1620 | 17 |
1931930 | 1931930 | 2021-11-19 | Ralls | Missouri | 29173 | 1620 | 17 |
1928496 | 1928496 | 2021-11-18 | Swift | Minnesota | 27151 | 1620 | 21 |
1898094 | 1898094 | 2021-11-09 | Archuleta | Colorado | 8007 | 1620 | 4 |
1895603 | 1895603 | 2021-11-08 | Bath | Kentucky | 21011 | 1620 | 31 |
1894489 | 1894489 | 2021-11-07 | Roane | West Virginia | 54087 | 1620 | 22 |
1875543 | 1875543 | 2021-11-02 | Evans | Georgia | 13109 | 1620 | 53 |
1875674 | 1875674 | 2021-11-02 | Clearwater | Idaho | 16035 | 1620 | 26 |
1877695 | 1877695 | 2021-11-02 | Perry | Tennessee | 47135 | 1620 | 34 |
1827892 | 1827892 | 2021-10-18 | Douglas | Missouri | 29067 | 1620 | 45 |
1824643 | 1824643 | 2021-10-17 | Douglas | Missouri | 29067 | 1620 | 45 |
1825256 | 1825256 | 2021-10-17 | Vinton | Ohio | 39163 | 1620 | 24 |
1821394 | 1821394 | 2021-10-16 | Douglas | Missouri | 29067 | 1620 | 45 |
1812044 | 1812044 | 2021-10-13 | Clay | North Carolina | 37043 | 1620 | 35 |
1807080 | 1807080 | 2021-10-12 | Mono | California | 6051 | 1620 | 5 |
1768126 | 1768126 | 2021-09-30 | Bent | Colorado | 8011 | 1620 | 23 |
1757216 | 1757216 | 2021-09-26 | Aguas Buenas | Puerto Rico | 72007 | 1620 | |
1753968 | 1753968 | 2021-09-25 | Aguas Buenas | Puerto Rico | 72007 | 1620 | |
1744540 | 1744540 | 2021-09-22 | Callahan | Texas | 48059 | 1620 | 51 |
1733438 | 1733438 | 2021-09-19 | Missaukee | Michigan | 26113 | 1620 | 29 |
1729023 | 1729023 | 2021-09-18 | Fulton | Arkansas | 5049 | 1620 | 54 |
1730188 | 1730188 | 2021-09-18 | Missaukee | Michigan | 26113 | 1620 | 29 |
1726938 | 1726938 | 2021-09-17 | Missaukee | Michigan | 26113 | 1620 | 29 |
1693776 | 1693776 | 2021-09-07 | Cumberland | Illinois | 17035 | 1620 | 33 |
1691042 | 1691042 | 2021-09-06 | Catahoula | Louisiana | 22025 | 1620 | 44 |
1687792 | 1687792 | 2021-09-05 | Catahoula | Louisiana | 22025 | 1620 | 44 |
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);