ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 8707 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- North Carolina 5
- Ohio 5
- Oregon 4
- Texas 4
- Washington 4
- Iowa 3
- Arkansas 2
- Pennsylvania 2
- Alabama 1
- Arizona 1
- Florida 1
- Georgia 1
- Kentucky 1
- Massachusetts 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- New Hampshire 1
- New York 1
- Oklahoma 1
- South Carolina 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500422 | 2500422 | 2022-05-13 | Jasper | Iowa | 19099 | 8707 | 110 |
2497164 | 2497164 | 2022-05-12 | Jasper | Iowa | 19099 | 8707 | 110 |
2493906 | 2493906 | 2022-05-11 | Jasper | Iowa | 19099 | 8707 | 110 |
2228083 | 2228083 | 2022-02-18 | Allegany | New York | 36003 | 8707 | 146 |
2212278 | 2212278 | 2022-02-13 | Jefferson | Pennsylvania | 42065 | 8707 | 210 |
2149627 | 2149627 | 2022-01-25 | Marshall | Mississippi | 28093 | 8707 | 151 |
2092480 | 2092480 | 2022-01-07 | Van Zandt | Texas | 48467 | 8707 | 237 |
2039678 | 2039678 | 2021-12-22 | Ashland | Ohio | 39005 | 8707 | 164 |
2019895 | 2019895 | 2021-12-16 | Grafton | New Hampshire | 33009 | 8707 | 42 |
2015911 | 2015911 | 2021-12-15 | Henderson | Kentucky | 21101 | 8707 | 129 |
1906309 | 1906309 | 2021-11-11 | McDowell | North Carolina | 37111 | 8707 | 133 |
1903060 | 1903060 | 2021-11-10 | McDowell | North Carolina | 37111 | 8707 | 133 |
1858404 | 1858404 | 2021-10-27 | Navarro | Texas | 48349 | 8707 | 185 |
1826207 | 1826207 | 2021-10-17 | Walla Walla | Washington | 53071 | 8707 | 99 |
1822958 | 1822958 | 2021-10-16 | Walla Walla | Washington | 53071 | 8707 | 99 |
1819709 | 1819709 | 2021-10-15 | Walla Walla | Washington | 53071 | 8707 | 99 |
1793886 | 1793886 | 2021-10-08 | Colbert | Alabama | 1033 | 8707 | 195 |
1739114 | 1739114 | 2021-09-21 | Laurens | Georgia | 13175 | 8707 | 212 |
1552199 | 1552199 | 2021-07-25 | Orange | North Carolina | 37135 | 8707 | 101 |
1548952 | 1548952 | 2021-07-24 | Orange | North Carolina | 37135 | 8707 | 101 |
1549120 | 1549120 | 2021-07-24 | Tuscarawas | Ohio | 39157 | 8707 | 254 |
1545705 | 1545705 | 2021-07-23 | Orange | North Carolina | 37135 | 8707 | 101 |
1526375 | 1526375 | 2021-07-17 | Pickaway | Ohio | 39129 | 8707 | 122 |
1487545 | 1487545 | 2021-07-05 | Umatilla | Oregon | 41059 | 8707 | 87 |
1484298 | 1484298 | 2021-07-04 | Umatilla | Oregon | 41059 | 8707 | 87 |
1481052 | 1481052 | 2021-07-03 | Umatilla | Oregon | 41059 | 8707 | 87 |
1477805 | 1477805 | 2021-07-02 | Umatilla | Oregon | 41059 | 8707 | 87 |
1465425 | 1465425 | 2021-06-28 | Walker | Texas | 48471 | 8707 | 132 |
1339577 | 1339577 | 2021-05-21 | Highlands | Florida | 12055 | 8707 | 365 |
1276371 | 1276371 | 2021-05-01 | Columbiana | Ohio | 39029 | 8707 | 229 |
1267743 | 1267743 | 2021-04-28 | Manitowoc | Wisconsin | 55071 | 8707 | 88 |
1249918 | 1249918 | 2021-04-23 | St. Francois | Missouri | 29187 | 8707 | 115 |
1144541 | 1144541 | 2021-03-22 | Jefferson | Arkansas | 5069 | 8707 | 161 |
1141294 | 1141294 | 2021-03-21 | Jefferson | Arkansas | 5069 | 8707 | 161 |
1074374 | 1074374 | 2021-02-28 | Sherburne | Minnesota | 27141 | 8707 | 72 |
1037100 | 1037100 | 2021-02-16 | Grant | Washington | 53025 | 8707 | 108 |
1000528 | 1000528 | 2021-02-05 | Muskogee | Oklahoma | 40101 | 8707 | 84 |
903027 | 903027 | 2021-01-06 | Allen | Ohio | 39003 | 8707 | 118 |
890249 | 890249 | 2021-01-02 | Beaver | Pennsylvania | 42007 | 8707 | 257 |
797218 | 797218 | 2020-12-05 | Navajo | Arizona | 4017 | 8707 | 277 |
679704 | 679704 | 2020-10-29 | Brazos | Texas | 48041 | 8707 | 73 |
414110 | 414110 | 2020-08-08 | Richland | South Carolina | 45079 | 8707 | 151 |
294599 | 294599 | 2020-07-02 | Plymouth | Massachusetts | 25023 | 8707 | 663 |
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);