ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
429 rows where cases = 1020 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 59
- Missouri 27
- South Dakota 23
- Kentucky 22
- Minnesota 18
- Georgia 16
- Kansas 16
- Puerto Rico 16
- Colorado 14
- Alabama 13
- Iowa 13
- Tennessee 12
- West Virginia 12
- Illinois 11
- Virginia 11
- Oklahoma 10
- Louisiana 9
- North Carolina 9
- North Dakota 9
- Michigan 8
- Mississippi 8
- Montana 8
- South Carolina 8
- Idaho 7
- Wisconsin 7
- New York 6
- Wyoming 6
- Arkansas 5
- Nebraska 5
- Ohio 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2362500 | 2362500 | 2022-03-31 | Unknown | Vermont | 1020 | 2 | |
2336231 | 2336231 | 2022-03-23 | Crockett | Texas | 48105 | 1020 | 19 |
2332977 | 2332977 | 2022-03-22 | Crockett | Texas | 48105 | 1020 | 19 |
2329724 | 2329724 | 2022-03-21 | Crockett | Texas | 48105 | 1020 | 19 |
2326472 | 2326472 | 2022-03-20 | Crockett | Texas | 48105 | 1020 | 19 |
2323219 | 2323219 | 2022-03-19 | Crockett | Texas | 48105 | 1020 | 19 |
2319965 | 2319965 | 2022-03-18 | Crockett | Texas | 48105 | 1020 | 19 |
2316711 | 2316711 | 2022-03-17 | Crockett | Texas | 48105 | 1020 | 19 |
2313458 | 2313458 | 2022-03-16 | Crockett | Texas | 48105 | 1020 | 19 |
2310205 | 2310205 | 2022-03-15 | Crockett | Texas | 48105 | 1020 | 19 |
2306952 | 2306952 | 2022-03-14 | Crockett | Texas | 48105 | 1020 | 19 |
2303701 | 2303701 | 2022-03-13 | Crockett | Texas | 48105 | 1020 | 19 |
2300449 | 2300449 | 2022-03-12 | Crockett | Texas | 48105 | 1020 | 19 |
2297197 | 2297197 | 2022-03-11 | Crockett | Texas | 48105 | 1020 | 19 |
2293945 | 2293945 | 2022-03-10 | Crockett | Texas | 48105 | 1020 | 19 |
2290693 | 2290693 | 2022-03-09 | Crockett | Texas | 48105 | 1020 | 19 |
2287441 | 2287441 | 2022-03-08 | Crockett | Texas | 48105 | 1020 | 19 |
2284189 | 2284189 | 2022-03-07 | Crockett | Texas | 48105 | 1020 | 19 |
2280937 | 2280937 | 2022-03-06 | Crockett | Texas | 48105 | 1020 | 19 |
2277684 | 2277684 | 2022-03-05 | Crockett | Texas | 48105 | 1020 | 19 |
2274431 | 2274431 | 2022-03-04 | Crockett | Texas | 48105 | 1020 | 19 |
2271178 | 2271178 | 2022-03-03 | Crockett | Texas | 48105 | 1020 | 19 |
2267926 | 2267926 | 2022-03-02 | Crockett | Texas | 48105 | 1020 | 19 |
2264673 | 2264673 | 2022-03-01 | Crockett | Texas | 48105 | 1020 | 19 |
2261423 | 2261423 | 2022-02-28 | Crockett | Texas | 48105 | 1020 | 19 |
2258172 | 2258172 | 2022-02-27 | Crockett | Texas | 48105 | 1020 | 19 |
2254921 | 2254921 | 2022-02-26 | Crockett | Texas | 48105 | 1020 | 19 |
2251670 | 2251670 | 2022-02-25 | Crockett | Texas | 48105 | 1020 | 19 |
2247102 | 2247102 | 2022-02-24 | Kittson | Minnesota | 27069 | 1020 | 26 |
2245163 | 2245163 | 2022-02-23 | Concho | Texas | 48095 | 1020 | 11 |
2241912 | 2241912 | 2022-02-22 | Concho | Texas | 48095 | 1020 | 11 |
2233042 | 2233042 | 2022-02-20 | Washington | Colorado | 8121 | 1020 | 26 |
2229791 | 2229791 | 2022-02-19 | Washington | Colorado | 8121 | 1020 | 26 |
2226540 | 2226540 | 2022-02-18 | Washington | Colorado | 8121 | 1020 | 26 |
2228280 | 2228280 | 2022-02-18 | Sargent | North Dakota | 38081 | 1020 | 9 |
2212462 | 2212462 | 2022-02-13 | Deuel | South Dakota | 46039 | 1020 | 12 |
2209209 | 2209209 | 2022-02-12 | Deuel | South Dakota | 46039 | 1020 | 12 |
2205956 | 2205956 | 2022-02-11 | Deuel | South Dakota | 46039 | 1020 | 12 |
2202868 | 2202868 | 2022-02-10 | Brewster | Texas | 48043 | 1020 | 25 |
2186327 | 2186327 | 2022-02-05 | Las Marias | Puerto Rico | 72083 | 1020 | |
2173820 | 2173820 | 2022-02-01 | Yoakum | Texas | 48501 | 1020 | 37 |
2166189 | 2166189 | 2022-01-30 | Thayer | Nebraska | 31169 | 1020 | 8 |
2166926 | 2166926 | 2022-01-30 | Gregory | South Dakota | 46053 | 1020 | 33 |
2162934 | 2162934 | 2022-01-29 | Thayer | Nebraska | 31169 | 1020 | 8 |
2163671 | 2163671 | 2022-01-29 | Gregory | South Dakota | 46053 | 1020 | 33 |
2159679 | 2159679 | 2022-01-28 | Thayer | Nebraska | 31169 | 1020 | 8 |
2160416 | 2160416 | 2022-01-28 | Gregory | South Dakota | 46053 | 1020 | 33 |
2147175 | 2147175 | 2022-01-24 | Wallowa | Oregon | 41063 | 1020 | 13 |
2142337 | 2142337 | 2022-01-23 | Putnam | Illinois | 17155 | 1020 | 8 |
2139082 | 2139082 | 2022-01-22 | Putnam | Illinois | 17155 | 1020 | 8 |
2135826 | 2135826 | 2022-01-21 | Putnam | Illinois | 17155 | 1020 | 8 |
2128350 | 2128350 | 2022-01-18 | Cumberland | Virginia | 51049 | 1020 | 19 |
2123856 | 2123856 | 2022-01-17 | Kearney | Nebraska | 31099 | 1020 | 7 |
2108606 | 2108606 | 2022-01-12 | Hartley | Texas | 48205 | 1020 | 3 |
2095658 | 2095658 | 2022-01-08 | McCulloch | Texas | 48307 | 1020 | 40 |
2086442 | 2086442 | 2022-01-06 | Dillingham Census Area | Alaska | 2070 | 1020 | 10 |
2088418 | 2088418 | 2022-01-06 | Sioux | North Dakota | 38085 | 1020 | 18 |
2078279 | 2078279 | 2022-01-03 | Toole | Montana | 30101 | 1020 | 21 |
2079415 | 2079415 | 2022-01-03 | Newton | Texas | 48351 | 1020 | 54 |
2057093 | 2057093 | 2021-12-27 | Crook | Wyoming | 56011 | 1020 | 22 |
2053844 | 2053844 | 2021-12-26 | Crook | Wyoming | 56011 | 1020 | 22 |
2050594 | 2050594 | 2021-12-25 | Crook | Wyoming | 56011 | 1020 | 22 |
2047344 | 2047344 | 2021-12-24 | Crook | Wyoming | 56011 | 1020 | 22 |
2044094 | 2044094 | 2021-12-23 | Crook | Wyoming | 56011 | 1020 | 22 |
2033583 | 2033583 | 2021-12-20 | Brule | South Dakota | 46015 | 1020 | 15 |
2015943 | 2015943 | 2021-12-15 | Menifee | Kentucky | 21165 | 1020 | 25 |
2014789 | 2014789 | 2021-12-14 | Iron | Wisconsin | 55051 | 1020 | 43 |
1984382 | 1984382 | 2021-12-05 | McHenry | North Dakota | 38049 | 1020 | 27 |
1962234 | 1962234 | 2021-11-28 | Bailey | Texas | 48017 | 1020 | 28 |
1958983 | 1958983 | 2021-11-27 | Bailey | Texas | 48017 | 1020 | 28 |
1955732 | 1955732 | 2021-11-26 | Bailey | Texas | 48017 | 1020 | 28 |
1952481 | 1952481 | 2021-11-25 | Bailey | Texas | 48017 | 1020 | 28 |
1949230 | 1949230 | 2021-11-24 | Bailey | Texas | 48017 | 1020 | 28 |
1945979 | 1945979 | 2021-11-23 | Bailey | Texas | 48017 | 1020 | 28 |
1928777 | 1928777 | 2021-11-18 | Cedar | Nebraska | 31027 | 1020 | 11 |
1925213 | 1925213 | 2021-11-17 | Mahnomen | Minnesota | 27087 | 1020 | 13 |
1923559 | 1923559 | 2021-11-16 | Fairfax city | Virginia | 51600 | 1020 | 35 |
1915689 | 1915689 | 2021-11-14 | Shannon | Missouri | 29203 | 1020 | 19 |
1912439 | 1912439 | 2021-11-13 | Shannon | Missouri | 29203 | 1020 | 19 |
1905656 | 1905656 | 2021-11-11 | Oscoda | Michigan | 26135 | 1020 | 40 |
1902407 | 1902407 | 2021-11-10 | Oscoda | Michigan | 26135 | 1020 | 40 |
1899132 | 1899132 | 2021-11-09 | Lake | Michigan | 26085 | 1020 | 22 |
1895168 | 1895168 | 2021-11-08 | Caribou | Idaho | 16029 | 1020 | 20 |
1895882 | 1895882 | 2021-11-08 | Lake | Michigan | 26085 | 1020 | 22 |
1897598 | 1897598 | 2021-11-08 | Madison | Virginia | 51113 | 1020 | 21 |
1890112 | 1890112 | 2021-11-06 | Dickey | North Dakota | 38021 | 1020 | 34 |
1884005 | 1884005 | 2021-11-04 | Villalba | Puerto Rico | 72149 | 1020 | |
1880756 | 1880756 | 2021-11-03 | Villalba | Puerto Rico | 72149 | 1020 | |
1854191 | 1854191 | 2021-10-26 | Quay | New Mexico | 35037 | 1020 | 23 |
1854875 | 1854875 | 2021-10-26 | Spink | South Dakota | 46115 | 1020 | 27 |
1851626 | 1851626 | 2021-10-25 | Spink | South Dakota | 46115 | 1020 | 27 |
1848347 | 1848347 | 2021-10-24 | Hamlin | South Dakota | 46057 | 1020 | 40 |
1845097 | 1845097 | 2021-10-23 | Hamlin | South Dakota | 46057 | 1020 | 40 |
1841847 | 1841847 | 2021-10-22 | Hamlin | South Dakota | 46057 | 1020 | 40 |
1838598 | 1838598 | 2021-10-21 | Hamlin | South Dakota | 46057 | 1020 | 40 |
1810742 | 1810742 | 2021-10-13 | Edwards | Illinois | 17047 | 1020 | 18 |
1806764 | 1806764 | 2021-10-11 | Tucker | West Virginia | 54093 | 1020 | 20 |
1803513 | 1803513 | 2021-10-10 | Tucker | West Virginia | 54093 | 1020 | 19 |
1785489 | 1785489 | 2021-10-05 | Lake | Minnesota | 27075 | 1020 | 21 |
1786619 | 1786619 | 2021-10-05 | Hutchinson | South Dakota | 46067 | 1020 | 28 |
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);