ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
309 rows where cases = 1690 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 70
- Georgia 20
- Arkansas 18
- Missouri 16
- Kentucky 11
- Louisiana 11
- Illinois 10
- Iowa 10
- Nebraska 10
- Virginia 10
- Puerto Rico 9
- Mississippi 8
- Wisconsin 8
- Alabama 7
- Indiana 7
- Kansas 7
- Michigan 7
- Minnesota 7
- North Carolina 6
- South Dakota 6
- Tennessee 6
- Maine 5
- South Carolina 5
- West Virginia 5
- Idaho 4
- Ohio 4
- Maryland 3
- Pennsylvania 3
- Florida 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502361 | 2502361 | 2022-05-13 | Marion | Texas | 48315 | 1690 | 60 |
2499103 | 2499103 | 2022-05-12 | Marion | Texas | 48315 | 1690 | 60 |
2495845 | 2495845 | 2022-05-11 | Marion | Texas | 48315 | 1690 | 60 |
2492587 | 2492587 | 2022-05-10 | Marion | Texas | 48315 | 1690 | 60 |
2489329 | 2489329 | 2022-05-09 | Marion | Texas | 48315 | 1690 | 60 |
2486072 | 2486072 | 2022-05-08 | Marion | Texas | 48315 | 1690 | 60 |
2482814 | 2482814 | 2022-05-07 | Marion | Texas | 48315 | 1690 | 60 |
2479556 | 2479556 | 2022-05-06 | Marion | Texas | 48315 | 1690 | 60 |
2476298 | 2476298 | 2022-05-05 | Marion | Texas | 48315 | 1690 | 60 |
2473041 | 2473041 | 2022-05-04 | Marion | Texas | 48315 | 1690 | 60 |
2469785 | 2469785 | 2022-05-03 | Marion | Texas | 48315 | 1690 | 60 |
2466529 | 2466529 | 2022-05-02 | Marion | Texas | 48315 | 1690 | 59 |
2462215 | 2462215 | 2022-05-01 | Knox | Nebraska | 31107 | 1690 | 13 |
2463274 | 2463274 | 2022-05-01 | Marion | Texas | 48315 | 1690 | 59 |
2458959 | 2458959 | 2022-04-30 | Knox | Nebraska | 31107 | 1690 | 13 |
2460018 | 2460018 | 2022-04-30 | Marion | Texas | 48315 | 1690 | 59 |
2455703 | 2455703 | 2022-04-29 | Knox | Nebraska | 31107 | 1690 | 13 |
2456762 | 2456762 | 2022-04-29 | Marion | Texas | 48315 | 1690 | 59 |
2452447 | 2452447 | 2022-04-28 | Knox | Nebraska | 31107 | 1690 | 13 |
2453506 | 2453506 | 2022-04-28 | Marion | Texas | 48315 | 1690 | 59 |
2449191 | 2449191 | 2022-04-27 | Knox | Nebraska | 31107 | 1690 | 13 |
2354579 | 2354579 | 2022-03-29 | Caldwell | Missouri | 29025 | 1690 | 38 |
2351326 | 2351326 | 2022-03-28 | Caldwell | Missouri | 29025 | 1690 | 37 |
2279833 | 2279833 | 2022-03-06 | Ozark | Missouri | 29153 | 1690 | 55 |
2276580 | 2276580 | 2022-03-05 | Ozark | Missouri | 29153 | 1690 | 55 |
2273327 | 2273327 | 2022-03-04 | Ozark | Missouri | 29153 | 1690 | 55 |
2270075 | 2270075 | 2022-03-03 | Ozark | Missouri | 29153 | 1690 | 55 |
2263915 | 2263915 | 2022-03-01 | Camden | North Carolina | 37029 | 1690 | 9 |
2258550 | 2258550 | 2022-02-27 | Williamsburg city | Virginia | 51830 | 1690 | 18 |
2255299 | 2255299 | 2022-02-26 | Williamsburg city | Virginia | 51830 | 1690 | 18 |
2252048 | 2252048 | 2022-02-25 | Williamsburg city | Virginia | 51830 | 1690 | 18 |
2213360 | 2213360 | 2022-02-14 | Dallas | Arkansas | 5039 | 1690 | 24 |
2213908 | 2213908 | 2022-02-14 | Pulaski | Illinois | 17153 | 1690 | 16 |
2210468 | 2210468 | 2022-02-13 | Miller | Georgia | 13201 | 1690 | 27 |
2207215 | 2207215 | 2022-02-12 | Miller | Georgia | 13201 | 1690 | 27 |
2203962 | 2203962 | 2022-02-11 | Miller | Georgia | 13201 | 1690 | 27 |
2148444 | 2148444 | 2022-01-25 | Lake | Colorado | 8065 | 1690 | 2 |
2132924 | 2132924 | 2022-01-20 | Crittenden | Kentucky | 21055 | 1690 | 39 |
2126073 | 2126073 | 2022-01-18 | Schuyler | Illinois | 17169 | 1690 | 27 |
2061702 | 2061702 | 2021-12-29 | Clearwater | Minnesota | 27029 | 1690 | 25 |
2063502 | 2063502 | 2021-12-29 | Ritchie | West Virginia | 54085 | 1690 | 24 |
2057976 | 2057976 | 2021-12-28 | Montgomery | Iowa | 19137 | 1690 | 48 |
2054727 | 2054727 | 2021-12-27 | Montgomery | Iowa | 19137 | 1690 | 48 |
2051048 | 2051048 | 2021-12-26 | Dooly | Georgia | 13093 | 1690 | 62 |
2051477 | 2051477 | 2021-12-26 | Montgomery | Iowa | 19137 | 1690 | 48 |
2047798 | 2047798 | 2021-12-25 | Dooly | Georgia | 13093 | 1690 | 62 |
2048227 | 2048227 | 2021-12-25 | Montgomery | Iowa | 19137 | 1690 | 48 |
2044548 | 2044548 | 2021-12-24 | Dooly | Georgia | 13093 | 1690 | 62 |
2044977 | 2044977 | 2021-12-24 | Montgomery | Iowa | 19137 | 1690 | 48 |
2041728 | 2041728 | 2021-12-23 | Montgomery | Iowa | 19137 | 1690 | 48 |
2038478 | 2038478 | 2021-12-22 | Montgomery | Iowa | 19137 | 1690 | 48 |
2029221 | 2029221 | 2021-12-19 | Jackson | Minnesota | 27063 | 1690 | 16 |
2025970 | 2025970 | 2021-12-18 | Jackson | Minnesota | 27063 | 1690 | 16 |
2022719 | 2022719 | 2021-12-17 | Jackson | Minnesota | 27063 | 1690 | 16 |
2019848 | 2019848 | 2021-12-16 | Phelps | Nebraska | 31137 | 1690 | 11 |
2012187 | 2012187 | 2021-12-14 | Fremont | Idaho | 16043 | 1690 | 18 |
1973320 | 1973320 | 2021-12-02 | Crawford | Indiana | 18025 | 1690 | 30 |
1960554 | 1960554 | 2021-11-28 | Marshall | Kansas | 20117 | 1690 | 32 |
1957303 | 1957303 | 2021-11-27 | Marshall | Kansas | 20117 | 1690 | 32 |
1954052 | 1954052 | 2021-11-26 | Marshall | Kansas | 20117 | 1690 | 32 |
1950801 | 1950801 | 2021-11-25 | Marshall | Kansas | 20117 | 1690 | 32 |
1947550 | 1947550 | 2021-11-24 | Marshall | Kansas | 20117 | 1690 | 32 |
1924441 | 1924441 | 2021-11-17 | Teton | Idaho | 16081 | 1690 | 5 |
1917237 | 1917237 | 2021-11-14 | Roane | West Virginia | 54087 | 1690 | 24 |
1899737 | 1899737 | 2021-11-09 | Schuyler | New York | 36097 | 1690 | 19 |
1896221 | 1896221 | 2021-11-08 | Dawson | Montana | 30021 | 1690 | 47 |
1849184 | 1849184 | 2021-10-25 | Ketchikan Gateway Borough | Alaska | 2130 | 1690 | 9 |
1837326 | 1837326 | 2021-10-21 | Kent | Maryland | 24029 | 1690 | 56 |
1832434 | 1832434 | 2021-10-19 | Runnels | Texas | 48399 | 1690 | 53 |
1826893 | 1826893 | 2021-10-18 | Turner | Georgia | 13287 | 1690 | 48 |
1816793 | 1816793 | 2021-10-15 | Stone | Arkansas | 5137 | 1690 | 41 |
1806091 | 1806091 | 2021-10-11 | Charles Mix | South Dakota | 46023 | 1690 | 26 |
1802841 | 1802841 | 2021-10-10 | Charles Mix | South Dakota | 46023 | 1690 | 26 |
1799592 | 1799592 | 2021-10-09 | Charles Mix | South Dakota | 46023 | 1690 | 26 |
1796343 | 1796343 | 2021-10-08 | Charles Mix | South Dakota | 46023 | 1690 | 26 |
1791103 | 1791103 | 2021-10-07 | Long | Georgia | 13183 | 1690 | 21 |
1791688 | 1791688 | 2021-10-07 | Lee | Kentucky | 21129 | 1690 | 29 |
1793094 | 1793094 | 2021-10-07 | Charles Mix | South Dakota | 46023 | 1690 | 26 |
1781363 | 1781363 | 2021-10-04 | McIntosh | Georgia | 13191 | 1690 | 28 |
1778113 | 1778113 | 2021-10-03 | McIntosh | Georgia | 13191 | 1690 | 28 |
1774863 | 1774863 | 2021-10-02 | McIntosh | Georgia | 13191 | 1690 | 28 |
1771613 | 1771613 | 2021-10-01 | McIntosh | Georgia | 13191 | 1690 | 28 |
1771726 | 1771726 | 2021-10-01 | Washington | Idaho | 16087 | 1690 | 38 |
1764319 | 1764319 | 2021-09-28 | Brunswick | Virginia | 51025 | 1690 | 29 |
1759328 | 1759328 | 2021-09-27 | Sagadahoc | Maine | 23023 | 1690 | 12 |
1760902 | 1760902 | 2021-09-27 | Live Oak | Texas | 48297 | 1690 | 33 |
1761284 | 1761284 | 2021-09-27 | Ashland | Wisconsin | 55003 | 1690 | 16 |
1755960 | 1755960 | 2021-09-26 | Martin | Kentucky | 21159 | 1690 | 29 |
1756080 | 1756080 | 2021-09-26 | Sagadahoc | Maine | 23023 | 1690 | 12 |
1757306 | 1757306 | 2021-09-26 | Calhoun | South Carolina | 45017 | 1690 | 49 |
1757654 | 1757654 | 2021-09-26 | Live Oak | Texas | 48297 | 1690 | 33 |
1752712 | 1752712 | 2021-09-25 | Martin | Kentucky | 21159 | 1690 | 29 |
1752832 | 1752832 | 2021-09-25 | Sagadahoc | Maine | 23023 | 1690 | 12 |
1754058 | 1754058 | 2021-09-25 | Calhoun | South Carolina | 45017 | 1690 | 49 |
1754406 | 1754406 | 2021-09-25 | Live Oak | Texas | 48297 | 1690 | 32 |
1749463 | 1749463 | 2021-09-24 | Martin | Kentucky | 21159 | 1690 | 29 |
1749583 | 1749583 | 2021-09-24 | Sagadahoc | Maine | 23023 | 1690 | 12 |
1750810 | 1750810 | 2021-09-24 | Calhoun | South Carolina | 45017 | 1690 | 49 |
1751158 | 1751158 | 2021-09-24 | Live Oak | Texas | 48297 | 1690 | 32 |
1747909 | 1747909 | 2021-09-23 | Live Oak | Texas | 48297 | 1690 | 32 |
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);