ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
409 rows where cases = 1070 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 48
- Minnesota 39
- Georgia 33
- Kansas 33
- Kentucky 22
- Tennessee 21
- South Dakota 17
- Puerto Rico 15
- Mississippi 14
- Missouri 14
- Virginia 13
- Louisiana 10
- Michigan 10
- Montana 9
- Illinois 7
- Ohio 7
- Oklahoma 7
- Oregon 7
- Alabama 6
- Arkansas 6
- Iowa 6
- North Carolina 6
- Colorado 4
- Utah 4
- Vermont 4
- Wisconsin 4
- Florida 3
- Idaho 3
- Nebraska 3
- New York 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502059 | 2502059 | 2022-05-13 | Corson | South Dakota | 46031 | 1070 | 17 |
2498801 | 2498801 | 2022-05-12 | Corson | South Dakota | 46031 | 1070 | 17 |
2495543 | 2495543 | 2022-05-11 | Corson | South Dakota | 46031 | 1070 | 17 |
2492454 | 2492454 | 2022-05-10 | Brewster | Texas | 48043 | 1070 | 29 |
2489196 | 2489196 | 2022-05-09 | Brewster | Texas | 48043 | 1070 | 29 |
2485939 | 2485939 | 2022-05-08 | Brewster | Texas | 48043 | 1070 | 29 |
2482681 | 2482681 | 2022-05-07 | Brewster | Texas | 48043 | 1070 | 29 |
2479423 | 2479423 | 2022-05-06 | Brewster | Texas | 48043 | 1070 | 29 |
2319960 | 2319960 | 2022-03-18 | Concho | Texas | 48095 | 1070 | 11 |
2316706 | 2316706 | 2022-03-17 | Concho | Texas | 48095 | 1070 | 11 |
2313453 | 2313453 | 2022-03-16 | Concho | Texas | 48095 | 1070 | 11 |
2309197 | 2309197 | 2022-03-15 | Antelope | Nebraska | 31003 | 1070 | 13 |
2310200 | 2310200 | 2022-03-15 | Concho | Texas | 48095 | 1070 | 11 |
2306947 | 2306947 | 2022-03-14 | Concho | Texas | 48095 | 1070 | 11 |
2303696 | 2303696 | 2022-03-13 | Concho | Texas | 48095 | 1070 | 11 |
2300444 | 2300444 | 2022-03-12 | Concho | Texas | 48095 | 1070 | 11 |
2297192 | 2297192 | 2022-03-11 | Concho | Texas | 48095 | 1070 | 11 |
2297209 | 2297209 | 2022-03-11 | Donley | Texas | 48129 | 1070 | 26 |
2293940 | 2293940 | 2022-03-10 | Concho | Texas | 48095 | 1070 | 11 |
2290688 | 2290688 | 2022-03-09 | Concho | Texas | 48095 | 1070 | 11 |
2286434 | 2286434 | 2022-03-08 | Antelope | Nebraska | 31003 | 1070 | 13 |
2287436 | 2287436 | 2022-03-08 | Concho | Texas | 48095 | 1070 | 11 |
2284184 | 2284184 | 2022-03-07 | Concho | Texas | 48095 | 1070 | 11 |
2280932 | 2280932 | 2022-03-06 | Concho | Texas | 48095 | 1070 | 11 |
2277679 | 2277679 | 2022-03-05 | Concho | Texas | 48095 | 1070 | 11 |
2274426 | 2274426 | 2022-03-04 | Concho | Texas | 48095 | 1070 | 11 |
2274629 | 2274629 | 2022-03-04 | Yoakum | Texas | 48501 | 1070 | 41 |
2271376 | 2271376 | 2022-03-03 | Yoakum | Texas | 48501 | 1070 | 41 |
2178036 | 2178036 | 2022-02-03 | Lewis | Idaho | 16061 | 1070 | 25 |
2180683 | 2180683 | 2022-02-03 | Hot Springs | Wyoming | 56017 | 1070 | 14 |
2146633 | 2146633 | 2022-01-24 | Kearney | Nebraska | 31099 | 1070 | 7 |
2142626 | 2142626 | 2022-01-23 | Ottawa | Kansas | 20143 | 1070 | 16 |
2139371 | 2139371 | 2022-01-22 | Ottawa | Kansas | 20143 | 1070 | 16 |
2136115 | 2136115 | 2022-01-21 | Ottawa | Kansas | 20143 | 1070 | 16 |
2130260 | 2130260 | 2022-01-19 | Broadwater | Montana | 30007 | 1070 | 18 |
2126019 | 2126019 | 2022-01-18 | Gallatin | Illinois | 17059 | 1070 | 11 |
2124642 | 2124642 | 2022-01-17 | Lyman | South Dakota | 46085 | 1070 | 12 |
2121390 | 2121390 | 2022-01-16 | Lyman | South Dakota | 46085 | 1070 | 12 |
2118138 | 2118138 | 2022-01-15 | Lyman | South Dakota | 46085 | 1070 | 12 |
2114887 | 2114887 | 2022-01-14 | Lyman | South Dakota | 46085 | 1070 | 12 |
2098626 | 2098626 | 2022-01-09 | Kingsbury | South Dakota | 46077 | 1070 | 20 |
2095374 | 2095374 | 2022-01-08 | Kingsbury | South Dakota | 46077 | 1070 | 20 |
2092122 | 2092122 | 2022-01-07 | Kingsbury | South Dakota | 46077 | 1070 | 20 |
2074354 | 2074354 | 2022-01-02 | Stevens | Kansas | 20189 | 1070 | 17 |
2071103 | 2071103 | 2022-01-01 | Stevens | Kansas | 20189 | 1070 | 17 |
2067852 | 2067852 | 2021-12-31 | Stevens | Kansas | 20189 | 1070 | 17 |
2064601 | 2064601 | 2021-12-30 | Stevens | Kansas | 20189 | 1070 | 17 |
2061351 | 2061351 | 2021-12-29 | Stevens | Kansas | 20189 | 1070 | 17 |
2020744 | 2020744 | 2021-12-16 | Bailey | Texas | 48017 | 1070 | 28 |
1965372 | 1965372 | 2021-11-29 | Spink | South Dakota | 46115 | 1070 | 29 |
1965959 | 1965959 | 2021-11-29 | Calhoun | West Virginia | 54013 | 1070 | 6 |
1922122 | 1922122 | 2021-11-16 | Daviess | Missouri | 29061 | 1070 | 14 |
1905820 | 1905820 | 2021-11-11 | Quitman | Mississippi | 28119 | 1070 | 28 |
1906586 | 1906586 | 2021-11-11 | Grant | Oregon | 41023 | 1070 | 14 |
1902571 | 1902571 | 2021-11-10 | Quitman | Mississippi | 28119 | 1070 | 28 |
1903337 | 1903337 | 2021-11-10 | Grant | Oregon | 41023 | 1070 | 14 |
1899321 | 1899321 | 2021-11-09 | Quitman | Mississippi | 28119 | 1070 | 28 |
1896951 | 1896951 | 2021-11-08 | Comerio | Puerto Rico | 72045 | 1070 | |
1893701 | 1893701 | 2021-11-07 | Comerio | Puerto Rico | 72045 | 1070 | |
1878944 | 1878944 | 2021-11-03 | Power | Idaho | 16077 | 1070 | 15 |
1835210 | 1835210 | 2021-10-20 | Ciales | Puerto Rico | 72039 | 1070 | |
1831961 | 1831961 | 2021-10-19 | Ciales | Puerto Rico | 72039 | 1070 | |
1827046 | 1827046 | 2021-10-18 | Schuyler | Illinois | 17169 | 1070 | 22 |
1828712 | 1828712 | 2021-10-18 | Ciales | Puerto Rico | 72039 | 1070 | |
1828958 | 1828958 | 2021-10-18 | Pickett | Tennessee | 47137 | 1070 | 24 |
1829360 | 1829360 | 2021-10-18 | Lunenburg | Virginia | 51111 | 1070 | 20 |
1823645 | 1823645 | 2021-10-17 | Twiggs | Georgia | 13289 | 1070 | 59 |
1825463 | 1825463 | 2021-10-17 | Ciales | Puerto Rico | 72039 | 1070 | |
1820396 | 1820396 | 2021-10-16 | Twiggs | Georgia | 13289 | 1070 | 59 |
1822214 | 1822214 | 2021-10-16 | Ciales | Puerto Rico | 72039 | 1070 | |
1817147 | 1817147 | 2021-10-15 | Twiggs | Georgia | 13289 | 1070 | 59 |
1818965 | 1818965 | 2021-10-15 | Ciales | Puerto Rico | 72039 | 1070 | |
1810650 | 1810650 | 2021-10-13 | Twiggs | Georgia | 13289 | 1070 | 59 |
1807401 | 1807401 | 2021-10-12 | Twiggs | Georgia | 13289 | 1070 | 59 |
1807812 | 1807812 | 2021-10-12 | Kingman | Kansas | 20095 | 1070 | 20 |
1809514 | 1809514 | 2021-10-12 | Brewster | Texas | 48043 | 1070 | 19 |
1804150 | 1804150 | 2021-10-11 | Twiggs | Georgia | 13289 | 1070 | 59 |
1804561 | 1804561 | 2021-10-11 | Kingman | Kansas | 20095 | 1070 | 20 |
1800901 | 1800901 | 2021-10-10 | Twiggs | Georgia | 13289 | 1070 | 59 |
1797652 | 1797652 | 2021-10-09 | Twiggs | Georgia | 13289 | 1070 | 59 |
1794403 | 1794403 | 2021-10-08 | Twiggs | Georgia | 13289 | 1070 | 59 |
1784309 | 1784309 | 2021-10-05 | Woodruff | Arkansas | 5147 | 1070 | 23 |
1785664 | 1785664 | 2021-10-05 | Hickory | Missouri | 29085 | 1070 | 20 |
1785902 | 1785902 | 2021-10-05 | Pershing | Nevada | 32027 | 1070 | 24 |
1782653 | 1782653 | 2021-10-04 | Pershing | Nevada | 32027 | 1070 | 23 |
1764391 | 1764391 | 2021-09-28 | Northampton | Virginia | 51131 | 1070 | 39 |
1760851 | 1760851 | 2021-09-27 | Hansford | Texas | 48195 | 1070 | 26 |
1757603 | 1757603 | 2021-09-26 | Hansford | Texas | 48195 | 1070 | 26 |
1754355 | 1754355 | 2021-09-25 | Hansford | Texas | 48195 | 1070 | 26 |
1747837 | 1747837 | 2021-09-23 | Floyd | Texas | 48153 | 1070 | 33 |
1733757 | 1733757 | 2021-09-19 | Carbon | Montana | 30009 | 1070 | 19 |
1730507 | 1730507 | 2021-09-18 | Carbon | Montana | 30009 | 1070 | 19 |
1727257 | 1727257 | 2021-09-17 | Carbon | Montana | 30009 | 1070 | 19 |
1719133 | 1719133 | 2021-09-14 | Platte | Wyoming | 56031 | 1070 | 18 |
1700134 | 1700134 | 2021-09-09 | Lincoln | Georgia | 13181 | 1070 | 29 |
1700444 | 1700444 | 2021-09-09 | Warren | Indiana | 18171 | 1070 | 18 |
1689364 | 1689364 | 2021-09-05 | Franklin | Texas | 48159 | 1070 | 27 |
1679877 | 1679877 | 2021-09-02 | Floyd | Virginia | 51063 | 1070 | 22 |
1667246 | 1667246 | 2021-08-30 | Ketchikan Gateway Borough | Alaska | 2130 | 1070 | 2 |
1667639 | 1667639 | 2021-08-30 | Jenkins | Georgia | 13165 | 1070 | 45 |
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);