ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
276 rows where cases = 1641 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 26
- North Carolina 23
- Texas 19
- Missouri 18
- Kentucky 15
- Indiana 13
- Iowa 13
- Minnesota 13
- Mississippi 12
- Illinois 10
- Puerto Rico 10
- Alabama 9
- Georgia 9
- Virginia 9
- Florida 8
- Ohio 7
- Tennessee 6
- Kansas 5
- Michigan 5
- Colorado 4
- Louisiana 4
- Nebraska 4
- Pennsylvania 4
- West Virginia 4
- California 3
- Idaho 3
- Oregon 3
- Wisconsin 3
- Maryland 2
- Oklahoma 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469654 | 2469654 | 2022-05-03 | Brooks | Texas | 48047 | 1641 | 52 |
2221242 | 2221242 | 2022-02-16 | Caldwell | Missouri | 29025 | 1641 | 32 |
2179052 | 2179052 | 2022-02-03 | Sullivan | Missouri | 29211 | 1641 | 19 |
2171072 | 2171072 | 2022-02-01 | Dallas | Arkansas | 5039 | 1641 | 22 |
2172686 | 2172686 | 2022-02-01 | Richardson | Nebraska | 31147 | 1641 | 24 |
2169433 | 2169433 | 2022-01-31 | Richardson | Nebraska | 31147 | 1641 | 24 |
2126360 | 2126360 | 2022-01-18 | Pratt | Kansas | 20151 | 1641 | 29 |
2123108 | 2123108 | 2022-01-17 | Pratt | Kansas | 20151 | 1641 | 29 |
2123149 | 2123149 | 2022-01-17 | Bracken | Kentucky | 21023 | 1641 | 22 |
2119856 | 2119856 | 2022-01-16 | Pratt | Kansas | 20151 | 1641 | 29 |
2119897 | 2119897 | 2022-01-16 | Bracken | Kentucky | 21023 | 1641 | 22 |
2116604 | 2116604 | 2022-01-15 | Pratt | Kansas | 20151 | 1641 | 29 |
2116645 | 2116645 | 2022-01-15 | Bracken | Kentucky | 21023 | 1641 | 22 |
2113353 | 2113353 | 2022-01-14 | Pratt | Kansas | 20151 | 1641 | 29 |
2113394 | 2113394 | 2022-01-14 | Bracken | Kentucky | 21023 | 1641 | 22 |
2107452 | 2107452 | 2022-01-12 | Oregon | Missouri | 29149 | 1641 | 27 |
2098517 | 2098517 | 2022-01-09 | Rincon | Puerto Rico | 72117 | 1641 | |
2099235 | 2099235 | 2022-01-09 | Gilmer | West Virginia | 54021 | 1641 | 16 |
2088857 | 2088857 | 2022-01-06 | Grant | South Dakota | 46051 | 1641 | 47 |
2084504 | 2084504 | 2022-01-05 | Pipestone | Minnesota | 27117 | 1641 | 30 |
2077214 | 2077214 | 2022-01-03 | Valley | Idaho | 16085 | 1641 | 13 |
2057952 | 2057952 | 2021-12-28 | Howard | Iowa | 19089 | 1641 | 24 |
2059774 | 2059774 | 2021-12-28 | Clay | Texas | 48077 | 1641 | 26 |
2054703 | 2054703 | 2021-12-27 | Howard | Iowa | 19089 | 1641 | 24 |
2051453 | 2051453 | 2021-12-26 | Howard | Iowa | 19089 | 1641 | 24 |
2048203 | 2048203 | 2021-12-25 | Howard | Iowa | 19089 | 1641 | 24 |
2044953 | 2044953 | 2021-12-24 | Howard | Iowa | 19089 | 1641 | 24 |
2041704 | 2041704 | 2021-12-23 | Howard | Iowa | 19089 | 1641 | 24 |
2038454 | 2038454 | 2021-12-22 | Howard | Iowa | 19089 | 1641 | 24 |
2031276 | 2031276 | 2021-12-20 | Perry | Arkansas | 5105 | 1641 | 24 |
2028025 | 2028025 | 2021-12-19 | Perry | Arkansas | 5105 | 1641 | 24 |
2030667 | 2030667 | 2021-12-19 | Ochiltree | Texas | 48357 | 1641 | 38 |
2024774 | 2024774 | 2021-12-18 | Perry | Arkansas | 5105 | 1641 | 23 |
2027416 | 2027416 | 2021-12-18 | Ochiltree | Texas | 48357 | 1641 | 38 |
2024503 | 2024503 | 2021-12-17 | Ritchie | West Virginia | 54085 | 1641 | 24 |
1993842 | 1993842 | 2021-12-08 | Phelps | Nebraska | 31137 | 1641 | 10 |
1990339 | 1990339 | 2021-12-07 | Tunica | Mississippi | 28143 | 1641 | 39 |
1983921 | 1983921 | 2021-12-05 | Montgomery | Missouri | 29139 | 1641 | 34 |
1980671 | 1980671 | 2021-12-04 | Montgomery | Missouri | 29139 | 1641 | 34 |
1964437 | 1964437 | 2021-11-29 | Ralls | Missouri | 29173 | 1641 | 17 |
1964851 | 1964851 | 2021-11-29 | Washington | North Carolina | 37187 | 1641 | 37 |
1965449 | 1965449 | 2021-11-29 | Perry | Tennessee | 47135 | 1641 | 34 |
1938821 | 1938821 | 2021-11-21 | Perquimans | North Carolina | 37143 | 1641 | 15 |
1935571 | 1935571 | 2021-11-20 | Perquimans | North Carolina | 37143 | 1641 | 15 |
1932321 | 1932321 | 2021-11-19 | Perquimans | North Carolina | 37143 | 1641 | 15 |
1921305 | 1921305 | 2021-11-16 | Brown | Indiana | 18013 | 1641 | 50 |
1910004 | 1910004 | 2021-11-12 | Yabucoa | Puerto Rico | 72151 | 1641 | |
1887182 | 1887182 | 2021-11-05 | Aguas Buenas | Puerto Rico | 72007 | 1641 | |
1883932 | 1883932 | 2021-11-04 | Aguas Buenas | Puerto Rico | 72007 | 1641 | |
1863634 | 1863634 | 2021-10-29 | Douglas | Missouri | 29067 | 1641 | 46 |
1859448 | 1859448 | 2021-10-28 | Owyhee | Idaho | 16073 | 1641 | 39 |
1836326 | 1836326 | 2021-10-21 | Plumas | California | 6063 | 1641 | 7 |
1813802 | 1813802 | 2021-10-14 | Dooly | Georgia | 13093 | 1641 | 54 |
1803867 | 1803867 | 2021-10-11 | Bent | Colorado | 8011 | 1641 | 23 |
1795387 | 1795387 | 2021-10-08 | Cedar | Missouri | 29039 | 1641 | 30 |
1789689 | 1789689 | 2021-10-06 | Potter | Pennsylvania | 42105 | 1641 | 31 |
1777690 | 1777690 | 2021-10-03 | Wilcox | Alabama | 1131 | 1641 | 37 |
1778953 | 1778953 | 2021-10-03 | Aitkin | Minnesota | 27001 | 1641 | 39 |
1775703 | 1775703 | 2021-10-02 | Aitkin | Minnesota | 27001 | 1641 | 39 |
1772453 | 1772453 | 2021-10-01 | Aitkin | Minnesota | 27001 | 1641 | 39 |
1764908 | 1764908 | 2021-09-29 | Las Animas | Colorado | 8071 | 1641 | 20 |
1765293 | 1765293 | 2021-09-29 | Menard | Illinois | 17129 | 1641 | 17 |
1761513 | 1761513 | 2021-09-28 | Fulton | Arkansas | 5049 | 1641 | 55 |
1755483 | 1755483 | 2021-09-26 | Washington | Idaho | 16087 | 1641 | 33 |
1757935 | 1757935 | 2021-09-26 | Westmoreland | Virginia | 51193 | 1641 | 30 |
1751807 | 1751807 | 2021-09-25 | Scott | Arkansas | 5127 | 1641 | 24 |
1754687 | 1754687 | 2021-09-25 | Westmoreland | Virginia | 51193 | 1641 | 30 |
1751439 | 1751439 | 2021-09-24 | Westmoreland | Virginia | 51193 | 1641 | 30 |
1733224 | 1733224 | 2021-09-19 | Metcalfe | Kentucky | 21169 | 1641 | 36 |
1733498 | 1733498 | 2021-09-19 | Kanabec | Minnesota | 27065 | 1641 | 29 |
1729974 | 1729974 | 2021-09-18 | Metcalfe | Kentucky | 21169 | 1641 | 36 |
1730248 | 1730248 | 2021-09-18 | Kanabec | Minnesota | 27065 | 1641 | 29 |
1726724 | 1726724 | 2021-09-17 | Metcalfe | Kentucky | 21169 | 1641 | 36 |
1726998 | 1726998 | 2021-09-17 | Kanabec | Minnesota | 27065 | 1641 | 29 |
1715803 | 1715803 | 2021-09-13 | Buffalo | Wisconsin | 55011 | 1641 | 7 |
1699735 | 1699735 | 2021-09-09 | Kusilvak Census Area | Alaska | 2158 | 1641 | 5 |
1665885 | 1665885 | 2021-08-29 | Mitchell | North Carolina | 37121 | 1641 | 16 |
1662637 | 1662637 | 2021-08-28 | Mitchell | North Carolina | 37121 | 1641 | 16 |
1659389 | 1659389 | 2021-08-27 | Mitchell | North Carolina | 37121 | 1641 | 16 |
1660079 | 1660079 | 2021-08-27 | Camp | Texas | 48063 | 1641 | 48 |
1647811 | 1647811 | 2021-08-24 | Desha | Arkansas | 5041 | 1641 | 24 |
1647020 | 1647020 | 2021-08-23 | Meigs | Tennessee | 47121 | 1641 | 24 |
1608572 | 1608572 | 2021-08-11 | Lincoln | West Virginia | 54043 | 1641 | 25 |
1591878 | 1591878 | 2021-08-06 | Comanche | Texas | 48093 | 1641 | 52 |
1579273 | 1579273 | 2021-08-02 | Clallam | Washington | 53009 | 1641 | 16 |
1555435 | 1555435 | 2021-07-26 | Madison | North Carolina | 37115 | 1641 | 43 |
1535524 | 1535524 | 2021-07-20 | Gasconade | Missouri | 29073 | 1641 | 47 |
1531990 | 1531990 | 2021-07-19 | Antrim | Michigan | 26009 | 1641 | 30 |
1532747 | 1532747 | 2021-07-19 | Yancey | North Carolina | 37199 | 1641 | 28 |
1529072 | 1529072 | 2021-07-18 | Pemiscot | Missouri | 29155 | 1641 | 39 |
1529500 | 1529500 | 2021-07-18 | Yancey | North Carolina | 37199 | 1641 | 28 |
1525825 | 1525825 | 2021-07-17 | Pemiscot | Missouri | 29155 | 1641 | 39 |
1526253 | 1526253 | 2021-07-17 | Yancey | North Carolina | 37199 | 1641 | 28 |
1523006 | 1523006 | 2021-07-16 | Yancey | North Carolina | 37199 | 1641 | 28 |
1519758 | 1519758 | 2021-07-15 | Yancey | North Carolina | 37199 | 1641 | 28 |
1516510 | 1516510 | 2021-07-14 | Yancey | North Carolina | 37199 | 1641 | 28 |
1500642 | 1500642 | 2021-07-09 | Isabela | Puerto Rico | 72071 | 1641 | |
1497396 | 1497396 | 2021-07-08 | Isabela | Puerto Rico | 72071 | 1641 | |
1493189 | 1493189 | 2021-07-07 | Wadena | Minnesota | 27159 | 1641 | 23 |
1489942 | 1489942 | 2021-07-06 | Wadena | Minnesota | 27159 | 1641 | 23 |
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);