ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
128 rows where cases = 28 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Gloucester 7
- Lexington city 7
- Northumberland 7
- Botetourt 6
- Charles City 6
- Prince George 6
- Charlotte 5
- Amherst 4
- Craig 4
- Nelson 4
- Patrick 4
- Alleghany 3
- Amelia 3
- Campbell 3
- Floyd 3
- Sussex 3
- Wise 3
- Bath 2
- Clarke 2
- Fauquier 2
- Franklin 2
- Henrico 2
- Henry 2
- Lunenburg 2
- New Kent 2
- Pulaski 2
- Russell 2
- Stafford 2
- Washington 2
- Accomack 1
- …
state 1
- Virginia · 128 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
702698 | 702698 | 2020-11-05 | Bath | Virginia | 51017 | 28 | 0 |
699455 | 699455 | 2020-11-04 | Bath | Virginia | 51017 | 28 | 0 |
560026 | 560026 | 2020-09-22 | Craig | Virginia | 51045 | 28 | 0 |
556790 | 556790 | 2020-09-21 | Craig | Virginia | 51045 | 28 | 0 |
553553 | 553553 | 2020-09-20 | Craig | Virginia | 51045 | 28 | 0 |
550314 | 550314 | 2020-09-19 | Craig | Virginia | 51045 | 28 | 0 |
433963 | 433963 | 2020-08-14 | Giles | Virginia | 51071 | 28 | 0 |
398562 | 398562 | 2020-08-03 | Middlesex | Virginia | 51119 | 28 | 1 |
388902 | 388902 | 2020-07-31 | Lexington city | Virginia | 51678 | 28 | 0 |
385685 | 385685 | 2020-07-30 | Lexington city | Virginia | 51678 | 28 | 0 |
382467 | 382467 | 2020-07-29 | Lexington city | Virginia | 51678 | 28 | 0 |
379250 | 379250 | 2020-07-28 | Lexington city | Virginia | 51678 | 28 | 0 |
376032 | 376032 | 2020-07-27 | Lancaster | Virginia | 51103 | 28 | 0 |
376034 | 376034 | 2020-07-27 | Lexington city | Virginia | 51678 | 28 | 0 |
372820 | 372820 | 2020-07-26 | Lexington city | Virginia | 51678 | 28 | 0 |
369608 | 369608 | 2020-07-25 | Lexington city | Virginia | 51678 | 28 | 0 |
356754 | 356754 | 2020-07-21 | Floyd | Virginia | 51063 | 28 | 1 |
356808 | 356808 | 2020-07-21 | Poquoson city | Virginia | 51735 | 28 | 0 |
353551 | 353551 | 2020-07-20 | Floyd | Virginia | 51063 | 28 | 1 |
353592 | 353592 | 2020-07-20 | Nelson | Virginia | 51125 | 28 | 0 |
350349 | 350349 | 2020-07-19 | Floyd | Virginia | 51063 | 28 | 1 |
350390 | 350390 | 2020-07-19 | Nelson | Virginia | 51125 | 28 | 0 |
347189 | 347189 | 2020-07-18 | Nelson | Virginia | 51125 | 28 | 0 |
347217 | 347217 | 2020-07-18 | Russell | Virginia | 51167 | 28 | 0 |
343989 | 343989 | 2020-07-17 | Nelson | Virginia | 51125 | 28 | 0 |
344017 | 344017 | 2020-07-17 | Russell | Virginia | 51167 | 28 | 0 |
331190 | 331190 | 2020-07-13 | King and Queen | Virginia | 51097 | 28 | 1 |
328060 | 328060 | 2020-07-12 | Tazewell | Virginia | 51185 | 28 | 0 |
296348 | 296348 | 2020-07-02 | Wise | Virginia | 51195 | 28 | 2 |
293193 | 293193 | 2020-07-01 | Wise | Virginia | 51195 | 28 | 2 |
290040 | 290040 | 2020-06-30 | Wise | Virginia | 51195 | 28 | 2 |
277428 | 277428 | 2020-06-26 | Rockbridge | Virginia | 51163 | 28 | 0 |
274259 | 274259 | 2020-06-25 | Northumberland | Virginia | 51133 | 28 | 1 |
271119 | 271119 | 2020-06-24 | Northumberland | Virginia | 51133 | 28 | 1 |
267970 | 267970 | 2020-06-23 | Lunenburg | Virginia | 51111 | 28 | 0 |
267985 | 267985 | 2020-06-23 | Northumberland | Virginia | 51133 | 28 | 1 |
264841 | 264841 | 2020-06-22 | Lunenburg | Virginia | 51111 | 28 | 0 |
264856 | 264856 | 2020-06-22 | Northumberland | Virginia | 51133 | 28 | 1 |
261727 | 261727 | 2020-06-21 | Northumberland | Virginia | 51133 | 28 | 1 |
258600 | 258600 | 2020-06-20 | Northumberland | Virginia | 51133 | 28 | 1 |
255392 | 255392 | 2020-06-19 | Amherst | Virginia | 51009 | 28 | 0 |
255473 | 255473 | 2020-06-19 | Northumberland | Virginia | 51133 | 28 | 1 |
252274 | 252274 | 2020-06-18 | Amherst | Virginia | 51009 | 28 | 0 |
252285 | 252285 | 2020-06-18 | Campbell | Virginia | 51031 | 28 | 1 |
252381 | 252381 | 2020-06-18 | Smyth | Virginia | 51173 | 28 | 0 |
249159 | 249159 | 2020-06-17 | Amherst | Virginia | 51009 | 28 | 0 |
249170 | 249170 | 2020-06-17 | Campbell | Virginia | 51031 | 28 | 1 |
246047 | 246047 | 2020-06-16 | Amherst | Virginia | 51009 | 28 | 0 |
246058 | 246058 | 2020-06-16 | Campbell | Virginia | 51031 | 28 | 1 |
242933 | 242933 | 2020-06-15 | Alleghany | Virginia | 51005 | 28 | 2 |
239822 | 239822 | 2020-06-14 | Alleghany | Virginia | 51005 | 28 | 2 |
236714 | 236714 | 2020-06-13 | Alleghany | Virginia | 51005 | 28 | 2 |
233623 | 233623 | 2020-06-12 | Charles City | Virginia | 51036 | 28 | 2 |
230518 | 230518 | 2020-06-11 | Charles City | Virginia | 51036 | 28 | 2 |
227414 | 227414 | 2020-06-10 | Charles City | Virginia | 51036 | 28 | 2 |
227484 | 227484 | 2020-06-10 | Patrick | Virginia | 51141 | 28 | 0 |
224314 | 224314 | 2020-06-09 | Charles City | Virginia | 51036 | 28 | 2 |
224384 | 224384 | 2020-06-09 | Patrick | Virginia | 51141 | 28 | 0 |
224393 | 224393 | 2020-06-09 | Pulaski | Virginia | 51155 | 28 | 1 |
221218 | 221218 | 2020-06-08 | Charles City | Virginia | 51036 | 28 | 2 |
221219 | 221219 | 2020-06-08 | Charlotte | Virginia | 51037 | 28 | 0 |
221288 | 221288 | 2020-06-08 | Patrick | Virginia | 51141 | 28 | 0 |
221297 | 221297 | 2020-06-08 | Pulaski | Virginia | 51155 | 28 | 1 |
218126 | 218126 | 2020-06-07 | Charles City | Virginia | 51036 | 28 | 2 |
218127 | 218127 | 2020-06-07 | Charlotte | Virginia | 51037 | 28 | 0 |
218196 | 218196 | 2020-06-07 | Patrick | Virginia | 51141 | 28 | 0 |
215037 | 215037 | 2020-06-06 | Charlotte | Virginia | 51037 | 28 | 0 |
211934 | 211934 | 2020-06-05 | Amelia | Virginia | 51007 | 28 | 1 |
211950 | 211950 | 2020-06-05 | Charlotte | Virginia | 51037 | 28 | 0 |
208849 | 208849 | 2020-06-04 | Amelia | Virginia | 51007 | 28 | 1 |
208865 | 208865 | 2020-06-04 | Charlotte | Virginia | 51037 | 28 | 0 |
205767 | 205767 | 2020-06-03 | Amelia | Virginia | 51007 | 28 | 1 |
202696 | 202696 | 2020-06-02 | Brunswick | Virginia | 51025 | 28 | 1 |
202708 | 202708 | 2020-06-02 | Clarke | Virginia | 51043 | 28 | 0 |
199632 | 199632 | 2020-06-01 | Clarke | Virginia | 51043 | 28 | 0 |
193551 | 193551 | 2020-05-30 | Nottoway | Virginia | 51135 | 28 | 0 |
187384 | 187384 | 2020-05-28 | Greene | Virginia | 51079 | 28 | 1 |
172186 | 172186 | 2020-05-23 | Pittsylvania | Virginia | 51143 | 28 | 1 |
160007 | 160007 | 2020-05-19 | Gloucester | Virginia | 51073 | 28 | 1 |
160084 | 160084 | 2020-05-19 | Waynesboro city | Virginia | 51820 | 28 | 0 |
156983 | 156983 | 2020-05-18 | Gloucester | Virginia | 51073 | 28 | 1 |
153966 | 153966 | 2020-05-17 | Gloucester | Virginia | 51073 | 28 | 1 |
150955 | 150955 | 2020-05-16 | Gloucester | Virginia | 51073 | 28 | 1 |
147946 | 147946 | 2020-05-15 | Gloucester | Virginia | 51073 | 28 | 1 |
144943 | 144943 | 2020-05-14 | Gloucester | Virginia | 51073 | 28 | 1 |
144953 | 144953 | 2020-05-14 | Henry | Virginia | 51089 | 28 | 1 |
144977 | 144977 | 2020-05-14 | New Kent | Virginia | 51127 | 28 | 2 |
141946 | 141946 | 2020-05-13 | Gloucester | Virginia | 51073 | 28 | 1 |
141956 | 141956 | 2020-05-13 | Henry | Virginia | 51089 | 28 | 1 |
141980 | 141980 | 2020-05-13 | New Kent | Virginia | 51127 | 28 | 1 |
138944 | 138944 | 2020-05-12 | Franklin | Virginia | 51067 | 28 | 0 |
135944 | 135944 | 2020-05-11 | Dinwiddie | Virginia | 51053 | 28 | 0 |
135953 | 135953 | 2020-05-11 | Franklin | Virginia | 51067 | 28 | 0 |
129951 | 129951 | 2020-05-09 | Carroll | Virginia | 51035 | 28 | 0 |
115065 | 115065 | 2020-05-04 | Botetourt | Virginia | 51023 | 28 | 3 |
112182 | 112182 | 2020-05-03 | Botetourt | Virginia | 51023 | 28 | 3 |
109308 | 109308 | 2020-05-02 | Botetourt | Virginia | 51023 | 28 | 3 |
106439 | 106439 | 2020-05-01 | Botetourt | Virginia | 51023 | 28 | 3 |
103575 | 103575 | 2020-04-30 | Botetourt | Virginia | 51023 | 28 | 3 |
100720 | 100720 | 2020-04-29 | Botetourt | Virginia | 51023 | 28 | 3 |
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);