ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 432 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 21
county 21
- Craig 3
- Falls Church city 2
- King William 2
- Washington 2
- Brunswick 1
- Cumberland 1
- Grayson 1
- Greene 1
- Henrico 1
- Hopewell city 1
- Lexington city 1
- Lunenburg 1
- Mathews 1
- Norfolk city 1
- Norton city 1
- Page 1
- Poquoson city 1
- Pulaski 1
- Staunton city 1
- Winchester city 1
- York 1
state 1
- Virginia · 26 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1725404 | 1725404 | 2021-09-16 | Norton city | Virginia | 51720 | 432 | 8 |
1712354 | 1712354 | 2021-09-12 | Craig | Virginia | 51045 | 432 | 6 |
1709107 | 1709107 | 2021-09-11 | Craig | Virginia | 51045 | 432 | 6 |
1705860 | 1705860 | 2021-09-10 | Craig | Virginia | 51045 | 432 | 6 |
1588924 | 1588924 | 2021-08-05 | Falls Church city | Virginia | 51610 | 432 | 8 |
1329204 | 1329204 | 2021-05-17 | Falls Church city | Virginia | 51610 | 432 | 9 |
1215555 | 1215555 | 2021-04-12 | Cumberland | Virginia | 51049 | 432 | 9 |
978608 | 978608 | 2021-01-29 | Mathews | Virginia | 51115 | 432 | 6 |
929947 | 929947 | 2021-01-14 | Poquoson city | Virginia | 51735 | 432 | 7 |
913698 | 913698 | 2021-01-09 | Lunenburg | Virginia | 51111 | 432 | 3 |
874746 | 874746 | 2020-12-28 | King William | Virginia | 51101 | 432 | 5 |
871501 | 871501 | 2020-12-27 | King William | Virginia | 51101 | 432 | 5 |
835791 | 835791 | 2020-12-16 | Greene | Virginia | 51079 | 432 | 4 |
822822 | 822822 | 2020-12-12 | Lexington city | Virginia | 51678 | 432 | 3 |
738472 | 738472 | 2020-11-16 | Pulaski | Virginia | 51155 | 432 | 8 |
722201 | 722201 | 2020-11-11 | Grayson | Virginia | 51077 | 432 | 20 |
699460 | 699460 | 2020-11-04 | Brunswick | Virginia | 51025 | 432 | 5 |
696320 | 696320 | 2020-11-03 | Staunton city | Virginia | 51790 | 432 | 4 |
624920 | 624920 | 2020-10-12 | Page | Virginia | 51139 | 432 | 29 |
611921 | 611921 | 2020-10-08 | Hopewell city | Virginia | 51670 | 432 | 7 |
518044 | 518044 | 2020-09-09 | Washington | Virginia | 51191 | 432 | 9 |
514809 | 514809 | 2020-09-08 | Washington | Virginia | 51191 | 432 | 9 |
476012 | 476012 | 2020-08-27 | Winchester city | Virginia | 51840 | 432 | 4 |
466321 | 466321 | 2020-08-24 | York | Virginia | 51199 | 432 | 5 |
178265 | 178265 | 2020-05-25 | Norfolk city | Virginia | 51710 | 432 | 6 |
58920 | 58920 | 2020-04-14 | Henrico | Virginia | 51087 | 432 | 45 |
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);