ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where cases = 16560 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Washington 3
- Indiana 2
- Maryland 2
- Alabama 1
- California 1
- Idaho 1
- Ohio 1
- Oklahoma 1
- South Carolina 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2203095 | 2203095 | 2022-02-10 | Wise | Texas | 48497 | 16560 | 234 |
2099435 | 2099435 | 2022-01-10 | Talladega | Alabama | 1121 | 16560 | 313 |
2102566 | 2102566 | 2022-01-10 | Manitowoc | Wisconsin | 55071 | 16560 | 148 |
1973360 | 1973360 | 2021-12-02 | Monroe | Indiana | 18105 | 16560 | 223 |
1969952 | 1969952 | 2021-12-01 | Twin Falls | Idaho | 16083 | 16560 | 232 |
1848934 | 1848934 | 2021-10-24 | Kitsap | Washington | 53035 | 16560 | 228 |
1845684 | 1845684 | 2021-10-23 | Kitsap | Washington | 53035 | 16560 | 228 |
1842434 | 1842434 | 2021-10-22 | Kitsap | Washington | 53035 | 16560 | 228 |
1673869 | 1673869 | 2021-09-01 | Marin | California | 6041 | 16560 | 240 |
1448478 | 1448478 | 2021-06-23 | Trumbull | Ohio | 39155 | 16560 | 483 |
1366416 | 1366416 | 2021-05-29 | Harford | Maryland | 24025 | 16560 | 292 |
1164647 | 1164647 | 2021-03-28 | Porter | Indiana | 18127 | 16560 | 303 |
650304 | 650304 | 2020-10-20 | Greenville | South Carolina | 45045 | 16560 | 334 |
626355 | 626355 | 2020-10-13 | Baltimore city | Maryland | 24510 | 16560 | 494 |
552806 | 552806 | 2020-09-20 | Oklahoma | Oklahoma | 40109 | 16560 | 182 |
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);