ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where deaths = 194 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 17
county 17
- Wise 19
- Suffolk city 9
- Henrico 7
- Pittsylvania 7
- Roanoke 7
- Franklin 6
- Danville city 5
- Shenandoah 5
- Roanoke city 4
- Virginia Beach city 3
- Frederick 2
- Augusta 1
- Bedford 1
- Chesapeake city 1
- Chesterfield 1
- Portsmouth city 1
- Washington 1
state 1
- Virginia · 80 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424393 | 2424393 | 2022-04-19 | Franklin | Virginia | 51067 | 10802 | 194 |
2421137 | 2421137 | 2022-04-18 | Franklin | Virginia | 51067 | 10800 | 194 |
2417881 | 2417881 | 2022-04-17 | Franklin | Virginia | 51067 | 10792 | 194 |
2414625 | 2414625 | 2022-04-16 | Franklin | Virginia | 51067 | 10792 | 194 |
2411369 | 2411369 | 2022-04-15 | Franklin | Virginia | 51067 | 10792 | 194 |
2408113 | 2408113 | 2022-04-14 | Franklin | Virginia | 51067 | 10782 | 194 |
2404908 | 2404908 | 2022-04-13 | Pittsylvania | Virginia | 51143 | 14022 | 194 |
2395179 | 2395179 | 2022-04-10 | Wise | Virginia | 51195 | 10243 | 194 |
2391923 | 2391923 | 2022-04-09 | Wise | Virginia | 51195 | 10243 | 194 |
2388667 | 2388667 | 2022-04-08 | Wise | Virginia | 51195 | 10243 | 194 |
2385412 | 2385412 | 2022-04-07 | Wise | Virginia | 51195 | 10244 | 194 |
2382157 | 2382157 | 2022-04-06 | Wise | Virginia | 51195 | 10242 | 194 |
2378866 | 2378866 | 2022-04-05 | Pittsylvania | Virginia | 51143 | 13940 | 194 |
2378902 | 2378902 | 2022-04-05 | Wise | Virginia | 51195 | 10240 | 194 |
2375612 | 2375612 | 2022-04-04 | Pittsylvania | Virginia | 51143 | 13911 | 194 |
2375648 | 2375648 | 2022-04-04 | Wise | Virginia | 51195 | 10239 | 194 |
2372360 | 2372360 | 2022-04-03 | Pittsylvania | Virginia | 51143 | 13901 | 194 |
2372396 | 2372396 | 2022-04-03 | Wise | Virginia | 51195 | 10237 | 194 |
2369107 | 2369107 | 2022-04-02 | Pittsylvania | Virginia | 51143 | 13901 | 194 |
2369143 | 2369143 | 2022-04-02 | Wise | Virginia | 51195 | 10237 | 194 |
2365854 | 2365854 | 2022-04-01 | Pittsylvania | Virginia | 51143 | 13901 | 194 |
2365890 | 2365890 | 2022-04-01 | Wise | Virginia | 51195 | 10237 | 194 |
2362601 | 2362601 | 2022-03-31 | Pittsylvania | Virginia | 51143 | 13891 | 194 |
2362637 | 2362637 | 2022-03-31 | Wise | Virginia | 51195 | 10237 | 194 |
2359383 | 2359383 | 2022-03-30 | Wise | Virginia | 51195 | 10234 | 194 |
2356129 | 2356129 | 2022-03-29 | Wise | Virginia | 51195 | 10237 | 194 |
2352876 | 2352876 | 2022-03-28 | Wise | Virginia | 51195 | 10238 | 194 |
2349624 | 2349624 | 2022-03-27 | Wise | Virginia | 51195 | 10235 | 194 |
2346371 | 2346371 | 2022-03-26 | Wise | Virginia | 51195 | 10235 | 194 |
2343118 | 2343118 | 2022-03-25 | Wise | Virginia | 51195 | 10235 | 194 |
2339865 | 2339865 | 2022-03-24 | Wise | Virginia | 51195 | 10232 | 194 |
2336612 | 2336612 | 2022-03-23 | Wise | Virginia | 51195 | 10229 | 194 |
2245426 | 2245426 | 2022-02-23 | Augusta | Virginia | 51015 | 18623 | 194 |
2196652 | 2196652 | 2022-02-08 | Bedford | Virginia | 51019 | 15175 | 194 |
2193512 | 2193512 | 2022-02-07 | Washington | Virginia | 51191 | 12670 | 194 |
2173917 | 2173917 | 2022-02-01 | Frederick | Virginia | 51069 | 19293 | 194 |
2170665 | 2170665 | 2022-01-31 | Frederick | Virginia | 51069 | 19221 | 194 |
2167480 | 2167480 | 2022-01-30 | Shenandoah | Virginia | 51171 | 10025 | 194 |
2164225 | 2164225 | 2022-01-29 | Shenandoah | Virginia | 51171 | 10025 | 194 |
2160970 | 2160970 | 2022-01-28 | Shenandoah | Virginia | 51171 | 10025 | 194 |
2157714 | 2157714 | 2022-01-27 | Shenandoah | Virginia | 51171 | 9986 | 194 |
2154461 | 2154461 | 2022-01-26 | Shenandoah | Virginia | 51171 | 9901 | 194 |
2066644 | 2066644 | 2021-12-30 | Roanoke | Virginia | 51161 | 14068 | 194 |
2063394 | 2063394 | 2021-12-29 | Roanoke | Virginia | 51161 | 13975 | 194 |
2060144 | 2060144 | 2021-12-28 | Roanoke | Virginia | 51161 | 13867 | 194 |
2056895 | 2056895 | 2021-12-27 | Roanoke | Virginia | 51161 | 13789 | 194 |
2053646 | 2053646 | 2021-12-26 | Roanoke | Virginia | 51161 | 13634 | 194 |
2050396 | 2050396 | 2021-12-25 | Roanoke | Virginia | 51161 | 13634 | 194 |
2047146 | 2047146 | 2021-12-24 | Roanoke | Virginia | 51161 | 13634 | 194 |
1894306 | 1894306 | 2021-11-07 | Danville city | Virginia | 51590 | 6284 | 194 |
1891056 | 1891056 | 2021-11-06 | Danville city | Virginia | 51590 | 6284 | 194 |
1887806 | 1887806 | 2021-11-05 | Danville city | Virginia | 51590 | 6284 | 194 |
1884556 | 1884556 | 2021-11-04 | Danville city | Virginia | 51590 | 6279 | 194 |
1881307 | 1881307 | 2021-11-03 | Danville city | Virginia | 51590 | 6273 | 194 |
1611745 | 1611745 | 2021-08-12 | Suffolk city | Virginia | 51800 | 8541 | 194 |
1608498 | 1608498 | 2021-08-11 | Suffolk city | Virginia | 51800 | 8504 | 194 |
1605249 | 1605249 | 2021-08-10 | Suffolk city | Virginia | 51800 | 8483 | 194 |
1601999 | 1601999 | 2021-08-09 | Suffolk city | Virginia | 51800 | 8441 | 194 |
1598751 | 1598751 | 2021-08-08 | Suffolk city | Virginia | 51800 | 8360 | 194 |
1595502 | 1595502 | 2021-08-07 | Suffolk city | Virginia | 51800 | 8360 | 194 |
1592253 | 1592253 | 2021-08-06 | Suffolk city | Virginia | 51800 | 8360 | 194 |
1589004 | 1589004 | 2021-08-05 | Suffolk city | Virginia | 51800 | 8334 | 194 |
1585755 | 1585755 | 2021-08-04 | Suffolk city | Virginia | 51800 | 8301 | 194 |
1394196 | 1394196 | 2021-06-06 | Roanoke city | Virginia | 51770 | 8543 | 194 |
1390951 | 1390951 | 2021-06-05 | Roanoke city | Virginia | 51770 | 8540 | 194 |
1387706 | 1387706 | 2021-06-04 | Roanoke city | Virginia | 51770 | 8524 | 194 |
1384461 | 1384461 | 2021-06-03 | Roanoke city | Virginia | 51770 | 8517 | 194 |
1319523 | 1319523 | 2021-05-14 | Portsmouth city | Virginia | 51740 | 9061 | 194 |
1079172 | 1079172 | 2021-03-01 | Chesapeake city | Virginia | 51550 | 18257 | 194 |
965674 | 965674 | 2021-01-25 | Virginia Beach city | Virginia | 51810 | 24600 | 194 |
962429 | 962429 | 2021-01-24 | Virginia Beach city | Virginia | 51810 | 24241 | 194 |
959184 | 959184 | 2021-01-23 | Virginia Beach city | Virginia | 51810 | 23990 | 194 |
952595 | 952595 | 2021-01-21 | Chesterfield | Virginia | 51041 | 17254 | 194 |
514742 | 514742 | 2020-09-08 | Henrico | Virginia | 51087 | 4844 | 194 |
511509 | 511509 | 2020-09-07 | Henrico | Virginia | 51087 | 4806 | 194 |
508276 | 508276 | 2020-09-06 | Henrico | Virginia | 51087 | 4795 | 194 |
505044 | 505044 | 2020-09-05 | Henrico | Virginia | 51087 | 4757 | 194 |
501810 | 501810 | 2020-09-04 | Henrico | Virginia | 51087 | 4738 | 194 |
498576 | 498576 | 2020-09-03 | Henrico | Virginia | 51087 | 4707 | 194 |
495343 | 495343 | 2020-09-02 | Henrico | Virginia | 51087 | 4670 | 194 |
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);