ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
273 rows where cases = 2077 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 26
- Virginia 19
- Kentucky 16
- Indiana 15
- Iowa 14
- Minnesota 13
- Missouri 13
- Georgia 12
- Mississippi 12
- Illinois 10
- Puerto Rico 10
- South Carolina 9
- West Virginia 9
- Tennessee 8
- Arkansas 7
- Idaho 7
- North Carolina 7
- Colorado 6
- Kansas 6
- Louisiana 6
- Vermont 5
- Wisconsin 5
- Alabama 4
- Florida 3
- New Hampshire 3
- Ohio 3
- Oklahoma 3
- Oregon 3
- California 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500417 | 2500417 | 2022-05-13 | Howard | Iowa | 19089 | 2077 | 35 |
2501195 | 2501195 | 2022-05-13 | Blaine | Montana | 30005 | 2077 | 32 |
2502719 | 2502719 | 2022-05-13 | Pleasants | West Virginia | 54073 | 2077 | 36 |
2502720 | 2502720 | 2022-05-13 | Pocahontas | West Virginia | 54075 | 2077 | 32 |
2497159 | 2497159 | 2022-05-12 | Howard | Iowa | 19089 | 2077 | 35 |
2499461 | 2499461 | 2022-05-12 | Pleasants | West Virginia | 54073 | 2077 | 36 |
2499462 | 2499462 | 2022-05-12 | Pocahontas | West Virginia | 54075 | 2077 | 32 |
2493901 | 2493901 | 2022-05-11 | Howard | Iowa | 19089 | 2077 | 35 |
2433854 | 2433854 | 2022-04-22 | Clay | Texas | 48077 | 2077 | 35 |
2423810 | 2423810 | 2022-04-19 | Patillas | Puerto Rico | 72109 | 2077 | |
2400994 | 2400994 | 2022-04-12 | Guayanilla | Puerto Rico | 72059 | 2077 | |
2397739 | 2397739 | 2022-04-11 | Guayanilla | Puerto Rico | 72059 | 2077 | |
2392608 | 2392608 | 2022-04-10 | Montgomery | Georgia | 13209 | 2077 | 53 |
2394484 | 2394484 | 2022-04-10 | Guayanilla | Puerto Rico | 72059 | 2077 | |
2389352 | 2389352 | 2022-04-09 | Montgomery | Georgia | 13209 | 2077 | 53 |
2386097 | 2386097 | 2022-04-08 | Montgomery | Georgia | 13209 | 2077 | 53 |
2352238 | 2352238 | 2022-03-28 | Allendale | South Carolina | 45005 | 2077 | 24 |
2348986 | 2348986 | 2022-03-27 | Allendale | South Carolina | 45005 | 2077 | 24 |
2345733 | 2345733 | 2022-03-26 | Allendale | South Carolina | 45005 | 2077 | 24 |
2342480 | 2342480 | 2022-03-25 | Allendale | South Carolina | 45005 | 2077 | 24 |
2339227 | 2339227 | 2022-03-24 | Allendale | South Carolina | 45005 | 2077 | 24 |
2335973 | 2335973 | 2022-03-23 | Allendale | South Carolina | 45005 | 2077 | 24 |
2331086 | 2331086 | 2022-03-22 | Warren | Indiana | 18171 | 2077 | 30 |
2332719 | 2332719 | 2022-03-22 | Allendale | South Carolina | 45005 | 2077 | 24 |
2327834 | 2327834 | 2022-03-21 | Warren | Indiana | 18171 | 2077 | 30 |
2324359 | 2324359 | 2022-03-20 | Boundary | Idaho | 16021 | 2077 | 58 |
2324581 | 2324581 | 2022-03-20 | Warren | Indiana | 18171 | 2077 | 30 |
2321105 | 2321105 | 2022-03-19 | Boundary | Idaho | 16021 | 2077 | 58 |
2321327 | 2321327 | 2022-03-19 | Warren | Indiana | 18171 | 2077 | 30 |
2317851 | 2317851 | 2022-03-18 | Boundary | Idaho | 16021 | 2077 | 58 |
2318073 | 2318073 | 2022-03-18 | Warren | Indiana | 18171 | 2077 | 30 |
2314820 | 2314820 | 2022-03-17 | Warren | Indiana | 18171 | 2077 | 29 |
2245294 | 2245294 | 2022-02-23 | Ochiltree | Texas | 48357 | 2077 | 46 |
2228940 | 2228940 | 2022-02-18 | Franklin | Texas | 48159 | 2077 | 39 |
2198494 | 2198494 | 2022-02-09 | DeKalb | Missouri | 29063 | 2077 | 42 |
2200115 | 2200115 | 2022-02-09 | Tyler | West Virginia | 54095 | 2077 | 27 |
2194873 | 2194873 | 2022-02-08 | Red River | Louisiana | 22081 | 2077 | 50 |
2191816 | 2191816 | 2022-02-07 | Jackson | Minnesota | 27063 | 2077 | 16 |
2183474 | 2183474 | 2022-02-04 | Live Oak | Texas | 48297 | 2077 | 40 |
2179781 | 2179781 | 2022-02-03 | Adjuntas | Puerto Rico | 72001 | 2077 | |
2168153 | 2168153 | 2022-01-31 | Heard | Georgia | 13149 | 2077 | 44 |
2152017 | 2152017 | 2022-01-26 | Valley | Idaho | 16085 | 2077 | 14 |
2128360 | 2128360 | 2022-01-18 | Floyd | Virginia | 51063 | 2077 | 33 |
2102330 | 2102330 | 2022-01-10 | Clarke | Virginia | 51043 | 2077 | 33 |
2097682 | 2097682 | 2022-01-09 | Linn | Missouri | 29115 | 2077 | 58 |
2077374 | 2077374 | 2022-01-03 | Newton | Indiana | 18111 | 2077 | 58 |
2063822 | 2063822 | 2021-12-30 | Mono | California | 6051 | 2077 | 4 |
2065518 | 2065518 | 2021-12-30 | Alleghany | North Carolina | 37005 | 2077 | 7 |
2058628 | 2058628 | 2021-12-28 | Cedar | Missouri | 29039 | 2077 | 42 |
2038748 | 2038748 | 2021-12-22 | Claiborne | Louisiana | 22027 | 2077 | 66 |
2030918 | 2030918 | 2021-12-19 | Westmoreland | Virginia | 51193 | 2077 | 39 |
2027667 | 2027667 | 2021-12-18 | Westmoreland | Virginia | 51193 | 2077 | 39 |
2024416 | 2024416 | 2021-12-17 | Westmoreland | Virginia | 51193 | 2077 | 39 |
1993596 | 1993596 | 2021-12-08 | Webster | Mississippi | 28155 | 2077 | 48 |
1989938 | 1989938 | 2021-12-07 | Metcalfe | Kentucky | 21169 | 2077 | 48 |
1971360 | 1971360 | 2021-12-01 | Barnes | North Dakota | 38003 | 2077 | 39 |
1961950 | 1961950 | 2021-11-28 | Cayey | Puerto Rico | 72035 | 2077 | |
1929336 | 1929336 | 2021-11-18 | Hood River | Oregon | 41027 | 2077 | 37 |
1904632 | 1904632 | 2021-11-11 | Moffat | Colorado | 8081 | 2077 | 45 |
1905443 | 1905443 | 2021-11-11 | Pendleton | Kentucky | 21191 | 2077 | 20 |
1902193 | 1902193 | 2021-11-10 | Pendleton | Kentucky | 21191 | 2077 | 20 |
1870072 | 1870072 | 2021-10-31 | Perry | Mississippi | 28111 | 2077 | 56 |
1866823 | 1866823 | 2021-10-30 | Perry | Mississippi | 28111 | 2077 | 56 |
1863574 | 1863574 | 2021-10-29 | Perry | Mississippi | 28111 | 2077 | 56 |
1813009 | 1813009 | 2021-10-13 | Millard | Utah | 49027 | 2077 | 24 |
1809559 | 1809559 | 2021-10-12 | Eastland | Texas | 48133 | 2077 | 76 |
1806325 | 1806325 | 2021-10-11 | Gaines | Texas | 48165 | 2077 | 57 |
1803075 | 1803075 | 2021-10-10 | Gaines | Texas | 48165 | 2077 | 57 |
1803576 | 1803576 | 2021-10-10 | Rusk | Wisconsin | 55107 | 2077 | 31 |
1799826 | 1799826 | 2021-10-09 | Gaines | Texas | 48165 | 2077 | 57 |
1800327 | 1800327 | 2021-10-09 | Rusk | Wisconsin | 55107 | 2077 | 31 |
1796577 | 1796577 | 2021-10-08 | Gaines | Texas | 48165 | 2077 | 56 |
1797078 | 1797078 | 2021-10-08 | Rusk | Wisconsin | 55107 | 2077 | 31 |
1793328 | 1793328 | 2021-10-07 | Gaines | Texas | 48165 | 2077 | 55 |
1790079 | 1790079 | 2021-10-06 | Gaines | Texas | 48165 | 2077 | 55 |
1786733 | 1786733 | 2021-10-05 | Stewart | Tennessee | 47161 | 2077 | 33 |
1786831 | 1786831 | 2021-10-05 | Gaines | Texas | 48165 | 2077 | 55 |
1780544 | 1780544 | 2021-10-03 | Orleans | Vermont | 50019 | 2077 | 13 |
1780601 | 1780601 | 2021-10-03 | Giles | Virginia | 51071 | 2077 | 25 |
1777351 | 1777351 | 2021-10-02 | Giles | Virginia | 51071 | 2077 | 25 |
1774101 | 1774101 | 2021-10-01 | Giles | Virginia | 51071 | 2077 | 25 |
1770297 | 1770297 | 2021-09-30 | Bamberg | South Carolina | 45009 | 2077 | 62 |
1767298 | 1767298 | 2021-09-29 | Comanche | Texas | 48093 | 2077 | 58 |
1755128 | 1755128 | 2021-09-26 | Alamosa | Colorado | 8003 | 2077 | 42 |
1751880 | 1751880 | 2021-09-25 | Alamosa | Colorado | 8003 | 2077 | 42 |
1748631 | 1748631 | 2021-09-24 | Alamosa | Colorado | 8003 | 2077 | 42 |
1746710 | 1746710 | 2021-09-23 | Osage | Missouri | 29151 | 2077 | 22 |
1741112 | 1741112 | 2021-09-21 | Clay | South Dakota | 46027 | 2077 | 15 |
1694024 | 1694024 | 2021-09-07 | O'Brien | Iowa | 19141 | 2077 | 61 |
1690775 | 1690775 | 2021-09-06 | O'Brien | Iowa | 19141 | 2077 | 61 |
1687525 | 1687525 | 2021-09-05 | O'Brien | Iowa | 19141 | 2077 | 61 |
1684275 | 1684275 | 2021-09-04 | O'Brien | Iowa | 19141 | 2077 | 61 |
1681024 | 1681024 | 2021-09-03 | O'Brien | Iowa | 19141 | 2077 | 61 |
1677776 | 1677776 | 2021-09-02 | O'Brien | Iowa | 19141 | 2077 | 61 |
1674529 | 1674529 | 2021-09-01 | O'Brien | Iowa | 19141 | 2077 | 61 |
1676558 | 1676558 | 2021-09-01 | San Juan | Utah | 49037 | 2077 | 39 |
1664821 | 1664821 | 2021-08-29 | Bourbon | Kansas | 20011 | 2077 | 33 |
1661573 | 1661573 | 2021-08-28 | Bourbon | Kansas | 20011 | 2077 | 33 |
1658325 | 1658325 | 2021-08-27 | Bourbon | Kansas | 20011 | 2077 | 33 |
1655701 | 1655701 | 2021-08-26 | Dallas | Missouri | 29059 | 2077 | 38 |
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);