ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 377 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 29
county 29
- Emporia city 2
- Franklin city 2
- Highland 2
- Louisa 2
- Amelia 1
- Bedford 1
- Campbell 1
- Caroline 1
- Charles City 1
- Cumberland 1
- Dinwiddie 1
- Giles 1
- Gloucester 1
- King George 1
- Martinsville city 1
- Norfolk city 1
- Nottoway 1
- Orange 1
- Prince George 1
- Pulaski 1
- Richmond 1
- Roanoke 1
- Staunton city 1
- Suffolk city 1
- Surry 1
- Tazewell 1
- Williamsburg city 1
- Winchester city 1
- Wise 1
state 1
- Virginia · 33 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469993 | 2469993 | 2022-05-03 | Highland | Virginia | 51091 | 377 | 7 |
2466737 | 2466737 | 2022-05-02 | Highland | Virginia | 51091 | 377 | 7 |
1098745 | 1098745 | 2021-03-07 | Surry | Virginia | 51181 | 377 | 8 |
1062952 | 1062952 | 2021-02-24 | Cumberland | Virginia | 51049 | 377 | 4 |
1030485 | 1030485 | 2021-02-14 | Charles City | Virginia | 51036 | 377 | 10 |
900649 | 900649 | 2021-01-05 | Amelia | Virginia | 51007 | 377 | 7 |
900773 | 900773 | 2021-01-05 | Williamsburg city | Virginia | 51830 | 377 | 8 |
845511 | 845511 | 2020-12-19 | Emporia city | Virginia | 51595 | 377 | 29 |
842265 | 842265 | 2020-12-18 | Emporia city | Virginia | 51595 | 377 | 29 |
813063 | 813063 | 2020-12-09 | Giles | Virginia | 51071 | 377 | 1 |
767649 | 767649 | 2020-11-25 | King George | Virginia | 51099 | 377 | 5 |
735231 | 735231 | 2020-11-15 | Richmond | Virginia | 51159 | 377 | 4 |
731930 | 731930 | 2020-11-14 | Gloucester | Virginia | 51073 | 377 | 3 |
719008 | 719008 | 2020-11-10 | Pulaski | Virginia | 51155 | 377 | 7 |
702778 | 702778 | 2020-11-05 | Nottoway | Virginia | 51135 | 377 | 21 |
663887 | 663887 | 2020-10-24 | Staunton city | Virginia | 51790 | 377 | 3 |
657352 | 657352 | 2020-10-22 | Louisa | Virginia | 51109 | 377 | 7 |
654107 | 654107 | 2020-10-21 | Louisa | Virginia | 51109 | 377 | 7 |
654126 | 654126 | 2020-10-21 | Orange | Virginia | 51137 | 377 | 5 |
621708 | 621708 | 2020-10-11 | Tazewell | Virginia | 51185 | 377 | 2 |
618362 | 618362 | 2020-10-10 | Caroline | Virginia | 51033 | 377 | 5 |
572994 | 572994 | 2020-09-26 | Dinwiddie | Virginia | 51053 | 377 | 11 |
560074 | 560074 | 2020-09-22 | Martinsville city | Virginia | 51690 | 377 | 15 |
540617 | 540617 | 2020-09-16 | Franklin city | Virginia | 51620 | 377 | 9 |
537380 | 537380 | 2020-09-15 | Franklin city | Virginia | 51620 | 377 | 9 |
527646 | 527646 | 2020-09-12 | Campbell | Virginia | 51031 | 377 | 3 |
527758 | 527758 | 2020-09-12 | Wise | Virginia | 51195 | 377 | 6 |
430700 | 430700 | 2020-08-13 | Bedford | Virginia | 51019 | 377 | 8 |
411454 | 411454 | 2020-08-07 | Prince George | Virginia | 51149 | 377 | 2 |
360024 | 360024 | 2020-07-22 | Roanoke | Virginia | 51161 | 377 | 6 |
353639 | 353639 | 2020-07-20 | Winchester city | Virginia | 51840 | 377 | 4 |
264888 | 264888 | 2020-06-22 | Suffolk city | Virginia | 51800 | 377 | 34 |
166100 | 166100 | 2020-05-21 | Norfolk city | Virginia | 51710 | 377 | 6 |
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);