ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 524 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 23
county 23
- Charles City 7
- Cumberland 3
- Falls Church city 3
- Page 3
- Surry 3
- Williamsburg city 3
- Franklin city 2
- Grayson 2
- Accomack 1
- Dickenson 1
- Fairfax city 1
- Frederick 1
- Fredericksburg city 1
- Galax city 1
- Gloucester 1
- Goochland 1
- Greene 1
- Mathews 1
- Middlesex 1
- Northumberland 1
- Nottoway 1
- Patrick 1
- Spotsylvania 1
state 1
- Virginia · 41 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1790338 | 1790338 | 2021-10-06 | Falls Church city | Virginia | 51610 | 524 | 8 |
1787090 | 1787090 | 2021-10-05 | Falls Church city | Virginia | 51610 | 524 | 8 |
1783841 | 1783841 | 2021-10-04 | Falls Church city | Virginia | 51610 | 524 | 8 |
1699452 | 1699452 | 2021-09-08 | Surry | Virginia | 51181 | 524 | 9 |
1696204 | 1696204 | 2021-09-07 | Surry | Virginia | 51181 | 524 | 9 |
1692956 | 1692956 | 2021-09-06 | Surry | Virginia | 51181 | 524 | 9 |
1575909 | 1575909 | 2021-08-01 | Charles City | Virginia | 51036 | 524 | 16 |
1572661 | 1572661 | 2021-07-31 | Charles City | Virginia | 51036 | 524 | 16 |
1569413 | 1569413 | 2021-07-30 | Charles City | Virginia | 51036 | 524 | 16 |
1566165 | 1566165 | 2021-07-29 | Charles City | Virginia | 51036 | 524 | 16 |
1562917 | 1562917 | 2021-07-28 | Charles City | Virginia | 51036 | 524 | 16 |
1559669 | 1559669 | 2021-07-27 | Charles City | Virginia | 51036 | 524 | 16 |
1556422 | 1556422 | 2021-07-26 | Charles City | Virginia | 51036 | 524 | 16 |
1553185 | 1553185 | 2021-07-25 | Cumberland | Virginia | 51049 | 524 | 10 |
1549938 | 1549938 | 2021-07-24 | Cumberland | Virginia | 51049 | 524 | 10 |
1546691 | 1546691 | 2021-07-23 | Cumberland | Virginia | 51049 | 524 | 10 |
1183081 | 1183081 | 2021-04-02 | Fairfax city | Virginia | 51600 | 524 | 18 |
1085720 | 1085720 | 2021-03-03 | Middlesex | Virginia | 51119 | 524 | 18 |
1079276 | 1079276 | 2021-03-01 | Williamsburg city | Virginia | 51830 | 524 | 9 |
1076031 | 1076031 | 2021-02-28 | Williamsburg city | Virginia | 51830 | 524 | 9 |
1072785 | 1072785 | 2021-02-27 | Williamsburg city | Virginia | 51830 | 524 | 9 |
1050015 | 1050015 | 2021-02-20 | Mathews | Virginia | 51115 | 524 | 8 |
942919 | 942919 | 2021-01-18 | Northumberland | Virginia | 51133 | 524 | 11 |
877978 | 877978 | 2020-12-29 | Greene | Virginia | 51079 | 524 | 4 |
842280 | 842280 | 2020-12-18 | Goochland | Virginia | 51075 | 524 | 7 |
839018 | 839018 | 2020-12-17 | Dickenson | Virginia | 51051 | 524 | 4 |
806618 | 806618 | 2020-12-07 | Patrick | Virginia | 51141 | 524 | 28 |
793595 | 793595 | 2020-12-03 | Gloucester | Virginia | 51073 | 524 | 3 |
793635 | 793635 | 2020-12-03 | Nottoway | Virginia | 51135 | 524 | 23 |
783863 | 783863 | 2020-11-30 | Grayson | Virginia | 51077 | 524 | 22 |
780618 | 780618 | 2020-11-29 | Grayson | Virginia | 51077 | 524 | 22 |
754650 | 754650 | 2020-11-21 | Galax city | Virginia | 51640 | 524 | 30 |
735218 | 735218 | 2020-11-15 | Page | Virginia | 51139 | 524 | 31 |
731972 | 731972 | 2020-11-14 | Page | Virginia | 51139 | 524 | 31 |
728680 | 728680 | 2020-11-13 | Franklin city | Virginia | 51620 | 524 | 15 |
728727 | 728727 | 2020-11-13 | Page | Virginia | 51139 | 524 | 31 |
725437 | 725437 | 2020-11-12 | Franklin city | Virginia | 51620 | 524 | 15 |
547092 | 547092 | 2020-09-18 | Fredericksburg city | Virginia | 51630 | 524 | 5 |
312090 | 312090 | 2020-07-07 | Frederick | Virginia | 51069 | 524 | 6 |
193578 | 193578 | 2020-05-30 | Spotsylvania | Virginia | 51177 | 524 | 7 |
135913 | 135913 | 2020-05-11 | Accomack | Virginia | 51001 | 524 | 7 |
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);