ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
275 rows where cases = 1858 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 29
- Texas 23
- Virginia 20
- Georgia 16
- Alabama 15
- Florida 15
- Tennessee 14
- Missouri 11
- Indiana 10
- Michigan 9
- Minnesota 9
- Arkansas 8
- Wisconsin 8
- Pennsylvania 7
- Puerto Rico 7
- Mississippi 6
- Colorado 5
- New Mexico 5
- Ohio 5
- Oregon 5
- Illinois 4
- Louisiana 4
- Nebraska 4
- Oklahoma 4
- Kentucky 3
- North Carolina 3
- South Carolina 3
- Wyoming 3
- California 2
- Massachusetts 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486301 | 2486301 | 2022-05-08 | Middlesex | Virginia | 51119 | 1858 | 48 |
2483043 | 2483043 | 2022-05-07 | Middlesex | Virginia | 51119 | 1858 | 48 |
2479785 | 2479785 | 2022-05-06 | Middlesex | Virginia | 51119 | 1858 | 48 |
2400971 | 2400971 | 2022-04-12 | Arroyo | Puerto Rico | 72015 | 1858 | |
2330604 | 2330604 | 2022-03-22 | Yuma | Colorado | 8125 | 1858 | 23 |
2308769 | 2308769 | 2022-03-15 | Alger | Michigan | 26003 | 1858 | 13 |
2305518 | 2305518 | 2022-03-14 | Alger | Michigan | 26003 | 1858 | 13 |
2302266 | 2302266 | 2022-03-13 | Alger | Michigan | 26003 | 1858 | 13 |
2299014 | 2299014 | 2022-03-12 | Alger | Michigan | 26003 | 1858 | 13 |
2295762 | 2295762 | 2022-03-11 | Alger | Michigan | 26003 | 1858 | 13 |
2288044 | 2288044 | 2022-03-09 | Greene | Alabama | 1063 | 1858 | 48 |
2270152 | 2270152 | 2022-03-03 | Powell | Montana | 30077 | 1858 | 28 |
2198132 | 2198132 | 2022-02-09 | St. Helena | Louisiana | 22091 | 1858 | 22 |
2187214 | 2187214 | 2022-02-06 | Choctaw | Alabama | 1023 | 1858 | 33 |
2183961 | 2183961 | 2022-02-05 | Choctaw | Alabama | 1023 | 1858 | 33 |
2155455 | 2155455 | 2022-01-27 | Union | Indiana | 18161 | 1858 | 21 |
2153015 | 2153015 | 2022-01-26 | St. Clair | Missouri | 29185 | 1858 | 29 |
2153252 | 2153252 | 2022-01-26 | Quay | New Mexico | 35037 | 1858 | 37 |
2147284 | 2147284 | 2022-01-24 | Jayuya | Puerto Rico | 72073 | 1858 | |
2126956 | 2126956 | 2022-01-18 | Monroe | Missouri | 29137 | 1858 | 37 |
2122654 | 2122654 | 2022-01-17 | Stewart | Georgia | 13259 | 1858 | 30 |
2101776 | 2101776 | 2022-01-10 | Santa Isabel | Puerto Rico | 72133 | 1858 | |
2102229 | 2102229 | 2022-01-10 | Trinity | Texas | 48455 | 1858 | 64 |
2086543 | 2086543 | 2022-01-06 | Scott | Arkansas | 5127 | 1858 | 34 |
2082839 | 2082839 | 2022-01-04 | Franklin city | Virginia | 51620 | 1858 | 44 |
2063970 | 2063970 | 2021-12-30 | Liberty | Florida | 12077 | 1858 | 25 |
2060720 | 2060720 | 2021-12-29 | Liberty | Florida | 12077 | 1858 | 25 |
2060874 | 2060874 | 2021-12-29 | Screven | Georgia | 13251 | 1858 | 62 |
2057471 | 2057471 | 2021-12-28 | Liberty | Florida | 12077 | 1858 | 25 |
2054222 | 2054222 | 2021-12-27 | Liberty | Florida | 12077 | 1858 | 25 |
2050972 | 2050972 | 2021-12-26 | Liberty | Florida | 12077 | 1858 | 25 |
2047722 | 2047722 | 2021-12-25 | Liberty | Florida | 12077 | 1858 | 25 |
2044472 | 2044472 | 2021-12-24 | Liberty | Florida | 12077 | 1858 | 25 |
2041155 | 2041155 | 2021-12-23 | Park | Colorado | 8093 | 1858 | 14 |
2034361 | 2034361 | 2021-12-20 | Washakie | Wyoming | 56043 | 1858 | 37 |
2030209 | 2030209 | 2021-12-19 | Camuy | Puerto Rico | 72027 | 1858 | |
1995022 | 1995022 | 2021-12-08 | Orange | Vermont | 50017 | 1858 | 7 |
1989714 | 1989714 | 2021-12-07 | Mitchell | Iowa | 19131 | 1858 | 43 |
1986464 | 1986464 | 2021-12-06 | Mitchell | Iowa | 19131 | 1858 | 43 |
1987230 | 1987230 | 2021-12-06 | Fergus | Montana | 30027 | 1858 | 48 |
1983214 | 1983214 | 2021-12-05 | Mitchell | Iowa | 19131 | 1858 | 43 |
1983907 | 1983907 | 2021-12-05 | Lewis | Missouri | 29111 | 1858 | 30 |
1979964 | 1979964 | 2021-12-04 | Mitchell | Iowa | 19131 | 1858 | 43 |
1975870 | 1975870 | 2021-12-03 | Coosa | Alabama | 1037 | 1858 | 47 |
1976714 | 1976714 | 2021-12-03 | Mitchell | Iowa | 19131 | 1858 | 43 |
1973465 | 1973465 | 2021-12-02 | Mitchell | Iowa | 19131 | 1858 | 43 |
1970215 | 1970215 | 2021-12-01 | Mitchell | Iowa | 19131 | 1858 | 43 |
1967922 | 1967922 | 2021-11-30 | Colfax | New Mexico | 35007 | 1858 | 52 |
1948487 | 1948487 | 2021-11-24 | Schuyler | New York | 36097 | 1858 | 20 |
1940186 | 1940186 | 2021-11-22 | Valdez-Cordova Census Area | Alaska | 2261 | 1858 | 9 |
1930251 | 1930251 | 2021-11-18 | Bayfield | Wisconsin | 55007 | 1858 | 25 |
1905733 | 1905733 | 2021-11-11 | Pope | Minnesota | 27121 | 1858 | 10 |
1887750 | 1887750 | 2021-11-05 | Unknown | Utah | 1858 | 41 | |
1881868 | 1881868 | 2021-11-04 | Gunnison | Colorado | 8051 | 1858 | 12 |
1883154 | 1883154 | 2021-11-04 | Linn | Missouri | 29115 | 1858 | 27 |
1859135 | 1859135 | 2021-10-28 | Las Animas | Colorado | 8071 | 1858 | 22 |
1856837 | 1856837 | 2021-10-27 | Dukes | Massachusetts | 25007 | 1858 | 0 |
1836125 | 1836125 | 2021-10-21 | Conecuh | Alabama | 1035 | 1858 | 53 |
1837130 | 1837130 | 2021-10-21 | Carroll | Kentucky | 21041 | 1858 | 26 |
1833298 | 1833298 | 2021-10-20 | Early | Georgia | 13099 | 1858 | 57 |
1830688 | 1830688 | 2021-10-19 | Martin | Kentucky | 21159 | 1858 | 35 |
1824451 | 1824451 | 2021-10-17 | Chippewa | Minnesota | 27023 | 1858 | 39 |
1821202 | 1821202 | 2021-10-16 | Chippewa | Minnesota | 27023 | 1858 | 39 |
1817953 | 1817953 | 2021-10-15 | Chippewa | Minnesota | 27023 | 1858 | 39 |
1795460 | 1795460 | 2021-10-08 | Ripley | Missouri | 29181 | 1858 | 23 |
1790599 | 1790599 | 2021-10-06 | Big Horn | Wyoming | 56003 | 1858 | 40 |
1771109 | 1771109 | 2021-09-30 | Goshen | Wyoming | 56015 | 1858 | 29 |
1736796 | 1736796 | 2021-09-20 | Wadena | Minnesota | 27159 | 1858 | 26 |
1727990 | 1727990 | 2021-09-17 | Cidra | Puerto Rico | 72041 | 1858 | |
1704766 | 1704766 | 2021-09-10 | Essex | New York | 36031 | 1858 | 29 |
1705252 | 1705252 | 2021-09-10 | Catano | Puerto Rico | 72033 | 1858 | |
1696167 | 1696167 | 2021-09-07 | New Kent | Virginia | 51127 | 1858 | 19 |
1679144 | 1679144 | 2021-09-02 | Crook | Oregon | 41013 | 1858 | 32 |
1679485 | 1679485 | 2021-09-02 | Lake | Tennessee | 47095 | 1858 | 31 |
1673844 | 1673844 | 2021-09-01 | Van Buren | Arkansas | 5141 | 1858 | 34 |
1674093 | 1674093 | 2021-09-01 | Dade | Georgia | 13083 | 1858 | 15 |
1672646 | 1672646 | 2021-08-31 | Clatsop | Oregon | 41007 | 1858 | 11 |
1667837 | 1667837 | 2021-08-30 | Moultrie | Illinois | 17139 | 1858 | 37 |
1655565 | 1655565 | 2021-08-26 | Redwood | Minnesota | 27127 | 1858 | 41 |
1634725 | 1634725 | 2021-08-20 | Macon | Alabama | 1087 | 1858 | 54 |
1632689 | 1632689 | 2021-08-19 | Charlevoix | Michigan | 26029 | 1858 | 26 |
1630434 | 1630434 | 2021-08-18 | Lincoln | Oregon | 41041 | 1858 | 23 |
1625185 | 1625185 | 2021-08-17 | Alamosa | Colorado | 8003 | 1858 | 39 |
1620975 | 1620975 | 2021-08-15 | Benton | Tennessee | 47005 | 1858 | 41 |
1617727 | 1617727 | 2021-08-14 | Benton | Tennessee | 47005 | 1858 | 41 |
1614479 | 1614479 | 2021-08-13 | Benton | Tennessee | 47005 | 1858 | 41 |
1610611 | 1610611 | 2021-08-12 | Bertie | North Carolina | 37015 | 1858 | 45 |
1599596 | 1599596 | 2021-08-09 | Jo Daviess | Illinois | 17085 | 1858 | 27 |
1600950 | 1600950 | 2021-08-09 | Warren | North Carolina | 37185 | 1858 | 20 |
1586299 | 1586299 | 2021-08-05 | Gilchrist | Florida | 12041 | 1858 | 44 |
1583049 | 1583049 | 2021-08-04 | Gilchrist | Florida | 12041 | 1858 | 44 |
1584189 | 1584189 | 2021-08-04 | Tallahatchie | Mississippi | 28135 | 1858 | 42 |
1579799 | 1579799 | 2021-08-03 | Gilchrist | Florida | 12041 | 1858 | 44 |
1576551 | 1576551 | 2021-08-02 | Gilchrist | Florida | 12041 | 1858 | 44 |
1578037 | 1578037 | 2021-08-02 | Lincoln | New Mexico | 35027 | 1858 | 20 |
1573303 | 1573303 | 2021-08-01 | Gilchrist | Florida | 12041 | 1858 | 44 |
1575329 | 1575329 | 2021-08-01 | Isabela | Puerto Rico | 72071 | 1858 | |
1570055 | 1570055 | 2021-07-31 | Gilchrist | Florida | 12041 | 1858 | 44 |
1566807 | 1566807 | 2021-07-30 | Gilchrist | Florida | 12041 | 1858 | 44 |
1533369 | 1533369 | 2021-07-19 | Andrews | Texas | 48003 | 1858 | 47 |
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);