ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
115 rows where deaths = 144 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 28
county 28
- Danville city 14
- Lynchburg city 11
- Albemarle 9
- Roanoke 7
- Augusta 6
- Smyth 6
- Carroll 5
- Hanover 5
- Pittsylvania 5
- Alexandria city 4
- Culpeper 4
- Henry 4
- Spotsylvania 4
- Bedford 3
- Campbell 3
- Fauquier 3
- Montgomery 3
- Shenandoah 3
- Arlington 2
- Loudoun 2
- Prince William 2
- Richmond city 2
- Rockingham 2
- Tazewell 2
- Hampton city 1
- Roanoke city 1
- Washington 1
- Wythe 1
state 1
- Virginia · 115 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502550 | 2502550 | 2022-05-13 | Fauquier | Virginia | 51061 | 13267 | 144 |
2499292 | 2499292 | 2022-05-12 | Fauquier | Virginia | 51061 | 13247 | 144 |
2496034 | 2496034 | 2022-05-11 | Fauquier | Virginia | 51061 | 13228 | 144 |
2382158 | 2382158 | 2022-04-06 | Wythe | Virginia | 51197 | 7482 | 144 |
2352766 | 2352766 | 2022-03-28 | Carroll | Virginia | 51035 | 6630 | 144 |
2349514 | 2349514 | 2022-03-27 | Carroll | Virginia | 51035 | 6628 | 144 |
2346261 | 2346261 | 2022-03-26 | Carroll | Virginia | 51035 | 6628 | 144 |
2343008 | 2343008 | 2022-03-25 | Carroll | Virginia | 51035 | 6628 | 144 |
2339755 | 2339755 | 2022-03-24 | Carroll | Virginia | 51035 | 6619 | 144 |
2326752 | 2326752 | 2022-03-20 | Culpeper | Virginia | 51047 | 11474 | 144 |
2323499 | 2323499 | 2022-03-19 | Culpeper | Virginia | 51047 | 11474 | 144 |
2320245 | 2320245 | 2022-03-18 | Culpeper | Virginia | 51047 | 11474 | 144 |
2294225 | 2294225 | 2022-03-10 | Culpeper | Virginia | 51047 | 11467 | 144 |
2291024 | 2291024 | 2022-03-09 | Montgomery | Virginia | 51121 | 18369 | 144 |
2287692 | 2287692 | 2022-03-08 | Albemarle | Virginia | 51003 | 15722 | 144 |
2287772 | 2287772 | 2022-03-08 | Montgomery | Virginia | 51121 | 18349 | 144 |
2284440 | 2284440 | 2022-03-07 | Albemarle | Virginia | 51003 | 15693 | 144 |
2284520 | 2284520 | 2022-03-07 | Montgomery | Virginia | 51121 | 18331 | 144 |
2281188 | 2281188 | 2022-03-06 | Albemarle | Virginia | 51003 | 15658 | 144 |
2277935 | 2277935 | 2022-03-05 | Albemarle | Virginia | 51003 | 15658 | 144 |
2274682 | 2274682 | 2022-03-04 | Albemarle | Virginia | 51003 | 15658 | 144 |
2271429 | 2271429 | 2022-03-03 | Albemarle | Virginia | 51003 | 15632 | 144 |
2268177 | 2268177 | 2022-03-02 | Albemarle | Virginia | 51003 | 15604 | 144 |
2264924 | 2264924 | 2022-03-01 | Albemarle | Virginia | 51003 | 15576 | 144 |
2261674 | 2261674 | 2022-02-28 | Albemarle | Virginia | 51003 | 15547 | 144 |
2226034 | 2226034 | 2022-02-17 | Tazewell | Virginia | 51185 | 9650 | 144 |
2222783 | 2222783 | 2022-02-16 | Tazewell | Virginia | 51185 | 9595 | 144 |
2193501 | 2193501 | 2022-02-07 | Smyth | Virginia | 51173 | 7769 | 144 |
2190248 | 2190248 | 2022-02-06 | Smyth | Virginia | 51173 | 7631 | 144 |
2186995 | 2186995 | 2022-02-05 | Smyth | Virginia | 51173 | 7631 | 144 |
2183742 | 2183742 | 2022-02-04 | Smyth | Virginia | 51173 | 7631 | 144 |
2180490 | 2180490 | 2022-02-03 | Smyth | Virginia | 51173 | 7550 | 144 |
2177239 | 2177239 | 2022-02-02 | Smyth | Virginia | 51173 | 7455 | 144 |
2102398 | 2102398 | 2022-01-10 | Pittsylvania | Virginia | 51143 | 9875 | 144 |
2099061 | 2099061 | 2022-01-09 | Augusta | Virginia | 51015 | 13021 | 144 |
2099147 | 2099147 | 2022-01-09 | Pittsylvania | Virginia | 51143 | 9633 | 144 |
2095810 | 2095810 | 2022-01-08 | Augusta | Virginia | 51015 | 13021 | 144 |
2095896 | 2095896 | 2022-01-08 | Pittsylvania | Virginia | 51143 | 9633 | 144 |
2092558 | 2092558 | 2022-01-07 | Augusta | Virginia | 51015 | 13021 | 144 |
2092644 | 2092644 | 2022-01-07 | Pittsylvania | Virginia | 51143 | 9633 | 144 |
2089306 | 2089306 | 2022-01-06 | Augusta | Virginia | 51015 | 12881 | 144 |
2089392 | 2089392 | 2022-01-06 | Pittsylvania | Virginia | 51143 | 9527 | 144 |
2086055 | 2086055 | 2022-01-05 | Augusta | Virginia | 51015 | 12730 | 144 |
2082803 | 2082803 | 2022-01-04 | Augusta | Virginia | 51015 | 12681 | 144 |
1930039 | 1930039 | 2021-11-18 | Campbell | Virginia | 51031 | 7435 | 144 |
1926789 | 1926789 | 2021-11-17 | Campbell | Virginia | 51031 | 7426 | 144 |
1923539 | 1923539 | 2021-11-16 | Campbell | Virginia | 51031 | 7408 | 144 |
1852159 | 1852159 | 2021-10-25 | Washington | Virginia | 51191 | 7525 | 144 |
1826049 | 1826049 | 2021-10-17 | Bedford | Virginia | 51019 | 9670 | 144 |
1826155 | 1826155 | 2021-10-17 | Spotsylvania | Virginia | 51177 | 14577 | 144 |
1822800 | 1822800 | 2021-10-16 | Bedford | Virginia | 51019 | 9670 | 144 |
1822906 | 1822906 | 2021-10-16 | Spotsylvania | Virginia | 51177 | 14577 | 144 |
1819551 | 1819551 | 2021-10-15 | Bedford | Virginia | 51019 | 9670 | 144 |
1819657 | 1819657 | 2021-10-15 | Spotsylvania | Virginia | 51177 | 14577 | 144 |
1816401 | 1816401 | 2021-10-14 | Rockingham | Virginia | 51165 | 9079 | 144 |
1816408 | 1816408 | 2021-10-14 | Spotsylvania | Virginia | 51177 | 14522 | 144 |
1813153 | 1813153 | 2021-10-13 | Rockingham | Virginia | 51165 | 9025 | 144 |
1806604 | 1806604 | 2021-10-11 | Henry | Virginia | 51089 | 6129 | 144 |
1803354 | 1803354 | 2021-10-10 | Henry | Virginia | 51089 | 6129 | 144 |
1800105 | 1800105 | 2021-10-09 | Henry | Virginia | 51089 | 6129 | 144 |
1796856 | 1796856 | 2021-10-08 | Henry | Virginia | 51089 | 6129 | 144 |
1770805 | 1770805 | 2021-09-30 | Alexandria city | Virginia | 51510 | 13650 | 144 |
1767556 | 1767556 | 2021-09-29 | Alexandria city | Virginia | 51510 | 13625 | 144 |
1764307 | 1764307 | 2021-09-28 | Alexandria city | Virginia | 51510 | 13605 | 144 |
1761058 | 1761058 | 2021-09-27 | Alexandria city | Virginia | 51510 | 13585 | 144 |
1757921 | 1757921 | 2021-09-26 | Shenandoah | Virginia | 51171 | 5552 | 144 |
1754673 | 1754673 | 2021-09-25 | Shenandoah | Virginia | 51171 | 5552 | 144 |
1751425 | 1751425 | 2021-09-24 | Shenandoah | Virginia | 51171 | 5552 | 144 |
1598664 | 1598664 | 2021-08-08 | Danville city | Virginia | 51590 | 4625 | 144 |
1595415 | 1595415 | 2021-08-07 | Danville city | Virginia | 51590 | 4625 | 144 |
1592166 | 1592166 | 2021-08-06 | Danville city | Virginia | 51590 | 4625 | 144 |
1588917 | 1588917 | 2021-08-05 | Danville city | Virginia | 51590 | 4608 | 144 |
1585668 | 1585668 | 2021-08-04 | Danville city | Virginia | 51590 | 4601 | 144 |
1582418 | 1582418 | 2021-08-03 | Danville city | Virginia | 51590 | 4585 | 144 |
1579168 | 1579168 | 2021-08-02 | Danville city | Virginia | 51590 | 4566 | 144 |
1575920 | 1575920 | 2021-08-01 | Danville city | Virginia | 51590 | 4556 | 144 |
1572672 | 1572672 | 2021-07-31 | Danville city | Virginia | 51590 | 4556 | 144 |
1569424 | 1569424 | 2021-07-30 | Danville city | Virginia | 51590 | 4556 | 144 |
1566176 | 1566176 | 2021-07-29 | Danville city | Virginia | 51590 | 4547 | 144 |
1562928 | 1562928 | 2021-07-28 | Danville city | Virginia | 51590 | 4543 | 144 |
1559680 | 1559680 | 2021-07-27 | Danville city | Virginia | 51590 | 4542 | 144 |
1556433 | 1556433 | 2021-07-26 | Danville city | Virginia | 51590 | 4532 | 144 |
1329271 | 1329271 | 2021-05-17 | Roanoke | Virginia | 51161 | 8258 | 144 |
1326025 | 1326025 | 2021-05-16 | Roanoke | Virginia | 51161 | 8254 | 144 |
1322779 | 1322779 | 2021-05-15 | Roanoke | Virginia | 51161 | 8252 | 144 |
1319533 | 1319533 | 2021-05-14 | Roanoke | Virginia | 51161 | 8241 | 144 |
1316285 | 1316285 | 2021-05-13 | Roanoke | Virginia | 51161 | 8239 | 144 |
1313039 | 1313039 | 2021-05-12 | Roanoke | Virginia | 51161 | 8239 | 144 |
1309792 | 1309792 | 2021-05-11 | Roanoke | Virginia | 51161 | 8232 | 144 |
1238331 | 1238331 | 2021-04-19 | Lynchburg city | Virginia | 51680 | 7466 | 144 |
1235084 | 1235084 | 2021-04-18 | Lynchburg city | Virginia | 51680 | 7458 | 144 |
1231836 | 1231836 | 2021-04-17 | Lynchburg city | Virginia | 51680 | 7447 | 144 |
1228588 | 1228588 | 2021-04-16 | Lynchburg city | Virginia | 51680 | 7438 | 144 |
1225340 | 1225340 | 2021-04-15 | Lynchburg city | Virginia | 51680 | 7420 | 144 |
1218845 | 1218845 | 2021-04-13 | Lynchburg city | Virginia | 51680 | 7415 | 144 |
1215597 | 1215597 | 2021-04-12 | Lynchburg city | Virginia | 51680 | 7363 | 144 |
1147395 | 1147395 | 2021-03-22 | Lynchburg city | Virginia | 51680 | 7040 | 144 |
1144148 | 1144148 | 2021-03-21 | Lynchburg city | Virginia | 51680 | 7032 | 144 |
1140901 | 1140901 | 2021-03-20 | Lynchburg city | Virginia | 51680 | 7028 | 144 |
1137638 | 1137638 | 2021-03-19 | Hanover | Virginia | 51085 | 7007 | 144 |
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);