ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
165 rows where cases = 3942 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 14
- Virginia 10
- Wisconsin 10
- Minnesota 9
- Nebraska 9
- Georgia 8
- Montana 7
- Indiana 6
- Kansas 6
- Kentucky 6
- Louisiana 6
- Vermont 6
- Mississippi 5
- Texas 5
- Missouri 4
- New Hampshire 4
- North Carolina 4
- Ohio 4
- Washington 4
- Alabama 3
- Alaska 3
- Arkansas 3
- Colorado 3
- Illinois 3
- Pennsylvania 3
- South Carolina 3
- Tennessee 3
- California 2
- New Mexico 2
- New York 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448857 | 2448857 | 2022-04-27 | Redwood | Minnesota | 27127 | 3942 | 53 |
2442587 | 2442587 | 2022-04-25 | Glacier | Montana | 30035 | 3942 | 70 |
2429563 | 2429563 | 2022-04-21 | Glacier | Montana | 30035 | 3942 | 69 |
2416671 | 2416671 | 2022-04-17 | York | Nebraska | 31185 | 3942 | 21 |
2413415 | 2413415 | 2022-04-16 | York | Nebraska | 31185 | 3942 | 21 |
2410159 | 2410159 | 2022-04-15 | York | Nebraska | 31185 | 3942 | 21 |
2405532 | 2405532 | 2022-04-14 | Banks | Georgia | 13011 | 3942 | 88 |
2406903 | 2406903 | 2022-04-14 | York | Nebraska | 31185 | 3942 | 21 |
2408086 | 2408086 | 2022-04-14 | Buckingham | Virginia | 51029 | 3942 | 57 |
2402277 | 2402277 | 2022-04-13 | Banks | Georgia | 13011 | 3942 | 88 |
2397005 | 2397005 | 2022-04-11 | Glacier | Montana | 30035 | 3942 | 69 |
2393750 | 2393750 | 2022-04-10 | Glacier | Montana | 30035 | 3942 | 69 |
2390494 | 2390494 | 2022-04-09 | Glacier | Montana | 30035 | 3942 | 69 |
2387238 | 2387238 | 2022-04-08 | Glacier | Montana | 30035 | 3942 | 69 |
2384690 | 2384690 | 2022-04-07 | Aguas Buenas | Puerto Rico | 72007 | 3942 | |
2301491 | 2301491 | 2022-03-13 | Jeff Davis | Georgia | 13161 | 3942 | 70 |
2298239 | 2298239 | 2022-03-12 | Jeff Davis | Georgia | 13161 | 3942 | 70 |
2294987 | 2294987 | 2022-03-11 | Jeff Davis | Georgia | 13161 | 3942 | 70 |
2294428 | 2294428 | 2022-03-10 | Burnett | Wisconsin | 55013 | 3942 | 41 |
2291176 | 2291176 | 2022-03-09 | Burnett | Wisconsin | 55013 | 3942 | 41 |
2287924 | 2287924 | 2022-03-08 | Burnett | Wisconsin | 55013 | 3942 | 41 |
2265215 | 2265215 | 2022-03-01 | Washburn | Wisconsin | 55129 | 3942 | 44 |
2261725 | 2261725 | 2022-02-28 | Greene | Virginia | 51079 | 3942 | 59 |
2233864 | 2233864 | 2022-02-20 | Bienville | Louisiana | 22013 | 3942 | 105 |
2230613 | 2230613 | 2022-02-19 | Bienville | Louisiana | 22013 | 3942 | 105 |
2227362 | 2227362 | 2022-02-18 | Bienville | Louisiana | 22013 | 3942 | 105 |
2228864 | 2228864 | 2022-02-18 | Aransas | Texas | 48007 | 3942 | 76 |
2157119 | 2157119 | 2022-01-27 | Lee | South Carolina | 45061 | 3942 | 85 |
2148864 | 2148864 | 2022-01-25 | White | Illinois | 17193 | 3942 | 45 |
2143621 | 2143621 | 2022-01-23 | Madison | North Carolina | 37115 | 3942 | 73 |
2140366 | 2140366 | 2022-01-22 | Madison | North Carolina | 37115 | 3942 | 73 |
2137110 | 2137110 | 2022-01-21 | Madison | North Carolina | 37115 | 3942 | 73 |
2128546 | 2128546 | 2022-01-18 | Adams | Wisconsin | 55001 | 3942 | 45 |
2123635 | 2123635 | 2022-01-17 | Andrew | Missouri | 29003 | 3942 | 42 |
2120383 | 2120383 | 2022-01-16 | Andrew | Missouri | 29003 | 3942 | 42 |
2117131 | 2117131 | 2022-01-15 | Andrew | Missouri | 29003 | 3942 | 42 |
2097096 | 2097096 | 2022-01-09 | Pottawatomie | Kansas | 20149 | 3942 | 48 |
2097606 | 2097606 | 2022-01-09 | Stone | Mississippi | 28131 | 3942 | 67 |
2093844 | 2093844 | 2022-01-08 | Pottawatomie | Kansas | 20149 | 3942 | 48 |
2094354 | 2094354 | 2022-01-08 | Stone | Mississippi | 28131 | 3942 | 67 |
2090592 | 2090592 | 2022-01-07 | Pottawatomie | Kansas | 20149 | 3942 | 48 |
2091102 | 2091102 | 2022-01-07 | Stone | Mississippi | 28131 | 3942 | 67 |
2053601 | 2053601 | 2021-12-26 | Hopewell city | Virginia | 51670 | 3942 | 96 |
2050351 | 2050351 | 2021-12-25 | Hopewell city | Virginia | 51670 | 3942 | 96 |
2047101 | 2047101 | 2021-12-24 | Hopewell city | Virginia | 51670 | 3942 | 96 |
2024015 | 2024015 | 2021-12-17 | Calhoun | Texas | 48057 | 3942 | 39 |
2015980 | 2015980 | 2021-12-15 | Woodford | Kentucky | 21239 | 3942 | 33 |
2009843 | 2009843 | 2021-12-13 | Tishomingo | Mississippi | 28141 | 3942 | 94 |
2007674 | 2007674 | 2021-12-12 | Haywood | Tennessee | 47075 | 3942 | 79 |
2004423 | 2004423 | 2021-12-11 | Haywood | Tennessee | 47075 | 3942 | 79 |
2001172 | 2001172 | 2021-12-10 | Haywood | Tennessee | 47075 | 3942 | 79 |
1984035 | 1984035 | 2021-12-05 | Cass | Nebraska | 31025 | 3942 | 22 |
1980785 | 1980785 | 2021-12-04 | Cass | Nebraska | 31025 | 3942 | 22 |
1977535 | 1977535 | 2021-12-03 | Cass | Nebraska | 31025 | 3942 | 22 |
1962515 | 1962515 | 2021-11-28 | Franklin | Vermont | 50011 | 3942 | 52 |
1959264 | 1959264 | 2021-11-27 | Franklin | Vermont | 50011 | 3942 | 52 |
1956013 | 1956013 | 2021-11-26 | Franklin | Vermont | 50011 | 3942 | 52 |
1952762 | 1952762 | 2021-11-25 | Franklin | Vermont | 50011 | 3942 | 52 |
1949511 | 1949511 | 2021-11-24 | Franklin | Vermont | 50011 | 3942 | 52 |
1938629 | 1938629 | 2021-11-21 | Coos | New Hampshire | 33007 | 3942 | 69 |
1935379 | 1935379 | 2021-11-20 | Coos | New Hampshire | 33007 | 3942 | 69 |
1932129 | 1932129 | 2021-11-19 | Coos | New Hampshire | 33007 | 3942 | 69 |
1922811 | 1922811 | 2021-11-16 | Seminole | Oklahoma | 40133 | 3942 | 105 |
1917917 | 1917917 | 2021-11-15 | Cassia | Idaho | 16031 | 3942 | 41 |
1919562 | 1919562 | 2021-11-15 | Seminole | Oklahoma | 40133 | 3942 | 105 |
1916312 | 1916312 | 2021-11-14 | Seminole | Oklahoma | 40133 | 3942 | 105 |
1913062 | 1913062 | 2021-11-13 | Seminole | Oklahoma | 40133 | 3942 | 105 |
1909812 | 1909812 | 2021-11-12 | Seminole | Oklahoma | 40133 | 3942 | 105 |
1906563 | 1906563 | 2021-11-11 | Seminole | Oklahoma | 40133 | 3942 | 105 |
1907514 | 1907514 | 2021-11-11 | Door | Wisconsin | 55029 | 3942 | 41 |
1903314 | 1903314 | 2021-11-10 | Seminole | Oklahoma | 40133 | 3942 | 105 |
1870211 | 1870211 | 2021-10-31 | Washington | Missouri | 29221 | 3942 | 67 |
1811452 | 1811452 | 2021-10-13 | Brown | Minnesota | 27015 | 3942 | 45 |
1804955 | 1804955 | 2021-10-11 | Cass | Minnesota | 27021 | 3942 | 41 |
1768946 | 1768946 | 2021-09-30 | Lincoln | Kentucky | 21137 | 3942 | 74 |
1755614 | 1755614 | 2021-09-26 | Greene | Indiana | 18055 | 3942 | 96 |
1752366 | 1752366 | 2021-09-25 | Greene | Indiana | 18055 | 3942 | 96 |
1749117 | 1749117 | 2021-09-24 | Greene | Indiana | 18055 | 3942 | 96 |
1746564 | 1746564 | 2021-09-23 | Coahoma | Mississippi | 28027 | 3942 | 98 |
1744346 | 1744346 | 2021-09-22 | Union | South Carolina | 45087 | 3942 | 90 |
1733507 | 1733507 | 2021-09-19 | Lyon | Minnesota | 27083 | 3942 | 54 |
1730257 | 1730257 | 2021-09-18 | Lyon | Minnesota | 27083 | 3942 | 54 |
1727007 | 1727007 | 2021-09-17 | Lyon | Minnesota | 27083 | 3942 | 54 |
1651955 | 1651955 | 2021-08-25 | Clay | Kentucky | 21051 | 3942 | 48 |
1634848 | 1634848 | 2021-08-20 | Poinsett | Arkansas | 5111 | 3942 | 89 |
1621716 | 1621716 | 2021-08-16 | Dallas | Alabama | 1047 | 3942 | 164 |
1624717 | 1624717 | 2021-08-16 | Prince George | Virginia | 51149 | 3942 | 33 |
1618626 | 1618626 | 2021-08-15 | Unknown | Arkansas | 3942 | 0 | |
1586994 | 1586994 | 2021-08-05 | Floyd | Kentucky | 21071 | 3942 | 74 |
1579277 | 1579277 | 2021-08-02 | Douglas | Washington | 53017 | 3942 | 23 |
1575068 | 1575068 | 2021-08-01 | Logan | Ohio | 39091 | 3942 | 79 |
1576029 | 1576029 | 2021-08-01 | Douglas | Washington | 53017 | 3942 | 23 |
1572781 | 1572781 | 2021-07-31 | Douglas | Washington | 53017 | 3942 | 23 |
1569533 | 1569533 | 2021-07-30 | Douglas | Washington | 53017 | 3942 | 23 |
1557333 | 1557333 | 2021-07-27 | Christian | Illinois | 17021 | 3942 | 93 |
1537527 | 1537527 | 2021-07-21 | Montrose | Colorado | 8085 | 3942 | 68 |
1532600 | 1532600 | 2021-07-19 | Cortland | New York | 36023 | 3942 | 64 |
1497926 | 1497926 | 2021-07-08 | Sanpete | Utah | 49039 | 3942 | 23 |
1331683 | 1331683 | 2021-05-18 | McCurtain | Oklahoma | 40089 | 3942 | 90 |
1328436 | 1328436 | 2021-05-17 | McCurtain | Oklahoma | 40089 | 3942 | 90 |
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);