ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51510 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177127 | 2177127 | 2022-02-02 | Alexandria city | Virginia | 51510 | 28528 | 168 |
2173874 | 2173874 | 2022-02-01 | Alexandria city | Virginia | 51510 | 28416 | 166 |
2170622 | 2170622 | 2022-01-31 | Alexandria city | Virginia | 51510 | 28302 | 165 |
2167369 | 2167369 | 2022-01-30 | Alexandria city | Virginia | 51510 | 27894 | 165 |
2164114 | 2164114 | 2022-01-29 | Alexandria city | Virginia | 51510 | 27894 | 165 |
2160859 | 2160859 | 2022-01-28 | Alexandria city | Virginia | 51510 | 27894 | 165 |
2157603 | 2157603 | 2022-01-27 | Alexandria city | Virginia | 51510 | 27730 | 165 |
2154350 | 2154350 | 2022-01-26 | Alexandria city | Virginia | 51510 | 27605 | 165 |
2151097 | 2151097 | 2022-01-25 | Alexandria city | Virginia | 51510 | 27475 | 165 |
2147845 | 2147845 | 2022-01-24 | Alexandria city | Virginia | 51510 | 27353 | 165 |
2144592 | 2144592 | 2022-01-23 | Alexandria city | Virginia | 51510 | 26871 | 165 |
2141337 | 2141337 | 2022-01-22 | Alexandria city | Virginia | 51510 | 26871 | 165 |
2138081 | 2138081 | 2022-01-21 | Alexandria city | Virginia | 51510 | 26871 | 165 |
2134827 | 2134827 | 2022-01-20 | Alexandria city | Virginia | 51510 | 26617 | 166 |
2131575 | 2131575 | 2022-01-19 | Alexandria city | Virginia | 51510 | 26340 | 165 |
2128321 | 2128321 | 2022-01-18 | Alexandria city | Virginia | 51510 | 26097 | 163 |
2125068 | 2125068 | 2022-01-17 | Alexandria city | Virginia | 51510 | 25899 | 163 |
2121816 | 2121816 | 2022-01-16 | Alexandria city | Virginia | 51510 | 25027 | 164 |
2118564 | 2118564 | 2022-01-15 | Alexandria city | Virginia | 51510 | 25027 | 164 |
2115312 | 2115312 | 2022-01-14 | Alexandria city | Virginia | 51510 | 25027 | 164 |
2112060 | 2112060 | 2022-01-13 | Alexandria city | Virginia | 51510 | 24719 | 163 |
2108808 | 2108808 | 2022-01-12 | Alexandria city | Virginia | 51510 | 24210 | 165 |
2105557 | 2105557 | 2022-01-11 | Alexandria city | Virginia | 51510 | 23737 | 162 |
2102306 | 2102306 | 2022-01-10 | Alexandria city | Virginia | 51510 | 23325 | 161 |
2099055 | 2099055 | 2022-01-09 | Alexandria city | Virginia | 51510 | 21809 | 161 |
2095804 | 2095804 | 2022-01-08 | Alexandria city | Virginia | 51510 | 21809 | 161 |
2092552 | 2092552 | 2022-01-07 | Alexandria city | Virginia | 51510 | 21809 | 161 |
2089300 | 2089300 | 2022-01-06 | Alexandria city | Virginia | 51510 | 21422 | 161 |
2086049 | 2086049 | 2022-01-05 | Alexandria city | Virginia | 51510 | 21086 | 161 |
2082797 | 2082797 | 2022-01-04 | Alexandria city | Virginia | 51510 | 20875 | 161 |
2079545 | 2079545 | 2022-01-03 | Alexandria city | Virginia | 51510 | 20419 | 161 |
2076293 | 2076293 | 2022-01-02 | Alexandria city | Virginia | 51510 | 18480 | 161 |
2073042 | 2073042 | 2022-01-01 | Alexandria city | Virginia | 51510 | 18480 | 161 |
2069791 | 2069791 | 2021-12-31 | Alexandria city | Virginia | 51510 | 18480 | 161 |
2066540 | 2066540 | 2021-12-30 | Alexandria city | Virginia | 51510 | 18779 | 161 |
2063290 | 2063290 | 2021-12-29 | Alexandria city | Virginia | 51510 | 18319 | 161 |
2060040 | 2060040 | 2021-12-28 | Alexandria city | Virginia | 51510 | 18082 | 161 |
2056791 | 2056791 | 2021-12-27 | Alexandria city | Virginia | 51510 | 17814 | 157 |
2053542 | 2053542 | 2021-12-26 | Alexandria city | Virginia | 51510 | 17121 | 157 |
2050292 | 2050292 | 2021-12-25 | Alexandria city | Virginia | 51510 | 17121 | 157 |
2047042 | 2047042 | 2021-12-24 | Alexandria city | Virginia | 51510 | 17121 | 157 |
2043792 | 2043792 | 2021-12-23 | Alexandria city | Virginia | 51510 | 16811 | 157 |
2040543 | 2040543 | 2021-12-22 | Alexandria city | Virginia | 51510 | 16495 | 157 |
2037293 | 2037293 | 2021-12-21 | Alexandria city | Virginia | 51510 | 16238 | 156 |
2034043 | 2034043 | 2021-12-20 | Alexandria city | Virginia | 51510 | 16075 | 156 |
2030793 | 2030793 | 2021-12-19 | Alexandria city | Virginia | 51510 | 15633 | 156 |
2027542 | 2027542 | 2021-12-18 | Alexandria city | Virginia | 51510 | 15633 | 156 |
2024291 | 2024291 | 2021-12-17 | Alexandria city | Virginia | 51510 | 15633 | 156 |
2021040 | 2021040 | 2021-12-16 | Alexandria city | Virginia | 51510 | 15517 | 156 |
2017789 | 2017789 | 2021-12-15 | Alexandria city | Virginia | 51510 | 15407 | 156 |
2014539 | 2014539 | 2021-12-14 | Alexandria city | Virginia | 51510 | 15332 | 155 |
2011288 | 2011288 | 2021-12-13 | Alexandria city | Virginia | 51510 | 15300 | 155 |
2008037 | 2008037 | 2021-12-12 | Alexandria city | Virginia | 51510 | 15185 | 155 |
2004786 | 2004786 | 2021-12-11 | Alexandria city | Virginia | 51510 | 15185 | 155 |
2001535 | 2001535 | 2021-12-10 | Alexandria city | Virginia | 51510 | 15185 | 155 |
1998285 | 1998285 | 2021-12-09 | Alexandria city | Virginia | 51510 | 15140 | 155 |
1995034 | 1995034 | 2021-12-08 | Alexandria city | Virginia | 51510 | 15105 | 155 |
1991783 | 1991783 | 2021-12-07 | Alexandria city | Virginia | 51510 | 15056 | 155 |
1988532 | 1988532 | 2021-12-06 | Alexandria city | Virginia | 51510 | 15016 | 155 |
1985282 | 1985282 | 2021-12-05 | Alexandria city | Virginia | 51510 | 14922 | 155 |
1982032 | 1982032 | 2021-12-04 | Alexandria city | Virginia | 51510 | 14922 | 155 |
1978782 | 1978782 | 2021-12-03 | Alexandria city | Virginia | 51510 | 14922 | 155 |
1975532 | 1975532 | 2021-12-02 | Alexandria city | Virginia | 51510 | 14879 | 155 |
1972283 | 1972283 | 2021-12-01 | Alexandria city | Virginia | 51510 | 14837 | 155 |
1969033 | 1969033 | 2021-11-30 | Alexandria city | Virginia | 51510 | 14806 | 155 |
1965783 | 1965783 | 2021-11-29 | Alexandria city | Virginia | 51510 | 14789 | 154 |
1962531 | 1962531 | 2021-11-28 | Alexandria city | Virginia | 51510 | 14753 | 154 |
1959280 | 1959280 | 2021-11-27 | Alexandria city | Virginia | 51510 | 14753 | 154 |
1956029 | 1956029 | 2021-11-26 | Alexandria city | Virginia | 51510 | 14753 | 154 |
1952778 | 1952778 | 2021-11-25 | Alexandria city | Virginia | 51510 | 14740 | 154 |
1949527 | 1949527 | 2021-11-24 | Alexandria city | Virginia | 51510 | 14728 | 154 |
1946276 | 1946276 | 2021-11-23 | Alexandria city | Virginia | 51510 | 14714 | 154 |
1943025 | 1943025 | 2021-11-22 | Alexandria city | Virginia | 51510 | 14701 | 153 |
1939775 | 1939775 | 2021-11-21 | Alexandria city | Virginia | 51510 | 14647 | 153 |
1936525 | 1936525 | 2021-11-20 | Alexandria city | Virginia | 51510 | 14647 | 153 |
1933275 | 1933275 | 2021-11-19 | Alexandria city | Virginia | 51510 | 14647 | 153 |
1930023 | 1930023 | 2021-11-18 | Alexandria city | Virginia | 51510 | 14616 | 153 |
1926773 | 1926773 | 2021-11-17 | Alexandria city | Virginia | 51510 | 14601 | 153 |
1923523 | 1923523 | 2021-11-16 | Alexandria city | Virginia | 51510 | 14571 | 153 |
1920274 | 1920274 | 2021-11-15 | Alexandria city | Virginia | 51510 | 14562 | 152 |
1917024 | 1917024 | 2021-11-14 | Alexandria city | Virginia | 51510 | 14524 | 152 |
1913774 | 1913774 | 2021-11-13 | Alexandria city | Virginia | 51510 | 14524 | 152 |
1910524 | 1910524 | 2021-11-12 | Alexandria city | Virginia | 51510 | 14524 | 152 |
1907275 | 1907275 | 2021-11-11 | Alexandria city | Virginia | 51510 | 14509 | 151 |
1904026 | 1904026 | 2021-11-10 | Alexandria city | Virginia | 51510 | 14488 | 151 |
1900776 | 1900776 | 2021-11-09 | Alexandria city | Virginia | 51510 | 14460 | 151 |
1897526 | 1897526 | 2021-11-08 | Alexandria city | Virginia | 51510 | 14455 | 151 |
1894276 | 1894276 | 2021-11-07 | Alexandria city | Virginia | 51510 | 14400 | 150 |
1891026 | 1891026 | 2021-11-06 | Alexandria city | Virginia | 51510 | 14400 | 150 |
1887776 | 1887776 | 2021-11-05 | Alexandria city | Virginia | 51510 | 14400 | 150 |
1884526 | 1884526 | 2021-11-04 | Alexandria city | Virginia | 51510 | 14378 | 150 |
1881277 | 1881277 | 2021-11-03 | Alexandria city | Virginia | 51510 | 14363 | 150 |
1878028 | 1878028 | 2021-11-02 | Alexandria city | Virginia | 51510 | 14342 | 149 |
1874779 | 1874779 | 2021-11-01 | Alexandria city | Virginia | 51510 | 14331 | 149 |
1871530 | 1871530 | 2021-10-31 | Alexandria city | Virginia | 51510 | 14277 | 149 |
1868281 | 1868281 | 2021-10-30 | Alexandria city | Virginia | 51510 | 14277 | 149 |
1865032 | 1865032 | 2021-10-29 | Alexandria city | Virginia | 51510 | 14277 | 149 |
1861783 | 1861783 | 2021-10-28 | Alexandria city | Virginia | 51510 | 14255 | 149 |
1858534 | 1858534 | 2021-10-27 | Alexandria city | Virginia | 51510 | 14231 | 149 |
1855285 | 1855285 | 2021-10-26 | Alexandria city | Virginia | 51510 | 14211 | 149 |
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);