ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 51760 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112163 | 2112163 | 2022-01-13 | Richmond city | Virginia | 51760 | 35646 | 394 |
2108911 | 2108911 | 2022-01-12 | Richmond city | Virginia | 51760 | 35284 | 393 |
2105660 | 2105660 | 2022-01-11 | Richmond city | Virginia | 51760 | 34798 | 393 |
2102409 | 2102409 | 2022-01-10 | Richmond city | Virginia | 51760 | 34296 | 391 |
2099158 | 2099158 | 2022-01-09 | Richmond city | Virginia | 51760 | 32901 | 391 |
2095907 | 2095907 | 2022-01-08 | Richmond city | Virginia | 51760 | 32901 | 391 |
2092655 | 2092655 | 2022-01-07 | Richmond city | Virginia | 51760 | 32901 | 391 |
2089403 | 2089403 | 2022-01-06 | Richmond city | Virginia | 51760 | 32460 | 391 |
2086152 | 2086152 | 2022-01-05 | Richmond city | Virginia | 51760 | 31873 | 391 |
2082900 | 2082900 | 2022-01-04 | Richmond city | Virginia | 51760 | 31486 | 391 |
2079648 | 2079648 | 2022-01-03 | Richmond city | Virginia | 51760 | 31054 | 390 |
2076396 | 2076396 | 2022-01-02 | Richmond city | Virginia | 51760 | 29694 | 390 |
2073145 | 2073145 | 2022-01-01 | Richmond city | Virginia | 51760 | 29694 | 390 |
2069894 | 2069894 | 2021-12-31 | Richmond city | Virginia | 51760 | 29694 | 390 |
2066643 | 2066643 | 2021-12-30 | Richmond city | Virginia | 51760 | 29208 | 390 |
2063393 | 2063393 | 2021-12-29 | Richmond city | Virginia | 51760 | 28819 | 389 |
2060143 | 2060143 | 2021-12-28 | Richmond city | Virginia | 51760 | 28367 | 389 |
2056894 | 2056894 | 2021-12-27 | Richmond city | Virginia | 51760 | 28075 | 384 |
2053645 | 2053645 | 2021-12-26 | Richmond city | Virginia | 51760 | 27319 | 382 |
2050395 | 2050395 | 2021-12-25 | Richmond city | Virginia | 51760 | 27319 | 382 |
2047145 | 2047145 | 2021-12-24 | Richmond city | Virginia | 51760 | 27319 | 382 |
2043895 | 2043895 | 2021-12-23 | Richmond city | Virginia | 51760 | 26973 | 382 |
2040646 | 2040646 | 2021-12-22 | Richmond city | Virginia | 51760 | 26779 | 382 |
2037396 | 2037396 | 2021-12-21 | Richmond city | Virginia | 51760 | 26567 | 380 |
2034146 | 2034146 | 2021-12-20 | Richmond city | Virginia | 51760 | 26433 | 380 |
2030896 | 2030896 | 2021-12-19 | Richmond city | Virginia | 51760 | 26106 | 380 |
2027645 | 2027645 | 2021-12-18 | Richmond city | Virginia | 51760 | 26106 | 380 |
2024394 | 2024394 | 2021-12-17 | Richmond city | Virginia | 51760 | 26106 | 380 |
2021143 | 2021143 | 2021-12-16 | Richmond city | Virginia | 51760 | 25989 | 380 |
2017892 | 2017892 | 2021-12-15 | Richmond city | Virginia | 51760 | 25897 | 378 |
2014642 | 2014642 | 2021-12-14 | Richmond city | Virginia | 51760 | 25816 | 378 |
2011391 | 2011391 | 2021-12-13 | Richmond city | Virginia | 51760 | 25762 | 376 |
2008140 | 2008140 | 2021-12-12 | Richmond city | Virginia | 51760 | 25591 | 375 |
2004889 | 2004889 | 2021-12-11 | Richmond city | Virginia | 51760 | 25591 | 375 |
2001638 | 2001638 | 2021-12-10 | Richmond city | Virginia | 51760 | 25591 | 375 |
1998388 | 1998388 | 2021-12-09 | Richmond city | Virginia | 51760 | 25518 | 374 |
1995137 | 1995137 | 2021-12-08 | Richmond city | Virginia | 51760 | 25462 | 375 |
1991886 | 1991886 | 2021-12-07 | Richmond city | Virginia | 51760 | 25412 | 374 |
1988635 | 1988635 | 2021-12-06 | Richmond city | Virginia | 51760 | 25362 | 371 |
1985385 | 1985385 | 2021-12-05 | Richmond city | Virginia | 51760 | 25218 | 371 |
1982135 | 1982135 | 2021-12-04 | Richmond city | Virginia | 51760 | 25218 | 371 |
1978885 | 1978885 | 2021-12-03 | Richmond city | Virginia | 51760 | 25218 | 371 |
1975635 | 1975635 | 2021-12-02 | Richmond city | Virginia | 51760 | 25149 | 371 |
1972386 | 1972386 | 2021-12-01 | Richmond city | Virginia | 51760 | 25101 | 371 |
1969136 | 1969136 | 2021-11-30 | Richmond city | Virginia | 51760 | 25054 | 371 |
1965886 | 1965886 | 2021-11-29 | Richmond city | Virginia | 51760 | 25016 | 371 |
1962634 | 1962634 | 2021-11-28 | Richmond city | Virginia | 51760 | 24918 | 371 |
1959383 | 1959383 | 2021-11-27 | Richmond city | Virginia | 51760 | 24918 | 371 |
1956132 | 1956132 | 2021-11-26 | Richmond city | Virginia | 51760 | 24918 | 371 |
1952881 | 1952881 | 2021-11-25 | Richmond city | Virginia | 51760 | 24883 | 371 |
1949630 | 1949630 | 2021-11-24 | Richmond city | Virginia | 51760 | 24849 | 371 |
1946379 | 1946379 | 2021-11-23 | Richmond city | Virginia | 51760 | 24800 | 370 |
1943128 | 1943128 | 2021-11-22 | Richmond city | Virginia | 51760 | 24760 | 368 |
1939878 | 1939878 | 2021-11-21 | Richmond city | Virginia | 51760 | 24665 | 366 |
1936628 | 1936628 | 2021-11-20 | Richmond city | Virginia | 51760 | 24665 | 366 |
1933378 | 1933378 | 2021-11-19 | Richmond city | Virginia | 51760 | 24665 | 366 |
1930126 | 1930126 | 2021-11-18 | Richmond city | Virginia | 51760 | 24640 | 365 |
1926876 | 1926876 | 2021-11-17 | Richmond city | Virginia | 51760 | 24600 | 363 |
1923626 | 1923626 | 2021-11-16 | Richmond city | Virginia | 51760 | 24552 | 363 |
1920377 | 1920377 | 2021-11-15 | Richmond city | Virginia | 51760 | 24508 | 362 |
1917127 | 1917127 | 2021-11-14 | Richmond city | Virginia | 51760 | 24425 | 359 |
1913877 | 1913877 | 2021-11-13 | Richmond city | Virginia | 51760 | 24425 | 359 |
1910627 | 1910627 | 2021-11-12 | Richmond city | Virginia | 51760 | 24425 | 359 |
1907378 | 1907378 | 2021-11-11 | Richmond city | Virginia | 51760 | 24396 | 359 |
1904129 | 1904129 | 2021-11-10 | Richmond city | Virginia | 51760 | 24356 | 359 |
1900879 | 1900879 | 2021-11-09 | Richmond city | Virginia | 51760 | 24312 | 357 |
1897629 | 1897629 | 2021-11-08 | Richmond city | Virginia | 51760 | 24274 | 357 |
1894379 | 1894379 | 2021-11-07 | Richmond city | Virginia | 51760 | 24171 | 355 |
1891129 | 1891129 | 2021-11-06 | Richmond city | Virginia | 51760 | 24171 | 355 |
1887879 | 1887879 | 2021-11-05 | Richmond city | Virginia | 51760 | 24171 | 355 |
1884629 | 1884629 | 2021-11-04 | Richmond city | Virginia | 51760 | 24153 | 355 |
1881380 | 1881380 | 2021-11-03 | Richmond city | Virginia | 51760 | 24119 | 354 |
1878131 | 1878131 | 2021-11-02 | Richmond city | Virginia | 51760 | 24082 | 351 |
1874882 | 1874882 | 2021-11-01 | Richmond city | Virginia | 51760 | 24020 | 350 |
1871633 | 1871633 | 2021-10-31 | Richmond city | Virginia | 51760 | 23933 | 348 |
1868384 | 1868384 | 2021-10-30 | Richmond city | Virginia | 51760 | 23933 | 348 |
1865135 | 1865135 | 2021-10-29 | Richmond city | Virginia | 51760 | 23933 | 348 |
1861886 | 1861886 | 2021-10-28 | Richmond city | Virginia | 51760 | 23889 | 348 |
1858637 | 1858637 | 2021-10-27 | Richmond city | Virginia | 51760 | 23855 | 348 |
1855388 | 1855388 | 2021-10-26 | Richmond city | Virginia | 51760 | 23819 | 346 |
1852139 | 1852139 | 2021-10-25 | Richmond city | Virginia | 51760 | 23795 | 343 |
1848889 | 1848889 | 2021-10-24 | Richmond city | Virginia | 51760 | 23694 | 343 |
1845639 | 1845639 | 2021-10-23 | Richmond city | Virginia | 51760 | 23694 | 343 |
1842389 | 1842389 | 2021-10-22 | Richmond city | Virginia | 51760 | 23694 | 343 |
1839140 | 1839140 | 2021-10-21 | Richmond city | Virginia | 51760 | 23649 | 343 |
1835891 | 1835891 | 2021-10-20 | Richmond city | Virginia | 51760 | 23622 | 341 |
1832642 | 1832642 | 2021-10-19 | Richmond city | Virginia | 51760 | 23597 | 340 |
1829393 | 1829393 | 2021-10-18 | Richmond city | Virginia | 51760 | 23553 | 336 |
1826144 | 1826144 | 2021-10-17 | Richmond city | Virginia | 51760 | 23458 | 333 |
1822895 | 1822895 | 2021-10-16 | Richmond city | Virginia | 51760 | 23458 | 333 |
1819646 | 1819646 | 2021-10-15 | Richmond city | Virginia | 51760 | 23458 | 333 |
1816397 | 1816397 | 2021-10-14 | Richmond city | Virginia | 51760 | 23430 | 332 |
1813149 | 1813149 | 2021-10-13 | Richmond city | Virginia | 51760 | 23382 | 331 |
1809900 | 1809900 | 2021-10-12 | Richmond city | Virginia | 51760 | 23337 | 329 |
1806650 | 1806650 | 2021-10-11 | Richmond city | Virginia | 51760 | 23145 | 322 |
1803400 | 1803400 | 2021-10-10 | Richmond city | Virginia | 51760 | 23145 | 322 |
1800151 | 1800151 | 2021-10-09 | Richmond city | Virginia | 51760 | 23145 | 322 |
1796902 | 1796902 | 2021-10-08 | Richmond city | Virginia | 51760 | 23145 | 322 |
1793653 | 1793653 | 2021-10-07 | Richmond city | Virginia | 51760 | 23095 | 322 |
1790404 | 1790404 | 2021-10-06 | Richmond city | Virginia | 51760 | 23032 | 320 |
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);