ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where deaths = 256 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
- Portsmouth city 27
- Arlington 19
- Suffolk city 9
- Norfolk city 7
- Hampton city 6
- Richmond city 6
- Roanoke city 5
- Hanover 3
- Chesapeake city 1
- Lynchburg city 1
- Prince William 1
state 1
- Virginia · 85 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2258478 | 2258478 | 2022-02-27 | Hanover | Virginia | 51085 | 21173 | 256 |
2255227 | 2255227 | 2022-02-26 | Hanover | Virginia | 51085 | 21173 | 256 |
2251976 | 2251976 | 2022-02-25 | Hanover | Virginia | 51085 | 21173 | 256 |
2222734 | 2222734 | 2022-02-16 | Lynchburg city | Virginia | 51680 | 19095 | 256 |
2144686 | 2144686 | 2022-01-23 | Portsmouth city | Virginia | 51740 | 19014 | 256 |
2144709 | 2144709 | 2022-01-23 | Suffolk city | Virginia | 51800 | 16900 | 256 |
2141431 | 2141431 | 2022-01-22 | Portsmouth city | Virginia | 51740 | 19014 | 256 |
2141454 | 2141454 | 2022-01-22 | Suffolk city | Virginia | 51800 | 16900 | 256 |
2138175 | 2138175 | 2022-01-21 | Portsmouth city | Virginia | 51740 | 19014 | 256 |
2138198 | 2138198 | 2022-01-21 | Suffolk city | Virginia | 51800 | 16900 | 256 |
2134921 | 2134921 | 2022-01-20 | Portsmouth city | Virginia | 51740 | 18841 | 256 |
2134944 | 2134944 | 2022-01-20 | Suffolk city | Virginia | 51800 | 16679 | 256 |
2131669 | 2131669 | 2022-01-19 | Portsmouth city | Virginia | 51740 | 18674 | 256 |
2131692 | 2131692 | 2022-01-19 | Suffolk city | Virginia | 51800 | 16438 | 256 |
2128415 | 2128415 | 2022-01-18 | Portsmouth city | Virginia | 51740 | 18517 | 256 |
2128438 | 2128438 | 2022-01-18 | Suffolk city | Virginia | 51800 | 16187 | 256 |
2125162 | 2125162 | 2022-01-17 | Portsmouth city | Virginia | 51740 | 18398 | 256 |
2125185 | 2125185 | 2022-01-17 | Suffolk city | Virginia | 51800 | 16029 | 256 |
2121910 | 2121910 | 2022-01-16 | Portsmouth city | Virginia | 51740 | 17830 | 256 |
2118658 | 2118658 | 2022-01-15 | Portsmouth city | Virginia | 51740 | 17830 | 256 |
2115406 | 2115406 | 2022-01-14 | Portsmouth city | Virginia | 51740 | 17830 | 256 |
2112154 | 2112154 | 2022-01-13 | Portsmouth city | Virginia | 51740 | 17624 | 256 |
2108902 | 2108902 | 2022-01-12 | Portsmouth city | Virginia | 51740 | 17331 | 256 |
2105651 | 2105651 | 2022-01-11 | Portsmouth city | Virginia | 51740 | 17113 | 256 |
2102400 | 2102400 | 2022-01-10 | Portsmouth city | Virginia | 51740 | 16881 | 256 |
2099149 | 2099149 | 2022-01-09 | Portsmouth city | Virginia | 51740 | 16100 | 256 |
2095898 | 2095898 | 2022-01-08 | Portsmouth city | Virginia | 51740 | 16100 | 256 |
2092646 | 2092646 | 2022-01-07 | Portsmouth city | Virginia | 51740 | 16100 | 256 |
2089394 | 2089394 | 2022-01-06 | Portsmouth city | Virginia | 51740 | 15814 | 256 |
2086143 | 2086143 | 2022-01-05 | Portsmouth city | Virginia | 51740 | 15506 | 256 |
2082891 | 2082891 | 2022-01-04 | Portsmouth city | Virginia | 51740 | 15339 | 256 |
2079639 | 2079639 | 2022-01-03 | Portsmouth city | Virginia | 51740 | 15062 | 256 |
2076346 | 2076346 | 2022-01-02 | Hampton city | Virginia | 51650 | 17525 | 256 |
2076387 | 2076387 | 2022-01-02 | Portsmouth city | Virginia | 51740 | 14523 | 256 |
2073095 | 2073095 | 2022-01-01 | Hampton city | Virginia | 51650 | 17525 | 256 |
2073136 | 2073136 | 2022-01-01 | Portsmouth city | Virginia | 51740 | 14523 | 256 |
2069844 | 2069844 | 2021-12-31 | Hampton city | Virginia | 51650 | 17525 | 256 |
2069885 | 2069885 | 2021-12-31 | Portsmouth city | Virginia | 51740 | 14523 | 256 |
2066593 | 2066593 | 2021-12-30 | Hampton city | Virginia | 51650 | 17229 | 256 |
2066634 | 2066634 | 2021-12-30 | Portsmouth city | Virginia | 51740 | 14265 | 256 |
2063343 | 2063343 | 2021-12-29 | Hampton city | Virginia | 51650 | 16979 | 256 |
2063384 | 2063384 | 2021-12-29 | Portsmouth city | Virginia | 51740 | 14089 | 256 |
2060093 | 2060093 | 2021-12-28 | Hampton city | Virginia | 51650 | 16746 | 256 |
2060134 | 2060134 | 2021-12-28 | Portsmouth city | Virginia | 51740 | 13893 | 256 |
2060157 | 2060157 | 2021-12-28 | Suffolk city | Virginia | 51800 | 12070 | 256 |
2056908 | 2056908 | 2021-12-27 | Suffolk city | Virginia | 51800 | 12019 | 256 |
1962636 | 1962636 | 2021-11-28 | Roanoke city | Virginia | 51770 | 12787 | 256 |
1959385 | 1959385 | 2021-11-27 | Roanoke city | Virginia | 51770 | 12787 | 256 |
1956134 | 1956134 | 2021-11-26 | Roanoke city | Virginia | 51770 | 12787 | 256 |
1952883 | 1952883 | 2021-11-25 | Roanoke city | Virginia | 51770 | 12762 | 256 |
1949632 | 1949632 | 2021-11-24 | Roanoke city | Virginia | 51770 | 12718 | 256 |
1394096 | 1394096 | 2021-06-06 | Arlington | Virginia | 51013 | 15293 | 256 |
1390851 | 1390851 | 2021-06-05 | Arlington | Virginia | 51013 | 15293 | 256 |
1387606 | 1387606 | 2021-06-04 | Arlington | Virginia | 51013 | 15293 | 256 |
1384361 | 1384361 | 2021-06-03 | Arlington | Virginia | 51013 | 15294 | 256 |
1381115 | 1381115 | 2021-06-02 | Arlington | Virginia | 51013 | 15291 | 256 |
1377870 | 1377870 | 2021-06-01 | Arlington | Virginia | 51013 | 15292 | 256 |
1374624 | 1374624 | 2021-05-31 | Arlington | Virginia | 51013 | 15291 | 256 |
1371379 | 1371379 | 2021-05-30 | Arlington | Virginia | 51013 | 15293 | 256 |
1368133 | 1368133 | 2021-05-29 | Arlington | Virginia | 51013 | 15290 | 256 |
1364887 | 1364887 | 2021-05-28 | Arlington | Virginia | 51013 | 15288 | 256 |
1361641 | 1361641 | 2021-05-27 | Arlington | Virginia | 51013 | 15282 | 256 |
1358395 | 1358395 | 2021-05-26 | Arlington | Virginia | 51013 | 15284 | 256 |
1355149 | 1355149 | 2021-05-25 | Arlington | Virginia | 51013 | 15287 | 256 |
1351903 | 1351903 | 2021-05-24 | Arlington | Virginia | 51013 | 15287 | 256 |
1348657 | 1348657 | 2021-05-23 | Arlington | Virginia | 51013 | 15289 | 256 |
1345409 | 1345409 | 2021-05-22 | Arlington | Virginia | 51013 | 15289 | 256 |
1342161 | 1342161 | 2021-05-21 | Arlington | Virginia | 51013 | 15285 | 256 |
1338913 | 1338913 | 2021-05-20 | Arlington | Virginia | 51013 | 15284 | 256 |
1335666 | 1335666 | 2021-05-19 | Arlington | Virginia | 51013 | 15279 | 256 |
1316264 | 1316264 | 2021-05-13 | Norfolk city | Virginia | 51710 | 17635 | 256 |
1313018 | 1313018 | 2021-05-12 | Norfolk city | Virginia | 51710 | 17609 | 256 |
1309771 | 1309771 | 2021-05-11 | Norfolk city | Virginia | 51710 | 17594 | 256 |
1306525 | 1306525 | 2021-05-10 | Norfolk city | Virginia | 51710 | 17566 | 256 |
1303279 | 1303279 | 2021-05-09 | Norfolk city | Virginia | 51710 | 17562 | 256 |
1300032 | 1300032 | 2021-05-08 | Norfolk city | Virginia | 51710 | 17543 | 256 |
1296785 | 1296785 | 2021-05-07 | Norfolk city | Virginia | 51710 | 17521 | 256 |
1254598 | 1254598 | 2021-04-24 | Richmond city | Virginia | 51760 | 16638 | 256 |
1251351 | 1251351 | 2021-04-23 | Richmond city | Virginia | 51760 | 16626 | 256 |
1248104 | 1248104 | 2021-04-22 | Richmond city | Virginia | 51760 | 16592 | 256 |
1244857 | 1244857 | 2021-04-21 | Richmond city | Virginia | 51760 | 16549 | 256 |
1238363 | 1238363 | 2021-04-19 | Richmond city | Virginia | 51760 | 16504 | 256 |
1235116 | 1235116 | 2021-04-18 | Richmond city | Virginia | 51760 | 16466 | 256 |
1121373 | 1121373 | 2021-03-14 | Chesapeake city | Virginia | 51550 | 18805 | 256 |
881271 | 881271 | 2020-12-30 | Prince William | Virginia | 51153 | 25247 | 256 |
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);