ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where deaths = 155 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 21
county 21
- Alexandria city 15
- Danville city 8
- Hanover 8
- Warren 7
- Arlington 6
- Halifax 6
- Lynchburg city 6
- Loudoun 5
- Augusta 3
- Franklin 3
- Henry 3
- Stafford 3
- Washington 3
- Campbell 2
- Frederick 2
- Harrisonburg city 2
- Roanoke 2
- Tazewell 2
- Prince William 1
- Smyth 1
- Wise 1
state 1
- Virginia · 89 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444010 | 2444010 | 2022-04-25 | Warren | Virginia | 51187 | 8586 | 155 |
2440754 | 2440754 | 2022-04-24 | Warren | Virginia | 51187 | 8578 | 155 |
2437498 | 2437498 | 2022-04-23 | Warren | Virginia | 51187 | 8578 | 155 |
2434242 | 2434242 | 2022-04-22 | Warren | Virginia | 51187 | 8578 | 155 |
2430986 | 2430986 | 2022-04-21 | Warren | Virginia | 51187 | 8574 | 155 |
2427730 | 2427730 | 2022-04-20 | Warren | Virginia | 51187 | 8573 | 155 |
2424474 | 2424474 | 2022-04-19 | Warren | Virginia | 51187 | 8572 | 155 |
2401613 | 2401613 | 2022-04-12 | Halifax | Virginia | 51083 | 7041 | 155 |
2398358 | 2398358 | 2022-04-11 | Halifax | Virginia | 51083 | 7033 | 155 |
2395103 | 2395103 | 2022-04-10 | Halifax | Virginia | 51083 | 7027 | 155 |
2391847 | 2391847 | 2022-04-09 | Halifax | Virginia | 51083 | 7027 | 155 |
2388591 | 2388591 | 2022-04-08 | Halifax | Virginia | 51083 | 7027 | 155 |
2385336 | 2385336 | 2022-04-07 | Halifax | Virginia | 51083 | 7027 | 155 |
2333284 | 2333284 | 2022-03-22 | Harrisonburg city | Virginia | 51660 | 13214 | 155 |
2330031 | 2330031 | 2022-03-21 | Harrisonburg city | Virginia | 51660 | 13214 | 155 |
2265045 | 2265045 | 2022-03-01 | Tazewell | Virginia | 51185 | 9896 | 155 |
2261795 | 2261795 | 2022-02-28 | Tazewell | Virginia | 51185 | 9888 | 155 |
2258539 | 2258539 | 2022-02-27 | Stafford | Virginia | 51179 | 29621 | 155 |
2255288 | 2255288 | 2022-02-26 | Stafford | Virginia | 51179 | 29621 | 155 |
2252037 | 2252037 | 2022-02-25 | Stafford | Virginia | 51179 | 29621 | 155 |
2222775 | 2222775 | 2022-02-16 | Smyth | Virginia | 51173 | 8277 | 155 |
2199939 | 2199939 | 2022-02-09 | Franklin | Virginia | 51067 | 10204 | 155 |
2196685 | 2196685 | 2022-02-08 | Franklin | Virginia | 51067 | 10158 | 155 |
2193430 | 2193430 | 2022-02-07 | Franklin | Virginia | 51067 | 10139 | 155 |
2154356 | 2154356 | 2022-01-26 | Augusta | Virginia | 51015 | 16516 | 155 |
2151103 | 2151103 | 2022-01-25 | Augusta | Virginia | 51015 | 16336 | 155 |
2151225 | 2151225 | 2022-01-25 | Wise | Virginia | 51195 | 7967 | 155 |
2147851 | 2147851 | 2022-01-24 | Augusta | Virginia | 51015 | 16242 | 155 |
2043808 | 2043808 | 2021-12-23 | Campbell | Virginia | 51031 | 8089 | 155 |
2040559 | 2040559 | 2021-12-22 | Campbell | Virginia | 51031 | 8055 | 155 |
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 |
1926896 | 1926896 | 2021-11-17 | Washington | Virginia | 51191 | 7861 | 155 |
1923566 | 1923566 | 2021-11-16 | Frederick | Virginia | 51069 | 11946 | 155 |
1923646 | 1923646 | 2021-11-16 | Washington | Virginia | 51191 | 7842 | 155 |
1920317 | 1920317 | 2021-11-15 | Frederick | Virginia | 51069 | 11914 | 155 |
1920397 | 1920397 | 2021-11-15 | Washington | Virginia | 51191 | 7828 | 155 |
1871587 | 1871587 | 2021-10-31 | Henry | Virginia | 51089 | 6491 | 155 |
1868338 | 1868338 | 2021-10-30 | Henry | Virginia | 51089 | 6491 | 155 |
1865089 | 1865089 | 2021-10-29 | Henry | Virginia | 51089 | 6491 | 155 |
1770909 | 1770909 | 2021-09-30 | Roanoke | Virginia | 51161 | 10934 | 155 |
1767660 | 1767660 | 2021-09-29 | Roanoke | Virginia | 51161 | 10866 | 155 |
1696116 | 1696116 | 2021-09-07 | Danville city | Virginia | 51590 | 5232 | 155 |
1692868 | 1692868 | 2021-09-06 | Danville city | Virginia | 51590 | 5224 | 155 |
1689619 | 1689619 | 2021-09-05 | Danville city | Virginia | 51590 | 5170 | 155 |
1689660 | 1689660 | 2021-09-05 | Lynchburg city | Virginia | 51680 | 8714 | 155 |
1686369 | 1686369 | 2021-09-04 | Danville city | Virginia | 51590 | 5170 | 155 |
1686410 | 1686410 | 2021-09-04 | Lynchburg city | Virginia | 51680 | 8714 | 155 |
1683118 | 1683118 | 2021-09-03 | Danville city | Virginia | 51590 | 5170 | 155 |
1683159 | 1683159 | 2021-09-03 | Lynchburg city | Virginia | 51680 | 8714 | 155 |
1679868 | 1679868 | 2021-09-02 | Danville city | Virginia | 51590 | 5139 | 155 |
1679909 | 1679909 | 2021-09-02 | Lynchburg city | Virginia | 51680 | 8592 | 155 |
1676620 | 1676620 | 2021-09-01 | Danville city | Virginia | 51590 | 5117 | 155 |
1676661 | 1676661 | 2021-09-01 | Lynchburg city | Virginia | 51680 | 8456 | 155 |
1673373 | 1673373 | 2021-08-31 | Danville city | Virginia | 51590 | 5078 | 155 |
1673414 | 1673414 | 2021-08-31 | Lynchburg city | Virginia | 51680 | 8395 | 155 |
1312989 | 1312989 | 2021-05-12 | Hanover | Virginia | 51085 | 8033 | 155 |
1309742 | 1309742 | 2021-05-11 | Hanover | Virginia | 51085 | 8030 | 155 |
1306496 | 1306496 | 2021-05-10 | Hanover | Virginia | 51085 | 8026 | 155 |
1303250 | 1303250 | 2021-05-09 | Hanover | Virginia | 51085 | 8023 | 155 |
1300003 | 1300003 | 2021-05-08 | Hanover | Virginia | 51085 | 8018 | 155 |
1296756 | 1296756 | 2021-05-07 | Hanover | Virginia | 51085 | 8017 | 155 |
1293510 | 1293510 | 2021-05-06 | Hanover | Virginia | 51085 | 8008 | 155 |
1290264 | 1290264 | 2021-05-05 | Hanover | Virginia | 51085 | 8003 | 155 |
852036 | 852036 | 2020-12-21 | Loudoun | Virginia | 51107 | 12861 | 155 |
848791 | 848791 | 2020-12-20 | Loudoun | Virginia | 51107 | 12682 | 155 |
845546 | 845546 | 2020-12-19 | Loudoun | Virginia | 51107 | 12503 | 155 |
842300 | 842300 | 2020-12-18 | Loudoun | Virginia | 51107 | 12386 | 155 |
839055 | 839055 | 2020-12-17 | Loudoun | Virginia | 51107 | 12297 | 155 |
728643 | 728643 | 2020-11-13 | Arlington | Virginia | 51013 | 5191 | 155 |
725400 | 725400 | 2020-11-12 | Arlington | Virginia | 51013 | 5158 | 155 |
722157 | 722157 | 2020-11-11 | Arlington | Virginia | 51013 | 5130 | 155 |
718914 | 718914 | 2020-11-10 | Arlington | Virginia | 51013 | 5093 | 155 |
715671 | 715671 | 2020-11-09 | Arlington | Virginia | 51013 | 5060 | 155 |
712427 | 712427 | 2020-11-08 | Arlington | Virginia | 51013 | 5036 | 155 |
318493 | 318493 | 2020-07-09 | Prince William | Virginia | 51153 | 7687 | 155 |
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);