ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
266 rows where cases = 2130 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 21
- Iowa 17
- Texas 17
- Virginia 16
- Indiana 13
- Arkansas 12
- Missouri 12
- Illinois 11
- Michigan 11
- Kentucky 10
- Nevada 10
- Mississippi 9
- Minnesota 8
- North Carolina 8
- South Dakota 8
- Alabama 7
- Puerto Rico 7
- West Virginia 7
- Wisconsin 7
- Louisiana 6
- Montana 6
- Ohio 6
- Tennessee 6
- Pennsylvania 4
- Colorado 3
- Idaho 3
- Florida 2
- Kansas 2
- Nebraska 2
- Oklahoma 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501356 | 2501356 | 2022-05-13 | Pershing | Nevada | 32027 | 2130 | 29 |
2498098 | 2498098 | 2022-05-12 | Pershing | Nevada | 32027 | 2130 | 29 |
2494840 | 2494840 | 2022-05-11 | Pershing | Nevada | 32027 | 2130 | 29 |
2491582 | 2491582 | 2022-05-10 | Pershing | Nevada | 32027 | 2130 | 29 |
2488324 | 2488324 | 2022-05-09 | Pershing | Nevada | 32027 | 2130 | 29 |
2485067 | 2485067 | 2022-05-08 | Pershing | Nevada | 32027 | 2130 | 29 |
2481809 | 2481809 | 2022-05-07 | Pershing | Nevada | 32027 | 2130 | 29 |
2478551 | 2478551 | 2022-05-06 | Pershing | Nevada | 32027 | 2130 | 29 |
2475293 | 2475293 | 2022-05-05 | Pershing | Nevada | 32027 | 2130 | 29 |
2472036 | 2472036 | 2022-05-04 | Pershing | Nevada | 32027 | 2130 | 29 |
2361191 | 2361191 | 2022-03-31 | Beaverhead | Montana | 30001 | 2130 | 29 |
2357937 | 2357937 | 2022-03-30 | Beaverhead | Montana | 30001 | 2130 | 29 |
2350208 | 2350208 | 2022-03-28 | Atkinson | Georgia | 13003 | 2130 | 47 |
2346955 | 2346955 | 2022-03-27 | Atkinson | Georgia | 13003 | 2130 | 47 |
2343702 | 2343702 | 2022-03-26 | Atkinson | Georgia | 13003 | 2130 | 47 |
2340449 | 2340449 | 2022-03-25 | Atkinson | Georgia | 13003 | 2130 | 47 |
2337196 | 2337196 | 2022-03-24 | Atkinson | Georgia | 13003 | 2130 | 47 |
2337288 | 2337288 | 2022-03-24 | Macon | Georgia | 13193 | 2130 | 49 |
2330780 | 2330780 | 2022-03-22 | Macon | Georgia | 13193 | 2130 | 49 |
2292624 | 2292624 | 2022-03-10 | Jackson | Minnesota | 27063 | 2130 | 17 |
2279792 | 2279792 | 2022-03-06 | Gentry | Missouri | 29075 | 2130 | 30 |
2281367 | 2281367 | 2022-03-06 | Doddridge | West Virginia | 54017 | 2130 | 18 |
2276539 | 2276539 | 2022-03-05 | Gentry | Missouri | 29075 | 2130 | 30 |
2278114 | 2278114 | 2022-03-05 | Doddridge | West Virginia | 54017 | 2130 | 18 |
2273286 | 2273286 | 2022-03-04 | Gentry | Missouri | 29075 | 2130 | 30 |
2274861 | 2274861 | 2022-03-04 | Doddridge | West Virginia | 54017 | 2130 | 18 |
2261519 | 2261519 | 2022-02-28 | Live Oak | Texas | 48297 | 2130 | 40 |
2258268 | 2258268 | 2022-02-27 | Live Oak | Texas | 48297 | 2130 | 40 |
2255017 | 2255017 | 2022-02-26 | Live Oak | Texas | 48297 | 2130 | 40 |
2247269 | 2247269 | 2022-02-24 | DeKalb | Missouri | 29063 | 2130 | 45 |
2240664 | 2240664 | 2022-02-22 | Claiborne | Mississippi | 28021 | 2130 | 46 |
2214941 | 2214941 | 2022-02-14 | Hamilton | Nebraska | 31081 | 2130 | 22 |
2188454 | 2188454 | 2022-02-06 | Baraga | Michigan | 26013 | 2130 | 53 |
2185201 | 2185201 | 2022-02-05 | Baraga | Michigan | 26013 | 2130 | 53 |
2181949 | 2181949 | 2022-02-04 | Baraga | Michigan | 26013 | 2130 | 53 |
2177750 | 2177750 | 2022-02-03 | San Miguel | Colorado | 8113 | 2130 | 7 |
2179842 | 2179842 | 2022-02-03 | Sabana Grande | Puerto Rico | 72121 | 2130 | |
2151190 | 2151190 | 2022-01-25 | Poquoson city | Virginia | 51735 | 2130 | 24 |
2115045 | 2115045 | 2022-01-14 | Childress | Texas | 48075 | 2130 | 24 |
2096885 | 2096885 | 2022-01-09 | Newton | Indiana | 18111 | 2130 | 60 |
2093633 | 2093633 | 2022-01-08 | Newton | Indiana | 18111 | 2130 | 60 |
2090381 | 2090381 | 2022-01-07 | Newton | Indiana | 18111 | 2130 | 60 |
2039966 | 2039966 | 2021-12-22 | Cidra | Puerto Rico | 72041 | 2130 | |
2036835 | 2036835 | 2021-12-21 | Butte | South Dakota | 46019 | 2130 | 36 |
2037324 | 2037324 | 2021-12-21 | Dickenson | Virginia | 51051 | 2130 | 32 |
2032524 | 2032524 | 2021-12-20 | Watonwan | Minnesota | 27165 | 2130 | 21 |
2003863 | 2003863 | 2021-12-11 | Barnes | North Dakota | 38003 | 2130 | 39 |
1973787 | 1973787 | 2021-12-02 | West Carroll | Louisiana | 22123 | 2130 | 52 |
1969950 | 1969950 | 2021-12-01 | Shoshone | Idaho | 16079 | 2130 | 64 |
1970676 | 1970676 | 2021-12-01 | Unknown | Michigan | 2130 | 21 | |
1859323 | 1859323 | 2021-10-28 | Jasper | Georgia | 13159 | 2130 | 58 |
1846012 | 1846012 | 2021-10-24 | Marion | Arkansas | 5089 | 2130 | 57 |
1845717 | 1845717 | 2021-10-23 | Grant | West Virginia | 54023 | 2130 | 33 |
1828654 | 1828654 | 2021-10-18 | Fulton | Pennsylvania | 42057 | 2130 | 26 |
1826256 | 1826256 | 2021-10-17 | Taylor | West Virginia | 54091 | 2130 | 37 |
1810154 | 1810154 | 2021-10-13 | Lamar | Alabama | 1075 | 2130 | 46 |
1804116 | 1804116 | 2021-10-11 | Oglethorpe | Georgia | 13221 | 2130 | 38 |
1800867 | 1800867 | 2021-10-10 | Oglethorpe | Georgia | 13221 | 2130 | 38 |
1797618 | 1797618 | 2021-10-09 | Oglethorpe | Georgia | 13221 | 2130 | 38 |
1794369 | 1794369 | 2021-10-08 | Oglethorpe | Georgia | 13221 | 2130 | 38 |
1792187 | 1792187 | 2021-10-07 | Mississippi | Missouri | 29133 | 2130 | 38 |
1785658 | 1785658 | 2021-10-05 | Gasconade | Missouri | 29073 | 2130 | 48 |
1779114 | 1779114 | 2021-10-03 | Walthall | Mississippi | 28147 | 2130 | 61 |
1775864 | 1775864 | 2021-10-02 | Walthall | Mississippi | 28147 | 2130 | 61 |
1772614 | 1772614 | 2021-10-01 | Walthall | Mississippi | 28147 | 2130 | 61 |
1769008 | 1769008 | 2021-09-30 | Caldwell | Louisiana | 22021 | 2130 | 38 |
1757239 | 1757239 | 2021-09-26 | Fajardo | Puerto Rico | 72053 | 2130 | |
1748250 | 1748250 | 2021-09-23 | Hardy | West Virginia | 54031 | 2130 | 27 |
1743866 | 1743866 | 2021-09-22 | Polk | North Carolina | 37149 | 2130 | 41 |
1739654 | 1739654 | 2021-09-21 | Butler | Kentucky | 21031 | 2130 | 29 |
1716788 | 1716788 | 2021-09-14 | Wright | Iowa | 19197 | 2130 | 41 |
1713542 | 1713542 | 2021-09-13 | Wright | Iowa | 19197 | 2130 | 41 |
1710295 | 1710295 | 2021-09-12 | Wright | Iowa | 19197 | 2130 | 41 |
1707048 | 1707048 | 2021-09-11 | Wright | Iowa | 19197 | 2130 | 41 |
1703800 | 1703800 | 2021-09-10 | Wright | Iowa | 19197 | 2130 | 41 |
1700550 | 1700550 | 2021-09-09 | Wright | Iowa | 19197 | 2130 | 41 |
1697301 | 1697301 | 2021-09-08 | Wright | Iowa | 19197 | 2130 | 41 |
1697932 | 1697932 | 2021-09-08 | Dallas | Missouri | 29059 | 2130 | 38 |
1673803 | 1673803 | 2021-09-01 | Howard | Arkansas | 5061 | 2130 | 28 |
1673242 | 1673242 | 2021-08-31 | San Jacinto | Texas | 48407 | 2130 | 42 |
1646259 | 1646259 | 2021-08-23 | Lincoln | New Mexico | 35027 | 2130 | 20 |
1643560 | 1643560 | 2021-08-22 | Manati | Puerto Rico | 72091 | 2130 | |
1625573 | 1625573 | 2021-08-17 | Hancock | Illinois | 17067 | 2130 | 42 |
1625901 | 1625901 | 2021-08-17 | Neosho | Kansas | 20133 | 2130 | 41 |
1622654 | 1622654 | 2021-08-16 | Neosho | Kansas | 20133 | 2130 | 41 |
1605201 | 1605201 | 2021-08-10 | Louisa | Virginia | 51109 | 2130 | 34 |
1601787 | 1601787 | 2021-08-09 | Shelby | Texas | 48419 | 2130 | 74 |
1591562 | 1591562 | 2021-08-06 | Corozal | Puerto Rico | 72047 | 2130 | |
1584101 | 1584101 | 2021-08-04 | Roseau | Minnesota | 27135 | 2130 | 21 |
1580067 | 1580067 | 2021-08-03 | Cass | Illinois | 17017 | 2130 | 36 |
1578906 | 1578906 | 2021-08-02 | Falls | Texas | 48145 | 2130 | 33 |
1565167 | 1565167 | 2021-07-29 | Hertford | North Carolina | 37091 | 2130 | 64 |
1559234 | 1559234 | 2021-07-27 | Oglala Lakota | South Dakota | 46102 | 2130 | 49 |
1555987 | 1555987 | 2021-07-26 | Oglala Lakota | South Dakota | 46102 | 2130 | 49 |
1552740 | 1552740 | 2021-07-25 | Oglala Lakota | South Dakota | 46102 | 2130 | 49 |
1549493 | 1549493 | 2021-07-24 | Oglala Lakota | South Dakota | 46102 | 2130 | 49 |
1546246 | 1546246 | 2021-07-23 | Oglala Lakota | South Dakota | 46102 | 2130 | 49 |
1542999 | 1542999 | 2021-07-22 | Oglala Lakota | South Dakota | 46102 | 2130 | 49 |
1538384 | 1538384 | 2021-07-21 | Jackson | Louisiana | 22049 | 2130 | 52 |
1539751 | 1539751 | 2021-07-21 | Oglala Lakota | South Dakota | 46102 | 2130 | 49 |
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);