ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Charles City" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1816313 | 1816313 | 2021-10-14 | Charles City | Virginia | 51036 | 669 | 19 |
1813065 | 1813065 | 2021-10-13 | Charles City | Virginia | 51036 | 662 | 19 |
1809816 | 1809816 | 2021-10-12 | Charles City | Virginia | 51036 | 660 | 19 |
1806566 | 1806566 | 2021-10-11 | Charles City | Virginia | 51036 | 653 | 19 |
1803316 | 1803316 | 2021-10-10 | Charles City | Virginia | 51036 | 653 | 19 |
1800067 | 1800067 | 2021-10-09 | Charles City | Virginia | 51036 | 653 | 19 |
1796818 | 1796818 | 2021-10-08 | Charles City | Virginia | 51036 | 653 | 19 |
1793569 | 1793569 | 2021-10-07 | Charles City | Virginia | 51036 | 653 | 19 |
1790320 | 1790320 | 2021-10-06 | Charles City | Virginia | 51036 | 653 | 19 |
1787072 | 1787072 | 2021-10-05 | Charles City | Virginia | 51036 | 653 | 19 |
1783823 | 1783823 | 2021-10-04 | Charles City | Virginia | 51036 | 653 | 19 |
1780574 | 1780574 | 2021-10-03 | Charles City | Virginia | 51036 | 649 | 19 |
1777324 | 1777324 | 2021-10-02 | Charles City | Virginia | 51036 | 649 | 19 |
1774074 | 1774074 | 2021-10-01 | Charles City | Virginia | 51036 | 649 | 19 |
1770824 | 1770824 | 2021-09-30 | Charles City | Virginia | 51036 | 645 | 19 |
1767575 | 1767575 | 2021-09-29 | Charles City | Virginia | 51036 | 644 | 19 |
1764326 | 1764326 | 2021-09-28 | Charles City | Virginia | 51036 | 642 | 19 |
1761077 | 1761077 | 2021-09-27 | Charles City | Virginia | 51036 | 641 | 19 |
1757829 | 1757829 | 2021-09-26 | Charles City | Virginia | 51036 | 639 | 19 |
1754581 | 1754581 | 2021-09-25 | Charles City | Virginia | 51036 | 639 | 19 |
1751333 | 1751333 | 2021-09-24 | Charles City | Virginia | 51036 | 639 | 19 |
1748084 | 1748084 | 2021-09-23 | Charles City | Virginia | 51036 | 637 | 19 |
1744834 | 1744834 | 2021-09-22 | Charles City | Virginia | 51036 | 632 | 19 |
1741585 | 1741585 | 2021-09-21 | Charles City | Virginia | 51036 | 632 | 19 |
1738336 | 1738336 | 2021-09-20 | Charles City | Virginia | 51036 | 632 | 19 |
1735087 | 1735087 | 2021-09-19 | Charles City | Virginia | 51036 | 622 | 19 |
1731837 | 1731837 | 2021-09-18 | Charles City | Virginia | 51036 | 622 | 19 |
1728587 | 1728587 | 2021-09-17 | Charles City | Virginia | 51036 | 622 | 19 |
1725337 | 1725337 | 2021-09-16 | Charles City | Virginia | 51036 | 622 | 19 |
1722088 | 1722088 | 2021-09-15 | Charles City | Virginia | 51036 | 617 | 18 |
1718840 | 1718840 | 2021-09-14 | Charles City | Virginia | 51036 | 614 | 17 |
1715592 | 1715592 | 2021-09-13 | Charles City | Virginia | 51036 | 610 | 17 |
1712346 | 1712346 | 2021-09-12 | Charles City | Virginia | 51036 | 604 | 17 |
1709099 | 1709099 | 2021-09-11 | Charles City | Virginia | 51036 | 604 | 17 |
1705852 | 1705852 | 2021-09-10 | Charles City | Virginia | 51036 | 604 | 17 |
1702602 | 1702602 | 2021-09-09 | Charles City | Virginia | 51036 | 600 | 17 |
1699353 | 1699353 | 2021-09-08 | Charles City | Virginia | 51036 | 597 | 17 |
1696105 | 1696105 | 2021-09-07 | Charles City | Virginia | 51036 | 597 | 16 |
1692857 | 1692857 | 2021-09-06 | Charles City | Virginia | 51036 | 596 | 16 |
1689608 | 1689608 | 2021-09-05 | Charles City | Virginia | 51036 | 593 | 16 |
1686358 | 1686358 | 2021-09-04 | Charles City | Virginia | 51036 | 593 | 16 |
1683107 | 1683107 | 2021-09-03 | Charles City | Virginia | 51036 | 593 | 16 |
1679857 | 1679857 | 2021-09-02 | Charles City | Virginia | 51036 | 592 | 16 |
1676609 | 1676609 | 2021-09-01 | Charles City | Virginia | 51036 | 586 | 16 |
1673362 | 1673362 | 2021-08-31 | Charles City | Virginia | 51036 | 581 | 16 |
1670114 | 1670114 | 2021-08-30 | Charles City | Virginia | 51036 | 581 | 16 |
1666867 | 1666867 | 2021-08-29 | Charles City | Virginia | 51036 | 574 | 16 |
1663619 | 1663619 | 2021-08-28 | Charles City | Virginia | 51036 | 574 | 16 |
1660371 | 1660371 | 2021-08-27 | Charles City | Virginia | 51036 | 574 | 16 |
1657122 | 1657122 | 2021-08-26 | Charles City | Virginia | 51036 | 573 | 16 |
1653875 | 1653875 | 2021-08-25 | Charles City | Virginia | 51036 | 567 | 16 |
1650629 | 1650629 | 2021-08-24 | Charles City | Virginia | 51036 | 559 | 16 |
1647380 | 1647380 | 2021-08-23 | Charles City | Virginia | 51036 | 553 | 16 |
1644131 | 1644131 | 2021-08-22 | Charles City | Virginia | 51036 | 546 | 16 |
1640881 | 1640881 | 2021-08-21 | Charles City | Virginia | 51036 | 546 | 16 |
1637631 | 1637631 | 2021-08-20 | Charles City | Virginia | 51036 | 546 | 16 |
1634381 | 1634381 | 2021-08-19 | Charles City | Virginia | 51036 | 546 | 16 |
1631133 | 1631133 | 2021-08-18 | Charles City | Virginia | 51036 | 546 | 16 |
1627886 | 1627886 | 2021-08-17 | Charles City | Virginia | 51036 | 543 | 16 |
1624639 | 1624639 | 2021-08-16 | Charles City | Virginia | 51036 | 543 | 16 |
1621392 | 1621392 | 2021-08-15 | Charles City | Virginia | 51036 | 540 | 16 |
1618144 | 1618144 | 2021-08-14 | Charles City | Virginia | 51036 | 540 | 16 |
1614896 | 1614896 | 2021-08-13 | Charles City | Virginia | 51036 | 540 | 16 |
1611647 | 1611647 | 2021-08-12 | Charles City | Virginia | 51036 | 539 | 16 |
1608400 | 1608400 | 2021-08-11 | Charles City | Virginia | 51036 | 537 | 16 |
1605151 | 1605151 | 2021-08-10 | Charles City | Virginia | 51036 | 535 | 16 |
1601901 | 1601901 | 2021-08-09 | Charles City | Virginia | 51036 | 533 | 16 |
1598653 | 1598653 | 2021-08-08 | Charles City | Virginia | 51036 | 531 | 16 |
1595404 | 1595404 | 2021-08-07 | Charles City | Virginia | 51036 | 531 | 16 |
1592155 | 1592155 | 2021-08-06 | Charles City | Virginia | 51036 | 531 | 16 |
1588906 | 1588906 | 2021-08-05 | Charles City | Virginia | 51036 | 529 | 16 |
1585657 | 1585657 | 2021-08-04 | Charles City | Virginia | 51036 | 529 | 16 |
1582407 | 1582407 | 2021-08-03 | Charles City | Virginia | 51036 | 529 | 16 |
1579157 | 1579157 | 2021-08-02 | Charles City | Virginia | 51036 | 527 | 16 |
1575909 | 1575909 | 2021-08-01 | Charles City | Virginia | 51036 | 524 | 16 |
1572661 | 1572661 | 2021-07-31 | Charles City | Virginia | 51036 | 524 | 16 |
1569413 | 1569413 | 2021-07-30 | Charles City | Virginia | 51036 | 524 | 16 |
1566165 | 1566165 | 2021-07-29 | Charles City | Virginia | 51036 | 524 | 16 |
1562917 | 1562917 | 2021-07-28 | Charles City | Virginia | 51036 | 524 | 16 |
1559669 | 1559669 | 2021-07-27 | Charles City | Virginia | 51036 | 524 | 16 |
1556422 | 1556422 | 2021-07-26 | Charles City | Virginia | 51036 | 524 | 16 |
1553175 | 1553175 | 2021-07-25 | Charles City | Virginia | 51036 | 522 | 16 |
1549928 | 1549928 | 2021-07-24 | Charles City | Virginia | 51036 | 522 | 16 |
1546681 | 1546681 | 2021-07-23 | Charles City | Virginia | 51036 | 522 | 16 |
1543434 | 1543434 | 2021-07-22 | Charles City | Virginia | 51036 | 522 | 16 |
1540186 | 1540186 | 2021-07-21 | Charles City | Virginia | 51036 | 521 | 16 |
1536939 | 1536939 | 2021-07-20 | Charles City | Virginia | 51036 | 523 | 16 |
1533691 | 1533691 | 2021-07-19 | Charles City | Virginia | 51036 | 523 | 16 |
1530444 | 1530444 | 2021-07-18 | Charles City | Virginia | 51036 | 522 | 16 |
1527197 | 1527197 | 2021-07-17 | Charles City | Virginia | 51036 | 522 | 16 |
1523950 | 1523950 | 2021-07-16 | Charles City | Virginia | 51036 | 522 | 16 |
1520702 | 1520702 | 2021-07-15 | Charles City | Virginia | 51036 | 521 | 16 |
1517454 | 1517454 | 2021-07-14 | Charles City | Virginia | 51036 | 522 | 16 |
1514207 | 1514207 | 2021-07-13 | Charles City | Virginia | 51036 | 512 | 16 |
1510961 | 1510961 | 2021-07-12 | Charles City | Virginia | 51036 | 513 | 16 |
1507714 | 1507714 | 2021-07-11 | Charles City | Virginia | 51036 | 513 | 16 |
1504468 | 1504468 | 2021-07-10 | Charles City | Virginia | 51036 | 512 | 16 |
1501222 | 1501222 | 2021-07-09 | Charles City | Virginia | 51036 | 512 | 16 |
1497976 | 1497976 | 2021-07-08 | Charles City | Virginia | 51036 | 513 | 16 |
1494729 | 1494729 | 2021-07-07 | Charles City | Virginia | 51036 | 512 | 16 |
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);