ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
271 rows where cases = 1985 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 29
- Arkansas 25
- Texas 24
- Florida 16
- Missouri 15
- Georgia 14
- Tennessee 11
- Iowa 10
- Kentucky 9
- North Carolina 9
- Minnesota 8
- Ohio 8
- Mississippi 7
- Kansas 6
- Michigan 6
- Illinois 5
- Oregon 5
- Puerto Rico 5
- Washington 5
- Idaho 4
- Indiana 4
- Louisiana 4
- New Mexico 4
- Wisconsin 4
- Alaska 3
- Colorado 3
- Montana 3
- Oklahoma 3
- Pennsylvania 3
- Utah 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500486 | 2500486 | 2022-05-13 | Clay | Kansas | 20027 | 1985 | 35 |
2501265 | 2501265 | 2022-05-13 | Cheyenne | Nebraska | 31033 | 1985 | 24 |
2382692 | 2382692 | 2022-04-07 | Glades | Florida | 12043 | 1985 | 36 |
2379437 | 2379437 | 2022-04-06 | Glades | Florida | 12043 | 1985 | 36 |
2376183 | 2376183 | 2022-04-05 | Glades | Florida | 12043 | 1985 | 36 |
2372931 | 2372931 | 2022-04-04 | Glades | Florida | 12043 | 1985 | 36 |
2369678 | 2369678 | 2022-04-03 | Glades | Florida | 12043 | 1985 | 36 |
2366425 | 2366425 | 2022-04-02 | Glades | Florida | 12043 | 1985 | 36 |
2363172 | 2363172 | 2022-04-01 | Glades | Florida | 12043 | 1985 | 36 |
2359918 | 2359918 | 2022-03-31 | Glades | Florida | 12043 | 1985 | 36 |
2356664 | 2356664 | 2022-03-30 | Glades | Florida | 12043 | 1985 | 36 |
2357707 | 2357707 | 2022-03-30 | Pipestone | Minnesota | 27117 | 1985 | 34 |
2353411 | 2353411 | 2022-03-29 | Glades | Florida | 12043 | 1985 | 36 |
2354454 | 2354454 | 2022-03-29 | Pipestone | Minnesota | 27117 | 1985 | 34 |
2355459 | 2355459 | 2022-03-29 | Patillas | Puerto Rico | 72109 | 1985 | |
2350159 | 2350159 | 2022-03-28 | Glades | Florida | 12043 | 1985 | 36 |
2351202 | 2351202 | 2022-03-28 | Pipestone | Minnesota | 27117 | 1985 | 34 |
2352206 | 2352206 | 2022-03-28 | Patillas | Puerto Rico | 72109 | 1985 | |
2346906 | 2346906 | 2022-03-27 | Glades | Florida | 12043 | 1985 | 36 |
2348954 | 2348954 | 2022-03-27 | Patillas | Puerto Rico | 72109 | 1985 | |
2343653 | 2343653 | 2022-03-26 | Glades | Florida | 12043 | 1985 | 36 |
2340400 | 2340400 | 2022-03-25 | Glades | Florida | 12043 | 1985 | 36 |
2312614 | 2312614 | 2022-03-16 | Quay | New Mexico | 35037 | 1985 | 49 |
2309361 | 2309361 | 2022-03-15 | Quay | New Mexico | 35037 | 1985 | 49 |
2287326 | 2287326 | 2022-03-08 | Hancock | Tennessee | 47067 | 1985 | 31 |
2284074 | 2284074 | 2022-03-07 | Hancock | Tennessee | 47067 | 1985 | 31 |
2280822 | 2280822 | 2022-03-06 | Hancock | Tennessee | 47067 | 1985 | 31 |
2281204 | 2281204 | 2022-03-06 | Buena Vista city | Virginia | 51530 | 1985 | 39 |
2277569 | 2277569 | 2022-03-05 | Hancock | Tennessee | 47067 | 1985 | 31 |
2277951 | 2277951 | 2022-03-05 | Buena Vista city | Virginia | 51530 | 1985 | 39 |
2274316 | 2274316 | 2022-03-04 | Hancock | Tennessee | 47067 | 1985 | 31 |
2274698 | 2274698 | 2022-03-04 | Buena Vista city | Virginia | 51530 | 1985 | 39 |
2271063 | 2271063 | 2022-03-03 | Hancock | Tennessee | 47067 | 1985 | 31 |
2271445 | 2271445 | 2022-03-03 | Buena Vista city | Virginia | 51530 | 1985 | 39 |
2267811 | 2267811 | 2022-03-02 | Hancock | Tennessee | 47067 | 1985 | 31 |
2262084 | 2262084 | 2022-03-01 | Southeast Fairbanks Census Area | Alaska | 2240 | 1985 | 16 |
2258833 | 2258833 | 2022-02-28 | Southeast Fairbanks Census Area | Alaska | 2240 | 1985 | 16 |
2247357 | 2247357 | 2022-02-24 | Blaine | Montana | 30005 | 1985 | 30 |
2239800 | 2239800 | 2022-02-22 | Benewah | Idaho | 16009 | 1985 | 39 |
2222212 | 2222212 | 2022-02-16 | Custer | South Dakota | 46033 | 1985 | 22 |
2213652 | 2213652 | 2022-02-14 | Clinch | Georgia | 13065 | 1985 | 37 |
2201661 | 2201661 | 2022-02-10 | Humphreys | Mississippi | 28053 | 1985 | 41 |
2193884 | 2193884 | 2022-02-08 | Searcy | Arkansas | 5129 | 1985 | 39 |
2179062 | 2179062 | 2022-02-03 | Beaverhead | Montana | 30001 | 1985 | 24 |
2167275 | 2167275 | 2022-01-30 | Somervell | Texas | 48425 | 1985 | 31 |
2152457 | 2152457 | 2022-01-26 | Gallatin | Kentucky | 21077 | 1985 | 45 |
2152867 | 2152867 | 2022-01-26 | Kemper | Mississippi | 28069 | 1985 | 42 |
2147678 | 2147678 | 2022-01-24 | La Salle | Texas | 48283 | 1985 | 41 |
2128214 | 2128214 | 2022-01-18 | Runnels | Texas | 48399 | 1985 | 57 |
2112982 | 2112982 | 2022-01-14 | Washington | Idaho | 16087 | 1985 | 50 |
2112099 | 2112099 | 2022-01-13 | Floyd | Virginia | 51063 | 1985 | 33 |
2052169 | 2052169 | 2021-12-26 | Linn | Missouri | 29115 | 1985 | 58 |
2048919 | 2048919 | 2021-12-25 | Linn | Missouri | 29115 | 1985 | 58 |
2045669 | 2045669 | 2021-12-24 | Linn | Missouri | 29115 | 1985 | 58 |
2042419 | 2042419 | 2021-12-23 | Linn | Missouri | 29115 | 1985 | 58 |
2040698 | 2040698 | 2021-12-22 | Pacific | Washington | 53049 | 1985 | 38 |
2027993 | 2027993 | 2021-12-19 | Desha | Arkansas | 5041 | 1985 | 35 |
2021495 | 2021495 | 2021-12-17 | Fulton | Arkansas | 5049 | 1985 | 71 |
2011856 | 2011856 | 2021-12-14 | Archuleta | Colorado | 8007 | 1985 | 8 |
1968008 | 1968008 | 2021-11-30 | Yates | New York | 36123 | 1985 | 34 |
1928393 | 1928393 | 2021-11-18 | Missaukee | Michigan | 26113 | 1985 | 41 |
1924613 | 1924613 | 2021-11-17 | Pulaski | Indiana | 18131 | 1985 | 59 |
1925143 | 1925143 | 2021-11-17 | Missaukee | Michigan | 26113 | 1985 | 41 |
1901212 | 1901212 | 2021-11-10 | Bradley | Arkansas | 5011 | 1985 | 41 |
1904089 | 1904089 | 2021-11-10 | King William | Virginia | 51101 | 1985 | 24 |
1880340 | 1880340 | 2021-11-03 | Swain | North Carolina | 37173 | 1985 | 24 |
1877091 | 1877091 | 2021-11-02 | Swain | North Carolina | 37173 | 1985 | 24 |
1874092 | 1874092 | 2021-11-01 | Hood River | Oregon | 41027 | 1985 | 37 |
1862700 | 1862700 | 2021-10-29 | Shoshone | Idaho | 16079 | 1985 | 59 |
1861111 | 1861111 | 2021-10-28 | Tillamook | Oregon | 41057 | 1985 | 33 |
1853700 | 1853700 | 2021-10-26 | Cottonwood | Minnesota | 27033 | 1985 | 29 |
1829690 | 1829690 | 2021-10-19 | Kusilvak Census Area | Alaska | 2158 | 1985 | 8 |
1797000 | 1797000 | 2021-10-08 | Monroe | West Virginia | 54063 | 1985 | 25 |
1793723 | 1793723 | 2021-10-07 | Braxton | West Virginia | 54007 | 1985 | 15 |
1755463 | 1755463 | 2021-09-26 | Gooding | Idaho | 16047 | 1985 | 30 |
1753495 | 1753495 | 2021-09-25 | Essex | New York | 36031 | 1985 | 29 |
1743357 | 1743357 | 2021-09-22 | Perry | Mississippi | 28111 | 1985 | 53 |
1729070 | 1729070 | 2021-09-18 | Van Buren | Arkansas | 5141 | 1985 | 35 |
1726683 | 1726683 | 2021-09-17 | Green | Kentucky | 21087 | 1985 | 27 |
1699907 | 1699907 | 2021-09-09 | Chaffee | Colorado | 8015 | 1985 | 26 |
1693681 | 1693681 | 2021-09-07 | Telfair | Georgia | 13271 | 1985 | 61 |
1691467 | 1691467 | 2021-09-06 | Macon | Missouri | 29121 | 1985 | 19 |
1677950 | 1677950 | 2021-09-02 | Garrard | Kentucky | 21079 | 1985 | 37 |
1663548 | 1663548 | 2021-08-28 | Zapata | Texas | 48505 | 1985 | 38 |
1654590 | 1654590 | 2021-08-26 | Charlton | Georgia | 13049 | 1985 | 41 |
1653188 | 1653188 | 2021-08-25 | Wasco | Oregon | 41065 | 1985 | 37 |
1646962 | 1646962 | 2021-08-23 | Benton | Tennessee | 47005 | 1985 | 41 |
1631826 | 1631826 | 2021-08-19 | Bacon | Georgia | 13005 | 1985 | 42 |
1632541 | 1632541 | 2021-08-19 | Spencer | Kentucky | 21215 | 1985 | 26 |
1622372 | 1622372 | 2021-08-16 | Richland | Illinois | 17159 | 1985 | 55 |
1620045 | 1620045 | 2021-08-15 | Ste. Genevieve | Missouri | 29186 | 1985 | 17 |
1602658 | 1602658 | 2021-08-10 | Greene | Georgia | 13133 | 1985 | 64 |
1603628 | 1603628 | 2021-08-10 | Clarke | Mississippi | 28023 | 1985 | 80 |
1598602 | 1598602 | 2021-08-08 | San Juan | Utah | 49037 | 1985 | 37 |
1594834 | 1594834 | 2021-08-07 | Manati | Puerto Rico | 72091 | 1985 | |
1595353 | 1595353 | 2021-08-07 | San Juan | Utah | 49037 | 1985 | 37 |
1592104 | 1592104 | 2021-08-06 | San Juan | Utah | 49037 | 1985 | 37 |
1582483 | 1582483 | 2021-08-03 | Powhatan | Virginia | 51145 | 1985 | 17 |
1574465 | 1574465 | 2021-08-01 | Benton | Missouri | 29015 | 1985 | 36 |
1554767 | 1554767 | 2021-07-26 | Manistee | Michigan | 26101 | 1985 | 25 |
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);