ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Washington" and fips = 51191 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1809920 | 1809920 | 2021-10-12 | Washington | Virginia | 51191 | 7268 | 137 |
1806671 | 1806671 | 2021-10-11 | Washington | Virginia | 51191 | 7192 | 136 |
1803420 | 1803420 | 2021-10-10 | Washington | Virginia | 51191 | 7192 | 136 |
1800171 | 1800171 | 2021-10-09 | Washington | Virginia | 51191 | 7192 | 136 |
1796922 | 1796922 | 2021-10-08 | Washington | Virginia | 51191 | 7192 | 136 |
1793673 | 1793673 | 2021-10-07 | Washington | Virginia | 51191 | 7152 | 136 |
1790424 | 1790424 | 2021-10-06 | Washington | Virginia | 51191 | 7108 | 133 |
1787176 | 1787176 | 2021-10-05 | Washington | Virginia | 51191 | 7046 | 133 |
1783927 | 1783927 | 2021-10-04 | Washington | Virginia | 51191 | 7040 | 133 |
1780678 | 1780678 | 2021-10-03 | Washington | Virginia | 51191 | 6958 | 132 |
1777428 | 1777428 | 2021-10-02 | Washington | Virginia | 51191 | 6958 | 132 |
1774178 | 1774178 | 2021-10-01 | Washington | Virginia | 51191 | 6958 | 132 |
1770928 | 1770928 | 2021-09-30 | Washington | Virginia | 51191 | 6943 | 132 |
1767679 | 1767679 | 2021-09-29 | Washington | Virginia | 51191 | 6904 | 132 |
1764430 | 1764430 | 2021-09-28 | Washington | Virginia | 51191 | 6862 | 132 |
1761181 | 1761181 | 2021-09-27 | Washington | Virginia | 51191 | 6832 | 132 |
1757933 | 1757933 | 2021-09-26 | Washington | Virginia | 51191 | 6732 | 131 |
1754685 | 1754685 | 2021-09-25 | Washington | Virginia | 51191 | 6732 | 131 |
1751437 | 1751437 | 2021-09-24 | Washington | Virginia | 51191 | 6732 | 131 |
1748188 | 1748188 | 2021-09-23 | Washington | Virginia | 51191 | 6693 | 126 |
1744938 | 1744938 | 2021-09-22 | Washington | Virginia | 51191 | 6656 | 124 |
1741689 | 1741689 | 2021-09-21 | Washington | Virginia | 51191 | 6615 | 124 |
1738440 | 1738440 | 2021-09-20 | Washington | Virginia | 51191 | 6587 | 124 |
1735191 | 1735191 | 2021-09-19 | Washington | Virginia | 51191 | 6495 | 121 |
1731941 | 1731941 | 2021-09-18 | Washington | Virginia | 51191 | 6495 | 121 |
1728691 | 1728691 | 2021-09-17 | Washington | Virginia | 51191 | 6495 | 121 |
1725441 | 1725441 | 2021-09-16 | Washington | Virginia | 51191 | 6445 | 121 |
1722192 | 1722192 | 2021-09-15 | Washington | Virginia | 51191 | 6399 | 120 |
1718944 | 1718944 | 2021-09-14 | Washington | Virginia | 51191 | 6348 | 119 |
1715696 | 1715696 | 2021-09-13 | Washington | Virginia | 51191 | 6314 | 119 |
1712450 | 1712450 | 2021-09-12 | Washington | Virginia | 51191 | 6201 | 118 |
1709203 | 1709203 | 2021-09-11 | Washington | Virginia | 51191 | 6201 | 118 |
1705956 | 1705956 | 2021-09-10 | Washington | Virginia | 51191 | 6201 | 118 |
1702706 | 1702706 | 2021-09-09 | Washington | Virginia | 51191 | 6136 | 118 |
1699457 | 1699457 | 2021-09-08 | Washington | Virginia | 51191 | 6091 | 118 |
1696209 | 1696209 | 2021-09-07 | Washington | Virginia | 51191 | 6034 | 118 |
1692961 | 1692961 | 2021-09-06 | Washington | Virginia | 51191 | 6022 | 118 |
1689712 | 1689712 | 2021-09-05 | Washington | Virginia | 51191 | 5905 | 115 |
1686462 | 1686462 | 2021-09-04 | Washington | Virginia | 51191 | 5905 | 115 |
1683211 | 1683211 | 2021-09-03 | Washington | Virginia | 51191 | 5905 | 115 |
1679961 | 1679961 | 2021-09-02 | Washington | Virginia | 51191 | 5866 | 115 |
1676713 | 1676713 | 2021-09-01 | Washington | Virginia | 51191 | 5834 | 115 |
1673466 | 1673466 | 2021-08-31 | Washington | Virginia | 51191 | 5779 | 115 |
1670218 | 1670218 | 2021-08-30 | Washington | Virginia | 51191 | 5735 | 115 |
1666971 | 1666971 | 2021-08-29 | Washington | Virginia | 51191 | 5664 | 115 |
1663723 | 1663723 | 2021-08-28 | Washington | Virginia | 51191 | 5664 | 115 |
1660475 | 1660475 | 2021-08-27 | Washington | Virginia | 51191 | 5664 | 115 |
1657227 | 1657227 | 2021-08-26 | Washington | Virginia | 51191 | 5627 | 115 |
1653979 | 1653979 | 2021-08-25 | Washington | Virginia | 51191 | 5588 | 115 |
1650733 | 1650733 | 2021-08-24 | Washington | Virginia | 51191 | 5563 | 115 |
1647484 | 1647484 | 2021-08-23 | Washington | Virginia | 51191 | 5541 | 115 |
1644235 | 1644235 | 2021-08-22 | Washington | Virginia | 51191 | 5481 | 115 |
1640985 | 1640985 | 2021-08-21 | Washington | Virginia | 51191 | 5481 | 115 |
1637735 | 1637735 | 2021-08-20 | Washington | Virginia | 51191 | 5481 | 115 |
1634485 | 1634485 | 2021-08-19 | Washington | Virginia | 51191 | 5459 | 115 |
1631237 | 1631237 | 2021-08-18 | Washington | Virginia | 51191 | 5429 | 115 |
1627990 | 1627990 | 2021-08-17 | Washington | Virginia | 51191 | 5399 | 115 |
1624743 | 1624743 | 2021-08-16 | Washington | Virginia | 51191 | 5386 | 115 |
1621496 | 1621496 | 2021-08-15 | Washington | Virginia | 51191 | 5327 | 115 |
1618248 | 1618248 | 2021-08-14 | Washington | Virginia | 51191 | 5327 | 115 |
1615000 | 1615000 | 2021-08-13 | Washington | Virginia | 51191 | 5327 | 115 |
1611751 | 1611751 | 2021-08-12 | Washington | Virginia | 51191 | 5304 | 115 |
1608504 | 1608504 | 2021-08-11 | Washington | Virginia | 51191 | 5286 | 115 |
1605255 | 1605255 | 2021-08-10 | Washington | Virginia | 51191 | 5258 | 115 |
1602005 | 1602005 | 2021-08-09 | Washington | Virginia | 51191 | 5241 | 115 |
1598757 | 1598757 | 2021-08-08 | Washington | Virginia | 51191 | 5203 | 115 |
1595508 | 1595508 | 2021-08-07 | Washington | Virginia | 51191 | 5203 | 115 |
1592259 | 1592259 | 2021-08-06 | Washington | Virginia | 51191 | 5203 | 115 |
1589010 | 1589010 | 2021-08-05 | Washington | Virginia | 51191 | 5191 | 115 |
1585761 | 1585761 | 2021-08-04 | Washington | Virginia | 51191 | 5176 | 115 |
1582511 | 1582511 | 2021-08-03 | Washington | Virginia | 51191 | 5166 | 115 |
1579261 | 1579261 | 2021-08-02 | Washington | Virginia | 51191 | 5158 | 115 |
1576013 | 1576013 | 2021-08-01 | Washington | Virginia | 51191 | 5143 | 115 |
1572765 | 1572765 | 2021-07-31 | Washington | Virginia | 51191 | 5143 | 115 |
1569517 | 1569517 | 2021-07-30 | Washington | Virginia | 51191 | 5143 | 115 |
1566269 | 1566269 | 2021-07-29 | Washington | Virginia | 51191 | 5135 | 115 |
1563021 | 1563021 | 2021-07-28 | Washington | Virginia | 51191 | 5126 | 114 |
1559773 | 1559773 | 2021-07-27 | Washington | Virginia | 51191 | 5118 | 113 |
1556526 | 1556526 | 2021-07-26 | Washington | Virginia | 51191 | 5106 | 112 |
1553279 | 1553279 | 2021-07-25 | Washington | Virginia | 51191 | 5095 | 112 |
1550032 | 1550032 | 2021-07-24 | Washington | Virginia | 51191 | 5095 | 112 |
1546785 | 1546785 | 2021-07-23 | Washington | Virginia | 51191 | 5095 | 112 |
1543538 | 1543538 | 2021-07-22 | Washington | Virginia | 51191 | 5089 | 113 |
1540290 | 1540290 | 2021-07-21 | Washington | Virginia | 51191 | 5083 | 113 |
1537043 | 1537043 | 2021-07-20 | Washington | Virginia | 51191 | 5078 | 112 |
1533795 | 1533795 | 2021-07-19 | Washington | Virginia | 51191 | 5066 | 112 |
1530548 | 1530548 | 2021-07-18 | Washington | Virginia | 51191 | 5064 | 111 |
1527301 | 1527301 | 2021-07-17 | Washington | Virginia | 51191 | 5064 | 111 |
1524054 | 1524054 | 2021-07-16 | Washington | Virginia | 51191 | 5064 | 111 |
1520806 | 1520806 | 2021-07-15 | Washington | Virginia | 51191 | 5059 | 111 |
1517558 | 1517558 | 2021-07-14 | Washington | Virginia | 51191 | 5047 | 111 |
1514311 | 1514311 | 2021-07-13 | Washington | Virginia | 51191 | 5042 | 111 |
1511065 | 1511065 | 2021-07-12 | Washington | Virginia | 51191 | 5039 | 111 |
1507818 | 1507818 | 2021-07-11 | Washington | Virginia | 51191 | 5039 | 111 |
1504572 | 1504572 | 2021-07-10 | Washington | Virginia | 51191 | 5036 | 111 |
1501326 | 1501326 | 2021-07-09 | Washington | Virginia | 51191 | 5041 | 111 |
1498080 | 1498080 | 2021-07-08 | Washington | Virginia | 51191 | 5032 | 111 |
1494833 | 1494833 | 2021-07-07 | Washington | Virginia | 51191 | 5036 | 111 |
1491586 | 1491586 | 2021-07-06 | Washington | Virginia | 51191 | 5034 | 111 |
1488339 | 1488339 | 2021-07-05 | Washington | Virginia | 51191 | 5034 | 111 |
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);