ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 282 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 23
county 23
- Norton city 6
- Charlotte 2
- Fairfax city 2
- Galax city 2
- Rappahannock 2
- Rockingham 2
- Westmoreland 2
- Amelia 1
- Amherst 1
- Augusta 1
- Bath 1
- Fauquier 1
- Goochland 1
- Hopewell city 1
- Lexington city 1
- Newport News city 1
- Patrick 1
- Portsmouth city 1
- Radford city 1
- Smyth 1
- Spotsylvania 1
- Surry 1
- York 1
state 1
- Virginia · 34 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1634369 | 1634369 | 2021-08-19 | Bath | Virginia | 51017 | 282 | 11 |
1309774 | 1309774 | 2021-05-11 | Norton city | Virginia | 51720 | 282 | 7 |
1306528 | 1306528 | 2021-05-10 | Norton city | Virginia | 51720 | 282 | 7 |
1303282 | 1303282 | 2021-05-09 | Norton city | Virginia | 51720 | 282 | 7 |
1300035 | 1300035 | 2021-05-08 | Norton city | Virginia | 51720 | 282 | 7 |
1293542 | 1293542 | 2021-05-06 | Norton city | Virginia | 51720 | 282 | 7 |
1277310 | 1277310 | 2021-05-01 | Norton city | Virginia | 51720 | 282 | 7 |
1014340 | 1014340 | 2021-02-09 | Rappahannock | Virginia | 51157 | 282 | 2 |
1011095 | 1011095 | 2021-02-08 | Rappahannock | Virginia | 51157 | 282 | 2 |
936462 | 936462 | 2021-01-16 | Surry | Virginia | 51181 | 282 | 5 |
868229 | 868229 | 2020-12-26 | Fairfax city | Virginia | 51600 | 282 | 10 |
864984 | 864984 | 2020-12-25 | Fairfax city | Virginia | 51600 | 282 | 10 |
813019 | 813019 | 2020-12-09 | Amelia | Virginia | 51007 | 282 | 7 |
780589 | 780589 | 2020-11-29 | Charlotte | Virginia | 51037 | 282 | 5 |
777343 | 777343 | 2020-11-28 | Charlotte | Virginia | 51037 | 282 | 5 |
728705 | 728705 | 2020-11-13 | Lexington city | Virginia | 51678 | 282 | 2 |
615228 | 615228 | 2020-10-09 | Westmoreland | Virginia | 51193 | 282 | 4 |
611987 | 611987 | 2020-10-08 | Westmoreland | Virginia | 51193 | 282 | 4 |
598940 | 598940 | 2020-10-04 | Goochland | Virginia | 51075 | 282 | 7 |
595739 | 595739 | 2020-10-03 | Patrick | Virginia | 51141 | 282 | 26 |
495399 | 495399 | 2020-09-02 | Smyth | Virginia | 51173 | 282 | 5 |
482355 | 482355 | 2020-08-29 | Amherst | Virginia | 51009 | 282 | 1 |
479218 | 479218 | 2020-08-28 | Radford city | Virginia | 51750 | 282 | 0 |
433976 | 433976 | 2020-08-14 | Hopewell city | Virginia | 51670 | 282 | 5 |
424246 | 424246 | 2020-08-11 | Augusta | Virginia | 51015 | 282 | 4 |
376097 | 376097 | 2020-07-27 | York | Virginia | 51199 | 282 | 3 |
318440 | 318440 | 2020-07-09 | Galax city | Virginia | 51640 | 282 | 16 |
315267 | 315267 | 2020-07-08 | Galax city | Virginia | 51640 | 282 | 16 |
199689 | 199689 | 2020-06-01 | Newport News city | Virginia | 51700 | 282 | 10 |
184371 | 184371 | 2020-05-27 | Portsmouth city | Virginia | 51740 | 282 | 11 |
175175 | 175175 | 2020-05-24 | Fauquier | Virginia | 51061 | 282 | 5 |
145010 | 145010 | 2020-05-14 | Spotsylvania | Virginia | 51177 | 282 | 4 |
121083 | 121083 | 2020-05-06 | Rockingham | Virginia | 51165 | 282 | 1 |
118119 | 118119 | 2020-05-05 | Rockingham | Virginia | 51165 | 282 | 1 |
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);