ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
340 rows where cases = 1627 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 35
- Virginia 24
- Illinois 23
- Texas 21
- Florida 18
- Minnesota 18
- Puerto Rico 18
- Tennessee 18
- Georgia 17
- Arkansas 14
- Mississippi 12
- Missouri 11
- Alabama 9
- Montana 8
- North Carolina 8
- Kansas 7
- Wisconsin 7
- Kentucky 6
- Nebraska 6
- Idaho 5
- Pennsylvania 5
- Washington 5
- Wyoming 5
- Indiana 4
- Michigan 4
- Maryland 3
- New York 3
- Oklahoma 3
- Oregon 3
- Utah 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2292677 | 2292677 | 2022-03-10 | Wilkin | Minnesota | 27167 | 1627 | 22 |
2288543 | 2288543 | 2022-03-09 | Treutlen | Georgia | 13283 | 1627 | 59 |
2285292 | 2285292 | 2022-03-08 | Treutlen | Georgia | 13283 | 1627 | 59 |
2200024 | 2200024 | 2022-02-09 | Williamsburg city | Virginia | 51830 | 1627 | 13 |
2196311 | 2196311 | 2022-02-08 | Pickett | Tennessee | 47137 | 1627 | 29 |
2193057 | 2193057 | 2022-02-07 | Pickett | Tennessee | 47137 | 1627 | 29 |
2188568 | 2188568 | 2022-02-06 | Lac qui Parle | Minnesota | 27073 | 1627 | 28 |
2189803 | 2189803 | 2022-02-06 | Pickett | Tennessee | 47137 | 1627 | 29 |
2190145 | 2190145 | 2022-02-06 | Bland | Virginia | 51021 | 1627 | 19 |
2185315 | 2185315 | 2022-02-05 | Lac qui Parle | Minnesota | 27073 | 1627 | 28 |
2186550 | 2186550 | 2022-02-05 | Pickett | Tennessee | 47137 | 1627 | 29 |
2186892 | 2186892 | 2022-02-05 | Bland | Virginia | 51021 | 1627 | 19 |
2182063 | 2182063 | 2022-02-04 | Lac qui Parle | Minnesota | 27073 | 1627 | 28 |
2183298 | 2183298 | 2022-02-04 | Pickett | Tennessee | 47137 | 1627 | 29 |
2183639 | 2183639 | 2022-02-04 | Bland | Virginia | 51021 | 1627 | 19 |
2179204 | 2179204 | 2022-02-03 | Thurston | Nebraska | 31173 | 1627 | 19 |
2180046 | 2180046 | 2022-02-03 | Pickett | Tennessee | 47137 | 1627 | 29 |
2176795 | 2176795 | 2022-02-02 | Pickett | Tennessee | 47137 | 1627 | 29 |
2131006 | 2131006 | 2022-01-19 | Guayanilla | Puerto Rico | 72059 | 1627 | |
2126252 | 2126252 | 2022-01-18 | Monroe | Iowa | 19135 | 1627 | 43 |
2122821 | 2122821 | 2022-01-17 | Schuyler | Illinois | 17169 | 1627 | 27 |
2123000 | 2123000 | 2022-01-17 | Monroe | Iowa | 19135 | 1627 | 43 |
2119569 | 2119569 | 2022-01-16 | Schuyler | Illinois | 17169 | 1627 | 27 |
2119748 | 2119748 | 2022-01-16 | Monroe | Iowa | 19135 | 1627 | 43 |
2116317 | 2116317 | 2022-01-15 | Schuyler | Illinois | 17169 | 1627 | 27 |
2116496 | 2116496 | 2022-01-15 | Monroe | Iowa | 19135 | 1627 | 43 |
2113066 | 2113066 | 2022-01-14 | Schuyler | Illinois | 17169 | 1627 | 27 |
2113245 | 2113245 | 2022-01-14 | Monroe | Iowa | 19135 | 1627 | 43 |
2109993 | 2109993 | 2022-01-13 | Monroe | Iowa | 19135 | 1627 | 43 |
2106742 | 2106742 | 2022-01-12 | Monroe | Iowa | 19135 | 1627 | 43 |
2102017 | 2102017 | 2022-01-10 | Blanco | Texas | 48031 | 1627 | 28 |
2096176 | 2096176 | 2022-01-09 | Perry | Alabama | 1105 | 1627 | 41 |
2096248 | 2096248 | 2022-01-09 | Cleveland | Arkansas | 5025 | 1627 | 33 |
2096285 | 2096285 | 2022-01-09 | Nevada | Arkansas | 5099 | 1627 | 43 |
2092996 | 2092996 | 2022-01-08 | Cleveland | Arkansas | 5025 | 1627 | 33 |
2093033 | 2093033 | 2022-01-08 | Nevada | Arkansas | 5099 | 1627 | 43 |
2077006 | 2077006 | 2022-01-03 | Atkinson | Georgia | 13003 | 1627 | 39 |
2078000 | 2078000 | 2022-01-03 | Pipestone | Minnesota | 27117 | 1627 | 30 |
2073755 | 2073755 | 2022-01-02 | Atkinson | Georgia | 13003 | 1627 | 39 |
2070504 | 2070504 | 2022-01-01 | Atkinson | Georgia | 13003 | 1627 | 39 |
2067253 | 2067253 | 2021-12-31 | Atkinson | Georgia | 13003 | 1627 | 39 |
2054462 | 2054462 | 2021-12-27 | Valley | Idaho | 16085 | 1627 | 13 |
2053155 | 2053155 | 2021-12-26 | Clay | Tennessee | 47027 | 1627 | 39 |
2049905 | 2049905 | 2021-12-25 | Clay | Tennessee | 47027 | 1627 | 39 |
2046655 | 2046655 | 2021-12-24 | Clay | Tennessee | 47027 | 1627 | 39 |
2043405 | 2043405 | 2021-12-23 | Clay | Tennessee | 47027 | 1627 | 39 |
2039304 | 2039304 | 2021-12-22 | Custer | Nebraska | 31041 | 1627 | 23 |
2035332 | 2035332 | 2021-12-21 | Pawnee | Kansas | 20145 | 1627 | 21 |
2036054 | 2036054 | 2021-12-21 | Custer | Nebraska | 31041 | 1627 | 23 |
2032082 | 2032082 | 2021-12-20 | Pawnee | Kansas | 20145 | 1627 | 21 |
2022895 | 2022895 | 2021-12-17 | Gentry | Missouri | 29075 | 1627 | 28 |
2024171 | 2024171 | 2021-12-17 | Parmer | Texas | 48369 | 1627 | 43 |
2017791 | 2017791 | 2021-12-15 | Amelia | Virginia | 51007 | 1627 | 42 |
2014563 | 2014563 | 2021-12-14 | Clarke | Virginia | 51043 | 1627 | 33 |
2002018 | 2002018 | 2021-12-11 | Perry | Arkansas | 5105 | 1627 | 23 |
1994908 | 1994908 | 2021-12-08 | Ochiltree | Texas | 48357 | 1627 | 38 |
1966682 | 1966682 | 2021-11-30 | Fremont | Idaho | 16043 | 1627 | 18 |
1965850 | 1965850 | 2021-11-29 | Lexington city | Virginia | 51678 | 1627 | 37 |
1942596 | 1942596 | 2021-11-22 | Lake | South Dakota | 46079 | 1627 | 20 |
1925842 | 1925842 | 2021-11-17 | Washington | North Carolina | 37187 | 1627 | 37 |
1922593 | 1922593 | 2021-11-16 | Washington | North Carolina | 37187 | 1627 | 37 |
1915044 | 1915044 | 2021-11-14 | Linn | Kansas | 20107 | 1627 | 21 |
1911794 | 1911794 | 2021-11-13 | Linn | Kansas | 20107 | 1627 | 21 |
1908545 | 1908545 | 2021-11-12 | Linn | Kansas | 20107 | 1627 | 21 |
1890388 | 1890388 | 2021-11-06 | Forest | Pennsylvania | 42053 | 1627 | 25 |
1882314 | 1882314 | 2021-11-04 | Crawford | Indiana | 18025 | 1627 | 29 |
1875181 | 1875181 | 2021-11-02 | Nome Census Area | Alaska | 2180 | 1627 | 2 |
1875677 | 1875677 | 2021-11-02 | Franklin | Idaho | 16041 | 1627 | 23 |
1874821 | 1874821 | 2021-11-01 | Franklin city | Virginia | 51620 | 1627 | 44 |
1870016 | 1870016 | 2021-10-31 | Yellow Medicine | Minnesota | 27173 | 1627 | 21 |
1866767 | 1866767 | 2021-10-30 | Yellow Medicine | Minnesota | 27173 | 1627 | 21 |
1863518 | 1863518 | 2021-10-29 | Yellow Medicine | Minnesota | 27173 | 1627 | 21 |
1852950 | 1852950 | 2021-10-26 | Owyhee | Idaho | 16073 | 1627 | 39 |
1847110 | 1847110 | 2021-10-24 | Benzie | Michigan | 26019 | 1627 | 40 |
1843860 | 1843860 | 2021-10-23 | Benzie | Michigan | 26019 | 1627 | 40 |
1840610 | 1840610 | 2021-10-22 | Benzie | Michigan | 26019 | 1627 | 40 |
1840888 | 1840888 | 2021-10-22 | Douglas | Missouri | 29067 | 1627 | 46 |
1837639 | 1837639 | 2021-10-21 | Douglas | Missouri | 29067 | 1627 | 46 |
1815292 | 1815292 | 2021-10-14 | Clay | North Carolina | 37043 | 1627 | 35 |
1809277 | 1809277 | 2021-10-12 | Yabucoa | Puerto Rico | 72151 | 1627 | |
1806027 | 1806027 | 2021-10-11 | Yabucoa | Puerto Rico | 72151 | 1627 | |
1796205 | 1796205 | 2021-10-08 | Aguas Buenas | Puerto Rico | 72007 | 1627 | |
1785003 | 1785003 | 2021-10-05 | Shelby | Iowa | 19165 | 1627 | 39 |
1785235 | 1785235 | 2021-10-05 | Todd | Kentucky | 21219 | 1627 | 30 |
1781754 | 1781754 | 2021-10-04 | Shelby | Iowa | 19165 | 1627 | 39 |
1782286 | 1782286 | 2021-10-04 | Watonwan | Minnesota | 27165 | 1627 | 11 |
1778504 | 1778504 | 2021-10-03 | Shelby | Iowa | 19165 | 1627 | 39 |
1775254 | 1775254 | 2021-10-02 | Shelby | Iowa | 19165 | 1627 | 39 |
1772004 | 1772004 | 2021-10-01 | Shelby | Iowa | 19165 | 1627 | 39 |
1768755 | 1768755 | 2021-09-30 | Shelby | Iowa | 19165 | 1627 | 39 |
1765506 | 1765506 | 2021-09-29 | Shelby | Iowa | 19165 | 1627 | 39 |
1766144 | 1766144 | 2021-09-29 | Cedar | Missouri | 29039 | 1627 | 30 |
1745300 | 1745300 | 2021-09-23 | Pike | Arkansas | 5109 | 1627 | 34 |
1725330 | 1725330 | 2021-09-16 | Brunswick | Virginia | 51025 | 1627 | 29 |
1696485 | 1696485 | 2021-09-08 | Kodiak Island Borough | Alaska | 2150 | 1627 | 6 |
1697908 | 1697908 | 2021-09-08 | Barton | Missouri | 29011 | 1627 | 22 |
1691372 | 1691372 | 2021-09-06 | Montgomery | Mississippi | 28097 | 1627 | 48 |
1683451 | 1683451 | 2021-09-04 | Lowndes | Alabama | 1085 | 1627 | 55 |
1671212 | 1671212 | 2021-08-31 | Allamakee | Iowa | 19005 | 1627 | 52 |
1667965 | 1667965 | 2021-08-30 | Allamakee | Iowa | 19005 | 1627 | 52 |
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);