ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where cases = 91 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Grayson 5
- Highland 5
- Madison 4
- Bedford 3
- Clarke 3
- Isle of Wight 3
- Pulaski 3
- Montgomery 2
- Nelson 2
- Westmoreland 2
- Williamsburg city 2
- Amelia 1
- Bristol city 1
- Brunswick 1
- Carroll 1
- Charles City 1
- Colonial Heights city 1
- Danville city 1
- Dickenson 1
- Emporia city 1
- Fairfax city 1
- Fluvanna 1
- Franklin 1
- Hanover 1
- King George 1
- King William 1
- Lee 1
- Lynchburg city 1
- Mathews 1
- Northumberland 1
- …
state 1
- Virginia · 67 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1082454 | 1082454 | 2021-03-02 | Highland | Virginia | 51091 | 91 | 0 |
1079208 | 1079208 | 2021-03-01 | Highland | Virginia | 51091 | 91 | 0 |
1075963 | 1075963 | 2021-02-28 | Highland | Virginia | 51091 | 91 | 0 |
1072717 | 1072717 | 2021-02-27 | Highland | Virginia | 51091 | 91 | 0 |
1069471 | 1069471 | 2021-02-26 | Highland | Virginia | 51091 | 91 | 0 |
796879 | 796879 | 2020-12-04 | Norton city | Virginia | 51720 | 91 | 0 |
657376 | 657376 | 2020-10-22 | Poquoson city | Virginia | 51735 | 91 | 2 |
634582 | 634582 | 2020-10-15 | Charles City | Virginia | 51036 | 91 | 5 |
602211 | 602211 | 2020-10-05 | Mathews | Virginia | 51115 | 91 | 0 |
560030 | 560030 | 2020-09-22 | Dickenson | Virginia | 51051 | 91 | 1 |
553550 | 553550 | 2020-09-20 | Clarke | Virginia | 51043 | 91 | 0 |
550311 | 550311 | 2020-09-19 | Clarke | Virginia | 51043 | 91 | 0 |
547072 | 547072 | 2020-09-18 | Clarke | Virginia | 51043 | 91 | 0 |
524474 | 524474 | 2020-09-11 | Nelson | Virginia | 51125 | 91 | 0 |
521238 | 521238 | 2020-09-10 | Nelson | Virginia | 51125 | 91 | 0 |
495359 | 495359 | 2020-09-02 | Madison | Virginia | 51113 | 91 | 2 |
495372 | 495372 | 2020-09-02 | Northumberland | Virginia | 51133 | 91 | 5 |
492125 | 492125 | 2020-09-01 | Madison | Virginia | 51113 | 91 | 2 |
488892 | 488892 | 2020-08-31 | Madison | Virginia | 51113 | 91 | 2 |
485659 | 485659 | 2020-08-30 | Madison | Virginia | 51113 | 91 | 2 |
456508 | 456508 | 2020-08-21 | Amelia | Virginia | 51007 | 91 | 2 |
456606 | 456606 | 2020-08-21 | Radford city | Virginia | 51750 | 91 | 0 |
443694 | 443694 | 2020-08-17 | Pulaski | Virginia | 51155 | 91 | 3 |
440468 | 440468 | 2020-08-16 | Pulaski | Virginia | 51155 | 91 | 3 |
437242 | 437242 | 2020-08-15 | Pulaski | Virginia | 51155 | 91 | 3 |
433928 | 433928 | 2020-08-14 | Bristol city | Virginia | 51520 | 91 | 0 |
427527 | 427527 | 2020-08-12 | King William | Virginia | 51101 | 91 | 2 |
424276 | 424276 | 2020-08-11 | Fairfax city | Virginia | 51600 | 91 | 7 |
417908 | 417908 | 2020-08-09 | Scott | Virginia | 51169 | 91 | 3 |
408246 | 408246 | 2020-08-06 | Russell | Virginia | 51167 | 91 | 2 |
388901 | 388901 | 2020-07-31 | Lee | Virginia | 51105 | 91 | 1 |
376079 | 376079 | 2020-07-27 | Smyth | Virginia | 51173 | 91 | 2 |
347235 | 347235 | 2020-07-18 | Williamsburg city | Virginia | 51830 | 91 | 6 |
344035 | 344035 | 2020-07-17 | Williamsburg city | Virginia | 51830 | 91 | 6 |
324804 | 324804 | 2020-07-11 | Grayson | Virginia | 51077 | 91 | 4 |
324850 | 324850 | 2020-07-11 | Powhatan | Virginia | 51145 | 91 | 2 |
321623 | 321623 | 2020-07-10 | Grayson | Virginia | 51077 | 91 | 4 |
318444 | 318444 | 2020-07-09 | Grayson | Virginia | 51077 | 91 | 4 |
315271 | 315271 | 2020-07-08 | Grayson | Virginia | 51077 | 91 | 2 |
312096 | 312096 | 2020-07-07 | Grayson | Virginia | 51077 | 91 | 2 |
302670 | 302670 | 2020-07-04 | Waynesboro city | Virginia | 51820 | 91 | 0 |
299412 | 299412 | 2020-07-03 | Danville city | Virginia | 51590 | 91 | 2 |
293106 | 293106 | 2020-07-01 | Franklin | Virginia | 51067 | 91 | 1 |
264896 | 264896 | 2020-06-22 | Westmoreland | Virginia | 51193 | 91 | 1 |
261654 | 261654 | 2020-06-21 | Brunswick | Virginia | 51025 | 91 | 1 |
261767 | 261767 | 2020-06-21 | Westmoreland | Virginia | 51193 | 91 | 1 |
246104 | 246104 | 2020-06-16 | King George | Virginia | 51099 | 91 | 4 |
242939 | 242939 | 2020-06-15 | Bedford | Virginia | 51019 | 91 | 2 |
239828 | 239828 | 2020-06-14 | Bedford | Virginia | 51019 | 91 | 2 |
236720 | 236720 | 2020-06-13 | Bedford | Virginia | 51019 | 91 | 2 |
236840 | 236840 | 2020-06-13 | York | Virginia | 51199 | 91 | 3 |
233674 | 233674 | 2020-06-12 | Lynchburg city | Virginia | 51680 | 91 | 1 |
224327 | 224327 | 2020-06-09 | Emporia city | Virginia | 51595 | 91 | 6 |
218185 | 218185 | 2020-06-07 | Montgomery | Virginia | 51121 | 91 | 1 |
215095 | 215095 | 2020-06-06 | Montgomery | Virginia | 51121 | 91 | 1 |
193483 | 193483 | 2020-05-30 | Carroll | Virginia | 51035 | 91 | 1 |
193490 | 193490 | 2020-05-30 | Colonial Heights city | Virginia | 51570 | 91 | 17 |
193504 | 193504 | 2020-05-30 | Fluvanna | Virginia | 51065 | 91 | 6 |
184365 | 184365 | 2020-05-27 | Orange | Virginia | 51137 | 91 | 0 |
157055 | 157055 | 2020-05-18 | Sussex | Virginia | 51183 | 91 | 1 |
127047 | 127047 | 2020-05-08 | Roanoke city | Virginia | 51770 | 91 | 1 |
100797 | 100797 | 2020-04-29 | Page | Virginia | 51139 | 91 | 1 |
89429 | 89429 | 2020-04-25 | Isle of Wight | Virginia | 51093 | 91 | 2 |
86614 | 86614 | 2020-04-24 | Isle of Wight | Virginia | 51093 | 91 | 2 |
83807 | 83807 | 2020-04-23 | Isle of Wight | Virginia | 51093 | 91 | 2 |
75426 | 75426 | 2020-04-20 | Hanover | Virginia | 51085 | 91 | 0 |
72709 | 72709 | 2020-04-19 | Suffolk city | Virginia | 51800 | 91 | 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);