ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
314 rows where cases = 1736 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 38
- Minnesota 33
- Arkansas 18
- Georgia 16
- Mississippi 13
- Tennessee 13
- Virginia 13
- North Carolina 12
- Puerto Rico 12
- Kentucky 11
- Missouri 10
- Wisconsin 10
- Illinois 9
- Iowa 9
- Idaho 8
- Indiana 8
- Alabama 7
- South Dakota 7
- Louisiana 6
- North Dakota 6
- California 5
- Ohio 5
- Oklahoma 5
- Kansas 4
- Nebraska 4
- New Mexico 4
- West Virginia 4
- Guam 3
- New York 3
- Florida 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501335 | 2501335 | 2022-05-13 | Thurston | Nebraska | 31173 | 1736 | 23 |
2399460 | 2399460 | 2022-04-12 | Greene | Iowa | 19073 | 1736 | 21 |
2396204 | 2396204 | 2022-04-11 | Greene | Iowa | 19073 | 1736 | 21 |
2392949 | 2392949 | 2022-04-10 | Greene | Iowa | 19073 | 1736 | 21 |
2389693 | 2389693 | 2022-04-09 | Greene | Iowa | 19073 | 1736 | 21 |
2386437 | 2386437 | 2022-04-08 | Greene | Iowa | 19073 | 1736 | 21 |
2383183 | 2383183 | 2022-04-07 | Greene | Iowa | 19073 | 1736 | 21 |
2379928 | 2379928 | 2022-04-06 | Greene | Iowa | 19073 | 1736 | 21 |
2370699 | 2370699 | 2022-04-03 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2367446 | 2367446 | 2022-04-02 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2364193 | 2364193 | 2022-04-01 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2360939 | 2360939 | 2022-03-31 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2357685 | 2357685 | 2022-03-30 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2354432 | 2354432 | 2022-03-29 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2351180 | 2351180 | 2022-03-28 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2347927 | 2347927 | 2022-03-27 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2344674 | 2344674 | 2022-03-26 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2341421 | 2341421 | 2022-03-25 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2334914 | 2334914 | 2022-03-23 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2331660 | 2331660 | 2022-03-22 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2328408 | 2328408 | 2022-03-21 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2325155 | 2325155 | 2022-03-20 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2321901 | 2321901 | 2022-03-19 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2318647 | 2318647 | 2022-03-18 | Lac qui Parle | Minnesota | 27073 | 1736 | 28 |
2188742 | 2188742 | 2022-02-06 | Harrison | Missouri | 29081 | 1736 | 27 |
2189691 | 2189691 | 2022-02-06 | Fall River | South Dakota | 46047 | 1736 | 37 |
2189913 | 2189913 | 2022-02-06 | Gaines | Texas | 48165 | 1736 | 78 |
2185489 | 2185489 | 2022-02-05 | Harrison | Missouri | 29081 | 1736 | 27 |
2186438 | 2186438 | 2022-02-05 | Fall River | South Dakota | 46047 | 1736 | 37 |
2183186 | 2183186 | 2022-02-04 | Fall River | South Dakota | 46047 | 1736 | 37 |
2178987 | 2178987 | 2022-02-03 | Hickory | Missouri | 29085 | 1736 | 50 |
2179389 | 2179389 | 2022-02-03 | Gates | North Carolina | 37073 | 1736 | 19 |
2177037 | 2177037 | 2022-02-02 | Stephens | Texas | 48429 | 1736 | 39 |
2170973 | 2170973 | 2022-02-01 | Greene | Alabama | 1063 | 1736 | 47 |
2156104 | 2156104 | 2022-01-27 | Franklin | Mississippi | 28037 | 1736 | 34 |
2138302 | 2138302 | 2022-01-21 | Webster | West Virginia | 54101 | 1736 | 27 |
2127759 | 2127759 | 2022-01-18 | Jayuya | Puerto Rico | 72073 | 1736 | |
2118022 | 2118022 | 2022-01-15 | Penuelas | Puerto Rico | 72111 | 1736 | |
2110094 | 2110094 | 2022-01-13 | Norton | Kansas | 20137 | 1736 | 35 |
2106843 | 2106843 | 2022-01-12 | Norton | Kansas | 20137 | 1736 | 35 |
2087905 | 2087905 | 2022-01-06 | Gentry | Missouri | 29075 | 1736 | 28 |
2073571 | 2073571 | 2022-01-02 | Mariposa | California | 6043 | 1736 | 18 |
2070320 | 2070320 | 2022-01-01 | Mariposa | California | 6043 | 1736 | 18 |
2067069 | 2067069 | 2021-12-31 | Mariposa | California | 6043 | 1736 | 18 |
2063818 | 2063818 | 2021-12-30 | Mariposa | California | 6043 | 1736 | 18 |
2051191 | 2051191 | 2021-12-26 | Fremont | Idaho | 16043 | 1736 | 18 |
2047941 | 2047941 | 2021-12-25 | Fremont | Idaho | 16043 | 1736 | 18 |
2044691 | 2044691 | 2021-12-24 | Fremont | Idaho | 16043 | 1736 | 18 |
2041442 | 2041442 | 2021-12-23 | Fremont | Idaho | 16043 | 1736 | 18 |
2034957 | 2034957 | 2021-12-21 | Owyhee | Idaho | 16073 | 1736 | 41 |
2020037 | 2020037 | 2021-12-16 | Clay | North Carolina | 37043 | 1736 | 38 |
2020907 | 2020907 | 2021-12-16 | Morris | Texas | 48343 | 1736 | 58 |
2016786 | 2016786 | 2021-12-15 | Clay | North Carolina | 37043 | 1736 | 38 |
2005823 | 2005823 | 2021-12-12 | Crawford | Indiana | 18025 | 1736 | 30 |
2007609 | 2007609 | 2021-12-12 | Lake | South Dakota | 46079 | 1736 | 20 |
2002572 | 2002572 | 2021-12-11 | Crawford | Indiana | 18025 | 1736 | 30 |
2004358 | 2004358 | 2021-12-11 | Lake | South Dakota | 46079 | 1736 | 20 |
1999322 | 1999322 | 2021-12-10 | Crawford | Indiana | 18025 | 1736 | 30 |
2001107 | 2001107 | 2021-12-10 | Lake | South Dakota | 46079 | 1736 | 20 |
1998387 | 1998387 | 2021-12-09 | Richmond | Virginia | 51159 | 1736 | 16 |
1976450 | 1976450 | 2021-12-03 | Teton | Idaho | 16081 | 1736 | 7 |
1973201 | 1973201 | 2021-12-02 | Teton | Idaho | 16081 | 1736 | 7 |
1975777 | 1975777 | 2021-12-02 | Forest | Wisconsin | 55041 | 1736 | 33 |
1964299 | 1964299 | 2021-11-29 | Jefferson Davis | Mississippi | 28065 | 1736 | 43 |
1960132 | 1960132 | 2021-11-28 | Turner | Georgia | 13287 | 1736 | 49 |
1961048 | 1961048 | 2021-11-28 | Jefferson Davis | Mississippi | 28065 | 1736 | 43 |
1956881 | 1956881 | 2021-11-27 | Turner | Georgia | 13287 | 1736 | 49 |
1957797 | 1957797 | 2021-11-27 | Jefferson Davis | Mississippi | 28065 | 1736 | 43 |
1953630 | 1953630 | 2021-11-26 | Turner | Georgia | 13287 | 1736 | 49 |
1954546 | 1954546 | 2021-11-26 | Jefferson Davis | Mississippi | 28065 | 1736 | 43 |
1950379 | 1950379 | 2021-11-25 | Turner | Georgia | 13287 | 1736 | 49 |
1951295 | 1951295 | 2021-11-25 | Jefferson Davis | Mississippi | 28065 | 1736 | 43 |
1947128 | 1947128 | 2021-11-24 | Turner | Georgia | 13287 | 1736 | 49 |
1948044 | 1948044 | 2021-11-24 | Jefferson Davis | Mississippi | 28065 | 1736 | 43 |
1942617 | 1942617 | 2021-11-22 | Todd | South Dakota | 46121 | 1736 | 37 |
1911009 | 1911009 | 2021-11-13 | Pike | Arkansas | 5109 | 1736 | 36 |
1907660 | 1907660 | 2021-11-12 | Wilcox | Alabama | 1131 | 1736 | 38 |
1893320 | 1893320 | 2021-11-07 | Pamlico | North Carolina | 37137 | 1736 | 26 |
1888269 | 1888269 | 2021-11-06 | Scott | Arkansas | 5127 | 1736 | 29 |
1890070 | 1890070 | 2021-11-06 | Pamlico | North Carolina | 37137 | 1736 | 26 |
1886820 | 1886820 | 2021-11-05 | Pamlico | North Carolina | 37137 | 1736 | 26 |
1859520 | 1859520 | 2021-10-28 | Menard | Illinois | 17129 | 1736 | 17 |
1854732 | 1854732 | 2021-10-26 | Loiza | Puerto Rico | 72087 | 1736 | |
1851483 | 1851483 | 2021-10-25 | Loiza | Puerto Rico | 72087 | 1736 | |
1848233 | 1848233 | 2021-10-24 | Loiza | Puerto Rico | 72087 | 1736 | |
1834704 | 1834704 | 2021-10-20 | Torrance | New Mexico | 35057 | 1736 | 20 |
1830804 | 1830804 | 2021-10-19 | Lincoln | Maine | 23015 | 1736 | 5 |
1827867 | 1827867 | 2021-10-18 | Bollinger | Missouri | 29017 | 1736 | 19 |
1789742 | 1789742 | 2021-10-06 | Juana Diaz | Puerto Rico | 72075 | 1736 | |
1764827 | 1764827 | 2021-09-29 | Inyo | California | 6027 | 1736 | 39 |
1759468 | 1759468 | 2021-09-27 | Chippewa | Minnesota | 27023 | 1736 | 39 |
1746221 | 1746221 | 2021-09-23 | Metcalfe | Kentucky | 21169 | 1736 | 36 |
1747481 | 1747481 | 2021-09-23 | Camuy | Puerto Rico | 72027 | 1736 | |
1716959 | 1716959 | 2021-09-14 | Leslie | Kentucky | 21131 | 1736 | 11 |
1714901 | 1714901 | 2021-09-13 | Tillamook | Oregon | 41057 | 1736 | 20 |
1696844 | 1696844 | 2021-09-08 | Early | Georgia | 13099 | 1736 | 50 |
1695848 | 1695848 | 2021-09-07 | Eastland | Texas | 48133 | 1736 | 58 |
1691252 | 1691252 | 2021-09-06 | Cottonwood | Minnesota | 27033 | 1736 | 24 |
1692600 | 1692600 | 2021-09-06 | Eastland | Texas | 48133 | 1736 | 58 |
1686809 | 1686809 | 2021-09-05 | Little River | Arkansas | 5081 | 1736 | 44 |
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);