ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
327 rows where deaths = 439 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: state, county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500121 | 2500121 | 2022-05-13 | Whitfield | Georgia | 13313 | 34132 | 439 |
2501729 | 2501729 | 2022-05-13 | Wayne | Ohio | 39169 | 23392 | 439 |
2496863 | 2496863 | 2022-05-12 | Whitfield | Georgia | 13313 | 34132 | 439 |
2498471 | 2498471 | 2022-05-12 | Wayne | Ohio | 39169 | 23392 | 439 |
2493605 | 2493605 | 2022-05-11 | Whitfield | Georgia | 13313 | 34132 | 439 |
2492341 | 2492341 | 2022-05-10 | Blount | Tennessee | 47009 | 39251 | 439 |
2489083 | 2489083 | 2022-05-09 | Blount | Tennessee | 47009 | 39251 | 439 |
2485826 | 2485826 | 2022-05-08 | Blount | Tennessee | 47009 | 39251 | 439 |
2482568 | 2482568 | 2022-05-07 | Blount | Tennessee | 47009 | 39251 | 439 |
2479310 | 2479310 | 2022-05-06 | Blount | Tennessee | 47009 | 39251 | 439 |
2476052 | 2476052 | 2022-05-05 | Blount | Tennessee | 47009 | 39251 | 439 |
2472795 | 2472795 | 2022-05-04 | Blount | Tennessee | 47009 | 39251 | 439 |
2468960 | 2468960 | 2022-05-03 | Johnston | North Carolina | 37101 | 59729 | 439 |
2465704 | 2465704 | 2022-05-02 | Johnston | North Carolina | 37101 | 59729 | 439 |
2462449 | 2462449 | 2022-05-01 | Johnston | North Carolina | 37101 | 59729 | 439 |
2459193 | 2459193 | 2022-04-30 | Johnston | North Carolina | 37101 | 59729 | 439 |
2455937 | 2455937 | 2022-04-29 | Johnston | North Carolina | 37101 | 59729 | 439 |
2452681 | 2452681 | 2022-04-28 | Johnston | North Carolina | 37101 | 59729 | 439 |
2448114 | 2448114 | 2022-04-27 | LaSalle | Illinois | 17099 | 29159 | 439 |
2449425 | 2449425 | 2022-04-27 | Johnston | North Carolina | 37101 | 59729 | 439 |
2444858 | 2444858 | 2022-04-26 | LaSalle | Illinois | 17099 | 29146 | 439 |
2446168 | 2446168 | 2022-04-26 | Johnston | North Carolina | 37101 | 59537 | 439 |
2441602 | 2441602 | 2022-04-25 | LaSalle | Illinois | 17099 | 29131 | 439 |
2442913 | 2442913 | 2022-04-25 | Johnston | North Carolina | 37101 | 59537 | 439 |
2438346 | 2438346 | 2022-04-24 | LaSalle | Illinois | 17099 | 29098 | 439 |
2439657 | 2439657 | 2022-04-24 | Johnston | North Carolina | 37101 | 59537 | 439 |
2435090 | 2435090 | 2022-04-23 | LaSalle | Illinois | 17099 | 29098 | 439 |
2436401 | 2436401 | 2022-04-23 | Johnston | North Carolina | 37101 | 59537 | 439 |
2431834 | 2431834 | 2022-04-22 | LaSalle | Illinois | 17099 | 29098 | 439 |
2433145 | 2433145 | 2022-04-22 | Johnston | North Carolina | 37101 | 59537 | 439 |
2428578 | 2428578 | 2022-04-21 | LaSalle | Illinois | 17099 | 29083 | 439 |
2429889 | 2429889 | 2022-04-21 | Johnston | North Carolina | 37101 | 59537 | 439 |
2425322 | 2425322 | 2022-04-20 | LaSalle | Illinois | 17099 | 29064 | 439 |
2426633 | 2426633 | 2022-04-20 | Johnston | North Carolina | 37101 | 59537 | 439 |
2422066 | 2422066 | 2022-04-19 | LaSalle | Illinois | 17099 | 29042 | 439 |
2418810 | 2418810 | 2022-04-18 | LaSalle | Illinois | 17099 | 29033 | 439 |
2415554 | 2415554 | 2022-04-17 | LaSalle | Illinois | 17099 | 29012 | 439 |
2412298 | 2412298 | 2022-04-16 | LaSalle | Illinois | 17099 | 29012 | 439 |
2409042 | 2409042 | 2022-04-15 | LaSalle | Illinois | 17099 | 29012 | 439 |
2405786 | 2405786 | 2022-04-14 | LaSalle | Illinois | 17099 | 28998 | 439 |
2402531 | 2402531 | 2022-04-13 | LaSalle | Illinois | 17099 | 28985 | 439 |
2399276 | 2399276 | 2022-04-12 | LaSalle | Illinois | 17099 | 28977 | 439 |
2359973 | 2359973 | 2022-03-31 | Bartow | Georgia | 13015 | 29194 | 439 |
2359987 | 2359987 | 2022-03-31 | Carroll | Georgia | 13045 | 23720 | 439 |
2350538 | 2350538 | 2022-03-28 | Delaware | Indiana | 18035 | 24802 | 439 |
2347285 | 2347285 | 2022-03-27 | Delaware | Indiana | 18035 | 24791 | 439 |
2344032 | 2344032 | 2022-03-26 | Delaware | Indiana | 18035 | 24791 | 439 |
2340779 | 2340779 | 2022-03-25 | Delaware | Indiana | 18035 | 24791 | 439 |
2336861 | 2336861 | 2022-03-24 | Shelby | Alabama | 1117 | 60400 | 439 |
2333607 | 2333607 | 2022-03-23 | Shelby | Alabama | 1117 | 60392 | 439 |
2293220 | 2293220 | 2022-03-10 | Iredell | North Carolina | 37097 | 47976 | 439 |
2293396 | 2293396 | 2022-03-10 | Portage | Ohio | 39133 | 33956 | 439 |
2290144 | 2290144 | 2022-03-09 | Portage | Ohio | 39133 | 33944 | 439 |
2286892 | 2286892 | 2022-03-08 | Portage | Ohio | 39133 | 33925 | 439 |
2258970 | 2258970 | 2022-02-28 | San Luis Obispo | California | 6079 | 55200 | 439 |
2256938 | 2256938 | 2022-02-27 | Jackson | Mississippi | 28059 | 36680 | 439 |
2253687 | 2253687 | 2022-02-26 | Jackson | Mississippi | 28059 | 36680 | 439 |
2250436 | 2250436 | 2022-02-25 | Jackson | Mississippi | 28059 | 36680 | 439 |
2235770 | 2235770 | 2022-02-20 | Richmond city | Virginia | 51760 | 43235 | 439 |
2232519 | 2232519 | 2022-02-19 | Richmond city | Virginia | 51760 | 43235 | 439 |
2229268 | 2229268 | 2022-02-18 | Richmond city | Virginia | 51760 | 43235 | 439 |
2219102 | 2219102 | 2022-02-15 | Washington | Tennessee | 47179 | 34879 | 439 |
2215851 | 2215851 | 2022-02-14 | Washington | Tennessee | 47179 | 34879 | 439 |
2211131 | 2211131 | 2022-02-13 | Livingston | Louisiana | 22063 | 36517 | 439 |
2212600 | 2212600 | 2022-02-13 | Washington | Tennessee | 47179 | 34879 | 439 |
2207878 | 2207878 | 2022-02-12 | Livingston | Louisiana | 22063 | 36517 | 439 |
2209347 | 2209347 | 2022-02-12 | Washington | Tennessee | 47179 | 34879 | 439 |
2204625 | 2204625 | 2022-02-11 | Livingston | Louisiana | 22063 | 36517 | 439 |
2206094 | 2206094 | 2022-02-11 | Washington | Tennessee | 47179 | 34879 | 439 |
2200647 | 2200647 | 2022-02-10 | Coweta | Georgia | 13077 | 32405 | 439 |
2201372 | 2201372 | 2022-02-10 | Livingston | Louisiana | 22063 | 36310 | 439 |
2201520 | 2201520 | 2022-02-10 | Monroe | Michigan | 26115 | 37005 | 439 |
2202215 | 2202215 | 2022-02-10 | Union | North Carolina | 37179 | 59575 | 439 |
2202841 | 2202841 | 2022-02-10 | Washington | Tennessee | 47179 | 34879 | 439 |
2198266 | 2198266 | 2022-02-09 | Monroe | Michigan | 26115 | 37005 | 439 |
2199587 | 2199587 | 2022-02-09 | Washington | Tennessee | 47179 | 34879 | 439 |
2189449 | 2189449 | 2022-02-06 | Jackson | Oregon | 41029 | 39418 | 439 |
2186196 | 2186196 | 2022-02-05 | Jackson | Oregon | 41029 | 39418 | 439 |
2182944 | 2182944 | 2022-02-04 | Jackson | Oregon | 41029 | 39418 | 439 |
2177895 | 2177895 | 2022-02-03 | Floyd | Georgia | 13115 | 26106 | 439 |
2179692 | 2179692 | 2022-02-03 | Jackson | Oregon | 41029 | 39175 | 439 |
2176441 | 2176441 | 2022-02-02 | Jackson | Oregon | 41029 | 38881 | 439 |
2172092 | 2172092 | 2022-02-01 | Lafayette | Louisiana | 22055 | 59001 | 439 |
2172418 | 2172418 | 2022-02-01 | Rankin | Mississippi | 28121 | 33560 | 439 |
2169099 | 2169099 | 2022-01-31 | Washington | Minnesota | 27163 | 61357 | 439 |
2164900 | 2164900 | 2022-01-30 | Houston | Georgia | 13153 | 36898 | 439 |
2161645 | 2161645 | 2022-01-29 | Houston | Georgia | 13153 | 36898 | 439 |
2158389 | 2158389 | 2022-01-28 | Houston | Georgia | 13153 | 36898 | 439 |
2156762 | 2156762 | 2022-01-27 | Greene | Ohio | 39057 | 35039 | 439 |
2153509 | 2153509 | 2022-01-26 | Greene | Ohio | 39057 | 34807 | 439 |
2154046 | 2154046 | 2022-01-26 | Angelina | Texas | 48005 | 14514 | 439 |
2150257 | 2150257 | 2022-01-25 | Greene | Ohio | 39057 | 34381 | 439 |
2148106 | 2148106 | 2022-01-24 | Marathon | Wisconsin | 55073 | 36023 | 439 |
2135064 | 2135064 | 2022-01-20 | Dane | Wisconsin | 55025 | 106363 | 439 |
2085630 | 2085630 | 2022-01-05 | Minnehaha | South Dakota | 46099 | 45550 | 439 |
2075211 | 2075211 | 2022-01-02 | Albany | New York | 36001 | 42229 | 439 |
2071960 | 2071960 | 2022-01-01 | Albany | New York | 36001 | 41708 | 439 |
2068709 | 2068709 | 2021-12-31 | Albany | New York | 36001 | 41133 | 439 |
2065458 | 2065458 | 2021-12-30 | Albany | New York | 36001 | 40432 | 439 |
2061096 | 2061096 | 2021-12-29 | Hendricks | Indiana | 18063 | 28972 | 439 |
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);