ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
323 rows where cases = 1949 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 41
- Oklahoma 25
- Texas 21
- Virginia 16
- Arkansas 15
- Illinois 12
- Georgia 11
- Kentucky 11
- Minnesota 11
- Puerto Rico 11
- Tennessee 11
- Florida 10
- Nebraska 10
- North Dakota 10
- Missouri 9
- Alabama 8
- Louisiana 8
- Montana 8
- Ohio 8
- North Carolina 7
- Michigan 6
- Oregon 6
- Mississippi 5
- Washington 5
- Colorado 4
- Idaho 4
- Indiana 4
- Kansas 4
- Maryland 4
- South Carolina 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2352520 | 2352520 | 2022-03-28 | Floyd | Texas | 48153 | 1949 | 48 |
2347248 | 2347248 | 2022-03-27 | Schuyler | Illinois | 17169 | 1949 | 29 |
2349268 | 2349268 | 2022-03-27 | Floyd | Texas | 48153 | 1949 | 48 |
2343995 | 2343995 | 2022-03-26 | Schuyler | Illinois | 17169 | 1949 | 29 |
2346015 | 2346015 | 2022-03-26 | Floyd | Texas | 48153 | 1949 | 48 |
2340742 | 2340742 | 2022-03-25 | Schuyler | Illinois | 17169 | 1949 | 29 |
2337489 | 2337489 | 2022-03-24 | Schuyler | Illinois | 17169 | 1949 | 29 |
2334235 | 2334235 | 2022-03-23 | Schuyler | Illinois | 17169 | 1949 | 29 |
2333265 | 2333265 | 2022-03-22 | Fairfax city | Virginia | 51600 | 1949 | 42 |
2330012 | 2330012 | 2022-03-21 | Fairfax city | Virginia | 51600 | 1949 | 42 |
2326760 | 2326760 | 2022-03-20 | Fairfax city | Virginia | 51600 | 1949 | 43 |
2323507 | 2323507 | 2022-03-19 | Fairfax city | Virginia | 51600 | 1949 | 43 |
2320253 | 2320253 | 2022-03-18 | Fairfax city | Virginia | 51600 | 1949 | 43 |
2313981 | 2313981 | 2022-03-16 | Pepin | Wisconsin | 55091 | 1949 | 18 |
2310493 | 2310493 | 2022-03-15 | Fairfax city | Virginia | 51600 | 1949 | 43 |
2260783 | 2260783 | 2022-02-28 | Pembina | North Dakota | 38067 | 1949 | 16 |
2257532 | 2257532 | 2022-02-27 | Pembina | North Dakota | 38067 | 1949 | 16 |
2254281 | 2254281 | 2022-02-26 | Pembina | North Dakota | 38067 | 1949 | 16 |
2223326 | 2223326 | 2022-02-17 | Glades | Florida | 12043 | 1949 | 35 |
2220075 | 2220075 | 2022-02-16 | Glades | Florida | 12043 | 1949 | 35 |
2216824 | 2216824 | 2022-02-15 | Glades | Florida | 12043 | 1949 | 34 |
2218172 | 2218172 | 2022-02-15 | Custer | Nebraska | 31041 | 1949 | 28 |
2219204 | 2219204 | 2022-02-15 | Hamilton | Texas | 48193 | 1949 | 30 |
2213573 | 2213573 | 2022-02-14 | Glades | Florida | 12043 | 1949 | 34 |
2215953 | 2215953 | 2022-02-14 | Hamilton | Texas | 48193 | 1949 | 30 |
2210321 | 2210321 | 2022-02-13 | Glades | Florida | 12043 | 1949 | 34 |
2212702 | 2212702 | 2022-02-13 | Hamilton | Texas | 48193 | 1949 | 30 |
2207068 | 2207068 | 2022-02-12 | Glades | Florida | 12043 | 1949 | 34 |
2203815 | 2203815 | 2022-02-11 | Glades | Florida | 12043 | 1949 | 34 |
2174369 | 2174369 | 2022-02-02 | Searcy | Arkansas | 5129 | 1949 | 37 |
2175225 | 2175225 | 2022-02-02 | Cumberland | Kentucky | 21057 | 1949 | 23 |
2170495 | 2170495 | 2022-01-31 | Ochiltree | Texas | 48357 | 1949 | 42 |
2167241 | 2167241 | 2022-01-30 | Ochiltree | Texas | 48357 | 1949 | 42 |
2163887 | 2163887 | 2022-01-29 | Franklin | Texas | 48159 | 1949 | 37 |
2163986 | 2163986 | 2022-01-29 | Ochiltree | Texas | 48357 | 1949 | 42 |
2146624 | 2146624 | 2022-01-24 | Hamilton | Nebraska | 31081 | 1949 | 22 |
2143193 | 2143193 | 2022-01-23 | Gentry | Missouri | 29075 | 1949 | 28 |
2123275 | 2123275 | 2022-01-17 | East Carroll | Louisiana | 22035 | 1949 | 33 |
2125214 | 2125214 | 2022-01-17 | Jefferson | Washington | 53031 | 1949 | 22 |
2120023 | 2120023 | 2022-01-16 | East Carroll | Louisiana | 22035 | 1949 | 33 |
2121962 | 2121962 | 2022-01-16 | Jefferson | Washington | 53031 | 1949 | 22 |
2116771 | 2116771 | 2022-01-15 | East Carroll | Louisiana | 22035 | 1949 | 33 |
2118710 | 2118710 | 2022-01-15 | Jefferson | Washington | 53031 | 1949 | 22 |
2113520 | 2113520 | 2022-01-14 | East Carroll | Louisiana | 22035 | 1949 | 33 |
2115458 | 2115458 | 2022-01-14 | Jefferson | Washington | 53031 | 1949 | 22 |
2084704 | 2084704 | 2022-01-05 | Ralls | Missouri | 29173 | 1949 | 19 |
2073964 | 2073964 | 2022-01-02 | Washington | Idaho | 16087 | 1949 | 47 |
2070713 | 2070713 | 2022-01-01 | Washington | Idaho | 16087 | 1949 | 47 |
2067462 | 2067462 | 2021-12-31 | Washington | Idaho | 16087 | 1949 | 47 |
2063902 | 2063902 | 2021-12-30 | Park | Colorado | 8093 | 1949 | 14 |
2064211 | 2064211 | 2021-12-30 | Washington | Idaho | 16087 | 1949 | 47 |
2040880 | 2040880 | 2021-12-23 | Conecuh | Alabama | 1035 | 1949 | 62 |
2033147 | 2033147 | 2021-12-20 | Mercer | North Dakota | 38057 | 1949 | 21 |
2029365 | 2029365 | 2021-12-19 | Barton | Missouri | 29011 | 1949 | 40 |
2029620 | 2029620 | 2021-12-19 | Unknown | Nebraska | 1949 | 276 | |
2029897 | 2029897 | 2021-12-19 | Mercer | North Dakota | 38057 | 1949 | 21 |
2026369 | 2026369 | 2021-12-18 | Unknown | Nebraska | 1949 | 271 | |
2026646 | 2026646 | 2021-12-18 | Mercer | North Dakota | 38057 | 1949 | 21 |
2023118 | 2023118 | 2021-12-17 | Unknown | Nebraska | 1949 | 260 | |
2023395 | 2023395 | 2021-12-17 | Mercer | North Dakota | 38057 | 1949 | 21 |
2009468 | 2009468 | 2021-12-13 | Todd | Kentucky | 21219 | 1949 | 36 |
2009914 | 2009914 | 2021-12-13 | Linn | Missouri | 29115 | 1949 | 57 |
2010503 | 2010503 | 2021-12-13 | Vinton | Ohio | 39163 | 1949 | 40 |
2010595 | 2010595 | 2021-12-13 | Curry | Oregon | 41015 | 1949 | 39 |
2010700 | 2010700 | 2021-12-13 | Barranquitas | Puerto Rico | 72019 | 1949 | |
2006663 | 2006663 | 2021-12-12 | Linn | Missouri | 29115 | 1949 | 57 |
2007449 | 2007449 | 2021-12-12 | Barranquitas | Puerto Rico | 72019 | 1949 | |
2004198 | 2004198 | 2021-12-11 | Barranquitas | Puerto Rico | 72019 | 1949 | |
2000947 | 2000947 | 2021-12-10 | Barranquitas | Puerto Rico | 72019 | 1949 | |
1997926 | 1997926 | 2021-12-09 | Houston | Tennessee | 47083 | 1949 | 46 |
1994448 | 1994448 | 2021-12-08 | Cabo Rojo | Puerto Rico | 72023 | 1949 | |
1994675 | 1994675 | 2021-12-08 | Houston | Tennessee | 47083 | 1949 | 46 |
1968306 | 1968306 | 2021-11-30 | Noble | Oklahoma | 40103 | 1949 | 30 |
1965055 | 1965055 | 2021-11-29 | Noble | Oklahoma | 40103 | 1949 | 30 |
1961011 | 1961011 | 2021-11-28 | Watonwan | Minnesota | 27165 | 1949 | 20 |
1961803 | 1961803 | 2021-11-28 | Noble | Oklahoma | 40103 | 1949 | 30 |
1957760 | 1957760 | 2021-11-27 | Watonwan | Minnesota | 27165 | 1949 | 20 |
1958552 | 1958552 | 2021-11-27 | Noble | Oklahoma | 40103 | 1949 | 30 |
1954509 | 1954509 | 2021-11-26 | Watonwan | Minnesota | 27165 | 1949 | 20 |
1955301 | 1955301 | 2021-11-26 | Noble | Oklahoma | 40103 | 1949 | 30 |
1952050 | 1952050 | 2021-11-25 | Noble | Oklahoma | 40103 | 1949 | 30 |
1948799 | 1948799 | 2021-11-24 | Noble | Oklahoma | 40103 | 1949 | 30 |
1944154 | 1944154 | 2021-11-23 | Calhoun | Iowa | 19025 | 1949 | 19 |
1940904 | 1940904 | 2021-11-22 | Calhoun | Iowa | 19025 | 1949 | 19 |
1937654 | 1937654 | 2021-11-21 | Calhoun | Iowa | 19025 | 1949 | 19 |
1934404 | 1934404 | 2021-11-20 | Calhoun | Iowa | 19025 | 1949 | 19 |
1935947 | 1935947 | 2021-11-20 | Cidra | Puerto Rico | 72041 | 1949 | |
1931153 | 1931153 | 2021-11-19 | Calhoun | Iowa | 19025 | 1949 | 19 |
1927902 | 1927902 | 2021-11-18 | Calhoun | Iowa | 19025 | 1949 | 19 |
1924652 | 1924652 | 2021-11-17 | Calhoun | Iowa | 19025 | 1949 | 19 |
1922942 | 1922942 | 2021-11-16 | Catano | Puerto Rico | 72033 | 1949 | |
1919693 | 1919693 | 2021-11-15 | Catano | Puerto Rico | 72033 | 1949 | |
1912877 | 1912877 | 2021-11-13 | McLean | North Dakota | 38055 | 1949 | 41 |
1894339 | 1894339 | 2021-11-07 | King William | Virginia | 51101 | 1949 | 24 |
1891089 | 1891089 | 2021-11-06 | King William | Virginia | 51101 | 1949 | 24 |
1887839 | 1887839 | 2021-11-05 | King William | Virginia | 51101 | 1949 | 24 |
1879676 | 1879676 | 2021-11-03 | Aitkin | Minnesota | 27001 | 1949 | 46 |
1875955 | 1875955 | 2021-11-02 | Lyon | Iowa | 19119 | 1949 | 42 |
1872706 | 1872706 | 2021-11-01 | Lyon | Iowa | 19119 | 1949 | 42 |
1869457 | 1869457 | 2021-10-31 | Lyon | Iowa | 19119 | 1949 | 42 |
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);