ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 583 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 26
county 26
- Albemarle 2
- Fairfax city 2
- Smyth 2
- Amherst 1
- Brunswick 1
- Buchanan 1
- Craig 1
- Cumberland 1
- Dinwiddie 1
- Essex 1
- Fredericksburg city 1
- Gloucester 1
- Goochland 1
- Hanover 1
- Harrisonburg city 1
- King William 1
- King and Queen 1
- Lancaster 1
- Lunenburg 1
- Mathews 1
- Nelson 1
- Norfolk city 1
- Poquoson city 1
- Prince Edward 1
- Warren 1
- Williamsburg city 1
state 1
- Virginia · 29 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1923550 | 1923550 | 2021-11-16 | Craig | Virginia | 51045 | 583 | 9 |
1783868 | 1783868 | 2021-10-04 | King and Queen | Virginia | 51097 | 583 | 8 |
1673372 | 1673372 | 2021-08-31 | Cumberland | Virginia | 51049 | 583 | 10 |
1631150 | 1631150 | 2021-08-18 | Fairfax city | Virginia | 51600 | 583 | 19 |
1627903 | 1627903 | 2021-08-17 | Fairfax city | Virginia | 51600 | 583 | 19 |
1205858 | 1205858 | 2021-04-09 | Mathews | Virginia | 51115 | 583 | 12 |
1144203 | 1144203 | 2021-03-21 | Williamsburg city | Virginia | 51830 | 583 | 11 |
1011028 | 1011028 | 2021-02-08 | Essex | Virginia | 51057 | 583 | 4 |
1004572 | 1004572 | 2021-02-06 | Lunenburg | Virginia | 51111 | 583 | 4 |
998075 | 998075 | 2021-02-04 | Lancaster | Virginia | 51103 | 583 | 4 |
975380 | 975380 | 2021-01-28 | Poquoson city | Virginia | 51735 | 583 | 7 |
965633 | 965633 | 2021-01-25 | Nelson | Virginia | 51125 | 583 | 6 |
929917 | 929917 | 2021-01-14 | King William | Virginia | 51101 | 583 | 5 |
864996 | 864996 | 2020-12-25 | Goochland | Virginia | 51075 | 583 | 7 |
861715 | 861715 | 2020-12-24 | Brunswick | Virginia | 51025 | 583 | 7 |
826015 | 826015 | 2020-12-13 | Buchanan | Virginia | 51027 | 583 | 24 |
819556 | 819556 | 2020-12-11 | Gloucester | Virginia | 51073 | 583 | 5 |
715698 | 715698 | 2020-11-09 | Dinwiddie | Virginia | 51053 | 583 | 12 |
673504 | 673504 | 2020-10-27 | Amherst | Virginia | 51009 | 583 | 6 |
673623 | 673623 | 2020-10-27 | Warren | Virginia | 51187 | 583 | 20 |
657327 | 657327 | 2020-10-22 | Fredericksburg city | Virginia | 51630 | 583 | 6 |
637920 | 637920 | 2020-10-16 | Smyth | Virginia | 51173 | 583 | 22 |
634675 | 634675 | 2020-10-15 | Smyth | Virginia | 51173 | 583 | 22 |
586022 | 586022 | 2020-09-30 | Prince Edward | Virginia | 51147 | 583 | 12 |
385672 | 385672 | 2020-07-30 | Hanover | Virginia | 51085 | 583 | 30 |
340709 | 340709 | 2020-07-16 | Albemarle | Virginia | 51003 | 583 | 10 |
337513 | 337513 | 2020-07-15 | Albemarle | Virginia | 51003 | 583 | 10 |
218189 | 218189 | 2020-06-07 | Norfolk city | Virginia | 51710 | 583 | 7 |
135967 | 135967 | 2020-05-11 | Harrisonburg city | Virginia | 51660 | 583 | 21 |
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);