ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
638 rows where deaths = 342 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 59
- Pennsylvania 39
- Georgia 37
- Michigan 37
- Iowa 29
- North Carolina 29
- Wisconsin 29
- Illinois 27
- Indiana 27
- Maryland 26
- Florida 22
- Ohio 21
- Alabama 20
- West Virginia 17
- Rhode Island 16
- Louisiana 15
- New Jersey 14
- Minnesota 13
- South Dakota 13
- Arizona 11
- California 10
- Colorado 10
- Missouri 10
- Oregon 10
- South Carolina 10
- Delaware 9
- New York 9
- Connecticut 8
- Tennessee 8
- Virginia 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501393 | 2501393 | 2022-05-13 | Warren | New Jersey | 34041 | 24838 | 342 |
2501407 | 2501407 | 2022-05-13 | Lea | New Mexico | 35025 | 20174 | 342 |
2502096 | 2502096 | 2022-05-13 | Pennington | South Dakota | 46103 | 32903 | 342 |
2498135 | 2498135 | 2022-05-12 | Warren | New Jersey | 34041 | 24771 | 342 |
2498838 | 2498838 | 2022-05-12 | Pennington | South Dakota | 46103 | 32903 | 342 |
2494877 | 2494877 | 2022-05-11 | Warren | New Jersey | 34041 | 24722 | 342 |
2495580 | 2495580 | 2022-05-11 | Pennington | South Dakota | 46103 | 32903 | 342 |
2496288 | 2496288 | 2022-05-11 | Washington | Wisconsin | 55131 | 38864 | 342 |
2491619 | 2491619 | 2022-05-10 | Warren | New Jersey | 34041 | 24681 | 342 |
2492322 | 2492322 | 2022-05-10 | Pennington | South Dakota | 46103 | 32840 | 342 |
2493030 | 2493030 | 2022-05-10 | Washington | Wisconsin | 55131 | 38788 | 342 |
2488361 | 2488361 | 2022-05-09 | Warren | New Jersey | 34041 | 24643 | 342 |
2489064 | 2489064 | 2022-05-09 | Pennington | South Dakota | 46103 | 32840 | 342 |
2489772 | 2489772 | 2022-05-09 | Washington | Wisconsin | 55131 | 38742 | 342 |
2485104 | 2485104 | 2022-05-08 | Warren | New Jersey | 34041 | 24623 | 342 |
2485807 | 2485807 | 2022-05-08 | Pennington | South Dakota | 46103 | 32840 | 342 |
2486515 | 2486515 | 2022-05-08 | Washington | Wisconsin | 55131 | 38647 | 342 |
2481846 | 2481846 | 2022-05-07 | Warren | New Jersey | 34041 | 24592 | 342 |
2482549 | 2482549 | 2022-05-07 | Pennington | South Dakota | 46103 | 32840 | 342 |
2483257 | 2483257 | 2022-05-07 | Washington | Wisconsin | 55131 | 38647 | 342 |
2478588 | 2478588 | 2022-05-06 | Warren | New Jersey | 34041 | 24544 | 342 |
2479291 | 2479291 | 2022-05-06 | Pennington | South Dakota | 46103 | 32840 | 342 |
2479999 | 2479999 | 2022-05-06 | Washington | Wisconsin | 55131 | 38647 | 342 |
2475330 | 2475330 | 2022-05-05 | Warren | New Jersey | 34041 | 24503 | 342 |
2476033 | 2476033 | 2022-05-05 | Pennington | South Dakota | 46103 | 32840 | 342 |
2472073 | 2472073 | 2022-05-04 | Warren | New Jersey | 34041 | 24458 | 342 |
2472776 | 2472776 | 2022-05-04 | Pennington | South Dakota | 46103 | 32840 | 342 |
2468817 | 2468817 | 2022-05-03 | Warren | New Jersey | 34041 | 24432 | 342 |
2465561 | 2465561 | 2022-05-02 | Warren | New Jersey | 34041 | 24403 | 342 |
2444098 | 2444098 | 2022-04-25 | Raleigh | West Virginia | 54081 | 22774 | 342 |
2440842 | 2440842 | 2022-04-24 | Raleigh | West Virginia | 54081 | 22743 | 342 |
2437586 | 2437586 | 2022-04-23 | Raleigh | West Virginia | 54081 | 22743 | 342 |
2434330 | 2434330 | 2022-04-22 | Raleigh | West Virginia | 54081 | 22743 | 342 |
2431074 | 2431074 | 2022-04-21 | Raleigh | West Virginia | 54081 | 22738 | 342 |
2426946 | 2426946 | 2022-04-20 | Armstrong | Pennsylvania | 42005 | 15279 | 342 |
2423690 | 2423690 | 2022-04-19 | Armstrong | Pennsylvania | 42005 | 15277 | 342 |
2401784 | 2401784 | 2022-04-12 | Wood | West Virginia | 54107 | 22177 | 342 |
2398529 | 2398529 | 2022-04-11 | Wood | West Virginia | 54107 | 22175 | 342 |
2377086 | 2377086 | 2022-04-05 | Allegan | Michigan | 26005 | 27030 | 342 |
2373834 | 2373834 | 2022-04-04 | Allegan | Michigan | 26005 | 27030 | 342 |
2374872 | 2374872 | 2022-04-04 | Clearfield | Pennsylvania | 42033 | 19260 | 342 |
2369360 | 2369360 | 2022-04-03 | Elmore | Alabama | 1051 | 23066 | 342 |
2370581 | 2370581 | 2022-04-03 | Allegan | Michigan | 26005 | 27030 | 342 |
2371620 | 2371620 | 2022-04-03 | Clearfield | Pennsylvania | 42033 | 19260 | 342 |
2366107 | 2366107 | 2022-04-02 | Elmore | Alabama | 1051 | 23066 | 342 |
2367328 | 2367328 | 2022-04-02 | Allegan | Michigan | 26005 | 27030 | 342 |
2368367 | 2368367 | 2022-04-02 | Clearfield | Pennsylvania | 42033 | 19260 | 342 |
2362854 | 2362854 | 2022-04-01 | Elmore | Alabama | 1051 | 23066 | 342 |
2364075 | 2364075 | 2022-04-01 | Allegan | Michigan | 26005 | 27030 | 342 |
2359600 | 2359600 | 2022-03-31 | Elmore | Alabama | 1051 | 23039 | 342 |
2360821 | 2360821 | 2022-03-31 | Allegan | Michigan | 26005 | 27022 | 342 |
2356346 | 2356346 | 2022-03-30 | Elmore | Alabama | 1051 | 22975 | 342 |
2357567 | 2357567 | 2022-03-30 | Allegan | Michigan | 26005 | 27022 | 342 |
2353093 | 2353093 | 2022-03-29 | Elmore | Alabama | 1051 | 22974 | 342 |
2354314 | 2354314 | 2022-03-29 | Allegan | Michigan | 26005 | 27014 | 342 |
2351062 | 2351062 | 2022-03-28 | Allegan | Michigan | 26005 | 27014 | 342 |
2347809 | 2347809 | 2022-03-27 | Allegan | Michigan | 26005 | 27008 | 342 |
2344556 | 2344556 | 2022-03-26 | Allegan | Michigan | 26005 | 27008 | 342 |
2341303 | 2341303 | 2022-03-25 | Allegan | Michigan | 26005 | 27008 | 342 |
2338050 | 2338050 | 2022-03-24 | Allegan | Michigan | 26005 | 26998 | 342 |
2339875 | 2339875 | 2022-03-24 | Cowlitz | Washington | 53015 | 22512 | 342 |
2334796 | 2334796 | 2022-03-23 | Allegan | Michigan | 26005 | 26998 | 342 |
2336622 | 2336622 | 2022-03-23 | Cowlitz | Washington | 53015 | 22512 | 342 |
2331542 | 2331542 | 2022-03-22 | Allegan | Michigan | 26005 | 26985 | 342 |
2327595 | 2327595 | 2022-03-21 | Unknown | Guam | 47778 | 342 | |
2328290 | 2328290 | 2022-03-21 | Allegan | Michigan | 26005 | 26985 | 342 |
2328565 | 2328565 | 2022-03-21 | Clay | Missouri | 29047 | 26895 | 342 |
2324342 | 2324342 | 2022-03-20 | Unknown | Guam | 47699 | 342 | |
2325037 | 2325037 | 2022-03-20 | Allegan | Michigan | 26005 | 26979 | 342 |
2325313 | 2325313 | 2022-03-20 | Clay | Missouri | 29047 | 26915 | 342 |
2321088 | 2321088 | 2022-03-19 | Unknown | Guam | 47664 | 342 | |
2321783 | 2321783 | 2022-03-19 | Allegan | Michigan | 26005 | 26979 | 342 |
2322059 | 2322059 | 2022-03-19 | Clay | Missouri | 29047 | 26915 | 342 |
2317834 | 2317834 | 2022-03-18 | Unknown | Guam | 47664 | 342 | |
2318529 | 2318529 | 2022-03-18 | Allegan | Michigan | 26005 | 26979 | 342 |
2318805 | 2318805 | 2022-03-18 | Clay | Missouri | 29047 | 26915 | 342 |
2314581 | 2314581 | 2022-03-17 | Unknown | Guam | 47619 | 342 | |
2315276 | 2315276 | 2022-03-17 | Allegan | Michigan | 26005 | 26961 | 342 |
2315552 | 2315552 | 2022-03-17 | Clay | Missouri | 29047 | 26926 | 342 |
2312023 | 2312023 | 2022-03-16 | Allegan | Michigan | 26005 | 26961 | 342 |
2312299 | 2312299 | 2022-03-16 | Clay | Missouri | 29047 | 26929 | 342 |
2291050 | 2291050 | 2022-03-09 | Roanoke city | Virginia | 51770 | 20608 | 342 |
2287569 | 2287569 | 2022-03-08 | Orange | Texas | 48361 | 14907 | 342 |
2276216 | 2276216 | 2022-03-05 | Charles | Maryland | 24017 | 27633 | 342 |
2272963 | 2272963 | 2022-03-04 | Charles | Maryland | 24017 | 27619 | 342 |
2269155 | 2269155 | 2022-03-03 | Macon | Illinois | 17115 | 30245 | 342 |
2269230 | 2269230 | 2022-03-03 | Grant | Indiana | 18053 | 17625 | 342 |
2269711 | 2269711 | 2022-03-03 | Charles | Maryland | 24017 | 27612 | 342 |
2265902 | 2265902 | 2022-03-02 | Macon | Illinois | 17115 | 30227 | 342 |
2265977 | 2265977 | 2022-03-02 | Grant | Indiana | 18053 | 17617 | 342 |
2266458 | 2266458 | 2022-03-02 | Charles | Maryland | 24017 | 27601 | 342 |
2267527 | 2267527 | 2022-03-02 | Centre | Pennsylvania | 42027 | 34772 | 342 |
2262726 | 2262726 | 2022-03-01 | Grant | Indiana | 18053 | 17614 | 342 |
2251289 | 2251289 | 2022-02-25 | Indiana | Pennsylvania | 42063 | 17137 | 342 |
2227438 | 2227438 | 2022-02-18 | Allegany | Maryland | 24001 | 16764 | 342 |
2224187 | 2224187 | 2022-02-17 | Allegany | Maryland | 24001 | 16727 | 342 |
2220118 | 2220118 | 2022-02-16 | Unknown | Florida | 30784 | 342 | |
2216431 | 2216431 | 2022-02-14 | Outagamie | Wisconsin | 55087 | 53352 | 342 |
2212404 | 2212404 | 2022-02-13 | Beaufort | South Carolina | 45013 | 41818 | 342 |
2209151 | 2209151 | 2022-02-12 | Beaufort | South Carolina | 45013 | 41818 | 342 |
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);