ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 8429 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Wisconsin 5
- Ohio 3
- Alabama 2
- Arkansas 2
- Illinois 2
- New Hampshire 2
- Texas 2
- Colorado 1
- Florida 1
- Georgia 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Maryland 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- New Jersey 1
- North Carolina 1
- North Dakota 1
- Pennsylvania 1
- Tennessee 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499598 | 2499598 | 2022-05-13 | Dallas | Alabama | 1047 | 8429 | 244 |
2286894 | 2286894 | 2022-03-08 | Putnam | Ohio | 39137 | 8429 | 153 |
2281457 | 2281457 | 2022-03-06 | Oneida | Wisconsin | 55085 | 8429 | 131 |
2278204 | 2278204 | 2022-03-05 | Oneida | Wisconsin | 55085 | 8429 | 131 |
2274951 | 2274951 | 2022-03-04 | Oneida | Wisconsin | 55085 | 8429 | 131 |
2266269 | 2266269 | 2022-03-02 | Carter | Kentucky | 21043 | 8429 | 97 |
2086510 | 2086510 | 2022-01-06 | Hot Spring | Arkansas | 5059 | 8429 | 113 |
2063556 | 2063556 | 2021-12-29 | Monroe | Wisconsin | 55081 | 8429 | 67 |
2052647 | 2052647 | 2021-12-26 | Morton | North Dakota | 38059 | 8429 | 130 |
2026183 | 2026183 | 2021-12-18 | Newton | Missouri | 29145 | 8429 | 167 |
1997299 | 1997299 | 2021-12-09 | Granville | North Carolina | 37077 | 8429 | 106 |
1940711 | 1940711 | 2021-11-22 | Coles | Illinois | 17029 | 8429 | 135 |
1925175 | 1925175 | 2021-11-17 | Benton | Minnesota | 27009 | 8429 | 122 |
1788545 | 1788545 | 2021-10-06 | St. Mary | Louisiana | 22101 | 8429 | 212 |
1695758 | 1695758 | 2021-09-07 | Roane | Tennessee | 47145 | 8429 | 125 |
1676385 | 1676385 | 2021-09-01 | Hardin | Texas | 48199 | 8429 | 137 |
1627811 | 1627811 | 2021-08-17 | Wise | Texas | 48497 | 8429 | 132 |
1540639 | 1540639 | 2021-07-22 | Lonoke | Arkansas | 5085 | 8429 | 134 |
1537693 | 1537693 | 2021-07-21 | Gordon | Georgia | 13129 | 8429 | 120 |
1300054 | 1300054 | 2021-05-08 | Roanoke city | Virginia | 51770 | 8429 | 192 |
1269941 | 1269941 | 2021-04-29 | Tuscarawas | Ohio | 39157 | 8429 | 241 |
1227714 | 1227714 | 2021-04-16 | Pickaway | Ohio | 39129 | 8429 | 121 |
1063267 | 1063267 | 2021-02-25 | DeKalb | Alabama | 1049 | 8429 | 174 |
1044459 | 1044459 | 2021-02-19 | Vermilion | Illinois | 17183 | 8429 | 130 |
1037227 | 1037227 | 2021-02-16 | Ozaukee | Wisconsin | 55089 | 8429 | 79 |
1015769 | 1015769 | 2021-02-10 | Charles | Maryland | 24017 | 8429 | 150 |
983300 | 983300 | 2021-01-31 | York | Maine | 23031 | 8429 | 100 |
867539 | 867539 | 2020-12-26 | Cambria | Pennsylvania | 42021 | 8429 | 223 |
769692 | 769692 | 2020-11-26 | Hillsborough | New Hampshire | 33011 | 8429 | 331 |
766446 | 766446 | 2020-11-25 | Hillsborough | New Hampshire | 33011 | 8429 | 331 |
704449 | 704449 | 2020-11-06 | Hinds | Mississippi | 28049 | 8429 | 181 |
554173 | 554173 | 2020-09-21 | Brevard | Florida | 12009 | 8429 | 277 |
350887 | 350887 | 2020-07-20 | Denver | Colorado | 8031 | 8429 | 398 |
66182 | 66182 | 2020-04-17 | Union | New Jersey | 34039 | 8429 | 330 |
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);