ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
280 rows where cases = 1667 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 25
- Arkansas 22
- Texas 22
- Iowa 16
- North Carolina 16
- Tennessee 14
- Georgia 13
- Missouri 13
- Puerto Rico 12
- Minnesota 10
- Virginia 10
- Alabama 9
- Montana 8
- Mississippi 7
- Colorado 6
- Indiana 6
- Louisiana 6
- Kentucky 5
- Nebraska 5
- New Mexico 4
- North Dakota 4
- Pennsylvania 4
- Wisconsin 4
- California 3
- Connecticut 3
- Florida 3
- Idaho 3
- New York 3
- Ohio 3
- West Virginia 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501302 | 2501302 | 2022-05-13 | Knox | Nebraska | 31107 | 1667 | 13 |
2359872 | 2359872 | 2022-03-31 | Rio Blanco | Colorado | 8103 | 1667 | 13 |
2356618 | 2356618 | 2022-03-30 | Rio Blanco | Colorado | 8103 | 1667 | 13 |
2358566 | 2358566 | 2022-03-30 | Grant | Oregon | 41023 | 1667 | 20 |
2355312 | 2355312 | 2022-03-29 | Grant | Oregon | 41023 | 1667 | 20 |
2279785 | 2279785 | 2022-03-06 | Daviess | Missouri | 29061 | 1667 | 26 |
2276532 | 2276532 | 2022-03-05 | Daviess | Missouri | 29061 | 1667 | 26 |
2273279 | 2273279 | 2022-03-04 | Daviess | Missouri | 29061 | 1667 | 26 |
2263662 | 2263662 | 2022-03-01 | Valley | Montana | 30105 | 1667 | 36 |
2196331 | 2196331 | 2022-02-08 | Van Buren | Tennessee | 47175 | 1667 | 45 |
2193077 | 2193077 | 2022-02-07 | Van Buren | Tennessee | 47175 | 1667 | 45 |
2187365 | 2187365 | 2022-02-06 | Newton | Arkansas | 5101 | 1667 | 45 |
2187882 | 2187882 | 2022-02-06 | Pulaski | Illinois | 17153 | 1667 | 16 |
2189823 | 2189823 | 2022-02-06 | Van Buren | Tennessee | 47175 | 1667 | 45 |
2184112 | 2184112 | 2022-02-05 | Newton | Arkansas | 5101 | 1667 | 45 |
2184629 | 2184629 | 2022-02-05 | Pulaski | Illinois | 17153 | 1667 | 16 |
2186570 | 2186570 | 2022-02-05 | Van Buren | Tennessee | 47175 | 1667 | 45 |
2181377 | 2181377 | 2022-02-04 | Pulaski | Illinois | 17153 | 1667 | 16 |
2183318 | 2183318 | 2022-02-04 | Van Buren | Tennessee | 47175 | 1667 | 45 |
2183806 | 2183806 | 2022-02-04 | Calhoun | West Virginia | 54013 | 1667 | 10 |
2177609 | 2177609 | 2022-02-03 | Newton | Arkansas | 5101 | 1667 | 45 |
2180066 | 2180066 | 2022-02-03 | Van Buren | Tennessee | 47175 | 1667 | 45 |
2176815 | 2176815 | 2022-02-02 | Van Buren | Tennessee | 47175 | 1667 | 45 |
2146921 | 2146921 | 2022-01-24 | Benson | North Dakota | 38005 | 1667 | 22 |
2143667 | 2143667 | 2022-01-23 | Benson | North Dakota | 38005 | 1667 | 22 |
2132362 | 2132362 | 2022-01-20 | Irwin | Georgia | 13155 | 1667 | 42 |
2130067 | 2130067 | 2022-01-19 | Choctaw | Mississippi | 28019 | 1667 | 27 |
2125911 | 2125911 | 2022-01-18 | Taylor | Georgia | 13269 | 1667 | 43 |
2124080 | 2124080 | 2022-01-17 | Graham | North Carolina | 37075 | 1667 | 28 |
2120828 | 2120828 | 2022-01-16 | Graham | North Carolina | 37075 | 1667 | 28 |
2117576 | 2117576 | 2022-01-15 | Graham | North Carolina | 37075 | 1667 | 28 |
2118784 | 2118784 | 2022-01-15 | Webster | West Virginia | 54101 | 1667 | 27 |
2114325 | 2114325 | 2022-01-14 | Graham | North Carolina | 37075 | 1667 | 28 |
2114715 | 2114715 | 2022-01-14 | Adjuntas | Puerto Rico | 72001 | 1667 | |
2107328 | 2107328 | 2022-01-12 | Kemper | Mississippi | 28069 | 1667 | 42 |
2108272 | 2108272 | 2022-01-12 | Sabana Grande | Puerto Rico | 72121 | 1667 | |
2100754 | 2100754 | 2022-01-10 | Murray | Minnesota | 27101 | 1667 | 14 |
2088061 | 2088061 | 2022-01-06 | Custer | Nebraska | 31041 | 1667 | 23 |
2081434 | 2081434 | 2022-01-04 | Monroe | Missouri | 29137 | 1667 | 34 |
2058076 | 2058076 | 2021-12-28 | Norton | Kansas | 20137 | 1667 | 35 |
2060120 | 2060120 | 2021-12-28 | Nelson | Virginia | 51125 | 1667 | 24 |
2054827 | 2054827 | 2021-12-27 | Norton | Kansas | 20137 | 1667 | 35 |
2037360 | 2037360 | 2021-12-21 | Lexington city | Virginia | 51678 | 1667 | 37 |
2020520 | 2020520 | 2021-12-16 | Yabucoa | Puerto Rico | 72151 | 1667 | |
2010096 | 2010096 | 2021-12-13 | Phelps | Nebraska | 31137 | 1667 | 10 |
2006465 | 2006465 | 2021-12-12 | Jackson | Minnesota | 27063 | 1667 | 16 |
2007106 | 2007106 | 2021-12-12 | Washington | North Carolina | 37187 | 1667 | 37 |
2003214 | 2003214 | 2021-12-11 | Jackson | Minnesota | 27063 | 1667 | 16 |
2003855 | 2003855 | 2021-12-11 | Washington | North Carolina | 37187 | 1667 | 37 |
1999964 | 1999964 | 2021-12-10 | Jackson | Minnesota | 27063 | 1667 | 16 |
2000604 | 2000604 | 2021-12-10 | Washington | North Carolina | 37187 | 1667 | 37 |
1987228 | 1987228 | 2021-12-06 | Deer Lodge | Montana | 30023 | 1667 | 27 |
1983491 | 1983491 | 2021-12-05 | East Carroll | Louisiana | 22035 | 1667 | 32 |
1980241 | 1980241 | 2021-12-04 | East Carroll | Louisiana | 22035 | 1667 | 32 |
1976991 | 1976991 | 2021-12-03 | East Carroll | Louisiana | 22035 | 1667 | 32 |
1963287 | 1963287 | 2021-11-29 | Dooly | Georgia | 13093 | 1667 | 62 |
1943067 | 1943067 | 2021-11-22 | Franklin city | Virginia | 51620 | 1667 | 44 |
1937413 | 1937413 | 2021-11-21 | Boundary | Idaho | 16021 | 1667 | 42 |
1934163 | 1934163 | 2021-11-20 | Boundary | Idaho | 16021 | 1667 | 42 |
1914735 | 1914735 | 2021-11-14 | Jasper | Illinois | 17079 | 1667 | 23 |
1911485 | 1911485 | 2021-11-13 | Jasper | Illinois | 17079 | 1667 | 23 |
1908236 | 1908236 | 2021-11-12 | Jasper | Illinois | 17079 | 1667 | 23 |
1909125 | 1909125 | 2021-11-12 | Douglas | Missouri | 29067 | 1667 | 47 |
1906088 | 1906088 | 2021-11-11 | Red Willow | Nebraska | 31145 | 1667 | 15 |
1862011 | 1862011 | 2021-10-28 | Bayfield | Wisconsin | 55007 | 1667 | 25 |
1844512 | 1844512 | 2021-10-23 | Yates | New York | 36123 | 1667 | 28 |
1833071 | 1833071 | 2021-10-20 | Mono | California | 6051 | 1667 | 5 |
1821081 | 1821081 | 2021-10-16 | Kent | Maryland | 24029 | 1667 | 55 |
1813431 | 1813431 | 2021-10-14 | Wilcox | Alabama | 1131 | 1667 | 38 |
1797254 | 1797254 | 2021-10-09 | Fulton | Arkansas | 5049 | 1667 | 56 |
1793514 | 1793514 | 2021-10-07 | Morgan | Utah | 49029 | 1667 | 11 |
1793825 | 1793825 | 2021-10-07 | Price | Wisconsin | 55099 | 1667 | 9 |
1777798 | 1777798 | 2021-10-03 | Scott | Arkansas | 5127 | 1667 | 25 |
1738837 | 1738837 | 2021-09-21 | Inyo | California | 6027 | 1667 | 39 |
1739997 | 1739997 | 2021-09-21 | Kanabec | Minnesota | 27065 | 1667 | 29 |
1732847 | 1732847 | 2021-09-19 | Blackford | Indiana | 18009 | 1667 | 34 |
1729597 | 1729597 | 2021-09-18 | Blackford | Indiana | 18009 | 1667 | 34 |
1726347 | 1726347 | 2021-09-17 | Blackford | Indiana | 18009 | 1667 | 34 |
1724161 | 1724161 | 2021-09-16 | Humboldt | Nevada | 32013 | 1667 | 17 |
1724871 | 1724871 | 2021-09-16 | Dewey | South Dakota | 46041 | 1667 | 30 |
1721132 | 1721132 | 2021-09-15 | Swain | North Carolina | 37173 | 1667 | 22 |
1695527 | 1695527 | 2021-09-07 | Juana Diaz | Puerto Rico | 72075 | 1667 | |
1679481 | 1679481 | 2021-09-02 | Jackson | Tennessee | 47087 | 1667 | 37 |
1674853 | 1674853 | 2021-09-01 | Hancock | Maine | 23009 | 1667 | 41 |
1671288 | 1671288 | 2021-08-31 | Poweshiek | Iowa | 19157 | 1667 | 36 |
1672380 | 1672380 | 2021-08-31 | Mitchell | North Carolina | 37121 | 1667 | 16 |
1667606 | 1667606 | 2021-08-30 | Early | Georgia | 13099 | 1667 | 50 |
1668041 | 1668041 | 2021-08-30 | Poweshiek | Iowa | 19157 | 1667 | 36 |
1669873 | 1669873 | 2021-08-30 | Gaines | Texas | 48165 | 1667 | 47 |
1664794 | 1664794 | 2021-08-29 | Poweshiek | Iowa | 19157 | 1667 | 36 |
1666626 | 1666626 | 2021-08-29 | Gaines | Texas | 48165 | 1667 | 47 |
1661546 | 1661546 | 2021-08-28 | Poweshiek | Iowa | 19157 | 1667 | 36 |
1663378 | 1663378 | 2021-08-28 | Gaines | Texas | 48165 | 1667 | 47 |
1658298 | 1658298 | 2021-08-27 | Poweshiek | Iowa | 19157 | 1667 | 36 |
1660130 | 1660130 | 2021-08-27 | Gaines | Texas | 48165 | 1667 | 47 |
1655050 | 1655050 | 2021-08-26 | Poweshiek | Iowa | 19157 | 1667 | 36 |
1651803 | 1651803 | 2021-08-25 | Poweshiek | Iowa | 19157 | 1667 | 36 |
1633411 | 1633411 | 2021-08-19 | Polk | North Carolina | 37149 | 1667 | 32 |
1627281 | 1627281 | 2021-08-17 | Cabo Rojo | Puerto Rico | 72023 | 1667 | |
1624034 | 1624034 | 2021-08-16 | Cabo Rojo | Puerto Rico | 72023 | 1667 |
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);