ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 246 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Bath 7
- Craig 5
- Buckingham 3
- Emporia city 2
- Fluvanna 2
- Fredericksburg city 2
- Lee 2
- Alleghany 1
- Amherst 1
- Augusta 1
- Botetourt 1
- Buchanan 1
- Cumberland 1
- Dickenson 1
- Dinwiddie 1
- Fairfax city 1
- Falls Church city 1
- Floyd 1
- Giles 1
- Hampton city 1
- Hanover 1
- King William 1
- Lancaster 1
- Lexington city 1
- Mecklenburg 1
- Middlesex 1
- Northumberland 1
- Norton city 1
- Page 1
- Patrick 1
- …
state 1
- Virginia · 54 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1137670 | 1137670 | 2021-03-19 | Norton city | Virginia | 51720 | 246 | 6 |
1134345 | 1134345 | 2021-03-18 | Bath | Virginia | 51017 | 246 | 11 |
1131097 | 1131097 | 2021-03-17 | Bath | Virginia | 51017 | 246 | 11 |
1127850 | 1127850 | 2021-03-16 | Bath | Virginia | 51017 | 246 | 11 |
1114884 | 1114884 | 2021-03-12 | Craig | Virginia | 51045 | 246 | 5 |
1111638 | 1111638 | 2021-03-11 | Craig | Virginia | 51045 | 246 | 5 |
1101880 | 1101880 | 2021-03-08 | Bath | Virginia | 51017 | 246 | 11 |
1101900 | 1101900 | 2021-03-08 | Craig | Virginia | 51045 | 246 | 6 |
1098634 | 1098634 | 2021-03-07 | Bath | Virginia | 51017 | 246 | 11 |
1098654 | 1098654 | 2021-03-07 | Craig | Virginia | 51045 | 246 | 6 |
1095386 | 1095386 | 2021-03-06 | Bath | Virginia | 51017 | 246 | 11 |
1095406 | 1095406 | 2021-03-06 | Craig | Virginia | 51045 | 246 | 6 |
1023981 | 1023981 | 2021-02-12 | Bath | Virginia | 51017 | 246 | 8 |
942871 | 942871 | 2021-01-18 | Falls Church city | Virginia | 51610 | 246 | 6 |
933128 | 933128 | 2021-01-15 | Cumberland | Virginia | 51049 | 246 | 4 |
881291 | 881291 | 2020-12-30 | Surry | Virginia | 51181 | 246 | 5 |
855291 | 855291 | 2020-12-22 | Middlesex | Virginia | 51119 | 246 | 11 |
835834 | 835834 | 2020-12-16 | Poquoson city | Virginia | 51735 | 246 | 3 |
832531 | 832531 | 2020-12-15 | Fairfax city | Virginia | 51600 | 246 | 10 |
800103 | 800103 | 2020-12-05 | Lancaster | Virginia | 51103 | 246 | 1 |
764388 | 764388 | 2020-11-24 | Giles | Virginia | 51071 | 246 | 0 |
761128 | 761128 | 2020-11-23 | Dickenson | Virginia | 51051 | 246 | 1 |
751444 | 751444 | 2020-11-20 | Northumberland | Virginia | 51133 | 246 | 8 |
741621 | 741621 | 2020-11-17 | Alleghany | Virginia | 51005 | 246 | 6 |
725458 | 725458 | 2020-11-12 | King William | Virginia | 51101 | 246 | 5 |
683297 | 683297 | 2020-10-30 | Lexington city | Virginia | 51678 | 246 | 1 |
673540 | 673540 | 2020-10-27 | Floyd | Virginia | 51063 | 246 | 15 |
660540 | 660540 | 2020-10-23 | Buchanan | Virginia | 51027 | 246 | 2 |
611961 | 611961 | 2020-10-08 | Pulaski | Virginia | 51155 | 246 | 5 |
566587 | 566587 | 2020-09-24 | Russell | Virginia | 51167 | 246 | 5 |
563354 | 563354 | 2020-09-23 | Staunton city | Virginia | 51790 | 246 | 0 |
553559 | 553559 | 2020-09-20 | Emporia city | Virginia | 51595 | 246 | 25 |
550320 | 550320 | 2020-09-19 | Emporia city | Virginia | 51595 | 246 | 25 |
530907 | 530907 | 2020-09-13 | Fluvanna | Virginia | 51065 | 246 | 9 |
530933 | 530933 | 2020-09-13 | Lee | Virginia | 51105 | 246 | 5 |
527670 | 527670 | 2020-09-12 | Fluvanna | Virginia | 51065 | 246 | 9 |
527696 | 527696 | 2020-09-12 | Lee | Virginia | 51105 | 246 | 5 |
521248 | 521248 | 2020-09-10 | Patrick | Virginia | 51141 | 246 | 13 |
482362 | 482362 | 2020-08-29 | Botetourt | Virginia | 51023 | 246 | 8 |
456509 | 456509 | 2020-08-21 | Amherst | Virginia | 51009 | 246 | 1 |
450082 | 450082 | 2020-08-19 | Dinwiddie | Virginia | 51053 | 246 | 7 |
385624 | 385624 | 2020-07-30 | Augusta | Virginia | 51015 | 246 | 4 |
369637 | 369637 | 2020-07-25 | Prince Edward | Virginia | 51147 | 246 | 6 |
312144 | 312144 | 2020-07-07 | Prince George | Virginia | 51149 | 246 | 1 |
296297 | 296297 | 2020-07-02 | Mecklenburg | Virginia | 51117 | 246 | 28 |
289956 | 289956 | 2020-06-30 | Fredericksburg city | Virginia | 51630 | 246 | 0 |
283660 | 283660 | 2020-06-28 | Fredericksburg city | Virginia | 51630 | 246 | 0 |
246095 | 246095 | 2020-06-16 | Hampton city | Virginia | 51650 | 246 | 5 |
224383 | 224383 | 2020-06-09 | Page | Virginia | 51139 | 246 | 24 |
169107 | 169107 | 2020-05-22 | Hanover | Virginia | 51085 | 246 | 19 |
135927 | 135927 | 2020-05-11 | Buckingham | Virginia | 51029 | 246 | 1 |
132937 | 132937 | 2020-05-10 | Buckingham | Virginia | 51029 | 246 | 1 |
129947 | 129947 | 2020-05-09 | Buckingham | Virginia | 51029 | 246 | 1 |
78255 | 78255 | 2020-04-21 | Richmond city | Virginia | 51760 | 246 | 10 |
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);