ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where cases = 1680 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 23
- Missouri 21
- Arkansas 14
- Georgia 13
- North Carolina 13
- Tennessee 13
- Iowa 11
- Michigan 11
- Kansas 10
- Kentucky 10
- Puerto Rico 10
- Mississippi 9
- Virginia 9
- Alabama 8
- Minnesota 7
- Illinois 6
- Indiana 6
- New York 6
- Colorado 5
- Florida 5
- Wisconsin 5
- Oklahoma 4
- Utah 4
- Montana 3
- Ohio 3
- Louisiana 2
- Maine 2
- Nebraska 2
- New Mexico 2
- North Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421713 | 2421713 | 2022-04-19 | Rio Blanco | Colorado | 8103 | 1680 | 13 |
2388389 | 2388389 | 2022-04-08 | Marion | Texas | 48315 | 1680 | 59 |
2325302 | 2325302 | 2022-03-20 | Caldwell | Missouri | 29025 | 1680 | 36 |
2322048 | 2322048 | 2022-03-19 | Caldwell | Missouri | 29025 | 1680 | 36 |
2318794 | 2318794 | 2022-03-18 | Caldwell | Missouri | 29025 | 1680 | 36 |
2315541 | 2315541 | 2022-03-17 | Caldwell | Missouri | 29025 | 1680 | 36 |
2312288 | 2312288 | 2022-03-16 | Caldwell | Missouri | 29025 | 1680 | 36 |
2302532 | 2302532 | 2022-03-13 | Caldwell | Missouri | 29025 | 1680 | 35 |
2299280 | 2299280 | 2022-03-12 | Caldwell | Missouri | 29025 | 1680 | 35 |
2296028 | 2296028 | 2022-03-11 | Caldwell | Missouri | 29025 | 1680 | 35 |
2292776 | 2292776 | 2022-03-10 | Caldwell | Missouri | 29025 | 1680 | 35 |
2257069 | 2257069 | 2022-02-27 | Ozark | Missouri | 29153 | 1680 | 53 |
2253818 | 2253818 | 2022-02-26 | Ozark | Missouri | 29153 | 1680 | 53 |
2250567 | 2250567 | 2022-02-25 | Ozark | Missouri | 29153 | 1680 | 53 |
2244247 | 2244247 | 2022-02-23 | Unknown | Nebraska | 1680 | 436 | |
2230729 | 2230729 | 2022-02-19 | Alcona | Michigan | 26001 | 1680 | 67 |
2227478 | 2227478 | 2022-02-18 | Alcona | Michigan | 26001 | 1680 | 67 |
2224227 | 2224227 | 2022-02-17 | Alcona | Michigan | 26001 | 1680 | 67 |
2220976 | 2220976 | 2022-02-16 | Alcona | Michigan | 26001 | 1680 | 67 |
2197455 | 2197455 | 2022-02-09 | Miller | Georgia | 13201 | 1680 | 26 |
2156612 | 2156612 | 2022-01-27 | Gates | North Carolina | 37073 | 1680 | 19 |
2145192 | 2145192 | 2022-01-24 | Lake | Colorado | 8065 | 1680 | 2 |
2145460 | 2145460 | 2022-01-24 | Wilcox | Georgia | 13315 | 1680 | 61 |
2125339 | 2125339 | 2022-01-17 | Pepin | Wisconsin | 55091 | 1680 | 16 |
2111609 | 2111609 | 2022-01-13 | Custer | South Dakota | 46033 | 1680 | 21 |
2106918 | 2106918 | 2022-01-12 | Gallatin | Kentucky | 21077 | 1680 | 44 |
2105642 | 2105642 | 2022-01-11 | Northumberland | Virginia | 51133 | 1680 | 39 |
2101087 | 2101087 | 2022-01-10 | Hamilton | Nebraska | 31081 | 1680 | 21 |
2088721 | 2088721 | 2022-01-06 | Ciales | Puerto Rico | 72039 | 1680 | |
2089033 | 2089033 | 2022-01-06 | Clay | Texas | 48077 | 1680 | 26 |
2080835 | 2080835 | 2022-01-04 | Pawnee | Kansas | 20145 | 1680 | 21 |
2077583 | 2077583 | 2022-01-03 | Pawnee | Kansas | 20145 | 1680 | 21 |
2053209 | 2053209 | 2021-12-26 | Perry | Tennessee | 47135 | 1680 | 41 |
2053609 | 2053609 | 2021-12-26 | Lexington city | Virginia | 51678 | 1680 | 37 |
2049959 | 2049959 | 2021-12-25 | Perry | Tennessee | 47135 | 1680 | 41 |
2050359 | 2050359 | 2021-12-25 | Lexington city | Virginia | 51678 | 1680 | 37 |
2046709 | 2046709 | 2021-12-24 | Perry | Tennessee | 47135 | 1680 | 41 |
2047109 | 2047109 | 2021-12-24 | Lexington city | Virginia | 51678 | 1680 | 37 |
2043459 | 2043459 | 2021-12-23 | Perry | Tennessee | 47135 | 1680 | 41 |
2039239 | 2039239 | 2021-12-22 | Deer Lodge | Montana | 30023 | 1680 | 28 |
2040567 | 2040567 | 2021-12-22 | Clarke | Virginia | 51043 | 1680 | 33 |
2034799 | 2034799 | 2021-12-21 | Dooly | Georgia | 13093 | 1680 | 62 |
1999184 | 1999184 | 2021-12-10 | Fremont | Idaho | 16043 | 1680 | 18 |
1967053 | 1967053 | 2021-11-30 | Linn | Kansas | 20107 | 1680 | 21 |
1963801 | 1963801 | 2021-11-29 | Linn | Kansas | 20107 | 1680 | 21 |
1926730 | 1926730 | 2021-11-17 | Emery | Utah | 49015 | 1680 | 23 |
1923480 | 1923480 | 2021-11-16 | Emery | Utah | 49015 | 1680 | 23 |
1916021 | 1916021 | 2021-11-14 | Clay | North Carolina | 37043 | 1680 | 36 |
1912771 | 1912771 | 2021-11-13 | Clay | North Carolina | 37043 | 1680 | 36 |
1909521 | 1909521 | 2021-11-12 | Clay | North Carolina | 37043 | 1680 | 36 |
1896254 | 1896254 | 2021-11-08 | Rosebud | Montana | 30087 | 1680 | 56 |
1879763 | 1879763 | 2021-11-03 | Yellow Medicine | Minnesota | 27173 | 1680 | 21 |
1874810 | 1874810 | 2021-11-01 | Dickenson | Virginia | 51051 | 1680 | 27 |
1853873 | 1853873 | 2021-10-26 | Cedar | Missouri | 29039 | 1680 | 30 |
1831453 | 1831453 | 2021-10-19 | Socorro | New Mexico | 35053 | 1680 | 62 |
1823247 | 1823247 | 2021-10-17 | Fulton | Arkansas | 5049 | 1680 | 62 |
1813531 | 1813531 | 2021-10-14 | Pike | Arkansas | 5109 | 1680 | 35 |
1816189 | 1816189 | 2021-10-14 | Runnels | Texas | 48399 | 1680 | 53 |
1794043 | 1794043 | 2021-10-08 | Scott | Arkansas | 5127 | 1680 | 26 |
1789379 | 1789379 | 2021-10-06 | Barnes | North Dakota | 38003 | 1680 | 32 |
1781941 | 1781941 | 2021-10-04 | Lee | Kentucky | 21129 | 1680 | 29 |
1762678 | 1762678 | 2021-09-28 | Missaukee | Michigan | 26113 | 1680 | 30 |
1759429 | 1759429 | 2021-09-27 | Missaukee | Michigan | 26113 | 1680 | 30 |
1748403 | 1748403 | 2021-09-24 | Coosa | Alabama | 1037 | 1680 | 33 |
1746333 | 1746333 | 2021-09-23 | Sagadahoc | Maine | 23023 | 1680 | 12 |
1741527 | 1741527 | 2021-09-21 | Juab | Utah | 49023 | 1680 | 16 |
1735917 | 1735917 | 2021-09-20 | Towns | Georgia | 13281 | 1680 | 70 |
1723579 | 1723579 | 2021-09-16 | Franklin | Maine | 23007 | 1680 | 17 |
1725622 | 1725622 | 2021-09-16 | Goshen | Wyoming | 56015 | 1680 | 27 |
1672528 | 1672528 | 2021-08-31 | Meigs | Ohio | 39105 | 1680 | 41 |
1664858 | 1664858 | 2021-08-29 | Jackson | Kansas | 20085 | 1680 | 18 |
1661610 | 1661610 | 2021-08-28 | Jackson | Kansas | 20085 | 1680 | 18 |
1657461 | 1657461 | 2021-08-27 | Lamar | Alabama | 1075 | 1680 | 38 |
1658362 | 1658362 | 2021-08-27 | Jackson | Kansas | 20085 | 1680 | 18 |
1659788 | 1659788 | 2021-08-27 | Hatillo | Puerto Rico | 72065 | 1680 | |
1654842 | 1654842 | 2021-08-26 | Mercer | Illinois | 17131 | 1680 | 34 |
1652398 | 1652398 | 2021-08-25 | Perry | Mississippi | 28111 | 1680 | 42 |
1650603 | 1650603 | 2021-08-24 | Windsor | Vermont | 50027 | 1680 | 14 |
1650841 | 1650841 | 2021-08-24 | Burnett | Wisconsin | 55013 | 1680 | 29 |
1633775 | 1633775 | 2021-08-19 | Cabo Rojo | Puerto Rico | 72023 | 1680 | |
1627286 | 1627286 | 2021-08-17 | Catano | Puerto Rico | 72033 | 1680 | |
1627942 | 1627942 | 2021-08-17 | Martinsville city | Virginia | 51690 | 1680 | 79 |
1614619 | 1614619 | 2021-08-13 | Comanche | Texas | 48093 | 1680 | 52 |
1606698 | 1606698 | 2021-08-11 | Antrim | Michigan | 26009 | 1680 | 31 |
1604543 | 1604543 | 2021-08-10 | Barranquitas | Puerto Rico | 72019 | 1680 | |
1587889 | 1587889 | 2021-08-05 | Currituck | North Carolina | 37053 | 1680 | 16 |
1584263 | 1584263 | 2021-08-04 | Linn | Missouri | 29115 | 1680 | 21 |
1584363 | 1584363 | 2021-08-04 | Roosevelt | Montana | 30085 | 1680 | 55 |
1579859 | 1579859 | 2021-08-03 | Bleckley | Georgia | 13023 | 1680 | 52 |
1580314 | 1580314 | 2021-08-03 | Madison | Iowa | 19121 | 1680 | 19 |
1577065 | 1577065 | 2021-08-02 | Madison | Iowa | 19121 | 1680 | 19 |
1573817 | 1573817 | 2021-08-01 | Madison | Iowa | 19121 | 1680 | 19 |
1570569 | 1570569 | 2021-07-31 | Madison | Iowa | 19121 | 1680 | 19 |
1567321 | 1567321 | 2021-07-30 | Madison | Iowa | 19121 | 1680 | 19 |
1564073 | 1564073 | 2021-07-29 | Madison | Iowa | 19121 | 1680 | 19 |
1560825 | 1560825 | 2021-07-28 | Madison | Iowa | 19121 | 1680 | 19 |
1538581 | 1538581 | 2021-07-21 | Cottonwood | Minnesota | 27033 | 1680 | 24 |
1536359 | 1536359 | 2021-07-20 | Isabela | Puerto Rico | 72071 | 1680 | |
1509587 | 1509587 | 2021-07-12 | Osage | Missouri | 29151 | 1680 | 16 |
1492186 | 1492186 | 2021-07-07 | Brantley | Georgia | 13025 | 1680 | 41 |
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);