ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
201 rows where cases = 2647 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 14
- Illinois 12
- Idaho 11
- Indiana 11
- Virginia 11
- Tennessee 10
- Georgia 9
- Oklahoma 8
- Texas 7
- Alabama 6
- Kentucky 6
- Mississippi 6
- Arkansas 5
- Colorado 5
- Louisiana 5
- Missouri 5
- Ohio 5
- Pennsylvania 5
- Utah 5
- Nebraska 4
- Puerto Rico 4
- California 3
- Massachusetts 3
- Michigan 3
- Nevada 3
- New Mexico 3
- New York 3
- North Carolina 3
- North Dakota 3
- Wisconsin 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493354 | 2493354 | 2022-05-11 | Prowers | Colorado | 8099 | 2647 | 51 |
2495814 | 2495814 | 2022-05-11 | Jim Hogg | Texas | 48247 | 2647 | 22 |
2473215 | 2473215 | 2022-05-04 | Clarke | Virginia | 51043 | 2647 | 42 |
2469959 | 2469959 | 2022-05-03 | Clarke | Virginia | 51043 | 2647 | 42 |
2453086 | 2453086 | 2022-04-28 | Florida | Puerto Rico | 72054 | 2647 | |
2399140 | 2399140 | 2022-04-12 | Screven | Georgia | 13251 | 2647 | 67 |
2301618 | 2301618 | 2022-03-13 | Shoshone | Idaho | 16079 | 2647 | 75 |
2298366 | 2298366 | 2022-03-12 | Shoshone | Idaho | 16079 | 2647 | 75 |
2295114 | 2295114 | 2022-03-11 | Shoshone | Idaho | 16079 | 2647 | 75 |
2284322 | 2284322 | 2022-03-07 | Pecos | Texas | 48371 | 2647 | 69 |
2281070 | 2281070 | 2022-03-06 | Pecos | Texas | 48371 | 2647 | 69 |
2277817 | 2277817 | 2022-03-05 | Pecos | Texas | 48371 | 2647 | 69 |
2271886 | 2271886 | 2022-03-04 | Fulton | Arkansas | 5049 | 2647 | 85 |
2274564 | 2274564 | 2022-03-04 | Pecos | Texas | 48371 | 2647 | 69 |
2257312 | 2257312 | 2022-02-27 | Colfax | New Mexico | 35007 | 2647 | 65 |
2254061 | 2254061 | 2022-02-26 | Colfax | New Mexico | 35007 | 2647 | 65 |
2250810 | 2250810 | 2022-02-25 | Colfax | New Mexico | 35007 | 2647 | 65 |
2247103 | 2247103 | 2022-02-24 | Koochiching | Minnesota | 27071 | 2647 | 34 |
2220373 | 2220373 | 2022-02-16 | Jasper | Illinois | 17079 | 2647 | 27 |
2221795 | 2221795 | 2022-02-16 | Unknown | Northern Mariana Islands | 2647 | 2 | |
2197563 | 2197563 | 2022-02-09 | Teton | Idaho | 16081 | 2647 | 8 |
2188671 | 2188671 | 2022-02-06 | Noxubee | Mississippi | 28103 | 2647 | 47 |
2185418 | 2185418 | 2022-02-05 | Noxubee | Mississippi | 28103 | 2647 | 47 |
2182166 | 2182166 | 2022-02-04 | Noxubee | Mississippi | 28103 | 2647 | 47 |
2174487 | 2174487 | 2022-02-02 | Park | Colorado | 8093 | 2647 | 17 |
2115299 | 2115299 | 2022-01-14 | Lamoille | Vermont | 50015 | 2647 | 12 |
2097357 | 2097357 | 2022-01-09 | Dukes | Massachusetts | 25007 | 2647 | 0 |
2097875 | 2097875 | 2022-01-09 | Seward | Nebraska | 31159 | 2647 | 40 |
2094105 | 2094105 | 2022-01-08 | Dukes | Massachusetts | 25007 | 2647 | 0 |
2094623 | 2094623 | 2022-01-08 | Seward | Nebraska | 31159 | 2647 | 40 |
2090853 | 2090853 | 2022-01-07 | Dukes | Massachusetts | 25007 | 2647 | 0 |
2091371 | 2091371 | 2022-01-07 | Seward | Nebraska | 31159 | 2647 | 40 |
2076343 | 2076343 | 2022-01-02 | Greene | Virginia | 51079 | 2647 | 47 |
2073092 | 2073092 | 2022-01-01 | Greene | Virginia | 51079 | 2647 | 47 |
2069841 | 2069841 | 2021-12-31 | Greene | Virginia | 51079 | 2647 | 47 |
2058145 | 2058145 | 2021-12-28 | Estill | Kentucky | 21065 | 2647 | 37 |
2054907 | 2054907 | 2021-12-27 | Green | Kentucky | 21087 | 2647 | 39 |
2052644 | 2052644 | 2021-12-26 | McKenzie | North Dakota | 38053 | 2647 | 23 |
2049394 | 2049394 | 2021-12-25 | McKenzie | North Dakota | 38053 | 2647 | 23 |
2046144 | 2046144 | 2021-12-24 | McKenzie | North Dakota | 38053 | 2647 | 23 |
2037633 | 2037633 | 2021-12-22 | Crenshaw | Alabama | 1041 | 2647 | 79 |
2035479 | 2035479 | 2021-12-21 | Washington | Kentucky | 21229 | 2647 | 51 |
2029464 | 2029464 | 2021-12-19 | Ste. Genevieve | Missouri | 29186 | 2647 | 34 |
2030232 | 2030232 | 2021-12-19 | Isabela | Puerto Rico | 72071 | 2647 | |
1995115 | 1995115 | 2021-12-08 | New Kent | Virginia | 51127 | 2647 | 27 |
1963244 | 1963244 | 2021-11-29 | Bacon | Georgia | 13005 | 2647 | 63 |
1965300 | 1965300 | 2021-11-29 | Lee | South Carolina | 45061 | 2647 | 78 |
1943598 | 1943598 | 2021-11-23 | Chaffee | Colorado | 8015 | 2647 | 34 |
1944903 | 1944903 | 2021-11-23 | Livingston | Missouri | 29117 | 2647 | 79 |
1944993 | 1944993 | 2021-11-23 | Park | Montana | 30067 | 2647 | 30 |
1938031 | 1938031 | 2021-11-21 | Winn | Louisiana | 22127 | 2647 | 58 |
1934781 | 1934781 | 2021-11-20 | Winn | Louisiana | 22127 | 2647 | 58 |
1931530 | 1931530 | 2021-11-19 | Winn | Louisiana | 22127 | 2647 | 58 |
1928279 | 1928279 | 2021-11-18 | Winn | Louisiana | 22127 | 2647 | 58 |
1917423 | 1917423 | 2021-11-15 | Kodiak Island Borough | Alaska | 2150 | 2647 | 9 |
1908795 | 1908795 | 2021-11-12 | Waldo | Maine | 23027 | 2647 | 34 |
1905546 | 1905546 | 2021-11-11 | Waldo | Maine | 23027 | 2647 | 34 |
1877308 | 1877308 | 2021-11-02 | Pawnee | Oklahoma | 40117 | 2647 | 66 |
1874059 | 1874059 | 2021-11-01 | Pawnee | Oklahoma | 40117 | 2647 | 66 |
1870810 | 1870810 | 2021-10-31 | Pawnee | Oklahoma | 40117 | 2647 | 66 |
1867561 | 1867561 | 2021-10-30 | Pawnee | Oklahoma | 40117 | 2647 | 66 |
1864312 | 1864312 | 2021-10-29 | Pawnee | Oklahoma | 40117 | 2647 | 66 |
1861063 | 1861063 | 2021-10-28 | Pawnee | Oklahoma | 40117 | 2647 | 66 |
1857814 | 1857814 | 2021-10-27 | Pawnee | Oklahoma | 40117 | 2647 | 66 |
1823722 | 1823722 | 2021-10-17 | Cass | Illinois | 17017 | 2647 | 39 |
1820473 | 1820473 | 2021-10-16 | Cass | Illinois | 17017 | 2647 | 39 |
1817224 | 1817224 | 2021-10-15 | Cass | Illinois | 17017 | 2647 | 39 |
1814132 | 1814132 | 2021-10-14 | Perry | Indiana | 18123 | 2647 | 55 |
1806500 | 1806500 | 2021-10-11 | Carbon | Utah | 49007 | 2647 | 24 |
1803250 | 1803250 | 2021-10-10 | Carbon | Utah | 49007 | 2647 | 24 |
1800001 | 1800001 | 2021-10-09 | Carbon | Utah | 49007 | 2647 | 24 |
1774245 | 1774245 | 2021-10-01 | Lewis | West Virginia | 54041 | 2647 | 36 |
1747206 | 1747206 | 2021-09-23 | Carroll | Ohio | 39019 | 2647 | 52 |
1716750 | 1716750 | 2021-09-14 | Mahaska | Iowa | 19123 | 2647 | 52 |
1713504 | 1713504 | 2021-09-13 | Mahaska | Iowa | 19123 | 2647 | 52 |
1710257 | 1710257 | 2021-09-12 | Mahaska | Iowa | 19123 | 2647 | 52 |
1710607 | 1710607 | 2021-09-12 | Caroline | Maryland | 24011 | 2647 | 36 |
1707010 | 1707010 | 2021-09-11 | Mahaska | Iowa | 19123 | 2647 | 52 |
1703762 | 1703762 | 2021-09-10 | Mahaska | Iowa | 19123 | 2647 | 52 |
1700512 | 1700512 | 2021-09-09 | Mahaska | Iowa | 19123 | 2647 | 52 |
1697263 | 1697263 | 2021-09-08 | Mahaska | Iowa | 19123 | 2647 | 52 |
1693296 | 1693296 | 2021-09-07 | Hempstead | Arkansas | 5057 | 2647 | 22 |
1694923 | 1694923 | 2021-09-07 | Churchill | Nevada | 32001 | 2647 | 53 |
1695651 | 1695651 | 2021-09-07 | Hughes | South Dakota | 46065 | 2647 | 43 |
1674212 | 1674212 | 2021-09-01 | Worth | Georgia | 13321 | 2647 | 72 |
1646836 | 1646836 | 2021-08-23 | Vega Alta | Puerto Rico | 72143 | 2647 | |
1628929 | 1628929 | 2021-08-18 | Jennings | Indiana | 18079 | 2647 | 54 |
1620997 | 1620997 | 2021-08-15 | Fentress | Tennessee | 47049 | 2647 | 49 |
1617749 | 1617749 | 2021-08-14 | Fentress | Tennessee | 47049 | 2647 | 49 |
1614501 | 1614501 | 2021-08-13 | Fentress | Tennessee | 47049 | 2647 | 49 |
1586003 | 1586003 | 2021-08-05 | Marengo | Alabama | 1091 | 2647 | 67 |
1578601 | 1578601 | 2021-08-02 | Rio Grande | Puerto Rico | 72119 | 2647 | |
1575554 | 1575554 | 2021-08-01 | Morgan | Tennessee | 47129 | 2647 | 38 |
1572306 | 1572306 | 2021-07-31 | Morgan | Tennessee | 47129 | 2647 | 38 |
1569058 | 1569058 | 2021-07-30 | Morgan | Tennessee | 47129 | 2647 | 38 |
1563838 | 1563838 | 2021-07-29 | Douglas | Illinois | 17041 | 2647 | 42 |
1550822 | 1550822 | 2021-07-25 | Payette | Idaho | 16075 | 2647 | 38 |
1547575 | 1547575 | 2021-07-24 | Payette | Idaho | 16075 | 2647 | 38 |
1544328 | 1544328 | 2021-07-23 | Payette | Idaho | 16075 | 2647 | 38 |
1540780 | 1540780 | 2021-07-22 | Pitkin | Colorado | 8097 | 2647 | 4 |
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);