ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
305 rows where cases = 1922 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 24
- Wyoming 23
- Mississippi 20
- Kentucky 18
- Texas 18
- Missouri 14
- Puerto Rico 13
- Iowa 12
- Louisiana 12
- Arkansas 11
- Oklahoma 9
- Alabama 8
- Illinois 8
- South Carolina 8
- Colorado 7
- Minnesota 7
- Tennessee 7
- Indiana 6
- Michigan 6
- North Carolina 6
- Utah 6
- Wisconsin 6
- Georgia 5
- Washington 5
- Kansas 4
- Ohio 4
- South Dakota 4
- Arizona 3
- Idaho 3
- Maine 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466993 | 2466993 | 2022-05-02 | Sublette | Wyoming | 56035 | 1922 | 27 |
2463738 | 2463738 | 2022-05-01 | Sublette | Wyoming | 56035 | 1922 | 27 |
2460482 | 2460482 | 2022-04-30 | Sublette | Wyoming | 56035 | 1922 | 27 |
2457226 | 2457226 | 2022-04-29 | Sublette | Wyoming | 56035 | 1922 | 27 |
2453970 | 2453970 | 2022-04-28 | Sublette | Wyoming | 56035 | 1922 | 27 |
2450714 | 2450714 | 2022-04-27 | Sublette | Wyoming | 56035 | 1922 | 27 |
2447458 | 2447458 | 2022-04-26 | Sublette | Wyoming | 56035 | 1922 | 27 |
2444202 | 2444202 | 2022-04-25 | Sublette | Wyoming | 56035 | 1922 | 27 |
2440946 | 2440946 | 2022-04-24 | Sublette | Wyoming | 56035 | 1922 | 27 |
2437690 | 2437690 | 2022-04-23 | Sublette | Wyoming | 56035 | 1922 | 27 |
2434434 | 2434434 | 2022-04-22 | Sublette | Wyoming | 56035 | 1922 | 27 |
2431178 | 2431178 | 2022-04-21 | Sublette | Wyoming | 56035 | 1922 | 27 |
2427922 | 2427922 | 2022-04-20 | Sublette | Wyoming | 56035 | 1922 | 27 |
2423762 | 2423762 | 2022-04-19 | Arroyo | Puerto Rico | 72015 | 1922 | |
2424666 | 2424666 | 2022-04-19 | Sublette | Wyoming | 56035 | 1922 | 27 |
2421410 | 2421410 | 2022-04-18 | Sublette | Wyoming | 56035 | 1922 | 27 |
2417633 | 2417633 | 2022-04-17 | Hansford | Texas | 48195 | 1922 | 29 |
2418154 | 2418154 | 2022-04-17 | Sublette | Wyoming | 56035 | 1922 | 27 |
2414377 | 2414377 | 2022-04-16 | Hansford | Texas | 48195 | 1922 | 29 |
2414898 | 2414898 | 2022-04-16 | Sublette | Wyoming | 56035 | 1922 | 27 |
2411121 | 2411121 | 2022-04-15 | Hansford | Texas | 48195 | 1922 | 29 |
2411642 | 2411642 | 2022-04-15 | Sublette | Wyoming | 56035 | 1922 | 27 |
2407865 | 2407865 | 2022-04-14 | Hansford | Texas | 48195 | 1922 | 29 |
2408386 | 2408386 | 2022-04-14 | Sublette | Wyoming | 56035 | 1922 | 27 |
2404609 | 2404609 | 2022-04-13 | Hansford | Texas | 48195 | 1922 | 29 |
2405130 | 2405130 | 2022-04-13 | Sublette | Wyoming | 56035 | 1922 | 27 |
2401875 | 2401875 | 2022-04-12 | Sublette | Wyoming | 56035 | 1922 | 27 |
2347997 | 2347997 | 2022-03-27 | Franklin | Mississippi | 28037 | 1922 | 38 |
2344744 | 2344744 | 2022-03-26 | Franklin | Mississippi | 28037 | 1922 | 38 |
2341491 | 2341491 | 2022-03-25 | Franklin | Mississippi | 28037 | 1922 | 38 |
2338238 | 2338238 | 2022-03-24 | Franklin | Mississippi | 28037 | 1922 | 38 |
2334984 | 2334984 | 2022-03-23 | Franklin | Mississippi | 28037 | 1922 | 38 |
2331730 | 2331730 | 2022-03-22 | Franklin | Mississippi | 28037 | 1922 | 38 |
2327202 | 2327202 | 2022-03-21 | Monroe | Arkansas | 5095 | 1922 | 33 |
2328478 | 2328478 | 2022-03-21 | Franklin | Mississippi | 28037 | 1922 | 38 |
2302455 | 2302455 | 2022-03-13 | Franklin | Mississippi | 28037 | 1922 | 38 |
2299203 | 2299203 | 2022-03-12 | Franklin | Mississippi | 28037 | 1922 | 38 |
2295951 | 2295951 | 2022-03-11 | Franklin | Mississippi | 28037 | 1922 | 38 |
2292699 | 2292699 | 2022-03-10 | Franklin | Mississippi | 28037 | 1922 | 38 |
2289447 | 2289447 | 2022-03-09 | Franklin | Mississippi | 28037 | 1922 | 38 |
2291259 | 2291259 | 2022-03-09 | Sublette | Wyoming | 56035 | 1922 | 27 |
2286196 | 2286196 | 2022-03-08 | Franklin | Mississippi | 28037 | 1922 | 38 |
2282944 | 2282944 | 2022-03-07 | Franklin | Mississippi | 28037 | 1922 | 38 |
2279691 | 2279691 | 2022-03-06 | Franklin | Mississippi | 28037 | 1922 | 38 |
2276438 | 2276438 | 2022-03-05 | Franklin | Mississippi | 28037 | 1922 | 38 |
2273185 | 2273185 | 2022-03-04 | Franklin | Mississippi | 28037 | 1922 | 38 |
2218262 | 2218262 | 2022-02-15 | White Pine | Nevada | 32033 | 1922 | 18 |
2211007 | 2211007 | 2022-02-13 | Crittenden | Kentucky | 21055 | 1922 | 41 |
2207754 | 2207754 | 2022-02-12 | Crittenden | Kentucky | 21055 | 1922 | 41 |
2204501 | 2204501 | 2022-02-11 | Crittenden | Kentucky | 21055 | 1922 | 41 |
2115637 | 2115637 | 2022-01-15 | Bullock | Alabama | 1011 | 1922 | 46 |
2112385 | 2112385 | 2022-01-14 | Bullock | Alabama | 1011 | 1922 | 46 |
2112544 | 2112544 | 2022-01-14 | Perry | Arkansas | 5105 | 1922 | 26 |
2109133 | 2109133 | 2022-01-13 | Bullock | Alabama | 1011 | 1922 | 46 |
2111955 | 2111955 | 2022-01-13 | Runnels | Texas | 48399 | 1922 | 56 |
2105882 | 2105882 | 2022-01-12 | Bullock | Alabama | 1011 | 1922 | 46 |
2102308 | 2102308 | 2022-01-10 | Amelia | Virginia | 51007 | 1922 | 44 |
2102624 | 2102624 | 2022-01-10 | Washakie | Wyoming | 56043 | 1922 | 39 |
2084184 | 2084184 | 2022-01-05 | Lee | Kentucky | 21129 | 1922 | 44 |
2081000 | 2081000 | 2022-01-04 | Catahoula | Louisiana | 22025 | 1922 | 48 |
2061001 | 2061001 | 2021-12-29 | Jasper | Illinois | 17079 | 1922 | 23 |
2021027 | 2021027 | 2021-12-16 | Lamoille | Vermont | 50015 | 1922 | 11 |
2016414 | 2016414 | 2021-12-15 | Lewis | Missouri | 29111 | 1922 | 30 |
2005356 | 2005356 | 2021-12-12 | Bent | Colorado | 8011 | 1922 | 34 |
2006609 | 2006609 | 2021-12-12 | Barton | Missouri | 29011 | 1922 | 40 |
2002105 | 2002105 | 2021-12-11 | Bent | Colorado | 8011 | 1922 | 34 |
1998855 | 1998855 | 2021-12-10 | Bent | Colorado | 8011 | 1922 | 34 |
1986713 | 1986713 | 2021-12-06 | Todd | Kentucky | 21219 | 1922 | 36 |
1982953 | 1982953 | 2021-12-05 | Washington | Idaho | 16087 | 1922 | 47 |
1979703 | 1979703 | 2021-12-04 | Washington | Idaho | 16087 | 1922 | 47 |
1964357 | 1964357 | 2021-11-29 | Bollinger | Missouri | 29017 | 1922 | 30 |
1946504 | 1946504 | 2021-11-23 | Bayfield | Wisconsin | 55007 | 1922 | 26 |
1907726 | 1907726 | 2021-11-12 | Desha | Arkansas | 5041 | 1922 | 33 |
1903438 | 1903438 | 2021-11-10 | Barranquitas | Puerto Rico | 72019 | 1922 | |
1903990 | 1903990 | 2021-11-10 | Morgan | Utah | 49029 | 1922 | 12 |
1898616 | 1898616 | 2021-11-09 | Pulaski | Indiana | 18131 | 1922 | 57 |
1900190 | 1900190 | 2021-11-09 | Cabo Rojo | Puerto Rico | 72023 | 1922 | |
1900740 | 1900740 | 2021-11-09 | Morgan | Utah | 49029 | 1922 | 12 |
1901002 | 1901002 | 2021-11-09 | Ashland | Wisconsin | 55003 | 1922 | 17 |
1896940 | 1896940 | 2021-11-08 | Cabo Rojo | Puerto Rico | 72023 | 1922 | |
1891627 | 1891627 | 2021-11-07 | Las Animas | Colorado | 8071 | 1922 | 24 |
1893690 | 1893690 | 2021-11-07 | Cabo Rojo | Puerto Rico | 72023 | 1922 | |
1888377 | 1888377 | 2021-11-06 | Las Animas | Colorado | 8071 | 1922 | 24 |
1885127 | 1885127 | 2021-11-05 | Las Animas | Colorado | 8071 | 1922 | 24 |
1871593 | 1871593 | 2021-10-31 | King William | Virginia | 51101 | 1922 | 24 |
1868344 | 1868344 | 2021-10-30 | King William | Virginia | 51101 | 1922 | 24 |
1865095 | 1865095 | 2021-10-29 | King William | Virginia | 51101 | 1922 | 24 |
1847217 | 1847217 | 2021-10-24 | Kanabec | Minnesota | 27065 | 1922 | 30 |
1843967 | 1843967 | 2021-10-23 | Kanabec | Minnesota | 27065 | 1922 | 30 |
1844955 | 1844955 | 2021-10-23 | Catano | Puerto Rico | 72033 | 1922 | |
1840717 | 1840717 | 2021-10-22 | Kanabec | Minnesota | 27065 | 1922 | 30 |
1837765 | 1837765 | 2021-10-21 | Roosevelt | Montana | 30085 | 1922 | 58 |
1814439 | 1814439 | 2021-10-14 | Lyon | Kentucky | 21143 | 1922 | 26 |
1812374 | 1812374 | 2021-10-13 | Tillamook | Oregon | 41057 | 1922 | 27 |
1808052 | 1808052 | 2021-10-12 | West Carroll | Louisiana | 22123 | 1922 | 47 |
1804801 | 1804801 | 2021-10-11 | West Carroll | Louisiana | 22123 | 1922 | 47 |
1789601 | 1789601 | 2021-10-06 | Baker | Oregon | 41001 | 1922 | 25 |
1773816 | 1773816 | 2021-10-01 | Duval | Texas | 48131 | 1922 | 52 |
1771036 | 1771036 | 2021-09-30 | Burnett | Wisconsin | 55013 | 1922 | 29 |
1758797 | 1758797 | 2021-09-27 | Mercer | Illinois | 17131 | 1922 | 34 |
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);