ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
115 rows where deaths = 149 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 26
county 26
- Culpeper 16
- Lynchburg city 15
- Alexandria city 9
- Wythe 9
- Montgomery 7
- Norfolk city 7
- Warren 6
- Campbell 5
- Bedford 4
- Halifax 4
- Pittsylvania 4
- Albemarle 3
- Arlington 3
- Frederick 3
- Hanover 3
- Portsmouth city 3
- Shenandoah 3
- Spotsylvania 3
- Augusta 1
- Chesapeake city 1
- Danville city 1
- Harrisonburg city 1
- Henry 1
- Roanoke 1
- Roanoke city 1
- Stafford 1
state 1
- Virginia · 115 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502540 | 2502540 | 2022-05-13 | Culpeper | Virginia | 51047 | 11497 | 149 |
2502641 | 2502641 | 2022-05-13 | Wythe | Virginia | 51197 | 7557 | 149 |
2499282 | 2499282 | 2022-05-12 | Culpeper | Virginia | 51047 | 11486 | 149 |
2499383 | 2499383 | 2022-05-12 | Wythe | Virginia | 51197 | 7548 | 149 |
2496024 | 2496024 | 2022-05-11 | Culpeper | Virginia | 51047 | 11477 | 149 |
2496125 | 2496125 | 2022-05-11 | Wythe | Virginia | 51197 | 7543 | 149 |
2492766 | 2492766 | 2022-05-10 | Culpeper | Virginia | 51047 | 11453 | 149 |
2492867 | 2492867 | 2022-05-10 | Wythe | Virginia | 51197 | 7538 | 149 |
2489609 | 2489609 | 2022-05-09 | Wythe | Virginia | 51197 | 7536 | 149 |
2486352 | 2486352 | 2022-05-08 | Wythe | Virginia | 51197 | 7532 | 149 |
2483094 | 2483094 | 2022-05-07 | Wythe | Virginia | 51197 | 7532 | 149 |
2479836 | 2479836 | 2022-05-06 | Wythe | Virginia | 51197 | 7532 | 149 |
2476578 | 2476578 | 2022-05-05 | Wythe | Virginia | 51197 | 7525 | 149 |
2424380 | 2424380 | 2022-04-19 | Culpeper | Virginia | 51047 | 11327 | 149 |
2421124 | 2421124 | 2022-04-18 | Culpeper | Virginia | 51047 | 11348 | 149 |
2404844 | 2404844 | 2022-04-13 | Culpeper | Virginia | 51047 | 11395 | 149 |
2401589 | 2401589 | 2022-04-12 | Culpeper | Virginia | 51047 | 11392 | 149 |
2401640 | 2401640 | 2022-04-12 | Montgomery | Virginia | 51121 | 18644 | 149 |
2398334 | 2398334 | 2022-04-11 | Culpeper | Virginia | 51047 | 11389 | 149 |
2398385 | 2398385 | 2022-04-11 | Montgomery | Virginia | 51121 | 18631 | 149 |
2395079 | 2395079 | 2022-04-10 | Culpeper | Virginia | 51047 | 11379 | 149 |
2395130 | 2395130 | 2022-04-10 | Montgomery | Virginia | 51121 | 18625 | 149 |
2391823 | 2391823 | 2022-04-09 | Culpeper | Virginia | 51047 | 11379 | 149 |
2391874 | 2391874 | 2022-04-09 | Montgomery | Virginia | 51121 | 18625 | 149 |
2388567 | 2388567 | 2022-04-08 | Culpeper | Virginia | 51047 | 11379 | 149 |
2388618 | 2388618 | 2022-04-08 | Montgomery | Virginia | 51121 | 18625 | 149 |
2385312 | 2385312 | 2022-04-07 | Culpeper | Virginia | 51047 | 11376 | 149 |
2385363 | 2385363 | 2022-04-07 | Montgomery | Virginia | 51121 | 18613 | 149 |
2382057 | 2382057 | 2022-04-06 | Culpeper | Virginia | 51047 | 11445 | 149 |
2382108 | 2382108 | 2022-04-06 | Montgomery | Virginia | 51121 | 18608 | 149 |
2378802 | 2378802 | 2022-04-05 | Culpeper | Virginia | 51047 | 11483 | 149 |
2375548 | 2375548 | 2022-04-04 | Culpeper | Virginia | 51047 | 11485 | 149 |
2375642 | 2375642 | 2022-04-04 | Warren | Virginia | 51187 | 8484 | 149 |
2372390 | 2372390 | 2022-04-03 | Warren | Virginia | 51187 | 8476 | 149 |
2369137 | 2369137 | 2022-04-02 | Warren | Virginia | 51187 | 8476 | 149 |
2365884 | 2365884 | 2022-04-01 | Warren | Virginia | 51187 | 8476 | 149 |
2362631 | 2362631 | 2022-03-31 | Warren | Virginia | 51187 | 8470 | 149 |
2359377 | 2359377 | 2022-03-30 | Warren | Virginia | 51187 | 8465 | 149 |
2326723 | 2326723 | 2022-03-20 | Albemarle | Virginia | 51003 | 15840 | 149 |
2323470 | 2323470 | 2022-03-19 | Albemarle | Virginia | 51003 | 15840 | 149 |
2320216 | 2320216 | 2022-03-18 | Albemarle | Virginia | 51003 | 15840 | 149 |
2304005 | 2304005 | 2022-03-13 | Halifax | Virginia | 51083 | 6975 | 149 |
2300753 | 2300753 | 2022-03-12 | Halifax | Virginia | 51083 | 6975 | 149 |
2297501 | 2297501 | 2022-03-11 | Halifax | Virginia | 51083 | 6975 | 149 |
2294249 | 2294249 | 2022-03-10 | Halifax | Virginia | 51083 | 6966 | 149 |
2264980 | 2264980 | 2022-03-01 | Harrisonburg city | Virginia | 51660 | 13168 | 149 |
2239033 | 2239033 | 2022-02-21 | Stafford | Virginia | 51179 | 29494 | 149 |
2167461 | 2167461 | 2022-01-30 | Pittsylvania | Virginia | 51143 | 11649 | 149 |
2164206 | 2164206 | 2022-01-29 | Pittsylvania | Virginia | 51143 | 11649 | 149 |
2160951 | 2160951 | 2022-01-28 | Pittsylvania | Virginia | 51143 | 11649 | 149 |
2157695 | 2157695 | 2022-01-27 | Pittsylvania | Virginia | 51143 | 11557 | 149 |
2112066 | 2112066 | 2022-01-13 | Augusta | Virginia | 51015 | 14298 | 149 |
1985298 | 1985298 | 2021-12-05 | Campbell | Virginia | 51031 | 7673 | 149 |
1982048 | 1982048 | 2021-12-04 | Campbell | Virginia | 51031 | 7673 | 149 |
1978798 | 1978798 | 2021-12-03 | Campbell | Virginia | 51031 | 7673 | 149 |
1975548 | 1975548 | 2021-12-02 | Campbell | Virginia | 51031 | 7657 | 149 |
1972299 | 1972299 | 2021-12-01 | Campbell | Virginia | 51031 | 7634 | 149 |
1878028 | 1878028 | 2021-11-02 | Alexandria city | Virginia | 51510 | 14342 | 149 |
1874779 | 1874779 | 2021-11-01 | Alexandria city | Virginia | 51510 | 14331 | 149 |
1871530 | 1871530 | 2021-10-31 | Alexandria city | Virginia | 51510 | 14277 | 149 |
1871573 | 1871573 | 2021-10-31 | Frederick | Virginia | 51069 | 11606 | 149 |
1871644 | 1871644 | 2021-10-31 | Spotsylvania | Virginia | 51177 | 15142 | 149 |
1868281 | 1868281 | 2021-10-30 | Alexandria city | Virginia | 51510 | 14277 | 149 |
1868324 | 1868324 | 2021-10-30 | Frederick | Virginia | 51069 | 11606 | 149 |
1868395 | 1868395 | 2021-10-30 | Spotsylvania | Virginia | 51177 | 15142 | 149 |
1865032 | 1865032 | 2021-10-29 | Alexandria city | Virginia | 51510 | 14277 | 149 |
1865075 | 1865075 | 2021-10-29 | Frederick | Virginia | 51069 | 11606 | 149 |
1865146 | 1865146 | 2021-10-29 | Spotsylvania | Virginia | 51177 | 15142 | 149 |
1861783 | 1861783 | 2021-10-28 | Alexandria city | Virginia | 51510 | 14255 | 149 |
1861791 | 1861791 | 2021-10-28 | Bedford | Virginia | 51019 | 9911 | 149 |
1858534 | 1858534 | 2021-10-27 | Alexandria city | Virginia | 51510 | 14231 | 149 |
1858542 | 1858542 | 2021-10-27 | Bedford | Virginia | 51019 | 9901 | 149 |
1855285 | 1855285 | 2021-10-26 | Alexandria city | Virginia | 51510 | 14211 | 149 |
1855293 | 1855293 | 2021-10-26 | Bedford | Virginia | 51019 | 9877 | 149 |
1852036 | 1852036 | 2021-10-25 | Alexandria city | Virginia | 51510 | 14194 | 149 |
1852044 | 1852044 | 2021-10-25 | Bedford | Virginia | 51019 | 9858 | 149 |
1829347 | 1829347 | 2021-10-18 | Henry | Virginia | 51089 | 6290 | 149 |
1790412 | 1790412 | 2021-10-06 | Shenandoah | Virginia | 51171 | 5921 | 149 |
1787164 | 1787164 | 2021-10-05 | Shenandoah | Virginia | 51171 | 5890 | 149 |
1783915 | 1783915 | 2021-10-04 | Shenandoah | Virginia | 51171 | 5866 | 149 |
1647391 | 1647391 | 2021-08-23 | Danville city | Virginia | 51590 | 4907 | 149 |
1621444 | 1621444 | 2021-08-15 | Lynchburg city | Virginia | 51680 | 7885 | 149 |
1618196 | 1618196 | 2021-08-14 | Lynchburg city | Virginia | 51680 | 7885 | 149 |
1614948 | 1614948 | 2021-08-13 | Lynchburg city | Virginia | 51680 | 7885 | 149 |
1611699 | 1611699 | 2021-08-12 | Lynchburg city | Virginia | 51680 | 7849 | 149 |
1608452 | 1608452 | 2021-08-11 | Lynchburg city | Virginia | 51680 | 7828 | 149 |
1605203 | 1605203 | 2021-08-10 | Lynchburg city | Virginia | 51680 | 7802 | 149 |
1601953 | 1601953 | 2021-08-09 | Lynchburg city | Virginia | 51680 | 7799 | 149 |
1598705 | 1598705 | 2021-08-08 | Lynchburg city | Virginia | 51680 | 7754 | 149 |
1595456 | 1595456 | 2021-08-07 | Lynchburg city | Virginia | 51680 | 7754 | 149 |
1592207 | 1592207 | 2021-08-06 | Lynchburg city | Virginia | 51680 | 7754 | 149 |
1588958 | 1588958 | 2021-08-05 | Lynchburg city | Virginia | 51680 | 7732 | 149 |
1588991 | 1588991 | 2021-08-05 | Roanoke | Virginia | 51161 | 8843 | 149 |
1585709 | 1585709 | 2021-08-04 | Lynchburg city | Virginia | 51680 | 7709 | 149 |
1582459 | 1582459 | 2021-08-03 | Lynchburg city | Virginia | 51680 | 7697 | 149 |
1579209 | 1579209 | 2021-08-02 | Lynchburg city | Virginia | 51680 | 7679 | 149 |
1309759 | 1309759 | 2021-05-11 | Lynchburg city | Virginia | 51680 | 7744 | 149 |
1225323 | 1225323 | 2021-04-15 | Hanover | Virginia | 51085 | 7732 | 149 |
1202588 | 1202588 | 2021-04-08 | Hanover | Virginia | 51085 | 7550 | 149 |
1199340 | 1199340 | 2021-04-07 | Hanover | Virginia | 51085 | 7511 | 149 |
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);