ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where deaths = 247 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492781 | 2492781 | 2022-05-10 | Frederick | Virginia | 51069 | 20839 | 247 |
2489523 | 2489523 | 2022-05-09 | Frederick | Virginia | 51069 | 20815 | 247 |
2486266 | 2486266 | 2022-05-08 | Frederick | Virginia | 51069 | 20765 | 247 |
2483008 | 2483008 | 2022-05-07 | Frederick | Virginia | 51069 | 20765 | 247 |
2479750 | 2479750 | 2022-05-06 | Frederick | Virginia | 51069 | 20765 | 247 |
2476492 | 2476492 | 2022-05-05 | Frederick | Virginia | 51069 | 20746 | 247 |
2473234 | 2473234 | 2022-05-04 | Frederick | Virginia | 51069 | 20725 | 247 |
2304010 | 2304010 | 2022-03-13 | Henry | Virginia | 51089 | 11292 | 247 |
2300758 | 2300758 | 2022-03-12 | Henry | Virginia | 51089 | 11292 | 247 |
2297506 | 2297506 | 2022-03-11 | Henry | Virginia | 51089 | 11292 | 247 |
2294254 | 2294254 | 2022-03-10 | Henry | Virginia | 51089 | 11276 | 247 |
2213025 | 2213025 | 2022-02-13 | Spotsylvania | Virginia | 51177 | 25755 | 247 |
2209772 | 2209772 | 2022-02-12 | Spotsylvania | Virginia | 51177 | 25755 | 247 |
2206519 | 2206519 | 2022-02-11 | Spotsylvania | Virginia | 51177 | 25755 | 247 |
2203223 | 2203223 | 2022-02-10 | Lynchburg city | Virginia | 51680 | 18718 | 247 |
1962648 | 1962648 | 2021-11-28 | Suffolk city | Virginia | 51800 | 11218 | 247 |
1959397 | 1959397 | 2021-11-27 | Suffolk city | Virginia | 51800 | 11218 | 247 |
1956146 | 1956146 | 2021-11-26 | Suffolk city | Virginia | 51800 | 11218 | 247 |
1946329 | 1946329 | 2021-11-23 | Hampton city | Virginia | 51650 | 15400 | 247 |
1926867 | 1926867 | 2021-11-17 | Portsmouth city | Virginia | 51740 | 12863 | 247 |
1666930 | 1666930 | 2021-08-29 | Newport News city | Virginia | 51700 | 16783 | 247 |
1663682 | 1663682 | 2021-08-28 | Newport News city | Virginia | 51700 | 16783 | 247 |
1660434 | 1660434 | 2021-08-27 | Newport News city | Virginia | 51700 | 16783 | 247 |
1248084 | 1248084 | 2021-04-22 | Norfolk city | Virginia | 51710 | 17107 | 247 |
1192794 | 1192794 | 2021-04-05 | Arlington | Virginia | 51013 | 14436 | 247 |
1046813 | 1046813 | 2021-02-19 | Virginia Beach city | Virginia | 51810 | 29552 | 247 |
855311 | 855311 | 2020-12-22 | Prince William | Virginia | 51153 | 23041 | 247 |
852066 | 852066 | 2020-12-21 | Prince William | Virginia | 51153 | 22734 | 247 |
848821 | 848821 | 2020-12-20 | Prince William | Virginia | 51153 | 22592 | 247 |
845576 | 845576 | 2020-12-19 | Prince William | Virginia | 51153 | 22355 | 247 |
842330 | 842330 | 2020-12-18 | Prince William | Virginia | 51153 | 22173 | 247 |
774134 | 774134 | 2020-11-27 | Henrico | Virginia | 51087 | 8179 | 247 |
770889 | 770889 | 2020-11-26 | Henrico | Virginia | 51087 | 8139 | 247 |
767643 | 767643 | 2020-11-25 | Henrico | Virginia | 51087 | 8047 | 247 |
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);