ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where deaths = 127 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 29
county 29
- Halifax 24
- Shenandoah 22
- Pulaski 7
- Alexandria city 4
- Campbell 4
- Chesterfield 4
- Tazewell 4
- Culpeper 3
- Henry 3
- Pittsylvania 3
- Prince William 3
- Rockingham 3
- Wythe 3
- Carroll 2
- Hampton city 2
- Harrisonburg city 2
- Loudoun 2
- Roanoke 2
- Spotsylvania 2
- Suffolk city 2
- Arlington 1
- Chesapeake city 1
- Danville city 1
- Fauquier 1
- Norfolk city 1
- Richmond city 1
- Roanoke city 1
- Warren 1
- Wise 1
state 1
- Virginia · 110 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2304052 | 2304052 | 2022-03-13 | Pulaski | Virginia | 51155 | 7175 | 127 |
2300800 | 2300800 | 2022-03-12 | Pulaski | Virginia | 51155 | 7175 | 127 |
2297548 | 2297548 | 2022-03-11 | Pulaski | Virginia | 51155 | 7175 | 127 |
2294296 | 2294296 | 2022-03-10 | Pulaski | Virginia | 51155 | 7172 | 127 |
2291044 | 2291044 | 2022-03-09 | Pulaski | Virginia | 51155 | 7171 | 127 |
2287792 | 2287792 | 2022-03-08 | Pulaski | Virginia | 51155 | 7165 | 127 |
2284540 | 2284540 | 2022-03-07 | Pulaski | Virginia | 51155 | 7163 | 127 |
2235695 | 2235695 | 2022-02-20 | Culpeper | Virginia | 51047 | 11383 | 127 |
2232444 | 2232444 | 2022-02-19 | Culpeper | Virginia | 51047 | 11383 | 127 |
2229193 | 2229193 | 2022-02-18 | Culpeper | Virginia | 51047 | 11383 | 127 |
2222701 | 2222701 | 2022-02-16 | Fauquier | Virginia | 51061 | 12641 | 127 |
2199953 | 2199953 | 2022-02-09 | Harrisonburg city | Virginia | 51660 | 12793 | 127 |
2200027 | 2200027 | 2022-02-09 | Wythe | Virginia | 51197 | 6978 | 127 |
2196662 | 2196662 | 2022-02-08 | Carroll | Virginia | 51035 | 6191 | 127 |
2196699 | 2196699 | 2022-02-08 | Harrisonburg city | Virginia | 51660 | 12752 | 127 |
2196766 | 2196766 | 2022-02-08 | Warren | Virginia | 51187 | 8173 | 127 |
2196773 | 2196773 | 2022-02-08 | Wythe | Virginia | 51197 | 6932 | 127 |
2193407 | 2193407 | 2022-02-07 | Carroll | Virginia | 51035 | 6164 | 127 |
2193518 | 2193518 | 2022-02-07 | Wythe | Virginia | 51197 | 6882 | 127 |
2157723 | 2157723 | 2022-01-27 | Tazewell | Virginia | 51185 | 8413 | 127 |
2154470 | 2154470 | 2022-01-26 | Tazewell | Virginia | 51185 | 8253 | 127 |
2151217 | 2151217 | 2022-01-25 | Tazewell | Virginia | 51185 | 8119 | 127 |
2147965 | 2147965 | 2022-01-24 | Tazewell | Virginia | 51185 | 8084 | 127 |
2144644 | 2144644 | 2022-01-23 | Halifax | Virginia | 51083 | 5879 | 127 |
2141389 | 2141389 | 2022-01-22 | Halifax | Virginia | 51083 | 5879 | 127 |
2138133 | 2138133 | 2022-01-21 | Halifax | Virginia | 51083 | 5879 | 127 |
2134879 | 2134879 | 2022-01-20 | Halifax | Virginia | 51083 | 5772 | 127 |
2131627 | 2131627 | 2022-01-19 | Halifax | Virginia | 51083 | 5679 | 127 |
2128373 | 2128373 | 2022-01-18 | Halifax | Virginia | 51083 | 5624 | 127 |
2125120 | 2125120 | 2022-01-17 | Halifax | Virginia | 51083 | 5591 | 127 |
2121868 | 2121868 | 2022-01-16 | Halifax | Virginia | 51083 | 5364 | 127 |
2118616 | 2118616 | 2022-01-15 | Halifax | Virginia | 51083 | 5364 | 127 |
2115364 | 2115364 | 2022-01-14 | Halifax | Virginia | 51083 | 5364 | 127 |
2112112 | 2112112 | 2022-01-13 | Halifax | Virginia | 51083 | 5284 | 127 |
2108860 | 2108860 | 2022-01-12 | Halifax | Virginia | 51083 | 5194 | 127 |
2105609 | 2105609 | 2022-01-11 | Halifax | Virginia | 51083 | 5091 | 127 |
2102358 | 2102358 | 2022-01-10 | Halifax | Virginia | 51083 | 5018 | 127 |
2099107 | 2099107 | 2022-01-09 | Halifax | Virginia | 51083 | 4819 | 127 |
2095856 | 2095856 | 2022-01-08 | Halifax | Virginia | 51083 | 4819 | 127 |
2092604 | 2092604 | 2022-01-07 | Halifax | Virginia | 51083 | 4819 | 127 |
2089352 | 2089352 | 2022-01-06 | Halifax | Virginia | 51083 | 4770 | 127 |
2086101 | 2086101 | 2022-01-05 | Halifax | Virginia | 51083 | 4717 | 127 |
2082849 | 2082849 | 2022-01-04 | Halifax | Virginia | 51083 | 4709 | 127 |
2079597 | 2079597 | 2022-01-03 | Halifax | Virginia | 51083 | 4634 | 127 |
2076345 | 2076345 | 2022-01-02 | Halifax | Virginia | 51083 | 4569 | 127 |
2073094 | 2073094 | 2022-01-01 | Halifax | Virginia | 51083 | 4569 | 127 |
2069843 | 2069843 | 2021-12-31 | Halifax | Virginia | 51083 | 4569 | 127 |
1930115 | 1930115 | 2021-11-18 | Pittsylvania | Virginia | 51143 | 8371 | 127 |
1926865 | 1926865 | 2021-11-17 | Pittsylvania | Virginia | 51143 | 8359 | 127 |
1923615 | 1923615 | 2021-11-16 | Pittsylvania | Virginia | 51143 | 8334 | 127 |
1839165 | 1839165 | 2021-10-21 | Wise | Virginia | 51195 | 5180 | 127 |
1783820 | 1783820 | 2021-10-04 | Campbell | Virginia | 51031 | 6734 | 127 |
1780571 | 1780571 | 2021-10-03 | Campbell | Virginia | 51031 | 6683 | 127 |
1777321 | 1777321 | 2021-10-02 | Campbell | Virginia | 51031 | 6683 | 127 |
1774071 | 1774071 | 2021-10-01 | Campbell | Virginia | 51031 | 6683 | 127 |
1744922 | 1744922 | 2021-09-22 | Rockingham | Virginia | 51165 | 8441 | 127 |
1741673 | 1741673 | 2021-09-21 | Rockingham | Virginia | 51165 | 8392 | 127 |
1738424 | 1738424 | 2021-09-20 | Rockingham | Virginia | 51165 | 8371 | 127 |
1666905 | 1666905 | 2021-08-29 | Henry | Virginia | 51089 | 5140 | 127 |
1663657 | 1663657 | 2021-08-28 | Henry | Virginia | 51089 | 5140 | 127 |
1660409 | 1660409 | 2021-08-27 | Henry | Virginia | 51089 | 5140 | 127 |
1653970 | 1653970 | 2021-08-25 | Spotsylvania | Virginia | 51177 | 11419 | 127 |
1650724 | 1650724 | 2021-08-24 | Spotsylvania | Virginia | 51177 | 11362 | 127 |
1199316 | 1199316 | 2021-04-07 | Danville city | Virginia | 51590 | 4194 | 127 |
1196148 | 1196148 | 2021-04-06 | Shenandoah | Virginia | 51171 | 3934 | 127 |
1192893 | 1192893 | 2021-04-05 | Roanoke | Virginia | 51161 | 7824 | 127 |
1192900 | 1192900 | 2021-04-05 | Shenandoah | Virginia | 51171 | 3928 | 127 |
1189643 | 1189643 | 2021-04-04 | Roanoke | Virginia | 51161 | 7819 | 127 |
1189650 | 1189650 | 2021-04-04 | Shenandoah | Virginia | 51171 | 3923 | 127 |
1186403 | 1186403 | 2021-04-03 | Shenandoah | Virginia | 51171 | 3921 | 127 |
1183156 | 1183156 | 2021-04-02 | Shenandoah | Virginia | 51171 | 3914 | 127 |
1179909 | 1179909 | 2021-04-01 | Shenandoah | Virginia | 51171 | 3895 | 127 |
1176662 | 1176662 | 2021-03-31 | Shenandoah | Virginia | 51171 | 3889 | 127 |
1173415 | 1173415 | 2021-03-30 | Shenandoah | Virginia | 51171 | 3888 | 127 |
1170168 | 1170168 | 2021-03-29 | Shenandoah | Virginia | 51171 | 3886 | 127 |
1166920 | 1166920 | 2021-03-28 | Shenandoah | Virginia | 51171 | 3881 | 127 |
1163672 | 1163672 | 2021-03-27 | Shenandoah | Virginia | 51171 | 3874 | 127 |
1160313 | 1160313 | 2021-03-26 | Alexandria city | Virginia | 51510 | 10850 | 127 |
1160424 | 1160424 | 2021-03-26 | Shenandoah | Virginia | 51171 | 3868 | 127 |
1157176 | 1157176 | 2021-03-25 | Shenandoah | Virginia | 51171 | 3866 | 127 |
1153929 | 1153929 | 2021-03-24 | Shenandoah | Virginia | 51171 | 3863 | 127 |
1150682 | 1150682 | 2021-03-23 | Shenandoah | Virginia | 51171 | 3856 | 127 |
1147435 | 1147435 | 2021-03-22 | Shenandoah | Virginia | 51171 | 3853 | 127 |
1144188 | 1144188 | 2021-03-21 | Shenandoah | Virginia | 51171 | 3849 | 127 |
1140941 | 1140941 | 2021-03-20 | Shenandoah | Virginia | 51171 | 3848 | 127 |
1137695 | 1137695 | 2021-03-19 | Shenandoah | Virginia | 51171 | 3844 | 127 |
1134449 | 1134449 | 2021-03-18 | Shenandoah | Virginia | 51171 | 3832 | 127 |
1131201 | 1131201 | 2021-03-17 | Shenandoah | Virginia | 51171 | 3828 | 127 |
1127954 | 1127954 | 2021-03-16 | Shenandoah | Virginia | 51171 | 3814 | 127 |
1114857 | 1114857 | 2021-03-12 | Alexandria city | Virginia | 51510 | 10529 | 127 |
1111611 | 1111611 | 2021-03-11 | Alexandria city | Virginia | 51510 | 10504 | 127 |
1108365 | 1108365 | 2021-03-10 | Alexandria city | Virginia | 51510 | 10490 | 127 |
1092186 | 1092186 | 2021-03-05 | Hampton city | Virginia | 51650 | 8768 | 127 |
1088940 | 1088940 | 2021-03-04 | Hampton city | Virginia | 51650 | 8738 | 127 |
1037074 | 1037074 | 2021-02-16 | Suffolk city | Virginia | 51800 | 6585 | 127 |
1033829 | 1033829 | 2021-02-15 | Suffolk city | Virginia | 51800 | 6558 | 127 |
998115 | 998115 | 2021-02-04 | Roanoke city | Virginia | 51770 | 7047 | 127 |
975390 | 975390 | 2021-01-28 | Richmond city | Virginia | 51760 | 12470 | 127 |
968819 | 968819 | 2021-01-26 | Chesapeake city | Virginia | 51550 | 14731 | 127 |
952655 | 952655 | 2021-01-21 | Norfolk city | Virginia | 51710 | 11615 | 127 |
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);