ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Brooke" 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 |
---|---|---|---|---|---|---|---|
1718995 | 1718995 | 2021-09-14 | Brooke | West Virginia | 54009 | 2644 | 62 |
1715747 | 1715747 | 2021-09-13 | Brooke | West Virginia | 54009 | 2616 | 62 |
1712501 | 1712501 | 2021-09-12 | Brooke | West Virginia | 54009 | 2598 | 62 |
1709254 | 1709254 | 2021-09-11 | Brooke | West Virginia | 54009 | 2578 | 62 |
1706007 | 1706007 | 2021-09-10 | Brooke | West Virginia | 54009 | 2560 | 62 |
1702757 | 1702757 | 2021-09-09 | Brooke | West Virginia | 54009 | 2535 | 62 |
1699508 | 1699508 | 2021-09-08 | Brooke | West Virginia | 54009 | 2527 | 62 |
1696260 | 1696260 | 2021-09-07 | Brooke | West Virginia | 54009 | 2509 | 62 |
1693012 | 1693012 | 2021-09-06 | Brooke | West Virginia | 54009 | 2499 | 62 |
1689763 | 1689763 | 2021-09-05 | Brooke | West Virginia | 54009 | 2491 | 61 |
1686513 | 1686513 | 2021-09-04 | Brooke | West Virginia | 54009 | 2468 | 61 |
1683262 | 1683262 | 2021-09-03 | Brooke | West Virginia | 54009 | 2443 | 61 |
1680012 | 1680012 | 2021-09-02 | Brooke | West Virginia | 54009 | 2440 | 61 |
1676764 | 1676764 | 2021-09-01 | Brooke | West Virginia | 54009 | 2436 | 61 |
1673517 | 1673517 | 2021-08-31 | Brooke | West Virginia | 54009 | 2425 | 61 |
1670269 | 1670269 | 2021-08-30 | Brooke | West Virginia | 54009 | 2416 | 61 |
1667022 | 1667022 | 2021-08-29 | Brooke | West Virginia | 54009 | 2405 | 61 |
1663774 | 1663774 | 2021-08-28 | Brooke | West Virginia | 54009 | 2384 | 61 |
1660526 | 1660526 | 2021-08-27 | Brooke | West Virginia | 54009 | 2384 | 61 |
1657278 | 1657278 | 2021-08-26 | Brooke | West Virginia | 54009 | 2381 | 61 |
1654030 | 1654030 | 2021-08-25 | Brooke | West Virginia | 54009 | 2368 | 61 |
1650784 | 1650784 | 2021-08-24 | Brooke | West Virginia | 54009 | 2347 | 61 |
1647535 | 1647535 | 2021-08-23 | Brooke | West Virginia | 54009 | 2347 | 61 |
1644286 | 1644286 | 2021-08-22 | Brooke | West Virginia | 54009 | 2333 | 61 |
1641036 | 1641036 | 2021-08-21 | Brooke | West Virginia | 54009 | 2333 | 61 |
1637786 | 1637786 | 2021-08-20 | Brooke | West Virginia | 54009 | 2333 | 61 |
1634536 | 1634536 | 2021-08-19 | Brooke | West Virginia | 54009 | 2324 | 61 |
1631288 | 1631288 | 2021-08-18 | Brooke | West Virginia | 54009 | 2320 | 61 |
1628041 | 1628041 | 2021-08-17 | Brooke | West Virginia | 54009 | 2316 | 61 |
1624794 | 1624794 | 2021-08-16 | Brooke | West Virginia | 54009 | 2309 | 61 |
1621547 | 1621547 | 2021-08-15 | Brooke | West Virginia | 54009 | 2300 | 61 |
1618299 | 1618299 | 2021-08-14 | Brooke | West Virginia | 54009 | 2300 | 61 |
1615051 | 1615051 | 2021-08-13 | Brooke | West Virginia | 54009 | 2300 | 61 |
1611802 | 1611802 | 2021-08-12 | Brooke | West Virginia | 54009 | 2299 | 61 |
1608555 | 1608555 | 2021-08-11 | Brooke | West Virginia | 54009 | 2299 | 61 |
1605306 | 1605306 | 2021-08-10 | Brooke | West Virginia | 54009 | 2297 | 61 |
1602056 | 1602056 | 2021-08-09 | Brooke | West Virginia | 54009 | 2291 | 61 |
1598808 | 1598808 | 2021-08-08 | Brooke | West Virginia | 54009 | 2285 | 61 |
1595559 | 1595559 | 2021-08-07 | Brooke | West Virginia | 54009 | 2285 | 61 |
1592310 | 1592310 | 2021-08-06 | Brooke | West Virginia | 54009 | 2285 | 61 |
1589061 | 1589061 | 2021-08-05 | Brooke | West Virginia | 54009 | 2282 | 61 |
1585812 | 1585812 | 2021-08-04 | Brooke | West Virginia | 54009 | 2279 | 61 |
1582562 | 1582562 | 2021-08-03 | Brooke | West Virginia | 54009 | 2279 | 61 |
1579312 | 1579312 | 2021-08-02 | Brooke | West Virginia | 54009 | 2278 | 61 |
1576064 | 1576064 | 2021-08-01 | Brooke | West Virginia | 54009 | 2271 | 61 |
1572816 | 1572816 | 2021-07-31 | Brooke | West Virginia | 54009 | 2271 | 61 |
1569568 | 1569568 | 2021-07-30 | Brooke | West Virginia | 54009 | 2271 | 61 |
1566320 | 1566320 | 2021-07-29 | Brooke | West Virginia | 54009 | 2269 | 60 |
1563072 | 1563072 | 2021-07-28 | Brooke | West Virginia | 54009 | 2269 | 60 |
1559824 | 1559824 | 2021-07-27 | Brooke | West Virginia | 54009 | 2266 | 60 |
1556577 | 1556577 | 2021-07-26 | Brooke | West Virginia | 54009 | 2264 | 60 |
1553330 | 1553330 | 2021-07-25 | Brooke | West Virginia | 54009 | 2257 | 60 |
1550083 | 1550083 | 2021-07-24 | Brooke | West Virginia | 54009 | 2257 | 60 |
1546836 | 1546836 | 2021-07-23 | Brooke | West Virginia | 54009 | 2257 | 60 |
1543589 | 1543589 | 2021-07-22 | Brooke | West Virginia | 54009 | 2255 | 60 |
1540341 | 1540341 | 2021-07-21 | Brooke | West Virginia | 54009 | 2254 | 60 |
1537094 | 1537094 | 2021-07-20 | Brooke | West Virginia | 54009 | 2253 | 60 |
1533846 | 1533846 | 2021-07-19 | Brooke | West Virginia | 54009 | 2253 | 60 |
1530599 | 1530599 | 2021-07-18 | Brooke | West Virginia | 54009 | 2253 | 60 |
1527352 | 1527352 | 2021-07-17 | Brooke | West Virginia | 54009 | 2253 | 60 |
1524105 | 1524105 | 2021-07-16 | Brooke | West Virginia | 54009 | 2253 | 60 |
1520857 | 1520857 | 2021-07-15 | Brooke | West Virginia | 54009 | 2252 | 60 |
1517609 | 1517609 | 2021-07-14 | Brooke | West Virginia | 54009 | 2250 | 60 |
1514362 | 1514362 | 2021-07-13 | Brooke | West Virginia | 54009 | 2250 | 60 |
1511116 | 1511116 | 2021-07-12 | Brooke | West Virginia | 54009 | 2250 | 60 |
1507869 | 1507869 | 2021-07-11 | Brooke | West Virginia | 54009 | 2249 | 60 |
1504623 | 1504623 | 2021-07-10 | Brooke | West Virginia | 54009 | 2249 | 60 |
1501377 | 1501377 | 2021-07-09 | Brooke | West Virginia | 54009 | 2249 | 60 |
1498131 | 1498131 | 2021-07-08 | Brooke | West Virginia | 54009 | 2249 | 60 |
1494884 | 1494884 | 2021-07-07 | Brooke | West Virginia | 54009 | 2249 | 60 |
1491637 | 1491637 | 2021-07-06 | Brooke | West Virginia | 54009 | 2249 | 60 |
1488390 | 1488390 | 2021-07-05 | Brooke | West Virginia | 54009 | 2247 | 60 |
1485143 | 1485143 | 2021-07-04 | Brooke | West Virginia | 54009 | 2247 | 60 |
1481897 | 1481897 | 2021-07-03 | Brooke | West Virginia | 54009 | 2247 | 60 |
1478650 | 1478650 | 2021-07-02 | Brooke | West Virginia | 54009 | 2247 | 60 |
1475404 | 1475404 | 2021-07-01 | Brooke | West Virginia | 54009 | 2247 | 60 |
1472158 | 1472158 | 2021-06-30 | Brooke | West Virginia | 54009 | 2247 | 60 |
1468913 | 1468913 | 2021-06-29 | Brooke | West Virginia | 54009 | 2247 | 60 |
1465668 | 1465668 | 2021-06-28 | Brooke | West Virginia | 54009 | 2247 | 60 |
1462423 | 1462423 | 2021-06-27 | Brooke | West Virginia | 54009 | 2247 | 60 |
1459178 | 1459178 | 2021-06-26 | Brooke | West Virginia | 54009 | 2247 | 60 |
1455933 | 1455933 | 2021-06-25 | Brooke | West Virginia | 54009 | 2247 | 60 |
1452688 | 1452688 | 2021-06-24 | Brooke | West Virginia | 54009 | 2247 | 60 |
1449442 | 1449442 | 2021-06-23 | Brooke | West Virginia | 54009 | 2247 | 60 |
1446197 | 1446197 | 2021-06-22 | Brooke | West Virginia | 54009 | 2246 | 60 |
1442952 | 1442952 | 2021-06-21 | Brooke | West Virginia | 54009 | 2246 | 60 |
1439707 | 1439707 | 2021-06-20 | Brooke | West Virginia | 54009 | 2246 | 60 |
1436460 | 1436460 | 2021-06-19 | Brooke | West Virginia | 54009 | 2246 | 60 |
1433213 | 1433213 | 2021-06-18 | Brooke | West Virginia | 54009 | 2246 | 60 |
1429967 | 1429967 | 2021-06-17 | Brooke | West Virginia | 54009 | 2246 | 60 |
1426722 | 1426722 | 2021-06-16 | Brooke | West Virginia | 54009 | 2246 | 60 |
1423476 | 1423476 | 2021-06-15 | Brooke | West Virginia | 54009 | 2246 | 60 |
1420229 | 1420229 | 2021-06-14 | Brooke | West Virginia | 54009 | 2246 | 60 |
1416984 | 1416984 | 2021-06-13 | Brooke | West Virginia | 54009 | 2241 | 60 |
1413738 | 1413738 | 2021-06-12 | Brooke | West Virginia | 54009 | 2241 | 60 |
1410493 | 1410493 | 2021-06-11 | Brooke | West Virginia | 54009 | 2241 | 60 |
1407248 | 1407248 | 2021-06-10 | Brooke | West Virginia | 54009 | 2241 | 60 |
1404002 | 1404002 | 2021-06-09 | Brooke | West Virginia | 54009 | 2241 | 60 |
1400757 | 1400757 | 2021-06-08 | Brooke | West Virginia | 54009 | 2240 | 60 |
1397512 | 1397512 | 2021-06-07 | Brooke | West Virginia | 54009 | 2236 | 60 |
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);