ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,028 rows where state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Virginia · 894 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
49730 | 49730 | 2022-08-17 | Virginia | 51 | 2005336 | 21203 |
49674 | 49674 | 2022-08-16 | Virginia | 51 | 2002553 | 21183 |
49618 | 49618 | 2022-08-15 | Virginia | 51 | 1999881 | 21163 |
49562 | 49562 | 2022-08-14 | Virginia | 51 | 1993874 | 21145 |
49506 | 49506 | 2022-08-13 | Virginia | 51 | 1993874 | 21145 |
49450 | 49450 | 2022-08-12 | Virginia | 51 | 1993874 | 21145 |
49394 | 49394 | 2022-08-11 | Virginia | 51 | 1990841 | 21126 |
49338 | 49338 | 2022-08-10 | Virginia | 51 | 1987738 | 21102 |
49282 | 49282 | 2022-08-09 | Virginia | 51 | 1984528 | 21085 |
49226 | 49226 | 2022-08-08 | Virginia | 51 | 1981758 | 21075 |
49170 | 49170 | 2022-08-07 | Virginia | 51 | 1975007 | 21054 |
49114 | 49114 | 2022-08-06 | Virginia | 51 | 1975007 | 21054 |
49058 | 49058 | 2022-08-05 | Virginia | 51 | 1975007 | 21054 |
49002 | 49002 | 2022-08-04 | Virginia | 51 | 1971358 | 21024 |
48946 | 48946 | 2022-08-03 | Virginia | 51 | 1968329 | 20995 |
48890 | 48890 | 2022-08-02 | Virginia | 51 | 1965090 | 20969 |
48834 | 48834 | 2022-08-01 | Virginia | 51 | 1962140 | 20938 |
48778 | 48778 | 2022-07-31 | Virginia | 51 | 1954716 | 20918 |
48722 | 48722 | 2022-07-30 | Virginia | 51 | 1954716 | 20918 |
48666 | 48666 | 2022-07-29 | Virginia | 51 | 1954716 | 20918 |
48610 | 48610 | 2022-07-28 | Virginia | 51 | 1950818 | 20905 |
48554 | 48554 | 2022-07-27 | Virginia | 51 | 1947686 | 20889 |
48498 | 48498 | 2022-07-26 | Virginia | 51 | 1944125 | 20877 |
48442 | 48442 | 2022-07-25 | Virginia | 51 | 1941358 | 20873 |
48386 | 48386 | 2022-07-24 | Virginia | 51 | 1933366 | 20867 |
48330 | 48330 | 2022-07-23 | Virginia | 51 | 1933366 | 20867 |
48274 | 48274 | 2022-07-22 | Virginia | 51 | 1933366 | 20867 |
48218 | 48218 | 2022-07-21 | Virginia | 51 | 1929718 | 20853 |
48162 | 48162 | 2022-07-20 | Virginia | 51 | 1925915 | 20839 |
48106 | 48106 | 2022-07-19 | Virginia | 51 | 1922809 | 20823 |
48050 | 48050 | 2022-07-18 | Virginia | 51 | 1919590 | 20812 |
47994 | 47994 | 2022-07-17 | Virginia | 51 | 1912217 | 20801 |
47938 | 47938 | 2022-07-16 | Virginia | 51 | 1912217 | 20801 |
47882 | 47882 | 2022-07-15 | Virginia | 51 | 1912217 | 20801 |
47826 | 47826 | 2022-07-14 | Virginia | 51 | 1908742 | 20786 |
47770 | 47770 | 2022-07-13 | Virginia | 51 | 1905474 | 20772 |
47714 | 47714 | 2022-07-12 | Virginia | 51 | 1902133 | 20755 |
47658 | 47658 | 2022-07-11 | Virginia | 51 | 1898849 | 20746 |
47602 | 47602 | 2022-07-10 | Virginia | 51 | 1890973 | 20740 |
47546 | 47546 | 2022-07-09 | Virginia | 51 | 1890973 | 20740 |
47490 | 47490 | 2022-07-08 | Virginia | 51 | 1890973 | 20740 |
47434 | 47434 | 2022-07-07 | Virginia | 51 | 1887431 | 20716 |
47378 | 47378 | 2022-07-06 | Virginia | 51 | 1884246 | 20691 |
47322 | 47322 | 2022-07-05 | Virginia | 51 | 1881525 | 20673 |
47266 | 47266 | 2022-07-04 | Virginia | 51 | 1879306 | 20654 |
47210 | 47210 | 2022-07-03 | Virginia | 51 | 1872624 | 20630 |
47154 | 47154 | 2022-07-02 | Virginia | 51 | 1872624 | 20630 |
47098 | 47098 | 2022-07-01 | Virginia | 51 | 1872624 | 20630 |
47042 | 47042 | 2022-06-30 | Virginia | 51 | 1869231 | 20598 |
46986 | 46986 | 2022-06-29 | Virginia | 51 | 1865917 | 20571 |
46930 | 46930 | 2022-06-28 | Virginia | 51 | 1862659 | 20558 |
46874 | 46874 | 2022-06-27 | Virginia | 51 | 1859589 | 20521 |
46818 | 46818 | 2022-06-26 | Virginia | 51 | 1852970 | 20519 |
46762 | 46762 | 2022-06-25 | Virginia | 51 | 1852970 | 20519 |
46706 | 46706 | 2022-06-24 | Virginia | 51 | 1852970 | 20519 |
46650 | 46650 | 2022-06-23 | Virginia | 51 | 1849990 | 20498 |
46594 | 46594 | 2022-06-22 | Virginia | 51 | 1846905 | 20482 |
46538 | 46538 | 2022-06-21 | Virginia | 51 | 1844313 | 20467 |
46482 | 46482 | 2022-06-20 | Virginia | 51 | 1841786 | 20455 |
46426 | 46426 | 2022-06-19 | Virginia | 51 | 1835591 | 20453 |
46370 | 46370 | 2022-06-18 | Virginia | 51 | 1835591 | 20453 |
46314 | 46314 | 2022-06-17 | Virginia | 51 | 1835591 | 20453 |
46258 | 46258 | 2022-06-16 | Virginia | 51 | 1832648 | 20450 |
46202 | 46202 | 2022-06-15 | Virginia | 51 | 1830122 | 20448 |
46146 | 46146 | 2022-06-14 | Virginia | 51 | 1827418 | 20443 |
46090 | 46090 | 2022-06-13 | Virginia | 51 | 1824660 | 20441 |
46034 | 46034 | 2022-06-12 | Virginia | 51 | 1817814 | 20441 |
45978 | 45978 | 2022-06-11 | Virginia | 51 | 1817814 | 20441 |
45922 | 45922 | 2022-06-10 | Virginia | 51 | 1817814 | 20441 |
45866 | 45866 | 2022-06-09 | Virginia | 51 | 1814666 | 20439 |
45810 | 45810 | 2022-06-08 | Virginia | 51 | 1811366 | 20436 |
45754 | 45754 | 2022-06-07 | Virginia | 51 | 1808408 | 20435 |
45698 | 45698 | 2022-06-06 | Virginia | 51 | 1805781 | 20431 |
45642 | 45642 | 2022-06-05 | Virginia | 51 | 1797700 | 20424 |
45586 | 45586 | 2022-06-04 | Virginia | 51 | 1797700 | 20424 |
45530 | 45530 | 2022-06-03 | Virginia | 51 | 1797700 | 20424 |
45474 | 45474 | 2022-06-02 | Virginia | 51 | 1793644 | 20410 |
45418 | 45418 | 2022-06-01 | Virginia | 51 | 1790726 | 20400 |
45362 | 45362 | 2022-05-31 | Virginia | 51 | 1787756 | 20389 |
45306 | 45306 | 2022-05-30 | Virginia | 51 | 1785768 | 20378 |
45250 | 45250 | 2022-05-29 | Virginia | 51 | 1777813 | 20376 |
45194 | 45194 | 2022-05-28 | Virginia | 51 | 1777813 | 20376 |
45138 | 45138 | 2022-05-27 | Virginia | 51 | 1777813 | 20376 |
45082 | 45082 | 2022-05-26 | Virginia | 51 | 1774185 | 20370 |
45026 | 45026 | 2022-05-25 | Virginia | 51 | 1770620 | 20358 |
44970 | 44970 | 2022-05-24 | Virginia | 51 | 1767132 | 20348 |
44914 | 44914 | 2022-05-23 | Virginia | 51 | 1763908 | 20340 |
44858 | 44858 | 2022-05-22 | Virginia | 51 | 1755290 | 20338 |
44802 | 44802 | 2022-05-21 | Virginia | 51 | 1755290 | 20338 |
44746 | 44746 | 2022-05-20 | Virginia | 51 | 1755290 | 20338 |
44690 | 44690 | 2022-05-19 | Virginia | 51 | 1751443 | 20332 |
44634 | 44634 | 2022-05-18 | Virginia | 51 | 1747607 | 20328 |
44578 | 44578 | 2022-05-17 | Virginia | 51 | 1744306 | 20328 |
44522 | 44522 | 2022-05-16 | Virginia | 51 | 1740753 | 20322 |
44466 | 44466 | 2022-05-15 | Virginia | 51 | 1733188 | 20317 |
44410 | 44410 | 2022-05-14 | Virginia | 51 | 1733188 | 20317 |
44354 | 44354 | 2022-05-13 | Virginia | 51 | 1733188 | 20317 |
44298 | 44298 | 2022-05-12 | Virginia | 51 | 1729893 | 20310 |
44242 | 44242 | 2022-05-11 | Virginia | 51 | 1726749 | 20301 |
44186 | 44186 | 2022-05-10 | Virginia | 51 | 1723985 | 20295 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );