ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
547 rows where deaths = 57 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Charlottesville city 71
- Southampton 69
- Page 67
- Winchester city 37
- Buckingham 36
- Colonial Heights city 33
- Manassas city 28
- Alexandria city 25
- Powhatan 15
- Rockbridge 15
- Amherst 10
- Hampton city 9
- Amelia 8
- Nottoway 8
- Staunton city 8
- Accomack 7
- Botetourt 7
- Lee 7
- Spotsylvania 7
- York 7
- Buchanan 6
- Salem city 6
- Warren 6
- Culpeper 5
- Greene 5
- Harrisonburg city 5
- Smyth 4
- Carroll 3
- Dinwiddie 3
- Isle of Wight 3
- …
state 1
- Virginia · 547 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492752 | 2492752 | 2022-05-10 | Buckingham | Virginia | 51029 | 3988 | 57 |
2489494 | 2489494 | 2022-05-09 | Buckingham | Virginia | 51029 | 3988 | 57 |
2486237 | 2486237 | 2022-05-08 | Buckingham | Virginia | 51029 | 3982 | 57 |
2482979 | 2482979 | 2022-05-07 | Buckingham | Virginia | 51029 | 3982 | 57 |
2479721 | 2479721 | 2022-05-06 | Buckingham | Virginia | 51029 | 3982 | 57 |
2476463 | 2476463 | 2022-05-05 | Buckingham | Virginia | 51029 | 3978 | 57 |
2473205 | 2473205 | 2022-05-04 | Buckingham | Virginia | 51029 | 3978 | 57 |
2469949 | 2469949 | 2022-05-03 | Buckingham | Virginia | 51029 | 3976 | 57 |
2466693 | 2466693 | 2022-05-02 | Buckingham | Virginia | 51029 | 3974 | 57 |
2463438 | 2463438 | 2022-05-01 | Buckingham | Virginia | 51029 | 3971 | 57 |
2460182 | 2460182 | 2022-04-30 | Buckingham | Virginia | 51029 | 3971 | 57 |
2456926 | 2456926 | 2022-04-29 | Buckingham | Virginia | 51029 | 3971 | 57 |
2453670 | 2453670 | 2022-04-28 | Buckingham | Virginia | 51029 | 3972 | 57 |
2450414 | 2450414 | 2022-04-27 | Buckingham | Virginia | 51029 | 3970 | 57 |
2447157 | 2447157 | 2022-04-26 | Buckingham | Virginia | 51029 | 3968 | 57 |
2443902 | 2443902 | 2022-04-25 | Buckingham | Virginia | 51029 | 3966 | 57 |
2440646 | 2440646 | 2022-04-24 | Buckingham | Virginia | 51029 | 3964 | 57 |
2437390 | 2437390 | 2022-04-23 | Buckingham | Virginia | 51029 | 3964 | 57 |
2434134 | 2434134 | 2022-04-22 | Buckingham | Virginia | 51029 | 3964 | 57 |
2430878 | 2430878 | 2022-04-21 | Buckingham | Virginia | 51029 | 3963 | 57 |
2427622 | 2427622 | 2022-04-20 | Buckingham | Virginia | 51029 | 3958 | 57 |
2424366 | 2424366 | 2022-04-19 | Buckingham | Virginia | 51029 | 3954 | 57 |
2421110 | 2421110 | 2022-04-18 | Buckingham | Virginia | 51029 | 3953 | 57 |
2417854 | 2417854 | 2022-04-17 | Buckingham | Virginia | 51029 | 3946 | 57 |
2414598 | 2414598 | 2022-04-16 | Buckingham | Virginia | 51029 | 3946 | 57 |
2411342 | 2411342 | 2022-04-15 | Buckingham | Virginia | 51029 | 3946 | 57 |
2408086 | 2408086 | 2022-04-14 | Buckingham | Virginia | 51029 | 3942 | 57 |
2404830 | 2404830 | 2022-04-13 | Buckingham | Virginia | 51029 | 3936 | 57 |
2401575 | 2401575 | 2022-04-12 | Buckingham | Virginia | 51029 | 3919 | 57 |
2398320 | 2398320 | 2022-04-11 | Buckingham | Virginia | 51029 | 3896 | 57 |
2395065 | 2395065 | 2022-04-10 | Buckingham | Virginia | 51029 | 3892 | 57 |
2391809 | 2391809 | 2022-04-09 | Buckingham | Virginia | 51029 | 3892 | 57 |
2388553 | 2388553 | 2022-04-08 | Buckingham | Virginia | 51029 | 3892 | 57 |
2385298 | 2385298 | 2022-04-07 | Buckingham | Virginia | 51029 | 3884 | 57 |
2382043 | 2382043 | 2022-04-06 | Buckingham | Virginia | 51029 | 3869 | 57 |
2382124 | 2382124 | 2022-04-06 | Powhatan | Virginia | 51145 | 5099 | 57 |
2378788 | 2378788 | 2022-04-05 | Buckingham | Virginia | 51029 | 3871 | 57 |
2378869 | 2378869 | 2022-04-05 | Powhatan | Virginia | 51145 | 5097 | 57 |
2375615 | 2375615 | 2022-04-04 | Powhatan | Virginia | 51145 | 5093 | 57 |
2372363 | 2372363 | 2022-04-03 | Powhatan | Virginia | 51145 | 5085 | 57 |
2369110 | 2369110 | 2022-04-02 | Powhatan | Virginia | 51145 | 5085 | 57 |
2365857 | 2365857 | 2022-04-01 | Powhatan | Virginia | 51145 | 5085 | 57 |
2362604 | 2362604 | 2022-03-31 | Powhatan | Virginia | 51145 | 5077 | 57 |
2359350 | 2359350 | 2022-03-30 | Powhatan | Virginia | 51145 | 5066 | 57 |
2356096 | 2356096 | 2022-03-29 | Powhatan | Virginia | 51145 | 5059 | 57 |
2352843 | 2352843 | 2022-03-28 | Powhatan | Virginia | 51145 | 5031 | 57 |
2349591 | 2349591 | 2022-03-27 | Powhatan | Virginia | 51145 | 5023 | 57 |
2346338 | 2346338 | 2022-03-26 | Powhatan | Virginia | 51145 | 5023 | 57 |
2343085 | 2343085 | 2022-03-25 | Powhatan | Virginia | 51145 | 5023 | 57 |
2339832 | 2339832 | 2022-03-24 | Powhatan | Virginia | 51145 | 5003 | 57 |
2336578 | 2336578 | 2022-03-23 | Powhatan | Virginia | 51145 | 4984 | 57 |
2271432 | 2271432 | 2022-03-03 | Amelia | Virginia | 51007 | 2576 | 57 |
2268180 | 2268180 | 2022-03-02 | Amelia | Virginia | 51007 | 2572 | 57 |
2264927 | 2264927 | 2022-03-01 | Amelia | Virginia | 51007 | 2571 | 57 |
2261677 | 2261677 | 2022-02-28 | Amelia | Virginia | 51007 | 2570 | 57 |
2258426 | 2258426 | 2022-02-27 | Amelia | Virginia | 51007 | 2569 | 57 |
2255175 | 2255175 | 2022-02-26 | Amelia | Virginia | 51007 | 2569 | 57 |
2251924 | 2251924 | 2022-02-25 | Amelia | Virginia | 51007 | 2569 | 57 |
2248673 | 2248673 | 2022-02-24 | Amelia | Virginia | 51007 | 2568 | 57 |
2245504 | 2245504 | 2022-02-23 | Northampton | Virginia | 51131 | 2123 | 57 |
2235717 | 2235717 | 2022-02-20 | Greene | Virginia | 51079 | 3889 | 57 |
2232466 | 2232466 | 2022-02-19 | Greene | Virginia | 51079 | 3889 | 57 |
2229215 | 2229215 | 2022-02-18 | Greene | Virginia | 51079 | 3889 | 57 |
2225964 | 2225964 | 2022-02-17 | Greene | Virginia | 51079 | 3886 | 57 |
2222713 | 2222713 | 2022-02-16 | Greene | Virginia | 51079 | 3878 | 57 |
2193513 | 2193513 | 2022-02-07 | Waynesboro city | Virginia | 51820 | 5119 | 57 |
2177196 | 2177196 | 2022-02-02 | Louisa | Virginia | 51109 | 5972 | 57 |
2147919 | 2147919 | 2022-01-24 | Manassas city | Virginia | 51683 | 8320 | 57 |
2144666 | 2144666 | 2022-01-23 | Manassas city | Virginia | 51683 | 8228 | 57 |
2141411 | 2141411 | 2022-01-22 | Manassas city | Virginia | 51683 | 8228 | 57 |
2138155 | 2138155 | 2022-01-21 | Manassas city | Virginia | 51683 | 8228 | 57 |
2134901 | 2134901 | 2022-01-20 | Manassas city | Virginia | 51683 | 8165 | 57 |
2131649 | 2131649 | 2022-01-19 | Manassas city | Virginia | 51683 | 8101 | 57 |
2128395 | 2128395 | 2022-01-18 | Manassas city | Virginia | 51683 | 8003 | 57 |
2125142 | 2125142 | 2022-01-17 | Manassas city | Virginia | 51683 | 7940 | 57 |
2121890 | 2121890 | 2022-01-16 | Manassas city | Virginia | 51683 | 7709 | 57 |
2118638 | 2118638 | 2022-01-15 | Manassas city | Virginia | 51683 | 7709 | 57 |
2115386 | 2115386 | 2022-01-14 | Manassas city | Virginia | 51683 | 7709 | 57 |
2112134 | 2112134 | 2022-01-13 | Manassas city | Virginia | 51683 | 7610 | 57 |
2108882 | 2108882 | 2022-01-12 | Manassas city | Virginia | 51683 | 7496 | 57 |
2105631 | 2105631 | 2022-01-11 | Manassas city | Virginia | 51683 | 7369 | 57 |
2102380 | 2102380 | 2022-01-10 | Manassas city | Virginia | 51683 | 7261 | 57 |
2099129 | 2099129 | 2022-01-09 | Manassas city | Virginia | 51683 | 6971 | 57 |
2095878 | 2095878 | 2022-01-08 | Manassas city | Virginia | 51683 | 6971 | 57 |
2092626 | 2092626 | 2022-01-07 | Manassas city | Virginia | 51683 | 6971 | 57 |
2089374 | 2089374 | 2022-01-06 | Manassas city | Virginia | 51683 | 6834 | 57 |
2086123 | 2086123 | 2022-01-05 | Manassas city | Virginia | 51683 | 6766 | 57 |
2082871 | 2082871 | 2022-01-04 | Manassas city | Virginia | 51683 | 6708 | 57 |
2079619 | 2079619 | 2022-01-03 | Manassas city | Virginia | 51683 | 6622 | 57 |
2076367 | 2076367 | 2022-01-02 | Manassas city | Virginia | 51683 | 6346 | 57 |
2073116 | 2073116 | 2022-01-01 | Manassas city | Virginia | 51683 | 6346 | 57 |
2069865 | 2069865 | 2021-12-31 | Manassas city | Virginia | 51683 | 6346 | 57 |
2066614 | 2066614 | 2021-12-30 | Manassas city | Virginia | 51683 | 6218 | 57 |
2063364 | 2063364 | 2021-12-29 | Manassas city | Virginia | 51683 | 6120 | 57 |
2060051 | 2060051 | 2021-12-28 | Bristol city | Virginia | 51520 | 2678 | 57 |
2060114 | 2060114 | 2021-12-28 | Manassas city | Virginia | 51683 | 6035 | 57 |
2056918 | 2056918 | 2021-12-27 | Winchester city | Virginia | 51840 | 4269 | 57 |
2053669 | 2053669 | 2021-12-26 | Winchester city | Virginia | 51840 | 4214 | 57 |
2050419 | 2050419 | 2021-12-25 | Winchester city | Virginia | 51840 | 4214 | 57 |
2047169 | 2047169 | 2021-12-24 | Winchester city | Virginia | 51840 | 4214 | 57 |
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);