ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
315 rows where cases = 1432 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 22
- Georgia 21
- Illinois 15
- Michigan 14
- Kansas 13
- Missouri 13
- Texas 13
- Tennessee 12
- Arkansas 11
- California 11
- Louisiana 10
- Kentucky 9
- Minnesota 9
- Oklahoma 9
- Alabama 8
- Nebraska 8
- Florida 7
- Indiana 7
- Iowa 7
- New Mexico 7
- North Carolina 6
- Ohio 6
- South Carolina 6
- Virginia 6
- West Virginia 6
- Montana 5
- Oregon 5
- South Dakota 5
- Vermont 5
- Mississippi 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492729 | 2492729 | 2022-05-10 | Unknown | Vermont | 1432 | 2 | |
2360886 | 2360886 | 2022-03-31 | Oscoda | Michigan | 26135 | 1432 | 55 |
2357632 | 2357632 | 2022-03-30 | Oscoda | Michigan | 26135 | 1432 | 55 |
2354379 | 2354379 | 2022-03-29 | Oscoda | Michigan | 26135 | 1432 | 54 |
2351127 | 2351127 | 2022-03-28 | Oscoda | Michigan | 26135 | 1432 | 54 |
2338115 | 2338115 | 2022-03-24 | Oscoda | Michigan | 26135 | 1432 | 54 |
2334861 | 2334861 | 2022-03-23 | Oscoda | Michigan | 26135 | 1432 | 54 |
2309888 | 2309888 | 2022-03-15 | Guanica | Puerto Rico | 72055 | 1432 | |
2306635 | 2306635 | 2022-03-14 | Guanica | Puerto Rico | 72055 | 1432 | |
2303384 | 2303384 | 2022-03-13 | Guanica | Puerto Rico | 72055 | 1432 | |
2287915 | 2287915 | 2022-03-08 | Wirt | West Virginia | 54105 | 1432 | 23 |
2213992 | 2213992 | 2022-02-14 | Ohio | Indiana | 18115 | 1432 | 17 |
2196505 | 2196505 | 2022-02-08 | Mills | Texas | 48333 | 1432 | 30 |
2192191 | 2192191 | 2022-02-07 | Nemaha | Nebraska | 31127 | 1432 | 19 |
2175565 | 2175565 | 2022-02-02 | Mahnomen | Minnesota | 27087 | 1432 | 17 |
2143178 | 2143178 | 2022-01-23 | Clark | Missouri | 29045 | 1432 | 28 |
2132355 | 2132355 | 2022-01-20 | Hancock | Georgia | 13141 | 1432 | 84 |
2101872 | 2101872 | 2022-01-10 | Hutchinson | South Dakota | 46067 | 1432 | 30 |
2081152 | 2081152 | 2022-01-04 | Lake | Michigan | 26085 | 1432 | 31 |
2077900 | 2077900 | 2022-01-03 | Lake | Michigan | 26085 | 1432 | 31 |
2079295 | 2079295 | 2022-01-03 | Dallam | Texas | 48111 | 1432 | 32 |
2063784 | 2063784 | 2021-12-30 | Searcy | Arkansas | 5129 | 1432 | 30 |
2060419 | 2060419 | 2021-12-29 | Sumter | Alabama | 1119 | 1432 | 42 |
2055552 | 2055552 | 2021-12-27 | Cuming | Nebraska | 31039 | 1432 | 15 |
2052302 | 2052302 | 2021-12-26 | Cuming | Nebraska | 31039 | 1432 | 15 |
2049052 | 2049052 | 2021-12-25 | Cuming | Nebraska | 31039 | 1432 | 15 |
2045802 | 2045802 | 2021-12-24 | Cuming | Nebraska | 31039 | 1432 | 15 |
2042552 | 2042552 | 2021-12-23 | Cuming | Nebraska | 31039 | 1432 | 15 |
2039303 | 2039303 | 2021-12-22 | Cuming | Nebraska | 31039 | 1432 | 15 |
2021461 | 2021461 | 2021-12-17 | Greenlee | Arizona | 4011 | 1432 | 25 |
2023735 | 2023735 | 2021-12-17 | Lares | Puerto Rico | 72081 | 1432 | |
2007559 | 2007559 | 2021-12-12 | McCormick | South Carolina | 45065 | 1432 | 30 |
2004308 | 2004308 | 2021-12-11 | McCormick | South Carolina | 45065 | 1432 | 30 |
2001057 | 2001057 | 2021-12-10 | McCormick | South Carolina | 45065 | 1432 | 30 |
1996971 | 1996971 | 2021-12-09 | Blaine | Montana | 30005 | 1432 | 28 |
1990861 | 1990861 | 2021-12-07 | Benson | North Dakota | 38005 | 1432 | 21 |
1988421 | 1988421 | 2021-12-06 | Red River | Texas | 48387 | 1432 | 55 |
1985171 | 1985171 | 2021-12-05 | Red River | Texas | 48387 | 1432 | 55 |
1967884 | 1967884 | 2021-11-30 | White Pine | Nevada | 32033 | 1432 | 16 |
1952185 | 1952185 | 2021-11-25 | Anasco | Puerto Rico | 72011 | 1432 | |
1948934 | 1948934 | 2021-11-24 | Anasco | Puerto Rico | 72011 | 1432 | |
1945683 | 1945683 | 2021-11-23 | Anasco | Puerto Rico | 72011 | 1432 | |
1942432 | 1942432 | 2021-11-22 | Anasco | Puerto Rico | 72011 | 1432 | |
1939182 | 1939182 | 2021-11-21 | Anasco | Puerto Rico | 72011 | 1432 | |
1935932 | 1935932 | 2021-11-20 | Anasco | Puerto Rico | 72011 | 1432 | |
1932682 | 1932682 | 2021-11-19 | Anasco | Puerto Rico | 72011 | 1432 | |
1929431 | 1929431 | 2021-11-18 | Anasco | Puerto Rico | 72011 | 1432 | |
1929447 | 1929447 | 2021-11-18 | Coamo | Puerto Rico | 72043 | 1432 | |
1920717 | 1920717 | 2021-11-16 | Cleveland | Arkansas | 5025 | 1432 | 33 |
1917467 | 1917467 | 2021-11-15 | Cleveland | Arkansas | 5025 | 1432 | 33 |
1914217 | 1914217 | 2021-11-14 | Cleveland | Arkansas | 5025 | 1432 | 33 |
1915017 | 1915017 | 2021-11-14 | Ellsworth | Kansas | 20053 | 1432 | 31 |
1910967 | 1910967 | 2021-11-13 | Cleveland | Arkansas | 5025 | 1432 | 33 |
1911767 | 1911767 | 2021-11-13 | Ellsworth | Kansas | 20053 | 1432 | 31 |
1907718 | 1907718 | 2021-11-12 | Cleveland | Arkansas | 5025 | 1432 | 33 |
1908518 | 1908518 | 2021-11-12 | Ellsworth | Kansas | 20053 | 1432 | 31 |
1904469 | 1904469 | 2021-11-11 | Cleveland | Arkansas | 5025 | 1432 | 33 |
1901219 | 1901219 | 2021-11-10 | Cleveland | Arkansas | 5025 | 1432 | 33 |
1904013 | 1904013 | 2021-11-10 | Lamoille | Vermont | 50015 | 1432 | 9 |
1897969 | 1897969 | 2021-11-09 | Cleveland | Arkansas | 5025 | 1432 | 33 |
1883256 | 1883256 | 2021-11-04 | Sanders | Montana | 30089 | 1432 | 25 |
1879419 | 1879419 | 2021-11-03 | Livingston | Kentucky | 21139 | 1432 | 43 |
1875307 | 1875307 | 2021-11-02 | Mariposa | California | 6043 | 1432 | 17 |
1875759 | 1875759 | 2021-11-02 | Marshall | Illinois | 17123 | 1432 | 25 |
1872058 | 1872058 | 2021-11-01 | Mariposa | California | 6043 | 1432 | 17 |
1865246 | 1865246 | 2021-10-29 | Summers | West Virginia | 54089 | 1432 | 30 |
1861822 | 1861822 | 2021-10-28 | Floyd | Virginia | 51063 | 1432 | 29 |
1858197 | 1858197 | 2021-10-27 | Moore | Tennessee | 47127 | 1432 | 22 |
1837723 | 1837723 | 2021-10-21 | Beaverhead | Montana | 30001 | 1432 | 15 |
1830586 | 1830586 | 2021-10-19 | Rice | Kansas | 20159 | 1432 | 15 |
1826828 | 1826828 | 2021-10-18 | Irwin | Georgia | 13155 | 1432 | 37 |
1827337 | 1827337 | 2021-10-18 | Rice | Kansas | 20159 | 1432 | 15 |
1812511 | 1812511 | 2021-10-13 | Salinas | Puerto Rico | 72123 | 1432 | |
1809094 | 1809094 | 2021-10-12 | Washita | Oklahoma | 40149 | 1432 | 25 |
1809262 | 1809262 | 2021-10-12 | Salinas | Puerto Rico | 72123 | 1432 | |
1805844 | 1805844 | 2021-10-11 | Washita | Oklahoma | 40149 | 1432 | 25 |
1802594 | 1802594 | 2021-10-10 | Washita | Oklahoma | 40149 | 1432 | 25 |
1799345 | 1799345 | 2021-10-09 | Washita | Oklahoma | 40149 | 1432 | 25 |
1796096 | 1796096 | 2021-10-08 | Washita | Oklahoma | 40149 | 1432 | 25 |
1792847 | 1792847 | 2021-10-07 | Washita | Oklahoma | 40149 | 1432 | 25 |
1789598 | 1789598 | 2021-10-06 | Washita | Oklahoma | 40149 | 1432 | 25 |
1789782 | 1789782 | 2021-10-06 | Yauco | Puerto Rico | 72153 | 1432 | |
1786534 | 1786534 | 2021-10-05 | Yauco | Puerto Rico | 72153 | 1432 | |
1755346 | 1755346 | 2021-09-26 | Heard | Georgia | 13149 | 1432 | 30 |
1757792 | 1757792 | 2021-09-26 | Caledonia | Vermont | 50005 | 1432 | 9 |
1752098 | 1752098 | 2021-09-25 | Heard | Georgia | 13149 | 1432 | 30 |
1748849 | 1748849 | 2021-09-24 | Heard | Georgia | 13149 | 1432 | 30 |
1743071 | 1743071 | 2021-09-22 | West Feliciana | Louisiana | 22125 | 1432 | 39 |
1739822 | 1739822 | 2021-09-21 | West Feliciana | Louisiana | 22125 | 1432 | 39 |
1735936 | 1735936 | 2021-09-20 | Wilkes | Georgia | 13317 | 1432 | 33 |
1736573 | 1736573 | 2021-09-20 | West Feliciana | Louisiana | 22125 | 1432 | 39 |
1727207 | 1727207 | 2021-09-17 | Montgomery | Missouri | 29139 | 1432 | 18 |
1720726 | 1720726 | 2021-09-15 | Ralls | Missouri | 29173 | 1432 | 14 |
1691753 | 1691753 | 2021-09-06 | Torrance | New Mexico | 35057 | 1432 | 16 |
1688503 | 1688503 | 2021-09-05 | Torrance | New Mexico | 35057 | 1432 | 16 |
1685253 | 1685253 | 2021-09-04 | Torrance | New Mexico | 35057 | 1432 | 16 |
1682002 | 1682002 | 2021-09-03 | Torrance | New Mexico | 35057 | 1432 | 16 |
1671968 | 1671968 | 2021-08-31 | Lewis | Missouri | 29111 | 1432 | 21 |
1653444 | 1653444 | 2021-08-25 | Roberts | South Dakota | 46109 | 1432 | 43 |
1653919 | 1653919 | 2021-08-25 | King William | Virginia | 51101 | 1432 | 16 |
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);