ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where deaths = 40, fips = 51167 and state = "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 |
---|---|---|---|---|---|---|---|
1647469 | 1647469 | 2021-08-23 | Russell | Virginia | 51167 | 2507 | 40 |
1644220 | 1644220 | 2021-08-22 | Russell | Virginia | 51167 | 2478 | 40 |
1640970 | 1640970 | 2021-08-21 | Russell | Virginia | 51167 | 2478 | 40 |
1637720 | 1637720 | 2021-08-20 | Russell | Virginia | 51167 | 2478 | 40 |
1634470 | 1634470 | 2021-08-19 | Russell | Virginia | 51167 | 2474 | 40 |
1631222 | 1631222 | 2021-08-18 | Russell | Virginia | 51167 | 2457 | 40 |
1627975 | 1627975 | 2021-08-17 | Russell | Virginia | 51167 | 2445 | 40 |
1624728 | 1624728 | 2021-08-16 | Russell | Virginia | 51167 | 2429 | 40 |
1621481 | 1621481 | 2021-08-15 | Russell | Virginia | 51167 | 2404 | 40 |
1618233 | 1618233 | 2021-08-14 | Russell | Virginia | 51167 | 2404 | 40 |
1614985 | 1614985 | 2021-08-13 | Russell | Virginia | 51167 | 2404 | 40 |
1611736 | 1611736 | 2021-08-12 | Russell | Virginia | 51167 | 2398 | 40 |
1608489 | 1608489 | 2021-08-11 | Russell | Virginia | 51167 | 2389 | 40 |
1605240 | 1605240 | 2021-08-10 | Russell | Virginia | 51167 | 2380 | 40 |
1601990 | 1601990 | 2021-08-09 | Russell | Virginia | 51167 | 2368 | 40 |
1598742 | 1598742 | 2021-08-08 | Russell | Virginia | 51167 | 2353 | 40 |
1595493 | 1595493 | 2021-08-07 | Russell | Virginia | 51167 | 2353 | 40 |
1592244 | 1592244 | 2021-08-06 | Russell | Virginia | 51167 | 2353 | 40 |
1588995 | 1588995 | 2021-08-05 | Russell | Virginia | 51167 | 2346 | 40 |
1585746 | 1585746 | 2021-08-04 | Russell | Virginia | 51167 | 2340 | 40 |
1582496 | 1582496 | 2021-08-03 | Russell | Virginia | 51167 | 2337 | 40 |
1579246 | 1579246 | 2021-08-02 | Russell | Virginia | 51167 | 2336 | 40 |
1575998 | 1575998 | 2021-08-01 | Russell | Virginia | 51167 | 2336 | 40 |
1572750 | 1572750 | 2021-07-31 | Russell | Virginia | 51167 | 2336 | 40 |
1569502 | 1569502 | 2021-07-30 | Russell | Virginia | 51167 | 2336 | 40 |
1566254 | 1566254 | 2021-07-29 | Russell | Virginia | 51167 | 2335 | 40 |
1563006 | 1563006 | 2021-07-28 | Russell | Virginia | 51167 | 2331 | 40 |
1559758 | 1559758 | 2021-07-27 | Russell | Virginia | 51167 | 2329 | 40 |
1556511 | 1556511 | 2021-07-26 | Russell | Virginia | 51167 | 2328 | 40 |
1553264 | 1553264 | 2021-07-25 | Russell | Virginia | 51167 | 2326 | 40 |
1550017 | 1550017 | 2021-07-24 | Russell | Virginia | 51167 | 2326 | 40 |
1546770 | 1546770 | 2021-07-23 | Russell | Virginia | 51167 | 2326 | 40 |
1543523 | 1543523 | 2021-07-22 | Russell | Virginia | 51167 | 2323 | 40 |
1540275 | 1540275 | 2021-07-21 | Russell | Virginia | 51167 | 2320 | 40 |
1537028 | 1537028 | 2021-07-20 | Russell | Virginia | 51167 | 2319 | 40 |
1533780 | 1533780 | 2021-07-19 | Russell | Virginia | 51167 | 2319 | 40 |
1530533 | 1530533 | 2021-07-18 | Russell | Virginia | 51167 | 2316 | 40 |
1527286 | 1527286 | 2021-07-17 | Russell | Virginia | 51167 | 2316 | 40 |
1524039 | 1524039 | 2021-07-16 | Russell | Virginia | 51167 | 2316 | 40 |
1520791 | 1520791 | 2021-07-15 | Russell | Virginia | 51167 | 2313 | 40 |
1517543 | 1517543 | 2021-07-14 | Russell | Virginia | 51167 | 2315 | 40 |
1514296 | 1514296 | 2021-07-13 | Russell | Virginia | 51167 | 2315 | 40 |
1511050 | 1511050 | 2021-07-12 | Russell | Virginia | 51167 | 2315 | 40 |
1507803 | 1507803 | 2021-07-11 | Russell | Virginia | 51167 | 2315 | 40 |
1504557 | 1504557 | 2021-07-10 | Russell | Virginia | 51167 | 2312 | 40 |
1501311 | 1501311 | 2021-07-09 | Russell | Virginia | 51167 | 2312 | 40 |
1498065 | 1498065 | 2021-07-08 | Russell | Virginia | 51167 | 2312 | 40 |
1494818 | 1494818 | 2021-07-07 | Russell | Virginia | 51167 | 2312 | 40 |
1491571 | 1491571 | 2021-07-06 | Russell | Virginia | 51167 | 2312 | 40 |
1488324 | 1488324 | 2021-07-05 | Russell | Virginia | 51167 | 2312 | 40 |
1485077 | 1485077 | 2021-07-04 | Russell | Virginia | 51167 | 2312 | 40 |
1481831 | 1481831 | 2021-07-03 | Russell | Virginia | 51167 | 2312 | 40 |
1478584 | 1478584 | 2021-07-02 | Russell | Virginia | 51167 | 2312 | 40 |
1475338 | 1475338 | 2021-07-01 | Russell | Virginia | 51167 | 2311 | 40 |
1472092 | 1472092 | 2021-06-30 | Russell | Virginia | 51167 | 2311 | 40 |
1468847 | 1468847 | 2021-06-29 | Russell | Virginia | 51167 | 2311 | 40 |
1465602 | 1465602 | 2021-06-28 | Russell | Virginia | 51167 | 2310 | 40 |
1462357 | 1462357 | 2021-06-27 | Russell | Virginia | 51167 | 2310 | 40 |
1459112 | 1459112 | 2021-06-26 | Russell | Virginia | 51167 | 2309 | 40 |
1455867 | 1455867 | 2021-06-25 | Russell | Virginia | 51167 | 2309 | 40 |
1452622 | 1452622 | 2021-06-24 | Russell | Virginia | 51167 | 2309 | 40 |
1449376 | 1449376 | 2021-06-23 | Russell | Virginia | 51167 | 2309 | 40 |
1446131 | 1446131 | 2021-06-22 | Russell | Virginia | 51167 | 2308 | 40 |
1442886 | 1442886 | 2021-06-21 | Russell | Virginia | 51167 | 2308 | 40 |
1439641 | 1439641 | 2021-06-20 | Russell | Virginia | 51167 | 2308 | 40 |
1436394 | 1436394 | 2021-06-19 | Russell | Virginia | 51167 | 2308 | 40 |
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);