ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
318 rows where cases = 1682 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 32
- Minnesota 23
- Missouri 21
- Iowa 19
- Kentucky 17
- Tennessee 16
- Michigan 14
- Illinois 12
- Mississippi 12
- Oklahoma 12
- Virginia 10
- Alabama 8
- Arkansas 8
- Georgia 8
- Indiana 8
- Louisiana 7
- Puerto Rico 7
- Kansas 6
- North Carolina 6
- Vermont 6
- Wisconsin 6
- Ohio 5
- South Dakota 5
- West Virginia 5
- New York 4
- Pennsylvania 4
- California 3
- Colorado 3
- Idaho 3
- Montana 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401411 | 2401411 | 2022-04-12 | Marion | Texas | 48315 | 1682 | 59 |
2328554 | 2328554 | 2022-03-21 | Caldwell | Missouri | 29025 | 1682 | 36 |
2309035 | 2309035 | 2022-03-15 | Caldwell | Missouri | 29025 | 1682 | 36 |
2305783 | 2305783 | 2022-03-14 | Caldwell | Missouri | 29025 | 1682 | 35 |
2257011 | 2257011 | 2022-02-27 | Chariton | Missouri | 29041 | 1682 | 34 |
2253760 | 2253760 | 2022-02-26 | Chariton | Missouri | 29041 | 1682 | 34 |
2250509 | 2250509 | 2022-02-25 | Chariton | Missouri | 29041 | 1682 | 34 |
2223168 | 2223168 | 2022-02-17 | Woodruff | Arkansas | 5147 | 1682 | 25 |
2214835 | 2214835 | 2022-02-14 | Sullivan | Missouri | 29211 | 1682 | 19 |
2197643 | 2197643 | 2022-02-09 | Pulaski | Illinois | 17153 | 1682 | 16 |
2183521 | 2183521 | 2022-02-04 | Refugio | Texas | 48391 | 1682 | 31 |
2176116 | 2176116 | 2022-02-02 | Camden | North Carolina | 37029 | 1682 | 9 |
2167123 | 2167123 | 2022-01-30 | Delta | Texas | 48119 | 1682 | 22 |
2151302 | 2151302 | 2022-01-25 | Pendleton | West Virginia | 54071 | 1682 | 16 |
2147754 | 2147754 | 2022-01-24 | Stephens | Texas | 48429 | 1682 | 40 |
2129762 | 2129762 | 2022-01-19 | Wolfe | Kentucky | 21237 | 1682 | 16 |
2127579 | 2127579 | 2022-01-18 | Latimer | Oklahoma | 40077 | 1682 | 29 |
2128499 | 2128499 | 2022-01-18 | Doddridge | West Virginia | 54017 | 1682 | 16 |
2124327 | 2124327 | 2022-01-17 | Latimer | Oklahoma | 40077 | 1682 | 29 |
2121075 | 2121075 | 2022-01-16 | Latimer | Oklahoma | 40077 | 1682 | 29 |
2117823 | 2117823 | 2022-01-15 | Latimer | Oklahoma | 40077 | 1682 | 29 |
2118355 | 2118355 | 2022-01-15 | Hamilton | Texas | 48193 | 1682 | 29 |
2112481 | 2112481 | 2022-01-14 | Greenlee | Arizona | 4011 | 1682 | 30 |
2114572 | 2114572 | 2022-01-14 | Latimer | Oklahoma | 40077 | 1682 | 29 |
2111320 | 2111320 | 2022-01-13 | Latimer | Oklahoma | 40077 | 1682 | 29 |
2111968 | 2111968 | 2022-01-13 | Somervell | Texas | 48425 | 1682 | 28 |
2108068 | 2108068 | 2022-01-12 | Latimer | Oklahoma | 40077 | 1682 | 29 |
2074410 | 2074410 | 2022-01-02 | Hancock | Kentucky | 21091 | 1682 | 19 |
2071159 | 2071159 | 2022-01-01 | Hancock | Kentucky | 21091 | 1682 | 19 |
2067908 | 2067908 | 2021-12-31 | Hancock | Kentucky | 21091 | 1682 | 19 |
2064657 | 2064657 | 2021-12-30 | Hancock | Kentucky | 21091 | 1682 | 19 |
2061407 | 2061407 | 2021-12-29 | Hancock | Kentucky | 21091 | 1682 | 19 |
2058403 | 2058403 | 2021-12-28 | Mackinac | Michigan | 26097 | 1682 | 19 |
2058737 | 2058737 | 2021-12-28 | Deer Lodge | Montana | 30023 | 1682 | 28 |
2055154 | 2055154 | 2021-12-27 | Mackinac | Michigan | 26097 | 1682 | 19 |
2055488 | 2055488 | 2021-12-27 | Deer Lodge | Montana | 30023 | 1682 | 28 |
2051954 | 2051954 | 2021-12-26 | Clearwater | Minnesota | 27029 | 1682 | 25 |
2052950 | 2052950 | 2021-12-26 | Anasco | Puerto Rico | 72011 | 1682 | |
2048704 | 2048704 | 2021-12-25 | Clearwater | Minnesota | 27029 | 1682 | 25 |
2045454 | 2045454 | 2021-12-24 | Clearwater | Minnesota | 27029 | 1682 | 25 |
2042204 | 2042204 | 2021-12-23 | Clearwater | Minnesota | 27029 | 1682 | 25 |
2034925 | 2034925 | 2021-12-21 | Benewah | Idaho | 16009 | 1682 | 29 |
2036362 | 2036362 | 2021-12-21 | Washington | North Carolina | 37187 | 1682 | 38 |
2029391 | 2029391 | 2021-12-19 | DeKalb | Missouri | 29063 | 1682 | 37 |
2026140 | 2026140 | 2021-12-18 | DeKalb | Missouri | 29063 | 1682 | 37 |
2012922 | 2012922 | 2021-12-14 | Presque Isle | Michigan | 26141 | 1682 | 50 |
2008936 | 2008936 | 2021-12-13 | Fremont | Idaho | 16043 | 1682 | 18 |
2009671 | 2009671 | 2021-12-13 | Presque Isle | Michigan | 26141 | 1682 | 50 |
1984870 | 1984870 | 2021-12-05 | Roberts | South Dakota | 46109 | 1682 | 45 |
1981620 | 1981620 | 2021-12-04 | Roberts | South Dakota | 46109 | 1682 | 45 |
1978370 | 1978370 | 2021-12-03 | Roberts | South Dakota | 46109 | 1682 | 45 |
1978649 | 1978649 | 2021-12-03 | Morris | Texas | 48343 | 1682 | 56 |
1962518 | 1962518 | 2021-11-28 | Orange | Vermont | 50017 | 1682 | 6 |
1959267 | 1959267 | 2021-11-27 | Orange | Vermont | 50017 | 1682 | 6 |
1956016 | 1956016 | 2021-11-26 | Orange | Vermont | 50017 | 1682 | 6 |
1952765 | 1952765 | 2021-11-25 | Orange | Vermont | 50017 | 1682 | 6 |
1949514 | 1949514 | 2021-11-24 | Orange | Vermont | 50017 | 1682 | 6 |
1940689 | 1940689 | 2021-11-22 | Owyhee | Idaho | 16073 | 1682 | 40 |
1863620 | 1863620 | 2021-10-29 | Cedar | Missouri | 29039 | 1682 | 30 |
1860371 | 1860371 | 2021-10-28 | Cedar | Missouri | 29039 | 1682 | 30 |
1855823 | 1855823 | 2021-10-27 | Plumas | California | 6063 | 1682 | 7 |
1852447 | 1852447 | 2021-10-26 | Valdez-Cordova Census Area | Alaska | 2261 | 1682 | 7 |
1827579 | 1827579 | 2021-10-18 | Kent | Maryland | 24029 | 1682 | 55 |
1827784 | 1827784 | 2021-10-18 | Carroll | Mississippi | 28015 | 1682 | 38 |
1814776 | 1814776 | 2021-10-14 | Watonwan | Minnesota | 27165 | 1682 | 11 |
1788700 | 1788700 | 2021-10-06 | Aitkin | Minnesota | 27001 | 1682 | 41 |
1742983 | 1742983 | 2021-09-22 | Pendleton | Kentucky | 21191 | 1682 | 12 |
1743575 | 1743575 | 2021-09-22 | Colfax | Nebraska | 31037 | 1682 | 21 |
1744311 | 1744311 | 2021-09-22 | Calhoun | South Carolina | 45017 | 1682 | 49 |
1739446 | 1739446 | 2021-09-21 | Calhoun | Iowa | 19025 | 1682 | 13 |
1741843 | 1741843 | 2021-09-21 | Richland | Wisconsin | 55103 | 1682 | 19 |
1736197 | 1736197 | 2021-09-20 | Calhoun | Iowa | 19025 | 1682 | 13 |
1738380 | 1738380 | 2021-09-20 | King William | Virginia | 51101 | 1682 | 18 |
1732947 | 1732947 | 2021-09-19 | Calhoun | Iowa | 19025 | 1682 | 13 |
1733728 | 1733728 | 2021-09-19 | Ripley | Missouri | 29181 | 1682 | 19 |
1729697 | 1729697 | 2021-09-18 | Calhoun | Iowa | 19025 | 1682 | 13 |
1726447 | 1726447 | 2021-09-17 | Calhoun | Iowa | 19025 | 1682 | 13 |
1723198 | 1723198 | 2021-09-16 | Calhoun | Iowa | 19025 | 1682 | 13 |
1719949 | 1719949 | 2021-09-15 | Calhoun | Iowa | 19025 | 1682 | 13 |
1694789 | 1694789 | 2021-09-07 | Glacier | Montana | 30035 | 1682 | 45 |
1691092 | 1691092 | 2021-09-06 | West Carroll | Louisiana | 22123 | 1682 | 44 |
1687842 | 1687842 | 2021-09-05 | West Carroll | Louisiana | 22123 | 1682 | 44 |
1684592 | 1684592 | 2021-09-04 | West Carroll | Louisiana | 22123 | 1682 | 44 |
1681341 | 1681341 | 2021-09-03 | West Carroll | Louisiana | 22123 | 1682 | 44 |
1673932 | 1673932 | 2021-09-01 | Grand | Colorado | 8049 | 1682 | 7 |
1676639 | 1676639 | 2021-09-01 | Grayson | Virginia | 51077 | 1682 | 40 |
1670146 | 1670146 | 2021-08-30 | Greensville | Virginia | 51081 | 1682 | 26 |
1670326 | 1670326 | 2021-08-30 | Burnett | Wisconsin | 55013 | 1682 | 29 |
1647323 | 1647323 | 2021-08-23 | Millard | Utah | 49027 | 1682 | 17 |
1625768 | 1625768 | 2021-08-17 | Floyd | Iowa | 19067 | 1682 | 42 |
1622521 | 1622521 | 2021-08-16 | Floyd | Iowa | 19067 | 1682 | 42 |
1623040 | 1623040 | 2021-08-16 | Fillmore | Minnesota | 27045 | 1682 | 10 |
1623098 | 1623098 | 2021-08-16 | Wadena | Minnesota | 27159 | 1682 | 23 |
1619274 | 1619274 | 2021-08-15 | Floyd | Iowa | 19067 | 1682 | 42 |
1616026 | 1616026 | 2021-08-14 | Floyd | Iowa | 19067 | 1682 | 42 |
1612777 | 1612777 | 2021-08-13 | Floyd | Iowa | 19067 | 1682 | 42 |
1609529 | 1609529 | 2021-08-12 | Floyd | Iowa | 19067 | 1682 | 42 |
1609723 | 1609723 | 2021-08-12 | Casey | Kentucky | 21045 | 1682 | 43 |
1609740 | 1609740 | 2021-08-12 | Garrard | Kentucky | 21079 | 1682 | 37 |
1606280 | 1606280 | 2021-08-11 | Floyd | Iowa | 19067 | 1682 | 42 |
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);