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)
date (date) >30 ✖
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- …
state 1
- Virginia · 691 ✖
fips 1
- 51041 · 691 ✖
county 1
- Chesterfield 691
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177150 | 2177150 | 2022-02-02 | Chesterfield | Virginia | 51041 | 67535 | 632 |
2173897 | 2173897 | 2022-02-01 | Chesterfield | Virginia | 51041 | 67260 | 625 |
2170645 | 2170645 | 2022-01-31 | Chesterfield | Virginia | 51041 | 66999 | 624 |
2167392 | 2167392 | 2022-01-30 | Chesterfield | Virginia | 51041 | 66201 | 622 |
2164137 | 2164137 | 2022-01-29 | Chesterfield | Virginia | 51041 | 66201 | 622 |
2160882 | 2160882 | 2022-01-28 | Chesterfield | Virginia | 51041 | 66201 | 622 |
2157626 | 2157626 | 2022-01-27 | Chesterfield | Virginia | 51041 | 65649 | 619 |
2154373 | 2154373 | 2022-01-26 | Chesterfield | Virginia | 51041 | 65031 | 619 |
2151120 | 2151120 | 2022-01-25 | Chesterfield | Virginia | 51041 | 64359 | 615 |
2147868 | 2147868 | 2022-01-24 | Chesterfield | Virginia | 51041 | 63806 | 613 |
2144615 | 2144615 | 2022-01-23 | Chesterfield | Virginia | 51041 | 62461 | 611 |
2141360 | 2141360 | 2022-01-22 | Chesterfield | Virginia | 51041 | 62461 | 611 |
2138104 | 2138104 | 2022-01-21 | Chesterfield | Virginia | 51041 | 62461 | 611 |
2134850 | 2134850 | 2022-01-20 | Chesterfield | Virginia | 51041 | 61674 | 611 |
2131598 | 2131598 | 2022-01-19 | Chesterfield | Virginia | 51041 | 61071 | 611 |
2128344 | 2128344 | 2022-01-18 | Chesterfield | Virginia | 51041 | 60476 | 611 |
2125091 | 2125091 | 2022-01-17 | Chesterfield | Virginia | 51041 | 60101 | 611 |
2121839 | 2121839 | 2022-01-16 | Chesterfield | Virginia | 51041 | 58244 | 611 |
2118587 | 2118587 | 2022-01-15 | Chesterfield | Virginia | 51041 | 58244 | 611 |
2115335 | 2115335 | 2022-01-14 | Chesterfield | Virginia | 51041 | 58244 | 611 |
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 |
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);