ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
574 rows where cases = 689 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 42
- Oklahoma 32
- Georgia 30
- Montana 26
- South Dakota 24
- Virginia 24
- Kansas 22
- Nebraska 21
- Minnesota 20
- Puerto Rico 20
- Illinois 18
- Kentucky 18
- North Carolina 18
- Iowa 16
- Missouri 16
- Idaho 15
- Michigan 15
- North Dakota 14
- Tennessee 14
- Alaska 13
- Arkansas 13
- Washington 13
- West Virginia 11
- Ohio 10
- Mississippi 9
- Utah 9
- Wisconsin 9
- Indiana 8
- Louisiana 8
- South Carolina 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492642 | 2492642 | 2022-05-10 | Shackelford | Texas | 48417 | 689 | 12 |
2489384 | 2489384 | 2022-05-09 | Shackelford | Texas | 48417 | 689 | 12 |
2486126 | 2486126 | 2022-05-08 | Shackelford | Texas | 48417 | 689 | 12 |
2482868 | 2482868 | 2022-05-07 | Shackelford | Texas | 48417 | 689 | 12 |
2479610 | 2479610 | 2022-05-06 | Shackelford | Texas | 48417 | 689 | 12 |
2424181 | 2424181 | 2022-04-19 | Kimble | Texas | 48267 | 689 | 15 |
2420925 | 2420925 | 2022-04-18 | Kimble | Texas | 48267 | 689 | 15 |
2353153 | 2353153 | 2022-03-29 | Petersburg Borough | Alaska | 2195 | 689 | 3 |
2349901 | 2349901 | 2022-03-28 | Petersburg Borough | Alaska | 2195 | 689 | 3 |
2346648 | 2346648 | 2022-03-27 | Petersburg Borough | Alaska | 2195 | 689 | 3 |
2343395 | 2343395 | 2022-03-26 | Petersburg Borough | Alaska | 2195 | 689 | 3 |
2340142 | 2340142 | 2022-03-25 | Petersburg Borough | Alaska | 2195 | 689 | 3 |
2309185 | 2309185 | 2022-03-15 | Sheridan | Montana | 30091 | 689 | 11 |
2305933 | 2305933 | 2022-03-14 | Sheridan | Montana | 30091 | 689 | 11 |
2302682 | 2302682 | 2022-03-13 | Sheridan | Montana | 30091 | 689 | 11 |
2299430 | 2299430 | 2022-03-12 | Sheridan | Montana | 30091 | 689 | 11 |
2296178 | 2296178 | 2022-03-11 | Sheridan | Montana | 30091 | 689 | 11 |
2292926 | 2292926 | 2022-03-10 | Sheridan | Montana | 30091 | 689 | 11 |
2289674 | 2289674 | 2022-03-09 | Sheridan | Montana | 30091 | 689 | 11 |
2286422 | 2286422 | 2022-03-08 | Sheridan | Montana | 30091 | 689 | 11 |
2283170 | 2283170 | 2022-03-07 | Sheridan | Montana | 30091 | 689 | 11 |
2263559 | 2263559 | 2022-03-01 | Mercer | Missouri | 29129 | 689 | 12 |
2224745 | 2224745 | 2022-02-17 | Webster | Nebraska | 31181 | 689 | 10 |
2225501 | 2225501 | 2022-02-17 | Potter | South Dakota | 46107 | 689 | 7 |
2218243 | 2218243 | 2022-02-15 | Webster | Nebraska | 31181 | 689 | 9 |
2214992 | 2214992 | 2022-02-14 | Webster | Nebraska | 31181 | 689 | 9 |
2211740 | 2211740 | 2022-02-13 | Webster | Nebraska | 31181 | 689 | 9 |
2208487 | 2208487 | 2022-02-12 | Webster | Nebraska | 31181 | 689 | 9 |
2205234 | 2205234 | 2022-02-11 | Webster | Nebraska | 31181 | 689 | 9 |
2198557 | 2198557 | 2022-02-09 | Schuyler | Missouri | 29197 | 689 | 24 |
2198719 | 2198719 | 2022-02-09 | Stanton | Nebraska | 31167 | 689 | 11 |
2141187 | 2141187 | 2022-01-22 | Mason | Texas | 48319 | 689 | 9 |
2128328 | 2128328 | 2022-01-18 | Bath | Virginia | 51017 | 689 | 15 |
2094884 | 2094884 | 2022-01-08 | Bowman | North Dakota | 38011 | 689 | 9 |
2091632 | 2091632 | 2022-01-07 | Bowman | North Dakota | 38011 | 689 | 9 |
2058938 | 2058938 | 2021-12-28 | Hidalgo | New Mexico | 35023 | 689 | 12 |
2054183 | 2054183 | 2021-12-27 | Unknown | Delaware | 689 | 0 | |
2055689 | 2055689 | 2021-12-27 | Hidalgo | New Mexico | 35023 | 689 | 12 |
2030348 | 2030348 | 2021-12-19 | Edmunds | South Dakota | 46045 | 689 | 14 |
2027097 | 2027097 | 2021-12-18 | Edmunds | South Dakota | 46045 | 689 | 14 |
2023846 | 2023846 | 2021-12-17 | Edmunds | South Dakota | 46045 | 689 | 14 |
2020595 | 2020595 | 2021-12-16 | Edmunds | South Dakota | 46045 | 689 | 14 |
2009036 | 2009036 | 2021-12-13 | Putnam | Illinois | 17155 | 689 | 6 |
2006043 | 2006043 | 2021-12-12 | Haskell | Kansas | 20081 | 689 | 9 |
2002792 | 2002792 | 2021-12-11 | Haskell | Kansas | 20081 | 689 | 9 |
1999542 | 1999542 | 2021-12-10 | Haskell | Kansas | 20081 | 689 | 9 |
1989488 | 1989488 | 2021-12-07 | Hardin | Illinois | 17069 | 689 | 16 |
1975268 | 1975268 | 2021-12-02 | Coke | Texas | 48081 | 689 | 18 |
1971088 | 1971088 | 2021-12-01 | Nuckolls | Nebraska | 31129 | 689 | 12 |
1948642 | 1948642 | 2021-11-24 | Sargent | North Dakota | 38081 | 689 | 9 |
1942152 | 1942152 | 2021-11-22 | Wells | North Dakota | 38103 | 689 | 10 |
1938234 | 1938234 | 2021-11-21 | Red Lake | Minnesota | 27125 | 689 | 10 |
1934984 | 1934984 | 2021-11-20 | Red Lake | Minnesota | 27125 | 689 | 10 |
1931734 | 1931734 | 2021-11-19 | Red Lake | Minnesota | 27125 | 689 | 10 |
1920232 | 1920232 | 2021-11-15 | Garfield | Utah | 49017 | 689 | 12 |
1914607 | 1914607 | 2021-11-14 | Schley | Georgia | 13249 | 689 | 7 |
1916982 | 1916982 | 2021-11-14 | Garfield | Utah | 49017 | 689 | 12 |
1911357 | 1911357 | 2021-11-13 | Schley | Georgia | 13249 | 689 | 7 |
1913732 | 1913732 | 2021-11-13 | Garfield | Utah | 49017 | 689 | 12 |
1908108 | 1908108 | 2021-11-12 | Schley | Georgia | 13249 | 689 | 7 |
1910482 | 1910482 | 2021-11-12 | Garfield | Utah | 49017 | 689 | 12 |
1899346 | 1899346 | 2021-11-09 | Atchison | Missouri | 29005 | 689 | 7 |
1897074 | 1897074 | 2021-11-08 | Corson | South Dakota | 46031 | 689 | 13 |
1875405 | 1875405 | 2021-11-02 | Washington | Colorado | 8121 | 689 | 19 |
1872439 | 1872439 | 2021-11-01 | Lincoln | Idaho | 16063 | 689 | 12 |
1860476 | 1860476 | 2021-10-28 | Chouteau | Montana | 30015 | 689 | 8 |
1852450 | 1852450 | 2021-10-26 | Yukon-Koyukuk Census Area | Alaska | 2290 | 689 | 5 |
1837753 | 1837753 | 2021-10-21 | Mineral | Montana | 30061 | 689 | 11 |
1831365 | 1831365 | 2021-10-19 | Thayer | Nebraska | 31169 | 689 | 7 |
1819344 | 1819344 | 2021-10-15 | Hemphill | Texas | 48211 | 689 | 3 |
1807433 | 1807433 | 2021-10-12 | Boise | Idaho | 16015 | 689 | 8 |
1784727 | 1784727 | 2021-10-05 | Alexander | Illinois | 17003 | 689 | 11 |
1783547 | 1783547 | 2021-10-04 | Concho | Texas | 48095 | 689 | 10 |
1780298 | 1780298 | 2021-10-03 | Concho | Texas | 48095 | 689 | 10 |
1769527 | 1769527 | 2021-09-30 | Pondera | Montana | 30073 | 689 | 4 |
1765995 | 1765995 | 2021-09-29 | Lincoln | Minnesota | 27081 | 689 | 4 |
1766993 | 1766993 | 2021-09-29 | Hormigueros | Puerto Rico | 72067 | 689 | |
1761966 | 1761966 | 2021-09-28 | Lewis | Idaho | 16061 | 689 | 16 |
1763744 | 1763744 | 2021-09-28 | Hormigueros | Puerto Rico | 72067 | 689 | |
1758385 | 1758385 | 2021-09-27 | Clear Creek | Colorado | 8019 | 689 | 4 |
1760495 | 1760495 | 2021-09-27 | Hormigueros | Puerto Rico | 72067 | 689 | |
1757247 | 1757247 | 2021-09-26 | Hormigueros | Puerto Rico | 72067 | 689 | |
1753999 | 1753999 | 2021-09-25 | Hormigueros | Puerto Rico | 72067 | 689 | |
1746948 | 1746948 | 2021-09-23 | Unknown | New Jersey | 689 | 0 | |
1735975 | 1735975 | 2021-09-20 | Lemhi | Idaho | 16059 | 689 | 10 |
1732658 | 1732658 | 2021-09-19 | Talbot | Georgia | 13263 | 689 | 22 |
1732824 | 1732824 | 2021-09-19 | Scott | Illinois | 17171 | 689 | 5 |
1729408 | 1729408 | 2021-09-18 | Talbot | Georgia | 13263 | 689 | 22 |
1729574 | 1729574 | 2021-09-18 | Scott | Illinois | 17171 | 689 | 5 |
1726158 | 1726158 | 2021-09-17 | Talbot | Georgia | 13263 | 689 | 22 |
1726324 | 1726324 | 2021-09-17 | Scott | Illinois | 17171 | 689 | 5 |
1716883 | 1716883 | 2021-09-14 | Stevens | Kansas | 20189 | 689 | 11 |
1713637 | 1713637 | 2021-09-13 | Stevens | Kansas | 20189 | 689 | 11 |
1711902 | 1711902 | 2021-09-12 | Lyman | South Dakota | 46085 | 689 | 11 |
1708655 | 1708655 | 2021-09-11 | Lyman | South Dakota | 46085 | 689 | 11 |
1705408 | 1705408 | 2021-09-10 | Lyman | South Dakota | 46085 | 689 | 11 |
1677887 | 1677887 | 2021-09-02 | Rooks | Kansas | 20163 | 689 | 11 |
1674640 | 1674640 | 2021-09-01 | Rooks | Kansas | 20163 | 689 | 11 |
1673157 | 1673157 | 2021-08-31 | Jack | Texas | 48237 | 689 | 18 |
1665205 | 1665205 | 2021-08-29 | Lake | Michigan | 26085 | 689 | 17 |
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);