ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 667 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 27
county 27
- Emporia city 9
- Sussex 5
- Covington city 3
- King and Queen 3
- Salem city 2
- Bland 1
- Campbell 1
- Dickenson 1
- Essex 1
- Fauquier 1
- Floyd 1
- Galax city 1
- Hopewell city 1
- James City 1
- King William 1
- Lancaster 1
- Manassas Park city 1
- Martinsville city 1
- Mathews 1
- Middlesex 1
- Northampton 1
- Patrick 1
- Poquoson city 1
- Rappahannock 1
- Roanoke 1
- Shenandoah 1
- Westmoreland 1
state 1
- Virginia · 44 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2017890 | 2017890 | 2021-12-15 | Rappahannock | Virginia | 51157 | 667 | 6 |
1962595 | 1962595 | 2021-11-28 | King and Queen | Virginia | 51097 | 667 | 8 |
1959344 | 1959344 | 2021-11-27 | King and Queen | Virginia | 51097 | 667 | 8 |
1956093 | 1956093 | 2021-11-26 | King and Queen | Virginia | 51097 | 667 | 8 |
1712353 | 1712353 | 2021-09-12 | Covington city | Virginia | 51580 | 667 | 14 |
1709106 | 1709106 | 2021-09-11 | Covington city | Virginia | 51580 | 667 | 14 |
1705859 | 1705859 | 2021-09-10 | Covington city | Virginia | 51580 | 667 | 14 |
1673421 | 1673421 | 2021-08-31 | Middlesex | Virginia | 51119 | 667 | 23 |
1647437 | 1647437 | 2021-08-23 | Mathews | Virginia | 51115 | 667 | 14 |
1270739 | 1270739 | 2021-04-29 | Bland | Virginia | 51021 | 667 | 10 |
1270763 | 1270763 | 2021-04-29 | Emporia city | Virginia | 51595 | 667 | 42 |
1267516 | 1267516 | 2021-04-28 | Emporia city | Virginia | 51595 | 667 | 42 |
1264269 | 1264269 | 2021-04-27 | Emporia city | Virginia | 51595 | 667 | 42 |
1261022 | 1261022 | 2021-04-26 | Emporia city | Virginia | 51595 | 667 | 42 |
1257775 | 1257775 | 2021-04-25 | Emporia city | Virginia | 51595 | 667 | 42 |
1254528 | 1254528 | 2021-04-24 | Emporia city | Virginia | 51595 | 667 | 42 |
1251281 | 1251281 | 2021-04-23 | Emporia city | Virginia | 51595 | 667 | 42 |
1248034 | 1248034 | 2021-04-22 | Emporia city | Virginia | 51595 | 667 | 42 |
1244787 | 1244787 | 2021-04-21 | Emporia city | Virginia | 51595 | 667 | 42 |
1134372 | 1134372 | 2021-03-18 | Essex | Virginia | 51057 | 667 | 8 |
1085707 | 1085707 | 2021-03-03 | Lancaster | Virginia | 51103 | 667 | 13 |
1024067 | 1024067 | 2021-02-12 | Poquoson city | Virginia | 51735 | 667 | 10 |
1017568 | 1017568 | 2021-02-10 | Northampton | Virginia | 51131 | 667 | 33 |
968836 | 968836 | 2021-01-26 | Floyd | Virginia | 51063 | 667 | 18 |
965616 | 965616 | 2021-01-25 | King William | Virginia | 51101 | 667 | 5 |
897433 | 897433 | 2021-01-04 | Dickenson | Virginia | 51051 | 667 | 6 |
865073 | 865073 | 2020-12-25 | Westmoreland | Virginia | 51193 | 667 | 9 |
852058 | 852058 | 2020-12-21 | Patrick | Virginia | 51141 | 667 | 28 |
842351 | 842351 | 2020-12-18 | Sussex | Virginia | 51183 | 667 | 13 |
835860 | 835860 | 2020-12-16 | Sussex | Virginia | 51183 | 667 | 13 |
826047 | 826047 | 2020-12-13 | Galax city | Virginia | 51640 | 667 | 30 |
806587 | 806587 | 2020-12-07 | Hopewell city | Virginia | 51670 | 667 | 9 |
777442 | 777442 | 2020-11-28 | Sussex | Virginia | 51183 | 667 | 13 |
774197 | 774197 | 2020-11-27 | Sussex | Virginia | 51183 | 667 | 13 |
770952 | 770952 | 2020-11-26 | Sussex | Virginia | 51183 | 667 | 13 |
767662 | 767662 | 2020-11-25 | Martinsville city | Virginia | 51690 | 667 | 24 |
715775 | 715775 | 2020-11-09 | Salem city | Virginia | 51775 | 667 | 12 |
709251 | 709251 | 2020-11-07 | Manassas Park city | Virginia | 51685 | 667 | 8 |
709287 | 709287 | 2020-11-07 | Salem city | Virginia | 51775 | 667 | 12 |
657299 | 657299 | 2020-10-22 | Campbell | Virginia | 51031 | 667 | 8 |
518025 | 518025 | 2020-09-09 | Roanoke | Virginia | 51161 | 667 | 5 |
456544 | 456544 | 2020-08-21 | Fauquier | Virginia | 51061 | 667 | 9 |
456567 | 456567 | 2020-08-21 | James City | Virginia | 51095 | 667 | 17 |
388946 | 388946 | 2020-07-31 | Shenandoah | Virginia | 51171 | 667 | 42 |
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);