ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where deaths = 304 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 5
state 1
- Virginia · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2008105 | 2008105 | 2021-12-12 | Loudoun | Virginia | 51107 | 37054 | 304 |
2004854 | 2004854 | 2021-12-11 | Loudoun | Virginia | 51107 | 37054 | 304 |
2001603 | 2001603 | 2021-12-10 | Loudoun | Virginia | 51107 | 37054 | 304 |
1998353 | 1998353 | 2021-12-09 | Loudoun | Virginia | 51107 | 36928 | 304 |
1995102 | 1995102 | 2021-12-08 | Loudoun | Virginia | 51107 | 36816 | 304 |
1991851 | 1991851 | 2021-12-07 | Loudoun | Virginia | 51107 | 36677 | 304 |
1988600 | 1988600 | 2021-12-06 | Loudoun | Virginia | 51107 | 36571 | 304 |
1985350 | 1985350 | 2021-12-05 | Loudoun | Virginia | 51107 | 36292 | 304 |
1982100 | 1982100 | 2021-12-04 | Loudoun | Virginia | 51107 | 36292 | 304 |
1978850 | 1978850 | 2021-12-03 | Loudoun | Virginia | 51107 | 36292 | 304 |
1975600 | 1975600 | 2021-12-02 | Loudoun | Virginia | 51107 | 36186 | 304 |
1972351 | 1972351 | 2021-12-01 | Loudoun | Virginia | 51107 | 36064 | 304 |
1939857 | 1939857 | 2021-11-21 | Newport News city | Virginia | 51700 | 21001 | 304 |
1936607 | 1936607 | 2021-11-20 | Newport News city | Virginia | 51700 | 21001 | 304 |
1933357 | 1933357 | 2021-11-19 | Newport News city | Virginia | 51700 | 21001 | 304 |
1930105 | 1930105 | 2021-11-18 | Newport News city | Virginia | 51700 | 20981 | 304 |
1926855 | 1926855 | 2021-11-17 | Newport News city | Virginia | 51700 | 20950 | 304 |
1923605 | 1923605 | 2021-11-16 | Newport News city | Virginia | 51700 | 20913 | 304 |
1920356 | 1920356 | 2021-11-15 | Newport News city | Virginia | 51700 | 20898 | 304 |
1770888 | 1770888 | 2021-09-30 | Norfolk city | Virginia | 51710 | 23161 | 304 |
1767639 | 1767639 | 2021-09-29 | Norfolk city | Virginia | 51710 | 23112 | 304 |
1764390 | 1764390 | 2021-09-28 | Norfolk city | Virginia | 51710 | 23040 | 304 |
1761161 | 1761161 | 2021-09-27 | Richmond city | Virginia | 51760 | 22488 | 304 |
1420077 | 1420077 | 2021-06-14 | Chesapeake city | Virginia | 51550 | 21167 | 304 |
1416832 | 1416832 | 2021-06-13 | Chesapeake city | Virginia | 51550 | 21164 | 304 |
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);