ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 7719 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 |
---|---|---|---|---|---|---|---|
2335876 | 2335876 | 2022-03-23 | Susquehanna | Pennsylvania | 42115 | 7719 | 107 |
2234823 | 2234823 | 2022-02-20 | Fayette | Ohio | 39047 | 7719 | 102 |
2176275 | 2176275 | 2022-02-02 | Coshocton | Ohio | 39031 | 7719 | 139 |
2156279 | 2156279 | 2022-01-27 | Warren | Missouri | 29219 | 7719 | 89 |
2134629 | 2134629 | 2022-01-20 | Hill | Texas | 48217 | 7719 | 180 |
2129047 | 2129047 | 2022-01-19 | Bryan | Georgia | 13029 | 7719 | 78 |
2129787 | 2129787 | 2022-01-19 | Iberville | Louisiana | 22047 | 7719 | 130 |
1990446 | 1990446 | 2021-12-07 | Scott | Missouri | 29201 | 7719 | 132 |
1969811 | 1969811 | 2021-12-01 | Habersham | Georgia | 13137 | 7719 | 212 |
1954962 | 1954962 | 2021-11-26 | Fulton | New York | 36035 | 7719 | 109 |
1776517 | 1776517 | 2021-10-02 | Union | Ohio | 39159 | 7719 | 53 |
1762154 | 1762154 | 2021-09-28 | Shelby | Indiana | 18145 | 7719 | 123 |
1717960 | 1717960 | 2021-09-14 | Belmont | Ohio | 39013 | 7719 | 183 |
1679640 | 1679640 | 2021-09-02 | Henderson | Texas | 48213 | 7719 | 224 |
1674218 | 1674218 | 2021-09-01 | Maui | Hawaii | 15009 | 7719 | 72 |
1676392 | 1676392 | 2021-09-01 | Henderson | Texas | 48213 | 7719 | 222 |
1673145 | 1673145 | 2021-08-31 | Henderson | Texas | 48213 | 7719 | 219 |
1633311 | 1633311 | 2021-08-19 | Ontario | New York | 36069 | 7719 | 93 |
1626866 | 1626866 | 2021-08-17 | Columbus | North Carolina | 37047 | 7719 | 162 |
1609878 | 1609878 | 2021-08-12 | Vermilion | Louisiana | 22113 | 7719 | 138 |
1575577 | 1575577 | 2021-08-01 | Unknown | Tennessee | 7719 | 95 | |
1572329 | 1572329 | 2021-07-31 | Unknown | Tennessee | 7719 | 95 | |
1558054 | 1558054 | 2021-07-27 | Blue Earth | Minnesota | 27013 | 7719 | 44 |
1515237 | 1515237 | 2021-07-14 | Grant | Indiana | 18053 | 7719 | 188 |
1516807 | 1516807 | 2021-07-14 | Lawrence | Pennsylvania | 42073 | 7719 | 216 |
1512354 | 1512354 | 2021-07-13 | Oldham | Kentucky | 21185 | 7719 | 84 |
1507928 | 1507928 | 2021-07-11 | Chippewa | Wisconsin | 55017 | 7719 | 97 |
1504682 | 1504682 | 2021-07-10 | Chippewa | Wisconsin | 55017 | 7719 | 97 |
1501436 | 1501436 | 2021-07-09 | Chippewa | Wisconsin | 55017 | 7719 | 97 |
1469035 | 1469035 | 2021-06-29 | Wood | Wisconsin | 55141 | 7719 | 106 |
1465790 | 1465790 | 2021-06-28 | Wood | Wisconsin | 55141 | 7719 | 105 |
1441077 | 1441077 | 2021-06-21 | Wicomico | Maryland | 24045 | 7719 | 173 |
1433795 | 1433795 | 2021-06-19 | Dougherty | Georgia | 13095 | 7719 | 311 |
1427304 | 1427304 | 2021-06-17 | Dougherty | Georgia | 13095 | 7719 | 311 |
1347707 | 1347707 | 2021-05-23 | Rockingham | North Carolina | 37157 | 7719 | 110 |
1344459 | 1344459 | 2021-05-22 | Rockingham | North Carolina | 37157 | 7719 | 110 |
1341211 | 1341211 | 2021-05-21 | Rockingham | North Carolina | 37157 | 7719 | 110 |
1249110 | 1249110 | 2021-04-23 | Warrick | Indiana | 18173 | 7719 | 158 |
1059853 | 1059853 | 2021-02-23 | Cabell | West Virginia | 54011 | 7719 | 160 |
917214 | 917214 | 2021-01-11 | Cullman | Alabama | 1043 | 7719 | 80 |
867142 | 867142 | 2020-12-26 | Niagara | New York | 36063 | 7719 | 168 |
832517 | 832517 | 2020-12-15 | Chesapeake city | Virginia | 51550 | 7719 | 89 |
812060 | 812060 | 2020-12-09 | New Hanover | North Carolina | 37129 | 7719 | 62 |
745112 | 745112 | 2020-11-18 | Fond du Lac | Wisconsin | 55039 | 7719 | 37 |
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);