ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 428 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 14
county 14
- Fredericksburg city 3
- Surry 3
- Winchester city 2
- Amherst 1
- Bath 1
- Fluvanna 1
- Frederick 1
- Halifax 1
- Manassas Park city 1
- Manassas city 1
- Martinsville city 1
- Page 1
- Poquoson city 1
- Powhatan 1
state 1
- Virginia · 19 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1793557 | 1793557 | 2021-10-07 | Bath | Virginia | 51017 | 428 | 14 |
1585756 | 1585756 | 2021-08-04 | Surry | Virginia | 51181 | 428 | 9 |
1582506 | 1582506 | 2021-08-03 | Surry | Virginia | 51181 | 428 | 9 |
1579256 | 1579256 | 2021-08-02 | Surry | Virginia | 51181 | 428 | 9 |
926702 | 926702 | 2021-01-13 | Poquoson city | Virginia | 51735 | 428 | 7 |
764437 | 764437 | 2020-11-24 | Powhatan | Virginia | 51145 | 428 | 6 |
676784 | 676784 | 2020-10-28 | Fluvanna | Virginia | 51065 | 428 | 9 |
631370 | 631370 | 2020-10-14 | Halifax | Virginia | 51083 | 428 | 7 |
621663 | 621663 | 2020-10-11 | Martinsville city | Virginia | 51690 | 428 | 23 |
618434 | 618434 | 2020-10-10 | Page | Virginia | 51139 | 428 | 29 |
602138 | 602138 | 2020-10-05 | Amherst | Virginia | 51009 | 428 | 4 |
459860 | 459860 | 2020-08-22 | Winchester city | Virginia | 51840 | 428 | 4 |
456633 | 456633 | 2020-08-21 | Winchester city | Virginia | 51840 | 428 | 4 |
446866 | 446866 | 2020-08-18 | Fredericksburg city | Virginia | 51630 | 428 | 3 |
443639 | 443639 | 2020-08-17 | Fredericksburg city | Virginia | 51630 | 428 | 4 |
440413 | 440413 | 2020-08-16 | Fredericksburg city | Virginia | 51630 | 428 | 4 |
283689 | 283689 | 2020-06-28 | Manassas Park city | Virginia | 51685 | 428 | 5 |
236753 | 236753 | 2020-06-13 | Frederick | Virginia | 51069 | 428 | 4 |
135986 | 135986 | 2020-05-11 | Manassas city | Virginia | 51683 | 428 | 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);