ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
250 rows where cases = 2283 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 22
- Georgia 19
- Missouri 18
- Virginia 16
- Alabama 15
- Puerto Rico 15
- Iowa 12
- Indiana 11
- Kansas 9
- Ohio 9
- Michigan 8
- Oklahoma 8
- Tennessee 8
- Arkansas 7
- Kentucky 7
- Louisiana 7
- Mississippi 7
- West Virginia 7
- North Carolina 6
- Maine 5
- Illinois 4
- South Dakota 4
- Colorado 3
- Minnesota 3
- New York 3
- New Mexico 2
- Utah 2
- Washington 2
- Wisconsin 2
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2428230 | 2428230 | 2022-04-21 | San Miguel | Colorado | 8113 | 2283 | 8 |
2422709 | 2422709 | 2022-04-19 | Luce | Michigan | 26095 | 2283 | 14 |
2419453 | 2419453 | 2022-04-18 | Luce | Michigan | 26095 | 2283 | 14 |
2416197 | 2416197 | 2022-04-17 | Luce | Michigan | 26095 | 2283 | 14 |
2412941 | 2412941 | 2022-04-16 | Luce | Michigan | 26095 | 2283 | 14 |
2409685 | 2409685 | 2022-04-15 | Luce | Michigan | 26095 | 2283 | 14 |
2406429 | 2406429 | 2022-04-14 | Luce | Michigan | 26095 | 2283 | 14 |
2403173 | 2403173 | 2022-04-13 | Luce | Michigan | 26095 | 2283 | 14 |
2398265 | 2398265 | 2022-04-11 | Grand | Utah | 49019 | 2283 | 6 |
2371998 | 2371998 | 2022-04-03 | Castro | Texas | 48069 | 2283 | 47 |
2368745 | 2368745 | 2022-04-02 | Castro | Texas | 48069 | 2283 | 47 |
2365492 | 2365492 | 2022-04-01 | Castro | Texas | 48069 | 2283 | 47 |
2362239 | 2362239 | 2022-03-31 | Castro | Texas | 48069 | 2283 | 47 |
2346568 | 2346568 | 2022-03-27 | Bullock | Alabama | 1011 | 2283 | 52 |
2343315 | 2343315 | 2022-03-26 | Bullock | Alabama | 1011 | 2283 | 52 |
2340062 | 2340062 | 2022-03-25 | Bullock | Alabama | 1011 | 2283 | 52 |
2336809 | 2336809 | 2022-03-24 | Bullock | Alabama | 1011 | 2283 | 52 |
2333555 | 2333555 | 2022-03-23 | Bullock | Alabama | 1011 | 2283 | 52 |
2330301 | 2330301 | 2022-03-22 | Bullock | Alabama | 1011 | 2283 | 52 |
2327049 | 2327049 | 2022-03-21 | Bullock | Alabama | 1011 | 2283 | 52 |
2317456 | 2317456 | 2022-03-18 | Scott | Arkansas | 5127 | 2283 | 40 |
2310346 | 2310346 | 2022-03-15 | Red River | Texas | 48387 | 2283 | 64 |
2294077 | 2294077 | 2022-03-10 | Parmer | Texas | 48369 | 2283 | 52 |
2288018 | 2288018 | 2022-03-09 | Bullock | Alabama | 1011 | 2283 | 51 |
2284766 | 2284766 | 2022-03-08 | Bullock | Alabama | 1011 | 2283 | 49 |
2259262 | 2259262 | 2022-02-28 | Stewart | Georgia | 13259 | 2283 | 31 |
2259815 | 2259815 | 2022-02-28 | Livingston | Kentucky | 21139 | 2283 | 58 |
2218949 | 2218949 | 2022-02-15 | Bon Homme | South Dakota | 46009 | 2283 | 37 |
2216480 | 2216480 | 2022-02-14 | Washakie | Wyoming | 56043 | 2283 | 42 |
2213123 | 2213123 | 2022-02-13 | Ritchie | West Virginia | 54085 | 2283 | 28 |
2178360 | 2178360 | 2022-02-03 | Coffey | Kansas | 20031 | 2283 | 37 |
2175107 | 2175107 | 2022-02-02 | Coffey | Kansas | 20031 | 2283 | 37 |
2171935 | 2171935 | 2022-02-01 | Thomas | Kansas | 20193 | 2283 | 26 |
2168682 | 2168682 | 2022-01-31 | Thomas | Kansas | 20193 | 2283 | 26 |
2170667 | 2170667 | 2022-01-31 | Galax city | Virginia | 51640 | 2283 | 71 |
2147767 | 2147767 | 2022-01-24 | Trinity | Texas | 48455 | 2283 | 66 |
2111038 | 2111038 | 2022-01-13 | Alleghany | North Carolina | 37005 | 2283 | 10 |
2063759 | 2063759 | 2021-12-30 | Lee | Arkansas | 5077 | 2283 | 55 |
2052142 | 2052142 | 2021-12-26 | Dent | Missouri | 29065 | 2283 | 63 |
2048892 | 2048892 | 2021-12-25 | Dent | Missouri | 29065 | 2283 | 63 |
2045642 | 2045642 | 2021-12-24 | Dent | Missouri | 29065 | 2283 | 63 |
2042392 | 2042392 | 2021-12-23 | Dent | Missouri | 29065 | 2283 | 63 |
2020076 | 2020076 | 2021-12-16 | Mitchell | North Carolina | 37121 | 2283 | 24 |
2009696 | 2009696 | 2021-12-13 | Chippewa | Minnesota | 27023 | 2283 | 43 |
1990588 | 1990588 | 2021-12-07 | Otoe | Nebraska | 31131 | 2283 | 16 |
1983506 | 1983506 | 2021-12-05 | Madison | Louisiana | 22065 | 2283 | 53 |
1980256 | 1980256 | 2021-12-04 | Madison | Louisiana | 22065 | 2283 | 53 |
1977006 | 1977006 | 2021-12-03 | Madison | Louisiana | 22065 | 2283 | 53 |
1973757 | 1973757 | 2021-12-02 | Madison | Louisiana | 22065 | 2283 | 53 |
1969123 | 1969123 | 2021-11-30 | Patrick | Virginia | 51141 | 2283 | 59 |
1969139 | 1969139 | 2021-11-30 | Rockbridge | Virginia | 51163 | 2283 | 66 |
1963006 | 1963006 | 2021-11-29 | Marion | Arkansas | 5089 | 2283 | 62 |
1944284 | 1944284 | 2021-11-23 | Jackson | Kansas | 20085 | 2283 | 20 |
1941034 | 1941034 | 2021-11-22 | Jackson | Kansas | 20085 | 2283 | 20 |
1939320 | 1939320 | 2021-11-21 | Clay | South Dakota | 46027 | 2283 | 17 |
1936070 | 1936070 | 2021-11-20 | Clay | South Dakota | 46027 | 2283 | 17 |
1932820 | 1932820 | 2021-11-19 | Clay | South Dakota | 46027 | 2283 | 17 |
1904870 | 1904870 | 2021-11-11 | Telfair | Georgia | 13271 | 2283 | 73 |
1905380 | 1905380 | 2021-11-11 | Estill | Kentucky | 21065 | 2283 | 12 |
1901620 | 1901620 | 2021-11-10 | Telfair | Georgia | 13271 | 2283 | 73 |
1902130 | 1902130 | 2021-11-10 | Estill | Kentucky | 21065 | 2283 | 12 |
1896123 | 1896123 | 2021-11-08 | Dallas | Missouri | 29059 | 2283 | 42 |
1877474 | 1877474 | 2021-11-02 | Las Piedras | Puerto Rico | 72085 | 2283 | |
1874225 | 1874225 | 2021-11-01 | Las Piedras | Puerto Rico | 72085 | 2283 | |
1870976 | 1870976 | 2021-10-31 | Las Piedras | Puerto Rico | 72085 | 2283 | |
1871576 | 1871576 | 2021-10-31 | Giles | Virginia | 51071 | 2283 | 31 |
1867727 | 1867727 | 2021-10-30 | Las Piedras | Puerto Rico | 72085 | 2283 | |
1868327 | 1868327 | 2021-10-30 | Giles | Virginia | 51071 | 2283 | 31 |
1864478 | 1864478 | 2021-10-29 | Las Piedras | Puerto Rico | 72085 | 2283 | |
1865078 | 1865078 | 2021-10-29 | Giles | Virginia | 51071 | 2283 | 31 |
1861229 | 1861229 | 2021-10-28 | Las Piedras | Puerto Rico | 72085 | 2283 | |
1857980 | 1857980 | 2021-10-27 | Las Piedras | Puerto Rico | 72085 | 2283 | |
1854731 | 1854731 | 2021-10-26 | Las Piedras | Puerto Rico | 72085 | 2283 | |
1851482 | 1851482 | 2021-10-25 | Las Piedras | Puerto Rico | 72085 | 2283 | |
1848232 | 1848232 | 2021-10-24 | Las Piedras | Puerto Rico | 72085 | 2283 | |
1790305 | 1790305 | 2021-10-06 | Appomattox | Virginia | 51011 | 2283 | 34 |
1785023 | 1785023 | 2021-10-05 | Atchison | Kansas | 20005 | 2283 | 23 |
1781774 | 1781774 | 2021-10-04 | Atchison | Kansas | 20005 | 2283 | 23 |
1768939 | 1768939 | 2021-09-30 | Larue | Kentucky | 21123 | 2283 | 37 |
1762190 | 1762190 | 2021-09-28 | Cedar | Iowa | 19031 | 2283 | 25 |
1758942 | 1758942 | 2021-09-27 | Cedar | Iowa | 19031 | 2283 | 25 |
1755694 | 1755694 | 2021-09-26 | Cedar | Iowa | 19031 | 2283 | 25 |
1751647 | 1751647 | 2021-09-25 | Clay | Alabama | 1027 | 2283 | 65 |
1752446 | 1752446 | 2021-09-25 | Cedar | Iowa | 19031 | 2283 | 25 |
1749197 | 1749197 | 2021-09-24 | Cedar | Iowa | 19031 | 2283 | 25 |
1749987 | 1749987 | 2021-09-24 | Ste. Genevieve | Missouri | 29186 | 2283 | 25 |
1745947 | 1745947 | 2021-09-23 | Cedar | Iowa | 19031 | 2283 | 25 |
1742698 | 1742698 | 2021-09-22 | Cedar | Iowa | 19031 | 2283 | 25 |
1732008 | 1732008 | 2021-09-18 | Lewis | West Virginia | 54041 | 2283 | 31 |
1723176 | 1723176 | 2021-09-16 | Vermillion | Indiana | 18165 | 2283 | 50 |
1722201 | 1722201 | 2021-09-15 | Asotin | Washington | 53003 | 2283 | 38 |
1718054 | 1718054 | 2021-09-14 | Choctaw | Oklahoma | 40023 | 2283 | 33 |
1718861 | 1718861 | 2021-09-14 | Fluvanna | Virginia | 51065 | 2283 | 22 |
1714806 | 1714806 | 2021-09-13 | Choctaw | Oklahoma | 40023 | 2283 | 33 |
1711560 | 1711560 | 2021-09-12 | Choctaw | Oklahoma | 40023 | 2283 | 33 |
1708313 | 1708313 | 2021-09-11 | Choctaw | Oklahoma | 40023 | 2283 | 33 |
1705066 | 1705066 | 2021-09-10 | Choctaw | Oklahoma | 40023 | 2283 | 33 |
1701816 | 1701816 | 2021-09-09 | Choctaw | Oklahoma | 40023 | 2283 | 33 |
1697533 | 1697533 | 2021-09-08 | Bienville | Louisiana | 22013 | 2283 | 87 |
1698567 | 1698567 | 2021-09-08 | Choctaw | Oklahoma | 40023 | 2283 | 33 |
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);