ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 499 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips 18
county 18
- Cumberland 6
- Bath 2
- Charles City 2
- Appomattox 1
- Bland 1
- Caroline 1
- Carroll 1
- Fairfax city 1
- Lexington city 1
- Madison 1
- Mathews 1
- New Kent 1
- Prince George 1
- Rappahannock 1
- Scott 1
- Shenandoah 1
- Washington 1
- Winchester city 1
state 1
- Virginia · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1926780 | 1926780 | 2021-11-17 | Bath | Virginia | 51017 | 499 | 15 |
1920281 | 1920281 | 2021-11-15 | Bath | Virginia | 51017 | 499 | 15 |
1744916 | 1744916 | 2021-09-22 | Rappahannock | Virginia | 51157 | 499 | 4 |
1377894 | 1377894 | 2021-06-01 | Cumberland | Virginia | 51049 | 499 | 10 |
1374648 | 1374648 | 2021-05-31 | Cumberland | Virginia | 51049 | 499 | 10 |
1371403 | 1371403 | 2021-05-30 | Cumberland | Virginia | 51049 | 499 | 9 |
1368157 | 1368157 | 2021-05-29 | Cumberland | Virginia | 51049 | 499 | 9 |
1364911 | 1364911 | 2021-05-28 | Cumberland | Virginia | 51049 | 499 | 9 |
1361665 | 1361665 | 2021-05-27 | Cumberland | Virginia | 51049 | 499 | 9 |
1345423 | 1345423 | 2021-05-22 | Charles City | Virginia | 51036 | 499 | 16 |
1286983 | 1286983 | 2021-05-04 | Charles City | Virginia | 51036 | 499 | 15 |
1101909 | 1101909 | 2021-03-08 | Fairfax city | Virginia | 51600 | 499 | 15 |
1037033 | 1037033 | 2021-02-16 | Mathews | Virginia | 51115 | 499 | 7 |
1001328 | 1001328 | 2021-02-05 | Madison | Virginia | 51113 | 499 | 6 |
897411 | 897411 | 2021-01-04 | Bland | Virginia | 51021 | 499 | 6 |
848790 | 848790 | 2020-12-20 | Lexington city | Virginia | 51678 | 499 | 3 |
839068 | 839068 | 2020-12-17 | New Kent | Virginia | 51127 | 499 | 5 |
826006 | 826006 | 2020-12-13 | Appomattox | Virginia | 51011 | 499 | 6 |
741637 | 741637 | 2020-11-17 | Caroline | Virginia | 51033 | 499 | 6 |
702801 | 702801 | 2020-11-05 | Scott | Virginia | 51169 | 499 | 7 |
576333 | 576333 | 2020-09-27 | Winchester city | Virginia | 51840 | 499 | 4 |
572980 | 572980 | 2020-09-26 | Carroll | Virginia | 51035 | 499 | 24 |
543934 | 543934 | 2020-09-17 | Washington | Virginia | 51191 | 499 | 14 |
475982 | 475982 | 2020-08-27 | Prince George | Virginia | 51149 | 499 | 2 |
230609 | 230609 | 2020-06-11 | Shenandoah | Virginia | 51171 | 499 | 25 |
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);