ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where deaths = 260 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 14
county 14
- Arlington 14
- Henry 14
- Henrico 6
- Hanover 4
- Suffolk city 4
- Newport News city 3
- Portsmouth city 3
- Hampton city 2
- Lynchburg city 2
- Chesterfield 1
- Danville city 1
- Loudoun 1
- Prince William 1
- Roanoke city 1
state 1
- Virginia · 57 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2385341 | 2385341 | 2022-04-07 | Henry | Virginia | 51089 | 11717 | 260 |
2382086 | 2382086 | 2022-04-06 | Henry | Virginia | 51089 | 11679 | 260 |
2378831 | 2378831 | 2022-04-05 | Henry | Virginia | 51089 | 11668 | 260 |
2375577 | 2375577 | 2022-04-04 | Henry | Virginia | 51089 | 11653 | 260 |
2372325 | 2372325 | 2022-04-03 | Henry | Virginia | 51089 | 11626 | 260 |
2369072 | 2369072 | 2022-04-02 | Henry | Virginia | 51089 | 11626 | 260 |
2365819 | 2365819 | 2022-04-01 | Henry | Virginia | 51089 | 11626 | 260 |
2362566 | 2362566 | 2022-03-31 | Henry | Virginia | 51089 | 11621 | 260 |
2359312 | 2359312 | 2022-03-30 | Henry | Virginia | 51089 | 11600 | 260 |
2356058 | 2356058 | 2022-03-29 | Henry | Virginia | 51089 | 11599 | 260 |
2352805 | 2352805 | 2022-03-28 | Henry | Virginia | 51089 | 11591 | 260 |
2349553 | 2349553 | 2022-03-27 | Henry | Virginia | 51089 | 11584 | 260 |
2346300 | 2346300 | 2022-03-26 | Henry | Virginia | 51089 | 11584 | 260 |
2343047 | 2343047 | 2022-03-25 | Henry | Virginia | 51089 | 11584 | 260 |
2284471 | 2284471 | 2022-03-07 | Danville city | Virginia | 51590 | 10930 | 260 |
2281243 | 2281243 | 2022-03-06 | Hanover | Virginia | 51085 | 21407 | 260 |
2277990 | 2277990 | 2022-03-05 | Hanover | Virginia | 51085 | 21407 | 260 |
2274737 | 2274737 | 2022-03-04 | Hanover | Virginia | 51085 | 21407 | 260 |
2271484 | 2271484 | 2022-03-03 | Hanover | Virginia | 51085 | 21387 | 260 |
2264996 | 2264996 | 2022-03-01 | Lynchburg city | Virginia | 51680 | 19704 | 260 |
2261746 | 2261746 | 2022-02-28 | Lynchburg city | Virginia | 51680 | 19668 | 260 |
2157697 | 2157697 | 2022-01-27 | Portsmouth city | Virginia | 51740 | 19610 | 260 |
2154444 | 2154444 | 2022-01-26 | Portsmouth city | Virginia | 51740 | 19507 | 260 |
2151150 | 2151150 | 2022-01-25 | Hampton city | Virginia | 51650 | 25359 | 260 |
2151191 | 2151191 | 2022-01-25 | Portsmouth city | Virginia | 51740 | 19380 | 260 |
2147898 | 2147898 | 2022-01-24 | Hampton city | Virginia | 51650 | 25207 | 260 |
2079662 | 2079662 | 2022-01-03 | Suffolk city | Virginia | 51800 | 12982 | 260 |
2076410 | 2076410 | 2022-01-02 | Suffolk city | Virginia | 51800 | 12561 | 260 |
2073159 | 2073159 | 2022-01-01 | Suffolk city | Virginia | 51800 | 12561 | 260 |
2069908 | 2069908 | 2021-12-31 | Suffolk city | Virginia | 51800 | 12561 | 260 |
2014644 | 2014644 | 2021-12-14 | Roanoke city | Virginia | 51770 | 13409 | 260 |
1735150 | 1735150 | 2021-09-19 | Newport News city | Virginia | 51700 | 18488 | 260 |
1731900 | 1731900 | 2021-09-18 | Newport News city | Virginia | 51700 | 18488 | 260 |
1728650 | 1728650 | 2021-09-17 | Newport News city | Virginia | 51700 | 18488 | 260 |
1689594 | 1689594 | 2021-09-05 | Arlington | Virginia | 51013 | 16736 | 260 |
1686344 | 1686344 | 2021-09-04 | Arlington | Virginia | 51013 | 16736 | 260 |
1683093 | 1683093 | 2021-09-03 | Arlington | Virginia | 51013 | 16736 | 260 |
1679843 | 1679843 | 2021-09-02 | Arlington | Virginia | 51013 | 16680 | 260 |
1676595 | 1676595 | 2021-09-01 | Arlington | Virginia | 51013 | 16649 | 260 |
1673348 | 1673348 | 2021-08-31 | Arlington | Virginia | 51013 | 16619 | 260 |
1670100 | 1670100 | 2021-08-30 | Arlington | Virginia | 51013 | 16597 | 260 |
1666853 | 1666853 | 2021-08-29 | Arlington | Virginia | 51013 | 16493 | 260 |
1663605 | 1663605 | 2021-08-28 | Arlington | Virginia | 51013 | 16493 | 260 |
1660357 | 1660357 | 2021-08-27 | Arlington | Virginia | 51013 | 16493 | 260 |
1657108 | 1657108 | 2021-08-26 | Arlington | Virginia | 51013 | 16458 | 260 |
1653861 | 1653861 | 2021-08-25 | Arlington | Virginia | 51013 | 16415 | 260 |
1650615 | 1650615 | 2021-08-24 | Arlington | Virginia | 51013 | 16362 | 260 |
1647366 | 1647366 | 2021-08-23 | Arlington | Virginia | 51013 | 16327 | 260 |
1108433 | 1108433 | 2021-03-10 | Loudoun | Virginia | 51107 | 23641 | 260 |
1059701 | 1059701 | 2021-02-23 | Chesterfield | Virginia | 51041 | 23172 | 260 |
884516 | 884516 | 2020-12-31 | Prince William | Virginia | 51153 | 25519 | 260 |
809829 | 809829 | 2020-12-08 | Henrico | Virginia | 51087 | 9281 | 260 |
806584 | 806584 | 2020-12-07 | Henrico | Virginia | 51087 | 9137 | 260 |
803339 | 803339 | 2020-12-06 | Henrico | Virginia | 51087 | 8988 | 260 |
800094 | 800094 | 2020-12-05 | Henrico | Virginia | 51087 | 8838 | 260 |
796849 | 796849 | 2020-12-04 | Henrico | Virginia | 51087 | 8710 | 260 |
793604 | 793604 | 2020-12-03 | Henrico | Virginia | 51087 | 8615 | 260 |
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);