ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
229 rows where cases = 2059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 16
- Michigan 16
- Arkansas 14
- Virginia 14
- Iowa 12
- Louisiana 12
- Texas 12
- Minnesota 10
- Puerto Rico 10
- West Virginia 9
- Kansas 8
- Indiana 7
- Maryland 7
- Mississippi 7
- Tennessee 7
- Vermont 7
- Colorado 6
- Kentucky 6
- Illinois 5
- Wisconsin 5
- Alabama 4
- Ohio 4
- New Mexico 3
- New York 3
- Florida 2
- Missouri 2
- Montana 2
- Nevada 2
- North Carolina 2
- Oregon 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466886 | 2466886 | 2022-05-02 | Pocahontas | West Virginia | 54075 | 2059 | 30 |
2338118 | 2338118 | 2022-03-24 | Presque Isle | Michigan | 26141 | 2059 | 56 |
2334043 | 2334043 | 2022-03-23 | Montgomery | Georgia | 13209 | 2059 | 51 |
2334864 | 2334864 | 2022-03-23 | Presque Isle | Michigan | 26141 | 2059 | 56 |
2331610 | 2331610 | 2022-03-22 | Presque Isle | Michigan | 26141 | 2059 | 56 |
2328358 | 2328358 | 2022-03-21 | Presque Isle | Michigan | 26141 | 2059 | 56 |
2325156 | 2325156 | 2022-03-20 | Lake | Minnesota | 27075 | 2059 | 28 |
2321902 | 2321902 | 2022-03-19 | Lake | Minnesota | 27075 | 2059 | 28 |
2318648 | 2318648 | 2022-03-18 | Lake | Minnesota | 27075 | 2059 | 28 |
2315395 | 2315395 | 2022-03-17 | Lake | Minnesota | 27075 | 2059 | 28 |
2308838 | 2308838 | 2022-03-15 | Presque Isle | Michigan | 26141 | 2059 | 56 |
2305587 | 2305587 | 2022-03-14 | Presque Isle | Michigan | 26141 | 2059 | 56 |
2302335 | 2302335 | 2022-03-13 | Presque Isle | Michigan | 26141 | 2059 | 56 |
2299083 | 2299083 | 2022-03-12 | Presque Isle | Michigan | 26141 | 2059 | 56 |
2295831 | 2295831 | 2022-03-11 | Presque Isle | Michigan | 26141 | 2059 | 56 |
2292883 | 2292883 | 2022-03-10 | Blaine | Montana | 30005 | 2059 | 31 |
2252416 | 2252416 | 2022-02-26 | Searcy | Arkansas | 5129 | 2059 | 41 |
2198580 | 2198580 | 2022-02-09 | Beaverhead | Montana | 30001 | 2059 | 24 |
2190220 | 2190220 | 2022-02-06 | Northampton | Virginia | 51131 | 2059 | 53 |
2186967 | 2186967 | 2022-02-05 | Northampton | Virginia | 51131 | 2059 | 53 |
2183714 | 2183714 | 2022-02-04 | Northampton | Virginia | 51131 | 2059 | 53 |
2175554 | 2175554 | 2022-02-02 | Jackson | Minnesota | 27063 | 2059 | 16 |
2166826 | 2166826 | 2022-01-30 | Penuelas | Puerto Rico | 72111 | 2059 | |
2108233 | 2108233 | 2022-01-12 | Comerio | Puerto Rico | 72045 | 2059 | |
2104114 | 2104114 | 2022-01-11 | Tunica | Mississippi | 28143 | 2059 | 40 |
2097079 | 2097079 | 2022-01-09 | Marshall | Kansas | 20117 | 2059 | 37 |
2093827 | 2093827 | 2022-01-08 | Marshall | Kansas | 20117 | 2059 | 37 |
2090575 | 2090575 | 2022-01-07 | Marshall | Kansas | 20117 | 2059 | 37 |
2087377 | 2087377 | 2022-01-06 | Bath | Kentucky | 21011 | 2059 | 34 |
2070291 | 2070291 | 2022-01-01 | Stone | Arkansas | 5137 | 2059 | 49 |
2053978 | 2053978 | 2021-12-27 | Bradley | Arkansas | 5011 | 2059 | 42 |
2056724 | 2056724 | 2021-12-27 | Ward | Texas | 48475 | 2059 | 35 |
2040982 | 2040982 | 2021-12-23 | Chicot | Arkansas | 5017 | 2059 | 48 |
2009492 | 2009492 | 2021-12-13 | Claiborne | Louisiana | 22027 | 2059 | 66 |
1966903 | 1966903 | 2021-11-30 | Appanoose | Iowa | 19007 | 2059 | 57 |
1963621 | 1963621 | 2021-11-29 | Pulaski | Indiana | 18131 | 2059 | 59 |
1963651 | 1963651 | 2021-11-29 | Appanoose | Iowa | 19007 | 2059 | 57 |
1960400 | 1960400 | 2021-11-28 | Appanoose | Iowa | 19007 | 2059 | 57 |
1957149 | 1957149 | 2021-11-27 | Appanoose | Iowa | 19007 | 2059 | 57 |
1953898 | 1953898 | 2021-11-26 | Appanoose | Iowa | 19007 | 2059 | 57 |
1950647 | 1950647 | 2021-11-25 | Appanoose | Iowa | 19007 | 2059 | 57 |
1947396 | 1947396 | 2021-11-24 | Appanoose | Iowa | 19007 | 2059 | 57 |
1926193 | 1926193 | 2021-11-17 | Cayey | Puerto Rico | 72035 | 2059 | |
1923798 | 1923798 | 2021-11-16 | Price | Wisconsin | 55099 | 2059 | 13 |
1901382 | 1901382 | 2021-11-10 | Moffat | Colorado | 8081 | 2059 | 45 |
1872001 | 1872001 | 2021-11-01 | Little River | Arkansas | 5081 | 2059 | 74 |
1868752 | 1868752 | 2021-10-31 | Little River | Arkansas | 5081 | 2059 | 74 |
1871605 | 1871605 | 2021-10-31 | Martinsville city | Virginia | 51690 | 2059 | 89 |
1868356 | 1868356 | 2021-10-30 | Martinsville city | Virginia | 51690 | 2059 | 89 |
1865107 | 1865107 | 2021-10-29 | Martinsville city | Virginia | 51690 | 2059 | 89 |
1850578 | 1850578 | 2021-10-25 | Perry | Mississippi | 28111 | 2059 | 56 |
1839238 | 1839238 | 2021-10-21 | Monroe | West Virginia | 54063 | 2059 | 25 |
1828933 | 1828933 | 2021-10-18 | Jackson | Tennessee | 47087 | 2059 | 40 |
1790892 | 1790892 | 2021-10-07 | Grand | Colorado | 8049 | 2059 | 10 |
1793524 | 1793524 | 2021-10-07 | Unknown | Utah | 2059 | 36 | |
1758561 | 1758561 | 2021-09-27 | Dade | Georgia | 13083 | 2059 | 17 |
1747725 | 1747725 | 2021-09-23 | Meigs | Tennessee | 47121 | 2059 | 25 |
1739334 | 1739334 | 2021-09-21 | Washington | Illinois | 17189 | 2059 | 33 |
1723704 | 1723704 | 2021-09-16 | Roscommon | Michigan | 26143 | 2059 | 57 |
1720455 | 1720455 | 2021-09-15 | Roscommon | Michigan | 26143 | 2059 | 57 |
1718825 | 1718825 | 2021-09-14 | Appomattox | Virginia | 51011 | 2059 | 29 |
1710515 | 1710515 | 2021-09-12 | Washington | Kentucky | 21229 | 2059 | 42 |
1707268 | 1707268 | 2021-09-11 | Washington | Kentucky | 21229 | 2059 | 42 |
1702948 | 1702948 | 2021-09-10 | Macon | Alabama | 1087 | 2059 | 54 |
1704020 | 1704020 | 2021-09-10 | Washington | Kentucky | 21229 | 2059 | 42 |
1689922 | 1689922 | 2021-09-06 | Clay | Alabama | 1027 | 2059 | 60 |
1677523 | 1677523 | 2021-09-02 | Clay | Illinois | 17025 | 2059 | 49 |
1678405 | 1678405 | 2021-09-02 | Yalobusha | Mississippi | 28161 | 2059 | 45 |
1671672 | 1671672 | 2021-08-31 | Cheboygan | Michigan | 26031 | 2059 | 52 |
1668425 | 1668425 | 2021-08-30 | Cheboygan | Michigan | 26031 | 2059 | 52 |
1654442 | 1654442 | 2021-08-26 | Elbert | Colorado | 8039 | 2059 | 16 |
1647985 | 1647985 | 2021-08-24 | Teller | Colorado | 8119 | 2059 | 19 |
1648073 | 1648073 | 2021-08-24 | Bacon | Georgia | 13005 | 2059 | 43 |
1650650 | 1650650 | 2021-08-24 | Fluvanna | Virginia | 51065 | 2059 | 22 |
1642368 | 1642368 | 2021-08-22 | Winn | Louisiana | 22127 | 2059 | 50 |
1642537 | 1642537 | 2021-08-22 | Hubbard | Minnesota | 27057 | 2059 | 41 |
1639118 | 1639118 | 2021-08-21 | Winn | Louisiana | 22127 | 2059 | 50 |
1639287 | 1639287 | 2021-08-21 | Hubbard | Minnesota | 27057 | 2059 | 41 |
1635868 | 1635868 | 2021-08-20 | Winn | Louisiana | 22127 | 2059 | 50 |
1636037 | 1636037 | 2021-08-20 | Hubbard | Minnesota | 27057 | 2059 | 41 |
1586699 | 1586699 | 2021-08-05 | Jay | Indiana | 18075 | 2059 | 35 |
1585445 | 1585445 | 2021-08-04 | Houston | Texas | 48225 | 2059 | 59 |
1585486 | 1585486 | 2021-08-04 | Madison | Texas | 48313 | 2059 | 31 |
1552063 | 1552063 | 2021-07-25 | Roosevelt | New Mexico | 35041 | 2059 | 59 |
1548816 | 1548816 | 2021-07-24 | Roosevelt | New Mexico | 35041 | 2059 | 59 |
1545569 | 1545569 | 2021-07-23 | Roosevelt | New Mexico | 35041 | 2059 | 59 |
1542871 | 1542871 | 2021-07-22 | Naranjito | Puerto Rico | 72105 | 2059 | |
1542883 | 1542883 | 2021-07-22 | San Lorenzo | Puerto Rico | 72129 | 2059 | |
1538452 | 1538452 | 2021-07-21 | Garrett | Maryland | 24023 | 2059 | 65 |
1539623 | 1539623 | 2021-07-21 | Naranjito | Puerto Rico | 72105 | 2059 | |
1539635 | 1539635 | 2021-07-21 | San Lorenzo | Puerto Rico | 72129 | 2059 | |
1535205 | 1535205 | 2021-07-20 | Garrett | Maryland | 24023 | 2059 | 65 |
1536388 | 1536388 | 2021-07-20 | San Lorenzo | Puerto Rico | 72129 | 2059 | |
1531957 | 1531957 | 2021-07-19 | Garrett | Maryland | 24023 | 2059 | 65 |
1528710 | 1528710 | 2021-07-18 | Garrett | Maryland | 24023 | 2059 | 65 |
1530406 | 1530406 | 2021-07-18 | Bennington | Vermont | 50003 | 2059 | 15 |
1525463 | 1525463 | 2021-07-17 | Garrett | Maryland | 24023 | 2059 | 65 |
1527159 | 1527159 | 2021-07-17 | Bennington | Vermont | 50003 | 2059 | 15 |
1523912 | 1523912 | 2021-07-16 | Bennington | Vermont | 50003 | 2059 | 15 |
1520664 | 1520664 | 2021-07-15 | Bennington | Vermont | 50003 | 2059 | 15 |
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);