ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 54037 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1488404 | 1488404 | 2021-07-05 | Jefferson | West Virginia | 54037 | 4800 | 59 |
1485157 | 1485157 | 2021-07-04 | Jefferson | West Virginia | 54037 | 4800 | 59 |
1481911 | 1481911 | 2021-07-03 | Jefferson | West Virginia | 54037 | 4800 | 59 |
1478664 | 1478664 | 2021-07-02 | Jefferson | West Virginia | 54037 | 4800 | 59 |
1475418 | 1475418 | 2021-07-01 | Jefferson | West Virginia | 54037 | 4800 | 59 |
1472172 | 1472172 | 2021-06-30 | Jefferson | West Virginia | 54037 | 4799 | 59 |
1468927 | 1468927 | 2021-06-29 | Jefferson | West Virginia | 54037 | 4798 | 58 |
1465682 | 1465682 | 2021-06-28 | Jefferson | West Virginia | 54037 | 4798 | 58 |
1462437 | 1462437 | 2021-06-27 | Jefferson | West Virginia | 54037 | 4794 | 57 |
1459192 | 1459192 | 2021-06-26 | Jefferson | West Virginia | 54037 | 4794 | 57 |
1455947 | 1455947 | 2021-06-25 | Jefferson | West Virginia | 54037 | 4794 | 57 |
1452702 | 1452702 | 2021-06-24 | Jefferson | West Virginia | 54037 | 4793 | 57 |
1449456 | 1449456 | 2021-06-23 | Jefferson | West Virginia | 54037 | 4793 | 57 |
1446211 | 1446211 | 2021-06-22 | Jefferson | West Virginia | 54037 | 4790 | 57 |
1442966 | 1442966 | 2021-06-21 | Jefferson | West Virginia | 54037 | 4777 | 56 |
1439721 | 1439721 | 2021-06-20 | Jefferson | West Virginia | 54037 | 4777 | 56 |
1436474 | 1436474 | 2021-06-19 | Jefferson | West Virginia | 54037 | 4777 | 56 |
1433227 | 1433227 | 2021-06-18 | Jefferson | West Virginia | 54037 | 4777 | 56 |
1429981 | 1429981 | 2021-06-17 | Jefferson | West Virginia | 54037 | 4777 | 56 |
1426736 | 1426736 | 2021-06-16 | Jefferson | West Virginia | 54037 | 4776 | 56 |
1423490 | 1423490 | 2021-06-15 | Jefferson | West Virginia | 54037 | 4777 | 56 |
1420243 | 1420243 | 2021-06-14 | Jefferson | West Virginia | 54037 | 4773 | 56 |
1416998 | 1416998 | 2021-06-13 | Jefferson | West Virginia | 54037 | 4767 | 56 |
1413752 | 1413752 | 2021-06-12 | Jefferson | West Virginia | 54037 | 4767 | 56 |
1410507 | 1410507 | 2021-06-11 | Jefferson | West Virginia | 54037 | 4767 | 56 |
1407262 | 1407262 | 2021-06-10 | Jefferson | West Virginia | 54037 | 4766 | 56 |
1404016 | 1404016 | 2021-06-09 | Jefferson | West Virginia | 54037 | 4766 | 56 |
1400771 | 1400771 | 2021-06-08 | Jefferson | West Virginia | 54037 | 4763 | 53 |
1397526 | 1397526 | 2021-06-07 | Jefferson | West Virginia | 54037 | 4759 | 53 |
1394279 | 1394279 | 2021-06-06 | Jefferson | West Virginia | 54037 | 4759 | 53 |
1391034 | 1391034 | 2021-06-05 | Jefferson | West Virginia | 54037 | 4759 | 53 |
1387789 | 1387789 | 2021-06-04 | Jefferson | West Virginia | 54037 | 4759 | 53 |
1384544 | 1384544 | 2021-06-03 | Jefferson | West Virginia | 54037 | 4756 | 53 |
1381298 | 1381298 | 2021-06-02 | Jefferson | West Virginia | 54037 | 4759 | 53 |
1378053 | 1378053 | 2021-06-01 | Jefferson | West Virginia | 54037 | 4762 | 52 |
1374807 | 1374807 | 2021-05-31 | Jefferson | West Virginia | 54037 | 4704 | 52 |
1371562 | 1371562 | 2021-05-30 | Jefferson | West Virginia | 54037 | 4704 | 52 |
1368316 | 1368316 | 2021-05-29 | Jefferson | West Virginia | 54037 | 4704 | 52 |
1365070 | 1365070 | 2021-05-28 | Jefferson | West Virginia | 54037 | 4704 | 52 |
1361824 | 1361824 | 2021-05-27 | Jefferson | West Virginia | 54037 | 4691 | 52 |
1358578 | 1358578 | 2021-05-26 | Jefferson | West Virginia | 54037 | 4680 | 52 |
1355332 | 1355332 | 2021-05-25 | Jefferson | West Virginia | 54037 | 4671 | 52 |
1352086 | 1352086 | 2021-05-24 | Jefferson | West Virginia | 54037 | 4668 | 52 |
1348840 | 1348840 | 2021-05-23 | Jefferson | West Virginia | 54037 | 4654 | 52 |
1345592 | 1345592 | 2021-05-22 | Jefferson | West Virginia | 54037 | 4654 | 52 |
1342344 | 1342344 | 2021-05-21 | Jefferson | West Virginia | 54037 | 4654 | 52 |
1339096 | 1339096 | 2021-05-20 | Jefferson | West Virginia | 54037 | 4651 | 52 |
1335849 | 1335849 | 2021-05-19 | Jefferson | West Virginia | 54037 | 4646 | 52 |
1332602 | 1332602 | 2021-05-18 | Jefferson | West Virginia | 54037 | 4637 | 52 |
1329355 | 1329355 | 2021-05-17 | Jefferson | West Virginia | 54037 | 4631 | 51 |
1326109 | 1326109 | 2021-05-16 | Jefferson | West Virginia | 54037 | 4631 | 51 |
1322863 | 1322863 | 2021-05-15 | Jefferson | West Virginia | 54037 | 4628 | 51 |
1319617 | 1319617 | 2021-05-14 | Jefferson | West Virginia | 54037 | 4622 | 51 |
1316369 | 1316369 | 2021-05-13 | Jefferson | West Virginia | 54037 | 4620 | 51 |
1313123 | 1313123 | 2021-05-12 | Jefferson | West Virginia | 54037 | 4608 | 51 |
1309876 | 1309876 | 2021-05-11 | Jefferson | West Virginia | 54037 | 4603 | 51 |
1306630 | 1306630 | 2021-05-10 | Jefferson | West Virginia | 54037 | 4600 | 50 |
1303384 | 1303384 | 2021-05-09 | Jefferson | West Virginia | 54037 | 4590 | 50 |
1300137 | 1300137 | 2021-05-08 | Jefferson | West Virginia | 54037 | 4577 | 50 |
1296890 | 1296890 | 2021-05-07 | Jefferson | West Virginia | 54037 | 4567 | 50 |
1293644 | 1293644 | 2021-05-06 | Jefferson | West Virginia | 54037 | 4561 | 49 |
1290398 | 1290398 | 2021-05-05 | Jefferson | West Virginia | 54037 | 4548 | 49 |
1287152 | 1287152 | 2021-05-04 | Jefferson | West Virginia | 54037 | 4538 | 49 |
1283906 | 1283906 | 2021-05-03 | Jefferson | West Virginia | 54037 | 4531 | 48 |
1280659 | 1280659 | 2021-05-02 | Jefferson | West Virginia | 54037 | 4526 | 48 |
1277412 | 1277412 | 2021-05-01 | Jefferson | West Virginia | 54037 | 4513 | 48 |
1274165 | 1274165 | 2021-04-30 | Jefferson | West Virginia | 54037 | 4507 | 48 |
1270918 | 1270918 | 2021-04-29 | Jefferson | West Virginia | 54037 | 4496 | 48 |
1267671 | 1267671 | 2021-04-28 | Jefferson | West Virginia | 54037 | 4477 | 48 |
1264424 | 1264424 | 2021-04-27 | Jefferson | West Virginia | 54037 | 4464 | 48 |
1261177 | 1261177 | 2021-04-26 | Jefferson | West Virginia | 54037 | 4457 | 50 |
1257930 | 1257930 | 2021-04-25 | Jefferson | West Virginia | 54037 | 4445 | 50 |
1254683 | 1254683 | 2021-04-24 | Jefferson | West Virginia | 54037 | 4430 | 50 |
1251436 | 1251436 | 2021-04-23 | Jefferson | West Virginia | 54037 | 4409 | 50 |
1248189 | 1248189 | 2021-04-22 | Jefferson | West Virginia | 54037 | 4393 | 50 |
1244942 | 1244942 | 2021-04-21 | Jefferson | West Virginia | 54037 | 4373 | 50 |
1241695 | 1241695 | 2021-04-20 | Jefferson | West Virginia | 54037 | 4361 | 49 |
1238448 | 1238448 | 2021-04-19 | Jefferson | West Virginia | 54037 | 4348 | 49 |
1235201 | 1235201 | 2021-04-18 | Jefferson | West Virginia | 54037 | 4345 | 49 |
1231953 | 1231953 | 2021-04-17 | Jefferson | West Virginia | 54037 | 4327 | 49 |
1228705 | 1228705 | 2021-04-16 | Jefferson | West Virginia | 54037 | 4312 | 49 |
1225457 | 1225457 | 2021-04-15 | Jefferson | West Virginia | 54037 | 4296 | 49 |
1222210 | 1222210 | 2021-04-14 | Jefferson | West Virginia | 54037 | 4281 | 48 |
1218962 | 1218962 | 2021-04-13 | Jefferson | West Virginia | 54037 | 4262 | 48 |
1215714 | 1215714 | 2021-04-12 | Jefferson | West Virginia | 54037 | 4242 | 48 |
1212467 | 1212467 | 2021-04-11 | Jefferson | West Virginia | 54037 | 4226 | 48 |
1209218 | 1209218 | 2021-04-10 | Jefferson | West Virginia | 54037 | 4208 | 48 |
1205970 | 1205970 | 2021-04-09 | Jefferson | West Virginia | 54037 | 4198 | 48 |
1202722 | 1202722 | 2021-04-08 | Jefferson | West Virginia | 54037 | 4185 | 48 |
1199474 | 1199474 | 2021-04-07 | Jefferson | West Virginia | 54037 | 4161 | 48 |
1196225 | 1196225 | 2021-04-06 | Jefferson | West Virginia | 54037 | 4136 | 47 |
1192977 | 1192977 | 2021-04-05 | Jefferson | West Virginia | 54037 | 4127 | 47 |
1189727 | 1189727 | 2021-04-04 | Jefferson | West Virginia | 54037 | 4120 | 47 |
1186480 | 1186480 | 2021-04-03 | Jefferson | West Virginia | 54037 | 4107 | 47 |
1183233 | 1183233 | 2021-04-02 | Jefferson | West Virginia | 54037 | 4098 | 47 |
1179986 | 1179986 | 2021-04-01 | Jefferson | West Virginia | 54037 | 4077 | 47 |
1176739 | 1176739 | 2021-03-31 | Jefferson | West Virginia | 54037 | 4051 | 47 |
1173492 | 1173492 | 2021-03-30 | Jefferson | West Virginia | 54037 | 4009 | 46 |
1170245 | 1170245 | 2021-03-29 | Jefferson | West Virginia | 54037 | 3991 | 46 |
1166997 | 1166997 | 2021-03-28 | Jefferson | West Virginia | 54037 | 3963 | 46 |
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);