ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Charlottesville city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177148 | 2177148 | 2022-02-02 | Charlottesville city | Virginia | 51540 | 9155 | 63 |
2173895 | 2173895 | 2022-02-01 | Charlottesville city | Virginia | 51540 | 9090 | 63 |
2170643 | 2170643 | 2022-01-31 | Charlottesville city | Virginia | 51540 | 9050 | 63 |
2167390 | 2167390 | 2022-01-30 | Charlottesville city | Virginia | 51540 | 8847 | 63 |
2164135 | 2164135 | 2022-01-29 | Charlottesville city | Virginia | 51540 | 8847 | 63 |
2160880 | 2160880 | 2022-01-28 | Charlottesville city | Virginia | 51540 | 8847 | 63 |
2157624 | 2157624 | 2022-01-27 | Charlottesville city | Virginia | 51540 | 8757 | 63 |
2154371 | 2154371 | 2022-01-26 | Charlottesville city | Virginia | 51540 | 8647 | 63 |
2151118 | 2151118 | 2022-01-25 | Charlottesville city | Virginia | 51540 | 8555 | 63 |
2147866 | 2147866 | 2022-01-24 | Charlottesville city | Virginia | 51540 | 8454 | 63 |
2144613 | 2144613 | 2022-01-23 | Charlottesville city | Virginia | 51540 | 8238 | 64 |
2141358 | 2141358 | 2022-01-22 | Charlottesville city | Virginia | 51540 | 8238 | 64 |
2138102 | 2138102 | 2022-01-21 | Charlottesville city | Virginia | 51540 | 8238 | 64 |
2134848 | 2134848 | 2022-01-20 | Charlottesville city | Virginia | 51540 | 8023 | 64 |
2131596 | 2131596 | 2022-01-19 | Charlottesville city | Virginia | 51540 | 7900 | 64 |
2128342 | 2128342 | 2022-01-18 | Charlottesville city | Virginia | 51540 | 7806 | 65 |
2125089 | 2125089 | 2022-01-17 | Charlottesville city | Virginia | 51540 | 7790 | 65 |
2121837 | 2121837 | 2022-01-16 | Charlottesville city | Virginia | 51540 | 7563 | 65 |
2118585 | 2118585 | 2022-01-15 | Charlottesville city | Virginia | 51540 | 7563 | 65 |
2115333 | 2115333 | 2022-01-14 | Charlottesville city | Virginia | 51540 | 7563 | 65 |
2112081 | 2112081 | 2022-01-13 | Charlottesville city | Virginia | 51540 | 7454 | 65 |
2108829 | 2108829 | 2022-01-12 | Charlottesville city | Virginia | 51540 | 7334 | 65 |
2105578 | 2105578 | 2022-01-11 | Charlottesville city | Virginia | 51540 | 7199 | 64 |
2102327 | 2102327 | 2022-01-10 | Charlottesville city | Virginia | 51540 | 7124 | 64 |
2099076 | 2099076 | 2022-01-09 | Charlottesville city | Virginia | 51540 | 6823 | 64 |
2095825 | 2095825 | 2022-01-08 | Charlottesville city | Virginia | 51540 | 6823 | 64 |
2092573 | 2092573 | 2022-01-07 | Charlottesville city | Virginia | 51540 | 6823 | 64 |
2089321 | 2089321 | 2022-01-06 | Charlottesville city | Virginia | 51540 | 6683 | 64 |
2086070 | 2086070 | 2022-01-05 | Charlottesville city | Virginia | 51540 | 6569 | 64 |
2082818 | 2082818 | 2022-01-04 | Charlottesville city | Virginia | 51540 | 6518 | 64 |
2079566 | 2079566 | 2022-01-03 | Charlottesville city | Virginia | 51540 | 6437 | 64 |
2076314 | 2076314 | 2022-01-02 | Charlottesville city | Virginia | 51540 | 6225 | 64 |
2073063 | 2073063 | 2022-01-01 | Charlottesville city | Virginia | 51540 | 6225 | 64 |
2069812 | 2069812 | 2021-12-31 | Charlottesville city | Virginia | 51540 | 6225 | 64 |
2066561 | 2066561 | 2021-12-30 | Charlottesville city | Virginia | 51540 | 6159 | 64 |
2063311 | 2063311 | 2021-12-29 | Charlottesville city | Virginia | 51540 | 6073 | 63 |
2060061 | 2060061 | 2021-12-28 | Charlottesville city | Virginia | 51540 | 5990 | 63 |
2056812 | 2056812 | 2021-12-27 | Charlottesville city | Virginia | 51540 | 5968 | 63 |
2053563 | 2053563 | 2021-12-26 | Charlottesville city | Virginia | 51540 | 5890 | 63 |
2050313 | 2050313 | 2021-12-25 | Charlottesville city | Virginia | 51540 | 5890 | 63 |
2047063 | 2047063 | 2021-12-24 | Charlottesville city | Virginia | 51540 | 5890 | 63 |
2043813 | 2043813 | 2021-12-23 | Charlottesville city | Virginia | 51540 | 5857 | 63 |
2040564 | 2040564 | 2021-12-22 | Charlottesville city | Virginia | 51540 | 5830 | 63 |
2037314 | 2037314 | 2021-12-21 | Charlottesville city | Virginia | 51540 | 5808 | 62 |
2034064 | 2034064 | 2021-12-20 | Charlottesville city | Virginia | 51540 | 5788 | 62 |
2030814 | 2030814 | 2021-12-19 | Charlottesville city | Virginia | 51540 | 5744 | 62 |
2027563 | 2027563 | 2021-12-18 | Charlottesville city | Virginia | 51540 | 5744 | 62 |
2024312 | 2024312 | 2021-12-17 | Charlottesville city | Virginia | 51540 | 5744 | 62 |
2021061 | 2021061 | 2021-12-16 | Charlottesville city | Virginia | 51540 | 5727 | 62 |
2017810 | 2017810 | 2021-12-15 | Charlottesville city | Virginia | 51540 | 5711 | 62 |
2014560 | 2014560 | 2021-12-14 | Charlottesville city | Virginia | 51540 | 5689 | 62 |
2011309 | 2011309 | 2021-12-13 | Charlottesville city | Virginia | 51540 | 5677 | 62 |
2008058 | 2008058 | 2021-12-12 | Charlottesville city | Virginia | 51540 | 5645 | 62 |
2004807 | 2004807 | 2021-12-11 | Charlottesville city | Virginia | 51540 | 5645 | 62 |
2001556 | 2001556 | 2021-12-10 | Charlottesville city | Virginia | 51540 | 5645 | 62 |
1998306 | 1998306 | 2021-12-09 | Charlottesville city | Virginia | 51540 | 5628 | 62 |
1995055 | 1995055 | 2021-12-08 | Charlottesville city | Virginia | 51540 | 5618 | 62 |
1991804 | 1991804 | 2021-12-07 | Charlottesville city | Virginia | 51540 | 5600 | 62 |
1988553 | 1988553 | 2021-12-06 | Charlottesville city | Virginia | 51540 | 5592 | 62 |
1985303 | 1985303 | 2021-12-05 | Charlottesville city | Virginia | 51540 | 5552 | 62 |
1982053 | 1982053 | 2021-12-04 | Charlottesville city | Virginia | 51540 | 5552 | 62 |
1978803 | 1978803 | 2021-12-03 | Charlottesville city | Virginia | 51540 | 5552 | 62 |
1975553 | 1975553 | 2021-12-02 | Charlottesville city | Virginia | 51540 | 5547 | 62 |
1972304 | 1972304 | 2021-12-01 | Charlottesville city | Virginia | 51540 | 5534 | 62 |
1969054 | 1969054 | 2021-11-30 | Charlottesville city | Virginia | 51540 | 5522 | 62 |
1965804 | 1965804 | 2021-11-29 | Charlottesville city | Virginia | 51540 | 5525 | 62 |
1962552 | 1962552 | 2021-11-28 | Charlottesville city | Virginia | 51540 | 5515 | 62 |
1959301 | 1959301 | 2021-11-27 | Charlottesville city | Virginia | 51540 | 5515 | 62 |
1956050 | 1956050 | 2021-11-26 | Charlottesville city | Virginia | 51540 | 5515 | 62 |
1952799 | 1952799 | 2021-11-25 | Charlottesville city | Virginia | 51540 | 5503 | 62 |
1949548 | 1949548 | 2021-11-24 | Charlottesville city | Virginia | 51540 | 5492 | 62 |
1946297 | 1946297 | 2021-11-23 | Charlottesville city | Virginia | 51540 | 5484 | 61 |
1943046 | 1943046 | 2021-11-22 | Charlottesville city | Virginia | 51540 | 5475 | 61 |
1939796 | 1939796 | 2021-11-21 | Charlottesville city | Virginia | 51540 | 5453 | 60 |
1936546 | 1936546 | 2021-11-20 | Charlottesville city | Virginia | 51540 | 5453 | 60 |
1933296 | 1933296 | 2021-11-19 | Charlottesville city | Virginia | 51540 | 5453 | 60 |
1930044 | 1930044 | 2021-11-18 | Charlottesville city | Virginia | 51540 | 5444 | 60 |
1926794 | 1926794 | 2021-11-17 | Charlottesville city | Virginia | 51540 | 5443 | 60 |
1923544 | 1923544 | 2021-11-16 | Charlottesville city | Virginia | 51540 | 5423 | 60 |
1920295 | 1920295 | 2021-11-15 | Charlottesville city | Virginia | 51540 | 5417 | 60 |
1917045 | 1917045 | 2021-11-14 | Charlottesville city | Virginia | 51540 | 5401 | 59 |
1913795 | 1913795 | 2021-11-13 | Charlottesville city | Virginia | 51540 | 5401 | 59 |
1910545 | 1910545 | 2021-11-12 | Charlottesville city | Virginia | 51540 | 5401 | 59 |
1907296 | 1907296 | 2021-11-11 | Charlottesville city | Virginia | 51540 | 5395 | 59 |
1904047 | 1904047 | 2021-11-10 | Charlottesville city | Virginia | 51540 | 5392 | 59 |
1900797 | 1900797 | 2021-11-09 | Charlottesville city | Virginia | 51540 | 5392 | 59 |
1897547 | 1897547 | 2021-11-08 | Charlottesville city | Virginia | 51540 | 5385 | 58 |
1894297 | 1894297 | 2021-11-07 | Charlottesville city | Virginia | 51540 | 5370 | 58 |
1891047 | 1891047 | 2021-11-06 | Charlottesville city | Virginia | 51540 | 5370 | 58 |
1887797 | 1887797 | 2021-11-05 | Charlottesville city | Virginia | 51540 | 5370 | 58 |
1884547 | 1884547 | 2021-11-04 | Charlottesville city | Virginia | 51540 | 5365 | 58 |
1881298 | 1881298 | 2021-11-03 | Charlottesville city | Virginia | 51540 | 5358 | 59 |
1878049 | 1878049 | 2021-11-02 | Charlottesville city | Virginia | 51540 | 5351 | 59 |
1874800 | 1874800 | 2021-11-01 | Charlottesville city | Virginia | 51540 | 5347 | 59 |
1871551 | 1871551 | 2021-10-31 | Charlottesville city | Virginia | 51540 | 5337 | 59 |
1868302 | 1868302 | 2021-10-30 | Charlottesville city | Virginia | 51540 | 5337 | 59 |
1865053 | 1865053 | 2021-10-29 | Charlottesville city | Virginia | 51540 | 5337 | 59 |
1861804 | 1861804 | 2021-10-28 | Charlottesville city | Virginia | 51540 | 5336 | 60 |
1858555 | 1858555 | 2021-10-27 | Charlottesville city | Virginia | 51540 | 5331 | 60 |
1855306 | 1855306 | 2021-10-26 | Charlottesville city | Virginia | 51540 | 5326 | 60 |
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);