ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where deaths = 129 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 27
county 27
- Wise 26
- Shenandoah 13
- Alexandria city 5
- Loudoun 5
- Petersburg city 5
- Franklin 4
- Wythe 4
- Albemarle 3
- Montgomery 3
- Pittsylvania 3
- Pulaski 3
- Culpeper 2
- Halifax 2
- Hampton city 2
- Smyth 2
- Spotsylvania 2
- Suffolk city 2
- Augusta 1
- Campbell 1
- Carroll 1
- Chesterfield 1
- Fauquier 1
- Harrisonburg city 1
- Roanoke city 1
- Rockingham 1
- Tazewell 1
- Virginia Beach city 1
state 1
- Virginia · 96 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2313809 | 2313809 | 2022-03-16 | Pulaski | Virginia | 51155 | 7194 | 129 |
2310556 | 2310556 | 2022-03-15 | Pulaski | Virginia | 51155 | 7193 | 129 |
2307303 | 2307303 | 2022-03-14 | Pulaski | Virginia | 51155 | 7187 | 129 |
2242197 | 2242197 | 2022-02-22 | Culpeper | Virginia | 51047 | 11491 | 129 |
2238946 | 2238946 | 2022-02-21 | Culpeper | Virginia | 51047 | 11428 | 129 |
2239009 | 2239009 | 2022-02-21 | Petersburg city | Virginia | 51730 | 8234 | 129 |
2235758 | 2235758 | 2022-02-20 | Petersburg city | Virginia | 51730 | 8179 | 129 |
2232507 | 2232507 | 2022-02-19 | Petersburg city | Virginia | 51730 | 8179 | 129 |
2229256 | 2229256 | 2022-02-18 | Petersburg city | Virginia | 51730 | 8179 | 129 |
2225952 | 2225952 | 2022-02-17 | Fauquier | Virginia | 51061 | 12659 | 129 |
2226005 | 2226005 | 2022-02-17 | Petersburg city | Virginia | 51730 | 8169 | 129 |
2226043 | 2226043 | 2022-02-17 | Wythe | Virginia | 51197 | 7208 | 129 |
2222792 | 2222792 | 2022-02-16 | Wythe | Virginia | 51197 | 7183 | 129 |
2219541 | 2219541 | 2022-02-15 | Wythe | Virginia | 51197 | 7166 | 129 |
2216291 | 2216291 | 2022-02-14 | Wythe | Virginia | 51197 | 7138 | 129 |
2203170 | 2203170 | 2022-02-10 | Carroll | Virginia | 51035 | 6260 | 129 |
2203207 | 2203207 | 2022-02-10 | Harrisonburg city | Virginia | 51660 | 12863 | 129 |
2199897 | 2199897 | 2022-02-09 | Albemarle | Virginia | 51003 | 14381 | 129 |
2196643 | 2196643 | 2022-02-08 | Albemarle | Virginia | 51003 | 14311 | 129 |
2193388 | 2193388 | 2022-02-07 | Albemarle | Virginia | 51003 | 14236 | 129 |
2190215 | 2190215 | 2022-02-06 | Montgomery | Virginia | 51121 | 17103 | 129 |
2186962 | 2186962 | 2022-02-05 | Montgomery | Virginia | 51121 | 17103 | 129 |
2183709 | 2183709 | 2022-02-04 | Montgomery | Virginia | 51121 | 17103 | 129 |
2177247 | 2177247 | 2022-02-02 | Tazewell | Virginia | 51185 | 8807 | 129 |
2173926 | 2173926 | 2022-02-01 | Halifax | Virginia | 51083 | 6377 | 129 |
2170674 | 2170674 | 2022-01-31 | Halifax | Virginia | 51083 | 6356 | 129 |
2076334 | 2076334 | 2022-01-02 | Franklin | Virginia | 51067 | 7387 | 129 |
2073083 | 2073083 | 2022-01-01 | Franklin | Virginia | 51067 | 7387 | 129 |
2069832 | 2069832 | 2021-12-31 | Franklin | Virginia | 51067 | 7387 | 129 |
2066581 | 2066581 | 2021-12-30 | Franklin | Virginia | 51067 | 7298 | 129 |
2017901 | 2017901 | 2021-12-15 | Smyth | Virginia | 51173 | 5409 | 129 |
2014651 | 2014651 | 2021-12-14 | Smyth | Virginia | 51173 | 5391 | 129 |
1952870 | 1952870 | 2021-11-25 | Pittsylvania | Virginia | 51143 | 8442 | 129 |
1949619 | 1949619 | 2021-11-24 | Pittsylvania | Virginia | 51143 | 8430 | 129 |
1946368 | 1946368 | 2021-11-23 | Pittsylvania | Virginia | 51143 | 8416 | 129 |
1939903 | 1939903 | 2021-11-21 | Wise | Virginia | 51195 | 5715 | 129 |
1936653 | 1936653 | 2021-11-20 | Wise | Virginia | 51195 | 5715 | 129 |
1933403 | 1933403 | 2021-11-19 | Wise | Virginia | 51195 | 5715 | 129 |
1930151 | 1930151 | 2021-11-18 | Wise | Virginia | 51195 | 5694 | 129 |
1926901 | 1926901 | 2021-11-17 | Wise | Virginia | 51195 | 5664 | 129 |
1923651 | 1923651 | 2021-11-16 | Wise | Virginia | 51195 | 5650 | 129 |
1920402 | 1920402 | 2021-11-15 | Wise | Virginia | 51195 | 5619 | 129 |
1917152 | 1917152 | 2021-11-14 | Wise | Virginia | 51195 | 5580 | 129 |
1913902 | 1913902 | 2021-11-13 | Wise | Virginia | 51195 | 5580 | 129 |
1910652 | 1910652 | 2021-11-12 | Wise | Virginia | 51195 | 5580 | 129 |
1907403 | 1907403 | 2021-11-11 | Wise | Virginia | 51195 | 5575 | 129 |
1904154 | 1904154 | 2021-11-10 | Wise | Virginia | 51195 | 5556 | 129 |
1900904 | 1900904 | 2021-11-09 | Wise | Virginia | 51195 | 5543 | 129 |
1897654 | 1897654 | 2021-11-08 | Wise | Virginia | 51195 | 5512 | 129 |
1894404 | 1894404 | 2021-11-07 | Wise | Virginia | 51195 | 5475 | 129 |
1891154 | 1891154 | 2021-11-06 | Wise | Virginia | 51195 | 5475 | 129 |
1887904 | 1887904 | 2021-11-05 | Wise | Virginia | 51195 | 5475 | 129 |
1881405 | 1881405 | 2021-11-03 | Wise | Virginia | 51195 | 5444 | 129 |
1878034 | 1878034 | 2021-11-02 | Augusta | Virginia | 51015 | 10195 | 129 |
1878156 | 1878156 | 2021-11-02 | Wise | Virginia | 51195 | 5409 | 129 |
1874907 | 1874907 | 2021-11-01 | Wise | Virginia | 51195 | 5390 | 129 |
1871658 | 1871658 | 2021-10-31 | Wise | Virginia | 51195 | 5353 | 129 |
1868409 | 1868409 | 2021-10-30 | Wise | Virginia | 51195 | 5353 | 129 |
1865160 | 1865160 | 2021-10-29 | Wise | Virginia | 51195 | 5353 | 129 |
1861911 | 1861911 | 2021-10-28 | Wise | Virginia | 51195 | 5321 | 129 |
1858662 | 1858662 | 2021-10-27 | Wise | Virginia | 51195 | 5304 | 129 |
1855413 | 1855413 | 2021-10-26 | Wise | Virginia | 51195 | 5262 | 129 |
1793566 | 1793566 | 2021-10-07 | Campbell | Virginia | 51031 | 6832 | 129 |
1748172 | 1748172 | 2021-09-23 | Rockingham | Virginia | 51165 | 8483 | 129 |
1699448 | 1699448 | 2021-09-08 | Spotsylvania | Virginia | 51177 | 12312 | 129 |
1696200 | 1696200 | 2021-09-07 | Spotsylvania | Virginia | 51177 | 12225 | 129 |
1254606 | 1254606 | 2021-04-24 | Shenandoah | Virginia | 51171 | 4175 | 129 |
1251359 | 1251359 | 2021-04-23 | Shenandoah | Virginia | 51171 | 4160 | 129 |
1248112 | 1248112 | 2021-04-22 | Shenandoah | Virginia | 51171 | 4149 | 129 |
1244865 | 1244865 | 2021-04-21 | Shenandoah | Virginia | 51171 | 4141 | 129 |
1241618 | 1241618 | 2021-04-20 | Shenandoah | Virginia | 51171 | 4129 | 129 |
1238371 | 1238371 | 2021-04-19 | Shenandoah | Virginia | 51171 | 4123 | 129 |
1235124 | 1235124 | 2021-04-18 | Shenandoah | Virginia | 51171 | 4113 | 129 |
1231876 | 1231876 | 2021-04-17 | Shenandoah | Virginia | 51171 | 4099 | 129 |
1228628 | 1228628 | 2021-04-16 | Shenandoah | Virginia | 51171 | 4061 | 129 |
1225380 | 1225380 | 2021-04-15 | Shenandoah | Virginia | 51171 | 4048 | 129 |
1222133 | 1222133 | 2021-04-14 | Shenandoah | Virginia | 51171 | 4017 | 129 |
1218885 | 1218885 | 2021-04-13 | Shenandoah | Virginia | 51171 | 4012 | 129 |
1215637 | 1215637 | 2021-04-12 | Shenandoah | Virginia | 51171 | 4002 | 129 |
1202534 | 1202534 | 2021-04-08 | Alexandria city | Virginia | 51510 | 11172 | 129 |
1199286 | 1199286 | 2021-04-07 | Alexandria city | Virginia | 51510 | 11136 | 129 |
1196037 | 1196037 | 2021-04-06 | Alexandria city | Virginia | 51510 | 11100 | 129 |
1131090 | 1131090 | 2021-03-17 | Alexandria city | Virginia | 51510 | 10643 | 129 |
1127843 | 1127843 | 2021-03-16 | Alexandria city | Virginia | 51510 | 10617 | 129 |
1098680 | 1098680 | 2021-03-07 | Hampton city | Virginia | 51650 | 8825 | 129 |
1095432 | 1095432 | 2021-03-06 | Hampton city | Virginia | 51650 | 8794 | 129 |
1046797 | 1046797 | 2021-02-19 | Roanoke city | Virginia | 51770 | 7336 | 129 |
1046809 | 1046809 | 2021-02-19 | Suffolk city | Virginia | 51800 | 6671 | 129 |
1043564 | 1043564 | 2021-02-18 | Suffolk city | Virginia | 51800 | 6649 | 129 |
835862 | 835862 | 2020-12-16 | Virginia Beach city | Virginia | 51810 | 13452 | 129 |
770856 | 770856 | 2020-11-26 | Chesterfield | Virginia | 51041 | 9045 | 129 |
647617 | 647617 | 2020-10-19 | Loudoun | Virginia | 51107 | 7576 | 129 |
644371 | 644371 | 2020-10-18 | Loudoun | Virginia | 51107 | 7558 | 129 |
641123 | 641123 | 2020-10-17 | Loudoun | Virginia | 51107 | 7505 | 129 |
637876 | 637876 | 2020-10-16 | Loudoun | Virginia | 51107 | 7454 | 129 |
634631 | 634631 | 2020-10-15 | Loudoun | Virginia | 51107 | 7417 | 129 |
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);