ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 7585 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461681 | 2461681 | 2022-05-01 | Hancock | Maine | 23009 | 7585 | 85 |
2458425 | 2458425 | 2022-04-30 | Hancock | Maine | 23009 | 7585 | 85 |
2352982 | 2352982 | 2022-03-28 | Clark | Wisconsin | 55019 | 7585 | 121 |
2293125 | 2293125 | 2022-03-10 | Delaware | New York | 36025 | 7585 | 68 |
2265159 | 2265159 | 2022-03-01 | Clark | Wisconsin | 55019 | 7585 | 117 |
2087879 | 2087879 | 2022-01-06 | Butler | Missouri | 29023 | 7585 | 134 |
2080646 | 2080646 | 2022-01-04 | Steuben | Indiana | 18151 | 7585 | 100 |
2065507 | 2065507 | 2021-12-30 | Tioga | New York | 36107 | 7585 | 78 |
1940057 | 1940057 | 2021-11-21 | Shawano | Wisconsin | 55115 | 7585 | 92 |
1936807 | 1936807 | 2021-11-20 | Shawano | Wisconsin | 55115 | 7585 | 92 |
1933557 | 1933557 | 2021-11-19 | Shawano | Wisconsin | 55115 | 7585 | 92 |
1825215 | 1825215 | 2021-10-17 | Knox | Ohio | 39083 | 7585 | 138 |
1812250 | 1812250 | 2021-10-13 | Sandusky | Ohio | 39143 | 7585 | 145 |
1771085 | 1771085 | 2021-09-30 | Sauk | Wisconsin | 55111 | 7585 | 62 |
1763932 | 1763932 | 2021-09-28 | Franklin | Tennessee | 47051 | 7585 | 96 |
1761290 | 1761290 | 2021-09-27 | Calumet | Wisconsin | 55015 | 7585 | 58 |
1737684 | 1737684 | 2021-09-20 | Indiana | Pennsylvania | 42063 | 7585 | 190 |
1653059 | 1653059 | 2021-08-25 | Ross | Ohio | 39141 | 7585 | 166 |
1653651 | 1653651 | 2021-08-25 | Hardin | Texas | 48199 | 7585 | 129 |
1585912 | 1585912 | 2021-08-04 | Portage | Wisconsin | 55097 | 7585 | 77 |
1576210 | 1576210 | 2021-08-02 | Autauga | Alabama | 1001 | 7585 | 114 |
1518546 | 1518546 | 2021-07-15 | Wayne | Indiana | 18177 | 7585 | 205 |
1448955 | 1448955 | 2021-06-23 | Unknown | Tennessee | 7585 | 86 | |
1427568 | 1427568 | 2021-06-17 | Williamson | Illinois | 17199 | 7585 | 146 |
1349502 | 1349502 | 2021-05-24 | Troup | Georgia | 13285 | 7585 | 229 |
1346255 | 1346255 | 2021-05-23 | Troup | Georgia | 13285 | 7585 | 229 |
1307198 | 1307198 | 2021-05-11 | Dougherty | Georgia | 13095 | 7585 | 303 |
1246505 | 1246505 | 2021-04-22 | Forrest | Mississippi | 28035 | 7585 | 149 |
1144241 | 1144241 | 2021-03-21 | Thurston | Washington | 53067 | 7585 | 81 |
1140994 | 1140994 | 2021-03-20 | Thurston | Washington | 53067 | 7585 | 81 |
1071330 | 1071330 | 2021-02-27 | St. Francois | Missouri | 29187 | 7585 | 104 |
1047345 | 1047345 | 2021-02-20 | Columbia | Florida | 12023 | 7585 | 154 |
1019251 | 1019251 | 2021-02-11 | Jones | Mississippi | 28067 | 7585 | 138 |
983171 | 983171 | 2021-01-31 | Madison | Kentucky | 21151 | 7585 | 56 |
946545 | 946545 | 2021-01-20 | Jefferson | Arkansas | 5069 | 7585 | 143 |
912021 | 912021 | 2021-01-09 | St. Clair | Michigan | 26147 | 7585 | 192 |
884834 | 884834 | 2021-01-01 | Cochise | Arizona | 4003 | 7585 | 136 |
844851 | 844851 | 2020-12-19 | Lebanon | Pennsylvania | 42075 | 7585 | 138 |
798325 | 798325 | 2020-12-05 | Frederick | Maryland | 24021 | 7585 | 154 |
761749 | 761749 | 2020-11-24 | Clay | Florida | 12019 | 7585 | 144 |
601955 | 601955 | 2020-10-05 | Jefferson | Texas | 48245 | 7585 | 136 |
598712 | 598712 | 2020-10-04 | Jefferson | Texas | 48245 | 7585 | 136 |
595469 | 595469 | 2020-10-03 | Jefferson | Texas | 48245 | 7585 | 136 |
574628 | 574628 | 2020-09-27 | Dakota | Minnesota | 27037 | 7585 | 126 |
525091 | 525091 | 2020-09-12 | Sarasota | Florida | 12115 | 7585 | 233 |
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);