ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 466 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 19
county 19
- Charles City 3
- King and Queen 3
- Prince Edward 3
- Surry 3
- Charlottesville city 1
- Essex 1
- Fairfax city 1
- Fluvanna 1
- Galax city 1
- Lancaster 1
- Middlesex 1
- Nelson 1
- Newport News city 1
- Northampton 1
- Rappahannock 1
- Russell 1
- Southampton 1
- Sussex 1
- Tazewell 1
state 1
- Virginia · 27 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1702684 | 1702684 | 2021-09-09 | Rappahannock | Virginia | 51157 | 466 | 3 |
1666912 | 1666912 | 2021-08-29 | King and Queen | Virginia | 51097 | 466 | 7 |
1663664 | 1663664 | 2021-08-28 | King and Queen | Virginia | 51097 | 466 | 7 |
1660416 | 1660416 | 2021-08-27 | King and Queen | Virginia | 51097 | 466 | 7 |
1644230 | 1644230 | 2021-08-22 | Surry | Virginia | 51181 | 466 | 9 |
1640980 | 1640980 | 2021-08-21 | Surry | Virginia | 51181 | 466 | 9 |
1637730 | 1637730 | 2021-08-20 | Surry | Virginia | 51181 | 466 | 9 |
1212298 | 1212298 | 2021-04-11 | Charles City | Virginia | 51036 | 466 | 15 |
1209049 | 1209049 | 2021-04-10 | Charles City | Virginia | 51036 | 466 | 15 |
1205801 | 1205801 | 2021-04-09 | Charles City | Virginia | 51036 | 466 | 15 |
1036993 | 1036993 | 2021-02-16 | Fairfax city | Virginia | 51600 | 466 | 12 |
1033790 | 1033790 | 2021-02-15 | Middlesex | Virginia | 51119 | 466 | 16 |
939654 | 939654 | 2021-01-17 | Lancaster | Virginia | 51103 | 466 | 3 |
936378 | 936378 | 2021-01-16 | Essex | Virginia | 51057 | 466 | 3 |
933179 | 933179 | 2021-01-15 | Nelson | Virginia | 51125 | 466 | 4 |
903976 | 903976 | 2021-01-06 | Northampton | Virginia | 51131 | 466 | 31 |
741660 | 741660 | 2020-11-17 | Fluvanna | Virginia | 51065 | 466 | 9 |
696249 | 696249 | 2020-11-03 | Galax city | Virginia | 51640 | 466 | 30 |
667124 | 667124 | 2020-10-25 | Russell | Virginia | 51167 | 466 | 8 |
660647 | 660647 | 2020-10-23 | Tazewell | Virginia | 51185 | 466 | 2 |
579566 | 579566 | 2020-09-28 | Sussex | Virginia | 51183 | 466 | 11 |
534215 | 534215 | 2020-09-14 | Southampton | Virginia | 51175 | 466 | 14 |
466287 | 466287 | 2020-08-24 | Prince Edward | Virginia | 51147 | 466 | 11 |
463058 | 463058 | 2020-08-23 | Prince Edward | Virginia | 51147 | 466 | 11 |
459829 | 459829 | 2020-08-22 | Prince Edward | Virginia | 51147 | 466 | 11 |
388856 | 388856 | 2020-07-31 | Charlottesville city | Virginia | 51540 | 466 | 11 |
274256 | 274256 | 2020-06-25 | Newport News city | Virginia | 51700 | 466 | 10 |
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);