ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where cases = 223 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Westmoreland 5
- Lancaster 3
- Norton city 3
- Bristol city 2
- Dinwiddie 2
- Fairfax city 2
- Fluvanna 2
- Greene 2
- Scott 2
- Accomack 1
- Amherst 1
- Botetourt 1
- Caroline 1
- Craig 1
- Cumberland 1
- Dickenson 1
- Essex 1
- Fauquier 1
- Floyd 1
- Frederick 1
- Fredericksburg city 1
- Galax city 1
- Giles 1
- Gloucester 1
- Highland 1
- Lexington city 1
- Louisa 1
- Manassas Park city 1
- Patrick 1
- Powhatan 1
- …
state 1
- Virginia · 50 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2043850 | 2043850 | 2021-12-23 | Highland | Virginia | 51091 | 223 | 4 |
1004529 | 1004529 | 2021-02-06 | Craig | Virginia | 51045 | 223 | 3 |
955903 | 955903 | 2021-01-22 | Norton city | Virginia | 51720 | 223 | 2 |
942920 | 942920 | 2021-01-18 | Norton city | Virginia | 51720 | 223 | 3 |
939675 | 939675 | 2021-01-17 | Norton city | Virginia | 51720 | 223 | 3 |
916902 | 916902 | 2021-01-10 | Cumberland | Virginia | 51049 | 223 | 4 |
803319 | 803319 | 2020-12-06 | Fairfax city | Virginia | 51600 | 223 | 9 |
800074 | 800074 | 2020-12-05 | Fairfax city | Virginia | 51600 | 223 | 9 |
757958 | 757958 | 2020-11-22 | Rockbridge | Virginia | 51163 | 223 | 2 |
751393 | 751393 | 2020-11-20 | Essex | Virginia | 51057 | 223 | 2 |
751405 | 751405 | 2020-11-20 | Giles | Virginia | 51071 | 223 | 0 |
748178 | 748178 | 2020-11-19 | Lancaster | Virginia | 51103 | 223 | 1 |
744898 | 744898 | 2020-11-18 | Dickenson | Virginia | 51051 | 223 | 1 |
744932 | 744932 | 2020-11-18 | Lancaster | Virginia | 51103 | 223 | 1 |
741685 | 741685 | 2020-11-17 | Lancaster | Virginia | 51103 | 223 | 1 |
686599 | 686599 | 2020-10-31 | Williamsburg city | Virginia | 51830 | 223 | 8 |
663838 | 663838 | 2020-10-24 | Lexington city | Virginia | 51678 | 223 | 1 |
634574 | 634574 | 2020-10-15 | Bristol city | Virginia | 51520 | 223 | 7 |
631329 | 631329 | 2020-10-14 | Bristol city | Virginia | 51520 | 223 | 7 |
624941 | 624941 | 2020-10-12 | Scott | Virginia | 51169 | 223 | 4 |
621698 | 621698 | 2020-10-11 | Scott | Virginia | 51169 | 223 | 4 |
618384 | 618384 | 2020-10-10 | Floyd | Virginia | 51063 | 223 | 16 |
589217 | 589217 | 2020-10-01 | Greene | Virginia | 51079 | 223 | 3 |
585976 | 585976 | 2020-09-30 | Greene | Virginia | 51079 | 223 | 3 |
579542 | 579542 | 2020-09-28 | Powhatan | Virginia | 51145 | 223 | 5 |
560128 | 560128 | 2020-09-22 | Wythe | Virginia | 51197 | 223 | 4 |
543927 | 543927 | 2020-09-17 | Staunton city | Virginia | 51790 | 223 | 0 |
530914 | 530914 | 2020-09-13 | Gloucester | Virginia | 51073 | 223 | 2 |
521278 | 521278 | 2020-09-10 | Tazewell | Virginia | 51185 | 223 | 2 |
488945 | 488945 | 2020-08-31 | Westmoreland | Virginia | 51193 | 223 | 3 |
485712 | 485712 | 2020-08-30 | Westmoreland | Virginia | 51193 | 223 | 3 |
482392 | 482392 | 2020-08-29 | Fluvanna | Virginia | 51065 | 223 | 9 |
482442 | 482442 | 2020-08-29 | Patrick | Virginia | 51141 | 223 | 11 |
482477 | 482477 | 2020-08-29 | Westmoreland | Virginia | 51193 | 223 | 3 |
479243 | 479243 | 2020-08-28 | Westmoreland | Virginia | 51193 | 223 | 3 |
475925 | 475925 | 2020-08-27 | Fluvanna | Virginia | 51065 | 223 | 9 |
476010 | 476010 | 2020-08-27 | Westmoreland | Virginia | 51193 | 223 | 3 |
472752 | 472752 | 2020-08-26 | Radford city | Virginia | 51750 | 223 | 0 |
453347 | 453347 | 2020-08-20 | Louisa | Virginia | 51109 | 223 | 2 |
446825 | 446825 | 2020-08-18 | Amherst | Virginia | 51009 | 223 | 1 |
443605 | 443605 | 2020-08-17 | Botetourt | Virginia | 51023 | 223 | 7 |
433934 | 433934 | 2020-08-14 | Caroline | Virginia | 51033 | 223 | 5 |
427496 | 427496 | 2020-08-12 | Dinwiddie | Virginia | 51053 | 223 | 7 |
424272 | 424272 | 2020-08-11 | Dinwiddie | Virginia | 51053 | 223 | 7 |
261687 | 261687 | 2020-06-21 | Galax city | Virginia | 51640 | 223 | 11 |
258559 | 258559 | 2020-06-20 | Fredericksburg city | Virginia | 51630 | 223 | 0 |
166090 | 166090 | 2020-05-21 | Manassas Park city | Virginia | 51685 | 223 | 3 |
160003 | 160003 | 2020-05-19 | Frederick | Virginia | 51069 | 223 | 3 |
156974 | 156974 | 2020-05-18 | Fauquier | Virginia | 51061 | 223 | 5 |
97860 | 97860 | 2020-04-28 | Accomack | Virginia | 51001 | 223 | 4 |
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);