ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
895 rows where cases = 218 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 68
- Kansas 66
- Georgia 48
- North Dakota 38
- Kentucky 36
- Nebraska 34
- Illinois 32
- Puerto Rico 32
- Missouri 30
- New York 30
- Virginia 29
- North Carolina 25
- West Virginia 24
- Florida 23
- Indiana 23
- Mississippi 22
- South Dakota 21
- Iowa 19
- Tennessee 19
- Wisconsin 19
- Washington 18
- Alabama 16
- Arkansas 16
- Louisiana 16
- Montana 16
- Ohio 14
- Pennsylvania 14
- Virgin Islands 14
- Minnesota 13
- Colorado 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2237624 | 2237624 | 2022-02-21 | Judith Basin | Montana | 30045 | 218 | 1 |
2234373 | 2234373 | 2022-02-20 | Judith Basin | Montana | 30045 | 218 | 1 |
2231122 | 2231122 | 2022-02-19 | Judith Basin | Montana | 30045 | 218 | 1 |
2227871 | 2227871 | 2022-02-18 | Judith Basin | Montana | 30045 | 218 | 1 |
2224620 | 2224620 | 2022-02-17 | Judith Basin | Montana | 30045 | 218 | 1 |
2219229 | 2219229 | 2022-02-15 | Jeff Davis | Texas | 48243 | 218 | 9 |
2215978 | 2215978 | 2022-02-14 | Jeff Davis | Texas | 48243 | 218 | 9 |
2212727 | 2212727 | 2022-02-13 | Jeff Davis | Texas | 48243 | 218 | 9 |
2209474 | 2209474 | 2022-02-12 | Jeff Davis | Texas | 48243 | 218 | 9 |
2206221 | 2206221 | 2022-02-11 | Jeff Davis | Texas | 48243 | 218 | 9 |
2202968 | 2202968 | 2022-02-10 | Jeff Davis | Texas | 48243 | 218 | 9 |
2199714 | 2199714 | 2022-02-09 | Jeff Davis | Texas | 48243 | 218 | 8 |
2130085 | 2130085 | 2022-01-19 | Issaquena | Mississippi | 28055 | 218 | 7 |
2130262 | 2130262 | 2022-01-19 | Carter | Montana | 30011 | 218 | 5 |
2127008 | 2127008 | 2022-01-18 | Carter | Montana | 30011 | 218 | 5 |
2123756 | 2123756 | 2022-01-17 | Carter | Montana | 30011 | 218 | 5 |
2120504 | 2120504 | 2022-01-16 | Carter | Montana | 30011 | 218 | 5 |
2117252 | 2117252 | 2022-01-15 | Carter | Montana | 30011 | 218 | 5 |
2114001 | 2114001 | 2022-01-14 | Carter | Montana | 30011 | 218 | 5 |
2110749 | 2110749 | 2022-01-13 | Carter | Montana | 30011 | 218 | 5 |
2107498 | 2107498 | 2022-01-12 | Carter | Montana | 30011 | 218 | 5 |
2108400 | 2108400 | 2022-01-12 | Sully | South Dakota | 46119 | 218 | 3 |
2101849 | 2101849 | 2022-01-10 | Campbell | South Dakota | 46021 | 218 | 6 |
2098872 | 2098872 | 2022-01-09 | Jeff Davis | Texas | 48243 | 218 | 6 |
2095620 | 2095620 | 2022-01-08 | Jeff Davis | Texas | 48243 | 218 | 6 |
2089264 | 2089264 | 2022-01-06 | Piute | Utah | 49031 | 218 | 2 |
1994601 | 1994601 | 2021-12-08 | Hyde | South Dakota | 46069 | 218 | 5 |
1991350 | 1991350 | 2021-12-07 | Hyde | South Dakota | 46069 | 218 | 5 |
1987649 | 1987649 | 2021-12-06 | Sheridan | North Dakota | 38083 | 218 | 4 |
1988099 | 1988099 | 2021-12-06 | Hyde | South Dakota | 46069 | 218 | 5 |
1984399 | 1984399 | 2021-12-05 | Sheridan | North Dakota | 38083 | 218 | 4 |
1984849 | 1984849 | 2021-12-05 | Hyde | South Dakota | 46069 | 218 | 5 |
1981599 | 1981599 | 2021-12-04 | Hyde | South Dakota | 46069 | 218 | 5 |
1978349 | 1978349 | 2021-12-03 | Hyde | South Dakota | 46069 | 218 | 5 |
1972835 | 1972835 | 2021-12-02 | Sierra | California | 6091 | 218 | 0 |
1969585 | 1969585 | 2021-12-01 | Sierra | California | 6091 | 218 | 0 |
1966335 | 1966335 | 2021-11-30 | Sierra | California | 6091 | 218 | 0 |
1963083 | 1963083 | 2021-11-29 | Sierra | California | 6091 | 218 | 0 |
1870417 | 1870417 | 2021-10-31 | Catron | New Mexico | 35003 | 218 | 7 |
1867168 | 1867168 | 2021-10-30 | Catron | New Mexico | 35003 | 218 | 7 |
1863919 | 1863919 | 2021-10-29 | Catron | New Mexico | 35003 | 218 | 7 |
1851754 | 1851754 | 2021-10-25 | Briscoe | Texas | 48045 | 218 | 7 |
1848504 | 1848504 | 2021-10-24 | Briscoe | Texas | 48045 | 218 | 7 |
1845254 | 1845254 | 2021-10-23 | Briscoe | Texas | 48045 | 218 | 7 |
1842004 | 1842004 | 2021-10-22 | Briscoe | Texas | 48045 | 218 | 7 |
1838755 | 1838755 | 2021-10-21 | Briscoe | Texas | 48045 | 218 | 7 |
1831223 | 1831223 | 2021-10-19 | Worth | Missouri | 29227 | 218 | 2 |
1827974 | 1827974 | 2021-10-18 | Worth | Missouri | 29227 | 218 | 2 |
1824725 | 1824725 | 2021-10-17 | Worth | Missouri | 29227 | 218 | 2 |
1821476 | 1821476 | 2021-10-16 | Worth | Missouri | 29227 | 218 | 2 |
1818227 | 1818227 | 2021-10-15 | Worth | Missouri | 29227 | 218 | 2 |
1814978 | 1814978 | 2021-10-14 | Worth | Missouri | 29227 | 218 | 2 |
1811730 | 1811730 | 2021-10-13 | Worth | Missouri | 29227 | 218 | 2 |
1808481 | 1808481 | 2021-10-12 | Worth | Missouri | 29227 | 218 | 2 |
1803692 | 1803692 | 2021-10-11 | Haines Borough | Alaska | 2100 | 218 | 0 |
1805230 | 1805230 | 2021-10-11 | Worth | Missouri | 29227 | 218 | 2 |
1801981 | 1801981 | 2021-10-10 | Worth | Missouri | 29227 | 218 | 2 |
1803439 | 1803439 | 2021-10-10 | Garfield | Washington | 53023 | 218 | 7 |
1798732 | 1798732 | 2021-10-09 | Worth | Missouri | 29227 | 218 | 2 |
1800190 | 1800190 | 2021-10-09 | Garfield | Washington | 53023 | 218 | 7 |
1795483 | 1795483 | 2021-10-08 | Worth | Missouri | 29227 | 218 | 2 |
1796941 | 1796941 | 2021-10-08 | Garfield | Washington | 53023 | 218 | 7 |
1792234 | 1792234 | 2021-10-07 | Worth | Missouri | 29227 | 218 | 2 |
1788985 | 1788985 | 2021-10-06 | Worth | Missouri | 29227 | 218 | 2 |
1765970 | 1765970 | 2021-09-29 | Cook | Minnesota | 27031 | 218 | 0 |
1763085 | 1763085 | 2021-09-28 | Gosper | Nebraska | 31073 | 218 | 5 |
1759769 | 1759769 | 2021-09-27 | Liberty | Montana | 30051 | 218 | 1 |
1754954 | 1754954 | 2021-09-26 | Denali Borough | Alaska | 2068 | 218 | 1 |
1751706 | 1751706 | 2021-09-25 | Denali Borough | Alaska | 2068 | 218 | 1 |
1748457 | 1748457 | 2021-09-24 | Denali Borough | Alaska | 2068 | 218 | 1 |
1746956 | 1746956 | 2021-09-23 | De Baca | New Mexico | 35011 | 218 | 3 |
1743707 | 1743707 | 2021-09-22 | De Baca | New Mexico | 35011 | 218 | 3 |
1716435 | 1716435 | 2021-09-14 | Webster | Georgia | 13307 | 218 | 4 |
1715738 | 1715738 | 2021-09-13 | Wahkiakum | Washington | 53069 | 218 | 5 |
1648613 | 1648613 | 2021-08-24 | Hamilton | Kansas | 20075 | 218 | 1 |
1645365 | 1645365 | 2021-08-23 | Hamilton | Kansas | 20075 | 218 | 1 |
1625879 | 1625879 | 2021-08-17 | Jewell | Kansas | 20089 | 218 | 6 |
1622632 | 1622632 | 2021-08-16 | Jewell | Kansas | 20089 | 218 | 6 |
1620851 | 1620851 | 2021-08-15 | Vieques | Puerto Rico | 72147 | 218 | |
1617603 | 1617603 | 2021-08-14 | Vieques | Puerto Rico | 72147 | 218 | |
1606019 | 1606019 | 2021-08-11 | Butte | Idaho | 16023 | 218 | 1 |
1581091 | 1581091 | 2021-08-03 | Granite | Montana | 30039 | 218 | 2 |
1566132 | 1566132 | 2021-07-29 | Grand Isle | Vermont | 50013 | 218 | 2 |
1557719 | 1557719 | 2021-07-27 | Wichita | Kansas | 20203 | 218 | 6 |
1558981 | 1558981 | 2021-07-27 | Wallowa | Oregon | 41063 | 218 | 6 |
1559351 | 1559351 | 2021-07-27 | Armstrong | Texas | 48011 | 218 | 7 |
1559509 | 1559509 | 2021-07-27 | Menard | Texas | 48327 | 218 | 9 |
1554472 | 1554472 | 2021-07-26 | Wichita | Kansas | 20203 | 218 | 6 |
1556262 | 1556262 | 2021-07-26 | Menard | Texas | 48327 | 218 | 9 |
1551225 | 1551225 | 2021-07-25 | Wichita | Kansas | 20203 | 218 | 6 |
1553015 | 1553015 | 2021-07-25 | Menard | Texas | 48327 | 218 | 9 |
1547978 | 1547978 | 2021-07-24 | Wichita | Kansas | 20203 | 218 | 6 |
1544731 | 1544731 | 2021-07-23 | Wichita | Kansas | 20203 | 218 | 6 |
1541483 | 1541483 | 2021-07-22 | Wichita | Kansas | 20203 | 218 | 6 |
1538236 | 1538236 | 2021-07-21 | Wichita | Kansas | 20203 | 218 | 6 |
1534988 | 1534988 | 2021-07-20 | Wichita | Kansas | 20203 | 218 | 6 |
1531741 | 1531741 | 2021-07-19 | Wichita | Kansas | 20203 | 218 | 6 |
1528494 | 1528494 | 2021-07-18 | Wichita | Kansas | 20203 | 218 | 6 |
1525247 | 1525247 | 2021-07-17 | Wichita | Kansas | 20203 | 218 | 6 |
1521999 | 1521999 | 2021-07-16 | Wichita | Kansas | 20203 | 218 | 6 |
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);