ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
475 rows where cases = 1012 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 35
- Texas 33
- Oklahoma 29
- Virginia 29
- Iowa 27
- Arkansas 23
- Mississippi 22
- Georgia 20
- Missouri 19
- Kentucky 16
- Puerto Rico 15
- Florida 14
- Colorado 12
- North Dakota 11
- South Dakota 11
- Washington 10
- Illinois 9
- Tennessee 9
- Idaho 8
- South Carolina 8
- Indiana 7
- Minnesota 7
- Nebraska 7
- Ohio 7
- Wisconsin 7
- Alaska 6
- Michigan 6
- West Virginia 6
- Alabama 5
- Louisiana 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498350 | 2498350 | 2022-05-12 | LaMoure | North Dakota | 38045 | 1012 | 20 |
2495092 | 2495092 | 2022-05-11 | LaMoure | North Dakota | 38045 | 1012 | 20 |
2491834 | 2491834 | 2022-05-10 | LaMoure | North Dakota | 38045 | 1012 | 20 |
2488576 | 2488576 | 2022-05-09 | LaMoure | North Dakota | 38045 | 1012 | 20 |
2485319 | 2485319 | 2022-05-08 | LaMoure | North Dakota | 38045 | 1012 | 20 |
2482061 | 2482061 | 2022-05-07 | LaMoure | North Dakota | 38045 | 1012 | 20 |
2478803 | 2478803 | 2022-05-06 | LaMoure | North Dakota | 38045 | 1012 | 20 |
2421197 | 2421197 | 2022-04-18 | Rappahannock | Virginia | 51157 | 1012 | 10 |
2339723 | 2339723 | 2022-03-24 | Grand Isle | Vermont | 50013 | 1012 | 5 |
2223050 | 2223050 | 2022-02-17 | Aleutians East Borough | Alaska | 2013 | 1012 | 3 |
2219799 | 2219799 | 2022-02-16 | Aleutians East Borough | Alaska | 2013 | 1012 | 3 |
2216787 | 2216787 | 2022-02-15 | Washington | Colorado | 8121 | 1012 | 26 |
2213536 | 2213536 | 2022-02-14 | Washington | Colorado | 8121 | 1012 | 26 |
2205519 | 2205519 | 2022-02-11 | Sargent | North Dakota | 38081 | 1012 | 9 |
2189883 | 2189883 | 2022-02-06 | Crockett | Texas | 48105 | 1012 | 17 |
2186630 | 2186630 | 2022-02-05 | Crockett | Texas | 48105 | 1012 | 17 |
2183528 | 2183528 | 2022-02-04 | San Augustine | Texas | 48405 | 1012 | 38 |
2178084 | 2178084 | 2022-02-03 | Hardin | Illinois | 17069 | 1012 | 18 |
2179274 | 2179274 | 2022-02-03 | Hidalgo | New Mexico | 35023 | 1012 | 12 |
2174831 | 2174831 | 2022-02-02 | Hardin | Illinois | 17069 | 1012 | 18 |
2175867 | 2175867 | 2022-02-02 | Antelope | Nebraska | 31003 | 1012 | 12 |
2176572 | 2176572 | 2022-02-02 | Las Marias | Puerto Rico | 72083 | 1012 | |
2150345 | 2150345 | 2022-01-25 | Greer | Oklahoma | 40055 | 1012 | 29 |
2147093 | 2147093 | 2022-01-24 | Greer | Oklahoma | 40055 | 1012 | 29 |
2143839 | 2143839 | 2022-01-23 | Greer | Oklahoma | 40055 | 1012 | 29 |
2140584 | 2140584 | 2022-01-22 | Greer | Oklahoma | 40055 | 1012 | 29 |
2137328 | 2137328 | 2022-01-21 | Greer | Oklahoma | 40055 | 1012 | 29 |
2134074 | 2134074 | 2022-01-20 | Greer | Oklahoma | 40055 | 1012 | 29 |
2130822 | 2130822 | 2022-01-19 | Greer | Oklahoma | 40055 | 1012 | 29 |
2124918 | 2124918 | 2022-01-17 | Martin | Texas | 48317 | 1012 | 24 |
2111911 | 2111911 | 2022-01-13 | Martin | Texas | 48317 | 1012 | 24 |
2105405 | 2105405 | 2022-01-11 | Lynn | Texas | 48305 | 1012 | 29 |
2099649 | 2099649 | 2022-01-10 | Huerfano | Colorado | 8055 | 1012 | 27 |
2092406 | 2092406 | 2022-01-07 | McCulloch | Texas | 48307 | 1012 | 40 |
2085166 | 2085166 | 2022-01-05 | Sioux | North Dakota | 38085 | 1012 | 18 |
2077158 | 2077158 | 2022-01-03 | Wheeler | Georgia | 13309 | 1012 | 36 |
2073907 | 2073907 | 2022-01-02 | Wheeler | Georgia | 13309 | 1012 | 36 |
2070656 | 2070656 | 2022-01-01 | Wheeler | Georgia | 13309 | 1012 | 36 |
2067405 | 2067405 | 2021-12-31 | Wheeler | Georgia | 13309 | 1012 | 36 |
2064096 | 2064096 | 2021-12-30 | Marion | Georgia | 13197 | 1012 | 41 |
2062025 | 2062025 | 2021-12-29 | Toole | Montana | 30101 | 1012 | 21 |
2058729 | 2058729 | 2021-12-28 | Broadwater | Montana | 30007 | 1012 | 17 |
2055480 | 2055480 | 2021-12-27 | Broadwater | Montana | 30007 | 1012 | 17 |
2040114 | 2040114 | 2021-12-22 | Kingsbury | South Dakota | 46077 | 1012 | 20 |
2030223 | 2030223 | 2021-12-19 | Florida | Puerto Rico | 72054 | 1012 | |
2030333 | 2030333 | 2021-12-19 | Brule | South Dakota | 46015 | 1012 | 15 |
2030755 | 2030755 | 2021-12-19 | Kane | Utah | 49025 | 1012 | 12 |
2026972 | 2026972 | 2021-12-18 | Florida | Puerto Rico | 72054 | 1012 | |
2027082 | 2027082 | 2021-12-18 | Brule | South Dakota | 46015 | 1012 | 15 |
2027504 | 2027504 | 2021-12-18 | Kane | Utah | 49025 | 1012 | 12 |
2023831 | 2023831 | 2021-12-17 | Brule | South Dakota | 46015 | 1012 | 15 |
2024253 | 2024253 | 2021-12-17 | Kane | Utah | 49025 | 1012 | 12 |
1989735 | 1989735 | 2021-12-07 | Taylor | Iowa | 19173 | 1012 | 14 |
1989843 | 1989843 | 2021-12-07 | Stevens | Kansas | 20189 | 1012 | 15 |
1986485 | 1986485 | 2021-12-06 | Taylor | Iowa | 19173 | 1012 | 14 |
1986593 | 1986593 | 2021-12-06 | Stevens | Kansas | 20189 | 1012 | 15 |
1983235 | 1983235 | 2021-12-05 | Taylor | Iowa | 19173 | 1012 | 14 |
1979985 | 1979985 | 2021-12-04 | Taylor | Iowa | 19173 | 1012 | 14 |
1976735 | 1976735 | 2021-12-03 | Taylor | Iowa | 19173 | 1012 | 14 |
1973486 | 1973486 | 2021-12-02 | Taylor | Iowa | 19173 | 1012 | 14 |
1975109 | 1975109 | 2021-12-02 | McCook | South Dakota | 46087 | 1012 | 27 |
1970236 | 1970236 | 2021-12-01 | Taylor | Iowa | 19173 | 1012 | 14 |
1971383 | 1971383 | 2021-12-01 | McHenry | North Dakota | 38049 | 1012 | 27 |
1960535 | 1960535 | 2021-11-28 | Harper | Kansas | 20077 | 1012 | 24 |
1957284 | 1957284 | 2021-11-27 | Harper | Kansas | 20077 | 1012 | 24 |
1954033 | 1954033 | 2021-11-26 | Harper | Kansas | 20077 | 1012 | 24 |
1950782 | 1950782 | 2021-11-25 | Harper | Kansas | 20077 | 1012 | 24 |
1947531 | 1947531 | 2021-11-24 | Harper | Kansas | 20077 | 1012 | 24 |
1928080 | 1928080 | 2021-11-18 | Sherman | Kansas | 20181 | 1012 | 13 |
1924830 | 1924830 | 2021-11-17 | Sherman | Kansas | 20181 | 1012 | 13 |
1922278 | 1922278 | 2021-11-16 | Cedar | Nebraska | 31027 | 1012 | 11 |
1896116 | 1896116 | 2021-11-08 | Clark | Missouri | 29045 | 1012 | 12 |
1881026 | 1881026 | 2021-11-03 | Crosby | Texas | 48107 | 1012 | 37 |
1875671 | 1875671 | 2021-11-02 | Caribou | Idaho | 16029 | 1012 | 19 |
1877777 | 1877777 | 2021-11-02 | Crosby | Texas | 48107 | 1012 | 37 |
1859110 | 1859110 | 2021-10-28 | Conejos | Colorado | 8021 | 1012 | 34 |
1833138 | 1833138 | 2021-10-20 | Lake | Colorado | 8065 | 1012 | 1 |
1834552 | 1834552 | 2021-10-20 | Dawes | Nebraska | 31045 | 1012 | 21 |
1831303 | 1831303 | 2021-10-19 | Dawes | Nebraska | 31045 | 1012 | 21 |
1811645 | 1811645 | 2021-10-13 | Daviess | Missouri | 29061 | 1012 | 14 |
1811874 | 1811874 | 2021-10-13 | Thurston | Nebraska | 31173 | 1012 | 12 |
1809943 | 1809943 | 2021-10-12 | Jefferson | Washington | 53031 | 1012 | 16 |
1806694 | 1806694 | 2021-10-11 | Jefferson | Washington | 53031 | 1012 | 16 |
1800264 | 1800264 | 2021-10-09 | Tucker | West Virginia | 54093 | 1012 | 19 |
1792345 | 1792345 | 2021-10-07 | Knox | Nebraska | 31107 | 1012 | 13 |
1765640 | 1765640 | 2021-09-29 | Bracken | Kentucky | 21023 | 1012 | 8 |
1761123 | 1761123 | 2021-09-27 | Lancaster | Virginia | 51103 | 1012 | 20 |
1747544 | 1747544 | 2021-09-23 | Villalba | Puerto Rico | 72149 | 1012 | |
1744294 | 1744294 | 2021-09-22 | Villalba | Puerto Rico | 72149 | 1012 | |
1741045 | 1741045 | 2021-09-21 | Villalba | Puerto Rico | 72149 | 1012 | |
1737796 | 1737796 | 2021-09-20 | Villalba | Puerto Rico | 72149 | 1012 | |
1734546 | 1734546 | 2021-09-19 | Villalba | Puerto Rico | 72149 | 1012 | |
1728284 | 1728284 | 2021-09-17 | Brewster | Texas | 48043 | 1012 | 19 |
1722476 | 1722476 | 2021-09-16 | Sitka City and Borough | Alaska | 2220 | 1012 | 2 |
1722995 | 1722995 | 2021-09-16 | Brown | Illinois | 17009 | 1012 | 14 |
1719746 | 1719746 | 2021-09-15 | Brown | Illinois | 17009 | 1012 | 13 |
1710800 | 1710800 | 2021-09-12 | Stevens | Minnesota | 27149 | 1012 | 11 |
1712479 | 1712479 | 2021-09-12 | Lincoln | Washington | 53043 | 1012 | 14 |
1707553 | 1707553 | 2021-09-11 | Stevens | Minnesota | 27149 | 1012 | 11 |
1709232 | 1709232 | 2021-09-11 | Lincoln | Washington | 53043 | 1012 | 14 |
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);