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 |
---|---|---|---|---|---|---|---|
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 |
1491498 | 1491498 | 2021-07-06 | Fairfax | Virginia | 51059 | 77200 | 1117 |
1488251 | 1488251 | 2021-07-05 | Fairfax | Virginia | 51059 | 77196 | 1116 |
1485004 | 1485004 | 2021-07-04 | Fairfax | Virginia | 51059 | 77187 | 1116 |
1481758 | 1481758 | 2021-07-03 | Fairfax | Virginia | 51059 | 77173 | 1116 |
1478511 | 1478511 | 2021-07-02 | Fairfax | Virginia | 51059 | 77171 | 1116 |
1475265 | 1475265 | 2021-07-01 | Fairfax | Virginia | 51059 | 77162 | 1115 |
1472019 | 1472019 | 2021-06-30 | Fairfax | Virginia | 51059 | 77136 | 1115 |
1468774 | 1468774 | 2021-06-29 | Fairfax | Virginia | 51059 | 77107 | 1115 |
1465529 | 1465529 | 2021-06-28 | Fairfax | Virginia | 51059 | 77102 | 1113 |
1462284 | 1462284 | 2021-06-27 | Fairfax | Virginia | 51059 | 77098 | 1113 |
1459039 | 1459039 | 2021-06-26 | Fairfax | Virginia | 51059 | 77091 | 1113 |
1455794 | 1455794 | 2021-06-25 | Fairfax | Virginia | 51059 | 77072 | 1113 |
1452549 | 1452549 | 2021-06-24 | Fairfax | Virginia | 51059 | 77063 | 1113 |
1449303 | 1449303 | 2021-06-23 | Fairfax | Virginia | 51059 | 77057 | 1111 |
1446058 | 1446058 | 2021-06-22 | Fairfax | Virginia | 51059 | 77045 | 1111 |
1442813 | 1442813 | 2021-06-21 | Fairfax | Virginia | 51059 | 77038 | 1109 |
1439568 | 1439568 | 2021-06-20 | Fairfax | Virginia | 51059 | 77025 | 1109 |
1436321 | 1436321 | 2021-06-19 | Fairfax | Virginia | 51059 | 77026 | 1108 |
1433074 | 1433074 | 2021-06-18 | Fairfax | Virginia | 51059 | 77025 | 1108 |
1429828 | 1429828 | 2021-06-17 | Fairfax | Virginia | 51059 | 77022 | 1108 |
1426583 | 1426583 | 2021-06-16 | Fairfax | Virginia | 51059 | 77022 | 1107 |
1423337 | 1423337 | 2021-06-15 | Fairfax | Virginia | 51059 | 77011 | 1107 |
1420090 | 1420090 | 2021-06-14 | Fairfax | Virginia | 51059 | 77017 | 1106 |
1416845 | 1416845 | 2021-06-13 | Fairfax | Virginia | 51059 | 77023 | 1105 |
1413599 | 1413599 | 2021-06-12 | Fairfax | Virginia | 51059 | 77026 | 1105 |
1410354 | 1410354 | 2021-06-11 | Fairfax | Virginia | 51059 | 77026 | 1105 |
1407109 | 1407109 | 2021-06-10 | Fairfax | Virginia | 51059 | 77027 | 1105 |
1403863 | 1403863 | 2021-06-09 | Fairfax | Virginia | 51059 | 77021 | 1105 |
1400618 | 1400618 | 2021-06-08 | Fairfax | Virginia | 51059 | 77028 | 1105 |
1397373 | 1397373 | 2021-06-07 | Fairfax | Virginia | 51059 | 77037 | 1105 |
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);