ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
499 rows where cases = 749 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 64
- Georgia 38
- Virginia 22
- Kentucky 21
- North Carolina 21
- Nebraska 19
- Illinois 18
- Iowa 18
- Kansas 18
- Michigan 17
- Virgin Islands 17
- Missouri 15
- South Dakota 14
- Alabama 13
- Puerto Rico 13
- Tennessee 13
- West Virginia 12
- Arkansas 11
- Montana 11
- Colorado 8
- Idaho 8
- Mississippi 8
- North Dakota 8
- Oklahoma 8
- Indiana 7
- Minnesota 7
- Louisiana 6
- Oregon 6
- Florida 5
- New Mexico 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501263 | 2501263 | 2022-05-13 | Chase | Nebraska | 31029 | 749 | 7 |
2472017 | 2472017 | 2022-05-04 | Valley | Nebraska | 31175 | 749 | 6 |
2269493 | 2269493 | 2022-03-03 | Trego | Kansas | 20195 | 749 | 9 |
2266240 | 2266240 | 2022-03-02 | Trego | Kansas | 20195 | 749 | 9 |
2262989 | 2262989 | 2022-03-01 | Trego | Kansas | 20195 | 749 | 9 |
2259738 | 2259738 | 2022-02-28 | Trego | Kansas | 20195 | 749 | 9 |
2256487 | 2256487 | 2022-02-27 | Trego | Kansas | 20195 | 749 | 9 |
2253236 | 2253236 | 2022-02-26 | Trego | Kansas | 20195 | 749 | 9 |
2249985 | 2249985 | 2022-02-25 | Trego | Kansas | 20195 | 749 | 9 |
2245416 | 2245416 | 2022-02-23 | St. John | Virgin Islands | 78020 | 749 | 5 |
2242165 | 2242165 | 2022-02-22 | St. John | Virgin Islands | 78020 | 749 | 5 |
2238914 | 2238914 | 2022-02-21 | St. John | Virgin Islands | 78020 | 749 | 5 |
2235663 | 2235663 | 2022-02-20 | St. John | Virgin Islands | 78020 | 749 | 5 |
2232412 | 2232412 | 2022-02-19 | St. John | Virgin Islands | 78020 | 749 | 5 |
2228253 | 2228253 | 2022-02-18 | Eddy | North Dakota | 38027 | 749 | 6 |
2229161 | 2229161 | 2022-02-18 | St. John | Virgin Islands | 78020 | 749 | 5 |
2225002 | 2225002 | 2022-02-17 | Eddy | North Dakota | 38027 | 749 | 6 |
2225910 | 2225910 | 2022-02-17 | St. John | Virgin Islands | 78020 | 749 | 5 |
2222659 | 2222659 | 2022-02-16 | St. John | Virgin Islands | 78020 | 749 | 5 |
2219408 | 2219408 | 2022-02-15 | St. John | Virgin Islands | 78020 | 749 | 5 |
2216157 | 2216157 | 2022-02-14 | St. John | Virgin Islands | 78020 | 749 | 5 |
2212906 | 2212906 | 2022-02-13 | St. John | Virgin Islands | 78020 | 749 | 5 |
2209653 | 2209653 | 2022-02-12 | St. John | Virgin Islands | 78020 | 749 | 5 |
2206400 | 2206400 | 2022-02-11 | St. John | Virgin Islands | 78020 | 749 | 5 |
2203147 | 2203147 | 2022-02-10 | St. John | Virgin Islands | 78020 | 749 | 5 |
2199893 | 2199893 | 2022-02-09 | St. John | Virgin Islands | 78020 | 749 | 5 |
2195374 | 2195374 | 2022-02-08 | Sweet Grass | Montana | 30097 | 749 | 8 |
2196639 | 2196639 | 2022-02-08 | St. John | Virgin Islands | 78020 | 749 | 5 |
2192965 | 2192965 | 2022-02-07 | Marshall | South Dakota | 46091 | 749 | 11 |
2189669 | 2189669 | 2022-02-06 | Aurora | South Dakota | 46003 | 749 | 17 |
2186416 | 2186416 | 2022-02-05 | Aurora | South Dakota | 46003 | 749 | 17 |
2183164 | 2183164 | 2022-02-04 | Aurora | South Dakota | 46003 | 749 | 17 |
2175928 | 2175928 | 2022-02-02 | Nance | Nebraska | 31125 | 749 | 10 |
2176211 | 2176211 | 2022-02-02 | Cavalier | North Dakota | 38019 | 749 | 7 |
2171870 | 2171870 | 2022-02-01 | Gove | Kansas | 20063 | 749 | 23 |
2171942 | 2171942 | 2022-02-01 | Woodson | Kansas | 20207 | 749 | 12 |
2172958 | 2172958 | 2022-02-01 | Cavalier | North Dakota | 38019 | 749 | 7 |
2173725 | 2173725 | 2022-02-01 | Mason | Texas | 48319 | 749 | 9 |
2168617 | 2168617 | 2022-01-31 | Gove | Kansas | 20063 | 749 | 23 |
2168689 | 2168689 | 2022-01-31 | Woodson | Kansas | 20207 | 749 | 12 |
2165027 | 2165027 | 2022-01-30 | Oneida | Idaho | 16071 | 749 | 10 |
2166912 | 2166912 | 2022-01-30 | Clark | South Dakota | 46025 | 749 | 6 |
2161772 | 2161772 | 2022-01-29 | Oneida | Idaho | 16071 | 749 | 10 |
2163657 | 2163657 | 2022-01-29 | Clark | South Dakota | 46025 | 749 | 6 |
2158516 | 2158516 | 2022-01-28 | Oneida | Idaho | 16071 | 749 | 10 |
2160402 | 2160402 | 2022-01-28 | Clark | South Dakota | 46025 | 749 | 6 |
2137966 | 2137966 | 2022-01-21 | Reagan | Texas | 48383 | 749 | 11 |
2103304 | 2103304 | 2022-01-11 | Pope | Illinois | 17151 | 749 | 7 |
2097025 | 2097025 | 2022-01-09 | Barber | Kansas | 20007 | 749 | 7 |
2093773 | 2093773 | 2022-01-08 | Barber | Kansas | 20007 | 749 | 7 |
2090521 | 2090521 | 2022-01-07 | Barber | Kansas | 20007 | 749 | 7 |
2084853 | 2084853 | 2022-01-05 | Nuckolls | Nebraska | 31129 | 749 | 13 |
2085808 | 2085808 | 2022-01-05 | Donley | Texas | 48129 | 749 | 18 |
2074384 | 2074384 | 2022-01-02 | Carlisle | Kentucky | 21039 | 749 | 13 |
2071133 | 2071133 | 2022-01-01 | Carlisle | Kentucky | 21039 | 749 | 13 |
2067882 | 2067882 | 2021-12-31 | Carlisle | Kentucky | 21039 | 749 | 13 |
2064631 | 2064631 | 2021-12-30 | Carlisle | Kentucky | 21039 | 749 | 13 |
2061381 | 2061381 | 2021-12-29 | Carlisle | Kentucky | 21039 | 749 | 13 |
2059461 | 2059461 | 2021-12-28 | Ceiba | Puerto Rico | 72037 | 749 | |
2056212 | 2056212 | 2021-12-27 | Ceiba | Puerto Rico | 72037 | 749 | |
2051291 | 2051291 | 2021-12-26 | Putnam | Illinois | 17155 | 749 | 7 |
2048041 | 2048041 | 2021-12-25 | Putnam | Illinois | 17155 | 749 | 7 |
2044791 | 2044791 | 2021-12-24 | Putnam | Illinois | 17155 | 749 | 7 |
2041542 | 2041542 | 2021-12-23 | Putnam | Illinois | 17155 | 749 | 7 |
2034924 | 2034924 | 2021-12-21 | Bear Lake | Idaho | 16007 | 749 | 15 |
2031674 | 2031674 | 2021-12-20 | Bear Lake | Idaho | 16007 | 749 | 15 |
2033844 | 2033844 | 2021-12-20 | Hemphill | Texas | 48211 | 749 | 3 |
2028423 | 2028423 | 2021-12-19 | Bear Lake | Idaho | 16007 | 749 | 15 |
2030341 | 2030341 | 2021-12-19 | Corson | South Dakota | 46031 | 749 | 15 |
2030594 | 2030594 | 2021-12-19 | Hemphill | Texas | 48211 | 749 | 3 |
2025172 | 2025172 | 2021-12-18 | Bear Lake | Idaho | 16007 | 749 | 15 |
2027090 | 2027090 | 2021-12-18 | Corson | South Dakota | 46031 | 749 | 15 |
2027343 | 2027343 | 2021-12-18 | Hemphill | Texas | 48211 | 749 | 3 |
2021921 | 2021921 | 2021-12-17 | Bear Lake | Idaho | 16007 | 749 | 15 |
2023839 | 2023839 | 2021-12-17 | Corson | South Dakota | 46031 | 749 | 15 |
2021077 | 2021077 | 2021-12-16 | Falls Church city | Virginia | 51610 | 749 | 14 |
2005626 | 2005626 | 2021-12-12 | Talbot | Georgia | 13263 | 749 | 29 |
2002375 | 2002375 | 2021-12-11 | Talbot | Georgia | 13263 | 749 | 29 |
1999125 | 1999125 | 2021-12-10 | Talbot | Georgia | 13263 | 749 | 29 |
1995874 | 1995874 | 2021-12-09 | Talbot | Georgia | 13263 | 749 | 29 |
1993822 | 1993822 | 2021-12-08 | Johnson | Nebraska | 31097 | 749 | 10 |
1987247 | 1987247 | 2021-12-06 | Mineral | Montana | 30061 | 749 | 14 |
1983997 | 1983997 | 2021-12-05 | Mineral | Montana | 30061 | 749 | 14 |
1980747 | 1980747 | 2021-12-04 | Mineral | Montana | 30061 | 749 | 14 |
1977497 | 1977497 | 2021-12-03 | Mineral | Montana | 30061 | 749 | 14 |
1977880 | 1977880 | 2021-12-03 | LaMoure | North Dakota | 38045 | 749 | 17 |
1978562 | 1978562 | 2021-12-03 | Garza | Texas | 48169 | 749 | 23 |
1974247 | 1974247 | 2021-12-02 | Mineral | Montana | 30061 | 749 | 14 |
1974302 | 1974302 | 2021-12-02 | Fillmore | Nebraska | 31059 | 749 | 13 |
1975312 | 1975312 | 2021-12-02 | Garza | Texas | 48169 | 749 | 23 |
1975551 | 1975551 | 2021-12-02 | Charles City | Virginia | 51036 | 749 | 21 |
1971835 | 1971835 | 2021-12-01 | Deuel | South Dakota | 46039 | 749 | 11 |
1972267 | 1972267 | 2021-12-01 | Essex | Vermont | 50009 | 749 | 2 |
1966409 | 1966409 | 2021-11-30 | Washington | Colorado | 8121 | 749 | 24 |
1967059 | 1967059 | 2021-11-30 | Meade | Kansas | 20119 | 749 | 14 |
1963807 | 1963807 | 2021-11-29 | Meade | Kansas | 20119 | 749 | 14 |
1926332 | 1926332 | 2021-11-17 | Gregory | South Dakota | 46053 | 749 | 30 |
1902768 | 1902768 | 2021-11-10 | Antelope | Nebraska | 31003 | 749 | 10 |
1881691 | 1881691 | 2021-11-04 | Yukon-Koyukuk Census Area | Alaska | 2290 | 749 | 5 |
1884562 | 1884562 | 2021-11-04 | Fairfax city | Virginia | 51600 | 749 | 26 |
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);