ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 51107 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1816362 | 1816362 | 2021-10-14 | Loudoun | Virginia | 51107 | 33482 | 294 |
1813114 | 1813114 | 2021-10-13 | Loudoun | Virginia | 51107 | 33414 | 293 |
1809865 | 1809865 | 2021-10-12 | Loudoun | Virginia | 51107 | 33350 | 293 |
1806615 | 1806615 | 2021-10-11 | Loudoun | Virginia | 51107 | 33175 | 292 |
1803365 | 1803365 | 2021-10-10 | Loudoun | Virginia | 51107 | 33175 | 292 |
1800116 | 1800116 | 2021-10-09 | Loudoun | Virginia | 51107 | 33175 | 292 |
1796867 | 1796867 | 2021-10-08 | Loudoun | Virginia | 51107 | 33175 | 292 |
1793618 | 1793618 | 2021-10-07 | Loudoun | Virginia | 51107 | 33122 | 292 |
1790369 | 1790369 | 2021-10-06 | Loudoun | Virginia | 51107 | 33084 | 292 |
1787121 | 1787121 | 2021-10-05 | Loudoun | Virginia | 51107 | 33017 | 291 |
1783872 | 1783872 | 2021-10-04 | Loudoun | Virginia | 51107 | 32954 | 291 |
1780623 | 1780623 | 2021-10-03 | Loudoun | Virginia | 51107 | 32793 | 291 |
1777373 | 1777373 | 2021-10-02 | Loudoun | Virginia | 51107 | 32793 | 291 |
1774123 | 1774123 | 2021-10-01 | Loudoun | Virginia | 51107 | 32793 | 291 |
1770873 | 1770873 | 2021-09-30 | Loudoun | Virginia | 51107 | 32745 | 290 |
1767624 | 1767624 | 2021-09-29 | Loudoun | Virginia | 51107 | 32662 | 290 |
1764375 | 1764375 | 2021-09-28 | Loudoun | Virginia | 51107 | 32604 | 288 |
1761126 | 1761126 | 2021-09-27 | Loudoun | Virginia | 51107 | 32529 | 288 |
1757878 | 1757878 | 2021-09-26 | Loudoun | Virginia | 51107 | 32308 | 288 |
1754630 | 1754630 | 2021-09-25 | Loudoun | Virginia | 51107 | 32308 | 288 |
1751382 | 1751382 | 2021-09-24 | Loudoun | Virginia | 51107 | 32308 | 288 |
1748133 | 1748133 | 2021-09-23 | Loudoun | Virginia | 51107 | 32220 | 288 |
1744883 | 1744883 | 2021-09-22 | Loudoun | Virginia | 51107 | 32122 | 288 |
1741634 | 1741634 | 2021-09-21 | Loudoun | Virginia | 51107 | 32012 | 287 |
1738385 | 1738385 | 2021-09-20 | Loudoun | Virginia | 51107 | 31910 | 287 |
1735136 | 1735136 | 2021-09-19 | Loudoun | Virginia | 51107 | 31654 | 287 |
1731886 | 1731886 | 2021-09-18 | Loudoun | Virginia | 51107 | 31654 | 287 |
1728636 | 1728636 | 2021-09-17 | Loudoun | Virginia | 51107 | 31654 | 287 |
1725386 | 1725386 | 2021-09-16 | Loudoun | Virginia | 51107 | 31553 | 287 |
1722137 | 1722137 | 2021-09-15 | Loudoun | Virginia | 51107 | 31478 | 287 |
1718889 | 1718889 | 2021-09-14 | Loudoun | Virginia | 51107 | 31407 | 287 |
1715641 | 1715641 | 2021-09-13 | Loudoun | Virginia | 51107 | 31342 | 287 |
1712395 | 1712395 | 2021-09-12 | Loudoun | Virginia | 51107 | 31101 | 285 |
1709148 | 1709148 | 2021-09-11 | Loudoun | Virginia | 51107 | 31101 | 285 |
1705901 | 1705901 | 2021-09-10 | Loudoun | Virginia | 51107 | 31101 | 285 |
1702651 | 1702651 | 2021-09-09 | Loudoun | Virginia | 51107 | 31073 | 285 |
1699402 | 1699402 | 2021-09-08 | Loudoun | Virginia | 51107 | 31051 | 285 |
1696154 | 1696154 | 2021-09-07 | Loudoun | Virginia | 51107 | 30903 | 285 |
1692906 | 1692906 | 2021-09-06 | Loudoun | Virginia | 51107 | 30863 | 285 |
1689657 | 1689657 | 2021-09-05 | Loudoun | Virginia | 51107 | 30641 | 285 |
1686407 | 1686407 | 2021-09-04 | Loudoun | Virginia | 51107 | 30641 | 285 |
1683156 | 1683156 | 2021-09-03 | Loudoun | Virginia | 51107 | 30641 | 285 |
1679906 | 1679906 | 2021-09-02 | Loudoun | Virginia | 51107 | 30485 | 285 |
1676658 | 1676658 | 2021-09-01 | Loudoun | Virginia | 51107 | 30441 | 285 |
1673411 | 1673411 | 2021-08-31 | Loudoun | Virginia | 51107 | 30375 | 285 |
1670163 | 1670163 | 2021-08-30 | Loudoun | Virginia | 51107 | 30311 | 285 |
1666916 | 1666916 | 2021-08-29 | Loudoun | Virginia | 51107 | 30125 | 285 |
1663668 | 1663668 | 2021-08-28 | Loudoun | Virginia | 51107 | 30125 | 285 |
1660420 | 1660420 | 2021-08-27 | Loudoun | Virginia | 51107 | 30125 | 285 |
1657171 | 1657171 | 2021-08-26 | Loudoun | Virginia | 51107 | 30060 | 285 |
1653924 | 1653924 | 2021-08-25 | Loudoun | Virginia | 51107 | 29995 | 285 |
1650678 | 1650678 | 2021-08-24 | Loudoun | Virginia | 51107 | 29902 | 285 |
1647429 | 1647429 | 2021-08-23 | Loudoun | Virginia | 51107 | 29833 | 284 |
1644180 | 1644180 | 2021-08-22 | Loudoun | Virginia | 51107 | 29644 | 284 |
1640930 | 1640930 | 2021-08-21 | Loudoun | Virginia | 51107 | 29644 | 284 |
1637680 | 1637680 | 2021-08-20 | Loudoun | Virginia | 51107 | 29644 | 284 |
1634430 | 1634430 | 2021-08-19 | Loudoun | Virginia | 51107 | 29581 | 284 |
1631182 | 1631182 | 2021-08-18 | Loudoun | Virginia | 51107 | 29529 | 284 |
1627935 | 1627935 | 2021-08-17 | Loudoun | Virginia | 51107 | 29459 | 284 |
1624688 | 1624688 | 2021-08-16 | Loudoun | Virginia | 51107 | 29414 | 284 |
1621441 | 1621441 | 2021-08-15 | Loudoun | Virginia | 51107 | 29316 | 283 |
1618193 | 1618193 | 2021-08-14 | Loudoun | Virginia | 51107 | 29316 | 283 |
1614945 | 1614945 | 2021-08-13 | Loudoun | Virginia | 51107 | 29316 | 283 |
1611696 | 1611696 | 2021-08-12 | Loudoun | Virginia | 51107 | 29247 | 283 |
1608449 | 1608449 | 2021-08-11 | Loudoun | Virginia | 51107 | 29179 | 283 |
1605200 | 1605200 | 2021-08-10 | Loudoun | Virginia | 51107 | 29109 | 283 |
1601950 | 1601950 | 2021-08-09 | Loudoun | Virginia | 51107 | 29048 | 283 |
1598702 | 1598702 | 2021-08-08 | Loudoun | Virginia | 51107 | 28909 | 283 |
1595453 | 1595453 | 2021-08-07 | Loudoun | Virginia | 51107 | 28909 | 283 |
1592204 | 1592204 | 2021-08-06 | Loudoun | Virginia | 51107 | 28909 | 283 |
1588955 | 1588955 | 2021-08-05 | Loudoun | Virginia | 51107 | 28859 | 283 |
1585706 | 1585706 | 2021-08-04 | Loudoun | Virginia | 51107 | 28814 | 283 |
1582456 | 1582456 | 2021-08-03 | Loudoun | Virginia | 51107 | 28757 | 283 |
1579206 | 1579206 | 2021-08-02 | Loudoun | Virginia | 51107 | 28728 | 283 |
1575958 | 1575958 | 2021-08-01 | Loudoun | Virginia | 51107 | 28600 | 283 |
1572710 | 1572710 | 2021-07-31 | Loudoun | Virginia | 51107 | 28600 | 283 |
1569462 | 1569462 | 2021-07-30 | Loudoun | Virginia | 51107 | 28600 | 283 |
1566214 | 1566214 | 2021-07-29 | Loudoun | Virginia | 51107 | 28554 | 283 |
1562966 | 1562966 | 2021-07-28 | Loudoun | Virginia | 51107 | 28530 | 283 |
1559718 | 1559718 | 2021-07-27 | Loudoun | Virginia | 51107 | 28478 | 283 |
1556471 | 1556471 | 2021-07-26 | Loudoun | Virginia | 51107 | 28441 | 283 |
1553224 | 1553224 | 2021-07-25 | Loudoun | Virginia | 51107 | 28376 | 283 |
1549977 | 1549977 | 2021-07-24 | Loudoun | Virginia | 51107 | 28376 | 283 |
1546730 | 1546730 | 2021-07-23 | Loudoun | Virginia | 51107 | 28376 | 283 |
1543483 | 1543483 | 2021-07-22 | Loudoun | Virginia | 51107 | 28337 | 283 |
1540235 | 1540235 | 2021-07-21 | Loudoun | Virginia | 51107 | 28315 | 283 |
1536988 | 1536988 | 2021-07-20 | Loudoun | Virginia | 51107 | 28292 | 283 |
1533740 | 1533740 | 2021-07-19 | Loudoun | Virginia | 51107 | 28233 | 283 |
1530493 | 1530493 | 2021-07-18 | Loudoun | Virginia | 51107 | 28207 | 283 |
1527246 | 1527246 | 2021-07-17 | Loudoun | Virginia | 51107 | 28207 | 283 |
1523999 | 1523999 | 2021-07-16 | Loudoun | Virginia | 51107 | 28207 | 283 |
1520751 | 1520751 | 2021-07-15 | Loudoun | Virginia | 51107 | 28188 | 283 |
1517503 | 1517503 | 2021-07-14 | Loudoun | Virginia | 51107 | 28168 | 283 |
1514256 | 1514256 | 2021-07-13 | Loudoun | Virginia | 51107 | 28151 | 283 |
1511010 | 1511010 | 2021-07-12 | Loudoun | Virginia | 51107 | 28141 | 283 |
1507763 | 1507763 | 2021-07-11 | Loudoun | Virginia | 51107 | 28134 | 283 |
1504517 | 1504517 | 2021-07-10 | Loudoun | Virginia | 51107 | 28128 | 283 |
1501271 | 1501271 | 2021-07-09 | Loudoun | Virginia | 51107 | 28121 | 283 |
1498025 | 1498025 | 2021-07-08 | Loudoun | Virginia | 51107 | 28114 | 283 |
1494778 | 1494778 | 2021-07-07 | Loudoun | Virginia | 51107 | 28110 | 283 |
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);