ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 522 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 16
county 16
- Charles City 8
- Brunswick 2
- Rappahannock 2
- Carroll 1
- Cumberland 1
- Danville city 1
- Fairfax city 1
- Fauquier 1
- Fluvanna 1
- Goochland 1
- King George 1
- Orange 1
- Roanoke 1
- Shenandoah 1
- Williamsburg city 1
- Winchester city 1
state 1
- Virginia · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1787154 | 1787154 | 2021-10-05 | Rappahannock | Virginia | 51157 | 522 | 4 |
1783905 | 1783905 | 2021-10-04 | Rappahannock | Virginia | 51157 | 522 | 4 |
1553175 | 1553175 | 2021-07-25 | Charles City | Virginia | 51036 | 522 | 16 |
1549928 | 1549928 | 2021-07-24 | Charles City | Virginia | 51036 | 522 | 16 |
1546681 | 1546681 | 2021-07-23 | Charles City | Virginia | 51036 | 522 | 16 |
1543434 | 1543434 | 2021-07-22 | Charles City | Virginia | 51036 | 522 | 16 |
1540196 | 1540196 | 2021-07-21 | Cumberland | Virginia | 51049 | 522 | 10 |
1530444 | 1530444 | 2021-07-18 | Charles City | Virginia | 51036 | 522 | 16 |
1527197 | 1527197 | 2021-07-17 | Charles City | Virginia | 51036 | 522 | 16 |
1523950 | 1523950 | 2021-07-16 | Charles City | Virginia | 51036 | 522 | 16 |
1517454 | 1517454 | 2021-07-14 | Charles City | Virginia | 51036 | 522 | 16 |
1176587 | 1176587 | 2021-03-31 | Fairfax city | Virginia | 51600 | 522 | 18 |
1069539 | 1069539 | 2021-02-26 | Williamsburg city | Virginia | 51830 | 522 | 9 |
839035 | 839035 | 2020-12-17 | Goochland | Virginia | 51075 | 522 | 7 |
826014 | 826014 | 2020-12-13 | Brunswick | Virginia | 51025 | 522 | 8 |
822767 | 822767 | 2020-12-12 | Brunswick | Virginia | 51025 | 522 | 8 |
816325 | 816325 | 2020-12-10 | King George | Virginia | 51099 | 522 | 7 |
800078 | 800078 | 2020-12-05 | Fluvanna | Virginia | 51065 | 522 | 9 |
757940 | 757940 | 2020-11-22 | Orange | Virginia | 51137 | 522 | 7 |
611880 | 611880 | 2020-10-08 | Carroll | Virginia | 51035 | 522 | 25 |
605504 | 605504 | 2020-10-06 | Winchester city | Virginia | 51840 | 522 | 4 |
456536 | 456536 | 2020-08-21 | Danville city | Virginia | 51590 | 522 | 12 |
443699 | 443699 | 2020-08-17 | Roanoke | Virginia | 51161 | 522 | 4 |
347147 | 347147 | 2020-07-18 | Fauquier | Virginia | 51061 | 522 | 8 |
249265 | 249265 | 2020-06-17 | Shenandoah | Virginia | 51171 | 522 | 27 |
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);