ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where county = "Pleasants", deaths = 11 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1663806 | 1663806 | 2021-08-28 | Pleasants | West Virginia | 54073 | 1032 | 11 |
1660558 | 1660558 | 2021-08-27 | Pleasants | West Virginia | 54073 | 1032 | 11 |
1374825 | 1374825 | 2021-05-31 | Pleasants | West Virginia | 54073 | 952 | 11 |
1371580 | 1371580 | 2021-05-30 | Pleasants | West Virginia | 54073 | 952 | 11 |
1368334 | 1368334 | 2021-05-29 | Pleasants | West Virginia | 54073 | 952 | 11 |
1365088 | 1365088 | 2021-05-28 | Pleasants | West Virginia | 54073 | 952 | 11 |
1361842 | 1361842 | 2021-05-27 | Pleasants | West Virginia | 54073 | 952 | 11 |
1358596 | 1358596 | 2021-05-26 | Pleasants | West Virginia | 54073 | 953 | 11 |
1355350 | 1355350 | 2021-05-25 | Pleasants | West Virginia | 54073 | 946 | 11 |
1352104 | 1352104 | 2021-05-24 | Pleasants | West Virginia | 54073 | 942 | 11 |
1348858 | 1348858 | 2021-05-23 | Pleasants | West Virginia | 54073 | 933 | 11 |
1345610 | 1345610 | 2021-05-22 | Pleasants | West Virginia | 54073 | 933 | 11 |
1342362 | 1342362 | 2021-05-21 | Pleasants | West Virginia | 54073 | 933 | 11 |
1339114 | 1339114 | 2021-05-20 | Pleasants | West Virginia | 54073 | 927 | 11 |
1335867 | 1335867 | 2021-05-19 | Pleasants | West Virginia | 54073 | 923 | 11 |
1332620 | 1332620 | 2021-05-18 | Pleasants | West Virginia | 54073 | 916 | 11 |
1329373 | 1329373 | 2021-05-17 | Pleasants | West Virginia | 54073 | 908 | 11 |
1326127 | 1326127 | 2021-05-16 | Pleasants | West Virginia | 54073 | 906 | 11 |
1322881 | 1322881 | 2021-05-15 | Pleasants | West Virginia | 54073 | 899 | 11 |
1319635 | 1319635 | 2021-05-14 | Pleasants | West Virginia | 54073 | 894 | 11 |
1316387 | 1316387 | 2021-05-13 | Pleasants | West Virginia | 54073 | 893 | 11 |
1313141 | 1313141 | 2021-05-12 | Pleasants | West Virginia | 54073 | 882 | 11 |
1309894 | 1309894 | 2021-05-11 | Pleasants | West Virginia | 54073 | 881 | 11 |
1306648 | 1306648 | 2021-05-10 | Pleasants | West Virginia | 54073 | 880 | 11 |
1303402 | 1303402 | 2021-05-09 | Pleasants | West Virginia | 54073 | 877 | 11 |
1300155 | 1300155 | 2021-05-08 | Pleasants | West Virginia | 54073 | 871 | 11 |
1296908 | 1296908 | 2021-05-07 | Pleasants | West Virginia | 54073 | 869 | 11 |
1293662 | 1293662 | 2021-05-06 | Pleasants | West Virginia | 54073 | 864 | 11 |
1290416 | 1290416 | 2021-05-05 | Pleasants | West Virginia | 54073 | 864 | 11 |
1287170 | 1287170 | 2021-05-04 | Pleasants | West Virginia | 54073 | 863 | 11 |
1283924 | 1283924 | 2021-05-03 | Pleasants | West Virginia | 54073 | 862 | 11 |
1280677 | 1280677 | 2021-05-02 | Pleasants | West Virginia | 54073 | 857 | 11 |
1277430 | 1277430 | 2021-05-01 | Pleasants | West Virginia | 54073 | 857 | 11 |
1274183 | 1274183 | 2021-04-30 | Pleasants | West Virginia | 54073 | 857 | 11 |
1270936 | 1270936 | 2021-04-29 | Pleasants | West Virginia | 54073 | 854 | 11 |
1267689 | 1267689 | 2021-04-28 | Pleasants | West Virginia | 54073 | 853 | 11 |
1264442 | 1264442 | 2021-04-27 | Pleasants | West Virginia | 54073 | 848 | 11 |
946287 | 946287 | 2021-01-19 | Pleasants | West Virginia | 54073 | 726 | 11 |
943040 | 943040 | 2021-01-18 | Pleasants | West Virginia | 54073 | 721 | 11 |
939795 | 939795 | 2021-01-17 | Pleasants | West Virginia | 54073 | 710 | 11 |
936550 | 936550 | 2021-01-16 | Pleasants | West Virginia | 54073 | 710 | 11 |
933305 | 933305 | 2021-01-15 | Pleasants | West Virginia | 54073 | 704 | 11 |
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);