ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 51041 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112083 | 2112083 | 2022-01-13 | Chesterfield | Virginia | 51041 | 57307 | 611 |
2108831 | 2108831 | 2022-01-12 | Chesterfield | Virginia | 51041 | 56542 | 610 |
2105580 | 2105580 | 2022-01-11 | Chesterfield | Virginia | 51041 | 55728 | 610 |
2102329 | 2102329 | 2022-01-10 | Chesterfield | Virginia | 51041 | 54959 | 609 |
2099078 | 2099078 | 2022-01-09 | Chesterfield | Virginia | 51041 | 52823 | 609 |
2095827 | 2095827 | 2022-01-08 | Chesterfield | Virginia | 51041 | 52823 | 609 |
2092575 | 2092575 | 2022-01-07 | Chesterfield | Virginia | 51041 | 52823 | 609 |
2089323 | 2089323 | 2022-01-06 | Chesterfield | Virginia | 51041 | 52119 | 609 |
2086072 | 2086072 | 2022-01-05 | Chesterfield | Virginia | 51041 | 51358 | 609 |
2082820 | 2082820 | 2022-01-04 | Chesterfield | Virginia | 51041 | 50782 | 609 |
2079568 | 2079568 | 2022-01-03 | Chesterfield | Virginia | 51041 | 50002 | 609 |
2076316 | 2076316 | 2022-01-02 | Chesterfield | Virginia | 51041 | 48029 | 607 |
2073065 | 2073065 | 2022-01-01 | Chesterfield | Virginia | 51041 | 48029 | 607 |
2069814 | 2069814 | 2021-12-31 | Chesterfield | Virginia | 51041 | 48029 | 607 |
2066563 | 2066563 | 2021-12-30 | Chesterfield | Virginia | 51041 | 47306 | 607 |
2063313 | 2063313 | 2021-12-29 | Chesterfield | Virginia | 51041 | 46708 | 605 |
2060063 | 2060063 | 2021-12-28 | Chesterfield | Virginia | 51041 | 46068 | 605 |
2056814 | 2056814 | 2021-12-27 | Chesterfield | Virginia | 51041 | 45643 | 602 |
2053565 | 2053565 | 2021-12-26 | Chesterfield | Virginia | 51041 | 44760 | 601 |
2050315 | 2050315 | 2021-12-25 | Chesterfield | Virginia | 51041 | 44760 | 601 |
2047065 | 2047065 | 2021-12-24 | Chesterfield | Virginia | 51041 | 44760 | 601 |
2043815 | 2043815 | 2021-12-23 | Chesterfield | Virginia | 51041 | 44421 | 600 |
2040566 | 2040566 | 2021-12-22 | Chesterfield | Virginia | 51041 | 44195 | 596 |
2037316 | 2037316 | 2021-12-21 | Chesterfield | Virginia | 51041 | 43970 | 594 |
2034066 | 2034066 | 2021-12-20 | Chesterfield | Virginia | 51041 | 43735 | 590 |
2030816 | 2030816 | 2021-12-19 | Chesterfield | Virginia | 51041 | 43361 | 590 |
2027565 | 2027565 | 2021-12-18 | Chesterfield | Virginia | 51041 | 43361 | 590 |
2024314 | 2024314 | 2021-12-17 | Chesterfield | Virginia | 51041 | 43361 | 590 |
2021063 | 2021063 | 2021-12-16 | Chesterfield | Virginia | 51041 | 43234 | 590 |
2017812 | 2017812 | 2021-12-15 | Chesterfield | Virginia | 51041 | 43085 | 587 |
2014562 | 2014562 | 2021-12-14 | Chesterfield | Virginia | 51041 | 42993 | 587 |
2011311 | 2011311 | 2021-12-13 | Chesterfield | Virginia | 51041 | 42841 | 587 |
2008060 | 2008060 | 2021-12-12 | Chesterfield | Virginia | 51041 | 42491 | 583 |
2004809 | 2004809 | 2021-12-11 | Chesterfield | Virginia | 51041 | 42491 | 583 |
2001558 | 2001558 | 2021-12-10 | Chesterfield | Virginia | 51041 | 42491 | 583 |
1998308 | 1998308 | 2021-12-09 | Chesterfield | Virginia | 51041 | 42376 | 580 |
1995057 | 1995057 | 2021-12-08 | Chesterfield | Virginia | 51041 | 42201 | 579 |
1991806 | 1991806 | 2021-12-07 | Chesterfield | Virginia | 51041 | 42128 | 578 |
1988555 | 1988555 | 2021-12-06 | Chesterfield | Virginia | 51041 | 42022 | 574 |
1985305 | 1985305 | 2021-12-05 | Chesterfield | Virginia | 51041 | 41786 | 574 |
1982055 | 1982055 | 2021-12-04 | Chesterfield | Virginia | 51041 | 41786 | 574 |
1978805 | 1978805 | 2021-12-03 | Chesterfield | Virginia | 51041 | 41786 | 574 |
1975555 | 1975555 | 2021-12-02 | Chesterfield | Virginia | 51041 | 41680 | 574 |
1972306 | 1972306 | 2021-12-01 | Chesterfield | Virginia | 51041 | 41580 | 573 |
1969056 | 1969056 | 2021-11-30 | Chesterfield | Virginia | 51041 | 41511 | 572 |
1965806 | 1965806 | 2021-11-29 | Chesterfield | Virginia | 51041 | 41420 | 572 |
1962554 | 1962554 | 2021-11-28 | Chesterfield | Virginia | 51041 | 41260 | 570 |
1959303 | 1959303 | 2021-11-27 | Chesterfield | Virginia | 51041 | 41260 | 570 |
1956052 | 1956052 | 2021-11-26 | Chesterfield | Virginia | 51041 | 41260 | 570 |
1952801 | 1952801 | 2021-11-25 | Chesterfield | Virginia | 51041 | 41212 | 569 |
1949550 | 1949550 | 2021-11-24 | Chesterfield | Virginia | 51041 | 41130 | 567 |
1946299 | 1946299 | 2021-11-23 | Chesterfield | Virginia | 51041 | 41071 | 566 |
1943048 | 1943048 | 2021-11-22 | Chesterfield | Virginia | 51041 | 41004 | 566 |
1939798 | 1939798 | 2021-11-21 | Chesterfield | Virginia | 51041 | 40818 | 563 |
1936548 | 1936548 | 2021-11-20 | Chesterfield | Virginia | 51041 | 40818 | 563 |
1933298 | 1933298 | 2021-11-19 | Chesterfield | Virginia | 51041 | 40818 | 563 |
1930046 | 1930046 | 2021-11-18 | Chesterfield | Virginia | 51041 | 40758 | 562 |
1926796 | 1926796 | 2021-11-17 | Chesterfield | Virginia | 51041 | 40683 | 561 |
1923546 | 1923546 | 2021-11-16 | Chesterfield | Virginia | 51041 | 40592 | 559 |
1920297 | 1920297 | 2021-11-15 | Chesterfield | Virginia | 51041 | 40531 | 558 |
1917047 | 1917047 | 2021-11-14 | Chesterfield | Virginia | 51041 | 40397 | 557 |
1913797 | 1913797 | 2021-11-13 | Chesterfield | Virginia | 51041 | 40397 | 557 |
1910547 | 1910547 | 2021-11-12 | Chesterfield | Virginia | 51041 | 40397 | 557 |
1907298 | 1907298 | 2021-11-11 | Chesterfield | Virginia | 51041 | 40336 | 557 |
1904049 | 1904049 | 2021-11-10 | Chesterfield | Virginia | 51041 | 40272 | 557 |
1900799 | 1900799 | 2021-11-09 | Chesterfield | Virginia | 51041 | 40229 | 557 |
1897549 | 1897549 | 2021-11-08 | Chesterfield | Virginia | 51041 | 40171 | 557 |
1894299 | 1894299 | 2021-11-07 | Chesterfield | Virginia | 51041 | 40026 | 555 |
1891049 | 1891049 | 2021-11-06 | Chesterfield | Virginia | 51041 | 40026 | 555 |
1887799 | 1887799 | 2021-11-05 | Chesterfield | Virginia | 51041 | 40026 | 555 |
1884549 | 1884549 | 2021-11-04 | Chesterfield | Virginia | 51041 | 39968 | 554 |
1881300 | 1881300 | 2021-11-03 | Chesterfield | Virginia | 51041 | 39897 | 552 |
1878051 | 1878051 | 2021-11-02 | Chesterfield | Virginia | 51041 | 39813 | 550 |
1874802 | 1874802 | 2021-11-01 | Chesterfield | Virginia | 51041 | 39762 | 549 |
1871553 | 1871553 | 2021-10-31 | Chesterfield | Virginia | 51041 | 39620 | 548 |
1868304 | 1868304 | 2021-10-30 | Chesterfield | Virginia | 51041 | 39620 | 548 |
1865055 | 1865055 | 2021-10-29 | Chesterfield | Virginia | 51041 | 39620 | 548 |
1861806 | 1861806 | 2021-10-28 | Chesterfield | Virginia | 51041 | 39552 | 547 |
1858557 | 1858557 | 2021-10-27 | Chesterfield | Virginia | 51041 | 39478 | 547 |
1855308 | 1855308 | 2021-10-26 | Chesterfield | Virginia | 51041 | 39421 | 546 |
1852059 | 1852059 | 2021-10-25 | Chesterfield | Virginia | 51041 | 39360 | 542 |
1848809 | 1848809 | 2021-10-24 | Chesterfield | Virginia | 51041 | 39201 | 539 |
1845559 | 1845559 | 2021-10-23 | Chesterfield | Virginia | 51041 | 39201 | 539 |
1842309 | 1842309 | 2021-10-22 | Chesterfield | Virginia | 51041 | 39201 | 539 |
1839060 | 1839060 | 2021-10-21 | Chesterfield | Virginia | 51041 | 39113 | 539 |
1835811 | 1835811 | 2021-10-20 | Chesterfield | Virginia | 51041 | 39042 | 538 |
1832562 | 1832562 | 2021-10-19 | Chesterfield | Virginia | 51041 | 38992 | 534 |
1829313 | 1829313 | 2021-10-18 | Chesterfield | Virginia | 51041 | 38939 | 531 |
1826064 | 1826064 | 2021-10-17 | Chesterfield | Virginia | 51041 | 38728 | 526 |
1822815 | 1822815 | 2021-10-16 | Chesterfield | Virginia | 51041 | 38728 | 526 |
1819566 | 1819566 | 2021-10-15 | Chesterfield | Virginia | 51041 | 38728 | 526 |
1816317 | 1816317 | 2021-10-14 | Chesterfield | Virginia | 51041 | 38640 | 526 |
1813069 | 1813069 | 2021-10-13 | Chesterfield | Virginia | 51041 | 38524 | 524 |
1809820 | 1809820 | 2021-10-12 | Chesterfield | Virginia | 51041 | 38409 | 522 |
1806570 | 1806570 | 2021-10-11 | Chesterfield | Virginia | 51041 | 38072 | 515 |
1803320 | 1803320 | 2021-10-10 | Chesterfield | Virginia | 51041 | 38072 | 515 |
1800071 | 1800071 | 2021-10-09 | Chesterfield | Virginia | 51041 | 38072 | 515 |
1796822 | 1796822 | 2021-10-08 | Chesterfield | Virginia | 51041 | 38072 | 515 |
1793573 | 1793573 | 2021-10-07 | Chesterfield | Virginia | 51041 | 37937 | 511 |
1790324 | 1790324 | 2021-10-06 | Chesterfield | Virginia | 51041 | 37778 | 510 |
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);