ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
311 rows where cases = 1864 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 41
- Georgia 19
- Montana 17
- Iowa 16
- Virginia 16
- Louisiana 15
- North Carolina 15
- Michigan 13
- Puerto Rico 12
- Mississippi 11
- Illinois 10
- Indiana 10
- Missouri 10
- Arkansas 9
- Kansas 9
- Kentucky 9
- Tennessee 9
- Wisconsin 9
- Colorado 8
- Nebraska 6
- South Carolina 6
- Ohio 5
- Alabama 4
- Pennsylvania 4
- West Virginia 4
- Florida 3
- Massachusetts 3
- Maryland 2
- Minnesota 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502374 | 2502374 | 2022-05-13 | Mitchell | Texas | 48335 | 1864 | 49 |
2499116 | 2499116 | 2022-05-12 | Mitchell | Texas | 48335 | 1864 | 49 |
2495858 | 2495858 | 2022-05-11 | Mitchell | Texas | 48335 | 1864 | 48 |
2492600 | 2492600 | 2022-05-10 | Mitchell | Texas | 48335 | 1864 | 48 |
2489342 | 2489342 | 2022-05-09 | Mitchell | Texas | 48335 | 1864 | 48 |
2486085 | 2486085 | 2022-05-08 | Mitchell | Texas | 48335 | 1864 | 48 |
2482827 | 2482827 | 2022-05-07 | Mitchell | Texas | 48335 | 1864 | 48 |
2479569 | 2479569 | 2022-05-06 | Mitchell | Texas | 48335 | 1864 | 48 |
2476311 | 2476311 | 2022-05-05 | Mitchell | Texas | 48335 | 1864 | 48 |
2473054 | 2473054 | 2022-05-04 | Mitchell | Texas | 48335 | 1864 | 48 |
2469798 | 2469798 | 2022-05-03 | Mitchell | Texas | 48335 | 1864 | 48 |
2466542 | 2466542 | 2022-05-02 | Mitchell | Texas | 48335 | 1864 | 48 |
2463287 | 2463287 | 2022-05-01 | Mitchell | Texas | 48335 | 1864 | 48 |
2460031 | 2460031 | 2022-04-30 | Mitchell | Texas | 48335 | 1864 | 48 |
2456775 | 2456775 | 2022-04-29 | Mitchell | Texas | 48335 | 1864 | 48 |
2453519 | 2453519 | 2022-04-28 | Mitchell | Texas | 48335 | 1864 | 48 |
2450263 | 2450263 | 2022-04-27 | Mitchell | Texas | 48335 | 1864 | 48 |
2450576 | 2450576 | 2022-04-27 | Calhoun | West Virginia | 54013 | 1864 | 14 |
2447006 | 2447006 | 2022-04-26 | Mitchell | Texas | 48335 | 1864 | 48 |
2443751 | 2443751 | 2022-04-25 | Mitchell | Texas | 48335 | 1864 | 48 |
2440495 | 2440495 | 2022-04-24 | Mitchell | Texas | 48335 | 1864 | 48 |
2437239 | 2437239 | 2022-04-23 | Mitchell | Texas | 48335 | 1864 | 48 |
2433983 | 2433983 | 2022-04-22 | Mitchell | Texas | 48335 | 1864 | 48 |
2354313 | 2354313 | 2022-03-29 | Alger | Michigan | 26003 | 1864 | 13 |
2351061 | 2351061 | 2022-03-28 | Alger | Michigan | 26003 | 1864 | 13 |
2347808 | 2347808 | 2022-03-27 | Alger | Michigan | 26003 | 1864 | 13 |
2344555 | 2344555 | 2022-03-26 | Alger | Michigan | 26003 | 1864 | 13 |
2341302 | 2341302 | 2022-03-25 | Alger | Michigan | 26003 | 1864 | 13 |
2333581 | 2333581 | 2022-03-23 | Greene | Alabama | 1063 | 1864 | 48 |
2335204 | 2335204 | 2022-03-23 | Powell | Montana | 30077 | 1864 | 28 |
2331950 | 2331950 | 2022-03-22 | Powell | Montana | 30077 | 1864 | 28 |
2328697 | 2328697 | 2022-03-21 | Powell | Montana | 30077 | 1864 | 28 |
2325445 | 2325445 | 2022-03-20 | Powell | Montana | 30077 | 1864 | 28 |
2322191 | 2322191 | 2022-03-19 | Powell | Montana | 30077 | 1864 | 28 |
2318937 | 2318937 | 2022-03-18 | Powell | Montana | 30077 | 1864 | 28 |
2315684 | 2315684 | 2022-03-17 | Powell | Montana | 30077 | 1864 | 28 |
2312431 | 2312431 | 2022-03-16 | Powell | Montana | 30077 | 1864 | 28 |
2312721 | 2312721 | 2022-03-16 | Gates | North Carolina | 37073 | 1864 | 19 |
2306215 | 2306215 | 2022-03-14 | Gates | North Carolina | 37073 | 1864 | 19 |
2302964 | 2302964 | 2022-03-13 | Gates | North Carolina | 37073 | 1864 | 19 |
2299712 | 2299712 | 2022-03-12 | Gates | North Carolina | 37073 | 1864 | 19 |
2296460 | 2296460 | 2022-03-11 | Gates | North Carolina | 37073 | 1864 | 19 |
2292919 | 2292919 | 2022-03-10 | Powell | Montana | 30077 | 1864 | 28 |
2289667 | 2289667 | 2022-03-09 | Powell | Montana | 30077 | 1864 | 28 |
2286415 | 2286415 | 2022-03-08 | Powell | Montana | 30077 | 1864 | 28 |
2233716 | 2233716 | 2022-02-20 | Russell | Kansas | 20167 | 1864 | 36 |
2234494 | 2234494 | 2022-02-20 | Unknown | Nebraska | 1864 | 394 | |
2230465 | 2230465 | 2022-02-19 | Russell | Kansas | 20167 | 1864 | 36 |
2231243 | 2231243 | 2022-02-19 | Unknown | Nebraska | 1864 | 394 | |
2227214 | 2227214 | 2022-02-18 | Russell | Kansas | 20167 | 1864 | 36 |
2227992 | 2227992 | 2022-02-18 | Unknown | Nebraska | 1864 | 394 | |
2196415 | 2196415 | 2022-02-08 | Floyd | Texas | 48153 | 1864 | 46 |
2196851 | 2196851 | 2022-02-08 | Pocahontas | West Virginia | 54075 | 1864 | 25 |
2193161 | 2193161 | 2022-02-07 | Floyd | Texas | 48153 | 1864 | 46 |
2189907 | 2189907 | 2022-02-06 | Floyd | Texas | 48153 | 1864 | 46 |
2186796 | 2186796 | 2022-02-05 | Swisher | Texas | 48437 | 1864 | 30 |
2183544 | 2183544 | 2022-02-04 | Swisher | Texas | 48437 | 1864 | 30 |
2164927 | 2164927 | 2022-01-30 | Montgomery | Georgia | 13209 | 1864 | 47 |
2161672 | 2161672 | 2022-01-29 | Montgomery | Georgia | 13209 | 1864 | 47 |
2158416 | 2158416 | 2022-01-28 | Montgomery | Georgia | 13209 | 1864 | 47 |
2151591 | 2151591 | 2022-01-26 | Searcy | Arkansas | 5129 | 1864 | 37 |
2142820 | 2142820 | 2022-01-23 | Red River | Louisiana | 22081 | 1864 | 49 |
2139565 | 2139565 | 2022-01-22 | Red River | Louisiana | 22081 | 1864 | 49 |
2136309 | 2136309 | 2022-01-21 | Red River | Louisiana | 22081 | 1864 | 49 |
2105027 | 2105027 | 2022-01-11 | Santa Isabel | Puerto Rico | 72133 | 1864 | |
2097264 | 2097264 | 2022-01-09 | East Carroll | Louisiana | 22035 | 1864 | 33 |
2094012 | 2094012 | 2022-01-08 | East Carroll | Louisiana | 22035 | 1864 | 33 |
2090760 | 2090760 | 2022-01-07 | East Carroll | Louisiana | 22035 | 1864 | 33 |
2091190 | 2091190 | 2022-01-07 | Montgomery | Missouri | 29139 | 1864 | 34 |
2078906 | 2078906 | 2022-01-03 | Forest | Pennsylvania | 42053 | 1864 | 31 |
2072497 | 2072497 | 2022-01-01 | Naguabo | Puerto Rico | 72103 | 1864 | |
2069246 | 2069246 | 2021-12-31 | Naguabo | Puerto Rico | 72103 | 1864 | |
2033484 | 2033484 | 2021-12-20 | Juana Diaz | Puerto Rico | 72075 | 1864 | |
1987345 | 1987345 | 2021-12-06 | Red Willow | Nebraska | 31145 | 1864 | 16 |
1966351 | 1966351 | 2021-11-30 | Archuleta | Colorado | 8007 | 1864 | 7 |
1961236 | 1961236 | 2021-11-28 | Jefferson | Montana | 30043 | 1864 | 14 |
1957985 | 1957985 | 2021-11-27 | Jefferson | Montana | 30043 | 1864 | 14 |
1954734 | 1954734 | 2021-11-26 | Jefferson | Montana | 30043 | 1864 | 14 |
1949982 | 1949982 | 2021-11-25 | Fulton | Arkansas | 5049 | 1864 | 67 |
1923164 | 1923164 | 2021-11-16 | Houston | Tennessee | 47083 | 1864 | 45 |
1920429 | 1920429 | 2021-11-15 | Pacific | Washington | 53049 | 1864 | 34 |
1879580 | 1879580 | 2021-11-03 | Dukes | Massachusetts | 25007 | 1864 | 0 |
1876331 | 1876331 | 2021-11-02 | Dukes | Massachusetts | 25007 | 1864 | 0 |
1873082 | 1873082 | 2021-11-01 | Dukes | Massachusetts | 25007 | 1864 | 0 |
1869901 | 1869901 | 2021-10-31 | Missaukee | Michigan | 26113 | 1864 | 38 |
1866652 | 1866652 | 2021-10-30 | Missaukee | Michigan | 26113 | 1864 | 38 |
1863403 | 1863403 | 2021-10-29 | Missaukee | Michigan | 26113 | 1864 | 38 |
1834326 | 1834326 | 2021-10-20 | Noxubee | Mississippi | 28103 | 1864 | 40 |
1830803 | 1830803 | 2021-10-19 | Knox | Maine | 23013 | 1864 | 12 |
1831951 | 1831951 | 2021-10-19 | Barranquitas | Puerto Rico | 72019 | 1864 | |
1809233 | 1809233 | 2021-10-12 | Hatillo | Puerto Rico | 72065 | 1864 | |
1805983 | 1805983 | 2021-10-11 | Hatillo | Puerto Rico | 72065 | 1864 | |
1801958 | 1801958 | 2021-10-10 | Ripley | Missouri | 29181 | 1864 | 23 |
1785236 | 1785236 | 2021-10-05 | Trigg | Kentucky | 21221 | 1864 | 21 |
1767646 | 1767646 | 2021-09-29 | Patrick | Virginia | 51141 | 1864 | 52 |
1755821 | 1755821 | 2021-09-26 | Jackson | Kansas | 20085 | 1864 | 18 |
1752573 | 1752573 | 2021-09-25 | Jackson | Kansas | 20085 | 1864 | 18 |
1749324 | 1749324 | 2021-09-24 | Jackson | Kansas | 20085 | 1864 | 18 |
1751495 | 1751495 | 2021-09-24 | Grant | West Virginia | 54023 | 1864 | 31 |
1748114 | 1748114 | 2021-09-23 | Grayson | Virginia | 51077 | 1864 | 43 |
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);