ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where deaths = 311 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 5
state 1
- Virginia · 42 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2294291 | 2294291 | 2022-03-10 | Portsmouth city | Virginia | 51740 | 20650 | 311 |
2291039 | 2291039 | 2022-03-09 | Portsmouth city | Virginia | 51740 | 20649 | 311 |
2287787 | 2287787 | 2022-03-08 | Portsmouth city | Virginia | 51740 | 20640 | 311 |
2284535 | 2284535 | 2022-03-07 | Portsmouth city | Virginia | 51740 | 20630 | 311 |
1783887 | 1783887 | 2021-10-04 | Norfolk city | Virginia | 51710 | 23410 | 311 |
1634384 | 1634384 | 2021-08-19 | Chesapeake city | Virginia | 51550 | 23237 | 311 |
1631136 | 1631136 | 2021-08-18 | Chesapeake city | Virginia | 51550 | 23138 | 311 |
1627889 | 1627889 | 2021-08-17 | Chesapeake city | Virginia | 51550 | 23049 | 311 |
1624642 | 1624642 | 2021-08-16 | Chesapeake city | Virginia | 51550 | 22946 | 311 |
1621395 | 1621395 | 2021-08-15 | Chesapeake city | Virginia | 51550 | 22732 | 311 |
1618147 | 1618147 | 2021-08-14 | Chesapeake city | Virginia | 51550 | 22732 | 311 |
1614899 | 1614899 | 2021-08-13 | Chesapeake city | Virginia | 51550 | 22732 | 311 |
1611650 | 1611650 | 2021-08-12 | Chesapeake city | Virginia | 51550 | 22624 | 311 |
1608403 | 1608403 | 2021-08-11 | Chesapeake city | Virginia | 51550 | 22512 | 311 |
1605154 | 1605154 | 2021-08-10 | Chesapeake city | Virginia | 51550 | 22452 | 311 |
1601904 | 1601904 | 2021-08-09 | Chesapeake city | Virginia | 51550 | 22384 | 311 |
1598656 | 1598656 | 2021-08-08 | Chesapeake city | Virginia | 51550 | 22211 | 311 |
1595407 | 1595407 | 2021-08-07 | Chesapeake city | Virginia | 51550 | 22211 | 311 |
1592158 | 1592158 | 2021-08-06 | Chesapeake city | Virginia | 51550 | 22211 | 311 |
1588909 | 1588909 | 2021-08-05 | Chesapeake city | Virginia | 51550 | 22160 | 311 |
1585660 | 1585660 | 2021-08-04 | Chesapeake city | Virginia | 51550 | 22106 | 311 |
1582410 | 1582410 | 2021-08-03 | Chesapeake city | Virginia | 51550 | 22050 | 311 |
1579160 | 1579160 | 2021-08-02 | Chesapeake city | Virginia | 51550 | 21986 | 311 |
1575912 | 1575912 | 2021-08-01 | Chesapeake city | Virginia | 51550 | 21840 | 311 |
1572664 | 1572664 | 2021-07-31 | Chesapeake city | Virginia | 51550 | 21840 | 311 |
1569416 | 1569416 | 2021-07-30 | Chesapeake city | Virginia | 51550 | 21840 | 311 |
1566168 | 1566168 | 2021-07-29 | Chesapeake city | Virginia | 51550 | 21786 | 311 |
1562920 | 1562920 | 2021-07-28 | Chesapeake city | Virginia | 51550 | 21740 | 311 |
1559672 | 1559672 | 2021-07-27 | Chesapeake city | Virginia | 51550 | 21703 | 311 |
1556425 | 1556425 | 2021-07-26 | Chesapeake city | Virginia | 51550 | 21660 | 311 |
1553178 | 1553178 | 2021-07-25 | Chesapeake city | Virginia | 51550 | 21579 | 311 |
1549931 | 1549931 | 2021-07-24 | Chesapeake city | Virginia | 51550 | 21579 | 311 |
1546684 | 1546684 | 2021-07-23 | Chesapeake city | Virginia | 51550 | 21579 | 311 |
1543437 | 1543437 | 2021-07-22 | Chesapeake city | Virginia | 51550 | 21538 | 311 |
1540189 | 1540189 | 2021-07-21 | Chesapeake city | Virginia | 51550 | 21518 | 311 |
1536942 | 1536942 | 2021-07-20 | Chesapeake city | Virginia | 51550 | 21493 | 311 |
1533694 | 1533694 | 2021-07-19 | Chesapeake city | Virginia | 51550 | 21477 | 311 |
1530447 | 1530447 | 2021-07-18 | Chesapeake city | Virginia | 51550 | 21439 | 311 |
1527200 | 1527200 | 2021-07-17 | Chesapeake city | Virginia | 51550 | 21439 | 311 |
1523953 | 1523953 | 2021-07-16 | Chesapeake city | Virginia | 51550 | 21439 | 311 |
1082517 | 1082517 | 2021-03-02 | Virginia Beach city | Virginia | 51810 | 30739 | 311 |
926665 | 926665 | 2021-01-13 | Henrico | Virginia | 51087 | 14900 | 311 |
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);