ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
211 rows where cases = 2636 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 15
- Missouri 14
- Tennessee 14
- Georgia 13
- Mississippi 12
- Virginia 12
- North Carolina 11
- Texas 9
- Minnesota 8
- Iowa 7
- Ohio 7
- Alabama 6
- Indiana 6
- South Carolina 6
- Illinois 5
- Oregon 5
- Pennsylvania 5
- Idaho 4
- Michigan 4
- West Virginia 4
- Alaska 3
- Kansas 3
- Louisiana 3
- Nebraska 3
- New Mexico 3
- New York 3
- Arizona 2
- Arkansas 2
- Colorado 2
- Florida 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473010 | 2473010 | 2022-05-04 | Jim Hogg | Texas | 48247 | 2636 | 22 |
2463448 | 2463448 | 2022-05-01 | Clarke | Virginia | 51043 | 2636 | 42 |
2460192 | 2460192 | 2022-04-30 | Clarke | Virginia | 51043 | 2636 | 42 |
2456936 | 2456936 | 2022-04-29 | Clarke | Virginia | 51043 | 2636 | 42 |
2452124 | 2452124 | 2022-04-28 | Stevens | Minnesota | 27149 | 2636 | 13 |
2430286 | 2430286 | 2022-04-21 | Ciales | Puerto Rico | 72039 | 2636 | |
2423075 | 2423075 | 2022-04-19 | Richland | Montana | 30083 | 2636 | 33 |
2419818 | 2419818 | 2022-04-18 | Richland | Montana | 30083 | 2636 | 33 |
2352850 | 2352850 | 2022-03-28 | Richmond | Virginia | 51159 | 2636 | 27 |
2348492 | 2348492 | 2022-03-27 | Clay | North Carolina | 37043 | 2636 | 39 |
2345239 | 2345239 | 2022-03-26 | Clay | North Carolina | 37043 | 2636 | 39 |
2341986 | 2341986 | 2022-03-25 | Clay | North Carolina | 37043 | 2636 | 39 |
2279536 | 2279536 | 2022-03-06 | Iron | Michigan | 26071 | 2636 | 85 |
2276283 | 2276283 | 2022-03-05 | Iron | Michigan | 26071 | 2636 | 85 |
2273030 | 2273030 | 2022-03-04 | Iron | Michigan | 26071 | 2636 | 85 |
2241816 | 2241816 | 2022-02-22 | Lake | Tennessee | 47095 | 2636 | 37 |
2238565 | 2238565 | 2022-02-21 | Lake | Tennessee | 47095 | 2636 | 37 |
2235314 | 2235314 | 2022-02-20 | Lake | Tennessee | 47095 | 2636 | 37 |
2232063 | 2232063 | 2022-02-19 | Lake | Tennessee | 47095 | 2636 | 37 |
2228812 | 2228812 | 2022-02-18 | Lake | Tennessee | 47095 | 2636 | 37 |
2225561 | 2225561 | 2022-02-17 | Lake | Tennessee | 47095 | 2636 | 37 |
2222310 | 2222310 | 2022-02-16 | Lake | Tennessee | 47095 | 2636 | 37 |
2176229 | 2176229 | 2022-02-02 | McLean | North Dakota | 38055 | 2636 | 49 |
2126806 | 2126806 | 2022-01-18 | Amite | Mississippi | 28005 | 2636 | 59 |
2109210 | 2109210 | 2022-01-13 | Nome Census Area | Alaska | 2180 | 2636 | 3 |
2105959 | 2105959 | 2022-01-12 | Nome Census Area | Alaska | 2180 | 2636 | 3 |
2107614 | 2107614 | 2022-01-12 | Otoe | Nebraska | 31131 | 2636 | 16 |
2104193 | 2104193 | 2022-01-11 | Mississippi | Missouri | 29133 | 2636 | 51 |
2097659 | 2097659 | 2022-01-09 | Gasconade | Missouri | 29073 | 2636 | 87 |
2074380 | 2074380 | 2022-01-02 | Butler | Kentucky | 21031 | 2636 | 43 |
2071129 | 2071129 | 2022-01-01 | Butler | Kentucky | 21031 | 2636 | 43 |
2067878 | 2067878 | 2021-12-31 | Butler | Kentucky | 21031 | 2636 | 43 |
2064627 | 2064627 | 2021-12-30 | Butler | Kentucky | 21031 | 2636 | 43 |
2061377 | 2061377 | 2021-12-29 | Butler | Kentucky | 21031 | 2636 | 43 |
2042057 | 2042057 | 2021-12-23 | Lincoln | Maine | 23015 | 2636 | 11 |
2040127 | 2040127 | 2021-12-22 | Oglala Lakota | South Dakota | 46102 | 2636 | 55 |
2035008 | 2035008 | 2021-12-21 | Johnson | Illinois | 17087 | 2636 | 38 |
2027723 | 2027723 | 2021-12-18 | Grant | West Virginia | 54023 | 2636 | 42 |
2027744 | 2027744 | 2021-12-18 | Morgan | West Virginia | 54065 | 2636 | 51 |
2018129 | 2018129 | 2021-12-16 | Crenshaw | Alabama | 1041 | 2636 | 79 |
2015059 | 2015059 | 2021-12-15 | Inyo | California | 6027 | 2636 | 46 |
1996714 | 1996714 | 2021-12-09 | Kanabec | Minnesota | 27065 | 2636 | 40 |
1984585 | 1984585 | 2021-12-05 | Clatsop | Oregon | 41007 | 2636 | 35 |
1981335 | 1981335 | 2021-12-04 | Clatsop | Oregon | 41007 | 2636 | 35 |
1981731 | 1981731 | 2021-12-04 | Aransas | Texas | 48007 | 2636 | 67 |
1978085 | 1978085 | 2021-12-03 | Clatsop | Oregon | 41007 | 2636 | 35 |
1978481 | 1978481 | 2021-12-03 | Aransas | Texas | 48007 | 2636 | 67 |
1962048 | 1962048 | 2021-11-28 | Lee | South Carolina | 45061 | 2636 | 78 |
1958797 | 1958797 | 2021-11-27 | Lee | South Carolina | 45061 | 2636 | 78 |
1955546 | 1955546 | 2021-11-26 | Lee | South Carolina | 45061 | 2636 | 78 |
1918735 | 1918735 | 2021-11-15 | Redwood | Minnesota | 27127 | 2636 | 45 |
1915661 | 1915661 | 2021-11-14 | Moniteau | Missouri | 29135 | 2636 | 40 |
1912411 | 1912411 | 2021-11-13 | Moniteau | Missouri | 29135 | 2636 | 40 |
1909161 | 1909161 | 2021-11-12 | Moniteau | Missouri | 29135 | 2636 | 40 |
1895782 | 1895782 | 2021-11-08 | Winn | Louisiana | 22127 | 2636 | 58 |
1875923 | 1875923 | 2021-11-02 | Delaware | Iowa | 19055 | 2636 | 49 |
1872674 | 1872674 | 2021-11-01 | Delaware | Iowa | 19055 | 2636 | 49 |
1869425 | 1869425 | 2021-10-31 | Delaware | Iowa | 19055 | 2636 | 49 |
1870440 | 1870440 | 2021-10-31 | San Miguel | New Mexico | 35047 | 2636 | 26 |
1866176 | 1866176 | 2021-10-30 | Delaware | Iowa | 19055 | 2636 | 49 |
1867191 | 1867191 | 2021-10-30 | San Miguel | New Mexico | 35047 | 2636 | 26 |
1862927 | 1862927 | 2021-10-29 | Delaware | Iowa | 19055 | 2636 | 49 |
1863942 | 1863942 | 2021-10-29 | San Miguel | New Mexico | 35047 | 2636 | 26 |
1859678 | 1859678 | 2021-10-28 | Delaware | Iowa | 19055 | 2636 | 49 |
1855688 | 1855688 | 2021-10-27 | North Slope Borough | Alaska | 2185 | 2636 | 6 |
1856429 | 1856429 | 2021-10-27 | Delaware | Iowa | 19055 | 2636 | 49 |
1830286 | 1830286 | 2021-10-19 | Pike | Illinois | 17149 | 2636 | 61 |
1809103 | 1809103 | 2021-10-12 | Crook | Oregon | 41013 | 2636 | 43 |
1804088 | 1804088 | 2021-10-11 | Jefferson | Georgia | 13163 | 2636 | 81 |
1800839 | 1800839 | 2021-10-10 | Jefferson | Georgia | 13163 | 2636 | 81 |
1797590 | 1797590 | 2021-10-09 | Jefferson | Georgia | 13163 | 2636 | 81 |
1794341 | 1794341 | 2021-10-08 | Jefferson | Georgia | 13163 | 2636 | 81 |
1792745 | 1792745 | 2021-10-07 | Paulding | Ohio | 39125 | 2636 | 44 |
1789334 | 1789334 | 2021-10-06 | Madison | North Carolina | 37115 | 2636 | 55 |
1766632 | 1766632 | 2021-09-29 | Yancey | North Carolina | 37199 | 2636 | 29 |
1763937 | 1763937 | 2021-09-28 | Grundy | Tennessee | 47061 | 2636 | 37 |
1756096 | 1756096 | 2021-09-26 | Garrett | Maryland | 24023 | 2636 | 70 |
1749884 | 1749884 | 2021-09-24 | Andrew | Missouri | 29003 | 2636 | 23 |
1744998 | 1744998 | 2021-09-22 | Hampshire | West Virginia | 54027 | 2636 | 38 |
1738413 | 1738413 | 2021-09-20 | Prince Edward | Virginia | 51147 | 2636 | 41 |
1706181 | 1706181 | 2021-09-11 | Fayette | Alabama | 1057 | 2636 | 67 |
1670990 | 1670990 | 2021-08-31 | Elmore | Idaho | 16039 | 2636 | 22 |
1667853 | 1667853 | 2021-08-30 | Shelby | Illinois | 17173 | 2636 | 43 |
1657595 | 1657595 | 2021-08-27 | Randolph | Arkansas | 5121 | 2636 | 50 |
1654902 | 1654902 | 2021-08-26 | Fountain | Indiana | 18045 | 2636 | 54 |
1643756 | 1643756 | 2021-08-22 | Johnson | Tennessee | 47091 | 2636 | 40 |
1640506 | 1640506 | 2021-08-21 | Johnson | Tennessee | 47091 | 2636 | 40 |
1637256 | 1637256 | 2021-08-20 | Johnson | Tennessee | 47091 | 2636 | 40 |
1631017 | 1631017 | 2021-08-18 | Scurry | Texas | 48415 | 2636 | 62 |
1625059 | 1625059 | 2021-08-17 | Clark | Arkansas | 5019 | 2636 | 41 |
1627081 | 1627081 | 2021-08-17 | Van Wert | Ohio | 39161 | 2636 | 65 |
1628184 | 1628184 | 2021-08-17 | Uinta | Wyoming | 56041 | 2636 | 14 |
1609204 | 1609204 | 2021-08-12 | Pike | Georgia | 13231 | 2636 | 44 |
1607887 | 1607887 | 2021-08-11 | Fairfield | South Carolina | 45039 | 2636 | 83 |
1528993 | 1528993 | 2021-07-18 | Adair | Missouri | 29001 | 2636 | 21 |
1525746 | 1525746 | 2021-07-17 | Adair | Missouri | 29001 | 2636 | 21 |
1518048 | 1518048 | 2021-07-15 | Pitkin | Colorado | 8097 | 2636 | 4 |
1511943 | 1511943 | 2021-07-13 | Saline | Illinois | 17165 | 2636 | 73 |
1505693 | 1505693 | 2021-07-11 | Franklin | Kansas | 20059 | 2636 | 43 |
1502447 | 1502447 | 2021-07-10 | Franklin | Kansas | 20059 | 2636 | 43 |
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);