ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 521 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 17
county 17
- Charles City 2
- Fairfax city 2
- Bland 1
- Botetourt 1
- Brunswick 1
- Buckingham 1
- Chesapeake city 1
- Emporia city 1
- Franklin city 1
- Frederick 1
- Gloucester 1
- Madison 1
- Norfolk city 1
- Norton city 1
- Page 1
- Russell 1
- Scott 1
state 1
- Virginia · 19 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1793636 | 1793636 | 2021-10-07 | Norton city | Virginia | 51720 | 521 | 12 |
1540186 | 1540186 | 2021-07-21 | Charles City | Virginia | 51036 | 521 | 16 |
1520702 | 1520702 | 2021-07-15 | Charles City | Virginia | 51036 | 521 | 16 |
1173340 | 1173340 | 2021-03-30 | Fairfax city | Virginia | 51600 | 521 | 18 |
1170093 | 1170093 | 2021-03-29 | Fairfax city | Virginia | 51600 | 521 | 18 |
1024046 | 1024046 | 2021-02-12 | Madison | Virginia | 51113 | 521 | 7 |
949360 | 949360 | 2021-01-20 | Emporia city | Virginia | 51595 | 521 | 31 |
907147 | 907147 | 2021-01-07 | Bland | Virginia | 51021 | 521 | 6 |
829260 | 829260 | 2020-12-14 | Brunswick | Virginia | 51025 | 521 | 8 |
790350 | 790350 | 2020-12-02 | Gloucester | Virginia | 51073 | 521 | 3 |
725484 | 725484 | 2020-11-12 | Page | Virginia | 51139 | 521 | 31 |
722194 | 722194 | 2020-11-11 | Franklin city | Virginia | 51620 | 521 | 14 |
709288 | 709288 | 2020-11-07 | Scott | Virginia | 51169 | 521 | 9 |
705944 | 705944 | 2020-11-06 | Botetourt | Virginia | 51023 | 521 | 13 |
686581 | 686581 | 2020-10-31 | Russell | Virginia | 51167 | 521 | 8 |
305753 | 305753 | 2020-07-05 | Frederick | Virginia | 51069 | 521 | 6 |
242944 | 242944 | 2020-06-15 | Buckingham | Virginia | 51029 | 521 | 3 |
199690 | 199690 | 2020-06-01 | Norfolk city | Virginia | 51710 | 521 | 6 |
196557 | 196557 | 2020-05-31 | Chesapeake city | Virginia | 51550 | 521 | 15 |
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);