ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
262 rows where cases = 1852 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 24
- Texas 21
- Alabama 15
- Iowa 15
- Mississippi 15
- Missouri 15
- Kentucky 11
- Oklahoma 11
- Virginia 11
- Illinois 10
- Kansas 9
- North Carolina 9
- Tennessee 9
- Puerto Rico 8
- Arkansas 7
- Florida 6
- Louisiana 6
- Minnesota 6
- Ohio 6
- Wisconsin 4
- Wyoming 4
- Colorado 3
- Indiana 3
- North Dakota 3
- Oregon 3
- Pennsylvania 3
- Utah 3
- West Virginia 3
- California 2
- Idaho 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502199 | 2502199 | 2022-05-13 | Van Buren | Tennessee | 47175 | 1852 | 48 |
2498941 | 2498941 | 2022-05-12 | Van Buren | Tennessee | 47175 | 1852 | 48 |
2495683 | 2495683 | 2022-05-11 | Van Buren | Tennessee | 47175 | 1852 | 48 |
2384721 | 2384721 | 2022-04-07 | Hormigueros | Puerto Rico | 72067 | 1852 | |
2310206 | 2310206 | 2022-03-15 | Crosby | Texas | 48107 | 1852 | 45 |
2258775 | 2258775 | 2022-02-28 | Greene | Alabama | 1063 | 1852 | 48 |
2255524 | 2255524 | 2022-02-27 | Greene | Alabama | 1063 | 1852 | 48 |
2252273 | 2252273 | 2022-02-26 | Greene | Alabama | 1063 | 1852 | 48 |
2238696 | 2238696 | 2022-02-21 | Gaines | Texas | 48165 | 1852 | 81 |
2196908 | 2196908 | 2022-02-08 | Menominee | Wisconsin | 55078 | 1852 | 13 |
2191624 | 2191624 | 2022-02-07 | St. Helena | Louisiana | 22091 | 1852 | 22 |
2193596 | 2193596 | 2022-02-07 | Pocahontas | West Virginia | 54075 | 1852 | 25 |
2180393 | 2180393 | 2022-02-03 | Buena Vista city | Virginia | 51530 | 1852 | 36 |
2155163 | 2155163 | 2022-01-27 | Montgomery | Georgia | 13209 | 1852 | 46 |
2119348 | 2119348 | 2022-01-16 | Heard | Georgia | 13149 | 1852 | 43 |
2116096 | 2116096 | 2022-01-15 | Heard | Georgia | 13149 | 1852 | 43 |
2112845 | 2112845 | 2022-01-14 | Heard | Georgia | 13149 | 1852 | 43 |
2104854 | 2104854 | 2022-01-11 | Washita | Oklahoma | 40149 | 1852 | 34 |
2101603 | 2101603 | 2022-01-10 | Washita | Oklahoma | 40149 | 1852 | 34 |
2102263 | 2102263 | 2022-01-10 | Emery | Utah | 49015 | 1852 | 25 |
2098352 | 2098352 | 2022-01-09 | Washita | Oklahoma | 40149 | 1852 | 34 |
2098978 | 2098978 | 2022-01-09 | Trinity | Texas | 48455 | 1852 | 64 |
2095100 | 2095100 | 2022-01-08 | Washita | Oklahoma | 40149 | 1852 | 34 |
2091848 | 2091848 | 2022-01-07 | Washita | Oklahoma | 40149 | 1852 | 34 |
2088596 | 2088596 | 2022-01-06 | Washita | Oklahoma | 40149 | 1852 | 34 |
2085345 | 2085345 | 2022-01-05 | Washita | Oklahoma | 40149 | 1852 | 34 |
2077192 | 2077192 | 2022-01-03 | Franklin | Idaho | 16041 | 1852 | 27 |
2070176 | 2070176 | 2022-01-01 | Wilcox | Alabama | 1131 | 1852 | 38 |
2066925 | 2066925 | 2021-12-31 | Wilcox | Alabama | 1131 | 1852 | 38 |
2065948 | 2065948 | 2021-12-30 | Anasco | Puerto Rico | 72011 | 1852 | |
2061754 | 2061754 | 2021-12-29 | Rock | Minnesota | 27133 | 1852 | 32 |
2057625 | 2057625 | 2021-12-28 | Screven | Georgia | 13251 | 1852 | 62 |
2058697 | 2058697 | 2021-12-28 | Ralls | Missouri | 29173 | 1852 | 19 |
2059464 | 2059464 | 2021-12-28 | Coamo | Puerto Rico | 72043 | 1852 | |
2055264 | 2055264 | 2021-12-27 | Stevens | Minnesota | 27149 | 1852 | 11 |
2041392 | 2041392 | 2021-12-23 | Towns | Georgia | 13281 | 1852 | 87 |
2035988 | 2035988 | 2021-12-21 | Dawson | Montana | 30021 | 1852 | 50 |
2029326 | 2029326 | 2021-12-19 | Montgomery | Mississippi | 28097 | 1852 | 57 |
2029399 | 2029399 | 2021-12-19 | Grundy | Missouri | 29079 | 1852 | 56 |
2026075 | 2026075 | 2021-12-18 | Montgomery | Mississippi | 28097 | 1852 | 57 |
2022824 | 2022824 | 2021-12-17 | Montgomery | Mississippi | 28097 | 1852 | 57 |
2014857 | 2014857 | 2021-12-14 | Washakie | Wyoming | 56043 | 1852 | 37 |
2011606 | 2011606 | 2021-12-13 | Washakie | Wyoming | 56043 | 1852 | 36 |
1990761 | 1990761 | 2021-12-07 | Alleghany | North Carolina | 37005 | 1852 | 6 |
1986362 | 1986362 | 2021-12-06 | Newton | Indiana | 18111 | 1852 | 54 |
1943480 | 1943480 | 2021-11-23 | Fulton | Arkansas | 5049 | 1852 | 67 |
1945379 | 1945379 | 2021-11-23 | Mercer | North Dakota | 38057 | 1852 | 17 |
1938347 | 1938347 | 2021-11-21 | Barton | Missouri | 29011 | 1852 | 38 |
1935097 | 1935097 | 2021-11-20 | Barton | Missouri | 29011 | 1852 | 38 |
1884251 | 1884251 | 2021-11-04 | Callahan | Texas | 48059 | 1852 | 55 |
1878619 | 1878619 | 2021-11-03 | Gunnison | Colorado | 8051 | 1852 | 12 |
1881259 | 1881259 | 2021-11-03 | Caledonia | Vermont | 50005 | 1852 | 16 |
1822204 | 1822204 | 2021-10-16 | Barranquitas | Puerto Rico | 72019 | 1852 | |
1807954 | 1807954 | 2021-10-12 | Metcalfe | Kentucky | 21169 | 1852 | 38 |
1808987 | 1808987 | 2021-10-12 | Morgan | Ohio | 39115 | 1852 | 32 |
1805860 | 1805860 | 2021-10-11 | Hood River | Oregon | 41027 | 1852 | 36 |
1792151 | 1792151 | 2021-10-07 | Dent | Missouri | 29065 | 1852 | 38 |
1787504 | 1787504 | 2021-10-06 | Desha | Arkansas | 5041 | 1852 | 29 |
1738518 | 1738518 | 2021-09-20 | Monroe | West Virginia | 54063 | 1852 | 20 |
1735174 | 1735174 | 2021-09-19 | Rockbridge | Virginia | 51163 | 1852 | 50 |
1731924 | 1731924 | 2021-09-18 | Rockbridge | Virginia | 51163 | 1852 | 50 |
1728328 | 1728328 | 2021-09-17 | Duval | Texas | 48131 | 1852 | 52 |
1728674 | 1728674 | 2021-09-17 | Rockbridge | Virginia | 51163 | 1852 | 50 |
1724961 | 1724961 | 2021-09-16 | Jackson | Tennessee | 47087 | 1852 | 37 |
1714028 | 1714028 | 2021-09-13 | Pennington | Minnesota | 27113 | 1852 | 21 |
1710891 | 1710891 | 2021-09-12 | Webster | Mississippi | 28155 | 1852 | 41 |
1707644 | 1707644 | 2021-09-11 | Webster | Mississippi | 28155 | 1852 | 41 |
1704397 | 1704397 | 2021-09-10 | Webster | Mississippi | 28155 | 1852 | 41 |
1704945 | 1704945 | 2021-09-10 | Ramsey | North Dakota | 38071 | 1852 | 31 |
1701768 | 1701768 | 2021-09-09 | Meigs | Ohio | 39105 | 1852 | 42 |
1698753 | 1698753 | 2021-09-08 | Catano | Puerto Rico | 72033 | 1852 | |
1693852 | 1693852 | 2021-09-07 | Wabash | Illinois | 17185 | 1852 | 16 |
1674131 | 1674131 | 2021-09-01 | Jasper | Georgia | 13159 | 1852 | 43 |
1674294 | 1674294 | 2021-09-01 | Greene | Illinois | 17061 | 1852 | 49 |
1665373 | 1665373 | 2021-08-29 | Lawrence | Mississippi | 28077 | 1852 | 29 |
1662125 | 1662125 | 2021-08-28 | Lawrence | Mississippi | 28077 | 1852 | 29 |
1658877 | 1658877 | 2021-08-27 | Lawrence | Mississippi | 28077 | 1852 | 29 |
1645045 | 1645045 | 2021-08-23 | Clay | Illinois | 17025 | 1852 | 48 |
1647597 | 1647597 | 2021-08-23 | Crawford | Wisconsin | 55023 | 1852 | 19 |
1603280 | 1603280 | 2021-08-10 | Mason | Kentucky | 21161 | 1852 | 40 |
1592596 | 1592596 | 2021-08-07 | Howard | Arkansas | 5061 | 1852 | 25 |
1576274 | 1576274 | 2021-08-02 | Washington | Alabama | 1129 | 1852 | 39 |
1573026 | 1573026 | 2021-08-01 | Washington | Alabama | 1129 | 1852 | 39 |
1575520 | 1575520 | 2021-08-01 | Grundy | Tennessee | 47061 | 1852 | 35 |
1572272 | 1572272 | 2021-07-31 | Grundy | Tennessee | 47061 | 1852 | 35 |
1569024 | 1569024 | 2021-07-30 | Grundy | Tennessee | 47061 | 1852 | 35 |
1527953 | 1527953 | 2021-07-18 | Greene | Georgia | 13133 | 1852 | 62 |
1524706 | 1524706 | 2021-07-17 | Greene | Georgia | 13133 | 1852 | 62 |
1521458 | 1521458 | 2021-07-16 | Greene | Georgia | 13133 | 1852 | 62 |
1518210 | 1518210 | 2021-07-15 | Greene | Georgia | 13133 | 1852 | 62 |
1514557 | 1514557 | 2021-07-14 | Monroe | Alabama | 1099 | 1852 | 41 |
1514963 | 1514963 | 2021-07-14 | Greene | Georgia | 13133 | 1852 | 62 |
1511717 | 1511717 | 2021-07-13 | Greene | Georgia | 13133 | 1852 | 62 |
1512840 | 1512840 | 2021-07-13 | Pike | Missouri | 29163 | 1852 | 27 |
1509614 | 1509614 | 2021-07-12 | Ste. Genevieve | Missouri | 29186 | 1852 | 17 |
1506368 | 1506368 | 2021-07-11 | Ste. Genevieve | Missouri | 29186 | 1852 | 17 |
1503122 | 1503122 | 2021-07-10 | Ste. Genevieve | Missouri | 29186 | 1852 | 17 |
1485901 | 1485901 | 2021-07-05 | Clark | Illinois | 17023 | 1852 | 41 |
1482655 | 1482655 | 2021-07-04 | Clark | Illinois | 17023 | 1852 | 41 |
1479408 | 1479408 | 2021-07-03 | Clark | Illinois | 17023 | 1852 | 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);