ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where deaths = 183 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 20
county 20
- Roanoke 9
- Alexandria city 8
- Franklin 7
- Prince William 6
- Shenandoah 6
- Suffolk city 4
- Chesterfield 3
- Portsmouth city 3
- Hampton city 2
- Roanoke city 2
- Arlington 1
- Campbell 1
- Chesapeake city 1
- Danville city 1
- Loudoun 1
- Lynchburg city 1
- Norfolk city 1
- Pittsylvania 1
- Spotsylvania 1
- Wise 1
state 1
- Virginia · 60 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2290986 | 2290986 | 2022-03-09 | Franklin | Virginia | 51067 | 10664 | 183 |
2291037 | 2291037 | 2022-03-09 | Pittsylvania | Virginia | 51143 | 13588 | 183 |
2287693 | 2287693 | 2022-03-08 | Alexandria city | Virginia | 51510 | 29748 | 183 |
2287734 | 2287734 | 2022-03-08 | Franklin | Virginia | 51067 | 10655 | 183 |
2284441 | 2284441 | 2022-03-07 | Alexandria city | Virginia | 51510 | 29734 | 183 |
2284482 | 2284482 | 2022-03-07 | Franklin | Virginia | 51067 | 10654 | 183 |
2284569 | 2284569 | 2022-03-07 | Wise | Virginia | 51195 | 10121 | 183 |
2281189 | 2281189 | 2022-03-06 | Alexandria city | Virginia | 51510 | 29662 | 183 |
2281230 | 2281230 | 2022-03-06 | Franklin | Virginia | 51067 | 10634 | 183 |
2277936 | 2277936 | 2022-03-05 | Alexandria city | Virginia | 51510 | 29662 | 183 |
2277977 | 2277977 | 2022-03-05 | Franklin | Virginia | 51067 | 10634 | 183 |
2274683 | 2274683 | 2022-03-04 | Alexandria city | Virginia | 51510 | 29662 | 183 |
2274724 | 2274724 | 2022-03-04 | Franklin | Virginia | 51067 | 10634 | 183 |
2271430 | 2271430 | 2022-03-03 | Alexandria city | Virginia | 51510 | 29630 | 183 |
2271471 | 2271471 | 2022-03-03 | Franklin | Virginia | 51067 | 10622 | 183 |
2268178 | 2268178 | 2022-03-02 | Alexandria city | Virginia | 51510 | 29603 | 183 |
2264925 | 2264925 | 2022-03-01 | Alexandria city | Virginia | 51510 | 29581 | 183 |
2222679 | 2222679 | 2022-02-16 | Campbell | Virginia | 51031 | 10860 | 183 |
2066654 | 2066654 | 2021-12-30 | Spotsylvania | Virginia | 51177 | 18421 | 183 |
2056902 | 2056902 | 2021-12-27 | Shenandoah | Virginia | 51171 | 7724 | 183 |
2053653 | 2053653 | 2021-12-26 | Shenandoah | Virginia | 51171 | 7631 | 183 |
2050403 | 2050403 | 2021-12-25 | Shenandoah | Virginia | 51171 | 7631 | 183 |
2047153 | 2047153 | 2021-12-24 | Shenandoah | Virginia | 51171 | 7631 | 183 |
2043903 | 2043903 | 2021-12-23 | Shenandoah | Virginia | 51171 | 7587 | 183 |
2040654 | 2040654 | 2021-12-22 | Shenandoah | Virginia | 51171 | 7556 | 183 |
1991887 | 1991887 | 2021-12-07 | Roanoke | Virginia | 51161 | 12924 | 183 |
1988636 | 1988636 | 2021-12-06 | Roanoke | Virginia | 51161 | 12875 | 183 |
1985386 | 1985386 | 2021-12-05 | Roanoke | Virginia | 51161 | 12777 | 183 |
1982136 | 1982136 | 2021-12-04 | Roanoke | Virginia | 51161 | 12777 | 183 |
1978886 | 1978886 | 2021-12-03 | Roanoke | Virginia | 51161 | 12777 | 183 |
1975636 | 1975636 | 2021-12-02 | Roanoke | Virginia | 51161 | 12734 | 183 |
1972387 | 1972387 | 2021-12-01 | Roanoke | Virginia | 51161 | 12705 | 183 |
1969137 | 1969137 | 2021-11-30 | Roanoke | Virginia | 51161 | 12664 | 183 |
1965887 | 1965887 | 2021-11-29 | Roanoke | Virginia | 51161 | 12615 | 183 |
1835818 | 1835818 | 2021-10-20 | Danville city | Virginia | 51590 | 6161 | 183 |
1816365 | 1816365 | 2021-10-14 | Lynchburg city | Virginia | 51680 | 11575 | 183 |
1543468 | 1543468 | 2021-07-22 | Hampton city | Virginia | 51650 | 10878 | 183 |
1540220 | 1540220 | 2021-07-21 | Hampton city | Virginia | 51650 | 10847 | 183 |
1254612 | 1254612 | 2021-04-24 | Suffolk city | Virginia | 51800 | 7759 | 183 |
1251365 | 1251365 | 2021-04-23 | Suffolk city | Virginia | 51800 | 7743 | 183 |
1248118 | 1248118 | 2021-04-22 | Suffolk city | Virginia | 51800 | 7728 | 183 |
1244871 | 1244871 | 2021-04-21 | Suffolk city | Virginia | 51800 | 7715 | 183 |
1225363 | 1225363 | 2021-04-15 | Portsmouth city | Virginia | 51740 | 8635 | 183 |
1222116 | 1222116 | 2021-04-14 | Portsmouth city | Virginia | 51740 | 8617 | 183 |
1218868 | 1218868 | 2021-04-13 | Portsmouth city | Virginia | 51740 | 8600 | 183 |
1199391 | 1199391 | 2021-04-07 | Roanoke city | Virginia | 51770 | 8089 | 183 |
1196142 | 1196142 | 2021-04-06 | Roanoke city | Virginia | 51770 | 8069 | 183 |
1072681 | 1072681 | 2021-02-27 | Chesapeake city | Virginia | 51550 | 18160 | 183 |
1069496 | 1069496 | 2021-02-26 | Norfolk city | Virginia | 51710 | 14780 | 183 |
991586 | 991586 | 2021-02-02 | Loudoun | Virginia | 51107 | 20618 | 183 |
920141 | 920141 | 2021-01-11 | Chesterfield | Virginia | 51041 | 14778 | 183 |
916896 | 916896 | 2021-01-10 | Chesterfield | Virginia | 51041 | 14686 | 183 |
913651 | 913651 | 2021-01-09 | Chesterfield | Virginia | 51041 | 14531 | 183 |
894161 | 894161 | 2021-01-03 | Arlington | Virginia | 51013 | 9250 | 183 |
479216 | 479216 | 2020-08-28 | Prince William | Virginia | 51153 | 10648 | 183 |
475983 | 475983 | 2020-08-27 | Prince William | Virginia | 51153 | 10577 | 183 |
472750 | 472750 | 2020-08-26 | Prince William | Virginia | 51153 | 10511 | 183 |
469518 | 469518 | 2020-08-25 | Prince William | Virginia | 51153 | 10470 | 183 |
466289 | 466289 | 2020-08-24 | Prince William | Virginia | 51153 | 10392 | 183 |
463060 | 463060 | 2020-08-23 | Prince William | Virginia | 51153 | 10341 | 183 |
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);