ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
373 rows where cases = 1227 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 43
- Idaho 22
- Mississippi 21
- West Virginia 21
- Puerto Rico 17
- Kentucky 16
- Kansas 15
- Michigan 15
- Iowa 14
- Georgia 13
- Virginia 13
- Missouri 11
- Indiana 10
- Colorado 9
- Minnesota 9
- Tennessee 9
- Wyoming 9
- Alabama 7
- Nebraska 7
- Florida 6
- Illinois 6
- Montana 6
- North Dakota 6
- Oregon 6
- Wisconsin 6
- Arkansas 5
- Louisiana 5
- New Mexico 4
- North Carolina 4
- Pennsylvania 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491524 | 2491524 | 2022-05-10 | Kearney | Nebraska | 31099 | 1227 | 9 |
2488266 | 2488266 | 2022-05-09 | Kearney | Nebraska | 31099 | 1227 | 9 |
2466124 | 2466124 | 2022-05-02 | Las Marias | Puerto Rico | 72083 | 1227 | |
2267958 | 2267958 | 2022-03-02 | Garza | Texas | 48169 | 1227 | 27 |
2264705 | 2264705 | 2022-03-01 | Garza | Texas | 48169 | 1227 | 27 |
2261455 | 2261455 | 2022-02-28 | Garza | Texas | 48169 | 1227 | 27 |
2261572 | 2261572 | 2022-02-28 | Sabine | Texas | 48403 | 1227 | 85 |
2258204 | 2258204 | 2022-02-27 | Garza | Texas | 48169 | 1227 | 27 |
2258321 | 2258321 | 2022-02-27 | Sabine | Texas | 48403 | 1227 | 85 |
2254953 | 2254953 | 2022-02-26 | Garza | Texas | 48169 | 1227 | 27 |
2255070 | 2255070 | 2022-02-26 | Sabine | Texas | 48403 | 1227 | 84 |
2251819 | 2251819 | 2022-02-25 | Sabine | Texas | 48403 | 1227 | 83 |
2244751 | 2244751 | 2022-02-23 | Wallowa | Oregon | 41063 | 1227 | 14 |
2220737 | 2220737 | 2022-02-16 | Ballard | Kentucky | 21007 | 1227 | 27 |
2217486 | 2217486 | 2022-02-15 | Ballard | Kentucky | 21007 | 1227 | 27 |
2197552 | 2197552 | 2022-02-09 | Lemhi | Idaho | 16059 | 1227 | 25 |
2193857 | 2193857 | 2022-02-08 | Lafayette | Arkansas | 5073 | 1227 | 28 |
2185176 | 2185176 | 2022-02-05 | Unknown | Maryland | 1227 | 184 | |
2183485 | 2183485 | 2022-02-04 | McCulloch | Texas | 48307 | 1227 | 42 |
2156718 | 2156718 | 2022-01-27 | Sioux | North Dakota | 38085 | 1227 | 19 |
2120577 | 2120577 | 2022-01-16 | Dawes | Nebraska | 31045 | 1227 | 21 |
2117325 | 2117325 | 2022-01-15 | Dawes | Nebraska | 31045 | 1227 | 21 |
2114074 | 2114074 | 2022-01-14 | Dawes | Nebraska | 31045 | 1227 | 21 |
2109384 | 2109384 | 2022-01-13 | Clear Creek | Colorado | 8019 | 1227 | 10 |
2110440 | 2110440 | 2022-01-13 | Oscoda | Michigan | 26135 | 1227 | 51 |
2107189 | 2107189 | 2022-01-12 | Oscoda | Michigan | 26135 | 1227 | 51 |
2100937 | 2100937 | 2022-01-10 | Maries | Missouri | 29125 | 1227 | 25 |
2098804 | 2098804 | 2022-01-09 | Crosby | Texas | 48107 | 1227 | 42 |
2099064 | 2099064 | 2022-01-09 | Bland | Virginia | 51021 | 1227 | 18 |
2095813 | 2095813 | 2022-01-08 | Bland | Virginia | 51021 | 1227 | 18 |
2092561 | 2092561 | 2022-01-07 | Bland | Virginia | 51021 | 1227 | 18 |
2081184 | 2081184 | 2022-01-04 | Schoolcraft | Michigan | 26153 | 1227 | 9 |
2077932 | 2077932 | 2022-01-03 | Schoolcraft | Michigan | 26153 | 1227 | 9 |
2076143 | 2076143 | 2022-01-02 | Marion | Texas | 48315 | 1227 | 55 |
2072892 | 2072892 | 2022-01-01 | Marion | Texas | 48315 | 1227 | 55 |
2069641 | 2069641 | 2021-12-31 | Marion | Texas | 48315 | 1227 | 55 |
2066390 | 2066390 | 2021-12-30 | Marion | Texas | 48315 | 1227 | 55 |
2063140 | 2063140 | 2021-12-29 | Marion | Texas | 48315 | 1227 | 53 |
2059890 | 2059890 | 2021-12-28 | Marion | Texas | 48315 | 1227 | 53 |
2037771 | 2037771 | 2021-12-22 | Monroe | Arkansas | 5095 | 1227 | 26 |
2037030 | 2037030 | 2021-12-21 | Coleman | Texas | 48083 | 1227 | 58 |
2032857 | 2032857 | 2021-12-20 | Richardson | Nebraska | 31147 | 1227 | 24 |
2028139 | 2028139 | 2021-12-19 | Kit Carson | Colorado | 8063 | 1227 | 24 |
2024888 | 2024888 | 2021-12-18 | Kit Carson | Colorado | 8063 | 1227 | 24 |
2021637 | 2021637 | 2021-12-17 | Kit Carson | Colorado | 8063 | 1227 | 24 |
2016387 | 2016387 | 2021-12-15 | Daviess | Missouri | 29061 | 1227 | 17 |
2005586 | 2005586 | 2021-12-12 | Lincoln | Georgia | 13181 | 1227 | 33 |
2002335 | 2002335 | 2021-12-11 | Lincoln | Georgia | 13181 | 1227 | 33 |
2003373 | 2003373 | 2021-12-11 | Chariton | Missouri | 29041 | 1227 | 30 |
1999085 | 1999085 | 2021-12-10 | Lincoln | Georgia | 13181 | 1227 | 33 |
1997597 | 1997597 | 2021-12-09 | Harney | Oregon | 41025 | 1227 | 33 |
1983250 | 1983250 | 2021-12-05 | Anderson | Kansas | 20003 | 1227 | 22 |
1980000 | 1980000 | 2021-12-04 | Anderson | Kansas | 20003 | 1227 | 22 |
1976750 | 1976750 | 2021-12-03 | Anderson | Kansas | 20003 | 1227 | 22 |
1962747 | 1962747 | 2021-11-28 | Tucker | West Virginia | 54093 | 1227 | 31 |
1959496 | 1959496 | 2021-11-27 | Tucker | West Virginia | 54093 | 1227 | 31 |
1956245 | 1956245 | 2021-11-26 | Tucker | West Virginia | 54093 | 1227 | 31 |
1952994 | 1952994 | 2021-11-25 | Tucker | West Virginia | 54093 | 1227 | 31 |
1949743 | 1949743 | 2021-11-24 | Tucker | West Virginia | 54093 | 1227 | 31 |
1941634 | 1941634 | 2021-11-22 | Hickory | Missouri | 29085 | 1227 | 43 |
1938686 | 1938686 | 2021-11-21 | Sierra | New Mexico | 35051 | 1227 | 58 |
1935436 | 1935436 | 2021-11-20 | Sierra | New Mexico | 35051 | 1227 | 58 |
1932186 | 1932186 | 2021-11-19 | Sierra | New Mexico | 35051 | 1227 | 58 |
1924935 | 1924935 | 2021-11-17 | Nicholas | Kentucky | 21181 | 1227 | 20 |
1915528 | 1915528 | 2021-11-14 | Franklin | Mississippi | 28037 | 1227 | 28 |
1912278 | 1912278 | 2021-11-13 | Franklin | Mississippi | 28037 | 1227 | 28 |
1909028 | 1909028 | 2021-11-12 | Franklin | Mississippi | 28037 | 1227 | 28 |
1894582 | 1894582 | 2021-11-07 | Johnson | Wyoming | 56019 | 1227 | 16 |
1891332 | 1891332 | 2021-11-06 | Johnson | Wyoming | 56019 | 1227 | 16 |
1888082 | 1888082 | 2021-11-05 | Johnson | Wyoming | 56019 | 1227 | 16 |
1877138 | 1877138 | 2021-11-02 | Pembina | North Dakota | 38067 | 1227 | 13 |
1872640 | 1872640 | 2021-11-01 | Warren | Indiana | 18171 | 1227 | 18 |
1873455 | 1873455 | 2021-11-01 | Sullivan | Missouri | 29211 | 1227 | 14 |
1870206 | 1870206 | 2021-10-31 | Sullivan | Missouri | 29211 | 1227 | 14 |
1864975 | 1864975 | 2021-10-29 | Winkler | Texas | 48495 | 1227 | 29 |
1856718 | 1856718 | 2021-10-27 | Trimble | Kentucky | 21223 | 1227 | 17 |
1858368 | 1858368 | 2021-10-27 | La Salle | Texas | 48283 | 1227 | 40 |
1858711 | 1858711 | 2021-10-27 | Clay | West Virginia | 54015 | 1227 | 20 |
1855119 | 1855119 | 2021-10-26 | La Salle | Texas | 48283 | 1227 | 40 |
1837018 | 1837018 | 2021-10-21 | Clay | Kansas | 20027 | 1227 | 31 |
1839071 | 1839071 | 2021-10-21 | Essex | Virginia | 51057 | 1227 | 17 |
1833769 | 1833769 | 2021-10-20 | Clay | Kansas | 20027 | 1227 | 31 |
1832239 | 1832239 | 2021-10-19 | Archer | Texas | 48009 | 1227 | 19 |
1813896 | 1813896 | 2021-10-14 | Treutlen | Georgia | 13283 | 1227 | 45 |
1805270 | 1805270 | 2021-10-11 | Powell | Montana | 30077 | 1227 | 14 |
1802021 | 1802021 | 2021-10-10 | Powell | Montana | 30077 | 1227 | 14 |
1798772 | 1798772 | 2021-10-09 | Powell | Montana | 30077 | 1227 | 14 |
1795523 | 1795523 | 2021-10-08 | Powell | Montana | 30077 | 1227 | 14 |
1792998 | 1792998 | 2021-10-07 | Luquillo | Puerto Rico | 72089 | 1227 | |
1788970 | 1788970 | 2021-10-06 | St. Clair | Missouri | 29185 | 1227 | 14 |
1789749 | 1789749 | 2021-10-06 | Luquillo | Puerto Rico | 72089 | 1227 | |
1783353 | 1783353 | 2021-10-04 | Custer | South Dakota | 46033 | 1227 | 15 |
1774406 | 1774406 | 2021-10-02 | Greene | Alabama | 1063 | 1227 | 44 |
1747954 | 1747954 | 2021-09-23 | Red River | Texas | 48387 | 1227 | 45 |
1741296 | 1741296 | 2021-09-21 | Castro | Texas | 48069 | 1227 | 33 |
1729048 | 1729048 | 2021-09-18 | Nevada | Arkansas | 5099 | 1227 | 30 |
1722448 | 1722448 | 2021-09-16 | Sumter | Alabama | 1119 | 1227 | 35 |
1717783 | 1717783 | 2021-09-14 | Schuyler | New York | 36097 | 1227 | 16 |
1715818 | 1715818 | 2021-09-13 | Forest | Wisconsin | 55041 | 1227 | 28 |
1694793 | 1694793 | 2021-09-07 | Jefferson | Montana | 30043 | 1227 | 9 |
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);