ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
286 rows where cases = 2000 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 25
- Missouri 18
- Virginia 17
- Puerto Rico 13
- Arkansas 12
- New Mexico 12
- Georgia 11
- Kentucky 11
- Minnesota 10
- Florida 9
- Indiana 9
- Louisiana 9
- North Carolina 9
- Texas 9
- Oklahoma 8
- Ohio 7
- Tennessee 7
- Alabama 6
- Alaska 6
- Illinois 6
- Michigan 6
- West Virginia 6
- Colorado 5
- Kansas 5
- Nebraska 5
- Wisconsin 5
- Idaho 4
- Mississippi 4
- North Dakota 4
- Pennsylvania 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448852 | 2448852 | 2022-04-27 | Pipestone | Minnesota | 27117 | 2000 | 34 |
2419998 | 2419998 | 2022-04-18 | Quay | New Mexico | 35037 | 2000 | 51 |
2416743 | 2416743 | 2022-04-17 | Quay | New Mexico | 35037 | 2000 | 51 |
2413487 | 2413487 | 2022-04-16 | Quay | New Mexico | 35037 | 2000 | 51 |
2410231 | 2410231 | 2022-04-15 | Quay | New Mexico | 35037 | 2000 | 51 |
2406975 | 2406975 | 2022-04-14 | Quay | New Mexico | 35037 | 2000 | 51 |
2398321 | 2398321 | 2022-04-11 | Buena Vista city | Virginia | 51530 | 2000 | 43 |
2395066 | 2395066 | 2022-04-10 | Buena Vista city | Virginia | 51530 | 2000 | 43 |
2391810 | 2391810 | 2022-04-09 | Buena Vista city | Virginia | 51530 | 2000 | 43 |
2388554 | 2388554 | 2022-04-08 | Buena Vista city | Virginia | 51530 | 2000 | 43 |
2385299 | 2385299 | 2022-04-07 | Buena Vista city | Virginia | 51530 | 2000 | 43 |
2382044 | 2382044 | 2022-04-06 | Buena Vista city | Virginia | 51530 | 2000 | 43 |
2353157 | 2353157 | 2022-03-29 | Southeast Fairbanks Census Area | Alaska | 2240 | 2000 | 19 |
2349905 | 2349905 | 2022-03-28 | Southeast Fairbanks Census Area | Alaska | 2240 | 2000 | 19 |
2352763 | 2352763 | 2022-03-28 | Buena Vista city | Virginia | 51530 | 2000 | 42 |
2346652 | 2346652 | 2022-03-27 | Southeast Fairbanks Census Area | Alaska | 2240 | 2000 | 19 |
2343399 | 2343399 | 2022-03-26 | Southeast Fairbanks Census Area | Alaska | 2240 | 2000 | 19 |
2340146 | 2340146 | 2022-03-25 | Southeast Fairbanks Census Area | Alaska | 2240 | 2000 | 19 |
2309890 | 2309890 | 2022-03-15 | Guayanilla | Puerto Rico | 72059 | 2000 | |
2304820 | 2304820 | 2022-03-14 | Wilcox | Georgia | 13315 | 2000 | 68 |
2306637 | 2306637 | 2022-03-14 | Guayanilla | Puerto Rico | 72059 | 2000 | |
2303386 | 2303386 | 2022-03-13 | Guayanilla | Puerto Rico | 72059 | 2000 | |
2304160 | 2304160 | 2022-03-13 | Pocahontas | West Virginia | 54075 | 2000 | 27 |
2300908 | 2300908 | 2022-03-12 | Pocahontas | West Virginia | 54075 | 2000 | 27 |
2297656 | 2297656 | 2022-03-11 | Pocahontas | West Virginia | 54075 | 2000 | 27 |
2241080 | 2241080 | 2022-02-22 | Sierra | New Mexico | 35051 | 2000 | 69 |
2237829 | 2237829 | 2022-02-21 | Sierra | New Mexico | 35051 | 2000 | 69 |
2226802 | 2226802 | 2022-02-18 | Boundary | Idaho | 16021 | 2000 | 56 |
2201934 | 2201934 | 2022-02-10 | Holt | Nebraska | 31089 | 2000 | 18 |
2197016 | 2197016 | 2022-02-09 | Perry | Alabama | 1105 | 2000 | 41 |
2197247 | 2197247 | 2022-02-09 | Lincoln | Colorado | 8073 | 2000 | 9 |
2183364 | 2183364 | 2022-02-04 | Clay | Texas | 48077 | 2000 | 27 |
2174587 | 2174587 | 2022-02-02 | Atkinson | Georgia | 13003 | 2000 | 39 |
2153810 | 2153810 | 2022-01-26 | Rincon | Puerto Rico | 72117 | 2000 | |
2143172 | 2143172 | 2022-01-23 | Carroll | Missouri | 29033 | 2000 | 41 |
2135726 | 2135726 | 2022-01-21 | Fremont | Idaho | 16043 | 2000 | 21 |
2128944 | 2128944 | 2022-01-19 | San Miguel | Colorado | 8113 | 2000 | 7 |
2129242 | 2129242 | 2022-01-19 | Valley | Idaho | 16085 | 2000 | 13 |
2123705 | 2123705 | 2022-01-17 | Montgomery | Missouri | 29139 | 2000 | 35 |
2124947 | 2124947 | 2022-01-17 | Parmer | Texas | 48369 | 2000 | 45 |
2120453 | 2120453 | 2022-01-16 | Montgomery | Missouri | 29139 | 2000 | 35 |
2117201 | 2117201 | 2022-01-15 | Montgomery | Missouri | 29139 | 2000 | 35 |
2102835 | 2102835 | 2022-01-11 | Mariposa | California | 6043 | 2000 | 18 |
2085152 | 2085152 | 2022-01-05 | Mercer | North Dakota | 38057 | 2000 | 22 |
2074918 | 2074918 | 2022-01-02 | Lewis | Missouri | 29111 | 2000 | 30 |
2071667 | 2071667 | 2022-01-01 | Lewis | Missouri | 29111 | 2000 | 30 |
2068416 | 2068416 | 2021-12-31 | Lewis | Missouri | 29111 | 2000 | 30 |
2065165 | 2065165 | 2021-12-30 | Lewis | Missouri | 29111 | 2000 | 30 |
2063015 | 2063015 | 2021-12-29 | Callahan | Texas | 48059 | 2000 | 59 |
2044247 | 2044247 | 2021-12-24 | Fulton | Arkansas | 5049 | 2000 | 76 |
2034498 | 2034498 | 2021-12-21 | Fulton | Arkansas | 5049 | 2000 | 76 |
2035178 | 2035178 | 2021-12-21 | Chickasaw | Iowa | 19037 | 2000 | 23 |
2031928 | 2031928 | 2021-12-20 | Chickasaw | Iowa | 19037 | 2000 | 23 |
2028677 | 2028677 | 2021-12-19 | Chickasaw | Iowa | 19037 | 2000 | 23 |
2025426 | 2025426 | 2021-12-18 | Chickasaw | Iowa | 19037 | 2000 | 23 |
2021539 | 2021539 | 2021-12-17 | Stone | Arkansas | 5137 | 2000 | 46 |
2022175 | 2022175 | 2021-12-17 | Chickasaw | Iowa | 19037 | 2000 | 23 |
2018924 | 2018924 | 2021-12-16 | Chickasaw | Iowa | 19037 | 2000 | 23 |
2015674 | 2015674 | 2021-12-15 | Chickasaw | Iowa | 19037 | 2000 | 23 |
2013863 | 2013863 | 2021-12-14 | Morrow | Oregon | 41049 | 2000 | 25 |
2008652 | 2008652 | 2021-12-13 | Prowers | Colorado | 8099 | 2000 | 41 |
1993341 | 1993341 | 2021-12-08 | Nantucket | Massachusetts | 25019 | 2000 | 0 |
1972874 | 1972874 | 2021-12-02 | Gunnison | Colorado | 8051 | 2000 | 12 |
1974013 | 1974013 | 2021-12-02 | Watonwan | Minnesota | 27165 | 2000 | 21 |
1971737 | 1971737 | 2021-12-01 | Morovis | Puerto Rico | 72101 | 2000 | |
1968487 | 1968487 | 2021-11-30 | Morovis | Puerto Rico | 72101 | 2000 | |
1965236 | 1965236 | 2021-11-29 | Morovis | Puerto Rico | 72101 | 2000 | |
1960673 | 1960673 | 2021-11-28 | Lyon | Kentucky | 21143 | 2000 | 26 |
1961984 | 1961984 | 2021-11-28 | Morovis | Puerto Rico | 72101 | 2000 | |
1957422 | 1957422 | 2021-11-27 | Lyon | Kentucky | 21143 | 2000 | 26 |
1958733 | 1958733 | 2021-11-27 | Morovis | Puerto Rico | 72101 | 2000 | |
1954171 | 1954171 | 2021-11-26 | Lyon | Kentucky | 21143 | 2000 | 26 |
1950920 | 1950920 | 2021-11-25 | Lyon | Kentucky | 21143 | 2000 | 26 |
1947669 | 1947669 | 2021-11-24 | Lyon | Kentucky | 21143 | 2000 | 26 |
1937464 | 1937464 | 2021-11-21 | Cumberland | Illinois | 17035 | 2000 | 39 |
1938940 | 1938940 | 2021-11-21 | Harrison | Ohio | 39067 | 2000 | 50 |
1934214 | 1934214 | 2021-11-20 | Cumberland | Illinois | 17035 | 2000 | 39 |
1930963 | 1930963 | 2021-11-19 | Cumberland | Illinois | 17035 | 2000 | 39 |
1932351 | 1932351 | 2021-11-19 | Barnes | North Dakota | 38003 | 2000 | 38 |
1932380 | 1932380 | 2021-11-19 | Mountrail | North Dakota | 38061 | 2000 | 29 |
1929565 | 1929565 | 2021-11-18 | Butte | South Dakota | 46019 | 2000 | 33 |
1900758 | 1900758 | 2021-11-09 | Caledonia | Vermont | 50005 | 2000 | 20 |
1879532 | 1879532 | 2021-11-03 | West Carroll | Louisiana | 22123 | 2000 | 50 |
1880106 | 1880106 | 2021-11-03 | Unknown | Nebraska | 2000 | 158 | |
1875808 | 1875808 | 2021-11-02 | Blackford | Indiana | 18009 | 2000 | 45 |
1872559 | 1872559 | 2021-11-01 | Blackford | Indiana | 18009 | 2000 | 45 |
1858684 | 1858684 | 2021-10-27 | Klickitat | Washington | 53039 | 2000 | 18 |
1853217 | 1853217 | 2021-10-26 | Mills | Iowa | 19129 | 2000 | 29 |
1849968 | 1849968 | 2021-10-25 | Mills | Iowa | 19129 | 2000 | 29 |
1846718 | 1846718 | 2021-10-24 | Mills | Iowa | 19129 | 2000 | 29 |
1848876 | 1848876 | 2021-10-24 | Patrick | Virginia | 51141 | 2000 | 55 |
1843468 | 1843468 | 2021-10-23 | Mills | Iowa | 19129 | 2000 | 29 |
1845626 | 1845626 | 2021-10-23 | Patrick | Virginia | 51141 | 2000 | 55 |
1840218 | 1840218 | 2021-10-22 | Mills | Iowa | 19129 | 2000 | 29 |
1842376 | 1842376 | 2021-10-22 | Patrick | Virginia | 51141 | 2000 | 55 |
1836969 | 1836969 | 2021-10-21 | Mills | Iowa | 19129 | 2000 | 29 |
1833720 | 1833720 | 2021-10-20 | Mills | Iowa | 19129 | 2000 | 29 |
1833994 | 1833994 | 2021-10-20 | Claiborne | Louisiana | 22027 | 2000 | 63 |
1830745 | 1830745 | 2021-10-19 | Claiborne | Louisiana | 22027 | 2000 | 63 |
1827496 | 1827496 | 2021-10-18 | Claiborne | Louisiana | 22027 | 2000 | 63 |
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);