ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 13092 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Indiana 4
- South Carolina 3
- Kansas 2
- Ohio 2
- Arizona 1
- Arkansas 1
- Florida 1
- Illinois 1
- Iowa 1
- Louisiana 1
- Maine 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- South Dakota 1
- Texas 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2383702 | 2383702 | 2022-04-07 | Goodhue | Minnesota | 27049 | 13092 | 130 |
2198514 | 2198514 | 2022-02-09 | Joplin | Missouri | 13092 | 204 | |
2191177 | 2191177 | 2022-02-07 | Dearborn | Indiana | 18029 | 13092 | 125 |
2151285 | 2151285 | 2022-01-25 | Jefferson | West Virginia | 54037 | 13092 | 111 |
2027396 | 2027396 | 2021-12-18 | Maverick | Texas | 48323 | 13092 | 412 |
1996328 | 1996328 | 2021-12-09 | Reno | Kansas | 20155 | 13092 | 175 |
1993077 | 1993077 | 2021-12-08 | Reno | Kansas | 20155 | 13092 | 175 |
1905093 | 1905093 | 2021-11-11 | Kosciusko | Indiana | 18085 | 13092 | 159 |
1711851 | 1711851 | 2021-09-12 | Oconee | South Carolina | 45073 | 13092 | 163 |
1708604 | 1708604 | 2021-09-11 | Oconee | South Carolina | 45073 | 13092 | 163 |
1705357 | 1705357 | 2021-09-10 | Oconee | South Carolina | 45073 | 13092 | 163 |
1385426 | 1385426 | 2021-06-04 | Madison | Indiana | 18095 | 13092 | 361 |
1354343 | 1354343 | 2021-05-25 | Portage | Ohio | 39133 | 13092 | 211 |
1343189 | 1343189 | 2021-05-22 | Clark | Indiana | 18019 | 13092 | 201 |
1320949 | 1320949 | 2021-05-15 | York | Maine | 23031 | 13092 | 129 |
1305662 | 1305662 | 2021-05-10 | Wood | Ohio | 39173 | 13092 | 189 |
1180243 | 1180243 | 2021-04-02 | Craighead | Arkansas | 5031 | 13092 | 174 |
1136132 | 1136132 | 2021-03-19 | Rankin | Mississippi | 28121 | 13092 | 271 |
1130675 | 1130675 | 2021-03-17 | Pennington | South Dakota | 46103 | 13092 | 189 |
1080316 | 1080316 | 2021-03-02 | Johnson | Iowa | 19103 | 13092 | 74 |
869642 | 869642 | 2020-12-27 | Calcasieu | Louisiana | 22019 | 13092 | 280 |
719556 | 719556 | 2020-11-11 | Brevard | Florida | 12009 | 13092 | 400 |
631748 | 631748 | 2020-10-15 | Yuma | Arizona | 4027 | 13092 | 349 |
573928 | 573928 | 2020-09-27 | Kane | Illinois | 17089 | 13092 | 327 |
242964 | 242964 | 2020-06-15 | Fairfax | Virginia | 51059 | 13092 | 423 |
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);