ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 13862 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- Ohio 8
- Oregon 2
- Colorado 1
- Maine 1
- Mississippi 1
- New Mexico 1
- North Carolina 1
- Pennsylvania 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2335687 | 2335687 | 2022-03-23 | Sandusky | Ohio | 39143 | 13862 | 232 |
2332433 | 2332433 | 2022-03-22 | Sandusky | Ohio | 39143 | 13862 | 232 |
2329180 | 2329180 | 2022-03-21 | Sandusky | Ohio | 39143 | 13862 | 232 |
2325928 | 2325928 | 2022-03-20 | Sandusky | Ohio | 39143 | 13862 | 232 |
2322675 | 2322675 | 2022-03-19 | Sandusky | Ohio | 39143 | 13862 | 232 |
2319421 | 2319421 | 2022-03-18 | Sandusky | Ohio | 39143 | 13862 | 232 |
2316167 | 2316167 | 2022-03-17 | Sandusky | Ohio | 39143 | 13862 | 232 |
2013848 | 2013848 | 2021-12-14 | Douglas | Oregon | 41019 | 13862 | 308 |
1946499 | 1946499 | 2021-11-23 | Wood | West Virginia | 54107 | 13862 | 262 |
1432358 | 1432358 | 2021-06-18 | Lane | Oregon | 41039 | 13862 | 162 |
1418603 | 1418603 | 2021-06-14 | Rankin | Mississippi | 28121 | 13862 | 282 |
1179171 | 1179171 | 2021-04-01 | Lebanon | Pennsylvania | 42075 | 13862 | 265 |
1168317 | 1168317 | 2021-03-29 | Cumberland | Maine | 23005 | 13862 | 185 |
1136745 | 1136745 | 2021-03-19 | Greene | Ohio | 39057 | 13862 | 227 |
1013296 | 1013296 | 2021-02-09 | Rowan | North Carolina | 37159 | 13862 | 259 |
920733 | 920733 | 2021-01-12 | Pueblo | Colorado | 8101 | 13862 | 334 |
785952 | 785952 | 2020-12-01 | Doña Ana | New Mexico | 35013 | 13862 | 191 |
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);