ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
461 rows where deaths = 382 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 38
- Ohio 34
- Georgia 32
- Pennsylvania 32
- Michigan 30
- Virginia 26
- California 23
- Florida 23
- Indiana 18
- North Carolina 18
- South Carolina 17
- Tennessee 13
- Wisconsin 12
- Colorado 11
- Illinois 11
- Arkansas 10
- Maryland 10
- Delaware 9
- Kentucky 9
- New York 9
- Alabama 8
- Iowa 7
- Mississippi 7
- Oklahoma 7
- Missouri 6
- Louisiana 5
- Nebraska 5
- Oregon 5
- Kansas 4
- Minnesota 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502808 | 2502808 | 2022-05-13 | Winnebago | Wisconsin | 55139 | 53045 | 382 |
2453724 | 2453724 | 2022-04-28 | Loudoun | Virginia | 51107 | 69639 | 382 |
2450468 | 2450468 | 2022-04-27 | Loudoun | Virginia | 51107 | 69527 | 382 |
2447211 | 2447211 | 2022-04-26 | Loudoun | Virginia | 51107 | 69428 | 382 |
2443956 | 2443956 | 2022-04-25 | Loudoun | Virginia | 51107 | 69344 | 382 |
2440700 | 2440700 | 2022-04-24 | Loudoun | Virginia | 51107 | 69110 | 382 |
2437444 | 2437444 | 2022-04-23 | Loudoun | Virginia | 51107 | 69110 | 382 |
2434188 | 2434188 | 2022-04-22 | Loudoun | Virginia | 51107 | 69110 | 382 |
2421842 | 2421842 | 2022-04-19 | Columbia | Georgia | 13073 | 35969 | 382 |
2418586 | 2418586 | 2022-04-18 | Columbia | Georgia | 13073 | 35969 | 382 |
2415330 | 2415330 | 2022-04-17 | Columbia | Georgia | 13073 | 35969 | 382 |
2415937 | 2415937 | 2022-04-17 | Daviess | Kentucky | 21059 | 31046 | 382 |
2412074 | 2412074 | 2022-04-16 | Columbia | Georgia | 13073 | 35969 | 382 |
2412681 | 2412681 | 2022-04-16 | Daviess | Kentucky | 21059 | 31046 | 382 |
2408818 | 2408818 | 2022-04-15 | Columbia | Georgia | 13073 | 35969 | 382 |
2409425 | 2409425 | 2022-04-15 | Daviess | Kentucky | 21059 | 31046 | 382 |
2406169 | 2406169 | 2022-04-14 | Daviess | Kentucky | 21059 | 31046 | 382 |
2402913 | 2402913 | 2022-04-13 | Daviess | Kentucky | 21059 | 31046 | 382 |
2399659 | 2399659 | 2022-04-12 | Daviess | Kentucky | 21059 | 31046 | 382 |
2396403 | 2396403 | 2022-04-11 | Daviess | Kentucky | 21059 | 31046 | 382 |
2381259 | 2381259 | 2022-04-06 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2378004 | 2378004 | 2022-04-05 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2372974 | 2372974 | 2022-04-04 | Unknown | Florida | 13875 | 382 | |
2374750 | 2374750 | 2022-04-04 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2371498 | 2371498 | 2022-04-03 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2368245 | 2368245 | 2022-04-02 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2364992 | 2364992 | 2022-04-01 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2361739 | 2361739 | 2022-03-31 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2353516 | 2353516 | 2022-03-29 | Forsyth | Georgia | 13117 | 55292 | 382 |
2335553 | 2335553 | 2022-03-23 | Wayne | North Carolina | 37191 | 29309 | 382 |
2314068 | 2314068 | 2022-03-17 | Lauderdale | Alabama | 1077 | 24010 | 382 |
2316002 | 2316002 | 2022-03-17 | New Hanover | North Carolina | 37129 | 49810 | 382 |
2312749 | 2312749 | 2022-03-16 | New Hanover | North Carolina | 37129 | 49731 | 382 |
2307962 | 2307962 | 2022-03-15 | Douglas | Georgia | 13097 | 34692 | 382 |
2304711 | 2304711 | 2022-03-14 | Douglas | Georgia | 13097 | 34684 | 382 |
2307286 | 2307286 | 2022-03-14 | Newport News city | Virginia | 51700 | 35972 | 382 |
2293727 | 2293727 | 2022-03-10 | Sumter | South Carolina | 45085 | 27718 | 382 |
2294152 | 2294152 | 2022-03-10 | Davis | Utah | 49011 | 99864 | 382 |
2290475 | 2290475 | 2022-03-09 | Sumter | South Carolina | 45085 | 27709 | 382 |
2287387 | 2287387 | 2022-03-08 | Williamson | Tennessee | 47187 | 61546 | 382 |
2284135 | 2284135 | 2022-03-07 | Williamson | Tennessee | 47187 | 61546 | 382 |
2280883 | 2280883 | 2022-03-06 | Williamson | Tennessee | 47187 | 61546 | 382 |
2277630 | 2277630 | 2022-03-05 | Williamson | Tennessee | 47187 | 61546 | 382 |
2274377 | 2274377 | 2022-03-04 | Williamson | Tennessee | 47187 | 61546 | 382 |
2268750 | 2268750 | 2022-03-03 | Boulder | Colorado | 8013 | 61390 | 382 |
2271124 | 2271124 | 2022-03-03 | Williamson | Tennessee | 47187 | 61546 | 382 |
2265497 | 2265497 | 2022-03-02 | Boulder | Colorado | 8013 | 61322 | 382 |
2267872 | 2267872 | 2022-03-02 | Williamson | Tennessee | 47187 | 61546 | 382 |
2263261 | 2263261 | 2022-03-01 | Eaton | Michigan | 26045 | 26378 | 382 |
2260010 | 2260010 | 2022-02-28 | Eaton | Michigan | 26045 | 26378 | 382 |
2256207 | 2256207 | 2022-02-27 | Clark | Indiana | 18019 | 30758 | 382 |
2256759 | 2256759 | 2022-02-27 | Eaton | Michigan | 26045 | 26347 | 382 |
2252956 | 2252956 | 2022-02-26 | Clark | Indiana | 18019 | 30758 | 382 |
2253508 | 2253508 | 2022-02-26 | Eaton | Michigan | 26045 | 26347 | 382 |
2249705 | 2249705 | 2022-02-25 | Clark | Indiana | 18019 | 30758 | 382 |
2250257 | 2250257 | 2022-02-25 | Eaton | Michigan | 26045 | 26347 | 382 |
2246454 | 2246454 | 2022-02-24 | Clark | Indiana | 18019 | 30742 | 382 |
2247006 | 2247006 | 2022-02-24 | Eaton | Michigan | 26045 | 26162 | 382 |
2243755 | 2243755 | 2022-02-23 | Eaton | Michigan | 26045 | 26162 | 382 |
2236440 | 2236440 | 2022-02-21 | Glynn | Georgia | 13127 | 22607 | 382 |
2233252 | 2233252 | 2022-02-20 | Spalding | Georgia | 13255 | 15640 | 382 |
2234670 | 2234670 | 2022-02-20 | Davidson | North Carolina | 37057 | 42290 | 382 |
2230001 | 2230001 | 2022-02-19 | Spalding | Georgia | 13255 | 15640 | 382 |
2231419 | 2231419 | 2022-02-19 | Davidson | North Carolina | 37057 | 42290 | 382 |
2226750 | 2226750 | 2022-02-18 | Spalding | Georgia | 13255 | 15640 | 382 |
2228168 | 2228168 | 2022-02-18 | Davidson | North Carolina | 37057 | 42290 | 382 |
2224917 | 2224917 | 2022-02-17 | Davidson | North Carolina | 37057 | 42227 | 382 |
2220942 | 2220942 | 2022-02-16 | Carroll | Maryland | 24013 | 20824 | 382 |
2217269 | 2217269 | 2022-02-15 | Vigo | Indiana | 18167 | 28517 | 382 |
2217691 | 2217691 | 2022-02-15 | Carroll | Maryland | 24013 | 20513 | 382 |
2214440 | 2214440 | 2022-02-14 | Carroll | Maryland | 24013 | 20503 | 382 |
2215875 | 2215875 | 2022-02-14 | Bowie | Texas | 48037 | 18999 | 382 |
2211188 | 2211188 | 2022-02-13 | Carroll | Maryland | 24013 | 20497 | 382 |
2212624 | 2212624 | 2022-02-13 | Bowie | Texas | 48037 | 18990 | 382 |
2207935 | 2207935 | 2022-02-12 | Carroll | Maryland | 24013 | 20452 | 382 |
2209371 | 2209371 | 2022-02-12 | Bowie | Texas | 48037 | 18974 | 382 |
2206118 | 2206118 | 2022-02-11 | Bowie | Texas | 48037 | 18882 | 382 |
2200765 | 2200765 | 2022-02-10 | Whitfield | Georgia | 13313 | 32958 | 382 |
2202287 | 2202287 | 2022-02-10 | Ashtabula | Ohio | 39007 | 19306 | 382 |
2202865 | 2202865 | 2022-02-10 | Bowie | Texas | 48037 | 18793 | 382 |
2202992 | 2202992 | 2022-02-10 | Liberty | Texas | 48291 | 17085 | 382 |
2203081 | 2203081 | 2022-02-10 | Victoria | Texas | 48469 | 18100 | 382 |
2197022 | 2197022 | 2022-02-09 | St. Clair | Alabama | 1115 | 24514 | 382 |
2197511 | 2197511 | 2022-02-09 | Whitfield | Georgia | 13313 | 32871 | 382 |
2198947 | 2198947 | 2022-02-09 | Randolph | North Carolina | 37151 | 34241 | 382 |
2199033 | 2199033 | 2022-02-09 | Ashtabula | Ohio | 39007 | 19264 | 382 |
2199699 | 2199699 | 2022-02-09 | Henderson | Texas | 48213 | 14948 | 382 |
2199738 | 2199738 | 2022-02-09 | Liberty | Texas | 48291 | 17035 | 382 |
2194211 | 2194211 | 2022-02-08 | Paulding | Georgia | 13223 | 37129 | 382 |
2195779 | 2195779 | 2022-02-08 | Ashtabula | Ohio | 39007 | 19203 | 382 |
2196359 | 2196359 | 2022-02-08 | Brazos | Texas | 48041 | 58439 | 382 |
2196484 | 2196484 | 2022-02-08 | Liberty | Texas | 48291 | 16997 | 382 |
2191687 | 2191687 | 2022-02-07 | Berkshire | Massachusetts | 25003 | 21440 | 382 |
2192525 | 2192525 | 2022-02-07 | Ashtabula | Ohio | 39007 | 19158 | 382 |
2193105 | 2193105 | 2022-02-07 | Brazos | Texas | 48041 | 58349 | 382 |
2193230 | 2193230 | 2022-02-07 | Liberty | Texas | 48291 | 16959 | 382 |
2189271 | 2189271 | 2022-02-06 | Ashtabula | Ohio | 39007 | 19151 | 382 |
2189851 | 2189851 | 2022-02-06 | Brazos | Texas | 48041 | 58286 | 382 |
2189976 | 2189976 | 2022-02-06 | Liberty | Texas | 48291 | 16925 | 382 |
2186018 | 2186018 | 2022-02-05 | Ashtabula | Ohio | 39007 | 19147 | 382 |
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);