ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
263 rows where deaths = 74 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Charlottesville city 29
- Franklin 17
- Alexandria city 15
- Tazewell 13
- Southampton 12
- Isle of Wight 11
- Petersburg city 11
- Augusta 10
- Nottoway 9
- Winchester city 9
- Accomack 7
- Grayson 7
- Alleghany 6
- Russell 6
- Shenandoah 6
- Carroll 5
- Rockingham 5
- Stafford 5
- York 5
- Albemarle 4
- Botetourt 4
- Caroline 4
- Martinsville city 4
- Mecklenburg 4
- Page 4
- Pittsylvania 4
- Amherst 3
- Rockbridge 3
- Spotsylvania 3
- Warren 3
- …
state 1
- Virginia · 263 ✖
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 2502533 | 2502533 | 2022-05-13 | Charlottesville city | Virginia | 51540 | 9466 | 74 |
| 2499275 | 2499275 | 2022-05-12 | Charlottesville city | Virginia | 51540 | 9428 | 74 |
| 2496017 | 2496017 | 2022-05-11 | Charlottesville city | Virginia | 51540 | 9372 | 74 |
| 2492759 | 2492759 | 2022-05-10 | Charlottesville city | Virginia | 51540 | 9335 | 74 |
| 2489501 | 2489501 | 2022-05-09 | Charlottesville city | Virginia | 51540 | 9300 | 74 |
| 2486244 | 2486244 | 2022-05-08 | Charlottesville city | Virginia | 51540 | 9244 | 74 |
| 2482986 | 2482986 | 2022-05-07 | Charlottesville city | Virginia | 51540 | 9244 | 74 |
| 2479728 | 2479728 | 2022-05-06 | Charlottesville city | Virginia | 51540 | 9244 | 74 |
| 2476470 | 2476470 | 2022-05-05 | Charlottesville city | Virginia | 51540 | 9221 | 74 |
| 2473212 | 2473212 | 2022-05-04 | Charlottesville city | Virginia | 51540 | 9190 | 74 |
| 2469956 | 2469956 | 2022-05-03 | Charlottesville city | Virginia | 51540 | 9133 | 74 |
| 2466700 | 2466700 | 2022-05-02 | Charlottesville city | Virginia | 51540 | 9118 | 74 |
| 2463445 | 2463445 | 2022-05-01 | Charlottesville city | Virginia | 51540 | 9075 | 74 |
| 2460189 | 2460189 | 2022-04-30 | Charlottesville city | Virginia | 51540 | 9075 | 74 |
| 2456933 | 2456933 | 2022-04-29 | Charlottesville city | Virginia | 51540 | 9075 | 74 |
| 2453677 | 2453677 | 2022-04-28 | Charlottesville city | Virginia | 51540 | 9060 | 74 |
| 2450421 | 2450421 | 2022-04-27 | Charlottesville city | Virginia | 51540 | 9028 | 74 |
| 2447164 | 2447164 | 2022-04-26 | Charlottesville city | Virginia | 51540 | 9002 | 74 |
| 2443909 | 2443909 | 2022-04-25 | Charlottesville city | Virginia | 51540 | 8984 | 74 |
| 2440653 | 2440653 | 2022-04-24 | Charlottesville city | Virginia | 51540 | 8955 | 74 |
| 2437397 | 2437397 | 2022-04-23 | Charlottesville city | Virginia | 51540 | 8955 | 74 |
| 2434141 | 2434141 | 2022-04-22 | Charlottesville city | Virginia | 51540 | 8955 | 74 |
| 2430885 | 2430885 | 2022-04-21 | Charlottesville city | Virginia | 51540 | 8943 | 74 |
| 2427629 | 2427629 | 2022-04-20 | Charlottesville city | Virginia | 51540 | 8930 | 74 |
| 2424373 | 2424373 | 2022-04-19 | Charlottesville city | Virginia | 51540 | 8916 | 74 |
| 2421117 | 2421117 | 2022-04-18 | Charlottesville city | Virginia | 51540 | 8915 | 74 |
| 2417861 | 2417861 | 2022-04-17 | Charlottesville city | Virginia | 51540 | 8915 | 74 |
| 2414605 | 2414605 | 2022-04-16 | Charlottesville city | Virginia | 51540 | 8915 | 74 |
| 2411349 | 2411349 | 2022-04-15 | Charlottesville city | Virginia | 51540 | 8915 | 74 |
| 2385381 | 2385381 | 2022-04-07 | Prince George | Virginia | 51149 | 8437 | 74 |
| 2382126 | 2382126 | 2022-04-06 | Prince George | Virginia | 51149 | 8436 | 74 |
| 2307215 | 2307215 | 2022-03-14 | Bristol city | Virginia | 51520 | 4370 | 74 |
| 2265052 | 2265052 | 2022-03-01 | Winchester city | Virginia | 51840 | 6225 | 74 |
| 2261802 | 2261802 | 2022-02-28 | Winchester city | Virginia | 51840 | 6223 | 74 |
| 2258441 | 2258441 | 2022-02-27 | Caroline | Virginia | 51033 | 6774 | 74 |
| 2258551 | 2258551 | 2022-02-27 | Winchester city | Virginia | 51840 | 6216 | 74 |
| 2255190 | 2255190 | 2022-02-26 | Caroline | Virginia | 51033 | 6774 | 74 |
| 2255300 | 2255300 | 2022-02-26 | Winchester city | Virginia | 51840 | 6216 | 74 |
| 2251939 | 2251939 | 2022-02-25 | Caroline | Virginia | 51033 | 6774 | 74 |
| 2252049 | 2252049 | 2022-02-25 | Winchester city | Virginia | 51840 | 6216 | 74 |
| 2248688 | 2248688 | 2022-02-24 | Caroline | Virginia | 51033 | 6766 | 74 |
| 2248716 | 2248716 | 2022-02-24 | Galax city | Virginia | 51640 | 2515 | 74 |
| 2248777 | 2248777 | 2022-02-24 | Rockbridge | Virginia | 51163 | 3191 | 74 |
| 2248798 | 2248798 | 2022-02-24 | Winchester city | Virginia | 51840 | 6216 | 74 |
| 2245526 | 2245526 | 2022-02-23 | Rockbridge | Virginia | 51163 | 3184 | 74 |
| 2245547 | 2245547 | 2022-02-23 | Winchester city | Virginia | 51840 | 6224 | 74 |
| 2242275 | 2242275 | 2022-02-22 | Rockbridge | Virginia | 51163 | 3176 | 74 |
| 2242296 | 2242296 | 2022-02-22 | Winchester city | Virginia | 51840 | 6224 | 74 |
| 2239045 | 2239045 | 2022-02-21 | Winchester city | Virginia | 51840 | 6224 | 74 |
| 2222695 | 2222695 | 2022-02-16 | Dinwiddie | Virginia | 51053 | 5111 | 74 |
| 2222712 | 2222712 | 2022-02-16 | Grayson | Virginia | 51077 | 3806 | 74 |
| 2219444 | 2219444 | 2022-02-15 | Dinwiddie | Virginia | 51053 | 5100 | 74 |
| 2219461 | 2219461 | 2022-02-15 | Grayson | Virginia | 51077 | 3792 | 74 |
| 2216211 | 2216211 | 2022-02-14 | Grayson | Virginia | 51077 | 3773 | 74 |
| 2212960 | 2212960 | 2022-02-13 | Grayson | Virginia | 51077 | 3732 | 74 |
| 2209707 | 2209707 | 2022-02-12 | Grayson | Virginia | 51077 | 3732 | 74 |
| 2206454 | 2206454 | 2022-02-11 | Grayson | Virginia | 51077 | 3732 | 74 |
| 2203201 | 2203201 | 2022-02-10 | Grayson | Virginia | 51077 | 3714 | 74 |
| 2190139 | 2190139 | 2022-02-06 | Amherst | Virginia | 51009 | 6385 | 74 |
| 2186886 | 2186886 | 2022-02-05 | Amherst | Virginia | 51009 | 6385 | 74 |
| 2183633 | 2183633 | 2022-02-04 | Amherst | Virginia | 51009 | 6385 | 74 |
| 2180388 | 2180388 | 2022-02-03 | Botetourt | Virginia | 51023 | 6520 | 74 |
| 2180465 | 2180465 | 2022-02-03 | Nottoway | Virginia | 51135 | 3711 | 74 |
| 2177137 | 2177137 | 2022-02-02 | Botetourt | Virginia | 51023 | 6487 | 74 |
| 2177214 | 2177214 | 2022-02-02 | Nottoway | Virginia | 51135 | 3696 | 74 |
| 2173884 | 2173884 | 2022-02-01 | Botetourt | Virginia | 51023 | 6457 | 74 |
| 2173899 | 2173899 | 2022-02-01 | Colonial Heights city | Virginia | 51570 | 4484 | 74 |
| 2173940 | 2173940 | 2022-02-01 | Lee | Virginia | 51105 | 5345 | 74 |
| 2173961 | 2173961 | 2022-02-01 | Nottoway | Virginia | 51135 | 3677 | 74 |
| 2170632 | 2170632 | 2022-01-31 | Botetourt | Virginia | 51023 | 6439 | 74 |
| 2170647 | 2170647 | 2022-01-31 | Colonial Heights city | Virginia | 51570 | 4463 | 74 |
| 2170688 | 2170688 | 2022-01-31 | Lee | Virginia | 51105 | 5307 | 74 |
| 2170709 | 2170709 | 2022-01-31 | Nottoway | Virginia | 51135 | 3653 | 74 |
| 2170712 | 2170712 | 2022-01-31 | Patrick | Virginia | 51141 | 3179 | 74 |
| 2167456 | 2167456 | 2022-01-30 | Nottoway | Virginia | 51135 | 3578 | 74 |
| 2164201 | 2164201 | 2022-01-29 | Nottoway | Virginia | 51135 | 3578 | 74 |
| 2160946 | 2160946 | 2022-01-28 | Nottoway | Virginia | 51135 | 3578 | 74 |
| 2157690 | 2157690 | 2022-01-27 | Nottoway | Virginia | 51135 | 3536 | 74 |
| 2154437 | 2154437 | 2022-01-26 | Nottoway | Virginia | 51135 | 3512 | 74 |
| 2099168 | 2099168 | 2022-01-09 | Southampton | Virginia | 51175 | 2657 | 74 |
| 2095917 | 2095917 | 2022-01-08 | Southampton | Virginia | 51175 | 2657 | 74 |
| 2092665 | 2092665 | 2022-01-07 | Southampton | Virginia | 51175 | 2657 | 74 |
| 2089413 | 2089413 | 2022-01-06 | Southampton | Virginia | 51175 | 2634 | 74 |
| 2086162 | 2086162 | 2022-01-05 | Southampton | Virginia | 51175 | 2616 | 74 |
| 2082910 | 2082910 | 2022-01-04 | Southampton | Virginia | 51175 | 2607 | 74 |
| 2079658 | 2079658 | 2022-01-03 | Southampton | Virginia | 51175 | 2590 | 74 |
| 2076406 | 2076406 | 2022-01-02 | Southampton | Virginia | 51175 | 2559 | 74 |
| 2073155 | 2073155 | 2022-01-01 | Southampton | Virginia | 51175 | 2559 | 74 |
| 2069904 | 2069904 | 2021-12-31 | Southampton | Virginia | 51175 | 2559 | 74 |
| 2066653 | 2066653 | 2021-12-30 | Southampton | Virginia | 51175 | 2545 | 74 |
| 2063403 | 2063403 | 2021-12-29 | Southampton | Virginia | 51175 | 2534 | 74 |
| 2056899 | 2056899 | 2021-12-27 | Russell | Virginia | 51167 | 4567 | 74 |
| 2053650 | 2053650 | 2021-12-26 | Russell | Virginia | 51167 | 4534 | 74 |
| 2050400 | 2050400 | 2021-12-25 | Russell | Virginia | 51167 | 4534 | 74 |
| 2047150 | 2047150 | 2021-12-24 | Russell | Virginia | 51167 | 4534 | 74 |
| 2043900 | 2043900 | 2021-12-23 | Russell | Virginia | 51167 | 4513 | 74 |
| 2040651 | 2040651 | 2021-12-22 | Russell | Virginia | 51167 | 4496 | 74 |
| 1946289 | 1946289 | 2021-11-23 | Buchanan | Virginia | 51027 | 2749 | 74 |
| 1943038 | 1943038 | 2021-11-22 | Buchanan | Virginia | 51027 | 2718 | 74 |
| 1858535 | 1858535 | 2021-10-27 | Alleghany | Virginia | 51005 | 2116 | 74 |
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);