ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
294 rows where cases = 2117 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 24
- North Carolina 18
- South Dakota 18
- Mississippi 15
- Missouri 15
- Texas 15
- Kentucky 14
- Georgia 13
- Alabama 12
- Minnesota 12
- Indiana 11
- Iowa 11
- Virginia 11
- Tennessee 9
- Arkansas 8
- Puerto Rico 8
- Illinois 7
- South Carolina 7
- Maine 6
- Louisiana 5
- Montana 5
- Wisconsin 5
- Washington 4
- West Virginia 4
- Arizona 3
- California 3
- Maryland 3
- Michigan 3
- Nebraska 3
- Oklahoma 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2406106 | 2406106 | 2022-04-14 | Pawnee | Kansas | 20145 | 2117 | 24 |
2402850 | 2402850 | 2022-04-13 | Pawnee | Kansas | 20145 | 2117 | 24 |
2399596 | 2399596 | 2022-04-12 | Pawnee | Kansas | 20145 | 2117 | 24 |
2396340 | 2396340 | 2022-04-11 | Pawnee | Kansas | 20145 | 2117 | 24 |
2393085 | 2393085 | 2022-04-10 | Pawnee | Kansas | 20145 | 2117 | 24 |
2389829 | 2389829 | 2022-04-09 | Pawnee | Kansas | 20145 | 2117 | 24 |
2386573 | 2386573 | 2022-04-08 | Pawnee | Kansas | 20145 | 2117 | 24 |
2360544 | 2360544 | 2022-03-31 | Pawnee | Kansas | 20145 | 2117 | 24 |
2357290 | 2357290 | 2022-03-30 | Pawnee | Kansas | 20145 | 2117 | 24 |
2354037 | 2354037 | 2022-03-29 | Pawnee | Kansas | 20145 | 2117 | 24 |
2350785 | 2350785 | 2022-03-28 | Pawnee | Kansas | 20145 | 2117 | 24 |
2347532 | 2347532 | 2022-03-27 | Pawnee | Kansas | 20145 | 2117 | 24 |
2344279 | 2344279 | 2022-03-26 | Pawnee | Kansas | 20145 | 2117 | 24 |
2341026 | 2341026 | 2022-03-25 | Pawnee | Kansas | 20145 | 2117 | 24 |
2337773 | 2337773 | 2022-03-24 | Pawnee | Kansas | 20145 | 2117 | 24 |
2334519 | 2334519 | 2022-03-23 | Pawnee | Kansas | 20145 | 2117 | 24 |
2286377 | 2286377 | 2022-03-08 | Beaverhead | Montana | 30001 | 2117 | 28 |
2283125 | 2283125 | 2022-03-07 | Beaverhead | Montana | 30001 | 2117 | 28 |
2279599 | 2279599 | 2022-03-06 | Clearwater | Minnesota | 27029 | 2117 | 30 |
2276346 | 2276346 | 2022-03-05 | Clearwater | Minnesota | 27029 | 2117 | 30 |
2273093 | 2273093 | 2022-03-04 | Clearwater | Minnesota | 27029 | 2117 | 30 |
2270892 | 2270892 | 2022-03-03 | Rincon | Puerto Rico | 72117 | 2117 | |
2261426 | 2261426 | 2022-02-28 | Dallam | Texas | 48111 | 2117 | 40 |
2257028 | 2257028 | 2022-02-27 | Gentry | Missouri | 29075 | 2117 | 29 |
2258175 | 2258175 | 2022-02-27 | Dallam | Texas | 48111 | 2117 | 40 |
2253777 | 2253777 | 2022-02-26 | Gentry | Missouri | 29075 | 2117 | 29 |
2254924 | 2254924 | 2022-02-26 | Dallam | Texas | 48111 | 2117 | 39 |
2250526 | 2250526 | 2022-02-25 | Gentry | Missouri | 29075 | 2117 | 29 |
2244024 | 2244024 | 2022-02-23 | Gentry | Missouri | 29075 | 2117 | 29 |
2237346 | 2237346 | 2022-02-21 | Jackson | Minnesota | 27063 | 2117 | 17 |
2234095 | 2234095 | 2022-02-20 | Jackson | Minnesota | 27063 | 2117 | 17 |
2230844 | 2230844 | 2022-02-19 | Jackson | Minnesota | 27063 | 2117 | 17 |
2227593 | 2227593 | 2022-02-18 | Jackson | Minnesota | 27063 | 2117 | 17 |
2225998 | 2225998 | 2022-02-17 | Northampton | Virginia | 51131 | 2117 | 54 |
2215564 | 2215564 | 2022-02-14 | Adjuntas | Puerto Rico | 72001 | 2117 | |
2212313 | 2212313 | 2022-02-13 | Adjuntas | Puerto Rico | 72001 | 2117 | |
2194226 | 2194226 | 2022-02-08 | Seminole | Georgia | 13253 | 2117 | 27 |
2157982 | 2157982 | 2022-01-28 | Sumter | Alabama | 1119 | 2117 | 42 |
2154729 | 2154729 | 2022-01-27 | Sumter | Alabama | 1119 | 2117 | 42 |
2151476 | 2151476 | 2022-01-26 | Sumter | Alabama | 1119 | 2117 | 42 |
2148224 | 2148224 | 2022-01-25 | Sumter | Alabama | 1119 | 2117 | 42 |
2144972 | 2144972 | 2022-01-24 | Sumter | Alabama | 1119 | 2117 | 42 |
2130278 | 2130278 | 2022-01-19 | Jefferson | Montana | 30043 | 2117 | 22 |
2127856 | 2127856 | 2022-01-18 | Bon Homme | South Dakota | 46009 | 2117 | 33 |
2117667 | 2117667 | 2022-01-15 | Mercer | North Dakota | 38057 | 2117 | 22 |
2113578 | 2113578 | 2022-01-14 | Piscataquis | Maine | 23021 | 2117 | 23 |
2099417 | 2099417 | 2022-01-10 | Lowndes | Alabama | 1085 | 2117 | 68 |
2100843 | 2100843 | 2022-01-10 | Noxubee | Mississippi | 28103 | 2117 | 44 |
2096785 | 2096785 | 2022-01-09 | Marshall | Illinois | 17123 | 2117 | 26 |
2093533 | 2093533 | 2022-01-08 | Marshall | Illinois | 17123 | 2117 | 26 |
2089638 | 2089638 | 2022-01-07 | Coosa | Alabama | 1037 | 2117 | 48 |
2090281 | 2090281 | 2022-01-07 | Marshall | Illinois | 17123 | 2117 | 26 |
2078522 | 2078522 | 2022-01-03 | Alleghany | North Carolina | 37005 | 2117 | 7 |
2023711 | 2023711 | 2021-12-17 | Cayey | Puerto Rico | 72035 | 2117 | |
2009775 | 2009775 | 2021-12-13 | Amite | Mississippi | 28005 | 2117 | 57 |
1993491 | 1993491 | 2021-12-08 | Pope | Minnesota | 27121 | 2117 | 10 |
1967117 | 1967117 | 2021-11-30 | Breathitt | Kentucky | 21025 | 2117 | 41 |
1967287 | 1967287 | 2021-11-30 | West Carroll | Louisiana | 22123 | 2117 | 52 |
1960497 | 1960497 | 2021-11-28 | Allen | Kansas | 20001 | 2117 | 26 |
1957246 | 1957246 | 2021-11-27 | Allen | Kansas | 20001 | 2117 | 26 |
1953995 | 1953995 | 2021-11-26 | Allen | Kansas | 20001 | 2117 | 26 |
1950744 | 1950744 | 2021-11-25 | Allen | Kansas | 20001 | 2117 | 26 |
1947493 | 1947493 | 2021-11-24 | Allen | Kansas | 20001 | 2117 | 26 |
1936996 | 1936996 | 2021-11-21 | Little River | Arkansas | 5081 | 2117 | 80 |
1937807 | 1937807 | 2021-11-21 | Nemaha | Kansas | 20131 | 2117 | 56 |
1939068 | 1939068 | 2021-11-21 | Unknown | Oklahoma | 2117 | 0 | |
1933746 | 1933746 | 2021-11-20 | Little River | Arkansas | 5081 | 2117 | 80 |
1934557 | 1934557 | 2021-11-20 | Nemaha | Kansas | 20131 | 2117 | 56 |
1935818 | 1935818 | 2021-11-20 | Unknown | Oklahoma | 2117 | 0 | |
1930494 | 1930494 | 2021-11-19 | Little River | Arkansas | 5081 | 2117 | 80 |
1931306 | 1931306 | 2021-11-19 | Nemaha | Kansas | 20131 | 2117 | 56 |
1932568 | 1932568 | 2021-11-19 | Unknown | Oklahoma | 2117 | 0 | |
1919310 | 1919310 | 2021-11-15 | Mitchell | North Carolina | 37121 | 2117 | 21 |
1915565 | 1915565 | 2021-11-14 | Perry | Mississippi | 28111 | 2117 | 56 |
1912315 | 1912315 | 2021-11-13 | Perry | Mississippi | 28111 | 2117 | 56 |
1909065 | 1909065 | 2021-11-12 | Perry | Mississippi | 28111 | 2117 | 56 |
1899206 | 1899206 | 2021-11-09 | Kanabec | Minnesota | 27065 | 2117 | 31 |
1895794 | 1895794 | 2021-11-08 | Sagadahoc | Maine | 23023 | 2117 | 13 |
1892544 | 1892544 | 2021-11-07 | Sagadahoc | Maine | 23023 | 2117 | 13 |
1889294 | 1889294 | 2021-11-06 | Sagadahoc | Maine | 23023 | 2117 | 13 |
1868483 | 1868483 | 2021-10-30 | Morgan | West Virginia | 54065 | 2117 | 44 |
1832301 | 1832301 | 2021-10-19 | Eastland | Texas | 48133 | 2117 | 76 |
1826516 | 1826516 | 2021-10-18 | Marion | Arkansas | 5089 | 2117 | 57 |
1822156 | 1822156 | 2021-10-16 | Fulton | Pennsylvania | 42057 | 2117 | 26 |
1823082 | 1823082 | 2021-10-16 | Washburn | Wisconsin | 55129 | 2117 | 26 |
1819833 | 1819833 | 2021-10-15 | Washburn | Wisconsin | 55129 | 2117 | 26 |
1815786 | 1815786 | 2021-10-14 | Bamberg | South Carolina | 45009 | 2117 | 63 |
1816584 | 1816584 | 2021-10-14 | Washburn | Wisconsin | 55129 | 2117 | 26 |
1806093 | 1806093 | 2021-10-11 | Clay | South Dakota | 46027 | 2117 | 18 |
1800405 | 1800405 | 2021-10-10 | Lamar | Alabama | 1075 | 2117 | 45 |
1802843 | 1802843 | 2021-10-10 | Clay | South Dakota | 46027 | 2117 | 18 |
1799594 | 1799594 | 2021-10-09 | Clay | South Dakota | 46027 | 2117 | 18 |
1796345 | 1796345 | 2021-10-08 | Clay | South Dakota | 46027 | 2117 | 18 |
1787872 | 1787872 | 2021-10-06 | Oglethorpe | Georgia | 13221 | 2117 | 38 |
1789961 | 1789961 | 2021-10-06 | Meigs | Tennessee | 47121 | 2117 | 27 |
1782699 | 1782699 | 2021-10-04 | Grant | New Mexico | 35017 | 2117 | 48 |
1779061 | 1779061 | 2021-10-03 | Greene | Mississippi | 28041 | 2117 | 47 |
1775811 | 1775811 | 2021-10-02 | Greene | Mississippi | 28041 | 2117 | 47 |
1772561 | 1772561 | 2021-10-01 | Greene | Mississippi | 28041 | 2117 | 47 |
1762510 | 1762510 | 2021-09-28 | Caldwell | Louisiana | 22021 | 2117 | 38 |
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);