ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 139 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Amelia 3
- Cumberland 3
- Fluvanna 3
- Augusta 2
- Fairfax city 2
- Goochland 2
- Mathews 2
- Middlesex 2
- Wythe 2
- Albemarle 1
- Bath 1
- Botetourt 1
- Buena Vista city 1
- Charles City 1
- Charlottesville city 1
- Clarke 1
- Colonial Heights city 1
- Falls Church city 1
- Floyd 1
- James City 1
- King and Queen 1
- Lynchburg city 1
- Madison 1
- Manassas Park city 1
- New Kent 1
- Northampton 1
- Northumberland 1
- Pittsylvania 1
- Rappahannock 1
- Richmond city 1
- …
state 1
- Virginia · 45 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
877935 | 877935 | 2020-12-29 | Bath | Virginia | 51017 | 139 | 0 |
855314 | 855314 | 2020-12-22 | Rappahannock | Virginia | 51157 | 139 | 2 |
842296 | 842296 | 2020-12-18 | King and Queen | Virginia | 51097 | 139 | 2 |
826039 | 826039 | 2020-12-13 | Falls Church city | Virginia | 51610 | 139 | 6 |
770852 | 770852 | 2020-11-26 | Charles City | Virginia | 51036 | 139 | 6 |
748142 | 748142 | 2020-11-19 | Cumberland | Virginia | 51049 | 139 | 4 |
744896 | 744896 | 2020-11-18 | Cumberland | Virginia | 51049 | 139 | 4 |
741649 | 741649 | 2020-11-17 | Cumberland | Virginia | 51049 | 139 | 4 |
715690 | 715690 | 2020-11-09 | Clarke | Virginia | 51043 | 139 | 2 |
709193 | 709193 | 2020-11-07 | Buena Vista city | Virginia | 51530 | 139 | 1 |
702767 | 702767 | 2020-11-05 | Mathews | Virginia | 51115 | 139 | 0 |
699524 | 699524 | 2020-11-04 | Mathews | Virginia | 51115 | 139 | 0 |
686545 | 686545 | 2020-10-31 | Madison | Virginia | 51113 | 139 | 3 |
657285 | 657285 | 2020-10-22 | Amelia | Virginia | 51007 | 139 | 6 |
654040 | 654040 | 2020-10-21 | Amelia | Virginia | 51007 | 139 | 6 |
650795 | 650795 | 2020-10-20 | Amelia | Virginia | 51007 | 139 | 6 |
644381 | 644381 | 2020-10-18 | Middlesex | Virginia | 51119 | 139 | 11 |
641133 | 641133 | 2020-10-17 | Middlesex | Virginia | 51119 | 139 | 11 |
602171 | 602171 | 2020-10-05 | Fairfax city | Virginia | 51600 | 139 | 8 |
598928 | 598928 | 2020-10-04 | Fairfax city | Virginia | 51600 | 139 | 8 |
547133 | 547133 | 2020-09-18 | Northumberland | Virginia | 51133 | 139 | 5 |
472691 | 472691 | 2020-08-26 | Floyd | Virginia | 51063 | 139 | 2 |
466320 | 466320 | 2020-08-24 | Wythe | Virginia | 51197 | 139 | 3 |
463091 | 463091 | 2020-08-23 | Wythe | Virginia | 51197 | 139 | 3 |
459814 | 459814 | 2020-08-22 | New Kent | Virginia | 51127 | 139 | 1 |
450176 | 450176 | 2020-08-19 | Williamsburg city | Virginia | 51830 | 139 | 6 |
398593 | 398593 | 2020-08-03 | Salem city | Virginia | 51775 | 139 | 3 |
382516 | 382516 | 2020-07-29 | Staunton city | Virginia | 51790 | 139 | 0 |
353560 | 353560 | 2020-07-20 | Goochland | Virginia | 51075 | 139 | 6 |
350358 | 350358 | 2020-07-19 | Goochland | Virginia | 51075 | 139 | 6 |
340750 | 340750 | 2020-07-16 | Fluvanna | Virginia | 51065 | 139 | 8 |
337554 | 337554 | 2020-07-15 | Fluvanna | Virginia | 51065 | 139 | 8 |
334359 | 334359 | 2020-07-14 | Fluvanna | Virginia | 51065 | 139 | 8 |
312139 | 312139 | 2020-07-07 | Pittsylvania | Virginia | 51143 | 139 | 1 |
308888 | 308888 | 2020-07-06 | Botetourt | Virginia | 51023 | 139 | 4 |
286833 | 286833 | 2020-06-29 | Lynchburg city | Virginia | 51680 | 139 | 1 |
271059 | 271059 | 2020-06-24 | Colonial Heights city | Virginia | 51570 | 139 | 17 |
230507 | 230507 | 2020-06-11 | Augusta | Virginia | 51015 | 139 | 2 |
227403 | 227403 | 2020-06-10 | Augusta | Virginia | 51015 | 139 | 2 |
221220 | 221220 | 2020-06-08 | Charlottesville city | Virginia | 51540 | 139 | 3 |
156938 | 156938 | 2020-05-18 | Albemarle | Virginia | 51003 | 139 | 4 |
138976 | 138976 | 2020-05-12 | Manassas Park city | Virginia | 51685 | 139 | 3 |
115137 | 115137 | 2020-05-04 | Northampton | Virginia | 51131 | 139 | 1 |
69886 | 69886 | 2020-04-18 | James City | Virginia | 51095 | 139 | 3 |
48234 | 48234 | 2020-04-10 | Richmond city | Virginia | 51760 | 139 | 2 |
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);