ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
344 rows where cases = 1360 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 28
- Texas 25
- Georgia 23
- Kansas 21
- Kentucky 20
- Mississippi 13
- Puerto Rico 13
- Ohio 11
- Wisconsin 11
- Minnesota 10
- Missouri 10
- Virginia 10
- Washington 10
- Alabama 9
- Arkansas 9
- Illinois 9
- North Carolina 9
- Utah 8
- Colorado 7
- Michigan 7
- Nebraska 7
- West Virginia 7
- South Carolina 6
- Idaho 5
- New Mexico 5
- North Dakota 5
- Tennessee 5
- Indiana 4
- Maryland 4
- Montana 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430662 | 2430662 | 2022-04-21 | Hartley | Texas | 48205 | 1360 | 3 |
2347533 | 2347533 | 2022-03-27 | Phillips | Kansas | 20147 | 1360 | 29 |
2344280 | 2344280 | 2022-03-26 | Phillips | Kansas | 20147 | 1360 | 29 |
2341027 | 2341027 | 2022-03-25 | Phillips | Kansas | 20147 | 1360 | 29 |
2342441 | 2342441 | 2022-03-25 | Maunabo | Puerto Rico | 72095 | 1360 | |
2339188 | 2339188 | 2022-03-24 | Maunabo | Puerto Rico | 72095 | 1360 | |
2335934 | 2335934 | 2022-03-23 | Maunabo | Puerto Rico | 72095 | 1360 | |
2330705 | 2330705 | 2022-03-22 | Calhoun | Georgia | 13037 | 1360 | 22 |
2331266 | 2331266 | 2022-03-22 | Phillips | Kansas | 20147 | 1360 | 29 |
2327453 | 2327453 | 2022-03-21 | Calhoun | Georgia | 13037 | 1360 | 22 |
2328014 | 2328014 | 2022-03-21 | Phillips | Kansas | 20147 | 1360 | 29 |
2324761 | 2324761 | 2022-03-20 | Phillips | Kansas | 20147 | 1360 | 29 |
2321507 | 2321507 | 2022-03-19 | Phillips | Kansas | 20147 | 1360 | 29 |
2318253 | 2318253 | 2022-03-18 | Phillips | Kansas | 20147 | 1360 | 29 |
2315000 | 2315000 | 2022-03-17 | Phillips | Kansas | 20147 | 1360 | 29 |
2311747 | 2311747 | 2022-03-16 | Phillips | Kansas | 20147 | 1360 | 29 |
2301430 | 2301430 | 2022-03-13 | Calhoun | Georgia | 13037 | 1360 | 22 |
2298178 | 2298178 | 2022-03-12 | Calhoun | Georgia | 13037 | 1360 | 22 |
2294926 | 2294926 | 2022-03-11 | Calhoun | Georgia | 13037 | 1360 | 22 |
2259153 | 2259153 | 2022-02-28 | Calhoun | Georgia | 13037 | 1360 | 22 |
2240124 | 2240124 | 2022-02-22 | Van Buren | Iowa | 19177 | 1360 | 26 |
2236873 | 2236873 | 2022-02-21 | Van Buren | Iowa | 19177 | 1360 | 26 |
2233622 | 2233622 | 2022-02-20 | Van Buren | Iowa | 19177 | 1360 | 26 |
2230371 | 2230371 | 2022-02-19 | Van Buren | Iowa | 19177 | 1360 | 26 |
2227120 | 2227120 | 2022-02-18 | Van Buren | Iowa | 19177 | 1360 | 26 |
2223869 | 2223869 | 2022-02-17 | Van Buren | Iowa | 19177 | 1360 | 26 |
2220618 | 2220618 | 2022-02-16 | Van Buren | Iowa | 19177 | 1360 | 26 |
2215755 | 2215755 | 2022-02-14 | Tripp | South Dakota | 46123 | 1360 | 23 |
2188730 | 2188730 | 2022-02-06 | Dade | Missouri | 29057 | 1360 | 38 |
2153433 | 2153433 | 2022-01-26 | Dickey | North Dakota | 38021 | 1360 | 38 |
2146923 | 2146923 | 2022-01-24 | Bottineau | North Dakota | 38009 | 1360 | 24 |
2143669 | 2143669 | 2022-01-23 | Bottineau | North Dakota | 38009 | 1360 | 24 |
2129114 | 2129114 | 2022-01-19 | Jenkins | Georgia | 13165 | 1360 | 63 |
2131584 | 2131584 | 2022-01-19 | Bland | Virginia | 51021 | 1360 | 18 |
2119181 | 2119181 | 2022-01-16 | Rio Blanco | Colorado | 8103 | 1360 | 13 |
2115929 | 2115929 | 2022-01-15 | Rio Blanco | Colorado | 8103 | 1360 | 13 |
2112678 | 2112678 | 2022-01-14 | Rio Blanco | Colorado | 8103 | 1360 | 13 |
2107609 | 2107609 | 2022-01-12 | Merrick | Nebraska | 31121 | 1360 | 15 |
2103490 | 2103490 | 2022-01-11 | Monona | Iowa | 19133 | 1360 | 41 |
2100239 | 2100239 | 2022-01-10 | Monona | Iowa | 19133 | 1360 | 41 |
2096988 | 2096988 | 2022-01-09 | Monona | Iowa | 19133 | 1360 | 41 |
2093736 | 2093736 | 2022-01-08 | Monona | Iowa | 19133 | 1360 | 41 |
2090484 | 2090484 | 2022-01-07 | Monona | Iowa | 19133 | 1360 | 41 |
2087233 | 2087233 | 2022-01-06 | Monona | Iowa | 19133 | 1360 | 41 |
2083981 | 2083981 | 2022-01-05 | Monona | Iowa | 19133 | 1360 | 41 |
2083002 | 2083002 | 2022-01-04 | Pendleton | West Virginia | 54071 | 1360 | 16 |
2062978 | 2062978 | 2021-12-29 | Van Buren | Tennessee | 47175 | 1360 | 43 |
2058537 | 2058537 | 2021-12-28 | Claiborne | Mississippi | 28021 | 1360 | 40 |
2035649 | 2035649 | 2021-12-21 | Lake | Michigan | 26085 | 1360 | 30 |
2032399 | 2032399 | 2021-12-20 | Lake | Michigan | 26085 | 1360 | 30 |
2003453 | 2003453 | 2021-12-11 | St. Clair | Missouri | 29185 | 1360 | 27 |
1973716 | 1973716 | 2021-12-02 | Trimble | Kentucky | 21223 | 1360 | 21 |
1968046 | 1968046 | 2021-11-30 | Graham | North Carolina | 37075 | 1360 | 28 |
1962952 | 1962952 | 2021-11-29 | Greenlee | Arizona | 4011 | 1360 | 22 |
1964518 | 1964518 | 2021-11-29 | Valley | Montana | 30105 | 1360 | 29 |
1965557 | 1965557 | 2021-11-29 | Franklin | Texas | 48159 | 1360 | 37 |
1961290 | 1961290 | 2021-11-28 | Cuming | Nebraska | 31039 | 1360 | 15 |
1962305 | 1962305 | 2021-11-28 | Franklin | Texas | 48159 | 1360 | 37 |
1958039 | 1958039 | 2021-11-27 | Cuming | Nebraska | 31039 | 1360 | 15 |
1959054 | 1959054 | 2021-11-27 | Franklin | Texas | 48159 | 1360 | 37 |
1954788 | 1954788 | 2021-11-26 | Cuming | Nebraska | 31039 | 1360 | 15 |
1955803 | 1955803 | 2021-11-26 | Franklin | Texas | 48159 | 1360 | 37 |
1951537 | 1951537 | 2021-11-25 | Cuming | Nebraska | 31039 | 1360 | 15 |
1952552 | 1952552 | 2021-11-25 | Franklin | Texas | 48159 | 1360 | 37 |
1946904 | 1946904 | 2021-11-24 | Yuma | Colorado | 8125 | 1360 | 18 |
1948286 | 1948286 | 2021-11-24 | Cuming | Nebraska | 31039 | 1360 | 15 |
1949301 | 1949301 | 2021-11-24 | Franklin | Texas | 48159 | 1360 | 37 |
1949547 | 1949547 | 2021-11-24 | Charlotte | Virginia | 51037 | 1360 | 28 |
1943653 | 1943653 | 2021-11-23 | Yuma | Colorado | 8125 | 1360 | 18 |
1941736 | 1941736 | 2021-11-22 | Madison | Montana | 30057 | 1360 | 14 |
1923616 | 1923616 | 2021-11-16 | Poquoson city | Virginia | 51735 | 1360 | 22 |
1904405 | 1904405 | 2021-11-11 | Sumter | Alabama | 1119 | 1360 | 40 |
1903458 | 1903458 | 2021-11-10 | Guayama | Puerto Rico | 72057 | 1360 | |
1900208 | 1900208 | 2021-11-09 | Guayama | Puerto Rico | 72057 | 1360 | |
1896958 | 1896958 | 2021-11-08 | Guayama | Puerto Rico | 72057 | 1360 | |
1897121 | 1897121 | 2021-11-08 | Turner | South Dakota | 46125 | 1360 | 61 |
1884048 | 1884048 | 2021-11-04 | McCormick | South Carolina | 45065 | 1360 | 30 |
1880799 | 1880799 | 2021-11-03 | McCormick | South Carolina | 45065 | 1360 | 30 |
1877550 | 1877550 | 2021-11-02 | McCormick | South Carolina | 45065 | 1360 | 30 |
1874301 | 1874301 | 2021-11-01 | McCormick | South Carolina | 45065 | 1360 | 30 |
1874328 | 1874328 | 2021-11-01 | Custer | South Dakota | 46033 | 1360 | 16 |
1871747 | 1871747 | 2021-10-31 | Tyler | West Virginia | 54095 | 1360 | 19 |
1867742 | 1867742 | 2021-10-30 | Quebradillas | Puerto Rico | 72115 | 1360 | |
1865210 | 1865210 | 2021-10-29 | Doddridge | West Virginia | 54017 | 1360 | 10 |
1862097 | 1862097 | 2021-10-28 | Sublette | Wyoming | 56035 | 1360 | 16 |
1853975 | 1853975 | 2021-10-26 | Carbon | Montana | 30009 | 1360 | 21 |
1852348 | 1852348 | 2021-10-25 | Platte | Wyoming | 56031 | 1360 | 25 |
1837450 | 1837450 | 2021-10-21 | Clearwater | Minnesota | 27029 | 1360 | 18 |
1833019 | 1833019 | 2021-10-20 | Nevada | Arkansas | 5099 | 1360 | 38 |
1814437 | 1814437 | 2021-10-14 | Livingston | Kentucky | 21139 | 1360 | 41 |
1816253 | 1816253 | 2021-10-14 | Grand | Utah | 49019 | 1360 | 4 |
1813085 | 1813085 | 2021-10-13 | Floyd | Virginia | 51063 | 1360 | 28 |
1810003 | 1810003 | 2021-10-12 | Pleasants | West Virginia | 54073 | 1360 | 27 |
1805436 | 1805436 | 2021-10-11 | Colfax | New Mexico | 35007 | 1360 | 47 |
1802187 | 1802187 | 2021-10-10 | Colfax | New Mexico | 35007 | 1360 | 47 |
1798938 | 1798938 | 2021-10-09 | Colfax | New Mexico | 35007 | 1360 | 47 |
1795689 | 1795689 | 2021-10-08 | Colfax | New Mexico | 35007 | 1360 | 47 |
1783960 | 1783960 | 2021-10-04 | Pend Oreille | Washington | 53051 | 1360 | 19 |
1775917 | 1775917 | 2021-10-02 | Howard | Missouri | 29089 | 1360 | 12 |
1766015 | 1766015 | 2021-09-29 | Pope | Minnesota | 27121 | 1360 | 8 |
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);