ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
301 rows where cases = 1651 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 33
- Georgia 24
- Illinois 24
- Arkansas 16
- Missouri 14
- Texas 14
- Michigan 13
- Louisiana 12
- Tennessee 12
- Mississippi 11
- Montana 10
- North Carolina 10
- Puerto Rico 10
- Alabama 8
- Florida 8
- Utah 8
- Kentucky 7
- Indiana 6
- Virginia 6
- West Virginia 6
- Colorado 5
- Oklahoma 5
- Idaho 4
- Iowa 4
- Minnesota 4
- Connecticut 3
- North Dakota 3
- Ohio 3
- Pennsylvania 3
- Maine 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474448 | 2474448 | 2022-05-05 | Harper | Kansas | 20077 | 1651 | 27 |
2471191 | 2471191 | 2022-05-04 | Harper | Kansas | 20077 | 1651 | 27 |
2467935 | 2467935 | 2022-05-03 | Harper | Kansas | 20077 | 1651 | 27 |
2464680 | 2464680 | 2022-05-02 | Harper | Kansas | 20077 | 1651 | 27 |
2461424 | 2461424 | 2022-05-01 | Harper | Kansas | 20077 | 1651 | 27 |
2458168 | 2458168 | 2022-04-30 | Harper | Kansas | 20077 | 1651 | 27 |
2454912 | 2454912 | 2022-04-29 | Harper | Kansas | 20077 | 1651 | 27 |
2451656 | 2451656 | 2022-04-28 | Harper | Kansas | 20077 | 1651 | 27 |
2448400 | 2448400 | 2022-04-27 | Harper | Kansas | 20077 | 1651 | 27 |
2445144 | 2445144 | 2022-04-26 | Harper | Kansas | 20077 | 1651 | 27 |
2441888 | 2441888 | 2022-04-25 | Harper | Kansas | 20077 | 1651 | 27 |
2438632 | 2438632 | 2022-04-24 | Harper | Kansas | 20077 | 1651 | 27 |
2435376 | 2435376 | 2022-04-23 | Harper | Kansas | 20077 | 1651 | 27 |
2432120 | 2432120 | 2022-04-22 | Harper | Kansas | 20077 | 1651 | 27 |
2428864 | 2428864 | 2022-04-21 | Harper | Kansas | 20077 | 1651 | 27 |
2425608 | 2425608 | 2022-04-20 | Harper | Kansas | 20077 | 1651 | 27 |
2422352 | 2422352 | 2022-04-19 | Harper | Kansas | 20077 | 1651 | 27 |
2419096 | 2419096 | 2022-04-18 | Harper | Kansas | 20077 | 1651 | 27 |
2415840 | 2415840 | 2022-04-17 | Harper | Kansas | 20077 | 1651 | 27 |
2412584 | 2412584 | 2022-04-16 | Harper | Kansas | 20077 | 1651 | 27 |
2409328 | 2409328 | 2022-04-15 | Harper | Kansas | 20077 | 1651 | 27 |
2240748 | 2240748 | 2022-02-22 | Caldwell | Missouri | 29025 | 1651 | 32 |
2216288 | 2216288 | 2022-02-14 | Williamsburg city | Virginia | 51830 | 1651 | 13 |
2187389 | 2187389 | 2022-02-06 | Woodruff | Arkansas | 5147 | 1651 | 24 |
2184136 | 2184136 | 2022-02-05 | Woodruff | Arkansas | 5147 | 1651 | 24 |
2180884 | 2180884 | 2022-02-04 | Woodruff | Arkansas | 5147 | 1651 | 24 |
2173764 | 2173764 | 2022-02-01 | Refugio | Texas | 48391 | 1651 | 31 |
2167850 | 2167850 | 2022-01-31 | Newton | Arkansas | 5101 | 1651 | 45 |
2157357 | 2157357 | 2022-01-27 | Delta | Texas | 48119 | 1651 | 22 |
2150506 | 2150506 | 2022-01-25 | Arroyo | Puerto Rico | 72015 | 1651 | |
2137156 | 2137156 | 2022-01-21 | Benson | North Dakota | 38005 | 1651 | 22 |
2129109 | 2129109 | 2022-01-19 | Irwin | Georgia | 13155 | 1651 | 42 |
2126332 | 2126332 | 2022-01-18 | Kingman | Kansas | 20095 | 1651 | 24 |
2123080 | 2123080 | 2022-01-17 | Kingman | Kansas | 20095 | 1651 | 24 |
2119828 | 2119828 | 2022-01-16 | Kingman | Kansas | 20095 | 1651 | 24 |
2116576 | 2116576 | 2022-01-15 | Kingman | Kansas | 20095 | 1651 | 24 |
2113325 | 2113325 | 2022-01-14 | Kingman | Kansas | 20095 | 1651 | 24 |
2111073 | 2111073 | 2022-01-13 | Graham | North Carolina | 37075 | 1651 | 28 |
2111894 | 2111894 | 2022-01-13 | La Salle | Texas | 48283 | 1651 | 41 |
2108357 | 2108357 | 2022-01-12 | Custer | South Dakota | 46033 | 1651 | 21 |
2105446 | 2105446 | 2022-01-11 | Red River | Texas | 48387 | 1651 | 58 |
2087989 | 2087989 | 2022-01-06 | Carbon | Montana | 30009 | 1651 | 23 |
2061731 | 2061731 | 2021-12-29 | Marshall | Minnesota | 27089 | 1651 | 23 |
2061902 | 2061902 | 2021-12-29 | Howard | Missouri | 29089 | 1651 | 19 |
2051577 | 2051577 | 2021-12-26 | Norton | Kansas | 20137 | 1651 | 35 |
2052997 | 2052997 | 2021-12-26 | Naguabo | Puerto Rico | 72103 | 1651 | |
2048327 | 2048327 | 2021-12-25 | Norton | Kansas | 20137 | 1651 | 35 |
2045077 | 2045077 | 2021-12-24 | Norton | Kansas | 20137 | 1651 | 35 |
2041828 | 2041828 | 2021-12-23 | Norton | Kansas | 20137 | 1651 | 35 |
2038578 | 2038578 | 2021-12-22 | Norton | Kansas | 20137 | 1651 | 35 |
1990166 | 1990166 | 2021-12-07 | Presque Isle | Michigan | 26141 | 1651 | 48 |
1986916 | 1986916 | 2021-12-06 | Presque Isle | Michigan | 26141 | 1651 | 48 |
1984351 | 1984351 | 2021-12-05 | Washington | North Carolina | 37187 | 1651 | 37 |
1981101 | 1981101 | 2021-12-04 | Washington | North Carolina | 37187 | 1651 | 37 |
1981955 | 1981955 | 2021-12-04 | Trinity | Texas | 48455 | 1651 | 62 |
1977851 | 1977851 | 2021-12-03 | Washington | North Carolina | 37187 | 1651 | 37 |
1958759 | 1958759 | 2021-11-27 | Yabucoa | Puerto Rico | 72151 | 1651 | |
1955508 | 1955508 | 2021-11-26 | Yabucoa | Puerto Rico | 72151 | 1651 | |
1951473 | 1951473 | 2021-11-25 | Deer Lodge | Montana | 30023 | 1651 | 27 |
1948222 | 1948222 | 2021-11-24 | Deer Lodge | Montana | 30023 | 1651 | 27 |
1948932 | 1948932 | 2021-11-24 | Aguas Buenas | Puerto Rico | 72007 | 1651 | |
1943637 | 1943637 | 2021-11-23 | Park | Colorado | 8093 | 1651 | 11 |
1944295 | 1944295 | 2021-11-23 | Linn | Kansas | 20107 | 1651 | 21 |
1941045 | 1941045 | 2021-11-22 | Linn | Kansas | 20107 | 1651 | 21 |
1936512 | 1936512 | 2021-11-20 | Orange | Vermont | 50017 | 1651 | 6 |
1925454 | 1925454 | 2021-11-17 | Wayne | Missouri | 29223 | 1651 | 18 |
1921311 | 1921311 | 2021-11-16 | Crawford | Indiana | 18025 | 1651 | 30 |
1914669 | 1914669 | 2021-11-14 | Clearwater | Idaho | 16035 | 1651 | 26 |
1911419 | 1911419 | 2021-11-13 | Clearwater | Idaho | 16035 | 1651 | 26 |
1906253 | 1906253 | 2021-11-11 | Alleghany | North Carolina | 37005 | 1651 | 6 |
1903004 | 1903004 | 2021-11-10 | Alleghany | North Carolina | 37005 | 1651 | 6 |
1883488 | 1883488 | 2021-11-04 | Schuyler | New York | 36097 | 1651 | 17 |
1879108 | 1879108 | 2021-11-03 | Newton | Indiana | 18111 | 1651 | 53 |
1865946 | 1865946 | 2021-10-30 | Owyhee | Idaho | 16073 | 1651 | 39 |
1856041 | 1856041 | 2021-10-27 | Dooly | Georgia | 13093 | 1651 | 59 |
1838252 | 1838252 | 2021-10-21 | Vinton | Ohio | 39163 | 1651 | 25 |
1811960 | 1811960 | 2021-10-13 | Socorro | New Mexico | 35053 | 1651 | 62 |
1801791 | 1801791 | 2021-10-10 | Carroll | Mississippi | 28015 | 1651 | 38 |
1798542 | 1798542 | 2021-10-09 | Carroll | Mississippi | 28015 | 1651 | 38 |
1795293 | 1795293 | 2021-10-08 | Carroll | Mississippi | 28015 | 1651 | 38 |
1790686 | 1790686 | 2021-10-07 | Wilcox | Alabama | 1131 | 1651 | 37 |
1791816 | 1791816 | 2021-10-07 | Lincoln | Maine | 23015 | 1651 | 4 |
1790265 | 1790265 | 2021-10-06 | Morgan | Utah | 49029 | 1651 | 11 |
1761551 | 1761551 | 2021-09-28 | Scott | Arkansas | 5127 | 1651 | 25 |
1761910 | 1761910 | 2021-09-28 | Turner | Georgia | 13287 | 1651 | 48 |
1751288 | 1751288 | 2021-09-24 | Unknown | Utah | 1651 | 32 | |
1746758 | 1746758 | 2021-09-23 | Custer | Montana | 30017 | 1651 | 21 |
1739835 | 1739835 | 2021-09-21 | Sagadahoc | Maine | 23023 | 1651 | 12 |
1712917 | 1712917 | 2021-09-13 | Gunnison | Colorado | 8051 | 1651 | 8 |
1712508 | 1712508 | 2021-09-12 | Grant | West Virginia | 54023 | 1651 | 30 |
1706048 | 1706048 | 2021-09-10 | Taylor | West Virginia | 54091 | 1651 | 27 |
1699697 | 1699697 | 2021-09-09 | Lowndes | Alabama | 1085 | 1651 | 55 |
1660823 | 1660823 | 2021-08-28 | Little River | Arkansas | 5081 | 1651 | 44 |
1651060 | 1651060 | 2021-08-25 | Desha | Arkansas | 5041 | 1651 | 24 |
1649097 | 1649097 | 2021-08-24 | Amite | Mississippi | 28005 | 1651 | 47 |
1626426 | 1626426 | 2021-08-17 | Walthall | Mississippi | 28147 | 1651 | 52 |
1624576 | 1624576 | 2021-08-16 | Duchesne | Utah | 49013 | 1651 | 9 |
1619076 | 1619076 | 2021-08-15 | Greene | Illinois | 17061 | 1651 | 48 |
1619579 | 1619579 | 2021-08-15 | Claiborne | Louisiana | 22027 | 1651 | 56 |
1621329 | 1621329 | 2021-08-15 | Duchesne | Utah | 49013 | 1651 | 9 |
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);