ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
464 rows where cases = 997 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 46
- Iowa 28
- Georgia 23
- Kentucky 23
- Missouri 23
- Puerto Rico 23
- Arkansas 20
- Virginia 17
- Colorado 16
- Nebraska 14
- Alabama 11
- Kansas 11
- Mississippi 11
- New Mexico 11
- Idaho 10
- Minnesota 10
- Wisconsin 10
- Illinois 9
- Indiana 9
- Oklahoma 9
- Tennessee 9
- Utah 9
- West Virginia 9
- North Carolina 8
- Ohio 8
- California 7
- South Carolina 7
- Louisiana 6
- New York 6
- South Dakota 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499138 | 2499138 | 2022-05-12 | Presidio | Texas | 48377 | 997 | 38 |
2495880 | 2495880 | 2022-05-11 | Presidio | Texas | 48377 | 997 | 38 |
2492622 | 2492622 | 2022-05-10 | Presidio | Texas | 48377 | 997 | 38 |
2489364 | 2489364 | 2022-05-09 | Presidio | Texas | 48377 | 997 | 38 |
2486106 | 2486106 | 2022-05-08 | Presidio | Texas | 48377 | 997 | 38 |
2482848 | 2482848 | 2022-05-07 | Presidio | Texas | 48377 | 997 | 38 |
2479590 | 2479590 | 2022-05-06 | Presidio | Texas | 48377 | 997 | 38 |
2428139 | 2428139 | 2022-04-21 | Modoc | California | 6049 | 997 | 8 |
2424883 | 2424883 | 2022-04-20 | Modoc | California | 6049 | 997 | 8 |
2421627 | 2421627 | 2022-04-19 | Modoc | California | 6049 | 997 | 8 |
2338210 | 2338210 | 2022-03-24 | Unknown | Minnesota | 997 | 220 | |
2319035 | 2319035 | 2022-03-18 | Sheridan | Nebraska | 31161 | 997 | 23 |
2315782 | 2315782 | 2022-03-17 | Sheridan | Nebraska | 31161 | 997 | 23 |
2312529 | 2312529 | 2022-03-16 | Sheridan | Nebraska | 31161 | 997 | 23 |
2287679 | 2287679 | 2022-03-08 | Grand Isle | Vermont | 50013 | 997 | 5 |
2284427 | 2284427 | 2022-03-07 | Grand Isle | Vermont | 50013 | 997 | 5 |
2280103 | 2280103 | 2022-03-06 | Union | New Mexico | 35059 | 997 | 14 |
2281215 | 2281215 | 2022-03-06 | Covington city | Virginia | 51580 | 997 | 24 |
2276850 | 2276850 | 2022-03-05 | Union | New Mexico | 35059 | 997 | 14 |
2277962 | 2277962 | 2022-03-05 | Covington city | Virginia | 51580 | 997 | 24 |
2273597 | 2273597 | 2022-03-04 | Union | New Mexico | 35059 | 997 | 14 |
2274709 | 2274709 | 2022-03-04 | Covington city | Virginia | 51580 | 997 | 24 |
2200285 | 2200285 | 2022-02-10 | Aleutians East Borough | Alaska | 2013 | 997 | 3 |
2197031 | 2197031 | 2022-02-09 | Aleutians East Borough | Alaska | 2013 | 997 | 3 |
2194276 | 2194276 | 2022-02-08 | Boise | Idaho | 16015 | 997 | 13 |
2170364 | 2170364 | 2022-01-31 | Concho | Texas | 48095 | 997 | 10 |
2166106 | 2166106 | 2022-01-30 | Antelope | Nebraska | 31003 | 997 | 12 |
2162851 | 2162851 | 2022-01-29 | Antelope | Nebraska | 31003 | 997 | 12 |
2163504 | 2163504 | 2022-01-29 | Sullivan | Pennsylvania | 42113 | 997 | 32 |
2163860 | 2163860 | 2022-01-29 | Crockett | Texas | 48105 | 997 | 17 |
2159596 | 2159596 | 2022-01-28 | Antelope | Nebraska | 31003 | 997 | 12 |
2159965 | 2159965 | 2022-01-28 | Pierce | North Dakota | 38069 | 997 | 30 |
2160574 | 2160574 | 2022-01-28 | Brewster | Texas | 48043 | 997 | 25 |
2148705 | 2148705 | 2022-01-25 | Warren | Georgia | 13301 | 997 | 26 |
2147931 | 2147931 | 2022-01-24 | Norton city | Virginia | 51720 | 997 | 20 |
2118310 | 2118310 | 2022-01-15 | Crane | Texas | 48103 | 997 | 19 |
2103585 | 2103585 | 2022-01-11 | Mitchell | Kansas | 20123 | 997 | 17 |
2100334 | 2100334 | 2022-01-10 | Mitchell | Kansas | 20123 | 997 | 17 |
2082651 | 2082651 | 2022-01-04 | McCulloch | Texas | 48307 | 997 | 40 |
2079441 | 2079441 | 2022-01-03 | Sabine | Texas | 48403 | 997 | 78 |
2051301 | 2051301 | 2021-12-26 | Stark | Illinois | 17175 | 997 | 29 |
2048051 | 2048051 | 2021-12-25 | Stark | Illinois | 17175 | 997 | 29 |
2044801 | 2044801 | 2021-12-24 | Stark | Illinois | 17175 | 997 | 29 |
2041552 | 2041552 | 2021-12-23 | Stark | Illinois | 17175 | 997 | 29 |
2039443 | 2039443 | 2021-12-22 | Los Alamos | New Mexico | 35028 | 997 | 10 |
1973594 | 1973594 | 2021-12-02 | Stevens | Kansas | 20189 | 997 | 15 |
1970344 | 1970344 | 2021-12-01 | Stevens | Kansas | 20189 | 997 | 15 |
1963090 | 1963090 | 2021-11-29 | Trinity | California | 6105 | 997 | 17 |
1966047 | 1966047 | 2021-11-29 | Menominee | Wisconsin | 55078 | 997 | 11 |
1962795 | 1962795 | 2021-11-28 | Menominee | Wisconsin | 55078 | 997 | 11 |
1959544 | 1959544 | 2021-11-27 | Menominee | Wisconsin | 55078 | 997 | 11 |
1956293 | 1956293 | 2021-11-26 | Menominee | Wisconsin | 55078 | 997 | 11 |
1953042 | 1953042 | 2021-11-25 | Menominee | Wisconsin | 55078 | 997 | 11 |
1949791 | 1949791 | 2021-11-24 | Menominee | Wisconsin | 55078 | 997 | 11 |
1938588 | 1938588 | 2021-11-21 | Richardson | Nebraska | 31147 | 997 | 24 |
1935338 | 1935338 | 2021-11-20 | Richardson | Nebraska | 31147 | 997 | 24 |
1932088 | 1932088 | 2021-11-19 | Richardson | Nebraska | 31147 | 997 | 24 |
1933175 | 1933175 | 2021-11-19 | San Saba | Texas | 48411 | 997 | 28 |
1929924 | 1929924 | 2021-11-18 | San Saba | Texas | 48411 | 997 | 28 |
1898714 | 1898714 | 2021-11-09 | Osceola | Iowa | 19143 | 997 | 17 |
1895464 | 1895464 | 2021-11-08 | Osceola | Iowa | 19143 | 997 | 17 |
1892214 | 1892214 | 2021-11-07 | Osceola | Iowa | 19143 | 997 | 17 |
1888964 | 1888964 | 2021-11-06 | Osceola | Iowa | 19143 | 997 | 17 |
1885714 | 1885714 | 2021-11-05 | Osceola | Iowa | 19143 | 997 | 17 |
1882465 | 1882465 | 2021-11-04 | Osceola | Iowa | 19143 | 997 | 17 |
1879216 | 1879216 | 2021-11-03 | Osceola | Iowa | 19143 | 997 | 17 |
1861213 | 1861213 | 2021-10-28 | Florida | Puerto Rico | 72054 | 997 | |
1861684 | 1861684 | 2021-10-28 | San Saba | Texas | 48411 | 997 | 27 |
1857621 | 1857621 | 2021-10-27 | Dickey | North Dakota | 38021 | 997 | 34 |
1857964 | 1857964 | 2021-10-27 | Florida | Puerto Rico | 72054 | 997 | |
1858435 | 1858435 | 2021-10-27 | San Saba | Texas | 48411 | 997 | 27 |
1854715 | 1854715 | 2021-10-26 | Florida | Puerto Rico | 72054 | 997 | |
1851466 | 1851466 | 2021-10-25 | Florida | Puerto Rico | 72054 | 997 | |
1848216 | 1848216 | 2021-10-24 | Florida | Puerto Rico | 72054 | 997 | |
1844966 | 1844966 | 2021-10-23 | Florida | Puerto Rico | 72054 | 997 | |
1831445 | 1831445 | 2021-10-19 | Quay | New Mexico | 35037 | 997 | 21 |
1823391 | 1823391 | 2021-10-17 | Lake | Colorado | 8065 | 997 | 1 |
1820142 | 1820142 | 2021-10-16 | Lake | Colorado | 8065 | 997 | 1 |
1816893 | 1816893 | 2021-10-15 | Lake | Colorado | 8065 | 997 | 1 |
1806108 | 1806108 | 2021-10-11 | Hamlin | South Dakota | 46057 | 997 | 40 |
1806497 | 1806497 | 2021-10-11 | Beaver | Utah | 49001 | 997 | 11 |
1802858 | 1802858 | 2021-10-10 | Hamlin | South Dakota | 46057 | 997 | 40 |
1803247 | 1803247 | 2021-10-10 | Beaver | Utah | 49001 | 997 | 11 |
1799609 | 1799609 | 2021-10-09 | Hamlin | South Dakota | 46057 | 997 | 40 |
1799998 | 1799998 | 2021-10-09 | Beaver | Utah | 49001 | 997 | 11 |
1796360 | 1796360 | 2021-10-08 | Hamlin | South Dakota | 46057 | 997 | 40 |
1796749 | 1796749 | 2021-10-08 | Beaver | Utah | 49001 | 997 | 11 |
1793696 | 1793696 | 2021-10-07 | Jefferson | Washington | 53031 | 997 | 15 |
1782393 | 1782393 | 2021-10-04 | Chariton | Missouri | 29041 | 997 | 8 |
1778990 | 1778990 | 2021-10-03 | Lake | Minnesota | 27075 | 997 | 21 |
1779143 | 1779143 | 2021-10-03 | Chariton | Missouri | 29041 | 997 | 8 |
1779242 | 1779242 | 2021-10-03 | Blaine | Montana | 30005 | 997 | 24 |
1775740 | 1775740 | 2021-10-02 | Lake | Minnesota | 27075 | 997 | 21 |
1775992 | 1775992 | 2021-10-02 | Blaine | Montana | 30005 | 997 | 24 |
1772490 | 1772490 | 2021-10-01 | Lake | Minnesota | 27075 | 997 | 21 |
1772742 | 1772742 | 2021-10-01 | Blaine | Montana | 30005 | 997 | 24 |
1768561 | 1768561 | 2021-09-30 | Schuyler | Illinois | 17169 | 997 | 22 |
1756563 | 1756563 | 2021-09-26 | Butler | Nebraska | 31023 | 997 | 12 |
1753315 | 1753315 | 2021-09-25 | Butler | Nebraska | 31023 | 997 | 12 |
1750067 | 1750067 | 2021-09-24 | Butler | Nebraska | 31023 | 997 | 12 |
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);