ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
296 rows where cases = 2139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 24
- Virginia 24
- Wisconsin 23
- Georgia 19
- Texas 16
- Indiana 13
- Arkansas 12
- Michigan 12
- North Carolina 12
- Mississippi 11
- Pennsylvania 11
- Montana 10
- South Dakota 9
- Illinois 8
- Missouri 8
- Kansas 7
- Minnesota 6
- Nebraska 6
- Puerto Rico 6
- Tennessee 6
- Alabama 5
- Washington 5
- Wyoming 5
- Colorado 4
- Iowa 4
- West Virginia 4
- Florida 3
- Idaho 3
- Louisiana 3
- Ohio 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497287 | 2497287 | 2022-05-12 | Pawnee | Kansas | 20145 | 2139 | 24 |
2494029 | 2494029 | 2022-05-11 | Pawnee | Kansas | 20145 | 2139 | 24 |
2490771 | 2490771 | 2022-05-10 | Pawnee | Kansas | 20145 | 2139 | 24 |
2487514 | 2487514 | 2022-05-09 | Pawnee | Kansas | 20145 | 2139 | 24 |
2484256 | 2484256 | 2022-05-08 | Pawnee | Kansas | 20145 | 2139 | 24 |
2480998 | 2480998 | 2022-05-07 | Pawnee | Kansas | 20145 | 2139 | 24 |
2477740 | 2477740 | 2022-05-06 | Pawnee | Kansas | 20145 | 2139 | 24 |
2423792 | 2423792 | 2022-04-19 | Jayuya | Puerto Rico | 72073 | 2139 | |
2420536 | 2420536 | 2022-04-18 | Jayuya | Puerto Rico | 72073 | 2139 | |
2362287 | 2362287 | 2022-03-31 | Gaines | Texas | 48165 | 2139 | 83 |
2359033 | 2359033 | 2022-03-30 | Gaines | Texas | 48165 | 2139 | 83 |
2351175 | 2351175 | 2022-03-28 | Jackson | Minnesota | 27063 | 2139 | 17 |
2352592 | 2352592 | 2022-03-28 | Live Oak | Texas | 48297 | 2139 | 42 |
2349340 | 2349340 | 2022-03-27 | Live Oak | Texas | 48297 | 2139 | 42 |
2346087 | 2346087 | 2022-03-26 | Live Oak | Texas | 48297 | 2139 | 41 |
2331956 | 2331956 | 2022-03-22 | Sanders | Montana | 30089 | 2139 | 46 |
2328703 | 2328703 | 2022-03-21 | Sanders | Montana | 30089 | 2139 | 46 |
2310635 | 2310635 | 2022-03-15 | Doddridge | West Virginia | 54017 | 2139 | 18 |
2302134 | 2302134 | 2022-03-13 | Trimble | Kentucky | 21223 | 2139 | 39 |
2302737 | 2302737 | 2022-03-13 | Holt | Nebraska | 31089 | 2139 | 18 |
2298882 | 2298882 | 2022-03-12 | Trimble | Kentucky | 21223 | 2139 | 39 |
2299485 | 2299485 | 2022-03-12 | Holt | Nebraska | 31089 | 2139 | 18 |
2295630 | 2295630 | 2022-03-11 | Trimble | Kentucky | 21223 | 2139 | 39 |
2296233 | 2296233 | 2022-03-11 | Holt | Nebraska | 31089 | 2139 | 18 |
2292378 | 2292378 | 2022-03-10 | Trimble | Kentucky | 21223 | 2139 | 39 |
2289126 | 2289126 | 2022-03-09 | Trimble | Kentucky | 21223 | 2139 | 39 |
2285875 | 2285875 | 2022-03-08 | Trimble | Kentucky | 21223 | 2139 | 39 |
2282623 | 2282623 | 2022-03-07 | Trimble | Kentucky | 21223 | 2139 | 39 |
2266276 | 2266276 | 2022-03-02 | Cumberland | Kentucky | 21057 | 2139 | 28 |
2248756 | 2248756 | 2022-02-24 | Northumberland | Virginia | 51133 | 2139 | 43 |
2239398 | 2239398 | 2022-02-22 | Nevada | Arkansas | 5099 | 2139 | 44 |
2236147 | 2236147 | 2022-02-21 | Nevada | Arkansas | 5099 | 2139 | 44 |
2236566 | 2236566 | 2022-02-21 | Fremont | Idaho | 16043 | 2139 | 24 |
2232896 | 2232896 | 2022-02-20 | Nevada | Arkansas | 5099 | 2139 | 44 |
2233315 | 2233315 | 2022-02-20 | Fremont | Idaho | 16043 | 2139 | 24 |
2230064 | 2230064 | 2022-02-19 | Fremont | Idaho | 16043 | 2139 | 24 |
2216996 | 2216996 | 2022-02-15 | Seminole | Georgia | 13253 | 2139 | 28 |
2200974 | 2200974 | 2022-02-10 | Martin | Indiana | 18101 | 2139 | 24 |
2194961 | 2194961 | 2022-02-08 | Baraga | Michigan | 26013 | 2139 | 53 |
2191707 | 2191707 | 2022-02-07 | Baraga | Michigan | 26013 | 2139 | 53 |
2180412 | 2180412 | 2022-02-03 | Essex | Virginia | 51057 | 2139 | 23 |
2175709 | 2175709 | 2022-02-02 | Carroll | Missouri | 29033 | 2139 | 42 |
2173753 | 2173753 | 2022-02-01 | Parmer | Texas | 48369 | 2139 | 46 |
2164557 | 2164557 | 2022-01-30 | Cleveland | Arkansas | 5025 | 2139 | 33 |
2161302 | 2161302 | 2022-01-29 | Cleveland | Arkansas | 5025 | 2139 | 33 |
2158046 | 2158046 | 2022-01-28 | Cleveland | Arkansas | 5025 | 2139 | 33 |
2160752 | 2160752 | 2022-01-28 | Runnels | Texas | 48399 | 2139 | 60 |
2152464 | 2152464 | 2022-01-26 | Hancock | Kentucky | 21091 | 2139 | 19 |
2146524 | 2146524 | 2022-01-24 | Wayne | Missouri | 29223 | 2139 | 42 |
2138407 | 2138407 | 2022-01-22 | Bullock | Alabama | 1011 | 2139 | 46 |
2087443 | 2087443 | 2022-01-06 | Lyon | Kentucky | 21143 | 2139 | 30 |
2059582 | 2059582 | 2021-12-28 | Butte | South Dakota | 46019 | 2139 | 39 |
2039024 | 2039024 | 2021-12-22 | Watonwan | Minnesota | 27165 | 2139 | 21 |
2039203 | 2039203 | 2021-12-22 | Ripley | Missouri | 29181 | 2139 | 50 |
2010202 | 2010202 | 2021-12-13 | Torrance | New Mexico | 35057 | 2139 | 26 |
1986616 | 1986616 | 2021-12-06 | Breathitt | Kentucky | 21025 | 2139 | 41 |
1987594 | 1987594 | 2021-12-06 | Swain | North Carolina | 37173 | 2139 | 28 |
1973855 | 1973855 | 2021-12-02 | Benzie | Michigan | 26019 | 2139 | 45 |
1970606 | 1970606 | 2021-12-01 | Benzie | Michigan | 26019 | 2139 | 45 |
1952826 | 1952826 | 2021-11-25 | Goochland | Virginia | 51075 | 2139 | 31 |
1943977 | 1943977 | 2021-11-23 | Greene | Illinois | 17061 | 2139 | 53 |
1945603 | 1945603 | 2021-11-23 | Tillamook | Oregon | 41057 | 2139 | 43 |
1906002 | 1906002 | 2021-11-11 | Roosevelt | Montana | 30085 | 2139 | 60 |
1902753 | 1902753 | 2021-11-10 | Roosevelt | Montana | 30085 | 2139 | 60 |
1895263 | 1895263 | 2021-11-08 | Mercer | Illinois | 17131 | 2139 | 37 |
1854965 | 1854965 | 2021-10-26 | Stewart | Tennessee | 47161 | 2139 | 35 |
1839338 | 1839338 | 2021-10-21 | Converse | Wyoming | 56009 | 2139 | 32 |
1812592 | 1812592 | 2021-10-13 | Clay | South Dakota | 46027 | 2139 | 18 |
1785613 | 1785613 | 2021-10-05 | Walthall | Mississippi | 28147 | 2139 | 62 |
1786482 | 1786482 | 2021-10-05 | Fajardo | Puerto Rico | 72053 | 2139 | |
1783233 | 1783233 | 2021-10-04 | Fajardo | Puerto Rico | 72053 | 2139 | |
1768963 | 1768963 | 2021-09-30 | Monroe | Kentucky | 21171 | 2139 | 56 |
1770818 | 1770818 | 2021-09-30 | Buchanan | Virginia | 51027 | 2139 | 49 |
1746289 | 1746289 | 2021-09-23 | Madison | Louisiana | 22065 | 2139 | 51 |
1744000 | 1744000 | 2021-09-22 | Meigs | Ohio | 39105 | 2139 | 42 |
1731765 | 1731765 | 2021-09-18 | Zapata | Texas | 48505 | 2139 | 40 |
1725626 | 1725626 | 2021-09-16 | Lincoln | Wyoming | 56023 | 2139 | 14 |
1716955 | 1716955 | 2021-09-14 | Larue | Kentucky | 21123 | 2139 | 30 |
1655452 | 1655452 | 2021-08-26 | Iosco | Michigan | 26069 | 2139 | 78 |
1651219 | 1651219 | 2021-08-25 | Otero | Colorado | 8089 | 2139 | 68 |
1652205 | 1652205 | 2021-08-25 | Iosco | Michigan | 26069 | 2139 | 78 |
1632130 | 1632130 | 2021-08-19 | Wayne | Illinois | 17191 | 2139 | 55 |
1625395 | 1625395 | 2021-08-17 | Greene | Georgia | 13133 | 2139 | 64 |
1623195 | 1623195 | 2021-08-16 | Benton | Missouri | 29015 | 2139 | 37 |
1624469 | 1624469 | 2021-08-16 | Madison | Texas | 48313 | 2139 | 31 |
1608450 | 1608450 | 2021-08-11 | Louisa | Virginia | 51109 | 2139 | 34 |
1602930 | 1602930 | 2021-08-10 | Fulton | Indiana | 18049 | 2139 | 46 |
1604715 | 1604715 | 2021-08-10 | Oglala Lakota | South Dakota | 46102 | 2139 | 49 |
1601466 | 1601466 | 2021-08-09 | Oglala Lakota | South Dakota | 46102 | 2139 | 49 |
1598060 | 1598060 | 2021-08-08 | Corozal | Puerto Rico | 72047 | 2139 | |
1598218 | 1598218 | 2021-08-08 | Oglala Lakota | South Dakota | 46102 | 2139 | 49 |
1594969 | 1594969 | 2021-08-07 | Oglala Lakota | South Dakota | 46102 | 2139 | 49 |
1591720 | 1591720 | 2021-08-06 | Oglala Lakota | South Dakota | 46102 | 2139 | 49 |
1587352 | 1587352 | 2021-08-05 | Roseau | Minnesota | 27135 | 2139 | 21 |
1588471 | 1588471 | 2021-08-05 | Oglala Lakota | South Dakota | 46102 | 2139 | 49 |
1585221 | 1585221 | 2021-08-04 | Oglala Lakota | South Dakota | 46102 | 2139 | 49 |
1585405 | 1585405 | 2021-08-04 | Falls | Texas | 48145 | 2139 | 33 |
1572995 | 1572995 | 2021-08-01 | Henry | Alabama | 1067 | 2139 | 45 |
1573564 | 1573564 | 2021-08-01 | Bond | Illinois | 17005 | 2139 | 29 |
1570316 | 1570316 | 2021-07-31 | Bond | Illinois | 17005 | 2139 | 29 |
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);