ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
302 rows where deaths = 407 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 38
- Pennsylvania 36
- Georgia 22
- Michigan 17
- Louisiana 16
- California 13
- Illinois 13
- Indiana 13
- Tennessee 13
- Virginia 10
- Florida 9
- Alabama 8
- Mississippi 8
- South Carolina 8
- Arkansas 7
- Maryland 7
- Rhode Island 7
- New York 6
- North Carolina 6
- Connecticut 5
- Massachusetts 5
- Wisconsin 5
- Minnesota 4
- Nebraska 4
- New Jersey 4
- Arizona 3
- Missouri 3
- Ohio 3
- Utah 3
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466070 | 2466070 | 2022-05-02 | Somerset | Pennsylvania | 42111 | 18786 | 407 |
2462815 | 2462815 | 2022-05-01 | Somerset | Pennsylvania | 42111 | 18782 | 407 |
2459559 | 2459559 | 2022-04-30 | Somerset | Pennsylvania | 42111 | 18775 | 407 |
2456303 | 2456303 | 2022-04-29 | Somerset | Pennsylvania | 42111 | 18771 | 407 |
2453047 | 2453047 | 2022-04-28 | Somerset | Pennsylvania | 42111 | 18764 | 407 |
2401238 | 2401238 | 2022-04-12 | Sevier | Tennessee | 47155 | 30275 | 407 |
2397983 | 2397983 | 2022-04-11 | Sevier | Tennessee | 47155 | 30275 | 407 |
2398022 | 2398022 | 2022-04-11 | Brazos | Texas | 48041 | 60321 | 407 |
2394728 | 2394728 | 2022-04-10 | Sevier | Tennessee | 47155 | 30275 | 407 |
2394767 | 2394767 | 2022-04-10 | Brazos | Texas | 48041 | 60317 | 407 |
2391472 | 2391472 | 2022-04-09 | Sevier | Tennessee | 47155 | 30275 | 407 |
2391511 | 2391511 | 2022-04-09 | Brazos | Texas | 48041 | 60310 | 407 |
2388216 | 2388216 | 2022-04-08 | Sevier | Tennessee | 47155 | 30275 | 407 |
2388255 | 2388255 | 2022-04-08 | Brazos | Texas | 48041 | 60302 | 407 |
2384961 | 2384961 | 2022-04-07 | Sevier | Tennessee | 47155 | 30275 | 407 |
2385000 | 2385000 | 2022-04-07 | Brazos | Texas | 48041 | 60291 | 407 |
2379610 | 2379610 | 2022-04-06 | Spalding | Georgia | 13255 | 15838 | 407 |
2381706 | 2381706 | 2022-04-06 | Sevier | Tennessee | 47155 | 30275 | 407 |
2381745 | 2381745 | 2022-04-06 | Brazos | Texas | 48041 | 60275 | 407 |
2361417 | 2361417 | 2022-03-31 | Sandoval | New Mexico | 35043 | 33415 | 407 |
2301079 | 2301079 | 2022-03-13 | St. Clair | Alabama | 1115 | 25181 | 407 |
2297827 | 2297827 | 2022-03-12 | St. Clair | Alabama | 1115 | 25181 | 407 |
2294575 | 2294575 | 2022-03-11 | St. Clair | Alabama | 1115 | 25181 | 407 |
2291323 | 2291323 | 2022-03-10 | St. Clair | Alabama | 1115 | 25172 | 407 |
2292441 | 2292441 | 2022-03-10 | Terrebonne | Louisiana | 22109 | 30768 | 407 |
2294176 | 2294176 | 2022-03-10 | Weber | Utah | 49057 | 70714 | 407 |
2289189 | 2289189 | 2022-03-09 | Terrebonne | Louisiana | 22109 | 30765 | 407 |
2290924 | 2290924 | 2022-03-09 | Weber | Utah | 49057 | 70714 | 407 |
2285938 | 2285938 | 2022-03-08 | Terrebonne | Louisiana | 22109 | 30760 | 407 |
2285992 | 2285992 | 2022-03-08 | Berkshire | Massachusetts | 25003 | 22688 | 407 |
2282686 | 2282686 | 2022-03-07 | Terrebonne | Louisiana | 22109 | 30749 | 407 |
2283813 | 2283813 | 2022-03-07 | Lawrence | Pennsylvania | 42073 | 18793 | 407 |
2279433 | 2279433 | 2022-03-06 | Terrebonne | Louisiana | 22109 | 30739 | 407 |
2280561 | 2280561 | 2022-03-06 | Lawrence | Pennsylvania | 42073 | 18789 | 407 |
2276180 | 2276180 | 2022-03-05 | Terrebonne | Louisiana | 22109 | 30739 | 407 |
2277308 | 2277308 | 2022-03-05 | Lawrence | Pennsylvania | 42073 | 18780 | 407 |
2272927 | 2272927 | 2022-03-04 | Terrebonne | Louisiana | 22109 | 30739 | 407 |
2274055 | 2274055 | 2022-03-04 | Lawrence | Pennsylvania | 42073 | 18774 | 407 |
2269045 | 2269045 | 2022-03-03 | Whitfield | Georgia | 13313 | 33768 | 407 |
2265792 | 2265792 | 2022-03-02 | Whitfield | Georgia | 13313 | 33748 | 407 |
2262541 | 2262541 | 2022-03-01 | Whitfield | Georgia | 13313 | 33689 | 407 |
2259290 | 2259290 | 2022-02-28 | Whitfield | Georgia | 13313 | 33657 | 407 |
2261389 | 2261389 | 2022-02-28 | Bowie | Texas | 48037 | 19504 | 407 |
2256729 | 2256729 | 2022-02-27 | Hampshire | Massachusetts | 25015 | 26639 | 407 |
2258138 | 2258138 | 2022-02-27 | Bowie | Texas | 48037 | 19483 | 407 |
2253478 | 2253478 | 2022-02-26 | Hampshire | Massachusetts | 25015 | 26639 | 407 |
2254887 | 2254887 | 2022-02-26 | Bowie | Texas | 48037 | 19455 | 407 |
2254975 | 2254975 | 2022-02-26 | Henderson | Texas | 48213 | 15285 | 407 |
2250227 | 2250227 | 2022-02-25 | Hampshire | Massachusetts | 25015 | 26639 | 407 |
2219789 | 2219789 | 2022-02-16 | Shelby | Alabama | 1117 | 58281 | 407 |
2211703 | 2211703 | 2022-02-13 | Lancaster | Nebraska | 31109 | 72670 | 407 |
2212399 | 2212399 | 2022-02-13 | Aiken | South Carolina | 45003 | 39925 | 407 |
2208450 | 2208450 | 2022-02-12 | Lancaster | Nebraska | 31109 | 72670 | 407 |
2209146 | 2209146 | 2022-02-12 | Aiken | South Carolina | 45003 | 39925 | 407 |
2205197 | 2205197 | 2022-02-11 | Lancaster | Nebraska | 31109 | 72670 | 407 |
2205893 | 2205893 | 2022-02-11 | Aiken | South Carolina | 45003 | 39925 | 407 |
2202640 | 2202640 | 2022-02-10 | Aiken | South Carolina | 45003 | 39925 | 407 |
2193912 | 2193912 | 2022-02-08 | Kings | California | 6031 | 51328 | 407 |
2196666 | 2196666 | 2022-02-08 | Chesapeake city | Virginia | 51550 | 48236 | 407 |
2174917 | 2174917 | 2022-02-02 | Delaware | Indiana | 18035 | 23667 | 407 |
2164668 | 2164668 | 2022-01-30 | Solano | California | 6095 | 74199 | 407 |
2164832 | 2164832 | 2022-01-30 | Bartow | Georgia | 13015 | 27636 | 407 |
2161413 | 2161413 | 2022-01-29 | Solano | California | 6095 | 74199 | 407 |
2161577 | 2161577 | 2022-01-29 | Bartow | Georgia | 13015 | 27636 | 407 |
2158157 | 2158157 | 2022-01-28 | Solano | California | 6095 | 74199 | 407 |
2158321 | 2158321 | 2022-01-28 | Bartow | Georgia | 13015 | 27636 | 407 |
2153853 | 2153853 | 2022-01-26 | Dorchester | South Carolina | 45035 | 51069 | 407 |
2149466 | 2149466 | 2022-01-25 | Monroe | Michigan | 26115 | 35212 | 407 |
2146214 | 2146214 | 2022-01-24 | Monroe | Michigan | 26115 | 35212 | 407 |
2130638 | 2130638 | 2022-01-19 | Union | North Carolina | 37179 | 51323 | 407 |
2109793 | 2109793 | 2022-01-13 | McHenry | Illinois | 17111 | 55662 | 407 |
2106306 | 2106306 | 2022-01-12 | Coweta | Georgia | 13077 | 28206 | 407 |
2079239 | 2079239 | 2022-01-03 | Wilson | Tennessee | 47189 | 30835 | 407 |
2076179 | 2076179 | 2022-01-02 | Randall | Texas | 48381 | 28224 | 407 |
2071328 | 2071328 | 2022-01-01 | Harford | Maryland | 24025 | 26489 | 407 |
2072928 | 2072928 | 2022-01-01 | Randall | Texas | 48381 | 28224 | 407 |
2068077 | 2068077 | 2021-12-31 | Harford | Maryland | 24025 | 26489 | 407 |
2069677 | 2069677 | 2021-12-31 | Randall | Texas | 48381 | 28224 | 407 |
2064826 | 2064826 | 2021-12-30 | Harford | Maryland | 24025 | 26489 | 407 |
2066426 | 2066426 | 2021-12-30 | Randall | Texas | 48381 | 28224 | 407 |
2056171 | 2056171 | 2021-12-27 | Monroe | Pennsylvania | 42089 | 25125 | 407 |
2041310 | 2041310 | 2021-12-23 | Floyd | Georgia | 13115 | 19342 | 407 |
2037711 | 2037711 | 2021-12-22 | Coconino | Arizona | 4005 | 26862 | 407 |
2038060 | 2038060 | 2021-12-22 | Floyd | Georgia | 13115 | 19287 | 407 |
2038304 | 2038304 | 2021-12-22 | Tazewell | Illinois | 17179 | 25197 | 407 |
2034810 | 2034810 | 2021-12-21 | Floyd | Georgia | 13115 | 19242 | 407 |
2035054 | 2035054 | 2021-12-21 | Tazewell | Illinois | 17179 | 25015 | 407 |
2031425 | 2031425 | 2021-12-20 | Middlesex | Connecticut | 9007 | 17301 | 407 |
2031560 | 2031560 | 2021-12-20 | Floyd | Georgia | 13115 | 19221 | 407 |
2032589 | 2032589 | 2021-12-20 | Rankin | Mississippi | 28121 | 22990 | 407 |
2029338 | 2029338 | 2021-12-19 | Rankin | Mississippi | 28121 | 22891 | 407 |
2026087 | 2026087 | 2021-12-18 | Rankin | Mississippi | 28121 | 22891 | 407 |
2022836 | 2022836 | 2021-12-17 | Rankin | Mississippi | 28121 | 22891 | 407 |
2019585 | 2019585 | 2021-12-16 | Rankin | Mississippi | 28121 | 22801 | 407 |
2016335 | 2016335 | 2021-12-15 | Rankin | Mississippi | 28121 | 22765 | 407 |
2017272 | 2017272 | 2021-12-15 | Kent | Rhode Island | 44003 | 25600 | 407 |
2013084 | 2013084 | 2021-12-14 | Rankin | Mississippi | 28121 | 22740 | 407 |
2014022 | 2014022 | 2021-12-14 | Kent | Rhode Island | 44003 | 25600 | 407 |
2010771 | 2010771 | 2021-12-13 | Kent | Rhode Island | 44003 | 25600 | 407 |
2005242 | 2005242 | 2021-12-12 | Garland | Arkansas | 5051 | 16327 | 407 |
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);