ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
259 rows where cases = 1999 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 21
- Virginia 20
- Arkansas 16
- Georgia 16
- West Virginia 13
- Texas 12
- Kentucky 10
- Mississippi 9
- Minnesota 8
- Missouri 8
- Oklahoma 8
- Pennsylvania 8
- Tennessee 8
- Washington 8
- Indiana 7
- Michigan 7
- Puerto Rico 7
- Nebraska 6
- Ohio 6
- Alabama 5
- California 5
- Colorado 5
- Louisiana 5
- Montana 5
- Illinois 4
- New Mexico 4
- North Carolina 4
- New York 3
- South Carolina 3
- Maine 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499526 | 2499526 | 2022-05-12 | Pepin | Wisconsin | 55091 | 1999 | 18 |
2431080 | 2431080 | 2022-04-21 | Tucker | West Virginia | 54093 | 1999 | 37 |
2427824 | 2427824 | 2022-04-20 | Tucker | West Virginia | 54093 | 1999 | 37 |
2424568 | 2424568 | 2022-04-19 | Tucker | West Virginia | 54093 | 1999 | 37 |
2421312 | 2421312 | 2022-04-18 | Tucker | West Virginia | 54093 | 1999 | 37 |
2403719 | 2403719 | 2022-04-13 | Quay | New Mexico | 35037 | 1999 | 51 |
2400464 | 2400464 | 2022-04-12 | Quay | New Mexico | 35037 | 1999 | 51 |
2387997 | 2387997 | 2022-04-08 | Patillas | Puerto Rico | 72109 | 1999 | |
2378789 | 2378789 | 2022-04-05 | Buena Vista city | Virginia | 51530 | 1999 | 43 |
2375535 | 2375535 | 2022-04-04 | Buena Vista city | Virginia | 51530 | 1999 | 43 |
2372283 | 2372283 | 2022-04-03 | Buena Vista city | Virginia | 51530 | 1999 | 43 |
2369030 | 2369030 | 2022-04-02 | Buena Vista city | Virginia | 51530 | 1999 | 43 |
2365777 | 2365777 | 2022-04-01 | Buena Vista city | Virginia | 51530 | 1999 | 43 |
2359270 | 2359270 | 2022-03-30 | Buena Vista city | Virginia | 51530 | 1999 | 43 |
2301568 | 2301568 | 2022-03-13 | Wilcox | Georgia | 13315 | 1999 | 68 |
2298316 | 2298316 | 2022-03-12 | Wilcox | Georgia | 13315 | 1999 | 68 |
2300134 | 2300134 | 2022-03-12 | Guayanilla | Puerto Rico | 72059 | 1999 | |
2295064 | 2295064 | 2022-03-11 | Wilcox | Georgia | 13315 | 1999 | 68 |
2296882 | 2296882 | 2022-03-11 | Guayanilla | Puerto Rico | 72059 | 1999 | |
2294404 | 2294404 | 2022-03-10 | Pocahontas | West Virginia | 54075 | 1999 | 27 |
2247118 | 2247118 | 2022-02-24 | Murray | Minnesota | 27101 | 1999 | 15 |
2243854 | 2243854 | 2022-02-23 | Lake | Minnesota | 27075 | 1999 | 28 |
2243867 | 2243867 | 2022-02-23 | Murray | Minnesota | 27101 | 1999 | 15 |
2214672 | 2214672 | 2022-02-14 | Humphreys | Mississippi | 28053 | 1999 | 42 |
2213117 | 2213117 | 2022-02-13 | Pleasants | West Virginia | 54073 | 1999 | 34 |
2194236 | 2194236 | 2022-02-08 | Terrell | Georgia | 13273 | 1999 | 60 |
2196822 | 2196822 | 2022-02-08 | Doddridge | West Virginia | 54017 | 1999 | 16 |
2174026 | 2174026 | 2022-02-01 | Lincoln | Washington | 53043 | 1999 | 27 |
2170774 | 2170774 | 2022-01-31 | Lincoln | Washington | 53043 | 1999 | 27 |
2145488 | 2145488 | 2022-01-24 | Clearwater | Idaho | 16035 | 1999 | 29 |
2144805 | 2144805 | 2022-01-23 | Ritchie | West Virginia | 54085 | 1999 | 26 |
2121861 | 2121861 | 2022-01-16 | Galax city | Virginia | 51640 | 1999 | 70 |
2118609 | 2118609 | 2022-01-15 | Galax city | Virginia | 51640 | 1999 | 70 |
2115357 | 2115357 | 2022-01-14 | Galax city | Virginia | 51640 | 1999 | 70 |
2103335 | 2103335 | 2022-01-11 | Benton | Indiana | 18007 | 1999 | 21 |
2077325 | 2077325 | 2022-01-03 | Brown | Indiana | 18013 | 1999 | 52 |
2077977 | 2077977 | 2022-01-03 | Koochiching | Minnesota | 27071 | 1999 | 29 |
2051935 | 2051935 | 2021-12-26 | Unknown | Michigan | 1999 | 22 | |
2041075 | 2041075 | 2021-12-23 | Mono | California | 6051 | 1999 | 4 |
2043843 | 2043843 | 2021-12-23 | Greensville | Virginia | 51081 | 1999 | 28 |
2037825 | 2037825 | 2021-12-22 | Mono | California | 6051 | 1999 | 4 |
2040594 | 2040594 | 2021-12-22 | Greensville | Virginia | 51081 | 1999 | 28 |
2030212 | 2030212 | 2021-12-19 | Catano | Puerto Rico | 72033 | 1999 | |
2023714 | 2023714 | 2021-12-17 | Cidra | Puerto Rico | 72041 | 1999 | |
2016548 | 2016548 | 2021-12-15 | Colfax | Nebraska | 31037 | 1999 | 23 |
2011826 | 2011826 | 2021-12-14 | Plumas | California | 6063 | 1999 | 12 |
2010612 | 2010612 | 2021-12-13 | Morrow | Oregon | 41049 | 1999 | 25 |
1985262 | 1985262 | 2021-12-05 | Addison | Vermont | 50001 | 1999 | 10 |
1940211 | 1940211 | 2021-11-22 | Bradley | Arkansas | 5011 | 1999 | 41 |
1932377 | 1932377 | 2021-11-19 | McLean | North Dakota | 38055 | 1999 | 43 |
1929085 | 1929085 | 2021-11-18 | Swain | North Carolina | 37173 | 1999 | 28 |
1876438 | 1876438 | 2021-11-02 | Chippewa | Minnesota | 27023 | 1999 | 40 |
1831839 | 1831839 | 2021-10-19 | Baker | Oregon | 41001 | 1999 | 28 |
1826512 | 1826512 | 2021-10-18 | Little River | Arkansas | 5081 | 1999 | 72 |
1823263 | 1823263 | 2021-10-17 | Little River | Arkansas | 5081 | 1999 | 71 |
1824224 | 1824224 | 2021-10-17 | Trigg | Kentucky | 21221 | 1999 | 21 |
1820975 | 1820975 | 2021-10-16 | Trigg | Kentucky | 21221 | 1999 | 21 |
1817726 | 1817726 | 2021-10-15 | Trigg | Kentucky | 21221 | 1999 | 21 |
1806749 | 1806749 | 2021-10-11 | Monroe | West Virginia | 54063 | 1999 | 25 |
1802944 | 1802944 | 2021-10-10 | Lake | Tennessee | 47095 | 1999 | 31 |
1799695 | 1799695 | 2021-10-09 | Lake | Tennessee | 47095 | 1999 | 31 |
1796446 | 1796446 | 2021-10-08 | Lake | Tennessee | 47095 | 1999 | 31 |
1779743 | 1779743 | 2021-10-03 | Monroe | Ohio | 39111 | 1999 | 50 |
1764897 | 1764897 | 2021-09-29 | Grand | Colorado | 8049 | 1999 | 10 |
1762196 | 1762196 | 2021-09-28 | Clayton | Iowa | 19043 | 1999 | 58 |
1758948 | 1758948 | 2021-09-27 | Clayton | Iowa | 19043 | 1999 | 58 |
1755700 | 1755700 | 2021-09-26 | Clayton | Iowa | 19043 | 1999 | 58 |
1756352 | 1756352 | 2021-09-26 | Perry | Mississippi | 28111 | 1999 | 53 |
1752452 | 1752452 | 2021-09-25 | Clayton | Iowa | 19043 | 1999 | 58 |
1753104 | 1753104 | 2021-09-25 | Perry | Mississippi | 28111 | 1999 | 53 |
1749203 | 1749203 | 2021-09-24 | Clayton | Iowa | 19043 | 1999 | 58 |
1749856 | 1749856 | 2021-09-24 | Perry | Mississippi | 28111 | 1999 | 53 |
1745953 | 1745953 | 2021-09-23 | Clayton | Iowa | 19043 | 1999 | 58 |
1742704 | 1742704 | 2021-09-22 | Clayton | Iowa | 19043 | 1999 | 58 |
1742904 | 1742904 | 2021-09-22 | Caldwell | Kentucky | 21033 | 1999 | 44 |
1732287 | 1732287 | 2021-09-19 | Lee | Arkansas | 5077 | 1999 | 41 |
1721066 | 1721066 | 2021-09-15 | Chowan | North Carolina | 37041 | 1999 | 38 |
1712892 | 1712892 | 2021-09-13 | Alamosa | Colorado | 8003 | 1999 | 41 |
1700351 | 1700351 | 2021-09-09 | Washington | Illinois | 17189 | 1999 | 33 |
1694273 | 1694273 | 2021-09-07 | Washington | Kentucky | 21229 | 1999 | 42 |
1680201 | 1680201 | 2021-09-03 | Macon | Alabama | 1087 | 1999 | 54 |
1679384 | 1679384 | 2021-09-02 | Clay | South Dakota | 46027 | 1999 | 15 |
1673183 | 1673183 | 2021-08-31 | Leon | Texas | 48289 | 1999 | 48 |
1670227 | 1670227 | 2021-08-30 | Asotin | Washington | 53003 | 1999 | 32 |
1664322 | 1664322 | 2021-08-29 | Bleckley | Georgia | 13023 | 1999 | 52 |
1661074 | 1661074 | 2021-08-28 | Bleckley | Georgia | 13023 | 1999 | 52 |
1657826 | 1657826 | 2021-08-27 | Bleckley | Georgia | 13023 | 1999 | 52 |
1654949 | 1654949 | 2021-08-26 | Rush | Indiana | 18139 | 1999 | 27 |
1641336 | 1641336 | 2021-08-22 | Madison | Arkansas | 5087 | 1999 | 32 |
1641575 | 1641575 | 2021-08-22 | Bacon | Georgia | 13005 | 1999 | 43 |
1638325 | 1638325 | 2021-08-21 | Bacon | Georgia | 13005 | 1999 | 43 |
1635075 | 1635075 | 2021-08-20 | Bacon | Georgia | 13005 | 1999 | 43 |
1632741 | 1632741 | 2021-08-19 | Osceola | Michigan | 26133 | 1999 | 31 |
1629494 | 1629494 | 2021-08-18 | Osceola | Michigan | 26133 | 1999 | 31 |
1626908 | 1626908 | 2021-08-17 | Northampton | North Carolina | 37131 | 1999 | 61 |
1621958 | 1621958 | 2021-08-16 | Elbert | Colorado | 8039 | 1999 | 15 |
1617865 | 1617865 | 2021-08-14 | Colorado | Texas | 48089 | 1999 | 34 |
1610045 | 1610045 | 2021-08-12 | Dodge | Minnesota | 27039 | 1999 | 3 |
1603007 | 1603007 | 2021-08-10 | Buchanan | Iowa | 19019 | 1999 | 34 |
1599758 | 1599758 | 2021-08-09 | Buchanan | Iowa | 19019 | 1999 | 34 |
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);