ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
142 rows where deaths = 7, fips = 51720 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 |
---|---|---|---|---|---|---|---|
1666934 | 1666934 | 2021-08-29 | Norton city | Virginia | 51720 | 371 | 7 |
1663686 | 1663686 | 2021-08-28 | Norton city | Virginia | 51720 | 371 | 7 |
1660438 | 1660438 | 2021-08-27 | Norton city | Virginia | 51720 | 371 | 7 |
1657189 | 1657189 | 2021-08-26 | Norton city | Virginia | 51720 | 369 | 7 |
1653942 | 1653942 | 2021-08-25 | Norton city | Virginia | 51720 | 364 | 7 |
1650696 | 1650696 | 2021-08-24 | Norton city | Virginia | 51720 | 360 | 7 |
1647447 | 1647447 | 2021-08-23 | Norton city | Virginia | 51720 | 360 | 7 |
1644198 | 1644198 | 2021-08-22 | Norton city | Virginia | 51720 | 354 | 7 |
1640948 | 1640948 | 2021-08-21 | Norton city | Virginia | 51720 | 354 | 7 |
1637698 | 1637698 | 2021-08-20 | Norton city | Virginia | 51720 | 354 | 7 |
1634448 | 1634448 | 2021-08-19 | Norton city | Virginia | 51720 | 352 | 7 |
1631200 | 1631200 | 2021-08-18 | Norton city | Virginia | 51720 | 351 | 7 |
1627953 | 1627953 | 2021-08-17 | Norton city | Virginia | 51720 | 344 | 7 |
1624706 | 1624706 | 2021-08-16 | Norton city | Virginia | 51720 | 341 | 7 |
1621459 | 1621459 | 2021-08-15 | Norton city | Virginia | 51720 | 336 | 7 |
1618211 | 1618211 | 2021-08-14 | Norton city | Virginia | 51720 | 336 | 7 |
1614963 | 1614963 | 2021-08-13 | Norton city | Virginia | 51720 | 336 | 7 |
1611714 | 1611714 | 2021-08-12 | Norton city | Virginia | 51720 | 334 | 7 |
1608467 | 1608467 | 2021-08-11 | Norton city | Virginia | 51720 | 333 | 7 |
1605218 | 1605218 | 2021-08-10 | Norton city | Virginia | 51720 | 329 | 7 |
1601968 | 1601968 | 2021-08-09 | Norton city | Virginia | 51720 | 328 | 7 |
1598720 | 1598720 | 2021-08-08 | Norton city | Virginia | 51720 | 327 | 7 |
1595471 | 1595471 | 2021-08-07 | Norton city | Virginia | 51720 | 327 | 7 |
1592222 | 1592222 | 2021-08-06 | Norton city | Virginia | 51720 | 327 | 7 |
1588973 | 1588973 | 2021-08-05 | Norton city | Virginia | 51720 | 325 | 7 |
1585724 | 1585724 | 2021-08-04 | Norton city | Virginia | 51720 | 324 | 7 |
1582474 | 1582474 | 2021-08-03 | Norton city | Virginia | 51720 | 311 | 7 |
1579224 | 1579224 | 2021-08-02 | Norton city | Virginia | 51720 | 309 | 7 |
1575976 | 1575976 | 2021-08-01 | Norton city | Virginia | 51720 | 303 | 7 |
1572728 | 1572728 | 2021-07-31 | Norton city | Virginia | 51720 | 303 | 7 |
1569480 | 1569480 | 2021-07-30 | Norton city | Virginia | 51720 | 303 | 7 |
1566232 | 1566232 | 2021-07-29 | Norton city | Virginia | 51720 | 303 | 7 |
1562984 | 1562984 | 2021-07-28 | Norton city | Virginia | 51720 | 303 | 7 |
1559736 | 1559736 | 2021-07-27 | Norton city | Virginia | 51720 | 303 | 7 |
1556489 | 1556489 | 2021-07-26 | Norton city | Virginia | 51720 | 299 | 7 |
1553242 | 1553242 | 2021-07-25 | Norton city | Virginia | 51720 | 294 | 7 |
1549995 | 1549995 | 2021-07-24 | Norton city | Virginia | 51720 | 294 | 7 |
1546748 | 1546748 | 2021-07-23 | Norton city | Virginia | 51720 | 294 | 7 |
1543501 | 1543501 | 2021-07-22 | Norton city | Virginia | 51720 | 294 | 7 |
1540253 | 1540253 | 2021-07-21 | Norton city | Virginia | 51720 | 294 | 7 |
1537006 | 1537006 | 2021-07-20 | Norton city | Virginia | 51720 | 294 | 7 |
1533758 | 1533758 | 2021-07-19 | Norton city | Virginia | 51720 | 293 | 7 |
1530511 | 1530511 | 2021-07-18 | Norton city | Virginia | 51720 | 293 | 7 |
1527264 | 1527264 | 2021-07-17 | Norton city | Virginia | 51720 | 293 | 7 |
1524017 | 1524017 | 2021-07-16 | Norton city | Virginia | 51720 | 293 | 7 |
1520769 | 1520769 | 2021-07-15 | Norton city | Virginia | 51720 | 293 | 7 |
1517521 | 1517521 | 2021-07-14 | Norton city | Virginia | 51720 | 293 | 7 |
1514274 | 1514274 | 2021-07-13 | Norton city | Virginia | 51720 | 293 | 7 |
1511028 | 1511028 | 2021-07-12 | Norton city | Virginia | 51720 | 293 | 7 |
1507781 | 1507781 | 2021-07-11 | Norton city | Virginia | 51720 | 293 | 7 |
1504535 | 1504535 | 2021-07-10 | Norton city | Virginia | 51720 | 293 | 7 |
1501289 | 1501289 | 2021-07-09 | Norton city | Virginia | 51720 | 292 | 7 |
1498043 | 1498043 | 2021-07-08 | Norton city | Virginia | 51720 | 292 | 7 |
1494796 | 1494796 | 2021-07-07 | Norton city | Virginia | 51720 | 292 | 7 |
1491549 | 1491549 | 2021-07-06 | Norton city | Virginia | 51720 | 292 | 7 |
1488302 | 1488302 | 2021-07-05 | Norton city | Virginia | 51720 | 292 | 7 |
1485055 | 1485055 | 2021-07-04 | Norton city | Virginia | 51720 | 291 | 7 |
1481809 | 1481809 | 2021-07-03 | Norton city | Virginia | 51720 | 290 | 7 |
1478562 | 1478562 | 2021-07-02 | Norton city | Virginia | 51720 | 289 | 7 |
1475316 | 1475316 | 2021-07-01 | Norton city | Virginia | 51720 | 289 | 7 |
1472070 | 1472070 | 2021-06-30 | Norton city | Virginia | 51720 | 289 | 7 |
1468825 | 1468825 | 2021-06-29 | Norton city | Virginia | 51720 | 290 | 7 |
1465580 | 1465580 | 2021-06-28 | Norton city | Virginia | 51720 | 290 | 7 |
1462335 | 1462335 | 2021-06-27 | Norton city | Virginia | 51720 | 290 | 7 |
1459090 | 1459090 | 2021-06-26 | Norton city | Virginia | 51720 | 290 | 7 |
1455845 | 1455845 | 2021-06-25 | Norton city | Virginia | 51720 | 290 | 7 |
1452600 | 1452600 | 2021-06-24 | Norton city | Virginia | 51720 | 290 | 7 |
1449354 | 1449354 | 2021-06-23 | Norton city | Virginia | 51720 | 290 | 7 |
1446109 | 1446109 | 2021-06-22 | Norton city | Virginia | 51720 | 290 | 7 |
1442864 | 1442864 | 2021-06-21 | Norton city | Virginia | 51720 | 290 | 7 |
1439619 | 1439619 | 2021-06-20 | Norton city | Virginia | 51720 | 290 | 7 |
1436372 | 1436372 | 2021-06-19 | Norton city | Virginia | 51720 | 290 | 7 |
1433125 | 1433125 | 2021-06-18 | Norton city | Virginia | 51720 | 290 | 7 |
1429879 | 1429879 | 2021-06-17 | Norton city | Virginia | 51720 | 290 | 7 |
1426634 | 1426634 | 2021-06-16 | Norton city | Virginia | 51720 | 290 | 7 |
1423388 | 1423388 | 2021-06-15 | Norton city | Virginia | 51720 | 290 | 7 |
1420141 | 1420141 | 2021-06-14 | Norton city | Virginia | 51720 | 290 | 7 |
1416896 | 1416896 | 2021-06-13 | Norton city | Virginia | 51720 | 290 | 7 |
1413650 | 1413650 | 2021-06-12 | Norton city | Virginia | 51720 | 290 | 7 |
1410405 | 1410405 | 2021-06-11 | Norton city | Virginia | 51720 | 290 | 7 |
1407160 | 1407160 | 2021-06-10 | Norton city | Virginia | 51720 | 290 | 7 |
1403914 | 1403914 | 2021-06-09 | Norton city | Virginia | 51720 | 290 | 7 |
1400669 | 1400669 | 2021-06-08 | Norton city | Virginia | 51720 | 290 | 7 |
1397424 | 1397424 | 2021-06-07 | Norton city | Virginia | 51720 | 290 | 7 |
1394177 | 1394177 | 2021-06-06 | Norton city | Virginia | 51720 | 290 | 7 |
1390932 | 1390932 | 2021-06-05 | Norton city | Virginia | 51720 | 290 | 7 |
1387687 | 1387687 | 2021-06-04 | Norton city | Virginia | 51720 | 290 | 7 |
1384442 | 1384442 | 2021-06-03 | Norton city | Virginia | 51720 | 290 | 7 |
1381196 | 1381196 | 2021-06-02 | Norton city | Virginia | 51720 | 290 | 7 |
1377951 | 1377951 | 2021-06-01 | Norton city | Virginia | 51720 | 290 | 7 |
1374705 | 1374705 | 2021-05-31 | Norton city | Virginia | 51720 | 290 | 7 |
1371460 | 1371460 | 2021-05-30 | Norton city | Virginia | 51720 | 290 | 7 |
1368214 | 1368214 | 2021-05-29 | Norton city | Virginia | 51720 | 290 | 7 |
1364968 | 1364968 | 2021-05-28 | Norton city | Virginia | 51720 | 290 | 7 |
1361722 | 1361722 | 2021-05-27 | Norton city | Virginia | 51720 | 290 | 7 |
1358476 | 1358476 | 2021-05-26 | Norton city | Virginia | 51720 | 290 | 7 |
1355230 | 1355230 | 2021-05-25 | Norton city | Virginia | 51720 | 291 | 7 |
1351984 | 1351984 | 2021-05-24 | Norton city | Virginia | 51720 | 290 | 7 |
1348738 | 1348738 | 2021-05-23 | Norton city | Virginia | 51720 | 290 | 7 |
1345490 | 1345490 | 2021-05-22 | Norton city | Virginia | 51720 | 290 | 7 |
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);