ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 157 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Williamsburg city 4
- Caroline 3
- Grayson 3
- Lunenburg 3
- Nottoway 3
- Fairfax city 2
- Fluvanna 2
- Warren 2
- Appomattox 1
- Augusta 1
- Bristol city 1
- Brunswick 1
- Buchanan 1
- Campbell 1
- Charlotte 1
- Colonial Heights city 1
- Covington city 1
- Danville city 1
- Emporia city 1
- Falls Church city 1
- Franklin city 1
- Giles 1
- Goochland 1
- Halifax 1
- King William 1
- Louisa 1
- Mathews 1
- New Kent 1
- Northumberland 1
- Patrick 1
- …
state 1
- Virginia · 48 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
855250 | 855250 | 2020-12-22 | Falls Church city | Virginia | 51610 | 157 | 6 |
783840 | 783840 | 2020-11-30 | Covington city | Virginia | 51580 | 157 | 1 |
777399 | 777399 | 2020-11-28 | Mathews | Virginia | 51115 | 157 | 1 |
715736 | 715736 | 2020-11-09 | Lunenburg | Virginia | 51111 | 157 | 5 |
712492 | 712492 | 2020-11-08 | Lunenburg | Virginia | 51111 | 157 | 5 |
709248 | 709248 | 2020-11-07 | Lunenburg | Virginia | 51111 | 157 | 5 |
702737 | 702737 | 2020-11-05 | Giles | Virginia | 51071 | 157 | 0 |
663807 | 663807 | 2020-10-24 | Fairfax city | Virginia | 51600 | 157 | 8 |
654074 | 654074 | 2020-10-21 | Fairfax city | Virginia | 51600 | 157 | 8 |
611882 | 611882 | 2020-10-08 | Charlotte | Virginia | 51037 | 157 | 0 |
585939 | 585939 | 2020-09-30 | Buchanan | Virginia | 51027 | 157 | 2 |
573047 | 573047 | 2020-09-26 | Northumberland | Virginia | 51133 | 157 | 6 |
569783 | 569783 | 2020-09-25 | King William | Virginia | 51101 | 157 | 2 |
527641 | 527641 | 2020-09-12 | Bristol city | Virginia | 51520 | 157 | 2 |
514812 | 514812 | 2020-09-08 | Williamsburg city | Virginia | 51830 | 157 | 6 |
511579 | 511579 | 2020-09-07 | Williamsburg city | Virginia | 51830 | 157 | 6 |
508346 | 508346 | 2020-09-06 | Williamsburg city | Virginia | 51830 | 157 | 6 |
505114 | 505114 | 2020-09-05 | Williamsburg city | Virginia | 51830 | 157 | 6 |
501835 | 501835 | 2020-09-04 | New Kent | Virginia | 51127 | 157 | 1 |
479122 | 479122 | 2020-08-28 | Appomattox | Virginia | 51011 | 157 | 1 |
443703 | 443703 | 2020-08-17 | Russell | Virginia | 51167 | 157 | 3 |
430741 | 430741 | 2020-08-13 | Grayson | Virginia | 51077 | 157 | 5 |
424292 | 424292 | 2020-08-11 | Halifax | Virginia | 51083 | 157 | 1 |
421068 | 421068 | 2020-08-10 | Grayson | Virginia | 51077 | 157 | 5 |
417847 | 417847 | 2020-08-09 | Grayson | Virginia | 51077 | 157 | 5 |
417888 | 417888 | 2020-08-09 | Patrick | Virginia | 51141 | 157 | 4 |
411466 | 411466 | 2020-08-07 | Salem city | Virginia | 51775 | 157 | 3 |
408186 | 408186 | 2020-08-06 | Goochland | Virginia | 51075 | 157 | 7 |
404960 | 404960 | 2020-08-05 | Franklin city | Virginia | 51620 | 157 | 6 |
398500 | 398500 | 2020-08-03 | Campbell | Virginia | 51031 | 157 | 2 |
382523 | 382523 | 2020-07-29 | Washington | Virginia | 51191 | 157 | 4 |
372786 | 372786 | 2020-07-26 | Emporia city | Virginia | 51595 | 157 | 15 |
369581 | 369581 | 2020-07-25 | Fluvanna | Virginia | 51065 | 157 | 8 |
366372 | 366372 | 2020-07-24 | Fluvanna | Virginia | 51065 | 157 | 8 |
366419 | 366419 | 2020-07-24 | Nottoway | Virginia | 51135 | 157 | 6 |
363195 | 363195 | 2020-07-23 | Louisa | Virginia | 51109 | 157 | 2 |
363213 | 363213 | 2020-07-23 | Nottoway | Virginia | 51135 | 157 | 6 |
360007 | 360007 | 2020-07-22 | Nottoway | Virginia | 51135 | 157 | 6 |
353524 | 353524 | 2020-07-20 | Brunswick | Virginia | 51025 | 157 | 1 |
353529 | 353529 | 2020-07-20 | Caroline | Virginia | 51033 | 157 | 4 |
350327 | 350327 | 2020-07-19 | Caroline | Virginia | 51033 | 157 | 4 |
347126 | 347126 | 2020-07-18 | Caroline | Virginia | 51033 | 157 | 4 |
343939 | 343939 | 2020-07-17 | Danville city | Virginia | 51590 | 157 | 2 |
327965 | 327965 | 2020-07-12 | Colonial Heights city | Virginia | 51570 | 157 | 20 |
293178 | 293178 | 2020-07-01 | Southampton | Virginia | 51175 | 157 | 5 |
249162 | 249162 | 2020-06-17 | Augusta | Virginia | 51015 | 157 | 2 |
199729 | 199729 | 2020-06-01 | Warren | Virginia | 51187 | 157 | 2 |
196656 | 196656 | 2020-05-31 | Warren | Virginia | 51187 | 157 | 2 |
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);