ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where county = "Crawford" and deaths = 165 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- Ohio 7
- Arkansas 6
- Pennsylvania 5
county 1
- Crawford · 18 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1701938 | 1701938 | 2021-09-09 | Crawford | Pennsylvania | 42039 | 8399 | 165 |
1705188 | 1705188 | 2021-09-10 | Crawford | Pennsylvania | 42039 | 8459 | 165 |
1708435 | 1708435 | 2021-09-11 | Crawford | Pennsylvania | 42039 | 8530 | 165 |
1711682 | 1711682 | 2021-09-12 | Crawford | Pennsylvania | 42039 | 8591 | 165 |
1714928 | 1714928 | 2021-09-13 | Crawford | Pennsylvania | 42039 | 8621 | 165 |
1764754 | 1764754 | 2021-09-29 | Crawford | Arkansas | 5033 | 10312 | 165 |
1768003 | 1768003 | 2021-09-30 | Crawford | Arkansas | 5033 | 10332 | 165 |
1771252 | 1771252 | 2021-10-01 | Crawford | Arkansas | 5033 | 10356 | 165 |
1774502 | 1774502 | 2021-10-02 | Crawford | Arkansas | 5033 | 10370 | 165 |
1777752 | 1777752 | 2021-10-03 | Crawford | Arkansas | 5033 | 10380 | 165 |
1781002 | 1781002 | 2021-10-04 | Crawford | Arkansas | 5033 | 10384 | 165 |
2068940 | 2068940 | 2021-12-31 | Crawford | Ohio | 39033 | 8448 | 165 |
2072191 | 2072191 | 2022-01-01 | Crawford | Ohio | 39033 | 8448 | 165 |
2075442 | 2075442 | 2022-01-02 | Crawford | Ohio | 39033 | 8562 | 165 |
2078693 | 2078693 | 2022-01-03 | Crawford | Ohio | 39033 | 8604 | 165 |
2081945 | 2081945 | 2022-01-04 | Crawford | Ohio | 39033 | 8678 | 165 |
2085197 | 2085197 | 2022-01-05 | Crawford | Ohio | 39033 | 8777 | 165 |
2088448 | 2088448 | 2022-01-06 | Crawford | Ohio | 39033 | 8849 | 165 |
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);