ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Harrisonburg city" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177182 | 2177182 | 2022-02-02 | Harrisonburg city | Virginia | 51660 | 12429 | 123 |
2173929 | 2173929 | 2022-02-01 | Harrisonburg city | Virginia | 51660 | 12347 | 122 |
2170677 | 2170677 | 2022-01-31 | Harrisonburg city | Virginia | 51660 | 12270 | 120 |
2167424 | 2167424 | 2022-01-30 | Harrisonburg city | Virginia | 51660 | 12080 | 120 |
2164169 | 2164169 | 2022-01-29 | Harrisonburg city | Virginia | 51660 | 12080 | 120 |
2160914 | 2160914 | 2022-01-28 | Harrisonburg city | Virginia | 51660 | 12080 | 120 |
2157658 | 2157658 | 2022-01-27 | Harrisonburg city | Virginia | 51660 | 11952 | 120 |
2154405 | 2154405 | 2022-01-26 | Harrisonburg city | Virginia | 51660 | 11824 | 120 |
2151152 | 2151152 | 2022-01-25 | Harrisonburg city | Virginia | 51660 | 11746 | 120 |
2147900 | 2147900 | 2022-01-24 | Harrisonburg city | Virginia | 51660 | 11661 | 119 |
2144647 | 2144647 | 2022-01-23 | Harrisonburg city | Virginia | 51660 | 11412 | 118 |
2141392 | 2141392 | 2022-01-22 | Harrisonburg city | Virginia | 51660 | 11412 | 118 |
2138136 | 2138136 | 2022-01-21 | Harrisonburg city | Virginia | 51660 | 11412 | 118 |
2134882 | 2134882 | 2022-01-20 | Harrisonburg city | Virginia | 51660 | 11211 | 118 |
2131630 | 2131630 | 2022-01-19 | Harrisonburg city | Virginia | 51660 | 11033 | 118 |
2128376 | 2128376 | 2022-01-18 | Harrisonburg city | Virginia | 51660 | 10944 | 118 |
2125123 | 2125123 | 2022-01-17 | Harrisonburg city | Virginia | 51660 | 10896 | 118 |
2121871 | 2121871 | 2022-01-16 | Harrisonburg city | Virginia | 51660 | 10596 | 118 |
2118619 | 2118619 | 2022-01-15 | Harrisonburg city | Virginia | 51660 | 10596 | 118 |
2115367 | 2115367 | 2022-01-14 | Harrisonburg city | Virginia | 51660 | 10596 | 118 |
2112115 | 2112115 | 2022-01-13 | Harrisonburg city | Virginia | 51660 | 10488 | 118 |
2108863 | 2108863 | 2022-01-12 | Harrisonburg city | Virginia | 51660 | 10354 | 118 |
2105612 | 2105612 | 2022-01-11 | Harrisonburg city | Virginia | 51660 | 10241 | 118 |
2102361 | 2102361 | 2022-01-10 | Harrisonburg city | Virginia | 51660 | 10145 | 118 |
2099110 | 2099110 | 2022-01-09 | Harrisonburg city | Virginia | 51660 | 9705 | 116 |
2095859 | 2095859 | 2022-01-08 | Harrisonburg city | Virginia | 51660 | 9705 | 116 |
2092607 | 2092607 | 2022-01-07 | Harrisonburg city | Virginia | 51660 | 9705 | 116 |
2089355 | 2089355 | 2022-01-06 | Harrisonburg city | Virginia | 51660 | 9589 | 116 |
2086104 | 2086104 | 2022-01-05 | Harrisonburg city | Virginia | 51660 | 9454 | 116 |
2082852 | 2082852 | 2022-01-04 | Harrisonburg city | Virginia | 51660 | 9397 | 116 |
2079600 | 2079600 | 2022-01-03 | Harrisonburg city | Virginia | 51660 | 9306 | 116 |
2076348 | 2076348 | 2022-01-02 | Harrisonburg city | Virginia | 51660 | 9119 | 116 |
2073097 | 2073097 | 2022-01-01 | Harrisonburg city | Virginia | 51660 | 9119 | 116 |
2069846 | 2069846 | 2021-12-31 | Harrisonburg city | Virginia | 51660 | 9119 | 116 |
2066595 | 2066595 | 2021-12-30 | Harrisonburg city | Virginia | 51660 | 9061 | 116 |
2063345 | 2063345 | 2021-12-29 | Harrisonburg city | Virginia | 51660 | 9009 | 116 |
2060095 | 2060095 | 2021-12-28 | Harrisonburg city | Virginia | 51660 | 8961 | 116 |
2056846 | 2056846 | 2021-12-27 | Harrisonburg city | Virginia | 51660 | 8951 | 116 |
2053597 | 2053597 | 2021-12-26 | Harrisonburg city | Virginia | 51660 | 8910 | 116 |
2050347 | 2050347 | 2021-12-25 | Harrisonburg city | Virginia | 51660 | 8910 | 116 |
2047097 | 2047097 | 2021-12-24 | Harrisonburg city | Virginia | 51660 | 8910 | 116 |
2043847 | 2043847 | 2021-12-23 | Harrisonburg city | Virginia | 51660 | 8880 | 116 |
2040598 | 2040598 | 2021-12-22 | Harrisonburg city | Virginia | 51660 | 8867 | 116 |
2037348 | 2037348 | 2021-12-21 | Harrisonburg city | Virginia | 51660 | 8840 | 116 |
2034098 | 2034098 | 2021-12-20 | Harrisonburg city | Virginia | 51660 | 8821 | 116 |
2030848 | 2030848 | 2021-12-19 | Harrisonburg city | Virginia | 51660 | 8760 | 114 |
2027597 | 2027597 | 2021-12-18 | Harrisonburg city | Virginia | 51660 | 8760 | 114 |
2024346 | 2024346 | 2021-12-17 | Harrisonburg city | Virginia | 51660 | 8760 | 114 |
2021095 | 2021095 | 2021-12-16 | Harrisonburg city | Virginia | 51660 | 8740 | 114 |
2017844 | 2017844 | 2021-12-15 | Harrisonburg city | Virginia | 51660 | 8714 | 114 |
2014594 | 2014594 | 2021-12-14 | Harrisonburg city | Virginia | 51660 | 8698 | 114 |
2011343 | 2011343 | 2021-12-13 | Harrisonburg city | Virginia | 51660 | 8682 | 114 |
2008092 | 2008092 | 2021-12-12 | Harrisonburg city | Virginia | 51660 | 8633 | 114 |
2004841 | 2004841 | 2021-12-11 | Harrisonburg city | Virginia | 51660 | 8633 | 114 |
2001590 | 2001590 | 2021-12-10 | Harrisonburg city | Virginia | 51660 | 8633 | 114 |
1998340 | 1998340 | 2021-12-09 | Harrisonburg city | Virginia | 51660 | 8617 | 114 |
1995089 | 1995089 | 2021-12-08 | Harrisonburg city | Virginia | 51660 | 8597 | 114 |
1991838 | 1991838 | 2021-12-07 | Harrisonburg city | Virginia | 51660 | 8584 | 114 |
1988587 | 1988587 | 2021-12-06 | Harrisonburg city | Virginia | 51660 | 8576 | 114 |
1985337 | 1985337 | 2021-12-05 | Harrisonburg city | Virginia | 51660 | 8537 | 114 |
1982087 | 1982087 | 2021-12-04 | Harrisonburg city | Virginia | 51660 | 8537 | 114 |
1978837 | 1978837 | 2021-12-03 | Harrisonburg city | Virginia | 51660 | 8537 | 114 |
1975587 | 1975587 | 2021-12-02 | Harrisonburg city | Virginia | 51660 | 8524 | 114 |
1972338 | 1972338 | 2021-12-01 | Harrisonburg city | Virginia | 51660 | 8503 | 114 |
1969088 | 1969088 | 2021-11-30 | Harrisonburg city | Virginia | 51660 | 8489 | 114 |
1965838 | 1965838 | 2021-11-29 | Harrisonburg city | Virginia | 51660 | 8469 | 114 |
1962586 | 1962586 | 2021-11-28 | Harrisonburg city | Virginia | 51660 | 8450 | 114 |
1959335 | 1959335 | 2021-11-27 | Harrisonburg city | Virginia | 51660 | 8450 | 114 |
1956084 | 1956084 | 2021-11-26 | Harrisonburg city | Virginia | 51660 | 8450 | 114 |
1952833 | 1952833 | 2021-11-25 | Harrisonburg city | Virginia | 51660 | 8442 | 114 |
1949582 | 1949582 | 2021-11-24 | Harrisonburg city | Virginia | 51660 | 8437 | 114 |
1946331 | 1946331 | 2021-11-23 | Harrisonburg city | Virginia | 51660 | 8433 | 114 |
1943080 | 1943080 | 2021-11-22 | Harrisonburg city | Virginia | 51660 | 8426 | 114 |
1939830 | 1939830 | 2021-11-21 | Harrisonburg city | Virginia | 51660 | 8408 | 112 |
1936580 | 1936580 | 2021-11-20 | Harrisonburg city | Virginia | 51660 | 8408 | 112 |
1933330 | 1933330 | 2021-11-19 | Harrisonburg city | Virginia | 51660 | 8408 | 112 |
1930078 | 1930078 | 2021-11-18 | Harrisonburg city | Virginia | 51660 | 8401 | 112 |
1926828 | 1926828 | 2021-11-17 | Harrisonburg city | Virginia | 51660 | 8390 | 111 |
1923578 | 1923578 | 2021-11-16 | Harrisonburg city | Virginia | 51660 | 8366 | 111 |
1920329 | 1920329 | 2021-11-15 | Harrisonburg city | Virginia | 51660 | 8352 | 111 |
1917079 | 1917079 | 2021-11-14 | Harrisonburg city | Virginia | 51660 | 8345 | 111 |
1913829 | 1913829 | 2021-11-13 | Harrisonburg city | Virginia | 51660 | 8345 | 111 |
1910579 | 1910579 | 2021-11-12 | Harrisonburg city | Virginia | 51660 | 8345 | 111 |
1907330 | 1907330 | 2021-11-11 | Harrisonburg city | Virginia | 51660 | 8332 | 110 |
1904081 | 1904081 | 2021-11-10 | Harrisonburg city | Virginia | 51660 | 8318 | 108 |
1900831 | 1900831 | 2021-11-09 | Harrisonburg city | Virginia | 51660 | 8314 | 108 |
1897581 | 1897581 | 2021-11-08 | Harrisonburg city | Virginia | 51660 | 8313 | 108 |
1894331 | 1894331 | 2021-11-07 | Harrisonburg city | Virginia | 51660 | 8296 | 107 |
1891081 | 1891081 | 2021-11-06 | Harrisonburg city | Virginia | 51660 | 8296 | 107 |
1887831 | 1887831 | 2021-11-05 | Harrisonburg city | Virginia | 51660 | 8296 | 107 |
1884581 | 1884581 | 2021-11-04 | Harrisonburg city | Virginia | 51660 | 8292 | 107 |
1881332 | 1881332 | 2021-11-03 | Harrisonburg city | Virginia | 51660 | 8284 | 107 |
1878083 | 1878083 | 2021-11-02 | Harrisonburg city | Virginia | 51660 | 8271 | 107 |
1874834 | 1874834 | 2021-11-01 | Harrisonburg city | Virginia | 51660 | 8273 | 107 |
1871585 | 1871585 | 2021-10-31 | Harrisonburg city | Virginia | 51660 | 8253 | 104 |
1868336 | 1868336 | 2021-10-30 | Harrisonburg city | Virginia | 51660 | 8253 | 104 |
1865087 | 1865087 | 2021-10-29 | Harrisonburg city | Virginia | 51660 | 8253 | 104 |
1861838 | 1861838 | 2021-10-28 | Harrisonburg city | Virginia | 51660 | 8251 | 104 |
1858589 | 1858589 | 2021-10-27 | Harrisonburg city | Virginia | 51660 | 8244 | 104 |
1855340 | 1855340 | 2021-10-26 | Harrisonburg city | Virginia | 51660 | 8230 | 104 |
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);