ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where deaths = 188 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Alexandria city 16
- Frederick 12
- Franklin 9
- Prince William 7
- Hanover 6
- Portsmouth city 5
- Suffolk city 4
- Henrico 3
- Loudoun 3
- Arlington 2
- Lynchburg city 2
- Campbell 1
- Roanoke city 1
- Shenandoah 1
- Spotsylvania 1
state 1
- Virginia · 73 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502512 | 2502512 | 2022-05-13 | Alexandria city | Virginia | 51510 | 32647 | 188 |
2499254 | 2499254 | 2022-05-12 | Alexandria city | Virginia | 51510 | 32528 | 188 |
2495996 | 2495996 | 2022-05-11 | Alexandria city | Virginia | 51510 | 32395 | 188 |
2492738 | 2492738 | 2022-05-10 | Alexandria city | Virginia | 51510 | 32310 | 188 |
2489480 | 2489480 | 2022-05-09 | Alexandria city | Virginia | 51510 | 32237 | 188 |
2486223 | 2486223 | 2022-05-08 | Alexandria city | Virginia | 51510 | 32001 | 188 |
2482965 | 2482965 | 2022-05-07 | Alexandria city | Virginia | 51510 | 32001 | 188 |
2479707 | 2479707 | 2022-05-06 | Alexandria city | Virginia | 51510 | 32001 | 188 |
2476449 | 2476449 | 2022-05-05 | Alexandria city | Virginia | 51510 | 31922 | 188 |
2473191 | 2473191 | 2022-05-04 | Alexandria city | Virginia | 51510 | 31840 | 188 |
2469935 | 2469935 | 2022-05-03 | Alexandria city | Virginia | 51510 | 31734 | 188 |
2466679 | 2466679 | 2022-05-02 | Alexandria city | Virginia | 51510 | 31687 | 188 |
2463424 | 2463424 | 2022-05-01 | Alexandria city | Virginia | 51510 | 31509 | 188 |
2460168 | 2460168 | 2022-04-30 | Alexandria city | Virginia | 51510 | 31509 | 188 |
2456912 | 2456912 | 2022-04-29 | Alexandria city | Virginia | 51510 | 31509 | 188 |
2453656 | 2453656 | 2022-04-28 | Alexandria city | Virginia | 51510 | 31441 | 188 |
2362550 | 2362550 | 2022-03-31 | Franklin | Virginia | 51067 | 10752 | 188 |
2359296 | 2359296 | 2022-03-30 | Franklin | Virginia | 51067 | 10751 | 188 |
2356042 | 2356042 | 2022-03-29 | Franklin | Virginia | 51067 | 10737 | 188 |
2352789 | 2352789 | 2022-03-28 | Franklin | Virginia | 51067 | 10733 | 188 |
2349537 | 2349537 | 2022-03-27 | Franklin | Virginia | 51067 | 10734 | 188 |
2346284 | 2346284 | 2022-03-26 | Franklin | Virginia | 51067 | 10734 | 188 |
2343031 | 2343031 | 2022-03-25 | Franklin | Virginia | 51067 | 10734 | 188 |
2339778 | 2339778 | 2022-03-24 | Franklin | Virginia | 51067 | 10737 | 188 |
2336524 | 2336524 | 2022-03-23 | Franklin | Virginia | 51067 | 10732 | 188 |
2238934 | 2238934 | 2022-02-21 | Campbell | Virginia | 51031 | 11024 | 188 |
2144635 | 2144635 | 2022-01-23 | Frederick | Virginia | 51069 | 18268 | 188 |
2141380 | 2141380 | 2022-01-22 | Frederick | Virginia | 51069 | 18268 | 188 |
2138124 | 2138124 | 2022-01-21 | Frederick | Virginia | 51069 | 18268 | 188 |
2134870 | 2134870 | 2022-01-20 | Frederick | Virginia | 51069 | 18096 | 188 |
2131618 | 2131618 | 2022-01-19 | Frederick | Virginia | 51069 | 17980 | 188 |
2128364 | 2128364 | 2022-01-18 | Frederick | Virginia | 51069 | 17853 | 188 |
2125111 | 2125111 | 2022-01-17 | Frederick | Virginia | 51069 | 17773 | 188 |
2121859 | 2121859 | 2022-01-16 | Frederick | Virginia | 51069 | 17330 | 188 |
2118607 | 2118607 | 2022-01-15 | Frederick | Virginia | 51069 | 17330 | 188 |
2115355 | 2115355 | 2022-01-14 | Frederick | Virginia | 51069 | 17330 | 188 |
2112103 | 2112103 | 2022-01-13 | Frederick | Virginia | 51069 | 17156 | 188 |
2108851 | 2108851 | 2022-01-12 | Frederick | Virginia | 51069 | 16945 | 188 |
2089411 | 2089411 | 2022-01-06 | Shenandoah | Virginia | 51171 | 8303 | 188 |
2086163 | 2086163 | 2022-01-05 | Spotsylvania | Virginia | 51177 | 20066 | 188 |
1900847 | 1900847 | 2021-11-09 | Lynchburg city | Virginia | 51680 | 11861 | 188 |
1897597 | 1897597 | 2021-11-08 | Lynchburg city | Virginia | 51680 | 11856 | 188 |
1806601 | 1806601 | 2021-10-11 | Hanover | Virginia | 51085 | 11257 | 188 |
1803351 | 1803351 | 2021-10-10 | Hanover | Virginia | 51085 | 11257 | 188 |
1800102 | 1800102 | 2021-10-09 | Hanover | Virginia | 51085 | 11257 | 188 |
1796853 | 1796853 | 2021-10-08 | Hanover | Virginia | 51085 | 11257 | 188 |
1793604 | 1793604 | 2021-10-07 | Hanover | Virginia | 51085 | 11218 | 188 |
1790355 | 1790355 | 2021-10-06 | Hanover | Virginia | 51085 | 11175 | 188 |
1316298 | 1316298 | 2021-05-13 | Suffolk city | Virginia | 51800 | 7899 | 188 |
1313052 | 1313052 | 2021-05-12 | Suffolk city | Virginia | 51800 | 7889 | 188 |
1309805 | 1309805 | 2021-05-11 | Suffolk city | Virginia | 51800 | 7891 | 188 |
1306559 | 1306559 | 2021-05-10 | Suffolk city | Virginia | 51800 | 7886 | 188 |
1287058 | 1287058 | 2021-05-04 | Portsmouth city | Virginia | 51740 | 8955 | 188 |
1283812 | 1283812 | 2021-05-03 | Portsmouth city | Virginia | 51740 | 8943 | 188 |
1280565 | 1280565 | 2021-05-02 | Portsmouth city | Virginia | 51740 | 8926 | 188 |
1277318 | 1277318 | 2021-05-01 | Portsmouth city | Virginia | 51740 | 8895 | 188 |
1274071 | 1274071 | 2021-04-30 | Portsmouth city | Virginia | 51740 | 8884 | 188 |
1267588 | 1267588 | 2021-04-28 | Roanoke city | Virginia | 51770 | 8334 | 188 |
1011062 | 1011062 | 2021-02-08 | Loudoun | Virginia | 51107 | 21564 | 188 |
1007816 | 1007816 | 2021-02-07 | Loudoun | Virginia | 51107 | 21552 | 188 |
1004570 | 1004570 | 2021-02-06 | Loudoun | Virginia | 51107 | 21492 | 188 |
942839 | 942839 | 2021-01-18 | Arlington | Virginia | 51013 | 10790 | 188 |
939594 | 939594 | 2021-01-17 | Arlington | Virginia | 51013 | 10677 | 188 |
518019 | 518019 | 2020-09-09 | Prince William | Virginia | 51153 | 11364 | 188 |
514784 | 514784 | 2020-09-08 | Prince William | Virginia | 51153 | 11304 | 188 |
511551 | 511551 | 2020-09-07 | Prince William | Virginia | 51153 | 11253 | 188 |
508318 | 508318 | 2020-09-06 | Prince William | Virginia | 51153 | 11217 | 188 |
505086 | 505086 | 2020-09-05 | Prince William | Virginia | 51153 | 11125 | 188 |
501852 | 501852 | 2020-09-04 | Prince William | Virginia | 51153 | 11085 | 188 |
498618 | 498618 | 2020-09-03 | Prince William | Virginia | 51153 | 11024 | 188 |
459789 | 459789 | 2020-08-22 | Henrico | Virginia | 51087 | 4294 | 188 |
456562 | 456562 | 2020-08-21 | Henrico | Virginia | 51087 | 4259 | 188 |
453334 | 453334 | 2020-08-20 | Henrico | Virginia | 51087 | 4224 | 188 |
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);