ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
302 rows where cases = 1871 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 22
- Georgia 21
- Missouri 19
- Arkansas 18
- Montana 17
- Alabama 15
- Mississippi 14
- Virginia 14
- Indiana 12
- Minnesota 10
- Kansas 9
- Oklahoma 9
- Puerto Rico 9
- Tennessee 9
- Florida 8
- Kentucky 8
- Louisiana 8
- Colorado 6
- Iowa 6
- Michigan 6
- Pennsylvania 6
- West Virginia 6
- Wisconsin 6
- North Dakota 5
- South Carolina 5
- North Carolina 4
- Ohio 4
- Idaho 3
- Washington 3
- Wyoming 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471911 | 2471911 | 2022-05-04 | Powell | Montana | 30077 | 1871 | 29 |
2468655 | 2468655 | 2022-05-03 | Powell | Montana | 30077 | 1871 | 29 |
2465399 | 2465399 | 2022-05-02 | Powell | Montana | 30077 | 1871 | 29 |
2462144 | 2462144 | 2022-05-01 | Powell | Montana | 30077 | 1871 | 29 |
2458888 | 2458888 | 2022-04-30 | Powell | Montana | 30077 | 1871 | 29 |
2455632 | 2455632 | 2022-04-29 | Powell | Montana | 30077 | 1871 | 29 |
2452376 | 2452376 | 2022-04-28 | Powell | Montana | 30077 | 1871 | 29 |
2449120 | 2449120 | 2022-04-27 | Powell | Montana | 30077 | 1871 | 29 |
2445863 | 2445863 | 2022-04-26 | Powell | Montana | 30077 | 1871 | 29 |
2442608 | 2442608 | 2022-04-25 | Powell | Montana | 30077 | 1871 | 29 |
2439352 | 2439352 | 2022-04-24 | Powell | Montana | 30077 | 1871 | 28 |
2436096 | 2436096 | 2022-04-23 | Powell | Montana | 30077 | 1871 | 28 |
2432840 | 2432840 | 2022-04-22 | Powell | Montana | 30077 | 1871 | 28 |
2427959 | 2427959 | 2022-04-21 | Greene | Alabama | 1063 | 1871 | 48 |
2429584 | 2429584 | 2022-04-21 | Powell | Montana | 30077 | 1871 | 28 |
2424703 | 2424703 | 2022-04-20 | Greene | Alabama | 1063 | 1871 | 48 |
2421447 | 2421447 | 2022-04-19 | Greene | Alabama | 1063 | 1871 | 48 |
2418191 | 2418191 | 2022-04-18 | Greene | Alabama | 1063 | 1871 | 48 |
2414935 | 2414935 | 2022-04-17 | Greene | Alabama | 1063 | 1871 | 48 |
2411679 | 2411679 | 2022-04-16 | Greene | Alabama | 1063 | 1871 | 48 |
2408423 | 2408423 | 2022-04-15 | Greene | Alabama | 1063 | 1871 | 48 |
2405167 | 2405167 | 2022-04-14 | Greene | Alabama | 1063 | 1871 | 48 |
2401912 | 2401912 | 2022-04-13 | Greene | Alabama | 1063 | 1871 | 48 |
2394488 | 2394488 | 2022-04-10 | Hormigueros | Puerto Rico | 72067 | 1871 | |
2349245 | 2349245 | 2022-03-27 | Crosby | Texas | 48107 | 1871 | 45 |
2345992 | 2345992 | 2022-03-26 | Crosby | Texas | 48107 | 1871 | 45 |
2285742 | 2285742 | 2022-03-08 | Russell | Kansas | 20167 | 1871 | 36 |
2282490 | 2282490 | 2022-03-07 | Russell | Kansas | 20167 | 1871 | 36 |
2222975 | 2222975 | 2022-02-16 | Platte | Wyoming | 56031 | 1871 | 39 |
2216199 | 2216199 | 2022-02-14 | Falls Church city | Virginia | 51610 | 1871 | 14 |
2216474 | 2216474 | 2022-02-14 | Platte | Wyoming | 56031 | 1871 | 39 |
2177606 | 2177606 | 2022-02-03 | Monroe | Arkansas | 5095 | 1871 | 28 |
2177791 | 2177791 | 2022-02-03 | Glades | Florida | 12043 | 1871 | 34 |
2174538 | 2174538 | 2022-02-02 | Glades | Florida | 12043 | 1871 | 34 |
2171285 | 2171285 | 2022-02-01 | Glades | Florida | 12043 | 1871 | 34 |
2168032 | 2168032 | 2022-01-31 | Glades | Florida | 12043 | 1871 | 34 |
2164777 | 2164777 | 2022-01-30 | Glades | Florida | 12043 | 1871 | 34 |
2161522 | 2161522 | 2022-01-29 | Glades | Florida | 12043 | 1871 | 34 |
2158266 | 2158266 | 2022-01-28 | Glades | Florida | 12043 | 1871 | 34 |
2142627 | 2142627 | 2022-01-23 | Pawnee | Kansas | 20145 | 1871 | 21 |
2139372 | 2139372 | 2022-01-22 | Pawnee | Kansas | 20145 | 1871 | 21 |
2136116 | 2136116 | 2022-01-21 | Pawnee | Kansas | 20145 | 1871 | 21 |
2130068 | 2130068 | 2022-01-19 | Claiborne | Mississippi | 28021 | 1871 | 42 |
2127617 | 2127617 | 2022-01-18 | Woods | Oklahoma | 40151 | 1871 | 30 |
2124365 | 2124365 | 2022-01-17 | Woods | Oklahoma | 40151 | 1871 | 30 |
2121113 | 2121113 | 2022-01-16 | Woods | Oklahoma | 40151 | 1871 | 30 |
2115755 | 2115755 | 2022-01-15 | Cleveland | Arkansas | 5025 | 1871 | 33 |
2117861 | 2117861 | 2022-01-15 | Woods | Oklahoma | 40151 | 1871 | 30 |
2114610 | 2114610 | 2022-01-14 | Woods | Oklahoma | 40151 | 1871 | 30 |
2111358 | 2111358 | 2022-01-13 | Woods | Oklahoma | 40151 | 1871 | 30 |
2108106 | 2108106 | 2022-01-12 | Woods | Oklahoma | 40151 | 1871 | 30 |
2096298 | 2096298 | 2022-01-09 | Scott | Arkansas | 5127 | 1871 | 34 |
2093046 | 2093046 | 2022-01-08 | Scott | Arkansas | 5127 | 1871 | 34 |
2073427 | 2073427 | 2022-01-02 | Wilcox | Alabama | 1131 | 1871 | 38 |
2074071 | 2074071 | 2022-01-02 | Benton | Indiana | 18007 | 1871 | 20 |
2070820 | 2070820 | 2022-01-01 | Benton | Indiana | 18007 | 1871 | 20 |
2067569 | 2067569 | 2021-12-31 | Benton | Indiana | 18007 | 1871 | 20 |
2064318 | 2064318 | 2021-12-30 | Benton | Indiana | 18007 | 1871 | 20 |
2058513 | 2058513 | 2021-12-28 | Stevens | Minnesota | 27149 | 1871 | 11 |
2050904 | 2050904 | 2021-12-26 | Park | Colorado | 8093 | 1871 | 14 |
2047654 | 2047654 | 2021-12-25 | Park | Colorado | 8093 | 1871 | 14 |
2044404 | 2044404 | 2021-12-24 | Park | Colorado | 8093 | 1871 | 14 |
2046489 | 2046489 | 2021-12-24 | Loiza | Puerto Rico | 72087 | 1871 | |
2043239 | 2043239 | 2021-12-23 | Loiza | Puerto Rico | 72087 | 1871 | |
2008049 | 2008049 | 2021-12-12 | Brunswick | Virginia | 51025 | 1871 | 35 |
2004798 | 2004798 | 2021-12-11 | Brunswick | Virginia | 51025 | 1871 | 35 |
2001547 | 2001547 | 2021-12-10 | Brunswick | Virginia | 51025 | 1871 | 35 |
1993846 | 1993846 | 2021-12-08 | Red Willow | Nebraska | 31145 | 1871 | 16 |
1961634 | 1961634 | 2021-11-28 | Mercer | North Dakota | 38057 | 1871 | 17 |
1958383 | 1958383 | 2021-11-27 | Mercer | North Dakota | 38057 | 1871 | 17 |
1940390 | 1940390 | 2021-11-22 | Prowers | Colorado | 8099 | 1871 | 35 |
1933774 | 1933774 | 2021-11-20 | Stone | Arkansas | 5137 | 1871 | 44 |
1926414 | 1926414 | 2021-11-17 | Houston | Tennessee | 47083 | 1871 | 45 |
1926928 | 1926928 | 2021-11-17 | Pacific | Washington | 53049 | 1871 | 34 |
1923248 | 1923248 | 2021-11-16 | Callahan | Texas | 48059 | 1871 | 57 |
1870068 | 1870068 | 2021-10-31 | Noxubee | Mississippi | 28103 | 1871 | 40 |
1866819 | 1866819 | 2021-10-30 | Noxubee | Mississippi | 28103 | 1871 | 40 |
1863570 | 1863570 | 2021-10-29 | Noxubee | Mississippi | 28103 | 1871 | 40 |
1860321 | 1860321 | 2021-10-28 | Noxubee | Mississippi | 28103 | 1871 | 40 |
1857072 | 1857072 | 2021-10-27 | Noxubee | Mississippi | 28103 | 1871 | 40 |
1857858 | 1857858 | 2021-10-27 | Morrow | Oregon | 41049 | 1871 | 23 |
1853684 | 1853684 | 2021-10-26 | Aitkin | Minnesota | 27001 | 1871 | 43 |
1844643 | 1844643 | 2021-10-23 | Mountrail | North Dakota | 38061 | 1871 | 26 |
1832590 | 1832590 | 2021-10-19 | Greensville | Virginia | 51081 | 1871 | 27 |
1824472 | 1824472 | 2021-10-17 | Kanabec | Minnesota | 27065 | 1871 | 30 |
1821223 | 1821223 | 2021-10-16 | Kanabec | Minnesota | 27065 | 1871 | 30 |
1817974 | 1817974 | 2021-10-15 | Kanabec | Minnesota | 27065 | 1871 | 30 |
1781948 | 1781948 | 2021-10-04 | Lyon | Kentucky | 21143 | 1871 | 25 |
1767729 | 1767729 | 2021-09-29 | Braxton | West Virginia | 54007 | 1871 | 12 |
1763344 | 1763344 | 2021-09-28 | Mitchell | North Carolina | 37121 | 1871 | 17 |
1759314 | 1759314 | 2021-09-27 | West Carroll | Louisiana | 22123 | 1871 | 46 |
1753985 | 1753985 | 2021-09-25 | Cidra | Puerto Rico | 72041 | 1871 | |
1745016 | 1745016 | 2021-09-22 | Monroe | West Virginia | 54063 | 1871 | 21 |
1745078 | 1745078 | 2021-09-22 | Marquette | Wisconsin | 55077 | 1871 | 29 |
1732289 | 1732289 | 2021-09-19 | Little River | Arkansas | 5081 | 1871 | 44 |
1723637 | 1723637 | 2021-09-16 | Antrim | Michigan | 26009 | 1871 | 33 |
1721749 | 1721749 | 2021-09-15 | Stewart | Tennessee | 47161 | 1871 | 30 |
1717276 | 1717276 | 2021-09-14 | Pennington | Minnesota | 27113 | 1871 | 21 |
1717924 | 1717924 | 2021-09-14 | McKenzie | North Dakota | 38053 | 1871 | 15 |
1694734 | 1694734 | 2021-09-07 | Pemiscot | Missouri | 29155 | 1871 | 39 |
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);