ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 11704 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Louisiana 6
- Illinois 4
- Ohio 2
- Puerto Rico 2
- Arkansas 1
- Connecticut 1
- Georgia 1
- Missouri 1
- New Jersey 1
- South Carolina 1
- Texas 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498705 | 2498705 | 2022-05-12 | Mayaguez | Puerto Rico | 72097 | 11704 | |
2356746 | 2356746 | 2022-03-30 | Colquitt | Georgia | 13071 | 11704 | 240 |
2339208 | 2339208 | 2022-03-24 | Toa Alta | Puerto Rico | 72135 | 11704 | |
2236646 | 2236646 | 2022-02-21 | Marion | Illinois | 17121 | 11704 | 205 |
2233395 | 2233395 | 2022-02-20 | Marion | Illinois | 17121 | 11704 | 205 |
2230144 | 2230144 | 2022-02-19 | Marion | Illinois | 17121 | 11704 | 205 |
2226893 | 2226893 | 2022-02-18 | Marion | Illinois | 17121 | 11704 | 205 |
2189270 | 2189270 | 2022-02-06 | Ashland | Ohio | 39005 | 11704 | 200 |
2109043 | 2109043 | 2022-01-12 | Columbia | Wisconsin | 55021 | 11704 | 105 |
2081422 | 2081422 | 2022-01-04 | Lincoln | Missouri | 29113 | 11704 | 100 |
1790775 | 1790775 | 2021-10-07 | Lonoke | Arkansas | 5085 | 11704 | 171 |
1771005 | 1771005 | 2021-09-30 | Monongalia | West Virginia | 54061 | 11704 | 116 |
1315315 | 1315315 | 2021-05-13 | Allen | Ohio | 39003 | 11704 | 232 |
1210474 | 1210474 | 2021-04-11 | Ascension | Louisiana | 22005 | 11704 | 162 |
1210511 | 1210511 | 2021-04-11 | Rapides | Louisiana | 22079 | 11704 | 307 |
1207225 | 1207225 | 2021-04-10 | Ascension | Louisiana | 22005 | 11704 | 162 |
1207262 | 1207262 | 2021-04-10 | Rapides | Louisiana | 22079 | 11704 | 307 |
1203977 | 1203977 | 2021-04-09 | Ascension | Louisiana | 22005 | 11704 | 162 |
1204014 | 1204014 | 2021-04-09 | Rapides | Louisiana | 22079 | 11704 | 307 |
1121981 | 1121981 | 2021-03-15 | Litchfield | Connecticut | 9005 | 11704 | 284 |
955306 | 955306 | 2021-01-22 | Aiken | South Carolina | 45003 | 11704 | 162 |
951442 | 951442 | 2021-01-21 | Cumberland | New Jersey | 34011 | 11704 | 283 |
858224 | 858224 | 2020-12-23 | Ellis | Texas | 48139 | 11704 | 151 |
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);