ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
564 rows where cases = 907 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 134
- Missouri 32
- Iowa 31
- Texas 31
- Georgia 27
- Arkansas 16
- South Dakota 16
- Kansas 15
- Louisiana 15
- Kentucky 14
- Montana 14
- Puerto Rico 14
- Indiana 13
- North Carolina 13
- Mississippi 12
- Virginia 12
- Idaho 11
- Alabama 10
- Florida 10
- Illinois 10
- West Virginia 10
- Tennessee 8
- Colorado 7
- Michigan 7
- Minnesota 7
- Oklahoma 7
- Maine 6
- Oregon 6
- South Carolina 6
- New Mexico 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495473 | 2495473 | 2022-05-11 | Vieques | Puerto Rico | 72147 | 907 | |
2479000 | 2479000 | 2022-05-06 | Unknown | Oklahoma | 907 | 0 | |
2475742 | 2475742 | 2022-05-05 | Unknown | Oklahoma | 907 | 0 | |
2244136 | 2244136 | 2022-02-23 | Musselshell | Montana | 30065 | 907 | 26 |
2216263 | 2216263 | 2022-02-14 | Rappahannock | Virginia | 51157 | 907 | 10 |
2193980 | 2193980 | 2022-02-08 | Gilpin | Colorado | 8047 | 907 | 4 |
2176918 | 2176918 | 2022-02-02 | Hall | Texas | 48191 | 907 | 20 |
2173664 | 2173664 | 2022-02-01 | Hall | Texas | 48191 | 907 | 20 |
2150193 | 2150193 | 2022-01-25 | LaMoure | North Dakota | 38045 | 907 | 19 |
2120903 | 2120903 | 2022-01-16 | Dunn | North Dakota | 38025 | 907 | 8 |
2102243 | 2102243 | 2022-01-10 | Wheeler | Texas | 48483 | 907 | 15 |
2080834 | 2080834 | 2022-01-04 | Ottawa | Kansas | 20143 | 907 | 15 |
2077582 | 2077582 | 2022-01-03 | Ottawa | Kansas | 20143 | 907 | 15 |
2011136 | 2011136 | 2021-12-13 | Lynn | Texas | 48305 | 907 | 27 |
2007885 | 2007885 | 2021-12-12 | Lynn | Texas | 48305 | 907 | 27 |
2004634 | 2004634 | 2021-12-11 | Lynn | Texas | 48305 | 907 | 27 |
1990220 | 1990220 | 2021-12-07 | Lincoln | Minnesota | 27081 | 907 | 5 |
1971034 | 1971034 | 2021-12-01 | Burt | Nebraska | 31021 | 907 | 13 |
1967629 | 1967629 | 2021-11-30 | Dade | Missouri | 29057 | 907 | 38 |
1961332 | 1961332 | 2021-11-28 | Morrill | Nebraska | 31123 | 907 | 16 |
1962124 | 1962124 | 2021-11-28 | Tripp | South Dakota | 46123 | 907 | 20 |
1958081 | 1958081 | 2021-11-27 | Morrill | Nebraska | 31123 | 907 | 16 |
1958873 | 1958873 | 2021-11-27 | Tripp | South Dakota | 46123 | 907 | 20 |
1954830 | 1954830 | 2021-11-26 | Morrill | Nebraska | 31123 | 907 | 16 |
1955622 | 1955622 | 2021-11-26 | Tripp | South Dakota | 46123 | 907 | 20 |
1951579 | 1951579 | 2021-11-25 | Morrill | Nebraska | 31123 | 907 | 16 |
1952371 | 1952371 | 2021-11-25 | Tripp | South Dakota | 46123 | 907 | 20 |
1948328 | 1948328 | 2021-11-24 | Morrill | Nebraska | 31123 | 907 | 16 |
1949120 | 1949120 | 2021-11-24 | Tripp | South Dakota | 46123 | 907 | 20 |
1944231 | 1944231 | 2021-11-23 | Van Buren | Iowa | 19177 | 907 | 22 |
1940981 | 1940981 | 2021-11-22 | Van Buren | Iowa | 19177 | 907 | 22 |
1937731 | 1937731 | 2021-11-21 | Van Buren | Iowa | 19177 | 907 | 22 |
1934481 | 1934481 | 2021-11-20 | Van Buren | Iowa | 19177 | 907 | 22 |
1931230 | 1931230 | 2021-11-19 | Van Buren | Iowa | 19177 | 907 | 22 |
1927979 | 1927979 | 2021-11-18 | Van Buren | Iowa | 19177 | 907 | 22 |
1924729 | 1924729 | 2021-11-17 | Van Buren | Iowa | 19177 | 907 | 22 |
1898678 | 1898678 | 2021-11-09 | Fremont | Iowa | 19071 | 907 | 11 |
1895428 | 1895428 | 2021-11-08 | Fremont | Iowa | 19071 | 907 | 11 |
1892178 | 1892178 | 2021-11-07 | Fremont | Iowa | 19071 | 907 | 11 |
1888928 | 1888928 | 2021-11-06 | Fremont | Iowa | 19071 | 907 | 11 |
1884857 | 1884857 | 2021-11-05 | Choctaw | Alabama | 1023 | 907 | 27 |
1885678 | 1885678 | 2021-11-05 | Fremont | Iowa | 19071 | 907 | 11 |
1881670 | 1881670 | 2021-11-04 | Dillingham Census Area | Alaska | 2070 | 907 | 6 |
1882429 | 1882429 | 2021-11-04 | Fremont | Iowa | 19071 | 907 | 11 |
1879180 | 1879180 | 2021-11-03 | Fremont | Iowa | 19071 | 907 | 11 |
1875029 | 1875029 | 2021-11-01 | Iron | Wisconsin | 55051 | 907 | 42 |
1861360 | 1861360 | 2021-10-28 | McCook | South Dakota | 46087 | 907 | 25 |
1853351 | 1853351 | 2021-10-26 | Wabaunsee | Kansas | 20197 | 907 | 18 |
1850102 | 1850102 | 2021-10-25 | Wabaunsee | Kansas | 20197 | 907 | 18 |
1832353 | 1832353 | 2021-10-19 | Jack | Texas | 48237 | 907 | 20 |
1828861 | 1828861 | 2021-10-18 | Kingsbury | South Dakota | 46077 | 907 | 18 |
1825612 | 1825612 | 2021-10-17 | Kingsbury | South Dakota | 46077 | 907 | 18 |
1822363 | 1822363 | 2021-10-16 | Kingsbury | South Dakota | 46077 | 907 | 18 |
1819114 | 1819114 | 2021-10-15 | Kingsbury | South Dakota | 46077 | 907 | 18 |
1815865 | 1815865 | 2021-10-14 | Kingsbury | South Dakota | 46077 | 907 | 18 |
1812159 | 1812159 | 2021-10-13 | Ransom | North Dakota | 38073 | 907 | 18 |
1808464 | 1808464 | 2021-10-12 | Shelby | Missouri | 29205 | 907 | 9 |
1805213 | 1805213 | 2021-10-11 | Shelby | Missouri | 29205 | 907 | 9 |
1806509 | 1806509 | 2021-10-11 | Kane | Utah | 49025 | 907 | 9 |
1801964 | 1801964 | 2021-10-10 | Shelby | Missouri | 29205 | 907 | 9 |
1803259 | 1803259 | 2021-10-10 | Kane | Utah | 49025 | 907 | 9 |
1798715 | 1798715 | 2021-10-09 | Shelby | Missouri | 29205 | 907 | 9 |
1800010 | 1800010 | 2021-10-09 | Kane | Utah | 49025 | 907 | 9 |
1796654 | 1796654 | 2021-10-08 | McCulloch | Texas | 48307 | 907 | 32 |
1796761 | 1796761 | 2021-10-08 | Kane | Utah | 49025 | 907 | 9 |
1787131 | 1787131 | 2021-10-05 | Middlesex | Virginia | 51119 | 907 | 25 |
1784068 | 1784068 | 2021-10-04 | Menominee | Wisconsin | 55078 | 907 | 11 |
1778721 | 1778721 | 2021-10-03 | Owsley | Kentucky | 21189 | 907 | 16 |
1775471 | 1775471 | 2021-10-02 | Owsley | Kentucky | 21189 | 907 | 16 |
1772221 | 1772221 | 2021-10-01 | Owsley | Kentucky | 21189 | 907 | 16 |
1751530 | 1751530 | 2021-09-24 | Tucker | West Virginia | 54093 | 907 | 14 |
1746547 | 1746547 | 2021-09-23 | Wilkin | Minnesota | 27167 | 907 | 14 |
1733829 | 1733829 | 2021-09-19 | Custer | Nebraska | 31041 | 907 | 19 |
1730579 | 1730579 | 2021-09-18 | Custer | Nebraska | 31041 | 907 | 19 |
1727329 | 1727329 | 2021-09-17 | Custer | Nebraska | 31041 | 907 | 19 |
1728029 | 1728029 | 2021-09-17 | Rincon | Puerto Rico | 72117 | 907 | |
1724080 | 1724080 | 2021-09-16 | Custer | Nebraska | 31041 | 907 | 19 |
1720505 | 1720505 | 2021-09-15 | Lake | Minnesota | 27075 | 907 | 21 |
1720831 | 1720831 | 2021-09-15 | Custer | Nebraska | 31041 | 907 | 19 |
1717583 | 1717583 | 2021-09-14 | Custer | Nebraska | 31041 | 907 | 19 |
1718570 | 1718570 | 2021-09-14 | Crosby | Texas | 48107 | 907 | 32 |
1714335 | 1714335 | 2021-09-13 | Custer | Nebraska | 31041 | 907 | 19 |
1710993 | 1710993 | 2021-09-12 | Shannon | Missouri | 29203 | 907 | 16 |
1711089 | 1711089 | 2021-09-12 | Custer | Nebraska | 31041 | 907 | 19 |
1707842 | 1707842 | 2021-09-11 | Custer | Nebraska | 31041 | 907 | 19 |
1704465 | 1704465 | 2021-09-10 | Maries | Missouri | 29125 | 907 | 15 |
1704595 | 1704595 | 2021-09-10 | Custer | Nebraska | 31041 | 907 | 19 |
1700198 | 1700198 | 2021-09-09 | Wheeler | Georgia | 13309 | 907 | 28 |
1700279 | 1700279 | 2021-09-09 | Edwards | Illinois | 17047 | 907 | 14 |
1701345 | 1701345 | 2021-09-09 | Custer | Nebraska | 31041 | 907 | 19 |
1696967 | 1696967 | 2021-09-08 | Benewah | Idaho | 16009 | 907 | 11 |
1698096 | 1698096 | 2021-09-08 | Custer | Nebraska | 31041 | 907 | 19 |
1694848 | 1694848 | 2021-09-07 | Custer | Nebraska | 31041 | 907 | 19 |
1691599 | 1691599 | 2021-09-06 | Custer | Nebraska | 31041 | 907 | 19 |
1688349 | 1688349 | 2021-09-05 | Custer | Nebraska | 31041 | 907 | 19 |
1685099 | 1685099 | 2021-09-04 | Custer | Nebraska | 31041 | 907 | 19 |
1681848 | 1681848 | 2021-09-03 | Custer | Nebraska | 31041 | 907 | 19 |
1678600 | 1678600 | 2021-09-02 | Custer | Nebraska | 31041 | 907 | 19 |
1675278 | 1675278 | 2021-09-01 | Blaine | Montana | 30005 | 907 | 24 |
1675352 | 1675352 | 2021-09-01 | Custer | Nebraska | 31041 | 907 | 19 |
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);