ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
311 rows where cases = 1546 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 33
- Georgia 21
- Missouri 21
- Iowa 15
- Puerto Rico 15
- Colorado 14
- Kentucky 13
- Alabama 12
- Montana 12
- Oregon 11
- Minnesota 10
- Louisiana 9
- Tennessee 9
- Wisconsin 9
- Arkansas 7
- Illinois 7
- Indiana 7
- Kansas 7
- Nebraska 7
- North Carolina 7
- Michigan 6
- Virginia 6
- West Virginia 6
- Mississippi 5
- Ohio 5
- Oklahoma 5
- Pennsylvania 5
- North Dakota 4
- New York 3
- Vermont 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2398154 | 2398154 | 2022-04-11 | Lynn | Texas | 48305 | 1546 | 38 |
2394899 | 2394899 | 2022-04-10 | Lynn | Texas | 48305 | 1546 | 38 |
2391643 | 2391643 | 2022-04-09 | Lynn | Texas | 48305 | 1546 | 38 |
2382604 | 2382604 | 2022-04-07 | Clear Creek | Colorado | 8019 | 1546 | 12 |
2247982 | 2247982 | 2022-02-24 | Grant | Oregon | 41023 | 1546 | 18 |
2244731 | 2244731 | 2022-02-23 | Grant | Oregon | 41023 | 1546 | 18 |
2241480 | 2241480 | 2022-02-22 | Grant | Oregon | 41023 | 1546 | 18 |
2238229 | 2238229 | 2022-02-21 | Grant | Oregon | 41023 | 1546 | 18 |
2234978 | 2234978 | 2022-02-20 | Grant | Oregon | 41023 | 1546 | 18 |
2231727 | 2231727 | 2022-02-19 | Grant | Oregon | 41023 | 1546 | 18 |
2228476 | 2228476 | 2022-02-18 | Grant | Oregon | 41023 | 1546 | 18 |
2225225 | 2225225 | 2022-02-17 | Grant | Oregon | 41023 | 1546 | 18 |
2195186 | 2195186 | 2022-02-08 | Quitman | Mississippi | 28119 | 1546 | 30 |
2195272 | 2195272 | 2022-02-08 | Maries | Missouri | 29125 | 1546 | 29 |
2146657 | 2146657 | 2022-01-24 | Richardson | Nebraska | 31147 | 1546 | 24 |
2147637 | 2147637 | 2022-01-24 | Hansford | Texas | 48195 | 1546 | 27 |
2147735 | 2147735 | 2022-01-24 | Refugio | Texas | 48391 | 1546 | 31 |
2125275 | 2125275 | 2022-01-17 | Pocahontas | West Virginia | 54075 | 1546 | 24 |
2063468 | 2063468 | 2021-12-29 | Doddridge | West Virginia | 54017 | 1546 | 13 |
2032828 | 2032828 | 2021-12-20 | Holt | Nebraska | 31089 | 1546 | 16 |
2033928 | 2033928 | 2021-12-20 | Rains | Texas | 48379 | 1546 | 49 |
2034223 | 2034223 | 2021-12-20 | Gilmer | West Virginia | 54021 | 1546 | 14 |
2030678 | 2030678 | 2021-12-19 | Rains | Texas | 48379 | 1546 | 49 |
2027427 | 2027427 | 2021-12-18 | Rains | Texas | 48379 | 1546 | 49 |
2024176 | 2024176 | 2021-12-17 | Rains | Texas | 48379 | 1546 | 49 |
2020925 | 2020925 | 2021-12-16 | Rains | Texas | 48379 | 1546 | 49 |
2017674 | 2017674 | 2021-12-15 | Rains | Texas | 48379 | 1546 | 49 |
2014424 | 2014424 | 2021-12-14 | Rains | Texas | 48379 | 1546 | 49 |
1992609 | 1992609 | 2021-12-08 | Pulaski | Georgia | 13235 | 1546 | 66 |
1989358 | 1989358 | 2021-12-07 | Pulaski | Georgia | 13235 | 1546 | 66 |
1969846 | 1969846 | 2021-12-01 | Montgomery | Georgia | 13209 | 1546 | 44 |
1907758 | 1907758 | 2021-11-12 | Perry | Arkansas | 5105 | 1546 | 22 |
1905704 | 1905704 | 2021-11-11 | Jackson | Minnesota | 27063 | 1546 | 16 |
1901388 | 1901388 | 2021-11-10 | Park | Colorado | 8093 | 1546 | 10 |
1894521 | 1894521 | 2021-11-07 | Forest | Wisconsin | 55041 | 1546 | 32 |
1891271 | 1891271 | 2021-11-06 | Forest | Wisconsin | 55041 | 1546 | 32 |
1886415 | 1886415 | 2021-11-05 | Montgomery | Missouri | 29139 | 1546 | 19 |
1888021 | 1888021 | 2021-11-05 | Forest | Wisconsin | 55041 | 1546 | 32 |
1882112 | 1882112 | 2021-11-04 | Seminole | Georgia | 13253 | 1546 | 25 |
1881151 | 1881151 | 2021-11-03 | Ochiltree | Texas | 48357 | 1546 | 37 |
1859402 | 1859402 | 2021-10-28 | Wilkes | Georgia | 13317 | 1546 | 35 |
1859853 | 1859853 | 2021-10-28 | Wilson | Kansas | 20205 | 1546 | 33 |
1859886 | 1859886 | 2021-10-28 | Edmonson | Kentucky | 21061 | 1546 | 29 |
1856604 | 1856604 | 2021-10-27 | Wilson | Kansas | 20205 | 1546 | 33 |
1857582 | 1857582 | 2021-10-27 | Perquimans | North Carolina | 37143 | 1546 | 15 |
1858268 | 1858268 | 2021-10-27 | Clay | Texas | 48077 | 1546 | 23 |
1844498 | 1844498 | 2021-10-23 | Schuyler | New York | 36097 | 1546 | 17 |
1834253 | 1834253 | 2021-10-20 | Rock | Minnesota | 27133 | 1546 | 19 |
1834485 | 1834485 | 2021-10-20 | Deer Lodge | Montana | 30023 | 1546 | 24 |
1830083 | 1830083 | 2021-10-19 | Johnson | Georgia | 13167 | 1546 | 60 |
1828862 | 1828862 | 2021-10-18 | Lake | South Dakota | 46079 | 1546 | 20 |
1798656 | 1798656 | 2021-10-09 | Grundy | Missouri | 29079 | 1546 | 47 |
1799410 | 1799410 | 2021-10-09 | Forest | Pennsylvania | 42053 | 1546 | 23 |
1785407 | 1785407 | 2021-10-05 | Kalkaska | Michigan | 26079 | 1546 | 30 |
1782158 | 1782158 | 2021-10-04 | Kalkaska | Michigan | 26079 | 1546 | 30 |
1765202 | 1765202 | 2021-09-29 | Clearwater | Idaho | 16035 | 1546 | 24 |
1739081 | 1739081 | 2021-09-21 | Evans | Georgia | 13109 | 1546 | 43 |
1740482 | 1740482 | 2021-09-21 | Torrance | New Mexico | 35057 | 1546 | 17 |
1737395 | 1737395 | 2021-09-20 | Barnes | North Dakota | 38003 | 1546 | 32 |
1725811 | 1725811 | 2021-09-17 | Scott | Arkansas | 5127 | 1546 | 23 |
1709680 | 1709680 | 2021-09-12 | Las Animas | Colorado | 8071 | 1546 | 18 |
1706433 | 1706433 | 2021-09-11 | Las Animas | Colorado | 8071 | 1546 | 18 |
1703069 | 1703069 | 2021-09-10 | Pike | Arkansas | 5109 | 1546 | 32 |
1703185 | 1703185 | 2021-09-10 | Las Animas | Colorado | 8071 | 1546 | 18 |
1705558 | 1705558 | 2021-09-10 | Callahan | Texas | 48059 | 1546 | 48 |
1675697 | 1675697 | 2021-09-01 | Mountrail | North Dakota | 38061 | 1546 | 19 |
1671305 | 1671305 | 2021-08-31 | Winnebago | Iowa | 19189 | 1546 | 31 |
1673393 | 1673393 | 2021-08-31 | Greene | Virginia | 51079 | 1546 | 23 |
1668058 | 1668058 | 2021-08-30 | Winnebago | Iowa | 19189 | 1546 | 31 |
1669419 | 1669419 | 2021-08-30 | Morrow | Oregon | 41049 | 1546 | 20 |
1664811 | 1664811 | 2021-08-29 | Winnebago | Iowa | 19189 | 1546 | 31 |
1661563 | 1661563 | 2021-08-28 | Winnebago | Iowa | 19189 | 1546 | 31 |
1663006 | 1663006 | 2021-08-28 | Aguas Buenas | Puerto Rico | 72007 | 1546 | |
1658315 | 1658315 | 2021-08-27 | Winnebago | Iowa | 19189 | 1546 | 31 |
1655067 | 1655067 | 2021-08-26 | Winnebago | Iowa | 19189 | 1546 | 31 |
1651820 | 1651820 | 2021-08-25 | Winnebago | Iowa | 19189 | 1546 | 31 |
1652959 | 1652959 | 2021-08-25 | McKenzie | North Dakota | 38053 | 1546 | 15 |
1649209 | 1649209 | 2021-08-24 | Dent | Missouri | 29065 | 1546 | 25 |
1649711 | 1649711 | 2021-08-24 | McKenzie | North Dakota | 38053 | 1546 | 15 |
1647003 | 1647003 | 2021-08-23 | Jackson | Tennessee | 47087 | 1546 | 37 |
1632829 | 1632829 | 2021-08-19 | Sibley | Minnesota | 27143 | 1546 | 10 |
1595974 | 1595974 | 2021-08-08 | Grand | Colorado | 8049 | 1546 | 7 |
1592725 | 1592725 | 2021-08-07 | Grand | Colorado | 8049 | 1546 | 7 |
1589476 | 1589476 | 2021-08-06 | Grand | Colorado | 8049 | 1546 | 7 |
1586227 | 1586227 | 2021-08-05 | Grand | Colorado | 8049 | 1546 | 7 |
1588301 | 1588301 | 2021-08-05 | Cabo Rojo | Puerto Rico | 72023 | 1546 | |
1577547 | 1577547 | 2021-08-02 | Chippewa | Minnesota | 27023 | 1546 | 38 |
1578843 | 1578843 | 2021-08-02 | Bandera | Texas | 48019 | 1546 | 32 |
1573365 | 1573365 | 2021-08-01 | Brooks | Georgia | 13027 | 1546 | 50 |
1575595 | 1575595 | 2021-08-01 | Bandera | Texas | 48019 | 1546 | 32 |
1575884 | 1575884 | 2021-08-01 | Windsor | Vermont | 50027 | 1546 | 13 |
1570117 | 1570117 | 2021-07-31 | Brooks | Georgia | 13027 | 1546 | 50 |
1572347 | 1572347 | 2021-07-31 | Bandera | Texas | 48019 | 1546 | 32 |
1572636 | 1572636 | 2021-07-31 | Windsor | Vermont | 50027 | 1546 | 13 |
1566869 | 1566869 | 2021-07-30 | Brooks | Georgia | 13027 | 1546 | 50 |
1569388 | 1569388 | 2021-07-30 | Windsor | Vermont | 50027 | 1546 | 13 |
1565478 | 1565478 | 2021-07-29 | Wasco | Oregon | 41065 | 1546 | 31 |
1559073 | 1559073 | 2021-07-27 | Cidra | Puerto Rico | 72041 | 1546 | |
1531418 | 1531418 | 2021-07-19 | Piatt | Illinois | 17147 | 1546 | 20 |
1527747 | 1527747 | 2021-07-18 | Bent | Colorado | 8011 | 1546 | 22 |
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);