ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where deaths = 161 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 25
county 25
- Alexandria city 14
- Shenandoah 11
- Hanover 8
- Loudoun 6
- Lynchburg city 6
- Frederick 4
- Hampton city 4
- Washington 4
- Bedford 3
- Smyth 3
- Harrisonburg city 2
- Henry 2
- Prince William 2
- Roanoke 2
- Stafford 2
- Wise 2
- Albemarle 1
- Arlington 1
- Campbell 1
- Chesapeake city 1
- Chesterfield 1
- Newport News city 1
- Portsmouth city 1
- Richmond city 1
- Suffolk city 1
state 1
- Virginia · 84 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476504 | 2476504 | 2022-05-05 | Harrisonburg city | Virginia | 51660 | 13415 | 161 |
2473246 | 2473246 | 2022-05-04 | Harrisonburg city | Virginia | 51660 | 13408 | 161 |
2408071 | 2408071 | 2022-04-14 | Albemarle | Virginia | 51003 | 17652 | 161 |
2281301 | 2281301 | 2022-03-06 | Smyth | Virginia | 51173 | 8642 | 161 |
2278048 | 2278048 | 2022-03-05 | Smyth | Virginia | 51173 | 8642 | 161 |
2274795 | 2274795 | 2022-03-04 | Smyth | Virginia | 51173 | 8642 | 161 |
2268293 | 2268293 | 2022-03-02 | Stafford | Virginia | 51179 | 29716 | 161 |
2265040 | 2265040 | 2022-03-01 | Stafford | Virginia | 51179 | 29681 | 161 |
2180506 | 2180506 | 2022-02-03 | Wise | Virginia | 51195 | 8853 | 161 |
2177255 | 2177255 | 2022-02-02 | Wise | Virginia | 51195 | 8721 | 161 |
2108824 | 2108824 | 2022-01-12 | Campbell | Virginia | 51031 | 9045 | 161 |
2102306 | 2102306 | 2022-01-10 | Alexandria city | Virginia | 51510 | 23325 | 161 |
2099055 | 2099055 | 2022-01-09 | Alexandria city | Virginia | 51510 | 21809 | 161 |
2095804 | 2095804 | 2022-01-08 | Alexandria city | Virginia | 51510 | 21809 | 161 |
2092552 | 2092552 | 2022-01-07 | Alexandria city | Virginia | 51510 | 21809 | 161 |
2089300 | 2089300 | 2022-01-06 | Alexandria city | Virginia | 51510 | 21422 | 161 |
2086049 | 2086049 | 2022-01-05 | Alexandria city | Virginia | 51510 | 21086 | 161 |
2082797 | 2082797 | 2022-01-04 | Alexandria city | Virginia | 51510 | 20875 | 161 |
2079545 | 2079545 | 2022-01-03 | Alexandria city | Virginia | 51510 | 20419 | 161 |
2076293 | 2076293 | 2022-01-02 | Alexandria city | Virginia | 51510 | 18480 | 161 |
2073042 | 2073042 | 2022-01-01 | Alexandria city | Virginia | 51510 | 18480 | 161 |
2069791 | 2069791 | 2021-12-31 | Alexandria city | Virginia | 51510 | 18480 | 161 |
2066540 | 2066540 | 2021-12-30 | Alexandria city | Virginia | 51510 | 18779 | 161 |
2063290 | 2063290 | 2021-12-29 | Alexandria city | Virginia | 51510 | 18319 | 161 |
2060040 | 2060040 | 2021-12-28 | Alexandria city | Virginia | 51510 | 18082 | 161 |
2008160 | 2008160 | 2021-12-12 | Washington | Virginia | 51191 | 8546 | 161 |
2004909 | 2004909 | 2021-12-11 | Washington | Virginia | 51191 | 8546 | 161 |
2001658 | 2001658 | 2021-12-10 | Washington | Virginia | 51191 | 8546 | 161 |
1998408 | 1998408 | 2021-12-09 | Washington | Virginia | 51191 | 8497 | 161 |
1965826 | 1965826 | 2021-11-29 | Frederick | Virginia | 51069 | 12422 | 161 |
1962574 | 1962574 | 2021-11-28 | Frederick | Virginia | 51069 | 12321 | 161 |
1959323 | 1959323 | 2021-11-27 | Frederick | Virginia | 51069 | 12321 | 161 |
1956072 | 1956072 | 2021-11-26 | Frederick | Virginia | 51069 | 12321 | 161 |
1917032 | 1917032 | 2021-11-14 | Bedford | Virginia | 51019 | 10151 | 161 |
1913782 | 1913782 | 2021-11-13 | Bedford | Virginia | 51019 | 10151 | 161 |
1910532 | 1910532 | 2021-11-12 | Bedford | Virginia | 51019 | 10151 | 161 |
1894387 | 1894387 | 2021-11-07 | Shenandoah | Virginia | 51171 | 6531 | 161 |
1891137 | 1891137 | 2021-11-06 | Shenandoah | Virginia | 51171 | 6531 | 161 |
1887887 | 1887887 | 2021-11-05 | Shenandoah | Virginia | 51171 | 6531 | 161 |
1884583 | 1884583 | 2021-11-04 | Henry | Virginia | 51089 | 6586 | 161 |
1884637 | 1884637 | 2021-11-04 | Shenandoah | Virginia | 51171 | 6512 | 161 |
1881334 | 1881334 | 2021-11-03 | Henry | Virginia | 51089 | 6564 | 161 |
1881388 | 1881388 | 2021-11-03 | Shenandoah | Virginia | 51171 | 6484 | 161 |
1878139 | 1878139 | 2021-11-02 | Shenandoah | Virginia | 51171 | 6473 | 161 |
1874890 | 1874890 | 2021-11-01 | Shenandoah | Virginia | 51171 | 6464 | 161 |
1861894 | 1861894 | 2021-10-28 | Shenandoah | Virginia | 51171 | 6415 | 161 |
1858645 | 1858645 | 2021-10-27 | Shenandoah | Virginia | 51171 | 6396 | 161 |
1855396 | 1855396 | 2021-10-26 | Shenandoah | Virginia | 51171 | 6382 | 161 |
1852147 | 1852147 | 2021-10-25 | Shenandoah | Virginia | 51171 | 6374 | 161 |
1816398 | 1816398 | 2021-10-14 | Roanoke | Virginia | 51161 | 11469 | 161 |
1813150 | 1813150 | 2021-10-13 | Roanoke | Virginia | 51161 | 11415 | 161 |
1722140 | 1722140 | 2021-09-15 | Lynchburg city | Virginia | 51680 | 10060 | 161 |
1718892 | 1718892 | 2021-09-14 | Lynchburg city | Virginia | 51680 | 9891 | 161 |
1715644 | 1715644 | 2021-09-13 | Lynchburg city | Virginia | 51680 | 9797 | 161 |
1712398 | 1712398 | 2021-09-12 | Lynchburg city | Virginia | 51680 | 9627 | 161 |
1709151 | 1709151 | 2021-09-11 | Lynchburg city | Virginia | 51680 | 9627 | 161 |
1705904 | 1705904 | 2021-09-10 | Lynchburg city | Virginia | 51680 | 9627 | 161 |
1377919 | 1377919 | 2021-06-01 | Hanover | Virginia | 51085 | 8193 | 161 |
1374673 | 1374673 | 2021-05-31 | Hanover | Virginia | 51085 | 8193 | 161 |
1371428 | 1371428 | 2021-05-30 | Hanover | Virginia | 51085 | 8187 | 161 |
1368182 | 1368182 | 2021-05-29 | Hanover | Virginia | 51085 | 8181 | 161 |
1364936 | 1364936 | 2021-05-28 | Hanover | Virginia | 51085 | 8176 | 161 |
1355198 | 1355198 | 2021-05-25 | Hanover | Virginia | 51085 | 8179 | 161 |
1351952 | 1351952 | 2021-05-24 | Hanover | Virginia | 51085 | 8178 | 161 |
1348706 | 1348706 | 2021-05-23 | Hanover | Virginia | 51085 | 8179 | 161 |
1202587 | 1202587 | 2021-04-08 | Hampton city | Virginia | 51650 | 9764 | 161 |
1199339 | 1199339 | 2021-04-07 | Hampton city | Virginia | 51650 | 9732 | 161 |
1196090 | 1196090 | 2021-04-06 | Hampton city | Virginia | 51650 | 9708 | 161 |
1192842 | 1192842 | 2021-04-05 | Hampton city | Virginia | 51650 | 9671 | 161 |
1131184 | 1131184 | 2021-03-17 | Portsmouth city | Virginia | 51740 | 8038 | 161 |
1089004 | 1089004 | 2021-03-04 | Suffolk city | Virginia | 51800 | 6974 | 161 |
1075987 | 1075987 | 2021-02-28 | Newport News city | Virginia | 51700 | 11468 | 161 |
1059700 | 1059700 | 2021-02-23 | Chesapeake city | Virginia | 51550 | 17913 | 161 |
1056535 | 1056535 | 2021-02-22 | Richmond city | Virginia | 51760 | 14499 | 161 |
903960 | 903960 | 2021-01-06 | Loudoun | Virginia | 51107 | 14973 | 161 |
900715 | 900715 | 2021-01-05 | Loudoun | Virginia | 51107 | 14786 | 161 |
897470 | 897470 | 2021-01-04 | Loudoun | Virginia | 51107 | 14569 | 161 |
894224 | 894224 | 2021-01-03 | Loudoun | Virginia | 51107 | 14518 | 161 |
890978 | 890978 | 2021-01-02 | Loudoun | Virginia | 51107 | 14481 | 161 |
887731 | 887731 | 2021-01-01 | Loudoun | Virginia | 51107 | 14352 | 161 |
858481 | 858481 | 2020-12-23 | Chesterfield | Virginia | 51041 | 12072 | 161 |
809778 | 809778 | 2020-12-08 | Arlington | Virginia | 51013 | 6944 | 161 |
347207 | 347207 | 2020-07-18 | Prince William | Virginia | 51153 | 8104 | 161 |
344007 | 344007 | 2020-07-17 | Prince William | Virginia | 51153 | 8034 | 161 |
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);