ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
400 rows where deaths = 59 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- York 40
- Warren 23
- Page 22
- Shenandoah 20
- Powhatan 18
- Winchester city 17
- Charlottesville city 15
- Dinwiddie 15
- Scott 15
- Waynesboro city 13
- Caroline 12
- Prince Edward 12
- Southampton 12
- Greene 9
- Lee 9
- Patrick 9
- Buchanan 8
- Prince George 8
- Alleghany 7
- Portsmouth city 7
- Pulaski 7
- Amelia 6
- Bristol city 6
- Fauquier 6
- Suffolk city 6
- Amherst 5
- Carroll 5
- Mecklenburg 5
- Orange 5
- Grayson 4
- …
state 1
- Virginia · 400 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502607 | 2502607 | 2022-05-13 | Powhatan | Virginia | 51145 | 5257 | 59 |
2499349 | 2499349 | 2022-05-12 | Powhatan | Virginia | 51145 | 5257 | 59 |
2496091 | 2496091 | 2022-05-11 | Powhatan | Virginia | 51145 | 5254 | 59 |
2492833 | 2492833 | 2022-05-10 | Powhatan | Virginia | 51145 | 5245 | 59 |
2489575 | 2489575 | 2022-05-09 | Powhatan | Virginia | 51145 | 5234 | 59 |
2486318 | 2486318 | 2022-05-08 | Powhatan | Virginia | 51145 | 5215 | 59 |
2483060 | 2483060 | 2022-05-07 | Powhatan | Virginia | 51145 | 5215 | 59 |
2479802 | 2479802 | 2022-05-06 | Powhatan | Virginia | 51145 | 5215 | 59 |
2476544 | 2476544 | 2022-05-05 | Powhatan | Virginia | 51145 | 5205 | 59 |
2473286 | 2473286 | 2022-05-04 | Powhatan | Virginia | 51145 | 5182 | 59 |
2470030 | 2470030 | 2022-05-03 | Powhatan | Virginia | 51145 | 5171 | 59 |
2466774 | 2466774 | 2022-05-02 | Powhatan | Virginia | 51145 | 5171 | 59 |
2463519 | 2463519 | 2022-05-01 | Powhatan | Virginia | 51145 | 5168 | 59 |
2460263 | 2460263 | 2022-04-30 | Powhatan | Virginia | 51145 | 5168 | 59 |
2457007 | 2457007 | 2022-04-29 | Powhatan | Virginia | 51145 | 5168 | 59 |
2453751 | 2453751 | 2022-04-28 | Powhatan | Virginia | 51145 | 5161 | 59 |
2450495 | 2450495 | 2022-04-27 | Powhatan | Virginia | 51145 | 5158 | 59 |
2447238 | 2447238 | 2022-04-26 | Powhatan | Virginia | 51145 | 5156 | 59 |
2313712 | 2313712 | 2022-03-16 | Amelia | Virginia | 51007 | 2595 | 59 |
2310459 | 2310459 | 2022-03-15 | Amelia | Virginia | 51007 | 2595 | 59 |
2307206 | 2307206 | 2022-03-14 | Amelia | Virginia | 51007 | 2586 | 59 |
2303955 | 2303955 | 2022-03-13 | Amelia | Virginia | 51007 | 2587 | 59 |
2300703 | 2300703 | 2022-03-12 | Amelia | Virginia | 51007 | 2587 | 59 |
2297451 | 2297451 | 2022-03-11 | Amelia | Virginia | 51007 | 2587 | 59 |
2271480 | 2271480 | 2022-03-03 | Greene | Virginia | 51079 | 3955 | 59 |
2268228 | 2268228 | 2022-03-02 | Greene | Virginia | 51079 | 3950 | 59 |
2264975 | 2264975 | 2022-03-01 | Greene | Virginia | 51079 | 3946 | 59 |
2261725 | 2261725 | 2022-02-28 | Greene | Virginia | 51079 | 3942 | 59 |
2258474 | 2258474 | 2022-02-27 | Greene | Virginia | 51079 | 3922 | 59 |
2258548 | 2258548 | 2022-02-27 | Waynesboro city | Virginia | 51820 | 5249 | 59 |
2255223 | 2255223 | 2022-02-26 | Greene | Virginia | 51079 | 3922 | 59 |
2255297 | 2255297 | 2022-02-26 | Waynesboro city | Virginia | 51820 | 5249 | 59 |
2251972 | 2251972 | 2022-02-25 | Greene | Virginia | 51079 | 3922 | 59 |
2252046 | 2252046 | 2022-02-25 | Waynesboro city | Virginia | 51820 | 5249 | 59 |
2248721 | 2248721 | 2022-02-24 | Greene | Virginia | 51079 | 3918 | 59 |
2248795 | 2248795 | 2022-02-24 | Waynesboro city | Virginia | 51820 | 5243 | 59 |
2245470 | 2245470 | 2022-02-23 | Greene | Virginia | 51079 | 3912 | 59 |
2245544 | 2245544 | 2022-02-23 | Waynesboro city | Virginia | 51820 | 5241 | 59 |
2242293 | 2242293 | 2022-02-22 | Waynesboro city | Virginia | 51820 | 5235 | 59 |
2239042 | 2239042 | 2022-02-21 | Waynesboro city | Virginia | 51820 | 5229 | 59 |
2235763 | 2235763 | 2022-02-20 | Prince Edward | Virginia | 51147 | 4553 | 59 |
2235791 | 2235791 | 2022-02-20 | Waynesboro city | Virginia | 51820 | 5207 | 59 |
2232512 | 2232512 | 2022-02-19 | Prince Edward | Virginia | 51147 | 4553 | 59 |
2232540 | 2232540 | 2022-02-19 | Waynesboro city | Virginia | 51820 | 5207 | 59 |
2229261 | 2229261 | 2022-02-18 | Prince Edward | Virginia | 51147 | 4553 | 59 |
2229289 | 2229289 | 2022-02-18 | Waynesboro city | Virginia | 51820 | 5207 | 59 |
2226010 | 2226010 | 2022-02-17 | Prince Edward | Virginia | 51147 | 4539 | 59 |
2226038 | 2226038 | 2022-02-17 | Waynesboro city | Virginia | 51820 | 5194 | 59 |
2222759 | 2222759 | 2022-02-16 | Prince Edward | Virginia | 51147 | 4529 | 59 |
2222787 | 2222787 | 2022-02-16 | Waynesboro city | Virginia | 51820 | 5186 | 59 |
2219508 | 2219508 | 2022-02-15 | Prince Edward | Virginia | 51147 | 4523 | 59 |
2219536 | 2219536 | 2022-02-15 | Waynesboro city | Virginia | 51820 | 5175 | 59 |
2216258 | 2216258 | 2022-02-14 | Prince Edward | Virginia | 51147 | 4521 | 59 |
2216259 | 2216259 | 2022-02-14 | Prince George | Virginia | 51149 | 7794 | 59 |
2213007 | 2213007 | 2022-02-13 | Prince Edward | Virginia | 51147 | 4491 | 59 |
2213008 | 2213008 | 2022-02-13 | Prince George | Virginia | 51149 | 7761 | 59 |
2209754 | 2209754 | 2022-02-12 | Prince Edward | Virginia | 51147 | 4491 | 59 |
2209755 | 2209755 | 2022-02-12 | Prince George | Virginia | 51149 | 7761 | 59 |
2206501 | 2206501 | 2022-02-11 | Prince Edward | Virginia | 51147 | 4491 | 59 |
2206502 | 2206502 | 2022-02-11 | Prince George | Virginia | 51149 | 7761 | 59 |
2203248 | 2203248 | 2022-02-10 | Prince Edward | Virginia | 51147 | 4474 | 59 |
2203249 | 2203249 | 2022-02-10 | Prince George | Virginia | 51149 | 7735 | 59 |
2199994 | 2199994 | 2022-02-09 | Prince Edward | Virginia | 51147 | 4446 | 59 |
2199995 | 2199995 | 2022-02-09 | Prince George | Virginia | 51149 | 7722 | 59 |
2196741 | 2196741 | 2022-02-08 | Prince George | Virginia | 51149 | 7707 | 59 |
2193486 | 2193486 | 2022-02-07 | Prince George | Virginia | 51149 | 7673 | 59 |
2180452 | 2180452 | 2022-02-03 | Manassas city | Virginia | 51683 | 8563 | 59 |
2157730 | 2157730 | 2022-01-27 | Winchester city | Virginia | 51840 | 5928 | 59 |
2154477 | 2154477 | 2022-01-26 | Winchester city | Virginia | 51840 | 5876 | 59 |
2151224 | 2151224 | 2022-01-25 | Winchester city | Virginia | 51840 | 5855 | 59 |
2147972 | 2147972 | 2022-01-24 | Winchester city | Virginia | 51840 | 5831 | 59 |
2144609 | 2144609 | 2022-01-23 | Caroline | Virginia | 51033 | 6032 | 59 |
2144720 | 2144720 | 2022-01-23 | Winchester city | Virginia | 51840 | 5700 | 59 |
2141354 | 2141354 | 2022-01-22 | Caroline | Virginia | 51033 | 6032 | 59 |
2141465 | 2141465 | 2022-01-22 | Winchester city | Virginia | 51840 | 5700 | 59 |
2138098 | 2138098 | 2022-01-21 | Caroline | Virginia | 51033 | 6032 | 59 |
2138209 | 2138209 | 2022-01-21 | Winchester city | Virginia | 51840 | 5700 | 59 |
2134844 | 2134844 | 2022-01-20 | Caroline | Virginia | 51033 | 5961 | 59 |
2134954 | 2134954 | 2022-01-20 | Winchester city | Virginia | 51840 | 5632 | 59 |
2131586 | 2131586 | 2022-01-19 | Bristol city | Virginia | 51520 | 3283 | 59 |
2131592 | 2131592 | 2022-01-19 | Caroline | Virginia | 51033 | 5916 | 59 |
2131702 | 2131702 | 2022-01-19 | Winchester city | Virginia | 51840 | 5595 | 59 |
2128332 | 2128332 | 2022-01-18 | Bristol city | Virginia | 51520 | 3247 | 59 |
2128338 | 2128338 | 2022-01-18 | Caroline | Virginia | 51033 | 5873 | 59 |
2128448 | 2128448 | 2022-01-18 | Winchester city | Virginia | 51840 | 5552 | 59 |
2125079 | 2125079 | 2022-01-17 | Bristol city | Virginia | 51520 | 3218 | 59 |
2125085 | 2125085 | 2022-01-17 | Caroline | Virginia | 51033 | 5846 | 59 |
2125195 | 2125195 | 2022-01-17 | Winchester city | Virginia | 51840 | 5531 | 59 |
2121827 | 2121827 | 2022-01-16 | Bristol city | Virginia | 51520 | 3060 | 59 |
2121833 | 2121833 | 2022-01-16 | Caroline | Virginia | 51033 | 5678 | 59 |
2121943 | 2121943 | 2022-01-16 | Winchester city | Virginia | 51840 | 5372 | 59 |
2118575 | 2118575 | 2022-01-15 | Bristol city | Virginia | 51520 | 3060 | 59 |
2118581 | 2118581 | 2022-01-15 | Caroline | Virginia | 51033 | 5678 | 59 |
2118691 | 2118691 | 2022-01-15 | Winchester city | Virginia | 51840 | 5372 | 59 |
2115323 | 2115323 | 2022-01-14 | Bristol city | Virginia | 51520 | 3060 | 59 |
2115329 | 2115329 | 2022-01-14 | Caroline | Virginia | 51033 | 5678 | 59 |
2115439 | 2115439 | 2022-01-14 | Winchester city | Virginia | 51840 | 5372 | 59 |
2112077 | 2112077 | 2022-01-13 | Caroline | Virginia | 51033 | 5607 | 59 |
2112187 | 2112187 | 2022-01-13 | Winchester city | Virginia | 51840 | 5303 | 59 |
2108825 | 2108825 | 2022-01-12 | Caroline | Virginia | 51033 | 5538 | 59 |
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);