ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
316 rows where cases = 1823 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 27
- Texas 23
- Florida 20
- Minnesota 18
- Georgia 17
- Mississippi 16
- Virginia 14
- North Carolina 13
- Iowa 12
- Puerto Rico 10
- Wisconsin 10
- Indiana 9
- Kansas 9
- Nebraska 8
- South Dakota 8
- Colorado 7
- Illinois 7
- Ohio 7
- Washington 7
- West Virginia 7
- Louisiana 6
- South Carolina 6
- Alabama 5
- Kentucky 5
- Michigan 5
- Arkansas 4
- Maine 4
- New York 4
- Pennsylvania 4
- Maryland 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466744 | 2466744 | 2022-05-02 | Lancaster | Virginia | 51103 | 1823 | 31 |
2354830 | 2354830 | 2022-03-29 | Wayne | Nebraska | 31179 | 1823 | 11 |
2352158 | 2352158 | 2022-03-28 | Arroyo | Puerto Rico | 72015 | 1823 | |
2286302 | 2286302 | 2022-03-08 | Hickory | Missouri | 29085 | 1823 | 55 |
2286523 | 2286523 | 2022-03-08 | Wayne | Nebraska | 31179 | 1823 | 11 |
2261560 | 2261560 | 2022-02-28 | Rains | Texas | 48379 | 1823 | 56 |
2258309 | 2258309 | 2022-02-27 | Rains | Texas | 48379 | 1823 | 56 |
2255058 | 2255058 | 2022-02-26 | Rains | Texas | 48379 | 1823 | 56 |
2235416 | 2235416 | 2022-02-20 | Crosby | Texas | 48107 | 1823 | 45 |
2232165 | 2232165 | 2022-02-19 | Crosby | Texas | 48107 | 1823 | 45 |
2220040 | 2220040 | 2022-02-16 | Yuma | Colorado | 8125 | 1823 | 23 |
2188638 | 2188638 | 2022-02-06 | Franklin | Mississippi | 28037 | 1823 | 35 |
2185385 | 2185385 | 2022-02-05 | Franklin | Mississippi | 28037 | 1823 | 35 |
2182133 | 2182133 | 2022-02-04 | Franklin | Mississippi | 28037 | 1823 | 35 |
2182707 | 2182707 | 2022-02-04 | Benson | North Dakota | 38005 | 1823 | 22 |
2165799 | 2165799 | 2022-01-30 | Lake | Minnesota | 27075 | 1823 | 26 |
2162544 | 2162544 | 2022-01-29 | Lake | Minnesota | 27075 | 1823 | 26 |
2159289 | 2159289 | 2022-01-28 | Lake | Minnesota | 27075 | 1823 | 26 |
2154262 | 2154262 | 2022-01-26 | Swisher | Texas | 48437 | 1823 | 30 |
2151010 | 2151010 | 2022-01-25 | Swisher | Texas | 48437 | 1823 | 30 |
2147758 | 2147758 | 2022-01-24 | Swisher | Texas | 48437 | 1823 | 30 |
2143349 | 2143349 | 2022-01-23 | Custer | Nebraska | 31041 | 1823 | 26 |
2143616 | 2143616 | 2022-01-23 | Jones | North Carolina | 37103 | 1823 | 38 |
2140094 | 2140094 | 2022-01-22 | Custer | Nebraska | 31041 | 1823 | 26 |
2140361 | 2140361 | 2022-01-22 | Jones | North Carolina | 37103 | 1823 | 38 |
2136838 | 2136838 | 2022-01-21 | Custer | Nebraska | 31041 | 1823 | 26 |
2137105 | 2137105 | 2022-01-21 | Jones | North Carolina | 37103 | 1823 | 38 |
2129034 | 2129034 | 2022-01-19 | Atkinson | Georgia | 13003 | 1823 | 39 |
2130092 | 2130092 | 2022-01-19 | Kemper | Mississippi | 28069 | 1823 | 42 |
2122642 | 2122642 | 2022-01-17 | Pulaski | Georgia | 13235 | 1823 | 68 |
2119357 | 2119357 | 2022-01-16 | Johnson | Georgia | 13167 | 1823 | 64 |
2116105 | 2116105 | 2022-01-15 | Johnson | Georgia | 13167 | 1823 | 64 |
2118027 | 2118027 | 2022-01-15 | Sabana Grande | Puerto Rico | 72121 | 1823 | |
2112854 | 2112854 | 2022-01-14 | Johnson | Georgia | 13167 | 1823 | 64 |
2110379 | 2110379 | 2022-01-13 | Baraga | Michigan | 26013 | 1823 | 49 |
2106427 | 2106427 | 2022-01-12 | Wilkinson | Georgia | 13319 | 1823 | 47 |
2107128 | 2107128 | 2022-01-12 | Baraga | Michigan | 26013 | 1823 | 49 |
2104141 | 2104141 | 2022-01-11 | Carroll | Missouri | 29033 | 1823 | 39 |
2078955 | 2078955 | 2022-01-03 | Barceloneta | Puerto Rico | 72017 | 1823 | |
2065584 | 2065584 | 2021-12-30 | Pamlico | North Carolina | 37137 | 1823 | 26 |
2058559 | 2058559 | 2021-12-28 | Jefferson Davis | Mississippi | 28065 | 1823 | 43 |
2054460 | 2054460 | 2021-12-27 | Teton | Idaho | 16081 | 1823 | 8 |
2055265 | 2055265 | 2021-12-27 | Swift | Minnesota | 27151 | 1823 | 29 |
2056328 | 2056328 | 2021-12-27 | Bon Homme | South Dakota | 46009 | 1823 | 31 |
2031405 | 2031405 | 2021-12-20 | Park | Colorado | 8093 | 1823 | 14 |
2019646 | 2019646 | 2021-12-16 | Grundy | Missouri | 29079 | 1823 | 56 |
2020402 | 2020402 | 2021-12-16 | Forest | Pennsylvania | 42053 | 1823 | 31 |
2012742 | 2012742 | 2021-12-14 | Catahoula | Louisiana | 22025 | 1823 | 48 |
1984875 | 1984875 | 2021-12-05 | Todd | South Dakota | 46121 | 1823 | 38 |
1981625 | 1981625 | 2021-12-04 | Todd | South Dakota | 46121 | 1823 | 38 |
1978375 | 1978375 | 2021-12-03 | Todd | South Dakota | 46121 | 1823 | 38 |
1924093 | 1924093 | 2021-11-17 | Bent | Colorado | 8011 | 1823 | 31 |
1912749 | 1912749 | 2021-11-13 | Yates | New York | 36123 | 1823 | 30 |
1881432 | 1881432 | 2021-11-03 | Pacific | Washington | 53049 | 1823 | 33 |
1878183 | 1878183 | 2021-11-02 | Pacific | Washington | 53049 | 1823 | 33 |
1859214 | 1859214 | 2021-10-28 | Liberty | Florida | 12077 | 1823 | 19 |
1855965 | 1855965 | 2021-10-27 | Liberty | Florida | 12077 | 1823 | 19 |
1852716 | 1852716 | 2021-10-26 | Liberty | Florida | 12077 | 1823 | 19 |
1849467 | 1849467 | 2021-10-25 | Liberty | Florida | 12077 | 1823 | 19 |
1850309 | 1850309 | 2021-10-25 | Washington | Maine | 23029 | 1823 | 20 |
1846217 | 1846217 | 2021-10-24 | Liberty | Florida | 12077 | 1823 | 19 |
1847059 | 1847059 | 2021-10-24 | Washington | Maine | 23029 | 1823 | 20 |
1842967 | 1842967 | 2021-10-23 | Liberty | Florida | 12077 | 1823 | 19 |
1843809 | 1843809 | 2021-10-23 | Washington | Maine | 23029 | 1823 | 20 |
1839717 | 1839717 | 2021-10-22 | Liberty | Florida | 12077 | 1823 | 19 |
1827918 | 1827918 | 2021-10-18 | Linn | Missouri | 29115 | 1823 | 26 |
1824669 | 1824669 | 2021-10-17 | Linn | Missouri | 29115 | 1823 | 26 |
1821420 | 1821420 | 2021-10-16 | Linn | Missouri | 29115 | 1823 | 26 |
1818171 | 1818171 | 2021-10-15 | Linn | Missouri | 29115 | 1823 | 26 |
1814388 | 1814388 | 2021-10-14 | Carroll | Kentucky | 21041 | 1823 | 23 |
1814922 | 1814922 | 2021-10-14 | Linn | Missouri | 29115 | 1823 | 26 |
1811674 | 1811674 | 2021-10-13 | Linn | Missouri | 29115 | 1823 | 26 |
1808425 | 1808425 | 2021-10-12 | Linn | Missouri | 29115 | 1823 | 25 |
1804695 | 1804695 | 2021-10-11 | Martin | Kentucky | 21159 | 1823 | 35 |
1805174 | 1805174 | 2021-10-11 | Linn | Missouri | 29115 | 1823 | 25 |
1801925 | 1801925 | 2021-10-10 | Linn | Missouri | 29115 | 1823 | 25 |
1798676 | 1798676 | 2021-10-09 | Linn | Missouri | 29115 | 1823 | 25 |
1791820 | 1791820 | 2021-10-07 | Sagadahoc | Maine | 23023 | 1823 | 12 |
1787104 | 1787104 | 2021-10-05 | Greensville | Virginia | 51081 | 1823 | 26 |
1741747 | 1741747 | 2021-09-21 | Grant | West Virginia | 54023 | 1823 | 31 |
1741781 | 1741781 | 2021-09-21 | Taylor | West Virginia | 54091 | 1823 | 29 |
1741797 | 1741797 | 2021-09-21 | Burnett | Wisconsin | 55013 | 1823 | 29 |
1732408 | 1732408 | 2021-09-19 | Grand | Colorado | 8049 | 1823 | 8 |
1735117 | 1735117 | 2021-09-19 | Grayson | Virginia | 51077 | 1823 | 40 |
1729158 | 1729158 | 2021-09-18 | Grand | Colorado | 8049 | 1823 | 8 |
1731867 | 1731867 | 2021-09-18 | Grayson | Virginia | 51077 | 1823 | 40 |
1732019 | 1732019 | 2021-09-18 | Monroe | West Virginia | 54063 | 1823 | 20 |
1725908 | 1725908 | 2021-09-17 | Grand | Colorado | 8049 | 1823 | 8 |
1728617 | 1728617 | 2021-09-17 | Grayson | Virginia | 51077 | 1823 | 40 |
1697789 | 1697789 | 2021-09-08 | Pennington | Minnesota | 27113 | 1823 | 20 |
1694650 | 1694650 | 2021-09-07 | Webster | Mississippi | 28155 | 1823 | 38 |
1691835 | 1691835 | 2021-09-06 | Chowan | North Carolina | 37041 | 1823 | 37 |
1688076 | 1688076 | 2021-09-05 | Amite | Mississippi | 28005 | 1823 | 49 |
1688585 | 1688585 | 2021-09-05 | Chowan | North Carolina | 37041 | 1823 | 37 |
1684826 | 1684826 | 2021-09-04 | Amite | Mississippi | 28005 | 1823 | 49 |
1685335 | 1685335 | 2021-09-04 | Chowan | North Carolina | 37041 | 1823 | 37 |
1681575 | 1681575 | 2021-09-03 | Amite | Mississippi | 28005 | 1823 | 49 |
1682084 | 1682084 | 2021-09-03 | Chowan | North Carolina | 37041 | 1823 | 37 |
1679257 | 1679257 | 2021-09-02 | Catano | Puerto Rico | 72033 | 1823 | |
1663791 | 1663791 | 2021-08-28 | Lincoln | West Virginia | 54043 | 1823 | 27 |
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);