ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
368 rows where deaths = 442 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 40
- Texas 39
- New Jersey 34
- Indiana 30
- Pennsylvania 18
- Georgia 17
- New York 17
- Ohio 16
- Louisiana 13
- Florida 12
- Illinois 12
- California 11
- Missouri 11
- Tennessee 10
- Washington 10
- North Carolina 9
- Utah 9
- Alabama 7
- Kentucky 6
- Arizona 5
- Minnesota 5
- Oregon 5
- Virginia 5
- South Carolina 4
- Colorado 3
- Connecticut 3
- Maryland 3
- Wisconsin 3
- Arkansas 2
- Idaho 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500225 | 2500225 | 2022-05-13 | LaSalle | Illinois | 17099 | 29734 | 442 |
2415626 | 2415626 | 2022-04-17 | Delaware | Indiana | 18035 | 24833 | 442 |
2412370 | 2412370 | 2022-04-16 | Delaware | Indiana | 18035 | 24833 | 442 |
2409114 | 2409114 | 2022-04-15 | Delaware | Indiana | 18035 | 24833 | 442 |
2405199 | 2405199 | 2022-04-14 | Walker | Alabama | 1127 | 18657 | 442 |
2405858 | 2405858 | 2022-04-14 | Delaware | Indiana | 18035 | 24833 | 442 |
2402279 | 2402279 | 2022-04-13 | Bartow | Georgia | 13015 | 29317 | 442 |
2402603 | 2402603 | 2022-04-13 | Delaware | Indiana | 18035 | 24833 | 442 |
2399024 | 2399024 | 2022-04-12 | Bartow | Georgia | 13015 | 29308 | 442 |
2399918 | 2399918 | 2022-04-12 | Livingston | Michigan | 26093 | 46089 | 442 |
2395769 | 2395769 | 2022-04-11 | Bartow | Georgia | 13015 | 29294 | 442 |
2396662 | 2396662 | 2022-04-11 | Livingston | Michigan | 26093 | 46089 | 442 |
2393407 | 2393407 | 2022-04-10 | Livingston | Michigan | 26093 | 46089 | 442 |
2390151 | 2390151 | 2022-04-09 | Livingston | Michigan | 26093 | 46089 | 442 |
2386895 | 2386895 | 2022-04-08 | Livingston | Michigan | 26093 | 46089 | 442 |
2383640 | 2383640 | 2022-04-07 | Livingston | Michigan | 26093 | 46089 | 442 |
2380385 | 2380385 | 2022-04-06 | Livingston | Michigan | 26093 | 46089 | 442 |
2376252 | 2376252 | 2022-04-05 | Carroll | Georgia | 13045 | 23741 | 442 |
2377130 | 2377130 | 2022-04-05 | Livingston | Michigan | 26093 | 46001 | 442 |
2373878 | 2373878 | 2022-04-04 | Livingston | Michigan | 26093 | 46001 | 442 |
2370625 | 2370625 | 2022-04-03 | Livingston | Michigan | 26093 | 46001 | 442 |
2367372 | 2367372 | 2022-04-02 | Livingston | Michigan | 26093 | 46001 | 442 |
2364119 | 2364119 | 2022-04-01 | Livingston | Michigan | 26093 | 46001 | 442 |
2358454 | 2358454 | 2022-03-30 | Portage | Ohio | 39133 | 34056 | 442 |
2354358 | 2354358 | 2022-03-29 | Livingston | Michigan | 26093 | 45945 | 442 |
2355200 | 2355200 | 2022-03-29 | Portage | Ohio | 39133 | 34056 | 442 |
2350313 | 2350313 | 2022-03-28 | Newton | Georgia | 13217 | 24478 | 442 |
2351106 | 2351106 | 2022-03-28 | Livingston | Michigan | 26093 | 45945 | 442 |
2351947 | 2351947 | 2022-03-28 | Portage | Ohio | 39133 | 34056 | 442 |
2347060 | 2347060 | 2022-03-27 | Newton | Georgia | 13217 | 24466 | 442 |
2348695 | 2348695 | 2022-03-27 | Portage | Ohio | 39133 | 34056 | 442 |
2343807 | 2343807 | 2022-03-26 | Newton | Georgia | 13217 | 24466 | 442 |
2345442 | 2345442 | 2022-03-26 | Portage | Ohio | 39133 | 34056 | 442 |
2340554 | 2340554 | 2022-03-25 | Newton | Georgia | 13217 | 24466 | 442 |
2342189 | 2342189 | 2022-03-25 | Portage | Ohio | 39133 | 34056 | 442 |
2337006 | 2337006 | 2022-03-24 | Kings | California | 6031 | 55005 | 442 |
2337301 | 2337301 | 2022-03-24 | Newton | Georgia | 13217 | 24461 | 442 |
2338094 | 2338094 | 2022-03-24 | Livingston | Michigan | 26093 | 45867 | 442 |
2338936 | 2338936 | 2022-03-24 | Portage | Ohio | 39133 | 34056 | 442 |
2333752 | 2333752 | 2022-03-23 | Kings | California | 6031 | 54984 | 442 |
2334840 | 2334840 | 2022-03-23 | Livingston | Michigan | 26093 | 45867 | 442 |
2335506 | 2335506 | 2022-03-23 | Iredell | North Carolina | 37097 | 48234 | 442 |
2327782 | 2327782 | 2022-03-21 | Howard | Indiana | 18067 | 25377 | 442 |
2324529 | 2324529 | 2022-03-20 | Howard | Indiana | 18067 | 25376 | 442 |
2321275 | 2321275 | 2022-03-19 | Howard | Indiana | 18067 | 25376 | 442 |
2318021 | 2318021 | 2022-03-18 | Howard | Indiana | 18067 | 25376 | 442 |
2316940 | 2316940 | 2022-03-17 | Washington | Utah | 49053 | 44624 | 442 |
2313589 | 2313589 | 2022-03-16 | Parker | Texas | 48367 | 34103 | 442 |
2313687 | 2313687 | 2022-03-16 | Washington | Utah | 49053 | 44620 | 442 |
2310434 | 2310434 | 2022-03-15 | Washington | Utah | 49053 | 44618 | 442 |
2307181 | 2307181 | 2022-03-14 | Washington | Utah | 49053 | 44594 | 442 |
2303930 | 2303930 | 2022-03-13 | Washington | Utah | 49053 | 44594 | 442 |
2300678 | 2300678 | 2022-03-12 | Washington | Utah | 49053 | 44594 | 442 |
2297426 | 2297426 | 2022-03-11 | Washington | Utah | 49053 | 44594 | 442 |
2266691 | 2266691 | 2022-03-02 | Jackson | Mississippi | 28059 | 36735 | 442 |
2247498 | 2247498 | 2022-02-24 | Unknown | Nebraska | 1684 | 442 | |
2220885 | 2220885 | 2022-02-16 | Livingston | Louisiana | 22063 | 36707 | 442 |
2217782 | 2217782 | 2022-02-15 | Monroe | Michigan | 26115 | 37214 | 442 |
2214531 | 2214531 | 2022-02-14 | Monroe | Michigan | 26115 | 37214 | 442 |
2211279 | 2211279 | 2022-02-13 | Monroe | Michigan | 26115 | 37117 | 442 |
2208026 | 2208026 | 2022-02-12 | Monroe | Michigan | 26115 | 37117 | 442 |
2204773 | 2204773 | 2022-02-11 | Monroe | Michigan | 26115 | 37117 | 442 |
2198776 | 2198776 | 2022-02-09 | Sussex | New Jersey | 34037 | 32924 | 442 |
2195522 | 2195522 | 2022-02-08 | Sussex | New Jersey | 34037 | 32888 | 442 |
2180796 | 2180796 | 2022-02-04 | Coconino | Arizona | 4005 | 41214 | 442 |
2177623 | 2177623 | 2022-02-03 | Sebastian | Arkansas | 5131 | 31574 | 442 |
2180264 | 2180264 | 2022-02-03 | Randall | Texas | 48381 | 36335 | 442 |
2174661 | 2174661 | 2022-02-02 | Houston | Georgia | 13153 | 37718 | 442 |
2169782 | 2169782 | 2022-01-31 | Greene | Ohio | 39057 | 35530 | 442 |
2166527 | 2166527 | 2022-01-30 | Greene | Ohio | 39057 | 35464 | 442 |
2167227 | 2167227 | 2022-01-30 | Midland | Texas | 48329 | 35051 | 442 |
2163272 | 2163272 | 2022-01-29 | Greene | Ohio | 39057 | 35363 | 442 |
2163810 | 2163810 | 2022-01-29 | Angelina | Texas | 48005 | 14702 | 442 |
2160017 | 2160017 | 2022-01-28 | Greene | Ohio | 39057 | 35177 | 442 |
2160555 | 2160555 | 2022-01-28 | Angelina | Texas | 48005 | 14629 | 442 |
2157864 | 2157864 | 2022-01-27 | Marathon | Wisconsin | 55073 | 36793 | 442 |
2154148 | 2154148 | 2022-01-26 | Hays | Texas | 48209 | 51873 | 442 |
2154611 | 2154611 | 2022-01-26 | Marathon | Wisconsin | 55073 | 36507 | 442 |
2148602 | 2148602 | 2022-01-25 | Dougherty | Georgia | 13095 | 17335 | 442 |
2151358 | 2151358 | 2022-01-25 | Marathon | Wisconsin | 55073 | 36232 | 442 |
2125422 | 2125422 | 2022-01-18 | Houston | Alabama | 1069 | 21304 | 442 |
2122170 | 2122170 | 2022-01-17 | Houston | Alabama | 1069 | 21197 | 442 |
2118918 | 2118918 | 2022-01-16 | Houston | Alabama | 1069 | 21077 | 442 |
2120098 | 2120098 | 2022-01-16 | Frederick | Maryland | 24021 | 40101 | 442 |
2114692 | 2114692 | 2022-01-14 | Monroe | Pennsylvania | 42089 | 32536 | 442 |
2110454 | 2110454 | 2022-01-13 | Washtenaw | Michigan | 26161 | 58416 | 442 |
2081714 | 2081714 | 2022-01-04 | Albany | New York | 36001 | 42841 | 442 |
2075626 | 2075626 | 2022-01-02 | Washington | Oregon | 41067 | 45682 | 442 |
2072375 | 2072375 | 2022-01-01 | Washington | Oregon | 41067 | 45682 | 442 |
2069124 | 2069124 | 2021-12-31 | Washington | Oregon | 41067 | 45682 | 442 |
2065873 | 2065873 | 2021-12-30 | Washington | Oregon | 41067 | 45682 | 442 |
2062666 | 2062666 | 2021-12-29 | Lycoming | Pennsylvania | 42081 | 21554 | 442 |
2057784 | 2057784 | 2021-12-28 | Peoria | Illinois | 17143 | 33570 | 442 |
2058543 | 2058543 | 2021-12-28 | DeSoto | Mississippi | 28033 | 35201 | 442 |
2054544 | 2054544 | 2021-12-27 | Rock Island | Illinois | 17161 | 23441 | 442 |
2051294 | 2051294 | 2021-12-26 | Rock Island | Illinois | 17161 | 23042 | 442 |
2052011 | 2052011 | 2021-12-26 | St. Louis | Minnesota | 27137 | 32313 | 442 |
2048044 | 2048044 | 2021-12-25 | Rock Island | Illinois | 17161 | 23042 | 442 |
2048761 | 2048761 | 2021-12-25 | St. Louis | Minnesota | 27137 | 32313 | 442 |
2044794 | 2044794 | 2021-12-24 | Rock Island | Illinois | 17161 | 23042 | 442 |
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);