ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 8859 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 |
---|---|---|---|---|---|---|---|
2422805 | 2422805 | 2022-04-19 | Polk | Minnesota | 27119 | 8859 | 107 |
2392681 | 2392681 | 2022-04-10 | Bonner | Idaho | 16017 | 8859 | 182 |
2389425 | 2389425 | 2022-04-09 | Bonner | Idaho | 16017 | 8859 | 182 |
2386170 | 2386170 | 2022-04-08 | Bonner | Idaho | 16017 | 8859 | 182 |
2382915 | 2382915 | 2022-04-07 | Bonner | Idaho | 16017 | 8859 | 182 |
2379660 | 2379660 | 2022-04-06 | Bonner | Idaho | 16017 | 8859 | 182 |
2336287 | 2336287 | 2022-03-23 | Hill | Texas | 48217 | 8859 | 191 |
2292809 | 2292809 | 2022-03-10 | Howell | Missouri | 29091 | 8859 | 205 |
2240437 | 2240437 | 2022-02-22 | Somerset | Maine | 23025 | 8859 | 92 |
2184107 | 2184107 | 2022-02-05 | Miller | Arkansas | 5091 | 8859 | 158 |
2125383 | 2125383 | 2022-01-17 | Sweetwater | Wyoming | 56037 | 8859 | 112 |
2122131 | 2122131 | 2022-01-16 | Sweetwater | Wyoming | 56037 | 8859 | 112 |
2118879 | 2118879 | 2022-01-15 | Sweetwater | Wyoming | 56037 | 8859 | 112 |
2115627 | 2115627 | 2022-01-14 | Sweetwater | Wyoming | 56037 | 8859 | 112 |
1940832 | 1940832 | 2021-11-22 | Henry | Indiana | 18065 | 8859 | 167 |
1902992 | 1902992 | 2021-11-10 | Sullivan | New York | 36105 | 8859 | 85 |
1819885 | 1819885 | 2021-10-16 | Dale | Alabama | 1045 | 8859 | 181 |
1691838 | 1691838 | 2021-09-06 | Columbus | North Carolina | 37047 | 8859 | 180 |
1688588 | 1688588 | 2021-09-05 | Columbus | North Carolina | 37047 | 8859 | 180 |
1685338 | 1685338 | 2021-09-04 | Columbus | North Carolina | 37047 | 8859 | 180 |
1682087 | 1682087 | 2021-09-03 | Columbus | North Carolina | 37047 | 8859 | 180 |
1582875 | 1582875 | 2021-08-04 | Pope | Arkansas | 5115 | 8859 | 116 |
1491339 | 1491339 | 2021-07-06 | Orange | Texas | 48361 | 8859 | 155 |
1488092 | 1488092 | 2021-07-05 | Orange | Texas | 48361 | 8859 | 155 |
1484845 | 1484845 | 2021-07-04 | Orange | Texas | 48361 | 8859 | 155 |
1481599 | 1481599 | 2021-07-03 | Orange | Texas | 48361 | 8859 | 154 |
1318576 | 1318576 | 2021-05-14 | Columbiana | Ohio | 39029 | 8859 | 229 |
1277688 | 1277688 | 2021-05-02 | Jefferson | Arkansas | 5069 | 8859 | 166 |
1272669 | 1272669 | 2021-04-30 | Cascade | Montana | 30013 | 8859 | 169 |
1249555 | 1249555 | 2021-04-23 | Hampshire | Massachusetts | 25015 | 8859 | 290 |
1163085 | 1163085 | 2021-03-27 | Oconee | South Carolina | 45073 | 8859 | 131 |
831725 | 831725 | 2020-12-15 | Canadian | Oklahoma | 40017 | 8859 | 44 |
666026 | 666026 | 2020-10-25 | Durham | North Carolina | 37063 | 8859 | 100 |
613777 | 613777 | 2020-10-09 | St. Charles | Missouri | 29183 | 8859 | 138 |
588188 | 588188 | 2020-10-01 | Guilford | North Carolina | 37081 | 8859 | 185 |
505670 | 505670 | 2020-09-06 | Marion | Florida | 12083 | 8859 | 218 |
470487 | 470487 | 2020-08-26 | Lake | Indiana | 18089 | 8859 | 311 |
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);