ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 278 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 12
county 12
- Loudoun 10
- Norfolk city 7
- Roanoke 5
- Chesapeake city 4
- Roanoke city 4
- Spotsylvania 4
- Hampton city 3
- Suffolk city 2
- Arlington 1
- Danville city 1
- Fairfax 1
- Prince William 1
state 1
- Virginia · 43 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401591 | 2401591 | 2022-04-12 | Danville city | Virginia | 51590 | 11050 | 278 |
2398410 | 2398410 | 2022-04-11 | Roanoke | Virginia | 51161 | 21076 | 278 |
2395155 | 2395155 | 2022-04-10 | Roanoke | Virginia | 51161 | 21068 | 278 |
2391899 | 2391899 | 2022-04-09 | Roanoke | Virginia | 51161 | 21068 | 278 |
2388643 | 2388643 | 2022-04-08 | Roanoke | Virginia | 51161 | 21068 | 278 |
2385388 | 2385388 | 2022-04-07 | Roanoke | Virginia | 51161 | 21063 | 278 |
2304067 | 2304067 | 2022-03-13 | Spotsylvania | Virginia | 51177 | 26410 | 278 |
2300815 | 2300815 | 2022-03-12 | Spotsylvania | Virginia | 51177 | 26410 | 278 |
2297563 | 2297563 | 2022-03-11 | Spotsylvania | Virginia | 51177 | 26410 | 278 |
2284555 | 2284555 | 2022-03-07 | Spotsylvania | Virginia | 51177 | 26446 | 278 |
2242286 | 2242286 | 2022-02-22 | Suffolk city | Virginia | 51800 | 18461 | 278 |
2239035 | 2239035 | 2022-02-21 | Suffolk city | Virginia | 51800 | 18452 | 278 |
2212964 | 2212964 | 2022-02-13 | Hampton city | Virginia | 51650 | 26798 | 278 |
2209711 | 2209711 | 2022-02-12 | Hampton city | Virginia | 51650 | 26798 | 278 |
2206458 | 2206458 | 2022-02-11 | Hampton city | Virginia | 51650 | 26798 | 278 |
2144697 | 2144697 | 2022-01-23 | Roanoke city | Virginia | 51770 | 18271 | 278 |
2141442 | 2141442 | 2022-01-22 | Roanoke city | Virginia | 51770 | 18271 | 278 |
2138186 | 2138186 | 2022-01-21 | Roanoke city | Virginia | 51770 | 18271 | 278 |
2134932 | 2134932 | 2022-01-20 | Roanoke city | Virginia | 51770 | 18084 | 278 |
2056796 | 2056796 | 2021-12-27 | Arlington | Virginia | 51013 | 24041 | 278 |
1621456 | 1621456 | 2021-08-15 | Norfolk city | Virginia | 51710 | 19186 | 278 |
1618208 | 1618208 | 2021-08-14 | Norfolk city | Virginia | 51710 | 19186 | 278 |
1614960 | 1614960 | 2021-08-13 | Norfolk city | Virginia | 51710 | 19186 | 278 |
1611711 | 1611711 | 2021-08-12 | Norfolk city | Virginia | 51710 | 19067 | 278 |
1608464 | 1608464 | 2021-08-11 | Norfolk city | Virginia | 51710 | 18980 | 278 |
1605215 | 1605215 | 2021-08-10 | Norfolk city | Virginia | 51710 | 18927 | 278 |
1601965 | 1601965 | 2021-08-09 | Norfolk city | Virginia | 51710 | 18851 | 278 |
1384424 | 1384424 | 2021-06-03 | Loudoun | Virginia | 51107 | 27954 | 278 |
1381178 | 1381178 | 2021-06-02 | Loudoun | Virginia | 51107 | 27940 | 278 |
1377933 | 1377933 | 2021-06-01 | Loudoun | Virginia | 51107 | 27923 | 278 |
1374687 | 1374687 | 2021-05-31 | Loudoun | Virginia | 51107 | 27922 | 278 |
1371442 | 1371442 | 2021-05-30 | Loudoun | Virginia | 51107 | 27922 | 278 |
1368196 | 1368196 | 2021-05-29 | Loudoun | Virginia | 51107 | 27923 | 278 |
1364950 | 1364950 | 2021-05-28 | Loudoun | Virginia | 51107 | 27916 | 278 |
1361704 | 1361704 | 2021-05-27 | Loudoun | Virginia | 51107 | 27902 | 278 |
1358458 | 1358458 | 2021-05-26 | Loudoun | Virginia | 51107 | 27889 | 278 |
1355212 | 1355212 | 2021-05-25 | Loudoun | Virginia | 51107 | 27873 | 278 |
1205804 | 1205804 | 2021-04-09 | Chesapeake city | Virginia | 51550 | 19856 | 278 |
1202556 | 1202556 | 2021-04-08 | Chesapeake city | Virginia | 51550 | 19829 | 278 |
1199308 | 1199308 | 2021-04-07 | Chesapeake city | Virginia | 51550 | 19775 | 278 |
1196059 | 1196059 | 2021-04-06 | Chesapeake city | Virginia | 51550 | 19745 | 278 |
946179 | 946179 | 2021-01-19 | Prince William | Virginia | 51153 | 32237 | 278 |
150943 | 150943 | 2020-05-16 | Fairfax | Virginia | 51059 | 7386 | 278 |
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);