ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
240 rows where cases = 2343 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 20
- Texas 17
- Virginia 16
- West Virginia 16
- Georgia 12
- Mississippi 10
- Oklahoma 10
- Iowa 9
- Minnesota 9
- Arkansas 7
- Louisiana 7
- Montana 7
- North Carolina 7
- South Dakota 7
- Alabama 6
- Michigan 6
- Tennessee 6
- Indiana 5
- Maryland 5
- Puerto Rico 5
- Illinois 4
- Missouri 4
- New York 4
- Ohio 4
- Wisconsin 4
- Wyoming 4
- Colorado 3
- Idaho 3
- Nebraska 3
- Pennsylvania 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487940 | 2487940 | 2022-05-09 | Rock | Minnesota | 27133 | 2343 | 34 |
2484682 | 2484682 | 2022-05-08 | Rock | Minnesota | 27133 | 2343 | 34 |
2486401 | 2486401 | 2022-05-08 | Clay | West Virginia | 54015 | 2343 | 41 |
2481424 | 2481424 | 2022-05-07 | Rock | Minnesota | 27133 | 2343 | 34 |
2483143 | 2483143 | 2022-05-07 | Clay | West Virginia | 54015 | 2343 | 41 |
2478166 | 2478166 | 2022-05-06 | Rock | Minnesota | 27133 | 2343 | 34 |
2479885 | 2479885 | 2022-05-06 | Clay | West Virginia | 54015 | 2343 | 41 |
2476627 | 2476627 | 2022-05-05 | Clay | West Virginia | 54015 | 2343 | 41 |
2473369 | 2473369 | 2022-05-04 | Clay | West Virginia | 54015 | 2343 | 41 |
2470112 | 2470112 | 2022-05-03 | Clay | West Virginia | 54015 | 2343 | 41 |
2466856 | 2466856 | 2022-05-02 | Clay | West Virginia | 54015 | 2343 | 41 |
2463601 | 2463601 | 2022-05-01 | Clay | West Virginia | 54015 | 2343 | 41 |
2460345 | 2460345 | 2022-04-30 | Clay | West Virginia | 54015 | 2343 | 41 |
2457089 | 2457089 | 2022-04-29 | Clay | West Virginia | 54015 | 2343 | 41 |
2453833 | 2453833 | 2022-04-28 | Clay | West Virginia | 54015 | 2343 | 41 |
2450577 | 2450577 | 2022-04-27 | Clay | West Virginia | 54015 | 2343 | 41 |
2447321 | 2447321 | 2022-04-26 | Clay | West Virginia | 54015 | 2343 | 41 |
2444065 | 2444065 | 2022-04-25 | Clay | West Virginia | 54015 | 2343 | 41 |
2439438 | 2439438 | 2022-04-24 | Phelps | Nebraska | 31137 | 2343 | 14 |
2436182 | 2436182 | 2022-04-23 | Phelps | Nebraska | 31137 | 2343 | 14 |
2432926 | 2432926 | 2022-04-22 | Phelps | Nebraska | 31137 | 2343 | 14 |
2395123 | 2395123 | 2022-04-10 | Madison | Virginia | 51113 | 2343 | 39 |
2391867 | 2391867 | 2022-04-09 | Madison | Virginia | 51113 | 2343 | 39 |
2388611 | 2388611 | 2022-04-08 | Madison | Virginia | 51113 | 2343 | 39 |
2385356 | 2385356 | 2022-04-07 | Madison | Virginia | 51113 | 2343 | 39 |
2333109 | 2333109 | 2022-03-22 | Parmer | Texas | 48369 | 2343 | 52 |
2281507 | 2281507 | 2022-03-06 | Washakie | Wyoming | 56043 | 2343 | 43 |
2278254 | 2278254 | 2022-03-05 | Washakie | Wyoming | 56043 | 2343 | 43 |
2275001 | 2275001 | 2022-03-04 | Washakie | Wyoming | 56043 | 2343 | 43 |
2210584 | 2210584 | 2022-02-13 | Brown | Illinois | 17009 | 2343 | 20 |
2207331 | 2207331 | 2022-02-12 | Brown | Illinois | 17009 | 2343 | 20 |
2203531 | 2203531 | 2022-02-11 | Sumter | Alabama | 1119 | 2343 | 44 |
2204078 | 2204078 | 2022-02-11 | Brown | Illinois | 17009 | 2343 | 20 |
2200825 | 2200825 | 2022-02-10 | Brown | Illinois | 17009 | 2343 | 20 |
2177246 | 2177246 | 2022-02-02 | Sussex | Virginia | 51183 | 2343 | 32 |
2172081 | 2172081 | 2022-02-01 | East Carroll | Louisiana | 22035 | 2343 | 35 |
2150369 | 2150369 | 2022-01-25 | Noble | Oklahoma | 40103 | 2343 | 33 |
2147117 | 2147117 | 2022-01-24 | Noble | Oklahoma | 40103 | 2343 | 33 |
2143863 | 2143863 | 2022-01-23 | Noble | Oklahoma | 40103 | 2343 | 33 |
2139958 | 2139958 | 2022-01-22 | Lewis | Missouri | 29111 | 2343 | 31 |
2140608 | 2140608 | 2022-01-22 | Noble | Oklahoma | 40103 | 2343 | 33 |
2137352 | 2137352 | 2022-01-21 | Noble | Oklahoma | 40103 | 2343 | 33 |
2132074 | 2132074 | 2022-01-20 | Stone | Arkansas | 5137 | 2343 | 51 |
2134098 | 2134098 | 2022-01-20 | Noble | Oklahoma | 40103 | 2343 | 33 |
2130846 | 2130846 | 2022-01-19 | Noble | Oklahoma | 40103 | 2343 | 33 |
2124170 | 2124170 | 2022-01-17 | McLean | North Dakota | 38055 | 2343 | 47 |
2108352 | 2108352 | 2022-01-12 | Charles Mix | South Dakota | 46023 | 2343 | 32 |
2064024 | 2064024 | 2021-12-30 | Charlton | Georgia | 13049 | 2343 | 58 |
2058450 | 2058450 | 2021-12-28 | Chippewa | Minnesota | 27023 | 2343 | 43 |
2059700 | 2059700 | 2021-12-28 | Meigs | Tennessee | 47121 | 2343 | 46 |
2056941 | 2056941 | 2021-12-27 | Klickitat | Washington | 53039 | 2343 | 34 |
2035200 | 2035200 | 2021-12-21 | Hancock | Iowa | 19081 | 2343 | 41 |
2031950 | 2031950 | 2021-12-20 | Hancock | Iowa | 19081 | 2343 | 41 |
2028699 | 2028699 | 2021-12-19 | Hancock | Iowa | 19081 | 2343 | 41 |
2025448 | 2025448 | 2021-12-18 | Hancock | Iowa | 19081 | 2343 | 41 |
2022197 | 2022197 | 2021-12-17 | Hancock | Iowa | 19081 | 2343 | 41 |
2018946 | 2018946 | 2021-12-16 | Hancock | Iowa | 19081 | 2343 | 41 |
2015696 | 2015696 | 2021-12-15 | Hancock | Iowa | 19081 | 2343 | 41 |
2016342 | 2016342 | 2021-12-15 | Tallahatchie | Mississippi | 28135 | 2343 | 53 |
2009685 | 2009685 | 2021-12-13 | Aitkin | Minnesota | 27001 | 2343 | 53 |
2006173 | 2006173 | 2021-12-12 | Leslie | Kentucky | 21131 | 2343 | 33 |
2002922 | 2002922 | 2021-12-11 | Leslie | Kentucky | 21131 | 2343 | 33 |
1999672 | 1999672 | 2021-12-10 | Leslie | Kentucky | 21131 | 2343 | 33 |
1992373 | 1992373 | 2021-12-08 | Grand | Colorado | 8049 | 2343 | 17 |
1995083 | 1995083 | 2021-12-08 | Grayson | Virginia | 51077 | 2343 | 53 |
1989034 | 1989034 | 2021-12-07 | Van Buren | Arkansas | 5141 | 2343 | 44 |
1992084 | 1992084 | 2021-12-07 | Converse | Wyoming | 56009 | 2343 | 45 |
1984828 | 1984828 | 2021-12-05 | Clay | South Dakota | 46027 | 2343 | 17 |
1981578 | 1981578 | 2021-12-04 | Clay | South Dakota | 46027 | 2343 | 17 |
1978328 | 1978328 | 2021-12-03 | Clay | South Dakota | 46027 | 2343 | 17 |
1969083 | 1969083 | 2021-11-30 | Greene | Virginia | 51079 | 2343 | 45 |
1929904 | 1929904 | 2021-11-18 | Pecos | Texas | 48371 | 2343 | 52 |
1900140 | 1900140 | 2021-11-09 | Fulton | Pennsylvania | 42057 | 2343 | 32 |
1884757 | 1884757 | 2021-11-04 | Burnett | Wisconsin | 55013 | 2343 | 32 |
1875299 | 1875299 | 2021-11-02 | Inyo | California | 6027 | 2343 | 41 |
1869618 | 1869618 | 2021-10-31 | Butler | Kentucky | 21031 | 2343 | 36 |
1866369 | 1866369 | 2021-10-30 | Butler | Kentucky | 21031 | 2343 | 36 |
1863120 | 1863120 | 2021-10-29 | Butler | Kentucky | 21031 | 2343 | 36 |
1835237 | 1835237 | 2021-10-20 | Manati | Puerto Rico | 72091 | 2343 | |
1811719 | 1811719 | 2021-10-13 | Ste. Genevieve | Missouri | 29186 | 2343 | 29 |
1783798 | 1783798 | 2021-10-04 | Windsor | Vermont | 50027 | 2343 | 25 |
1726218 | 1726218 | 2021-09-17 | Gem | Idaho | 16045 | 2343 | 49 |
1718277 | 1718277 | 2021-09-14 | Naranjito | Puerto Rico | 72105 | 2343 | |
1713991 | 1713991 | 2021-09-13 | Dodge | Minnesota | 27039 | 2343 | 3 |
1712176 | 1712176 | 2021-09-12 | Madison | Texas | 48313 | 2343 | 38 |
1708929 | 1708929 | 2021-09-11 | Madison | Texas | 48313 | 2343 | 37 |
1703928 | 1703928 | 2021-09-10 | Casey | Kentucky | 21045 | 2343 | 48 |
1686723 | 1686723 | 2021-09-05 | Washington | Alabama | 1129 | 2343 | 43 |
1678820 | 1678820 | 2021-09-02 | Avery | North Carolina | 37011 | 2343 | 22 |
1672939 | 1672939 | 2021-08-31 | Union | South Dakota | 46127 | 2343 | 43 |
1661895 | 1661895 | 2021-08-28 | Talbot | Maryland | 24041 | 2343 | 48 |
1650805 | 1650805 | 2021-08-24 | Mason | West Virginia | 54053 | 2343 | 40 |
1642819 | 1642819 | 2021-08-22 | Lake | Montana | 30047 | 2343 | 41 |
1639569 | 1639569 | 2021-08-21 | Lake | Montana | 30047 | 2343 | 41 |
1636319 | 1636319 | 2021-08-20 | Lake | Montana | 30047 | 2343 | 41 |
1608837 | 1608837 | 2021-08-12 | Grant | Arkansas | 5053 | 2343 | 39 |
1605878 | 1605878 | 2021-08-11 | Cook | Georgia | 13075 | 2343 | 44 |
1584617 | 1584617 | 2021-08-04 | Ashe | North Carolina | 37009 | 2343 | 45 |
1574049 | 1574049 | 2021-08-01 | Morgan | Kentucky | 21175 | 2343 | 5 |
1569884 | 1569884 | 2021-07-31 | Randolph | Arkansas | 5121 | 2343 | 48 |
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);