ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
538 rows where cases = 522 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 48
- Georgia 33
- Oklahoma 31
- Virginia 25
- Kansas 24
- South Dakota 23
- Nebraska 22
- Minnesota 21
- Idaho 20
- Puerto Rico 18
- Missouri 16
- Montana 16
- Kentucky 14
- North Dakota 14
- Tennessee 14
- Michigan 13
- Mississippi 13
- North Carolina 13
- Illinois 11
- Indiana 11
- Iowa 11
- Oregon 11
- Arkansas 9
- California 9
- Alabama 8
- Colorado 8
- Ohio 8
- West Virginia 7
- Alaska 6
- Louisiana 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501761 | 2501761 | 2022-05-13 | Harmon | Oklahoma | 40057 | 522 | 12 |
2498503 | 2498503 | 2022-05-12 | Harmon | Oklahoma | 40057 | 522 | 12 |
2495245 | 2495245 | 2022-05-11 | Harmon | Oklahoma | 40057 | 522 | 12 |
2491987 | 2491987 | 2022-05-10 | Harmon | Oklahoma | 40057 | 522 | 12 |
2488729 | 2488729 | 2022-05-09 | Harmon | Oklahoma | 40057 | 522 | 12 |
2485472 | 2485472 | 2022-05-08 | Harmon | Oklahoma | 40057 | 522 | 12 |
2482214 | 2482214 | 2022-05-07 | Harmon | Oklahoma | 40057 | 522 | 12 |
2478956 | 2478956 | 2022-05-06 | Harmon | Oklahoma | 40057 | 522 | 12 |
2475698 | 2475698 | 2022-05-05 | Harmon | Oklahoma | 40057 | 522 | 12 |
2472441 | 2472441 | 2022-05-04 | Harmon | Oklahoma | 40057 | 522 | 12 |
2469185 | 2469185 | 2022-05-03 | Harmon | Oklahoma | 40057 | 522 | 12 |
2465929 | 2465929 | 2022-05-02 | Harmon | Oklahoma | 40057 | 522 | 12 |
2462674 | 2462674 | 2022-05-01 | Harmon | Oklahoma | 40057 | 522 | 12 |
2459418 | 2459418 | 2022-04-30 | Harmon | Oklahoma | 40057 | 522 | 12 |
2456162 | 2456162 | 2022-04-29 | Harmon | Oklahoma | 40057 | 522 | 12 |
2452906 | 2452906 | 2022-04-28 | Harmon | Oklahoma | 40057 | 522 | 12 |
2442634 | 2442634 | 2022-04-25 | Brown | Nebraska | 31017 | 522 | 4 |
2439378 | 2439378 | 2022-04-24 | Brown | Nebraska | 31017 | 522 | 4 |
2436122 | 2436122 | 2022-04-23 | Brown | Nebraska | 31017 | 522 | 4 |
2432866 | 2432866 | 2022-04-22 | Brown | Nebraska | 31017 | 522 | 4 |
2362411 | 2362411 | 2022-03-31 | Schleicher | Texas | 48413 | 522 | 9 |
2359157 | 2359157 | 2022-03-30 | Schleicher | Texas | 48413 | 522 | 9 |
2355903 | 2355903 | 2022-03-29 | Schleicher | Texas | 48413 | 522 | 9 |
2352650 | 2352650 | 2022-03-28 | Schleicher | Texas | 48413 | 522 | 9 |
2349398 | 2349398 | 2022-03-27 | Schleicher | Texas | 48413 | 522 | 9 |
2346145 | 2346145 | 2022-03-26 | Schleicher | Texas | 48413 | 522 | 9 |
2342892 | 2342892 | 2022-03-25 | Schleicher | Texas | 48413 | 522 | 9 |
2317128 | 2317128 | 2022-03-17 | Wahkiakum | Washington | 53069 | 522 | 6 |
2313875 | 2313875 | 2022-03-16 | Wahkiakum | Washington | 53069 | 522 | 6 |
2282086 | 2282086 | 2022-03-07 | Custer | Idaho | 16037 | 522 | 8 |
2278833 | 2278833 | 2022-03-06 | Custer | Idaho | 16037 | 522 | 8 |
2275580 | 2275580 | 2022-03-05 | Custer | Idaho | 16037 | 522 | 8 |
2272327 | 2272327 | 2022-03-04 | Custer | Idaho | 16037 | 522 | 8 |
2269075 | 2269075 | 2022-03-03 | Custer | Idaho | 16037 | 522 | 8 |
2240872 | 2240872 | 2022-02-22 | Granite | Montana | 30039 | 522 | 7 |
2241749 | 2241749 | 2022-02-22 | Mellette | South Dakota | 46095 | 522 | 6 |
2238498 | 2238498 | 2022-02-21 | Mellette | South Dakota | 46095 | 522 | 6 |
2235247 | 2235247 | 2022-02-20 | Mellette | South Dakota | 46095 | 522 | 6 |
2231996 | 2231996 | 2022-02-19 | Mellette | South Dakota | 46095 | 522 | 6 |
2228745 | 2228745 | 2022-02-18 | Mellette | South Dakota | 46095 | 522 | 6 |
2225789 | 2225789 | 2022-02-17 | Oldham | Texas | 48359 | 522 | 6 |
2218183 | 2218183 | 2022-02-15 | Frontier | Nebraska | 31063 | 522 | 2 |
2214932 | 2214932 | 2022-02-14 | Frontier | Nebraska | 31063 | 522 | 2 |
2176726 | 2176726 | 2022-02-02 | Ziebach | South Dakota | 46137 | 522 | 11 |
2172986 | 2172986 | 2022-02-01 | Renville | North Dakota | 38075 | 522 | 15 |
2173472 | 2173472 | 2022-02-01 | Ziebach | South Dakota | 46137 | 522 | 11 |
2149917 | 2149917 | 2022-01-25 | Sherman | Nebraska | 31163 | 522 | 4 |
2142760 | 2142760 | 2022-01-23 | Robertson | Kentucky | 21201 | 522 | 19 |
2139505 | 2139505 | 2022-01-22 | Robertson | Kentucky | 21201 | 522 | 19 |
2136249 | 2136249 | 2022-01-21 | Robertson | Kentucky | 21201 | 522 | 19 |
2129094 | 2129094 | 2022-01-19 | Glascock | Georgia | 13125 | 522 | 22 |
2128631 | 2128631 | 2022-01-18 | Niobrara | Wyoming | 56027 | 522 | 8 |
2114435 | 2114435 | 2022-01-14 | Towner | North Dakota | 38095 | 522 | 11 |
2101209 | 2101209 | 2022-01-10 | Mora | New Mexico | 35033 | 522 | 14 |
2084711 | 2084711 | 2022-01-05 | Scotland | Missouri | 29199 | 522 | 17 |
2082383 | 2082383 | 2022-01-04 | Potter | South Dakota | 46107 | 522 | 5 |
2039675 | 2039675 | 2021-12-22 | Unknown | Northern Mariana Islands | 522 | 2 | |
2029454 | 2029454 | 2021-12-19 | Schuyler | Missouri | 29197 | 522 | 22 |
2026203 | 2026203 | 2021-12-18 | Schuyler | Missouri | 29197 | 522 | 22 |
1997821 | 1997821 | 2021-12-09 | Bennett | South Dakota | 46007 | 522 | 9 |
1998116 | 1998116 | 2021-12-09 | Kinney | Texas | 48271 | 522 | 10 |
1994570 | 1994570 | 2021-12-08 | Bennett | South Dakota | 46007 | 522 | 9 |
1994865 | 1994865 | 2021-12-08 | Kinney | Texas | 48271 | 522 | 10 |
1989819 | 1989819 | 2021-12-07 | Osborne | Kansas | 20141 | 522 | 15 |
1986569 | 1986569 | 2021-12-06 | Osborne | Kansas | 20141 | 522 | 15 |
1964478 | 1964478 | 2021-11-29 | Fallon | Montana | 30025 | 522 | 8 |
1961227 | 1961227 | 2021-11-28 | Fallon | Montana | 30025 | 522 | 8 |
1957976 | 1957976 | 2021-11-27 | Fallon | Montana | 30025 | 522 | 8 |
1954725 | 1954725 | 2021-11-26 | Fallon | Montana | 30025 | 522 | 8 |
1951474 | 1951474 | 2021-11-25 | Fallon | Montana | 30025 | 522 | 8 |
1948223 | 1948223 | 2021-11-24 | Fallon | Montana | 30025 | 522 | 8 |
1944318 | 1944318 | 2021-11-23 | Rawlins | Kansas | 20153 | 522 | 7 |
1944711 | 1944711 | 2021-11-23 | Lake of the Woods | Minnesota | 27077 | 522 | 5 |
1945107 | 1945107 | 2021-11-23 | Webster | Nebraska | 31181 | 522 | 9 |
1940364 | 1940364 | 2021-11-22 | Gilpin | Colorado | 8047 | 522 | 3 |
1941068 | 1941068 | 2021-11-22 | Rawlins | Kansas | 20153 | 522 | 7 |
1906005 | 1906005 | 2021-11-11 | Sheridan | Montana | 30091 | 522 | 8 |
1906371 | 1906371 | 2021-11-11 | Hettinger | North Dakota | 38041 | 522 | 6 |
1902756 | 1902756 | 2021-11-10 | Sheridan | Montana | 30091 | 522 | 8 |
1898752 | 1898752 | 2021-11-09 | Chautauqua | Kansas | 20019 | 522 | 11 |
1895502 | 1895502 | 2021-11-08 | Chautauqua | Kansas | 20019 | 522 | 11 |
1891436 | 1891436 | 2021-11-07 | Unknown | Alaska | 522 | 1 | |
1888186 | 1888186 | 2021-11-06 | Unknown | Alaska | 522 | 1 | |
1884936 | 1884936 | 2021-11-05 | Unknown | Alaska | 522 | 1 | |
1881687 | 1881687 | 2021-11-04 | Unknown | Alaska | 522 | 1 | |
1863654 | 1863654 | 2021-10-29 | Knox | Missouri | 29103 | 522 | 3 |
1850282 | 1850282 | 2021-10-25 | Tensas | Louisiana | 22107 | 522 | 8 |
1851122 | 1851122 | 2021-10-25 | Cavalier | North Dakota | 38019 | 522 | 5 |
1838127 | 1838127 | 2021-10-21 | Eddy | North Dakota | 38027 | 522 | 6 |
1831295 | 1831295 | 2021-10-19 | Chase | Nebraska | 31029 | 522 | 5 |
1799130 | 1799130 | 2021-10-09 | Bowman | North Dakota | 38011 | 522 | 7 |
1785061 | 1785061 | 2021-10-05 | Haskell | Kansas | 20081 | 522 | 8 |
1786760 | 1786760 | 2021-10-05 | Baylor | Texas | 48023 | 522 | 18 |
1787154 | 1787154 | 2021-10-05 | Rappahannock | Virginia | 51157 | 522 | 4 |
1781812 | 1781812 | 2021-10-04 | Haskell | Kansas | 20081 | 522 | 8 |
1783905 | 1783905 | 2021-10-04 | Rappahannock | Virginia | 51157 | 522 | 4 |
1769266 | 1769266 | 2021-09-30 | Red Lake | Minnesota | 27125 | 522 | 8 |
1760149 | 1760149 | 2021-09-27 | Emmons | North Dakota | 38029 | 522 | 14 |
1743531 | 1743531 | 2021-09-22 | Mineral | Montana | 30061 | 522 | 9 |
1740674 | 1740674 | 2021-09-21 | Nelson | North Dakota | 38063 | 522 | 16 |
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);