ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 54081 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 |
---|---|---|---|---|---|---|---|
1624830 | 1624830 | 2021-08-16 | Raleigh | West Virginia | 54081 | 7474 | 105 |
1621583 | 1621583 | 2021-08-15 | Raleigh | West Virginia | 54081 | 7432 | 104 |
1618335 | 1618335 | 2021-08-14 | Raleigh | West Virginia | 54081 | 7432 | 104 |
1615087 | 1615087 | 2021-08-13 | Raleigh | West Virginia | 54081 | 7432 | 104 |
1611838 | 1611838 | 2021-08-12 | Raleigh | West Virginia | 54081 | 7429 | 103 |
1608591 | 1608591 | 2021-08-11 | Raleigh | West Virginia | 54081 | 7403 | 102 |
1605342 | 1605342 | 2021-08-10 | Raleigh | West Virginia | 54081 | 7383 | 101 |
1602092 | 1602092 | 2021-08-09 | Raleigh | West Virginia | 54081 | 7365 | 101 |
1598844 | 1598844 | 2021-08-08 | Raleigh | West Virginia | 54081 | 7298 | 102 |
1595595 | 1595595 | 2021-08-07 | Raleigh | West Virginia | 54081 | 7298 | 102 |
1592346 | 1592346 | 2021-08-06 | Raleigh | West Virginia | 54081 | 7298 | 102 |
1589097 | 1589097 | 2021-08-05 | Raleigh | West Virginia | 54081 | 7280 | 102 |
1585848 | 1585848 | 2021-08-04 | Raleigh | West Virginia | 54081 | 7252 | 101 |
1582598 | 1582598 | 2021-08-03 | Raleigh | West Virginia | 54081 | 7236 | 101 |
1579348 | 1579348 | 2021-08-02 | Raleigh | West Virginia | 54081 | 7225 | 101 |
1576100 | 1576100 | 2021-08-01 | Raleigh | West Virginia | 54081 | 7183 | 101 |
1572852 | 1572852 | 2021-07-31 | Raleigh | West Virginia | 54081 | 7183 | 101 |
1569604 | 1569604 | 2021-07-30 | Raleigh | West Virginia | 54081 | 7183 | 101 |
1566356 | 1566356 | 2021-07-29 | Raleigh | West Virginia | 54081 | 7178 | 101 |
1563108 | 1563108 | 2021-07-28 | Raleigh | West Virginia | 54081 | 7163 | 101 |
1559860 | 1559860 | 2021-07-27 | Raleigh | West Virginia | 54081 | 7152 | 101 |
1556613 | 1556613 | 2021-07-26 | Raleigh | West Virginia | 54081 | 7149 | 101 |
1553366 | 1553366 | 2021-07-25 | Raleigh | West Virginia | 54081 | 7141 | 101 |
1550119 | 1550119 | 2021-07-24 | Raleigh | West Virginia | 54081 | 7141 | 101 |
1546872 | 1546872 | 2021-07-23 | Raleigh | West Virginia | 54081 | 7141 | 101 |
1543625 | 1543625 | 2021-07-22 | Raleigh | West Virginia | 54081 | 7136 | 101 |
1540377 | 1540377 | 2021-07-21 | Raleigh | West Virginia | 54081 | 7132 | 100 |
1537130 | 1537130 | 2021-07-20 | Raleigh | West Virginia | 54081 | 7130 | 100 |
1533882 | 1533882 | 2021-07-19 | Raleigh | West Virginia | 54081 | 7128 | 100 |
1530635 | 1530635 | 2021-07-18 | Raleigh | West Virginia | 54081 | 7119 | 100 |
1527388 | 1527388 | 2021-07-17 | Raleigh | West Virginia | 54081 | 7119 | 100 |
1524141 | 1524141 | 2021-07-16 | Raleigh | West Virginia | 54081 | 7119 | 100 |
1520893 | 1520893 | 2021-07-15 | Raleigh | West Virginia | 54081 | 7113 | 100 |
1517645 | 1517645 | 2021-07-14 | Raleigh | West Virginia | 54081 | 7110 | 100 |
1514398 | 1514398 | 2021-07-13 | Raleigh | West Virginia | 54081 | 7109 | 99 |
1511152 | 1511152 | 2021-07-12 | Raleigh | West Virginia | 54081 | 7106 | 99 |
1507905 | 1507905 | 2021-07-11 | Raleigh | West Virginia | 54081 | 7104 | 99 |
1504659 | 1504659 | 2021-07-10 | Raleigh | West Virginia | 54081 | 7104 | 99 |
1501413 | 1501413 | 2021-07-09 | Raleigh | West Virginia | 54081 | 7104 | 99 |
1498167 | 1498167 | 2021-07-08 | Raleigh | West Virginia | 54081 | 7104 | 98 |
1494920 | 1494920 | 2021-07-07 | Raleigh | West Virginia | 54081 | 7103 | 98 |
1491673 | 1491673 | 2021-07-06 | Raleigh | West Virginia | 54081 | 7096 | 98 |
1488426 | 1488426 | 2021-07-05 | Raleigh | West Virginia | 54081 | 7096 | 98 |
1485179 | 1485179 | 2021-07-04 | Raleigh | West Virginia | 54081 | 7096 | 98 |
1481933 | 1481933 | 2021-07-03 | Raleigh | West Virginia | 54081 | 7096 | 98 |
1478686 | 1478686 | 2021-07-02 | Raleigh | West Virginia | 54081 | 7096 | 98 |
1475440 | 1475440 | 2021-07-01 | Raleigh | West Virginia | 54081 | 7093 | 98 |
1472194 | 1472194 | 2021-06-30 | Raleigh | West Virginia | 54081 | 7091 | 98 |
1468949 | 1468949 | 2021-06-29 | Raleigh | West Virginia | 54081 | 7089 | 98 |
1465704 | 1465704 | 2021-06-28 | Raleigh | West Virginia | 54081 | 7090 | 98 |
1462459 | 1462459 | 2021-06-27 | Raleigh | West Virginia | 54081 | 7087 | 98 |
1459214 | 1459214 | 2021-06-26 | Raleigh | West Virginia | 54081 | 7087 | 98 |
1455969 | 1455969 | 2021-06-25 | Raleigh | West Virginia | 54081 | 7087 | 98 |
1452724 | 1452724 | 2021-06-24 | Raleigh | West Virginia | 54081 | 7084 | 98 |
1449478 | 1449478 | 2021-06-23 | Raleigh | West Virginia | 54081 | 7081 | 98 |
1446233 | 1446233 | 2021-06-22 | Raleigh | West Virginia | 54081 | 7079 | 97 |
1442988 | 1442988 | 2021-06-21 | Raleigh | West Virginia | 54081 | 7062 | 95 |
1439743 | 1439743 | 2021-06-20 | Raleigh | West Virginia | 54081 | 7062 | 95 |
1436496 | 1436496 | 2021-06-19 | Raleigh | West Virginia | 54081 | 7062 | 95 |
1433249 | 1433249 | 2021-06-18 | Raleigh | West Virginia | 54081 | 7062 | 95 |
1430003 | 1430003 | 2021-06-17 | Raleigh | West Virginia | 54081 | 7062 | 95 |
1426758 | 1426758 | 2021-06-16 | Raleigh | West Virginia | 54081 | 7057 | 94 |
1423512 | 1423512 | 2021-06-15 | Raleigh | West Virginia | 54081 | 7043 | 93 |
1420265 | 1420265 | 2021-06-14 | Raleigh | West Virginia | 54081 | 7036 | 92 |
1417020 | 1417020 | 2021-06-13 | Raleigh | West Virginia | 54081 | 7012 | 92 |
1413774 | 1413774 | 2021-06-12 | Raleigh | West Virginia | 54081 | 7012 | 92 |
1410529 | 1410529 | 2021-06-11 | Raleigh | West Virginia | 54081 | 7012 | 92 |
1407284 | 1407284 | 2021-06-10 | Raleigh | West Virginia | 54081 | 7007 | 92 |
1404038 | 1404038 | 2021-06-09 | Raleigh | West Virginia | 54081 | 6998 | 92 |
1400793 | 1400793 | 2021-06-08 | Raleigh | West Virginia | 54081 | 6996 | 90 |
1397548 | 1397548 | 2021-06-07 | Raleigh | West Virginia | 54081 | 6995 | 90 |
1394301 | 1394301 | 2021-06-06 | Raleigh | West Virginia | 54081 | 6987 | 90 |
1391056 | 1391056 | 2021-06-05 | Raleigh | West Virginia | 54081 | 6987 | 90 |
1387811 | 1387811 | 2021-06-04 | Raleigh | West Virginia | 54081 | 6987 | 90 |
1384566 | 1384566 | 2021-06-03 | Raleigh | West Virginia | 54081 | 6983 | 90 |
1381320 | 1381320 | 2021-06-02 | Raleigh | West Virginia | 54081 | 6976 | 88 |
1378075 | 1378075 | 2021-06-01 | Raleigh | West Virginia | 54081 | 6971 | 88 |
1374829 | 1374829 | 2021-05-31 | Raleigh | West Virginia | 54081 | 6958 | 88 |
1371584 | 1371584 | 2021-05-30 | Raleigh | West Virginia | 54081 | 6958 | 88 |
1368338 | 1368338 | 2021-05-29 | Raleigh | West Virginia | 54081 | 6958 | 88 |
1365092 | 1365092 | 2021-05-28 | Raleigh | West Virginia | 54081 | 6958 | 88 |
1361846 | 1361846 | 2021-05-27 | Raleigh | West Virginia | 54081 | 6945 | 88 |
1358600 | 1358600 | 2021-05-26 | Raleigh | West Virginia | 54081 | 6940 | 87 |
1355354 | 1355354 | 2021-05-25 | Raleigh | West Virginia | 54081 | 6928 | 87 |
1352108 | 1352108 | 2021-05-24 | Raleigh | West Virginia | 54081 | 6923 | 87 |
1348862 | 1348862 | 2021-05-23 | Raleigh | West Virginia | 54081 | 6898 | 87 |
1345614 | 1345614 | 2021-05-22 | Raleigh | West Virginia | 54081 | 6898 | 87 |
1342366 | 1342366 | 2021-05-21 | Raleigh | West Virginia | 54081 | 6898 | 87 |
1339118 | 1339118 | 2021-05-20 | Raleigh | West Virginia | 54081 | 6883 | 87 |
1335871 | 1335871 | 2021-05-19 | Raleigh | West Virginia | 54081 | 6871 | 87 |
1332624 | 1332624 | 2021-05-18 | Raleigh | West Virginia | 54081 | 6850 | 86 |
1329377 | 1329377 | 2021-05-17 | Raleigh | West Virginia | 54081 | 6843 | 86 |
1326131 | 1326131 | 2021-05-16 | Raleigh | West Virginia | 54081 | 6830 | 86 |
1322885 | 1322885 | 2021-05-15 | Raleigh | West Virginia | 54081 | 6822 | 86 |
1319639 | 1319639 | 2021-05-14 | Raleigh | West Virginia | 54081 | 6808 | 86 |
1316391 | 1316391 | 2021-05-13 | Raleigh | West Virginia | 54081 | 6790 | 86 |
1313145 | 1313145 | 2021-05-12 | Raleigh | West Virginia | 54081 | 6777 | 86 |
1309898 | 1309898 | 2021-05-11 | Raleigh | West Virginia | 54081 | 6760 | 85 |
1306652 | 1306652 | 2021-05-10 | Raleigh | West Virginia | 54081 | 6742 | 85 |
1303406 | 1303406 | 2021-05-09 | Raleigh | West Virginia | 54081 | 6735 | 85 |
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);