ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
268 rows where cases = 1982 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 31
- Georgia 28
- Michigan 15
- Minnesota 15
- Virginia 14
- Kentucky 13
- Missouri 13
- Iowa 12
- Arkansas 11
- Alabama 8
- Indiana 8
- Tennessee 8
- Colorado 7
- Mississippi 7
- Oklahoma 7
- Wisconsin 7
- Louisiana 5
- North Carolina 5
- Puerto Rico 5
- South Carolina 5
- Illinois 4
- Nebraska 4
- Oregon 4
- Utah 4
- West Virginia 4
- California 3
- Montana 3
- New York 3
- Pennsylvania 3
- Idaho 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498007 | 2498007 | 2022-05-12 | Cheyenne | Nebraska | 31033 | 1982 | 24 |
2494749 | 2494749 | 2022-05-11 | Cheyenne | Nebraska | 31033 | 1982 | 24 |
2417876 | 2417876 | 2022-04-17 | Fairfax city | Virginia | 51600 | 1982 | 42 |
2414620 | 2414620 | 2022-04-16 | Fairfax city | Virginia | 51600 | 1982 | 42 |
2411364 | 2411364 | 2022-04-15 | Fairfax city | Virginia | 51600 | 1982 | 42 |
2402404 | 2402404 | 2022-04-13 | Taylor | Georgia | 13269 | 1982 | 53 |
2399149 | 2399149 | 2022-04-12 | Taylor | Georgia | 13269 | 1982 | 53 |
2395894 | 2395894 | 2022-04-11 | Taylor | Georgia | 13269 | 1982 | 53 |
2392638 | 2392638 | 2022-04-10 | Taylor | Georgia | 13269 | 1982 | 53 |
2389382 | 2389382 | 2022-04-09 | Taylor | Georgia | 13269 | 1982 | 53 |
2386127 | 2386127 | 2022-04-08 | Taylor | Georgia | 13269 | 1982 | 53 |
2339195 | 2339195 | 2022-03-24 | Patillas | Puerto Rico | 72109 | 1982 | |
2328430 | 2328430 | 2022-03-21 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2325177 | 2325177 | 2022-03-20 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2321923 | 2321923 | 2022-03-19 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2318669 | 2318669 | 2022-03-18 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2315416 | 2315416 | 2022-03-17 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2268193 | 2268193 | 2022-03-02 | Buena Vista city | Virginia | 51530 | 1982 | 39 |
2264940 | 2264940 | 2022-03-01 | Buena Vista city | Virginia | 51530 | 1982 | 39 |
2261690 | 2261690 | 2022-02-28 | Buena Vista city | Virginia | 51530 | 1982 | 39 |
2248104 | 2248104 | 2022-02-24 | Guayanilla | Puerto Rico | 72059 | 1982 | |
2233283 | 2233283 | 2022-02-20 | Wilcox | Georgia | 13315 | 1982 | 65 |
2230032 | 2230032 | 2022-02-19 | Wilcox | Georgia | 13315 | 1982 | 65 |
2226781 | 2226781 | 2022-02-18 | Wilcox | Georgia | 13315 | 1982 | 65 |
2218323 | 2218323 | 2022-02-15 | Sierra | New Mexico | 35051 | 1982 | 69 |
2210400 | 2210400 | 2022-02-13 | Clinch | Georgia | 13065 | 1982 | 37 |
2207147 | 2207147 | 2022-02-12 | Clinch | Georgia | 13065 | 1982 | 37 |
2203894 | 2203894 | 2022-02-11 | Clinch | Georgia | 13065 | 1982 | 37 |
2190314 | 2190314 | 2022-02-06 | Doddridge | West Virginia | 54017 | 1982 | 16 |
2175810 | 2175810 | 2022-02-02 | Beaverhead | Montana | 30001 | 1982 | 24 |
2172284 | 2172284 | 2022-02-01 | Clearwater | Minnesota | 27029 | 1982 | 29 |
2135206 | 2135206 | 2022-01-21 | Sumter | Alabama | 1119 | 1982 | 42 |
2132990 | 2132990 | 2022-01-20 | Owen | Kentucky | 21187 | 1982 | 29 |
2125027 | 2125027 | 2022-01-17 | Grand | Utah | 49019 | 1982 | 6 |
2106407 | 2106407 | 2022-01-12 | Towns | Georgia | 13281 | 1982 | 90 |
2101119 | 2101119 | 2022-01-10 | Red Willow | Nebraska | 31145 | 1982 | 17 |
2052849 | 2052849 | 2021-12-26 | Curry | Oregon | 41015 | 1982 | 40 |
2049599 | 2049599 | 2021-12-25 | Curry | Oregon | 41015 | 1982 | 40 |
2046349 | 2046349 | 2021-12-24 | Curry | Oregon | 41015 | 1982 | 40 |
2043099 | 2043099 | 2021-12-23 | Curry | Oregon | 41015 | 1982 | 40 |
2032224 | 2032224 | 2021-12-20 | Todd | Kentucky | 21219 | 1982 | 37 |
2020463 | 2020463 | 2021-12-16 | Cidra | Puerto Rico | 72041 | 1982 | |
1998784 | 1998784 | 2021-12-10 | Stone | Arkansas | 5137 | 1982 | 46 |
1992398 | 1992398 | 2021-12-08 | Prowers | Colorado | 8099 | 1982 | 39 |
1963122 | 1963122 | 2021-11-29 | Gunnison | Colorado | 8051 | 1982 | 12 |
1915167 | 1915167 | 2021-11-14 | Lyon | Kentucky | 21143 | 1982 | 26 |
1911917 | 1911917 | 2021-11-13 | Lyon | Kentucky | 21143 | 1982 | 26 |
1908668 | 1908668 | 2021-11-12 | Lyon | Kentucky | 21143 | 1982 | 26 |
1897962 | 1897962 | 2021-11-09 | Bradley | Arkansas | 5011 | 1982 | 41 |
1898645 | 1898645 | 2021-11-09 | Allamakee | Iowa | 19005 | 1982 | 54 |
1894712 | 1894712 | 2021-11-08 | Bradley | Arkansas | 5011 | 1982 | 41 |
1895395 | 1895395 | 2021-11-08 | Allamakee | Iowa | 19005 | 1982 | 54 |
1891462 | 1891462 | 2021-11-07 | Bradley | Arkansas | 5011 | 1982 | 41 |
1892145 | 1892145 | 2021-11-07 | Allamakee | Iowa | 19005 | 1982 | 54 |
1888895 | 1888895 | 2021-11-06 | Allamakee | Iowa | 19005 | 1982 | 54 |
1885645 | 1885645 | 2021-11-05 | Allamakee | Iowa | 19005 | 1982 | 54 |
1882396 | 1882396 | 2021-11-04 | Allamakee | Iowa | 19005 | 1982 | 54 |
1879147 | 1879147 | 2021-11-03 | Allamakee | Iowa | 19005 | 1982 | 54 |
1853540 | 1853540 | 2021-10-26 | West Carroll | Louisiana | 22123 | 1982 | 48 |
1833873 | 1833873 | 2021-10-20 | Breathitt | Kentucky | 21025 | 1982 | 28 |
1784791 | 1784791 | 2021-10-05 | Mercer | Illinois | 17131 | 1982 | 34 |
1782010 | 1782010 | 2021-10-04 | Claiborne | Louisiana | 22027 | 1982 | 62 |
1758400 | 1758400 | 2021-09-27 | Grand | Colorado | 8049 | 1982 | 11 |
1755957 | 1755957 | 2021-09-26 | Magoffin | Kentucky | 21153 | 1982 | 18 |
1752215 | 1752215 | 2021-09-25 | Gooding | Idaho | 16047 | 1982 | 30 |
1752709 | 1752709 | 2021-09-25 | Magoffin | Kentucky | 21153 | 1982 | 18 |
1749460 | 1749460 | 2021-09-24 | Magoffin | Kentucky | 21153 | 1982 | 18 |
1733529 | 1733529 | 2021-09-19 | Redwood | Minnesota | 27127 | 1982 | 42 |
1730279 | 1730279 | 2021-09-18 | Redwood | Minnesota | 27127 | 1982 | 42 |
1727029 | 1727029 | 2021-09-17 | Redwood | Minnesota | 27127 | 1982 | 42 |
1720532 | 1720532 | 2021-09-15 | Renville | Minnesota | 27129 | 1982 | 47 |
1721811 | 1721811 | 2021-09-15 | Comanche | Texas | 48093 | 1982 | 56 |
1713999 | 1713999 | 2021-09-13 | Houston | Minnesota | 27055 | 1982 | 16 |
1701108 | 1701108 | 2021-09-09 | Lawrence | Mississippi | 28077 | 1982 | 31 |
1701158 | 1701158 | 2021-09-09 | Bates | Missouri | 29013 | 1982 | 38 |
1693172 | 1693172 | 2021-09-07 | Cleburne | Alabama | 1029 | 1982 | 46 |
1678224 | 1678224 | 2021-09-02 | Roscommon | Michigan | 26143 | 1982 | 55 |
1674976 | 1674976 | 2021-09-01 | Roscommon | Michigan | 26143 | 1982 | 55 |
1652423 | 1652423 | 2021-08-25 | Yalobusha | Mississippi | 28161 | 1982 | 43 |
1648189 | 1648189 | 2021-08-24 | Rabun | Georgia | 13241 | 1982 | 52 |
1647661 | 1647661 | 2021-08-23 | Carbon | Wyoming | 56007 | 1982 | 29 |
1634836 | 1634836 | 2021-08-20 | Madison | Arkansas | 5087 | 1982 | 32 |
1634037 | 1634037 | 2021-08-19 | Sequatchie | Tennessee | 47153 | 1982 | 30 |
1626196 | 1626196 | 2021-08-17 | Cheboygan | Michigan | 26031 | 1982 | 49 |
1622949 | 1622949 | 2021-08-16 | Cheboygan | Michigan | 26031 | 1982 | 49 |
1624755 | 1624755 | 2021-08-16 | Clallam | Washington | 53009 | 1982 | 17 |
1605717 | 1605717 | 2021-08-11 | Elbert | Colorado | 8039 | 1982 | 15 |
1602468 | 1602468 | 2021-08-10 | Elbert | Colorado | 8039 | 1982 | 15 |
1603511 | 1603511 | 2021-08-10 | Osceola | Michigan | 26133 | 1982 | 31 |
1605172 | 1605172 | 2021-08-10 | Fluvanna | Virginia | 51065 | 1982 | 21 |
1600262 | 1600262 | 2021-08-09 | Osceola | Michigan | 26133 | 1982 | 31 |
1588855 | 1588855 | 2021-08-05 | San Juan | Utah | 49037 | 1982 | 37 |
1585605 | 1585605 | 2021-08-04 | San Juan | Utah | 49037 | 1982 | 37 |
1581038 | 1581038 | 2021-08-03 | Pike | Missouri | 29163 | 1982 | 28 |
1571217 | 1571217 | 2021-07-31 | Benton | Missouri | 29015 | 1982 | 36 |
1565664 | 1565664 | 2021-07-29 | Lee | South Carolina | 45061 | 1982 | 65 |
1559257 | 1559257 | 2021-07-27 | Cannon | Tennessee | 47015 | 1982 | 32 |
1559336 | 1559336 | 2021-07-27 | Union | Tennessee | 47173 | 1982 | 34 |
1535126 | 1535126 | 2021-07-20 | Concordia | Louisiana | 22029 | 1982 | 62 |
1532036 | 1532036 | 2021-07-19 | Manistee | Michigan | 26101 | 1982 | 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);