ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 566 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 21
county 21
- Buckingham 3
- Covington city 3
- Middlesex 3
- Amelia 1
- Appomattox 1
- Campbell 1
- Charlottesville city 1
- Fluvanna 1
- Fredericksburg city 1
- Hopewell city 1
- Isle of Wight 1
- Lunenburg 1
- Madison 1
- Mathews 1
- New Kent 1
- Rappahannock 1
- Smyth 1
- Surry 1
- Tazewell 1
- Warren 1
- York 1
state 1
- Virginia · 27 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1832640 | 1832640 | 2021-10-19 | Rappahannock | Virginia | 51157 | 566 | 4 |
1787171 | 1787171 | 2021-10-05 | Surry | Virginia | 51181 | 566 | 10 |
1241585 | 1241585 | 2021-04-20 | Middlesex | Virginia | 51119 | 566 | 20 |
1238338 | 1238338 | 2021-04-19 | Middlesex | Virginia | 51119 | 566 | 20 |
1235091 | 1235091 | 2021-04-18 | Middlesex | Virginia | 51119 | 566 | 20 |
1196109 | 1196109 | 2021-04-06 | Madison | Virginia | 51113 | 566 | 15 |
1147350 | 1147350 | 2021-03-22 | Covington city | Virginia | 51580 | 566 | 12 |
1147400 | 1147400 | 2021-03-22 | Mathews | Virginia | 51115 | 566 | 12 |
991544 | 991544 | 2021-02-02 | Covington city | Virginia | 51580 | 566 | 4 |
988298 | 988298 | 2021-02-01 | Covington city | Virginia | 51580 | 566 | 4 |
985095 | 985095 | 2021-01-31 | Lunenburg | Virginia | 51111 | 566 | 4 |
952574 | 952574 | 2021-01-21 | Amelia | Virginia | 51007 | 566 | 8 |
858539 | 858539 | 2020-12-23 | New Kent | Virginia | 51127 | 566 | 5 |
842236 | 842236 | 2020-12-18 | Appomattox | Virginia | 51011 | 566 | 6 |
813057 | 813057 | 2020-12-09 | Fluvanna | Virginia | 51065 | 566 | 9 |
744926 | 744926 | 2020-11-18 | Hopewell city | Virginia | 51670 | 566 | 8 |
693082 | 693082 | 2020-11-02 | Tazewell | Virginia | 51185 | 566 | 2 |
663893 | 663893 | 2020-10-24 | Warren | Virginia | 51187 | 566 | 20 |
624847 | 624847 | 2020-10-12 | Campbell | Virginia | 51031 | 566 | 5 |
618389 | 618389 | 2020-10-10 | Fredericksburg city | Virginia | 51630 | 566 | 5 |
618457 | 618457 | 2020-10-10 | Smyth | Virginia | 51173 | 566 | 21 |
605507 | 605507 | 2020-10-06 | York | Virginia | 51199 | 566 | 8 |
495347 | 495347 | 2020-09-02 | Isle of Wight | Virginia | 51093 | 566 | 11 |
450071 | 450071 | 2020-08-19 | Charlottesville city | Virginia | 51540 | 566 | 14 |
305724 | 305724 | 2020-07-05 | Buckingham | Virginia | 51029 | 566 | 4 |
302560 | 302560 | 2020-07-04 | Buckingham | Virginia | 51029 | 566 | 4 |
299396 | 299396 | 2020-07-03 | Buckingham | Virginia | 51029 | 566 | 4 |
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);