ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 8903 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Idaho 4
- Missouri 4
- Texas 4
- California 3
- New York 3
- Wisconsin 3
- Massachusetts 2
- West Virginia 2
- Alabama 1
- Arkansas 1
- Colorado 1
- Maryland 1
- Pennsylvania 1
- South Dakota 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2365566 | 2365566 | 2022-04-01 | Hill | Texas | 48217 | 8903 | 191 |
2348414 | 2348414 | 2022-03-27 | Allegany | New York | 36003 | 8903 | 154 |
2324383 | 2324383 | 2022-03-20 | Nez Perce | Idaho | 16069 | 8903 | 145 |
2325335 | 2325335 | 2022-03-20 | Howell | Missouri | 29091 | 8903 | 207 |
2321129 | 2321129 | 2022-03-19 | Nez Perce | Idaho | 16069 | 8903 | 145 |
2322081 | 2322081 | 2022-03-19 | Howell | Missouri | 29091 | 8903 | 207 |
2317875 | 2317875 | 2022-03-18 | Nez Perce | Idaho | 16069 | 8903 | 145 |
2318827 | 2318827 | 2022-03-18 | Howell | Missouri | 29091 | 8903 | 207 |
2314622 | 2314622 | 2022-03-17 | Nez Perce | Idaho | 16069 | 8903 | 145 |
2213093 | 2213093 | 2022-02-13 | Greenbrier | West Virginia | 54025 | 8903 | 128 |
1975263 | 1975263 | 2021-12-02 | Chambers | Texas | 48071 | 8903 | 100 |
1917608 | 1917608 | 2021-11-15 | Eagle | Colorado | 8037 | 8903 | 32 |
1912695 | 1912695 | 2021-11-13 | Cattaraugus | New York | 36009 | 8903 | 140 |
1900611 | 1900611 | 2021-11-09 | Lamar | Texas | 48277 | 8903 | 209 |
1868490 | 1868490 | 2021-10-30 | Putnam | West Virginia | 54079 | 8903 | 124 |
1800566 | 1800566 | 2021-10-10 | Humboldt | California | 6023 | 8903 | 106 |
1797317 | 1797317 | 2021-10-09 | Humboldt | California | 6023 | 8903 | 106 |
1794068 | 1794068 | 2021-10-08 | Humboldt | California | 6023 | 8903 | 106 |
1630688 | 1630688 | 2021-08-18 | Lincoln | South Dakota | 46083 | 8903 | 78 |
1396008 | 1396008 | 2021-06-07 | St. Francois | Missouri | 29187 | 8903 | 115 |
1394351 | 1394351 | 2021-06-06 | Manitowoc | Wisconsin | 55071 | 8903 | 91 |
1391106 | 1391106 | 2021-06-05 | Manitowoc | Wisconsin | 55071 | 8903 | 91 |
1387861 | 1387861 | 2021-06-04 | Manitowoc | Wisconsin | 55071 | 8903 | 91 |
1363806 | 1363806 | 2021-05-28 | Chautauqua | New York | 36013 | 8903 | 143 |
1332344 | 1332344 | 2021-05-18 | Victoria | Texas | 48469 | 8903 | 210 |
1316646 | 1316646 | 2021-05-14 | Jefferson | Arkansas | 5069 | 8903 | 166 |
1259296 | 1259296 | 2021-04-26 | Hampshire | Massachusetts | 25015 | 8903 | 290 |
1079491 | 1079491 | 2021-03-02 | Cullman | Alabama | 1043 | 8903 | 181 |
1066311 | 1066311 | 2021-02-25 | Grant | Washington | 53025 | 8903 | 114 |
776706 | 776706 | 2020-11-28 | Northampton | Pennsylvania | 42095 | 8903 | 332 |
516208 | 516208 | 2020-09-09 | Anne Arundel | Maryland | 24003 | 8903 | 240 |
355060 | 355060 | 2020-07-21 | Plymouth | Massachusetts | 25023 | 8903 | 699 |
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);