ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
720 rows where cases = 422 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 66
- Georgia 43
- Virginia 43
- Kansas 41
- South Dakota 41
- Kentucky 37
- Oklahoma 37
- Nebraska 30
- Louisiana 26
- Minnesota 24
- Montana 21
- Missouri 18
- North Dakota 18
- Illinois 16
- Iowa 16
- Wyoming 16
- Colorado 15
- Arkansas 14
- Michigan 14
- Ohio 14
- Alabama 13
- Pennsylvania 12
- North Carolina 11
- Puerto Rico 11
- Tennessee 11
- Indiana 10
- Mississippi 10
- Wisconsin 10
- Washington 9
- New York 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485026 | 2485026 | 2022-05-08 | Pawnee | Nebraska | 31133 | 422 | 4 |
2481768 | 2481768 | 2022-05-07 | Pawnee | Nebraska | 31133 | 422 | 4 |
2478510 | 2478510 | 2022-05-06 | Pawnee | Nebraska | 31133 | 422 | 4 |
2475252 | 2475252 | 2022-05-05 | Pawnee | Nebraska | 31133 | 422 | 4 |
2471995 | 2471995 | 2022-05-04 | Pawnee | Nebraska | 31133 | 422 | 4 |
2468739 | 2468739 | 2022-05-03 | Pawnee | Nebraska | 31133 | 422 | 4 |
2358023 | 2358023 | 2022-03-30 | Franklin | Nebraska | 31061 | 422 | 10 |
2354770 | 2354770 | 2022-03-29 | Franklin | Nebraska | 31061 | 422 | 10 |
2351517 | 2351517 | 2022-03-28 | Franklin | Nebraska | 31061 | 422 | 10 |
2348265 | 2348265 | 2022-03-27 | Franklin | Nebraska | 31061 | 422 | 10 |
2345012 | 2345012 | 2022-03-26 | Franklin | Nebraska | 31061 | 422 | 10 |
2341759 | 2341759 | 2022-03-25 | Franklin | Nebraska | 31061 | 422 | 10 |
2338506 | 2338506 | 2022-03-24 | Franklin | Nebraska | 31061 | 422 | 10 |
2335252 | 2335252 | 2022-03-23 | Franklin | Nebraska | 31061 | 422 | 10 |
2331998 | 2331998 | 2022-03-22 | Franklin | Nebraska | 31061 | 422 | 10 |
2274441 | 2274441 | 2022-03-04 | Dickens | Texas | 48125 | 422 | 16 |
2241747 | 2241747 | 2022-02-22 | McPherson | South Dakota | 46089 | 422 | 9 |
2238496 | 2238496 | 2022-02-21 | McPherson | South Dakota | 46089 | 422 | 9 |
2235245 | 2235245 | 2022-02-20 | McPherson | South Dakota | 46089 | 422 | 9 |
2231994 | 2231994 | 2022-02-19 | McPherson | South Dakota | 46089 | 422 | 9 |
2228743 | 2228743 | 2022-02-18 | McPherson | South Dakota | 46089 | 422 | 9 |
2225492 | 2225492 | 2022-02-17 | McPherson | South Dakota | 46089 | 422 | 9 |
2198995 | 2198995 | 2022-02-09 | Logan | North Dakota | 38047 | 422 | 11 |
2195741 | 2195741 | 2022-02-08 | Logan | North Dakota | 38047 | 422 | 11 |
2146935 | 2146935 | 2022-01-24 | Golden Valley | North Dakota | 38033 | 422 | 4 |
2143681 | 2143681 | 2022-01-23 | Golden Valley | North Dakota | 38033 | 422 | 4 |
2140426 | 2140426 | 2022-01-22 | Golden Valley | North Dakota | 38033 | 422 | 4 |
2134684 | 2134684 | 2022-01-20 | Menard | Texas | 48327 | 422 | 12 |
2127067 | 2127067 | 2022-01-18 | Brown | Nebraska | 31017 | 422 | 4 |
2123815 | 2123815 | 2022-01-17 | Brown | Nebraska | 31017 | 422 | 4 |
2124648 | 2124648 | 2022-01-17 | Miner | South Dakota | 46097 | 422 | 12 |
2121396 | 2121396 | 2022-01-16 | Miner | South Dakota | 46097 | 422 | 12 |
2117657 | 2117657 | 2022-01-15 | Grant | North Dakota | 38037 | 422 | 11 |
2118144 | 2118144 | 2022-01-15 | Miner | South Dakota | 46097 | 422 | 12 |
2114893 | 2114893 | 2022-01-14 | Miner | South Dakota | 46097 | 422 | 12 |
2111157 | 2111157 | 2022-01-13 | Kidder | North Dakota | 38043 | 422 | 13 |
2095678 | 2095678 | 2022-01-08 | Oldham | Texas | 48359 | 422 | 6 |
2081604 | 2081604 | 2022-01-04 | Perkins | Nebraska | 31135 | 422 | 12 |
2076430 | 2076430 | 2022-01-02 | Columbia | Washington | 53013 | 422 | 9 |
2073179 | 2073179 | 2022-01-01 | Columbia | Washington | 53013 | 422 | 9 |
2069928 | 2069928 | 2021-12-31 | Columbia | Washington | 53013 | 422 | 9 |
2066677 | 2066677 | 2021-12-30 | Columbia | Washington | 53013 | 422 | 9 |
2041315 | 2041315 | 2021-12-23 | Glascock | Georgia | 13125 | 422 | 21 |
2012557 | 2012557 | 2021-12-14 | Lincoln | Kansas | 20105 | 422 | 7 |
2009306 | 2009306 | 2021-12-13 | Lincoln | Kansas | 20105 | 422 | 7 |
2010877 | 2010877 | 2021-12-13 | Sanborn | South Dakota | 46111 | 422 | 3 |
2006055 | 2006055 | 2021-12-12 | Lincoln | Kansas | 20105 | 422 | 7 |
2007626 | 2007626 | 2021-12-12 | Sanborn | South Dakota | 46111 | 422 | 3 |
2002804 | 2002804 | 2021-12-11 | Lincoln | Kansas | 20105 | 422 | 7 |
2004375 | 2004375 | 2021-12-11 | Sanborn | South Dakota | 46111 | 422 | 3 |
1999554 | 1999554 | 2021-12-10 | Lincoln | Kansas | 20105 | 422 | 7 |
2001124 | 2001124 | 2021-12-10 | Sanborn | South Dakota | 46111 | 422 | 3 |
1974304 | 1974304 | 2021-12-02 | Frontier | Nebraska | 31063 | 422 | 2 |
1963172 | 1963172 | 2021-11-29 | Unknown | Delaware | 422 | 0 | |
1964603 | 1964603 | 2021-11-29 | Sherman | Nebraska | 31163 | 422 | 4 |
1962269 | 1962269 | 2021-11-28 | Collingsworth | Texas | 48087 | 422 | 11 |
1959018 | 1959018 | 2021-11-27 | Collingsworth | Texas | 48087 | 422 | 11 |
1955767 | 1955767 | 2021-11-26 | Collingsworth | Texas | 48087 | 422 | 11 |
1952516 | 1952516 | 2021-11-25 | Collingsworth | Texas | 48087 | 422 | 11 |
1946917 | 1946917 | 2021-11-24 | Unknown | Delaware | 422 | 0 | |
1949265 | 1949265 | 2021-11-24 | Collingsworth | Texas | 48087 | 422 | 11 |
1946014 | 1946014 | 2021-11-23 | Collingsworth | Texas | 48087 | 422 | 11 |
1940352 | 1940352 | 2021-11-22 | Costilla | Colorado | 8023 | 422 | 13 |
1925886 | 1925886 | 2021-11-17 | Renville | North Dakota | 38075 | 422 | 14 |
1915014 | 1915014 | 2021-11-14 | Edwards | Kansas | 20047 | 422 | 13 |
1911764 | 1911764 | 2021-11-13 | Edwards | Kansas | 20047 | 422 | 13 |
1908515 | 1908515 | 2021-11-12 | Edwards | Kansas | 20047 | 422 | 13 |
1910295 | 1910295 | 2021-11-12 | Fisher | Texas | 48151 | 422 | 17 |
1907046 | 1907046 | 2021-11-11 | Fisher | Texas | 48151 | 422 | 17 |
1880863 | 1880863 | 2021-11-03 | Perkins | South Dakota | 46105 | 422 | 15 |
1858121 | 1858121 | 2021-10-27 | Potter | South Dakota | 46107 | 422 | 4 |
1826610 | 1826610 | 2021-10-18 | Baca | Colorado | 8009 | 422 | 5 |
1823403 | 1823403 | 2021-10-17 | Ouray | Colorado | 8091 | 422 | 5 |
1820154 | 1820154 | 2021-10-16 | Ouray | Colorado | 8091 | 422 | 5 |
1816905 | 1816905 | 2021-10-15 | Ouray | Colorado | 8091 | 422 | 5 |
1814274 | 1814274 | 2021-10-14 | Cheyenne | Kansas | 20023 | 422 | 13 |
1811025 | 1811025 | 2021-10-13 | Cheyenne | Kansas | 20023 | 422 | 13 |
1807776 | 1807776 | 2021-10-12 | Cheyenne | Kansas | 20023 | 422 | 13 |
1804525 | 1804525 | 2021-10-11 | Cheyenne | Kansas | 20023 | 422 | 13 |
1789239 | 1789239 | 2021-10-06 | Hamilton | New York | 36041 | 422 | 3 |
1790285 | 1790285 | 2021-10-06 | Essex | Vermont | 50009 | 422 | 2 |
1782502 | 1782502 | 2021-10-04 | Fallon | Montana | 30025 | 422 | 4 |
1783811 | 1783811 | 2021-10-04 | Bath | Virginia | 51017 | 422 | 14 |
1779189 | 1779189 | 2021-10-03 | Mercer | Missouri | 29129 | 422 | 3 |
1779252 | 1779252 | 2021-10-03 | Fallon | Montana | 30025 | 422 | 4 |
1775939 | 1775939 | 2021-10-02 | Mercer | Missouri | 29129 | 422 | 3 |
1776002 | 1776002 | 2021-10-02 | Fallon | Montana | 30025 | 422 | 4 |
1776652 | 1776652 | 2021-10-02 | Cameron | Pennsylvania | 42023 | 422 | 10 |
1772752 | 1772752 | 2021-10-01 | Fallon | Montana | 30025 | 422 | 4 |
1770368 | 1770368 | 2021-09-30 | Hanson | South Dakota | 46061 | 422 | 4 |
1770634 | 1770634 | 2021-09-30 | Kimble | Texas | 48267 | 422 | 11 |
1767119 | 1767119 | 2021-09-29 | Hanson | South Dakota | 46061 | 422 | 4 |
1767385 | 1767385 | 2021-09-29 | Kimble | Texas | 48267 | 422 | 11 |
1763870 | 1763870 | 2021-09-28 | Hanson | South Dakota | 46061 | 422 | 4 |
1764042 | 1764042 | 2021-09-28 | Cochran | Texas | 48079 | 422 | 16 |
1760621 | 1760621 | 2021-09-27 | Hanson | South Dakota | 46061 | 422 | 4 |
1757373 | 1757373 | 2021-09-26 | Hanson | South Dakota | 46061 | 422 | 4 |
1753659 | 1753659 | 2021-09-25 | Hettinger | North Dakota | 38041 | 422 | 4 |
1754125 | 1754125 | 2021-09-25 | Hanson | South Dakota | 46061 | 422 | 4 |
1750877 | 1750877 | 2021-09-24 | Hanson | South Dakota | 46061 | 422 | 4 |
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);