ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
170 rows where deaths = 134 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 26
county 26
- Shenandoah 66
- Danville city 15
- Franklin 12
- Alexandria city 10
- Henrico 8
- Pittsylvania 8
- Loudoun 7
- Arlington 6
- Pulaski 5
- Spotsylvania 5
- Carroll 4
- Roanoke 4
- Wise 4
- Henry 2
- Petersburg city 2
- Roanoke city 2
- Augusta 1
- Campbell 1
- Chesapeake city 1
- Fairfax 1
- Hanover 1
- Prince William 1
- Smyth 1
- Suffolk city 1
- Virginia Beach city 1
- Warren 1
state 1
- Virginia · 170 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2349595 | 2349595 | 2022-03-27 | Pulaski | Virginia | 51155 | 7212 | 134 |
2346342 | 2346342 | 2022-03-26 | Pulaski | Virginia | 51155 | 7212 | 134 |
2343089 | 2343089 | 2022-03-25 | Pulaski | Virginia | 51155 | 7212 | 134 |
2339836 | 2339836 | 2022-03-24 | Pulaski | Virginia | 51155 | 7209 | 134 |
2336582 | 2336582 | 2022-03-23 | Pulaski | Virginia | 51155 | 7208 | 134 |
2268269 | 2268269 | 2022-03-02 | Petersburg city | Virginia | 51730 | 8278 | 134 |
2265016 | 2265016 | 2022-03-01 | Petersburg city | Virginia | 51730 | 8272 | 134 |
2258442 | 2258442 | 2022-02-27 | Carroll | Virginia | 51035 | 6516 | 134 |
2255191 | 2255191 | 2022-02-26 | Carroll | Virginia | 51035 | 6516 | 134 |
2251940 | 2251940 | 2022-02-25 | Carroll | Virginia | 51035 | 6516 | 134 |
2248689 | 2248689 | 2022-02-24 | Carroll | Virginia | 51035 | 6504 | 134 |
2219534 | 2219534 | 2022-02-15 | Warren | Virginia | 51187 | 8270 | 134 |
2144633 | 2144633 | 2022-01-23 | Franklin | Virginia | 51067 | 9124 | 134 |
2141378 | 2141378 | 2022-01-22 | Franklin | Virginia | 51067 | 9124 | 134 |
2138122 | 2138122 | 2022-01-21 | Franklin | Virginia | 51067 | 9124 | 134 |
2134868 | 2134868 | 2022-01-20 | Franklin | Virginia | 51067 | 9007 | 134 |
2131616 | 2131616 | 2022-01-19 | Franklin | Virginia | 51067 | 8854 | 134 |
2128362 | 2128362 | 2022-01-18 | Franklin | Virginia | 51067 | 8833 | 134 |
2125109 | 2125109 | 2022-01-17 | Franklin | Virginia | 51067 | 8809 | 134 |
2121857 | 2121857 | 2022-01-16 | Franklin | Virginia | 51067 | 8442 | 134 |
2118605 | 2118605 | 2022-01-15 | Franklin | Virginia | 51067 | 8442 | 134 |
2115353 | 2115353 | 2022-01-14 | Franklin | Virginia | 51067 | 8442 | 134 |
2112101 | 2112101 | 2022-01-13 | Franklin | Virginia | 51067 | 8308 | 134 |
2108849 | 2108849 | 2022-01-12 | Franklin | Virginia | 51067 | 8206 | 134 |
2034135 | 2034135 | 2021-12-20 | Pittsylvania | Virginia | 51143 | 8841 | 134 |
2034155 | 2034155 | 2021-12-20 | Smyth | Virginia | 51173 | 5466 | 134 |
2030885 | 2030885 | 2021-12-19 | Pittsylvania | Virginia | 51143 | 8781 | 134 |
2027634 | 2027634 | 2021-12-18 | Pittsylvania | Virginia | 51143 | 8781 | 134 |
2024383 | 2024383 | 2021-12-17 | Pittsylvania | Virginia | 51143 | 8781 | 134 |
2021132 | 2021132 | 2021-12-16 | Pittsylvania | Virginia | 51143 | 8760 | 134 |
2017881 | 2017881 | 2021-12-15 | Pittsylvania | Virginia | 51143 | 8713 | 134 |
2014631 | 2014631 | 2021-12-14 | Pittsylvania | Virginia | 51143 | 8686 | 134 |
2011380 | 2011380 | 2021-12-13 | Pittsylvania | Virginia | 51143 | 8670 | 134 |
2011416 | 2011416 | 2021-12-13 | Wise | Virginia | 51195 | 6150 | 134 |
2008165 | 2008165 | 2021-12-12 | Wise | Virginia | 51195 | 6116 | 134 |
2004914 | 2004914 | 2021-12-11 | Wise | Virginia | 51195 | 6116 | 134 |
2001663 | 2001663 | 2021-12-10 | Wise | Virginia | 51195 | 6116 | 134 |
1900782 | 1900782 | 2021-11-09 | Augusta | Virginia | 51015 | 10325 | 134 |
1835804 | 1835804 | 2021-10-20 | Campbell | Virginia | 51031 | 7036 | 134 |
1738431 | 1738431 | 2021-09-20 | Spotsylvania | Virginia | 51177 | 13215 | 134 |
1735182 | 1735182 | 2021-09-19 | Spotsylvania | Virginia | 51177 | 13012 | 134 |
1731932 | 1731932 | 2021-09-18 | Spotsylvania | Virginia | 51177 | 13012 | 134 |
1728682 | 1728682 | 2021-09-17 | Spotsylvania | Virginia | 51177 | 13012 | 134 |
1725432 | 1725432 | 2021-09-16 | Spotsylvania | Virginia | 51177 | 12912 | 134 |
1722126 | 1722126 | 2021-09-15 | Henry | Virginia | 51089 | 5622 | 134 |
1715630 | 1715630 | 2021-09-13 | Henry | Virginia | 51089 | 5575 | 134 |
1598745 | 1598745 | 2021-08-08 | Shenandoah | Virginia | 51171 | 4417 | 134 |
1595496 | 1595496 | 2021-08-07 | Shenandoah | Virginia | 51171 | 4417 | 134 |
1592247 | 1592247 | 2021-08-06 | Shenandoah | Virginia | 51171 | 4417 | 134 |
1588998 | 1588998 | 2021-08-05 | Shenandoah | Virginia | 51171 | 4404 | 134 |
1585749 | 1585749 | 2021-08-04 | Shenandoah | Virginia | 51171 | 4397 | 134 |
1582499 | 1582499 | 2021-08-03 | Shenandoah | Virginia | 51171 | 4386 | 134 |
1579249 | 1579249 | 2021-08-02 | Shenandoah | Virginia | 51171 | 4377 | 134 |
1576001 | 1576001 | 2021-08-01 | Shenandoah | Virginia | 51171 | 4370 | 134 |
1572753 | 1572753 | 2021-07-31 | Shenandoah | Virginia | 51171 | 4370 | 134 |
1569505 | 1569505 | 2021-07-30 | Shenandoah | Virginia | 51171 | 4370 | 134 |
1566257 | 1566257 | 2021-07-29 | Shenandoah | Virginia | 51171 | 4369 | 134 |
1563009 | 1563009 | 2021-07-28 | Shenandoah | Virginia | 51171 | 4366 | 134 |
1559761 | 1559761 | 2021-07-27 | Shenandoah | Virginia | 51171 | 4353 | 134 |
1556514 | 1556514 | 2021-07-26 | Shenandoah | Virginia | 51171 | 4353 | 134 |
1553267 | 1553267 | 2021-07-25 | Shenandoah | Virginia | 51171 | 4343 | 134 |
1550020 | 1550020 | 2021-07-24 | Shenandoah | Virginia | 51171 | 4343 | 134 |
1546773 | 1546773 | 2021-07-23 | Shenandoah | Virginia | 51171 | 4343 | 134 |
1543526 | 1543526 | 2021-07-22 | Shenandoah | Virginia | 51171 | 4340 | 134 |
1540278 | 1540278 | 2021-07-21 | Shenandoah | Virginia | 51171 | 4340 | 134 |
1537031 | 1537031 | 2021-07-20 | Shenandoah | Virginia | 51171 | 4339 | 134 |
1533783 | 1533783 | 2021-07-19 | Shenandoah | Virginia | 51171 | 4335 | 134 |
1530536 | 1530536 | 2021-07-18 | Shenandoah | Virginia | 51171 | 4326 | 134 |
1527289 | 1527289 | 2021-07-17 | Shenandoah | Virginia | 51171 | 4326 | 134 |
1524042 | 1524042 | 2021-07-16 | Shenandoah | Virginia | 51171 | 4326 | 134 |
1520794 | 1520794 | 2021-07-15 | Shenandoah | Virginia | 51171 | 4322 | 134 |
1517546 | 1517546 | 2021-07-14 | Shenandoah | Virginia | 51171 | 4320 | 134 |
1514299 | 1514299 | 2021-07-13 | Shenandoah | Virginia | 51171 | 4320 | 134 |
1511053 | 1511053 | 2021-07-12 | Shenandoah | Virginia | 51171 | 4317 | 134 |
1507806 | 1507806 | 2021-07-11 | Shenandoah | Virginia | 51171 | 4316 | 134 |
1504560 | 1504560 | 2021-07-10 | Shenandoah | Virginia | 51171 | 4316 | 134 |
1501314 | 1501314 | 2021-07-09 | Shenandoah | Virginia | 51171 | 4316 | 134 |
1498068 | 1498068 | 2021-07-08 | Shenandoah | Virginia | 51171 | 4314 | 134 |
1494821 | 1494821 | 2021-07-07 | Shenandoah | Virginia | 51171 | 4313 | 134 |
1491574 | 1491574 | 2021-07-06 | Shenandoah | Virginia | 51171 | 4311 | 134 |
1488327 | 1488327 | 2021-07-05 | Shenandoah | Virginia | 51171 | 4310 | 134 |
1485080 | 1485080 | 2021-07-04 | Shenandoah | Virginia | 51171 | 4309 | 134 |
1481834 | 1481834 | 2021-07-03 | Shenandoah | Virginia | 51171 | 4306 | 134 |
1478587 | 1478587 | 2021-07-02 | Shenandoah | Virginia | 51171 | 4304 | 134 |
1475341 | 1475341 | 2021-07-01 | Shenandoah | Virginia | 51171 | 4303 | 134 |
1472095 | 1472095 | 2021-06-30 | Shenandoah | Virginia | 51171 | 4303 | 134 |
1468850 | 1468850 | 2021-06-29 | Shenandoah | Virginia | 51171 | 4300 | 134 |
1465605 | 1465605 | 2021-06-28 | Shenandoah | Virginia | 51171 | 4299 | 134 |
1462360 | 1462360 | 2021-06-27 | Shenandoah | Virginia | 51171 | 4300 | 134 |
1459115 | 1459115 | 2021-06-26 | Shenandoah | Virginia | 51171 | 4300 | 134 |
1455870 | 1455870 | 2021-06-25 | Shenandoah | Virginia | 51171 | 4295 | 134 |
1452625 | 1452625 | 2021-06-24 | Shenandoah | Virginia | 51171 | 4294 | 134 |
1449379 | 1449379 | 2021-06-23 | Shenandoah | Virginia | 51171 | 4294 | 134 |
1446134 | 1446134 | 2021-06-22 | Shenandoah | Virginia | 51171 | 4293 | 134 |
1442889 | 1442889 | 2021-06-21 | Shenandoah | Virginia | 51171 | 4296 | 134 |
1439644 | 1439644 | 2021-06-20 | Shenandoah | Virginia | 51171 | 4296 | 134 |
1436397 | 1436397 | 2021-06-19 | Shenandoah | Virginia | 51171 | 4296 | 134 |
1433150 | 1433150 | 2021-06-18 | Shenandoah | Virginia | 51171 | 4296 | 134 |
1429904 | 1429904 | 2021-06-17 | Shenandoah | Virginia | 51171 | 4296 | 134 |
1426659 | 1426659 | 2021-06-16 | Shenandoah | Virginia | 51171 | 4311 | 134 |
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);