ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
140 rows where cases = 4812 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 10
- Illinois 10
- Wisconsin 10
- Minnesota 9
- North Carolina 9
- Missouri 8
- Oklahoma 8
- Mississippi 7
- Texas 7
- Kansas 6
- Louisiana 6
- Ohio 6
- Indiana 4
- Michigan 4
- Arkansas 3
- Idaho 3
- Montana 3
- Puerto Rico 3
- South Carolina 3
- West Virginia 3
- Alabama 2
- New Mexico 2
- North Dakota 2
- California 1
- Florida 1
- Iowa 1
- Kentucky 1
- Maine 1
- Maryland 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2411812 | 2411812 | 2022-04-16 | Phillips | Arkansas | 5107 | 4812 | 99 |
2330261 | 2330261 | 2022-03-21 | Taylor | Wisconsin | 55119 | 4812 | 72 |
2327009 | 2327009 | 2022-03-20 | Taylor | Wisconsin | 55119 | 4812 | 72 |
2323756 | 2323756 | 2022-03-19 | Taylor | Wisconsin | 55119 | 4812 | 72 |
2320502 | 2320502 | 2022-03-18 | Taylor | Wisconsin | 55119 | 4812 | 72 |
2265721 | 2265721 | 2022-03-02 | Lamar | Georgia | 13171 | 4812 | 111 |
2237343 | 2237343 | 2022-02-21 | Hubbard | Minnesota | 27057 | 4812 | 56 |
2234092 | 2234092 | 2022-02-20 | Hubbard | Minnesota | 27057 | 4812 | 56 |
2230841 | 2230841 | 2022-02-19 | Hubbard | Minnesota | 27057 | 4812 | 56 |
2227590 | 2227590 | 2022-02-18 | Hubbard | Minnesota | 27057 | 4812 | 56 |
2223725 | 2223725 | 2022-02-17 | Jay | Indiana | 18075 | 4812 | 76 |
2218443 | 2218443 | 2022-02-15 | Madison | North Carolina | 37115 | 4812 | 78 |
2193860 | 2193860 | 2022-02-08 | Lincoln | Arkansas | 5079 | 4812 | 60 |
2195548 | 2195548 | 2022-02-08 | Roosevelt | New Mexico | 35041 | 4812 | 89 |
2190884 | 2190884 | 2022-02-07 | Cook | Georgia | 13075 | 4812 | 67 |
2166803 | 2166803 | 2022-01-30 | Hatillo | Puerto Rico | 72065 | 4812 | |
2155892 | 2155892 | 2022-01-27 | Somerset | Maryland | 24039 | 4812 | 66 |
2147681 | 2147681 | 2022-01-24 | Lampasas | Texas | 48281 | 4812 | 73 |
2129146 | 2129146 | 2022-01-19 | Pike | Georgia | 13231 | 4812 | 77 |
2097284 | 2097284 | 2022-01-09 | Plaquemines | Louisiana | 22075 | 4812 | 41 |
2094032 | 2094032 | 2022-01-08 | Plaquemines | Louisiana | 22075 | 4812 | 41 |
2090780 | 2090780 | 2022-01-07 | Plaquemines | Louisiana | 22075 | 4812 | 41 |
2080057 | 2080057 | 2022-01-04 | Calaveras | California | 6009 | 4812 | 93 |
2074966 | 2074966 | 2022-01-02 | Stoddard | Missouri | 29207 | 4812 | 110 |
2071715 | 2071715 | 2022-01-01 | Stoddard | Missouri | 29207 | 4812 | 110 |
2068464 | 2068464 | 2021-12-31 | Stoddard | Missouri | 29207 | 4812 | 110 |
2065213 | 2065213 | 2021-12-30 | Stoddard | Missouri | 29207 | 4812 | 110 |
2056936 | 2056936 | 2021-12-27 | Island | Washington | 53029 | 4812 | 55 |
2015574 | 2015574 | 2021-12-15 | Clay | Indiana | 18021 | 4812 | 65 |
2008943 | 2008943 | 2021-12-13 | Latah | Idaho | 16057 | 4812 | 41 |
1996477 | 1996477 | 2021-12-09 | Allen | Louisiana | 22003 | 4812 | 118 |
1997444 | 1997444 | 2021-12-09 | Gallia | Ohio | 39053 | 4812 | 79 |
1993226 | 1993226 | 2021-12-08 | Allen | Louisiana | 22003 | 4812 | 118 |
1989038 | 1989038 | 2021-12-07 | Yell | Arkansas | 5149 | 4812 | 84 |
1990187 | 1990187 | 2021-12-07 | Brown | Minnesota | 27015 | 4812 | 62 |
1974420 | 1974420 | 2021-12-02 | Cibola | New Mexico | 35006 | 4812 | 149 |
1970147 | 1970147 | 2021-12-01 | Wells | Indiana | 18179 | 4812 | 105 |
1960522 | 1960522 | 2021-11-28 | Ellis | Kansas | 20051 | 4812 | 75 |
1957271 | 1957271 | 2021-11-27 | Ellis | Kansas | 20051 | 4812 | 75 |
1958435 | 1958435 | 2021-11-27 | Fayette | Ohio | 39047 | 4812 | 70 |
1954020 | 1954020 | 2021-11-26 | Ellis | Kansas | 20051 | 4812 | 75 |
1950769 | 1950769 | 2021-11-25 | Ellis | Kansas | 20051 | 4812 | 76 |
1947518 | 1947518 | 2021-11-24 | Ellis | Kansas | 20051 | 4812 | 76 |
1943796 | 1943796 | 2021-11-23 | Gilmer | Georgia | 13123 | 4812 | 137 |
1939305 | 1939305 | 2021-11-21 | Union | South Carolina | 45087 | 4812 | 106 |
1936055 | 1936055 | 2021-11-20 | Union | South Carolina | 45087 | 4812 | 106 |
1932805 | 1932805 | 2021-11-19 | Union | South Carolina | 45087 | 4812 | 106 |
1920151 | 1920151 | 2021-11-15 | Palo Pinto | Texas | 48363 | 4812 | 120 |
1915579 | 1915579 | 2021-11-14 | Tippah | Mississippi | 28139 | 4812 | 81 |
1916901 | 1916901 | 2021-11-14 | Palo Pinto | Texas | 48363 | 4812 | 120 |
1912329 | 1912329 | 2021-11-13 | Tippah | Mississippi | 28139 | 4812 | 81 |
1913651 | 1913651 | 2021-11-13 | Palo Pinto | Texas | 48363 | 4812 | 120 |
1913972 | 1913972 | 2021-11-13 | Mineral | West Virginia | 54057 | 4812 | 117 |
1909079 | 1909079 | 2021-11-12 | Tippah | Mississippi | 28139 | 4812 | 81 |
1898280 | 1898280 | 2021-11-09 | Decatur | Georgia | 13087 | 4812 | 101 |
1899045 | 1899045 | 2021-11-09 | Somerset | Maine | 23025 | 4812 | 54 |
1894608 | 1894608 | 2021-11-08 | Clarke | Alabama | 1025 | 4812 | 86 |
1824767 | 1824767 | 2021-10-17 | Ravalli | Montana | 30081 | 4812 | 65 |
1821518 | 1821518 | 2021-10-16 | Ravalli | Montana | 30081 | 4812 | 65 |
1818269 | 1818269 | 2021-10-15 | Ravalli | Montana | 30081 | 4812 | 65 |
1805719 | 1805719 | 2021-10-11 | Jackson | Ohio | 39079 | 4812 | 68 |
1765282 | 1765282 | 2021-09-29 | Logan | Illinois | 17107 | 4812 | 87 |
1759505 | 1759505 | 2021-09-27 | Morrison | Minnesota | 27097 | 4812 | 63 |
1736972 | 1736972 | 2021-09-20 | Pulaski | Missouri | 29169 | 4812 | 69 |
1737172 | 1737172 | 2021-09-20 | Cheshire | New Hampshire | 33005 | 4812 | 43 |
1710755 | 1710755 | 2021-09-12 | Isanti | Minnesota | 27059 | 4812 | 70 |
1707508 | 1707508 | 2021-09-11 | Isanti | Minnesota | 27059 | 4812 | 70 |
1704261 | 1704261 | 2021-09-10 | Isanti | Minnesota | 27059 | 4812 | 70 |
1690444 | 1690444 | 2021-09-06 | Upson | Georgia | 13293 | 4812 | 137 |
1691181 | 1691181 | 2021-09-06 | Hillsdale | Michigan | 26059 | 4812 | 100 |
1691823 | 1691823 | 2021-09-06 | Bladen | North Carolina | 37017 | 4812 | 78 |
1687194 | 1687194 | 2021-09-05 | Upson | Georgia | 13293 | 4812 | 137 |
1687931 | 1687931 | 2021-09-05 | Hillsdale | Michigan | 26059 | 4812 | 100 |
1688573 | 1688573 | 2021-09-05 | Bladen | North Carolina | 37017 | 4812 | 78 |
1683944 | 1683944 | 2021-09-04 | Upson | Georgia | 13293 | 4812 | 137 |
1684681 | 1684681 | 2021-09-04 | Hillsdale | Michigan | 26059 | 4812 | 100 |
1685323 | 1685323 | 2021-09-04 | Bladen | North Carolina | 37017 | 4812 | 78 |
1680693 | 1680693 | 2021-09-03 | Upson | Georgia | 13293 | 4812 | 137 |
1681430 | 1681430 | 2021-09-03 | Hillsdale | Michigan | 26059 | 4812 | 100 |
1682072 | 1682072 | 2021-09-03 | Bladen | North Carolina | 37017 | 4812 | 78 |
1650543 | 1650543 | 2021-08-24 | Washington | Texas | 48477 | 4812 | 102 |
1645982 | 1645982 | 2021-08-23 | Laclede | Missouri | 29105 | 4812 | 98 |
1643246 | 1643246 | 2021-08-22 | Ashland | Ohio | 39005 | 4812 | 101 |
1620350 | 1620350 | 2021-08-15 | Alexander | North Carolina | 37003 | 4812 | 85 |
1617102 | 1617102 | 2021-08-14 | Alexander | North Carolina | 37003 | 4812 | 85 |
1613854 | 1613854 | 2021-08-13 | Alexander | North Carolina | 37003 | 4812 | 85 |
1602931 | 1602931 | 2021-08-10 | Gibson | Indiana | 18051 | 4812 | 100 |
1580926 | 1580926 | 2021-08-03 | Panola | Mississippi | 28107 | 4812 | 112 |
1555610 | 1555610 | 2021-07-26 | Shelby | Ohio | 39149 | 4812 | 97 |
1538831 | 1538831 | 2021-07-21 | Scott | Missouri | 29201 | 4812 | 88 |
1540025 | 1540025 | 2021-07-21 | Medina | Texas | 48325 | 4812 | 107 |
1533143 | 1533143 | 2021-07-19 | Toa Alta | Puerto Rico | 72135 | 4812 | |
1520871 | 1520871 | 2021-07-15 | Jefferson | West Virginia | 54037 | 4812 | 60 |
1517623 | 1517623 | 2021-07-14 | Jefferson | West Virginia | 54037 | 4812 | 60 |
1507733 | 1507733 | 2021-07-11 | Fauquier | Virginia | 51061 | 4812 | 69 |
1490741 | 1490741 | 2021-07-06 | Osage | Oklahoma | 40113 | 4812 | 80 |
1490780 | 1490780 | 2021-07-06 | Klamath | Oregon | 41035 | 4812 | 78 |
1485945 | 1485945 | 2021-07-05 | Macoupin | Illinois | 17117 | 4812 | 118 |
1487494 | 1487494 | 2021-07-05 | Osage | Oklahoma | 40113 | 4812 | 80 |
1482699 | 1482699 | 2021-07-04 | Macoupin | Illinois | 17117 | 4812 | 118 |
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);