ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where county = "Pendleton" and deaths = 7 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1700751 | 1700751 | 2021-09-09 | Pendleton | Kentucky | 21191 | 1508 | 7 |
1697502 | 1697502 | 2021-09-08 | Pendleton | Kentucky | 21191 | 1493 | 7 |
1199491 | 1199491 | 2021-04-07 | Pendleton | West Virginia | 54071 | 670 | 7 |
1196242 | 1196242 | 2021-04-06 | Pendleton | West Virginia | 54071 | 670 | 7 |
1192994 | 1192994 | 2021-04-05 | Pendleton | West Virginia | 54071 | 671 | 7 |
1189744 | 1189744 | 2021-04-04 | Pendleton | West Virginia | 54071 | 670 | 7 |
1186497 | 1186497 | 2021-04-03 | Pendleton | West Virginia | 54071 | 671 | 7 |
1183250 | 1183250 | 2021-04-02 | Pendleton | West Virginia | 54071 | 668 | 7 |
1180003 | 1180003 | 2021-04-01 | Pendleton | West Virginia | 54071 | 668 | 7 |
1176756 | 1176756 | 2021-03-31 | Pendleton | West Virginia | 54071 | 666 | 7 |
1173509 | 1173509 | 2021-03-30 | Pendleton | West Virginia | 54071 | 666 | 7 |
1170262 | 1170262 | 2021-03-29 | Pendleton | West Virginia | 54071 | 661 | 7 |
1167014 | 1167014 | 2021-03-28 | Pendleton | West Virginia | 54071 | 659 | 7 |
1163766 | 1163766 | 2021-03-27 | Pendleton | West Virginia | 54071 | 652 | 7 |
1160518 | 1160518 | 2021-03-26 | Pendleton | West Virginia | 54071 | 651 | 7 |
1157270 | 1157270 | 2021-03-25 | Pendleton | West Virginia | 54071 | 647 | 7 |
1154023 | 1154023 | 2021-03-24 | Pendleton | West Virginia | 54071 | 643 | 7 |
1150776 | 1150776 | 2021-03-23 | Pendleton | West Virginia | 54071 | 641 | 7 |
1147529 | 1147529 | 2021-03-22 | Pendleton | West Virginia | 54071 | 635 | 7 |
1144282 | 1144282 | 2021-03-21 | Pendleton | West Virginia | 54071 | 635 | 7 |
1141035 | 1141035 | 2021-03-20 | Pendleton | West Virginia | 54071 | 634 | 7 |
1137789 | 1137789 | 2021-03-19 | Pendleton | West Virginia | 54071 | 631 | 7 |
1134543 | 1134543 | 2021-03-18 | Pendleton | West Virginia | 54071 | 630 | 7 |
1131295 | 1131295 | 2021-03-17 | Pendleton | West Virginia | 54071 | 628 | 7 |
1128048 | 1128048 | 2021-03-16 | Pendleton | West Virginia | 54071 | 625 | 7 |
1124802 | 1124802 | 2021-03-15 | Pendleton | West Virginia | 54071 | 624 | 7 |
1121556 | 1121556 | 2021-03-14 | Pendleton | West Virginia | 54071 | 624 | 7 |
1118309 | 1118309 | 2021-03-13 | Pendleton | West Virginia | 54071 | 623 | 7 |
1115062 | 1115062 | 2021-03-12 | Pendleton | West Virginia | 54071 | 623 | 7 |
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);