ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where "date" is on date 2020-03-24 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Accomack 1
- Albemarle 1
- Alexandria city 1
- Amherst 1
- Arlington 1
- Bedford 1
- Botetourt 1
- Charles City 1
- Charlottesville city 1
- Chesapeake city 1
- Chesterfield 1
- Culpeper 1
- Danville city 1
- Fairfax 1
- Fluvanna 1
- Franklin 1
- Gloucester 1
- Goochland 1
- Halifax 1
- Hanover 1
- Harrisonburg city 1
- Henrico 1
- Isle of Wight 1
- James City 1
- Lee 1
- Loudoun 1
- Louisa 1
- Mecklenburg 1
- Newport News city 1
- Norfolk city 1
- …
state 1
- Virginia · 43 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10710 | 10710 | 2020-03-24 | Accomack | Virginia | 51001 | 1 | 0 |
10711 | 10711 | 2020-03-24 | Albemarle | Virginia | 51003 | 2 | 0 |
10712 | 10712 | 2020-03-24 | Alexandria city | Virginia | 51510 | 8 | 0 |
10713 | 10713 | 2020-03-24 | Amherst | Virginia | 51009 | 1 | 0 |
10714 | 10714 | 2020-03-24 | Arlington | Virginia | 51013 | 36 | 0 |
10715 | 10715 | 2020-03-24 | Bedford | Virginia | 51019 | 1 | 0 |
10716 | 10716 | 2020-03-24 | Botetourt | Virginia | 51023 | 1 | 0 |
10717 | 10717 | 2020-03-24 | Charles City | Virginia | 51036 | 1 | 0 |
10718 | 10718 | 2020-03-24 | Charlottesville city | Virginia | 51540 | 5 | 0 |
10719 | 10719 | 2020-03-24 | Chesapeake city | Virginia | 51550 | 1 | 0 |
10720 | 10720 | 2020-03-24 | Chesterfield | Virginia | 51041 | 10 | 0 |
10721 | 10721 | 2020-03-24 | Culpeper | Virginia | 51047 | 2 | 0 |
10722 | 10722 | 2020-03-24 | Danville city | Virginia | 51590 | 1 | 0 |
10723 | 10723 | 2020-03-24 | Fairfax | Virginia | 51059 | 46 | 1 |
10724 | 10724 | 2020-03-24 | Fluvanna | Virginia | 51065 | 1 | 0 |
10725 | 10725 | 2020-03-24 | Franklin | Virginia | 51067 | 1 | 0 |
10726 | 10726 | 2020-03-24 | Gloucester | Virginia | 51073 | 2 | 0 |
10727 | 10727 | 2020-03-24 | Goochland | Virginia | 51075 | 3 | 0 |
10728 | 10728 | 2020-03-24 | Halifax | Virginia | 51083 | 1 | 0 |
10729 | 10729 | 2020-03-24 | Hanover | Virginia | 51085 | 2 | 0 |
10730 | 10730 | 2020-03-24 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
10731 | 10731 | 2020-03-24 | Henrico | Virginia | 51087 | 14 | 0 |
10732 | 10732 | 2020-03-24 | Isle of Wight | Virginia | 51093 | 2 | 0 |
10733 | 10733 | 2020-03-24 | James City | Virginia | 51095 | 37 | 3 |
10734 | 10734 | 2020-03-24 | Lee | Virginia | 51105 | 2 | 0 |
10735 | 10735 | 2020-03-24 | Loudoun | Virginia | 51107 | 18 | 0 |
10736 | 10736 | 2020-03-24 | Louisa | Virginia | 51109 | 2 | 0 |
10737 | 10737 | 2020-03-24 | Mecklenburg | Virginia | 51117 | 2 | 0 |
10738 | 10738 | 2020-03-24 | Newport News city | Virginia | 51700 | 3 | 1 |
10739 | 10739 | 2020-03-24 | Norfolk city | Virginia | 51710 | 5 | 0 |
10740 | 10740 | 2020-03-24 | Portsmouth city | Virginia | 51740 | 3 | 0 |
10741 | 10741 | 2020-03-24 | Prince Edward | Virginia | 51147 | 1 | 0 |
10742 | 10742 | 2020-03-24 | Prince William | Virginia | 51153 | 23 | 0 |
10743 | 10743 | 2020-03-24 | Richmond city | Virginia | 51760 | 11 | 0 |
10744 | 10744 | 2020-03-24 | Rockbridge | Virginia | 51163 | 1 | 0 |
10745 | 10745 | 2020-03-24 | Rockingham | Virginia | 51165 | 3 | 0 |
10746 | 10746 | 2020-03-24 | Spotsylvania | Virginia | 51177 | 2 | 0 |
10747 | 10747 | 2020-03-24 | Stafford | Virginia | 51179 | 6 | 0 |
10748 | 10748 | 2020-03-24 | Suffolk city | Virginia | 51800 | 1 | 0 |
10749 | 10749 | 2020-03-24 | Unknown | Virginia | 0 | 1 | |
10750 | 10750 | 2020-03-24 | Virginia Beach city | Virginia | 51810 | 17 | 0 |
10751 | 10751 | 2020-03-24 | Williamsburg city | Virginia | 51830 | 5 | 1 |
10752 | 10752 | 2020-03-24 | York | Virginia | 51199 | 6 | 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);