ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where deaths = 154 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 23
county 23
- Lynchburg city 23
- Arlington 15
- Loudoun 9
- Albemarle 7
- Alexandria city 7
- Wise 7
- Halifax 6
- Hanover 6
- Warren 5
- Montgomery 4
- Shenandoah 4
- Harrisonburg city 3
- Henry 3
- Tazewell 3
- Campbell 2
- Roanoke 2
- Chesterfield 1
- Danville city 1
- Hampton city 1
- Portsmouth city 1
- Roanoke city 1
- Spotsylvania 1
- Stafford 1
state 1
- Virginia · 113 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502591 | 2502591 | 2022-05-13 | Montgomery | Virginia | 51121 | 19403 | 154 |
2499333 | 2499333 | 2022-05-12 | Montgomery | Virginia | 51121 | 19362 | 154 |
2496075 | 2496075 | 2022-05-11 | Montgomery | Virginia | 51121 | 19304 | 154 |
2492817 | 2492817 | 2022-05-10 | Montgomery | Virginia | 51121 | 19256 | 154 |
2421218 | 2421218 | 2022-04-18 | Warren | Virginia | 51187 | 8570 | 154 |
2417962 | 2417962 | 2022-04-17 | Warren | Virginia | 51187 | 8560 | 154 |
2414706 | 2414706 | 2022-04-16 | Warren | Virginia | 51187 | 8560 | 154 |
2411450 | 2411450 | 2022-04-15 | Warren | Virginia | 51187 | 8560 | 154 |
2408194 | 2408194 | 2022-04-14 | Warren | Virginia | 51187 | 8557 | 154 |
2401560 | 2401560 | 2022-04-12 | Albemarle | Virginia | 51003 | 17503 | 154 |
2385283 | 2385283 | 2022-04-07 | Albemarle | Virginia | 51003 | 17102 | 154 |
2382028 | 2382028 | 2022-04-06 | Albemarle | Virginia | 51003 | 16885 | 154 |
2382081 | 2382081 | 2022-04-06 | Halifax | Virginia | 51083 | 7026 | 154 |
2378826 | 2378826 | 2022-04-05 | Halifax | Virginia | 51083 | 7023 | 154 |
2375519 | 2375519 | 2022-04-04 | Albemarle | Virginia | 51003 | 16693 | 154 |
2375572 | 2375572 | 2022-04-04 | Halifax | Virginia | 51083 | 7023 | 154 |
2372267 | 2372267 | 2022-04-03 | Albemarle | Virginia | 51003 | 16533 | 154 |
2372320 | 2372320 | 2022-04-03 | Halifax | Virginia | 51083 | 7015 | 154 |
2369014 | 2369014 | 2022-04-02 | Albemarle | Virginia | 51003 | 16533 | 154 |
2369067 | 2369067 | 2022-04-02 | Halifax | Virginia | 51083 | 7015 | 154 |
2365761 | 2365761 | 2022-04-01 | Albemarle | Virginia | 51003 | 16533 | 154 |
2365814 | 2365814 | 2022-04-01 | Halifax | Virginia | 51083 | 7015 | 154 |
2326779 | 2326779 | 2022-03-20 | Harrisonburg city | Virginia | 51660 | 13209 | 154 |
2323526 | 2323526 | 2022-03-19 | Harrisonburg city | Virginia | 51660 | 13209 | 154 |
2320272 | 2320272 | 2022-03-18 | Harrisonburg city | Virginia | 51660 | 13209 | 154 |
2258544 | 2258544 | 2022-02-27 | Tazewell | Virginia | 51185 | 9857 | 154 |
2255293 | 2255293 | 2022-02-26 | Tazewell | Virginia | 51185 | 9857 | 154 |
2252042 | 2252042 | 2022-02-25 | Tazewell | Virginia | 51185 | 9857 | 154 |
2248786 | 2248786 | 2022-02-24 | Stafford | Virginia | 51179 | 29603 | 154 |
2147973 | 2147973 | 2022-01-24 | Wise | Virginia | 51195 | 7867 | 154 |
2144721 | 2144721 | 2022-01-23 | Wise | Virginia | 51195 | 7722 | 154 |
2141466 | 2141466 | 2022-01-22 | Wise | Virginia | 51195 | 7722 | 154 |
2138210 | 2138210 | 2022-01-21 | Wise | Virginia | 51195 | 7722 | 154 |
2134955 | 2134955 | 2022-01-20 | Wise | Virginia | 51195 | 7633 | 154 |
2131703 | 2131703 | 2022-01-19 | Wise | Virginia | 51195 | 7487 | 154 |
2128449 | 2128449 | 2022-01-18 | Wise | Virginia | 51195 | 7435 | 154 |
2037309 | 2037309 | 2021-12-21 | Campbell | Virginia | 51031 | 8040 | 154 |
2034059 | 2034059 | 2021-12-20 | Campbell | Virginia | 51031 | 8022 | 154 |
1965783 | 1965783 | 2021-11-29 | Alexandria city | Virginia | 51510 | 14789 | 154 |
1962531 | 1962531 | 2021-11-28 | Alexandria city | Virginia | 51510 | 14753 | 154 |
1959280 | 1959280 | 2021-11-27 | Alexandria city | Virginia | 51510 | 14753 | 154 |
1956029 | 1956029 | 2021-11-26 | Alexandria city | Virginia | 51510 | 14753 | 154 |
1952778 | 1952778 | 2021-11-25 | Alexandria city | Virginia | 51510 | 14740 | 154 |
1949527 | 1949527 | 2021-11-24 | Alexandria city | Virginia | 51510 | 14728 | 154 |
1946276 | 1946276 | 2021-11-23 | Alexandria city | Virginia | 51510 | 14714 | 154 |
1904140 | 1904140 | 2021-11-10 | Spotsylvania | Virginia | 51177 | 15515 | 154 |
1861840 | 1861840 | 2021-10-28 | Henry | Virginia | 51089 | 6467 | 154 |
1858591 | 1858591 | 2021-10-27 | Henry | Virginia | 51089 | 6447 | 154 |
1855342 | 1855342 | 2021-10-26 | Henry | Virginia | 51089 | 6428 | 154 |
1826152 | 1826152 | 2021-10-17 | Shenandoah | Virginia | 51171 | 6184 | 154 |
1822903 | 1822903 | 2021-10-16 | Shenandoah | Virginia | 51171 | 6184 | 154 |
1819654 | 1819654 | 2021-10-15 | Shenandoah | Virginia | 51171 | 6184 | 154 |
1816405 | 1816405 | 2021-10-14 | Shenandoah | Virginia | 51171 | 6155 | 154 |
1764411 | 1764411 | 2021-09-28 | Roanoke | Virginia | 51161 | 10803 | 154 |
1761162 | 1761162 | 2021-09-27 | Roanoke | Virginia | 51161 | 10773 | 154 |
1670125 | 1670125 | 2021-08-30 | Danville city | Virginia | 51590 | 5058 | 154 |
1452585 | 1452585 | 2021-06-24 | Lynchburg city | Virginia | 51680 | 7803 | 154 |
1433110 | 1433110 | 2021-06-18 | Lynchburg city | Virginia | 51680 | 7848 | 154 |
1429864 | 1429864 | 2021-06-17 | Lynchburg city | Virginia | 51680 | 7849 | 154 |
1426619 | 1426619 | 2021-06-16 | Lynchburg city | Virginia | 51680 | 7850 | 154 |
1423373 | 1423373 | 2021-06-15 | Lynchburg city | Virginia | 51680 | 7841 | 154 |
1420126 | 1420126 | 2021-06-14 | Lynchburg city | Virginia | 51680 | 7838 | 154 |
1416881 | 1416881 | 2021-06-13 | Lynchburg city | Virginia | 51680 | 7839 | 154 |
1413635 | 1413635 | 2021-06-12 | Lynchburg city | Virginia | 51680 | 7839 | 154 |
1410390 | 1410390 | 2021-06-11 | Lynchburg city | Virginia | 51680 | 7837 | 154 |
1407145 | 1407145 | 2021-06-10 | Lynchburg city | Virginia | 51680 | 7840 | 154 |
1403899 | 1403899 | 2021-06-09 | Lynchburg city | Virginia | 51680 | 7835 | 154 |
1400654 | 1400654 | 2021-06-08 | Lynchburg city | Virginia | 51680 | 7834 | 154 |
1397409 | 1397409 | 2021-06-07 | Lynchburg city | Virginia | 51680 | 7824 | 154 |
1394162 | 1394162 | 2021-06-06 | Lynchburg city | Virginia | 51680 | 7823 | 154 |
1390917 | 1390917 | 2021-06-05 | Lynchburg city | Virginia | 51680 | 7819 | 154 |
1387672 | 1387672 | 2021-06-04 | Lynchburg city | Virginia | 51680 | 7818 | 154 |
1384427 | 1384427 | 2021-06-03 | Lynchburg city | Virginia | 51680 | 7800 | 154 |
1381181 | 1381181 | 2021-06-02 | Lynchburg city | Virginia | 51680 | 7838 | 154 |
1364953 | 1364953 | 2021-05-28 | Lynchburg city | Virginia | 51680 | 7873 | 154 |
1361707 | 1361707 | 2021-05-27 | Lynchburg city | Virginia | 51680 | 7865 | 154 |
1358461 | 1358461 | 2021-05-26 | Lynchburg city | Virginia | 51680 | 7881 | 154 |
1355215 | 1355215 | 2021-05-25 | Lynchburg city | Virginia | 51680 | 7873 | 154 |
1351969 | 1351969 | 2021-05-24 | Lynchburg city | Virginia | 51680 | 7871 | 154 |
1287018 | 1287018 | 2021-05-04 | Hanover | Virginia | 51085 | 8013 | 154 |
1283772 | 1283772 | 2021-05-03 | Hanover | Virginia | 51085 | 8013 | 154 |
1280525 | 1280525 | 2021-05-02 | Hanover | Virginia | 51085 | 8000 | 154 |
1277278 | 1277278 | 2021-05-01 | Hanover | Virginia | 51085 | 7993 | 154 |
1274031 | 1274031 | 2021-04-30 | Hanover | Virginia | 51085 | 7983 | 154 |
1270784 | 1270784 | 2021-04-29 | Hanover | Virginia | 51085 | 7979 | 154 |
1170110 | 1170110 | 2021-03-29 | Hampton city | Virginia | 51650 | 9469 | 154 |
1114951 | 1114951 | 2021-03-12 | Portsmouth city | Virginia | 51740 | 7946 | 154 |
1082501 | 1082501 | 2021-03-02 | Roanoke city | Virginia | 51770 | 7553 | 154 |
874751 | 874751 | 2020-12-28 | Loudoun | Virginia | 51107 | 13683 | 154 |
871506 | 871506 | 2020-12-27 | Loudoun | Virginia | 51107 | 13600 | 154 |
868261 | 868261 | 2020-12-26 | Loudoun | Virginia | 51107 | 13441 | 154 |
865016 | 865016 | 2020-12-25 | Loudoun | Virginia | 51107 | 13280 | 154 |
861771 | 861771 | 2020-12-24 | Loudoun | Virginia | 51107 | 13171 | 154 |
858526 | 858526 | 2020-12-23 | Loudoun | Virginia | 51107 | 13082 | 154 |
855281 | 855281 | 2020-12-22 | Loudoun | Virginia | 51107 | 12925 | 154 |
839010 | 839010 | 2020-12-17 | Chesterfield | Virginia | 51041 | 11220 | 154 |
835809 | 835809 | 2020-12-16 | Loudoun | Virginia | 51107 | 12193 | 154 |
832563 | 832563 | 2020-12-15 | Loudoun | Virginia | 51107 | 12029 | 154 |
709183 | 709183 | 2020-11-07 | Arlington | Virginia | 51013 | 4970 | 154 |
705939 | 705939 | 2020-11-06 | Arlington | Virginia | 51013 | 4919 | 154 |
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);