ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Mercer" 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 |
---|---|---|---|---|---|---|---|
1624817 | 1624817 | 2021-08-16 | Mercer | West Virginia | 54055 | 5494 | 129 |
1621570 | 1621570 | 2021-08-15 | Mercer | West Virginia | 54055 | 5437 | 129 |
1618322 | 1618322 | 2021-08-14 | Mercer | West Virginia | 54055 | 5437 | 129 |
1615074 | 1615074 | 2021-08-13 | Mercer | West Virginia | 54055 | 5437 | 129 |
1611825 | 1611825 | 2021-08-12 | Mercer | West Virginia | 54055 | 5433 | 129 |
1608578 | 1608578 | 2021-08-11 | Mercer | West Virginia | 54055 | 5416 | 129 |
1605329 | 1605329 | 2021-08-10 | Mercer | West Virginia | 54055 | 5398 | 129 |
1602079 | 1602079 | 2021-08-09 | Mercer | West Virginia | 54055 | 5383 | 129 |
1598831 | 1598831 | 2021-08-08 | Mercer | West Virginia | 54055 | 5348 | 129 |
1595582 | 1595582 | 2021-08-07 | Mercer | West Virginia | 54055 | 5348 | 129 |
1592333 | 1592333 | 2021-08-06 | Mercer | West Virginia | 54055 | 5348 | 129 |
1589084 | 1589084 | 2021-08-05 | Mercer | West Virginia | 54055 | 5338 | 129 |
1585835 | 1585835 | 2021-08-04 | Mercer | West Virginia | 54055 | 5325 | 129 |
1582585 | 1582585 | 2021-08-03 | Mercer | West Virginia | 54055 | 5318 | 129 |
1579335 | 1579335 | 2021-08-02 | Mercer | West Virginia | 54055 | 5310 | 129 |
1576087 | 1576087 | 2021-08-01 | Mercer | West Virginia | 54055 | 5286 | 129 |
1572839 | 1572839 | 2021-07-31 | Mercer | West Virginia | 54055 | 5286 | 129 |
1569591 | 1569591 | 2021-07-30 | Mercer | West Virginia | 54055 | 5286 | 129 |
1566343 | 1566343 | 2021-07-29 | Mercer | West Virginia | 54055 | 5282 | 129 |
1563095 | 1563095 | 2021-07-28 | Mercer | West Virginia | 54055 | 5273 | 129 |
1559847 | 1559847 | 2021-07-27 | Mercer | West Virginia | 54055 | 5269 | 129 |
1556600 | 1556600 | 2021-07-26 | Mercer | West Virginia | 54055 | 5267 | 129 |
1553353 | 1553353 | 2021-07-25 | Mercer | West Virginia | 54055 | 5248 | 129 |
1550106 | 1550106 | 2021-07-24 | Mercer | West Virginia | 54055 | 5248 | 129 |
1546859 | 1546859 | 2021-07-23 | Mercer | West Virginia | 54055 | 5248 | 129 |
1543612 | 1543612 | 2021-07-22 | Mercer | West Virginia | 54055 | 5238 | 129 |
1540364 | 1540364 | 2021-07-21 | Mercer | West Virginia | 54055 | 5236 | 129 |
1537117 | 1537117 | 2021-07-20 | Mercer | West Virginia | 54055 | 5232 | 129 |
1533869 | 1533869 | 2021-07-19 | Mercer | West Virginia | 54055 | 5230 | 129 |
1530622 | 1530622 | 2021-07-18 | Mercer | West Virginia | 54055 | 5228 | 129 |
1527375 | 1527375 | 2021-07-17 | Mercer | West Virginia | 54055 | 5228 | 129 |
1524128 | 1524128 | 2021-07-16 | Mercer | West Virginia | 54055 | 5228 | 129 |
1520880 | 1520880 | 2021-07-15 | Mercer | West Virginia | 54055 | 5223 | 129 |
1517632 | 1517632 | 2021-07-14 | Mercer | West Virginia | 54055 | 5219 | 129 |
1514385 | 1514385 | 2021-07-13 | Mercer | West Virginia | 54055 | 5215 | 128 |
1511139 | 1511139 | 2021-07-12 | Mercer | West Virginia | 54055 | 5213 | 128 |
1507892 | 1507892 | 2021-07-11 | Mercer | West Virginia | 54055 | 5205 | 128 |
1504646 | 1504646 | 2021-07-10 | Mercer | West Virginia | 54055 | 5205 | 128 |
1501400 | 1501400 | 2021-07-09 | Mercer | West Virginia | 54055 | 5205 | 128 |
1498154 | 1498154 | 2021-07-08 | Mercer | West Virginia | 54055 | 5201 | 128 |
1494907 | 1494907 | 2021-07-07 | Mercer | West Virginia | 54055 | 5201 | 128 |
1491660 | 1491660 | 2021-07-06 | Mercer | West Virginia | 54055 | 5200 | 128 |
1488413 | 1488413 | 2021-07-05 | Mercer | West Virginia | 54055 | 5193 | 127 |
1485166 | 1485166 | 2021-07-04 | Mercer | West Virginia | 54055 | 5193 | 127 |
1481920 | 1481920 | 2021-07-03 | Mercer | West Virginia | 54055 | 5193 | 127 |
1478673 | 1478673 | 2021-07-02 | Mercer | West Virginia | 54055 | 5193 | 127 |
1475427 | 1475427 | 2021-07-01 | Mercer | West Virginia | 54055 | 5186 | 126 |
1472181 | 1472181 | 2021-06-30 | Mercer | West Virginia | 54055 | 5181 | 122 |
1468936 | 1468936 | 2021-06-29 | Mercer | West Virginia | 54055 | 5178 | 121 |
1465691 | 1465691 | 2021-06-28 | Mercer | West Virginia | 54055 | 5174 | 121 |
1462446 | 1462446 | 2021-06-27 | Mercer | West Virginia | 54055 | 5156 | 121 |
1459201 | 1459201 | 2021-06-26 | Mercer | West Virginia | 54055 | 5156 | 121 |
1455956 | 1455956 | 2021-06-25 | Mercer | West Virginia | 54055 | 5156 | 121 |
1452711 | 1452711 | 2021-06-24 | Mercer | West Virginia | 54055 | 5151 | 121 |
1449465 | 1449465 | 2021-06-23 | Mercer | West Virginia | 54055 | 5149 | 121 |
1446220 | 1446220 | 2021-06-22 | Mercer | West Virginia | 54055 | 5145 | 121 |
1442975 | 1442975 | 2021-06-21 | Mercer | West Virginia | 54055 | 5124 | 121 |
1439730 | 1439730 | 2021-06-20 | Mercer | West Virginia | 54055 | 5124 | 121 |
1436483 | 1436483 | 2021-06-19 | Mercer | West Virginia | 54055 | 5124 | 121 |
1433236 | 1433236 | 2021-06-18 | Mercer | West Virginia | 54055 | 5124 | 121 |
1429990 | 1429990 | 2021-06-17 | Mercer | West Virginia | 54055 | 5124 | 121 |
1426745 | 1426745 | 2021-06-16 | Mercer | West Virginia | 54055 | 5117 | 121 |
1423499 | 1423499 | 2021-06-15 | Mercer | West Virginia | 54055 | 5105 | 121 |
1420252 | 1420252 | 2021-06-14 | Mercer | West Virginia | 54055 | 5105 | 121 |
1417007 | 1417007 | 2021-06-13 | Mercer | West Virginia | 54055 | 5100 | 121 |
1413761 | 1413761 | 2021-06-12 | Mercer | West Virginia | 54055 | 5100 | 121 |
1410516 | 1410516 | 2021-06-11 | Mercer | West Virginia | 54055 | 5100 | 121 |
1407271 | 1407271 | 2021-06-10 | Mercer | West Virginia | 54055 | 5096 | 121 |
1404025 | 1404025 | 2021-06-09 | Mercer | West Virginia | 54055 | 5092 | 121 |
1400780 | 1400780 | 2021-06-08 | Mercer | West Virginia | 54055 | 5087 | 120 |
1397535 | 1397535 | 2021-06-07 | Mercer | West Virginia | 54055 | 5087 | 120 |
1394288 | 1394288 | 2021-06-06 | Mercer | West Virginia | 54055 | 5076 | 120 |
1391043 | 1391043 | 2021-06-05 | Mercer | West Virginia | 54055 | 5076 | 120 |
1387798 | 1387798 | 2021-06-04 | Mercer | West Virginia | 54055 | 5076 | 120 |
1384553 | 1384553 | 2021-06-03 | Mercer | West Virginia | 54055 | 5072 | 119 |
1381307 | 1381307 | 2021-06-02 | Mercer | West Virginia | 54055 | 5068 | 119 |
1378062 | 1378062 | 2021-06-01 | Mercer | West Virginia | 54055 | 5064 | 119 |
1374816 | 1374816 | 2021-05-31 | Mercer | West Virginia | 54055 | 5043 | 119 |
1371571 | 1371571 | 2021-05-30 | Mercer | West Virginia | 54055 | 5043 | 119 |
1368325 | 1368325 | 2021-05-29 | Mercer | West Virginia | 54055 | 5043 | 119 |
1365079 | 1365079 | 2021-05-28 | Mercer | West Virginia | 54055 | 5043 | 119 |
1361833 | 1361833 | 2021-05-27 | Mercer | West Virginia | 54055 | 5037 | 119 |
1358587 | 1358587 | 2021-05-26 | Mercer | West Virginia | 54055 | 5021 | 119 |
1355341 | 1355341 | 2021-05-25 | Mercer | West Virginia | 54055 | 5015 | 117 |
1352095 | 1352095 | 2021-05-24 | Mercer | West Virginia | 54055 | 4999 | 117 |
1348849 | 1348849 | 2021-05-23 | Mercer | West Virginia | 54055 | 4962 | 117 |
1345601 | 1345601 | 2021-05-22 | Mercer | West Virginia | 54055 | 4962 | 117 |
1342353 | 1342353 | 2021-05-21 | Mercer | West Virginia | 54055 | 4962 | 117 |
1339105 | 1339105 | 2021-05-20 | Mercer | West Virginia | 54055 | 4943 | 117 |
1335858 | 1335858 | 2021-05-19 | Mercer | West Virginia | 54055 | 4929 | 116 |
1332611 | 1332611 | 2021-05-18 | Mercer | West Virginia | 54055 | 4919 | 116 |
1329364 | 1329364 | 2021-05-17 | Mercer | West Virginia | 54055 | 4908 | 116 |
1326118 | 1326118 | 2021-05-16 | Mercer | West Virginia | 54055 | 4901 | 116 |
1322872 | 1322872 | 2021-05-15 | Mercer | West Virginia | 54055 | 4886 | 116 |
1319626 | 1319626 | 2021-05-14 | Mercer | West Virginia | 54055 | 4870 | 116 |
1316378 | 1316378 | 2021-05-13 | Mercer | West Virginia | 54055 | 4856 | 116 |
1313132 | 1313132 | 2021-05-12 | Mercer | West Virginia | 54055 | 4831 | 116 |
1309885 | 1309885 | 2021-05-11 | Mercer | West Virginia | 54055 | 4815 | 115 |
1306639 | 1306639 | 2021-05-10 | Mercer | West Virginia | 54055 | 4808 | 115 |
1303393 | 1303393 | 2021-05-09 | Mercer | West Virginia | 54055 | 4801 | 115 |
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);