ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
297 rows where cases = 1663 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 19
- Missouri 18
- Virginia 16
- Florida 15
- Texas 15
- Arkansas 14
- Illinois 14
- Georgia 13
- Montana 12
- Michigan 11
- Oklahoma 10
- Alabama 9
- Kentucky 9
- Puerto Rico 9
- Idaho 8
- Mississippi 8
- Nebraska 8
- Tennessee 8
- Utah 7
- Minnesota 6
- Pennsylvania 6
- Wisconsin 6
- North Carolina 5
- Colorado 4
- Indiana 4
- Kansas 4
- Louisiana 4
- New York 4
- Oregon 4
- South Carolina 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2263523 | 2263523 | 2022-03-01 | Daviess | Missouri | 29061 | 1663 | 26 |
2260272 | 2260272 | 2022-02-28 | Daviess | Missouri | 29061 | 1663 | 26 |
2234497 | 2234497 | 2022-02-20 | Wayne | Nebraska | 31179 | 1663 | 11 |
2231246 | 2231246 | 2022-02-19 | Wayne | Nebraska | 31179 | 1663 | 11 |
2227995 | 2227995 | 2022-02-18 | Wayne | Nebraska | 31179 | 1663 | 11 |
2224559 | 2224559 | 2022-02-17 | Ozark | Missouri | 29153 | 1663 | 48 |
2195866 | 2195866 | 2022-02-08 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2192612 | 2192612 | 2022-02-07 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2189358 | 2189358 | 2022-02-06 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2186105 | 2186105 | 2022-02-05 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2182853 | 2182853 | 2022-02-04 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2178126 | 2178126 | 2022-02-03 | Pulaski | Illinois | 17153 | 1663 | 16 |
2179601 | 2179601 | 2022-02-03 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2174873 | 2174873 | 2022-02-02 | Pulaski | Illinois | 17153 | 1663 | 16 |
2176350 | 2176350 | 2022-02-02 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2145221 | 2145221 | 2022-01-24 | Yuma | Colorado | 8125 | 1663 | 22 |
2146451 | 2146451 | 2022-01-24 | Harrison | Missouri | 29081 | 1663 | 27 |
2148052 | 2148052 | 2022-01-24 | Pocahontas | West Virginia | 54075 | 1663 | 25 |
2141689 | 2141689 | 2022-01-23 | Greene | Alabama | 1063 | 1663 | 47 |
2135133 | 2135133 | 2022-01-20 | Johnson | Wyoming | 56019 | 1663 | 18 |
2115175 | 2115175 | 2022-01-14 | Mitchell | Texas | 48335 | 1663 | 44 |
2109919 | 2109919 | 2022-01-13 | Warren | Indiana | 18171 | 1663 | 22 |
2110703 | 2110703 | 2022-01-13 | Oregon | Missouri | 29149 | 1663 | 27 |
2099089 | 2099089 | 2022-01-09 | Essex | Virginia | 51057 | 1663 | 21 |
2095838 | 2095838 | 2022-01-08 | Essex | Virginia | 51057 | 1663 | 21 |
2092586 | 2092586 | 2022-01-07 | Essex | Virginia | 51057 | 1663 | 21 |
2077396 | 2077396 | 2022-01-03 | Switzerland | Indiana | 18155 | 1663 | 14 |
2079278 | 2079278 | 2022-01-03 | Clay | Texas | 48077 | 1663 | 26 |
2057274 | 2057274 | 2021-12-28 | Perry | Arkansas | 5105 | 1663 | 25 |
2054957 | 2054957 | 2021-12-27 | Owen | Kentucky | 21187 | 1663 | 29 |
2028424 | 2028424 | 2021-12-19 | Benewah | Idaho | 16009 | 1663 | 29 |
2025173 | 2025173 | 2021-12-18 | Benewah | Idaho | 16009 | 1663 | 29 |
1993135 | 1993135 | 2021-12-08 | Edmonson | Kentucky | 21061 | 1663 | 33 |
1973514 | 1973514 | 2021-12-02 | Cloud | Kansas | 20029 | 1663 | 30 |
1974228 | 1974228 | 2021-12-02 | Deer Lodge | Montana | 30023 | 1663 | 27 |
1970264 | 1970264 | 2021-12-01 | Cloud | Kansas | 20029 | 1663 | 30 |
1971030 | 1971030 | 2021-12-01 | Box Butte | Nebraska | 31013 | 1663 | 16 |
1967689 | 1967689 | 2021-11-30 | Ralls | Missouri | 29173 | 1663 | 17 |
1926815 | 1926815 | 2021-11-17 | Franklin city | Virginia | 51620 | 1663 | 44 |
1922885 | 1922885 | 2021-11-16 | Forest | Pennsylvania | 42053 | 1663 | 26 |
1920231 | 1920231 | 2021-11-15 | Emery | Utah | 49015 | 1663 | 23 |
1916981 | 1916981 | 2021-11-14 | Emery | Utah | 49015 | 1663 | 23 |
1913731 | 1913731 | 2021-11-13 | Emery | Utah | 49015 | 1663 | 23 |
1899377 | 1899377 | 2021-11-09 | Douglas | Missouri | 29067 | 1663 | 47 |
1895190 | 1895190 | 2021-11-08 | Owyhee | Idaho | 16073 | 1663 | 39 |
1891940 | 1891940 | 2021-11-07 | Owyhee | Idaho | 16073 | 1663 | 39 |
1888690 | 1888690 | 2021-11-06 | Owyhee | Idaho | 16073 | 1663 | 39 |
1885440 | 1885440 | 2021-11-05 | Owyhee | Idaho | 16073 | 1663 | 39 |
1882191 | 1882191 | 2021-11-04 | Owyhee | Idaho | 16073 | 1663 | 39 |
1878942 | 1878942 | 2021-11-03 | Owyhee | Idaho | 16073 | 1663 | 39 |
1869854 | 1869854 | 2021-10-31 | Benzie | Michigan | 26019 | 1663 | 40 |
1871561 | 1871561 | 2021-10-31 | Dickenson | Virginia | 51051 | 1663 | 27 |
1866605 | 1866605 | 2021-10-30 | Benzie | Michigan | 26019 | 1663 | 40 |
1868312 | 1868312 | 2021-10-30 | Dickenson | Virginia | 51051 | 1663 | 27 |
1863356 | 1863356 | 2021-10-29 | Benzie | Michigan | 26019 | 1663 | 40 |
1865063 | 1865063 | 2021-10-29 | Dickenson | Virginia | 51051 | 1663 | 27 |
1813616 | 1813616 | 2021-10-14 | Bent | Colorado | 8011 | 1663 | 23 |
1805028 | 1805028 | 2021-10-11 | Watonwan | Minnesota | 27165 | 1663 | 11 |
1805040 | 1805040 | 2021-10-11 | Carroll | Mississippi | 28015 | 1663 | 38 |
1792466 | 1792466 | 2021-10-07 | Torrance | New Mexico | 35057 | 1663 | 18 |
1781407 | 1781407 | 2021-10-04 | Turner | Georgia | 13287 | 1663 | 48 |
1761183 | 1761183 | 2021-09-27 | Westmoreland | Virginia | 51193 | 1663 | 30 |
1757352 | 1757352 | 2021-09-26 | Butte | South Dakota | 46019 | 1663 | 24 |
1754104 | 1754104 | 2021-09-25 | Butte | South Dakota | 46019 | 1663 | 24 |
1750856 | 1750856 | 2021-09-24 | Butte | South Dakota | 46019 | 1663 | 24 |
1748077 | 1748077 | 2021-09-23 | Brunswick | Virginia | 51025 | 1663 | 29 |
1736836 | 1736836 | 2021-09-20 | Jefferson Davis | Mississippi | 28065 | 1663 | 41 |
1737510 | 1737510 | 2021-09-20 | Noble | Ohio | 39121 | 1663 | 40 |
1734374 | 1734374 | 2021-09-19 | Curry | Oregon | 41015 | 1663 | 17 |
1731124 | 1731124 | 2021-09-18 | Curry | Oregon | 41015 | 1663 | 17 |
1727228 | 1727228 | 2021-09-17 | Ripley | Missouri | 29181 | 1663 | 19 |
1727874 | 1727874 | 2021-09-17 | Curry | Oregon | 41015 | 1663 | 17 |
1724642 | 1724642 | 2021-09-16 | Morrow | Oregon | 41049 | 1663 | 21 |
1724814 | 1724814 | 2021-09-16 | Calhoun | South Carolina | 45017 | 1663 | 47 |
1716421 | 1716421 | 2021-09-14 | Towns | Georgia | 13281 | 1663 | 69 |
1700014 | 1700014 | 2021-09-09 | Liberty | Florida | 12077 | 1663 | 16 |
1696765 | 1696765 | 2021-09-08 | Liberty | Florida | 12077 | 1663 | 16 |
1693517 | 1693517 | 2021-09-07 | Liberty | Florida | 12077 | 1663 | 16 |
1690268 | 1690268 | 2021-09-06 | Liberty | Florida | 12077 | 1663 | 16 |
1691540 | 1691540 | 2021-09-06 | Glacier | Montana | 30035 | 1663 | 45 |
1691556 | 1691556 | 2021-09-06 | Park | Montana | 30067 | 1663 | 24 |
1687018 | 1687018 | 2021-09-05 | Liberty | Florida | 12077 | 1663 | 16 |
1688290 | 1688290 | 2021-09-05 | Glacier | Montana | 30035 | 1663 | 45 |
1688306 | 1688306 | 2021-09-05 | Park | Montana | 30067 | 1663 | 24 |
1683768 | 1683768 | 2021-09-04 | Liberty | Florida | 12077 | 1663 | 16 |
1685040 | 1685040 | 2021-09-04 | Glacier | Montana | 30035 | 1663 | 45 |
1685056 | 1685056 | 2021-09-04 | Park | Montana | 30067 | 1663 | 24 |
1680517 | 1680517 | 2021-09-03 | Liberty | Florida | 12077 | 1663 | 16 |
1681789 | 1681789 | 2021-09-03 | Glacier | Montana | 30035 | 1663 | 45 |
1681805 | 1681805 | 2021-09-03 | Park | Montana | 30067 | 1663 | 24 |
1670143 | 1670143 | 2021-08-30 | Goochland | Virginia | 51075 | 1663 | 25 |
1665412 | 1665412 | 2021-08-29 | Webster | Mississippi | 28155 | 1663 | 34 |
1662164 | 1662164 | 2021-08-28 | Webster | Mississippi | 28155 | 1663 | 34 |
1663327 | 1663327 | 2021-08-28 | Camp | Texas | 48063 | 1663 | 48 |
1658916 | 1658916 | 2021-08-27 | Webster | Mississippi | 28155 | 1663 | 34 |
1644402 | 1644402 | 2021-08-22 | Washburn | Wisconsin | 55129 | 1663 | 24 |
1641152 | 1641152 | 2021-08-21 | Washburn | Wisconsin | 55129 | 1663 | 24 |
1637902 | 1637902 | 2021-08-20 | Washburn | Wisconsin | 55129 | 1663 | 24 |
1632450 | 1632450 | 2021-08-19 | Caldwell | Kentucky | 21033 | 1663 | 32 |
1609319 | 1609319 | 2021-08-12 | De Witt | Illinois | 17039 | 1663 | 36 |
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);