ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
408 rows where cases = 1259 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 24
- Kansas 23
- Texas 23
- Mississippi 22
- Illinois 21
- Iowa 20
- Missouri 18
- Arkansas 16
- Georgia 16
- Oklahoma 15
- Virginia 15
- Colorado 11
- Florida 10
- Minnesota 10
- Oregon 10
- Tennessee 10
- West Virginia 10
- Louisiana 9
- Michigan 9
- Montana 8
- South Dakota 8
- Utah 8
- Idaho 7
- Kentucky 7
- Nebraska 7
- Ohio 7
- Alabama 6
- Connecticut 6
- Indiana 5
- North Carolina 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498060 | 2498060 | 2022-05-12 | Pierce | Nebraska | 31139 | 1259 | 21 |
2494802 | 2494802 | 2022-05-11 | Pierce | Nebraska | 31139 | 1259 | 21 |
2474099 | 2474099 | 2022-05-05 | Lemhi | Idaho | 16059 | 1259 | 25 |
2470842 | 2470842 | 2022-05-04 | Lemhi | Idaho | 16059 | 1259 | 25 |
2462755 | 2462755 | 2022-05-01 | Wallowa | Oregon | 41063 | 1259 | 16 |
2459499 | 2459499 | 2022-04-30 | Wallowa | Oregon | 41063 | 1259 | 16 |
2456243 | 2456243 | 2022-04-29 | Wallowa | Oregon | 41063 | 1259 | 16 |
2452987 | 2452987 | 2022-04-28 | Wallowa | Oregon | 41063 | 1259 | 16 |
2449731 | 2449731 | 2022-04-27 | Wallowa | Oregon | 41063 | 1259 | 16 |
2446474 | 2446474 | 2022-04-26 | Wallowa | Oregon | 41063 | 1259 | 16 |
2443219 | 2443219 | 2022-04-25 | Wallowa | Oregon | 41063 | 1259 | 16 |
2425358 | 2425358 | 2022-04-20 | Scott | Illinois | 17171 | 1259 | 11 |
2422102 | 2422102 | 2022-04-19 | Scott | Illinois | 17171 | 1259 | 11 |
2319997 | 2319997 | 2022-03-18 | Garza | Texas | 48169 | 1259 | 27 |
2292884 | 2292884 | 2022-03-10 | Broadwater | Montana | 30007 | 1259 | 18 |
2244153 | 2244153 | 2022-02-23 | Teton | Montana | 30099 | 1259 | 20 |
2228912 | 2228912 | 2022-02-18 | Crane | Texas | 48103 | 1259 | 23 |
2225661 | 2225661 | 2022-02-17 | Crane | Texas | 48103 | 1259 | 23 |
2218162 | 2218162 | 2022-02-15 | Burt | Nebraska | 31021 | 1259 | 15 |
2218963 | 2218963 | 2022-02-15 | Day | South Dakota | 46037 | 1259 | 33 |
2210072 | 2210072 | 2022-02-13 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1259 | 8 |
2210960 | 2210960 | 2022-02-13 | Scott | Kansas | 20171 | 1259 | 33 |
2206819 | 2206819 | 2022-02-12 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1259 | 8 |
2207707 | 2207707 | 2022-02-12 | Scott | Kansas | 20171 | 1259 | 33 |
2203566 | 2203566 | 2022-02-11 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1259 | 8 |
2204454 | 2204454 | 2022-02-11 | Scott | Kansas | 20171 | 1259 | 33 |
2201201 | 2201201 | 2022-02-10 | Scott | Kansas | 20171 | 1259 | 33 |
2197947 | 2197947 | 2022-02-09 | Scott | Kansas | 20171 | 1259 | 33 |
2167529 | 2167529 | 2022-01-30 | Skamania | Washington | 53059 | 1259 | 10 |
2164274 | 2164274 | 2022-01-29 | Skamania | Washington | 53059 | 1259 | 10 |
2161019 | 2161019 | 2022-01-28 | Skamania | Washington | 53059 | 1259 | 10 |
2150388 | 2150388 | 2022-01-25 | Tillman | Oklahoma | 40141 | 1259 | 29 |
2150517 | 2150517 | 2022-01-25 | Ceiba | Puerto Rico | 72037 | 1259 | |
2147136 | 2147136 | 2022-01-24 | Tillman | Oklahoma | 40141 | 1259 | 29 |
2147265 | 2147265 | 2022-01-24 | Ceiba | Puerto Rico | 72037 | 1259 | |
2147438 | 2147438 | 2022-01-24 | Tripp | South Dakota | 46123 | 1259 | 21 |
2142616 | 2142616 | 2022-01-23 | Mitchell | Kansas | 20123 | 1259 | 18 |
2143882 | 2143882 | 2022-01-23 | Tillman | Oklahoma | 40141 | 1259 | 29 |
2139361 | 2139361 | 2022-01-22 | Mitchell | Kansas | 20123 | 1259 | 18 |
2140627 | 2140627 | 2022-01-22 | Tillman | Oklahoma | 40141 | 1259 | 29 |
2136105 | 2136105 | 2022-01-21 | Mitchell | Kansas | 20123 | 1259 | 18 |
2137371 | 2137371 | 2022-01-21 | Tillman | Oklahoma | 40141 | 1259 | 29 |
2132405 | 2132405 | 2022-01-20 | Randolph | Georgia | 13243 | 1259 | 45 |
2133588 | 2133588 | 2022-01-20 | Dawes | Nebraska | 31045 | 1259 | 21 |
2134117 | 2134117 | 2022-01-20 | Tillman | Oklahoma | 40141 | 1259 | 29 |
2130865 | 2130865 | 2022-01-19 | Tillman | Oklahoma | 40141 | 1259 | 29 |
2127122 | 2127122 | 2022-01-18 | Nemaha | Nebraska | 31127 | 1259 | 18 |
2123731 | 2123731 | 2022-01-17 | Shannon | Missouri | 29203 | 1259 | 30 |
2120479 | 2120479 | 2022-01-16 | Shannon | Missouri | 29203 | 1259 | 30 |
2117227 | 2117227 | 2022-01-15 | Shannon | Missouri | 29203 | 1259 | 30 |
2117228 | 2117228 | 2022-01-15 | Shelby | Missouri | 29205 | 1259 | 13 |
2092401 | 2092401 | 2022-01-07 | Marion | Texas | 48315 | 1259 | 55 |
2081360 | 2081360 | 2022-01-04 | Wilkinson | Mississippi | 28157 | 1259 | 39 |
2073988 | 2073988 | 2022-01-02 | Edwards | Illinois | 17047 | 1259 | 22 |
2070737 | 2070737 | 2022-01-01 | Edwards | Illinois | 17047 | 1259 | 22 |
2067486 | 2067486 | 2021-12-31 | Edwards | Illinois | 17047 | 1259 | 22 |
2064235 | 2064235 | 2021-12-30 | Edwards | Illinois | 17047 | 1259 | 22 |
2056216 | 2056216 | 2021-12-27 | Comerio | Puerto Rico | 72045 | 1259 | |
2051297 | 2051297 | 2021-12-26 | Schuyler | Illinois | 17169 | 1259 | 26 |
2048047 | 2048047 | 2021-12-25 | Schuyler | Illinois | 17169 | 1259 | 26 |
2044797 | 2044797 | 2021-12-24 | Schuyler | Illinois | 17169 | 1259 | 26 |
2041548 | 2041548 | 2021-12-23 | Schuyler | Illinois | 17169 | 1259 | 26 |
2026999 | 2026999 | 2021-12-18 | Orocovis | Puerto Rico | 72107 | 1259 | |
2019627 | 2019627 | 2021-12-16 | Chariton | Missouri | 29041 | 1259 | 31 |
2010088 | 2010088 | 2021-12-13 | Merrick | Nebraska | 31121 | 1259 | 15 |
1989377 | 1989377 | 2021-12-07 | Terrell | Georgia | 13273 | 1259 | 58 |
1943647 | 1943647 | 2021-11-23 | San Miguel | Colorado | 8113 | 1259 | 5 |
1940397 | 1940397 | 2021-11-22 | San Miguel | Colorado | 8113 | 1259 | 5 |
1938209 | 1938209 | 2021-11-21 | Lake | Minnesota | 27075 | 1259 | 24 |
1934959 | 1934959 | 2021-11-20 | Lake | Minnesota | 27075 | 1259 | 24 |
1931709 | 1931709 | 2021-11-19 | Lake | Minnesota | 27075 | 1259 | 24 |
1906723 | 1906723 | 2021-11-11 | Luquillo | Puerto Rico | 72089 | 1259 | |
1907581 | 1907581 | 2021-11-11 | Johnson | Wyoming | 56019 | 1259 | 16 |
1904332 | 1904332 | 2021-11-10 | Johnson | Wyoming | 56019 | 1259 | 16 |
1888270 | 1888270 | 2021-11-06 | Searcy | Arkansas | 5129 | 1259 | 24 |
1890135 | 1890135 | 2021-11-06 | Pembina | North Dakota | 38067 | 1259 | 13 |
1882710 | 1882710 | 2021-11-04 | Trimble | Kentucky | 21223 | 1259 | 17 |
1879946 | 1879946 | 2021-11-03 | St. Clair | Missouri | 29185 | 1259 | 14 |
1881454 | 1881454 | 2021-11-03 | Clay | West Virginia | 54015 | 1259 | 20 |
1876009 | 1876009 | 2021-11-02 | Clay | Kansas | 20027 | 1259 | 31 |
1876697 | 1876697 | 2021-11-02 | St. Clair | Missouri | 29185 | 1259 | 14 |
1872760 | 1872760 | 2021-11-01 | Clay | Kansas | 20027 | 1259 | 31 |
1874479 | 1874479 | 2021-11-01 | Archer | Texas | 48009 | 1259 | 22 |
1871230 | 1871230 | 2021-10-31 | Archer | Texas | 48009 | 1259 | 22 |
1867981 | 1867981 | 2021-10-30 | Archer | Texas | 48009 | 1259 | 22 |
1853998 | 1853998 | 2021-10-26 | Madison | Montana | 30057 | 1259 | 11 |
1830860 | 1830860 | 2021-10-19 | Baraga | Michigan | 26013 | 1259 | 46 |
1826884 | 1826884 | 2021-10-18 | Taylor | Georgia | 13269 | 1259 | 37 |
1827528 | 1827528 | 2021-10-18 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1827611 | 1827611 | 2021-10-18 | Baraga | Michigan | 26013 | 1259 | 46 |
1824279 | 1824279 | 2021-10-17 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1821030 | 1821030 | 2021-10-16 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1817781 | 1817781 | 2021-10-15 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1814533 | 1814533 | 2021-10-14 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1810640 | 1810640 | 2021-10-13 | Taylor | Georgia | 13269 | 1259 | 36 |
1811284 | 1811284 | 2021-10-13 | St. Helena | Louisiana | 22091 | 1259 | 18 |
1793099 | 1793099 | 2021-10-07 | Custer | South Dakota | 46033 | 1259 | 15 |
1789859 | 1789859 | 2021-10-06 | Grant | South Dakota | 46051 | 1259 | 43 |
1790381 | 1790381 | 2021-10-06 | Nelson | Virginia | 51125 | 1259 | 16 |
1787126 | 1787126 | 2021-10-05 | Manassas Park city | Virginia | 51685 | 1259 | 12 |
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);