ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
270 rows where deaths = 92 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Isle of Wight 32
- Wise 22
- Petersburg city 21
- Scott 20
- Lee 15
- Culpeper 14
- Alleghany 12
- Southampton 12
- Montgomery 11
- Fauquier 9
- Patrick 9
- Pulaski 9
- Nottoway 8
- Albemarle 7
- Carroll 7
- Page 7
- Buchanan 6
- Danville city 6
- Smyth 5
- Stafford 5
- Augusta 4
- James City 4
- Warren 3
- Chesapeake city 2
- Gloucester 2
- Norfolk city 2
- Richmond city 2
- Rockingham 2
- Bedford 1
- Halifax 1
- …
state 1
- Virginia · 270 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502599 | 2502599 | 2022-05-13 | Nottoway | Virginia | 51135 | 4300 | 92 |
2499341 | 2499341 | 2022-05-12 | Nottoway | Virginia | 51135 | 4297 | 92 |
2496083 | 2496083 | 2022-05-11 | Nottoway | Virginia | 51135 | 4299 | 92 |
2492825 | 2492825 | 2022-05-10 | Nottoway | Virginia | 51135 | 4293 | 92 |
2489567 | 2489567 | 2022-05-09 | Nottoway | Virginia | 51135 | 4289 | 92 |
2486310 | 2486310 | 2022-05-08 | Nottoway | Virginia | 51135 | 4283 | 92 |
2486336 | 2486336 | 2022-05-08 | Southampton | Virginia | 51175 | 3433 | 92 |
2483052 | 2483052 | 2022-05-07 | Nottoway | Virginia | 51135 | 4283 | 92 |
2483078 | 2483078 | 2022-05-07 | Southampton | Virginia | 51175 | 3433 | 92 |
2479794 | 2479794 | 2022-05-06 | Nottoway | Virginia | 51135 | 4283 | 92 |
2479820 | 2479820 | 2022-05-06 | Southampton | Virginia | 51175 | 3433 | 92 |
2476562 | 2476562 | 2022-05-05 | Southampton | Virginia | 51175 | 3432 | 92 |
2473304 | 2473304 | 2022-05-04 | Southampton | Virginia | 51175 | 3430 | 92 |
2470048 | 2470048 | 2022-05-03 | Southampton | Virginia | 51175 | 3429 | 92 |
2466792 | 2466792 | 2022-05-02 | Southampton | Virginia | 51175 | 3429 | 92 |
2463537 | 2463537 | 2022-05-01 | Southampton | Virginia | 51175 | 3425 | 92 |
2460281 | 2460281 | 2022-04-30 | Southampton | Virginia | 51175 | 3425 | 92 |
2457025 | 2457025 | 2022-04-29 | Southampton | Virginia | 51175 | 3425 | 92 |
2453769 | 2453769 | 2022-04-28 | Southampton | Virginia | 51175 | 3416 | 92 |
2450513 | 2450513 | 2022-04-27 | Southampton | Virginia | 51175 | 3408 | 92 |
2408138 | 2408138 | 2022-04-14 | Lee | Virginia | 51105 | 6210 | 92 |
2404882 | 2404882 | 2022-04-13 | Lee | Virginia | 51105 | 6210 | 92 |
2401627 | 2401627 | 2022-04-12 | Lee | Virginia | 51105 | 6210 | 92 |
2398372 | 2398372 | 2022-04-11 | Lee | Virginia | 51105 | 6210 | 92 |
2395117 | 2395117 | 2022-04-10 | Lee | Virginia | 51105 | 6210 | 92 |
2391861 | 2391861 | 2022-04-09 | Lee | Virginia | 51105 | 6210 | 92 |
2388605 | 2388605 | 2022-04-08 | Lee | Virginia | 51105 | 6210 | 92 |
2385350 | 2385350 | 2022-04-07 | Lee | Virginia | 51105 | 6212 | 92 |
2382095 | 2382095 | 2022-04-06 | Lee | Virginia | 51105 | 6211 | 92 |
2378840 | 2378840 | 2022-04-05 | Lee | Virginia | 51105 | 6210 | 92 |
2378864 | 2378864 | 2022-04-05 | Patrick | Virginia | 51141 | 3604 | 92 |
2375586 | 2375586 | 2022-04-04 | Lee | Virginia | 51105 | 6210 | 92 |
2375610 | 2375610 | 2022-04-04 | Patrick | Virginia | 51141 | 3604 | 92 |
2372334 | 2372334 | 2022-04-03 | Lee | Virginia | 51105 | 6209 | 92 |
2372358 | 2372358 | 2022-04-03 | Patrick | Virginia | 51141 | 3601 | 92 |
2369081 | 2369081 | 2022-04-02 | Lee | Virginia | 51105 | 6209 | 92 |
2369105 | 2369105 | 2022-04-02 | Patrick | Virginia | 51141 | 3601 | 92 |
2365828 | 2365828 | 2022-04-01 | Lee | Virginia | 51105 | 6209 | 92 |
2365852 | 2365852 | 2022-04-01 | Patrick | Virginia | 51141 | 3601 | 92 |
2362599 | 2362599 | 2022-03-31 | Patrick | Virginia | 51141 | 3601 | 92 |
2359321 | 2359321 | 2022-03-30 | Lee | Virginia | 51105 | 6209 | 92 |
2359345 | 2359345 | 2022-03-30 | Patrick | Virginia | 51141 | 3599 | 92 |
2356091 | 2356091 | 2022-03-29 | Patrick | Virginia | 51141 | 3597 | 92 |
2352838 | 2352838 | 2022-03-28 | Patrick | Virginia | 51141 | 3597 | 92 |
2258425 | 2258425 | 2022-02-27 | Alleghany | Virginia | 51005 | 3534 | 92 |
2255174 | 2255174 | 2022-02-26 | Alleghany | Virginia | 51005 | 3534 | 92 |
2251923 | 2251923 | 2022-02-25 | Alleghany | Virginia | 51005 | 3534 | 92 |
2248672 | 2248672 | 2022-02-24 | Alleghany | Virginia | 51005 | 3530 | 92 |
2245421 | 2245421 | 2022-02-23 | Alleghany | Virginia | 51005 | 3521 | 92 |
2242170 | 2242170 | 2022-02-22 | Alleghany | Virginia | 51005 | 3517 | 92 |
2238919 | 2238919 | 2022-02-21 | Alleghany | Virginia | 51005 | 3511 | 92 |
2235668 | 2235668 | 2022-02-20 | Alleghany | Virginia | 51005 | 3491 | 92 |
2232417 | 2232417 | 2022-02-19 | Alleghany | Virginia | 51005 | 3491 | 92 |
2229166 | 2229166 | 2022-02-18 | Alleghany | Virginia | 51005 | 3491 | 92 |
2225915 | 2225915 | 2022-02-17 | Alleghany | Virginia | 51005 | 3499 | 92 |
2222664 | 2222664 | 2022-02-16 | Alleghany | Virginia | 51005 | 3494 | 92 |
2216175 | 2216175 | 2022-02-14 | Buchanan | Virginia | 51027 | 4399 | 92 |
2212924 | 2212924 | 2022-02-13 | Buchanan | Virginia | 51027 | 4379 | 92 |
2209671 | 2209671 | 2022-02-12 | Buchanan | Virginia | 51027 | 4379 | 92 |
2206418 | 2206418 | 2022-02-11 | Buchanan | Virginia | 51027 | 4379 | 92 |
2203165 | 2203165 | 2022-02-10 | Buchanan | Virginia | 51027 | 4363 | 92 |
2199911 | 2199911 | 2022-02-09 | Buchanan | Virginia | 51027 | 4344 | 92 |
2199945 | 2199945 | 2022-02-09 | Gloucester | Virginia | 51073 | 7064 | 92 |
2200006 | 2200006 | 2022-02-09 | Russell | Virginia | 51167 | 6299 | 92 |
2196691 | 2196691 | 2022-02-08 | Gloucester | Virginia | 51073 | 7035 | 92 |
2167429 | 2167429 | 2022-01-30 | Isle of Wight | Virginia | 51093 | 6857 | 92 |
2164174 | 2164174 | 2022-01-29 | Isle of Wight | Virginia | 51093 | 6857 | 92 |
2160919 | 2160919 | 2022-01-28 | Isle of Wight | Virginia | 51093 | 6857 | 92 |
2157663 | 2157663 | 2022-01-27 | Isle of Wight | Virginia | 51093 | 6808 | 92 |
2154410 | 2154410 | 2022-01-26 | Isle of Wight | Virginia | 51093 | 6757 | 92 |
2151157 | 2151157 | 2022-01-25 | Isle of Wight | Virginia | 51093 | 6690 | 92 |
2147905 | 2147905 | 2022-01-24 | Isle of Wight | Virginia | 51093 | 6664 | 92 |
2144652 | 2144652 | 2022-01-23 | Isle of Wight | Virginia | 51093 | 6561 | 92 |
2141397 | 2141397 | 2022-01-22 | Isle of Wight | Virginia | 51093 | 6561 | 92 |
2138141 | 2138141 | 2022-01-21 | Isle of Wight | Virginia | 51093 | 6561 | 92 |
2134887 | 2134887 | 2022-01-20 | Isle of Wight | Virginia | 51093 | 6477 | 92 |
2131635 | 2131635 | 2022-01-19 | Isle of Wight | Virginia | 51093 | 6386 | 92 |
2128381 | 2128381 | 2022-01-18 | Isle of Wight | Virginia | 51093 | 6312 | 92 |
2125128 | 2125128 | 2022-01-17 | Isle of Wight | Virginia | 51093 | 6257 | 92 |
2125178 | 2125178 | 2022-01-17 | Scott | Virginia | 51169 | 4260 | 92 |
2121876 | 2121876 | 2022-01-16 | Isle of Wight | Virginia | 51093 | 6010 | 92 |
2121926 | 2121926 | 2022-01-16 | Scott | Virginia | 51169 | 4135 | 92 |
2118624 | 2118624 | 2022-01-15 | Isle of Wight | Virginia | 51093 | 6010 | 92 |
2118674 | 2118674 | 2022-01-15 | Scott | Virginia | 51169 | 4135 | 92 |
2115372 | 2115372 | 2022-01-14 | Isle of Wight | Virginia | 51093 | 6010 | 92 |
2115422 | 2115422 | 2022-01-14 | Scott | Virginia | 51169 | 4135 | 92 |
2112120 | 2112120 | 2022-01-13 | Isle of Wight | Virginia | 51093 | 5946 | 92 |
2112170 | 2112170 | 2022-01-13 | Scott | Virginia | 51169 | 4106 | 92 |
2108918 | 2108918 | 2022-01-12 | Scott | Virginia | 51169 | 4060 | 92 |
2105667 | 2105667 | 2022-01-11 | Scott | Virginia | 51169 | 4047 | 92 |
2102416 | 2102416 | 2022-01-10 | Scott | Virginia | 51169 | 4022 | 92 |
2099165 | 2099165 | 2022-01-09 | Scott | Virginia | 51169 | 3945 | 92 |
2095914 | 2095914 | 2022-01-08 | Scott | Virginia | 51169 | 3945 | 92 |
2092662 | 2092662 | 2022-01-07 | Scott | Virginia | 51169 | 3945 | 92 |
2089410 | 2089410 | 2022-01-06 | Scott | Virginia | 51169 | 3916 | 92 |
2086138 | 2086138 | 2022-01-05 | Page | Virginia | 51139 | 4278 | 92 |
2086159 | 2086159 | 2022-01-05 | Scott | Virginia | 51169 | 3882 | 92 |
2082886 | 2082886 | 2022-01-04 | Page | Virginia | 51139 | 4268 | 92 |
2082907 | 2082907 | 2022-01-04 | Scott | Virginia | 51169 | 3853 | 92 |
2079634 | 2079634 | 2022-01-03 | Page | Virginia | 51139 | 4251 | 92 |
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);