ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 1195 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 22
county 22
- Sussex 6
- Franklin city 3
- Lancaster 3
- Accomack 1
- Albemarle 1
- Amelia 1
- Bristol city 1
- Brunswick 1
- Buchanan 1
- Culpeper 1
- Fauquier 1
- Frederick 1
- Galax city 1
- Giles 1
- Hanover 1
- King William 1
- Loudoun 1
- Lunenburg 1
- Petersburg city 1
- Pittsylvania 1
- Salem city 1
- Westmoreland 1
state 1
- Virginia · 31 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2076358 | 2076358 | 2022-01-02 | Lancaster | Virginia | 51103 | 1195 | 24 |
2073107 | 2073107 | 2022-01-01 | Lancaster | Virginia | 51103 | 1195 | 24 |
2069856 | 2069856 | 2021-12-31 | Lancaster | Virginia | 51103 | 1195 | 24 |
1943095 | 1943095 | 2021-11-22 | Lunenburg | Virginia | 51111 | 1195 | 22 |
1725320 | 1725320 | 2021-09-16 | Amelia | Virginia | 51007 | 1195 | 38 |
1621415 | 1621415 | 2021-08-15 | Franklin city | Virginia | 51620 | 1195 | 33 |
1618167 | 1618167 | 2021-08-14 | Franklin city | Virginia | 51620 | 1195 | 33 |
1614919 | 1614919 | 2021-08-13 | Franklin city | Virginia | 51620 | 1195 | 33 |
1601927 | 1601927 | 2021-08-09 | Galax city | Virginia | 51640 | 1195 | 53 |
1361755 | 1361755 | 2021-05-27 | Sussex | Virginia | 51183 | 1195 | 21 |
1358509 | 1358509 | 2021-05-26 | Sussex | Virginia | 51183 | 1195 | 21 |
1355263 | 1355263 | 2021-05-25 | Sussex | Virginia | 51183 | 1195 | 21 |
1352017 | 1352017 | 2021-05-24 | Sussex | Virginia | 51183 | 1195 | 21 |
1348771 | 1348771 | 2021-05-23 | Sussex | Virginia | 51183 | 1195 | 21 |
1345523 | 1345523 | 2021-05-22 | Sussex | Virginia | 51183 | 1195 | 21 |
1277287 | 1277287 | 2021-05-01 | King William | Virginia | 51101 | 1195 | 11 |
1218820 | 1218820 | 2021-04-13 | Giles | Virginia | 51071 | 1195 | 18 |
1183170 | 1183170 | 2021-04-02 | Westmoreland | Virginia | 51193 | 1195 | 22 |
1075917 | 1075917 | 2021-02-28 | Brunswick | Virginia | 51025 | 1195 | 16 |
1007759 | 1007759 | 2021-02-07 | Bristol city | Virginia | 51520 | 1195 | 27 |
1001269 | 1001269 | 2021-02-05 | Buchanan | Virginia | 51027 | 1195 | 32 |
897511 | 897511 | 2021-01-04 | Salem city | Virginia | 51775 | 1195 | 28 |
813108 | 813108 | 2020-12-09 | Petersburg city | Virginia | 51730 | 1195 | 31 |
722190 | 722190 | 2020-11-11 | Fauquier | Virginia | 51061 | 1195 | 27 |
683273 | 683273 | 2020-10-30 | Frederick | Virginia | 51069 | 1195 | 14 |
641147 | 641147 | 2020-10-17 | Pittsylvania | Virginia | 51143 | 1195 | 12 |
631316 | 631316 | 2020-10-14 | Accomack | Virginia | 51001 | 1195 | 19 |
572990 | 572990 | 2020-09-26 | Culpeper | Virginia | 51047 | 1195 | 17 |
553525 | 553525 | 2020-09-20 | Albemarle | Virginia | 51003 | 1195 | 21 |
543865 | 543865 | 2020-09-17 | Hanover | Virginia | 51085 | 1195 | 35 |
135980 | 135980 | 2020-05-11 | Loudoun | Virginia | 51107 | 1195 | 30 |
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);