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 |
---|---|---|---|---|---|---|---|
1949595 | 1949595 | 2021-11-24 | Loudoun | Virginia | 51107 | 35585 | 303 |
1946344 | 1946344 | 2021-11-23 | Loudoun | Virginia | 51107 | 35514 | 303 |
1943093 | 1943093 | 2021-11-22 | Loudoun | Virginia | 51107 | 35455 | 303 |
1939843 | 1939843 | 2021-11-21 | Loudoun | Virginia | 51107 | 35260 | 303 |
1936593 | 1936593 | 2021-11-20 | Loudoun | Virginia | 51107 | 35260 | 303 |
1933343 | 1933343 | 2021-11-19 | Loudoun | Virginia | 51107 | 35260 | 303 |
1930091 | 1930091 | 2021-11-18 | Loudoun | Virginia | 51107 | 35191 | 303 |
1926841 | 1926841 | 2021-11-17 | Loudoun | Virginia | 51107 | 35094 | 302 |
1923591 | 1923591 | 2021-11-16 | Loudoun | Virginia | 51107 | 34980 | 302 |
1920342 | 1920342 | 2021-11-15 | Loudoun | Virginia | 51107 | 34928 | 302 |
1917092 | 1917092 | 2021-11-14 | Loudoun | Virginia | 51107 | 34782 | 301 |
1913842 | 1913842 | 2021-11-13 | Loudoun | Virginia | 51107 | 34782 | 301 |
1910592 | 1910592 | 2021-11-12 | Loudoun | Virginia | 51107 | 34782 | 301 |
1907343 | 1907343 | 2021-11-11 | Loudoun | Virginia | 51107 | 34732 | 301 |
1904094 | 1904094 | 2021-11-10 | Loudoun | Virginia | 51107 | 34655 | 301 |
1900844 | 1900844 | 2021-11-09 | Loudoun | Virginia | 51107 | 34594 | 301 |
1897594 | 1897594 | 2021-11-08 | Loudoun | Virginia | 51107 | 34544 | 301 |
1894344 | 1894344 | 2021-11-07 | Loudoun | Virginia | 51107 | 34455 | 300 |
1891094 | 1891094 | 2021-11-06 | Loudoun | Virginia | 51107 | 34455 | 300 |
1887844 | 1887844 | 2021-11-05 | Loudoun | Virginia | 51107 | 34455 | 300 |
1884594 | 1884594 | 2021-11-04 | Loudoun | Virginia | 51107 | 34408 | 300 |
1881345 | 1881345 | 2021-11-03 | Loudoun | Virginia | 51107 | 34355 | 300 |
1878096 | 1878096 | 2021-11-02 | Loudoun | Virginia | 51107 | 34300 | 300 |
1874847 | 1874847 | 2021-11-01 | Loudoun | Virginia | 51107 | 34266 | 300 |
1871598 | 1871598 | 2021-10-31 | Loudoun | Virginia | 51107 | 34176 | 300 |
1868349 | 1868349 | 2021-10-30 | Loudoun | Virginia | 51107 | 34176 | 300 |
1865100 | 1865100 | 2021-10-29 | Loudoun | Virginia | 51107 | 34176 | 300 |
1861851 | 1861851 | 2021-10-28 | Loudoun | Virginia | 51107 | 34125 | 300 |
1858602 | 1858602 | 2021-10-27 | Loudoun | Virginia | 51107 | 34074 | 298 |
1855353 | 1855353 | 2021-10-26 | Loudoun | Virginia | 51107 | 34035 | 297 |
1852104 | 1852104 | 2021-10-25 | Loudoun | Virginia | 51107 | 34005 | 296 |
1848854 | 1848854 | 2021-10-24 | Loudoun | Virginia | 51107 | 33870 | 295 |
1845604 | 1845604 | 2021-10-23 | Loudoun | Virginia | 51107 | 33870 | 295 |
1842354 | 1842354 | 2021-10-22 | Loudoun | Virginia | 51107 | 33870 | 295 |
1839105 | 1839105 | 2021-10-21 | Loudoun | Virginia | 51107 | 33816 | 295 |
1835856 | 1835856 | 2021-10-20 | Loudoun | Virginia | 51107 | 33766 | 295 |
1832607 | 1832607 | 2021-10-19 | Loudoun | Virginia | 51107 | 33715 | 294 |
1829358 | 1829358 | 2021-10-18 | Loudoun | Virginia | 51107 | 33659 | 294 |
1826109 | 1826109 | 2021-10-17 | Loudoun | Virginia | 51107 | 33536 | 294 |
1822860 | 1822860 | 2021-10-16 | Loudoun | Virginia | 51107 | 33536 | 294 |
1819611 | 1819611 | 2021-10-15 | Loudoun | Virginia | 51107 | 33536 | 294 |
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 |
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);