ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 51059 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1816329 | 1816329 | 2021-10-14 | Fairfax | Virginia | 51059 | 90234 | 1166 |
1813081 | 1813081 | 2021-10-13 | Fairfax | Virginia | 51059 | 90083 | 1165 |
1809832 | 1809832 | 2021-10-12 | Fairfax | Virginia | 51059 | 89944 | 1165 |
1806582 | 1806582 | 2021-10-11 | Fairfax | Virginia | 51059 | 89473 | 1158 |
1803332 | 1803332 | 2021-10-10 | Fairfax | Virginia | 51059 | 89473 | 1158 |
1800083 | 1800083 | 2021-10-09 | Fairfax | Virginia | 51059 | 89473 | 1158 |
1796834 | 1796834 | 2021-10-08 | Fairfax | Virginia | 51059 | 89473 | 1158 |
1793585 | 1793585 | 2021-10-07 | Fairfax | Virginia | 51059 | 89287 | 1158 |
1790336 | 1790336 | 2021-10-06 | Fairfax | Virginia | 51059 | 89102 | 1155 |
1787088 | 1787088 | 2021-10-05 | Fairfax | Virginia | 51059 | 88896 | 1154 |
1783839 | 1783839 | 2021-10-04 | Fairfax | Virginia | 51059 | 88852 | 1153 |
1780590 | 1780590 | 2021-10-03 | Fairfax | Virginia | 51059 | 88464 | 1152 |
1777340 | 1777340 | 2021-10-02 | Fairfax | Virginia | 51059 | 88464 | 1152 |
1774090 | 1774090 | 2021-10-01 | Fairfax | Virginia | 51059 | 88464 | 1152 |
1770840 | 1770840 | 2021-09-30 | Fairfax | Virginia | 51059 | 88328 | 1152 |
1767591 | 1767591 | 2021-09-29 | Fairfax | Virginia | 51059 | 88176 | 1151 |
1764342 | 1764342 | 2021-09-28 | Fairfax | Virginia | 51059 | 87942 | 1151 |
1761093 | 1761093 | 2021-09-27 | Fairfax | Virginia | 51059 | 87809 | 1151 |
1757845 | 1757845 | 2021-09-26 | Fairfax | Virginia | 51059 | 87356 | 1150 |
1754597 | 1754597 | 2021-09-25 | Fairfax | Virginia | 51059 | 87356 | 1150 |
1751349 | 1751349 | 2021-09-24 | Fairfax | Virginia | 51059 | 87356 | 1150 |
1748100 | 1748100 | 2021-09-23 | Fairfax | Virginia | 51059 | 87134 | 1149 |
1744850 | 1744850 | 2021-09-22 | Fairfax | Virginia | 51059 | 86917 | 1147 |
1741601 | 1741601 | 2021-09-21 | Fairfax | Virginia | 51059 | 86689 | 1146 |
1738352 | 1738352 | 2021-09-20 | Fairfax | Virginia | 51059 | 86498 | 1146 |
1735103 | 1735103 | 2021-09-19 | Fairfax | Virginia | 51059 | 86081 | 1148 |
1731853 | 1731853 | 2021-09-18 | Fairfax | Virginia | 51059 | 86081 | 1148 |
1728603 | 1728603 | 2021-09-17 | Fairfax | Virginia | 51059 | 86081 | 1148 |
1725353 | 1725353 | 2021-09-16 | Fairfax | Virginia | 51059 | 85911 | 1147 |
1722104 | 1722104 | 2021-09-15 | Fairfax | Virginia | 51059 | 85647 | 1145 |
1718856 | 1718856 | 2021-09-14 | Fairfax | Virginia | 51059 | 85432 | 1143 |
1715608 | 1715608 | 2021-09-13 | Fairfax | Virginia | 51059 | 85236 | 1143 |
1712362 | 1712362 | 2021-09-12 | Fairfax | Virginia | 51059 | 84765 | 1141 |
1709115 | 1709115 | 2021-09-11 | Fairfax | Virginia | 51059 | 84765 | 1141 |
1705868 | 1705868 | 2021-09-10 | Fairfax | Virginia | 51059 | 84765 | 1141 |
1702618 | 1702618 | 2021-09-09 | Fairfax | Virginia | 51059 | 84479 | 1141 |
1699369 | 1699369 | 2021-09-08 | Fairfax | Virginia | 51059 | 84278 | 1140 |
1696121 | 1696121 | 2021-09-07 | Fairfax | Virginia | 51059 | 84056 | 1140 |
1692873 | 1692873 | 2021-09-06 | Fairfax | Virginia | 51059 | 83945 | 1140 |
1689624 | 1689624 | 2021-09-05 | Fairfax | Virginia | 51059 | 83526 | 1139 |
1686374 | 1686374 | 2021-09-04 | Fairfax | Virginia | 51059 | 83526 | 1139 |
1683123 | 1683123 | 2021-09-03 | Fairfax | Virginia | 51059 | 83526 | 1139 |
1679873 | 1679873 | 2021-09-02 | Fairfax | Virginia | 51059 | 83330 | 1139 |
1676625 | 1676625 | 2021-09-01 | Fairfax | Virginia | 51059 | 83150 | 1138 |
1673378 | 1673378 | 2021-08-31 | Fairfax | Virginia | 51059 | 82955 | 1137 |
1670130 | 1670130 | 2021-08-30 | Fairfax | Virginia | 51059 | 82840 | 1137 |
1666883 | 1666883 | 2021-08-29 | Fairfax | Virginia | 51059 | 82324 | 1133 |
1663635 | 1663635 | 2021-08-28 | Fairfax | Virginia | 51059 | 82324 | 1133 |
1660387 | 1660387 | 2021-08-27 | Fairfax | Virginia | 51059 | 82324 | 1133 |
1657138 | 1657138 | 2021-08-26 | Fairfax | Virginia | 51059 | 82143 | 1131 |
1653891 | 1653891 | 2021-08-25 | Fairfax | Virginia | 51059 | 81964 | 1131 |
1650645 | 1650645 | 2021-08-24 | Fairfax | Virginia | 51059 | 81716 | 1130 |
1647396 | 1647396 | 2021-08-23 | Fairfax | Virginia | 51059 | 81562 | 1129 |
1644147 | 1644147 | 2021-08-22 | Fairfax | Virginia | 51059 | 81115 | 1128 |
1640897 | 1640897 | 2021-08-21 | Fairfax | Virginia | 51059 | 81115 | 1128 |
1637647 | 1637647 | 2021-08-20 | Fairfax | Virginia | 51059 | 81115 | 1128 |
1634397 | 1634397 | 2021-08-19 | Fairfax | Virginia | 51059 | 80909 | 1128 |
1631149 | 1631149 | 2021-08-18 | Fairfax | Virginia | 51059 | 80720 | 1128 |
1627902 | 1627902 | 2021-08-17 | Fairfax | Virginia | 51059 | 80571 | 1128 |
1624655 | 1624655 | 2021-08-16 | Fairfax | Virginia | 51059 | 80403 | 1127 |
1621408 | 1621408 | 2021-08-15 | Fairfax | Virginia | 51059 | 80012 | 1127 |
1618160 | 1618160 | 2021-08-14 | Fairfax | Virginia | 51059 | 80012 | 1127 |
1614912 | 1614912 | 2021-08-13 | Fairfax | Virginia | 51059 | 80012 | 1127 |
1611663 | 1611663 | 2021-08-12 | Fairfax | Virginia | 51059 | 79901 | 1126 |
1608416 | 1608416 | 2021-08-11 | Fairfax | Virginia | 51059 | 79717 | 1126 |
1605167 | 1605167 | 2021-08-10 | Fairfax | Virginia | 51059 | 79581 | 1126 |
1601917 | 1601917 | 2021-08-09 | Fairfax | Virginia | 51059 | 79448 | 1126 |
1598669 | 1598669 | 2021-08-08 | Fairfax | Virginia | 51059 | 79102 | 1126 |
1595420 | 1595420 | 2021-08-07 | Fairfax | Virginia | 51059 | 79102 | 1126 |
1592171 | 1592171 | 2021-08-06 | Fairfax | Virginia | 51059 | 79102 | 1126 |
1588922 | 1588922 | 2021-08-05 | Fairfax | Virginia | 51059 | 78955 | 1126 |
1585673 | 1585673 | 2021-08-04 | Fairfax | Virginia | 51059 | 78841 | 1125 |
1582423 | 1582423 | 2021-08-03 | Fairfax | Virginia | 51059 | 78728 | 1125 |
1579173 | 1579173 | 2021-08-02 | Fairfax | Virginia | 51059 | 78633 | 1125 |
1575925 | 1575925 | 2021-08-01 | Fairfax | Virginia | 51059 | 78317 | 1125 |
1572677 | 1572677 | 2021-07-31 | Fairfax | Virginia | 51059 | 78317 | 1125 |
1569429 | 1569429 | 2021-07-30 | Fairfax | Virginia | 51059 | 78317 | 1125 |
1566181 | 1566181 | 2021-07-29 | Fairfax | Virginia | 51059 | 78246 | 1125 |
1562933 | 1562933 | 2021-07-28 | Fairfax | Virginia | 51059 | 78159 | 1125 |
1559685 | 1559685 | 2021-07-27 | Fairfax | Virginia | 51059 | 78078 | 1125 |
1556438 | 1556438 | 2021-07-26 | Fairfax | Virginia | 51059 | 78026 | 1125 |
1553191 | 1553191 | 2021-07-25 | Fairfax | Virginia | 51059 | 77838 | 1125 |
1549944 | 1549944 | 2021-07-24 | Fairfax | Virginia | 51059 | 77838 | 1125 |
1546697 | 1546697 | 2021-07-23 | Fairfax | Virginia | 51059 | 77838 | 1125 |
1543450 | 1543450 | 2021-07-22 | Fairfax | Virginia | 51059 | 77754 | 1124 |
1540202 | 1540202 | 2021-07-21 | Fairfax | Virginia | 51059 | 77680 | 1124 |
1536955 | 1536955 | 2021-07-20 | Fairfax | Virginia | 51059 | 77612 | 1124 |
1533707 | 1533707 | 2021-07-19 | Fairfax | Virginia | 51059 | 77569 | 1124 |
1530460 | 1530460 | 2021-07-18 | Fairfax | Virginia | 51059 | 77465 | 1124 |
1527213 | 1527213 | 2021-07-17 | Fairfax | Virginia | 51059 | 77465 | 1124 |
1523966 | 1523966 | 2021-07-16 | Fairfax | Virginia | 51059 | 77465 | 1124 |
1520718 | 1520718 | 2021-07-15 | Fairfax | Virginia | 51059 | 77419 | 1124 |
1517470 | 1517470 | 2021-07-14 | Fairfax | Virginia | 51059 | 77371 | 1123 |
1514223 | 1514223 | 2021-07-13 | Fairfax | Virginia | 51059 | 77346 | 1122 |
1510977 | 1510977 | 2021-07-12 | Fairfax | Virginia | 51059 | 77313 | 1119 |
1507730 | 1507730 | 2021-07-11 | Fairfax | Virginia | 51059 | 77297 | 1119 |
1504484 | 1504484 | 2021-07-10 | Fairfax | Virginia | 51059 | 77285 | 1119 |
1501238 | 1501238 | 2021-07-09 | Fairfax | Virginia | 51059 | 77256 | 1119 |
1497992 | 1497992 | 2021-07-08 | Fairfax | Virginia | 51059 | 77235 | 1118 |
1494745 | 1494745 | 2021-07-07 | Fairfax | Virginia | 51059 | 77210 | 1117 |
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);