ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51153 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112158 | 2112158 | 2022-01-13 | Prince William | Virginia | 51153 | 81904 | 620 |
2108906 | 2108906 | 2022-01-12 | Prince William | Virginia | 51153 | 80922 | 619 |
2105655 | 2105655 | 2022-01-11 | Prince William | Virginia | 51153 | 79407 | 617 |
2102404 | 2102404 | 2022-01-10 | Prince William | Virginia | 51153 | 78059 | 616 |
2099153 | 2099153 | 2022-01-09 | Prince William | Virginia | 51153 | 74775 | 616 |
2095902 | 2095902 | 2022-01-08 | Prince William | Virginia | 51153 | 74775 | 616 |
2092650 | 2092650 | 2022-01-07 | Prince William | Virginia | 51153 | 74775 | 616 |
2089398 | 2089398 | 2022-01-06 | Prince William | Virginia | 51153 | 73405 | 616 |
2086147 | 2086147 | 2022-01-05 | Prince William | Virginia | 51153 | 72503 | 616 |
2082895 | 2082895 | 2022-01-04 | Prince William | Virginia | 51153 | 71895 | 616 |
2079643 | 2079643 | 2022-01-03 | Prince William | Virginia | 51153 | 70998 | 616 |
2076391 | 2076391 | 2022-01-02 | Prince William | Virginia | 51153 | 67877 | 616 |
2073140 | 2073140 | 2022-01-01 | Prince William | Virginia | 51153 | 67877 | 616 |
2069889 | 2069889 | 2021-12-31 | Prince William | Virginia | 51153 | 67877 | 616 |
2066638 | 2066638 | 2021-12-30 | Prince William | Virginia | 51153 | 66310 | 616 |
2063388 | 2063388 | 2021-12-29 | Prince William | Virginia | 51153 | 65360 | 616 |
2060138 | 2060138 | 2021-12-28 | Prince William | Virginia | 51153 | 64182 | 615 |
2056889 | 2056889 | 2021-12-27 | Prince William | Virginia | 51153 | 63603 | 598 |
2053640 | 2053640 | 2021-12-26 | Prince William | Virginia | 51153 | 62030 | 597 |
2050390 | 2050390 | 2021-12-25 | Prince William | Virginia | 51153 | 62030 | 597 |
2047140 | 2047140 | 2021-12-24 | Prince William | Virginia | 51153 | 62030 | 597 |
2043890 | 2043890 | 2021-12-23 | Prince William | Virginia | 51153 | 61354 | 596 |
2040641 | 2040641 | 2021-12-22 | Prince William | Virginia | 51153 | 60819 | 594 |
2037391 | 2037391 | 2021-12-21 | Prince William | Virginia | 51153 | 60281 | 593 |
2034141 | 2034141 | 2021-12-20 | Prince William | Virginia | 51153 | 59986 | 591 |
2030891 | 2030891 | 2021-12-19 | Prince William | Virginia | 51153 | 59310 | 590 |
2027640 | 2027640 | 2021-12-18 | Prince William | Virginia | 51153 | 59310 | 590 |
2024389 | 2024389 | 2021-12-17 | Prince William | Virginia | 51153 | 59310 | 590 |
2021138 | 2021138 | 2021-12-16 | Prince William | Virginia | 51153 | 59110 | 590 |
2017887 | 2017887 | 2021-12-15 | Prince William | Virginia | 51153 | 58937 | 590 |
2014637 | 2014637 | 2021-12-14 | Prince William | Virginia | 51153 | 58777 | 590 |
2011386 | 2011386 | 2021-12-13 | Prince William | Virginia | 51153 | 58676 | 590 |
2008135 | 2008135 | 2021-12-12 | Prince William | Virginia | 51153 | 58346 | 590 |
2004884 | 2004884 | 2021-12-11 | Prince William | Virginia | 51153 | 58346 | 590 |
2001633 | 2001633 | 2021-12-10 | Prince William | Virginia | 51153 | 58346 | 590 |
1998383 | 1998383 | 2021-12-09 | Prince William | Virginia | 51153 | 58221 | 591 |
1995132 | 1995132 | 2021-12-08 | Prince William | Virginia | 51153 | 58085 | 590 |
1991881 | 1991881 | 2021-12-07 | Prince William | Virginia | 51153 | 57899 | 585 |
1988630 | 1988630 | 2021-12-06 | Prince William | Virginia | 51153 | 57794 | 585 |
1985380 | 1985380 | 2021-12-05 | Prince William | Virginia | 51153 | 57508 | 585 |
1982130 | 1982130 | 2021-12-04 | Prince William | Virginia | 51153 | 57508 | 585 |
1978880 | 1978880 | 2021-12-03 | Prince William | Virginia | 51153 | 57508 | 585 |
1975630 | 1975630 | 2021-12-02 | Prince William | Virginia | 51153 | 57384 | 585 |
1972381 | 1972381 | 2021-12-01 | Prince William | Virginia | 51153 | 57253 | 584 |
1969131 | 1969131 | 2021-11-30 | Prince William | Virginia | 51153 | 57104 | 584 |
1965881 | 1965881 | 2021-11-29 | Prince William | Virginia | 51153 | 57023 | 583 |
1962629 | 1962629 | 2021-11-28 | Prince William | Virginia | 51153 | 56888 | 581 |
1959378 | 1959378 | 2021-11-27 | Prince William | Virginia | 51153 | 56888 | 581 |
1956127 | 1956127 | 2021-11-26 | Prince William | Virginia | 51153 | 56888 | 581 |
1952876 | 1952876 | 2021-11-25 | Prince William | Virginia | 51153 | 56845 | 580 |
1949625 | 1949625 | 2021-11-24 | Prince William | Virginia | 51153 | 56772 | 580 |
1946374 | 1946374 | 2021-11-23 | Prince William | Virginia | 51153 | 56716 | 579 |
1943123 | 1943123 | 2021-11-22 | Prince William | Virginia | 51153 | 56658 | 579 |
1939873 | 1939873 | 2021-11-21 | Prince William | Virginia | 51153 | 56495 | 578 |
1936623 | 1936623 | 2021-11-20 | Prince William | Virginia | 51153 | 56495 | 578 |
1933373 | 1933373 | 2021-11-19 | Prince William | Virginia | 51153 | 56495 | 578 |
1930121 | 1930121 | 2021-11-18 | Prince William | Virginia | 51153 | 56411 | 578 |
1926871 | 1926871 | 2021-11-17 | Prince William | Virginia | 51153 | 56314 | 578 |
1923621 | 1923621 | 2021-11-16 | Prince William | Virginia | 51153 | 56165 | 576 |
1920372 | 1920372 | 2021-11-15 | Prince William | Virginia | 51153 | 56105 | 575 |
1917122 | 1917122 | 2021-11-14 | Prince William | Virginia | 51153 | 55938 | 574 |
1913872 | 1913872 | 2021-11-13 | Prince William | Virginia | 51153 | 55938 | 574 |
1910622 | 1910622 | 2021-11-12 | Prince William | Virginia | 51153 | 55938 | 574 |
1907373 | 1907373 | 2021-11-11 | Prince William | Virginia | 51153 | 55873 | 573 |
1904124 | 1904124 | 2021-11-10 | Prince William | Virginia | 51153 | 55793 | 573 |
1900874 | 1900874 | 2021-11-09 | Prince William | Virginia | 51153 | 55743 | 573 |
1897624 | 1897624 | 2021-11-08 | Prince William | Virginia | 51153 | 55632 | 572 |
1894374 | 1894374 | 2021-11-07 | Prince William | Virginia | 51153 | 55478 | 572 |
1891124 | 1891124 | 2021-11-06 | Prince William | Virginia | 51153 | 55478 | 572 |
1887874 | 1887874 | 2021-11-05 | Prince William | Virginia | 51153 | 55478 | 572 |
1884624 | 1884624 | 2021-11-04 | Prince William | Virginia | 51153 | 55422 | 570 |
1881375 | 1881375 | 2021-11-03 | Prince William | Virginia | 51153 | 55344 | 568 |
1878126 | 1878126 | 2021-11-02 | Prince William | Virginia | 51153 | 55280 | 566 |
1874877 | 1874877 | 2021-11-01 | Prince William | Virginia | 51153 | 55241 | 566 |
1871628 | 1871628 | 2021-10-31 | Prince William | Virginia | 51153 | 55079 | 563 |
1868379 | 1868379 | 2021-10-30 | Prince William | Virginia | 51153 | 55079 | 563 |
1865130 | 1865130 | 2021-10-29 | Prince William | Virginia | 51153 | 55079 | 563 |
1861881 | 1861881 | 2021-10-28 | Prince William | Virginia | 51153 | 55000 | 563 |
1858632 | 1858632 | 2021-10-27 | Prince William | Virginia | 51153 | 54913 | 563 |
1855383 | 1855383 | 2021-10-26 | Prince William | Virginia | 51153 | 54842 | 560 |
1852134 | 1852134 | 2021-10-25 | Prince William | Virginia | 51153 | 54805 | 559 |
1848884 | 1848884 | 2021-10-24 | Prince William | Virginia | 51153 | 54635 | 557 |
1845634 | 1845634 | 2021-10-23 | Prince William | Virginia | 51153 | 54635 | 557 |
1842384 | 1842384 | 2021-10-22 | Prince William | Virginia | 51153 | 54635 | 557 |
1839135 | 1839135 | 2021-10-21 | Prince William | Virginia | 51153 | 54568 | 556 |
1835886 | 1835886 | 2021-10-20 | Prince William | Virginia | 51153 | 54470 | 556 |
1832637 | 1832637 | 2021-10-19 | Prince William | Virginia | 51153 | 54348 | 555 |
1829388 | 1829388 | 2021-10-18 | Prince William | Virginia | 51153 | 54279 | 552 |
1826139 | 1826139 | 2021-10-17 | Prince William | Virginia | 51153 | 54059 | 549 |
1822890 | 1822890 | 2021-10-16 | Prince William | Virginia | 51153 | 54059 | 549 |
1819641 | 1819641 | 2021-10-15 | Prince William | Virginia | 51153 | 54059 | 549 |
1816392 | 1816392 | 2021-10-14 | Prince William | Virginia | 51153 | 53952 | 548 |
1813144 | 1813144 | 2021-10-13 | Prince William | Virginia | 51153 | 53809 | 546 |
1809895 | 1809895 | 2021-10-12 | Prince William | Virginia | 51153 | 53712 | 546 |
1806645 | 1806645 | 2021-10-11 | Prince William | Virginia | 51153 | 53386 | 544 |
1803395 | 1803395 | 2021-10-10 | Prince William | Virginia | 51153 | 53386 | 544 |
1800146 | 1800146 | 2021-10-09 | Prince William | Virginia | 51153 | 53386 | 544 |
1796897 | 1796897 | 2021-10-08 | Prince William | Virginia | 51153 | 53386 | 544 |
1793648 | 1793648 | 2021-10-07 | Prince William | Virginia | 51153 | 53250 | 544 |
1790399 | 1790399 | 2021-10-06 | Prince William | Virginia | 51153 | 53151 | 544 |
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);