ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 1302 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
county 9
- Norton city 14
- Manassas Park city 3
- Alleghany 2
- Galax city 1
- Greene 1
- Lancaster 1
- Mathews 1
- Westmoreland 1
- Williamsburg city 1
state 1
- Virginia · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463510 | 2463510 | 2022-05-01 | Norton city | Virginia | 51720 | 1302 | 22 |
2460254 | 2460254 | 2022-04-30 | Norton city | Virginia | 51720 | 1302 | 22 |
2456998 | 2456998 | 2022-04-29 | Norton city | Virginia | 51720 | 1302 | 22 |
2453742 | 2453742 | 2022-04-28 | Norton city | Virginia | 51720 | 1302 | 22 |
2352834 | 2352834 | 2022-03-28 | Norton city | Virginia | 51720 | 1302 | 22 |
2349582 | 2349582 | 2022-03-27 | Norton city | Virginia | 51720 | 1302 | 22 |
2346329 | 2346329 | 2022-03-26 | Norton city | Virginia | 51720 | 1302 | 22 |
2343076 | 2343076 | 2022-03-25 | Norton city | Virginia | 51720 | 1302 | 22 |
2333315 | 2333315 | 2022-03-22 | Norton city | Virginia | 51720 | 1302 | 22 |
2330062 | 2330062 | 2022-03-21 | Norton city | Virginia | 51720 | 1302 | 22 |
2326810 | 2326810 | 2022-03-20 | Norton city | Virginia | 51720 | 1302 | 22 |
2323557 | 2323557 | 2022-03-19 | Norton city | Virginia | 51720 | 1302 | 22 |
2320303 | 2320303 | 2022-03-18 | Norton city | Virginia | 51720 | 1302 | 22 |
2317049 | 2317049 | 2022-03-17 | Norton city | Virginia | 51720 | 1302 | 22 |
2147921 | 2147921 | 2022-01-24 | Mathews | Virginia | 51115 | 1302 | 24 |
2089365 | 2089365 | 2022-01-06 | Lancaster | Virginia | 51103 | 1302 | 24 |
2056917 | 2056917 | 2021-12-27 | Williamsburg city | Virginia | 51830 | 1302 | 13 |
2053615 | 2053615 | 2021-12-26 | Manassas Park city | Virginia | 51685 | 1302 | 15 |
2050365 | 2050365 | 2021-12-25 | Manassas Park city | Virginia | 51685 | 1302 | 15 |
2047115 | 2047115 | 2021-12-24 | Manassas Park city | Virginia | 51685 | 1302 | 15 |
1679883 | 1679883 | 2021-09-02 | Galax city | Virginia | 51640 | 1302 | 53 |
1491513 | 1491513 | 2021-07-06 | Greene | Virginia | 51079 | 1302 | 18 |
1365007 | 1365007 | 2021-05-28 | Westmoreland | Virginia | 51193 | 1302 | 26 |
1248002 | 1248002 | 2021-04-22 | Alleghany | Virginia | 51005 | 1302 | 48 |
1241508 | 1241508 | 2021-04-20 | Alleghany | Virginia | 51005 | 1302 | 48 |
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);