ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
472 rows where cases = 969 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 35
- Georgia 33
- Colorado 27
- Nevada 25
- Puerto Rico 25
- Texas 21
- Arkansas 18
- Mississippi 18
- Kentucky 17
- Nebraska 15
- Tennessee 15
- Louisiana 14
- Missouri 14
- Virginia 14
- Minnesota 12
- Montana 11
- Alabama 10
- Iowa 10
- Idaho 9
- Indiana 9
- North Carolina 9
- Michigan 8
- New Mexico 7
- South Dakota 7
- Alaska 6
- Florida 6
- North Dakota 6
- Oklahoma 6
- Pennsylvania 6
- South Carolina 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501329 | 2501329 | 2022-05-13 | Sheridan | Nebraska | 31161 | 969 | 23 |
2501736 | 2501736 | 2022-05-13 | Beaver | Oklahoma | 40007 | 969 | 11 |
2498478 | 2498478 | 2022-05-12 | Beaver | Oklahoma | 40007 | 969 | 11 |
2486813 | 2486813 | 2022-05-09 | Gilpin | Colorado | 8047 | 969 | 4 |
2279278 | 2279278 | 2022-03-06 | Carlisle | Kentucky | 21039 | 969 | 19 |
2276025 | 2276025 | 2022-03-05 | Carlisle | Kentucky | 21039 | 969 | 19 |
2272772 | 2272772 | 2022-03-04 | Carlisle | Kentucky | 21039 | 969 | 19 |
2263173 | 2263173 | 2022-03-01 | Unknown | Louisiana | 969 | 0 | |
2259922 | 2259922 | 2022-02-28 | Unknown | Louisiana | 969 | 0 | |
2256671 | 2256671 | 2022-02-27 | Unknown | Louisiana | 969 | 0 | |
2253420 | 2253420 | 2022-02-26 | Unknown | Louisiana | 969 | 0 | |
2250169 | 2250169 | 2022-02-25 | Unknown | Louisiana | 969 | 0 | |
2247362 | 2247362 | 2022-02-24 | Chouteau | Montana | 30015 | 969 | 14 |
2245230 | 2245230 | 2022-02-23 | Hudspeth | Texas | 48229 | 969 | 16 |
2228255 | 2228255 | 2022-02-18 | Foster | North Dakota | 38031 | 969 | 21 |
2225004 | 2225004 | 2022-02-17 | Foster | North Dakota | 38031 | 969 | 21 |
2215258 | 2215258 | 2022-02-14 | LaMoure | North Dakota | 38045 | 969 | 19 |
2150488 | 2150488 | 2022-01-25 | Sullivan | Pennsylvania | 42113 | 969 | 32 |
2144035 | 2144035 | 2022-01-23 | Las Marias | Puerto Rico | 72083 | 969 | |
2081691 | 2081691 | 2022-01-04 | Guadalupe | New Mexico | 35019 | 969 | 15 |
2082644 | 2082644 | 2022-01-04 | Lynn | Texas | 48305 | 969 | 29 |
2053873 | 2053873 | 2021-12-27 | Choctaw | Alabama | 1023 | 969 | 30 |
2050623 | 2050623 | 2021-12-26 | Choctaw | Alabama | 1023 | 969 | 30 |
2047373 | 2047373 | 2021-12-25 | Choctaw | Alabama | 1023 | 969 | 30 |
2044123 | 2044123 | 2021-12-24 | Choctaw | Alabama | 1023 | 969 | 30 |
2040126 | 2040126 | 2021-12-22 | Moody | South Dakota | 46101 | 969 | 25 |
2019084 | 2019084 | 2021-12-16 | Republic | Kansas | 20157 | 969 | 14 |
2015834 | 2015834 | 2021-12-15 | Republic | Kansas | 20157 | 969 | 14 |
2017536 | 2017536 | 2021-12-15 | Crane | Texas | 48103 | 969 | 19 |
2017587 | 2017587 | 2021-12-15 | Hartley | Texas | 48205 | 969 | 2 |
1997403 | 1997403 | 2021-12-09 | Sioux | North Dakota | 38085 | 969 | 18 |
1993436 | 1993436 | 2021-12-08 | Big Stone | Minnesota | 27011 | 969 | 6 |
1974049 | 1974049 | 2021-12-02 | Jefferson | Mississippi | 28063 | 969 | 34 |
1975103 | 1975103 | 2021-12-02 | Kingsbury | South Dakota | 46077 | 969 | 18 |
1970800 | 1970800 | 2021-12-01 | Jefferson | Mississippi | 28063 | 969 | 34 |
1970971 | 1970971 | 2021-12-01 | Broadwater | Montana | 30007 | 969 | 17 |
1967550 | 1967550 | 2021-11-30 | Jefferson | Mississippi | 28063 | 969 | 34 |
1964298 | 1964298 | 2021-11-29 | Jefferson | Mississippi | 28063 | 969 | 34 |
1937780 | 1937780 | 2021-11-21 | Harper | Kansas | 20077 | 969 | 24 |
1934530 | 1934530 | 2021-11-20 | Harper | Kansas | 20077 | 969 | 24 |
1931279 | 1931279 | 2021-11-19 | Harper | Kansas | 20077 | 969 | 24 |
1918940 | 1918940 | 2021-11-15 | Shelby | Missouri | 29205 | 969 | 9 |
1915690 | 1915690 | 2021-11-14 | Shelby | Missouri | 29205 | 969 | 9 |
1917288 | 1917288 | 2021-11-14 | Menominee | Wisconsin | 55078 | 969 | 11 |
1914038 | 1914038 | 2021-11-13 | Menominee | Wisconsin | 55078 | 969 | 11 |
1910788 | 1910788 | 2021-11-12 | Menominee | Wisconsin | 55078 | 969 | 11 |
1907237 | 1907237 | 2021-11-11 | Kane | Utah | 49025 | 969 | 11 |
1903988 | 1903988 | 2021-11-10 | Kane | Utah | 49025 | 969 | 11 |
1900738 | 1900738 | 2021-11-09 | Kane | Utah | 49025 | 969 | 11 |
1875585 | 1875585 | 2021-11-02 | Marion | Georgia | 13197 | 969 | 39 |
1872336 | 1872336 | 2021-11-01 | Marion | Georgia | 13197 | 969 | 39 |
1869087 | 1869087 | 2021-10-31 | Marion | Georgia | 13197 | 969 | 39 |
1865838 | 1865838 | 2021-10-30 | Marion | Georgia | 13197 | 969 | 39 |
1862589 | 1862589 | 2021-10-29 | Marion | Georgia | 13197 | 969 | 39 |
1859340 | 1859340 | 2021-10-28 | Marion | Georgia | 13197 | 969 | 39 |
1856091 | 1856091 | 2021-10-27 | Marion | Georgia | 13197 | 969 | 39 |
1846154 | 1846154 | 2021-10-24 | Rio Blanco | Colorado | 8103 | 969 | 8 |
1842904 | 1842904 | 2021-10-23 | Rio Blanco | Colorado | 8103 | 969 | 8 |
1844617 | 1844617 | 2021-10-23 | Bottineau | North Dakota | 38009 | 969 | 21 |
1839654 | 1839654 | 2021-10-22 | Rio Blanco | Colorado | 8103 | 969 | 8 |
1829362 | 1829362 | 2021-10-18 | Madison | Virginia | 51113 | 969 | 20 |
1811712 | 1811712 | 2021-10-13 | Shannon | Missouri | 29203 | 969 | 17 |
1795431 | 1795431 | 2021-10-08 | Maries | Missouri | 29125 | 969 | 18 |
1790901 | 1790901 | 2021-10-07 | Lake | Colorado | 8065 | 969 | 1 |
1785644 | 1785644 | 2021-10-05 | Clark | Missouri | 29045 | 969 | 12 |
1782395 | 1782395 | 2021-10-04 | Clark | Missouri | 29045 | 969 | 12 |
1778135 | 1778135 | 2021-10-03 | Randolph | Georgia | 13243 | 969 | 39 |
1779145 | 1779145 | 2021-10-03 | Clark | Missouri | 29045 | 969 | 12 |
1774885 | 1774885 | 2021-10-02 | Randolph | Georgia | 13243 | 969 | 39 |
1775895 | 1775895 | 2021-10-02 | Clark | Missouri | 29045 | 969 | 12 |
1771635 | 1771635 | 2021-10-01 | Randolph | Georgia | 13243 | 969 | 39 |
1766408 | 1766408 | 2021-09-29 | White Pine | Nevada | 32033 | 969 | 10 |
1763159 | 1763159 | 2021-09-28 | White Pine | Nevada | 32033 | 969 | 10 |
1759910 | 1759910 | 2021-09-27 | White Pine | Nevada | 32033 | 969 | 10 |
1756662 | 1756662 | 2021-09-26 | White Pine | Nevada | 32033 | 969 | 10 |
1753414 | 1753414 | 2021-09-25 | White Pine | Nevada | 32033 | 969 | 10 |
1750166 | 1750166 | 2021-09-24 | White Pine | Nevada | 32033 | 969 | 10 |
1746752 | 1746752 | 2021-09-23 | Blaine | Montana | 30005 | 969 | 24 |
1746916 | 1746916 | 2021-09-23 | White Pine | Nevada | 32033 | 969 | 10 |
1743667 | 1743667 | 2021-09-22 | White Pine | Nevada | 32033 | 969 | 10 |
1738719 | 1738719 | 2021-09-21 | Nome Census Area | Alaska | 2180 | 969 | 0 |
1740361 | 1740361 | 2021-09-21 | Knox | Nebraska | 31107 | 969 | 13 |
1740418 | 1740418 | 2021-09-21 | White Pine | Nevada | 32033 | 969 | 10 |
1735470 | 1735470 | 2021-09-20 | Nome Census Area | Alaska | 2180 | 969 | 0 |
1736417 | 1736417 | 2021-09-20 | Crittenden | Kentucky | 21055 | 969 | 30 |
1725261 | 1725261 | 2021-09-16 | Winkler | Texas | 48495 | 969 | 26 |
1711065 | 1711065 | 2021-09-12 | Valley | Montana | 30105 | 969 | 18 |
1707818 | 1707818 | 2021-09-11 | Valley | Montana | 30105 | 969 | 18 |
1709068 | 1709068 | 2021-09-11 | Orange | Vermont | 50017 | 969 | 4 |
1704444 | 1704444 | 2021-09-10 | Hickory | Missouri | 29085 | 969 | 17 |
1704571 | 1704571 | 2021-09-10 | Valley | Montana | 30105 | 969 | 18 |
1701990 | 1701990 | 2021-09-09 | Aibonito | Puerto Rico | 72009 | 969 | |
1698741 | 1698741 | 2021-09-08 | Aibonito | Puerto Rico | 72009 | 969 | |
1698764 | 1698764 | 2021-09-08 | Florida | Puerto Rico | 72054 | 969 | |
1690441 | 1690441 | 2021-09-06 | Twiggs | Georgia | 13289 | 969 | 49 |
1687191 | 1687191 | 2021-09-05 | Twiggs | Georgia | 13289 | 969 | 49 |
1683941 | 1683941 | 2021-09-04 | Twiggs | Georgia | 13289 | 969 | 49 |
1680690 | 1680690 | 2021-09-03 | Twiggs | Georgia | 13289 | 969 | 49 |
1657583 | 1657583 | 2021-08-27 | Montgomery | Arkansas | 5097 | 969 | 34 |
1651147 | 1651147 | 2021-08-25 | Plumas | California | 6063 | 969 | 6 |
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);