ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 9072 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Colorado 3
- Illinois 3
- South Carolina 3
- Alabama 2
- Idaho 2
- Minnesota 2
- Ohio 2
- Texas 2
- West Virginia 2
- California 1
- Guam 1
- Louisiana 1
- Missouri 1
- Nebraska 1
- New Jersey 1
- New York 1
- Oregon 1
- Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474850 | 2474850 | 2022-05-05 | Carlton | Minnesota | 27017 | 9072 | 96 |
2380446 | 2380446 | 2022-04-06 | Freeborn | Minnesota | 27047 | 9072 | 74 |
2278545 | 2278545 | 2022-03-06 | Montrose | Colorado | 8085 | 9072 | 158 |
2275292 | 2275292 | 2022-03-05 | Montrose | Colorado | 8085 | 9072 | 158 |
2272039 | 2272039 | 2022-03-04 | Montrose | Colorado | 8085 | 9072 | 158 |
2196575 | 2196575 | 2022-02-08 | Waller | Texas | 48473 | 9072 | 97 |
2187874 | 2187874 | 2022-02-06 | Morgan | Illinois | 17137 | 9072 | 133 |
2184621 | 2184621 | 2022-02-05 | Morgan | Illinois | 17137 | 9072 | 133 |
2181369 | 2181369 | 2022-02-04 | Morgan | Illinois | 17137 | 9072 | 133 |
1998627 | 1998627 | 2021-12-10 | Dale | Alabama | 1045 | 9072 | 192 |
1971600 | 1971600 | 2021-12-01 | Klamath | Oregon | 41035 | 9072 | 147 |
1757308 | 1757308 | 2021-09-26 | Cherokee | South Carolina | 45021 | 9072 | 203 |
1753526 | 1753526 | 2021-09-25 | St. Lawrence | New York | 36089 | 9072 | 120 |
1754060 | 1754060 | 2021-09-25 | Cherokee | South Carolina | 45021 | 9072 | 203 |
1750812 | 1750812 | 2021-09-24 | Cherokee | South Carolina | 45021 | 9072 | 203 |
1724521 | 1724521 | 2021-09-16 | Ross | Ohio | 39141 | 9072 | 172 |
1516582 | 1516582 | 2021-07-14 | Columbiana | Ohio | 39029 | 9072 | 236 |
1379353 | 1379353 | 2021-06-02 | St. Landry | Louisiana | 22097 | 9072 | 259 |
1326791 | 1326791 | 2021-05-17 | Unknown | Guam | 9072 | 140 | |
1284025 | 1284025 | 2021-05-03 | Laramie | Wyoming | 56021 | 9072 | 113 |
1272564 | 1272564 | 2021-04-30 | Cass | Missouri | 29037 | 9072 | 107 |
1228596 | 1228596 | 2021-04-16 | Montgomery | Virginia | 51121 | 9072 | 88 |
1119021 | 1119021 | 2021-03-14 | Twin Falls | Idaho | 16083 | 9072 | 125 |
1115774 | 1115774 | 2021-03-13 | Twin Falls | Idaho | 16083 | 9072 | 125 |
1102251 | 1102251 | 2021-03-09 | St. Clair | Alabama | 1115 | 9072 | 228 |
1073173 | 1073173 | 2021-02-28 | El Dorado | California | 6017 | 9072 | 100 |
998181 | 998181 | 2021-02-04 | Berkeley | West Virginia | 54003 | 9072 | 87 |
897591 | 897591 | 2021-01-04 | Kanawha | West Virginia | 54039 | 9072 | 209 |
809689 | 809689 | 2020-12-08 | Taylor | Texas | 48441 | 9072 | 136 |
672302 | 672302 | 2020-10-27 | Lancaster | Nebraska | 31109 | 9072 | 43 |
471525 | 471525 | 2020-08-26 | Camden | New Jersey | 34007 | 9072 | 585 |
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);