ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 8959 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- New York 7
- Louisiana 6
- Wisconsin 4
- Pennsylvania 3
- Texas 3
- Alabama 2
- Kansas 2
- North Carolina 2
- Ohio 2
- Tennessee 2
- California 1
- Georgia 1
- Idaho 1
- Illinois 1
- Indiana 1
- Iowa 1
- Kentucky 1
- Maryland 1
- Michigan 1
- Mississippi 1
- New Jersey 1
- North Dakota 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493651 | 2493651 | 2022-05-11 | Nez Perce | Idaho | 16069 | 8959 | 148 |
2403734 | 2403734 | 2022-04-13 | Allegany | New York | 36003 | 8959 | 154 |
2279402 | 2279402 | 2022-03-06 | Iberville | Louisiana | 22047 | 8959 | 148 |
2276149 | 2276149 | 2022-03-05 | Iberville | Louisiana | 22047 | 8959 | 148 |
2272896 | 2272896 | 2022-03-04 | Iberville | Louisiana | 22047 | 8959 | 148 |
2269644 | 2269644 | 2022-03-03 | Iberville | Louisiana | 22047 | 8959 | 148 |
2174966 | 2174966 | 2022-02-02 | Putnam | Indiana | 18133 | 8959 | 109 |
2163940 | 2163940 | 2022-01-29 | Kerr | Texas | 48265 | 8959 | 157 |
2132809 | 2132809 | 2022-01-20 | Cowley | Kansas | 20035 | 8959 | 138 |
2129556 | 2129556 | 2022-01-19 | Cowley | Kansas | 20035 | 8959 | 138 |
2130133 | 2130133 | 2022-01-19 | Washington | Mississippi | 28151 | 8959 | 171 |
2103153 | 2103153 | 2022-01-11 | Thomas | Georgia | 13275 | 8959 | 185 |
2083064 | 2083064 | 2022-01-04 | Oconto | Wisconsin | 55083 | 8959 | 89 |
2058283 | 2058283 | 2021-12-28 | St. Mary | Louisiana | 22101 | 8959 | 230 |
1985152 | 1985152 | 2021-12-05 | Navarro | Texas | 48349 | 8959 | 190 |
1888118 | 1888118 | 2021-11-06 | Dale | Alabama | 1045 | 8959 | 186 |
1769080 | 1769080 | 2021-09-30 | Allegany | Maryland | 24001 | 8959 | 233 |
1734422 | 1734422 | 2021-09-19 | Crawford | Pennsylvania | 42039 | 8959 | 168 |
1683409 | 1683409 | 2021-09-04 | Autauga | Alabama | 1001 | 8959 | 119 |
1682833 | 1682833 | 2021-09-03 | Coryell | Texas | 48099 | 8959 | 103 |
1562498 | 1562498 | 2021-07-28 | Anderson | Tennessee | 47001 | 8959 | 179 |
1553416 | 1553416 | 2021-07-25 | Manitowoc | Wisconsin | 55071 | 8959 | 96 |
1550169 | 1550169 | 2021-07-24 | Manitowoc | Wisconsin | 55071 | 8959 | 96 |
1546922 | 1546922 | 2021-07-23 | Manitowoc | Wisconsin | 55071 | 8959 | 96 |
1457928 | 1457928 | 2021-06-26 | Chautauqua | New York | 36013 | 8959 | 145 |
1454683 | 1454683 | 2021-06-25 | Chautauqua | New York | 36013 | 8959 | 145 |
1451438 | 1451438 | 2021-06-24 | Chautauqua | New York | 36013 | 8959 | 145 |
1448192 | 1448192 | 2021-06-23 | Chautauqua | New York | 36013 | 8959 | 145 |
1444947 | 1444947 | 2021-06-22 | Chautauqua | New York | 36013 | 8959 | 145 |
1441702 | 1441702 | 2021-06-21 | Chautauqua | New York | 36013 | 8959 | 145 |
1364029 | 1364029 | 2021-05-28 | Columbiana | Ohio | 39029 | 8959 | 229 |
1360783 | 1360783 | 2021-05-27 | Columbiana | Ohio | 39029 | 8959 | 229 |
1231149 | 1231149 | 2021-04-17 | Northumberland | Pennsylvania | 42097 | 8959 | 342 |
1215213 | 1215213 | 2021-04-12 | Unknown | Tennessee | 8959 | 122 | |
1209109 | 1209109 | 2021-04-10 | Montgomery | Virginia | 51121 | 8959 | 88 |
1107396 | 1107396 | 2021-03-10 | Lincoln | North Carolina | 37109 | 8959 | 75 |
1099994 | 1099994 | 2021-03-08 | Hardin | Kentucky | 21093 | 8959 | 101 |
963927 | 963927 | 2021-01-25 | Monroe | Michigan | 26115 | 8959 | 176 |
940780 | 940780 | 2021-01-18 | Pottawattamie | Iowa | 19155 | 8959 | 112 |
825097 | 825097 | 2020-12-13 | Grand Forks | North Dakota | 38035 | 8959 | 55 |
776723 | 776723 | 2020-11-28 | Westmoreland | Pennsylvania | 42129 | 8959 | 192 |
737387 | 737387 | 2020-11-16 | Gaston | North Carolina | 37071 | 8959 | 164 |
732812 | 732812 | 2020-11-15 | Champaign | Illinois | 17019 | 8959 | 40 |
574432 | 574432 | 2020-09-27 | Lafayette | Louisiana | 22055 | 8959 | 132 |
255921 | 255921 | 2020-06-20 | San Bernardino | California | 6071 | 8959 | 233 |
68938 | 68938 | 2020-04-18 | Union | New Jersey | 34039 | 8959 | 356 |
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);