ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where cases = 5455 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2482418 | 2482418 | 2022-05-07 | Morovis | Puerto Rico | 72101 | 5455 | |
2436812 | 2436812 | 2022-04-23 | Hatillo | Puerto Rico | 72065 | 5455 | |
2421920 | 2421920 | 2022-04-19 | Pike | Georgia | 13231 | 5455 | 96 |
2418664 | 2418664 | 2022-04-18 | Pike | Georgia | 13231 | 5455 | 96 |
2359235 | 2359235 | 2022-03-30 | Addison | Vermont | 50001 | 5455 | 15 |
2343472 | 2343472 | 2022-03-26 | Ouachita | Arkansas | 5103 | 5455 | 104 |
2340219 | 2340219 | 2022-03-25 | Ouachita | Arkansas | 5103 | 5455 | 103 |
2268374 | 2268374 | 2022-03-02 | McDowell | West Virginia | 54047 | 5455 | 63 |
2178939 | 2178939 | 2022-02-03 | Wayne | Mississippi | 28153 | 5455 | 78 |
2172546 | 2172546 | 2022-02-01 | Stone | Missouri | 29209 | 5455 | 105 |
2152035 | 2152035 | 2022-01-26 | Crawford | Illinois | 17033 | 5455 | 54 |
2126195 | 2126195 | 2022-01-18 | Buena Vista | Iowa | 19021 | 5455 | 51 |
2122943 | 2122943 | 2022-01-17 | Buena Vista | Iowa | 19021 | 5455 | 51 |
2119691 | 2119691 | 2022-01-16 | Buena Vista | Iowa | 19021 | 5455 | 51 |
2116439 | 2116439 | 2022-01-15 | Buena Vista | Iowa | 19021 | 5455 | 51 |
2113188 | 2113188 | 2022-01-14 | Buena Vista | Iowa | 19021 | 5455 | 51 |
2109936 | 2109936 | 2022-01-13 | Buena Vista | Iowa | 19021 | 5455 | 51 |
2110222 | 2110222 | 2022-01-13 | Ohio | Kentucky | 21183 | 5455 | 91 |
2106685 | 2106685 | 2022-01-12 | Buena Vista | Iowa | 19021 | 5455 | 51 |
2084886 | 2084886 | 2022-01-05 | Douglas | Nevada | 32005 | 5455 | 75 |
2013263 | 2013263 | 2021-12-14 | Ravalli | Montana | 30081 | 5455 | 128 |
2014721 | 2014721 | 2021-12-14 | Greenbrier | West Virginia | 54025 | 5455 | 113 |
1992758 | 1992758 | 2021-12-08 | Logan | Illinois | 17107 | 5455 | 90 |
1913968 | 1913968 | 2021-11-13 | Marshall | West Virginia | 54051 | 5455 | 116 |
1792728 | 1792728 | 2021-10-07 | Logan | Ohio | 39091 | 5455 | 90 |
1764635 | 1764635 | 2021-09-29 | Chambers | Alabama | 1017 | 5455 | 135 |
1761558 | 1761558 | 2021-09-28 | Union | Arkansas | 5139 | 5455 | 127 |
1751248 | 1751248 | 2021-09-24 | Washington | Texas | 48477 | 5455 | 117 |
1747999 | 1747999 | 2021-09-23 | Washington | Texas | 48477 | 5455 | 116 |
1737000 | 1737000 | 2021-09-20 | Webster | Missouri | 29225 | 5455 | 83 |
1665919 | 1665919 | 2021-08-29 | Watauga | North Carolina | 37189 | 5455 | 33 |
1662671 | 1662671 | 2021-08-28 | Watauga | North Carolina | 37189 | 5455 | 33 |
1659423 | 1659423 | 2021-08-27 | Watauga | North Carolina | 37189 | 5455 | 33 |
1653173 | 1653173 | 2021-08-25 | Klamath | Oregon | 41035 | 5455 | 81 |
1641434 | 1641434 | 2021-08-22 | Broomfield | Colorado | 8014 | 5455 | 77 |
1638184 | 1638184 | 2021-08-21 | Broomfield | Colorado | 8014 | 5455 | 77 |
1634934 | 1634934 | 2021-08-20 | Broomfield | Colorado | 8014 | 5455 | 77 |
1609195 | 1609195 | 2021-08-12 | Murray | Georgia | 13213 | 5455 | 93 |
1568545 | 1568545 | 2021-07-30 | Darke | Ohio | 39037 | 5455 | 131 |
1562332 | 1562332 | 2021-07-28 | Guaynabo | Puerto Rico | 72061 | 5455 | |
1516639 | 1516639 | 2021-07-14 | Sandusky | Ohio | 39143 | 5455 | 129 |
1513392 | 1513392 | 2021-07-13 | Sandusky | Ohio | 39143 | 5455 | 129 |
1510146 | 1510146 | 2021-07-12 | Sandusky | Ohio | 39143 | 5455 | 129 |
1506899 | 1506899 | 2021-07-11 | Sandusky | Ohio | 39143 | 5455 | 129 |
1503653 | 1503653 | 2021-07-10 | Sandusky | Ohio | 39143 | 5455 | 129 |
1500407 | 1500407 | 2021-07-09 | Sandusky | Ohio | 39143 | 5455 | 129 |
1399904 | 1399904 | 2021-06-08 | Linn | Oregon | 41043 | 5455 | 77 |
1382685 | 1382685 | 2021-06-03 | Cass | Michigan | 26027 | 5455 | 76 |
1354766 | 1354766 | 2021-05-25 | Dyer | Tennessee | 47045 | 5455 | 106 |
1321846 | 1321846 | 2021-05-15 | Huron | Ohio | 39077 | 5455 | 120 |
1276397 | 1276397 | 2021-05-01 | Jefferson | Ohio | 39081 | 5455 | 150 |
1259740 | 1259740 | 2021-04-26 | Buffalo | Nebraska | 31019 | 5455 | 58 |
1230705 | 1230705 | 2021-04-17 | Jefferson | New York | 36045 | 5455 | 64 |
1220414 | 1220414 | 2021-04-14 | St. Joseph | Michigan | 26149 | 5455 | 92 |
1180385 | 1180385 | 2021-04-02 | Garfield | Colorado | 8045 | 5455 | 38 |
1142705 | 1142705 | 2021-03-21 | Lincoln | Missouri | 29113 | 5455 | 39 |
1135918 | 1135918 | 2021-03-19 | Clinton | Michigan | 26037 | 5455 | 74 |
1110534 | 1110534 | 2021-03-11 | Cayuga | New York | 36011 | 5455 | 90 |
1084673 | 1084673 | 2021-03-03 | Lenoir | North Carolina | 37107 | 5455 | 105 |
1080181 | 1080181 | 2021-03-02 | Cass | Indiana | 18017 | 5455 | 101 |
1050219 | 1050219 | 2021-02-20 | Sauk | Wisconsin | 55111 | 5455 | 45 |
1031560 | 1031560 | 2021-02-15 | Shelby | Indiana | 18145 | 5455 | 98 |
1020144 | 1020144 | 2021-02-11 | Caguas | Puerto Rico | 72025 | 5455 | |
998695 | 998695 | 2021-02-05 | Monroe | Florida | 12087 | 5455 | 41 |
899169 | 899169 | 2021-01-05 | Jones | Mississippi | 28067 | 5455 | 98 |
845387 | 845387 | 2020-12-19 | Starr | Texas | 48427 | 5455 | 197 |
818712 | 818712 | 2020-12-11 | Richland | Ohio | 39139 | 5455 | 48 |
693646 | 693646 | 2020-11-03 | Martin | Florida | 12085 | 5455 | 170 |
588863 | 588863 | 2020-10-01 | Williamson | Tennessee | 47187 | 5455 | 38 |
495931 | 495931 | 2020-09-03 | Bay | Florida | 12005 | 5455 | 84 |
440794 | 440794 | 2020-08-17 | Navajo | Arizona | 4017 | 5455 | 208 |
152872 | 152872 | 2020-05-17 | Camden | New Jersey | 34007 | 5455 | 272 |
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);