ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
330 rows where deaths = 425 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 33
- Ohio 31
- Pennsylvania 27
- Texas 25
- Alabama 17
- Illinois 15
- New York 15
- Michigan 13
- Missouri 13
- Florida 12
- North Carolina 11
- Mississippi 10
- California 9
- Colorado 9
- Nebraska 9
- Connecticut 8
- South Carolina 8
- Virginia 8
- Louisiana 7
- Utah 7
- Indiana 6
- New Mexico 6
- Tennessee 5
- Washington 4
- Minnesota 3
- West Virginia 3
- Arizona 2
- Kansas 2
- Massachusetts 2
- New Jersey 2
- …
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 2426744 | 2426744 | 2022-04-20 | Ashtabula | Ohio | 39007 | 19872 | 425 |
| 2423488 | 2423488 | 2022-04-19 | Ashtabula | Ohio | 39007 | 19872 | 425 |
| 2420231 | 2420231 | 2022-04-18 | Ashtabula | Ohio | 39007 | 19872 | 425 |
| 2416976 | 2416976 | 2022-04-17 | Ashtabula | Ohio | 39007 | 19872 | 425 |
| 2413720 | 2413720 | 2022-04-16 | Ashtabula | Ohio | 39007 | 19872 | 425 |
| 2410464 | 2410464 | 2022-04-15 | Ashtabula | Ohio | 39007 | 19872 | 425 |
| 2407208 | 2407208 | 2022-04-14 | Ashtabula | Ohio | 39007 | 19872 | 425 |
| 2403952 | 2403952 | 2022-04-13 | Ashtabula | Ohio | 39007 | 19820 | 425 |
| 2400697 | 2400697 | 2022-04-12 | Ashtabula | Ohio | 39007 | 19820 | 425 |
| 2397442 | 2397442 | 2022-04-11 | Ashtabula | Ohio | 39007 | 19820 | 425 |
| 2394187 | 2394187 | 2022-04-10 | Ashtabula | Ohio | 39007 | 19820 | 425 |
| 2390931 | 2390931 | 2022-04-09 | Ashtabula | Ohio | 39007 | 19820 | 425 |
| 2387675 | 2387675 | 2022-04-08 | Ashtabula | Ohio | 39007 | 19820 | 425 |
| 2384420 | 2384420 | 2022-04-07 | Ashtabula | Ohio | 39007 | 19820 | 425 |
| 2376340 | 2376340 | 2022-04-05 | Paulding | Georgia | 13223 | 38045 | 425 |
| 2353606 | 2353606 | 2022-03-29 | Walton | Georgia | 13297 | 21948 | 425 |
| 2350354 | 2350354 | 2022-03-28 | Walton | Georgia | 13297 | 21954 | 425 |
| 2350500 | 2350500 | 2022-03-28 | Sangamon | Illinois | 17167 | 54688 | 425 |
| 2347101 | 2347101 | 2022-03-27 | Walton | Georgia | 13297 | 21958 | 425 |
| 2347247 | 2347247 | 2022-03-27 | Sangamon | Illinois | 17167 | 54664 | 425 |
| 2347850 | 2347850 | 2022-03-27 | Lapeer | Michigan | 26087 | 20757 | 425 |
| 2343848 | 2343848 | 2022-03-26 | Walton | Georgia | 13297 | 21958 | 425 |
| 2343994 | 2343994 | 2022-03-26 | Sangamon | Illinois | 17167 | 54664 | 425 |
| 2344597 | 2344597 | 2022-03-26 | Lapeer | Michigan | 26087 | 20757 | 425 |
| 2340595 | 2340595 | 2022-03-25 | Walton | Georgia | 13297 | 21958 | 425 |
| 2340741 | 2340741 | 2022-03-25 | Sangamon | Illinois | 17167 | 54664 | 425 |
| 2341344 | 2341344 | 2022-03-25 | Lapeer | Michigan | 26087 | 20757 | 425 |
| 2337342 | 2337342 | 2022-03-24 | Walton | Georgia | 13297 | 21961 | 425 |
| 2337488 | 2337488 | 2022-03-24 | Sangamon | Illinois | 17167 | 54650 | 425 |
| 2334088 | 2334088 | 2022-03-23 | Walton | Georgia | 13297 | 21964 | 425 |
| 2334234 | 2334234 | 2022-03-23 | Sangamon | Illinois | 17167 | 54643 | 425 |
| 2330834 | 2330834 | 2022-03-22 | Walton | Georgia | 13297 | 21962 | 425 |
| 2330980 | 2330980 | 2022-03-22 | Sangamon | Illinois | 17167 | 54640 | 425 |
| 2327582 | 2327582 | 2022-03-21 | Walton | Georgia | 13297 | 21969 | 425 |
| 2309283 | 2309283 | 2022-03-15 | Unknown | Nebraska | 2721 | 425 | |
| 2293024 | 2293024 | 2022-03-10 | Unknown | Nebraska | 4100 | 425 | |
| 2286487 | 2286487 | 2022-03-08 | Lancaster | Nebraska | 31109 | 77671 | 425 |
| 2282007 | 2282007 | 2022-03-07 | Newton | Georgia | 13217 | 24393 | 425 |
| 2283235 | 2283235 | 2022-03-07 | Lancaster | Nebraska | 31109 | 77655 | 425 |
| 2279982 | 2279982 | 2022-03-06 | Lancaster | Nebraska | 31109 | 77609 | 425 |
| 2276729 | 2276729 | 2022-03-05 | Lancaster | Nebraska | 31109 | 77609 | 425 |
| 2273476 | 2273476 | 2022-03-04 | Lancaster | Nebraska | 31109 | 77609 | 425 |
| 2270224 | 2270224 | 2022-03-03 | Lancaster | Nebraska | 31109 | 77574 | 425 |
| 2265509 | 2265509 | 2022-03-02 | Douglas | Colorado | 8035 | 76379 | 425 |
| 2266971 | 2266971 | 2022-03-02 | Lancaster | Nebraska | 31109 | 77547 | 425 |
| 2262258 | 2262258 | 2022-03-01 | Douglas | Colorado | 8035 | 76379 | 425 |
| 2259007 | 2259007 | 2022-02-28 | Douglas | Colorado | 8035 | 76304 | 425 |
| 2260893 | 2260893 | 2022-02-28 | Wayne | Ohio | 39169 | 23005 | 425 |
| 2261652 | 2261652 | 2022-02-28 | Washington | Utah | 49053 | 44487 | 425 |
| 2255756 | 2255756 | 2022-02-27 | Douglas | Colorado | 8035 | 76277 | 425 |
| 2257642 | 2257642 | 2022-02-27 | Wayne | Ohio | 39169 | 23002 | 425 |
| 2258401 | 2258401 | 2022-02-27 | Washington | Utah | 49053 | 44444 | 425 |
| 2254391 | 2254391 | 2022-02-26 | Wayne | Ohio | 39169 | 22999 | 425 |
| 2255052 | 2255052 | 2022-02-26 | Parker | Texas | 48367 | 33840 | 425 |
| 2255150 | 2255150 | 2022-02-26 | Washington | Utah | 49053 | 44444 | 425 |
| 2251140 | 2251140 | 2022-02-25 | Wayne | Ohio | 39169 | 22994 | 425 |
| 2251899 | 2251899 | 2022-02-25 | Washington | Utah | 49053 | 44444 | 425 |
| 2247870 | 2247870 | 2022-02-24 | Portage | Ohio | 39133 | 33737 | 425 |
| 2248648 | 2248648 | 2022-02-24 | Washington | Utah | 49053 | 44421 | 425 |
| 2242723 | 2242723 | 2022-02-23 | Solano | California | 6095 | 85164 | 425 |
| 2244443 | 2244443 | 2022-02-23 | Iredell | North Carolina | 37097 | 47533 | 425 |
| 2244619 | 2244619 | 2022-02-23 | Portage | Ohio | 39133 | 33713 | 425 |
| 2245397 | 2245397 | 2022-02-23 | Washington | Utah | 49053 | 44379 | 425 |
| 2239472 | 2239472 | 2022-02-22 | Solano | California | 6095 | 85102 | 425 |
| 2241368 | 2241368 | 2022-02-22 | Portage | Ohio | 39133 | 33692 | 425 |
| 2223209 | 2223209 | 2022-02-17 | San Luis Obispo | California | 6079 | 54295 | 425 |
| 2213880 | 2213880 | 2022-02-14 | LaSalle | Illinois | 17099 | 28220 | 425 |
| 2216184 | 2216184 | 2022-02-14 | Chesapeake city | Virginia | 51550 | 48595 | 425 |
| 2203255 | 2203255 | 2022-02-10 | Richmond city | Virginia | 51760 | 42784 | 425 |
| 2194022 | 2194022 | 2022-02-08 | Litchfield | Connecticut | 9005 | 30411 | 425 |
| 2190768 | 2190768 | 2022-02-07 | Litchfield | Connecticut | 9005 | 30349 | 425 |
| 2187515 | 2187515 | 2022-02-06 | Litchfield | Connecticut | 9005 | 30248 | 425 |
| 2184262 | 2184262 | 2022-02-05 | Litchfield | Connecticut | 9005 | 30248 | 425 |
| 2181010 | 2181010 | 2022-02-04 | Litchfield | Connecticut | 9005 | 30248 | 425 |
| 2176191 | 2176191 | 2022-02-02 | Union | North Carolina | 37179 | 58141 | 425 |
| 2172938 | 2172938 | 2022-02-01 | Union | North Carolina | 37179 | 57841 | 425 |
| 2169768 | 2169768 | 2022-01-31 | Columbiana | Ohio | 39029 | 23527 | 425 |
| 2166513 | 2166513 | 2022-01-30 | Columbiana | Ohio | 39029 | 23492 | 425 |
| 2163258 | 2163258 | 2022-01-29 | Columbiana | Ohio | 39029 | 23454 | 425 |
| 2160003 | 2160003 | 2022-01-28 | Columbiana | Ohio | 39029 | 23393 | 425 |
| 2155117 | 2155117 | 2022-01-27 | Floyd | Georgia | 13115 | 25328 | 425 |
| 2150982 | 2150982 | 2022-01-25 | Randall | Texas | 48381 | 34521 | 425 |
| 2147730 | 2147730 | 2022-01-24 | Randall | Texas | 48381 | 33798 | 425 |
| 2144476 | 2144476 | 2022-01-23 | Randall | Texas | 48381 | 33798 | 425 |
| 2141221 | 2141221 | 2022-01-22 | Randall | Texas | 48381 | 33798 | 425 |
| 2137965 | 2137965 | 2022-01-21 | Randall | Texas | 48381 | 33798 | 425 |
| 2133024 | 2133024 | 2022-01-20 | Bossier | Louisiana | 22015 | 31401 | 425 |
| 2133305 | 2133305 | 2022-01-20 | Washington | Minnesota | 27163 | 54646 | 425 |
| 2134711 | 2134711 | 2022-01-20 | Randall | Texas | 48381 | 33340 | 425 |
| 2129771 | 2129771 | 2022-01-19 | Bossier | Louisiana | 22015 | 30918 | 425 |
| 2129792 | 2129792 | 2022-01-19 | Lafayette | Louisiana | 22055 | 51668 | 425 |
| 2131459 | 2131459 | 2022-01-19 | Randall | Texas | 48381 | 32789 | 425 |
| 2111920 | 2111920 | 2022-01-13 | Midland | Texas | 48329 | 30996 | 425 |
| 2102543 | 2102543 | 2022-01-10 | Dane | Wisconsin | 55025 | 77227 | 425 |
| 2088679 | 2088679 | 2022-01-06 | Monroe | Pennsylvania | 42089 | 28355 | 425 |
| 2076664 | 2076664 | 2022-01-03 | Morgan | Alabama | 1103 | 24195 | 425 |
| 2073413 | 2073413 | 2022-01-02 | Morgan | Alabama | 1103 | 24089 | 425 |
| 2070162 | 2070162 | 2022-01-01 | Morgan | Alabama | 1103 | 23831 | 425 |
| 2066911 | 2066911 | 2021-12-31 | Morgan | Alabama | 1103 | 23831 | 425 |
| 2063661 | 2063661 | 2021-12-30 | Morgan | Alabama | 1103 | 23661 | 425 |
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);