ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
641 rows where deaths = 48 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Rockbridge 77
- Alleghany 65
- Manassas city 61
- Lee 59
- Nottoway 52
- Winchester city 35
- Gloucester 24
- Bristol city 19
- Middlesex 19
- Radford city 16
- Northampton 13
- Rockingham 12
- Buckingham 11
- Alexandria city 8
- Shenandoah 8
- Appomattox 7
- Grayson 7
- Greene 7
- Louisa 7
- Franklin city 6
- Hanover 6
- Prince George 6
- Southampton 6
- Augusta 5
- Caroline 5
- Giles 5
- Hampton city 5
- Loudoun 5
- Montgomery 5
- Warren 5
- …
state 1
- Virginia · 641 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502590 | 2502590 | 2022-05-13 | Middlesex | Virginia | 51119 | 1874 | 48 |
2499332 | 2499332 | 2022-05-12 | Middlesex | Virginia | 51119 | 1872 | 48 |
2496074 | 2496074 | 2022-05-11 | Middlesex | Virginia | 51119 | 1868 | 48 |
2492816 | 2492816 | 2022-05-10 | Middlesex | Virginia | 51119 | 1865 | 48 |
2489558 | 2489558 | 2022-05-09 | Middlesex | Virginia | 51119 | 1861 | 48 |
2486301 | 2486301 | 2022-05-08 | Middlesex | Virginia | 51119 | 1858 | 48 |
2483043 | 2483043 | 2022-05-07 | Middlesex | Virginia | 51119 | 1858 | 48 |
2479785 | 2479785 | 2022-05-06 | Middlesex | Virginia | 51119 | 1858 | 48 |
2476527 | 2476527 | 2022-05-05 | Middlesex | Virginia | 51119 | 1855 | 48 |
2473269 | 2473269 | 2022-05-04 | Middlesex | Virginia | 51119 | 1854 | 48 |
2470013 | 2470013 | 2022-05-03 | Middlesex | Virginia | 51119 | 1849 | 48 |
2466757 | 2466757 | 2022-05-02 | Middlesex | Virginia | 51119 | 1847 | 48 |
2463502 | 2463502 | 2022-05-01 | Middlesex | Virginia | 51119 | 1842 | 48 |
2460246 | 2460246 | 2022-04-30 | Middlesex | Virginia | 51119 | 1842 | 48 |
2456990 | 2456990 | 2022-04-29 | Middlesex | Virginia | 51119 | 1842 | 48 |
2453734 | 2453734 | 2022-04-28 | Middlesex | Virginia | 51119 | 1841 | 48 |
2450478 | 2450478 | 2022-04-27 | Middlesex | Virginia | 51119 | 1839 | 48 |
2447221 | 2447221 | 2022-04-26 | Middlesex | Virginia | 51119 | 1838 | 48 |
2443966 | 2443966 | 2022-04-25 | Middlesex | Virginia | 51119 | 1836 | 48 |
2430895 | 2430895 | 2022-04-21 | Dickenson | Virginia | 51051 | 3321 | 48 |
2427639 | 2427639 | 2022-04-20 | Dickenson | Virginia | 51051 | 3319 | 48 |
2424383 | 2424383 | 2022-04-19 | Dickenson | Virginia | 51051 | 3317 | 48 |
2401607 | 2401607 | 2022-04-12 | Giles | Virginia | 51071 | 4053 | 48 |
2398352 | 2398352 | 2022-04-11 | Giles | Virginia | 51071 | 4051 | 48 |
2395097 | 2395097 | 2022-04-10 | Giles | Virginia | 51071 | 4052 | 48 |
2391841 | 2391841 | 2022-04-09 | Giles | Virginia | 51071 | 4052 | 48 |
2388585 | 2388585 | 2022-04-08 | Giles | Virginia | 51071 | 4052 | 48 |
2378874 | 2378874 | 2022-04-05 | Radford city | Virginia | 51750 | 4909 | 48 |
2375620 | 2375620 | 2022-04-04 | Radford city | Virginia | 51750 | 4910 | 48 |
2372368 | 2372368 | 2022-04-03 | Radford city | Virginia | 51750 | 4909 | 48 |
2369115 | 2369115 | 2022-04-02 | Radford city | Virginia | 51750 | 4909 | 48 |
2365862 | 2365862 | 2022-04-01 | Radford city | Virginia | 51750 | 4909 | 48 |
2362609 | 2362609 | 2022-03-31 | Radford city | Virginia | 51750 | 4909 | 48 |
2359355 | 2359355 | 2022-03-30 | Radford city | Virginia | 51750 | 4909 | 48 |
2356101 | 2356101 | 2022-03-29 | Radford city | Virginia | 51750 | 4907 | 48 |
2352848 | 2352848 | 2022-03-28 | Radford city | Virginia | 51750 | 4906 | 48 |
2349596 | 2349596 | 2022-03-27 | Radford city | Virginia | 51750 | 4903 | 48 |
2346343 | 2346343 | 2022-03-26 | Radford city | Virginia | 51750 | 4903 | 48 |
2343090 | 2343090 | 2022-03-25 | Radford city | Virginia | 51750 | 4903 | 48 |
2339837 | 2339837 | 2022-03-24 | Radford city | Virginia | 51750 | 4902 | 48 |
2336583 | 2336583 | 2022-03-23 | Radford city | Virginia | 51750 | 4902 | 48 |
2333329 | 2333329 | 2022-03-22 | Radford city | Virginia | 51750 | 4902 | 48 |
2330076 | 2330076 | 2022-03-21 | Radford city | Virginia | 51750 | 4902 | 48 |
2281314 | 2281314 | 2022-03-06 | Westmoreland | Virginia | 51193 | 3216 | 48 |
2278061 | 2278061 | 2022-03-05 | Westmoreland | Virginia | 51193 | 3216 | 48 |
2274808 | 2274808 | 2022-03-04 | Westmoreland | Virginia | 51193 | 3216 | 48 |
2268220 | 2268220 | 2022-03-02 | Franklin city | Virginia | 51620 | 2457 | 48 |
2264967 | 2264967 | 2022-03-01 | Franklin city | Virginia | 51620 | 2457 | 48 |
2261717 | 2261717 | 2022-02-28 | Franklin city | Virginia | 51620 | 2457 | 48 |
2258466 | 2258466 | 2022-02-27 | Franklin city | Virginia | 51620 | 2455 | 48 |
2255215 | 2255215 | 2022-02-26 | Franklin city | Virginia | 51620 | 2455 | 48 |
2251964 | 2251964 | 2022-02-25 | Franklin city | Virginia | 51620 | 2455 | 48 |
2248685 | 2248685 | 2022-02-24 | Buckingham | Virginia | 51029 | 3754 | 48 |
2248766 | 2248766 | 2022-02-24 | Powhatan | Virginia | 51145 | 4781 | 48 |
2245434 | 2245434 | 2022-02-23 | Buckingham | Virginia | 51029 | 3752 | 48 |
2242183 | 2242183 | 2022-02-22 | Buckingham | Virginia | 51029 | 3750 | 48 |
2238932 | 2238932 | 2022-02-21 | Buckingham | Virginia | 51029 | 3748 | 48 |
2235681 | 2235681 | 2022-02-20 | Buckingham | Virginia | 51029 | 3738 | 48 |
2232430 | 2232430 | 2022-02-19 | Buckingham | Virginia | 51029 | 3738 | 48 |
2229179 | 2229179 | 2022-02-18 | Buckingham | Virginia | 51029 | 3738 | 48 |
2225928 | 2225928 | 2022-02-17 | Buckingham | Virginia | 51029 | 3736 | 48 |
2222677 | 2222677 | 2022-02-16 | Buckingham | Virginia | 51029 | 3731 | 48 |
2219416 | 2219416 | 2022-02-15 | Appomattox | Virginia | 51011 | 3554 | 48 |
2219426 | 2219426 | 2022-02-15 | Buckingham | Virginia | 51029 | 3720 | 48 |
2216166 | 2216166 | 2022-02-14 | Appomattox | Virginia | 51011 | 3547 | 48 |
2216176 | 2216176 | 2022-02-14 | Buckingham | Virginia | 51029 | 3701 | 48 |
2212915 | 2212915 | 2022-02-13 | Appomattox | Virginia | 51011 | 3528 | 48 |
2209662 | 2209662 | 2022-02-12 | Appomattox | Virginia | 51011 | 3528 | 48 |
2206409 | 2206409 | 2022-02-11 | Appomattox | Virginia | 51011 | 3528 | 48 |
2203156 | 2203156 | 2022-02-10 | Appomattox | Virginia | 51011 | 3507 | 48 |
2199902 | 2199902 | 2022-02-09 | Appomattox | Virginia | 51011 | 3483 | 48 |
2190169 | 2190169 | 2022-02-06 | Emporia city | Virginia | 51595 | 1045 | 48 |
2186916 | 2186916 | 2022-02-05 | Emporia city | Virginia | 51595 | 1045 | 48 |
2183663 | 2183663 | 2022-02-04 | Emporia city | Virginia | 51595 | 1045 | 48 |
2177129 | 2177129 | 2022-02-02 | Amelia | Virginia | 51007 | 2436 | 48 |
2167419 | 2167419 | 2022-01-30 | Greene | Virginia | 51079 | 3561 | 48 |
2164164 | 2164164 | 2022-01-29 | Greene | Virginia | 51079 | 3561 | 48 |
2160909 | 2160909 | 2022-01-28 | Greene | Virginia | 51079 | 3561 | 48 |
2157653 | 2157653 | 2022-01-27 | Greene | Virginia | 51079 | 3546 | 48 |
2154400 | 2154400 | 2022-01-26 | Greene | Virginia | 51079 | 3524 | 48 |
2151147 | 2151147 | 2022-01-25 | Greene | Virginia | 51079 | 3491 | 48 |
2147895 | 2147895 | 2022-01-24 | Greene | Virginia | 51079 | 3456 | 48 |
2056875 | 2056875 | 2021-12-27 | Northampton | Virginia | 51131 | 1233 | 48 |
2053626 | 2053626 | 2021-12-26 | Northampton | Virginia | 51131 | 1224 | 48 |
2050376 | 2050376 | 2021-12-25 | Northampton | Virginia | 51131 | 1224 | 48 |
2047126 | 2047126 | 2021-12-24 | Northampton | Virginia | 51131 | 1224 | 48 |
2043876 | 2043876 | 2021-12-23 | Northampton | Virginia | 51131 | 1221 | 48 |
2040627 | 2040627 | 2021-12-22 | Northampton | Virginia | 51131 | 1218 | 48 |
2037377 | 2037377 | 2021-12-21 | Northampton | Virginia | 51131 | 1215 | 48 |
2034127 | 2034127 | 2021-12-20 | Northampton | Virginia | 51131 | 1215 | 48 |
2030877 | 2030877 | 2021-12-19 | Northampton | Virginia | 51131 | 1210 | 48 |
2027626 | 2027626 | 2021-12-18 | Northampton | Virginia | 51131 | 1210 | 48 |
2024375 | 2024375 | 2021-12-17 | Northampton | Virginia | 51131 | 1210 | 48 |
2021124 | 2021124 | 2021-12-16 | Northampton | Virginia | 51131 | 1209 | 48 |
2017873 | 2017873 | 2021-12-15 | Northampton | Virginia | 51131 | 1204 | 48 |
1943036 | 1943036 | 2021-11-22 | Bristol city | Virginia | 51520 | 2357 | 48 |
1939786 | 1939786 | 2021-11-21 | Bristol city | Virginia | 51520 | 2347 | 48 |
1939824 | 1939824 | 2021-11-21 | Grayson | Virginia | 51077 | 2231 | 48 |
1936536 | 1936536 | 2021-11-20 | Bristol city | Virginia | 51520 | 2347 | 48 |
1936574 | 1936574 | 2021-11-20 | Grayson | Virginia | 51077 | 2231 | 48 |
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);