ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where cases = 55 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
- Falls Church city 14
- Middlesex 8
- Greensville 6
- Dickenson 5
- Lunenburg 4
- Northumberland 4
- Williamsburg city 4
- Alleghany 3
- Appomattox 3
- Greene 3
- Prince Edward 3
- Augusta 2
- Buckingham 2
- Charlotte 2
- Goochland 2
- Louisa 2
- Pulaski 2
- York 2
- Amelia 1
- Botetourt 1
- Caroline 1
- Charles City 1
- Clarke 1
- Danville city 1
- Dinwiddie 1
- Emporia city 1
- Franklin city 1
- Fredericksburg city 1
- Galax city 1
- Grayson 1
- …
state 1
- Virginia · 93 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
865006 | 865006 | 2020-12-25 | Highland | Virginia | 51091 | 55 | 0 |
498598 | 498598 | 2020-09-03 | Middlesex | Virginia | 51119 | 55 | 1 |
495365 | 495365 | 2020-09-02 | Middlesex | Virginia | 51119 | 55 | 1 |
492131 | 492131 | 2020-09-01 | Middlesex | Virginia | 51119 | 55 | 1 |
488898 | 488898 | 2020-08-31 | Middlesex | Virginia | 51119 | 55 | 1 |
485665 | 485665 | 2020-08-30 | Middlesex | Virginia | 51119 | 55 | 1 |
482430 | 482430 | 2020-08-29 | Middlesex | Virginia | 51119 | 55 | 1 |
479196 | 479196 | 2020-08-28 | Middlesex | Virginia | 51119 | 55 | 1 |
475963 | 475963 | 2020-08-27 | Middlesex | Virginia | 51119 | 55 | 1 |
466222 | 466222 | 2020-08-24 | Dickenson | Virginia | 51051 | 55 | 1 |
462993 | 462993 | 2020-08-23 | Dickenson | Virginia | 51051 | 55 | 1 |
459764 | 459764 | 2020-08-22 | Dickenson | Virginia | 51051 | 55 | 1 |
456537 | 456537 | 2020-08-21 | Dickenson | Virginia | 51051 | 55 | 1 |
453309 | 453309 | 2020-08-20 | Dickenson | Virginia | 51051 | 55 | 1 |
440388 | 440388 | 2020-08-16 | Charles City | Virginia | 51036 | 55 | 5 |
430712 | 430712 | 2020-08-13 | Charlotte | Virginia | 51037 | 55 | 0 |
427484 | 427484 | 2020-08-12 | Charlotte | Virginia | 51037 | 55 | 0 |
398554 | 398554 | 2020-08-03 | Lunenburg | Virginia | 51111 | 55 | 1 |
395338 | 395338 | 2020-08-02 | Lunenburg | Virginia | 51111 | 55 | 1 |
392122 | 392122 | 2020-08-01 | Lunenburg | Virginia | 51111 | 55 | 1 |
388905 | 388905 | 2020-07-31 | Lunenburg | Virginia | 51111 | 55 | 1 |
376004 | 376004 | 2020-07-27 | Falls Church city | Virginia | 51610 | 55 | 6 |
372790 | 372790 | 2020-07-26 | Falls Church city | Virginia | 51610 | 55 | 6 |
369578 | 369578 | 2020-07-25 | Falls Church city | Virginia | 51610 | 55 | 6 |
366336 | 366336 | 2020-07-24 | Appomattox | Virginia | 51011 | 55 | 0 |
366369 | 366369 | 2020-07-24 | Falls Church city | Virginia | 51610 | 55 | 6 |
363130 | 363130 | 2020-07-23 | Appomattox | Virginia | 51011 | 55 | 0 |
363163 | 363163 | 2020-07-23 | Falls Church city | Virginia | 51610 | 55 | 6 |
363211 | 363211 | 2020-07-23 | Northumberland | Virginia | 51133 | 55 | 1 |
363246 | 363246 | 2020-07-23 | Tazewell | Virginia | 51185 | 55 | 0 |
359924 | 359924 | 2020-07-22 | Appomattox | Virginia | 51011 | 55 | 0 |
360005 | 360005 | 2020-07-22 | Northumberland | Virginia | 51133 | 55 | 1 |
356716 | 356716 | 2020-07-21 | Alleghany | Virginia | 51005 | 55 | 2 |
356800 | 356800 | 2020-07-21 | Northumberland | Virginia | 51133 | 55 | 1 |
353513 | 353513 | 2020-07-20 | Alleghany | Virginia | 51005 | 55 | 2 |
353549 | 353549 | 2020-07-20 | Falls Church city | Virginia | 51610 | 55 | 7 |
353597 | 353597 | 2020-07-20 | Northumberland | Virginia | 51133 | 55 | 1 |
350311 | 350311 | 2020-07-19 | Alleghany | Virginia | 51005 | 55 | 2 |
337516 | 337516 | 2020-07-15 | Amelia | Virginia | 51007 | 55 | 1 |
337613 | 337613 | 2020-07-15 | Pulaski | Virginia | 51155 | 55 | 2 |
334418 | 334418 | 2020-07-14 | Pulaski | Virginia | 51155 | 55 | 2 |
308915 | 308915 | 2020-07-06 | Falls Church city | Virginia | 51610 | 55 | 8 |
308920 | 308920 | 2020-07-06 | Franklin city | Virginia | 51620 | 55 | 2 |
305747 | 305747 | 2020-07-05 | Falls Church city | Virginia | 51610 | 55 | 8 |
302570 | 302570 | 2020-07-04 | Clarke | Virginia | 51043 | 55 | 0 |
283742 | 283742 | 2020-06-28 | Williamsburg city | Virginia | 51830 | 55 | 6 |
280596 | 280596 | 2020-06-27 | Williamsburg city | Virginia | 51830 | 55 | 6 |
277403 | 277403 | 2020-06-26 | New Kent | Virginia | 51127 | 55 | 1 |
277448 | 277448 | 2020-06-26 | Williamsburg city | Virginia | 51830 | 55 | 6 |
274300 | 274300 | 2020-06-25 | Williamsburg city | Virginia | 51830 | 55 | 6 |
271084 | 271084 | 2020-06-24 | Greene | Virginia | 51079 | 55 | 1 |
267950 | 267950 | 2020-06-23 | Greene | Virginia | 51079 | 55 | 1 |
264821 | 264821 | 2020-06-22 | Greene | Virginia | 51079 | 55 | 1 |
255398 | 255398 | 2020-06-19 | Botetourt | Virginia | 51023 | 55 | 4 |
252364 | 252364 | 2020-06-18 | Powhatan | Virginia | 51145 | 55 | 0 |
246166 | 246166 | 2020-06-16 | Waynesboro city | Virginia | 51820 | 55 | 0 |
230614 | 230614 | 2020-06-11 | Staunton city | Virginia | 51790 | 55 | 0 |
224343 | 224343 | 2020-06-09 | Grayson | Virginia | 51077 | 55 | 1 |
205799 | 205799 | 2020-06-03 | Falls Church city | Virginia | 51610 | 55 | 8 |
202720 | 202720 | 2020-06-02 | Falls Church city | Virginia | 51610 | 55 | 8 |
199644 | 199644 | 2020-06-01 | Falls Church city | Virginia | 51610 | 55 | 8 |
196565 | 196565 | 2020-05-31 | Danville city | Virginia | 51590 | 55 | 2 |
196571 | 196571 | 2020-05-31 | Falls Church city | Virginia | 51610 | 55 | 8 |
193501 | 193501 | 2020-05-30 | Falls Church city | Virginia | 51610 | 55 | 8 |
190435 | 190435 | 2020-05-29 | Falls Church city | Virginia | 51610 | 55 | 8 |
184295 | 184295 | 2020-05-27 | Caroline | Virginia | 51033 | 55 | 2 |
181258 | 181258 | 2020-05-26 | Dinwiddie | Virginia | 51053 | 55 | 0 |
178233 | 178233 | 2020-05-25 | Greensville | Virginia | 51081 | 55 | 7 |
175188 | 175188 | 2020-05-24 | Greensville | Virginia | 51081 | 55 | 7 |
172145 | 172145 | 2020-05-23 | Greensville | Virginia | 51081 | 55 | 7 |
169104 | 169104 | 2020-05-22 | Greensville | Virginia | 51081 | 55 | 7 |
166068 | 166068 | 2020-05-21 | Greensville | Virginia | 51081 | 55 | 7 |
163039 | 163039 | 2020-05-20 | Greensville | Virginia | 51081 | 55 | 7 |
156969 | 156969 | 2020-05-18 | Emporia city | Virginia | 51595 | 55 | 3 |
135957 | 135957 | 2020-05-11 | Galax city | Virginia | 51640 | 55 | 0 |
132991 | 132991 | 2020-05-10 | Louisa | Virginia | 51109 | 55 | 0 |
130001 | 130001 | 2020-05-09 | Louisa | Virginia | 51109 | 55 | 0 |
130062 | 130062 | 2020-05-09 | York | Virginia | 51199 | 55 | 2 |
126952 | 126952 | 2020-05-08 | Augusta | Virginia | 51015 | 55 | 1 |
126986 | 126986 | 2020-05-08 | Fredericksburg city | Virginia | 51630 | 55 | 0 |
127072 | 127072 | 2020-05-08 | York | Virginia | 51199 | 55 | 2 |
123967 | 123967 | 2020-05-07 | Augusta | Virginia | 51015 | 55 | 1 |
115149 | 115149 | 2020-05-04 | Prince Edward | Virginia | 51147 | 55 | 2 |
112266 | 112266 | 2020-05-03 | Prince Edward | Virginia | 51147 | 55 | 2 |
109392 | 109392 | 2020-05-02 | Prince Edward | Virginia | 51147 | 55 | 2 |
100724 | 100724 | 2020-04-29 | Buckingham | Virginia | 51029 | 55 | 0 |
100787 | 100787 | 2020-04-29 | Montgomery | Virginia | 51121 | 55 | 1 |
97874 | 97874 | 2020-04-28 | Buckingham | Virginia | 51029 | 55 | 0 |
72645 | 72645 | 2020-04-19 | Goochland | Virginia | 51075 | 55 | 1 |
69875 | 69875 | 2020-04-18 | Goochland | Virginia | 51075 | 55 | 1 |
53543 | 53543 | 2020-04-12 | Mecklenburg | Virginia | 51117 | 55 | 0 |
32970 | 32970 | 2020-04-04 | Norfolk city | Virginia | 51710 | 55 | 1 |
15655 | 15655 | 2020-03-27 | James City | Virginia | 51095 | 55 | 3 |
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);