ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where cases = 38 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
- Bland 7
- Amherst 5
- Amelia 4
- Bedford 4
- Caroline 4
- Lynchburg city 4
- Northumberland 4
- Charlotte 3
- Gloucester 3
- King George 3
- Appomattox 2
- Charlottesville city 2
- Clarke 2
- Cumberland 2
- Danville city 2
- Dickenson 2
- Franklin city 2
- Grayson 2
- Hanover 2
- Louisa 2
- Madison 2
- New Kent 2
- Salem city 2
- Sussex 2
- Waynesboro city 2
- Westmoreland 2
- Wythe 2
- York 2
- Albemarle 1
- Alleghany 1
- …
state 1
- Virginia · 99 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
842290 | 842290 | 2020-12-18 | Highland | Virginia | 51091 | 38 | 0 |
631345 | 631345 | 2020-10-14 | Craig | Virginia | 51045 | 38 | 0 |
466200 | 466200 | 2020-08-24 | Bland | Virginia | 51021 | 38 | 0 |
462971 | 462971 | 2020-08-23 | Bland | Virginia | 51021 | 38 | 0 |
459742 | 459742 | 2020-08-22 | Bland | Virginia | 51021 | 38 | 0 |
456515 | 456515 | 2020-08-21 | Bland | Virginia | 51021 | 38 | 0 |
453287 | 453287 | 2020-08-20 | Bland | Virginia | 51021 | 38 | 0 |
453345 | 453345 | 2020-08-20 | Lexington city | Virginia | 51678 | 38 | 0 |
450059 | 450059 | 2020-08-19 | Bland | Virginia | 51021 | 38 | 0 |
446831 | 446831 | 2020-08-18 | Bland | Virginia | 51021 | 38 | 0 |
411388 | 411388 | 2020-08-07 | Dickenson | Virginia | 51051 | 38 | 1 |
408169 | 408169 | 2020-08-06 | Dickenson | Virginia | 51051 | 38 | 1 |
398602 | 398602 | 2020-08-03 | Surry | Virginia | 51181 | 38 | 2 |
366440 | 366440 | 2020-07-24 | Russell | Virginia | 51167 | 38 | 1 |
337534 | 337534 | 2020-07-15 | Charlotte | Virginia | 51037 | 38 | 0 |
334339 | 334339 | 2020-07-14 | Charlotte | Virginia | 51037 | 38 | 0 |
331146 | 331146 | 2020-07-13 | Charlotte | Virginia | 51037 | 38 | 0 |
324883 | 324883 | 2020-07-11 | Wise | Virginia | 51195 | 38 | 2 |
321577 | 321577 | 2020-07-10 | Amherst | Virginia | 51009 | 38 | 0 |
321659 | 321659 | 2020-07-10 | Northumberland | Virginia | 51133 | 38 | 1 |
318398 | 318398 | 2020-07-09 | Amherst | Virginia | 51009 | 38 | 0 |
318408 | 318408 | 2020-07-09 | Buchanan | Virginia | 51027 | 38 | 0 |
315225 | 315225 | 2020-07-08 | Amherst | Virginia | 51009 | 38 | 0 |
312049 | 312049 | 2020-07-07 | Alleghany | Virginia | 51005 | 38 | 2 |
312051 | 312051 | 2020-07-07 | Amherst | Virginia | 51009 | 38 | 0 |
308882 | 308882 | 2020-07-06 | Amherst | Virginia | 51009 | 38 | 0 |
283701 | 283701 | 2020-06-28 | Northumberland | Virginia | 51133 | 38 | 1 |
280475 | 280475 | 2020-06-27 | Appomattox | Virginia | 51011 | 38 | 0 |
280555 | 280555 | 2020-06-27 | Northumberland | Virginia | 51133 | 38 | 1 |
277327 | 277327 | 2020-06-26 | Appomattox | Virginia | 51011 | 38 | 0 |
277407 | 277407 | 2020-06-26 | Northumberland | Virginia | 51133 | 38 | 1 |
274237 | 274237 | 2020-06-25 | King William | Virginia | 51101 | 38 | 0 |
261732 | 261732 | 2020-06-21 | Patrick | Virginia | 51141 | 38 | 0 |
249158 | 249158 | 2020-06-17 | Amelia | Virginia | 51007 | 38 | 1 |
249201 | 249201 | 2020-06-17 | Gloucester | Virginia | 51073 | 38 | 1 |
246046 | 246046 | 2020-06-16 | Amelia | Virginia | 51007 | 38 | 1 |
246089 | 246089 | 2020-06-16 | Gloucester | Virginia | 51073 | 38 | 1 |
246094 | 246094 | 2020-06-16 | Halifax | Virginia | 51083 | 38 | 1 |
242954 | 242954 | 2020-06-15 | Clarke | Virginia | 51043 | 38 | 0 |
242976 | 242976 | 2020-06-15 | Gloucester | Virginia | 51073 | 38 | 1 |
239823 | 239823 | 2020-06-14 | Amelia | Virginia | 51007 | 38 | 1 |
239843 | 239843 | 2020-06-14 | Clarke | Virginia | 51043 | 38 | 0 |
236715 | 236715 | 2020-06-13 | Amelia | Virginia | 51007 | 38 | 1 |
227523 | 227523 | 2020-06-10 | Wythe | Virginia | 51197 | 38 | 1 |
224423 | 224423 | 2020-06-09 | Wythe | Virginia | 51197 | 38 | 1 |
218215 | 218215 | 2020-06-07 | Salem city | Virginia | 51775 | 38 | 3 |
215066 | 215066 | 2020-06-06 | Greene | Virginia | 51079 | 38 | 1 |
215125 | 215125 | 2020-06-06 | Salem city | Virginia | 51775 | 38 | 3 |
211970 | 211970 | 2020-06-05 | Franklin | Virginia | 51067 | 38 | 1 |
205837 | 205837 | 2020-06-03 | Martinsville city | Virginia | 51690 | 38 | 1 |
205843 | 205843 | 2020-06-03 | New Kent | Virginia | 51127 | 38 | 1 |
202713 | 202713 | 2020-06-02 | Cumberland | Virginia | 51049 | 38 | 0 |
202764 | 202764 | 2020-06-02 | New Kent | Virginia | 51127 | 38 | 1 |
199637 | 199637 | 2020-06-01 | Cumberland | Virginia | 51049 | 38 | 0 |
199656 | 199656 | 2020-06-01 | Grayson | Virginia | 51077 | 38 | 0 |
196583 | 196583 | 2020-05-31 | Grayson | Virginia | 51077 | 38 | 0 |
187406 | 187406 | 2020-05-28 | Madison | Virginia | 51113 | 38 | 1 |
187426 | 187426 | 2020-05-28 | Pittsylvania | Virginia | 51143 | 38 | 1 |
184349 | 184349 | 2020-05-27 | Madison | Virginia | 51113 | 38 | 1 |
175179 | 175179 | 2020-05-24 | Franklin city | Virginia | 51620 | 38 | 1 |
175261 | 175261 | 2020-05-24 | Waynesboro city | Virginia | 51820 | 38 | 0 |
172136 | 172136 | 2020-05-23 | Franklin city | Virginia | 51620 | 38 | 1 |
172218 | 172218 | 2020-05-23 | Waynesboro city | Virginia | 51820 | 38 | 0 |
156968 | 156968 | 2020-05-18 | Dinwiddie | Virginia | 51053 | 38 | 0 |
142018 | 142018 | 2020-05-13 | Sussex | Virginia | 51183 | 38 | 1 |
138913 | 138913 | 2020-05-12 | Bedford | Virginia | 51019 | 38 | 1 |
138921 | 138921 | 2020-05-12 | Caroline | Virginia | 51033 | 38 | 2 |
139022 | 139022 | 2020-05-12 | Sussex | Virginia | 51183 | 38 | 1 |
135922 | 135922 | 2020-05-11 | Bedford | Virginia | 51019 | 38 | 1 |
135930 | 135930 | 2020-05-11 | Caroline | Virginia | 51033 | 38 | 2 |
136037 | 136037 | 2020-05-11 | Westmoreland | Virginia | 51193 | 38 | 0 |
132932 | 132932 | 2020-05-10 | Bedford | Virginia | 51019 | 38 | 1 |
132940 | 132940 | 2020-05-10 | Caroline | Virginia | 51033 | 38 | 2 |
132953 | 132953 | 2020-05-10 | Danville city | Virginia | 51590 | 38 | 1 |
133047 | 133047 | 2020-05-10 | Westmoreland | Virginia | 51193 | 38 | 0 |
129942 | 129942 | 2020-05-09 | Bedford | Virginia | 51019 | 38 | 1 |
129950 | 129950 | 2020-05-09 | Caroline | Virginia | 51033 | 38 | 2 |
129994 | 129994 | 2020-05-09 | King George | Virginia | 51099 | 38 | 4 |
127004 | 127004 | 2020-05-08 | King George | Virginia | 51099 | 38 | 4 |
123988 | 123988 | 2020-05-07 | Danville city | Virginia | 51590 | 38 | 1 |
124019 | 124019 | 2020-05-07 | King George | Virginia | 51099 | 38 | 4 |
106551 | 106551 | 2020-05-01 | Washington | Virginia | 51191 | 38 | 3 |
100759 | 100759 | 2020-04-29 | Greensville | Virginia | 51081 | 38 | 6 |
86623 | 86623 | 2020-04-24 | Louisa | Virginia | 51109 | 38 | 0 |
83816 | 83816 | 2020-04-23 | Louisa | Virginia | 51109 | 38 | 0 |
83820 | 83820 | 2020-04-23 | Manassas Park city | Virginia | 51685 | 38 | 1 |
75442 | 75442 | 2020-04-20 | Lynchburg city | Virginia | 51680 | 38 | 0 |
72666 | 72666 | 2020-04-19 | Lynchburg city | Virginia | 51680 | 38 | 0 |
69896 | 69896 | 2020-04-18 | Lynchburg city | Virginia | 51680 | 38 | 0 |
69953 | 69953 | 2020-04-18 | York | Virginia | 51199 | 38 | 1 |
67134 | 67134 | 2020-04-17 | Lynchburg city | Virginia | 51680 | 38 | 0 |
67191 | 67191 | 2020-04-17 | York | Virginia | 51199 | 38 | 1 |
64340 | 64340 | 2020-04-16 | Charlottesville city | Virginia | 51540 | 38 | 1 |
61608 | 61608 | 2020-04-15 | Charlottesville city | Virginia | 51540 | 38 | 1 |
56207 | 56207 | 2020-04-13 | Goochland | Virginia | 51075 | 38 | 0 |
53522 | 53522 | 2020-04-12 | Hanover | Virginia | 51085 | 38 | 0 |
50847 | 50847 | 2020-04-11 | Hanover | Virginia | 51085 | 38 | 0 |
40354 | 40354 | 2020-04-07 | Albemarle | Virginia | 51003 | 38 | 0 |
32997 | 32997 | 2020-04-04 | Stafford | Virginia | 51179 | 38 | 0 |
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);