ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 613 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 12
county 12
- Covington city 4
- Madison 4
- Manassas Park city 4
- Bland 3
- Buckingham 1
- Essex 1
- Gloucester 1
- Lunenburg 1
- Newport News city 1
- Prince Edward 1
- Salem city 1
- Waynesboro city 1
state 1
- Virginia · 23 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1501229 | 1501229 | 2021-07-09 | Covington city | Virginia | 51580 | 613 | 14 |
1478548 | 1478548 | 2021-07-02 | Madison | Virginia | 51113 | 613 | 14 |
1475302 | 1475302 | 2021-07-01 | Madison | Virginia | 51113 | 613 | 14 |
1472056 | 1472056 | 2021-06-30 | Madison | Virginia | 51113 | 613 | 14 |
1420081 | 1420081 | 2021-06-14 | Covington city | Virginia | 51580 | 613 | 14 |
1390872 | 1390872 | 2021-06-05 | Covington city | Virginia | 51580 | 613 | 14 |
1306514 | 1306514 | 2021-05-10 | Madison | Virginia | 51113 | 613 | 16 |
1043517 | 1043517 | 2021-02-18 | Lunenburg | Virginia | 51111 | 613 | 4 |
1040236 | 1040236 | 2021-02-17 | Essex | Virginia | 51057 | 613 | 4 |
1030475 | 1030475 | 2021-02-14 | Bland | Virginia | 51021 | 613 | 9 |
1027228 | 1027228 | 2021-02-13 | Bland | Virginia | 51021 | 613 | 9 |
1027245 | 1027245 | 2021-02-13 | Covington city | Virginia | 51580 | 613 | 4 |
1023983 | 1023983 | 2021-02-12 | Bland | Virginia | 51021 | 613 | 9 |
822802 | 822802 | 2020-12-12 | Gloucester | Virginia | 51073 | 613 | 5 |
774202 | 774202 | 2020-11-27 | Waynesboro city | Virginia | 51820 | 613 | 5 |
689827 | 689827 | 2020-11-01 | Salem city | Virginia | 51775 | 613 | 10 |
598988 | 598988 | 2020-10-04 | Prince Edward | Virginia | 51147 | 613 | 12 |
595722 | 595722 | 2020-10-03 | Manassas Park city | Virginia | 51685 | 613 | 8 |
592480 | 592480 | 2020-10-02 | Manassas Park city | Virginia | 51685 | 613 | 8 |
589240 | 589240 | 2020-10-01 | Manassas Park city | Virginia | 51685 | 613 | 8 |
579520 | 579520 | 2020-09-28 | Manassas Park city | Virginia | 51685 | 613 | 8 |
433931 | 433931 | 2020-08-14 | Buckingham | Virginia | 51029 | 613 | 8 |
312129 | 312129 | 2020-07-07 | Newport News city | Virginia | 51700 | 613 | 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);