ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
278 rows where cases = 1931 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 35
- Michigan 25
- Illinois 16
- Georgia 13
- Missouri 13
- Virginia 12
- Wisconsin 12
- South Dakota 11
- Arkansas 9
- Ohio 9
- Alabama 8
- Indiana 8
- Minnesota 8
- Tennessee 8
- Colorado 7
- Kentucky 7
- Nebraska 7
- California 6
- Kansas 6
- Mississippi 6
- Iowa 5
- Washington 5
- Louisiana 4
- North Carolina 4
- Puerto Rico 4
- Oklahoma 3
- Pennsylvania 3
- South Carolina 3
- West Virginia 3
- Alaska 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500548 | 2500548 | 2022-05-13 | Pratt | Kansas | 20151 | 1931 | 30 |
2484971 | 2484971 | 2022-05-08 | Butler | Nebraska | 31023 | 1931 | 18 |
2481713 | 2481713 | 2022-05-07 | Butler | Nebraska | 31023 | 1931 | 18 |
2478455 | 2478455 | 2022-05-06 | Butler | Nebraska | 31023 | 1931 | 18 |
2473670 | 2473670 | 2022-05-05 | Monroe | Arkansas | 5095 | 1931 | 35 |
2475197 | 2475197 | 2022-05-05 | Butler | Nebraska | 31023 | 1931 | 18 |
2313004 | 2313004 | 2022-03-16 | Unknown | Oklahoma | 1931 | 217 | |
2309751 | 2309751 | 2022-03-15 | Unknown | Oklahoma | 1931 | 217 | |
2307118 | 2307118 | 2022-03-14 | Swisher | Texas | 48437 | 1931 | 33 |
2303867 | 2303867 | 2022-03-13 | Swisher | Texas | 48437 | 1931 | 33 |
2300615 | 2300615 | 2022-03-12 | Swisher | Texas | 48437 | 1931 | 33 |
2297363 | 2297363 | 2022-03-11 | Swisher | Texas | 48437 | 1931 | 33 |
2294111 | 2294111 | 2022-03-10 | Swisher | Texas | 48437 | 1931 | 33 |
2223668 | 2223668 | 2022-02-17 | Schuyler | Illinois | 17169 | 1931 | 29 |
2222678 | 2222678 | 2022-02-16 | Buena Vista city | Virginia | 51530 | 1931 | 39 |
2198351 | 2198351 | 2022-02-09 | Pipestone | Minnesota | 27117 | 1931 | 33 |
2189927 | 2189927 | 2022-02-06 | Hamilton | Texas | 48193 | 1931 | 29 |
2179021 | 2179021 | 2022-02-03 | Oregon | Missouri | 29149 | 1931 | 28 |
2164320 | 2164320 | 2022-01-29 | Pleasants | West Virginia | 54073 | 1931 | 33 |
2151181 | 2151181 | 2022-01-25 | Northampton | Virginia | 51131 | 1931 | 52 |
2140794 | 2140794 | 2022-01-22 | Penuelas | Puerto Rico | 72111 | 1931 | |
2141209 | 2141209 | 2022-01-22 | Ochiltree | Texas | 48357 | 1931 | 40 |
2128765 | 2128765 | 2022-01-19 | Cleveland | Arkansas | 5025 | 1931 | 33 |
2128355 | 2128355 | 2022-01-18 | Essex | Virginia | 51057 | 1931 | 22 |
2107489 | 2107489 | 2022-01-12 | Wayne | Missouri | 29223 | 1931 | 37 |
2104252 | 2104252 | 2022-01-11 | Dawson | Montana | 30021 | 1931 | 53 |
2105005 | 2105005 | 2022-01-11 | Luquillo | Puerto Rico | 72089 | 1931 | |
2034454 | 2034454 | 2021-12-21 | Valdez-Cordova Census Area | Alaska | 2261 | 1931 | 11 |
2031204 | 2031204 | 2021-12-20 | Valdez-Cordova Census Area | Alaska | 2261 | 1931 | 11 |
2032932 | 2032932 | 2021-12-20 | Colfax | New Mexico | 35007 | 1931 | 54 |
2028816 | 2028816 | 2021-12-19 | Marshall | Kansas | 20117 | 1931 | 35 |
2025565 | 2025565 | 2021-12-18 | Marshall | Kansas | 20117 | 1931 | 35 |
2022314 | 2022314 | 2021-12-17 | Marshall | Kansas | 20117 | 1931 | 35 |
2011858 | 2011858 | 2021-12-14 | Bent | Colorado | 8011 | 1931 | 35 |
2010115 | 2010115 | 2021-12-13 | Unknown | Nebraska | 1931 | 267 | |
1974839 | 1974839 | 2021-12-02 | Curry | Oregon | 41015 | 1931 | 39 |
1969370 | 1969370 | 2021-12-01 | Conecuh | Alabama | 1035 | 1931 | 62 |
1966120 | 1966120 | 2021-11-30 | Conecuh | Alabama | 1035 | 1931 | 62 |
1906378 | 1906378 | 2021-11-11 | McLean | North Dakota | 38055 | 1931 | 41 |
1907501 | 1907501 | 2021-11-11 | Ashland | Wisconsin | 55003 | 1931 | 18 |
1875996 | 1875996 | 2021-11-02 | Allen | Kansas | 20001 | 1931 | 26 |
1872747 | 1872747 | 2021-11-01 | Allen | Kansas | 20001 | 1931 | 26 |
1860092 | 1860092 | 2021-10-28 | Nantucket | Massachusetts | 25019 | 1931 | 0 |
1857135 | 1857135 | 2021-10-27 | Dent | Missouri | 29065 | 1931 | 41 |
1836394 | 1836394 | 2021-10-21 | Moffat | Colorado | 8081 | 1931 | 40 |
1837306 | 1837306 | 2021-10-21 | Sagadahoc | Maine | 23023 | 1931 | 12 |
1839187 | 1839187 | 2021-10-21 | Klickitat | Washington | 53039 | 1931 | 18 |
1792019 | 1792019 | 2021-10-07 | Sibley | Minnesota | 27143 | 1931 | 12 |
1788563 | 1788563 | 2021-10-06 | Franklin | Maine | 23007 | 1931 | 19 |
1780991 | 1780991 | 2021-10-04 | Bradley | Arkansas | 5011 | 1931 | 37 |
1783879 | 1783879 | 2021-10-04 | Martinsville city | Virginia | 51690 | 1931 | 86 |
1762045 | 1762045 | 2021-09-28 | Mercer | Illinois | 17131 | 1931 | 34 |
1758805 | 1758805 | 2021-09-27 | Piatt | Illinois | 17147 | 1931 | 20 |
1756998 | 1756998 | 2021-09-26 | Monroe | Ohio | 39111 | 1931 | 49 |
1750734 | 1750734 | 2021-09-24 | Cayey | Puerto Rico | 72035 | 1931 | |
1736881 | 1736881 | 2021-09-20 | Webster | Mississippi | 28155 | 1931 | 42 |
1726666 | 1726666 | 2021-09-17 | Clinton | Kentucky | 21053 | 1931 | 33 |
1714115 | 1714115 | 2021-09-13 | Perry | Mississippi | 28111 | 1931 | 53 |
1712563 | 1712563 | 2021-09-12 | Crawford | Wisconsin | 55023 | 1931 | 22 |
1709316 | 1709316 | 2021-09-11 | Crawford | Wisconsin | 55023 | 1931 | 22 |
1706069 | 1706069 | 2021-09-10 | Crawford | Wisconsin | 55023 | 1931 | 22 |
1691300 | 1691300 | 2021-09-06 | Renville | Minnesota | 27129 | 1931 | 46 |
1688050 | 1688050 | 2021-09-05 | Renville | Minnesota | 27129 | 1931 | 46 |
1684800 | 1684800 | 2021-09-04 | Renville | Minnesota | 27129 | 1931 | 46 |
1681549 | 1681549 | 2021-09-03 | Renville | Minnesota | 27129 | 1931 | 46 |
1674359 | 1674359 | 2021-09-01 | Washington | Illinois | 17189 | 1931 | 32 |
1670563 | 1670563 | 2021-08-31 | Lee | Arkansas | 5077 | 1931 | 40 |
1664563 | 1664563 | 2021-08-29 | Jo Daviess | Illinois | 17085 | 1931 | 27 |
1661315 | 1661315 | 2021-08-28 | Jo Daviess | Illinois | 17085 | 1931 | 27 |
1658067 | 1658067 | 2021-08-27 | Jo Daviess | Illinois | 17085 | 1931 | 27 |
1654429 | 1654429 | 2021-08-26 | Chaffee | Colorado | 8015 | 1931 | 26 |
1651552 | 1651552 | 2021-08-25 | Edgar | Illinois | 17045 | 1931 | 62 |
1625080 | 1625080 | 2021-08-17 | Howard | Arkansas | 5061 | 1931 | 28 |
1626252 | 1626252 | 2021-08-17 | Roscommon | Michigan | 26143 | 1931 | 55 |
1623005 | 1623005 | 2021-08-16 | Roscommon | Michigan | 26143 | 1931 | 55 |
1606149 | 1606149 | 2021-08-11 | White | Illinois | 17193 | 1931 | 36 |
1601512 | 1601512 | 2021-08-09 | Grundy | Tennessee | 47061 | 1931 | 35 |
1596107 | 1596107 | 2021-08-08 | Brantley | Georgia | 13025 | 1931 | 42 |
1592858 | 1592858 | 2021-08-07 | Brantley | Georgia | 13025 | 1931 | 42 |
1589609 | 1589609 | 2021-08-06 | Brantley | Georgia | 13025 | 1931 | 42 |
1586413 | 1586413 | 2021-08-05 | Greene | Georgia | 13133 | 1931 | 62 |
1583711 | 1583711 | 2021-08-04 | Anderson | Kentucky | 21005 | 1931 | 24 |
1576330 | 1576330 | 2021-08-02 | Clay | Arkansas | 5021 | 1931 | 52 |
1578953 | 1578953 | 2021-08-02 | Jackson | Texas | 48239 | 1931 | 31 |
1573082 | 1573082 | 2021-08-01 | Clay | Arkansas | 5021 | 1931 | 52 |
1573723 | 1573723 | 2021-08-01 | Orange | Indiana | 18117 | 1931 | 59 |
1575705 | 1575705 | 2021-08-01 | Jackson | Texas | 48239 | 1931 | 31 |
1570475 | 1570475 | 2021-07-31 | Orange | Indiana | 18117 | 1931 | 59 |
1572457 | 1572457 | 2021-07-31 | Jackson | Texas | 48239 | 1931 | 31 |
1567227 | 1567227 | 2021-07-30 | Orange | Indiana | 18117 | 1931 | 59 |
1562847 | 1562847 | 2021-07-28 | Zavala | Texas | 48507 | 1931 | 42 |
1558225 | 1558225 | 2021-07-27 | Benton | Missouri | 29015 | 1931 | 36 |
1556342 | 1556342 | 2021-07-26 | Wilbarger | Texas | 48487 | 1931 | 55 |
1553095 | 1553095 | 2021-07-25 | Wilbarger | Texas | 48487 | 1931 | 55 |
1549848 | 1549848 | 2021-07-24 | Wilbarger | Texas | 48487 | 1931 | 55 |
1546601 | 1546601 | 2021-07-23 | Wilbarger | Texas | 48487 | 1931 | 55 |
1543354 | 1543354 | 2021-07-22 | Wilbarger | Texas | 48487 | 1931 | 55 |
1540106 | 1540106 | 2021-07-21 | Wilbarger | Texas | 48487 | 1931 | 55 |
1529874 | 1529874 | 2021-07-18 | Manati | Puerto Rico | 72091 | 1931 | |
1523870 | 1523870 | 2021-07-16 | Wilbarger | Texas | 48487 | 1931 | 55 |
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);