ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
247 rows where cases = 2056 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 15
- Mississippi 14
- Oklahoma 14
- Virginia 14
- Georgia 13
- Illinois 13
- Puerto Rico 13
- Michigan 11
- Missouri 11
- West Virginia 11
- Colorado 8
- Indiana 8
- Arkansas 6
- Florida 6
- Kentucky 6
- Louisiana 6
- Maryland 6
- Minnesota 6
- Tennessee 6
- North Carolina 5
- South Dakota 5
- Wisconsin 5
- Iowa 4
- Kansas 4
- New Hampshire 4
- Ohio 4
- Alabama 3
- North Dakota 3
- Washington 3
- Idaho 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502548 | 2502548 | 2022-05-13 | Fairfax city | Virginia | 51600 | 2056 | 43 |
2436786 | 2436786 | 2022-04-23 | Arroyo | Puerto Rico | 72015 | 2056 | |
2381462 | 2381462 | 2022-04-06 | Guayanilla | Puerto Rico | 72059 | 2056 | |
2307410 | 2307410 | 2022-03-14 | Pleasants | West Virginia | 54073 | 2056 | 34 |
2304159 | 2304159 | 2022-03-13 | Pleasants | West Virginia | 54073 | 2056 | 34 |
2300907 | 2300907 | 2022-03-12 | Pleasants | West Virginia | 54073 | 2056 | 34 |
2297655 | 2297655 | 2022-03-11 | Pleasants | West Virginia | 54073 | 2056 | 34 |
2292579 | 2292579 | 2022-03-10 | Presque Isle | Michigan | 26141 | 2056 | 56 |
2294403 | 2294403 | 2022-03-10 | Pleasants | West Virginia | 54073 | 2056 | 34 |
2288295 | 2288295 | 2022-03-09 | Lincoln | Colorado | 8073 | 2056 | 9 |
2289327 | 2289327 | 2022-03-09 | Presque Isle | Michigan | 26141 | 2056 | 56 |
2289631 | 2289631 | 2022-03-09 | Blaine | Montana | 30005 | 2056 | 31 |
2285044 | 2285044 | 2022-03-08 | Lincoln | Colorado | 8073 | 2056 | 9 |
2286076 | 2286076 | 2022-03-08 | Presque Isle | Michigan | 26141 | 2056 | 55 |
2286379 | 2286379 | 2022-03-08 | Blaine | Montana | 30005 | 2056 | 31 |
2282824 | 2282824 | 2022-03-07 | Presque Isle | Michigan | 26141 | 2056 | 55 |
2263309 | 2263309 | 2022-03-01 | Presque Isle | Michigan | 26141 | 2056 | 55 |
2260058 | 2260058 | 2022-02-28 | Presque Isle | Michigan | 26141 | 2056 | 55 |
2256283 | 2256283 | 2022-02-27 | Warren | Indiana | 18171 | 2056 | 25 |
2253032 | 2253032 | 2022-02-26 | Warren | Indiana | 18171 | 2056 | 25 |
2249165 | 2249165 | 2022-02-25 | Searcy | Arkansas | 5129 | 2056 | 41 |
2249781 | 2249781 | 2022-02-25 | Warren | Indiana | 18171 | 2056 | 25 |
2223394 | 2223394 | 2022-02-17 | Candler | Georgia | 13043 | 2056 | 91 |
2219784 | 2219784 | 2022-02-16 | Perry | Alabama | 1105 | 2056 | 41 |
2219187 | 2219187 | 2022-02-15 | Franklin | Texas | 48159 | 2056 | 38 |
2211576 | 2211576 | 2022-02-13 | St. Clair | Missouri | 29185 | 2056 | 31 |
2208323 | 2208323 | 2022-02-12 | St. Clair | Missouri | 29185 | 2056 | 31 |
2205070 | 2205070 | 2022-02-11 | St. Clair | Missouri | 29185 | 2056 | 31 |
2201817 | 2201817 | 2022-02-10 | St. Clair | Missouri | 29185 | 2056 | 31 |
2194824 | 2194824 | 2022-02-08 | Trimble | Kentucky | 21223 | 2056 | 35 |
2191051 | 2191051 | 2022-02-07 | Owyhee | Idaho | 16073 | 2056 | 48 |
2190288 | 2190288 | 2022-02-06 | Lincoln | Washington | 53043 | 2056 | 27 |
2187035 | 2187035 | 2022-02-05 | Lincoln | Washington | 53043 | 2056 | 27 |
2183782 | 2183782 | 2022-02-04 | Lincoln | Washington | 53043 | 2056 | 27 |
2176250 | 2176250 | 2022-02-02 | Traill | North Dakota | 38097 | 2056 | 22 |
2172362 | 2172362 | 2022-02-01 | Benton | Mississippi | 28009 | 2056 | 44 |
2172368 | 2172368 | 2022-02-01 | Claiborne | Mississippi | 28021 | 2056 | 42 |
2172997 | 2172997 | 2022-02-01 | Traill | North Dakota | 38097 | 2056 | 22 |
2173717 | 2173717 | 2022-02-01 | Live Oak | Texas | 48297 | 2056 | 40 |
2169115 | 2169115 | 2022-01-31 | Claiborne | Mississippi | 28021 | 2056 | 42 |
2153812 | 2153812 | 2022-01-26 | Sabana Grande | Puerto Rico | 72121 | 2056 | |
2151117 | 2151117 | 2022-01-25 | Charlotte | Virginia | 51037 | 2056 | 32 |
2144470 | 2144470 | 2022-01-23 | Parmer | Texas | 48369 | 2056 | 46 |
2131016 | 2131016 | 2022-01-19 | Lajas | Puerto Rico | 72079 | 2056 | |
2110715 | 2110715 | 2022-01-13 | Ralls | Missouri | 29173 | 2056 | 19 |
2103626 | 2103626 | 2022-01-11 | Wilson | Kansas | 20205 | 2056 | 35 |
2100375 | 2100375 | 2022-01-10 | Wilson | Kansas | 20205 | 2056 | 35 |
2083413 | 2083413 | 2022-01-05 | Prowers | Colorado | 8099 | 2056 | 43 |
2083778 | 2083778 | 2022-01-05 | Marshall | Illinois | 17123 | 2056 | 26 |
2081330 | 2081330 | 2022-01-04 | Montgomery | Mississippi | 28097 | 2056 | 58 |
2053475 | 2053475 | 2021-12-26 | Ward | Texas | 48475 | 2056 | 35 |
2050225 | 2050225 | 2021-12-25 | Ward | Texas | 48475 | 2056 | 35 |
2046975 | 2046975 | 2021-12-24 | Ward | Texas | 48475 | 2056 | 35 |
2043725 | 2043725 | 2021-12-23 | Ward | Texas | 48475 | 2056 | 35 |
2040507 | 2040507 | 2021-12-22 | Morgan | Utah | 49029 | 2056 | 13 |
2007581 | 2007581 | 2021-12-12 | Charles Mix | South Dakota | 46023 | 2056 | 28 |
2004330 | 2004330 | 2021-12-11 | Charles Mix | South Dakota | 46023 | 2056 | 28 |
2001079 | 2001079 | 2021-12-10 | Charles Mix | South Dakota | 46023 | 2056 | 28 |
1996765 | 1996765 | 2021-12-09 | Watonwan | Minnesota | 27165 | 2056 | 21 |
1998316 | 1998316 | 2021-12-09 | Dickenson | Virginia | 51051 | 2056 | 30 |
1974447 | 1974447 | 2021-12-02 | Torrance | New Mexico | 35057 | 2056 | 23 |
1946502 | 1946502 | 2021-11-23 | Ashland | Wisconsin | 55003 | 2056 | 21 |
1922836 | 1922836 | 2021-11-16 | Hood River | Oregon | 41027 | 2056 | 37 |
1879445 | 1879445 | 2021-11-03 | Pendleton | Kentucky | 21191 | 2056 | 19 |
1861858 | 1861858 | 2021-10-28 | Martinsville city | Virginia | 51690 | 2056 | 89 |
1852436 | 1852436 | 2021-10-26 | Kusilvak Census Area | Alaska | 2158 | 2056 | 8 |
1849774 | 1849774 | 2021-10-25 | Mercer | Illinois | 17131 | 2056 | 36 |
1846489 | 1846489 | 2021-10-24 | Greene | Illinois | 17061 | 2056 | 53 |
1843239 | 1843239 | 2021-10-23 | Greene | Illinois | 17061 | 2056 | 53 |
1839989 | 1839989 | 2021-10-22 | Greene | Illinois | 17061 | 2056 | 53 |
1816475 | 1816475 | 2021-10-14 | Grant | West Virginia | 54023 | 2056 | 32 |
1802485 | 1802485 | 2021-10-10 | Monroe | Ohio | 39111 | 2056 | 50 |
1793829 | 1793829 | 2021-10-07 | Rusk | Wisconsin | 55107 | 2056 | 31 |
1772153 | 1772153 | 2021-10-01 | Clinton | Kentucky | 21053 | 2056 | 33 |
1767602 | 1767602 | 2021-09-29 | Giles | Virginia | 51071 | 2056 | 25 |
1755135 | 1755135 | 2021-09-26 | Chaffee | Colorado | 8015 | 2056 | 28 |
1751887 | 1751887 | 2021-09-25 | Chaffee | Colorado | 8015 | 2056 | 28 |
1748540 | 1748540 | 2021-09-24 | Marion | Arkansas | 5089 | 2056 | 55 |
1748638 | 1748638 | 2021-09-24 | Chaffee | Colorado | 8015 | 2056 | 28 |
1739404 | 1739404 | 2021-09-21 | Pike | Indiana | 18125 | 2056 | 39 |
1720715 | 1720715 | 2021-09-15 | Osage | Missouri | 29151 | 2056 | 20 |
1679762 | 1679762 | 2021-09-02 | Tyler | Texas | 48457 | 2056 | 53 |
1676514 | 1676514 | 2021-09-01 | Tyler | Texas | 48457 | 2056 | 53 |
1672327 | 1672327 | 2021-08-31 | Bertie | North Carolina | 37015 | 2056 | 46 |
1653486 | 1653486 | 2021-08-25 | Grundy | Tennessee | 47061 | 2056 | 35 |
1650239 | 1650239 | 2021-08-24 | Grundy | Tennessee | 47061 | 2056 | 35 |
1641881 | 1641881 | 2021-08-22 | White | Illinois | 17193 | 2056 | 37 |
1638631 | 1638631 | 2021-08-21 | White | Illinois | 17193 | 2056 | 37 |
1635381 | 1635381 | 2021-08-20 | White | Illinois | 17193 | 2056 | 37 |
1628765 | 1628765 | 2021-08-18 | Gem | Idaho | 16045 | 2056 | 46 |
1631224 | 1631224 | 2021-08-18 | Scott | Virginia | 51169 | 2056 | 61 |
1624435 | 1624435 | 2021-08-16 | Jackson | Texas | 48239 | 2056 | 32 |
1621188 | 1621188 | 2021-08-15 | Jackson | Texas | 48239 | 2056 | 32 |
1617940 | 1617940 | 2021-08-14 | Jackson | Texas | 48239 | 2056 | 32 |
1609848 | 1609848 | 2021-08-12 | LaSalle | Louisiana | 22059 | 2056 | 39 |
1611032 | 1611032 | 2021-08-12 | Aguada | Puerto Rico | 72003 | 2056 | |
1603782 | 1603782 | 2021-08-10 | Pike | Missouri | 29163 | 2056 | 28 |
1598512 | 1598512 | 2021-08-08 | Panola | Texas | 48365 | 2056 | 78 |
1576817 | 1576817 | 2021-08-02 | Carroll | Illinois | 17015 | 2056 | 38 |
1553509 | 1553509 | 2021-07-26 | Henry | Alabama | 1067 | 2056 | 45 |
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);